Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

Popular Tags:
  • Oracle Spatial
  • Source Code
  • Linear Reference System
  • PL/SQL
  • MySQL Spatial
0 $0.00
Primary Menu
  • Home
  • Articles
    • Spatial Database Functions
    • SQL Server Spatial
    • Oracle Spatial and Locator
    • PostGIS
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Linear Referencing
    • Software Change LogDescribes changes to packaged software.
  • About
  • Contact
  • Shop
0 $0.00
x
Popular Tags:
  • Oracle Spatial
  • Source Code
  • Linear Reference System
  • PL/SQL
  • MySQL Spatial
  • Login
Home / Space Curves

Top 5 Recent Articles

OptimoRoute

Functions to Convert Native PostgreSQL geometric types to PostGIS

Converting PostgreSQL Native Geometric Types to PostGIS

Fitting Bezier Polygon to Points

Fixing Geography Ring Orientation

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)

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

Read More »
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

Read More »
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.

Read More »
19 November, 2020 No Comments

Sorting SDO_GEOMETRY data using the ORDER BY clause of a SELECT statement

It is often observed that you cannot use an sdo_geometry object in an ORDER BY clause of a SELECT statement. This is demonstrated below. Test

Read More »
31 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

Read More »
27 July, 2020 No Comments

Morton Key Function for PostgreSQL/PostGIS

In my article on the creation and use of a space keys for the spatial sorting of spatial data, I show how to implement a

Read More »
10 July, 2020 No Comments

Spatial Sorting of Data via Morton Key For Oracle Spatial/Locator

I have often advocated the use of a spatial sort when loading static spatial data into Oracle (See 1. Spatially sort read-only data. in my

Read More »
30 May, 2020 No Comments

Geomatics Degrees, Space Curves and Oracle Spatial

One of the things that should be taught to GIS students at Uni but isn’t in a lot of courses is the notion of space

Read More »
26 March, 2020 No Comments

Geomatics Degrees, Space Curves and Oracle Spatial

One of the things that should be taught to GIS students at Uni but isn’t in a lot of courses is the notion of space

Read More »
26 March, 2020 No Comments

Documentation

  • MySQL Spatial General Functions
  • Oracle LRS Objects
  • Oracle Spatial Exporter (Java + pl/SQL)
  • Oracle Spatial Object Functions
  • Oracle Spatial Object Functions (Multi Page)
  • PostGIS pl/pgSQL Functions
  • SC4O Oracle Java Topology Suite (Java + pl/SQL)
  • SQL Server Spatial General TSQL Functions
  • SQL Server Spatial LRS TSQL Functions
© The Spatial Database Advisor 2019 | Shopical by AF themes.