I have downloaded Israel’s map and extracted it to sql server (using osm2mssql).
I have 11 tables in the database:
I want to find all the cities polygons and their names, with no success.
I couldn’t find the tables schema documentation.
Can someone please assist?
I’m using OSMSharp and Net Topology Suite to open a pbf file of Israel and extract geometries.
I also would advise to use PostGis with postgres database as all OSM community is using it for this purpose.
I’m not aware of a GIS implementation to MSSQL, but I’m sure there is something, I’ll be surprised if someone uses it with OSM.
Most of the C# code that is used to read OSM file/save them to DB can be found here in our project: