Changes between Version 8 and Version 9 of oid/WorkLog/09-02-05

Timestamp:

Feb 5, 2009, 8:54:14 PM (15 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/09-02-05

@@ -78 +78 @@
 }
 }}}
+ * 現有資料經緯度範圍
+{{{
+SELECT max( loc1_lon ) , max( loc1_lat ) , max( loc2_lon ) , max( loc2_lat ) , min( loc1_lon ) , min( loc1_lat ) , min( loc2_lon ) , min( loc2_lat )
+FROM maincase_new
+}}}
+|| max(loc1_lon) || max(loc1_lat) || max(loc2_lon) || max(loc2_lat) || min(loc1_lon) || min(loc1_lat) || min(loc2_lon) || min(loc2_lat) ||
+|| 123.60018 || 35.41830 || 123.60018 || 35.41830 || 0.00000 || -0.34000 || 0.00000 || -0.34000 ||