[postgis-users] Create a geom column from old data
Paul Ramsey
pramsey at refractions.net
Tue Jul 22 16:22:52 PDT 2003
It depends on which spheroid you are using. I just gave the null SRID,
you are free to use which ever one you want. Note that SRID != EPSG
number, necessarily. The SRID number is entirely tied to the entries of
the SPATIAL_REF_SYS table. I could define NAD83 Lat/Lon as SRID 2222222
if it so amused me, as long as SRID 2222222 in my SPATIAL_REF_SYS table
gave a definition of NAD83 Lat/Lon.
Paul
PS - the EPSG number for NAD83 Lat/Lon is 4269
the EPSG number for generic WGS84 is 4326
Zamil Murji wrote:
> 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
\_
More information about the postgis-users
mailing list