[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