Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
PostGIS: Creating a line inside a polygon
I love working with the PostGIS API. It is a deep and wide river to swim in. But sometime having read, researched, experimented, and not
7 August, 2020
No Comments
Urban Trees Data Model
Data model for the recording of urban trees in a city, town or council
7 August, 2020
No Comments
Scheduling the Export of Spatial Data in Oracle to a Shapefile each night
While there is always a need for software like Safe Software’s Awesome FME to automate import and export tasks from your database, the ability to
5 August, 2020
No Comments
ST_Densify for Object PLSQL
The Java Topology Suite (JTS) has a linestring densifier function that is available in my Spatial Companion for Oracle (SC4O) solution. See here for documentation.
5 August, 2020
No Comments
PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)
Previously I created the following Java stored procedures to enable the import/export of ZM aware WKT. ST_GeomFromText ST_GeomFromEWKT ST_AsText ST_AsEWKT These functions are necessary if
5 August, 2020
No Comments
Noding and building a polygon from single, overlapping linestrings
The Spatial Companion 4 Oracle (SC4O) package (built using Java Topology Suite components) contains a method called ST_PolygonBuilder that can then form polygons from linestrings.
5 August, 2020
No Comments
Extend (Reduce/Contract/Skrink) Function for Oracle
Recently I was looking at some cadastral data with a view to working out how to polygonize the linestrings. The data contains this sort of
20 April, 2020
No Comments
Change Log For Open Source Spatial Scripts and Extensions.
This page documents the changes made to all my Open Source Spatial Database Scripts.
15 January, 2019
No Comments