Run Export frm SQL script: CO SE CNA Student Geocoding

Export the records with missing geocode data to a CSV file WITHOUT column names.

URL for the Census geocoding batch upload portal: https://geocoding.geo.census.gov/geocoder/locations/addressbatch?form

Open the exported CSV file from the Census Portal

1.  Insert one row

2.  Add these column titles: MsfID, Address, Match, Status, AddressCombined, Coordinates, CensusID, Label, ScbLongitude, ScbLatitude

3.  Delete any rows that do not have coordinates returned

4.  Enter these formulas in columns I and J
CALC LONGITUDE IN EXCEL: =LEFT(F2,FIND(",",F2,1)-1)
CALC LATITUDE IN EXCEL: =RIGHT(F2,LEN(F2)-FIND(",",F2,1))

5.  Filter Coordinates Column (F) for blanks only and delete these.