MS Sql Server 2005有空间数据功能吗？

I wonder if there is any optimization I can do to achieve faster SELECTs for spatial data without moving to SQL SERVER 2008. There is for SQL Server 2005, natively or through plugins, any of the features below?

我想知道我是否可以做任何优化来实现更快的空间数据SELECT而无需迁移到SQL SERVER 2008. SQL Server 2005本身或通过插件有以下任何功能吗?

Spatial field types

空间字段类型

Spatial indexes
Arcsin math function for surface distance calculation on a sphere (Earth)

Arcsin数学函数用于球体(地球)上的表面距离计算

3 个解决方案

#1

There are some GIS features available through http://www.codeplex.com/Wiki/View.aspx?ProjectName=MsSqlSpatial but as far as I know SQL 2008 is the way to go

有一些GIS功能可以通过http://www.codeplex.com/Wiki/View.aspx?ProjectName=MsSqlSpatial获得,但据我所知,SQL 2008是要走的路

#2

Just 3 is there in 2005 (ASIN). Spatial stuff are new in 2008.

2005年只有3人(ASIN)。空间的东西在2008年是新的。

#3

Not as such. SQL Server has no native spatial indexing facilities. Various people have done projects that emulate a spatial index on top of the native indexing facilities, but these are not as efficient as a native R-tree or other spatial index. For native support for this you really need SQL Server 2008 or another DBMS such as PostGresSQL that directly supports spatial indexing.

不是这样的。 SQL Server没有本机空间索引功能。各种各样的人已经完成了在本机索引工具之上模拟空间索引的项目,但这些项目不如本机R树或其他空间索引那样高效。对于本机支持,您确实需要SQL Server 2008或其他直接支持空间索引的DBMS,如PostGresSQL。

However, one of the solutions that the other posters have linked to may give you a performance improvement.

但是,其他海报与之相关的解决方案之一可能会为您带来性能提升。

#1