Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

Search for:

Popular Tags:

Source Code
GNU Lesser General Public License Version 3
Oracle Spatial
SQL Server Spatial
Linear Reference System

0 $0.00

Primary Menu

Home
Articles
About
Contact
Shop

0 $0.00

x

Search for:

Popular Tags:

Source Code
GNU Lesser General Public License Version 3
Oracle Spatial
SQL Server Spatial
Linear Reference System

Login/Register

Home / Data Models

Data Models

All
Blog
Data Models
Open Source

Urban Trees Data Model

07 Aug 2020 By Simon Greener

Data model for the recording of urban trees in a city, town or council

Leave a Comment on Urban Trees Data Model

Top 5 Recent Articles

OptimoRoute 27 May, 2024
Functions to Convert Native PostgreSQL geometric types to PostGIS 18 May, 2024
Converting PostgreSQL Native Geometric Types to PostGIS 17 May, 2024
Fitting Bezier Polygon to Points 30 April, 2024
Fixing Geography Ring Orientation 30 December, 2022

Documentation

MySQL Spatial General Functions
Oracle LRS Objects
Oracle Spatial Exporter (Java + pl/SQL)
Oracle Spatial Object Functions
Oracle Spatial Object Functions (Multi Page)
PostGIS pl/pgSQL Functions
SC4O Oracle Java Topology Suite (Java + pl/SQL)
SQL Server Spatial General TSQL Functions
SQL Server Spatial LRS TSQL Functions

SQL Server General Articles

Fixing Geography Ring Orientation 30 December, 2022 4:24 PM
Delaunay Triangulation Function for TSQL and SQL Server Spatial 18 April, 2022 2:51 PM
Creating linestring geometries from a table of ordinates (SQL Server) 18 April, 2022 12:24 PM
Partition Spatial Data using SQL Server 13 April, 2022 11:07 AM
Removing Spikes in SQL Server Spatial Linestrings 7 April, 2022 4:45 PM
How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads 22 March, 2022 10:40 AM
qGIS, GEOMETRY_COLUMNS and SQL Server Spatial 3 November, 2021 2:19 PM
Removing Duplicate Vertices in SQL Server Spatial 23 October, 2021 4:13 PM
Geometry object size when exchanging of WKT/WKB encoded geometries. 12 December, 2020 5:21 PM
Geometry Validity and Method Access 6 December, 2020 12:26 PM
Linear Referencing System (LRS) Functions for TSQL 6 December, 2020 8:28 AM
Pseudo Array Implementation for SQL Server Spatial (Part 2) 30 November, 2020 4:36 PM
CheckRadii: Identifying Tight Radius Curves sections within LineString geometry data 30 November, 2020 3:58 PM
Overlaying Polygons in SQL Server Spatial 25 November, 2020 2:07 PM
Space Filling Curve Functions For TSQL 22 November, 2020 7:32 AM
Bing Maps Tile System Functions for TSQL 19 November, 2020 4:48 PM
Geocoding Points Against a Grid of Cells/Tiles With/out Spatial Operators 19 November, 2020 3:30 PM
Using a GeometryCollection as an Array for TSQL (Stored Procedure) Development. 6 November, 2020 11:14 AM
Identifying Quadrilateral Polygon Geometries in SQL Server Spatial 16 October, 2020 1:20 PM
STLineToCurve. A Function that Converts a LineString to a CircularString, CompoundCurve or CurvePolygon. 15 October, 2020 3:45 PM
STInsertN: Insert single vertex into a geometry 7 August, 2020 3:20 PM
STUpdateN: Update (replace) a single vertex within a geometry object. 7 August, 2020 3:16 PM
STUpdate: Replace all points equal to the supplied point with replacement point. 7 August, 2020 3:12 PM
STDeleteN: Delete single vertex from geometry 7 August, 2020 3:06 PM
STDelete: Deleting vertices in geometry objects 7 August, 2020 3:01 PM
STFlipVectors: Normalize direction of linestring vectors 5 August, 2020 5:08 PM
STConvertToLineString: Extract LineStrings in GeometryCollection to create LineString 5 August, 2020 5:04 PM
STCogo2Line: Creating (Multi)LineStrings geometries from COGO XML instructions 5 August, 2020 5:02 PM
STLine2Cogo: Converting LineStrings to COGO XML 5 August, 2020 4:57 PM
STVectorize: Break Linestring/Polygon elements into 2 point vectors (or 3 point circular curves) 5 August, 2020 3:05 PM
STScale: Function to Scale a geometry object 31 July, 2020 4:14 PM
STGeometry2MBR/STGeography2MBR: Compute and return MBR ordinates 31 July, 2020 4:10 PM
STExtractPolygon: Extract Polygons from result of STIntersection in SQL Server Spatial 27 July, 2020 11:06 AM
STRound: Function to round ordinates of a SQL Server Spatial geometry object 27 July, 2020 10:58 AM
STExtract: Extract elements of a geometry object 27 July, 2020 10:55 AM
STNumRings: Counting number of polygon rings 27 July, 2020 10:45 AM
STFilterRings: Removing rings from Polygon based on area. 27 July, 2020 10:41 AM
STMove: Function to Move a geometry object in SQL Server Spatial 27 July, 2020 10:37 AM
STCentroid*: Alternate Functions for Compute a Centroid 27 July, 2020 10:32 AM
STRotate: Function to rotate a geometry object in SQL Server Spatial 27 July, 2020 10:23 AM
STVertices: Wrapper over STDumpPoints 27 July, 2020 10:18 AM
STMorton: Creating a Morton Number Space Key Value for Grid Cells 27 July, 2020 10:15 AM
Gridding a geometry or geography object (SQL Server Denali) 24 July, 2020 3:37 PM
On hinting spatial indexes 24 July, 2020 12:00 PM
RandomSearchByExtent: Random Search Procedure (2008 Spatial) 24 July, 2020 11:56 AM
COGO: Converting (Google Earth) Formatted Longitude/Latitude points to decimal degrees (SQL Server) 17 July, 2020 11:36 AM
COGO: Convert Degrees, Minutes and Seconds values to Decimal Degrees 17 July, 2020 11:31 AM
COGO: Convert DMS String to decimal degrees floating point number. 17 July, 2020 11:25 AM
COGO: DD2DMS Formatting a latitude/longitude decimal degree value 17 July, 2020 11:19 AM
COGO: TSQL Function For Creating a Point from Point, Bearing and Distance 17 July, 2020 11:14 AM
COGO: Compute number of vertices required to stroke circle or circular arc 17 July, 2020 11:10 AM
COGO: TSQL Function to Calculate the Bearing Between Two Points 17 July, 2020 11:06 AM
COGO: Compute arc length subtended by angle centre of circle 17 July, 2020 11:01 AM
COGO: Compute chord length of segment of a circle (arc) 17 July, 2020 10:57 AM
COGO: Computing Arc To Chord (Arc2Chord) Separation 17 July, 2020 10:53 AM
COGO: Creating a stroked polygon from a circle’s centre x,y and radius 17 July, 2020 10:48 AM
COGO: Finding centre and radius of a curve defined by three points: FindCircle function 17 July, 2020 10:40 AM
Generating random point data for SQL Server 2008 Spatial 16 July, 2020 2:59 PM
New Presentation on Active (Searchable) Spatial Metadata for SQL Server 2008 Spatial and FreeText 10 July, 2020 1:46 PM
STisGeo: Checking if a column in a table or a view is of type geometry or geography 10 July, 2020 11:30 AM
STGeometryTypes: Extracting all geometry type string values from complex geometry 9 July, 2020 3:50 PM
Vectorising geometry objects in SQL Server 2008 9 July, 2020 3:41 PM
STMBR2Geometry/STMBR2Geography functions 9 July, 2020 3:11 PM
Extracting geometry types from geometry/geography objects in SQL Server 2008 9 July, 2020 3:00 PM
Reflecting a Geometry Object Around a Line 19 June, 2020 6:25 PM
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 3) 12 June, 2020 5:06 PM
Getting the number of coordinate dimensions of a geometry/geography object in SQL Server 2008 30 May, 2020 3:38 PM
STDumpPoints: A Function that Dumps the Vertices/Points in a geometry 30 May, 2020 3:28 PM
toGeography and toGeography Conversion Functions for SQL Server 2008 Spatial 30 May, 2020 3:18 PM
Write text file with spatial data from SQL Server 2008 30 May, 2020 2:54 PM
TSQL String Tokenizer Function for SQL Server 30 May, 2020 1:11 PM
Spatially Extending Database Management and Development Tools: GeoRaptor, DBeaver, pgAdmin and SSMS 10 May, 2020 3:22 PM
Loading Shapefiles into Geography type column in SQL Server 2008 15 April, 2020 2:13 PM
generate_series for SQL Server 2008 1 April, 2020 2:25 PM
Tip #6: Correcting invalid geometries 27 March, 2020 3:46 PM
Tip #5: Where or where has my little column gone 27 March, 2020 2:32 PM
Tip #4: What Coordinate System is that? 27 March, 2020 1:17 PM
Tip #3: What object is that? 27 March, 2020 1:09 PM
Tip #2: Spatial Indexing and Primary Keys 27 March, 2020 1:00 PM
Tip #1: SQL Server 2008 “Katmai” – Setting SRIDs 27 March, 2020 12:54 PM
STDensify: Densify LineString or Polygon geometry objects 20 February, 2020 3:18 PM
STGeometryTypes: Extracting all geometry type string values from a complex geometry 20 February, 2020 3:02 PM
STAsEWKT 3 January, 2020 2:37 PM
STGeomFromEWKT 1 January, 2020 5:54 PM
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 2) 20 November, 2019 9:26 AM
Using SQL Server XML and Spatial to import VicMap seed/Incremental Update Format (IUF) data (Part 1) 5 October, 2019 6:33 PM
STMulti 10 September, 2019 4:45 PM
STRound 10 September, 2019 9:53 AM
STIsPseudoMultiCurve 5 July, 2019 4:53 PM
STScale 4 July, 2019 2:05 PM
STMove 4 July, 2019 12:14 PM
Change Log For Open Source Spatial Scripts and Extensions. 15 January, 2019 9:33 AM

SQL Server LRS Articles

2011 Oracle Spatial Excellence Award for Education and Research 17 July, 2020 12:14 PM
3D/4D and SRID aware Conversion functions for SDO_Geometry: WKT and EWKT 27 July, 2020 11:24 AM
A Biography 26 March, 2020 1:37 PM
A Short Biography 15 April, 2020 5:02 PM
A simple spike finder for Spatial 24 July, 2020 12:06 PM
ADF and Spatial 26 March, 2020 1:25 PM
Aggregate APPEND Islands and XOR polygons 5 August, 2020 11:52 AM
Alternative to my SQL based GetNumRings function 17 July, 2020 4:23 PM
Analyzing Spatial Query Performance Improvements in Oracle Spatial and Graph 12c Through Cross-Vendor Comparison 5 August, 2020 11:54 AM
Announcing the Spatial Companion For Oracle (SC4O) 27 July, 2020 12:27 PM
Application of Delaunay Triangulation and Inverse Distance Weighting (IDW) in Oracle for Soils Interpolation 31 July, 2020 3:17 PM
Applying and Extending Oracle Spatial: Source Code Problem 5 August, 2020 11:38 AM
Australian MGA/AMG Zone Calculation from geographic (longitude/latitude) data 26 March, 2020 4:25 PM
Bing Maps Tile System Functions for TSQL 19 November, 2020 4:48 PM
Boarder and District Spatial Information Group Presentation on Spatial Datbases 1 April, 2020 1:47 PM
Book: “Applying And Extending Oracle Spatial” 5 August, 2020 11:35 AM
Bouquets and Brickbats 26 March, 2020 1:23 PM
Building Lines into Polygons in Oracle Locator / Spatial 21 July, 2020 12:28 PM
Building Polygons from Incomplete Linestrings using ST_PolygonBuilder 5 August, 2020 11:26 AM
Building polygons from overlapping linestrings requiring intersection 15 April, 2020 1:41 PM
Calculating Distance in the Lambert Conformal Conic projection vs WGS84/GDA94 5 July, 2022 5:17 PM
Calling the Oracle Spatial shapefile loader from within the Oracle database itself 15 April, 2020 11:10 AM
CASE Statements and SDO_GEOMETRY 24 July, 2020 3:16 PM
CENTROID 21 July, 2020 12:40 PM
CENTROID For Oracle 27 July, 2020 11:13 AM
CENTROID package – Tips for Use 27 July, 2020 12:30 PM
CENTROID Package now returns centroid of multi-linestring 24 July, 2020 2:56 PM
Centroid Package now supports Y ordinate seeding 5 August, 2020 3:08 PM
CENTROID package update 5 August, 2020 10:41 AM
CENTROID package use with ESRI’s sde.st_geometry 24 July, 2020 3:05 PM
Change Log For Open Source Spatial Scripts and Extensions. 15 January, 2019 9:33 AM
Changes to CENTROID and TESSELATE packages 24 July, 2020 2:59 PM
Changing all DIMINFO sdo_tolerance values for all metadata records in one go. 5 August, 2020 11:31 AM
Changing Oracle Spatial Index Parameters on existing index 24 July, 2020 2:43 PM
CheckRadii: Identifying Tight Radius Curves sections within LineString geometry data 30 November, 2020 3:58 PM
Choosing a Tile Size 26 March, 2020 2:14 PM
Circular Arcs in Geodetic Polygons 5 August, 2020 11:48 AM
Cloud Computing GIS and Standards (OGC/ISO) 16 July, 2020 12:40 PM
COGO 21 July, 2020 1:30 PM
COGO: Compute arc length subtended by angle centre of circle 17 July, 2020 11:01 AM
COGO: Compute chord length of segment of a circle (arc) 17 July, 2020 10:57 AM
COGO: Compute number of vertices required to stroke circle or circular arc 17 July, 2020 11:10 AM
COGO: Computing Arc To Chord (Arc2Chord) Separation 17 July, 2020 10:53 AM
COGO: Convert Degrees, Minutes and Seconds values to Decimal Degrees 17 July, 2020 11:31 AM
COGO: Convert DMS String to decimal degrees floating point number. 17 July, 2020 11:25 AM
COGO: Converting (Google Earth) Formatted Longitude/Latitude points to decimal degrees (SQL Server) 17 July, 2020 11:36 AM
COGO: Converting Decimal Degrees to Degrees Minutes and Seconds – and back again (PostGIS) 27 July, 2020 12:26 PM
COGO: Creating a stroked polygon from a circle’s centre x,y and radius 17 July, 2020 10:48 AM
COGO: DD2DMS Formatting a latitude/longitude decimal degree value 17 July, 2020 11:19 AM
COGO: Finding centre and radius of a curve defined by three points (PostGIS) 27 July, 2020 12:00 PM
COGO: Finding centre and radius of a curve defined by three points: FindCircle function 17 July, 2020 10:40 AM
COGO: TSQL Function For Creating a Point from Point, Bearing and Distance 17 July, 2020 11:14 AM
COGO: TSQL Function to Calculate the Bearing Between Two Points 17 July, 2020 11:06 AM
Compute Location from known Lat/Long point using delta easting and northing in miles 31 July, 2020 4:45 PM
Computing Cardinal Directions to nearby geometries 5 August, 2020 11:21 AM
Concave Hull Geometries in Oracle 11gR2 16 July, 2020 2:43 PM
Configurable Buffer: JTS and Oracle 22 July, 2020 3:41 PM
Constraining geometry type for sdo_geometry column in a table. 24 July, 2020 3:26 PM
Convert GeoJSON document to Sdo_Geometry objects 5 August, 2020 2:56 PM
Convert GML to SDO_Geometry in Oracle 10gR2 9 July, 2020 4:08 PM
Convert Single Geometry to Multi-part Geometry in Oracle Spatial 5 August, 2020 3:25 PM
Convert Single Point stored in SDO_ORDINATES to SDO_POINT_TYPE 5 August, 2020 11:59 AM
Converting decimal seconds to string 17 July, 2020 12:16 PM
Converting distances and units of measure in Oracle Locator 1 April, 2020 10:55 AM
Converting Google Earth Formatted Longitude/Latitude points to decimal degrees 13 April, 2020 4:16 PM
Converting Oracle Optimized Rectangles to PostGIS 15 April, 2020 2:05 PM
Converting PostgreSQL Native Geometric Types to PostGIS 17 May, 2024 4:59 PM
Create GeoJSON Document from Selection of SDO_Geometry objects. 30 October, 2020 1:16 PM
Create Polygons and Linestrings From Bearings And Distances (COGO) 5 August, 2020 2:43 PM
Creating a Grid of Geographic Tiles 18 November, 2019 3:03 PM
Creating linestring geometries from a table of ordinates (Oracle) 18 April, 2022 11:13 AM
Creating linestring geometries from a table of ordinates (SQL Server) 18 April, 2022 12:24 PM
Creating linestrings from points 31 July, 2020 3:39 PM
Creating SDO_Geometry from geometric data recorded in the columns of a table 16 July, 2020 2:55 PM
Customers 15 April, 2020 5:00 PM
Delaunay Triangulation Function for TSQL and SQL Server Spatial 18 April, 2022 2:51 PM
Detecting sdo_geometries with compound (3-point Arcs) segments 9 July, 2020 4:28 PM
DMS2DD for PostGIS 15 April, 2020 10:57 AM
Drawing a layer in GeoRaptor: Simple Gotchas! 5 August, 2020 11:10 AM
Duplicate Geometry data and Data Models 5 August, 2020 10:58 AM
Effects of Sdo_Geometry Ordinate Precision on Performance 31 July, 2020 3:29 PM
Effects of Sdo_Geometry Ordinate Precision on Storage 21 July, 2020 11:48 AM
Elem_Info_Array Processing: An alternative to SDO_UTIL.GetNumRings and querying SDO_ELEM_INFO itself 2 April, 2020 12:05 PM
ESRI ArcSDE Exverted and Inverted Polygons and Oracle Spatial 13 April, 2020 2:55 PM
ESRI Ireland – Many Thanks 26 March, 2020 1:34 PM
Experience With GIS Desktop Software 19 November, 2020 4:26 PM
EXPORTER 17 July, 2020 1:00 PM
Exposing JTS’s Densifier functionality 22 July, 2020 4:26 PM
Exposing JTS’s MinimumBoundingCircle functionality 22 July, 2020 4:36 PM
Extend (Reduce/Contract/Skrink) Function for Oracle 20 April, 2020 12:41 PM
External Tables and SDO_Geometry data. 17 July, 2020 12:50 PM
Extract Polygons from Compound Polygon 9 July, 2020 4:33 PM
Extracting geometry types from geometry/geography objects in SQL Server 2008 9 July, 2020 3:00 PM
Extracting Inner Rings Changed Ordinate Ordering: A Trap For Players Who Don’t Read Documentation! 5 August, 2020 2:11 PM
Fast Refreshing Materialized View Containing SDO_GEOMETRY and SDO_GEOM.SDO_AREA function 10 July, 2020 1:29 PM
FAST REFRESHing of Oracle Materialized Views containing Sdo_Geometry columns 26 March, 2020 5:11 PM
Feature Data Objects – Either/Or? 26 March, 2020 1:12 PM
Filtering Rings (Oracle Spatial) 6 April, 2020 1:54 PM
Filtering Rings in Polygon (PostGIS) 2 April, 2020 2:45 PM
Filtering very short linestrings via bitmap function index 27 July, 2020 11:17 AM

MySQL Spatial Articles

ST_Scale for MySQL Spatial
ST_Round for MySQL Spatial
ST_Rotate for MySQL Spatial
ST_Move for MySQL Spatial
ST_Move
Spatial Functions for MySQL
Change Log For Open Source Spatial Scripts and Extensions.

Oracle Spatial Articles

Creating linestring geometries from a table of ordinates (Oracle) 18 April, 2022 11:13 AM
How to calculate cumulative length of a linestring, or the truck tonnage that accumulates across a set of roads 22 March, 2022 10:40 AM
Visualising the Topological Relations of LineStrings 17 September, 2021 5:29 PM
Object Implementation of Oracle SDO_LRS 5 July, 2021 1:59 PM
Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2) 30 June, 2021 2:34 PM
Split Oracle Sdo_Geometry Linestring at a Known Point using PL/SQL (1) 30 June, 2021 2:00 PM
GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects 28 June, 2021 2:04 PM
Snapping a Point to an Oracle Spatial SDO_GEOMETRY LineString 26 June, 2021 3:19 PM
GeoRaptor: Layer Properties 31 May, 2021 3:11 PM
GeoRaptor: Exporting GeoJSON and viewing in Tatuk GIS Viewer 26 May, 2021 4:49 PM
GeoRaptor: Exporting GML and visualising in qGIS 20 May, 2021 4:32 PM
GeoRaptor: Area Rendering Options 5 May, 2021 1:26 PM
GeoRaptor: Views and On The Fly Projection 24 April, 2021 6:15 PM
GeoRaptor: Metadata Management 24 April, 2021 2:06 PM
GeoRaptor: Importing a Shapefile into a table 23 April, 2021 4:08 PM
GeoRaptor: Simple Mapping 23 April, 2021 2:20 PM
GeoRaptor: Visualising Geometry Objects 23 April, 2021 8:59 AM
GeoRaptor: Working with xxx_SDO_GEOM_METADATA records. 22 April, 2021 11:19 AM
GeoRaptor 18+: Downloading and Installing beta 7 April, 2021 1:32 PM
Oracle 21c: Locator is no more 18 January, 2021 9:46 AM
Oracle Spatial Vector Acceleration: Flick the Switch 18 January, 2021 9:30 AM
Geometry object size when exchanging of WKT/WKB encoded geometries. 12 December, 2020 5:21 PM
Geometry Validity and Method Access 6 December, 2020 12:26 PM
Oracle Spatial Mapping and Map Rendering Performance Tips 23 November, 2020 4:40 PM
The Frontage Problem: Creating references from land parcel street frontage boundary to point in street 3 November, 2020 2:03 PM
Create GeoJSON Document from Selection of SDO_Geometry objects. 30 October, 2020 1:16 PM
Using Oracle’s ST_GEOMETRY type hierarchy with SDO_GEOMETRY: ST_PointN and ST_NumPoints 7 August, 2020 2:55 PM
Scheduling the Export of Spatial Data in Oracle to a Shapefile each night 5 August, 2020 5:32 PM
ST_Densify for Object PLSQL 5 August, 2020 5:23 PM
PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version) 5 August, 2020 5:19 PM
Tip: Drop that Spatial Index! 5 August, 2020 3:28 PM
Convert Single Geometry to Multi-part Geometry in Oracle Spatial 5 August, 2020 3:25 PM
Optimized Rectangle to 5 Point Polygon 5 August, 2020 3:14 PM
Centroid Package now supports Y ordinate seeding 5 August, 2020 3:08 PM
Convert GeoJSON document to Sdo_Geometry objects 5 August, 2020 2:56 PM
Simple Implementation Of Travelling Salesman Problem 5 August, 2020 2:48 PM
Create Polygons and Linestrings From Bearings And Distances (COGO) 5 August, 2020 2:43 PM
Function That Returns a Compass Point From a Whole Circle Bearing 5 August, 2020 2:35 PM
Playing around with Centroids by using different seed values 5 August, 2020 2:29 PM
Simple Oracle C Sprintf or Java String.format 5 August, 2020 2:23 PM
Some Oriented Point Functions 5 August, 2020 2:15 PM
Extracting Inner Rings Changed Ordinate Ordering: A Trap For Players Who Don’t Read Documentation! 5 August, 2020 2:11 PM
PLS-00306: wrong number or types of arguments in call to ‘SDO_GEOMETRY’ 5 August, 2020 2:06 PM
Oracle Business Intelligence Warehousing and Analytics – Spatial Summit 5 August, 2020 1:40 PM
How far inside, is inside? Measuring actual distance. 5 August, 2020 1:36 PM
Noding and building a polygon from single, overlapping linestrings 5 August, 2020 1:32 PM
ST_VertexN / ST_PointN – Extracting a specific point from any geometry 5 August, 2020 12:06 PM
Convert Single Point stored in SDO_ORDINATES to SDO_POINT_TYPE 5 August, 2020 11:59 AM
Analyzing Spatial Query Performance Improvements in Oracle Spatial and Graph 12c Through Cross-Vendor Comparison 5 August, 2020 11:54 AM
Aggregate APPEND Islands and XOR polygons 5 August, 2020 11:52 AM
Circular Arcs in Geodetic Polygons 5 August, 2020 11:48 AM
Some SDO_GEOMETRY/DIMINFO handling functions 5 August, 2020 11:45 AM
Book: “Applying And Extending Oracle Spatial” 5 August, 2020 11:35 AM
Changing all DIMINFO sdo_tolerance values for all metadata records in one go. 5 August, 2020 11:31 AM
Building Polygons from Incomplete Linestrings using ST_PolygonBuilder 5 August, 2020 11:26 AM
Computing Cardinal Directions to nearby geometries 5 August, 2020 11:21 AM
Intersecting two aggregated polygon layers with SC4O 5 August, 2020 11:17 AM
Spatial and Oracle 12c 5 August, 2020 11:08 AM
Update Triggers and SDO_GEOMETRY Equality 5 August, 2020 11:06 AM
Duplicate Geometry data and Data Models 5 August, 2020 10:58 AM
CENTROID package update 5 August, 2020 10:41 AM
Useful Package of Wrapper Functions for Sdo_Util.AffineTransforms 31 July, 2020 4:59 PM
Compute Location from known Lat/Long point using delta easting and northing in miles 31 July, 2020 4:45 PM
Sorting SDO_GEOMETRY data using the ORDER BY clause of a SELECT statement 31 July, 2020 4:39 PM
SDO_AGGR_SET_UNION 31 July, 2020 4:30 PM
Rounding Coordinates or Ordinates in SDO_GEOMETRY 31 July, 2020 4:22 PM
Creating linestrings from points 31 July, 2020 3:39 PM
Effects of Sdo_Geometry Ordinate Precision on Performance 31 July, 2020 3:29 PM
The Spatial filtering of geometries: The effect of tolerances on relationships 31 July, 2020 3:23 PM
Application of Delaunay Triangulation and Inverse Distance Weighting (IDW) in Oracle for Soils Interpolation 31 July, 2020 3:17 PM
Selecting all SDO_GTYPE values for all tables/sdo_geometry columns in a schema 31 July, 2020 3:09 PM
CENTROID package – Tips for Use 27 July, 2020 12:30 PM
Announcing the Spatial Companion For Oracle (SC4O) 27 July, 2020 12:27 PM
Splitting a polygon using one or more linestrings 27 July, 2020 11:38 AM
isValid, isSimple, Dimension and CoordDim methods for SDO_Geometry 27 July, 2020 11:33 AM
Line Merging or Collecting lines together: ST_LineMerger 27 July, 2020 11:31 AM
ST_DeleteVertex for Oracle SDO_Geometry based on Jaspa/JTS 27 July, 2020 11:27 AM
3D/4D and SRID aware Conversion functions for SDO_Geometry: WKT and EWKT 27 July, 2020 11:24 AM
Topological vs Non-Topological Simplification/Generalization of Aggregated Area Geometies in Oracle 27 July, 2020 11:21 AM
Filtering very short linestrings via bitmap function index 27 July, 2020 11:17 AM
CENTROID For Oracle 27 July, 2020 11:13 AM
Gridding a sdo_geometry line/polygon object (Oracle) 27 July, 2020 10:06 AM
Finding centre and radius of a circular geometry 24 July, 2020 3:31 PM
Constraining geometry type for sdo_geometry column in a table. 24 July, 2020 3:26 PM
The Power of Constraints and Indexes for Spatial Constraints: stopping duplicate points 24 July, 2020 3:21 PM
CASE Statements and SDO_GEOMETRY 24 July, 2020 3:16 PM
Replacement for SDO_GEOM.RELATE – ST_Relate based on JTS 24 July, 2020 2:51 PM
Changing Oracle Spatial Index Parameters on existing index 24 July, 2020 2:43 PM
Writing Excel Spreadsheets files from within the Oracle database using Java and PL/SQL 24 July, 2020 2:39 PM
Writing xSV (eg csv) files from within the Oracle database using Java and PL/SQL 24 July, 2020 12:11 PM
A simple spike finder for Spatial 24 July, 2020 12:06 PM
JTS Java class compilation for 11g and above 24 July, 2020 11:28 AM
Random Spatial Search Procedure 24 July, 2020 11:24 AM
Geometry Snapping using JTS in Oracle 24 July, 2020 11:19 AM
Exposing JTS’s MinimumBoundingCircle functionality 22 July, 2020 4:36 PM
Exposing JTS’s Densifier functionality 22 July, 2020 4:26 PM
Using JTS’s Comparison Functions – HausdorffSimilarityMeasure & AreaSimilarityMeasure with SDO_GEOMETRY 22 July, 2020 4:22 PM
Free JTS-based Area/Length Functions 22 July, 2020 4:15 PM
Handy way of systematically fixing polygon geometries with 13349 and other errors 22 July, 2020 4:11 PM
Standalone CENTROID package now available for download 22 July, 2020 3:54 PM

PostGIS

Functions to Convert Native PostgreSQL geometric types to PostGIS 18 May, 2024 10:23 AM
Converting PostgreSQL Native Geometric Types to PostGIS 17 May, 2024 4:59 PM
GeoRaptor: Direct Display of SDO_GEOMETRY / WKT text objects 28 June, 2021 2:04 PM
Geometry object size when exchanging of WKT/WKB encoded geometries. 12 December, 2020 5:21 PM
Geometry Validity and Method Access 6 December, 2020 12:26 PM
Processing GML data using PostgreSQL’s XMLTABLE 1 October, 2020 12:42 PM
PostGIS: Creating a line inside a polygon 7 August, 2020 2:51 PM
Spatial Representation of a Communications Pit 7 August, 2020 2:47 PM
PGAdmin Finally Has A Spatial Viewer 7 August, 2020 2:06 PM
Generating a Grid (fishnet) of points or polygons for PostGIS 5 August, 2020 10:52 AM
R based Delaunay Triangulation Function for PostGIS using the deldir package 31 July, 2020 4:26 PM
COGO: Converting Decimal Degrees to Degrees Minutes and Seconds – and back again (PostGIS) 27 July, 2020 12:26 PM
COGO: Finding centre and radius of a curve defined by three points (PostGIS) 27 July, 2020 12:00 PM
Gridding a geometry object (PostGIS) 24 July, 2020 3:43 PM
ST_Parallel for PostGIS 17 July, 2020 4:39 PM
Morton Key Function for PostgreSQL/PostGIS 10 July, 2020 2:01 PM
Implementing Point-based Costs in pgRouting 17 June, 2020 10:37 AM
Spatially Extending Database Management and Development Tools: GeoRaptor, DBeaver, pgAdmin and SSMS 10 May, 2020 3:22 PM
FOSSLIC – PostGIS presentations 15 April, 2020 4:58 PM
Vectorization: Exploding a linestring or polygon into individual vectors in PostGIS 15 April, 2020 4:56 PM
How to apply spatial constraints to PostGIS tables 15 April, 2020 4:30 PM
Loading and Processing GPX 1.1 files using PostgreSQL XML 15 April, 2020 2:15 PM
Converting Oracle Optimized Rectangles to PostGIS 15 April, 2020 2:05 PM
Building polygons from overlapping linestrings requiring intersection 15 April, 2020 1:41 PM
Loading Point Data from a CSV File in PostGIS 15 April, 2020 11:41 AM
DMS2DD for PostGIS 15 April, 2020 10:57 AM
Implementing Oracle’s GetVertices function in PostGIS – ST_DumpPoints 13 April, 2020 2:35 PM
Filtering Rings in Polygon (PostGIS) 2 April, 2020 2:45 PM
STAsEWKT 3 January, 2020 2:37 PM
STGeomFromEWKT 1 January, 2020 5:54 PM
Using PostgreSQL’s XML processing to load spatial data 2 September, 2019 6:40 PM
STLocateBetweenElevations 19 July, 2019 4:14 PM
STLineSubstring 19 July, 2019 4:08 PM
STLineInterpolatePoint 19 July, 2019 3:58 PM
Wrapper Functions for PostGIS geography 12 July, 2019 5:01 PM
Change Log For Open Source Spatial Scripts and Extensions. 15 January, 2019 9:33 AM

© The Spatial Database Advisor 2019 | Shopical by AF themes.