No subject

d
a link from http://spatialreference.org/ref/sr-org/24/postgis/ as the basis
for creating the srid above.
PROJCS["NAD_1983_Albers",
  GEOGCS["GCS_North_American_1983",
    DATUM["D_North_American_1983",
      SPHEROID["GRS_1980", 6378137.0, 298.257222101]],
    PRIMEM["Greenwich", 0.0],
    UNIT["degree", 0.017453292519943295],
    AXIS["Lon", EAST],
    AXIS["Lat", NORTH]],
  PROJECTION["Albers_Conic_Equal_Area"],
  PARAMETER["central_meridian", -96.0],
  PARAMETER["latitude_of_origin", 23.0],
  PARAMETER["standard_parallel_1", 29.5],
  PARAMETER["false_easting", 0.0],
  PARAMETER["false_northing", 0.0],
  PARAMETER["standard_parallel_2", 45.5],
  UNIT["m", 1.0],
  AXIS["x", EAST],
  AXIS["y", NORTH]]
Thanks,
Bryan.

--001636c92c2c4a230d047af379e1
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi,</div>
<div>We&#39;ve bene trying to import shape files from the website here. (RI=
 is relatively small). I can display the shape files on udig, but have not =
been able to use shp2pgsql to import them an make sense of it.</div>
<div>=A0</div>
<div>I tried running INSERT into spatial_ref_sys (srid, auth_name, auth_sri=
d, proj4text, srtext) <br>values ( 924, &#39;sr-org&#39;, 24, &#39;&#39;, <=
br>&#39;PROJCS[&quot;NAD_1983_Albers&quot;,GEOGCS[&quot;GCS_North_American_=
1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&=
quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quo=
t;Degree&quot;,0.017453292519943295]],PROJECTION[&quot;Albers&quot;],PARAME=
TER[&quot;False_Easting&quot;,00000.0],PARAMETER[&quot;False_Northing&quot;=
,0.0],PARAMETER[&quot;Central_Meridian&quot;,-96.0],PARAMETER[&quot;Standar=
d_Parallel_1&quot;,29.5],PARAMETER[&quot;Standard_Parallel_2&quot;,45.5],PA=
RAMETER[&quot;Latitude_Of_Origin&quot;,23.0],UNIT[&quot;Meter&quot;,1.0]]&#=
39;);<br>
and use that as the srid of the imported data. Trying to st_transofrm that =
to 4326 or 32015 on windows with postgresql 8.4.1 crashed the server. We&#3=
9;ve also run it on 8.2 on linux - which doesn&#39;t die.</div>
<div>=A0</div>
<div>However, the results are essentially garbage. I assume there is someth=
ing (probably simple) that we are missing. Can someon point us in the right=
 direction to get this converted?</div>
<div>=A0</div>
<div>From what I can tell, udig sees thespatial reference as posted below. =
I used a link from <a href=3D"http://spatialreference.org/ref/sr-org/24/pos=
tgis/">http://spatialreference.org/ref/sr-org/24/postgis/</a>=A0as the basi=
s for creating the srid above.</div>

<div>PROJCS[&quot;NAD_1983_Albers&quot;, <br>=A0 GEOGCS[&quot;GCS_North_Ame=
rican_1983&quot;, <br>=A0=A0=A0 DATUM[&quot;D_North_American_1983&quot;, <b=
r>=A0=A0=A0=A0=A0 SPHEROID[&quot;GRS_1980&quot;, 6378137.0, 298.257222101]]=
, <br>=A0=A0=A0 PRIMEM[&quot;Greenwich&quot;, 0.0], <br>
=A0=A0=A0 UNIT[&quot;degree&quot;, 0.017453292519943295], <br>=A0=A0=A0 AXI=
S[&quot;Lon&quot;, EAST], <br>=A0=A0=A0 AXIS[&quot;Lat&quot;, NORTH]], <br>=
=A0 PROJECTION[&quot;Albers_Conic_Equal_Area&quot;], <br>=A0 PARAMETER[&quo=
t;central_meridian&quot;, -96.0], <br>
=A0 PARAMETER[&quot;latitude_of_origin&quot;, 23.0], <br>=A0 PARAMETER[&quo=
t;standard_parallel_1&quot;, 29.5], <br>=A0 PARAMETER[&quot;false_easting&q=
uot;, 0.0], <br>=A0 PARAMETER[&quot;false_northing&quot;, 0.0], <br>=A0 PAR=
AMETER[&quot;standard_parallel_2&quot;, 45.5], <br>
=A0 UNIT[&quot;m&quot;, 1.0], <br>=A0 AXIS[&quot;x&quot;, EAST], <br>=A0 AX=
IS[&quot;y&quot;, NORTH]]</div>
<div>Thanks,</div>
<div>Bryan.</div>
<div>=A0</div>
<div>=A0</div>

--001636c92c2c4a230d047af379e1--