Viewing 9 posts - 1 through 9 (of 9 total)
See screenshot in step 2, lower right panel, I named Geometry name as BoundaryGeom.
June 1, 2012 at 12:56 pm
Please refer to my post. You should have two fields added to tl_2008_us_state: BoundaryGeom (GEOMETRY) and BoundaryGeog (GEOGRAPHY).
June 1, 2012 at 12:43 pm
"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...
June 1, 2012 at 12:31 pm
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...
June 1, 2012 at 10:57 am
I'd suggest to maintain data at the leaf-levels of the HIERARCHYID column and create artificial nodes for the roll ups. Let's say the HIERARCHYID column is called LocationId, and...
December 23, 2011 at 11:01 am
Thanks for the feedback. I hope this article can be helpful someday.
SQLRNNR (12/22/2011)Nice work thanks. I added this to my briefcase for future reference.
December 23, 2011 at 10:39 am
Thanks for your comment. 🙂
SQL Kiwi (12/22/2011)Very nice work, thank you.
SQL Kiwi (12/22/2011)
December 23, 2011 at 10:22 am
Thanks for your comment. Unfortunately, I don't have SQL Server 2008 in our environment to test this. However, I'd think it will work as long as your...
March 7, 2011 at 9:28 am
Thanks for your comment. The Great Lakes shorelines were not carved out in the 2008 census shapefile. In our production environment, we use ESRI state shapefile. With...
March 7, 2011 at 9:09 am