STDensify: Densify (m)LineString or (m)Polygon geometry objects

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 the box”. Others, such as Oracle Locator/Spatial do not which is why a function is available with the PL/SQL (Package and Object) code that is available for download from thisRead More

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 (SFS) 1.1 and 1.2, as well as the SQL/MM standard, define a Well Known Text (WKT) format for use in interchanging or processing geometry data. These specifications are 2D inRead 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 Consortium’s, Simple Features Specifications (SFS) 1.1 and 1.2, as well as the SQL/MM standard, define a Well Known Text (WKT) format for use in interchanging or processing geometry data. TheseRead More

Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 2)

In Part 1 were were introduced to the IUF data, its structure, and processing (for Locality elements). In Part 2 we will look at ways of reducing the data volume of the seed file, and look at issues when processing whole layers (LGA will be used instead of LOCALITY). In Part 3 we will lookRead More

Loading and Processing GPX 1.1 files using Oracle XMLDB

Note This is an article I wrote some years back which I have ported to my new website. Introduction There are a large number of geospatial data storage, delivery and interchange formats around nowadays. Including (I limit this discussion to vector data formats only): Geography Markup Language (GML) Keyhole Markup Language GPS eXchange Format (GPX)Read More

Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 1)

Introduction This article is about importing Victorian Government’s Incremental Update File (IUF) XML data into SQL Server. The IUF XML is used to publish whole (complete) datasets (e.g. Local Government Areas) or deltas/changes. As will be seen, it encodes geometry objects in its own unique way, and thus is a good dataset to demonstrate theRead More

Migrating Tables with Geometry Columns from Oracle to SQL Server Spatial

A colleague asked me the other day how he could move data from a table in an Oracle database with a geometry column to SQL server. Of course I thought of this as a straight forward data migration exercise using standard database tools, in this case SQL Developer and SQL Server Management Studio (SSMS), whereRead More