corpus.blog
41554 blogs · [ { "id": "01a0d19f-fbf8-7043-a680-9be6270d2c31", "title": "Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 1", "url": "https://www.spdba.com.au/free-union-intersection-xor-and-difference-functions-for-oracle-locator-part-1/", "published_at": "2020-07-21T02:20:36+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be6274f2b0c", "title": "Effects of Sdo_Geometry Ordinate Precision on Storage", "url": "https://www.spdba.com.au/effects-of-sdo_geometry-ordinate-precision-on-storage/", "published_at": "2020-07-21T01:48:19+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be627cd761d", "title": "Finding Intersection Points between Line and Polygon", "url": "https://www.spdba.com.au/finding-intersection-points-between-line-and-polygon/", "published_at": "2020-07-21T01:31:49+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be628548498", "title": "SDO2GeoJSON", "url": "https://www.spdba.com.au/sdo2geojson/", "published_at": "2020-07-17T12:14:35+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be628c07f4e", "title": "ST_Parallel for PostGIS", "url": "https://www.spdba.com.au/st_parallel-for-postgis/", "published_at": "2020-07-17T06:39:32+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be6291da5d3", "title": "Free version of sdo_length", "url": "https://www.spdba.com.au/free-version-of-sdo_length/", "published_at": "2020-07-17T06:31:32+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be6291e5388", "title": "Alternative to my SQL based GetNumRings function", "url": "https://www.spdba.com.au/alternative-to-my-sql-based-getnumrings-function/", "published_at": "2020-07-17T06:23:50+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be62931bfcb", "title": "EXPORTER", "url": "https://www.spdba.com.au/exporter/", "published_at": "2020-07-17T03:00:26+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be629e2b78c", "title": "External Tables and SDO_Geometry data.", "url": "https://www.spdba.com.au/external-tables-and-sdo_geometry-data/", "published_at": "2020-07-17T02:50:17+00:00" }, { "id": "01a0d19f-fbf8-7043-a680-9be62a21bf18", "title": "layer_gtype keyword issue when indexing linear data on 11g", "url": "https://www.spdba.com.au/layer_gtype-keyword-issue-when-indexing-linear-data-on-11g/", "published_at": "2020-07-17T02:47:10+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b00bc8f6", "title": "String Tokenizer for Oracle", "url": "https://www.spdba.com.au/string-tokenizer-for-oracle/", "published_at": "2020-07-17T02:44:36+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b06556ad", "title": "Free Aggregate Method for Concatenating 2D Lines in Oracle Locator 10g", "url": "https://www.spdba.com.au/free-aggregate-method-for-concatenating-2d-lines-in-oracle-locator-10g/", "published_at": "2020-07-17T02:31:45+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b15d87fe", "title": "Reducing 5 Vertex Polygon to Optimized Rectangle", "url": "https://www.spdba.com.au/reducing-5-vertex-polygon-to-optimized-rectangle/", "published_at": "2020-07-17T02:28:22+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b16d68ec", "title": "Square Buffer", "url": "https://www.spdba.com.au/square-buffer/", "published_at": "2020-07-17T02:21:52+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b22417c7", "title": "Converting decimal seconds to string", "url": "https://www.spdba.com.au/converting-decimal-seconds-to-string/", "published_at": "2020-07-17T02:16:58+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b2e5e70e", "title": "2011 Oracle Spatial Excellence Award for Education and Research", "url": "https://www.spdba.com.au/2011-oracle-spatial-excellence-award-for-education-and-research/", "published_at": "2020-07-17T02:14:13+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b347f26e", "title": "SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT – 13356 Issues", "url": "https://www.spdba.com.au/sdo_geom-validate_geometry_with_context-13356-issues/", "published_at": "2020-07-17T02:12:50+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b3ce2c11", "title": "Valid conversion unit values for Oracle sdo_geom.sdo_length()", "url": "https://www.spdba.com.au/valid-conversion-unit-values-for-oracle-sdo_geom-sdo_length/", "published_at": "2020-07-17T02:09:18+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b423810d", "title": "COGO: Converting (Google Earth) Formatted Longitude/Latitude points to decimal degrees (SQL Server)", "url": "https://www.spdba.com.au/cogo-converting-google-earth-formatted-longitude-latitude-points-to-decimal-degrees-sql-server/", "published_at": "2020-07-17T01:36:42+00:00" }, { "id": "01a0d1a0-2ffb-7184-8d92-8c61b50b576b", "title": "COGO: Convert Degrees, Minutes and Seconds values to Decimal Degrees", "url": "https://www.spdba.com.au/cogo-convert-degrees-minutes-and-seconds-values-to-decimal-degrees/", "published_at": "2020-07-17T01:31:03+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c439fac83", "title": "COGO: Convert DMS String to decimal degrees floating point number.", "url": "https://www.spdba.com.au/cogo-convert-dms-string-to-decimal-degrees-floating-point-number/", "published_at": "2020-07-17T01:25:15+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c4442d988", "title": "COGO: DD2DMS Formatting a latitude/longitude decimal degree value", "url": "https://www.spdba.com.au/cogo-dd2dms-formatting-a-latitude-longitude-decimal-degree-value/", "published_at": "2020-07-17T01:19:49+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c4456b9fa", "title": "COGO: TSQL Function For Creating a Point from Point, Bearing and Distance", "url": "https://www.spdba.com.au/cogo-create-point-from-bearing-and-distance/", "published_at": "2020-07-17T01:14:44+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c44e04845", "title": "COGO: Compute number of vertices required to stroke circle or circular arc", "url": "https://www.spdba.com.au/cogo-compute-number-of-vertices-required-to-stroke-circle-or-circular-arc/", "published_at": "2020-07-17T01:10:19+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c4566650e", "title": "COGO: TSQL Function to Calculate the Bearing Between Two Points", "url": "https://www.spdba.com.au/cogo-calculating-the-bearing-between-two-points-sql-server-2008-spatial/", "published_at": "2020-07-17T01:06:48+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c464e060c", "title": "COGO: Compute arc length subtended by angle centre of circle", "url": "https://www.spdba.com.au/cogo-compute-arc-length-subtended-by-angle-centre-of-circle/", "published_at": "2020-07-17T01:01:19+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c467030c2", "title": "COGO: Compute chord length of segment of a circle (arc)", "url": "https://www.spdba.com.au/cogo-compute-chord-length-of-segment-of-a-circle-arc/", "published_at": "2020-07-17T00:57:02+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c46ec403f", "title": "COGO: Computing Arc To Chord (Arc2Chord) Separation", "url": "https://www.spdba.com.au/cogo-computing-arc-to-chord-arc2chord-separation/", "published_at": "2020-07-17T00:53:24+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c472c138c", "title": "COGO: Creating a stroked polygon from a circle’s centre x,y and radius", "url": "https://www.spdba.com.au/cogo-creating-a-stroked-polygon-from-a-circles-centre-xy-and-radius/", "published_at": "2020-07-17T00:48:43+00:00" }, { "id": "01a0d1a0-61a9-702e-a019-dd5c47877e12", "title": "COGO: Finding centre and radius of a curve defined by three points: FindCircle function", "url": "https://www.spdba.com.au/cogo-finding-centre-and-radius-of-a-curve-defined-by-three-points-findcircle-function/", "published_at": "2020-07-17T00:40:40+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877c847e67f", "title": "Removing Steps in Gridded Vector Data – SmoothGrid for Oracle", "url": "https://www.spdba.com.au/removing-steps-in-gridded-vector-data-smoothgrid-for-oracle/", "published_at": "2020-07-16T05:15:49+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877c90bbbca", "title": "Oracle Spatial DISJOINT search/filtering", "url": "https://www.spdba.com.au/oracle-spatial-disjoint-search-filtering/", "published_at": "2020-07-16T05:08:20+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877c95ce9ea", "title": "Tiling Very Large Rasters", "url": "https://www.spdba.com.au/tiling-very-large-rasters/", "published_at": "2020-07-16T05:03:18+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877c9d631f3", "title": "Generating random point data for SQL Server 2008 Spatial", "url": "https://www.spdba.com.au/generating-random-point-data-for-sql-server-2008-spatial/", "published_at": "2020-07-16T04:59:36+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877ca1ae973", "title": "Creating SDO_Geometry from geometric data recorded in the columns of a table", "url": "https://www.spdba.com.au/creating-sdo_geometry-from-geometric-data-recorded-in-the-columns-of-a-table/", "published_at": "2020-07-16T04:55:22+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877ca638ec7", "title": "Concave Hull Geometries in Oracle 11gR2", "url": "https://www.spdba.com.au/concave-hull-geometries-in-oracle-11gr2/", "published_at": "2020-07-16T04:43:39+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877cb02b649", "title": "Cloud Computing GIS and Standards (OGC/ISO)", "url": "https://www.spdba.com.au/cloud-computing-gis-and-standards-ogc-iso/", "published_at": "2020-07-16T02:40:02+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877cb56e056", "title": "Projecting SDO_GEOM_METADATA DIMINFO XY ordinates", "url": "https://www.spdba.com.au/projecting-sdo_geom_metadata-diminfo-xy-ordinates/", "published_at": "2020-07-16T02:37:33+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877cb72f96f", "title": "Morton Key Function for PostgreSQL/PostGIS", "url": "https://www.spdba.com.au/morton-key-function-for-postgresql-postgis/", "published_at": "2020-07-10T04:01:45+00:00" }, { "id": "01a0d1a0-96f2-72ce-a590-b877cc6e2813", "title": "Usefulness of Spatial Metadata as a Foundation for an Australian data.gov and other uses", "url": "https://www.spdba.com.au/usefulness-of-spatial-metadata-as-a-foundation-for-an-australian-data-gov-and-other-uses/", "published_at": "2020-07-10T03:54:10+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e2510097920", "title": "New Presentation on Active (Searchable) Spatial Metadata for SQL Server 2008 Spatial and FreeText", "url": "https://www.spdba.com.au/new-presentation-on-active-searchable-spatial-metadata-for-sql-server-2008-spatial-and-freetext/", "published_at": "2020-07-10T03:46:41+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e25100e8f80", "title": "Instantiating MDSYS.VERTEX_TYPE", "url": "https://www.spdba.com.au/instantiating-mdsys-vertex_type/", "published_at": "2020-07-10T03:44:57+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e25102d20a5", "title": "New PL/SQL Packages – Rotate oriented point", "url": "https://www.spdba.com.au/new-pl-sql-packages-rotate-oriented-point/", "published_at": "2020-07-10T03:42:15+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e25106129b4", "title": "Vale Professor Pieter Roelof Zwart 1941-2010", "url": "https://www.spdba.com.au/vale-professor-pieter-roelof-zwart-1941-2010/", "published_at": "2020-07-10T03:37:04+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e25113ec9ad", "title": "Fast Refreshing Materialized View Containing SDO_GEOMETRY and SDO_GEOM.SDO_AREA function", "url": "https://www.spdba.com.au/fast-refreshing-materialized-view-containing-sdo_geometry-and-sdo_geom-sdo_area-function/", "published_at": "2020-07-10T03:29:12+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e251232e392", "title": "Interview by Nestoria on Real Estate Mapping", "url": "https://www.spdba.com.au/interview-by-nestoria-on-real-estate-mapping/", "published_at": "2020-07-10T03:21:37+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e25125c767b", "title": "Performance of PL/SQL Functions using SQL vs Pure Code", "url": "https://www.spdba.com.au/performance-of-pl-sql-functions-using-sql-vs-pure-code/", "published_at": "2020-07-10T03:19:42+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e251304f18d", "title": "Implementing the BEST VicGrid Projection in Oracle 10gR2", "url": "https://www.spdba.com.au/implementing-the-best-vicgrid-projection-in-oracle-10gr2/", "published_at": "2020-07-10T02:03:35+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e2513bc6dc4", "title": "Making Sdo Geometry Metadata", "url": "https://www.spdba.com.au/making-sdo-geometry-metadata/", "published_at": "2020-07-10T01:56:12+00:00" }, { "id": "01a0d1a0-b6dc-7090-ba5d-2e25145eaad4", "title": "ORA-13011 errors when using SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT()", "url": "https://www.spdba.com.au/ora-13011-errors-when-using-sdo_geom-validate_layer_with_context/", "published_at": "2020-07-10T01:41:53+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c4dddc9e", "title": "Mapping surface area of a ruptured pipe in Oracle Spatial", "url": "https://www.spdba.com.au/mapping-surface-area-of-a-ruptured-pipe-in-oracle-spatial/", "published_at": "2020-07-10T01:32:33+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c5a059bb", "title": "STisGeo: Checking if a column in a table or a view is of type geometry or geography", "url": "https://www.spdba.com.au/stisgeo-checking-if-a-column-in-a-table-or-a-view-is-of-type-geometry-or-geography/", "published_at": "2020-07-10T01:30:36+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c5bcf77c", "title": "Extract Polygons from Compound Polygon", "url": "https://www.spdba.com.au/extract-polygons-from-compound-polygon/", "published_at": "2020-07-09T06:33:42+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c6a5c0e6", "title": "Detecting sdo_geometries with compound (3-point Arcs) segments", "url": "https://www.spdba.com.au/detecting-sdo_geometries-with-compound-3-point-arcs-segments/", "published_at": "2020-07-09T06:28:28+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c6b50e66", "title": "GEOMETRY_COLUMNS for Oracle Spatial", "url": "https://www.spdba.com.au/geometry_columns-for-oracle-spatial/", "published_at": "2020-07-09T06:23:17+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c6fd3a5d", "title": "FOSS4G 2009 Sydney Presentation", "url": "https://www.spdba.com.au/foss4g-2009-sydney-presentation/", "published_at": "2020-07-09T06:11:47+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c7cc3e2e", "title": "Convert GML to SDO_Geometry in Oracle 10gR2", "url": "https://www.spdba.com.au/convert-gml-to-sdo_geometry-in-oracle-10gr2/", "published_at": "2020-07-09T06:08:10+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c89ceac0", "title": "STGeometryTypes: Extracting all geometry type string values from complex geometry", "url": "https://www.spdba.com.au/stgeometrytypes-extracting-all-geometry-type-string-values-from-complex-geometry-2/", "published_at": "2020-07-09T05:50:06+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c9330293", "title": "Vectorising geometry objects in SQL Server 2008", "url": "https://www.spdba.com.au/vectorising-geometry-objects-in-sql-server-2008/", "published_at": "2020-07-09T05:41:43+00:00" }, { "id": "01a0d1a0-dcf1-7154-bb4f-b400c98bd122", "title": "STMBR2Geometry/STMBR2Geography functions", "url": "https://www.spdba.com.au/stmbr2geometry-stmbr2geography-functions/", "published_at": "2020-07-09T05:11:16+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd956592ac57", "title": "Extracting geometry types from geometry/geography objects in SQL Server 2008", "url": "https://www.spdba.com.au/extracting-geometry-types-from-geometry-geography-objects-in-sql-server-2008/", "published_at": "2020-07-09T05:00:30+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd9565e86b93", "title": "Reflecting a Geometry Object Around a Line", "url": "https://www.spdba.com.au/reflecting-a-geometry-around-a-line/", "published_at": "2020-06-19T08:25:20+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd95663ce720", "title": "Implementing Point-based Costs in pgRouting", "url": "https://www.spdba.com.au/implementing-point-based-costs-in-pgrouting/", "published_at": "2020-06-17T00:37:44+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd9566f6e301", "title": "Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 3)", "url": "https://www.spdba.com.au/using-sql-server-xml-and-spatial-to-import-vicmap-seed-incremental-update-format-iuf-data-part-3/", "published_at": "2020-06-12T07:06:26+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd9567529779", "title": "Getting the number of coordinate dimensions of a geometry/geography object in SQL Server 2008", "url": "https://www.spdba.com.au/getting-the-number-of-coordinate-dimensions-of-a-geometry-geography-object-in-sql-server-2008/", "published_at": "2020-05-30T05:38:09+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd95681f98b5", "title": "STDumpPoints: A Function that Dumps the Vertices/Points in a geometry", "url": "https://www.spdba.com.au/stdumppoints-a-function-that-dumps-the-vertices-points-in-a-geometry/", "published_at": "2020-05-30T05:28:33+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd95687333ff", "title": "toGeography and toGeography Conversion Functions for SQL Server 2008 Spatial", "url": "https://www.spdba.com.au/togeography-and-togeography-conversion-functions-for-sql-server-2008-spatial/", "published_at": "2020-05-30T05:18:12+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd9568e87b78", "title": "Spatial Sorting of Data via Morton Key For Oracle Spatial/Locator", "url": "https://www.spdba.com.au/spatial-sorting-of-data-via-morton-key/", "published_at": "2020-05-30T05:11:33+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd95699ee837", "title": "Write text file with spatial data from SQL Server 2008", "url": "https://www.spdba.com.au/write-text-file-with-spatial-data-from-sql-server-2008/", "published_at": "2020-05-30T04:54:27+00:00" }, { "id": "01a0d1a1-0433-7239-a2e1-cd956a30a27c", "title": "TSQL String Tokenizer Function for SQL Server", "url": "https://www.spdba.com.au/tsql-string-tokenizer-function-for-sql-server/", "published_at": "2020-05-30T03:11:29+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad0006d48fa", "title": "Swapping Ordinates in an SDO_GEOMETRY object", "url": "https://www.spdba.com.au/swapping-ordinates-in-an-sdo_geometry-object/", "published_at": "2020-05-30T02:28:27+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad000e3e137", "title": "Hat Tip to Philipp Salvisberg", "url": "https://www.spdba.com.au/hat-tip-to-philipp-salvisberg/", "published_at": "2020-05-28T04:29:14+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad001b6e09a", "title": "Spatially Extending Database Management and Development Tools: GeoRaptor, DBeaver, pgAdmin and SSMS", "url": "https://www.spdba.com.au/spatially-extending-database-management-and-development-tools-georaptor-dbeaver-pgadmin-and-ssms/", "published_at": "2020-05-10T05:22:58+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad002b0ceb1", "title": "New To_3D Function", "url": "https://www.spdba.com.au/new-to_3d-function/", "published_at": "2020-04-20T02:58:27+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad0038ec671", "title": "Extend (Reduce/Contract/Skrink) Function for Oracle", "url": "https://www.spdba.com.au/extend-reduce-contract-skrink-function-for-oracle/", "published_at": "2020-04-20T02:41:33+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad003cfde13", "title": "Find all segments of a LineString within distance of a point", "url": "https://www.spdba.com.au/find-all-segments-of-a-linestring-within-distance-of-a-point/", "published_at": "2020-04-16T00:29:05+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad004b41366", "title": "A Short Biography", "url": "https://www.spdba.com.au/a-short-biography/", "published_at": "2020-04-15T07:02:23+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad005868cad", "title": "Customers", "url": "https://www.spdba.com.au/customers/", "published_at": "2020-04-15T07:00:35+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad0063d4ac0", "title": "FOSSLIC – PostGIS presentations", "url": "https://www.spdba.com.au/fosslic-postgis-presentations/", "published_at": "2020-04-15T06:58:24+00:00" }, { "id": "01a0d1a1-3156-72d9-967c-0ad0073025ed", "title": "Vectorization: Exploding a linestring or polygon into individual vectors in PostGIS", "url": "https://www.spdba.com.au/vectorization-exploding-a-linestring-or-polygon-into-individual-vectors-in-postgis/", "published_at": "2020-04-15T06:56:35+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-323257e39cb4", "title": "How to apply spatial constraints to PostGIS tables", "url": "https://www.spdba.com.au/how-to-apply-spatial-constraints-to-postgis-tables/", "published_at": "2020-04-15T06:30:02+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-323258d3204f", "title": "GIS software and Database Primary Keys", "url": "https://www.spdba.com.au/gis-software-and-database-primary-keys/", "published_at": "2020-04-15T05:47:36+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-32325963825d", "title": "To Constrain or Not to Constrain: There should be NO Question", "url": "https://www.spdba.com.au/to-constrain-or-not-to-constrain-there-should-be-no-question/", "published_at": "2020-04-15T04:20:14+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-323259b74fd7", "title": "Loading and Processing GPX 1.1 files using PostgreSQL XML", "url": "https://www.spdba.com.au/loading-and-processing-gpx-1-1-files-using-postgresql-xml/", "published_at": "2020-04-15T04:15:48+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-32325a98a8c9", "title": "Loading Shapefiles into Geography type column in SQL Server 2008", "url": "https://www.spdba.com.au/loading-shapefiles-into-geography-type-column-in-sql-server-2008/", "published_at": "2020-04-15T04:13:01+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-32325b1e4aa4", "title": "Converting Oracle Optimized Rectangles to PostGIS", "url": "https://www.spdba.com.au/converting-oracle-optimized-rectangles-to-postgis/", "published_at": "2020-04-15T04:05:49+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-32325b3ae932", "title": "The Shapefile 2.0 Manifesto", "url": "https://www.spdba.com.au/the-shapefile-2-0-manifesto/", "published_at": "2020-04-15T03:52:48+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-32325b5a0ff0", "title": "Building polygons from overlapping linestrings requiring intersection", "url": "https://www.spdba.com.au/building-polygons-from-overlapping-linestrings-requiring-intersection/", "published_at": "2020-04-15T03:41:14+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-32325c126d8a", "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-2/", "published_at": "2020-04-15T02:17:51+00:00" }, { "id": "01a0d1a1-5b02-734d-854a-32325cbcd8bc", "title": "Loading Point Data from a CSV File in PostGIS", "url": "https://www.spdba.com.au/loading-point-data-from-a-csv-file-in-postgis/", "published_at": "2020-04-15T01:41:59+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f3fe4188", "title": "Loading Spatial Data from an external CSV file in Oracle", "url": "https://www.spdba.com.au/loading-spatial-data-from-an-external-csv-file-in-oracle/", "published_at": "2020-04-15T01:38:07+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f4a6e8bd", "title": "Calling the Oracle Spatial shapefile loader from within the Oracle database itself", "url": "https://www.spdba.com.au/calling-the-oracle-spatial-shapefile-loader-from-within-the-oracle-database-itself/", "published_at": "2020-04-15T01:10:38+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f575109e", "title": "DMS2DD for PostGIS", "url": "https://www.spdba.com.au/dms2dd-for-postgis/", "published_at": "2020-04-15T00:57:44+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f5e55435", "title": "Converting Google Earth Formatted Longitude/Latitude points to decimal degrees", "url": "https://www.spdba.com.au/converting-google-earth-formatted-longitude-latitude-points-to-decimal-degrees/", "published_at": "2020-04-13T06:16:44+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f6b9fbb8", "title": "Implementing SDO_VertexUpdate/ST_VertexUpdate for Oracle", "url": "https://www.spdba.com.au/implementing-sdo_vertexupdate-st_vertexupdate-for-oracle/", "published_at": "2020-04-13T06:01:10+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f7b54b6a", "title": "Implementing SDO_RemovePoint/ST_RemovePoint for Oracle", "url": "https://www.spdba.com.au/implementing-sdo_removepoint-st_removepoint-for-oracle/", "published_at": "2020-04-13T05:35:51+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f7c1f36a", "title": "Implementing SDO_AddPoint/ST_AddPoint for Oracle", "url": "https://www.spdba.com.au/1959-2/", "published_at": "2020-04-13T05:22:19+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f7d2722b", "title": "ESRI ArcSDE Exverted and Inverted Polygons and Oracle Spatial", "url": "https://www.spdba.com.au/esri-arcsde-exverted-and-inverted-polygons-and-oracle-spatial/", "published_at": "2020-04-13T04:55:26+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f817a923", "title": "Implementing Oracle’s GetVertices function in PostGIS – ST_DumpPoints", "url": "https://www.spdba.com.au/implementing-oracles-getvertices-function-in-postgis-st_dumppoints/", "published_at": "2020-04-13T04:35:07+00:00" }, { "id": "01a0d1a1-849b-7216-a952-6a59f8d59ad8", "title": "Funky Fix Ordinates By Formula", "url": "https://www.spdba.com.au/funky-fix-ordinates-by-formula/", "published_at": "2020-04-13T03:51: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

Free Union, Intersection, Xor and Difference Functions for Oracle Locator – Part 1original ↗
21 Jul 2020
Effects of Sdo_Geometry Ordinate Precision on Storageoriginal ↗
21 Jul 2020
Finding Intersection Points between Line and Polygonoriginal ↗
21 Jul 2020
SDO2GeoJSONoriginal ↗
17 Jul 2020
ST_Parallel for PostGISoriginal ↗
17 Jul 2020
Free version of sdo_lengthoriginal ↗
17 Jul 2020
Alternative to my SQL based GetNumRings functionoriginal ↗
17 Jul 2020
EXPORTERoriginal ↗
17 Jul 2020
External Tables and SDO_Geometry data.original ↗
17 Jul 2020
layer_gtype keyword issue when indexing linear data on 11goriginal ↗
17 Jul 2020
String Tokenizer for Oracleoriginal ↗
17 Jul 2020
Free Aggregate Method for Concatenating 2D Lines in Oracle Locator 10goriginal ↗
17 Jul 2020
Reducing 5 Vertex Polygon to Optimized Rectangleoriginal ↗
17 Jul 2020
Square Bufferoriginal ↗
17 Jul 2020
Converting decimal seconds to stringoriginal ↗
17 Jul 2020
2011 Oracle Spatial Excellence Award for Education and Researchoriginal ↗
17 Jul 2020
SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT – 13356 Issuesoriginal ↗
17 Jul 2020
Valid conversion unit values for Oracle sdo_geom.sdo_length()original ↗
17 Jul 2020
COGO: Converting (Google Earth) Formatted Longitude/Latitude points to decimal degrees (SQL Server)original ↗
17 Jul 2020
COGO: Convert Degrees, Minutes and Seconds values to Decimal Degreesoriginal ↗
17 Jul 2020
COGO: Convert DMS String to decimal degrees floating point number.original ↗
17 Jul 2020
COGO: DD2DMS Formatting a latitude/longitude decimal degree valueoriginal ↗
17 Jul 2020
COGO: TSQL Function For Creating a Point from Point, Bearing and Distanceoriginal ↗
17 Jul 2020
COGO: Compute number of vertices required to stroke circle or circular arcoriginal ↗
17 Jul 2020
COGO: TSQL Function to Calculate the Bearing Between Two Pointsoriginal ↗
17 Jul 2020
COGO: Compute arc length subtended by angle centre of circleoriginal ↗
17 Jul 2020
COGO: Compute chord length of segment of a circle (arc)original ↗
17 Jul 2020
COGO: Computing Arc To Chord (Arc2Chord) Separationoriginal ↗
17 Jul 2020
COGO: Creating a stroked polygon from a circle’s centre x,y and radiusoriginal ↗
17 Jul 2020
COGO: Finding centre and radius of a curve defined by three points: FindCircle functionoriginal ↗
17 Jul 2020
Removing Steps in Gridded Vector Data – SmoothGrid for Oracleoriginal ↗
16 Jul 2020
Oracle Spatial DISJOINT search/filteringoriginal ↗
16 Jul 2020
Tiling Very Large Rastersoriginal ↗
16 Jul 2020
Generating random point data for SQL Server 2008 Spatialoriginal ↗
16 Jul 2020
Creating SDO_Geometry from geometric data recorded in the columns of a tableoriginal ↗
16 Jul 2020
Concave Hull Geometries in Oracle 11gR2original ↗
16 Jul 2020
Cloud Computing GIS and Standards (OGC/ISO)original ↗
16 Jul 2020
Projecting SDO_GEOM_METADATA DIMINFO XY ordinatesoriginal ↗
16 Jul 2020
Morton Key Function for PostgreSQL/PostGISoriginal ↗
10 Jul 2020
Usefulness of Spatial Metadata as a Foundation for an Australian data.gov and other usesoriginal ↗
10 Jul 2020
New Presentation on Active (Searchable) Spatial Metadata for SQL Server 2008 Spatial and FreeTextoriginal ↗
10 Jul 2020
Instantiating MDSYS.VERTEX_TYPEoriginal ↗
10 Jul 2020
New PL/SQL Packages – Rotate oriented pointoriginal ↗
10 Jul 2020
Vale Professor Pieter Roelof Zwart 1941-2010original ↗
10 Jul 2020
Fast Refreshing Materialized View Containing SDO_GEOMETRY and SDO_GEOM.SDO_AREA functionoriginal ↗
10 Jul 2020
Interview by Nestoria on Real Estate Mappingoriginal ↗
10 Jul 2020
Performance of PL/SQL Functions using SQL vs Pure Codeoriginal ↗
10 Jul 2020
Implementing the BEST VicGrid Projection in Oracle 10gR2original ↗
10 Jul 2020
Making Sdo Geometry Metadataoriginal ↗
10 Jul 2020
ORA-13011 errors when using SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT()original ↗
10 Jul 2020
Mapping surface area of a ruptured pipe in Oracle Spatialoriginal ↗
10 Jul 2020
STisGeo: Checking if a column in a table or a view is of type geometry or geographyoriginal ↗
10 Jul 2020
Extract Polygons from Compound Polygonoriginal ↗
9 Jul 2020
Detecting sdo_geometries with compound (3-point Arcs) segmentsoriginal ↗
9 Jul 2020
GEOMETRY_COLUMNS for Oracle Spatialoriginal ↗
9 Jul 2020
FOSS4G 2009 Sydney Presentationoriginal ↗
9 Jul 2020
Convert GML to SDO_Geometry in Oracle 10gR2original ↗
9 Jul 2020
STGeometryTypes: Extracting all geometry type string values from complex geometryoriginal ↗
9 Jul 2020
Vectorising geometry objects in SQL Server 2008original ↗
9 Jul 2020
STMBR2Geometry/STMBR2Geography functionsoriginal ↗
9 Jul 2020
Extracting geometry types from geometry/geography objects in SQL Server 2008original ↗
9 Jul 2020
Reflecting a Geometry Object Around a Lineoriginal ↗
19 Jun 2020
Implementing Point-based Costs in pgRoutingoriginal ↗
17 Jun 2020
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 3)original ↗
12 Jun 2020
Getting the number of coordinate dimensions of a geometry/geography object in SQL Server 2008original ↗
30 May 2020
STDumpPoints: A Function that Dumps the Vertices/Points in a geometryoriginal ↗
30 May 2020
toGeography and toGeography Conversion Functions for SQL Server 2008 Spatialoriginal ↗
30 May 2020
Spatial Sorting of Data via Morton Key For Oracle Spatial/Locatororiginal ↗
30 May 2020
Write text file with spatial data from SQL Server 2008original ↗
30 May 2020
TSQL String Tokenizer Function for SQL Serveroriginal ↗
30 May 2020
Swapping Ordinates in an SDO_GEOMETRY objectoriginal ↗
30 May 2020
Hat Tip to Philipp Salvisbergoriginal ↗
28 May 2020
Spatially Extending Database Management and Development Tools: GeoRaptor, DBeaver, pgAdmin and SSMSoriginal ↗
10 May 2020
New To_3D Functionoriginal ↗
20 Apr 2020
Extend (Reduce/Contract/Skrink) Function for Oracleoriginal ↗
20 Apr 2020
Find all segments of a LineString within distance of a pointoriginal ↗
16 Apr 2020
A Short Biographyoriginal ↗
15 Apr 2020
Customersoriginal ↗
15 Apr 2020
FOSSLIC – PostGIS presentationsoriginal ↗
15 Apr 2020
Vectorization: Exploding a linestring or polygon into individual vectors in PostGISoriginal ↗
15 Apr 2020
How to apply spatial constraints to PostGIS tablesoriginal ↗
15 Apr 2020
GIS software and Database Primary Keysoriginal ↗
15 Apr 2020
To Constrain or Not to Constrain: There should be NO Questionoriginal ↗
15 Apr 2020
Loading and Processing GPX 1.1 files using PostgreSQL XMLoriginal ↗
15 Apr 2020
Loading Shapefiles into Geography type column in SQL Server 2008original ↗
15 Apr 2020
Converting Oracle Optimized Rectangles to PostGISoriginal ↗
15 Apr 2020
The Shapefile 2.0 Manifestooriginal ↗
15 Apr 2020
Building polygons from overlapping linestrings requiring intersectionoriginal ↗
15 Apr 2020
Loading and Processing GPX 1.1 files using Oracle XMLDBoriginal ↗
15 Apr 2020
Loading Point Data from a CSV File in PostGISoriginal ↗
15 Apr 2020
Loading Spatial Data from an external CSV file in Oracleoriginal ↗
15 Apr 2020
Calling the Oracle Spatial shapefile loader from within the Oracle database itselforiginal ↗
15 Apr 2020
DMS2DD for PostGISoriginal ↗
15 Apr 2020
Converting Google Earth Formatted Longitude/Latitude points to decimal degreesoriginal ↗
13 Apr 2020
Implementing SDO_VertexUpdate/ST_VertexUpdate for Oracleoriginal ↗
13 Apr 2020
Implementing SDO_RemovePoint/ST_RemovePoint for Oracleoriginal ↗
13 Apr 2020
Implementing SDO_AddPoint/ST_AddPoint for Oracleoriginal ↗
13 Apr 2020
ESRI ArcSDE Exverted and Inverted Polygons and Oracle Spatialoriginal ↗
13 Apr 2020
Implementing Oracle’s GetVertices function in PostGIS – ST_DumpPointsoriginal ↗
13 Apr 2020
Funky Fix Ordinates By Formulaoriginal ↗
13 Apr 2020
Previous Next