Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

0 $0.00
Primary Menu
  • Home
  • Articles
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Oracle Spatial and Locator
    • PostGIS
    • SQL Server Spatial
    • Software Change LogDescribes changes to packaged software.
    • Spatial Database Functions
  • About
  • Contact
  • Shop
0 $0.00
x
  • Login/Register
Home / PostGIS

Top 5 Recent Articles

GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects

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

Geometry Validity and Method Access

Processing GML data using PostgreSQL’s XMLTABLE

PostGIS: Creating a line inside a polygon

ARTICLES CATEGORIES
  • Algorithms (19)
  • All (400)
  • Biography (1)
  • Blog (45)
  • Business Requirements (1)
  • Commentary (1)
  • 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) (4)
  • Open Source (18)
  • Oracle Spatial and Locator (193)
  • Partitioning (1)
  • PostGIS (34)
  • Published Articles (1)
  • qGIS (1)
  • Recommendations (1)
  • Services (1)
  • Software Change Log (1)
  • Source Code (35)
  • Space Curves (9)
  • Spatial Database Functions (107)
  • Spatial DB comparison (1)
  • Spatial XML Processing (11)
  • SQL Server Spatial (91)
  • Standards (3)
  • Stored Procedure (15)
  • Tessellation or Gridding (10)
  • Tools (2)
  • Topological Relationships (1)
  • Training (2)
  • Triangulation (2)

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

R based Delaunay Triangulation Function for PostGIS using the deldir package

This article shows how to create and use an r-based Delaunay triangulation function for postgis using a XYZ supporting version of the deldir package.

Read More »
31 July, 2020 No Comments

COGO: Converting Decimal Degrees to Degrees Minutes and Seconds – and back again (PostGIS)

It is useful to have functions for converting from individual degrees, minutes and seconds to a single decimal degree value and back again. Here are

Read More »
27 July, 2020 No Comments
Page1 Page2 Page3 Page4

Documentation

  • MySQL Spatial General Function Documentation
  • Oracle LRS Object Documentation
  • Oracle Spatial Exporter Package Documentation
  • Oracle Spatial Object Function Documentation
  • Oracle Spatial Object Function Documentation (Multi Page Version)
  • PostGIS pl/pgSQL Function Documentation
  • SC4O Oracle Java Topology Suite (Stored Procedures) Package Documentation
  • SQL Server Spatial General TSQL Function Documentation
  • SQL Server Spatial LRS TSQL Function Documentation
© The Spatial Database Advisor 2019