OpenStreetMap + PostgreSQL(How to load OpenStreetMap data into a PostgreSQL Database)

In this video,I tell what is OpenStreetMap and how to download OSM data and how to load that data to a PostGreSQL database.

How to install PostGreSQL server:

osm2pgsql Github Repo(Contains guidelines for installing and setting up):

[noblenetdk]

Why not trough it all into a docker-compose?

[koztrkr]

I'm from 🇹🇲Turkmenistan 😇, thanks

[gurbanacylow]

Hi Rahul,
I from Turkmenistan and thank you for info

[SarabjotSingh]

Hi Rahul,

I want to filter the OSM data before importing it into the PostGresSQL db. I am first using OsmConvert to convert the data into the .o5m format and then using OSMFilter to filter out the selected elements. How can I then import the data into PostGresSQL? As per your video, it takes .osm.pbf file format in the command line?

[vaseemrajakottarath]

i have uploaded osm data to posgressql but when queried, table values are null

[shahi_gautam]

You are only creating the database, will it create the table automatically? How can I import osm to the Postgres server? Can you please the command?

[shivannagn]

Hi rahul
I am trying to do in Windows using command prompt
It is showing Connection to database failed : Fe _ sendauth: no password supplied, can u know hw to overcome this

[vinayrachapalli]

hi rahul, actually I want to download india map and run Dijkstra's algo on my own. How can I download map as a graph. I'm new to osm and all. Please help me.
1. I downloaded india map from Geofabrik, it's format is .osm.pbf, what is next step

[lazymacs]

Does this have asset tracking feature?

[shoibansari]

Hi Rahul,
do you know how to edit osm boundaries. I want offline map of India with J&K boundaries as per Indian Govt. Could you please help me ?

[moussaamadouabdoulrazak]

Hi Rahul, how can I do the geocoding on this database ?

[flassyp]

bad tutorial. bring very shame to Turkmenistan and our glorious leader

[OurstPlanet]

Please redo and speak clearly and concisely.