oracle 有什么好的空间数据库教程吗？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/586444/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Any good spatial database tutorials out there?
提问by geoffrobinson
I was looking to explore the spatial capabilities of PostGIS or SQL Server 2008. Maybe Oracle as well.
我希望探索 PostGIS 或 SQL Server 2008 的空间功能。也许 Oracle 也是如此。
I was wondering if there are any good tutorials out there exploring the spatial capabilities of these database in particular or of this type of capability in general.
我想知道是否有任何很好的教程来探索这些数据库的空间功能，特别是探索此类功能的空间功能。
Does anyone know of any? Book recommendations would work as well.
有谁知道吗？书籍推荐也会起作用。
采纳答案by SQLMenace
I wrote a little blogpost about SQL Server geography data type here: SQL Server 2008 Proximity Search With The Geography Data Type
我在这里写了一篇关于 SQL Server 地理数据类型的小博文：SQL Server 2008 Proximity Search With The Geography Data Type
回答by Nathan
This isn't a tutorial, bit it's a good comparison of the various offerings, to see how they stack up against one another: Spatial Database Cross Compare
这不是教程，而是对各种产品进行了很好的比较，以了解它们如何相互叠加： 空间数据库交叉比较
回答by geographika
A great introduction to SQL Server 2008 Spatial in 8 parts. Projections, geography / geometry, spatial SQL functions etc.
对 SQL Server 2008 Spatial 的精彩介绍，分为 8 个部分。投影、地理/几何、空间 SQL 函数等。
http://www.jasonfollas.com/blog/archive/2008/03/14/sql-server-2008-spatial-data-part-1.aspx
http://www.jasonfollas.com/blog/archive/2008/03/14/sql-server-2008-spatial-data-part-1.aspx
A few extra links and SQL examples here - http://geographika.co.uk/sql-server-spatial-sql
这里有一些额外的链接和 SQL 示例 - http://geographika.co.uk/sql-server-spatial-sql
回答by John Powell
They mostly cover Postgres/PostGIS, though they talk about SQL Server also. There are some pretty good examples.
他们主要涵盖 Postgres/PostGIS，尽管他们也谈论 SQL Server。有一些很好的例子。
The PostGIS manual is really good too, chapters 4 and 6 in particular, though it is all worth reading.
PostGIS 手册也非常好，尤其是第 4 章和第 6 章，但都值得一读。
http://www.postgis.org/docs/ch04.html
http://www.postgis.org/docs/ch04.html
PostGIS again, but this book is really very comprehensive in its coverage of spatial sql, and many of the queries will port to other dbs, particularly Oracle -- as the Postgres devs have made an effort to be compatable with Oracle syntax, where possible. It starts with the basics, but some of the later examples are really very advanced.
再次使用 PostGIS，但这本书对空间 sql 的覆盖确实非常全面，并且许多查询将移植到其他数据库，尤其是 Oracle——因为 Postgres 开发人员已尽可能与 Oracle 语法兼容。它从基础开始，但后面的一些示例确实非常高级。
回答by Ray
While it doesn't specifically address SQL Server 2008, Boundless has a very good tutorialon PostGIS. I didn't use their OpenGeo Suite to follow along but instead adapted the examples to PostgreSQL which is what I use. In the end, I learned a lot from this tutorial paired with the PostGIS user manual.
虽然它没有专门针对 SQL Server 2008，但 Boundless 有一个关于 PostGIS的非常好的教程。我没有使用他们的 OpenGeo Suite 来跟进，而是将示例改编为我使用的 PostgreSQL。最后，我从本教程和 PostGIS 用户手册配对中学到了很多东西。
回答by Aaron Palmer
You may be interested in ESRI's ArcSDE tutorials.
您可能对ESRI 的 ArcSDE 教程感兴趣。
Edit:Sorry... I just read the question details. And this doesn't really answer your specific need. However, for people looking for an SDE tutorial that are using the ESRI products, they may find this useful.
编辑：对不起......我刚刚阅读了问题的详细信息。这并不能真正满足您的特定需求。但是，对于正在寻找使用 ESRI 产品的 SDE 教程的人来说，他们可能会发现这很有用。
