Map of Диффа in PostGIS SQL format
Преузмите карту Диффа у PostGIS SQL формату. OpenStreetMap подаци.
Генерисање карте
Map passport
Area145 777 km²
Buildings73 046
Roads12 954 km
Points of interest355
ProjectionWGS-84 (EPSG:4326)
LicenseODbL
Data sourceOpenStreetMap
О формату PostGIS SQL
PostGIS SQL is a geodata dump as an SQL script for PostgreSQL/PostGIS. CREATE TABLE + INSERT with geometry for direct database import.
Примене
- PostGIS import
- backup
- geodata migration
- CI/CD pipelines
| Категорија | GIS |
| Екстензија фајла | .sql |
| Ниво | Free |
What's in the PostGIS SQL map of Диффа
73,046 buildings (1,016 residential, 2 commercial, 1 industrial, 1 religious), 12,953.7 km of roads, 355 points of interest, 10 landmarks.
Mostly unclassified roads 11,378.8 km, residential streets 978.5 km, trunk roads 366.7 km.
1.4% of the area is green space.
Among the objects: fountain — 96, schools — 91, clinic — 31.
Main streets: Route Nationale 41
Landmarks: Kazelmarie , Tribune officielle, Tribune, Ancienne mairie Ngourti, Tribune officielle
How to use PostGIS SQL for Диффа
- Select the Диффа map area on the main page
- Choose PostGIS SQL format and configure export settings
- Click Export and wait for processing
- Download the file and use in your application
Programs that open PostGIS SQL
PostgreSQL/PostGISpsqlpgAdminDBeaverDataGrip