View In:   ArcGIS Online Map Viewer

Name: culverts_risk_final_clean

Display Field: pr

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>The Culvert Guide book detailing the collection efforts can be found on the TAMS Sharepoint page:</SPAN></P><P><SPAN>https://stateofmichigan.sharepoint.com/sites/mdot/Organizational/field_services/ops/maintenance/SitePages/TAMS.aspx</SPAN></P></DIV></DIV></DIV>

Service Item Id: 4c83d73a79e0491f890d69b5752204ad

Copyright Text: Contacts/Business Owners: Justin Droste Bureau of Field Services drostej@michigan.gov Dan Belcher Bureau of Development belcherd@michigan.gov Cory Johnson Bureau of Transportation Planning johnsonC45@michigan.gov

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 1.3182955208333328E7
YMin: 83273.39927820861
XMax: 1.3638432893700793E7
YMax: 613260.2214566916
Spatial Reference: 2898  (2898)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: <4
  Label: <4
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: 2-3
  Label: <3
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 1-2
  Label: <2
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: Object ID )
• pr ( modelName: PR, nullable: true, editable: true, defaultValue: null, length: 14, alias: Physical Road ID, type: esriFieldTypeString )
• route ( modelName: Route, nullable: true, editable: true, defaultValue: null, length: 50, alias: Route, type: esriFieldTypeString )
• beneath ( modelName: Beneath, nullable: true, editable: true, defaultValue: null, length: 20, alias: Beneath, type: esriFieldTypeString )
• change_in_days_with_3inches_of_ ( modelName: change_in_days_with_3inches_of_, nullable: true, editable: true, defaultValue: null, alias: Change in Days with Precip > 3in, type: esriFieldTypeDouble )
• perrank_changedaysprecip ( modelName: perrank_changedaysprecip, nullable: true, editable: true, defaultValue: null, alias: Change in Precip Score, type: esriFieldTypeDouble )
• impervious_per ( modelName: impervious_per, nullable: true, editable: true, defaultValue: null, alias: Impervious Surface Percentage in Basin, type: esriFieldTypeDouble )
• perrank_imperv ( modelName: perrank_imperv, nullable: true, editable: true, defaultValue: null, alias: Impervious Surface Percentage Score, type: esriFieldTypeDouble )
• floodplain ( modelName: floodplain, nullable: true, editable: true, defaultValue: null, length: 255, alias: FEMA Flood Zone, type: esriFieldTypeString )
• perrank_floodprox ( modelName: perrank_floodprox, nullable: true, editable: true, defaultValue: null, alias: FEMA Flood Zone Score, type: esriFieldTypeDouble )
• max_rastervalu ( modelName: max_rastervalu, nullable: true, editable: true, defaultValue: null, alias: Flow Accumulation Value, type: esriFieldTypeDouble )
• near_dist ( modelName: near_dist, nullable: true, editable: true, defaultValue: null, alias: Distance to Culvert (m), type: esriFieldTypeDouble )
• perrank_ponding ( modelName: perrank_ponding, nullable: true, editable: true, defaultValue: null, alias: Flow Accumulation and Ponding Score, type: esriFieldTypeDouble )
• pastflooding ( modelName: pastflooding, nullable: true, editable: true, defaultValue: null, length: 255, alias: Past Flooding Experience, type: esriFieldTypeString )
• perrank_pastflooding ( modelName: perrank_pastflooding, nullable: true, editable: true, defaultValue: null, alias: Past Flooding Experience Score, type: esriFieldTypeDouble )
• perrank_exposure ( modelName: perrank_exposure, nullable: true, editable: true, defaultValue: null, alias: Exposure Score, type: esriFieldTypeDouble )
• response1 ( modelName: Response1, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Flood Survey Grouping, type: esriFieldTypeString )
• comment ( modelName: Comment, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Flood Survey Comment, type: esriFieldTypeString )
• perrank_pastflooddamage ( modelName: perrank_pastflooddamage, nullable: true, editable: true, defaultValue: null, alias: Past Flood Damage Score, type: esriFieldTypeDouble )
• conditionindex ( modelName: ConditionIndex, nullable: true, editable: true, defaultValue: null, alias: Condition Index, type: esriFieldTypeSmallInteger )
• perrank_conditionindex ( modelName: perrank_conditionindex, nullable: true, editable: true, defaultValue: null, alias: Condition Index Score, type: esriFieldTypeDouble )
• culvertinstallationdate ( modelName: CulvertInstallationDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Culvert Installation Date, type: esriFieldTypeDate )
• perrank_culvertage ( modelName: perrank_culvertage, nullable: true, editable: true, defaultValue: null, alias: Culvert Age Score, type: esriFieldTypeDouble )
• comments ( modelName: Comments, nullable: true, editable: true, defaultValue: null, length: 250, alias: Inspection Comments, type: esriFieldTypeString )
• perrank_inspectioncomment ( modelName: perrank_inspectioncomment, nullable: true, editable: true, defaultValue: null, alias: Inspection Comments Score, type: esriFieldTypeDouble )
• waterdepth ( modelName: WaterDepth, nullable: true, editable: true, defaultValue: null, alias: Water Depth, type: esriFieldTypeDouble )
• culvertheight ( modelName: CulvertHeight, nullable: true, editable: true, defaultValue: null, alias: Culvert Height, type: esriFieldTypeSmallInteger )
• perrank_culvertproportion ( modelName: perrank_culvertproportion, nullable: true, editable: true, defaultValue: null, alias: Proportion of Height Filled with Water Score, type: esriFieldTypeDouble )
• streamsubstrate ( modelName: StreamSubstrate, nullable: true, editable: true, defaultValue: null, length: 15, alias: Stream Substrate, type: esriFieldTypeString )
• perrank_streamsubstrate ( modelName: perrank_streamsubstrate, nullable: true, editable: true, defaultValue: null, alias: Stream Substrate Score, type: esriFieldTypeDouble )
• perrank_sensitivity ( modelName: perrank_sensitivity, nullable: true, editable: true, defaultValue: null, alias: Sensitivity Score, type: esriFieldTypeDouble )
• perrank_criticality ( modelName: perrank_criticality, nullable: true, editable: true, defaultValue: null, alias: Criticality Score, type: esriFieldTypeDouble )
• perrank_vulnerability ( modelName: perrank_vulnerability, nullable: true, editable: true, defaultValue: null, alias: Vulnerability Score, type: esriFieldTypeDouble )
• perrank_risk ( modelName: perrank_risk, nullable: true, editable: true, defaultValue: null, alias: Risk Score, type: esriFieldTypeDouble )
• completed_flood_resilience_proj ( modelName: completed_flood_resilience_proj, nullable: true, editable: true, defaultValue: null, length: 255, alias: Completed Flood Resilience Project?, type: esriFieldTypeString )
• risk_level ( modelName: risk_level, nullable: true, editable: true, defaultValue: null, length: 25, alias: Risk_Level, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: culverts_risk_final_clean
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata