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)
Boarder and District Spatial Information Group Presentation on Spatial Datbases
On Tuesday November 11th 2008 I gave a 1 hour presentation on spatial databases entitled An Introduction to Spatial Databases to the Boader and District Spatial Information Group (BADSIG) at Albury NSW.
The presentation was rather long as, generally, GIS practitioners are usually unfamiliar with database technology (no fault of their own) and so I felt I had to cover the computer science theory behind databases before moving on to describe object-relational databases (the required host technology) by descibing how their extensible type systems are used to create true spatial database implemenations. I also included slides on the OpenGIS and ISO standards that apply to spatial implementations.
Finally, I finished with some examples, drawn from the real world, which showed how spatial database technology can be used to solve business problems.
The presentation was not perfect and was too much information for the group to swallow in one bite, but I have posted it on my site in case anyone is interested in the technology
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