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

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)

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.