Hi,
I have downloaded Israel’s map and extracted it to sql server (using osm2mssql).
I have 11 tables in the database:
tWayCreation
tWay
tWayTag
tNode
tNodeTag
tTagType
tRelationCreation
tRelation
tRelationTag
tMemberType
tMemberRole
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?
Thanks,
Keren
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:
https://github.com/IsraelHikingMap/Site/tree/master/IsraelHiking.DataAccess