My question is similar to this question. I have two different data files.
Data1.csv (4500 rows) GEOid GEOid2 Total Population Urban Rural 1000000US220019603001020 220019603001020 72 0 72 Data2.csv (7000 rows) Latitude Longitude ADT 30.48103 -92.61743 234
I want to get GEOid2 for each point (latitude, longitude) which I can do manually by using this API. This task will be then tiresome.
Is there any particular method by which I can use the list of latitude and longitude to get exact GEOid2 for each location point by using that API?
Finally I want my table like this.
Data.csv Latitude Longitude ADT GEOid2 Total Population Urban Rural 30.48103 -92.61743 234 220019603001020 72 0 72