Name: Countermeasures

Display Field: countermeasure

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 59a34239df8b42b59e6211baf9358f27

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• countermeasure ( modelName: countermeasure, nullable: true, editable: true, defaultValue: null, length: 255, alias: Countermeasure, type: esriFieldTypeString )
• source ( modelName: source, nullable: true, editable: true, defaultValue: null, length: 255, alias: Source, type: esriFieldTypeString )
• cp1__vru__at_intersection__prin ( modelName: cp1__vru__at_intersection__prin, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP1- VRU, at intersection, principal arterial road: x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• cp1a__vru__at_intersection__lef ( modelName: cp1a__vru__at_intersection__lef, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP1a- VRU, at intersection, left-turn crash, Principal arterial road: x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• cp1b__pedestrian__pedestrian_at ( modelName: cp1b__pedestrian__pedestrian_at, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP1b- Pedestrian, Pedestrian at intersection, at crosswalk, Principal arterial road x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• cp1c__pedestrian__pedestrian_at ( modelName: cp1c__pedestrian__pedestrian_at, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP1c- Pedestrian, Pedestrian at intersection, no crosswalk, Principal arterial road x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• cp2__pedestrian__pedestrian_in_ ( modelName: cp2__pedestrian__pedestrian_in_, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP2- Pedestrian, Pedestrian in roadway, sidewalk missing on at least one side, Local or collector road x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• cp3__all__left_turn_at_signaliz ( modelName: cp3__all__left_turn_at_signaliz, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP3- All, Left-turn at signalized intersection, Equity emphasis area; Principal arterial road x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• cp4__all__unsignalized_t_inters ( modelName: cp4__all__unsignalized_t_inters, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP4- All, Unsignalized T-intersection, Local functional class x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• cp5__all__angle_crash_at_unsign ( modelName: cp5__all__angle_crash_at_unsign, nullable: true, editable: true, defaultValue: null, length: 255, alias: CP5- All, Angle crash at unsignalized, four-way intersection, Local functional class x = yes, it is applicable, o = applicable under certain circumstances; keep blank if not , type: esriFieldTypeString )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• crash_reduction_factor__report_ ( modelName: crash_reduction_factor__report_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Crash Reduction Factor: Report as a percentage, keep blank if there is no applicable CRF., type: esriFieldTypeString )
• crash_modification_factor__repo ( modelName: crash_modification_factor__repo, nullable: true, editable: true, defaultValue: null, length: 255, alias: Crash Modification Factor; Report as a decimal, keep blank if no applicable CMF., type: esriFieldTypeString )
• crash_type_and_severity9_17_202 ( modelName: crash_type_and_severity9_17_202, nullable: true, editable: true, defaultValue: null, length: 255, alias: Crash Type and Severity9/17/2025 K: Fatal A: Serious Injury B: Minor Injury C: Possible Injury O: Property Damage Only Keep blank if there is no applicable CRF/CMF., type: esriFieldTypeString )
• complexity_to_implement___low__ ( modelName: complexity_to_implement___low__, nullable: true, editable: true, defaultValue: null, length: 255, alias: Complexity to Implement: (Low, Med, High), type: esriFieldTypeString )
• construction_cost_______100_000 ( modelName: construction_cost_______100_000, nullable: true, editable: true, defaultValue: null, length: 255, alias: Construction Cost: $: <$100,000 $$: $100,000 - $1,000,000 $$$: > $1,000,000, type: esriFieldTypeString )
• maintenance_cost______100_000__ ( modelName: maintenance_cost______100_000__, nullable: true, editable: true, defaultValue: null, length: 255, alias: Maintenance Cost:$: <$100,000 $$: $100,000 - $1,000,000 $$$: > $1,000,000, type: esriFieldTypeString )
• quick_build_opportunity__x___ye ( modelName: quick_build_opportunity__x___ye, nullable: true, editable: true, defaultValue: null, length: 255, alias: Quick Build Opportunity? x = yes, it can be implemented as a quick build, o = can be implemented as a quick build under certain circumstances, keep blank if not , type: esriFieldTypeString )
• publications ( modelName: publications, nullable: true, editable: true, defaultValue: null, length: 255, alias: Publications, type: esriFieldTypeString )
• implemented_in_delaware_county_ ( modelName: implemented_in_delaware_county_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Implemented in Delaware County on State-Owned Roadways: [This column completed by Delco staff on 4/16/2024] x = yes, it has been implemented; keep blank if not , type: esriFieldTypeString )
• implemented_in_delaware_county1 ( modelName: implemented_in_delaware_county1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Implemented in Delaware County on Non-State-Owned Roadways: [This column completed by Delco staff on 4/16/2024] x = yes, it has been implemented; keep blank if not , type: esriFieldTypeString )

Templates:

• Name: Countermeasures
  Description:
  Prototype:
  cp1b__pedestrian__pedestrian_at: null
  cp2__pedestrian__pedestrian_in_: null
  complexity_to_implement___low__: null
  notes: null
  crash_modification_factor__repo: null
  implemented_in_delaware_county1: null
  countermeasure: null
  cp1a__vru__at_intersection__lef: null
  construction_cost_______100_000: null
  source: null
  cp1__vru__at_intersection__prin: null
  maintenance_cost______100_000__: null
  crash_reduction_factor__report_: null
  cp4__all__unsignalized_t_inters: null
  cp5__all__angle_crash_at_unsign: null
  cp1c__pedestrian__pedestrian_at: null
  crash_type_and_severity9_17_202: null
  implemented_in_delaware_county_: null
  cp3__all__left_turn_at_signaliz: null
  quick_build_opportunity__x___ye: null
  publications: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

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