Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

Popular Tags:
  • Oracle Spatial
  • Source Code
  • Linear Reference System
  • PL/SQL
  • MySQL Spatial
0 $0.00
Primary Menu
  • Home
  • Articles
    • Spatial Database Functions
    • SQL Server Spatial
    • Oracle Spatial and Locator
    • PostGIS
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Linear Referencing
    • Software Change LogDescribes changes to packaged software.
  • About
  • Contact
  • Shop
0 $0.00
x
Popular Tags:
  • Oracle Spatial
  • Source Code
  • Linear Reference System
  • PL/SQL
  • MySQL Spatial
  • Login
Home / 2021 / April / 23

Day: 23 April 2021

  • GeoRaptor
  • Import Export
  • Oracle Spatial and Locator

GeoRaptor: Importing a Shapefile into a table

23 Apr 2021 By Simon Greener

Using GeoRaptor to Load Shapefile(s) into a table

Leave a Comment on GeoRaptor: Importing a Shapefile into a table
GeoRaptor: Simple Mapping
  • GeoRaptor
  • Oracle Spatial and Locator

GeoRaptor: Simple Mapping

23 Apr 2021 By Simon Greener

A simple demonstration of how to map SDO_GEOMETRY data from two different sources.

Leave a Comment on GeoRaptor: Simple Mapping
  • GeoRaptor
  • Oracle Spatial and Locator

GeoRaptor: Visualising Geometry Objects

23 Apr 2021 By Simon Greener

GeoRaptor can represent SDO_GEOMETRY data using a number of visual formats such as WKT, GML and KML, but also “enhanced” SDO_GEOMETRY formatting using colour and coordinate grouping. GeoRaptor even supports the visualiation of the actual geometry using a thumbnail.

Leave a Comment on GeoRaptor: Visualising Geometry Objects

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.