[GIS] How to convert polygon shapefile to CSV

convertcsvgeojsonMySQL

I can convert shapefile (having points) to CSV file, import in MySQL databases and then i can execute my queries for searching. Now I want to do same for polygon shapefile; that is, I want to convert a shapefile having polygons to CSV and then import in MySQL databases for search purposes.

Is that possible?

Actually i have a geojson file having road polylines. i want to convert this geojson to csv then import in databases and then execute my search queries e-g i want to draw on google map only those roads having length less than 10km etc.

Best Answer

In QGIS, you can use the MMQGIS plugin function "Export Geometry to CSV". This tool would generate WKT for each polygon in the shape file as well as any associated attributes. The process is simple and relatively quick.

Related Solutions

ArcGIS Desktop – How to Convert XY Points to a Line

It seems like the crucial thing you want here is for the points in the line to be sorted by the time of capture, spread across three column rows. While you could organise the data in a spreadsheet, I often find writing a quick script provides the most flexibility:

import csv
from datetime import datetime
try:
    from osgeo import ogr
except ImportError:
    import ogr

SHP_FILENAME = "output.shp"
CSV_FILENAME = "input.csv"

r = csv.reader(open(CSV_FILENAME, 'r'), delimiter=',', quotechar=None)
header = dict(((str, i) for i, str in enumerate(r.next())))

# load data rows into memory
rows = [row for row in r]

# sort by date and time ascending
rows.sort(key=lambda row: datetime.strptime(
        (row[header['Date']] + ' ' + row[header['Time']] + ' ' + 
         row[header['ampam']]), 
        '%d/%m/%Y %I:%M:%S %p'))

# Create new shapefile
ogr.UseExceptions()
ds = ogr.GetDriverByName('ESRI Shapefile').CreateDataSource(SHP_FILENAME)
layer = ds.CreateLayer("data", None, ogr.wkbLineString)

# Create a new line geometry
line = ogr.Geometry(type=ogr.wkbLineString)

# Add GPS points to line
lon_idx, lat_idx = header['Longitude'], header['Latitude']
for row in rows:
    line.AddPoint(float(row[lon_idx]), float(row[lat_idx]))

# Add line as a new feature to the shapefile
feature = ogr.Feature(feature_def=layer.GetLayerDefn())
feature.SetGeometryDirectly(line)
layer.CreateFeature(feature)

# Cleanup
feature.Destroy()
ds.Destroy()

[GIS] Converting Shapefile data to GeoJSON

There are java bindings for GDAL/ogr - see http://gdal.org/java/ . No idea if they work on Android, though. Apparently ( https://www.google.de/search?q=gdal+on+android ) building gdal on Android is not really easy.

http://sourceforge.net/projects/javashapefilere/ seems to be another option.

Also https://stackoverflow.com/questions/2044876/does-anyone-know-of-a-library-in-java-that-can-parse-esri-shapefiles .

Best Answer

Related Solutions

ArcGIS Desktop – How to Convert XY Points to a Line

[GIS] Converting Shapefile data to GeoJSON

Related Question