[Attachment(s) from Iqbal included below]

Saya sendiri belum pernah implementasi, tp kalau mau untuk mencoba spatial di SQL S2005, bisa dicobakan sample database Spatial (termasuk CLR yg diperlukan) yg ada di C:\Program Files\Microsoft SQL Server\90\Samples\Engine\Programmability\CLR\Spatial.

Lalu untuk contoh rumus geometri jarak bisa digunakan fungsi terlampir. Rumus yg lain bisa dilihat di http://williams.best.vwh.net/avform.htm dan dicobakan buat fungsinya sendiri :)

Berikut contoh query untuk menghitung jarak antara Seattle dan redmond (dalam km & mil)

WITH Seattle AS
(
SELECT Lat,
Lon
FROM Place
WHERE PlaceName = 'Seattle'
AND State = 'WA'
)
,Redmond AS
(
SELECT Lat,
Lon
FROM Place
WHERE PlaceName = 'Redmond'
AND State = 'WA'
)
SELECT dbo.Distance(s.Lat, s.Lon, r.Lat, r.Lon, 'km') AS DistInKilometers,
dbo.Distance(s.Lat, s.Lon, r.Lat, r.Lon, 'mi') AS DistInMiles
FROM Seattle AS s
CROSS
JOIN Redmond AS r;

Semoga membantu.

Iqbal

________________________________
From: didit.s banuardi.n <didithoe@...>
To: sqlserver-indo@yahoogroups.com
Sent: Monday, July 13, 2009 2:50:09 PM
Subject: Re: [sqlserver-indo] Spatial Data Dengan SQL Server 2005

belum didukung, spatial baru didukung di SQL 2008.
untuk menyimpan data spatial di SQL 2005 harus pake extension, berdasar pengalaman, performanya buruk.
http://mssqlspatial .codeplex. com/
--
br,
didit s.banuardi.n
http://diditho. net

2009/7/13 Barry . <barry@wahanamotoren t.com>

>
>
>Dear rekan2 milis
>
>Saya ingin tanya untuk penjelasan mengenai spatial data jika menggunakan SQL server 2005 apakah secara fungsi geometry sudah support di engine tsb.
>
>
>Terima kasih
>
>
>Barry
>