wonrg LAT LONG values loading shapefile

[strutus]

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]],PROJECTIONTransverse_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.

[kashif]

well the point coordinates you are seeing are in the original 6805 projection system. If you want the data in lat/lng you will need to st_transform it to srid 4326, or:

shp2pgsql -I -s 6805:4326 SABINE_wells.shp welldata > wellsdata.sql

should in theory save the coordinates in lat/lngs

hope this helps

[robe]

Thanks kashif. I'm going to close this out.