Would be taking up a course on spatial databases next semester.
Would anybody know a newbie friendly introductory resource?
A vendor neutral one would be preferable.
-
1What is the audience? Developers? First year students in GIS?– Ragi Yaser BurhumMay 29, 2011 at 17:03
-
I am a geomatics engineering student. Specializing in geoinformatics. We develop applications too but we focus mostly on theory right now. At least that's what I was led to believe.– R.K.May 29, 2011 at 17:20
Comments disabled on deleted / locked posts / reviews
|
6 Answers
take a look at http://www.bostongis.org
they have great "An almost idiot guide ..." for
PostGIS,
Microsoft SQL Server spatial and
SpatiaLite.
that is really a great start.
-
Thanks, I was thinking more along spatial database theories but those are good resources. :)– R.K.May 29, 2011 at 14:01
- Spatial Databases course from School of Computing, Dublin Institute of Technology.
- Introduction to PostGIS & Spatial Database Tips and Tricks Workshop from OpenGeo
- Introduction to Spatial Databases slides from Toni Hernández
-
1I liked PostGIS in Action but I'm accepting this as it fits my needs. Do keep the answers coming people :)– R.K.May 30, 2011 at 7:31
I strongly recommend the book "PostGIS in Action" by Regina Obe and Leo Hsu.
They are the same people who run the Boston GIS site mentioned above.
The book goes into a lot of detail about PostGIS but the concepts transfer well to other platforms.
-
-
A bit cheaper here: amazon.com/PostGIS-Action-Regina-Obe/dp/1935182269 Jul 1, 2011 at 10:49
Beginning Spatial with SQL Server 2008 would definitely be helpful even though it is specific to SQL Server. For now at least, SQL Server seems to be one of the better platforms for leaning about spatial SQL operations.
SQL Server Express is free and will give you full access to the same spatial capabilities you would get with the Enterprise version.
-
3I can say the same about PostgreSQL, with the only difference that there is no difference between free and Enterprise version, this because PostgreSQL if free (gratis), if free (Open Source) and at the same time is Enterprise. May 29, 2011 at 15:46
For Spatialite, the best resource is the official doc. The main developers are maintaining a great cookbook and it's oriented general spatial database too. It's really good material for beginners.
See also OSGeo's Searchable Database of Educational Material for courseware: http://www.osgeo.org/educational_content