I'm working on a project where I have to get all the streets of the city where I live, including colony, suburb, postal code, but I am a little confused about what process do I have to follow.
I have download three files from geofabrik.de (osm.pbf, osm.bz2 and shp) that belongs to my country Mexico.
I have other shapefiles of my city (I opened them in the site https://mapshaper.org/ and only could see the boundaries of my city).
So I would like to know how can I extract the full address including the street, postal code, etc.
I work with Windows.
This is what I have done without results (in my point of view)
I load country.osm.pbf file to OSGeo4w QGIS3 (I am able to see the map), but I do not know how to export the data that I need. I click on the layers and export to csv, but the generated files are to big and includes a lot of points and information that I do not need.
I also use osm2mssql tool to migrate country.osm.pbf to SQL Server but the generated database contains some points but not all the streets.
I also used osmconvert to transform the pbf file to o5m
Then I run this
.\osmfilter.exe mexico.o5m --keep="addr:country= and addr:city= and addr:postcode= and addr:street= and addr:state=" --ignore-dependencies | .\osmconvert64-0.8.8p.exe - --csv="@oname @id @lon @lat addr:country addr:city addr:postcode addr:street addr:state" --csv-headline -o=filteredfile.csv
But it only generates about 1000 rows.
I do not know if the geofabrik files includes all the streets of my country or only some points about malls, banks and something like that.