[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