csv - Geocoding using Geopy ArcGIS and Python -
i trying geocode multipe address using geopy , arcgis. have set code loop through csv , check address , name , provide separate column lat , long coordinates.
this wrong code when executed not provide lat long coordinates , not loop through csv. how make it loop through multiple address , geocode them giving lat , long coordinates.
below code:
import csv geopy.geocoders import arcgis geolocator = arcgis() #here parameters needed open('c:/users/v-albaut/desktop/test_geo.csv', 'rb') csvinput: open('output.csv', 'w') csvoutput: output_fieldnames = ['name','address', 'latitude', 'longitude'] writer = csv.dictwriter(csvoutput, delimiter=',', fieldnames=output_fieldnames) reader = csv.dictreader(csvinput) row in reader: ##here have replace dict item csv column names query = ','.join(str(x) x in (row['name'], row['address'])) address, (latitude, longitude) = geolocator.geocode(query) ###here writing section output_row = {} output_row['name'] = name output_row['address'] = address output_row['latitude'] = latitude output_row['longitude'] =longitude writer.writerow(output_row)
name,latitude longitude haven't been defined in scope in lines
output_row['name'] = name output_row['address'] = address output_row['latitude'] = latitude output_row['longitude'] =longitude it should latitude, longitude there. name, guessing should row['name']. can post snippet(header , 1-2 lines) of csv file?
Comments
Post a Comment