Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Pseudo Array Implementation for SQL Server Spatial (Part 2)
Introduction Data Structure + Base Function Accessors and Setters Four functions are declared for processing geometry or geography data within the array. These are “wrappers”
30 November, 2020
No Comments
Processing GML data using PostgreSQL’s XMLTABLE
This article shows how to use PostgreSQL’s XMLTABLE XML operator to process GML data and create PostGIS geometries.
1 October, 2020
No Comments
STCogo2Line: Creating (Multi)LineStrings geometries from COGO XML instructions
Previously I wrote about a function that converted the segments of a (Multi)LineString into a COGO XML document that contains all the instructions (bearing, distances,
5 August, 2020
No Comments
STLine2Cogo: Converting LineStrings to COGO XML
I have just written a useful function for my new package of TSQL functions for SQL Server Spatial called STLine2Cogo which converts (exports) a (Multi)LineString
5 August, 2020
No Comments
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
12 June, 2020
No Comments
Loading and Processing GPX 1.1 files using PostgreSQL XML
My good friend Regina Obe has taken my article Loading and Processing GPX 1.1 files using Oracle XMLDB and implemented it using PostgreSQL’s XML implementation.
15 April, 2020
No Comments
Loading and Processing GPX 1.1 files using Oracle XMLDB
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):
15 April, 2020
No Comments
All
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).
20 November, 2019
No Comments
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
6 October, 2019
No Comments
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.
5 October, 2019
No Comments