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.
PostGIS
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 list includes: point – Point on a plane – (x,y) lseg – Finite line segment – ((x1,y1),(x2,y2)) box – Rectangular box – ((x1,y1),(x2,y2)) path – Closed path (similar to polygon)Read More
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.
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 aspect of data management that is seldom considered by most practitioners. Other articles in this website deal with how to round their values. This article is about a related topic”Read More
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.
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.
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 found the right solution one can be forced to roll one’s own so to speak to get the job done. For the problem below, if someone can point out aRead More
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.
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 as announced by Regina Obe You can see the announcement and some examples here
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 generation of an array of point objects for a geometry polygon, so I wrote a version that also allows for the generation of a grid of polygons or points dependingRead More