Skip to main content

Azure Storage

Storage has a combined Unique key of Partition Key and Row Key.

Table Storage​

Table storage does not have a strict structure like SQL Tables. Instead azure table storage uses a property bag it allows for more flexibility allowing you to add new columns as needed however if the developer is not careful then additional columns may be made by mistake as the columns are case sensitive.

Combined Tables​

These are tables that contain both Stomwater and SWMM Data.

Errors​

Error Table with data Error Entity

SWMM Input​

Inputs​

Inputs Table with data Inputs Entity

SWMM Run​

Runs​

Runs Table with data Runs Entity

SWMM Output​

Link Outputs Table with data Link Outputs Entity

Node Outputs​

Node Outputs Table with data Node Outputs Entity

Subcatchment Outputs​

Subcatch Outputs Table with data Subcatch Outputs Entity

System Outputs​

System Outputs Table with data System Outputs Entity

SWMM Sensor​

Sensors​

Sensor Table with data Sensor Entity

Sensors X Ref​

Sensor X Ref Table with data Sensor X Ref Entity

Sensor Data​

Sensor Data Table with data Sensor Data Entity

Temp Sensors​

temp Sensors Data Table with data temp Sensors Data Entity

Rainfall And Evaporation Stations​

NOAA Account Tokens​

NOAA Account Tokens

NOAA Account Tokens Table with data NOAA Account Tokens Entity

NOAA Hourly Precipitation​

Rainfall Data

NOAA Hourly Precipitation Table with data NOAA Hourly Precipitation Entity

NSWC Evaporation Stations​

Evaporation Data monthly

NSWC evaporation Stations Table with data NSWC evaporation Stations Entity

NOAA Rainfall Stations​

Rainfall Stations

NOAA Rainfall Stations Table with data NOAA Rainfall Stations Entity

NOAA Rainfall Stations 2021​

Rainfall Stations that we have 2021 data for. I do not know where this is being used at this time.

NOAA Rainfall Stations 2021 Table with data NOAA Rainfall Stations 2021 Entity

Station​

This has KCVG data. I do not know where this is being used at this time.

Station Table with data Station Entity

Stormwater Input​

NSWC Cities​

List of cities that we have set up to run Stormwater.

NSWC Cities Table with data NSWC Cities Entity

Stormwater Run​

NSWC Input parameters​

This is where the NSWC input parameters that have been chosen by the user are stored. They are passed in for the INP file. This is also the table that is used when the previous results come up.

NSWC Input parameters Table with data NSWC Input parameters Entity 1 NSWC Input parameters Entity 2 NSWC Input parameters Entity 3

NSWC Inputs entity​

This table is what the SWMM engine picks up and runs. It has the flag that is flipped when it is picked up and where you will see if a swmm run is running, complete, or erroring out.

NSWC Inputs Table with data NSWC Inputs Entity 1

Stormwater Output​

NSWC Runs​

This table contains the output of the SWMM run from the stormwater Run.

Runs Table with data Runs Entity

Tables not in Use​

user profile​

We are now only using 1 hardcoded user profile.

user profile Table with data user profile Entity

user session​

We are now only using 1 hardcoded user profile. This used to record all sessions for an authorized user based on there locations.

user session Table with data user session Entity

NSWC Pollutant​

This is the table that we should use.

NSWC pollutant Table with data NSWC pollutant Entity

NSWC Pollutants​

This is not the correct table. It should be deleted.

NSWC pollutants Table with data NSWC pollutants Entity

Blob Storage​

Network Model​

List of Links and Nodes. The links reference the nodes and the nodes have Lat Longs.

Network Model Network Model Rivershore

nswc rainfall​

Rainfall from 1970 to current.

nswc rainfall

nswc swmm input​

NSWC input files.

nswc swmm input

nswc swmm output​

This is empty.

nswc swmm output

radar images​

Doppler radar images.

radar images

rivershore swmm output​

SWMM output files binary output.

rivershore swmm output

swmm input​

scenario inp files for SWMM.

swmm input