Advertisement
Guest User

Trashbin_access

a guest
Nov 24th, 2019
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.77 KB | None | 0 0
  1. import json
  2. import csv
  3. s = open('ZPK_O_Kont_TOstan_b.json', encoding='utf-8-sig')
  4. data = s.read()
  5. popelnice = json.loads(data)
  6. writer = csv.writer(open("trashbin_access.csv", 'w', newline='', encoding='utf-8'))
  7. writer.writerow(['OBJECTID','ID','STATIONNUMBER','STATIONNAME','CITYDISTRICTRUIANCODE','CITYDISTRICT','PRISTUP'])
  8. for odpad in popelnice['features']:
  9.   column1 = odpad['properties']['OBJECTID']
  10.   column2 = odpad['properties']['ID']
  11.   column3 = odpad['properties']['STATIONNUMBER']
  12.   column4 = odpad['properties']['STATIONNAME']
  13.   column5 = odpad['properties']['CITYDISTRICTRUIANCODE']
  14.   column6 = odpad['properties']['CITYDISTRICT']
  15.   column7 = odpad['properties']['PRISTUP']
  16.  
  17.   writer.writerow([column1, column2, column3, column4, column5, column6, column7])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement