| Service | Description | Feature Access | Layer |
|---|---|---|---|
| BES_Asset_Risk | Data for Asset Risk Mapping. Primarily used by the BES Risk Assessment Division (RAD).Data considers modeled capacity constraints and structural concerns through an asset management framework. This is raw data that has not been curated for any particular need. | Dynamic | ccsp_characterizationlinks |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Any Surcharge Over 30 Minute Duration |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Excessive Pipe Surcharge _ HGL Minus Max Crown Elevation Greater than 4 ft |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Existing Pipe Flow Ratio Peak over Design Flow |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Future Pipe Flow Ratio Peak over Design Flow |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | In Model, Not in Hansen |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Invalid Inspection Pipes |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Large Diameter |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Pipe Condition Grade |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Pipe Inspection Age |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Root Rating |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Special Shape Modeled Pipe |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Structural BPW |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Surcharging Brick Pipe |
| BES_CCSP | Data tailored for Risk Assessment Division (RAD) Continuous Collection System Planning (CCSP) mapping. This data has been filtered and symbolized to reflect thematics consistent with the 2012 System Plan albeit with current data. | Dynamic | Uninspected Pipes |
| | ||||||
|---|---|---|---|---|---|---|
| Table Description | ||||||
| Table Jurisdiction | ||||||
| Column Sort | Column Name | Column Alias | Column Type | Column Size | Domain Value(s) | Column Description | 1 | PrimaryKey | PrimaryKey | Integer | 4 | | | 1 | LinkID | LinkID | Integer | 4 | | | 1 | ModelLinkID | ModelLinkID | Integer | 4 | | | 1 | ModelLinkName | ModelLinkName | String | 255 | | | 1 | GlobalID | GlobalID | Integer | 4 | | | 1 | CompKey | CompKey | Integer | 4 | | | 1 | InBESCollectionSystem | InBESCollectionSystem | Integer | 4 | | | 1 | LinkOperation | LinkOperation | String | 255 | | | 1 | Diameter | Diameter | Numeric | 8 | | | 1 | UnitType | UnitType | String | 255 | | | 1 | LayerGroup | LayerGroup | String | 255 | | | 1 | SymbolGroup | SymbolGroup | String | 255 | | | 1 | DetailSymbol | DetailSymbol | String | 255 | | | 1 | ServStatus | ServStatus | String | 255 | | | 1 | CrossSectionID | CrossSectionID | Integer | 4 | | | 1 | HansenMaterial | HansenMaterial | String | 255 | | | 1 | ModelMaterial | ModelMaterial | String | 255 | | | 1 | MappingCombinedMaterial | MappingCombinedMaterial | String | 255 | | | 1 | UpstreamDepth | UpstreamDepth | Numeric | 8 | | | 1 | DownstreamDepth | DownstreamDepth | Numeric | 8 | | | 1 | PipeHasInspections | PipeHasInspections | Integer | 4 | | | 1 | CurrentInspectionDate | CurrentInspectionDate | Date | 36 | | | 1 | InspectionCurrent | InspectionCurrent | Integer | 4 | | | 1 | ValidInspection | ValidInspection | Integer | 4 | | | 1 | StructuralRating | StructuralRating | Numeric | 8 | | | 1 | InspectionAge | InspectionAge | Integer | 4 | | | 1 | RootRating | RootRating | Numeric | 8 | | | 1 | FailureYear | FailureYear | Numeric | 8 | | | 1 | Age | Age | Numeric | 8 | | | 1 | ModelLinkGlobalID | ModelLinkGlobalID | Integer | 4 | | | 1 | ModelID | ModelID | Integer | 4 | | | 1 | SimulationID | SimulationID | Integer | 4 | | | 1 | SimulationDescription | SimulationDescription | String | 255 | | | 1 | ModelLinkSymbology | ModelLinkSymbology | String | 255 | | | 1 | ModelLinkPipeFlowRatio | ModelLinkPipeFlowRatio | Numeric | 8 | | | 1 | UpstreamSurchargeTime | UpstreamSurchargeTime | Numeric | 8 | | | 1 | UpstreamSurchargeDepthFt | UpstreamSurchargeDepthFt | Numeric | 8 | | | 1 | ML_IsUSNodeSurcharged | ML_IsUSNodeSurcharged | Integer | 4 | | | 1 | ML_IsHydraulDef | ML_IsHydraulDef | Integer | 4 | | | 1 | ModelLinkIsBrickPipeSurcharged | ModelLinkIsBrickPipeSurcharged | Integer | 4 | | | 1 | ML_ExceedsSurchargedDepthCrit | ML_ExceedsSurchargedDepthCrit | Integer | 4 | | | 1 | ML_ExceedsSurchargeDurCrit | ML_ExceedsSurchargeDurCrit | Integer | 4 | | | 1 | SmallDiamRehabStatusInProject | SmallDiamRehabStatusInProject | Integer | 4 | | | 1 | LargeDiameter | LargeDiameter | Integer | 4 | | | 1 | LargeDiameterInRehabDatabase | LargeDiameterInRehabDatabase | Integer | 4 | | | 1 | LargeDiamRehabStatusInProject | LargeDiamRehabStatusInProject | Integer | 4 | | | 1 | LargeDiameterRehabBPW | LargeDiameterRehabBPW | Numeric | 8 | | | 1 | LifeCycleBPW | LifeCycleBPW | Numeric | 8 | | | 1 | LifeCycleAPW | LifeCycleAPW | Numeric | 8 | | | 1 | LifeCycleNBCR | LifeCycleNBCR | Numeric | 8 | | | 1 | WatchMe | WatchMe | Integer | 4 | | | 1 | LifeCycleRecommendedMethod | LifeCycleRecommendedMethod | String | 255 | | | 1 | LifeCycleEmergencyMethod | LifeCycleEmergencyMethod | String | 255 | | | 1 | BPW | BPW | Numeric | 8 | | | 1 | SimulationReturnPeriod | SimulationReturnPeriod | Numeric | 8 | | | 1 | IsStormHistoric | IsStormHistoric | Integer | 4 | | | 1 | LifeCycleCapitalCostNBCR | LifeCycleCapitalCostNBCR | Numeric | 8 | | | 1 | GmlID | GmlID | String | 255 | | | 1 | LASTUPDATE | LASTUPDATE | Date | 36 | | |