خريطة Trinity بصيغة 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 Trinity

68 buildings (6 residential), 95.5 km of roads, 24 points of interest, 13 landmarks.

Mostly residential streets 51.2 km, secondary roads 20.5 km, trunk roads 9.4 km.

Among the objects: fuel stations — 5, fast_food — 5, pitch — 4.

Main streets: East Caroline Street, Farm to Market Road 1617, Twin Oaks Road, Trinlady Park Road, Pinecrest Road

Landmarks: Texas Long Leaf Lumber Company, Jacob Pope And Elizabeth Ann Barnes, I. N. Parker House, Dorcas Wills Memorial Baptist Church, Charles Nesbitt Charlie Wilson

How to use PostGIS SQL for Trinity

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