CSMART
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 a decision-support software package 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.
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: 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.
Step 1: Features
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 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). 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.
Step 2: Locations
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.
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
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.
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.
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).
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.
