The GetVertices function in the MDSYS.SDO_UTIL package in Oracle Spatial is an exceedingly useful function. From the Oracle documentation of this function: This function returns an object of VERTEX_SET_TYPE, which consists of a table of objects of VERTEX_TYPE. Oracle Spatial defines the type VERTEX_SET_TYPE as: Oracle Spatial defines the object type VERTEX_TYPE as: The GetVerticesRead More
This is my first blog article on PostGIS. On the PostGIS discussion list, a question was asked: > I have a polygon table that has many small areas and holes. Now, I would > like to remove small areas and holes that are 2800 m^2. > > Any help or advice would be really appreciated.Read More
Using PostgreSQL’s XML processing to load spatial data Spatial data comes in many forms, but the most common is, probably, XML. If you have a need to load XML data – whether that be GML or other XML with spatial data – you may not know it, but you can use native PostgreSQL tools toRead More
A collection of wrapper functions for geography data type that homogenize access.