2007-06-20

mapinfo SQL 20070620

Select * from grid25yr_up25cm where Grid_code>= .25 and Grid_code<.5
into Selection
Browse * From Selection
Select * from grid25yr_up25cm where Grid_code>= .5 and Grid_code<1
into Selection
Browse * From Selection
Select * from grid25yr_up25cm where Grid_code>=1 and Grid_code<2 into Selection
Browse * From Selection
Select * from grid25yr_up25cm where Grid_code>=2 and Grid_code<3 into Selection
Browse * From Selection
Select * from grid25yr_up25cm where Grid_code>=3 and Grid_code<4 into Selection
Browse * From Selection
Select * from grid25yr_up25cm where Grid_code>=4 and Grid_code<5 into Selection
Browse * From Selection
Select * from grid25yr_up25cm where Grid_code>=5 and Grid_code<6 into Selection
Browse * From Selection
Select * from grid25yr_up25cm where Grid_code>=6 into Selection
Browse * From Selection
Update Query12 Set deep = 1
Browse * From Query12
Update Query13 Set deep = 2
Browse * From Query13
Update Query14 Set deep = 3
Browse * From Query14
Update Query15 Set deep = 4
Browse * From Query15
Update Query16 Set deep = 5
Browse * From Query16
Update Query17 Set deep = 6
Browse * From Query17
Update Query18 Set deep = 7
Browse * From Query18
Update Query19 Set deep = 8
Browse * From Query19

沒有留言:

張貼留言

QGIS 圖資自動輸出與簡報產製流程說明

  QGIS 圖資自動輸出與簡報產製流程說明 一、目的說明 本流程主要目的,是將既有的 GIS 圖資與分析成果,透過 QGIS 專案與版面配置設定,自動輸出為圖片,並依序套用到簡報檔案中,減少人工截圖、貼圖與排版時間。 透過此方式,可快速產製多個行政區、鄉鎮、市區或指定範圍的成果...