[postgis-users] Create a geom column from old data

[Zamil Murji]

Is the -1 the SRID? What is the SRID for lat/long? I believe it is 8307. Please let me know if this right.

Thanks for the quick response.

Zamil

-----Original Message-----
From: Paul Ramsey [mailto:pramsey at refractions.net]
Sent: Tuesday, July 22, 2003 4:29 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Create a geom column from old data


update thetable set the_geom = GeometryFromText('POINT(' || longitude || 
' ' || latitude || ')',-1);


Zamil Murji wrote:
> Hello list,
> 
> I have a database all ready to go. It had two columns already defined
> (latitude and longitude). I want to use those two columns to create
> geoms under the proper SRID. Please help. I have 50000+ rows so I
> don't want to create each geom one at a time.
> 
> A step by step guide would be great. I already have a geometry column
> defined in the table called the_geom.
> 

-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users