[postgis-users] MakePoint() uses no SRID
Mark Fenbers
Mark.Fenbers at noaa.gov
Thu Dec 1 05:37:59 PST 2005
After adding a geometry column, i.e.,
SELECT AddGeometryColumn('public', 'gislocation', 'the_geom', 4269,
'POINT', 2);
I want to populate this column using two other fields in the gislocation
table (which are lat, lon). But when I try:
UPDATE gislocation SET the_geom = MakePoint(lon, lat);
then, I get a complaint about the SRID enforcement. How do I get
MakePoint() to generate a geometry with an SRID of 4269?
Mark
More information about the postgis-users
mailing list