STAsEWKT

STAsEWKT — Implements an method to create Extended Well Known Text (EWKT) strings from the input @p_geometry. Introduction/Description The Open Geospatial Consortium’s, Simple Features Specifications

Read More »

STGeomFromEWKT

STGeomFromEWKT — Function that implements an import method for Extended Well Known Text including EWKT with SRID, Z and M ordinates.. Introduction/Description The Open Geospatial

Read More »

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.

Read More »

STMulti

STMulti — Function that returns @p_geometry as a MULTI* geometry Function Specification Description In situations where a geometry column is constrained to hold only the

Read More »