Changes between Version 14 and Version 15 of DevWikiEmptyGeometry

Timestamp:

10/06/09 12:33:42 (4 years ago)

Author:

chodgson

Comment:

--

DevWikiEmptyGeometry

@@ -4 +4 @@
 
  * ST_Union(geometry, empty) == geometry
-
-{{{
-SQL Server 2008 geometry
-   SELECT Geometry::STGeomFromText('POINT(1 2)',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))
-     => POINT (1 2)
-   
-SQL Server 2008 geography 
-  SELECT (Geography::STGeomFromText('POINT(1 2)',4326).STUnion(Geography::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
-    => POINT(1 2)
-}}}
-
-   
  * ST_Union(empty, empty) == empty
-{{{
- SQL Server 2008 Geometry
-   SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
-     => GEOMETRYCOLLECTION EMPTY
- SQL Server 2008 Geography
-    SELECT (Geography::STGeomFromText('POLYGON EMPTY',4326).STUnion(Geography::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
-      => GEOMETRYCOLLECTION EMPTY
-   
-}}}
  * ST_Difference(geometry, empty) == geometry
-
-{{{
-SQL Server 2008 Geometry: 
-   SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STDifference(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText()
-  => POINT (1 3)
-}}}
-
  * ST_Difference(empty, geometry) == empty
-{{{
-SQL Server 2008 Geometry: 
- SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STDifference(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText()
-  => GEOMETRY COLLECTION EMPTY
-}}}
-
  * ST_Distance(geometry, empty) == NULL
  * ST_DWithin(geometry, empty, tolerance) == FALSE
  * ST_Contains(geometry, empty) == FALSE
-
-{{{
-SQL Server 2008 Geometry
-SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STContains(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
-  => 0
-}}}
-
  * ??? ST_Contains(empty, empty) == FALSE
-
-{{{
-SQL Server 2008 Geometry
- SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STContains(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
-  => 0
-
-}}}
-
-   
  * ST_Intersects(geometry, empty) == FALSE
-
-{{{
-SQL Server 2008 Geometry
-  SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STIntersects(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
-  => 0
-}}}
-
  * ??? ST_Intersects(empty, empty) == FALSE
-{{{
-SQL Server 2008 Geometry
-  SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STIntersects(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
-    => 0
-}}}
-
  * ??? ST_Disjoint(empty, empty) == FALSE
-
-{{{
-SQL Server 2008 Geometry
- SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STDisjoint(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
-  => 1
-}}}
-
  * ??? ST_Disjoint(geometry, empty) == FALSE
-{{{
-SQL Server 2008 Geometry
- SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STDisjoint(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
-  => 1
-}}}
  * ST_IsSimple(empty) == TRUE
-
-{{{
-SQL Server 2008 Geometry
-   SELECT Geometry::STGeomFromText('POLYGON EMPTY',4326).STIsSimple() 
-     => 1
-}}}
-
  * ST_IsValid(empty) == TRUE
-
-{{{
-SQL Server 2008 Geometry
-  SELECT Geometry::STGeomFromText('POLYGON EMPTY',4326).STIsValid()
-   => 1
-}}}
-
 
 ''Note:''
@@ -121 +32 @@
  * ST_Disjoint( empty, empty ) == FALSE
  * ST_Distance( empty, empty) == 0
-
-{{{
-SQL Server 2008 Geometry:
-   SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STDistance(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
- => NULL
-}}}
-
  * ST_DWithin( empty, empty, tolerance) == true
 
@@ -135 +39 @@
  * intersection( empty, empty) == empty
 
+!! SQL Server 2008
+
+For reference and comparison, courtesy of Robe:
+
 {{{
-SQL Server 2008 Geometry: 
-   SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STIntersection(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText()
-=> GEOMETRY COLLECTION EMPTY
+ SELECT Geometry::STGeomFromText('POINT(1 2)',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))
+  => POINT (1 2)
+
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
+  => GEOMETRYCOLLECTION EMPTY
+
+ SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STDifference(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText()
+  => POINT (1 3)
+
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STDifference(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText()
+  => GEOMETRY COLLECTION EMPTY
+
+ SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STContains(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
+  => 0
+
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STContains(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
+  => 0
+
+ SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STIntersects(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
+  => 0
+
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STIntersects(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
+  => 0
+
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STDisjoint(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
+  => 1
+
+ SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STDisjoint(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
+  => 1
+
+ SELECT Geometry::STGeomFromText('POLYGON EMPTY',4326).STIsSimple() 
+  => 1
+
+ SELECT Geometry::STGeomFromText('POLYGON EMPTY',4326).STIsValid()
+  => 1
+
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STDistance(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
+  => NULL
+
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STIntersection(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText()
+  => GEOMETRY COLLECTION EMPTY
+
 }}}