Data import from osm.pbf

General
1

Good morning all,

we tried to import argentina-latest.osb.pbf in a postgis db.
When we try to extract the data to create a layer of only boundaries with admin_level = ‘4’ with this query:

insert into osm_argentina.states(osm_id, name, uppername, geom)
SELECT planet_osm_polygon.osm_id,
planet_osm_polygon.name as name,
upper(planet_osm_polygon.name) AS uppername,
st_multi(planet_osm_polygon.way)::geometry(MultiPolygon, 3857) as way
FROM planet_osm_polygon
WHERE planet_osm_polygon.admin_level = ‘4’::text AND planet_osm_polygon.boundary = ‘administrative’::text;

We get the following rendering error, as you can see the boundary is not the geographic one, but the political.

geo7
geo7972×426 189 KB

Could it be that there are some error in the original .osm.pbf file?

Unfortunally this is not the only area of south America with this kind of issue, there are some other area which we cannot give an explanation

Is it a known issue? Is there a solution? Maybe download an older version of the area?

Thank you.

4

I think this is a common occurence with clipped OSM data that it is missing much of the administrative boundary layers.

I see this quite often with data extracts from https://download.geofabrik.de/. You might need to pick a bigger area that that includes argentina, or use just boundary sources, such as the ones from natural earth to get the best boundaries.