Talk:Istanbul

Status

Below are the queries for the status statistics. Data was downloaded from Mapzen Metro Extracts and imported with osm2pgsql.

POIs

Places of Worship

select count(*) from planet_osm_point where amenity = 'place_of_worship' OR building in ('cathedral', 'chapel', 'mosque', 'temple')

select count(*) from planet_osm_polygon where amenity = 'place_of_worship' OR building in ('cathedral', 'chapel', 'mosque', 'temple')

Education

select count(*) from planet_osm_point where amenity = 'university' OR building = 'university' OR amenity = 'college' OR building = 'college '

select count(*) from planet_osm_polygon where amenity = 'university' OR building = 'university' OR amenity = 'college' OR building = 'college '

select count(*) from planet_osm_point where amenity = 'school' OR building = 'school'

select count(*) from planet_osm_polygon where amenity = 'school' OR building = 'school'

Health

select count(*) from planet_osm_point where amenity = 'hospital' OR building = 'hospital'

select count(*) from planet_osm_polygon where amenity = 'hospital' OR building = 'hospital'

select count(*) from planet_osm_point where amenity = 'pharmacy' OR building = 'pharmacy'

select count(*) from planet_osm_polygon where amenity = 'pharmacy' OR building = 'pharmacy'

Tourism

select count(*) from planet_osm_point where tourism in ('alpine_hut','apartment','chalet','guest_house','hostel','hotel','motel')

select count(*) from planet_osm_polygon where tourism in ('alpine_hut','apartment','chalet','guest_house','hostel','hotel','motel')

Public Transport

Stations

CREATE TABLE stations AS SELECT osm_id, name, operator, highway, public_transport, railway, amenity, way FROM planet_osm_point WHERE "public_transport" IN ('platform','stop_position', 'station','stop_area','halt','tram_stop','subway_entrance','bus_stop','bus_station') OR "highway" IN ('platform','stop_position', 'station','stop_area','halt','tram_stop','subway_entrance','bus_stop','bus_station') OR "railway" IN ('platform','stop_position', 'station','stop_area','halt','tram_stop','subway_entrance','bus_stop','bus_station') OR "amenity" IN ('platform','stop_position', 'station','stop_area','halt','tram_stop','subway_entrance','bus_stop','bus_station')

select public_transport, count(*) from stations group by public_transport

select highway, count(*) from stations group by highway

select railway, count(*) from stations group by railway

select amenity, count(*) from stations group by amenity