I wish to draw some custom boundaries (eg. neighbourhoods or streets or city boundaries).

  1. What software (free or paid) can I use to do this? I read that google maps recently has support for this?
  2. Import this boundary into Sql Server 2008.

Are there any links, tutorials or info anyone can provide, please?

  • How long do you want to do it for Mike? Could download an eval if its for one job. Other than that, if you just want to do something lite, then get onto ebay and buy an old copy of MapInfo 6, as that will do the job. – Hairy Dec 5 '11 at 9:34

Here's one possible solution:

  1. Digitize the features in QGIS (which is free software)
  2. Use SQL Server 2008 Spatial Tools (free), Shape2SQL in particular, to import your resulting shapefile(s) you created in QGIS into SQL Server

Some Googling or searching on this site will get you links to other QGIS tutorials on digitizing and just using QGIS in general.

  • You may also have success connecting directly to SQL Server from within QGIS - see woostuff.wordpress.com/2011/03/13/… (never done it myself, so can't speak to stability &c). Probably creating a Shapefile and importing is easiest in this situation. – mattwigway Dec 5 '11 at 22:02
  • 1
    @mattwigway just a note: there is native support for SQL Server coming for QGIS in the near future. Development is in the works. – Nathan W Dec 6 '11 at 5:27
  • also this woostuff.wordpress.com/2011/06/07/… is the better post for the MS SQL stuff – Nathan W Dec 6 '11 at 5:30
  • @NathanW excellent! It seems like a lot of people are moving towards SQL Server from Oracle. – mattwigway Dec 6 '11 at 6:57

Not the answer you're looking for? Browse other questions tagged or ask your own question.