Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (15)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (3)
- Open Source (18)
- Oracle Spatial and Locator (192)
- PostGIS (34)
- Published Articles (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (35)
- Space Curves (9)
- Spatial Database Functions (106)
- Spatial DB comparison (1)
- Spatial XML Processing (10)
- SQL Server Spatial (General) (83)
- SQL Server Spatial (LRS) (38)
- Standards (1)
- Stored Procedure (15)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
STRotate: Function to rotate a geometry object in SQL Server Spatial
If you have need for a TSQL based function for rotating geometry objects in SQL Server Spatial (Denali is required), here is a function you
27 July, 2020
No Comments
STVertices: Wrapper over STDumpPoints
Oracle’s point dumping function, mdsys.sdo_util.getVertices is most useful. When swapping between platforms sometimes I look first for such a function in SQL Server Spatial forgetting
27 July, 2020
No Comments
STMorton: Creating a Morton Number Space Key Value for Grid Cells
Introduction NOTE: This article is a copy of the original first written in 2010 from my old website. Space curves are imaginary lines that systematically
27 July, 2020
No Comments
Gridding a geometry or geography object (SQL Server Denali)
A common question that comes up in the various database forums (PostGIS, SQL Server, Oracle) is how to “grid” a linear or polygonal object. By
24 July, 2020
No Comments
On hinting spatial indexes
Recently, using SQL Server 2008 (not R2), I came across an issue with hinting a SELECT statement with a spatial index. This particular issue is
24 July, 2020
No Comments
RandomSearchByExtent: Random Search Procedure (2008 Spatial)
I have had the need, over the years, to produce statistics that helped me decide how effective a change to a property of a spatial
24 July, 2020
No Comments
COGO: Converting (Google Earth) Formatted Longitude/Latitude points to decimal degrees (SQL Server)
In an article on Oracle I described how to convert Google Earth textual representations of a longitude or latitude value to its decimal equivalent. Here
17 July, 2020
No Comments
COGO: Convert Degrees, Minutes and Seconds values to Decimal Degrees
Sometimes data is provided to spatial databases via spreadsheets or other database tables in the form of degrees, minutes and seconds values. For example, data
17 July, 2020
No Comments
COGO: Convert DMS String to decimal degrees floating point number.
In my article on DD2DMS I outlined how to convert a latitude or longitude as a decimal degrees value to a formatted string. This article
17 July, 2020
No Comments
COGO: DD2DMS Formatting a latitude/longitude decimal degree value
Many years ago I had need to annotate the lines of a cadastral (land titles) polygon with the bearing and distance of each line. The
17 July, 2020
No Comments