title: SQL Geography point inside polygon not returning true on STIntersect (but returns true using Geometry)
body: <p>I don't want to resort in converting my geography data to geometry just so it returns true in STIntersect.</p>
  
  <p>Here is the code in SQL:</p>
  
  <pre><code>DECLARE @point GEOGRAPHY = GEOGRAPHY::Point(1, 1, 4326)
  DECLARE @polygon GEOGRAPHY = GEOGRAPHY::STGeomFromText('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))', 4326)
  
  SELECT @polygon.STIntersects(@point), @point.STIntersects(@polygon)
  </code></pre>
  
  <p>The following returns false (0), however if I use:</p>
  
  <pre><code>DECLARE @point GEOMETRY = GEOMETRY::Point(1, 1, 4326)
  DECLARE @polygon GEOMETRY = GEOMETRY::STGeomFromText('POLYGON((0 0, 0 2, 2 2, 2 0, 0 0))', 4326)
  
  SELECT @polygon.STIntersects(@point), @point.STIntersects(@polygon)
  </code></pre>
  
  <p>It returns true, is there something I am missing? All I know is geography is 3D plane and geometry is a flat map, however I am using the earth for calculation if the point is in the polygon.</p>
  
  <p>PS: It doesn't work as well with STContains, STWithin, STOverlaps</p>
  
  <p>Using Microsoft SQL Server 2012</p>