Automation in Creating Drought Map Images by Wrapping the ArcObjects in the Application

By John Zhu

Transcript

1. Automation in Creating Drought Map Images by Wrapping the ArcObjects in the Application John  Zhu,  Ph.D.   Hydrologist   Texas  Water  development  Doard  
2. TWDB  and  Drought   •  TWDB  was  created  a@er  50’s  drought   •  Water  Planning  by  TWDB  is  based  on  Drought-­‐ of-­‐Record  condiHon.   •  Plays  key  role  during  drought  in  term  of   financial  support   •  Plays  important  role  in  TX  Drought  Council   under  DPS   •  Collect  and  post  important  drought   informaHon  for  the  public  
3. Important  Drought  Info   •  PDSI  -­‐  Palmer  Drought  Severity  Index   •  SPI  –  Standardized  PrecipitaHon  Index   •  CMI  –  Crop  Moisture  Index   •  KBDI  –  Keetch-­‐Byram  Drought  Index   •  RSI  –  Reservoir  Storage  Index   •  SFI  –  Streamflow  Index   •  ……….  
4. Tabular  Data  is  Not  Enough  
5. Map  is  Preferred  
6. Map  Must  be  Latest  
7. AutomaHon  is  a  Key   •  Collect  data  -­‐>  insert  into  DB  -­‐>  retrieve  data   •  Use  programming  tool  to  wrap  the  ArcObjects   •  Program  manipulates  data,  color  and  label   •  Program  orders  map  layout  to  be  exported  to   image   •  Build  an  executable  by  the  applicaHon   •  Set  up  schedule  for  executables  to  work   automaHcally  
8. Create  ArcMap  Document  
9. Add  Reference  in  ApplicaHon  
10. Open  ArcMap  in  ApplicaHon  
11. Get  Drought  Data  from  Database  
12. Manipulate  Layer  Color  and  Label  
13. Export  Map  Layout  to  Image  
14. Two  Steps  Approach   •  SymbolizaHon  ready  in  ArcMap  thru  A_ribute   Table  joinHng  Excel  Table   •  FIRST  PROGRAM:    Retrieve  data  from  DB  and  update  Excel  table   (Never  open  ArcMap)   •  SECOND  PROGRAM:    Open  ArcMap,  update  label  and  export  map   layout  (automaHc  symbolizaHon)  
15. Don’t  Forget  to  Ask  ESRI    for  License  Code  
16. Examples  of  Exported  Images        
17. Examples  of  Exported  Images         h_p://www.twdb.texas.gov/apps/droughHnfo/default.aspx  
18. Examples  of  Exported  Images      h_p://www.twdb.texas.gov/apps/droughHnfo/default.aspx    
19. Examples  of  Exported  Images      h_p://www.twdb.texas.gov/apps/droughHnfo/default.aspx    
20. Conclusions   •  Extremely  reliable   •  100%  efficiency   •  Draw  beauHful  map  without  hand   •  Management  is  saHsfied   •  Public  is  happy