EPA Aggregator Tools User Manual
Contents
1. jw Lise selected features 1 features selected Apply a buffer to the features in states Presley The red features representthe features in States The highlighted cyan features are selected because they Intersect the red features Points Folyqans Apply Close All the ModelGrid cells located in Illinois are selected e Select Deposition Visualization Display Deposition Total Keep the defaults and click OK The function processes all the selected cells which are displayed as processed at the end of the process November 2006 10 EPA Aggregator Tools Version 1 0 User Manual Aggregator mxd ArcMap Arcinfo ale File Edit View Insert Selection Tools Window Help DsaS t BBX lo e Deposition Visualization Clear Display Help amp Layers E Y Aggregator MercuryDeposition mdb Data E States M ModelGrid TotalDeposition Cell_Value O 0 2 3 5 6 10 E 11 50 51 100 MM 101 1000 ResultTable SourcelDCrossRef E Y Aggregator aggregator mdb TotalDeposition DepositionFraction e pa Michigan RA uk Kad AK a LPL TT TT oe LELLE ESSER ERE eee eee Indiana AL LLLLLLLLLLUI Pree a LO LT a a a a E Baa ung Hag jas a a El a boah f LILLIA a e a EEOrHY 103 Ati titty E m E Display Source a 354574 87 238295 63 Meters Note You can check the statistics for the Cell_ Value field2. 2 13 5 6 10 MA 11 50 MA si 100 E 101 1000 ResultTable SourcelDCrossRef El 5 De 4ggregatorlaggregator mdb Totalbeposition DepositionPraction lora EA oak Ku aE sisi Winds Indiana orntt e 2 Mi Sour Ta i Kentucky rm a AE r Display Source Pojem al E 2 381336 54 442705 05 Meters A The function creates the table TotalDeposition and DepositionFraction and adds them into the Table of Contents of ArcMap Notes November 2006 8 EPA Aggregator Tools Version 1 0 User Manual 1 With 300 sources the processing time 1s roughly 15 20 seconds per cell when so processing one state such as Illinois should take about 4 to 5 hours This tutorial uses data from 4 sources only 2 Edits are saved each time 5 cells have been processed 3 You can cancel the process by clicking escape The function will finish processing the current cell and then escape 4 The message on the status bar shows the number of cells processed and the total number of cells The Total Deposition table stores the preprocessed total of deposition from all sources Created Fields Cell_ID Long integer representing the unique ID of the cell Cell_Value Total deposition value from all sources in g km H Attributes of TotalDeposition KOX OBJEC TID Cell ID Cell Value n 5 524 12094261 O 12094262 7 12094263 E 12094264 El 12094597 Record showy sek The Depo
3. Display Source study area and the importance of 12 Generate Deposition Chart Select Deposition Visualization gt Generate Deposition Chart will be selected as domain The user can select individual source s for plotting the graph Select the state of Illinois on the map Alternatively the user can select the top contributors 1 to 5 among the sources for their contribution relatively to the selected domain of sources By default all the sources plotting the graph The function Generates Deposition Chart allows generating a pie chart showing the load contribution in grams of specific sources for the selected The objective of this step is to visualize the contributions in the state of Illinois which defines the Study Area November 2006 2 3 EPA Aggregator Tools Version 1 0 User Manual EPA Aggregator Deposition Visualization Clear Display Help Display Deposition Total Generate Deposition Chart e Specify as Study Area the States feature class Illinois is the only selected state and represents the area of interest Select SourcelDCrossRef as Source Lookup Click OK Generate Deposition Chart stuchy rea States Model Grid ModelGrid a Source Lookup SourcelDCrossRef Y Total Deposition TotalDeposition Deposition Fraction DepositionFraction Graph Values Graphwalues Help Cancel The form Select source s for plotting 1s displayed This form offers 2 options for th
4. by right clicking this field and selecting Statistics ES Attributes of TotalDeposition _ OBJECTID __ Cell iD Cell Value O 1 12094261 E Sort Ascending 2 12094262 2 3 12094263 21 F Sort Descending 4 12094264 Soe El 5 12094597 dt Calculate Values A 2 oo Statistics Freeze Unfreeze Column Delete Field 2 2 Clear Display The function Clear Display allows removing the join and the symbology created by the function Display Deposition total The symbology associated to the layer file ModelGrid lyr is reapplied to the Model Grid polygon feature class so that all cells are again visible The layer file is stored by default in the directory C Program Files ESRI WaterUtils ArcHydro Bin November 2006 11 User Manual Select Clear Display If the Model Grid layer is not set the function prompts for the layer to use as Model Grid EPA Aggregator Tools Version 1 0 Otherwise the function proceeds without asking the user a E Jl Ji Jr E DA n A A A M eh CORRE HTP BEER Ea Hes T A a 284640 68 321177 85 Meters z T a a A noe 0 11A4L0 lt gt Yv Help 11 7 029 725 Clear Display Help a Y ES M ModelGrid Y Aggregator MercuryDeposition mdb Data Y Aggregator aggregator mdb File Edit View Insert Selection Tools Window Hel Aggregator mxd ArcMap Arcinfo Deposition Visualization Y amp Layers
5. for plotting Select deposition contributors Select deposition domain IL_ Joliet_29 IL_ Joliet_29 IL_Joppa_Steam IL_Joppa_Steam Select All IL_Other_non utility_sources_inside_Chicago_MSA IL_Other_non utility_sources_inside_Chicago_MSA IL_Other_Sources IL_Other_Sources Clear All IL_Other_utilities_inside_Chicago_MSA IL_Other_utilties_inside_Chicago_MSA IL_Other_utilities_outside_Chicago_MSA IL_Other_utilities_outside_Chicago_MSA IL_Powerton IL_Powerton IL_ Waukegan IL_Waukegan Number of top contributors gt The function overwrites the records in the output GraphValues table and generates a new pie chart showing the loads from the top 3 contributor for the state of Illinois as well as the load from all other sources from the selected domain November 2006 15 EPA Aggregator Tools Version 1 0 User Manual ES Attributes of GraphValues OBJEC TID Cell Value Source Name pem 3 60196 040 IL_ Other Sources E 4 o79 76 621 IL Other non utility sources inside Chicago MSA 5 54961 602 IL Joppa Steam El 6 52344 383 Other sources Record ma 1 gt mn Show All Selected Records 0 outof 4 Selecte Deposition Chart Total mercury 225 080 8 g Total Area 144 141 96 Sq km Notes The cell area used to compute the load for each cell is read from the XML file It defaults to 144 km2 12x12 km cells The title of the chart and the unit for the load are also read from the XML 2 4 Help The Hel
6. DCrossRef ResultTable ori PSO But ae i Display Source 3441669 17 5778739 41 Mete November 2006 6 EPA Aggregator Tools Version 1 0 User Manual 2 1 Display Deposition Total The Display Deposition Total tool has 3 main purposes l 2 Compute the deposition total from all sources for each selected Model Grid cell and store this value in the output Total Deposition table Compute the fraction of the total deposition for each source and store this value in the output Deposition Fraction table This improves the performance when generating the pie chart Create a join between the Model Grid polygon feature class and the output Total Deposition table using the common Cell_ID attribute unique identifier of the model grid cell and apply a range symbology from 0 to 1000 to the Model Grid feature class based on the joined field TotalDeposition TotValue to show to the user only the cells that have been preprocessed A pie chart may be generated only for study areas for which all cells and neighboring cells have been preprocessed Notes No Data values are representing by 999 and are ignored in the computation The function works on a selected set of model grid cells Only the cells that have not already been preprocessed will be processed The user can select only the cells of interest and keep building the preprocessed data for the entire U S or choose to process all the cells at once Since most of the
7. EPA Aggregator Tools User Manual Version 1 0 November 2006 EPA Aggregator Tools Version 1 0 User Manual Table of Contents T A Tee nt ee Soy ene Oey en nS ener sey oT rrr oes ane tena eter l t Data Requirements a T aE 4 1 1 Model Grd polygon feature Class unid 4 12 Model Result table asc a 4 1 3 Source LOOKUP table ardido 4 1 4 Study Area polygon feature class optional ooooccccccccnononooncnnnnnnnonononanononos 5 2 EPA Aseresator OO Suri 6 NS E O 6 Zal Display Deposition Total oa 7 22 Clean BATS 8 20 O PON ce are reat ee I ee ee 11 2 3 Generate Deposition Carta a in Ge AR 12 De PO A EES 16 11 EPA Aggregator Tools Version 1 0 User Manual Getting started Setting uo the EPA Aggregator Software Reguirements Microsoft Net Framework 1 1 ArcGIS 9 0 9 1 with Net libraries XML Parser version 4 0 Water Utilities Application Framework ApFramework Arc Hydro Tools 1 Install the Arc Hydro Tools The EPA Aggregator toolbar is installed as part of the Arc Hydro tools Read the Arc Hydro tools Tutorial for instructions on how to install Arc Hydro and other required software Note Microsoft Net Framework 1 1 must be installed before ArcGIS for the Net Support libraries to be available when installing ArcGIS If ArcGIS is installed on your computer but the Net Framework 1 1 is not installed you need to install the Net Framework and then modify your ArcGIS installation to in
8. analysis will be done locally preprocessing the entire US is not required If no cells are selected the user will be asked whether to process all the cells in the model grid which will take a long time to complete This tool will compute the deposition total for the selected cells in Model Grid layer and compute total deposition for every single cell from all the sources in the ResultTable e Select a few Model Grid cells e Select Deposition Visualization Display Deposition Total EP4 Aggregator Deposition Visualization Clear Display Help Display Deposition Total Generate Deposition Chart The following form is displayed November 2006 7 EPA Aggregator Tools Version 1 0 User Manual Display Deposition Total Model Grid ModelGrid Model Result ResultTable Total Depasition TotalDeposition Deposition Fraction DepositionFraction OK Help Cancel e Select the Model Grid polygon feature class as Model Grid and ResultTable as Model Result The function will generate the output tables TotalDeposition and DepositionFraction if they do not already exist Click OK Aggregator mxd ArcMap ArcInfo File Edit wiew Insert Selection Tools Window Help Deng t BX a ola ize l or Deposition Visualization Clear Display Help eee 7 Michigan x pl El De Aggregator MercuryDeposition mdb E PH Data States E ModelGrid Totalbeposition Cell Value 0
9. e choice of sources to plot 1 Select deposition contributors this option allows selecting specific sources that will all be plotted 2 Number of top contributors this option specifies the number of top contributor sources to plot 1 5 The user needs also to specify the deposition domain 1 e which sources to include for computing the total deposition 100 First check the contribution of IL_ Joliet_29 versus all other sources e Check Select deposition contributors and click on IL_Joliet_29 All the sources should be selected under Select deposition domain Click OK November 2006 13 EPA Aggregator Tools Version 1 0 User Manual Select source s for plotting f Select deposition contributors IL_ Joliet_29 IL_Joppa_Steam IL_Other_non utility_sources_inside_Chicago_MSA IL_Other_Sources IL_Other_utilities_inside_Chicago_MSA IL_Other_utilities_outside_Chicago_MsA IL_Powerton IL_ Waukegan Select deposition domain IL_Joliet_29 IL Joppa_Steam IL_Other_non utility_sources_inside_Chicago_MSA IL_Other_Sources IL_Other_utilties_inside_Chicago_MSA IL_Other_utilities_outside_Chicago_MsA IL_Powerton IL_Waukegan Select All Clear All ec C Number of top contributors The function creates the output GraphValues if it does not already exists and overwrites any existing record in this table The GraphValues table stores all the sources and their related deposition total Beside t
10. he selected source IL_Joliet_29 there is one additional row to store the Other group which is the difference in total between the selected domain and selected sources GraphValues table Created Fields Cell_Value Total deposition value in grams from a specific source Source_Name Text representing the full description of the source ES Attributes of GraphValues Att of G EX OBJECTID Cell Value Source Name H 52344 383 IL_Joliet_29 172736462 Other sources El 25 Record mM al 1 gt m1 show All Sele The function uses the GraphValues table to plot the pie chart showing the contributing deposition loads for the specified study area The graph is plotted in a dockable window that can be docked anywhere on the screen This chart can be screen captured and pasted in other Windows applications November 2006 14 EPA Aggregator Tools Version 1 0 User Manual Deposition Chart Total mercury 225 080 8 g Total Area 144 141 96 Sq km Note Other custom graphs can be created by using out of the box ArcGIS graphing tools with the GraphValues as source table Check now the top 3 contributors for Illinois e Close the chart Select Deposition Visualization gt Generate Deposition Chart e Inthe Select source s for plotting form select 3 as Number of top contributors Make sure all sources are selected under Select deposition domain and click OK Select source s
11. n feature class The first required input required by the EPA Aggregator tools is a polygon feature class representing the spatial extent of model grids in a projected coordinate system e g USA_Contiguous_Lambert_Conformal_Conic This feature class must contain the field File_ID storing the unique identifier of each model grid cell Required Field Cell_ID Long integer representing the unique ID of the cell 1 2 Model Result table The second input required by the tools is a Model Result table storing the result of a model run for the chemical component of interest This table must contain the fields File_ID TotValue and Source that characterize the total deposition of the chemical component by source in a model grid cell of the associated Model Grid polygon feature class Required Fields Cell_ID Long integer representing the unique ID of the cell Cell_Value Total deposition value in g km from all seasons and all types e g wet and dry for Mercury deposition from a specific source for the current cell Source_ID Integer representing a source of deposition 1 3 Source Lookup table The third required input is the Source Lookup table that stores the name of the sources the user can select when selecting parameters for the pie chart This table must contain the fields Source and SourceDescription The Source field is used to relate to the Model Result table November 2006 4 EPA Aggregator Tools Versi
12. on 1 0 User Manual Required Fields Source_ID Integer representing the source of deposition Source_Name Text representing a description of the source that user can select when generating a pie chart 1 4 Study Area polygon feature class optional The Study Area polygon is an optional input The Model Grid can be used instead if needed The selected features in this feature class define the study area of interest for the chart November 2006 EPA Aggregator Tools Version 1 0 User Manual 2 EPA Aggregator Tools The EPA Aggregator tools allow visualizing the importance of the contribution of multiple sources to the amount of chemical e g mercury in a given study area e g County State Watershed The tools can be tested by using the sample geodatabase MercuryDeposition mdb that can downloaded with the tools 2 0 Load Sample Data The MercuryDeposition sample geodatabase that can be downloaded from the ArcHydro Data directory on the ftp site ftp esri com RiverHydraulics river 1114 contains 2 feature classes and 2 tables Sw MercuryDeposition A Data El ModelGrid States e Add all the data into the Table of Contents of ArcMap Aggregator mxd ArcMap Arcinfo File Edit View Insert Selection Tools Window Help DOS de SS BX o fro s33 On Deposition Visualization Clear Display Help pa Layers E C Aggregator MercuryDeposition mdb t Data States ModelGrid Sourcel
13. p button launches the online help for the EPA Aggregator tools November 2006 16
14. sition Fraction table stores the preprocessed fraction of deposition of a specific source against total of deposition from all sources Created Fields File_ID Long integer representing the unique ID of the cell Source_ID Integer representing the source of deposition Fraction Fraction of deposition of a specific source against total of deposition from all sources ES Attributes of DepositionFraction Lx OBJEC TID Cell ID Source gt J Fraction A ES 12094261 0 256 B 2 12094261 0 267 3 12094261 87 0 233 4 12094261 88 0 244 E LJ Record a a 1 gt Show All Selected Records The objective of this tutorial is to assess the main contributing sources for the state of Illinois so all the cells within Illinois need to be preprocessed e Select the state of Illinois on the map e Click Selection gt Select By Location e Inthe Select By Location form Choose select features from November 2006 9 EPA Aggregator Tools Version 1 0 User Manual Check ModelGrid Choose Intersect Select States Check Use selected features Click Apply Select By Location Lets you selectfeatures from one or more layers based on where they are located in relation to the features in another layer want to select features from the following layer s Only show selectable layers in this list that intersect the features in this layer states
15. stall the Net Support libraries 2 Open ArcMap and load the EPA Aggregator toolbar e Open ArcMap Create a new empty map and save it as Aggregator mxd or any other name e Right click on the menu bar to pop up the context menu showing available tools November 2006 l EPA Aggregator Tools Version 1 0 User Manual Dr ayy E Ee Editor The EPA Aggregator toolbar is shown below EPA Aggregator Ed Deposition Visualization Clear Display Help November 2006 2 EPA Aggregator Tools Version 1 0 User Manual Data Management Data Location Data can be stored in any geodatabase and loaded in the map Tables created with the EPA Aggregator tools are stored in the Vector target location which defaults to a personal geodatabase located in the same directory as the map document and named after the mxd For example a table generated in the map document Aggregator mxd will be stored in a personal geodatabase called Aggregator mdb The location of the vector data can be explicitly specified using the function ApUtilities gt Set Target Locations that is available in the ApUtilities menu in the Arc Hydro toolbar November 2006 3 EPA Aggregator Tools Version 1 0 User Manual 1 Data Requirements The EPA Aggregator tools use the following input data Model Grid polygon feature class Model Result table Source Lookup table Study Area polygon feature class optional 1 1 Model Grid polygo
Download Pdf Manuals
Related Search