POI CSV Schema: Fields, Nulls & Coordinates
Published by DevIntel · Content reviewed 2026-10-22. Dataset snapshot dates are stated separately.
The same 11 columns are used across regional POI snapshots. Rates below are global record-weighted rates, not regional accuracy scores. Snapshot: 2026-10-20.
| Field | Type | Fill rate | Meaning |
|---|---|---|---|
address | STRING | 77.3% | Full street address with city, region, postcode and country. US addresses are cleaned (ZIP+4, suites, spacing). |
entity_id | STRING | 100.0% | Place ID derived from an MD5 of the winning source record. Upstream changes or a different winning record can change it between releases; not a permanent cross-release guarantee. |
entity_type | STRING | 92.2% | Category from the winning source. Vocabularies differ by source (e.g. 'Hardware Store', 'fast_food'). |
status | STRING | 100.0% | Active, or Inactive when a source marks the place closed. |
entity_name | STRING | 100.0% | Place name. |
city | STRING | 84.6% | City or locality. |
state | STRING | 64.5% | State or region. Two-letter code in the US. |
iso_country_code | STRING | 100.0% | Country (ISO 3166-1 alpha-3). |
latitude | FLOAT | 100.0% | Latitude in WGS84 degrees. |
longitude | FLOAT | 100.0% | Longitude in WGS84 degrees. |
geometry | GEOMETRY | 100.0% | Footprint of the building containing the place, or the nearest within about 50 m, as WKT in WGS84 (EPSG:4326). |
CSV preview conventions
The three-row public previews are UTF-8, comma-delimited, with a header and LF newlines. Cells containing commas, quotes or newlines are quoted; embedded quotes are doubled. Empty cells represent missing values. Spreadsheet-sensitive text in these previews is prefixed with an apostrophe. Confirm production file conventions with the team for your import requirements.
Codes and coordinates
Purchase region codes use ISO 3166-1 alpha-2 countries or ISO 3166-2 subdivisions, such as GB and US-NY. The delivered iso_country_code field uses alpha-3, such as USA. Georgia, United States (US-GA), is distinct from Georgia (GE). Latitude and longitude use WGS84 degrees; geometry is WKT in EPSG:4326.
Interpretation caveats
Source category vocabularies differ. “Active” is source status, not verified opening status. The ID derives from the winning source record and should not be treated as an immutable cross-release key.
Inspect before buying
Browse regional POI coverage and download actual CSV samples · Inspect schema and regional prices · Contact the team