Name: SoCalProjects.DBO.sandag_vz_countermeasures_info_table

Display Field: risk_factor

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7ad37f1281b64c6d829b92575aa09b02

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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: true
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: false
Supports Query With LOD Spatial Reference: false
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• risk_factor ( type: esriFieldTypeString, alias: risk_factor, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: risk_factor )
• countermeasure_tier ( type: esriFieldTypeString, alias: countermeasure_tier, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: countermeasure_tier )
• countermeasure ( type: esriFieldTypeString, alias: countermeasure, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: countermeasure )
• description ( type: esriFieldTypeString, alias: description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: description )
• Modal_Safety_Emphasis ( type: esriFieldTypeString, alias: Modal_Safety_Emphasis, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Modal_Safety_Emphasis )
• category ( type: esriFieldTypeString, alias: category, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: category )
• lu_urban ( type: esriFieldTypeString, alias: lu_urban, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lu_urban )
• lu_suburban ( type: esriFieldTypeString, alias: lu_suburban, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lu_suburban )
• lu_rural ( type: esriFieldTypeString, alias: lu_rural, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lu_rural )
• local_serving_roadway ( type: esriFieldTypeString, alias: local_serving_roadway, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: local_serving_roadway )
• circulatorYes_roadway ( type: esriFieldTypeString, alias: circulatorYes_roadway, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: circulatorYes_roadway )
• state_owned_roadway ( type: esriFieldTypeString, alias: state_owned_roadway, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: state_owned_roadway )
• ssa_tier1 ( type: esriFieldTypeString, alias: ssa_tier1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ssa_tier1 )
• ssa_tier2 ( type: esriFieldTypeString, alias: ssa_tier2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ssa_tier2 )
• ssa_tier3 ( type: esriFieldTypeString, alias: ssa_tier3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ssa_tier3 )
• ssa_tier4 ( type: esriFieldTypeString, alias: ssa_tier4, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ssa_tier4 )
• profile1 ( type: esriFieldTypeString, alias: profile1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile1 )
• profile2 ( type: esriFieldTypeString, alias: profile2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile2 )
• profile3 ( type: esriFieldTypeString, alias: profile3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile3 )
• profile4 ( type: esriFieldTypeString, alias: profile4, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile4 )
• profile5 ( type: esriFieldTypeString, alias: profile5, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile5 )
• profile6 ( type: esriFieldTypeString, alias: profile6, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile6 )
• profile7 ( type: esriFieldTypeString, alias: profile7, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile7 )
• profile8 ( type: esriFieldTypeString, alias: profile8, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile8 )
• profile9 ( type: esriFieldTypeString, alias: profile9, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: profile9 )
• crash_reduction_eff ( type: esriFieldTypeString, alias: crash_reduction_eff, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: crash_reduction_eff )
• implementation_timeline ( type: esriFieldTypeString, alias: implementation_timeline, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: implementation_timeline )
• cost ( type: esriFieldTypeString, alias: cost, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: cost )
• lowcost_quickbulild_alternative ( type: esriFieldTypeString, alias: lowcost_quickbulild_alternative_available, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lowcost_quickbulild_alternative )
• considerations ( type: esriFieldTypeString, alias: considerations, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: considerations )
• lrsm_id ( type: esriFieldTypeString, alias: lrsm_id, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lrsm_id )
• lrsm_name ( type: esriFieldTypeString, alias: lrsm_name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: lrsm_name )
• cmf_id ( type: esriFieldTypeString, alias: cmf_id, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: cmf_id )
• cmf_name ( type: esriFieldTypeString, alias: cmf_name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: cmf_name )
• cmf_link ( type: esriFieldTypeString, alias: cmf_link, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: cmf_link )
• crf ( type: esriFieldTypeString, alias: crf, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: crf )
• crash_type ( type: esriFieldTypeString, alias: crash_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: crash_type )
• expected_life_years ( type: esriFieldTypeInteger, alias: expected_life_years, editable: true, nullable: true, defaultValue: null, modelName: expected_life_years )
• federal_funding_eligibility ( type: esriFieldTypeString, alias: federal_funding_eligibility, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: federal_funding_eligibility )
• systemic_opportunity ( type: esriFieldTypeString, alias: systemic_opportunity, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: systemic_opportunity )
• unit_cost ( type: esriFieldTypeDouble, alias: unit_cost, editable: true, nullable: true, defaultValue: null, modelName: unit_cost )
• unit ( type: esriFieldTypeString, alias: unit, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: unit )
• countermeasure_tier_id ( type: esriFieldTypeString, alias: countermeasure_tier_id, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: countermeasure_tier_id )

Templates:

• Name: SoCalProjects.DBO.sandag_vz_countermeasures_info_table
  Description:
  Prototype:
  unit: null
  risk_factor: null
  countermeasure_tier: null
  countermeasure: null
  description: null
  Modal_Safety_Emphasis: null
  category: null
  lu_urban: null
  lu_suburban: null
  lu_rural: null
  local_serving_roadway: null
  circulatorYes_roadway: null
  state_owned_roadway: null
  ssa_tier1: null
  ssa_tier2: null
  ssa_tier3: null
  ssa_tier4: null
  profile1: null
  profile2: null
  profile3: null
  profile4: null
  profile5: null
  profile6: null
  profile7: null
  profile8: null
  profile9: null
  crash_reduction_eff: null
  implementation_timeline: null
  cost: null
  lowcost_quickbulild_alternative: null
  considerations: null
  lrsm_id: null
  lrsm_name: null
  cmf_id: null
  cmf_name: null
  cmf_link: null
  crf: null
  crash_type: null
  expected_life_years: null
  federal_funding_eligibility: null
  systemic_opportunity: null
  unit_cost: null
  countermeasure_tier_id: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata