Answered by:
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
Wednesday, December 4, 2019 7:08 PM
Answers
-
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 MSDNFSF@microsoft.com.- Marked as answer by Momen Azmath Tuesday, December 10, 2019 12:35 PM
Thursday, December 5, 2019 5:42 AM
All replies
-
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 MSDNFSF@microsoft.com.- Marked as answer by Momen Azmath Tuesday, December 10, 2019 12:35 PM
Thursday, December 5, 2019 5:42 AM -
-
Thanks, linked were helpful, I was able to import the OSM Data.
Thank you... MOMEN
Tuesday, December 10, 2019 12:35 PM