Looking fro some information

[andyfenna]

Please can you confirm that the Id fields on SQL Server tables node and relation is infact the osm_id within the planet.osm.pbf file?

Kind regards

Andrew

[xivk]

Yes, that's exactly right:

https://github.com/OsmSharp/data-providers/blob/master/OsmSharp.Data.SQLServer/Osm/Streams/SQLServerOsmStreamTarget.cs#L261

The ID's are copied from the source.

[andyfenna]

Thank-you very much for answering my question.

[andyfenna]

One more question... the latitude and longitude within the node table are int's therefore do not have a decimal place, how does one calculate the correct lat and longs?

[xivk]

Example here:

https://github.com/OsmSharp/data-providers/blob/master/OsmSharp.Data.SQLServer/Osm/SQLServerDataSource.cs#L231

[andyfenna]

Please can you explain to me how I create a polygon in SQL when I have populated dbo.node, dbo.node_tags, dbo.relation, dbo.relation_members, dbo.relation_tags, dbo.way, dbo.way_nodes and dbo.way_tags?

Am I right in assuming that the relation_id in dbo.relation_members table is in fact the osm_id?

Also what does? and how does? the dbo.relation_members join back to the dbo.node table for the lat and longs? which are needed to build a sql geography polygon?

Any help would be much appreciated.

Thanks

Andrew