Map of Devonshire in PostGIS SQL format
Download Devonshire map in PostGIS SQL format. OpenStreetMap data, instant generation.
Map generation
Map passport
Area4.9 km²
Buildings2 088
Roads84 km
Points of interest10
ProjectionWGS-84 (EPSG:4326)
LicenseODbL
Data sourceOpenStreetMap
About PostGIS SQL
PostGIS SQL is a geodata dump as an SQL script for PostgreSQL/PostGIS. CREATE TABLE + INSERT with geometry for direct database import.
Use cases
- PostGIS import
- backup
- geodata migration
- CI/CD pipelines
| Category | GIS |
| File extension | .sql |
| Tier | Free |
What's in the PostGIS SQL map of Devonshire
2,088 buildings (25 residential, 2 commercial, 1 industrial, 8 religious), 84.1 km of roads, 10 points of interest.
Mostly residential streets 27.6 km, service roads 23.0 km, primary roads 14.2 km.
21.8% of the area is green space.
Among the objects: parking — 3, post_box — 2, pet — 1.
Main streets: Middle Road, North Shore Road, South Road, North Shore Road, Palmetto Road
How to use PostGIS SQL for Devonshire
- Select the Devonshire 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