I am stuck converting a geometry(MultiLineString) into coordinates. The following I did.

  1. I download the data from this Austin Contours data link

  2. I import the shape files using PGAdmin III and inserted around 894345 data.

  3. In last column I got the following geom MultiLineString.


When I converted this into coordinates from online link it gives the wrong coordinated data as given below


Which is not the lat long. I didn't understand why I getting this I am using the following query to get the data from the PostgreSQL database tables.

SELECT row_to_json(fc.*) as dparcel into ac
  SELECT  'FeatureCollection' AS type, 
    array_to_json(array_agg(f.*)) AS features 
    SELECT  'Feature' AS type,  
        SELECT  row_to_json(t) as properties  
          select * from austin.austin_contours WHERE gid = adp.gid
        ) t 
    ST_AsGeoJSON(geom)::json  as geometry
    FROM austin.austin_contours  adp
    LIMIT 20
  ) f 
) fc; 

Here geom is the column name of austin.austin_contours table.

  • 2
    the data is in a projected CRS, the coordinates meter (or possibly even feet) in relation to the reference axes; do you know the CRS SRID of that data?
    – geozelot
    Commented Jun 28, 2018 at 11:40
  • No, I am sorry... I don't know the CRS SRID, because I import the data directly from shapefile via PostGIS Shapefile and DBF Loader. But yes I import the shape file the import/export manager window default was 0 I just saw that. I was also wondering the the string is right or not ? Commented Jun 28, 2018 at 11:52
  • the string is fine, it just need a SRID, at least to be transformed to the geographic coordinates you seem to want. what tools do you have available? QGIS? or are you familiar with the OGR command line tools (i.e. ogrinfo)? the shapefiles should have the CRS info in it´s metadata or go check the providers homepage for info on it.
    – geozelot
    Commented Jun 28, 2018 at 11:59
  • I didn't work on QGIS recently, so not so much aware on this and don't have software available with me and not worked on OGR command line tools yet. I just try to show the shape files on mapshaper.org and get the other format data as I need. Commented Jun 28, 2018 at 12:06
  • I got the CRS from QGIS. CRS is "[+proj=lcc +lat_1=30.11666666666667 +lat_2=31.88333333333333 +lat_0=29.66666666666667 +lon_0=-100.3333333333333 +x_0=699999.9999999999 +y_0=3000000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=us-ft +no_defs]". Now what need to do, please help me Commented Jul 2, 2018 at 10:19

1 Answer 1


According to the .prj file included it is stored in NAD_1983_StatePlane_Texas_Central_FIPS_4203_Feet which according to epgs.io is ESRI:102739 and probably EPSG:42307.

  • ok, but we need CRS SRID of the data I imported which I am not able to get it, I thing we got this we can do something for string and get the right coordinate multiline string data, is that make sense ? Commented Jun 28, 2018 at 14:18
  • that is the SRID of your data
    – Ian Turton
    Commented Jun 28, 2018 at 14:19
  • Ok...So EPSG:42307 is the SRID. What I need to do in that to get the right coordinates of the multilinestring data given above. Commented Jun 29, 2018 at 5:31
  • I set the SRID to 4326 now from the following query. ALTER TABLE austin.austin_contours ALTER COLUMN geom SET DATA TYPE geometry(MULTILINESTRING, 4326) USING ST_SetSRID(geom,4326); Again when I select the data the out of coordinate is same, what to do to get the right data now. Commented Jun 29, 2018 at 6:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.