[postgis-users] Distance query

Michael Fuhr mike at fuhr.org
Wed Feb 7 08:08:21 PST 2007


On Wed, Feb 07, 2007 at 03:46:13PM -0000, Pedro Doria Meunier wrote:
> In the table definition for units:
> CONSTRAINT enforce_srid CHECK (srid(curr_location) = 4326)
> In the table definition for toponimia:
> CONSTRAINT enforce_srid_geometry CHECK (srid(geometry) = 4326)
> 
> As you can see their srid=4326

The geometries are *defined* to be 4326 but the coordinates are
meaningless in that SRID:

> Unit 80000135 curr_location = "POINT(3239.3462 -1650.4789)"
> Unit 11111111 curr_location = "POINT(3238.82678 -1654.51)"
> Unit 99999999 curr_location = "POINT(3241.00088 -1647.84688)"

If these coordinates are 4326 then the first has a longitude of
3239.3462 degrees and a latitude of -1650.4789 degrees.  Where is
that?  Apparently these coordinates are really in some other SRID
and they're mis-labeled as being 4326, or perhaps they have some
other meaning altogether.  What's the source of these coordinates?

-- 
Michael Fuhr



More information about the postgis-users mailing list