corpus.blog
41554 blogs · [ { "id": "01a087e4-28f8-731c-a07a-95cc1f3a46ce", "title": "Generating Road LineStrings with Z (Elevation) through processing involving a Tasmanian statewide Digital Elevation Model (DEM)", "url": "https://www.spdba.com.au/generating-road-linestrings-with-z-elevation-through-processing-involving-a-tasmanian-statewide-digital-elevation-model-dem/", "published_at": "2026-09-04T06:09:11+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc1ff1ec9c", "title": "Best Practice when Loading geographic Polygons into SQL Server Spatial geometry column", "url": "https://www.spdba.com.au/best-practice-when-loading-geographic-polygons-into-sql-server-spatial-geometry-column/", "published_at": "2026-09-02T06:40:04+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc1ffc2ae6", "title": "OptimoRoute", "url": "https://www.spdba.com.au/optimoroute/", "published_at": "2024-05-27T01:34:45+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc20b63f84", "title": "Functions to Convert Native PostgreSQL geometric types to PostGIS", "url": "https://www.spdba.com.au/functions-to-convert-native-postgresql-geometric-types-to-postgis/", "published_at": "2024-05-18T00:23:47+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc20f5557c", "title": "Converting PostgreSQL Native Geometric Types to PostGIS", "url": "https://www.spdba.com.au/converting-postgresql-native-geometric-types-to-postgis/", "published_at": "2024-05-17T06:59:13+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc21040d8f", "title": "Fitting Bezier Polygon to Points", "url": "https://www.spdba.com.au/fitting-bezier-polygon-to-points/", "published_at": "2024-04-30T07:43:32+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc21453c2d", "title": "Fixing Geography Ring Orientation", "url": "https://www.spdba.com.au/fixing-geography-ring-orientation/", "published_at": "2022-12-30T05:24:40+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc21bba427", "title": "Calculating Distance in the Lambert Conformal Conic projection vs WGS84/GDA94", "url": "https://www.spdba.com.au/calculating-distance-in-the-lambert-conformal-conic-projection-vs-wgs84-gda94/", "published_at": "2022-07-05T07:17:00+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc21db32a3", "title": "Killer Data", "url": "https://www.spdba.com.au/killer-data/", "published_at": "2022-05-14T04:09:25+00:00" }, { "id": "01a087e4-28f8-731c-a07a-95cc22346de4", "title": "Delaunay Triangulation Function for TSQL and SQL Server Spatial", "url": "https://www.spdba.com.au/r-based-delaunay-triangulation-function-for-sql-server-spatial-using-the-deldir-package/", "published_at": "2022-04-18T04:51:39+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bc68e555", "title": "Creating linestring geometries from a table of ordinates (SQL Server)", "url": "https://www.spdba.com.au/creating-linestring-geometries-from-a-table-of-ordinates-sql-server/", "published_at": "2022-04-18T02:24:40+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bc9859c9", "title": "Creating linestring geometries from a table of ordinates (Oracle)", "url": "https://www.spdba.com.au/creating-linestring-geometries-from-a-table-of-ordinates/", "published_at": "2022-04-18T01:13:36+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bcf9aa5a", "title": "Partition Spatial Data using SQL Server", "url": "https://www.spdba.com.au/partition-spatial-data-using-sql-server/", "published_at": "2022-04-13T01:07:24+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bdefbd95", "title": "Removing Spikes in SQL Server Spatial Linestrings", "url": "https://www.spdba.com.au/removing-spikes-in-sql-server-spatial-linestrings/", "published_at": "2022-04-07T06:45:03+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2be610356", "title": "Geometry Storage Format", "url": "https://www.spdba.com.au/geometry-storage-format/", "published_at": "2022-04-07T04:00:38+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bea4e1e6", "title": "How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads", "url": "https://www.spdba.com.au/how-to-calculate-cumulative-length-of-a-linestring/", "published_at": "2022-03-21T23:40:02+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bf96de82", "title": "qGIS, GEOMETRY_COLUMNS and SQL Server Spatial", "url": "https://www.spdba.com.au/qgis-geometry_columns-and-sql-server-spatial/", "published_at": "2021-11-03T03:19:47+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bfb3836c", "title": "Removing Duplicate Vertices in SQL Server Spatial", "url": "https://www.spdba.com.au/removing-duplicate-vertices-in-sql-server-spatial/", "published_at": "2021-10-23T05:13:27+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2bff1488d", "title": "Visualising the Topological Relations of LineStrings", "url": "https://www.spdba.com.au/visualising-the-topological-relations-of-linestrings/", "published_at": "2021-09-17T07:29:16+00:00" }, { "id": "01a0d19b-abdb-7303-9b9e-01f2c086f74a", "title": "Object Implementation of Oracle SDO_LRS", "url": "https://www.spdba.com.au/object-implementation-of-oracle-sdo_lrs/", "published_at": "2021-07-05T03:59:54+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce150a1223", "title": "Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2)", "url": "https://www.spdba.com.au/split-a-linestring-at-a-known-point-using-oracle-spatial-and-pl-sql/", "published_at": "2021-06-30T04:34:50+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce157aed52", "title": "Split Oracle Sdo_Geometry Linestring at a Known Point using PL/SQL (1)", "url": "https://www.spdba.com.au/split-sdo_geometry-linestring-at-a-known-point/", "published_at": "2021-06-30T04:00:57+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce165e3cea", "title": "GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects", "url": "https://www.spdba.com.au/jumptogeometry/", "published_at": "2021-06-28T04:04:48+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce166a47ae", "title": "Snapping a Point to an Oracle Spatial SDO_GEOMETRY LineString", "url": "https://www.spdba.com.au/snapping-a-point-to-a-linear-oracle-spatial-sdo_geometry/", "published_at": "2021-06-26T05:19:51+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce16b63ef8", "title": "GeoRaptor: Layer Properties", "url": "https://www.spdba.com.au/georaptor-layer-properties/", "published_at": "2021-05-31T05:11:09+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce17259f9b", "title": "GeoRaptor: Exporting GeoJSON and viewing in Tatuk GIS Viewer", "url": "https://www.spdba.com.au/georaptor-exporting-geojson-and-viewing-in-tatuk-gis-viewer/", "published_at": "2021-05-26T06:49:58+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce17b3acdb", "title": "GeoRaptor: Exporting GML and visualising in qGIS", "url": "https://www.spdba.com.au/georaptor-exporting-gml-and-visualising-in-qgis/", "published_at": "2021-05-20T06:32:50+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce187c13bc", "title": "GeoRaptor: Area Rendering Options", "url": "https://www.spdba.com.au/georaptor-area-rendering-options/", "published_at": "2021-05-05T03:26:47+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce1930336f", "title": "GeoRaptor: Views and On The Fly Projection", "url": "https://www.spdba.com.au/georaptor-views-and-on-the-fly-projection/", "published_at": "2021-04-24T08:15:56+00:00" }, { "id": "01a0d19c-4220-72a0-b4f5-67ce19896018", "title": "GeoRaptor: Metadata Management", "url": "https://www.spdba.com.au/georaptor-metadata-management/", "published_at": "2021-04-24T04:06:15+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bb77705c6", "title": "GeoRaptor: Importing a Shapefile into a table", "url": "https://www.spdba.com.au/using-georaptor-to-load-shapefiles-into-a-table/", "published_at": "2021-04-23T06:08:09+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bb8761485", "title": "GeoRaptor: Simple Mapping", "url": "https://www.spdba.com.au/georaptor-simple-mapping/", "published_at": "2021-04-23T04:20:14+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bb94e88d5", "title": "GeoRaptor: Visualising Geometry Objects", "url": "https://www.spdba.com.au/georaptor-visualising-geometry-objects/", "published_at": "2021-04-22T22:59:38+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bb9a88c5a", "title": "GeoRaptor: Working with xxx_SDO_GEOM_METADATA records.", "url": "https://www.spdba.com.au/georaptor-working-with-xxx_sdo_geom_metadata-records/", "published_at": "2021-04-22T01:19:00+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bba421a75", "title": "GeoRaptor 18+: Downloading and Installing beta", "url": "https://www.spdba.com.au/georaptor-install/", "published_at": "2021-04-07T03:32:24+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bbb07f1b4", "title": "Oracle 21c: Locator is no more", "url": "https://www.spdba.com.au/oracle-21c-locator-is-no-more/", "published_at": "2021-01-17T22:46:57+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bbb9ade08", "title": "Oracle Spatial Vector Acceleration: Flick the Switch", "url": "https://www.spdba.com.au/oracle-spatial-vector-acceleration-flick-the-switch/", "published_at": "2021-01-17T22:30:08+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bbc224819", "title": "Geometry object size when exchanging of WKT/WKB encoded geometries.", "url": "https://www.spdba.com.au/geometry-objects-and-the-representation-and-exchange-of-wkt-wkb-encoded-geometries/", "published_at": "2020-12-12T06:21:46+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bbd057257", "title": "Geometry Validity and Method Access", "url": "https://www.spdba.com.au/geometry-validity-and-method-access/", "published_at": "2020-12-06T01:26:43+00:00" }, { "id": "01a0d19c-911f-7305-b7bf-685bbd6b58b6", "title": "Linear Referencing System (LRS) Functions for TSQL", "url": "https://www.spdba.com.au/linear-referencing-system-lrs-functions-for-tsql/", "published_at": "2020-12-05T21:28:33+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b17bc6839", "title": "My Services", "url": "https://www.spdba.com.au/my-services/", "published_at": "2020-12-04T01:46:35+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b186c6c18", "title": "Pseudo Array Implementation for SQL Server Spatial (Part 2)", "url": "https://www.spdba.com.au/pseudo-array-implementation-for-sql-server-spatial-part-2/", "published_at": "2020-11-30T05:36:28+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b18981041", "title": "CheckRadii: Identifying Tight Radius Curves sections within LineString geometry data", "url": "https://www.spdba.com.au/checkradii-identifying-tight-radius-curves-sections-within-linestring-geometry-data/", "published_at": "2020-11-30T04:58:15+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b18bab044", "title": "The Sad State of GIS SQL Standards", "url": "https://www.spdba.com.au/the-sad-state-of-gis-sql-standards/", "published_at": "2020-11-30T02:00:09+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b18c6bb1a", "title": "Overlaying Polygons in SQL Server Spatial", "url": "https://www.spdba.com.au/overlaying-polygons-in-sql-server-spatial/", "published_at": "2020-11-25T03:07:14+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b18e8965b", "title": "Oracle Spatial Mapping and Map Rendering Performance Tips", "url": "https://www.spdba.com.au/oracle-spatial-mapping-and-map-rendering-performance-tips/", "published_at": "2020-11-23T05:40:47+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b192adaa5", "title": "Space Filling Curve Functions For TSQL", "url": "https://www.spdba.com.au/space-filling-curve-functions-for-tsql/", "published_at": "2020-11-21T20:32:34+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b1939b001", "title": "Bing Maps Tile System Functions for TSQL", "url": "https://www.spdba.com.au/bing-maps-tile-system-functions-for-tsql/", "published_at": "2020-11-19T05:48:52+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b19ee8c09", "title": "Experience With GIS Desktop Software", "url": "https://www.spdba.com.au/experience-with-gis-desktop-software/", "published_at": "2020-11-19T05:26:10+00:00" }, { "id": "01a0d19c-dd2f-70c6-8f23-539b1ad2d1d5", "title": "Geocoding Points Against a Grid of Cells/Tiles With/out Spatial Operators", "url": "https://www.spdba.com.au/geocoding-points-against-a-grid-of-cells-tiles-with-out-spatial-operators/", "published_at": "2020-11-19T04:30:56+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e89ba0f4b8", "title": "Using a GeometryCollection as an Array for TSQL (Stored Procedure) Development.", "url": "https://www.spdba.com.au/using-a-geometrycollection-as-an-array-for-tsql-stored-procedure-development/", "published_at": "2020-11-06T00:14:14+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e89c8d3003", "title": "The Frontage Problem: Creating references from land parcel street frontage boundary to point in street", "url": "https://www.spdba.com.au/the-frontage-problem-creating-references-from-land-parcel-street-frontage-boundary-to-point-in-street/", "published_at": "2020-11-03T03:03:54+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e89d103be4", "title": "Create GeoJSON Document from Selection of SDO_Geometry objects.", "url": "https://www.spdba.com.au/create-geojson-document-from-selection-of-sdo_geometry-objects/", "published_at": "2020-10-30T02:16:18+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e89ddad303", "title": "Identifying Quadrilateral Polygon Geometries in SQL Server Spatial", "url": "https://www.spdba.com.au/identifying-quadrilateral-geometric-shapes-in-sql-server-spatial/", "published_at": "2020-10-16T02:20:18+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e89e3eda99", "title": "STLineToCurve. A Function that Converts a LineString to a CircularString, CompoundCurve or CurvePolygon.", "url": "https://www.spdba.com.au/stlinetocurve-converting-a-linestring-to-a-circularstring-or-compoundcurve/", "published_at": "2020-10-15T04:45:38+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e89f323081", "title": "Processing GML data using PostgreSQL’s XMLTABLE", "url": "https://www.spdba.com.au/processing-gml-data-using-postgresqls-xmltable/", "published_at": "2020-10-01T02:42:27+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e89fb8e5b7", "title": "STInsertN: Insert single vertex into a geometry", "url": "https://www.spdba.com.au/stinsertn-insert-single-vertex-into-a-geometry/", "published_at": "2020-08-07T05:20:18+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e8a0894b0b", "title": "STUpdateN: Update (replace) a single vertex within a geometry object.", "url": "https://www.spdba.com.au/stupdaten-update-replace-a-single-vertex-within-a-geometry-object/", "published_at": "2020-08-07T05:16:18+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e8a13fc30f", "title": "STUpdate: Replace all points equal to the supplied point with replacement point.", "url": "https://www.spdba.com.au/stupdate-replace-all-points-equal-to-the-supplied-point-with-replacement-point/", "published_at": "2020-08-07T05:12:45+00:00" }, { "id": "01a0d19d-3082-70d1-b18e-95e8a1f06961", "title": "STDeleteN: Delete single vertex from geometry", "url": "https://www.spdba.com.au/stdeleten-delete-single-vertex-from-geometry/", "published_at": "2020-08-07T05:06:40+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0ab9c6d41d", "title": "STDelete: Deleting vertices in geometry objects", "url": "https://www.spdba.com.au/stdelete-deleting-vertices-in-geometry-objects/", "published_at": "2020-08-07T05:01:59+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0aba41de9d", "title": "Using Oracle’s ST_GEOMETRY type hierarchy with SDO_GEOMETRY: ST_PointN and ST_NumPoints", "url": "https://www.spdba.com.au/using-oracles-st_geometry-type-hierarchy-with-sdo_geometry-st_pointn-and-st_numpoints/", "published_at": "2020-08-07T04:55:59+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0aba53c073", "title": "PostGIS: Creating a line inside a polygon", "url": "https://www.spdba.com.au/postgis-creating-a-line-inside-a-polygon/", "published_at": "2020-08-07T04:51:44+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0abaed0274", "title": "Spatial Representation of a Communications Pit", "url": "https://www.spdba.com.au/spatial-representation-of-a-communications-pit/", "published_at": "2020-08-07T04:47:54+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0abb2c93ca", "title": "Urban Trees Data Model", "url": "https://www.spdba.com.au/data-models-computerised-tree-inventory-system/", "published_at": "2020-08-07T04:08:52+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0abb7c1be5", "title": "PGAdmin Finally Has A Spatial Viewer", "url": "https://www.spdba.com.au/pgadmin-finally-has-a-spatial-viewer/", "published_at": "2020-08-07T04:06:35+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0abc0307ab", "title": "Scheduling the Export of Spatial Data in Oracle to a Shapefile each night", "url": "https://www.spdba.com.au/scheduling-the-export-of-spatial-data-in-oracle-to-a-shapefile-each-night/", "published_at": "2020-08-05T07:32:22+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0abc74a97e", "title": "ST_Densify for Object PLSQL", "url": "https://www.spdba.com.au/st_densify-for-object-plsql/", "published_at": "2020-08-05T07:23:03+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0abd567d64", "title": "PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)", "url": "https://www.spdba.com.au/plsql-st_asewkt-and-st_fromwkt-functions-for-oracle-any-version/", "published_at": "2020-08-05T07:19:08+00:00" }, { "id": "01a0d19d-7422-7020-9b3e-9f0abda75fbc", "title": "STFlipVectors: Normalize direction of linestring vectors", "url": "https://www.spdba.com.au/stflipvectors-normalize-direction-of-linestring-vectors/", "published_at": "2020-08-05T07:08:50+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec1fe736983", "title": "STConvertToLineString: Extract LineStrings in GeometryCollection to create LineString", "url": "https://www.spdba.com.au/stconverttolinestring-extract-linestrings-in-geometrycollection-to-create-linestring/", "published_at": "2020-08-05T07:04:57+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec1fed1f9d6", "title": "STCogo2Line: Creating (Multi)LineStrings geometries from COGO XML instructions", "url": "https://www.spdba.com.au/stcogo2line-creating-multilinestrings-geometries-from-cogo-xml-instructions/", "published_at": "2020-08-05T07:02:21+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec1ffa68a2e", "title": "STLine2Cogo: Converting LineStrings to COGO XML", "url": "https://www.spdba.com.au/stline2cogo-converting-linestrings-to-cogo-xml/", "published_at": "2020-08-05T06:57:21+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec2009a84e8", "title": "Support for ESRI’s ST_GEOMETRY", "url": "https://www.spdba.com.au/support-for-esris-st_geometry/", "published_at": "2020-08-05T06:52:44+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec2016b3e96", "title": "Spatial Functions for MySQL", "url": "https://www.spdba.com.au/spatial-functions-for-mysql/", "published_at": "2020-08-05T06:50:19+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec202137153", "title": "ST_Round for MySQL Spatial", "url": "https://www.spdba.com.au/st_round-for-mysql-spatial/", "published_at": "2020-08-05T06:49:17+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec202867070", "title": "ST_Scale for MySQL Spatial", "url": "https://www.spdba.com.au/st_scale-for-mysql-spatial/", "published_at": "2020-08-05T06:46:44+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec2031fde3f", "title": "ST_Rotate for MySQL Spatial", "url": "https://www.spdba.com.au/st_rotate-for-mysql-spatial/", "published_at": "2020-08-05T06:44:19+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec2032635f2", "title": "ST_Move for MySQL Spatial", "url": "https://www.spdba.com.au/st_move-for-mysql-spatial/", "published_at": "2020-08-05T05:38:19+00:00" }, { "id": "01a0d19d-ac42-739d-a55a-3ec203afb09f", "title": "Using Range Querying to Filter LineString Segments", "url": "https://www.spdba.com.au/querying-ranged-variables/", "published_at": "2020-08-05T05:33:36+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-01779cabddb4", "title": "Tip: Drop that Spatial Index!", "url": "https://www.spdba.com.au/tip-drop-that-spatial-index/", "published_at": "2020-08-05T05:28:34+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-01779d5f3042", "title": "Convert Single Geometry to Multi-part Geometry in Oracle Spatial", "url": "https://www.spdba.com.au/convert-single-geometry-to-multi-part-geometry-in-oracle-spatial/", "published_at": "2020-08-05T05:25:00+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-01779dfdbce2", "title": "Optimized Rectangle to 5 Point Polygon", "url": "https://www.spdba.com.au/optimized-rectangle-to-5-point-polygon/", "published_at": "2020-08-05T05:14:28+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-01779e4ca799", "title": "Centroid Package now supports Y ordinate seeding", "url": "https://www.spdba.com.au/centroid-package-now-supports-y-ordinate-seeding/", "published_at": "2020-08-05T05:08:27+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-01779efd3ff3", "title": "STVectorize: Break Linestring/Polygon elements into 2 point vectors (or 3 point circular curves)", "url": "https://www.spdba.com.au/stvectorize-break-linestring-polygon-elements-into-2-point-vectors-or-3-point-circular-curves/", "published_at": "2020-08-05T05:05:06+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-01779fd3618f", "title": "Spatial Database Training Courses", "url": "https://www.spdba.com.au/spatial-database-training-courses/", "published_at": "2020-08-05T04:57:47+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-01779ffe7bfc", "title": "Convert GeoJSON document to Sdo_Geometry objects", "url": "https://www.spdba.com.au/convert-geojson-document-to-sdo_geometry-objects/", "published_at": "2020-08-05T04:56:07+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-0177a0f2087f", "title": "Simple Implementation Of Travelling Salesman Problem", "url": "https://www.spdba.com.au/simple-implementation-of-travelling-salesman-problem/", "published_at": "2020-08-05T04:48:25+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-0177a1937c85", "title": "Create Polygons and Linestrings From Bearings And Distances (COGO)", "url": "https://www.spdba.com.au/create-polygons-and-linestrings-from-bearings-and-distances-cogo/", "published_at": "2020-08-05T04:43:18+00:00" }, { "id": "01a0d19d-e0ff-7367-8fa1-0177a20b1e95", "title": "Function That Returns a Compass Point From a Whole Circle Bearing", "url": "https://www.spdba.com.au/function-that-returns-a-compass-point-from-a-whole-circle-bearing/", "published_at": "2020-08-05T04:35:51+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fd7a16ca3", "title": "Playing around with Centroids by using different seed values", "url": "https://www.spdba.com.au/playing-around-with-centroids-by-using-different-seed-values/", "published_at": "2020-08-05T04:29:26+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fd811727a", "title": "Simple Oracle C Sprintf or Java String.format", "url": "https://www.spdba.com.au/simple-oracle-c-sprintf-or-java-string-format/", "published_at": "2020-08-05T04:23:51+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fd8ed4dd7", "title": "Some Oriented Point Functions", "url": "https://www.spdba.com.au/some-oriented-point-functions/", "published_at": "2020-08-05T04:15:16+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fd942fe51", "title": "Extracting Inner Rings Changed Ordinate Ordering: A Trap For Players Who Don’t Read Documentation!", "url": "https://www.spdba.com.au/extracting-inner-rings-changed-ordinate-ordering-a-trap-for-players-who-dont-read-documentation/", "published_at": "2020-08-05T04:11:02+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fda07f771", "title": "PLS-00306: wrong number or types of arguments in call to ‘SDO_GEOMETRY’", "url": "https://www.spdba.com.au/pls-00306-wrong-number-or-types-of-arguments-in-call-to-sdo_geometry/", "published_at": "2020-08-05T04:06:09+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fda0d9fe5", "title": "New versions of LINEAR, CENTROID and GEOM etc packages", "url": "https://www.spdba.com.au/new-versions-of-linear-centroid-and-geom-etc-packages/", "published_at": "2020-08-05T03:54:55+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fda37c087", "title": "TESSELATE and CENTROID package updates", "url": "https://www.spdba.com.au/tesselate-and-centroid-package-updates/", "published_at": "2020-08-05T03:45:32+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fdabd6531", "title": "Oracle Business Intelligence Warehousing and Analytics – Spatial Summit", "url": "https://www.spdba.com.au/oracle-business-intelligence-warehousing-and-analytics-spatial-summit/", "published_at": "2020-08-05T03:40:18+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fdac26748", "title": "How far inside, is inside? Measuring actual distance.", "url": "https://www.spdba.com.au/how-far-inside-is-inside-measuring-actual-distance/", "published_at": "2020-08-05T03:36:35+00:00" }, { "id": "01a0d19e-0b44-7331-ba0c-db2fdb78d63b", "title": "Noding and building a polygon from single, overlapping linestrings", "url": "https://www.spdba.com.au/noding-and-building-a-polygon-from-single-overlapping-linestrings/", "published_at": "2020-08-05T03:32:01+00:00" } ] posts Claim your blog
Back to spdba.com.au
Blog · corpus.blog/blogs/spdba.com.au/posts

spdba.com.au

spdba.com.au

2026

Generating Road LineStrings with Z (Elevation) through processing involving a Tasmanian statewide Digital Elevation Model (DEM)original ↗
4 Sept 2026
Best Practice when Loading geographic Polygons into SQL Server Spatial geometry columnoriginal ↗
2 Sept 2026

2024

OptimoRouteoriginal ↗
27 May 2024
Functions to Convert Native PostgreSQL geometric types to PostGISoriginal ↗
18 May 2024
Converting PostgreSQL Native Geometric Types to PostGISoriginal ↗
17 May 2024
Fitting Bezier Polygon to Pointsoriginal ↗
30 Apr 2024

2022

Fixing Geography Ring Orientationoriginal ↗
30 Dec 2022
Calculating Distance in the Lambert Conformal Conic projection vs WGS84/GDA94original ↗
5 Jul 2022
Killer Dataoriginal ↗
14 May 2022
Delaunay Triangulation Function for TSQL and SQL Server Spatialoriginal ↗
18 Apr 2022
Creating linestring geometries from a table of ordinates (SQL Server)original ↗
18 Apr 2022
Creating linestring geometries from a table of ordinates (Oracle)original ↗
18 Apr 2022
Partition Spatial Data using SQL Serveroriginal ↗
13 Apr 2022
Removing Spikes in SQL Server Spatial Linestringsoriginal ↗
7 Apr 2022
Geometry Storage Formatoriginal ↗
7 Apr 2022
How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roadsoriginal ↗
21 Mar 2022

2021

qGIS, GEOMETRY_COLUMNS and SQL Server Spatialoriginal ↗
3 Nov 2021
Removing Duplicate Vertices in SQL Server Spatialoriginal ↗
23 Oct 2021
Visualising the Topological Relations of LineStringsoriginal ↗
17 Sept 2021
Object Implementation of Oracle SDO_LRSoriginal ↗
5 Jul 2021
Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2)original ↗
30 Jun 2021
Split Oracle Sdo_Geometry Linestring at a Known Point using PL/SQL (1)original ↗
30 Jun 2021
GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objectsoriginal ↗
28 Jun 2021
Snapping a Point to an Oracle Spatial SDO_GEOMETRY LineStringoriginal ↗
26 Jun 2021
GeoRaptor: Layer Propertiesoriginal ↗
31 May 2021
GeoRaptor: Exporting GeoJSON and viewing in Tatuk GIS Vieweroriginal ↗
26 May 2021
GeoRaptor: Exporting GML and visualising in qGISoriginal ↗
20 May 2021
GeoRaptor: Area Rendering Optionsoriginal ↗
5 May 2021
GeoRaptor: Views and On The Fly Projectionoriginal ↗
24 Apr 2021
GeoRaptor: Metadata Managementoriginal ↗
24 Apr 2021
GeoRaptor: Importing a Shapefile into a tableoriginal ↗
23 Apr 2021
GeoRaptor: Simple Mappingoriginal ↗
23 Apr 2021
GeoRaptor: Visualising Geometry Objectsoriginal ↗
22 Apr 2021
GeoRaptor: Working with xxx_SDO_GEOM_METADATA records.original ↗
22 Apr 2021
GeoRaptor 18+: Downloading and Installing betaoriginal ↗
7 Apr 2021
Oracle 21c: Locator is no moreoriginal ↗
17 Jan 2021
Oracle Spatial Vector Acceleration: Flick the Switchoriginal ↗
17 Jan 2021

2020

Geometry object size when exchanging of WKT/WKB encoded geometries.original ↗
12 Dec 2020
Geometry Validity and Method Accessoriginal ↗
6 Dec 2020
Linear Referencing System (LRS) Functions for TSQLoriginal ↗
5 Dec 2020
My Servicesoriginal ↗
4 Dec 2020
Pseudo Array Implementation for SQL Server Spatial (Part 2)original ↗
30 Nov 2020
CheckRadii: Identifying Tight Radius Curves sections within LineString geometry dataoriginal ↗
30 Nov 2020
The Sad State of GIS SQL Standardsoriginal ↗
30 Nov 2020
Overlaying Polygons in SQL Server Spatialoriginal ↗
25 Nov 2020
Oracle Spatial Mapping and Map Rendering Performance Tipsoriginal ↗
23 Nov 2020
Space Filling Curve Functions For TSQLoriginal ↗
21 Nov 2020
Bing Maps Tile System Functions for TSQLoriginal ↗
19 Nov 2020
Experience With GIS Desktop Softwareoriginal ↗
19 Nov 2020
Geocoding Points Against a Grid of Cells/Tiles With/out Spatial Operatorsoriginal ↗
19 Nov 2020
Using a GeometryCollection as an Array for TSQL (Stored Procedure) Development.original ↗
6 Nov 2020
The Frontage Problem: Creating references from land parcel street frontage boundary to point in streetoriginal ↗
3 Nov 2020
Create GeoJSON Document from Selection of SDO_Geometry objects.original ↗
30 Oct 2020
Identifying Quadrilateral Polygon Geometries in SQL Server Spatialoriginal ↗
16 Oct 2020
STLineToCurve. A Function that Converts a LineString to a CircularString, CompoundCurve or CurvePolygon.original ↗
15 Oct 2020
Processing GML data using PostgreSQL’s XMLTABLEoriginal ↗
1 Oct 2020
STInsertN: Insert single vertex into a geometryoriginal ↗
7 Aug 2020
STUpdateN: Update (replace) a single vertex within a geometry object.original ↗
7 Aug 2020
STUpdate: Replace all points equal to the supplied point with replacement point.original ↗
7 Aug 2020
STDeleteN: Delete single vertex from geometryoriginal ↗
7 Aug 2020
STDelete: Deleting vertices in geometry objectsoriginal ↗
7 Aug 2020
Using Oracle’s ST_GEOMETRY type hierarchy with SDO_GEOMETRY: ST_PointN and ST_NumPointsoriginal ↗
7 Aug 2020
PostGIS: Creating a line inside a polygonoriginal ↗
7 Aug 2020
Spatial Representation of a Communications Pitoriginal ↗
7 Aug 2020
Urban Trees Data Modeloriginal ↗
7 Aug 2020
PGAdmin Finally Has A Spatial Vieweroriginal ↗
7 Aug 2020
Scheduling the Export of Spatial Data in Oracle to a Shapefile each nightoriginal ↗
5 Aug 2020
ST_Densify for Object PLSQLoriginal ↗
5 Aug 2020
PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)original ↗
5 Aug 2020
STFlipVectors: Normalize direction of linestring vectorsoriginal ↗
5 Aug 2020
STConvertToLineString: Extract LineStrings in GeometryCollection to create LineStringoriginal ↗
5 Aug 2020
STCogo2Line: Creating (Multi)LineStrings geometries from COGO XML instructionsoriginal ↗
5 Aug 2020
STLine2Cogo: Converting LineStrings to COGO XMLoriginal ↗
5 Aug 2020
Support for ESRI’s ST_GEOMETRYoriginal ↗
5 Aug 2020
Spatial Functions for MySQLoriginal ↗
5 Aug 2020
ST_Round for MySQL Spatialoriginal ↗
5 Aug 2020
ST_Scale for MySQL Spatialoriginal ↗
5 Aug 2020
ST_Rotate for MySQL Spatialoriginal ↗
5 Aug 2020
ST_Move for MySQL Spatialoriginal ↗
5 Aug 2020
Using Range Querying to Filter LineString Segmentsoriginal ↗
5 Aug 2020
Tip: Drop that Spatial Index!original ↗
5 Aug 2020
Convert Single Geometry to Multi-part Geometry in Oracle Spatialoriginal ↗
5 Aug 2020
Optimized Rectangle to 5 Point Polygonoriginal ↗
5 Aug 2020
Centroid Package now supports Y ordinate seedingoriginal ↗
5 Aug 2020
STVectorize: Break Linestring/Polygon elements into 2 point vectors (or 3 point circular curves)original ↗
5 Aug 2020
Spatial Database Training Coursesoriginal ↗
5 Aug 2020
Convert GeoJSON document to Sdo_Geometry objectsoriginal ↗
5 Aug 2020
Simple Implementation Of Travelling Salesman Problemoriginal ↗
5 Aug 2020
Create Polygons and Linestrings From Bearings And Distances (COGO)original ↗
5 Aug 2020
Function That Returns a Compass Point From a Whole Circle Bearingoriginal ↗
5 Aug 2020
Playing around with Centroids by using different seed valuesoriginal ↗
5 Aug 2020
Simple Oracle C Sprintf or Java String.formatoriginal ↗
5 Aug 2020
Some Oriented Point Functionsoriginal ↗
5 Aug 2020
Extracting Inner Rings Changed Ordinate Ordering: A Trap For Players Who Don’t Read Documentation!original ↗
5 Aug 2020
PLS-00306: wrong number or types of arguments in call to ‘SDO_GEOMETRY’original ↗
5 Aug 2020
New versions of LINEAR, CENTROID and GEOM etc packagesoriginal ↗
5 Aug 2020
TESSELATE and CENTROID package updatesoriginal ↗
5 Aug 2020
Oracle Business Intelligence Warehousing and Analytics – Spatial Summitoriginal ↗
5 Aug 2020
How far inside, is inside? Measuring actual distance.original ↗
5 Aug 2020
Noding and building a polygon from single, overlapping linestringsoriginal ↗
5 Aug 2020
Next