Geometry Storage Format
This article outlines why the storage formats used for geometry data by database spatial APIs are irrelevant: what is important is logical access.
Blog
PostGIS: Creating a line inside a polygon
I love working with the PostGIS API. It is a deep and wide river to swim in. But sometime having read, researched, experimented, and not found the right solution one can be forced to roll one’s own so to speak to get the job done. For the problem below, if someone can point out aRead More
Spatial Representation of a Communications Pit
This article describes the elements of a telecommunications pit and shows how they can be spatially represented. In particular the concept of a butterfly as a method for displaying the walls of a pit is introduced.
Data Models – Computerised Tree Inventory System
ESRI hosts a set of community created, domain-specific, data models on its website. As I understand the licensing of these data models, they are effectively free and open source. I have converted some of these data models into a form that they can be used natively in any of the current spatially enables databases egRead More
Support for ESRI’s ST_GEOMETRY
The following article results from customers downloading the free source code (eg for Oracle SDO_GEOMETRY) on this site without fully understanding that the code is not for ESRI’s ST_GEOMETRY spatial type and then requesting changes to the source code to support that foreign type. So, to be clear, all of the source code, products andRead More
Using Range Querying to Filter LineString Segments
This article shows how to use range querying against cumulative length to filter/select LineString segments
Google Maps / Bing Maps Spherical Mercator Projection Information
I found this article very useful, I hope you do too. The Google Maps / Bing Maps Spherical Mercator Projection
Silence is Golden?
UPDATE The book has been published If any of my readers are wondering why I have been so quiet of late, here are the reasons. GeoRaptor Firstly I have been working on a new GeoRaptor release. That release was made a few weeks ago (12th February 2013). A lot of time and effort went intoRead More
National Broadband Network, Spatial Data & Processing
As a spatial practitioner familiar with many aspects of spatial data capture and processing, I have been watching the responses to the opportunity that the National Broadband Network (NBN) offers the people of Australia and its federal, state, local and private spatial practitioners. One hears very little from NBN Co about what it is doingRead More
Industry Best Practice?
Recently I was asked to review a database migration from one vendor’s database to another’s. The conversion involved geospatial data and database internal representations. I am not going to talk about who the client was, or what actually transpired, but the final report I submitted was edited by the client and the phrase “to industry-bestRead More