Help
The OSM SQL Terminal is an online tool to query OpenStreetMap data (Switzerland) with spatial SQL.
If the Data Output contains a column of type geometry, the data will be shown on the map. To successfully show
on the map the geometry data needs to be in EPSG:4326 (WGS84). An output with more than about 10'000 objects
(rows)
will increase loading time significantly.
The database is usually being refreshed every hour from the OpenStreetMap database and loaded into
PostGIS/PostgreSQL ("EOSMDBTwo").
Terms and Conditions: By using this service you agree to these terms and conditions. Use this service
responsibly and at your sole risk. This service is provided "as is", "as available" and with no warranties. We
are not responsible for the content or data. We do not track you, however accesses and anonymized use are
logged.
Database schema
| osm_point |
| osm_id : bigint [primary key] |
| osm_version : integer [not null] |
| osm_timestamp : timestamptz [not null] |
| name : text |
| label : text |
| tags : hstore |
| rank : integer |
| geom : geometry(Point) [not null] |
| osm_line |
| osm_id : bigint [primary key] |
| osm_version : integer [not null] |
| osm_timestamp : timestamptz [not null] |
| name : text |
| label : text |
| tags : hstore |
| rank : integer |
| geom : geometry(LineString) [not null] |
| osm_polygon |
| osm_id : bigint [primary key] |
| osm_version : integer [not null] |
| osm_timestamp : timestamptz [not null] |
| name : text |
| label : text |
| tags : hstore |
| rank : integer |
| geom : geometry(Geometry) [not null] |
| osm_boundary |
| osm_id : bigint [primary key] |
| osm_version : integer [not null] |
| osm_timestamp : timestamptz [not null] |
| name : text |
| label : text |
| tags : hstore |
| admin_level : integer |
| rank : integer |
| geom : geometry(Geometry) [not null] |
| osm_centroid |
| id : bigint |
| osm_id : bigint |
| osm_type : enum(N,W,R) |
| osm_version : integer |
| osm_timestamp : timestamptz |
| name : text |
| label : text |
| tags : hstore |
| rank : integer |
| geom : geometry(Point) |