corpus.blog
41554 blogs · [ { "id": "01a0d1a1-b180-70da-9606-548b9a7ad9f2", "title": "Implementing a SetPoint/ST_SetPoint function in Oracle", "url": "https://www.spdba.com.au/implementing-a-setpoint-st_setpoint-function-in-oracle/", "published_at": "2020-04-13T03:22:51+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9b232ee1", "title": "Implementing an ST_SnapToGrid (PostGIS) function for Oracle Spatial", "url": "https://www.spdba.com.au/implementing-an-st_snaptogrid-postgis-function-for-oracle-spatial/", "published_at": "2020-04-13T03:00:23+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9b941ce4", "title": "Implementing an Affine/ST_Affine function for Oracle Spatial", "url": "https://www.spdba.com.au/implementing-an-affine-st_affine-function-for-oracle-spatial/", "published_at": "2020-04-06T05:55:58+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9bc1cc9c", "title": "Implementing a Scale/ST_Scale function for Oracle Spatial", "url": "https://www.spdba.com.au/implementing-a-scale-st_scale-function-for-oracle-spatial/", "published_at": "2020-04-06T05:33:54+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9cb3b5a9", "title": "Spatial Database Comparison", "url": "https://www.spdba.com.au/spatial-database-comparison/", "published_at": "2020-04-06T05:24:18+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9cb5370e", "title": "Maps of War Website", "url": "https://www.spdba.com.au/maps-of-war-website/", "published_at": "2020-04-06T04:45:45+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9d6628a3", "title": "Implementing a Parallel/ST_Parallel function for linestring data for Oracle Spatial", "url": "https://www.spdba.com.au/implementing-a-parallel-st_parallel-function-for-linestring-data-for-oracle-spatial/", "published_at": "2020-04-06T04:42:45+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9e38cf38", "title": "Talk on Open GeoData in Australia", "url": "https://www.spdba.com.au/talk-on-open-geodata-in-australia/", "published_at": "2020-04-06T04:23:15+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9e5ea97b", "title": "Implementing a Rotate/ST_Rotate function for Oracle Spatial", "url": "https://www.spdba.com.au/implementing-a-rotate-st_rotate-function-for-oracle-spatial/", "published_at": "2020-04-06T04:19:04+00:00" }, { "id": "01a0d1a1-b180-70da-9606-548b9f59c342", "title": "Limiting table list returned when connecting to Oracle Database using ODBC", "url": "https://www.spdba.com.au/limiting-table-list-returned-when-connecting-to-oracle-database-using-odbc/", "published_at": "2020-04-06T04:01:27+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf2925bc6", "title": "Filtering Rings (Oracle Spatial)", "url": "https://www.spdba.com.au/filtering-rings-oracle-spatial/", "published_at": "2020-04-06T03:54:30+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf2ae526a", "title": "There’s Network Analysis, and then there IS Network Analysis", "url": "https://www.spdba.com.au/theres-network-analysis-and-then-there-is-network-analysis/", "published_at": "2020-04-03T10:16:23+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf377dcca", "title": "Filtering Rings in Polygon (PostGIS)", "url": "https://www.spdba.com.au/filtering-rings-in-polygon-postgis/", "published_at": "2020-04-02T03:45:33+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf37daa44", "title": "ST_Azimuth for Oracle: AKA Cogo.Bearing", "url": "https://www.spdba.com.au/st_azimuth-for-oracle-aka-cogo-bearing/", "published_at": "2020-04-02T03:06:12+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf3b71a39", "title": "Implementing a Translate/ST_Translate/Move function for Oracle Spatial", "url": "https://www.spdba.com.au/implementing-a-translate-st_translate-move-function-for-oracle-spatial/", "published_at": "2020-04-02T02:50:21+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf3e72aa2", "title": "Elem_Info_Array Processing: An alternative to SDO_UTIL.GetNumRings and querying SDO_ELEM_INFO itself", "url": "https://www.spdba.com.au/elem_info_array-processing-an-alternative-to-sdo_util-getnumrings-and-querying-sdo_elem_info-itself/", "published_at": "2020-04-02T01:05:33+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf461a68f", "title": "Minumum Bounding Rectangle (MBR) Object Type for Oracle", "url": "https://www.spdba.com.au/minumum-bounding-rectangle-mbr-object-type-for-oracle/", "published_at": "2020-04-02T00:18:52+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf482804e", "title": "How to extract elements from the result of an sdo_intersection of two polygons.", "url": "https://www.spdba.com.au/how-to-extract-elements-from-the-result-of-an-sdo_intersection-of-two-polygons/", "published_at": "2020-04-01T23:49:42+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf486af04", "title": "generate_series for SQL Server 2008", "url": "https://www.spdba.com.au/generate_series-for-sql-server-2008/", "published_at": "2020-04-01T03:25:44+00:00" }, { "id": "01a0d1a1-d83c-70f9-8b57-14cbf4eb84c7", "title": "How to restart a database after failed parameter change", "url": "https://www.spdba.com.au/how-to-restart-a-database-after-failed-parameter-change/", "published_at": "2020-04-01T03:15:39+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bcc50d49b", "title": "Fixing failed spatial indexes after import using data pump", "url": "https://www.spdba.com.au/fixing-failed-spatial-indexes-after-import-using-data-pump/", "published_at": "2020-04-01T02:59:17+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bcd331ea0", "title": "Boarder and District Spatial Information Group Presentation on Spatial Datbases", "url": "https://www.spdba.com.au/boarder-and-district-spatial-information-group-presentation-on-spatial-datbases/", "published_at": "2020-04-01T02:47:58+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bcde3b9d6", "title": "generate_series: an Oracle implementation in light of SQL Design Patterns", "url": "https://www.spdba.com.au/generate_series-an-oracle-implementation-in-light-of-sql-design-patterns/", "published_at": "2020-04-01T02:45:01+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bcee0818e", "title": "Simplification and Gridding", "url": "https://www.spdba.com.au/simplification-and-gridding/", "published_at": "2020-04-01T02:00:19+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bcf20c439", "title": "On the use of ROLLUP in Oracle SELECT statements", "url": "https://www.spdba.com.au/on-the-use-of-rollup-in-oracle-select-statements/", "published_at": "2020-04-01T01:57:44+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bcf391d4b", "title": "Surrounding Parcels", "url": "https://www.spdba.com.au/surrounding-parcels/", "published_at": "2020-04-01T01:54:09+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bcfc4a630", "title": "Presentations given by myself at the Australian Oracle Spatial Forum, Sydney, Thursday 28th August 2008", "url": "https://www.spdba.com.au/presentations-given-by-myself-at-the-australian-oracle-spatial-forum-sydney-thursday-28th-august-2008/", "published_at": "2020-04-01T01:35:38+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bd05b1018", "title": "Multi-Centroid Shootout", "url": "https://www.spdba.com.au/multi-centroid-shootout/", "published_at": "2020-04-01T01:32:35+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bd12e132a", "title": "Spatial Pipelining", "url": "https://www.spdba.com.au/spatial-pipelining/", "published_at": "2020-04-01T01:18:04+00:00" }, { "id": "01a0d1a2-0206-71d2-809b-ee0bd1c21428", "title": "Using Oracle’s SDO_NN Operator – Some examples", "url": "https://www.spdba.com.au/using-oracles-sdo_nn-operator-some-examples/", "published_at": "2020-04-01T00:51:53+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c12198b5397", "title": "Converting distances and units of measure in Oracle Locator", "url": "https://www.spdba.com.au/converting-distances-and-units-of-measure-in-oracle-locator/", "published_at": "2020-03-31T23:55:48+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c1219f4642a", "title": "Oracle Spatial Centroid Shootout", "url": "https://www.spdba.com.au/oracle-spatial-centroid-shootout/", "published_at": "2020-03-30T02:54:16+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121a7fdf04", "title": "Tip #6: Correcting invalid geometries", "url": "https://www.spdba.com.au/tip-6-correcting-invalid-geometries/", "published_at": "2020-03-27T04:46:14+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121b7b038b", "title": "The Sad State of SQL Spatial Standards – Take 2", "url": "https://www.spdba.com.au/the-sad-state-of-sql-spatial-standards-take-2/", "published_at": "2020-03-27T03:50:57+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121bf43c91", "title": "Tip #5: Where or where has my little column gone", "url": "https://www.spdba.com.au/tip-5-where-or-where-has-my-little-column-gone/", "published_at": "2020-03-27T03:32:29+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121cb89c21", "title": "Tip #4: What Coordinate System is that?", "url": "https://www.spdba.com.au/tip-4-what-coordinate-system-is-that/", "published_at": "2020-03-27T02:17:39+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121ccb1507", "title": "Tip #3: What object is that?", "url": "https://www.spdba.com.au/tip-3-what-object-is-that/", "published_at": "2020-03-27T02:09:53+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121d84ce5c", "title": "Tip #2: Spatial Indexing and Primary Keys", "url": "https://www.spdba.com.au/tip-2-spatial-indexing-and-primary-keys/", "published_at": "2020-03-27T02:00:55+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121ddd1865", "title": "Tip #1: SQL Server 2008 “Katmai” – Setting SRIDs", "url": "https://www.spdba.com.au/tip-1-sql-server-2008-katmai-setting-srids/", "published_at": "2020-03-27T01:54:11+00:00" }, { "id": "01a0d1a2-2610-725d-afee-9c121e4f650a", "title": "Generating multi-points from single point records in Oracle Spatial", "url": "https://www.spdba.com.au/generating-multi-points-from-single-point-records-in-oracle-spatial/", "published_at": "2020-03-27T00:01:17+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d3248d7fc", "title": "SQL Server 2008 Katmai", "url": "https://www.spdba.com.au/sql-server-2008-katmai/", "published_at": "2020-03-26T23:42:39+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d327b66e1", "title": "Object Tables of Sdo_Geometry", "url": "https://www.spdba.com.au/object-tables-of-sdo_geometry/", "published_at": "2020-03-26T23:38:43+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d3303dfda", "title": "Oracle Locator vs Oracle Spatial: A Reflection on Oracle Licensing of the SDO_GEOM Package", "url": "https://www.spdba.com.au/oracle-locator-vs-oracle-spatial-a-reflection-on-oracle-licensing-of-the-sdo_geom-package/", "published_at": "2020-03-26T09:22:38+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d33653cec", "title": "FAST REFRESHing of Oracle Materialized Views containing Sdo_Geometry columns", "url": "https://www.spdba.com.au/fast-refreshing-of-oracle-materialized-views-containing-sdo_geometry-columns/", "published_at": "2020-03-26T06:11:47+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d3425fe6a", "title": "Australian MGA/AMG Zone Calculation from geographic (longitude/latitude) data", "url": "https://www.spdba.com.au/australian-mga-amg-zone-calculation-from-geographic-longitude-latitude-data/", "published_at": "2020-03-26T05:25:43+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d34ba57cd", "title": "Loading Shapefiles (SHP) into Oracle Spatial", "url": "https://www.spdba.com.au/loading-shapefiles-shp-into-oracle-spatial/", "published_at": "2020-03-26T05:13:24+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d35949cab", "title": "Microsoft to release their own spatial capability for SQL Server", "url": "https://www.spdba.com.au/microsoft-to-release-their-own-spatial-capability-for-sql-server/", "published_at": "2020-03-26T05:04:46+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d35ad560e", "title": "The significance of sdo_lb/sdo_ub in USER_SDO_GEOM_METDATA: Do I need it?", "url": "https://www.spdba.com.au/the-significance-of-sdo_lb-sdo_ub-in-user_sdo_geom_metdata-do-i-need-it/", "published_at": "2020-03-26T05:00:21+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d36649e4c", "title": "Insularity and Progress", "url": "https://www.spdba.com.au/insularity-and-progress/", "published_at": "2020-03-26T04:49:23+00:00" }, { "id": "01a0d1a2-45c6-73d8-b03c-ff7d36d19bc4", "title": "Oracle Spatial Forum – Melbourne April 2007", "url": "https://www.spdba.com.au/oracle-spatial-forum-melbourne-april-2007/", "published_at": "2020-03-26T04:22:51+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b45fcf8bcd", "title": "Radius Studio and ESRI (Part 2)", "url": "https://www.spdba.com.au/radius-studio-and-esri-part-2/", "published_at": "2020-03-26T04:14:35+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b460ce6dd6", "title": "Radius Studio and FDO", "url": "https://www.spdba.com.au/radius-studio-and-fdo/", "published_at": "2020-03-26T04:11:06+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b461cd8fda", "title": "VB6 Oracle Spatial or Locator OO4O code", "url": "https://www.spdba.com.au/vb6-oracle-spatial-or-locator-oo4o-code/", "published_at": "2020-03-26T04:08:50+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b461d7f3f6", "title": "Tip #1 – Extracting the Spatial Extent of an Image and Saving in a Drawing", "url": "https://www.spdba.com.au/tip-1-extracting-the-spatial-extent-of-an-image-and-saving-in-a-drawing/", "published_at": "2020-03-26T03:52:41+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b462598e8a", "title": "Manifold GIS – Tips and Tricks", "url": "https://www.spdba.com.au/manifold-gis-tips-and-tricks/", "published_at": "2020-03-26T03:41:42+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b4625af045", "title": "Layer_GTypes for spatial indexes", "url": "https://www.spdba.com.au/layer_gtypes-for-spatial-indexes/", "published_at": "2020-03-26T03:38:03+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b4628144a7", "title": "Unpacking USER_SDO_GEOM_METADATA’s DIMINFO structure using SQL", "url": "https://www.spdba.com.au/unpacking-user_sdo_geom_metadatas-diminfo-structure-using-sql/", "published_at": "2020-03-26T03:32:12+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b4631f30b7", "title": "Forcing an Sdo_Geometry object to contain only points, lines or areas", "url": "https://www.spdba.com.au/forcing-an-sdo_geometry-object-to-contain-only-points-lines-or-areas/", "published_at": "2020-03-26T03:21:44+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b463a39a3f", "title": "Tips and Tricks", "url": "https://www.spdba.com.au/tips-and-tricks/", "published_at": "2020-03-26T03:18:16+00:00" }, { "id": "01a0d1a2-69bb-70ed-8a2e-d7b463df0264", "title": "What people say about me or my work…", "url": "https://www.spdba.com.au/what-people-say-about-me-or-my-work/", "published_at": "2020-03-26T03:17:01+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d69fc39f02", "title": "Choosing a Tile Size", "url": "https://www.spdba.com.au/choosing-a-tile-size/", "published_at": "2020-03-26T03:14:21+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a027ea8b", "title": "First Radius Studio Certified Practitioner", "url": "https://www.spdba.com.au/first-radius-studio-certified-practitioner/", "published_at": "2020-03-26T03:13:20+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a0b263dd", "title": "Tile Map Service Specification", "url": "https://www.spdba.com.au/tile-map-service-specification/", "published_at": "2020-03-26T03:12:01+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a0eba07c", "title": "Image Catalog Tool", "url": "https://www.spdba.com.au/image-catalog-tool-2/", "published_at": "2020-03-26T03:10:48+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a12b1fbf", "title": "Image Catalog Tool – How To Videos", "url": "https://www.spdba.com.au/image-catalog-tool-how-to-videos/", "published_at": "2020-03-26T03:09:27+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a1cfd2ee", "title": "Oracle’s SQL/MM Compliant Types", "url": "https://www.spdba.com.au/oracles-sql-mm-compliant-types/", "published_at": "2020-03-26T03:08:16+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a29c4497", "title": "Latest article published on Directions Magazine", "url": "https://www.spdba.com.au/latest-article-published-on-directions-magazine/", "published_at": "2020-03-26T03:06:26+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a29f7a3a", "title": "Spatial PL/SQL Packages by Example", "url": "https://www.spdba.com.au/spatial-pl-sql-packages-by-example/", "published_at": "2020-03-26T03:04:53+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a31d6f41", "title": "Image Catalog / GeoRaster Management Tools", "url": "https://www.spdba.com.au/image-catalog-georaster-management-tools/", "published_at": "2020-03-26T02:47:11+00:00" }, { "id": "01a0d1a2-96e3-7271-920d-35d6a39c1b10", "title": "Oracle Spatial PL/SQL and VB6 Source Code", "url": "https://www.spdba.com.au/oracle-spatial-pl-sql-and-vb6-source-code/", "published_at": "2020-03-26T02:45:59+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9a3e6636", "title": "SpatialWare 4.9 Released", "url": "https://www.spdba.com.au/spatialware-4-9-released/", "published_at": "2020-03-26T02:42:46+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9b117e77", "title": "Proprietary and Standards – What’s in a name", "url": "https://www.spdba.com.au/proprietary-and-standards-whats-in-a-name/", "published_at": "2020-03-26T02:41:16+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9b4d19c4", "title": "Geomatics Degrees, Space Curves and Oracle Spatial", "url": "https://www.spdba.com.au/geomatics-degrees-space-curves-and-oracle-spatial-2/", "published_at": "2020-03-26T02:39:53+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9be44a15", "title": "Geomatics Degrees, Space Curves and Oracle Spatial", "url": "https://www.spdba.com.au/geomatics-degrees-space-curves-and-oracle-spatial/", "published_at": "2020-03-26T02:39:36+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9c6c2551", "title": "A Biography", "url": "https://www.spdba.com.au/a-biography/", "published_at": "2020-03-26T02:37:39+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9c9650f2", "title": "ESRI Ireland – Many Thanks", "url": "https://www.spdba.com.au/esri-ireland-many-thanks/", "published_at": "2020-03-26T02:34:23+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9ce07576", "title": "PL/SQL Packages for Oracle Sdo_Geometry", "url": "https://www.spdba.com.au/pl-sql-packages-for-oracle-sdo_geometry/", "published_at": "2020-03-26T02:32:20+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9cfc0b77", "title": "Professor Hanan Samet", "url": "https://www.spdba.com.au/professor-hanan-samet/", "published_at": "2020-03-26T02:26:48+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9defbbee", "title": "ADF and Spatial", "url": "https://www.spdba.com.au/adf-and-spatial/", "published_at": "2020-03-26T02:25:19+00:00" }, { "id": "01a0d1a2-bf88-735f-a741-2e5a9eaee16b", "title": "Non-Persistent Types", "url": "https://www.spdba.com.au/non-persistent-types/", "published_at": "2020-03-26T02:25:08+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b66ce3b0", "title": "Bouquets and Brickbats", "url": "https://www.spdba.com.au/bouquets-and-brickbats/", "published_at": "2020-03-26T02:23:56+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b6ff38aa", "title": "Feature Data Objects – Either/Or?", "url": "https://www.spdba.com.au/feature-data-objects-either-or/", "published_at": "2020-03-26T02:12:54+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b710dea8", "title": "What is Route Optimization?", "url": "https://www.spdba.com.au/what-is-route-optimization/", "published_at": "2020-03-24T23:16:58+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b762c6a7", "title": "STDensify: Densify LineString or Polygon geometry objects", "url": "https://www.spdba.com.au/stdensify-densify-mlinestring-or-mpolygon-geometry-objects/", "published_at": "2020-02-20T04:18:10+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b76e731e", "title": "STGeometryTypes: Extracting all geometry type string values from a complex geometry", "url": "https://www.spdba.com.au/stgeometrytypes-extracting-all-geometry-type-string-values-from-complex-geometry/", "published_at": "2020-02-20T04:02:19+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b82ce178", "title": "STAsEWKT", "url": "https://www.spdba.com.au/stasewkt/", "published_at": "2020-01-03T03:37:45+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b89f7f7f", "title": "STGeomFromEWKT", "url": "https://www.spdba.com.au/stfromewkt/", "published_at": "2020-01-01T06:54:42+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b8a2271d", "title": "PostGIS Certification", "url": "https://www.spdba.com.au/postgis-certification/", "published_at": "2019-11-21T06:58:05+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b8b40a8d", "title": "Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 2)", "url": "https://www.spdba.com.au/using-sql-server-xml-and-spatial-to-import-vicmap-seed-incremental-update-format-iuf-data-part-2/", "published_at": "2019-11-19T22:26:54+00:00" }, { "id": "01a0d1a2-e03c-7110-a890-4933b9153612", "title": "Creating a Grid of Geographic Tiles", "url": "https://www.spdba.com.au/tiling-creating-a-grid-over-geographic-space/", "published_at": "2019-11-18T04:03:31+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e66551a94f9", "title": "Loading and Processing GPX 1.1 files using Oracle XMLDB", "url": "https://www.spdba.com.au/loading-and-processing-gpx-1-1-files-using-oracle-xmldb/", "published_at": "2019-10-06T06:10:01+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e66558d2fd6", "title": "Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 1)", "url": "https://www.spdba.com.au/using-sql-server-xml-and-spatial-to-import-vicmap-seed-incremental-update-format-iuf-data/", "published_at": "2019-10-05T08:33:39+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e66561506cb", "title": "Migrating Tables with Geometry Columns from Oracle to SQL Server Spatial", "url": "https://www.spdba.com.au/migrating-tables-with-geometry-columns-from-oracle-to-sql-server-spatial/", "published_at": "2019-09-30T12:01:54+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e6656bac5ff", "title": "STMulti", "url": "https://www.spdba.com.au/stmulti/", "published_at": "2019-09-10T06:45:29+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e66576349da", "title": "STRound", "url": "https://www.spdba.com.au/stround/", "published_at": "2019-09-09T23:53:11+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e66580e9ed3", "title": "Using PostgreSQL’s XML processing to load spatial data", "url": "https://www.spdba.com.au/using-postgresqls-xml-processing-to-load-spatial-data/", "published_at": "2019-09-02T08:40:37+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e665890d57f", "title": "Snap Point to SQL Server Spatial geometry using TSQL", "url": "https://www.spdba.com.au/stpointtocirculararc/", "published_at": "2019-08-16T09:14:01+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e6658b448c9", "title": "STLocateBetweenElevations", "url": "https://www.spdba.com.au/stlocatebetweenelevations/", "published_at": "2019-07-19T06:14:39+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e665990a791", "title": "STLineSubstring", "url": "https://www.spdba.com.au/stlinesubstring/", "published_at": "2019-07-19T06:08:28+00:00" }, { "id": "01a0d1a3-0ac1-72ba-b10e-4e665a72562b", "title": "STLineInterpolatePoint", "url": "https://www.spdba.com.au/stlineinterpolatepoint/", "published_at": "2019-07-19T05:58:06+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

Implementing a SetPoint/ST_SetPoint function in Oracleoriginal ↗
13 Apr 2020
Implementing an ST_SnapToGrid (PostGIS) function for Oracle Spatialoriginal ↗
13 Apr 2020
Implementing an Affine/ST_Affine function for Oracle Spatialoriginal ↗
6 Apr 2020
Implementing a Scale/ST_Scale function for Oracle Spatialoriginal ↗
6 Apr 2020
Spatial Database Comparisonoriginal ↗
6 Apr 2020
Maps of War Websiteoriginal ↗
6 Apr 2020
Implementing a Parallel/ST_Parallel function for linestring data for Oracle Spatialoriginal ↗
6 Apr 2020
Talk on Open GeoData in Australiaoriginal ↗
6 Apr 2020
Implementing a Rotate/ST_Rotate function for Oracle Spatialoriginal ↗
6 Apr 2020
Limiting table list returned when connecting to Oracle Database using ODBCoriginal ↗
6 Apr 2020
Filtering Rings (Oracle Spatial)original ↗
6 Apr 2020
There’s Network Analysis, and then there IS Network Analysisoriginal ↗
3 Apr 2020
Filtering Rings in Polygon (PostGIS)original ↗
2 Apr 2020
ST_Azimuth for Oracle: AKA Cogo.Bearingoriginal ↗
2 Apr 2020
Implementing a Translate/ST_Translate/Move function for Oracle Spatialoriginal ↗
2 Apr 2020
Elem_Info_Array Processing: An alternative to SDO_UTIL.GetNumRings and querying SDO_ELEM_INFO itselforiginal ↗
2 Apr 2020
Minumum Bounding Rectangle (MBR) Object Type for Oracleoriginal ↗
2 Apr 2020
How to extract elements from the result of an sdo_intersection of two polygons.original ↗
1 Apr 2020
generate_series for SQL Server 2008original ↗
1 Apr 2020
How to restart a database after failed parameter changeoriginal ↗
1 Apr 2020
Fixing failed spatial indexes after import using data pumporiginal ↗
1 Apr 2020
Boarder and District Spatial Information Group Presentation on Spatial Datbasesoriginal ↗
1 Apr 2020
generate_series: an Oracle implementation in light of SQL Design Patternsoriginal ↗
1 Apr 2020
Simplification and Griddingoriginal ↗
1 Apr 2020
On the use of ROLLUP in Oracle SELECT statementsoriginal ↗
1 Apr 2020
Surrounding Parcelsoriginal ↗
1 Apr 2020
Presentations given by myself at the Australian Oracle Spatial Forum, Sydney, Thursday 28th August 2008original ↗
1 Apr 2020
Multi-Centroid Shootoutoriginal ↗
1 Apr 2020
Spatial Pipeliningoriginal ↗
1 Apr 2020
Using Oracle’s SDO_NN Operator – Some examplesoriginal ↗
1 Apr 2020
Converting distances and units of measure in Oracle Locatororiginal ↗
31 Mar 2020
Oracle Spatial Centroid Shootoutoriginal ↗
30 Mar 2020
Tip #6: Correcting invalid geometriesoriginal ↗
27 Mar 2020
The Sad State of SQL Spatial Standards – Take 2original ↗
27 Mar 2020
Tip #5: Where or where has my little column goneoriginal ↗
27 Mar 2020
Tip #4: What Coordinate System is that?original ↗
27 Mar 2020
Tip #3: What object is that?original ↗
27 Mar 2020
Tip #2: Spatial Indexing and Primary Keysoriginal ↗
27 Mar 2020
Tip #1: SQL Server 2008 “Katmai” – Setting SRIDsoriginal ↗
27 Mar 2020
Generating multi-points from single point records in Oracle Spatialoriginal ↗
27 Mar 2020
SQL Server 2008 Katmaioriginal ↗
26 Mar 2020
Object Tables of Sdo_Geometryoriginal ↗
26 Mar 2020
Oracle Locator vs Oracle Spatial: A Reflection on Oracle Licensing of the SDO_GEOM Packageoriginal ↗
26 Mar 2020
FAST REFRESHing of Oracle Materialized Views containing Sdo_Geometry columnsoriginal ↗
26 Mar 2020
Australian MGA/AMG Zone Calculation from geographic (longitude/latitude) dataoriginal ↗
26 Mar 2020
Loading Shapefiles (SHP) into Oracle Spatialoriginal ↗
26 Mar 2020
Microsoft to release their own spatial capability for SQL Serveroriginal ↗
26 Mar 2020
The significance of sdo_lb/sdo_ub in USER_SDO_GEOM_METDATA: Do I need it?original ↗
26 Mar 2020
Insularity and Progressoriginal ↗
26 Mar 2020
Oracle Spatial Forum – Melbourne April 2007original ↗
26 Mar 2020
Radius Studio and ESRI (Part 2)original ↗
26 Mar 2020
Radius Studio and FDOoriginal ↗
26 Mar 2020
VB6 Oracle Spatial or Locator OO4O codeoriginal ↗
26 Mar 2020
Tip #1 – Extracting the Spatial Extent of an Image and Saving in a Drawingoriginal ↗
26 Mar 2020
Manifold GIS – Tips and Tricksoriginal ↗
26 Mar 2020
Layer_GTypes for spatial indexesoriginal ↗
26 Mar 2020
Unpacking USER_SDO_GEOM_METADATA’s DIMINFO structure using SQLoriginal ↗
26 Mar 2020
Forcing an Sdo_Geometry object to contain only points, lines or areasoriginal ↗
26 Mar 2020
Tips and Tricksoriginal ↗
26 Mar 2020
What people say about me or my work…original ↗
26 Mar 2020
Choosing a Tile Sizeoriginal ↗
26 Mar 2020
First Radius Studio Certified Practitioneroriginal ↗
26 Mar 2020
Tile Map Service Specificationoriginal ↗
26 Mar 2020
Image Catalog Tooloriginal ↗
26 Mar 2020
Image Catalog Tool – How To Videosoriginal ↗
26 Mar 2020
Oracle’s SQL/MM Compliant Typesoriginal ↗
26 Mar 2020
Latest article published on Directions Magazineoriginal ↗
26 Mar 2020
Spatial PL/SQL Packages by Exampleoriginal ↗
26 Mar 2020
Image Catalog / GeoRaster Management Toolsoriginal ↗
26 Mar 2020
Oracle Spatial PL/SQL and VB6 Source Codeoriginal ↗
26 Mar 2020
SpatialWare 4.9 Releasedoriginal ↗
26 Mar 2020
Proprietary and Standards – What’s in a nameoriginal ↗
26 Mar 2020
Geomatics Degrees, Space Curves and Oracle Spatialoriginal ↗
26 Mar 2020
Geomatics Degrees, Space Curves and Oracle Spatialoriginal ↗
26 Mar 2020
A Biographyoriginal ↗
26 Mar 2020
ESRI Ireland – Many Thanksoriginal ↗
26 Mar 2020
PL/SQL Packages for Oracle Sdo_Geometryoriginal ↗
26 Mar 2020
Professor Hanan Sametoriginal ↗
26 Mar 2020
ADF and Spatialoriginal ↗
26 Mar 2020
Non-Persistent Typesoriginal ↗
26 Mar 2020
Bouquets and Brickbatsoriginal ↗
26 Mar 2020
Feature Data Objects – Either/Or?original ↗
26 Mar 2020
What is Route Optimization?original ↗
24 Mar 2020
STDensify: Densify LineString or Polygon geometry objectsoriginal ↗
20 Feb 2020
STGeometryTypes: Extracting all geometry type string values from a complex geometryoriginal ↗
20 Feb 2020
STAsEWKToriginal ↗
3 Jan 2020
STGeomFromEWKToriginal ↗
1 Jan 2020

2019

PostGIS Certificationoriginal ↗
21 Nov 2019
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 2)original ↗
19 Nov 2019
Creating a Grid of Geographic Tilesoriginal ↗
18 Nov 2019
Loading and Processing GPX 1.1 files using Oracle XMLDBoriginal ↗
6 Oct 2019
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 1)original ↗
5 Oct 2019
Migrating Tables with Geometry Columns from Oracle to SQL Server Spatialoriginal ↗
30 Sept 2019
STMultioriginal ↗
10 Sept 2019
STRoundoriginal ↗
9 Sept 2019
Using PostgreSQL’s XML processing to load spatial dataoriginal ↗
2 Sept 2019
Snap Point to SQL Server Spatial geometry using TSQLoriginal ↗
16 Aug 2019
STLocateBetweenElevationsoriginal ↗
19 Jul 2019
STLineSubstringoriginal ↗
19 Jul 2019
STLineInterpolatePointoriginal ↗
19 Jul 2019
Previous Next