Top 5 Recent Articles
- Biography (1)
- Blog (41)
- Changes (1)
- Customers (1)
- Data Models (1)
- Education (2)
- General Software (21)
- Georaptor Blog (5)
- Image Catalog (2)
- Licensing (1)
- ManifoldGIS (3)
- MySQL Blog (4)
- MySQL Spatial (3)
- Networking and Routing (including Optimization) (3)
- Oracle Spatial (171)
- Philosophy (1)
- PostGIS (30)
- Press Releases (1)
- Source code (24)
- Space Curves (1)
- Spatial DB comparison (1)
- SQL (1)
- SQL Server Blog (58)
- SQL Server Spatial (General) (15)
- SQL Server Spatial (LRS) (37)
- Stored Procedure (2)
- Training (1)
- XML (5)
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 3)
This is the 3rd and last blog post about processing VicMap IUF XML data. (The 6 month delay is because I lost a draft of
“Imitation is the Greatest Form of Flattery” Before I talk about SSMS, pgAdmin and DBeaver spatial visualisation solutions, some history about the first spatial tool
Requirement The ability to densify a lineString or polygon ring is a common requirement across database platforms. Some, like PostGIS, has such functionality “out of
Extract sub element geometry types of geometry collection or complex geometry.
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 2)
This Part 2 article looks at ways of reducing the data volume of the seed file, and issues associated with processing whole layers (LGA will be used instead of LOCALITY).
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 1)
The VicMap Incremental Update Format file is an XML document that is used to publish whole datasets (e.g. every Local Government Area in Victoria) or changes to one or more individual records within a whole dataset.
The IUF encodes its geometry objects in its own unique way. While tools such as Safe Software’s Feature Manipulation Engine can process IUF documents, it is a good dataset to demonstrate the use of SQL Server XML and Spatial processing to import the data.
This article introduces the structure of the IUF XML data and shows how to process it to create polygons with exterior and interior rings, and attributes.