Converting Ushahidi JSON to GeoJSON

gistfile1.py

# convert Ushahidi JSON on stdin to GeoJSON on stdout

import json, sys

data = json.load(sys.stdin)

features = []
for item in data["payload"]["incidents"]:
    incident = item["incident"]
    feature = {
        "type": "Feature",
        "id": int(incident["incidentid"]),
        "properties": incident,
        "geometry": {
            "type": "Point",
            "coordinates": [
                float(incident["locationlongitude"]),
                float(incident["locationlatitude"])
            ]
        }
    }
    features.append(feature) 

collection = {
    "type": "FeatureCollection",
    "features": features
}

json.dump(collection, sys.stdout, indent=2)

Convert the output of this script to CSV using:

ogr2ogr -f CSV file.csv file.geojson