[OSM-talk] recommendation for JSON to CSV converter

[Dave F]

You don't say what you want to output to but I use the command line 
program ogr2ogr (you will need to install all GDAL, I believe - 
https://gdal.org/index.html).

Example to convert to CSV:

ogr2ogr.exe -f csv output.csv input.geojson -lco GEOMETRY=AS_XY

You may have to adjust the GEOMETRY settings to get it to format to your 
desire.

It's also very useful for converting between co-ordinate systems eg 
(-s_srs EPSG:27700 -t_srs EPSG:4326")

DaveF

On 28/02/2024 15:16, Martin Trautmann via talk wrote:
> Is there any JSON converter that you would recommend?
>
> There are plenty of web services, but none of those worked for me, on
> <https://opendata.essen.de/sites/default/files/Hauskoordinaten_0822.geojson>
> (70 MB)
>
> There are plenty of starter tutorials, in order to use python,
> javascript etc.
>
> But those did not work either.
>
> I tried dasel, without success (dasel version v2.5.0)
>
> So I wonder what the best solution might be, apart of writing my own
> converter (probably in perl).
>
> What I would expect is hopefully a 100 % conversion - or an error log
> which data could not be processed.
>
> The problem here seems to be the nesting of several levels.
>
> Thanks,
> Martin
>
>
> _______________________________________________
> talk mailing list
> talk at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk