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 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: 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 features to include in the analysis. The features include: commercial tonnage, commercial fishing, coast guard incidents, dredging, cruise data, ferry data, boat ramps, binary choices, and structure condition ratings. 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.
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.
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.
