Map of Bermuda in PostGIS SQL format

A map built from OpenStreetMap data, ready to download

Map of Bermuda in PostGIS SQL format

Customize the map

Open this place's area in the constructor and adjust everything to your needs

Open in constructor →

Map passport

Area2 996 km²
Buildings12 552
Roads725 km
Points of interest3 362

What this map contains by default

This is how the map is built as-is — every setting can be changed in the constructor.

FormatPostGIS SQL .sql
LayersRoads, Buildings, Water, Greenery, Points of interest change
Stylestandard change
Detailauto change
House numbersall change
Points of interestall categories change
Coordinate systemWGS 84 (auto) change
Sheet sizeauto change
Relief & gridoff change

Interactive map of the area

About PostGIS SQL

Map of Bermuda in PostGIS SQL — an export of real OpenStreetMap data for the selected area.

PostGIS SQL is a geodata dump as an SQL script for PostgreSQL/PostGIS. CREATE TABLE + INSERT with geometry for direct database import.

Which layers are in the file

This file for the selected area contains:

Coordinate systems

WGS 84 (EPSG:4326), selectable in the wizard

Compatibility

PostgreSQL/PostGISpsqlpgAdminDBeaverDataGrip

Units

Meters (projected in the chosen coordinate system)

CategoryGIS
File extension.sql
TierFree

What's in the PostGIS SQL map of Bermuda

12,552 buildings (515 residential, 98 commercial, 16 industrial, 95 religious), 724.6 km of roads, 3,362 points of interest, 50 landmarks.

The area covers 2,996 km², with about 4 buildings per km².

Mostly residential streets 314.1 km, service roads 203.9 km, unclassified roads 63.7 km.

0.5% of the area is green space.

The map marks 69 parks and 22 water bodies.

Key amenities: schools — 36, supermarkets — 22, hotels — 33.

Public transport: 607 bus stops.

Main streets: Middle Road, South Road, North Shore Road, South Road, Harbour Road

Landmarks: Carter House, St. George's Historical Society Museum, Printery & Garden, Tucker House Museum, Bermuda National Trust Museum, Commisioner's House

How to use PostGIS SQL for Bermuda

  1. Select the Bermuda map area on the main page
  2. Choose PostGIS SQL format and configure export settings
  3. Click Export and wait for processing
  4. Download the file and use in your application

Programs that open PostGIS SQL

PostgreSQL/PostGISpsqlpgAdminDBeaverDataGrip

Other formats for Bermuda

All 126 formats for Bermuda →
All formats for Bermuda