Map of Occitania in PostGIS SQL format

A map built from OpenStreetMap data, ready to download

Customize the map

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

Open in constructor →

Map passport

Area73 367 km²
Buildings5 792 128
Roads186 764 km
Points of interest150 938

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
Detailoverview (auto) change
House numbersnot visible at this scale change
Points of interestnot visible at this scale change
Coordinate systemWGS 84 (auto) change
Sheet sizeauto change
Relief & gridoff change

About PostGIS SQL

Map of Occitania 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 Occitania

5,792,128 buildings (131,266 residential, 8,688 commercial, 3,302 industrial, 6,916 religious), 186,764.0 km of roads, 150,938 points of interest, 15 landmarks.

The area covers 73,367 km², with about 79 buildings per km².

Mostly unclassified roads 56,829.7 km, service roads 40,025.4 km, tertiary roads 32,883.7 km.

The map marks 5 parks and 10 water bodies.

Key amenities: bakeries — 2,583, town halls — 2,353, restaurants — 8,581.

Public transport: 21,977 bus stops, 880 tram stops, 99 metro stations, 319 rail stations.

Main streets: Route de Toulouse, Route de Toulouse, Route des Pyrénées, Route des Pyrénées, Rue de l'Église

Landmarks: Maison de la Céramique Contemporaine, Musée du Château Le Cayla, Musée Art du Chocolat, Centre historique Jean Duvernoy, Musée d'Histoire Naturelle Philadelphe Thomas

How to use PostGIS SQL for Occitania

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

All 126 formats for Occitania →

PostGIS SQL for nearby places

All formats for Occitania