rgeo/activerecord-postgis-adapter

Operation on two GEOMETRIES with different SRIDs

Closed this issue · 0 comments

Hi guys!

I'm trying to upgrade to the latest gem version with rails 4.2
After upgrade all queries on spatial columns raise the error:

> TruckStatus.where(coords: 'POINT(-122 47)')
   (15.2ms)  SELECT f_geometry_column,coord_dimension,srid,type FROM geometry_columns WHERE f_table_name='truck_statuses'
  TruckStatus Load (0.8ms)  SELECT "truck_statuses".* FROM "truck_statuses" WHERE "truck_statuses"."coords" = $1  [["coords", "002000000100000000c05e8000000000004047800000000000"]]
PG::InternalError: ERROR:  Operation on two GEOMETRIES with different SRIDs

The cords column has 3785 srid and point type