locations

244 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, state, geocode_source

Next page

CREATE TABLE locations (
  canonical_name TEXT PRIMARY KEY,
  location_type TEXT,
  state TEXT, country TEXT,
  lat REAL, lon REAL,
  geocode_source TEXT,          -- manual / nominatim / NULL
  geocode_note TEXT,            -- OSM display_name or manual note (auditable)
  notes TEXT
);