[postgis-users] Questions about using SRID not -1
Olivier Courtin
olivier.courtin at oslandia.com
Sat Jan 16 11:00:13 PST 2010
On Jan 16, 2010, at 7:54 PM, Oscar Zamudio wrote:
Hi Oscar.
> Ok, when I insert my points in my spatial enabled database I used:
> [...]
> without no spatial reference system explicit so I guess the SRID is
> set to "unknown" i.e. -1. Then naively I created a new column named
> srid for my table and put the right value of SRID
SRID information is stored *both* in the geometry_columns table (srid
column),
and inside each geometry itself.
So consider using UpdateGeometrySRID function to fix your issue.
<http://postgis.refractions.net/documentation/manual-svn/UpdateGeometrySRID.html
>
HTH,
--
Olivier
More information about the postgis-users
mailing list