More

Handling KML/CSV with geopandas - DriverError: unsupported driver: u'CSV'

Handling KML/CSV with geopandas - DriverError: unsupported driver: u'CSV'


I'm trying to import a dataset of UK postcode districts UK postcode districts from Google Fusion tables into geopandas with the aim of splicing it to a dataset of house prices.

The problem is that geopandas doesn't seem to like either the CSV/KML version of the data.

If I use the command geopandas.from_file(path) then I receive the error:

DriverError: unsupported driver: u'CSV'

I have the same error when I try to import a KML version of the data (You can download the data below).

I'm sure it's trivial, but can anyone work out what I'm doing wrong?

UK postcode districts - KML

UK postcode districts - CSV


in case of csv, it probably would be easier to read it with pandas and then convert it to geopandas Dataframe

import pandas as pd import geopandas as gp from shapely.geometry import Point stations = pd.read_csv('… /data/stations.csv') stations['geometry'] = stations.apply(lambda z: Point(z.X, z.Y), axis=1) stations = gp.GeoDataFrame(stations)

The KML driver isn't enabled by default as detailed in this github issue https://github.com/Toblerity/Fiona/issues/97. Basically, the KML driver doesn't seem to meet Fiona's quality requirements (as of 2014), not sure if it will be fixed in the future.

You could try to read a simple/standard-enough KML as follows:

import geopandas as gpd fiona.drvsupport.supported_drivers['kml'] = 'rw' # enable KML support which is disabled by default fiona.drvsupport.supported_drivers['KML'] = 'rw' # enable KML support which is disabled by default gpd.read_file("/path/to/your/test.kml")

I've tried to read a file here and it gave me the following output:

Credits to this gist:

https://gist.github.com/timtroendle/6f61dc38a0aad58c2261524d7d8594c3

Edit 20191021: With newer versions offiona, you might need to uselibkmlinstead ofkml. I.e.:

fiona.drvsupport.supported_drivers['libkml'] = 'rw' # enable KML support which is disabled by default fiona.drvsupport.supported_drivers['LIBKML'] = 'rw' # enable KML support which is disabled by default

GeoPandas relies on the Fiona library (http://github.com/toblerity/Fiona) for thefrom_file()implementation. At this time Fiona, and therefore GeoPandas, does not support CSV or KML input. If you can convert them to GeoJSON or Shapefiles, then GeoPandas should be able to read without a problem.


The current version of Fiona supports the CSV driver out of the box. You may have to specify the names of the latitude and longitude columns like this:

geopandas.read_file("file.csv", X_POSSIBLE_NAMES="X", Y_POSSIBLE_NAMES="Y")

More information about possible arguments for the csv driver can be found in the gdal driver documentation: https://gdal.org/drivers/vector/csv.html#open-options


Watch the video: CSV to Google earth