python-2.7kmlpolygonsgeopandas

Convert GeoDataFrame polygons to kml file


I have a geopandas GeoDataFrame with various polygons and colors that I'm using to plot meteorological data (another question I asked here):

        color   geometry
0   #fbfdd1 (POLYGON ((-97.12191717810094 32.569, -97.1194...
1   #f3fabf (POLYGON ((-97.12442748846019 32.569, -97.1219...
2   #ebf7b1 (POLYGON ((-97.12944810917861 32.569, -97.1269...
3   #daf0b2 (POLYGON ((-97.18969555780023 32.569, -97.1879...
4   #cbeab3 (POLYGON ((-97.18969555780023 32.5710632999095...
5   #afdfb6 (POLYGON ((-97.18467493708175 32.569, -97.1821...
6   #92d4b9 (POLYGON ((-97.17463369564484 32.5730575804109...
7   #74c9bc (POLYGON ((-97.17714400600408 32.5764063816167...
8   #5bbfc0 (POLYGON ((-97.17714400600408 32.5790959050363...
9   #40b5c3 (POLYGON ((-97.17463369564484 32.5814268890055...
10  #31a6c2 (POLYGON ((-97.17714400600408 32.5852716913413...
11  #2397c0 (POLYGON ((-97.17714400600408 32.5878055733984...
12  #1e83b9 (POLYGON ((-97.17714400600408 32.5895482376014...
13  #206eaf (POLYGON ((-97.17714400600408 32.5911487379959...
14  #2259a5 (POLYGON ((-97.17714400600408 32.5927834911588...
15  #23479d POLYGON ((-97.17463369564484 32.59421434681196...
16  #243594 POLYGON ((-97.17463369564484 32.5962866795434,...
17  #1a2b7d POLYGON ((-97.1721233852856 32.59996829071199,...

I'd like to convert this to a kml / kmz file, but I have never worked with that file type before, so I'm not sure how to proceed. I've tried using this script, but it requires some height field that I do not have. Is there a good / easy way to do this within python? I'd like to avoid using online converter tools, if possible.


Solution

  • So I may have found a solution...

    I installed the Geospatial Data Abstraction Library and have been using the ogr2ogr function.

    As I explained in my question, I have a geopandas GeoDataFrame with polygons and associated colors, which I write to a json file:

    with open('/Users/Me/Documents/mydata.json', 'w') as f:
        f.write(gdf.to_json())
    

    In the Terminal / command line, I type:

    ogr2ogr -f KML /Users/Me/Documents/mydata.kml /Users/Me/Documents/mydata.json
    

    You could technically call this command from within a python script using the library 'subprocess':

    import subprocess
    subprocess.call("ogr2ogr -f KML /Users/Me/Documents/mydata.kml /Users/Me/Documents/mydata.json",shell=True)
    

    This generates a kml file with my lat/lon-based polygons. However, it automatically sets all the line colors to red with no fill color (even though my json file has colors in it). I haven't found a good solution to this, so I've been editing the KML file by hand to get the styling I want.