[postgis-users] Problem trying to import data from wetlands.fws.gov

[Bryan Montgomery]

Hi,
We'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.

I tried running INSERT into spatial_ref_sys (srid, auth_name, auth_srid,
proj4text, srtext)
values ( 924, 'sr-org', 24, '',
'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]],PROJECTION["Albers"],PARAMETER["False_Easting",00000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",23.0],UNIT["Meter",1.0]]');
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've
also run it on 8.2 on linux - which doesn't die.

However, the results are essentially garbage. I assume there is something
(probably simple) that we are missing. Can someon point us in the right
direction to get this converted?

>From what I can tell, udig sees thespatial reference as posted below. I used
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091217/5895dfe0/attachment.html>