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 / PostGIS

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)

Functions to Convert Native PostgreSQL geometric types to PostGIS

A set of functions that enable the conversion of the native PostgreSQL geometric types to PostGIS geometry objects.

Read More »
18 May, 2024 No Comments

Converting PostgreSQL Native Geometric Types to PostGIS

Introduction I comes as a surprise to some that PostgreSQL has it own native geometric type system. The geometric types are documented here but the

Read More »
17 May, 2024 No Comments

GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects

This article shows how to use GeoRaptor’s Jump to Geometry functionality to conduct “one off” mapping of SDO_GEOMETRY and EWKT/WKT text objects. PostGIS is shown as a source for EWKT showing how to integrate development across multiple databases.

Read More »
28 June, 2021 No Comments

Geometry object size when exchanging of WKT/WKB encoded geometries.

Introduction The ordinates stored in an geometry objects, across all spatial data types do not have any rounding applied to their values. This is one

Read More »
12 December, 2020 No Comments

Geometry Validity and Method Access

This article demonstrates how an invalid polygon (and linestring) are handled by the different database spatial APIs with correction in TSQL.

Read More »
6 December, 2020 No Comments

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

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

PGAdmin Finally Has A Spatial Viewer

A great day has arrived for PostgreSQL developers (not just Spatial geeks) in that finally an integrated spatial viewer has been added to PgAdmin 4.3

Read More »
7 August, 2020 No Comments

Generating a Grid (fishnet) of points or polygons for PostGIS

I wrote an article on Gridding a PostGIS Geometry object a while back. I had cause, recently, to use a variation on this for the

Read More »
5 August, 2020 1 Comment
Page1 Page2 Page3 Page4

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.