GeoRaptor: Layer Properties
This page describes all the elements of the layer properties dialog used to style spatial data in a GeoRaptor map view.
Open Source
Open Source Software Products Available
GeoRaptor: Working with xxx_SDO_GEOM_METADATA records.
The following video shows the functionality GeoRaptor offers for selections made against the XXX_SDO_GEOM_METADATA system views.
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 filling curves have always been overlooked in their use within GIS. Their existence was/is rarely taught at Universities, though at least in my day. Perhaps today it is different (butRead More
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).
Create GeoJSON Document from Selection of SDO_Geometry objects.
This article shows how to create a GeoJSON Document from Selection of SDO_Geometry objects.
STUpdateN: Update (replace) a single vertex within a geometry object.
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a part of either the SQL or OGC standards. In fact neither provide an API for the SQL editing of geometry objects. If one wishes to do so, one must programRead More
STUpdate: Replace all points equal to the supplied point with replacement point.
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a part of either the SQL or OGC standards. In fact neither provide an API for the SQL editing of geometry objects. If one wishes to do so, one must programRead More
STDeleteN: Delete single vertex from geometry
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a part of either the SQL or OGC standards. In fact neither provide an API for the SQL editing of geometry objects. If one wishes to do so, one must programRead More
STDelete: Deleting vertices in geometry objects
SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions: STAddPoint STUpdatePoint STDeletePoint These functions are not a part of either the SQL or OGC standards. In fact neither provide an API for the SQL editing of geometry objects. If one wishes to do so, one must programRead More
Using Oracle’s ST_GEOMETRY type hierarchy with SDO_GEOMETRY: ST_PointN and ST_NumPoints
Oracle Spatial has, for many versions, made available an implementation of the OpenGIS SFS type hierarchy. Today I will show how to use this type hierarchy do extract points from an SDO_GEOMETRY. The first example extracts the first and last point from a linestring constructed from Well Known Text. The second example finds the firstRead More