I am working on Oracle Spatial 11g and I am referring to Oracle docs as a learning resource.
Does any one know any more Oracle Spatial tutorials?
We want to integrate Oracle Spatial data with ArcGIS and QGIS.
[GIS] Seeking Oracle Spatial tutorials
oracle-spatialreferences
Related Solutions
This question has been converted to Community Wiki and wiki locked because it is an example of a question that seeks a list of answers and appears to be popular enough to protect it from closure. It should be treated as a special case and should not be viewed as the type of question that is encouraged on this, or any Stack Exchange site, but if you wish to contribute more content to it then feel free to do so by editing this answer.
There's quite a few resources for learning 'spatial' R online:
A really solid blog post by Frank Davenport, with notes on some basic spatial data manipulation in R
R Spatial Tips (Internet Archive link, original site seems to be gone)
Barry Rowlingson's site containing some great examples and a cheatsheet
I'd strongly recommend Analysing spatial point patterns in 'R' by Prof. Adrian Baddeley at the CSIRO in Australia. It covers the
spatstatmodule in depth and I think it's a great resource for cluster analysis.Applied Spatial Data Analysis in R (Bivand, Roger S., Pebesma, Edzer J., Gómez-Rubio, Virgilio) and Spatial Statistics and Modeling (Gaetan, Carlo, Guyon, Xavier) are also both great books.
Virgilio Gómez Rubio's (he is the author of the famous/superuseful ASDAR book, mentioned in other answers) website provides materials to his tutorials from useR! conferences - slides, data and code are available.
Apart from ADAR, there is now new book 'An Introduction to R for Spatial Analysis and Mapping' by Brundson & Comber with code available for download.
CSDE (University of Washington) course on GIS has some spatial R materials, focusing on ESDA, GWR, spatial regression
Maps with R I (II, III) series of blog posts offer a lot of extensively commented code that you can learn from.
UC Davis Soil Resource Laboratory has a nice collection of tips and examples of spatial R
Francisco Rodriguez-Sanchez has a nice materials on 'Spatial data in R: Using R as a GIS'.
A Practical Guide to Geostatistical Mapping by T. Hengl
Comprehensive Tutorial for Spatio-Temporal R Package (Bergen et al., 2013)
ggmap: Spatial Visualization with ggplot2 (Kahle and Wickham)
D.G Rossiter (lecture notes)
A few nice tutorials, including some with a focus on interactivity (often listed as a weakness of doing GIS with R)
- Spatial data in R: Using R as a GIS: A tutorial to perform basic operations with spatial data in R, such as importing and exporting data (both vectorial and raster), plotting, analysing and making maps. by Francisco Rodriguez-Sanchez
- Using RStudio as an interactive GIS with Leaflet by Kyle Walker, Texas Christian University
- Working with PostGIS from R by Duncan Golicher
- Geospatial Data Processing and Analysis in R by Andy Lyons
I also made a quick easy and holistic tutorial you folks can check out here https://github.com/mattjbayly/MapsProj. All you need is the R text script and all other material is downloaded remotely from R.
My tutorial covered GIS data imports/exports, basic manipulation of vector & raster data, some of basic plotting and a brief overview of projections. Estimated time to complete: 60mins
We did have similar issue with Oracle Spatial. In our case we need to adding more permissios for geom-columns (or whatever column you use to store geometries).
GRANT UPDATE ("GEOM") ON "MYSCHEMA"."MYTABLE" TO "OTHERSCHEMA_USER";
It seems that other GIS desktop applications are not so strict.
More information from QGIS Developer email list.
Best Answer
I suggest starting with this excellent pdf for the conceptual aspects:
Then move onto the dev guide (11gR2 here, about 900 pages worth):
At that point you'll be informed enough to integrate Oracle Spatial professionally into any Desktop GIS application. Specifically for ArcGIS, here's the ground rules and documentation for using SDO_Geometry within ArcSDE geodatabases: