difficulties to chage json data structure using json module in python

[Sibdar]

Good Day, Python community

I am trying to create a script to change THIS JSON data structure:

{ "16bec99d-a13e-4a21-a761-f673631b6060": { "ImageName": "chp/chp08.png", "Fill": 844168280, "Line": -11469736, "ID": "16bec99d-a13e-4a21-a761-f673631b6060", "ParentID": "94021e84-2a1e-440d-9f37-b349fa2cd0d8", "Name": "198008", "IsPolygon": true, "R": 0, "Lat": [ 58.496235, 58.496299, 58.49533, 58.495213 ], "Lng": [ 103.794173, 103.797618, 103.797715, 103.796126 ], "Holes": null }, "8dc91f95-666e-4137-b29b-b12dbbddbdbe": { "ImageName": "chp/chp08.png", "Fill": 844168280, "Line": -11469736, "ID": "8dc91f95-666e-4137-b29b-b12dbbddbdbe", "ParentID": "94021e84-2a1e-440d-9f37-b349fa2cd0d8", "Name": "198005", "IsPolygon": true, "R": 0, "Lat": [ 58.484494, 58.484392, 58.483932, 58.484163 ], "Lng": [ 103.625914, 103.626353, 103.625889, 103.625286 ], "Holes": null } }

TO THIS JSON STRUCTURE:

{ "features": [ { "geometry": { "rings": [ [ [103.794173,58.496235], [103.797618,58.496299], [103.797715,58.49533], [103.796126,58.495213] ] ], }, "attributes": { "Name": "123456", "ID": "16bec99d-a13e-4a21-a761-f673631b6060", "Fill": 844168280, "Line": -11469736 } }, { "geometry": { "rings": [ [ [103.625914,58.484494], [103.626353,58.484392], [103.625889,58.483932], [103.625286,58.484163] ] ], }, "attributes": { "Name": "689651", "ID": "8dc91f95-666e-4137-b29b-b12dbbddbdbe", "Fill": 844168280, "Line": -11469736 } } ] }

I am newbie in Python (and in programming in general), so I spent 3 days literally for nothing
and would like to ask your help. At least, maybe you can point me in the right direction.

Here is my attempt:

import json data = {'16bec99d-a13e-4a21-a761-f673631b6060': {'ImageName': 'chp/chp08.png', 'Fill': 844168280, 'Line': -11469736, 'ID': '16bec99d-a13e-4a21-a761-f673631b6060', 'ParentID': '94021e84-2a1e-440d-9f37-b349fa2cd0d8', 'Name': '198008', 'IsPolygon': True, 'R': 0, 'Lat': [58.496235, 58.496299, 58.49533, 58.495213], 'Lng': [103.794173, 103.797618, 103.797715, 103.796126], 'Holes': None}, '8dc91f95-666e-4137-b29b-b12dbbddbdbe': {'ImageName': 'chp/chp08.png', 'Fill': 844168280, 'Line': -11469736, 'ID': '8dc91f95-666e-4137-b29b-b12dbbddbdbe', 'ParentID': '94021e84-2a1e-440d-9f37-b349fa2cd0d8', 'Name': '198005', 'IsPolygon': True, 'R': 0, 'Lat': [58.484494, 58.484392, 58.483932, 58.484163], 'Lng': [103.625914, 103.626353, 103.625889, 103.625286], 'Holes': None}} for d in data: for x,y in zip(data[d]['Lat'],data[d]['Lng']): arcgisJSON = { "features": [ { "geometry": { "rings": [[ x,y ]] }, "attributes": {data[d]['Name'],data[d]['ID'],data[d]['Fill'],data[d]['Line']} } ] } print(arcgisJSON)

The OUTPUT is:

Output:
{'features': [ {'geometry': {'rings': [[58.484163, 103.625286]]}, 'attributes': { -11469736, '198005', 844168280, '8dc91f95-666e-4137-b29b-b12dbbddbdbe'}}]}

My loop gets just one object from data, creates just one array in 'rings' and I can not fetch needed key-value pairs in 'attributes' (just values).

Please, give me at least good advice.

Best wishes,
Sibdar

[micseydel]

I don't see where the names in the final result are coming from, and your target json had some extraneous commas that make it invalid. That said, I tinkered with it and got something working.

The biggest problem is that you're returning in a loop, when logically you need the whole thing. Here's what I ended up with:

def transform(start): return { "features": [ { "geometry": { "rings": [ list(zip(obj["Lng"], obj["Lat"])) ], }, "attributes": { "Name": "123456", "ID": name, "Fill": obj["Fill"], "Line": obj["Line"] } } for name, obj in start.items() ] }

I realize this may be more advanced than you're used to. If you have trouble understanding it, we could re-write it without the list comprehension.