I understand the the data that I download from download.geofabrik.de/ has all the data which is available from WWW sources (such as turbo-overpass, osmand.net/,osmand.net/, routing.openrailrouting.org/ and so on). So once I able to load the data in postgresSQL, then instead of using APIs, I can use SQL queries to extract needed data. As an alternate, I can also use QGIS software for the same purpose. I hope my assumption is correct.
If you download an .osm.pbf file from Geofabrik it will have all the data for that region. If you download a .shp.zip file then it does not have all data, but only the most common data.
Third-party web sites will sometimes use other sources in addition to OpenStreetMap; if that is the case, then those other sources will not be in the .osm.pbf files that you download from Geofabrik. One example is certain Mapbox-based web sites which utilise 3rd party building datasets on top of OSM.
3 Likes
and it’s faster to load data in .pbf format in PostgreSQL using osm2pgsql for example, give it a try