CSMART: Difference between revisions

From CIRPwiki
Jump to navigation Jump to search
*>Anonymous
mNo edit summary
 
(27 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=''' Coastal Structures Management, Analysis, and Ranking Tool (CSMART) '''=
=''' Coastal Structures Management, Analysis, and Ranking Tool (CSMART) '''=
[[Image:CSMART Main Page.png|500px|thumb|Right|CSMART and CSMART Silverlight Edition]]
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 OM budget development. CSMART may be accessed at https://cpt.usace.army.mil/Structures with CAC authentication, additionally the developmental version of CSMART Silverlight Edition may be accessed at https://itlgis01.usace.army.mil/csmart/.
CSMART accesses 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.




Line 10: Line 17:


CSMART is developmental software that is updated frequently.
CSMART is developmental software that is updated frequently.
<br style=clear:both />


=''' CSMART Introduction '''=
=''' 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.


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. Accessed through a straightforward user interface, 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.
[[Image:HomeScreen_Features.jpg|400px|thumb|left|Fig. 1 – Steps Tabs]]
<br style=clear:both />


='''  CSMART General Layout  '''=
=='' Step 1: Features ''==
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: Locations; allows filtering at the project, district, divisions, and coast levels. 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 structure within the locations selected in Step 2 according to each of the metrics chosen in Step 1 individually. A global ranking including all the selected metrics may also be executed during this step. Step 5: Google Earth. Once a global ranking is executed it may be exported as a Google Earth overlay for visual representation.


[[Image:CSMART_Steps.jpg|400px|thumb|left|Fig. 1 – Steps Tabs]]
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.
<br style="clear:both" />


=='' Step 1: Features ''==
[[Image:HomeScreen_Features2.jpg|400px|thumb|left|Fig. 2 – Features Tabs]]
<br style=clear:both />


Step 1 prompts the user to select which metrics to include in the analysis. The metrics include: commercial tonnage, coast guard incidents, dredging, commercial fishing and boat ramps. These metrics are accessed via the sub-tabs as shown in Figure 2.
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.  


[[Image:CSMART Open Page.jpg|400px|thumb|left|Fig. 2 – Features Tab]]
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 nationwide 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.
<br style="clear:both" />


The user may select one or more of the sub-tabs for the analysis by 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. 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 Navigation Data Center (http://www.ndc.iwr.usace.army.mil/index.htm). Commercial fishing data is taken from The National Oceanic and Atmospheric Administration’s National Marine Fisheries Service (NOAA-NMFS).
[[Image:SearchRadius.jpg|400px|thumb|left|Fig. 3 – All selected data within the user specified search radius is credited to the structure for analysis]]
Corps structures that support tonnage are hard-linked to the specific waterways they support.  Commercial fishing, coast guard incidents, dredging and boat ramps are spatially linked to structures within a user specified radius.
<br style=clear:both />


==''  Step 2: Locations ''==
==''  Step 2: Structures ''==


CSMART allows the user to choose varying levels of resolution for analysis and ranking. Under Step 2: Locations are sub-tabs for projects, districts, divisions, and coasts. After selecting a level of resolution the locations desired for analysis and ranking may be selected. Figure 3 below shows a selection at the district level with the Charleston (SAC), Jacksonville (SAJ), Mobile (SAM), Savannah (SAS), Wilmington (SAW), and Galveston (SWG) Districts chosen for the analysis and ranking.
CSMART allows the user to select any of the Corps coastal structures 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.


[[Image:LocationsTab.jpg|400px|thumb|left|Fig. 3 Locations Tab]]  
[[Image:StructuresTab.jpg|400px|thumb|left|Fig. 4 Structures Tab]]  
<br style="clear:both" />
<br style=clear:both />


==''  Step 3: Execute Query  ''==
==''  Step 3: Execute Query  ''==
Line 44: Line 52:
==''  Step 4: View Results  ''==
==''  Step 4: View Results  ''==


Each of the features selected by the user in Step 1 is a sub-tab under the View Results Tab. By selecting one of the sub-tabs CSMART will display each of the user selected locations with its associated rank and data. Figure 4 shows the tonnage results. By selecting Fishing or Coast Guard the user would be able to see the locations ranked according to those metrics. Notice that both the dredging and boat ramp sub-tabs cannot be selected because they were not selected for the analysis.
The results for each of the features selected in Step 1 are 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). Notice that when a sub-tab is selected that was not included by the user a message is displayed saying the feature was not included in the analysis.


[[Image:ViewResultsTab.jpg|400px|thumb|left|Fig. 4 – View Results Tab]]  
[[Image:ViewResults_Tonnage.jpg|400px|thumb|left|Fig. 5 Tonnage output for 2006 under the View Results Tab]]  
<br style="clear:both" />
<br style=clear:both />


There is also a details column for each of the feature sub-tabs. By clicking in the details column and the row corresponding with a desired location the user can see a further breakdown of the selected feature at that particular location. For example by clicking the details column and row corresponding to SAW – Wilmington the screen shown in Figure 5 is displayed.  
After looking at the results for a particular feature the user may want a more detailed look at 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 sub-tab the data shown in Figure 6 is displayed.  


[[Image:Details.jpg|400px|thumb|left|Fig. 5 Details]]  
[[Image:Tonnage_Details.jpg|400px|thumb|left|Fig. 6 2006 Tonnage details for the San Pedro Breakwater]]  
<br style="clear:both" />
<br style=clear:both />


A global ranking of the chosen locations according to all the selected features may also be executed. By selecting the Global Ranking sub-tab the user may set a weight for each metric. The weight is a tool for the user to specify how much he/she wants each metric to be counted toward the global ranking of the locations (see Figure 6).
In addition to ranking structures according to each feature individually a global ranking of structures 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:GlobalRanking.jpg|400px|thumb|left|Fig. 6 Global Ranking]]  
[[Image:Weightings.jpg|400px|thumb|left|Fig. 7 Weighting of each feature for global ranking of structures]]  
<br style="clear:both" />
<br style=clear:both />


==''  Step 5: Google Earth  ''==
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.


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.
[[Image:GlobalRankingsTable.jpg|400px|thumb|left|Fig. 8 – Global Rankings Table]]
<br style=clear:both />


[[Image:GoogleEarthOutput.jpg|400px|thumb|left|Fig. 7 – Google Earth Output]]
The global rankings generated by CSMART are an initial screening of structures, not an in depth analysis of the structures that are most deserving of OM funding. The goal of CSMART is to assist OM decision makers in focusing their efforts on structures ranked by several general measures of significance.
<br style="clear:both" />

Latest revision as of 19:30, 1 November 2013

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

CSMART and CSMART Silverlight Edition

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 OM budget development. CSMART may be accessed at https://cpt.usace.army.mil/Structures with CAC authentication, additionally the developmental version of CSMART Silverlight Edition may be accessed at https://itlgis01.usace.army.mil/csmart/.


CSMART accesses 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.


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 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 nationwide 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 of the Corps coastal structures 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 are 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). Notice that when a sub-tab is selected that was not included by the user a message is displayed saying the feature was not included in the 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 a more detailed look at 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 sub-tab the data shown in Figure 6 is displayed.

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


In addition to ranking structures according to each feature individually a global ranking of structures 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


The global rankings generated by CSMART are an initial screening of structures, not an in depth analysis of the structures that are most deserving of OM funding. The goal of CSMART is to assist OM decision makers in focusing their efforts on structures ranked by several general measures of significance.