Hi everybody, i dont know if anybody minds, but i am writing an own importer for the OSM File into a spatial enabled MS-SQL 2011 database for reverse geocoding,
maybe somebody is interested in this little project ?
Fully written in C#, and i want to implement a own importer see Screenshots (Already working perfect) and a WCF-Service with a little Silverlight Demo Client application for searching Latitude/Longitude or Names :-)
Work is in progress, but at the moment im able to search with the Sql Management Center already, just have to port it into the program. ;-)
Looks cool. I'm not a MS-SQL user myself, but it's always good to see new tools helping to bring OpenStreetMap to new horizons.
Are you planning to offer this tool to download somewhere? And the source code?
And here's a stub page 'osm2mssql' on the wiki
I'm interested in your project. I work in a little project regarding GPS tracking and I use openstreetmap.
So, if you want to offer this tool to download somewhere or the source code, I'm waiting to see.
I am interested in this project, from last one month i was working on a idea something like this. Before starting i searched and found this. Let me know where the project is hosted, so that i can get involved.
Sorry for the massive delay i did not had enough time to continue on the project, but i did get several emails from interested people, that´s powering me :-).
I will publish the project on codeplex soon: http://osm2mssql.codeplex.com
But i want to do some further testing, if anybody want to help me out he is pleased to do :-)
Contact me here or with the contact formular on my website.
Last edited by latinchriz (2012-02-09 00:57:27)
If anybody want´s to give it a try it is possible to query my development machine..
It is an slow Atom (2x 1.60 GHz). I imported whole Europe in ~1 day :-)
I have created a simple webpage for querying the service.
Have a look: http://giesswein-web.at/osm2mssql/
I´m currently developing a new feature: Fulltextsearch
If anybody is interested give it a try: http://www.giesswein-web.at/osm2mssql/?search=mcdonalds
Currently only Austria is supported, my server is importing Europe again, therefore the performance is not so good currently. (will take ~24h)
Service Link: http://osm2mssql.dyndns.org:8080/Search … =mcdonalds
Last edited by latinchriz (2012-02-29 23:33:57)
Hey! After a few problems... Europe is now imported and you can use it if you want to:
This looks like a nice project. I downloaded it to try it out but seem to have some sort of dependency issue.
I would love to play around with OSM data in mssql I hope this helps sort out any problems.
I should also note that while it seems to fail on the ways, the interface shows a red X on the nodes line prior to failing.
Win7 x64 running SQL2008R2 trying to run the osm2mssql x64 0.2.0 version. Unzipped and ran osm2mssql.exe the DB structure was created, just nothing imported.
The log output is below.
5/10/2012 12:10:42 AM - Task is waiting until all running tasks finish... 5/10/2012 12:10:42 AM - All tasks are finished 5/10/2012 12:10:42 AM - Finished Task: Read all ways from OSM to the database 5/10/2012 12:17:12 AM - Starting Task: Creates the database structure 5/10/2012 12:17:20 AM - Finished Task: Creates the database structure 5/10/2012 12:17:20 AM - Starting Task: Read all node from OSM to the database 5/10/2012 12:17:20 AM - Starting Task: Read all ways from OSM to the database 5/10/2012 12:17:20 AM - System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SqlServer.Types, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91' at osm2mssql.Importer.Tasks.TaskNodeReader.DoTaskWork(String osmFile) at osm2mssql.Importer.Tasks.TaskBase.RunTask(SqlConnectionStringBuilder connection, String osmFile) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
I also tried grabbing the source, where I found "Dependencies\MSSQL2008\Microsoft.SqlServer.Types.dll" and placed that with the osm2mssql.exe but that had no effect.
I have downloaded the files and also code, I will look at it.