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: Socrata does not support the geocoding of intersection data. In order to map intersections, you will have to provide latitude and longitude values for each point.
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 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.