reverse geocoding - osm2mssql - Import OSM into Ms-SQL

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 :slight_smile:
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. :wink:

WCF-Control

Importer

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?

You’d be welcome to use SVN to share your code. We already have a number of tools for converting osm2something See Getting commit access.

And here’s a stub page ‘osm2mssql’ on the wiki

Hi latinchriz,

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.

Hi latinchriz,

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.

Regards,
Shivashankar
Nucleon Technologies

Hi!

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 :slight_smile:
Contact me here or with the contact formular on my website.

greets
christian

screenshot

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 :slight_smile:

http://osm2mssql.dyndns.org:8080/LookupRoad?latitude=48.204394&longitude=16.358848

I have created a simple webpage for querying the service.
Have a look: http://giesswein-web.at/osm2mssql/

Hey!

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/SearchRequest?search=mcdonalds

Hey! After a few problems… Europe is now imported and you can use it if you want to:
http://giesswein-web.at/osm2mssql/?search=mcdonalds

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=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.SqlServer.Types, Version=11.0.0.0, 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.

Thanks latinchriz,

I have downloaded the files and also code, I will look at it.

Shiv