Need to Load the OSM (Open Street Map) data Nodes and Ways data for a region

Question

Dear Experts, 

I have a requirement recently to generate an OSM(Open Street Map) database that contains Ways and Node data for our application to generate a Map route sequence for our application. Initially we thought to do this with a PostgreSQL DB approach as it has some extensions available. But, I would like to know if there is a way to do the same with the SQL Server to generate such OSM Database. Have anyone did this, would be great if they share their knowledge in this forum. 

I got some references on shape files into PGSQL through  openstreetmap.org. 

Appreciate help on this regards. 

Thanks Momen 

---

Thank you... MOMEN

Answer 1

Hi Momen,

Here are some articles which might help:

Loading Open Street Map POIs with SQL Server / Bing Maps

Loading Open Street Map Data in SQL Server Part II: Ways

OpenStreetMap Data Wrangling with SQL

Downloading entire OSM world dataset and import into MS SQL

Hope this could help you.

Best Regards,

Amelia Gu

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

OSM supports to download the points/ways as XML file and SQL Server supports to run xQueries against XML data; this ways you can load & process the spatial data.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

Thanks, linked were helpful, I was able to import the OSM Data. 

---

Thank you... MOMEN