First Steps in Spatial Data

This session describes my first steps working with Oracle Spatial data. It looks at some fundamental concepts and how to get started with Spatial. 
I wanted to work out which GPS tracks pass through which areas. 
On the way, I had to 
  • load flat files into the database
  • read XML data,
  • convert GPS tracks to Spatial objects
  • load publically available data sets for political and administrative areas, 
  • process and compare spatial objects 
  • and produce a responsive front-end query application in Apex
I have written a series of blogs upon which this presentation was based, and all the files are available on Github.

A video of this presentation (given at DOAG2021) is available.