The location column is a column within a Socrata dataset with the data type 'Location' . When address information is inputted into this column our platform uses a third party geocoding service to geocode this information into a latitude and longitude which can be plotted on a map. At least one successfully geocoded location column is required to create a map.
The following kinds of location information can be used to create a geocoded address -
- A U.S. street address
- Zip Code (can be geocoded individually)
- City, State
- Latitude and Longitude (if provided the dataset is already considered geocoded and will bypass our service. As a result, this doesn't need any of the other address information).
- Use: + for N Lat or E Long & - for S Lat or W Long.
For the most accurate geocoding results, we recommend including the address, city, state and zip code.
Common Errors while geocoding:
1. Intersections: While it is possible to geocode intersections using our service, often times intersections do not have a precise address. This results in the location information given not plotting exactly in the right spot on the map. These are some best practices to ensure the most accurate plotted address:
- The names should be spelled out fully.
- The connector should be a "&".
- Lastly, provide a zip code to narrow down your results.
2. P.O. Box and Apt/Suite numbers: We do not use this information for geocoding and if you include it in the address field the it will interfere with the geocoding, which will fail.
Example: Charlotte-Gastonia-Concord, NC-SC (Metropolitan Area)
4. International Locations: Currently, we do not support international geocoding. Latitudes and longitudes must be provided for international addresses. If addresses are listed, they must include the city and country.