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

Spatial data Geography Expand / Collapse
Author
Message
Posted Tuesday, December 24, 2013 2:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 10:30 AM
Points: 37, Visits: 197
I recently saw a training video from CBT Nuggets on querying SQL Server 2012 (70-741). In the video a table was used for spatial data querying which consisted of all the geometry, geography data and lines of latitude and longitude, for all the countries of the world.
the website http://www.thematicmapping.org was suggested as the site where the table was obtained.
Upon visiting the site I was able to download a table which had most of the information including lines of latitude, longitude, population etc, I used SQL spatial tools to upload the table into SQL Server successfully. However it did not have a column with geography data.
I would like to know if anyone out there have the full data table for world borders including the geography column. If you do could please let me know how or where I could acquire this table

Thanks.
Post #1525712
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse