Kaart van Botswana in PostGIS SQL-formaat

Over PostGIS SQL

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

Toepassingen

• PostGIS import
• backup
• geodata migration
• CI/CD pipelines

What's in the PostGIS SQL map of Botswana

105,201 buildings (3,343 residential, 437 commercial, 231 industrial, 41 religious), 69,356.3 km of roads, 6,236 points of interest, 200 landmarks.

Mostly residential streets 24,825.5 km, unclassified roads 20,993.2 km, tertiary roads 10,299.7 km.

Among the objects: swimming_pool — 1,164, pitch — 830, parking — 767.

Main streets: Sand Road, Nossob Road, Road to Mabuasehube, Mosetse Road, Molepolole Road

Landmarks: Khama III Memorial Museum, Otse Wildlife Visitor Centre, Botswana National Museum, Adrian Gale Diamond Musem, Kgosi Bathoen II Museum

How to use PostGIS SQL for Botswana

1. Select the Botswana 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