Trashbin_position

import json
import csv
s = open('ZPK_O_Kont_TOitem_b.json', encoding='utf-8-sig')
data = s.read()
popelnice = json.loads(data)
writer = csv.writer(open("trashbin_position.csv", 'w', newline='', encoding='utf-8'))
writer.writerow(['LATITUDE','LONGITUDE','OBJECTID','STATIONID','TRASHTYPENAME','CLEANINGFREQUENCYCODE','CONTAINERTYPE',])
for odpad in popelnice['features']:
  column1 = odpad['geometry']['coordinates'][1]
  column2 = odpad['geometry']['coordinates'][0]
  column3 = odpad['properties']['OBJECTID']
  column4 = odpad['properties']['STATIONID']
  column5 = odpad['properties']['TRASHTYPENAME']
  column6 = odpad['properties']['CLEANINGFREQUENCYCODE']
  column7 = odpad['properties']['CONTAINERTYPE']


  writer.writerow([column1, column2, column3, column4, column5, column6, column7])