none
SpatialLocation in sample AW database to create map report

Answers

All replies

  • However, I can not manage to find any SpatialLocation field anywhere. I downloaded the sample databases (AdventureWorks)

    For spatial sample data you need AdventureWorks2008 or AdventureWorks2008R2.

    Example for table with SpatialLocation:

    CREATE TABLE [Person].[Address](
    	[AddressID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL PRIMARY KEY,
    	[AddressLine1] [nvarchar](60) NOT NULL,
    	[AddressLine2] [nvarchar](60) NULL,
    	[City] [nvarchar](30) NOT NULL,
    	[StateProvinceID] [int] NOT NULL,
    	[PostalCode] [nvarchar](15) NOT NULL,
    	[SpatialLocation] [geography] NULL,
    	[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
    	[ModifiedDate] [datetime] NOT NULL)
    

     


    Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
    Monday, October 18, 2010 2:18 PM
  • Thanks for the reply.

    I´m wondering what I´m missing. The database should be included in the AdventureWorks2008R2_RTM installation, right? Yesterday I had three AW databases but I could not find any spatial field anywhere. If installing again, which database are we talking about?

    http://www.kodyaz.com/images/sql/sql-server-2008-r2-sample-databases-installation-2.PNG

    I currently only have the AdventureWorksDW2008R2 but that doesn't seem to be it.

    Tuesday, October 19, 2010 7:59 AM
  • Try AdventureWorks2008R2.


    Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM
    • Marked as answer by Marcus84 Wednesday, October 20, 2010 11:17 AM
    Tuesday, October 19, 2010 8:44 AM
  • Hi Marcus84,

    Please try this sample(SQL Server 2008 SR4):
    http://msftdbprodsamples.codeplex.com/releases/view/37109

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Wednesday, October 20, 2010 8:38 AM
    Moderator