CSMART: Difference between revisions

From CIRPwiki
Jump to navigation Jump to search
*>Anonymous
*>Anonymous
Line 60: Line 60:
In addition to ranking strucutres according to each feature individually a global ranking of strucures incorporating all of the selected features may also be executed. By selecting the Global Ranking sub-tab the user may set a weight for each feature. The total of all the weights entered must be equal to one. By weighting each feature the user can specify how much he/she wants each feature to be counted toward the global ranking of the structures (see Figure 7).
In addition to ranking strucutres according to each feature individually a global ranking of strucures incorporating all of the selected features may also be executed. By selecting the Global Ranking sub-tab the user may set a weight for each feature. The total of all the weights entered must be equal to one. By weighting each feature the user can specify how much he/she wants each feature to be counted toward the global ranking of the structures (see Figure 7).


[[Image:Weightings.jpg|400px|thumb|left|Fig. 7 – Global Ranking]]  
[[Image:Weightings.jpg|400px|thumb|left|Fig. 7 – Weighting of each feature for global ranking of structures]]
<br style="clear:both" />
 
Once all the weightings have been entered the user must click the "Update Weightings" button. Next the Global Rankings sub-tab may be selected, which will generate a table with a normalized ranking for each structure under each of the selected features. CSMART also computes an overall structure ranking and sorts the table accordingly. Figure 8 shows an example of the global rankings table.
 
[[Image:GlobalRankingsTable.jpg|400px|thumb|left|Fig. 8 – Global Rankings Table]]  
<br style="clear:both" />
<br style="clear:both" />



Revision as of 20:51, 8 June 2011

Coastal Structures Management, Analysis, and Ranking Tool (CSMART)

POC: Dr. Kenneth Ned Mitchell <br\>Kenneth.n.mitchell@usace.army.mil <br\>601-634-2022 <br\>US Army Engineer Research and Development Center (ERDC) <br\>Coastal and Hydraulics Lab (CHL)


CSMART is developmental software that is updated frequently.

CSMART Introduction

The Coastal Structures Management, Analysis, and Ranking Tool (CSMART) is an internet application being developed in the Coastal Inlets Research Program (CIRP) for prioritization of coastal jetties and breakwaters in O&M budget development. CSMART may be accessed at https://cpt.usace.army.mil/Structures with CAC authentication. CSMART employs structured query language to access a variety of data sets that provide indicators of coastal structure significance. For example, metrics for economic activity supported by coastal structures include commercial tonnage in associated channels, nearby commercial fish landings, and associated cruise and ferry passenger statistics. These and other selected metrics are analyzed to produce customized rankings of coastal structures according to user-specified filters and search criteria. The final rankings can be exported and saved for later viewing, or used to generate Google Earth™ overlays for visualizations. CSMART is designed for use by personnel at the District, Division, and HQ levels of Corps management.

CSMART General Layout

CSMART is organized into a series of steps (see Figure 1) to guide the user in filtering the query, picking locations for analysis, and displaying the results. Step 1 is titled: Features. These are commercial tonnage, coast guard incidents, dredging, and other metrics which can be selected by the user. Step 2: Structures; allows the user to specify the structures to include in the analysis. The structures are organized by district. Step 3: Execute Query. Once all selections have been made the query is executed. Step 4: View Results. After completing the query CSMART ranks each of the structures selected in Step 2 according to each of the metrics chosen in Step 1 individually. A global ranking incorporating all the selected features and structures may also be executed during this step.

File:HomeScreen Features.jpg
Fig. 1 – Steps Tabs


Step 1: Features

Step 1 prompts the user to select which features to include in the analysis. The features include: commercial tonnage, commercial fishing, coast guard incidents, dredging, cruise data, ferry data, boat ramps/marinas, binary choices, and structure condition ratings. These metrics are accessed via the sub-tabs as shown in Figure 2.

File:HomeScreen Features2.jpg
Fig. 2 – Features Tabs


The user may select one or more of the sub-tabs for the analysis by clicking on the tab and checking the “Include?” box. Once a sub-tab has been selected the user can choose what data within each sub-tab to include in the query. For example, under the commercial tonnage sub-tab, selections for movement, year, and commodity are available. After all selections within a sub-tab are made the "Save Filter Selections" button must be pushed in order for the selections to be included in the analysis. The user may then move to other sub-tabs and make similar selections to filter the query.

Data for commercial tonnage, coast guard incidents, and dredging were obtained from the US Army Corps of Engineers (USACE) Navigation Data Center (http://www.ndc.iwr.usace.army.mil/index.htm). Commercial fishing data were taken from The National Oceanic and Atmospheric Administration’s National Marine Fisheries Service (NOAA-NMFS). Cruise data were obtained from the US Dept of Transportation’s Maritime Administration and Ferry data from Research and Innovative Technology Administration (RITA) Bureau of Transportation Statistics (BTS). Boat Ramp locations were from multiple sources. A nation wide database from EarthNC was supplemented by other sources for many individual coastal states. Binary choices allow the user to include structures that support a harbor of refuge, a subsistence harbor, public transportation, a military base, etc. These data come from project usage codes maintained by the Navigation Business Line at USACE-HQ. Finally, structure condition ratings were obtained from communications with district personnel. Commercial tonnage and cruise data are hard-linked to Corps structures, whereas the other data sets are spatially joined to selected structures by a user specified search radius. Figure 3 shows a one mile search radius around the East Arrowhead Breakwater in Cleveland. The red pins represent Coast Guard incidents, the yellow represent boat ramps and marinas, and the green represents dredging events that took place within the search radius.

File:SearchRadius.jpg
Fig. 3 – All selected data within the user specified search radius is credited to the structure for analysis


Step 2: Structures

CSMART allows the user to select any coastal structure or structures within the USACE portfolio for analyses and comparison. By clicking the Step 2: Structures Tab, a drop down tree organized into USACE districts appears. This tree is organized into a hierarchy containing districts, projects and individual structures. The user may click the small triangles to open the next level of the hierarchy. Structures may be chosen for analysis at each level in the tree by clicking the small box next to the desired selection. Once all selections have been made the user must push the "Save Filter Selections" button in order for the structures to be included in the analysis.

File:StructuresTab.jpg
Fig. 4 – Structures Tab


Step 3: Execute Query

Once all selections under steps one and two are completed selecting step 3 will execute the query. Depending on the users selections the query may take several seconds. Once complete the tab labeled Step 4: View Results will be visible.

Step 4: View Results

The results for each of the features selected in Step 1 is available to the user by clicking on the appropriate sub-tab under the View Results Tab. By selecting one of the sub-tabs CSMART will display each of the selected structures with its associated rank and data. Figure 5 shows the tonnage results of all the structures within CSMART for 2006 (Note: CSMART does not include local or internal traffic in tonnage totals). By selecting Fishing or Coast Guard the user would be able to see the data and rankings of the selected structures according to those metrics. Notice that when a sub-tab is selected that was not included by the user a message is displayed saying the feature has not been included for analysis.

File:ViewResults Tonnage.jpg
Fig. 5 – Tonnage output for 2006 under the View Results Tab


After looking at the results for a particular feature the user may want more detailed data for a particular structure. In this case the user may click on the row containing the desired structure and a new sub-tab will appear with the structure name. Selecting the new sub-tab will show the user a more detailed breakdown of the particular feature for the selected structure. For example, by clicking the row corresponding to "LA-LB Harbors San Pedro Breakwater, California" under the tonnage tab the data shown in Firure 6 is displayed.

File:Tonnage Details.jpg
Fig. 6 – 2006 Tonnage details for the San Pedro Breakwater


In addition to ranking strucutres according to each feature individually a global ranking of strucures incorporating all of the selected features may also be executed. By selecting the Global Ranking sub-tab the user may set a weight for each feature. The total of all the weights entered must be equal to one. By weighting each feature the user can specify how much he/she wants each feature to be counted toward the global ranking of the structures (see Figure 7).

File:Weightings.jpg
Fig. 7 – Weighting of each feature for global ranking of structures


Once all the weightings have been entered the user must click the "Update Weightings" button. Next the Global Rankings sub-tab may be selected, which will generate a table with a normalized ranking for each structure under each of the selected features. CSMART also computes an overall structure ranking and sorts the table accordingly. Figure 8 shows an example of the global rankings table.

File:GlobalRankingsTable.jpg
Fig. 8 – Global Rankings Table


Step 5: Google Earth

After a global ranking has been executed the results may be displayed as a Google Earth KML file. After clicking on the Google Earth tab the user is prompted to enter a name and a description for the file. The file can then be saved and opened in Google Earth. Figure 7 shows the Google Earth image corresponding to the Global Rankings shown in Figure 6. Notice by clicking on the location marker in Google Earth the user may see the data corresponding to that location.

File:GoogleEarthOutput.jpg
Fig. 8 – Google Earth Output