Berne

Extracts data of Berne from the OpenstreetMaps project for free

Main files

  • [bern.pbf] - for osm2pgsql, Osmium, Osmosis, imposm, mkgmap, and others. This file was last modified -15 hours ago and contains all OSM data up to March 28 2024 16:18:46. File size: 63.38MB; MD5 sum: e0d896e04207c299538d178aae4b8cb5.

Additional Files

Prepared geodata of Berne 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

 

 

Berne 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
  • way — Geometry
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 Berne and sample project

Statistics on objects in the Berne

NameTypeOSM TagCount
Countrieslinesadmin_level = '2'5
Administrative level 3linesadmin_level = '3'1
Administrative level 4linesadmin_level = '4'361
Administrative level 5linesadmin_level = '5'156
Administrative level 6linesadmin_level = '6'198
Administrative level 8linesadmin_level = '8'1807
Administrative level 9linesadmin_level = '9'126
Administrative level 10linesadmin_level = '10'127
.$row2[6].
NameTypeOSM TagCount
Administrative level 4polygonsadmin_level = '4'2
Administrative level 5polygonsadmin_level = '5'6
Administrative level 6polygonsadmin_level = '6'12
Administrative level 8polygonsadmin_level = '8'411
Administrative level 9polygonsadmin_level = '9'27
Administrative level 10polygonsadmin_level = '10'63
Placespolygonsplace = 'city' / place = 'town' / place = 'village' / place = 'hamlet' / place = 'locality' / place = 'suburb' / place = 'island' / place = 'farm' / place = 'isolated_dwelling'108
.$row2[6].
NameTypeOSM TagCount
Villagepolygonsplace = 'village'15
Hamletpolygonsplace = 'hamlet'16
Localitypolygonsplace = 'locality'12
Islandpolygonsplace = 'island'7
Farmpolygonsplace = 'farm'51
Isolated dwellingpolygonsplace = 'isolated_dwelling'7
Region or countrypolygonsplace = 'region' / place = 'county'1
NameTypeOSM TagCount
Buildingpointsbuilding is not ''2188
.$row2[6].
NameTypeOSM TagCount
Buildingpolygonsbuilding is not ''481367
Dominantspolygonsbuilding = 'church' / building = 'government' / building = 'cathedral' / building = 'public' / building = 'hospital' / building = 'train_station' / building = 'chapel' / building = 'college' / building = 'university'986
Schools and kindergartenspolygonsbuilding = 'school' / building = 'kindergarten'1458
Under constructionpolygonsbuilding = 'construction'101
.$row2[6].
NameTypeOSM TagCount
bicycle parkingpointsamenity = 'bicycle_parking'858
policepointsamenity = 'police'55
fire stationpointsamenity = 'fire_station'136
post boxpointsamenity = 'post_box'1426
post officepointsamenity = 'post_office'206
telephonepointsamenity = 'telephone'75
librarypointsamenity = 'library'120
townhallpointsamenity = 'townhall'92
courthousepointsamenity = 'courthouse'1
embassypointsamenity = 'embassy' / office = 'diplomatic'56
community centrepointsamenity = 'community_centre'49
nursing homepointsamenity = 'nursing_home'13
arts centrepointsamenity = 'arts_centre'18
cemeterypointsamenity = 'grave_yard' / landuse = 'cemetery'1
marketplacepointsamenity = 'marketplace'9
recyclingpointsamenity = 'recycling'637
universitypointsamenity = 'university'50
schoolpointsamenity = 'school'196
kindergartenpointsamenity = 'kindergarten'192
collegepointsamenity = 'college'17
pharmacypointsamenity = 'pharmacy'170
hospitalpointsamenity = 'hospital'3
clinicpointsamenity = 'clinic'30
doctorspointsamenity = 'doctors'151
dentistpointsamenity = 'dentist'82
veterinarypointsamenity = 'veterinary'53
theatrepointsamenity = 'theatre'46
nightclubpointsamenity = 'nightclub'40
cinemapointsamenity = 'cinema'48
swimming poolpointsamenity = 'swimming_pool' / leisure = 'swimming_pool' / sport = 'swimming' / leisure = 'water_park'50
restaurantpointsamenity = 'restaurant'1980
fast foodpointsamenity = 'fast_food'325
cafepointsamenity = 'cafe'387
pubpointsamenity = 'pub'93
bar, biergartenpointsamenity = 'bar' / amenity = 'biergarten'230
food courtpointsamenity = 'food_court'4
shelterpointsamenity = 'shelter'148
car rentalpointsamenity = 'car_rental'15
car washpointsamenity = 'car_wash'82
car sharingpointsamenity = 'car_sharing'240
bicycle rentalpointsamenity = 'bicycle_rental'286
bankpointsamenity = 'bank'299
atmpointsamenity = 'atm'376
toiletspointsamenity = 'toilets'766
benchpointsamenity = 'bench'9858
drinking waterpointsamenity = 'drinking_water'1247
fuelpointsamenity = 'fuel'481
bus stationpoints/polygonsamenity = 'bus_station'11
taxipoints/polygonsamenity = 'taxi'13
ferry terminalpoints/polygonsamenity = 'ferry_terminal'60
.$row2[6].
NameTypeOSM TagCount
Christian churchespointsamenity = 'place_of_worship' + religion = 'christian'86
Mosquepointsamenity = 'place_of_worship' + religion = 'muslim'7
Buddhist templepointsamenity = 'place_of_worship' + religion = 'buddhist'2
Hindu templepointsamenity = 'place_of_worship' + religion = 'hindu'1
.$row2[6].
NameTypeOSM TagCount
playgroundpoints/polygonsleisure = 'playground'498
sports centrepoints/polygonsleisure = 'sports_centre'131
stadiumpoints/polygonsleisure = 'stadium'1
trackpointsleisure = 'track'1
ice rinkpoints/polygonsleisure = 'ice_rink'4
marinapointsleisure = 'marina'19
slipwaypointsleisure = 'slipway'46
.$row2[6].
NameTypeOSM TagCount
supermarket, generalpointsshop = 'supermarket' / shop = 'general'498
bakerypointsshop = 'bakery'283
kioskpointsshop = 'kiosk'152
mallpointsshop = 'mall'2
department storepointsshop = 'department_store'19
conveniencepointsshop = 'convenience'392
clothespointsshop = 'clothes'395
floristpointsshop = 'florist'149
chemistpointsshop = 'chemist'49
bookspointsshop = 'books'52
butcherpointsshop = 'butcher'115
shoespointsshop = 'shoes'97
alcohol, beveragespointsshop = 'alcohol' / shop = 'beverages'49
opticianpointsshop = 'optician'109
jewelrypointsshop = 'jewelry'96
giftpointsshop = 'gift'61
sportspointsshop = 'sports'105
stationerypointsshop = 'stationery'37
outdoorpointsshop = 'outdoor'24
mobile phonepointsshop = 'mobile_phone'37
toyspointsshop = 'toys'30
newsagentpointsshop = 'newsagent'39
greengrocerpointsshop = 'greengrocer'20
beautypointsshop = 'beauty'89
videopointsshop = 'video'5
carpointsshop = 'car'131
bicyclepointsshop = 'bicycle'198
doityourself, hardwarpointsshop = 'doityourself' / shop = 'hardware'77
furniturepointsshop = 'furniture'85
computerpointsshop = 'computer'25
garden centrepointsshop = 'garden_centre'17
hairdresserpointsshop = 'hairdresser'588
car repairpointsshop = 'car_repair'178
.$row2[6].
NameTypeOSM TagCount
Bowlingpointssport = '10pin' / sport = 'bowling'3
athleticspointssport = 'athletics'3
canoepointssport = 'canoe'2
chesspointssport = 'chess'16
fitnesspointssport = 'fitness'233
gymnasticspointssport = 'gymnastics'7
hockeypointssport = 'hockey'1
motorpointssport = 'motor'1
shootingpointssport = 'shooting'18
skiingpointssport = 'skiing'2
soccerpointssport = 'soccer'11
swimmingpointssport = 'swimming'44
table tennispointssport = 'table_tennis'984
tennispointssport = 'tennis'13
.$row2[6].
NameTypeOSM TagCount
artworkpoints/polygonstourism = 'artwork'240
attractionpoints/polygonstourism = 'attraction'129
camp sitepoints/polygonstourism = 'camp_site'14
caravan sitepoints/polygonstourism = 'caravan_site'31
guest housepoints/polygonstourism = 'guest_house'115
hostelpoints/polygonstourism = 'hostel'36
hotelpointstourism = 'hotel'398
informationpoints/polygonstourism = 'information'6212
motelpoints/polygonstourism = 'motel'3
museumpoints/polygonstourism = 'museum'79
picnic sitepointstourism = 'picnic_site'616
theme parkpoints/polygonstourism = 'theme_park'1
viewpointpointstourism = 'viewpoint'593
zoopoints/polygonstourism = 'zoo'3
chaletpoints/polygonstourism = 'chalet'29
yespointstourism = 'yes'14
alpine hutpointstourism = 'alpine_hut'53
mappointsinformation = 'map'213
boardpointsinformation = 'board'683
guidepostpointsinformation = 'guidepost'5136
monumentpointshistoric = 'monument'18
memorialpointshistoric = 'memorial'155
apartmentpointstourism = 'apartment'16
camp pitchpointstourism = 'camp_pitch'29
gallerypointstourism = 'gallery'17
wilderness hutpointstourism = 'wilderness_hut'7
.$row2[6].
NameTypeOSM TagCount
Coastlineslines1
Water surfacepolygons1
Land boundariespolygons1
.$row2[6].
NameTypeOSM TagCount
Lakes and large riverspolygonsnatural = 'water' / waterway = 'riverbank'3329
Wetlandpolygonsnatural = 'wetland'544
water' and water notpolygonsnatural = 'water' + water is not 'river' + water is not 'reservoir'1564
.$row2[6].
NameTypeOSM TagCount
Canallineswaterway = 'canal'180
Drainlineswaterway = 'drain'697
Riverlineswaterway = 'river'322
Streamlineswaterway = 'stream'21466
Otherslineswaterway is not ''24232
.$row2[6].
NameTypeOSM TagCount
Fencelinesbarrier = 'fence'2516
Walllinesbarrier = 'wall'2428
.$row2[6].
NameTypeOSM TagCount
Towerpointsman_made = 'tower'189
Cell towerpointsman_made = 'tower' + tower:type = 'communication'97
Water towerpointsman_made = 'water_tower'3
Lookout towerpointsman_made = 'tower' + tower:type = 'observation'10
Lighthousepointsman_made = 'lighthouse'1
Water wellpointsman_made = 'water_well'171
Watermillpointsman_made = 'watermill'8
NameTypeOSM TagCount
Power lineslinespower is not ''1484
.$row2[6].
NameTypeOSM TagCount
Towers Power linespointspower is not ''25577
.$row2[6].
NameTypeOSM TagCount
Springpointsnatural = 'spring'64
Peakpointsnatural = 'peak'1213
Treepointsnatural = 'tree'92342
Cave entrancepointsnatural = 'cave_entrance'92
NameTypeOSM TagCount
Citypointsplace = 'city'1
Townpointsplace = 'town'19
Villagepointsplace = 'village'605
Hamletpointsplace = 'hamlet'1495
Hamletpointsplace = 'locality'2111
The capitalpointsplace = 'city' + is_capital = 'country' / admin_level = '2' / capital = 'yes' + 'admin_level' is null1
.$row2[6].
NameTypeOSM TagCount
Allotmentspolygonslanduse = 'allotments'233
Basinpolygonslanduse = 'basin'232
Brownfieldpolygonslanduse = 'brownfield'6
Cemeterypolygonslanduse = 'cemetery'293
Commercialpolygonslanduse = 'commercial'202
Constructionpolygonslanduse = 'construction'118
Farm, farmlandpolygonslanduse = 'farm' / landuse = 'farmland'3796
Farmyardpolygonslanduse = 'farmyard'4170
Forestpolygonslanduse = 'forest' / landuse = 'natural'16007
Garagespolygonslanduse = 'garages'13
Grasspolygonslanduse = 'grass'2560
Greenfieldpolygonslanduse = 'greenfield'7
Industrialpolygonslanduse = 'industrial'937
Landfillpolygonslanduse = 'landfill'20
Meadowpolygonslanduse = 'meadow'4771
Quarrypolygonslanduse = 'quarry'165
Railwaypolygonslanduse = 'railway'734
Recreation groundpolygonslanduse = 'recreation_ground'120
Reservoirpolygonslanduse = 'reservoir'93
Residentialpolygonslanduse = 'residential'3459
Retailpolygonslanduse = 'retail'83
Village greenpolygonslanduse = 'village_green'37
Vineyardpolygonslanduse = 'vineyard'207
Plant nurserypolygonslanduse = 'plant_nursery'95
Educationpolygonslanduse = 'education'8
Parkpolygonsleisure = 'park'306
Beachpolygonsnatural = 'beach'39
Fellpolygonsnatural = 'fell'85
Grasslandpolygonsnatural = 'grassland'2099
Heathpolygonsnatural = 'heath'12
Sandpolygonsnatural = 'sand'357
Scrubpolygonsnatural = 'scrub'5562
.$row2[6].
NameTypeOSM TagCount
Amenitypolygonsamenity is not ''11481
.$row2[6].
NameTypeOSM TagCount
Leisurepolygonsleisure is not ''7572
.$row2[6].
NameTypeOSM TagCount
Place of worshippolygonsamenity = 'place_of_worship'536
Place of worshippolygonsamenity = 'place_of_worship'536
.$row2[6].
NameTypeOSM TagCount
Shoppolygonsshop is not ''659
.$row2[6].
NameTypeOSM TagCount
Sportpolygonssport is not ''3009
.$row2[6].
NameTypeOSM TagCount
Tourismpolygonstourism is not ''1183
.$row2[6].
NameTypeOSM TagCount
parkingpolygonsamenity = 'parking'6189
.$row2[6].
NameTypeOSM TagCount
bus, tram, trolleybuslinesroute = 'bus' / route = 'trolleybus' / route = 'tram' / route = 'share_taxi'6119
trainlinesroute = 'train'519
ferrylinesroute = 'ferry'201
.$row2[6].
NameTypeOSM TagCount
Platformpolygonsrailway = 'platform'592
.$row2[6].
NameTypeOSM TagCount
Abandonedlinesrailway = 'abandoned'287
Constructionlinesrailway = 'construction'13
Narrow gaugelinesrailway = 'narrow_gauge'1749
Platformlinesrailway = 'platform'94
Railwaylinesrailway = 'rail' + service is null2758
Service railwaylinesrailway = 'rail' + service is not null3062
tramlinesrailway = 'tram'399
miniaturelinesrailway = 'miniature'73
funicularlinesrailway = 'funicular' / railway = 'rail' + traction = 'funicular'145
.$row2[6].
NameTypeOSM TagCount
Trunklineshighway = 'trunk' / highway = 'trunk_link'701
Primarylineshighway = 'primary' / highway = 'primary_link'3926
Secondarylineshighway = 'secondary' / highway = 'secondary_link'5050
Tertiarylineshighway = 'tertiary' / highway = 'tertiary_link'5989
Unclassifiedlineshighway = 'unclassified'14168
Residentiallineshighway = 'residential'27263
Servicelineshighway = 'service'48357
Footwaylineshighway = 'footway' / highway = 'path' + foot = 'designated'31977
Constructionlineshighway = 'construction'13
Roadlineshighway = 'road'6
Cyclewaylineshighway = 'cycleway' / highway = 'path' + cycle = 'designated'982
Living streetlineshighway = 'living_street'886
Pedestrianlineshighway = 'pedestrian'262
Stepslineshighway = 'steps'6190
Tracklineshighway = 'track'68680
Bridlewaylineshighway = 'bridleway' / highway = 'path' + horse = 'designated'65
Racewaylineshighway = 'raceway'40
.$row2[6].
NameTypeOSM TagCount
Crossingpointshighway = 'crossing' / railway = 'level_crossing'11073
Traffic signalspointshighway = 'traffic_signals'528
Mini roundaboutpointshighway = 'mini_roundabout'34
Stoppointshighway = 'stop'375
Speed camerapointshighway = 'speed_camera'61
Street lamppointshighway = 'street_lamp'4007
Bus stoppointshighway = 'bus_stop'4756
.$row2[6].
NameTypeOSM TagCount
servicespolygonshighway = 'services'2
NameTypeOSM TagCount
squarepolygonsplace = 'square'67
.$row2[6].
NameTypeOSM TagCount
Stationpointsrailway = 'station'235
Haltpointsrailway = 'halt'136
Tram stoppointsrailway = 'tram_stop' / public_transport = 'stop_position' + tram = 'yes'144
Subway entrancepointsrailway = 'subway_entrance'2
.$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.