Milestones_on_the_A148_22nd_October_2007_SQLServer

Post navigation

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

Leave a Reply Cancel reply