RE: [gdal-dev] PostGIS SRID conundrum

2012-02-14 Thread Martin Chapman
-dev] PostGIS SRID conundrum On Sat, Feb 11, 2012 at 6:48 AM, Martin Chapman wrote: 4. I select the max(srid) where srid > 1000. If zero is returned then I use that base number (1000) and add a new entry to the spatial_ref_sys table using the proj4 text and wkt so all fie

Re: [gdal-dev] PostGIS SRID conundrum

2012-02-14 Thread Sandro Santilli
On Sat, Feb 11, 2012 at 6:48 AM, Martin Chapman wrote: > 4. I select the max(srid) where srid > 1000. If zero is > returned then I use that base number (1000) and add a new entry to the > spatial_ref_sys table using the proj4 text and wkt so all fields have a > value…and my app na

RE: [gdal-dev] PostGIS SRID conundrum

2012-02-11 Thread pcreso
ou or anyone else can see any flaws in that logic I would appreciate some criticism.  Thanks again for your feedback!  Best regards,Martin  From: pcr...@pcreso.com [mailto:pcr...@pcreso.com] Sent: Friday, February 10, 2012 10:33 PM To: Martin Chapman Cc: gdal-dev@lists.osgeo.org Subject: Re: [gd

RE: [gdal-dev] PostGIS SRID conundrum

2012-02-10 Thread Martin Chapman
ack! Best regards, Martin From: pcr...@pcreso.com [mailto:pcr...@pcreso.com] Sent: Friday, February 10, 2012 10:33 PM To: Martin Chapman Cc: gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] PostGIS SRID conundrum ESRI does not use a SRID, it uses a text string that needs complex parsing to w

Re: [gdal-dev] PostGIS SRID conundrum

2012-02-10 Thread pcreso
On Sat, 2/11/12, Martin Chapman wrote: From: Martin Chapman Subject: [gdal-dev] PostGIS SRID conundrum To: gdal-dev@lists.osgeo.org Date: Saturday, February 11, 2012, 12:25 PM I know this question isn’t exactly related to GDAL but I thought someone on the list might be able to answer this quest

[gdal-dev] PostGIS SRID conundrum

2012-02-10 Thread Martin Chapman
I know this question isn't exactly related to GDAL but I thought someone on the list might be able to answer this question. So, I have a shape file that has the following spatial reference: PROJCS["Orthographic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["W GS_1984",6378137,298.25722