Geo DB Importer
OSM search-object pipeline

Import OSM search objects

Select source files and load typed, searchable OSM polygons into PostgreSQL.

Database objects1766
Available files1
Source volume—
Import stateIdle

Source files

Choose one or more .osm.pbf files from the configured read-only source.

OSM_PBF_DIR/app/source_osm_pbf_downloads
No files selected
Loading source files…

Geo-object filters

Active base conditions, applied from top to bottom after osm2pgsql finishes.

10 active
01.0Administrative areasadministrative01.0.administrative.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'administrative'::text
WHERE condition
p.boundary IN ('administrative', 'place')
OR p.place IN (
    'country',
    'state',
    'province',
    'region',
    'district',
    'county',
    'subdistrict',
    'municipality',
    'city',
    'borough',
    'suburb',
    'quarter',
    'neighbourhood',
    'city_block',
    'town',
    'village',
    'hamlet',
    'isolated_dwelling',
    'farm',
    'allotments',
    'square'
)
OR p.landuse IN ('residential', 'allotments')
OR NULLIF(BTRIM(p.population), '') IS NOT NULL
03.0Water featureswater03.0.water.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'water'::text
WHERE condition
p."natural" IN ('water', 'bay', 'strait', 'spring', 'hot_spring')
OR NULLIF(BTRIM(p.water), '') IS NOT NULL
OR p.place IN ('sea', 'ocean')
OR p.landuse IN ('reservoir', 'basin', 'salt_pond')
04.0Islands and coastal landformsislands04.0.islands.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'islands'::text
WHERE condition
p.place IN ('archipelago', 'island', 'islet')
OR p."natural" IN ('peninsula', 'cape', 'isthmus', 'shoal', 'reef')
07.0Landforms and natural coverlandforms07.0.landforms.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'valleys'::text
WHERE condition
p."natural" IN (
    'valley',
    'canyon',
    'gorge',
    'plain',
    'grassland',
    'scrub',
    'heath',
    'tundra'
)
OR p.landuse IN ('grass', 'meadow')
08.0Rocks and mountainsrocks08.0.rocks.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'rocks'::text
WHERE condition
p."natural" IN (
    'bare_rock',
    'blockfield',
    'scree',
    'shingle',
    'rock',
    'stone',
    'cliff',
    'mountain_range',
    'peak',
    'ridge'
)
09.0Wetlands and moorswetlands09.0.wetlands.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'swamp'::text
WHERE condition
p."natural" IN ('wetland', 'moor')
OR NULLIF(BTRIM(p.wetland), '') IS NOT NULL
10.0Forests and woodlandforests10.0.forests.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'forests'::text
WHERE condition
p.boundary = 'forest'
OR p."natural" IN ('wood', 'forest', 'tree_group', 'tree_row')
OR p.landuse = 'forest'
OR NULLIF(BTRIM(p.wood), '') IS NOT NULL
11.0Glaciersglaciers11.0.glaciers.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'glacier'::text
WHERE condition
p."natural" = 'glacier'
12.0Sand, beaches, and dunessands12.0.sands.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'sands'::text
WHERE condition
p."natural" IN ('sand', 'beach', 'dune')
13.0Other named placesother_places13.0.other_places.sql
Earlier matches take precedence.Both expressions use the staging-table aliasp.
Object type expression
'other'::text
WHERE condition
p.place IN ('locality', 'region')