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 / All / Page 3

Top 5 Recent Articles

Generating Road LineStrings with Z (Elevation) through processing involving a Tasmanian statewide Digital Elevation Model (DEM)

Best Practice when Loading geographic Polygons into SQL Server Spatial geometry column

OptimoRoute

Functions to Convert Native PostgreSQL geometric types to PostGIS

Converting PostgreSQL Native Geometric Types to PostGIS

ARTICLES CATEGORIES
  • Algorithms (23)
  • All (399)
  • Biography (1)
  • Blog (45)
  • Business Requirements (1)
  • Commentary (1)
  • Conversion (3)
  • Customers (2)
  • Data Models (1)
  • Education (2)
  • GeoRaptor (13)
  • GPS (1)
  • Image Processing (2)
  • Import Export (9)
  • Licensing (2)
  • LiDAR (1)
  • Linear Referencing (4)
  • Manifold GIS (3)
  • Mapping (2)
  • MySQL Spatial (7)
  • Networking and Routing (including Optimization) (6)
  • Open Source (18)
  • Oracle Spatial and Locator (194)
  • Partitioning (1)
  • PostGIS (38)
  • 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 (93)
  • Standards (3)
  • Stored Procedure (17)
  • Tessellation or Gridding (11)
  • Tools (2)
  • Topological Relationships (1)
  • Training (2)
  • Triangulation (2)

Processing GML data using PostgreSQL’s XMLTABLE

This article shows how to use PostgreSQL’s XMLTABLE XML operator to process GML data and create PostGIS geometries.

Read More »
1 October, 2020 No Comments

STInsertN: Insert single vertex into a 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

Read More »
7 August, 2020 No Comments

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

Read More »
7 August, 2020 No Comments

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

Read More »
7 August, 2020 No Comments

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

Read More »
7 August, 2020 No Comments

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

Read More »
7 August, 2020 No Comments

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

Read More »
7 August, 2020 No Comments

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

Read More »
7 August, 2020 No Comments

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.

Read More »
7 August, 2020 No Comments

Urban Trees Data Model

Data model for the recording of urban trees in a city, town or council

Read More »
7 August, 2020 No Comments
Page1 Page2 Page3 Page4 Page5

Documentation

  • GeoRaptor 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.