Storing Shape data in a database. (Plans and Maps)

• Trystan Hughes

  SSCrazy

  Points: 2109

  More actions

  January 15, 2007 at 2:04 pm

  #174561

  Hi all,

  we have a situation on our project where we need to present to the user plans of builds, where the user can select a certain area (i.e. room, or hall-way) and mark some information on it.

  What I think we need to do, is to store the points for each shape on the plan, for example a square room, we need to store each of the four points. How would I do this, and how would I be able to link the points together so that the correct shape is drawn.

  So basically, I know I need to store the data as shapes and record their points (i think). I just need some pointers on how to store shaped data to be placed on maps/plans.

  Look forward to hearing your ideas.

  Thanks

  Tryst

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 19, 2007 at 1:11 am

  #684202

  First thing I'd do, if you really want to do this in sql server, is upgrade to 2005 where you can define a user defined data type as an array , e.g. a box, a room, a cube etc. You do this via the CLR btw. seen it done and it works well.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• Trystan Hughes

  SSCrazy

  Points: 2109

  More actions

  January 24, 2007 at 2:49 am

  #685145

  Right, thats interesting.

  We already us SQL Server 2005, so will look into it.

  But I worked for a company in the past who used SQL Server 2000 and they had a shapes table, shape category and I think there was some other table. And the draw of shapes could be drawn from the information contained in these tables.

  Tryst