[GIS] Converting .shp file to .csv file using ogr2ogr

csvogr2ogrshapefile

I want to covert the .shp file to .csv file by using ogr2ogr
and I am running

PGCLIENTENCODING=UTF8 ogr2ogr -f CSV "/home/pj/Desktop/test1.csv" "/home/pj/Desktop/20160705102900718.shp"

but the shell prompt

ERROR 4: Unable to open /home/pj/Desktop/20160705102900718.shx or /home/pj/Desktop/20160705102900718.SHX.
FAILURE:
Unable to open datasource `/home/pj/Desktop/20160705102900718.shp' with the following drivers.
  -> ESRI Shapefile
  -> MapInfo File
  -> UK .NTF
  -> SDTS
  -> TIGER
  -> S57
  -> DGN
  -> VRT
  -> REC
  -> Memory
  -> BNA
  -> CSV
  -> NAS
  -> GML
  -> GPX
  -> LIBKML
  -> KML
  -> GeoJSON
  -> Interlis 1
  -> Interlis 2
  -> GMT
  -> SQLite
  -> DODS
  -> ODBC
  -> PGeo
  -> MSSQLSpatial
  -> OGDI
  -> PostgreSQL
  -> MySQL
  -> PCIDSK
  -> XPlane
  -> AVCBin
  -> AVCE00
  -> DXF
  -> Geoconcept
  -> GeoRSS
  -> GPSTrackMaker
  -> VFK
  -> PGDump
  -> OSM
  -> GPSBabel
  -> SUA
  -> OpenAir
  -> PDS
  -> WFS
  -> HTF
  -> AeronavFAA
  -> Geomedia
  -> EDIGEO
  -> GFT
  -> SVG
  -> CouchDB
  -> Idrisi
  -> ARCGEN
  -> SEGUKOOA
  -> SEGY
  -> XLS
  -> ODS
  -> XLSX
  -> ElasticSearch
  -> PDF
]

Best Answer

A shapefile consists of a bunch of files. The .shp and .shx are mandatory, .dbf and .prj are necessary for some tasks as well.

The error message notes that the .shx file for your .shp file is missing. If you rename the .shp file to match the naming conventions, make sure to rename the .shx file as well.

Related Solutions

Convert CSV with WKT Data to Shapefile Using Ogr2ogr

I had to solve the same problem today, so here is my answer, which gives a complete solution.

I have a lineWKT.csv file stored in F:\Data\ folder, with the data like this:

id,gm
0,"LINESTRING (30 10 0, 10 30 0, 40 40 5)"

I have a test.vrt file like this:

<OGRVRTDataSource>
    <OGRVRTLayer name="lineWKT">
       <SrcDataSource>F:\Data\lineWKT.csv</SrcDataSource>
      <GeometryType>wkbLineString25D</GeometryType>
 <LayerSRS>PROJCS["WGS_1984_Lambert_Conformal_Conic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1000000.0],PARAMETER["False_Northing",1000000.0],PARAMETER["Central_Meridian",85.875],PARAMETER["Standard_Parallel_1",24.625],PARAMETER["Standard_Parallel_2",27.125],PARAMETER["Latitude_Of_Origin",25.8772525],UNIT["Meter",1.0]]</LayerSRS>
 <GeometryField encoding="WKT" field='gm' > </GeometryField >
     </OGRVRTLayer>
</OGRVRTDataSource>

With this configuration, I can create a shapefile with the following command:

ogr2ogr line.shp test.vrt

OGR2OGR CSV Reprojection – How to Reproject CSV File to a Different Projection Using OGR2OGR

This should be possible. But I have not tried it, so test it out first.

In order to read a csv as a spatial file you need to create a .vrt file for it. So it can be loaded in virtually.

So you need something like:

<OGRVRTDataSource> 
  <OGRVRTLayer name="codepoint"> 
    <SrcDataSource>codepoint.csv</SrcDataSource> 
    <GeometryType>wkbPoint</GeometryType> 
    <LayerSRS>EPSG:27700</LayerSRS> 
    <GeometryField encoding="PointFromColumns" x="Eastings" y="Northings"/> 
  </OGRVRTLayer> 
</OGRVRTDataSource>

So this defines how your csv is laid out. Replace field "Easting" and file "codepoint" and projection "EPSG:27700" as needed.

Then to convert it shouldn't be an issue:

ogr2ogr -f CSV -lco GEOMETRY=AS_XY -t_srs EPSG:4326 test.csv visivisi.csv

Writing to CSV, geometry is discarded as default, so the -lco GEOMETRY=AS_XY is needed. Your source projection should be defined in the .vrt file so a -s_srs shouldn't be needed, but might.

I have a guide on loading csv data to PostGIS which may help a bit: http://gisforthought.com/loading-csv-xy-data-into-postgis-with-codepoint-open/

And the ogr csv driver details does cover most of this: http://www.gdal.org/ogr/drv_csv.html

Best Answer

Related Solutions

Convert CSV with WKT Data to Shapefile Using Ogr2ogr

OGR2OGR CSV Reprojection – How to Reproject CSV File to a Different Projection Using OGR2OGR

Related Question