Adding Properties to GeoJSON File

Question

I have a GeoJSON file of the country of Haiti with the administrative boundaries for communes (i.e. counties). Here is the file:

https://rawgit.com/mattbowlby/bf5243ab097e50eb8864/raw/46818c96bc49629681238d5302d597456227c040/haiti_communes.geo.json

That file has a few properties, for example:

( "properties": {
        "id_com": 112,
        "commune": "Delmas",
        "id_dept": 1,
        "dept": "West Department",
        "shape_leng": 0.242799419022,
        "latitude": 18.5543057016,
        "longitude": -72.297644435,
        "shape_le_1": 0.242799419022,
        "shape_area": 0.00222841371629

Now, I want to be able to add a number of new properties, such as area, population and other things. I have 141 different communes and do not want to enter this information manually. Is there a way to work with a GeoJSON file and add the properties, such as with a spreadsheet or other format? Ideally I would have it in a spreadsheet and add in the new properties as columns.

Answer 1

I would download and install QGIS, and then open the geojson file by clicking Add vector layer button:

After that you should be able to see you geojson file in QGIS:

And right click the layer's name in the left hand layer list, and click "Properties"; then go to the "Joins" tab, and click the green plus icon on the left bottom corner to open "Add vector join":

Join the table with the fields you would like to append to your geojson file; then right click layer's name in the left hand layer list, and click "Save As..." to save the geojson file into a new file and you should have what you need. And make sure you specify the output format as "GeoJSON":

Hope this helps, thanks.

Answer 2

Another option would be to use geojson.io Just upload your geojson file and add a column, and do your edits.

Once you are satisfied with your edits, you can just download the resulting geojson file

Good luck!

Answer 3

In case you work with d3 (as your tag suggests) here is an alternative using topojson.

For a tsv file "attributes.tsv" in the following format:

id  attribute
112 A
114 B
123 C
211 D
442 E
343 F
...

Convert to topojson:

topojson -o topojson.json haiti_communes.geo.json -p

Join:

topojson -o final.json -e attributes.tsv --id-property=+id_com,+id -p -- topojson.json

hat tip