<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">ESRI does not use a SRID, it uses a text string that needs complex parsing to work. If ESRI supported EPSG codes it would be easier...<br><br>The spatial_ref_sys table contains entries for all EPSG recognised projections. If you have a reasonable case to have a projection inluded by EPSG, submit a request to EPSG & it will finish up in the Postgis spatial_reference table.<br><br>In the short term, add a proj4txt record for your projection with an arbitrary new srid in the spatial_ref_sys table & it will work fine in Postgis. If you want it to work with GDAL/OGR then you;ll need to add it to the proj4 list of projection parameters. Where this is depends on your OS & implementation.<br><br>See this spec:<br><br><a
href="http://remotesensing.org/geotiff/proj_list/orthographic.html">http://remotesensing.org/geotiff/proj_list/orthographic.html</a><br><br>The proj4 parameter list for your case may need to specify WGS84 as your ellipsoid & datum.<br><br>HTH,<br><br> Brent Wood<br><br>--- On <b>Sat, 2/11/12, Martin Chapman <i><chapmanm@pixia.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Martin Chapman <chapmanm@pixia.com><br>Subject: [gdal-dev] PostGIS SRID conundrum<br>To: gdal-dev@lists.osgeo.org<br>Date: Saturday, February 11, 2012, 12:25 PM<br><br><div id="yiv75235976"><style><!--
#yiv75235976
_filtered #yiv75235976 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv75235976 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#yiv75235976
#yiv75235976 p.yiv75235976MsoNormal, #yiv75235976 li.yiv75235976MsoNormal, #yiv75235976 div.yiv75235976MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"sans-serif";}
#yiv75235976 a:link, #yiv75235976 span.yiv75235976MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv75235976 a:visited, #yiv75235976 span.yiv75235976MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv75235976 span.yiv75235976EmailStyle17
{font-family:"sans-serif";color:windowtext;}
#yiv75235976 .yiv75235976MsoChpDefault
{font-family:"sans-serif";}
_filtered #yiv75235976 {margin:1.0in 1.0in 1.0in 1.0in;}
#yiv75235976 div.yiv75235976WordSection1
{}
--></style><div><div class="yiv75235976WordSection1"><p class="yiv75235976MsoNormal">I know this question isn’t exactly related to GDAL but I thought someone on the list might be able to answer this question.</p><p class="yiv75235976MsoNormal"> </p><p class="yiv75235976MsoNormal">So, I have a shape file that has the following spatial reference:</p><p class="yiv75235976MsoNormal"> </p><p class="yiv75235976MsoNormal"><span style="font-family:"Courier New";">PROJCS["Orthographic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Orthographic"],PARAMETER["Latitude_Of_Center",40],PARAMETER["Longitude_Of_Center",-75],PARAMETER["false_easting",0],PARAMETER["false_northing",0],UNIT["User Defined",1]]</span></p><p class="yiv75235976MsoNormal"><span style="font-family:"Courier New";"> </span></p><p
class="yiv75235976MsoNormal"><span style="font-family:"Courier New";">It was generated using OGR. I want to insert it into postgres / postgis but there is no direct match for the wkt or proj4 definition in the spatial_ref_sys table. So, I go to insert it into the table but the question arises, what SRID do I use? Do I just fudge a random one with a high enough value that I hope it won’t conflict with some other SRID in the future, or do I create a table based off of the heterogeneous list of SRIDs at spatialreference.org and insert from that? I would like to do the later but that will be a pain unless someone has a put together a batch insert sql file for all the projections on spatialreference.org. Still, there is always the possibility that I may run into one that isn’t defined and I will have to fudge my own number anyway.</span></p><p class="yiv75235976MsoNormal"><span style="font-family:"Courier
New";"> </span></p><p class="yiv75235976MsoNormal"><span style="font-family:"Courier New";">Question: What is the best way to handle this? I wish the spatial_ref_sys table came with all the ESRI and other SRID definitions. </span></p><p class="yiv75235976MsoNormal"><span style="font-family:"Courier New";"> </span></p><p class="yiv75235976MsoNormal"><span style="font-family:"Courier New";">Suggestions are much appreciated!</span></p><p class="yiv75235976MsoNormal"> </p><p class="yiv75235976MsoNormal">Best regards,</p><p class="yiv75235976MsoNormal"><span style="font-size:12.0pt;font-family:"serif";">Martin</span><span style="font-size:10.0pt;font-family:"sans-serif";"></span></p><p class="yiv75235976MsoNormal"><span style="font-size:12.0pt;font-family:"serif";"> </span></p><p class="yiv75235976MsoNormal"> </p></div></div></div><br>-----Inline
Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>gdal-dev mailing list<br><a ymailto="mailto:gdal-dev@lists.osgeo.org" href="/mc/compose?to=gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a></div></blockquote></td></tr></table>