Berlin

Extracts data of Berlin from the OpenstreetMaps project for free

Main files

  • [berlin.pbf] - for osm2pgsql, Osmium, Osmosis, imposm, mkgmap, and others. This file was last modified -19 hours ago and contains all OSM data up to November 20 2024 21:13:34. File size: 66.93MB; MD5 sum: 430f32ffd22fe9b2dc669adf4b13a8f1.

Additional Files

Prepared geodata of Berlin in the SHP format

You are getting:

  • Fresh geo data from the Openstreetmap project in ESRI Shape format
  • If necessary, we can provide data in the following formats: GeoPackage, GeoJSON, CSV, TAB
  • Ready-made project for the QGIS 3 mapping program
  • Styles for all layers
  • 150+ icons

Sample of map

 

 

Berlin map layers

Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • religion — religion field value
  • amenity — amenity field value
  • landuse — landuse field value
  • leisure — leisure field value
  • sport — sport field value
  • type — type field value
  • way — Geometry
Amenity (areas)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • religion — religion field value
  • amenity — amenity field value
  • landuse — landuse field value
  • leisure — leisure field value
  • sport — sport field value
  • type — type field value
  • way — Geometry
Amenity (points)
Fields of layer:
  • osm_id — ID in OSM base
  • barrier — barrier field value
  • way — Geometry
Barriers (lines)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • admin_level - Grade of administrative level
  • way — Geometry
Boundary (areas)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • admin_level - Grade of administrative level
  • way — Geometry
Boundary (lines)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • building — building field value
  • b_level — building:levels field value
  • a_numb — addr:housenumber field value
  • way — Geometry
Building
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • building — building field value
  • b_level — building:levels field value
  • a_numb — addr:housenumber field value
  • way — Geometry
Buildings (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • natural — Natural field value
  • landuse — Landuse field value
  • wood — Wood field is not null
  • leisure — Leisure field value
  • way — Geometry
Surfaces and land use
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • leisure — leisure field value
  • way — Geometry
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • leisure — leisure field value
  • way — Geometry
Leisure (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • man_made — man_made field valu
  • tower_type — tower:type field value
  • way — Geometry
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • natural — natural field value
  • way — Geometry
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • AMENITY — AMENITY field value
  • way — Geometry
Parking (areas)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • AMENITY — AMENITY field value
  • way — Geometry
Parking (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • place — place field value
  • official_s — official_status field value
  • POPULATION — POPULATION field value
  • way — Geometry
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • place — place field value
  • official_s — official_status field value
  • POPULATION — POPULATION field value
  • is_capital — is_capital field value
  • admin_level — Administrative grade value
  • capital — capital field value
  • way — Geometry
Places (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • POWER — POWER field value
  • VOLTAGE — VOLTAGE field value
  • way — Geometry
Power lines
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • POWER — POWER field value
  • VOLTAGE — VOLTAGE field value
  • way — Geometry
Power line towers
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • RAILWAY — RAILWAY field value
  • way — Geometry
Railway platforms
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • RAILWAY — RAILWAY field value
  • traction — traction field value
  • service — service field value
  • BRIDGE — BRIDGE field value
  • TUNNEL — TUNNEL field value
  • way — Geometry
Railways
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • RAILWAY — RAILWAY field value
  • public_transport — public_transport field value
  • tram — tram field value
  • station — station field value
  • way — Geometry
Railways (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • religion — religion field value
  • way — Geometry
Religion (areas)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • religion — religion field value
  • way — Geometry
Religion (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • ref — ref field value
  • HIGHWAY — HIGHWAY field value
  • cycle — cycle field value
  • horse — horse field value
  • foot — foot field value
  • lanes — lanes field value
  • toll — toll field value
  • width — width field value
  • way — Geometry
Roads
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • HIGHWAY — HIGHWAY field value
  • railway — railway field value
  • way — Geometry
Road infrastructure
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • shop — shop field value
  • way — Geometry
Shop (areas)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • shop — shop field value
  • way — Geometry
Shops (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • sport — sport field value
  • way — Geometry
Sport (areas)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • sport — sport field value
  • way — Geometry
Sport (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • TOURISM — TOURISM field value
  • information — information field value
  • historic — historic field value
  • way — Geometry
Tourism (areas)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • TOURISM — TOURISM field value
  • information — information field value
  • historic — historic field value
  • way — Geometry
Tourism (points)
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • ROUTE — ROUTE field value
  • REF — REF field value
  • OPERATOR — OPERATOR field value
  • way — Geometry
Routes
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • WATERWAY — WATERWAY field value
  • way — Geometry
Streams and ditches
Fields of layer:
  • osm_id — ID in OSM base
  • name — Local name
  • name_en — Name in English
  • natural — Natural field value
  • landuse — Landuse field value
  • water — Water field is not null
  • waterway — Waterway field value
  • way — Geometry
Lakes, swamps and large rivers
Fields of layer:
  • id — Local ID
Coastline
Fields of layer:
  • id — Local ID
Land border
Fields of layer:
  • id — Local ID
Ocean border

Legend of map of Berlin and sample project

Statistics on objects in the Berlin

NameTypeOSM TagCount
Administrative level 4linesadmin_level = '4'172
Administrative level 6linesadmin_level = '6'20
Administrative level 8linesadmin_level = '8'51
Administrative level 9linesadmin_level = '9'383
Administrative level 10linesadmin_level = '10'616
.$row2[6].
NameTypeOSM TagCount
Administrative level 4polygonsadmin_level = '4'4
Administrative level 9polygonsadmin_level = '9'13
Administrative level 10polygonsadmin_level = '10'98
Placespolygonsplace = 'city' / place = 'town' / place = 'village' / place = 'hamlet' / place = 'locality' / place = 'suburb' / place = 'island' / place = 'farm' / place = 'isolated_dwelling'115
.$row2[6].
NameTypeOSM TagCount
Citypolygonsplace = 'city'2
Localitypolygonsplace = 'locality'13
Suburbpolygonsplace = 'suburb'98
Islandpolygonsplace = 'island'2
NameTypeOSM TagCount
Buildingpointsbuilding is not ''29
.$row2[6].
NameTypeOSM TagCount
Buildingpolygonsbuilding is not ''519729
Dominantspolygonsbuilding = 'church' / building = 'government' / building = 'cathedral' / building = 'public' / building = 'hospital' / building = 'train_station' / building = 'chapel' / building = 'college' / building = 'university'2387
Schools and kindergartenspolygonsbuilding = 'school' / building = 'kindergarten'2926
Under constructionpolygonsbuilding = 'construction'657
.$row2[6].
NameTypeOSM TagCount
bicycle parkingpointsamenity = 'bicycle_parking'13888
policepointsamenity = 'police'18
fire stationpointsamenity = 'fire_station'29
post boxpointsamenity = 'post_box'2465
post officepointsamenity = 'post_office'198
telephonepointsamenity = 'telephone'810
librarypointsamenity = 'library'103
townhallpointsamenity = 'townhall'8
courthousepointsamenity = 'courthouse'3
prisonpointsamenity = 'prison'1
embassypointsamenity = 'embassy' / office = 'diplomatic'107
community centrepointsamenity = 'community_centre'329
nursing homepointsamenity = 'nursing_home'5
arts centrepointsamenity = 'arts_centre'94
cemeterypointsamenity = 'grave_yard' / landuse = 'cemetery'7
marketplacepointsamenity = 'marketplace'78
recyclingpointsamenity = 'recycling'2465
universitypointsamenity = 'university'38
schoolpointsamenity = 'school'107
kindergartenpointsamenity = 'kindergarten'1243
collegepointsamenity = 'college'57
pharmacypointsamenity = 'pharmacy'714
hospitalpointsamenity = 'hospital'2
clinicpointsamenity = 'clinic'92
doctorspointsamenity = 'doctors'1268
dentistpointsamenity = 'dentist'654
veterinarypointsamenity = 'veterinary'156
theatrepointsamenity = 'theatre'135
nightclubpointsamenity = 'nightclub'129
cinemapointsamenity = 'cinema'70
swimming poolpointsamenity = 'swimming_pool' / leisure = 'swimming_pool' / sport = 'swimming' / leisure = 'water_park'26
restaurantpointsamenity = 'restaurant'4299
fast foodpointsamenity = 'fast_food'2213
cafepointsamenity = 'cafe'2304
pubpointsamenity = 'pub'980
bar, biergartenpointsamenity = 'bar' / amenity = 'biergarten'885
food courtpointsamenity = 'food_court'5
shelterpointsamenity = 'shelter'232
car rentalpointsamenity = 'car_rental'98
car washpointsamenity = 'car_wash'56
car sharingpointsamenity = 'car_sharing'28
bicycle rentalpointsamenity = 'bicycle_rental'521
bankpointsamenity = 'bank'337
atmpointsamenity = 'atm'989
toiletspointsamenity = 'toilets'517
benchpointsamenity = 'bench'22472
drinking waterpointsamenity = 'drinking_water'207
fuelpointsamenity = 'fuel'153
bus stationpoints/polygonsamenity = 'bus_station'1
taxipoints/polygonsamenity = 'taxi'368
ferry terminalpoints/polygonsamenity = 'ferry_terminal'60
.$row2[6].
NameTypeOSM TagCount
Christian churchespointsamenity = 'place_of_worship' + religion = 'christian'98
Synagoguepointsamenity = 'place_of_worship' + religion = 'jewish'2
Mosquepointsamenity = 'place_of_worship' + religion = 'muslim'51
Buddhist templepointsamenity = 'place_of_worship' + religion = 'buddhist'12
Hindu templepointsamenity = 'place_of_worship' + religion = 'hindu'3
.$row2[6].
NameTypeOSM TagCount
playgroundpoints/polygonsleisure = 'playground'1007
sports centrepoints/polygonsleisure = 'sports_centre'146
stadiumpoints/polygonsleisure = 'stadium'1
trackpointsleisure = 'track'3
marinapointsleisure = 'marina'127
slipwaypointsleisure = 'slipway'61
dog parkpointsleisure = 'dog_park'4
golf coursepointsleisure = 'golf_course'1
.$row2[6].
NameTypeOSM TagCount
supermarket, generalpointsshop = 'supermarket' / shop = 'general'883
bakerypointsshop = 'bakery'1311
kioskpointsshop = 'kiosk'533
mallpointsshop = 'mall'4
department storepointsshop = 'department_store'60
conveniencepointsshop = 'convenience'913
clothespointsshop = 'clothes'1526
floristpointsshop = 'florist'597
chemistpointsshop = 'chemist'235
bookspointsshop = 'books'310
butcherpointsshop = 'butcher'122
shoespointsshop = 'shoes'278
alcohol, beveragespointsshop = 'alcohol' / shop = 'beverages'279
opticianpointsshop = 'optician'339
jewelrypointsshop = 'jewelry'338
giftpointsshop = 'gift'130
sportspointsshop = 'sports'101
stationerypointsshop = 'stationery'168
outdoorpointsshop = 'outdoor'25
mobile phonepointsshop = 'mobile_phone'291
toyspointsshop = 'toys'116
newsagentpointsshop = 'newsagent'104
greengrocerpointsshop = 'greengrocer'85
beautypointsshop = 'beauty'794
videopointsshop = 'video'21
carpointsshop = 'car'168
bicyclepointsshop = 'bicycle'372
doityourself, hardwarpointsshop = 'doityourself' / shop = 'hardware'98
furniturepointsshop = 'furniture'220
computerpointsshop = 'computer'92
garden centrepointsshop = 'garden_centre'22
hairdresserpointsshop = 'hairdresser'1815
car repairpointsshop = 'car_repair'332
.$row2[6].
NameTypeOSM TagCount
Bowlingpointssport = '10pin' / sport = 'bowling'12
athleticspointssport = 'athletics'4
basketballpointssport = 'basketball'50
canoepointssport = 'canoe'3
chesspointssport = 'chess'22
cyclingpointssport = 'cycling'3
fitnesspointssport = 'fitness'170
gymnasticspointssport = 'gymnastics'17
hockeypointssport = 'hockey'1
shootingpointssport = 'shooting'2
skatingpointssport = 'skating'1
skiingpointssport = 'skiing'1
soccerpointssport = 'soccer'22
swimmingpointssport = 'swimming'19
table tennispointssport = 'table_tennis'1354
tennispointssport = 'tennis'6
horse racingpointssport = 'horse_racing'1
.$row2[6].
NameTypeOSM TagCount
artworkpoints/polygonstourism = 'artwork'1664
attractionpoints/polygonstourism = 'attraction'64
camp sitepoints/polygonstourism = 'camp_site'2
caravan sitepoints/polygonstourism = 'caravan_site'3
guest housepoints/polygonstourism = 'guest_house'106
hostelpoints/polygonstourism = 'hostel'84
hotelpointstourism = 'hotel'464
informationpoints/polygonstourism = 'information'3335
motelpoints/polygonstourism = 'motel'5
museumpoints/polygonstourism = 'museum'134
picnic sitepointstourism = 'picnic_site'91
theme parkpoints/polygonstourism = 'theme_park'1
viewpointpointstourism = 'viewpoint'196
zoopoints/polygonstourism = 'zoo'4
chaletpoints/polygonstourism = 'chalet'4
yespointstourism = 'yes'2
mappointsinformation = 'map'324
boardpointsinformation = 'board'1159
guidepostpointsinformation = 'guidepost'1640
monumentpointshistoric = 'monument'18
memorialpointshistoric = 'memorial'2613
apartmentpointstourism = 'apartment'43
gallerypointstourism = 'gallery'233
.$row2[6].
NameTypeOSM TagCount
Coastlineslines1
Water surfacepolygons1
Land boundariespolygons1
.$row2[6].
NameTypeOSM TagCount
Lakes and large riverspolygonsnatural = 'water' / waterway = 'riverbank'1530
Wetlandpolygonsnatural = 'wetland'423
water' and water notpolygonsnatural = 'water' + water is not 'river' + water is not 'reservoir'718
.$row2[6].
NameTypeOSM TagCount
Canallineswaterway = 'canal'159
Drainlineswaterway = 'drain'1026
Riverlineswaterway = 'river'108
Streamlineswaterway = 'stream'976
Otherslineswaterway is not ''3300
.$row2[6].
NameTypeOSM TagCount
Fencelinesbarrier = 'fence'20941
Walllinesbarrier = 'wall'5534
.$row2[6].
NameTypeOSM TagCount
Towerpointsman_made = 'tower'59
Cell towerpointsman_made = 'tower' + tower:type = 'communication'22
Water towerpointsman_made = 'water_tower'3
Lookout towerpointsman_made = 'tower' + tower:type = 'observation'6
Water wellpointsman_made = 'water_well'2004
Watermillpointsman_made = 'watermill'1
NameTypeOSM TagCount
Power lineslinespower is not ''589
.$row2[6].
NameTypeOSM TagCount
Towers Power linespointspower is not ''2719
.$row2[6].
NameTypeOSM TagCount
Springpointsnatural = 'spring'9
Peakpointsnatural = 'peak'72
Treepointsnatural = 'tree'203329
NameTypeOSM TagCount
Citypointsplace = 'city'1
Townpointsplace = 'town'2
Villagepointsplace = 'village'4
Hamletpointsplace = 'hamlet'20
Hamletpointsplace = 'locality'52
The capitalpointsplace = 'city' + is_capital = 'country' / admin_level = '2' / capital = 'yes' + 'admin_level' is null1
.$row2[6].
NameTypeOSM TagCount
Allotmentspolygonslanduse = 'allotments'1327
Basinpolygonslanduse = 'basin'81
Brownfieldpolygonslanduse = 'brownfield'256
Cemeterypolygonslanduse = 'cemetery'239
Commercialpolygonslanduse = 'commercial'1647
Constructionpolygonslanduse = 'construction'1111
Farm, farmlandpolygonslanduse = 'farm' / landuse = 'farmland'164
Farmyardpolygonslanduse = 'farmyard'60
Forestpolygonslanduse = 'forest' / landuse = 'natural'904
Garagespolygonslanduse = 'garages'74
Grasspolygonslanduse = 'grass'14683
Greenfieldpolygonslanduse = 'greenfield'94
Industrialpolygonslanduse = 'industrial'639
Landfillpolygonslanduse = 'landfill'16
Meadowpolygonslanduse = 'meadow'644
Quarrypolygonslanduse = 'quarry'1
Railwaypolygonslanduse = 'railway'350
Recreation groundpolygonslanduse = 'recreation_ground'145
Reservoirpolygonslanduse = 'reservoir'9
Residentialpolygonslanduse = 'residential'9113
Retailpolygonslanduse = 'retail'1025
Village greenpolygonslanduse = 'village_green'123
Vineyardpolygonslanduse = 'vineyard'8
Plant nurserypolygonslanduse = 'plant_nursery'26
Educationpolygonslanduse = 'education'14
Parkpolygonsleisure = 'park'2553
Beachpolygonsnatural = 'beach'121
Fellpolygonsnatural = 'fell'3
Grasslandpolygonsnatural = 'grassland'792
Heathpolygonsnatural = 'heath'31
Sandpolygonsnatural = 'sand'466
Scrubpolygonsnatural = 'scrub'5367
.$row2[6].
NameTypeOSM TagCount
Amenitypolygonsamenity is not ''32799
.$row2[6].
NameTypeOSM TagCount
Leisurepolygonsleisure is not ''14740
.$row2[6].
NameTypeOSM TagCount
Place of worshippolygonsamenity = 'place_of_worship'579
Place of worshippolygonsamenity = 'place_of_worship'579
.$row2[6].
NameTypeOSM TagCount
Shoppolygonsshop is not ''1910
.$row2[6].
NameTypeOSM TagCount
Sportpolygonssport is not ''4560
.$row2[6].
NameTypeOSM TagCount
Tourismpolygonstourism is not ''758
.$row2[6].
NameTypeOSM TagCount
parkingpolygonsamenity = 'parking'19598
.$row2[6].
NameTypeOSM TagCount
bus, tram, trolleybuslinesroute = 'bus' / route = 'trolleybus' / route = 'tram' / route = 'share_taxi'15101
subwaylinesroute = 'subway'394
trainlinesroute = 'train'120
ferrylinesroute = 'ferry'41
.$row2[6].
NameTypeOSM TagCount
Platformpolygonsrailway = 'platform'553
.$row2[6].
NameTypeOSM TagCount
Abandonedlinesrailway = 'abandoned'876
Constructionlinesrailway = 'construction'69
Light raillinesrailway = 'light_rail'2727
Narrow gaugelinesrailway = 'narrow_gauge'34
Platformlinesrailway = 'platform'747
Railwaylinesrailway = 'rail' + service is null2003
Service railwaylinesrailway = 'rail' + service is not null1910
Subwaylinesrailway = 'subway'1253
tramlinesrailway = 'tram'2009
miniaturelinesrailway = 'miniature'35
.$row2[6].
NameTypeOSM TagCount
Trunklineshighway = 'trunk' / highway = 'trunk_link'82
Primarylineshighway = 'primary' / highway = 'primary_link'3883
Secondarylineshighway = 'secondary' / highway = 'secondary_link'10150
Tertiarylineshighway = 'tertiary' / highway = 'tertiary_link'5835
Unclassifiedlineshighway = 'unclassified'959
Residentiallineshighway = 'residential'26272
Servicelineshighway = 'service'82137
Footwaylineshighway = 'footway' / highway = 'path' + foot = 'designated'124958
Constructionlineshighway = 'construction'376
Roadlineshighway = 'road'2
Cyclewaylineshighway = 'cycleway' / highway = 'path' + cycle = 'designated'2945
Living streetlineshighway = 'living_street'2110
Pedestrianlineshighway = 'pedestrian'419
Stepslineshighway = 'steps'9046
Tracklineshighway = 'track'5474
Bridlewaylineshighway = 'bridleway' / highway = 'path' + horse = 'designated'185
Racewaylineshighway = 'raceway'9
.$row2[6].
NameTypeOSM TagCount
Crossingpointshighway = 'crossing' / railway = 'level_crossing'27130
Traffic signalspointshighway = 'traffic_signals'7552
Mini roundaboutpointshighway = 'mini_roundabout'5
Stoppointshighway = 'stop'413
Speed camerapointshighway = 'speed_camera'53
Street lamppointshighway = 'street_lamp'63285
Bus stoppointshighway = 'bus_stop'6345
.$row2[6].
NameTypeOSM TagCount
NameTypeOSM TagCount
squarepolygonsplace = 'square'294
.$row2[6].
NameTypeOSM TagCount
Stationpointsrailway = 'station'285
Haltpointsrailway = 'halt'65
Tram stoppointsrailway = 'tram_stop' / public_transport = 'stop_position' + tram = 'yes'884
Subway entrancepointsrailway = 'subway_entrance'641
.$row2[6].

 

 

© Copyright 2023 Data/Maps OSM Today and OpenStreetMap Contributors | Map tiles by CartoDB, under CC BY 3.0. Data by OpenStreetMap, under ODbL.