[postgis-users] create a point fom lat/lon

[Nahum Castro]

--- Stephen Woodbridge <woodbri at swoodbridge.com>
escribió:

> Try:
> 
> update iter_rco_2005g set
> the_geom=makepoint(lon,lat);
> 
>    or if you want to set the srid for the points to
> say wgs84 srid=4326:
> 
> update iter_rco_2005g set
> the_geom=setsrid(makepoint(lon,lat), 4326);
> 
> this is faster and probably more accurate the using
> string/text 
> manipulation.
> 
> -Steve W.
> 

Thank you all.

It works great.

Saludos desde México


--
Nahum Castro
Leon, Guanajuato, Mexico
http://www.leon-linux.com
e-mail: pedro1_72 [en] yahoo [punto] com


      Llama gratis a cualquier PC del mundo. 
Con una excelente calidad de sonido. 
http://mx.messenger.yahoo.com/