<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:SimSun;
panose-1:2 1 6 0 3 1 1 1 1 1;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@SimSun";
panose-1:2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi there,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I need to add a projection to support an imported shapefiles dataset with the following projection:<o:p></o:p></p><p class=MsoNormal>PROJCS [ "Business Analyst Projection",<o:p></o:p></p><p class=MsoNormal> GEOGCS[ <o:p></o:p></p><p class=MsoNormal> "GCS_WGS_1984",<o:p></o:p></p><p class=MsoNormal> DATUM[ "D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],<o:p></o:p></p><p class=MsoNormal> PRIMEM["Greenwich",0.0],<o:p></o:p></p><p class=MsoNormal> UNIT["Degree",0.0174532925199433]], <o:p></o:p></p><p class=MsoNormal> PROJECTION["Equidistant_Conic"],<o:p></o:p></p><p class=MsoNormal> PARAMETER["False_Easting",0.0],<o:p></o:p></p><p class=MsoNormal> PARAMETER["False_Northing",0.0],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Central_Meridian",-88.02657853618898],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Standard_Parallel_1",41.82305904132364],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Standard_Parallel_2",41.82305804132364],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Latitude_Of_Origin",0.0],<o:p></o:p></p><p class=MsoNormal> UNIT["Meter",1.0] ]<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I used the following SQL to add the projection to the spatial_ref_sys table:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) VALUES (9998, 'EPSG', 9998, <o:p></o:p></p><p class=MsoNormal> 'PROJCS["Business Analyst Projection",<o:p></o:p></p><p class=MsoNormal> GEOGCS["GCS_WGS_1984",<o:p></o:p></p><p class=MsoNormal> DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],<o:p></o:p></p><p class=MsoNormal> PRIMEM["Greenwich",0.0],<o:p></o:p></p><p class=MsoNormal> UNIT["Degree",0.0174532925199433]],<o:p></o:p></p><p class=MsoNormal> PROJECTION["Equidistant_Conic"],<o:p></o:p></p><p class=MsoNormal> PARAMETER["False_Easting",0.0],<o:p></o:p></p><p class=MsoNormal> PARAMETER["False_Northing",0.0],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Central_Meridian",-88.02657853618898],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Standard_Parallel_1",41.82305904132364],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Standard_Parallel_2",41.82305804132364],<o:p></o:p></p><p class=MsoNormal> PARAMETER["Latitude_Of_Origin",0.0],<o:p></o:p></p><p class=MsoNormal> UNIT["Meter",1.0]]', <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> '+proj=eqdc +lat_0=41.82305904132364 <o:p></o:p></p><p class=MsoNormal> +lon_0=-88.02657853618898<o:p></o:p></p><p class=MsoNormal> +lon_1=-88.02657853618898 <o:p></o:p></p><p class=MsoNormal> +lon_2=-88.02657853618898 <o:p></o:p></p><p class=MsoNormal> +x_0=0 <o:p></o:p></p><p class=MsoNormal> +y_0=0 <o:p></o:p></p><p class=MsoNormal> +a=6378137.0<o:p></o:p></p><p class=MsoNormal> +ellps=WGS84 <o:p></o:p></p><p class=MsoNormal> +datum=WGS84 <o:p></o:p></p><p class=MsoNormal> +units=m <o:p></o:p></p><p class=MsoNormal> +no_defs');<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When I tried to do a transform test [ update major set geom=transform(geom, 4326) ], I go the following error:<o:p></o:p></p><p class=MsoNormal>ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=eqdc <o:p></o:p></p><p class=MsoNormal> +lat_0=41.82305904132364 <o:p></o:p></p><p class=MsoNormal> +lon_0=-88.02657853618898<o:p></o:p></p><p class=MsoNormal> +lon_1=-88.02657853618898 <o:p></o:p></p><p class=MsoNormal> +lon_2=-88.02657853618898 <o:p></o:p></p><p class=MsoNormal> +x_0=0 <o:p></o:p></p><p class=MsoNormal> +y_0=0 <o:p></o:p></p><p class=MsoNormal> +a=6378137.0<o:p></o:p></p><p class=MsoNormal> +ellps=WGS84 <o:p></o:p></p><p class=MsoNormal> +datum=WGS84 <o:p></o:p></p><p class=MsoNormal> +units=m <o:p></o:p></p><p class=MsoNormal> +no_defs': major axis or radius = 0 or not given<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>BTW, I found no documentation that provides a complete listing of parameters I need to set for eqdc projection.<br><br><o:p></o:p></p><p class=MsoNormal>Thanks for any hint.<o:p></o:p></p><p class=MsoNormal>DWW<o:p></o:p></p></div>
<br><br>
<font color=green face=Webdings style='font-size:12.0pt;'> P </font><font style='font-size:8.0pt;font-family:Tahoma,sans-serif;color:green'> Please consider the environment before printing this email.</font>
<hr size=1><font face=arial size=2>
This communication may contain information that is confidential, privileged or subject to copyright. If you are not the intended recipient, please advise by return e-mail and delete the message and any attachments immediately without reading, copying or forwarding to others.<BR><BR>
<br></body></html>