RCC-GIS Geocoding Service
Welcome to the University of Chicago RCC-GIS Geocoding Service. This application allows UChicago affiliates to take lists of street addresses or place names and convert them into latitude and longitude coordinates. The coordinate pairs can then be used in any sort of mapping application or spatial analysis method.
Records must be formatted in a particular way for processing by the RCC-GIS Geocoding Service. The RCC-GIS Geocoding service requires data to be uploaded in a CSV (comma-separated value) format in the standard UTF-8 encoding. Different parts of the world have different formats and subdivisions for street addresses and place names. Records should be either in one column or divided accordingly for processing. The following column headers are acceptable for your CSV file:
ID ADDRESS NEIGHBORHOOD CITY SUBREGION REGION or STATE or ST POSTAL or ZIP or ZIPCODE COUNTRYCODE It is NOT necessary to provide data for all the variables listed above. However, if more data is provided, the geocoding service should provide a higher match rate.
Example File: A formatted US address file can be downloaded from here. International address file formatting For the CSV file creation, RCC recommends the use of OpenOffice or LibreOffice over excel.
Log on to the enterprise ArcGIS Online portal for the University of Chicago by clicking on “Sign in with Enterprise Login”.
- Enter the portal’s URL “uchicago.maps.arcgis.com” and click Continue.
- Sign in to the University of Chicago portal by clicking on UCHICAGO.
- Enter your University of Chicago CNetID username and password and click LOG IN.
- Upload your file to be geocoded by clicking Select File.
- Browse to your file’s location, highlight it, and click Open.
- Click the Submit button to activate the geocoding service.
- The geocoding service page will notify you that your file has been uploaded. Refresh your browser to see the progress with your data. (The geocoding service will process approximately 250,000 - 500,000 records per hour.)
When completed, click the link to Download the Geocoded File. Your geocoded file will be available for download for 7 days. After that time, it will be deleted from the queue.
3. Activate Geocoding Service
Click the above link or navigate to https://geocoder.rcc.uchicago.edu
The latitude and longitude variables are the real-world coordinates as interpreted by the ESRI’s World Geocoder for ArcGIS.
Match Score The match score is a calculation of how closely the interpreter came to finding the exact same address or place name. A perfect match score of 100% is optimal. However, a match score above 90% may also be suitable for many cases.- Example: a score of 92% may occur when the user provides the following address: 1100 E. 57th, Chicago, IL. A score of 100% might have been achieved if the user included the street type (ST) in the address record. Therefore, a perfect score could be achieved for 1100 E. 57th St., Chicago, IL.
- Example: if the user has 1100 N. Woodlawn Ave., Chicago, IL as a record, the interpreter may produce a match score of 72% along with a latitude/longitude coordinate pair. However, since 1100 N. Woodlawn Ave. does not exist, the interpreter will assign the location to the center of Chicago, IL instead. IT WILL NOT PRODUCE AN ERROR, ONLY A LOWER MATCH SCORE.