Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2008-11-03 : 09:04:16
|
| Does anyone use GIS (Geographical Information Systems) in SQL Server (or any other database)?I'm currently looking into what is available and I know that SQL Server 2008 has some elements of the functionality for this. Oracle is probably too expensive for our needs. The current favorite seems to be Postgres.If you do use it what sort of broad functionality do you make use of?Thankssteve-----------ASCII and ye shall receive. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-04 : 15:31:37
|
We use it to classify customers in our crm application.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2008-11-05 : 11:27:17
|
| Peso do you use SQL server 2008 for this and if so what did you use before?Do you make use of polygons and points in polygons and all that sort of thing?steve-----------ASCII and ye shall receive. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-05 : 11:32:10
|
My current employer is still on SQL Server 2000.So I use the Haversine formulas.We are a long way from SQL Server 2008. My employer will install SQL Server 2005 first.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2008-11-12 : 11:17:46
|
| Thanks PesoSteve-----------ASCII and ye shall receive. |
|
|
|
|
|
|
GIS