StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3566801
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-08-25T14:19:53.113
FavoriteCount
0
LastActivityDate
2014-05-26T14:34:38.817
LastEditDate
2014-05-26T14:34:38.817
LastEditorUserId
164001
OwnerUserId
5096
ParentId
373589
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
The distance returned depends on the <a href="http://technet.microsoft.com/en-us/library/bb964707.aspx" rel="nofollow noreferrer">"Spatial Reference Identifier (SRID)"</a> you define for your geography types. In the example below, the default <a href="http://technet.microsoft.com/en-us/library/bb964707.aspx" rel="nofollow noreferrer">SRID</a> of 4336 is used, see the second argument of <a href="http://msdn.microsoft.com/en-us/library/bb933823.aspx" rel="nofollow noreferrer">STGeomFromText</a>. This means the distance returned is in meters, you find this via querying the catalog view <a href="http://technet.microsoft.com/en-us/library/bb964707.aspx" rel="nofollow noreferrer">spatial_reference_systems</a> i.e. <code>select srs.unit_of_measure from sys.spatial_reference_systems as srs where srs.spatial_reference_id = 4326</code> As an alternative to <a href="http://msdn.microsoft.com/en-us/library/bb933823.aspx" rel="nofollow noreferrer">STGeomFromText</a>, you can use <a href="http://msdn.microsoft.com/en-us/library/bb933824.aspx" rel="nofollow noreferrer">parse</a> which assumes a <a href="http://technet.microsoft.com/en-us/library/bb964707.aspx" rel="nofollow noreferrer">SRID</a> of 4326 and you don't have to specify one explicitly. When calculating the distance between two points, you must use the same <a href="http://technet.microsoft.com/en-us/library/bb964707.aspx" rel="nofollow noreferrer">SRID</a> for both geography types else you get an error. Example: <pre><code>DECLARE @address1 GEOGRAPHY DECLARE @address2 GEOGRAPHY DECLARE @distance float SET @address1 = GEOGRAPHY::STGeomFromText ('point(53.046908 -2.991673)',4326) SET @address2 = GEOGRAPHY::STGeomFromText ('point(51.500152 -0.126236)',4326) SET @distance = @address1.STDistance(@address2) SELECT @distance --this is the distance in meters </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POGeometry column: STGeomFromText and SRID (what is an SRID?)
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPavlo Neyman
UserOwnerUserId
1. USAndy Jones
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.