Hi i was able to import data from http://download.geofabrik.de/south-america/argentina-latest.osm.pbf using osm2pgsql the steps that i used are:
1- createuser -U postgres utest
2- createdb -U postgres -E UTF8 -O utest osm
3- Execute the query in the PostgreSQL 9.6 DB: create extension postgis;
4- osm2pgsql -cGs -d osm -S /usr/local/share/osm2pgsql/default.style /Users/XXX/Documents/OSM/argentina-latest.osm.pbf
Those steps imports the data in the DB osm in Postgres correctly
To test the data i tried this query
select city.name, city.osm_id from planet_osm_polygon city limit 10 wich return the 10 rows
but when i tried to search for my neighborhood “Corral de Palos”
select city.name, city.osm_id from planet_osm_polygon city where name = ‘Corral de Palos’ returns 0 rows…
select city.name, city.osm_id from planet_osm_polygon city where name like ‘%orral %’ returns many rows but none with the name “Corral de Palos”
However in OpenStreetMaps “Corral de Palos” exists
I download again the pbf from geofabrik and get the same results, also i tried http://download.bbbike.org/ and create the region for Argentina downloaded the generated pbf and import to the db with the same result i cant find the neighborhood.
There is something wrong on how i import the data?
I’m missing a step?