Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Investigating the new Spatial Types in SQL Server 2008 - Part 2 Expand / Collapse
Author
Message
Posted Thursday, April 9, 2009 2:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 10, 2009 9:11 AM
Points: 2, Visits: 2
Have you seen the Manage SQL Server 2008 Spatial Data tutorial on the SQL Server "How Do I?" Videos page? It's a nice companion to this article because you can see how to do it.
Post #694427
Posted Thursday, October 8, 2009 3:36 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 13, 2014 8:12 AM
Points: 50, Visits: 196
Do we still have any hope for the rest of the articles in this series? Can some other expert jump in and complete puzzle?
I need to get information on this topic specially building / constructing 3D shapes and querying the data involving these shapes. Can someone refer to some sites/books that can speed up this process of learning for me?
Any and all help is well appreciated.
Thanks.
Post #800403
Posted Thursday, October 8, 2009 8:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 10, 2014 10:30 AM
Points: 4, Visits: 63
Hello,

This is Bennie (the original author). I have been out for a while due to family issues, but I am back, look for the next post in a couple of days.

Bennie
Post #800470
Posted Friday, October 9, 2009 2:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 1, 2012 10:31 AM
Points: 17, Visits: 105
Hi Rehman,

You can check out "Beginning Spatial with SQL Server 2008" (http://www.amazon.com/Beginning-Spatial-Server-Experts-Voice/dp/1430218290), which has chapters covering the following topics:
1. Defining Spatial Information
2. Implementing Spatial Data in SQL Server 2008
3. CLR Datatypes and the .NET Framework
4. Creating Spatial Data
5. Marking Out Features Using Virtual Earth
6. Importing Spatial Data
7. Geocoding
8. Syndicating Spatial Data
9. Interactive Web Mapping
10. The Spatial Results Tab
11. Examining Spatial Properties
12. Modifying Spatial Objects
13. Testing Spatial Relationships
14. Spatial Indexing

However, you won't find anything about working with 3D geometries, in this book or any other - although SQL Server allows you to define coordinates in 4 dimensions (x, y, z, m), all of the inbuilt methods only operate in two dimensions (the flat planar surface of the geometry datatype, or the ellipsoidal surface of the geography datatype). z and m can be stored, but are not used unless you want to write your own custom methods.
Post #800559
Posted Friday, October 9, 2009 8:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 13, 2014 8:12 AM
Points: 50, Visits: 196
Glad to hear from you Bennie. Hope everything will be fine with you.
I am eagerly waiting for the next article.
Post #800815
Posted Friday, October 9, 2009 8:49 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 13, 2014 8:12 AM
Points: 50, Visits: 196
Thanks Alastair. I am looking into buying this book.
Post #800818
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse