[postgis-users] How to create a point geometry from two text fields?

Stephen Woodbridge woodbri at swoodbridge.com
Fri Mar 25 08:26:04 PDT 2011

update mytable set the_geom=st_setsrid(st_makepoint(lon,lat),4326);

On 3/25/2011 10:44 AM, Gis Mage wrote:
> Hello!
> I have a table with two text fields "lat" and "long" of character
> varying type.
> I've created a field the_geom with type geometry.
> How do I calculate the_geom field with an sql query?
> The table is huge - about 1.5 million records, so I think the fastest
> way to do this is to use pointfromtext function, but I can't figure out
> how to put in the values of "lat" and "long" fields inside function
> arguments.
> Can anyone help me out?
> Thanks.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list