خريطة Saint Patrick بصيغة PostGIS SQL

حول 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

What's in the PostGIS SQL map of Saint Patrick

5,523 buildings (187 residential, 1 commercial, 1 religious), 147.6 km of roads, 16 points of interest, 4 landmarks.

Mostly residential streets 79.3 km, tertiary roads 22.2 km, service roads 20.5 km.

34.7% of the area is green space.

Among the objects: viewpoint — 3, attraction — 2, guest_house — 2.

Main streets: Western Road, Prospect Road, Paradise - La Taste Road, Hermitage Road, River Sallee - Levera Road

Landmarks: Mt. Rich Petroglyphs, River Antoine Rum Distillery, Welcome Rock, Leapers Hill

How to use PostGIS SQL for Saint Patrick

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