Map of Philippines in PostGIS SQL format

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

What's in the PostGIS SQL map of Philippines

1,092,243 buildings (100,604 residential, 16,439 commercial, 11,218 industrial, 5,560 religious), 361,080.6 km of roads, 253,957 points of interest, 200 landmarks.

Mostly residential streets 139,075.1 km, unclassified roads 90,971.7 km, tertiary roads 54,538.5 km.

Among the objects: schools — 50,192, convenience — 24,967, pitch — 18,943.

Main streets: Puerto Princesa North Road, Mindoro West Coastal Road, Catanduanes Circumferential Road, Zambales Highway, Puerto Princesa South Road

Landmarks: Pope John Paul II Tower, Old Casa Real de Patnongon, Museo ng Bangko Sentral ng Pilipinas, Vintage Glasses Museum, Museo ng Santa Rosa

How to use PostGIS SQL for Philippines

1. 1Select the Philippines map area on the main page
2. 2Choose PostGIS SQL format and configure export settings
3. 3Click Export and wait for processing
4. 4Download the file and use in your application

Programs that open PostGIS SQL