Spatial - Simon Sabin UK SQL Consultant's Blog

Browse by Tags

All Tags » Spatial (RSS)
20 March 2009 11:49

Virtual Earth Silverlight Control - Register Now

If you want to get your hands on the CTP of the Silverlight Virtual Earth Control then you will need to go to Connect. There you will have to complete a short survey and I guess you will then be informed when the download is available. https://connect...
Posted by simonsabin | with no comments
Filed under: , ,
22 February 2009 12:42

Converting Mappoint routes to SqlGeography

The mapping services from microsoft aren't limited displaying maps in Virtual Earth, and not only limited to websites. There are numerous webservices for, resolving locations to longtiudes and latitudes as well as a routing api. I am working on something...
Posted by simonsabin | with no comments
Filed under: , , ,
16 October 2008 23:14

SQL 2008 and Virtual Earth : Converting a VERoute to a SqlGeography

At the SQL 2008 unleashed event I demoed some code that incorporated VE with SQL 2008 to find those people attending SQLBits that where near your route to the conference. I've been asked to provide the code for that, unfortunately the code is to entangled...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
06 February 2008 18:24

Spatial data where to download

I'm going to build a list of locations to download spatial data for free. This is the first http://arcdata.esri.com/data_downloader/DataDownloader?s=s&service=ESRI_World It allows you to downloads country boundaries, roads, water bodies and cities...
Posted by simonsabin | 4 comment(s)
Filed under:
21 January 2008 22:38

SQL Server 2008 Spatial - STContains for Geography type

Where is the STContains function for the Geography type. I don't know but its not in Sql Server 2008. As a workaround you can use STIntersection and compare the results with the geography you are comparing with i..e declare @g geography = 'POLYGON...
Posted by simonsabin | 3 comment(s)
Filed under:
15 January 2008 02:30

Viewing Geometries on Virtual Earth

One of the biggest challenges in understanding spatial data is visualising shapes. In 2D it isn't two bad, and I have started the SpatialViewer project on codeplex ( http://www.codeplex.com/SpatialViewer ) However visualising Geography types requires...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
09 January 2008 23:21

SQL Server 2008 Spatial - How to create a circle?

How do you create a circle in a planar system. Ok so there are some funky algorithms for creating a set of points all the way round the circle. Well there is a much easier way. Create a point i.e. POINT (10 10) and the use the STBuffer(radius) method...
Posted by simonsabin | with no comments
Filed under: , ,
08 January 2008 22:41

SQL Server 2008 Spatial - Performance of database calls follow up

I recently blogged about the performance of passing spatial data to the database.( SQL Server 2008 Spatial - Performance of database calls? ) In it I found that the the performance radically dropped off as the number of points increases. Whilst this was...
Posted by simonsabin | with no comments
Filed under: , , ,
07 January 2008 21:32

SQL Server 2008 Spatial - Performance of database calls?

There are 4 ways of holding spatial data, Well Known Text (WKT), Well Known Binary (WKB), Geography Markup Language and the base spatial type (SqlGeometry or SqlGeometry). This leads me on to the question how should you pass the data to SQL Server. I've...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
04 January 2008 17:58

SQL Server 2008 Spatial - Which is faster WKT or WKB?

I've just posted two methods for creating geometries in client code. The examples use Stylus points from an ink canvas but any collection of points will go. After doing that I ran some tests to compare the two. I found that in generally the WKB method...
Posted by simonsabin | 2 comment(s)
Filed under: , , , ,
04 January 2008 17:34

SQL Server 2008 Spatial - Converting from Ink Strokes to geometries

The following snippet will convert an strok collected using an Ink Canvas in WPF to a LINSTRING geometry. The first uses the Well Known Text format WKT. //Text representation of a line is LINESTRING (x1 y1,x2 y2 x3 y3....) //create an string array to...
Posted by simonsabin | with no comments
Filed under: , , , , ,
31 December 2007 08:43

SQL Server 2008 Spatial - Using it in .Net code

So you want to use the SqlGeometry and SqlGeogrpahy collections in .Net. I found the lack of friendly collection based properties and methods suprising, i.e. no iterators, no collections which you can add to.( http://sqlblogcasts.com/blogs/simons/archive...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
29 December 2007 22:14

SQL Server 2008 Spatial - How many ways to make your point?

The spatial functionality is hugely standards based. There spatial standards are well established what this means is that there are many methods to support the standards. One of the areas that you will see this is the creation of spatial data. To create...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
29 December 2007 18:28

SQL Server 2008 Spatial - List of spatial referneces

For a list of spatial references and their definitions including units of measure have a look at the system view select * from sys.spatial_reference_systems - var height=90;var width=720;
Posted by simonsabin | 2 comment(s)
Filed under: ,
29 December 2007 17:54

SQL Server 2008- What is a spatial reference?

A friend recently emailed me after trying out the new spatial stuff in Katmai asking why the distance from Beaverton to Boston was 51, and any way 51 what. On looking at his code I realised he had used the Geometry type and not the Geography type. The...
Posted by simonsabin | with no comments
Filed under: , ,
More Posts Next page »