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

Timestamp:

Feb 5, 2009, 8:56:42 PM (15 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/09-02-05

@@ -79 +79 @@
 }}}
  * 現有資料經緯度範圍
-{{{
-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 )
+{{{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
+WHERE loc1_lon >0 AND loc1_lat >0
 }}}
 || 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 ||
+|| 123.60018 || 35.41830 || 123.60018 || 35.41830 || 106.51300 || 1.98380 || 106.51300 || 1.98380 ||