Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Geography   (RSS)
Friday, November 14, 2008 7:47 AM

SQL Spatial - How to get Spatial data. (FREE Maps 'n Demographics)

This post lists ways to get spatial maps, some of them are Free. If you are in a hurry jump to the last link, it is so cool. Then check out the Free Map sites. Overview There are 3 ways to get the spatial data for your application:- Buy it Download it
Posted by davele | 3 Comments
Saturday, November 01, 2008 3:40 PM

SQL 2008 Spatial Samples, Part 1 of 9 - How to Learn SQL Spatial

This post covers how to get started with SQL Spatial methods & the best way to test things for yourself. One of the goals in this series of articles is to give you code you can cut, paste & try. I hope you find this handy. Overview Visual Studio
Posted by davele | 8 Comments
Saturday, November 01, 2008 3:34 PM

SQL 2008 Spatial Samples, Part 2 of 9 - Background on Spatial Types & Well Known Text (WKT)

This post covers all the Methods to enter data in WKT, WKB & XML(GML) as well as functions to view the in Human Readable form. It also covers MakeValid, STIsValid & STSrid.   Summary of Methods to convert Geometric Formats The following table
Posted by davele | 3 Comments
Thursday, October 30, 2008 5:25 PM

SQL 2008 Spatial Samples, Part 3 of 9 - SQL Builder API

This post covers the SqlGeographyBuilder & SqlGeometryBuilder Classes & their methods. Overview of Methods to make your own Spatial Objects using the Builder API. SQL provides a Builder API that permit you to easily write your own Spatial Data
Posted by davele | 3 Comments
Wednesday, October 29, 2008 3:45 PM

SQL 2008 Spatial Sample, Part 4 of 9 - Methods for Drawing Spatial Shapes

This post covers the following methods: STDimension, STGeometryType, STNumGeometries, STGeometryN, STNumPoints, STPointN, STNumInteriorRing / NumRings, STInteriorRingN / RingN, STExteriorRing, STX / Long, STY / Lat, Z & M (measure). Note: Unless otherwise
Posted by davele | 3 Comments
Monday, October 27, 2008 1:03 PM

SQL 2008 Spatial Samples, Part 5 of 9 - Performance Improvement Methods

This post covers the following methods: Reduce, STEnvelope, EnvelopeCenter, EnvelopeAngle, STConvexHull. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio (SSMS) & run. Sometimes
Posted by davele | 1 Comments
Saturday, October 25, 2008 4:40 PM

SQL 2008 Spatial Samples, Part 6 of 9 - Geometric “Set Theory” Methods

This post covers the following methods: STUnion, STIntersection, STDifference, STSymDifference, STCentroid / STEnvelopeCentre, STPointOnSurface, STBoundary. Overview of Geometric "Set Theory" Methods These Methods help to understand the relationship
Posted by davele | 1 Comments
Friday, October 24, 2008 11:53 PM

SQL 2008 Spatial Samples, Part 7 of 9 - STBuffer ... Spatial starts here.

This post covers only 2 methods: STBuffer & BufferWithTolerance . They are so handy, they deserve a post all to themselves. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio
Posted by davele | 1 Comments
Friday, October 24, 2008 7:36 PM

SQL 2008 Spatial Samples, Part 8 of 9 - Conditional Methods

This post covers the following methods: STDisjoint, STIntersects , Filter,  STTouches , STWithin , STContains ,  STOverlaps , STCrosses,  STRelate, & STEquals One day these examples may find their way to Books Online. For now they can
Posted by davele | 10 Comments
Friday, October 17, 2008 10:10 AM

SQL 2008 Spatial Samples, Part 9 of 9 - Handy but Obvious Methods

This post covers the following methods: STArea, STLength, STDistance, STIsEmpty, STIsClosed, STIsSimple, STIsRing. Overview of Handy but obvious Methods The following methods are self evident. I’ve included here for the sake of completeness. You
Posted by davele | 3 Comments
 
Page view tracker