![]() Like Nodes, Ways may contain a number of key/value pair tag elements describing properties of ways. To start with, I’ll just populate a table containing the IDs of all the ways included in the dataset: CREATE TABLE ways ( Ways contain collections of nodes – they might mark out areas, footpaths, boundaries of fields, counties, or buildings, for example. Ways do not necessarily represent routes, or even roads. INSERT INTO 'int') AS 'float') AS 'float') AS 'float'), 'float'), 4326) AS AS OSM(OSMnode) Load the XML FileĪs before, start by loading the XML file into a single SQL Server variable of the XML datatype using OPENROWSET(BULK) as a SINGLE_BLOB DECLARE xml īefore loading the Ways, it’s first necessary to extract the nodes from which each way is formed: CREATE TABLE nodes ( Shredding the data relating to OSM ways is a little bit more involved that for POIs, since each way contains references to a number of different nodes. The original file can be downloaded from, or you can download subsets split by individual country or feature type from and
0 Comments
Leave a Reply. |