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_downloadsNo .osm.pbf files foundAdd files below OSM_PBF_DIR, then refresh this list.
Loading source files…
Geo-object filters
Active base conditions, applied from top to bottom after osm2pgsql finishes.
01.0Administrative areasadministrative01.0.administrative.sql
Earlier matches take precedence.Both expressions use the staging-table alias
p.Object type expression
'administrative'::textWHERE 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 NULL03.0Water featureswater03.0.water.sql
Earlier matches take precedence.Both expressions use the staging-table alias
p.Object type expression
'water'::textWHERE 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 alias
p.Object type expression
'islands'::textWHERE 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 alias
p.Object type expression
'valleys'::textWHERE 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 alias
p.Object type expression
'rocks'::textWHERE 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 alias
p.Object type expression
'swamp'::textWHERE condition
p."natural" IN ('wetland', 'moor')
OR NULLIF(BTRIM(p.wetland), '') IS NOT NULL10.0Forests and woodlandforests10.0.forests.sql
Earlier matches take precedence.Both expressions use the staging-table alias
p.Object type expression
'forests'::textWHERE 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 NULL11.0Glaciersglaciers11.0.glaciers.sql
Earlier matches take precedence.Both expressions use the staging-table alias
p.Object type expression
'glacier'::textWHERE condition
p."natural" = 'glacier'12.0Sand, beaches, and dunessands12.0.sands.sql
Earlier matches take precedence.Both expressions use the staging-table alias
p.Object type expression
'sands'::textWHERE 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 alias
p.Object type expression
'other'::textWHERE condition
p.place IN ('locality', 'region')