[OSM-talk] recommendation for JSON to CSV converter

[Colin Smale]

> On 28/02/2024 17:30 CET Martin Trautmann via talk <talk at openstreetmap.org> wrote:
> 
>  
> On 28.02.24 16:43, Mike Thompson wrote:
> > Hi Martin,
> > 
> > Could you provide some more detail on what specifically you are
> > attempting to achieve? Converting a geojson file of points to CSV is
> > pretty easy, but once you get to linestrings, multi-linestrings,
> > polygons, etc. it gets difficult because in those cases the geometry
> > objects have a variable number of components.  
> 
> Hi Mike,
> 
> what I need is
> 
> Strassenna;HsNr_Zus;StrSchlues
> Stinnesstr.;8;02968
> 
> ..which I could grep easily, but I would also need to know in which
> "Gemeinde" that is, including their "Amtlicher Gemeindeschlüssel (AGS)"

Have you looked at "jq"?
Some tips here:
https://qmacro.org/blog/posts/2022/05/19/json-object-values-into-csv-with-jq/
https://richrose.dev/posts/linux/jq/jq-json2csv/