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 ««123»»

Create CNN-style Map in Reporting Services Expand / Collapse
Author
Message
Posted Tuesday, March 8, 2011 2:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 26, 2013 12:53 AM
Points: 3, Visits: 163
Very informative and easy to follow quick kick start article on using SQL Server with Maps (storing the data inside db engine) and capitalising on SSRS R2 map capabilities. I like.

Maps can be downloaded ifrom most GIS web sites, regardless of you country of origin (not limited to US only).
Post #1075117
Posted Friday, May 6, 2011 1:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 12:49 PM
Points: 13, Visits: 265
Someone, please help me. I successfully registered the assembly SQLSpatialTools but when I run these statements to use the AffineTransform function I get this error:

Msg 243, Level 16, State 4, Line 12
Type AffineTransform is not a defined system type.

What is wrong with my system? As I mentioned above. All other steps worked without any issues.

Thanks,
Stan
Post #1104863
Posted Friday, May 6, 2011 2:49 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 12:49 PM
Points: 13, Visits: 265
Never mind my previous post. I ran the Register.sql on a wrong db. I was able to run all the sql statements after I ran Register.sql.
Post #1104916
Posted Friday, June 1, 2012 10:41 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:43 AM
Points: 370, Visits: 954
Step 3 seems to have issues

UPDATE tl_2008_us_state
SET BoundaryGeog = GEOGRAPHY::STGeomFromWKB(BoundaryGeom.MakeValid().STAsBinary(), 4326)
WHERE NAME NOT IN('Massachusetts', 'New Mexico', 'Wyoming', 'Montana', 'Texas', 'North Carolina', 'Arizona', 'Tennessee', 'Utah')


Msg 4121, Level 16, State 1, Line 1
Cannot find either column "BoundaryGeom" or the user-defined function or aggregate "BoundaryGeom.MakeValid", or the name is ambiguous.


Cheers
Post #1309859
Posted Friday, June 1, 2012 10:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 16, 2014 10:41 AM
Points: 9, Visits: 93
Did you get any errors while importing the shapefile: tl_2008_us_state.shp ? From the error message, it looks like BoundaryGeom wasn't there in the table. Please double check the Geometry coumn's name.
Post #1309871
Posted Friday, June 1, 2012 12:22 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:43 AM
Points: 370, Visits: 954
I didn't actually. Not message, etc at all. A search of sys.objects in every database returns no results as well. On with the search..

Cheers
Post #1309912
Posted Friday, June 1, 2012 12:27 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:43 AM
Points: 370, Visits: 954
I noticed while looking at the table structure for tl_2008_us_state that there is a column called geom and one called boundaryGeog. Just mentioning this because it is odd those two names are a cross between what is causing the current situation.

Cheers
Post #1309914
Posted Friday, June 1, 2012 12:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 16, 2014 10:41 AM
Points: 9, Visits: 93
"geom" is the name you created during the import. I named it BoundaryGeom. BoundaryGeog is another field I added to the tl_2008_us_state table. geom is a Geometry field while BoundaryGeog is a geography field.
Post #1309916
Posted Friday, June 1, 2012 12:34 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:43 AM
Points: 370, Visits: 954
I changed BoundaryGeom to BoundaryGeog as seen below and now it throws the following:

UPDATE tl_2008_us_state
SET BoundaryGeog = GEOGRAPHY::STGeomFromWKB(BoundaryGeog.MakeValid().STAsBinary(), 4326)
WHERE NAME NOT IN('Massachusetts', 'New Mexico', 'Wyoming', 'Montana', 'Texas', 'North Carolina', 'Arizona', 'Tennessee', 'Utah')

Msg 6506, Level 16, State 10, Line 2
Could not find method 'MakeValid' for type 'Microsoft.SqlServer.Types.SqlGeography' in assembly 'Microsoft.SqlServer.Types'


Cheers
Post #1309918
Posted Friday, June 1, 2012 12:42 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 7:43 AM
Points: 370, Visits: 954
Per your explanation of column names changing the statement as seen below resolves the issue.

UPDATE tl_2008_us_state
SET BoundaryGeog = GEOGRAPHY::STGeomFromWKB(Geom.MakeValid().STAsBinary(), 4326)
WHERE NAME NOT IN('Massachusetts', 'New Mexico', 'Wyoming', 'Montana', 'Texas', 'North Carolina', 'Arizona', 'Tennessee', 'Utah')


Cheers
Post #1309926
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse