Import CSV and OSM data into PostgreSQL using ogr2ogr

In this video we use ogr2ogr to insert CSV and OSM data into PostgreSQL. We install postgis and hstore extension and look at various flags associated with ogr2ogr command.

Data:

0:00 Looking at the data (CSV)
2:00 Start coding
8:32 Visualize the data on postgreSQL

#postgresql
#openstreetmap
#ogr2ogr

[ashishkumar]

Hi Aman, while importing the info from pbf file i am getting the WKB geometry column as binary, can you guide in terms of how can this be used as as geom