SBAS/UsersGuide: Difference between revisions

From CIRPwiki
Jump to navigation Jump to search
 
(55 intermediate revisions by 3 users not shown)
Line 25: Line 25:


==SBAS Desktop==
==SBAS Desktop==
:SBAS Desktop is a legacy version of SBAS designed to run as a stand-alone program  
:SBAS Desktop is a legacy version of SBAS designed to run as a stand-alone program.
:For information on all past (and present) versions of SBAS, see the [[SBAS]] main wiki page.
:For information on all past (and present) versions of SBAS, see the [[SBAS]] main wiki page.


=Using SBAS ArcGIS Pro=
=Using SBAS ArcGIS Pro=
==Installation & Launching SBAS==
==Installation & Launching SBAS==
[[File:SBAS2020Toolbox.png|thumb|right|SBAS 2020 Toolbox after installation and expanded in the Catalog pane to show all the individual steps]]
[[File:SBAS2020Toolbox.png|thumb|right|Figure 1. SBAS 2020 Toolbox after installation and expanded in the Catalog pane to show all the individual steps.]]
SBAS for ArcGIS Pro is designed as an ArcToolbox written in Python, and installation is as simple as unzipping the distribution file to a local drive. The zip file includes the toolbar (SBAS_2020.pyt), layer packages (*.lyrx), a settings file (SBAS_settings.txt), and a template geodatabase (SBAS.gdb). The settings file is used by the SBAS tools to easily find the local SBAS database, and must stay in the same directory as the .pyt file. To launch SBAS create a new project in ArcGIS Pro and use 'Add a Folder Connection' to add 'SBAS_2020.pyt' to your project in the Catalog pane. Within the toolbox is the individual tools that you will use to create a sediment budget (Figure 1).
The SBAS for ArcGIS Pro is designed as an ArcToolbox written in Python 3, and installation requires unzipping the distribution file to a local drive. The zip file can be downloaded from here: https://www.arcgis.com/home/item.html?id=90576370d48f491fbddc7a15bbfb40d7. The zip file includes the toolbox (SBAS_2020.pyt), layer packages (_.lyrx), a settings file (SBAS_settings.txt), and a template geodatabase (SBAS.gdb). The settings file is used by the SBAS tools to easily find the local SBAS database and must stay in the same directory as the toolbox file. To launch SBAS, create a new project in ArcGIS Pro and use “Add a Folder Connection” to add SBAS_2020.pyt to your project in the catalog pane. Within the toolbox are the individual tools used to create a sediment
budget (Figure 1; Table 1).
 
{| class = "wikitable"
|+ Description of SBAS Tools
|-
! Topic
! style=max-width:8em | Tool Description
|-
| 00 – Set Local Database
| Designates location for SBAS data to be stored
|-
| 01a – Create SBAS Alternative
| Creates a sediment budget
|-
| 01b – Load SBAS Alternative
| Loads an existing sediment budget
|-
| 01C – Copy SBAS Alternative
| Copies an existing sediment budget
|-
| 02a – Plot GenCade Points
| Plots shoreline points from GenCade data
|-
| 02b – Convert GenCade Points to Budget Features
| Converts GenCade data into budget cells and fluxes
|-
| 03a – Import GIS Features to SBAS Alternative
| Imports GIS features into the sediment budget
|-
| 03b – Transfer Values to SBAS Cell Attributes
| Transfers sediment budget values from a different file into the budget alternative
|-
| 03c – Create Relationship to SBAS Features
| Joins data based on spatial relationship
|-
| 03d – Show Related SBAS Attributes
| Create a layer file to hold a relationship between SBAS features and additional attribute data
|-
| 04a – Load Complementary Data
| Loads complementary data
|-
| 04b – Load Published Sediment Budgets
| Loads a sediment budget that is published on USACE AGOL
|-
| 05a – Start Editing (Add Features)
| Starts editing session to create features
|-
| 05b – Stop Editing (Add Features)
| Stops editing session
|-
| 06 – Recompute Residual
| Recalculates residual volume, transport removal, and transport placement
|-
| 07 – Delete Alternative
| Deletes Sediment Budget
|-
| 08 – Share Sediment Budget Online
| Publishes sediment budget to ArcGIS Online
|}


==Creating a Sediment Budget==
==Creating a Sediment Budget==
===Set Local Database (Tool 00)===
===Set Local Database===
''Tool 00 - Set Local Database'' is used to designate a known locality for your local SBAS database and provides the flexibility to have one or more local SBAS databases. Behind the scenes this tools is simply writing a string value into SBAS_settings.txt. Each time SBAS needs to locate the SBAS database in the data processing, it will put the value listed in this file.
Tool ''00 - Set Local Database'' is used to designate a known file locality for the user’s local SBAS database and provides the flexibility to have one or more local SBAS databases. Behind the scenes, this tool is simply writing a string value into the file “SBAS_settings.txt”. Each time SBAS needs to locate the SBAS database in the data processing, it will put the value listed in this file.
[[File:00SetLocalDatabase.png|thumb|right|Tool 00 preview.]]


===Create SBAS Alternative (Tool 01a)===
===Create SBAS Alternative===
Sediment budget data is grouped into alternatives, which are representations of one set of assumed conditions for a sediment budget. Creating a new alternative is the first step in building the geometry container to hold littoral cells and fluxes features. Each alternative has its own set of littoral cells(with delta volume, placement/input volume, and removal/output volume) and fluxes. Alternatives may be created to reflect different assumptions about sediment-transport paths/rates and engineering activities, or they may reflect different time periods. Alternatives hold all values applied to littoral cells and fluxes, and the data is written to the 'Alternative table' in the local geodatabase.
Sediment budget data are grouped into alternatives, which are representations of one set of assumed conditions for a sediment budget. Creating a new alternative is the first step in building the geometry container to hold littoral cell and flux features. The user has an option to create a micro (<200-meter cell lengths) or macro (>200-meter cell lengths) budget type (Figure 2). Each alternative has its own set of littoral cells (with delta volume, placement/input volume, and removal/output volume) and fluxes. Alternatives may be created to reflect different assumptions about sediment-transport paths/rates and engineering activities, or they may reflect different time periods. Alternatives hold all values applied to littoral cells and fluxes, and the data are written to the alternative table in the local geodatabase.


''Tool 01a - Create SBAS Alternative'' is used to create a new alternative for a sediment budget (Figure). Basic information is collected to assist in building metadata for the alternative. The following pieces are data are required:
[[File:Macro V Micro Image.png|thumb|Figure 2. Micro vs. macro sediment budget comparison.]]
 
Tool ''01a - Create SBAS Alternative'' is used to create a new alternative for a sediment budget. Basic information is collected to assist in building metadata for the alternative. The following pieces of data are required:
:a. Budget Type (Micro or Macro)
:a. Budget Type (Micro or Macro)
:b. Alternative Name
:b. Alternative Name
Line 48: Line 108:
:e. Data From (Epoch)
:e. Data From (Epoch)
:f. Date To (Epoch)
:f. Date To (Epoch)
:g. Flux Q Units (Cubic Year/Year or Cubic Meters/Year)
:g. Flux Q Units (cubic year/year or cubic meters/year)
:h. Cell Volume Units (Cubic Yards or Cubic Meters)
:h. Cell Volume Units (cubic Yards or cubic Meters)
[[File:01aCreateSBASAlternative.png|thumb|right|Tool 01a: Creating the SBASAlternative]]
 
There is a checkbox to load new alternative immediately, which if ticked will add three new layers to the table of contents.  Each layer will named "Fluxes for Alternative Name" or "Cells for Alternative Name." As different alternatives are created, each are assigned a unique ID.  This value is stored in the scenarioIDPK attribute field.  When added to the Table of Contents, the SBAS tool pulls the supplied layer files (Cells.lyrx, AllCells.lyrx, and Flux.lyrx) and applies a definition query to the items that filters only on the assigned unique ID for the active alternative.
[[File:SBASLayersInTOC.png|thumb|right|Upon successful creation of a new alternative, the ArcPro Table of Contents will populate with three layers.]]
 
===Load SBAS Alternative (Tool 01b, Optional)===
This is an optional step to load any alternative and its respective feature layers into the Table of Contents. All available alternatives are listed in the drop down menu that are stored in your local SBAS database, and multiple alternatives can be loaded at the same time.
 
===Create SBAS Feature Geometry (Littoral Cells)===
In SBAS there are three ways to create littoral cell geometry; sketching cells by hand, importing cells from GenCade outputs, and importing cells from existing GIS layers.
 
====Sketching New Cells====
Creating new feature geometry in SBAS follows much of the same process inherent in GIS, however in SBAS we first have to start an 'SBAS Edit Session' so geometry is related to the correct alternative.
:1. To begin launch ''Tool 05a - Start Editing (Add Features)''
:2. A list of all alternative in the Table of Contents will be in the drop-down list.  Choose the desired alternative and click Run.
:3. In the background, SBAS sets the default values for the scenarioIDFK equal to that of the selected alternative.  Remember, this is the value that is used in all of the definition queries.
:4. Zoom to your area of interest and click on ArcGIS Pro's ''Edit'' ribbon and click on ''Create''.
:5. In the ''Create Features'' panel, click on the symbol in front of Cells for Alternative Name layer. This will expand to show you the sketch options. Click on the first icon, which will turn on your sketch tool. Click in the map to drop vertices for your littoral cell polygon. Double-click to complete sketch.
:6. When done sketching all of the new littoral cell features, launch ''Tool 05b - Stop Editing (Add Features)'' to commit your changes.
:7. To modify location of vertices, click on the Modify button from ArcGIS Pro's Edit ribbon, then click on Reshape, then Edit Vertices.  Click on the vertices to move to new location or right click to remove.  Save changes when complete.


====Importing Cells from GenCade Data====
There is a checkbox to load a new alternative immediately, which if selected will add three new layers to the Table of Contents. One layer will be named “Fluxes for Alternative Name,and the other two will be named “Cells for Alternative Name.” One of the cell layers displays the cell boundaries while the other displays the residual volume change for the cell (Figure 3). As different alternatives are created, each is assigned a unique identifier (ID). This value is stored in the “scenarioIDPK” attribute field. When added to the Table of Contents, the SBAS tool pulls the supplied layer files (Cells.lyrx, AllCells.lyrx, and Flux.lyrx) and applies a definition query to the items that filters only on the assigned unique ID for the active alternative.
When importing GenCade data, geometry for both Cells and Fluxes is created.  ''Tool 02a  - Plot GenCade Points'' and ''Tool 02b - Convert GenCade Points to Budget Features'' are used for this data transformation. For the data transformation, the associated .gen, .slo, and .map for the GenCade budget are required.
:1. First run ''Tool 02a  - Plot GenCade Points''. This will plot the shoreline point locations documented in the .slo file.  The output shapefile is needed for the input into 02b.
:The following values are extracted from the .gen file:
::*X0 and Y0 values = the starting coordinate
::*Azimuth
::*Dx = distance between points
:The collection of distances from the starting location is collected for each date is extracted from the .slo file
::*Note: If "Use Only First Date in Point Plot" is selected in the tool, only the first row of the .slo is used for the plot.
:2. Next open ''Tool 02b - Convert GenCade Points to Budget Features''. You will need to supply the three GenCade files, the newly created GenCade shoreline points, set temporary placeholder feature classes for the Cells and Fluxes, set design distant variables, and choose the alternative that will be the home for these features.
::'''Distance variables'''
:::*The design width of the littoral cells and the length of the flux lines.
:::*Distance (ft) Stretch Width of Littoral Cell - when this conversion tool is constructing the cells, the script builds a buffer around the shoreline position plot.  The width of the buffer correlates to the width of the littoral cell. The value listed for this parameter is used as the buffer width.
:::*Distance (ft) Offset for Flux Arrows - when this conversion tool is constructing the fluxes, the script builds two flux arrows. The distance defined here defines how far apart the flux lines will be offset.
::'''Coordinate system'''
:::*Will be re-projected automatically to match that of the selected alternative.
:::*The origin coordinate system is pulled from the GenCade .map file between the COV_WKT PROJCS and END_COV_WKT tags.
:::*Sample Coordinate System Text:
COV_WKT PROJCS["NAD83_Delaware",GEOGCS["GCS_North_American_1983",DATUM["D_NORTH_AMERICAN_1983",SPHEROID["GRS_1980",6378137,298.257222101]],
PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["scale_factor",0.999995],
PARAMETER["central_meridian",-75.41666666666667],PARAMETER["latitude_of_origin",38],PARAMETER["false_easting",200000],
PARAMETER["false_northing",0],UNIT["Meter",1]]END_COV_WKT
::'''Cell and flux boundaries'''
:::Both pulled from the SBAS section of the .gen file.
:::*Cell boundaries are captured by the sequence of start/end definitions.
::::*V1 = start location of cell
::::*V2 = end location of cell
:::*Flux connections are captured by the sequence of start/end definitions.
::::*Q1 = start of flux
::::*Q2 = end of flux


====Importing Cells from Existing GIS Layers====
[[File:TableofContentsForAlternative2.jpg|thumb|center|Figure 3. Table of contents view containing components of the alternative.]]
If you have GIS layers already created that represent littoral cells, but were created outside of this SBAS toolbox, these features can be imported into SBAS.
:*If your existing features are to be a part of a new alternative, use ''Tool 01a - Create New Alternative'' to set up your alternative placeholder. Otherwise move to the next step.  
:*Using ''Tool 03a - Import GIS Features to SBAS Alternative'', browse to an existing feature class or shapefile, then provide field mapping to connect your original field names to the SBAS values.
::*Field mapping for Littoral Cells include: Name, Description, Placement Volume, Removal Volume, and Volume Change
::*Checking for Duplicate Geometries: This tool will check for duplicate geometries, or polygons and polylines footprints that already exist in the local SBAS database.  If this is what you would like to do (e.g., you use the same cells for multiple alternatives), check the Duplicate Geometries OK checkbox.


===Create SBAS Feature Geometry (Fluxes)===
===Load SBAS Alternative===  
The methods to create the flux geometry is similar to how to create the littoral cell geometry, but with minor modifications.
''Tool 01b – Load SBAS Alternative'' is an optional step to load any alternative and its respective feature layers into the Table of Contents. All available alternatives are listed in the drop-down menu that are stored in your local SBAS database, and multiple alternatives can be loaded at the same time.
====Sketching Flux Lines====
Sketching flux lines by hand can be done using either straight or curved geometry. Creating new feature geometry in SBAS, follows much of the same process inherent in GIS, however in SBAS we first have to start an 'SBAS Edit Session' so geometry is related to the correct alternative.
:1. To begin launch ''Tool 05a - Start Editing (Add Features)''
:2. A list of all alternative in the Table of Contents will be listed in the drop-down.  Choose the desired alternative and click Run.
:3. In the background, SBAS sets the default values for the scenarioIDFK equal to that of the selected alternative. Remember, this is the value used in all of the definition queries.
:4. Zoom to your area of interest and click on ArcGIS Pro's ''Edit'' ribbon and click on ''Create''.
:5. In the Create Features panel, click on the symbol in front of Fluxes for Alternative Name layer. This will expand to show you the sketch options. Click on the first icon. This is turn on your sketch tool. Click in the map to drop vertices for your littoral cell polygon.  Double-click to complete sketch.
:6. When done sketching all of the new littoral cell features, launch ''Tool 05b - Stop Editing (Add Features)'' to commit your changes.
:7. To modify location of vertices, click on the ''Modify'' button from ArcGIS Pro's Edit ribbon.  Click on ''Reshape'', then ''Edit Vertices''. Click on the vertices to move to new location or right click to remove. Save changes when complete.


====Importing Fluxes from GenCade Data====
===Copy, Change, and Delete Alternatives===
Cells and Fluxes are imported at the same time with GenCade data import.  Refer to this instructions in the ''Littoral Cells'' section above.
''Tool 01c – Copy SBAS Alternative'' is used to copy any existing alternative into a new alternative. This tool allows the user to reuse feature geometry for a new alternative. The user also has the ability to change specific alternative details such as “Name,” “Description,” “Start,” and “End Date.


====Importing Fluxes from Existing GIS Layers====
:1. In the Catalog pane, browse and expand the “SBAS.gdb”.
If you have GIS layers already created that represent fluxes, but were created outside of this SBAS toolbox, these features can be imported into SBAS.
:2. Right-click on the alternative table and select “Add to Current Map.
:*If your existing features are to be a part of a new alternative, use ''Tool 01a - Create New Alternative'' to set up your alternative placeholder.
:3. In the Table of Contents pane, right-click on the alternative table and select “Open.
:*Using ''Tool 03a - Import GIS Features to SBAS Alternative'', browse to an existing feature class or shapefile, then provide field mapping to connect your original field names to the SBAS values.
:4. In the attribute window, click the row/column value to modify and enter any changes.
::*Field mapping for fluxes include: Name, Description, and Q Value
:5. Enter any changes, and when finished click the “Save” button on the Edit ribbon.
::*Duplicate Geometries: This tool will check for duplicate geometries, or polygons and polylines footprints that already exist in the local SBAS database.  If this is what you would like to do (e.g., you use the same fluxes for multiple alternatives), check the ''Duplicate Geometries OK'' checkbox.


===SBAS Feature Values===
===Sketching SBAS Feature Geometry===
====Manually Add SBAS Feature Values====
Creating new feature geometry in SBAS follows much of the same process inherent in ArcGIS Pro, however in SBAS, the user must first start an “SBAS Edit Session” so geometry is related to the correct alternative.
Sediment budget values linked to cell volumes and fluxes can easily be added to geometry as feature attributes. Use these steps to add or modify values for Cells (Placement, Removal, Delta Volume, Confidence Level) & Flux (Q Values)
:1. To begin launch tool ''05a - Start Editing (Add Features)''
:2. A list of all alternative in the Table of Contents will be in the drop-down list.  Choose the desired alternative and click "Run".
:3. Zoom to your area of interest, click on ArcGIS Pro's Edit ribbon, and click on "Create".
:4. To sketch littoral cells, click on the symbol in front of the "Cells for Alternative Name" layer in the "Create Features" panel. This will expand to show the sketch options. Click on the first icon, which will turn on the sketch tool. Click in the map to drop vertices for your littoral cell polygon. Double-click to complete sketch. For sketching flux cells, select “Fluxes for Alternative Name” layer in the “Create Features” panel and create vertices for a flux line in the direction of flux with the sketch tool. Fluxes may represent a sink for one cell and a source for another, so all fluxes are symbolized the same way and given a positive magnitude and direction.
:5. When done sketching all of the new littoral cell features, launch tool ''05b - Stop Editing (Add Features)'' to commit changes.
:6. To modify location of vertices, click on the "Modify" button from ArcGIS Pro's Edit ribbon, then click on "Reshape", then "Edit Vertices." Click on the vertices to move to new location or right click to remove. Save changes when complete.


:*From the Edit ribbon, click the Attributes button. This will open the Attribute pane.  
===Importing SBAS Feature Geometry from GenCade Data===
:*Select a budget feature (cell or flux) on the map with the Selection Tool. The Attribute pane will display the values for the selected feature.
GenCade is a one-dimensional numerical model that calculates the shoreline change based on longshore sediment transport rates. After creating and calibrating a GenCade grid, the user can create sediment budget cells and fluxes and run the model. In the GenCade results file (_.prt) under “SBAS OUTPUT,” the results for volume change and rate for the fluxes and cells will be used with SBAS. A GenCade special report (Munger and Frey 2015) provides more information for new users on how to use GenCade, and a technical note (Frey 2015) is available for more detail on incorporating GenCade and SBAS data.
:*Click on the value next to the attribute to edit.  Enter in the new value.


::'''Attribute Values available to Edit:'''
When importing GenCade data, geometry for both “Cells” and “Fluxes” is created. ''Tools 02a - Plot GenCade Points'' and ''02b - Convert GenCade Points to Budget Features'' are used for this data transformation. For the data transformation to a sediment budget, the associated GenCade files, _.gen (GenCade control file), _.slo (shoreline position file), _.prt (sediment fluxes file), and _.map(GenCade coverage file) are required. These steps below need to be run only once as the tool will import the littoral cells and fluxes at the same time.
::''Littoral Cells, user-defined values:''
:::-sdsFeatureName (text, 50 characters). Name or label of the littoral cell. 
:::-sdsFeatureDescription (text, 255 characters). Description of the littoral cell.
:::-removalVolume (double). Volume of sediment removal (per littoral cell and alternative).
:::-placementVolume (double). Volume of sediment placement (per littoral cell and alternative).
:::-deltaVolume (double). Change in volume per littoral cell and alternative.
:::-valConfidence (text, 255 characters).  Determine level of data confidence, assigned by sediment budget author. Low, Medium, High
:::-projectID (text, 50 characters). Optional project id for internal management purpose.The SBAS application does not reference or write to this field.


::''Littoral Cells, dynamic fields:''
:1. First run tool ''02a - Plot GenCade Points''. This will plot the shoreline point locations documented in the _.slo file. The output shapefile is needed for the input into tool ''02b - Convert GenCade Points to Budget Features''. The starting coordinate, azimuth, and distance between points is collected from the _.slo file. If "Use Only First Date in Point Plot" is selected in the tool, only the first row of the _.slo is used for the plot.
::For littoral cells, the residual, transportRemoval, and transportPlacement attribute values will automatically re-calculate each time the 06 - Recompute Residual tool is executed.  Values for these fields DO NOT NEED to be manually updated.
:2. Next open tool ''02b - Convert GenCade Points to Budget Features''. The three GenCade files and the newly created GenCade shoreline points will need to be supplied. Set the temporary placeholder feature classes for the “Cells” and “Fluxes”, set the design distant variables, and choose the alternative that will be the home for these features.
:::-residualVolume: Computed Residual volume per littoral cell and alternative. 
::::Residual is computed by Sum of Transport Placement - Sum of Transport Removal - delta volume + Placement volume - Removal volume.
::::SBAS tools will compute the residual volume based on values assigned to SBAS features.
::::SBAS determines the direction of sediment fluxes and automatically identifies each as either a "source" or "sink" for each cell.
:::-transportRemoval: Sum of transport removal per cell.
::::SBAS finds all sediment fluxes where the starting point of the line intersects the littoral cell.  These fluxes are classified as "sink" volumes.
::::All sink volumes are summed and values reported to this field.
:::-transportPlacement: Sum of transport placement per cell.
::::SBAS finds all sediment fluxes where the end point of the line (arrow head) intersects the littoral cell.  These fluxes are classified as "sources" volumes.
::::All source volumes are summed and values reported to this field.


::''Fluxes, user-defined values:''
===Importing SBAS Feature Geometry from Existing Geographic Information System (GIS) Layers===
:::-sdsFeatureName (text, 50 characters). Name or label of the flux.
If geographic information system (GIS) layers are already created that represent littoral cells or fluxes, but were created outside of the SBAS toolbox, these features can be imported into SBAS. The steps for importing SBAS Feature Geometry from existing layers are below.
:::sdsFeatureDescription (text, 255 characters). Description of the flux.
:1. Using tool ''03a - Import GIS Features to SBAS Alternative'', browse to an existing feature class or shapefile, then provide field mapping to connect the original field names to the SBAS values.
:::-qValue (double). Volume of sediment moving in or out of cell.
:2. If importing littoral cells, the required fields for mapping include the following: Name, Description, Placement Volume, Removal Volume, and Volume Change. If importing flux cells, the required fields for mapping include: “Name,” “Description,” and “Q Value.
:3. Check the “Duplicate Geometries OK” checkbox to use the same cells/fluxes for multiple alternatives.


:*To finish:
===Manually Add SBAS Feature Values===
::-Save Attribute Changes
Sediment budget values linked to cell volumes and fluxes can easily be added to geometry as feature attributes. Tables A2 and A3 contain the values available to edit for the littoral cells and fluxes. Within the littoral cell there are three dynamic fields: “residualVolume,” “transportRemoval,” and “transportPlacement.” The values within these fields do not need to be manually updated, as they can be automatically recalculated using tool ''06 – Recompute Residual''.
::-From the Edit ribbon, click the save button
To manually add feature values:
:1. From the Edit ribbon, click the “Attributes” button to open the Attribute pane.
:2. Selected a budget feature (cell or flux) on the map with the Selection Tool. The attribute pane will display the values for the selected feature.
:3. Click on the value next to the attribute to edit. Enter in the new value.
:4. When finished, click the “Save” button on the Edit ribbon.


====Transfer Values into SBAS Cell Attributes====
===Transfer Values into SBAS Cell Attributes===
If sediment budget geometries and values exists outside of your local SBAS database in a feature class with identical geometry, the attributes can be transferred into your selected Alternative using ''tool 03b - Transfer Values to SBAS Cell Attributes''. To use this tool to update feature values. The geometries in both datasets must match.
If sediment budget geometries and values exist outside of your local SBAS database in a feature class with identical geometry, the attributes can be transferred into the selected Alternative using tool ''03b Transfer Values to SBAS Cell Attributes''. To use this tool, the geometries in both datasets must match. All values from the input feature class will be used to update the littoral cell layer, and a record of all transferred values will be listed in the Results Window. Tool ''06 – Recompute Residual'' does not need to be run as the residual is automatically recalculated.
:*Verify that the geometries in the SBAS dataset and outside dataset match.
:*Open ''tool 03b - Transfer Values to SBAS Cell Attributes'', select your desired input parameters and click ''Run''.
:*All values from your Input Feature Class will be used to update your littoral cell layer.
:*A record of all transferred values will be listed in the Results Window.
:*The residual is automatically recalculated.


====Create Relationship to SBAS Features====
===Create Relationship to SBAS Features===
Additional attribute data may be stored outside of the SBAS local database in feature classes . Contents from supplemental databases can be related to SBAS features using the ''03c - Create Relationship to SBAS Features tool''. This tool uses spatial and non-spatial relationships to determine how to connect the data attribute to the sediment budget. If you created geometry and values outside of this SBAS toolbox, but would like to use these in your budget, this tool will create a spatial relationship and add the correct SBAS foreign keys to easily join the datasets together.
Additional attribute data may be stored outside of the SBAS local database in feature classes. Contents from supplemental databases can be related to SBAS features using tool ''03c Create Relationship to SBAS Features''. This tool uses spatial and nonspatial relationships to determine how to connect the data attributes to the sediment budget. If there are feature geometry and values created outside of the SBAS toolbox, this tool will create a spatial relationship to join the datasets together. This tool should be used when a table join cannot easily be performed, such as when there is no consistent field between the tables that can be referenced for the join. This tool does not support Grouped Layers.
*About ''Tool 03c - Create Relationship to SBAS Features tool''
:-Do you have data that uses the same geometry, does NOT have a SBAS key attribute, but has values you would like integrated in your budget? This tool should be used if there is not an ID field in the comparison layer and the geometry of the compares, and therefore a simple table join can not easily be performed.
:-A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table.
:-The PRIMARY KEY for each littoral cell is ''littoralcellIDPK''
:-The PRIMARY KEY for each flux is ''sedimentTransportDirectionIDPK''
:-This tool adds a new FOREIGN KEY field to the comparison dataset: ''littoralCellIDFK'' or ''sedimentTransportDirectionIDFK''
:-This tool does NOT support Grouped layers. If this tool opens with a "No Parameters" message, or intended data layers are not listed in the drop down menus.
*Steps
:*Open ''tool 03c - Create Relationship to SBAS Features tool''.
:*''Select SBAS Layer'' : choose the layer in SBAS to which values will be related
:*''Choose Comparison Input Layer'' : select the layer outside of the SBAS database to be related
:*Click ''run''


===Load Complementary Data & Published Sediment Budgets===
===Load Complementary Data & Published Sediment Budgets===
SBAS 2020 is configured to work with available content on AGOL. ''Tools 04a - Load Complementary Data'' and ''04b - Load Published Sediment Budgets'' allow you to quickly connect to online content that have been appropriately tagged in AGOL item descriptions or data published through the SBAS 2020 toolbox (see tool 08 - Share Sediment Budget Online)
SBAS is configured to work with sediment budgets and complementary data that have been published online (Dunkin et al. 2020). Use tool ''04a Load Complementary Data'' to connect to online content (map services or feature services) that have been appropriately tagged in ArcGIS Online (AGOL) item descriptions or published through the SBAS 2020 toolbox (see tool ''08 Share Sediment Budget Online'').
 
'''Tool 04a - Load Complementary Data''' To view or load data that may support your sediment budget, use this tool.
:*Open the tool and view data sources listed under ''Select RSM Data Source'', a list of datasets configured in AGOL to assist with finding data
:*Choose the desired dataset and click ''Run''
:*Expand the tool results window. A short summary and link to discover more details is provided.
 
'''Tool 04b - Load Published Sediment Budgets'''
:*Ensure you are logged in to an account with access to the USACE AGOL.
:*Open the tool and open the drop-down under ''Select Published Sediment Budget''
:*Choose the budget you'd like to load and click ''Run''
 
===Modifying Alternatives===
====Opening an Existing Alternative====
:'''Tool 01b Load Alternative''' Opening an Alternative is the function as Loading Alternatives.  Use tool 01b Load Alternatives to complete this function.  Loading an alternative will automatically load in the applicable data layers available to the Table of Contents.
:*If an alternative was created using ''Tool 01a'', ''Tool 01b - Load SBAS Alternative'' is used to simply load the respective feature layers (and definition query filters) into Table of Contents.  Multiple alternative can be loaded at the same time.
:*All available alternatives are listed in the drop down menu are that are stored in your local SBAS database.
:*As different alternatives are created, each are assigned a unique ID.  This value is stored in the scenarioIDPK attribute field.  When added to the Table of Contents, the SBAS tool pulls the supplied layer files (Cells.lyrx, AllCells.lyrx, and Flux.lyrx) and applies a definition query to the items that filters only on the assigned unique ID for the active alternative.
 
====Copying Alternatives====
:'''Tool 01c - Copy Alternative''' is used to copy and existing Alternative into a new Alternative. Use this tool if you would like to reuse the feature geometry for a selected Alternative.  All features will be copied and labeled with the new Alternative ID (scenarioIDFK) value.
 
====Changing Alternative Property Values====
If you need to change any of the Alternative details like ''Name'', ''Description'', ''Start'' and ''End Date'' you can directly modify the Alternative table.
:*In the ''Catalog'' pane, browse and expand the SBAS.gdb.
:*Right-click on the Alternative table and select ''Add to Current Map''.
:*In the ''Table of Contents'' pane, right-click on the Alternative table and select ''Open''.
:*In the Attribute window, click the row/column value to modify.
:*Enter any changes. When complete, from the Edit ribbon click the ''Save'' button. Note: If the ''Save'' button is disabled, hit the enter key (with the attribute table) to complete the change
:*If you have renamed your Alternative, to see these changes reflected in toolbox right-click on the toolbox name and click Refresh.
 
====Deleting Alternatives====
:'''Tool 07 - Delete Alternative''' If you need to delete an alternative, use this tool to remove the alternative from your personal database. This tool does NOT automatically remove any published datasets.  If you have published a sediment budget to AGOL, and you would like to remove it, log-in to https://usace.maps.arcgis.com/home/index.html and delete the feature service from My Contents.
 
==Local and Enterprise Data Storage==
===Local Database Location===
SBAS uses the template database (SBAS.gdb) to store all sediment budge geometries and alternative values.  This local geodatabase contains 5 objects.  The database schema follows the schema identified by SDSFIE.
 
:'''Alternative''' is a table that holds basic metadata information related to individual sediment budgets.
:*''scenarioIDPK'' (text, 50 characters).  Primary Key. This value is auto-generated by SBAS and provides a unique identifier for each alternative (or scenario).
:*''sdsID'' (guid). This value is auto-generated by SBAS and provides a unique identifier for each alternative (or scenario).  Value can be used to link to items in other enterprise GIS.
:*''scenarioAuthor'' (text, 100 characters). Author of the alternative.  Name of author is pre-determined by the user login to ArcGIS Pro.  Name is listed as the AGOL username.
:*''sdsFeatureName'' (text, 50 characters). Name or label of alternative.
:*''sdsFeatureDescription'' (text, 255 characters). Description of alternative.
:*''geoAreaDescription'' (text, 255 characters). Description of location of sediment budget
:*''projectID'' (text, 50 characters). Optional project id for internal management purposes. The SBAS application does not reference or write to this field.
:*''dateScenarioCreated'' (date). Date alternative created in the SBAS database.
:*''budgetType'' (text, 50 characters). Type of sediment budget (Micro - local or Macro - regional).
:*''dateIntervalStart'' (date). Start date of alternative epoch.
:*''dateIntervalEnd'' (date). End date of alternative epoch.
:*''cellUnits'' (text, 255 characters). Units of volume for littoral cells (Cubic Yards or Cubic Meters)
:*''qUnits'' (text, 255 characters). Units of volume for sediment transport rate (Cubic Yards/Year or Cubic Meters/Year)
:*''uncertaintyMethods'' (text, 50 characters). List of uncertainty methods used in Sediment Budget. The SBAS application does not reference or write to this field.
:*''medialDPK'' (text, 50 characters). ID to hold links to related media documentation. The SBAS application does not reference or write to this field.
:*''sdsMetadataID'' (text, 50 characters). ID to hold unique metadata ID.
 
:'''Sediment Management Cells''' (polygon) Boundaries of each littoral cell.
 
:*''littoralCellIDPK'' (text, 50 characters). Primary Key. This value is auto-generated by SBAS and provides a unique identifier for each littoral cell.
:*''sdsFeatureName'' (text, 50 characters). Name or label of the littoral cell. 
:*''sdsFeatureDescription'' (text, 255 characters). Description of the littoral cell. 
:*''scenarioIDFK'' (text, 50 characters).  Foreign Key. Value to the related alternative (or scenario).
:*''removalVolume'' (double). Volume of sediment removal (per littoral cell and alternative).
:*''placementVolume'' (double). Volume of sediment placement (per littoral cell and alternative).
:*''deltaVolume'' (double). Change in volume per littoral cell and alternative.
:*''valConfidence'' (text, 255 characters).  Determine level of data confidence, assigned by sediment budget author.  Low, Medium, High
:*''residualVolume'' (double). Computed Residual volume per littoral cell and alternative. 
::*Residual is computed by Sum of Transport Placement - Sum of Transport Removal - delta volume + Placement volume - Removal volume.
::*SBAS tools will compute the residual volume based on values assigned to SBAS features.
::*SBAS determines the direction of sediment fluxes and automatically identifies each as either a "source" or "sink" for each cell.
:*''transportRemoval'' (double). Sum of transport removal per cell.
::*SBAS finds all sediment fluxes where the starting point of the line intersects the littoral cell.  These fluxes are classified as "sink" volumes.
::*All sink volumes are summed and values reported to this field.
:*''transportPlacement'' (double).Sum of transport placement per cell.
::*SBAS finds all sediment fluxes where the end point of the line (arrow head) intersects the littoral cell.  These fluxes are classified as "sources" volumes.
::*All source volumes are summed and values reported to this field.
:*''volumeUom'' (text, 50 characters). Units of measure for Volume Change, Removal, Placement and Residual volumes.  Cubic Yards or Cubic Meters.
:*''transportUom'' (text, 50 characters). Units of measure for Sediment Transport Rates.  Cubic Yards/Year or Cubic Meters/Year.
:*''alternativeLabel'' (text, 255 characters). Name of Alternative
:*''mediaIDPK'' (text, 50 characters). ID to hold links to related media documentation.The SBAS application does not reference or write to this field.
:*''sdsMetadataID'' (text, 50 characters). ID to hold unique metadata ID.
:*''projectID'' (text, 50 characters). Optional project id for internal management purpose.The SBAS application does not reference or write to this field.
:*''sdsID'' (guid). This value is auto-generated by SBAS and provides a unique identifier for each alternative (or scenario).  Value can be used to link to items in other enterprise GIS.
 
:'''SedimentTransportDirection''' (polyline) Linear representation of sediment transport.
 
:*''sedimentTransportDirectionIDPK'' (text, 50 characters). Primary Key. This value is auto-generated by SBAS and provides a unique identifier for each flux.
:*''sdsFeatureName'' (text, 50 characters). Name or label of the flux. 
:*''sdsFeatureDescription'' (text, 255 characters). Description of the flux. 
:*''scenarioIDFK'' (text, 50 characters).  Foreign Key. Value to the related alternative (or scenario).
:*''qValue'' (double). Volume of sediment moving in or out of cell.
:*''transportUom'' (text, 50 characters). Units of measure for Sediment Transport Rates.  Cubic Yards/Year or Cubic Meters/Year.
:*''alternativeLabel'' (text, 255 characters). Name of Alternative
 
===Enterprise Database Location===
====ArcGIS Online (AGOL) Accessibility====
All users of SBAS can control the accessibility of their Sediment Budgets published on the Enterprise. You must be signed into to ArcGIS Pro with your user id.
To determine if you are logged into ArcGIS Pro:
:*Look in the upper right corner of the ArcGIS Pro window. If you are signed in you will see your account name, otherwise it will list "Not signed in". 
:*Click the drop-down menu, and follow the Sign-In link to log into your account (Figure 2). 
:*When running SBAS, if you drop a connection and are signed out you will receive an error (Figure 3). If this occurs, just sign in again and relaunch the tool.
 
[[File:Step08-ShareSedimentBudgetOnline.png|thumb|right|Figure 4: SBAS 2020 Step 08]]
 
====Publishing your completed datasets====
*use '''tool 08 - Share Sediment Budget Online'''. This tool will create a copy of your selected Sediment Budget Alternative and create a ''feature web service'' hosted on USACE's AGOL (Figure 4). ''Feature web services'' are a way geographic information is created, modified and exchanged on the Internet.
*Prepare your ArcGIS Pro project. Remove any extraneous datasets from the Table of Contents.  Anything list here will be included in your webservice.  Don't forget to to Save your project.
 
[[File:TOCvisualization.png|thumb|right|Figure 5: Table of Contents view including only one visualization]]
 
*The Table of Contents may have multiple display options for a single dataset, e.g. cell outlines and color-coded cells by residual. Only keep one visualization per dataset for your service (Figure 5). Remove all others from your table of content.
 
*In order to launch this tool you will need an account created for you on https://usace.maps.arcgis.com/home/index.html
:*To obtain an AGOL account, please contact one of the POCs listed at the bottom of this page.
:*In ArcGIS Pro you must be logged in with your USACE AGOL credential to correctly publish SBAS data.
:*If your tool shows "No Parameters" message, this means you have been logged out of AGOL within ArcGIS Pro (Figure 6). To fix, in the upper right corner of ArcGIS Pro, click Sign-In.
 
*This tool will OVERWRITE any web services you own of the same name.
*Set your connection and content parameters.
:*Local Staging Location is the local drive where ArcGIS ArcPro will copy temporary files needed to create your service.
 
*Your SBAS Service will be created for all layers within your current saved version of your ArcGIS Pro project.
:*Your selected Alternative will be used to build a summary and description for your Feature Service.
:*If you have more than 1 alternative loaded in your Table of Contents, all will be combined into a single feature service but as separate layers.
::a. The Feature Service description will be pulled from the alternative selected with tool 08 - Share Sediment Budget Online.
::b. All layers will be listed in your service definition.
::c. Supplemental Budget Data
:::*Do not publish any datasets that contain PII (Personally identifiable information), For Official Use Only (FOUO), other other sensitive information.
:::*Do not publish datasets that are already available online.  E.g., NOAA Shorelines are available as a web service hosted by NOAA and should not be included as part of your service package.
:::*SBAS Budget service should include littoral cells, sediment fluxes, and optional supplemental data such as properties of bluffs.
 
*Feature Web Services are created for each alternative and are documented with the details you provide when the alternative is created.
:*See Create SBAS Alternative section
:*Web Services are initially only shared to the USACE organization.  To share your sediment budgets to Everyone, edit the AGOL item in My Contents on https://usace.maps.arcgis.com/
::*Log-in to https://usace.maps.arcgis.com/
::*Browse to My Contents and locate the budget to share.  Click the checkbox in front of the budget item (Figure 7).
 
[[File:AGOLshareBudget.png|thumb|right|Figure 7: Sharing a budget on AGOL]]
 
::*Click the Share link
::*To share to Everyone (public) click this sharing level (Figure 8).  Group level sharing can also be modified.  All sediment budgets created in SBAS should be shared.
 
=SBAS ArcGIS Desktop=
*[https://rsm.usace.army.mil/pubs/pdfs/SBAS_Arc10_Guide-Jun12.pdf|SBAS ArcGIS 10 User's Guide (PDF)] - PDF user's guide specific to the ArcGIS 10 version
 
==Installation==
#[https://geospatial-usace.opendata.arcgis.com/datasets/8686b2f460a04931a2154f83cafcabde Download SBASArc10 Toolbox Here]
#Extract ZIP distribution
#Move SBAS directory to one's desired location
#Run SBAS\comtypes-0.6.2\install_comtypes.bat
#Run SBAS\install_dependencies.bat
#Within the Catalog, add a Folder Connection to the SBAS directory
#Within the Folder Connection to the SBAS toolbox, expand the toolbox and execute the "00  - Set Up SBAS Environment" tool.
 
==Usage==
*If you would like to specify a workspace path and/or load a basemap, run the "00 - Set Up Environment" tool before running any other tools on your map document.
*For the remainder of the workflow, tools should be executed essentially in order. For example, one must execute "01a - Create SBAS Alternative" before executing "01b - Load SBAS Alternative", which must be run before executing "02a - Convert Graphics to New Features".
 
=Abbreviations and Acronyms Defined=
 
AGOL - ArcGIS Online
 
ESRI - Environmental Systems Research Institute
 
GIS - Geographic Information Systems
 
NOAA - National Oceanographic and Atmospheric Administration


RSM - Regional Sediment Management
===Share Sediment Budget Online===
Users with an AGOL account can request access to the SBAS ArcGIS Hub (https://sbas-usace.hub.arcgis.com) to publish sediment budgets online. Using tool ''08 – Share Sediment Budget Online'', budgets will be published as a feature web service to the SBAS Hub. Extraneous datasets need to be removed from the Table of Contents, as the tool includes all contents in the web service. Content with multiple display options for a single dataset need to be reduced to one visualization per dataset. When publishing a budget, consider the following:
:•Any existing web service with the same name will be overwritten.
:•If more than one alternative is loaded in the Table of Contents, all alternatives will be combined into a single feature service but as separate layers.
:•Do not publish any datasets containing personally identifiable information or other sensitive information.
:•Do not publish datasets that are already available online.


SBAS - Sediment Budget Analysis Systems
=Definitions and Descriptions=


SDSFIE - Spatial Data Standards for Facilities, Infrastructure, and Environment
{| class = "wikitable"
|+ Definitions
|-
! Term
! style=max-width:10em | Definition
|-
| Alternative
| Representation of a sediment budget. Contains fluxes, cells, and associated values.
|-
| Attribute
| Specific information related to a feature layer
|-
| Attribute Table
| Table that stores the attributes related to a feature layer
|-
| Confidence
| The certainty level that the values assigned to littoral cells and fluxes are accurate
|-
| Feature
| A point, line, or polygon in a coverage, shapefile, or geodatabase feature class
|-
| Feature Layer
| A collection of similar features and their associated properties
|-
| Flux
| The movement of sediment into or out of a littoral cell. Flux features are a representation of the input and output of sediment into a littoral cell. Each cell requires both eastward and westward transport rates
|-
| Littoral Cell
| A delineated area that acts as a source or sink of sediment. Littoral Cell features are collection of information describing similar physical, biological, and cultural characteristics within a particular area along a river, lake, sea, or ocean
|-
| Macro Budget
| A sediment budget for a region; it may consist of multiple micro budgets
|-
| Micro Budget
| A sediment budget for a specific local area
|-
| Sediment Budget
| A measure of sediment (usually sand) “sources” (inputs), “sinks” (outputs), and net change within a specified “control volume” (a cell or series of connecting cells) over a given period of time.
|-
| Shapefile/Feature Class
| A vector data storage format for storing the shape, location, and attributes of geographic features. A shapefile is stored in a set of related files and contains one feature class.
|-
| Sink
| The destination of sediment that is moved from its original location.
|-
| Source
| The point of origin of sediment that is moved to a different location
|}


USACE - United States Army Corps of Engineers


{| class = "wikitable"
|+ Sediment flux attributes. Highlighted rows represent editable cells.
|-
! Field Name
! style=max-width:3em |Field Type
! style=max-width:5em |Character Limit (if applicable)
! style=max-width:7em | Field Description
|-
| sedimentTransportDirectionIDPK
| Text
| 50
| Primary Key. This value is auto-generated by SBAS and provides a unique identifier for each flux
|-
|style="background: yellow;"| sdsFeatureName ||style="background: yellow;"| Text ||style="background: yellow;"| 50 ||style="background: yellow;"| Name or label of the flux
|-
|style="background: yellow;"| sdsFeatureDescription ||style="background: yellow;"| Text ||style="background: yellow;"| 255 ||style="background: yellow;"| Description of the flux
|-
| scenarioIDFK
| Text
| 50
| Foreign Key. Value to the relative alternative (or scenario)
|-
|style="background: yellow;"| qValue ||style="background: yellow;"| Double ||style="background: yellow;"| - ||style="background: yellow;"| Volume of sediment moving in or out of cell
|-
| transportUom
| Text
| 50
| Units of measure for sediment transport rates. Cubic yards/year or cubic meters/year
|-
| alternativeLabel
| Text
| 50
| Name of alternative
|}


=Points of Contact=
=Points of Contact=
Line 377: Line 265:
Email:  [mailto://Sean.P.McGill@usace.army.mil Sean.P.McGill@usace.army.mil]
Email:  [mailto://Sean.P.McGill@usace.army.mil Sean.P.McGill@usace.army.mil]


Secondary POC: Katie Brutsche<br>
Secondary POC: David Perkey<br>
Email:  [mailto:Katherine.E.Brutsche@usace.army.mil Katherine.E.Brutsche@usace.army.mil]  
Email:  [mailto:David.Perkey@usace.army.mil David.Perkey@usace.army.mil]  


Technical Issues:  Rose Dopsovic<br>
Technical Issues:  Rose Dopsovic<br>

Latest revision as of 19:27, 31 January 2023


Versions & Requirements

SBAS ArcGIS Pro

SBAS ArcGIS Desktop

  • ESRI ArcGIS 10.1 - 10.4
  • Python comtypes package (tested with 0.6.2 - included with this tool)
URL: https://pypi.org/project/comtypes/ -- (Previous link http://starship.python.net/crew/theller/comtypes/ no longer works)
Author: Thomas Heller, theller@ctypes.org
License: MIT License
The package must be installed into the local python instance.
Install does not require admin rights.
Can be installed by running comtypes-0.6.2\install_comtypes.bat
  • Snippets.py, slightly modified code snippets file for accessing ArcObjects via Python. (Included)
File: snippets.py -- (Previous link http://www.pierssen.com/arcgis/misc.htm no longer works)
Author: Mark Cederholm
License: No specific license.
(Formerly available on http://www.pierssen.com/ and indicated "Free stuff for GIS Developers and Users!")

SBAS Desktop

SBAS Desktop is a legacy version of SBAS designed to run as a stand-alone program.
For information on all past (and present) versions of SBAS, see the SBAS main wiki page.

Using SBAS ArcGIS Pro

Installation & Launching SBAS

Figure 1. SBAS 2020 Toolbox after installation and expanded in the Catalog pane to show all the individual steps.

The SBAS for ArcGIS Pro is designed as an ArcToolbox written in Python 3, and installation requires unzipping the distribution file to a local drive. The zip file can be downloaded from here: https://www.arcgis.com/home/item.html?id=90576370d48f491fbddc7a15bbfb40d7. The zip file includes the toolbox (SBAS_2020.pyt), layer packages (_.lyrx), a settings file (SBAS_settings.txt), and a template geodatabase (SBAS.gdb). The settings file is used by the SBAS tools to easily find the local SBAS database and must stay in the same directory as the toolbox file. To launch SBAS, create a new project in ArcGIS Pro and use “Add a Folder Connection” to add SBAS_2020.pyt to your project in the catalog pane. Within the toolbox are the individual tools used to create a sediment budget (Figure 1; Table 1).

Description of SBAS Tools
Topic Tool Description
00 – Set Local Database Designates location for SBAS data to be stored
01a – Create SBAS Alternative Creates a sediment budget
01b – Load SBAS Alternative Loads an existing sediment budget
01C – Copy SBAS Alternative Copies an existing sediment budget
02a – Plot GenCade Points Plots shoreline points from GenCade data
02b – Convert GenCade Points to Budget Features Converts GenCade data into budget cells and fluxes
03a – Import GIS Features to SBAS Alternative Imports GIS features into the sediment budget
03b – Transfer Values to SBAS Cell Attributes Transfers sediment budget values from a different file into the budget alternative
03c – Create Relationship to SBAS Features Joins data based on spatial relationship
03d – Show Related SBAS Attributes Create a layer file to hold a relationship between SBAS features and additional attribute data
04a – Load Complementary Data Loads complementary data
04b – Load Published Sediment Budgets Loads a sediment budget that is published on USACE AGOL
05a – Start Editing (Add Features) Starts editing session to create features
05b – Stop Editing (Add Features) Stops editing session
06 – Recompute Residual Recalculates residual volume, transport removal, and transport placement
07 – Delete Alternative Deletes Sediment Budget
08 – Share Sediment Budget Online Publishes sediment budget to ArcGIS Online

Creating a Sediment Budget

Set Local Database

Tool 00 - Set Local Database is used to designate a known file locality for the user’s local SBAS database and provides the flexibility to have one or more local SBAS databases. Behind the scenes, this tool is simply writing a string value into the file “SBAS_settings.txt”. Each time SBAS needs to locate the SBAS database in the data processing, it will put the value listed in this file.

Create SBAS Alternative

Sediment budget data are grouped into alternatives, which are representations of one set of assumed conditions for a sediment budget. Creating a new alternative is the first step in building the geometry container to hold littoral cell and flux features. The user has an option to create a micro (<200-meter cell lengths) or macro (>200-meter cell lengths) budget type (Figure 2). Each alternative has its own set of littoral cells (with delta volume, placement/input volume, and removal/output volume) and fluxes. Alternatives may be created to reflect different assumptions about sediment-transport paths/rates and engineering activities, or they may reflect different time periods. Alternatives hold all values applied to littoral cells and fluxes, and the data are written to the alternative table in the local geodatabase.

Figure 2. Micro vs. macro sediment budget comparison.

Tool 01a - Create SBAS Alternative is used to create a new alternative for a sediment budget. Basic information is collected to assist in building metadata for the alternative. The following pieces of data are required:

a. Budget Type (Micro or Macro)
b. Alternative Name
c. Alternative Description
d. Geographic Area Name or Description
e. Data From (Epoch)
f. Date To (Epoch)
g. Flux Q Units (cubic year/year or cubic meters/year)
h. Cell Volume Units (cubic Yards or cubic Meters)

There is a checkbox to load a new alternative immediately, which if selected will add three new layers to the Table of Contents. One layer will be named “Fluxes for Alternative Name,” and the other two will be named “Cells for Alternative Name.” One of the cell layers displays the cell boundaries while the other displays the residual volume change for the cell (Figure 3). As different alternatives are created, each is assigned a unique identifier (ID). This value is stored in the “scenarioIDPK” attribute field. When added to the Table of Contents, the SBAS tool pulls the supplied layer files (Cells.lyrx, AllCells.lyrx, and Flux.lyrx) and applies a definition query to the items that filters only on the assigned unique ID for the active alternative.

Figure 3. Table of contents view containing components of the alternative.

Load SBAS Alternative

Tool 01b – Load SBAS Alternative is an optional step to load any alternative and its respective feature layers into the Table of Contents. All available alternatives are listed in the drop-down menu that are stored in your local SBAS database, and multiple alternatives can be loaded at the same time.

Copy, Change, and Delete Alternatives

Tool 01c – Copy SBAS Alternative is used to copy any existing alternative into a new alternative. This tool allows the user to reuse feature geometry for a new alternative. The user also has the ability to change specific alternative details such as “Name,” “Description,” “Start,” and “End Date.”

1. In the Catalog pane, browse and expand the “SBAS.gdb”.
2. Right-click on the alternative table and select “Add to Current Map.”
3. In the Table of Contents pane, right-click on the alternative table and select “Open.”
4. In the attribute window, click the row/column value to modify and enter any changes.
5. Enter any changes, and when finished click the “Save” button on the Edit ribbon.

Sketching SBAS Feature Geometry

Creating new feature geometry in SBAS follows much of the same process inherent in ArcGIS Pro, however in SBAS, the user must first start an “SBAS Edit Session” so geometry is related to the correct alternative.

1. To begin launch tool 05a - Start Editing (Add Features)
2. A list of all alternative in the Table of Contents will be in the drop-down list. Choose the desired alternative and click "Run".
3. Zoom to your area of interest, click on ArcGIS Pro's Edit ribbon, and click on "Create".
4. To sketch littoral cells, click on the symbol in front of the "Cells for Alternative Name" layer in the "Create Features" panel. This will expand to show the sketch options. Click on the first icon, which will turn on the sketch tool. Click in the map to drop vertices for your littoral cell polygon. Double-click to complete sketch. For sketching flux cells, select “Fluxes for Alternative Name” layer in the “Create Features” panel and create vertices for a flux line in the direction of flux with the sketch tool. Fluxes may represent a sink for one cell and a source for another, so all fluxes are symbolized the same way and given a positive magnitude and direction.
5. When done sketching all of the new littoral cell features, launch tool 05b - Stop Editing (Add Features) to commit changes.
6. To modify location of vertices, click on the "Modify" button from ArcGIS Pro's Edit ribbon, then click on "Reshape", then "Edit Vertices." Click on the vertices to move to new location or right click to remove. Save changes when complete.

Importing SBAS Feature Geometry from GenCade Data

GenCade is a one-dimensional numerical model that calculates the shoreline change based on longshore sediment transport rates. After creating and calibrating a GenCade grid, the user can create sediment budget cells and fluxes and run the model. In the GenCade results file (_.prt) under “SBAS OUTPUT,” the results for volume change and rate for the fluxes and cells will be used with SBAS. A GenCade special report (Munger and Frey 2015) provides more information for new users on how to use GenCade, and a technical note (Frey 2015) is available for more detail on incorporating GenCade and SBAS data.

When importing GenCade data, geometry for both “Cells” and “Fluxes” is created. Tools 02a - Plot GenCade Points and 02b - Convert GenCade Points to Budget Features are used for this data transformation. For the data transformation to a sediment budget, the associated GenCade files, _.gen (GenCade control file), _.slo (shoreline position file), _.prt (sediment fluxes file), and _.map(GenCade coverage file) are required. These steps below need to be run only once as the tool will import the littoral cells and fluxes at the same time.

1. First run tool 02a - Plot GenCade Points. This will plot the shoreline point locations documented in the _.slo file. The output shapefile is needed for the input into tool 02b - Convert GenCade Points to Budget Features. The starting coordinate, azimuth, and distance between points is collected from the _.slo file. If "Use Only First Date in Point Plot" is selected in the tool, only the first row of the _.slo is used for the plot.
2. Next open tool 02b - Convert GenCade Points to Budget Features. The three GenCade files and the newly created GenCade shoreline points will need to be supplied. Set the temporary placeholder feature classes for the “Cells” and “Fluxes”, set the design distant variables, and choose the alternative that will be the home for these features.

Importing SBAS Feature Geometry from Existing Geographic Information System (GIS) Layers

If geographic information system (GIS) layers are already created that represent littoral cells or fluxes, but were created outside of the SBAS toolbox, these features can be imported into SBAS. The steps for importing SBAS Feature Geometry from existing layers are below.

1. Using tool 03a - Import GIS Features to SBAS Alternative, browse to an existing feature class or shapefile, then provide field mapping to connect the original field names to the SBAS values.
2. If importing littoral cells, the required fields for mapping include the following: Name, Description, Placement Volume, Removal Volume, and Volume Change. If importing flux cells, the required fields for mapping include: “Name,” “Description,” and “Q Value.”
3. Check the “Duplicate Geometries OK” checkbox to use the same cells/fluxes for multiple alternatives.

Manually Add SBAS Feature Values

Sediment budget values linked to cell volumes and fluxes can easily be added to geometry as feature attributes. Tables A2 and A3 contain the values available to edit for the littoral cells and fluxes. Within the littoral cell there are three dynamic fields: “residualVolume,” “transportRemoval,” and “transportPlacement.” The values within these fields do not need to be manually updated, as they can be automatically recalculated using tool 06 – Recompute Residual. To manually add feature values:

1. From the Edit ribbon, click the “Attributes” button to open the Attribute pane.
2. Selected a budget feature (cell or flux) on the map with the Selection Tool. The attribute pane will display the values for the selected feature.
3. Click on the value next to the attribute to edit. Enter in the new value.
4. When finished, click the “Save” button on the Edit ribbon.

Transfer Values into SBAS Cell Attributes

If sediment budget geometries and values exist outside of your local SBAS database in a feature class with identical geometry, the attributes can be transferred into the selected Alternative using tool 03b – Transfer Values to SBAS Cell Attributes. To use this tool, the geometries in both datasets must match. All values from the input feature class will be used to update the littoral cell layer, and a record of all transferred values will be listed in the Results Window. Tool 06 – Recompute Residual does not need to be run as the residual is automatically recalculated.

Create Relationship to SBAS Features

Additional attribute data may be stored outside of the SBAS local database in feature classes. Contents from supplemental databases can be related to SBAS features using tool 03c – Create Relationship to SBAS Features. This tool uses spatial and nonspatial relationships to determine how to connect the data attributes to the sediment budget. If there are feature geometry and values created outside of the SBAS toolbox, this tool will create a spatial relationship to join the datasets together. This tool should be used when a table join cannot easily be performed, such as when there is no consistent field between the tables that can be referenced for the join. This tool does not support Grouped Layers.

Load Complementary Data & Published Sediment Budgets

SBAS is configured to work with sediment budgets and complementary data that have been published online (Dunkin et al. 2020). Use tool 04a – Load Complementary Data to connect to online content (map services or feature services) that have been appropriately tagged in ArcGIS Online (AGOL) item descriptions or published through the SBAS 2020 toolbox (see tool 08 – Share Sediment Budget Online).

Share Sediment Budget Online

Users with an AGOL account can request access to the SBAS ArcGIS Hub (https://sbas-usace.hub.arcgis.com) to publish sediment budgets online. Using tool 08 – Share Sediment Budget Online, budgets will be published as a feature web service to the SBAS Hub. Extraneous datasets need to be removed from the Table of Contents, as the tool includes all contents in the web service. Content with multiple display options for a single dataset need to be reduced to one visualization per dataset. When publishing a budget, consider the following:

•Any existing web service with the same name will be overwritten.
•If more than one alternative is loaded in the Table of Contents, all alternatives will be combined into a single feature service but as separate layers.
•Do not publish any datasets containing personally identifiable information or other sensitive information.
•Do not publish datasets that are already available online.

Definitions and Descriptions

Definitions
Term Definition
Alternative Representation of a sediment budget. Contains fluxes, cells, and associated values.
Attribute Specific information related to a feature layer
Attribute Table Table that stores the attributes related to a feature layer
Confidence The certainty level that the values assigned to littoral cells and fluxes are accurate
Feature A point, line, or polygon in a coverage, shapefile, or geodatabase feature class
Feature Layer A collection of similar features and their associated properties
Flux The movement of sediment into or out of a littoral cell. Flux features are a representation of the input and output of sediment into a littoral cell. Each cell requires both eastward and westward transport rates
Littoral Cell A delineated area that acts as a source or sink of sediment. Littoral Cell features are collection of information describing similar physical, biological, and cultural characteristics within a particular area along a river, lake, sea, or ocean
Macro Budget A sediment budget for a region; it may consist of multiple micro budgets
Micro Budget A sediment budget for a specific local area
Sediment Budget A measure of sediment (usually sand) “sources” (inputs), “sinks” (outputs), and net change within a specified “control volume” (a cell or series of connecting cells) over a given period of time.
Shapefile/Feature Class A vector data storage format for storing the shape, location, and attributes of geographic features. A shapefile is stored in a set of related files and contains one feature class.
Sink The destination of sediment that is moved from its original location.
Source The point of origin of sediment that is moved to a different location


Sediment flux attributes. Highlighted rows represent editable cells.
Field Name Field Type Character Limit (if applicable) Field Description
sedimentTransportDirectionIDPK Text 50 Primary Key. This value is auto-generated by SBAS and provides a unique identifier for each flux
sdsFeatureName Text 50 Name or label of the flux
sdsFeatureDescription Text 255 Description of the flux
scenarioIDFK Text 50 Foreign Key. Value to the relative alternative (or scenario)
qValue Double - Volume of sediment moving in or out of cell
transportUom Text 50 Units of measure for sediment transport rates. Cubic yards/year or cubic meters/year
alternativeLabel Text 50 Name of alternative

Points of Contact

Main POC: Sean McGill
Email: Sean.P.McGill@usace.army.mil

Secondary POC: David Perkey
Email: David.Perkey@usace.army.mil

Technical Issues: Rose Dopsovic
Email: Rose.Dopsovic@usace.army.mil



Back to Main SBAS Page