Browse by Tags

SpatialViewer Beta 3 – new release

Just released an updated version of the spatial viewer http://spatialviewer.codeplex.com This is a C# app that allows you to draw shapes and then get the spatial representation for them in WKT format. It also allows you to manipulate shapes union, intersections etc. It doesn’t require a database...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Aug 4 2010
Spatial data in the UK

I am just loving the fact that the Ordance Survey has now released a huge amount of data that can be used freely. I’ve downloaded the Panorama (tm) data http://www.ordnancesurvey.co.uk/oswebsite/products/land-form-panorama-contours/index.html . which is all the contours for the UK This I’ve loaded into...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Apr 5 2010
Mapping the Brain using SQL Server 2008 Spatial Features

I have had a problem with my brain for the past few years now and about 3 years ago had a ‘Brain Pacemaker’ fitted – now without going into the gory details (check my facebook for the pictures J ) this involves placing a couple of electrodes into the brain on the left and right sides. When I first had...

Posted to The SQLARTIST Blog (Weblog) by sqlartist on Sat, Sep 5 2009
MapPoint Add-in for SQL Server (Updated with Example)

Nice :) If you have MSDN you can download MapPoint Europe or US or get the trial from the link below - will be trying this out tonight View and edit your SQL data on a map. It’s quick, low cost, and doesn’t require special training. To get started you need the free Add-in, MapPoint 2009 1 , and access...

Posted to The SQLARTIST Blog (Weblog) by sqlartist on Fri, Jul 31 2009
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 for SQLBits to enable people to lift share...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Feb 22 2009
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 with the SQLbits site and so I've decided...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 16 2008
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 a globe.Virtual Earth can come to the rescue....

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jan 15 2008
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 to get a circle whose centre is at the point and with...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jan 9 2008
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 suprising I had used my usual approach of eliminaing...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jan 8 2008
Spatial Perf

Posted to Blog Images (Gallery) by simonsabin on Mon, Jan 7 2008

Page 1 of 3 (21 items) 1 2 3 Next >