[postgis-tickets] [PostGIS] #2447: wonrg LAT LONG values loading shapefile

[PostGIS]

#2447: wonrg LAT LONG values loading shapefile
---------------------------+------------------------------------------------
 Reporter:  strutus        |       Owner:  mcayland     
     Type:  defect         |      Status:  new          
 Priority:  blocker        |   Milestone:  PostGIS 2.1.0
Component:  loader/dumper  |     Version:  2.0.x        
 Keywords:                 |  
---------------------------+------------------------------------------------
 Loading shapefile containing POINT geom.
 For some reason, the LAT and LONG values show numbers that do no t look
 right when converted as TEXT (mapping using tools also do not work):

  SELECT ST_AsText(geom) from welldata
 "POINT(444602.87785624 3496780.24540007)"
 "POINT(444393.150243643 3498954.02641898)"

 SHape file was downloaded from http://sonris-
 www.dnr.state.la.us/gis/agsweb/arcgisserver/arcgisoutput/extData/shp/SABINE_wells.zip

 Shape loading was performed using the following command:
 shp2pgsql -I -s 6805 SABINE_wells.shp welldata > wellsdata.sql

 PRJ file contains:
 PROJCS["NAD_1983_UTM_Zone_15N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-93.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]

 Searching in spatial reference site I found this:
 http://spatialreference.org/ref/sr-org/6805/

 Any hints are highly appreciated.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2447>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.