Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (20)
- All (400)
- Biography (1)
- Blog (45)
- Business Requirements (1)
- Commentary (1)
- 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) (4)
- Open Source (18)
- Oracle Spatial and Locator (193)
- Partitioning (1)
- PostGIS (34)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (108)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
Oracle Spatial Mapping and Map Rendering Performance Tips
Comment: This article was written about 10 years ago. Most of what is written is still relevant though the comments about disk usage and access
23 November, 2020
No Comments
Space Filling Curve Functions For TSQL
Introduction Warning: This article is long mainly because it includes the source code of the Hilbert, Morton and Peano key/curves. I would assert that space
22 November, 2020
No Comments
Bing Maps Tile System Functions for TSQL
This blog presents functions for Bing Maps Tile System for TSQL. This support includes converting Latitude/Longitude pairs to Bing Maps QuadKeys. The source for the
19 November, 2020
No Comments
Experience With GIS Desktop Software
GIS Desktop Software is the bedrock of how most people experience Geographic Information Systems. A limited selection of such products are: ArcGIS Manifold MapInfo qGIS
19 November, 2020
No Comments
Geocoding Points Against a Grid of Cells/Tiles With/out Spatial Operators
This article shows how to geocode points objects against grid cells without using spatial operators. The article also shows how to use space curve values such as generated by a Morton key algorithm as grid cell ids and thus geocodes.
19 November, 2020
No Comments
Using a GeometryCollection as an Array for TSQL (Stored Procedure) Development.
The lack of an array datatype in TSQL can be overcome for geometry processing by use of a GeometryCollection as a data type and a set of methods to manipulate it.
6 November, 2020
No Comments
The Frontage Problem: Creating references from land parcel street frontage boundary to point in street
This article demonstrates the power of database-based spatial processing. The business requirement is to determine, dynamically, the side of a land parcel that faces the street (could be single 2 point straight line to something more complex), and then determine the clockface direction from either ends of the frontage or the middle, to a object in the roads reserve (eg telecommunications pit).
3 November, 2020
No Comments
Create GeoJSON Document from Selection of SDO_Geometry objects.
This article shows how to create a GeoJSON Document from Selection of SDO_Geometry objects.
30 October, 2020
No Comments
Identifying Quadrilateral Polygon Geometries in SQL Server Spatial
In some situations Quadrilateral polygon geometries in SQL Server Spatial can affect processing results. The best example of this is the identification of CircularStrings in polygon geometries. If quadrilateral objects are not identified, they end up being incorrectly converted. This function helps identify such polygon objects.
16 October, 2020
No Comments
STLineToCurve. A Function that Converts a LineString to a CircularString, CompoundCurve or CurvePolygon.
The STLineToCurve function analyses a LineString looking for CircularString elements among its vertices (often LineStrings are created from curve elements by “stroking” especially where the processing software does not support CircularStrings). Any constructed CircularStrings are combined with other LineStrings to create CompoundCurves or CurvePolygons.
15 October, 2020
No Comments