corpus.blog
41554 blogs · [ { "id": "01a0d19e-34a9-7293-8ab0-9a0a469bfed0", "title": "ST_VertexN / ST_PointN – Extracting a specific point from any geometry", "url": "https://www.spdba.com.au/st_vertexn-st_pointn-extracting-a-specific-point-from-any-geometry/", "published_at": "2020-08-05T02:06:27+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a474ca6cf", "title": "Convert Single Point stored in SDO_ORDINATES to SDO_POINT_TYPE", "url": "https://www.spdba.com.au/convert-single-point-stored-in-sdo_ordinates-to-sdo_point_type/", "published_at": "2020-08-05T01:59:12+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a4783e742", "title": "Analyzing Spatial Query Performance Improvements in Oracle Spatial and Graph 12c Through Cross-Vendor Comparison", "url": "https://www.spdba.com.au/analyzing-spatial-query-performance-improvements-in-oracle-spatial-and-graph-12c-through-cross-vendor-comparison/", "published_at": "2020-08-05T01:54:33+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a47c65b9b", "title": "Aggregate APPEND Islands and XOR polygons", "url": "https://www.spdba.com.au/aggregate-append-islands-and-xor-polygons/", "published_at": "2020-08-05T01:52:19+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a481fdda2", "title": "Circular Arcs in Geodetic Polygons", "url": "https://www.spdba.com.au/circular-arcs-in-geodetic-polygons/", "published_at": "2020-08-05T01:48:36+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a4902a0a3", "title": "Some SDO_GEOMETRY/DIMINFO handling functions", "url": "https://www.spdba.com.au/some-sdo_geometry-diminfo-handling-functions/", "published_at": "2020-08-05T01:45:19+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a4947989a", "title": "Applying and Extending Oracle Spatial: Source Code Problem", "url": "https://www.spdba.com.au/applying-and-extending-oracle-spatial-source-code-problem/", "published_at": "2020-08-05T01:38:00+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a4a3e591f", "title": "PL/SQL Objects from “Applying and Extending Oracle Spatial”", "url": "https://www.spdba.com.au/pl-sql-objects-from-applying-and-extending-oracle-spatial/", "published_at": "2020-08-05T01:36:37+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a4af4c801", "title": "Book: “Applying And Extending Oracle Spatial”", "url": "https://www.spdba.com.au/book-applying-and-extending-oracle-spatial/", "published_at": "2020-08-05T01:35:05+00:00" }, { "id": "01a0d19e-34a9-7293-8ab0-9a0a4b70c1d3", "title": "Google Maps / Bing Maps Spherical Mercator Projection Information", "url": "https://www.spdba.com.au/google-maps-bing-maps-spherical-mercator-projection-information/", "published_at": "2020-08-05T01:33:26+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099a6dbb58", "title": "Changing all DIMINFO sdo_tolerance values for all metadata records in one go.", "url": "https://www.spdba.com.au/changing-all-diminfo-sdo_tolerance-values-for-all-metadata-records-in-one-go/", "published_at": "2020-08-05T01:31:18+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099abbd537", "title": "Building Polygons from Incomplete Linestrings using ST_PolygonBuilder", "url": "https://www.spdba.com.au/building-polygons-from-incomplete-linestrings-using-st_polygonbuilder/", "published_at": "2020-08-05T01:26:10+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099ad8d44c", "title": "Computing Cardinal Directions to nearby geometries", "url": "https://www.spdba.com.au/computing-cardinal-directions-to-nearby-geometries/", "published_at": "2020-08-05T01:21:57+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099b9b4762", "title": "Intersecting two aggregated polygon layers with SC4O", "url": "https://www.spdba.com.au/intersecting-two-aggregated-polygon-layers-with-sc4o/", "published_at": "2020-08-05T01:17:33+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099c381c1f", "title": "Silence is Golden?", "url": "https://www.spdba.com.au/silence-is-golden/", "published_at": "2020-08-05T01:12:02+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099cfa26e1", "title": "Drawing a layer in GeoRaptor: Simple Gotchas!", "url": "https://www.spdba.com.au/drawing-a-layer-in-georaptor-simple-gotchas/", "published_at": "2020-08-05T01:10:13+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099dd62c16", "title": "Spatial and Oracle 12c", "url": "https://www.spdba.com.au/spatial-and-oracle-12c/", "published_at": "2020-08-05T01:08:07+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099e9e7ab7", "title": "Update Triggers and SDO_GEOMETRY Equality", "url": "https://www.spdba.com.au/update-triggers-and-sdo_geometry-equality/", "published_at": "2020-08-05T01:06:15+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099eada730", "title": "Duplicate Geometry data and Data Models", "url": "https://www.spdba.com.au/duplicate-geometry-data-and-data-models/", "published_at": "2020-08-05T00:58:01+00:00" }, { "id": "01a0d19e-5c13-70e0-917c-93099edc2472", "title": "Generating a Grid (fishnet) of points or polygons for PostGIS", "url": "https://www.spdba.com.au/generating-a-grid-fishnet-of-points-or-polygons-for-postgis/", "published_at": "2020-08-05T00:52:48+00:00" }, { "id": "01a0d19e-865f-7305-8977-3409023c03a8", "title": "CENTROID package update", "url": "https://www.spdba.com.au/centroid-package-update/", "published_at": "2020-08-05T00:41:55+00:00" }, { "id": "01a0d19e-865f-7305-8977-3409029c7281", "title": "Useful Package of Wrapper Functions for Sdo_Util.AffineTransforms", "url": "https://www.spdba.com.au/useful-package-of-wrapper-functions-for-sdo_util-affinetransforms/", "published_at": "2020-07-31T06:59:05+00:00" }, { "id": "01a0d19e-865f-7305-8977-340902ad26bd", "title": "National Broadband Network, Spatial Data & Processing", "url": "https://www.spdba.com.au/national-broadband-network-spatial-data-processing/", "published_at": "2020-07-31T06:48:33+00:00" }, { "id": "01a0d19e-865f-7305-8977-340903311cb3", "title": "Compute Location from known Lat/Long point using delta easting and northing in miles", "url": "https://www.spdba.com.au/compute-location-from-known-lat-long-point-using-delta-easting-and-northing-in-miles/", "published_at": "2020-07-31T06:45:53+00:00" }, { "id": "01a0d19e-865f-7305-8977-34090359f7ca", "title": "Sorting SDO_GEOMETRY data using the ORDER BY clause of a SELECT statement", "url": "https://www.spdba.com.au/sorting-sdo_geometry-data-using-the-order-by-clause-of-a-select-statement/", "published_at": "2020-07-31T06:39:01+00:00" }, { "id": "01a0d19e-865f-7305-8977-34090376ec5a", "title": "SDO_AGGR_SET_UNION", "url": "https://www.spdba.com.au/sdo_aggr_set_union/", "published_at": "2020-07-31T06:30:19+00:00" }, { "id": "01a0d19e-865f-7305-8977-3409038739b7", "title": "R based Delaunay Triangulation Function for PostGIS using the deldir package", "url": "https://www.spdba.com.au/r-based-delaunay-triangulation-function-for-postgis-using-the-deldir-package/", "published_at": "2020-07-31T06:26:38+00:00" }, { "id": "01a0d19e-865f-7305-8977-34090458b0da", "title": "Rounding Coordinates or Ordinates in SDO_GEOMETRY", "url": "https://www.spdba.com.au/rounding-coordinates-or-ordinates-in-sdo_geometry/", "published_at": "2020-07-31T06:22:33+00:00" }, { "id": "01a0d19e-865f-7305-8977-340905360b82", "title": "STScale: Function to Scale a geometry object", "url": "https://www.spdba.com.au/stscale-function-to-scale-a-geometry-object/", "published_at": "2020-07-31T06:14:51+00:00" }, { "id": "01a0d19e-865f-7305-8977-34090556b282", "title": "STGeometry2MBR/STGeography2MBR: Compute and return MBR ordinates", "url": "https://www.spdba.com.au/stgeometry2mbr-stgeography2mbr-compute-and-return-mbr-ordinates/", "published_at": "2020-07-31T06:10:36+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7a8db42b7", "title": "Creating linestrings from points", "url": "https://www.spdba.com.au/creating-linestrings-from-points/", "published_at": "2020-07-31T05:39:53+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7a957bc6a", "title": "Effects of Sdo_Geometry Ordinate Precision on Performance", "url": "https://www.spdba.com.au/effects-of-sdo_geometry-ordinate-precision-on-performance/", "published_at": "2020-07-31T05:29:09+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7aa4368fe", "title": "The Spatial filtering of geometries: The effect of tolerances on relationships", "url": "https://www.spdba.com.au/the-spatial-filtering-of-geometries-the-effect-of-tolerances-on-relationships/", "published_at": "2020-07-31T05:23:24+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7aaa30aa2", "title": "Application of Delaunay Triangulation and Inverse Distance Weighting (IDW) in Oracle for Soils Interpolation", "url": "https://www.spdba.com.au/application-of-delaunay-triangulation-and-inverse-distance-weighting-idw-in-oracle-for-soils-interpolation/", "published_at": "2020-07-31T05:17:40+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7aae95728", "title": "Selecting all SDO_GTYPE values for all tables/sdo_geometry columns in a schema", "url": "https://www.spdba.com.au/selecting-all-sdo_gtype-values-for-all-tables-sdo_geometry-columns-in-a-schema/", "published_at": "2020-07-31T05:09:54+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7ab3e0154", "title": "CENTROID package – Tips for Use", "url": "https://www.spdba.com.au/centroid-package-tips-for-use/", "published_at": "2020-07-27T02:30:36+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7ac0144bd", "title": "Announcing the Spatial Companion For Oracle (SC4O)", "url": "https://www.spdba.com.au/announcing-the-spatial-companion-for-oracle-sc4o/", "published_at": "2020-07-27T02:27:42+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7ac04d17b", "title": "COGO: Converting Decimal Degrees to Degrees Minutes and Seconds – and back again (PostGIS)", "url": "https://www.spdba.com.au/cogo-converting-decimal-degrees-to-degrees-minutes-and-seconds-and-back-again-postgis/", "published_at": "2020-07-27T02:26:12+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7accc81be", "title": "COGO: Finding centre and radius of a curve defined by three points (PostGIS)", "url": "https://www.spdba.com.au/cogo-finding-centre-and-radius-of-a-curve-defined-by-three-points-postgis/", "published_at": "2020-07-27T02:00:10+00:00" }, { "id": "01a0d19e-bfb3-711f-9091-1df7acdd4f85", "title": "Splitting a polygon using one or more linestrings", "url": "https://www.spdba.com.au/splitting-a-polygon-using-one-or-more-linestrings/", "published_at": "2020-07-27T01:38:34+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa1ca93c4e", "title": "isValid, isSimple, Dimension and CoordDim methods for SDO_Geometry", "url": "https://www.spdba.com.au/isvalid-issimple-dimension-and-coorddim-methods-for-sdo_geometry/", "published_at": "2020-07-27T01:33:43+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa1ceb0e7a", "title": "Line Merging or Collecting lines together: ST_LineMerger", "url": "https://www.spdba.com.au/line-merging-or-collecting-lines-together-st_linemerger/", "published_at": "2020-07-27T01:31:12+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa1d1828eb", "title": "ST_DeleteVertex for Oracle SDO_Geometry based on Jaspa/JTS", "url": "https://www.spdba.com.au/st_deletevertex-for-oracle-sdo_geometry-based-on-jaspa-jts/", "published_at": "2020-07-27T01:27:19+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa1e156962", "title": "3D/4D and SRID aware Conversion functions for SDO_Geometry: WKT and EWKT", "url": "https://www.spdba.com.au/3d-4d-and-srid-aware-conversion-functions-for-sdo_geometry-wkt-and-ewkt/", "published_at": "2020-07-27T01:24:32+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa1ef620e9", "title": "Topological vs Non-Topological Simplification/Generalization of Aggregated Area Geometies in Oracle", "url": "https://www.spdba.com.au/topological-vs-non-topological-simplification-generalization-of-aggregated-area-geometies-in-oracle/", "published_at": "2020-07-27T01:21:15+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa1fb69634", "title": "Filtering very short linestrings via bitmap function index", "url": "https://www.spdba.com.au/filtering-very-short-linestrings-via-bitmap-function-index/", "published_at": "2020-07-27T01:17:24+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa1ff311b1", "title": "CENTROID For Oracle", "url": "https://www.spdba.com.au/centroid-for-oracle/", "published_at": "2020-07-27T01:13:04+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa20dc1cdf", "title": "STExtractPolygon: Extract Polygons from result of STIntersection in SQL Server Spatial", "url": "https://www.spdba.com.au/stextractpolygon-extract-polygons-from-result-of-stintersection-in-sql-server-spatial/", "published_at": "2020-07-27T01:06:19+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa218ca3bb", "title": "STRound: Function to round ordinates of a SQL Server Spatial geometry object", "url": "https://www.spdba.com.au/stround-function-to-round-ordinates-of-a-sql-server-spatial-geometry-object/", "published_at": "2020-07-27T00:58:59+00:00" }, { "id": "01a0d19e-ea75-723e-9d64-95aa2287b87a", "title": "STExtract: Extract elements of a geometry object", "url": "https://www.spdba.com.au/stextract-extract-elements-of-a-geometry-object/", "published_at": "2020-07-27T00:55:56+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-482904a61dd8", "title": "STNumRings: Counting number of polygon rings", "url": "https://www.spdba.com.au/stnumrings-counting-number-of-polygon-rings/", "published_at": "2020-07-27T00:45:04+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-4829054895f0", "title": "STFilterRings: Removing rings from Polygon based on area.", "url": "https://www.spdba.com.au/stfilterrings-removing-rings-from-polygon-based-on-area/", "published_at": "2020-07-27T00:41:52+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-482905e0c2f3", "title": "STMove: Function to Move a geometry object in SQL Server Spatial", "url": "https://www.spdba.com.au/stmove-function-to-move-a-geometry-object-in-sql-server-spatial/", "published_at": "2020-07-27T00:37:19+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-482906813cac", "title": "STCentroid*: Alternate Functions for Compute a Centroid", "url": "https://www.spdba.com.au/stcentroid-alternate-functions-for-compute-a-centroid/", "published_at": "2020-07-27T00:32:51+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-482906f3dc7d", "title": "STRotate: Function to rotate a geometry object in SQL Server Spatial", "url": "https://www.spdba.com.au/strotate-function-to-rotate-a-geometry-object-in-sql-server-spatial/", "published_at": "2020-07-27T00:23:11+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-4829070953aa", "title": "STVertices: Wrapper over STDumpPoints", "url": "https://www.spdba.com.au/stvertices-wrapper-over-stdumppoints/", "published_at": "2020-07-27T00:18:46+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-48290802d8ed", "title": "STMorton: Creating a Morton Number Space Key Value for Grid Cells", "url": "https://www.spdba.com.au/stmorton-creating-a-morton-number-space-key-value-for-grid-square/", "published_at": "2020-07-27T00:15:03+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-482908c3bd76", "title": "Gridding a sdo_geometry line/polygon object (Oracle)", "url": "https://www.spdba.com.au/gridding-a-sdo_geometry-line-polygon-object-oracle/", "published_at": "2020-07-27T00:06:43+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-482908c43eb1", "title": "Gridding a geometry object (PostGIS)", "url": "https://www.spdba.com.au/gridding-a-geometry-object-postgis/", "published_at": "2020-07-24T05:43:51+00:00" }, { "id": "01a0d19f-19c5-7084-8a43-482909236df9", "title": "Gridding a geometry or geography object (SQL Server Denali)", "url": "https://www.spdba.com.au/gridding-a-geometry-or-geography-object-sql-server-denali/", "published_at": "2020-07-24T05:37:31+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd53a650d3", "title": "Finding centre and radius of a circular geometry", "url": "https://www.spdba.com.au/finding-centre-and-radius-of-a-circular-geometry/", "published_at": "2020-07-24T05:31:43+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd53b1d3a5", "title": "Constraining geometry type for sdo_geometry column in a table.", "url": "https://www.spdba.com.au/constraining-geometry-type-for-sdo_geometry-column-in-a-table/", "published_at": "2020-07-24T05:26:59+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd541dffe0", "title": "Industry Best Practice?", "url": "https://www.spdba.com.au/industry-best-practice/", "published_at": "2020-07-24T05:23:12+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd54ddbcf8", "title": "The Power of Constraints and Indexes for Spatial Constraints: stopping duplicate points", "url": "https://www.spdba.com.au/the-power-of-constraints-and-indexes-for-spatial-constraints-stopping-duplicate-points/", "published_at": "2020-07-24T05:21:09+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd55d4e418", "title": "CASE Statements and SDO_GEOMETRY", "url": "https://www.spdba.com.au/case-statements-and-sdo_geometry/", "published_at": "2020-07-24T05:16:56+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd56896b61", "title": "CENTROID package use with ESRI’s sde.st_geometry", "url": "https://www.spdba.com.au/centroid-package-use-with-esris-sde-st_geometry/", "published_at": "2020-07-24T05:05:23+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd572cb9e4", "title": "Changes to CENTROID and TESSELATE packages", "url": "https://www.spdba.com.au/changes-to-centroid-and-tesselate-packages/", "published_at": "2020-07-24T04:59:04+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd5759230b", "title": "CENTROID Package now returns centroid of multi-linestring", "url": "https://www.spdba.com.au/centroid-package-now-returns-centroid-of-multi-linestring/", "published_at": "2020-07-24T04:56:52+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd57c70074", "title": "Replacement for SDO_GEOM.RELATE – ST_Relate based on JTS", "url": "https://www.spdba.com.au/replacement-for-sdo_geom-relate-st_relate-based-on-jts/", "published_at": "2020-07-24T04:51:48+00:00" }, { "id": "01a0d19f-40f8-7099-8f6a-26bd57dab45a", "title": "Changing Oracle Spatial Index Parameters on existing index", "url": "https://www.spdba.com.au/changing-oracle-spatial-index-parameters-on-existing-index/", "published_at": "2020-07-24T04:43:37+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b572f483b00", "title": "Writing Excel Spreadsheets files from within the Oracle database using Java and PL/SQL", "url": "https://www.spdba.com.au/writing-excel-spreadsheets-files-from-within-the-oracle-database-using-java-and-pl-sql/", "published_at": "2020-07-24T04:39:54+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b572f53e908", "title": "Writing xSV (eg csv) files from within the Oracle database using Java and PL/SQL", "url": "https://www.spdba.com.au/writing-xsv-eg-csv-files-from-within-the-oracle-database-using-java-and-pl-sql/", "published_at": "2020-07-24T02:11:03+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b57304f5c16", "title": "A simple spike finder for Spatial", "url": "https://www.spdba.com.au/a-simple-spike-finder-for-spatial-locator/", "published_at": "2020-07-24T02:06:19+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b57306611f0", "title": "On hinting spatial indexes", "url": "https://www.spdba.com.au/on-hinting-spatial-indexes/", "published_at": "2020-07-24T02:00:22+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b5731229b6e", "title": "RandomSearchByExtent: Random Search Procedure (2008 Spatial)", "url": "https://www.spdba.com.au/randomsearchbyextent-random-search-procedure-2008-spatial/", "published_at": "2020-07-24T01:56:57+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b5731c41d3c", "title": "Spatial Database Independence", "url": "https://www.spdba.com.au/spatial-database-independence/", "published_at": "2020-07-24T01:49:27+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b57321710d5", "title": "JTS Java class compilation for 11g and above", "url": "https://www.spdba.com.au/jts-java-class-compilation-for-11g-and-above/", "published_at": "2020-07-24T01:28:04+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b573284e5b6", "title": "Random Spatial Search Procedure", "url": "https://www.spdba.com.au/random-spatial-search-procedure/", "published_at": "2020-07-24T01:24:07+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b5732d6cc64", "title": "Geometry Snapping using JTS in Oracle", "url": "https://www.spdba.com.au/geometry-snapping-using-jts-in-oracle/", "published_at": "2020-07-24T01:19:03+00:00" }, { "id": "01a0d19f-6f1c-72df-a977-3b57337d3a58", "title": "Exposing JTS’s MinimumBoundingCircle functionality", "url": "https://www.spdba.com.au/exposing-jtss-minimumboundingcircle-functionality/", "published_at": "2020-07-22T06:36:36+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-906826a818ab", "title": "Exposing JTS’s Densifier functionality", "url": "https://www.spdba.com.au/exposing-jtss-densifier-functionality/", "published_at": "2020-07-22T06:26:44+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-9068279fbe44", "title": "Using JTS’s Comparison Functions – HausdorffSimilarityMeasure & AreaSimilarityMeasure with SDO_GEOMETRY", "url": "https://www.spdba.com.au/using-jtss-comparison-functions-hausdorffsimilaritymeasure-areasimilaritymeasure-with-sdo_geometry/", "published_at": "2020-07-22T06:22:26+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-90682899ce11", "title": "Free JTS-based Area/Length Functions", "url": "https://www.spdba.com.au/free-jts-based-area-length-functions/", "published_at": "2020-07-22T06:15:49+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-906828cfc5af", "title": "Handy way of systematically fixing polygon geometries with 13349 and other errors", "url": "https://www.spdba.com.au/handy-way-of-systematically-fixing-polygon-geometries-with-13349-and-other-errors/", "published_at": "2020-07-22T06:11:25+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-9068299ec171", "title": "Standalone CENTROID package now available for download", "url": "https://www.spdba.com.au/standalone-centroid-package-now-available-for-download/", "published_at": "2020-07-22T05:54:21+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-906829ea2e7d", "title": "Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 4 Processing Geodetic data", "url": "https://www.spdba.com.au/free-union-intersection-xor-and-difference-functions-for-oracle-locator-part-4-processing-geodetic-data/", "published_at": "2020-07-22T05:51:00+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-90682a02ba59", "title": "New versions of PL/SQL packages uploaded", "url": "https://www.spdba.com.au/new-versions-of-pl-sql-packages-uploaded/", "published_at": "2020-07-22T05:43:11+00:00" }, { "id": "01a0d19f-9b60-73a6-a11b-90682a2b8fb1", "title": "Configurable Buffer: JTS and Oracle", "url": "https://www.spdba.com.au/configurable-buffer-jts-and-oracle/", "published_at": "2020-07-22T05:41:37+00:00" }, { "id": "01a0d19f-9b61-7122-80b0-69e7e0ecd9f9", "title": "Spatial Companion For Oracle (SC4O)", "url": "https://www.spdba.com.au/spatial-companion-for-oracle-sc4o/", "published_at": "2020-07-22T05:28:45+00:00" }, { "id": "01a0d19f-9b61-7122-80b0-69e7e130a653", "title": "Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 3", "url": "https://www.spdba.com.au/free-union-intersection-xor-and-difference-functions-for-oracle-locator-part-3/", "published_at": "2020-07-22T05:13:04+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-3831276ba7c5", "title": "Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 2", "url": "https://www.spdba.com.au/free-union-intersection-xor-and-difference-functions-for-oracle-locator-part-2/", "published_at": "2020-07-22T05:05:02+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-383127cfa197", "title": "NETWORK", "url": "https://www.spdba.com.au/network/", "published_at": "2020-07-22T05:00:50+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-38312845c661", "title": "TOOLS", "url": "https://www.spdba.com.au/tools/", "published_at": "2020-07-22T04:58:43+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-383128647b63", "title": "KML", "url": "https://www.spdba.com.au/kml/", "published_at": "2020-07-21T03:37:34+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-383128fb07a8", "title": "COGO", "url": "https://www.spdba.com.au/cogo/", "published_at": "2020-07-21T03:30:38+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-383129155ffe", "title": "GEOM", "url": "https://www.spdba.com.au/geom/", "published_at": "2020-07-21T03:25:20+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-383129e3053f", "title": "LINEAR (LRS)", "url": "https://www.spdba.com.au/linear-lrs/", "published_at": "2020-07-21T03:11:47+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-38312ab1ad60", "title": "SDO_ERROR", "url": "https://www.spdba.com.au/sdo_error/", "published_at": "2020-07-21T02:47:18+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-38312b1879a0", "title": "CENTROID", "url": "https://www.spdba.com.au/centroid/", "published_at": "2020-07-21T02:40:12+00:00" }, { "id": "01a0d19f-cf2e-71ae-9c72-38312bf30a10", "title": "Building Lines into Polygons in Oracle Locator / Spatial", "url": "https://www.spdba.com.au/building-lines-into-polygons-in-oracle-locator-spatial/", "published_at": "2020-07-21T02:28:22+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

2020

ST_VertexN / ST_PointN – Extracting a specific point from any geometryoriginal ↗
5 Aug 2020
Convert Single Point stored in SDO_ORDINATES to SDO_POINT_TYPEoriginal ↗
5 Aug 2020
Analyzing Spatial Query Performance Improvements in Oracle Spatial and Graph 12c Through Cross-Vendor Comparisonoriginal ↗
5 Aug 2020
Aggregate APPEND Islands and XOR polygonsoriginal ↗
5 Aug 2020
Circular Arcs in Geodetic Polygonsoriginal ↗
5 Aug 2020
Some SDO_GEOMETRY/DIMINFO handling functionsoriginal ↗
5 Aug 2020
Applying and Extending Oracle Spatial: Source Code Problemoriginal ↗
5 Aug 2020
PL/SQL Objects from “Applying and Extending Oracle Spatial”original ↗
5 Aug 2020
Book: “Applying And Extending Oracle Spatial”original ↗
5 Aug 2020
Google Maps / Bing Maps Spherical Mercator Projection Informationoriginal ↗
5 Aug 2020
Changing all DIMINFO sdo_tolerance values for all metadata records in one go.original ↗
5 Aug 2020
Building Polygons from Incomplete Linestrings using ST_PolygonBuilderoriginal ↗
5 Aug 2020
Computing Cardinal Directions to nearby geometriesoriginal ↗
5 Aug 2020
Intersecting two aggregated polygon layers with SC4Ooriginal ↗
5 Aug 2020
Silence is Golden?original ↗
5 Aug 2020
Drawing a layer in GeoRaptor: Simple Gotchas!original ↗
5 Aug 2020
Spatial and Oracle 12coriginal ↗
5 Aug 2020
Update Triggers and SDO_GEOMETRY Equalityoriginal ↗
5 Aug 2020
Duplicate Geometry data and Data Modelsoriginal ↗
5 Aug 2020
Generating a Grid (fishnet) of points or polygons for PostGISoriginal ↗
5 Aug 2020
CENTROID package updateoriginal ↗
5 Aug 2020
Useful Package of Wrapper Functions for Sdo_Util.AffineTransformsoriginal ↗
31 Jul 2020
National Broadband Network, Spatial Data & Processingoriginal ↗
31 Jul 2020
Compute Location from known Lat/Long point using delta easting and northing in milesoriginal ↗
31 Jul 2020
Sorting SDO_GEOMETRY data using the ORDER BY clause of a SELECT statementoriginal ↗
31 Jul 2020
SDO_AGGR_SET_UNIONoriginal ↗
31 Jul 2020
R based Delaunay Triangulation Function for PostGIS using the deldir packageoriginal ↗
31 Jul 2020
Rounding Coordinates or Ordinates in SDO_GEOMETRYoriginal ↗
31 Jul 2020
STScale: Function to Scale a geometry objectoriginal ↗
31 Jul 2020
STGeometry2MBR/STGeography2MBR: Compute and return MBR ordinatesoriginal ↗
31 Jul 2020
Creating linestrings from pointsoriginal ↗
31 Jul 2020
Effects of Sdo_Geometry Ordinate Precision on Performanceoriginal ↗
31 Jul 2020
The Spatial filtering of geometries: The effect of tolerances on relationshipsoriginal ↗
31 Jul 2020
Application of Delaunay Triangulation and Inverse Distance Weighting (IDW) in Oracle for Soils Interpolationoriginal ↗
31 Jul 2020
Selecting all SDO_GTYPE values for all tables/sdo_geometry columns in a schemaoriginal ↗
31 Jul 2020
CENTROID package – Tips for Useoriginal ↗
27 Jul 2020
Announcing the Spatial Companion For Oracle (SC4O)original ↗
27 Jul 2020
COGO: Converting Decimal Degrees to Degrees Minutes and Seconds – and back again (PostGIS)original ↗
27 Jul 2020
COGO: Finding centre and radius of a curve defined by three points (PostGIS)original ↗
27 Jul 2020
Splitting a polygon using one or more linestringsoriginal ↗
27 Jul 2020
isValid, isSimple, Dimension and CoordDim methods for SDO_Geometryoriginal ↗
27 Jul 2020
Line Merging or Collecting lines together: ST_LineMergeroriginal ↗
27 Jul 2020
ST_DeleteVertex for Oracle SDO_Geometry based on Jaspa/JTSoriginal ↗
27 Jul 2020
3D/4D and SRID aware Conversion functions for SDO_Geometry: WKT and EWKToriginal ↗
27 Jul 2020
Topological vs Non-Topological Simplification/Generalization of Aggregated Area Geometies in Oracleoriginal ↗
27 Jul 2020
Filtering very short linestrings via bitmap function indexoriginal ↗
27 Jul 2020
CENTROID For Oracleoriginal ↗
27 Jul 2020
STExtractPolygon: Extract Polygons from result of STIntersection in SQL Server Spatialoriginal ↗
27 Jul 2020
STRound: Function to round ordinates of a SQL Server Spatial geometry objectoriginal ↗
27 Jul 2020
STExtract: Extract elements of a geometry objectoriginal ↗
27 Jul 2020
STNumRings: Counting number of polygon ringsoriginal ↗
27 Jul 2020
STFilterRings: Removing rings from Polygon based on area.original ↗
27 Jul 2020
STMove: Function to Move a geometry object in SQL Server Spatialoriginal ↗
27 Jul 2020
STCentroid*: Alternate Functions for Compute a Centroidoriginal ↗
27 Jul 2020
STRotate: Function to rotate a geometry object in SQL Server Spatialoriginal ↗
27 Jul 2020
STVertices: Wrapper over STDumpPointsoriginal ↗
27 Jul 2020
STMorton: Creating a Morton Number Space Key Value for Grid Cellsoriginal ↗
27 Jul 2020
Gridding a sdo_geometry line/polygon object (Oracle)original ↗
27 Jul 2020
Gridding a geometry object (PostGIS)original ↗
24 Jul 2020
Gridding a geometry or geography object (SQL Server Denali)original ↗
24 Jul 2020
Finding centre and radius of a circular geometryoriginal ↗
24 Jul 2020
Constraining geometry type for sdo_geometry column in a table.original ↗
24 Jul 2020
Industry Best Practice?original ↗
24 Jul 2020
The Power of Constraints and Indexes for Spatial Constraints: stopping duplicate pointsoriginal ↗
24 Jul 2020
CASE Statements and SDO_GEOMETRYoriginal ↗
24 Jul 2020
CENTROID package use with ESRI’s sde.st_geometryoriginal ↗
24 Jul 2020
Changes to CENTROID and TESSELATE packagesoriginal ↗
24 Jul 2020
CENTROID Package now returns centroid of multi-linestringoriginal ↗
24 Jul 2020
Replacement for SDO_GEOM.RELATE – ST_Relate based on JTSoriginal ↗
24 Jul 2020
Changing Oracle Spatial Index Parameters on existing indexoriginal ↗
24 Jul 2020
Writing Excel Spreadsheets files from within the Oracle database using Java and PL/SQLoriginal ↗
24 Jul 2020
Writing xSV (eg csv) files from within the Oracle database using Java and PL/SQLoriginal ↗
24 Jul 2020
A simple spike finder for Spatialoriginal ↗
24 Jul 2020
On hinting spatial indexesoriginal ↗
24 Jul 2020
RandomSearchByExtent: Random Search Procedure (2008 Spatial)original ↗
24 Jul 2020
Spatial Database Independenceoriginal ↗
24 Jul 2020
JTS Java class compilation for 11g and aboveoriginal ↗
24 Jul 2020
Random Spatial Search Procedureoriginal ↗
24 Jul 2020
Geometry Snapping using JTS in Oracleoriginal ↗
24 Jul 2020
Exposing JTS’s MinimumBoundingCircle functionalityoriginal ↗
22 Jul 2020
Exposing JTS’s Densifier functionalityoriginal ↗
22 Jul 2020
Using JTS’s Comparison Functions – HausdorffSimilarityMeasure & AreaSimilarityMeasure with SDO_GEOMETRYoriginal ↗
22 Jul 2020
Free JTS-based Area/Length Functionsoriginal ↗
22 Jul 2020
Handy way of systematically fixing polygon geometries with 13349 and other errorsoriginal ↗
22 Jul 2020
Standalone CENTROID package now available for downloadoriginal ↗
22 Jul 2020
Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 4 Processing Geodetic dataoriginal ↗
22 Jul 2020
New versions of PL/SQL packages uploadedoriginal ↗
22 Jul 2020
Configurable Buffer: JTS and Oracleoriginal ↗
22 Jul 2020
Spatial Companion For Oracle (SC4O)original ↗
22 Jul 2020
Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 3original ↗
22 Jul 2020
Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 2original ↗
22 Jul 2020
NETWORKoriginal ↗
22 Jul 2020
TOOLSoriginal ↗
22 Jul 2020
KMLoriginal ↗
21 Jul 2020
COGOoriginal ↗
21 Jul 2020
GEOMoriginal ↗
21 Jul 2020
LINEAR (LRS)original ↗
21 Jul 2020
SDO_ERRORoriginal ↗
21 Jul 2020
CENTROIDoriginal ↗
21 Jul 2020
Building Lines into Polygons in Oracle Locator / Spatialoriginal ↗
21 Jul 2020
Previous Next