RGeo - PostGis - SRID - Recording

[benebrice]

Hello,

I am currently working with RGeo and PostGIS on a Rails application (Rails 4.0.2, Ruby 2.1).

I think I have found a problem coming from the recording of a position. You can find ​here an post at the end where I explain all my problems. At the beginning I thought that the problem came from RGeo but now I am not really sure.

To install PostGIS I used ​PostgresApp and the following code lines to create the template used for the creation of my database with Rails.

sudo su postgres

createdb template_postgis

createlang plpgsql template_postgis

psql -d template_postgis -f /usr/share/postgresql/8.4/contrib/postgis.sql

psql -d template_postgis -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql

If you could help me on this problem it would be very interesting for me. I do not know what I can do more. I am completely blocked on the development of my application because of this problem.

Thank you very much in advance.

Regards,

Brice.

[dustymugs]

In your last github comment, your values for latitude and longitude are flipped.

@lng=37.785834
@lat=-122.406417

-122.406417 is the longitude and 37.785834 is the latitude.

Also, please use the postgis-users mailing list for these kinds of questions.