The Geo Data Review page lets you validate the geo-coordinates – that is, the latitudes and longitudes – of service point locations.
The validation process looks for and counts:
- Latitude and longitude values that equal 0, -0 (the equator)
- Invalid or out-of-bounds latitudes and longitudes (values that fall outside of the selected location state overlay)
- The total number of geo-coordinates reviewed.
Service locations that fall outside the boundary map and as thus invalid are displayed as dots on a map. Clicking each dot opens a searchable pop-up menu.
To help you correct invalid geo-coordinates, a Report Preview displays a paginated list. By default, the list includes all invalid geo-coordinates.
To filter the results displayed in the Preview Report, click one of:
- Latitude and longitude values that equal 0, -0 (the equator)
- Invalid or out-of-bounds latitudes and longitudes (values that fall outside of the selected location state overlay).
The active filter is displayed in a light blue rectangle next to Report Preview.
To clear the filter, click the X.
A drop-down menu lets you export CSV-format reports.
To start the geo data validation process:
- Use the Location drop-down menu to select the state in which to validate geo-coordinates. To select a state, click on its name and then click outside the location drop-down menu.
- Click Validate Now.
- When validation is complete, the system displays the results of its data validation check below the Validate Now button and as color-coded dots on the map. Each color indicates a geocode status that tells you how the latitude and longitude values were determined.
Purple – Service Point – Geo-location is based on the Service_Point_Longitude/Latitude values provided via a Data Exchange file.
Yellow – Facility – Geo-location is based on the Utility’s coordinates.
Pink – Location – Geo-location is based on the Location address provided via Data Exchange file.
Orange – Indeterminable – Geo-location could not be determined based on the Location address provided via Configured Import file. - Use the < and > buttons to step forward and backward through the list of locations.
The Report Preview lists invalid geo-coordinates along with data to help you identify each service.
Fields displayed in the Report Preview
| Field Name | Description |
| Meter ID | Identifier of the meter. |
| Account ID | Unique identifier of the Account used for billing purposes. |
| Location ID | Unique identifier for the location where the service is being provided. |
| Address | Address of the service location as determined by the value entered in the Location_Address_Line1 field of a data exchange file. |
| Zip Code | ZIP+4 or postal code of the service location. |
| Latitude | Latitude position of the service location in decimal degrees. Must be no more than 15 digits long and fall between -90 and 90 degrees. |
| Longitude | Longitude position of the service location in decimal degrees. Must be no more than 15 digits long and fall between -180 and 180 degrees. |
| Geo Coordinate Source |
For details on how AquaCUE determines geo-coordinates along with instructions on how to correct geo-coordinates, see Set Latitude and Longitude. |
Additional Fields included in downloaded reports:
| Field Name | Description |
| Location_Address_Line2 | |
| Location_Address_Line3 | |
| Location_City | |
| Location_State | |
| Location_Country |
Use the Download Report drop-down menu to select the data of interest.
Near Zero Geo(s) Report – Exports a CSV-format report that includes locations whose latitude and longitude is equal to 0º latitude, 0º longitude.
Invalid Geo(s) Report – Exports a CSV-format report that includes all of the geo-coordinates that fall outside of the selected location overlay.
Correcting Geo Coordinates
For detailed instructions on how to correct geo coordinates, see Set Latitude and Longitude.
Use the Pagination Controls on the bottom of the Activity List to jump to the first, last or a group of
entries.
