[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Create a geom column from old data
From:       Paul Ramsey <pramsey () refractions ! net>
Date:       2003-07-22 23:22:52
Message-ID: 3F1DC74C.7030509 () refractions ! net
[Download RAW message or body]

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@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@refractions.net
      | Phone: (250) 885-0632
      \_


[prev in list] [next in list] [prev in thread] [next in thread]