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
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
ST_Parallel for PostGIS
Many people have asked me to convert my Oracle Parallel function to PostGIS. I did it a year or so ago but the results were not as I wished. I have now corrected much that was wrong with the function so I hope it is of more value to those who have asked for itRead More
FOSSLIC – PostGIS presentations
The people over at the Free and Open Source Software Learning Centre on 19-22nd May 2009 hosted an event that included three sessions on PostGIS (on 21st May): Steve Singer, OpenStreetMap with PostGIS ; Regina Obe and Leo Hsu, Spatial Analysis with PostGIS ; Luis Bueno, Saving the Amazon with PostGIS . They are worthRead More
Vectorization: Exploding a linestring or polygon into individual vectors in PostGIS
I find having a vectorising function in my database kit-bag almost indispensable in my work. I have written and revised my Oracle PL/SQL functions that do this many times over the years and so, when I first started using PostGIS, I decided to learn how to program in PL/pgSQL by implementing something familiar: a GetVector()Read More
Loading and Processing GPX 1.1 files using PostgreSQL XML
My good friend Regina Obe has taken my article Loading and Processing GPX 1.1 files using Oracle XMLDB and implemented it using PostgreSQL’s XML implementation. For those who are interested the article is called Loading and Processing GPX XML files using PostgreSQL
Converting Oracle Optimized Rectangles to PostGIS
Someone on the PostGIS discussion list asked about a problem converting an Oracle database to PostGIS and he had run into some difficulties with Oracle’s Optimized Rectangles. Is there a way to store rectangles in postGIS in a similar fashion? With the “similar fashion” being all about converting to equivalent 5 vertex POLYGONS: I understandRead More
Building polygons from overlapping linestrings requiring intersection
I received an email a few weeks ago asking: I was wondering if you could post an article explaining how to create a polygon from overlapping lines, if this is possible. I am new as in 1 week into exploring this product and am finding the documentation for ST_BuildArea and the like a little hardRead More
Loading Point Data from a CSV File in PostGIS
I recently wrote an article on the use of External File with Oracle tables to load point data into Oracle. I thought I would have a look on how to do this in PostGIS. A bit of research came up with the PostgreSQL COPY SQL command. There appears to be no equivalent to Oracle’s OrganisationRead More
DMS2DD for PostGIS
Yesterday, I posted a short article on Converting Google Earth Formatted Longitude/Latitude points to decimal degrees. The Google Earth longitude/latitude values are expressed as a string containing degree, minute and seconds values with text separators as follows: Latitude Longitude 43� 0�50.60�S 147�12�18.20�E The function described was written in PL/SQL for Oracle. Regina Obe emailed meRead More