osm2mssql Data Model

Oct 6, 2014 at 2:36 PM
Edited Oct 6, 2014 at 10:19 PM
Hi,

I'm really interested in using osm2mssql. Before I start wit my question, I've to congrat you for your project ;-)

Well, I have some questions:
1- Before I start importing OMS map, do I need to 1st creat a Spatial DB? If so, can you please tell me how to do it or what technologies should I use? (It's my first time using mssql)

2- Can you share with me the UML of the imported DB?

3- I've used postgreSQL and it has special types of queries like ST_DISTANCE etc.. Is there any query service like that on spatial mssql?

4- Finally, the road address is contained in the Tags table? Is there anyway to find in the DB the country of a specific lat/long ?

I'm sorry to bore you guys, but those informations have a big impact in my university project, so if you could help me it would be awesome..

Thanks for your attention