Name: Count_Stats_2022

Display Field: region

Type: Table

Geometry Type: N/A

Description:

Service Item Id: dcb71dfae5504ea8828a191c07fae56a

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• count_stats_id ( modelName: count_stats_id, nullable: true, editable: true, defaultValue: null, alias: COUNT_STATS_ID, type: esriFieldTypeInteger )
• region ( modelName: region, nullable: true, editable: true, defaultValue: null, length: 255, alias: REGION, type: esriFieldTypeString )
• region_code ( modelName: region_code, nullable: true, editable: true, defaultValue: null, alias: REGION_CODE, type: esriFieldTypeInteger )
• county_code ( modelName: county_code, nullable: true, editable: true, defaultValue: null, alias: COUNTY_CODE, type: esriFieldTypeInteger )
• county_fips ( modelName: county_fips, nullable: true, editable: true, defaultValue: null, length: 255, alias: COUNTY_FIPS, type: esriFieldTypeString )
• station ( modelName: station, nullable: true, editable: true, defaultValue: null, length: 255, alias: STATION, type: esriFieldTypeString )
• rcsta ( modelName: rcsta, nullable: true, editable: true, defaultValue: null, length: 255, alias: RCSTA, type: esriFieldTypeString )
• ccsta ( modelName: ccsta, nullable: true, editable: true, defaultValue: null, length: 255, alias: CCSTA, type: esriFieldTypeString )
• fc ( modelName: fc, nullable: true, editable: true, defaultValue: null, alias: FC, type: esriFieldTypeInteger )
• fg ( modelName: fg, nullable: true, editable: true, defaultValue: null, length: 255, alias: FG, type: esriFieldTypeString )
• federal_direction ( modelName: federal_direction, nullable: true, editable: true, defaultValue: null, length: 255, alias: FEDERAL_DIRECTION, type: esriFieldTypeString )
• full_count ( modelName: full_count, nullable: true, editable: true, defaultValue: null, length: 255, alias: FULL_COUNT, type: esriFieldTypeString )
• oneway_flag ( modelName: oneway_flag, nullable: true, editable: true, defaultValue: null, length: 255, alias: ONEWAY_FLAG, type: esriFieldTypeString )
• calculation_year ( modelName: calculation_year, nullable: true, editable: true, defaultValue: null, alias: CALCULATION_YEAR, type: esriFieldTypeInteger )
• ae_flag ( modelName: ae_flag, nullable: true, editable: true, defaultValue: null, length: 255, alias: AE_FLAG, type: esriFieldTypeString )
• aadt ( modelName: aadt, nullable: true, editable: true, defaultValue: null, alias: AADT, type: esriFieldTypeInteger )
• dhv ( modelName: dhv, nullable: true, editable: true, defaultValue: null, length: 255, alias: DHV, type: esriFieldTypeString )
• ddhv ( modelName: ddhv, nullable: true, editable: true, defaultValue: null, length: 255, alias: DDHV, type: esriFieldTypeString )
• su_aadt ( modelName: su_aadt, nullable: true, editable: true, defaultValue: null, length: 255, alias: SU_AADT, type: esriFieldTypeString )
• cu_aadt ( modelName: cu_aadt, nullable: true, editable: true, defaultValue: null, length: 255, alias: CU_AADT, type: esriFieldTypeString )
• year_last_act ( modelName: year_last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: YEAR_LAST_ACT, type: esriFieldTypeString )
• month_last_act ( modelName: month_last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: MONTH_LAST_ACT, type: esriFieldTypeString )
• day_last_act ( modelName: day_last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: DAY_LAST_ACT, type: esriFieldTypeString )
• aadt_last_act ( modelName: aadt_last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: AADT_LAST_ACT, type: esriFieldTypeString )
• k_factor ( modelName: k_factor, nullable: true, editable: true, defaultValue: null, length: 255, alias: K_FACTOR, type: esriFieldTypeString )
• d_factor ( modelName: d_factor, nullable: true, editable: true, defaultValue: null, length: 255, alias: D_FACTOR, type: esriFieldTypeString )
• year_2last_act ( modelName: year_2last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: YEAR_2LAST_ACT, type: esriFieldTypeString )
• aadt_2last_act ( modelName: aadt_2last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: AADT_2LAST_ACT, type: esriFieldTypeString )
• year_3last_act ( modelName: year_3last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: YEAR_3LAST_ACT, type: esriFieldTypeString )
• aadt_3last_act ( modelName: aadt_3last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: AADT_3LAST_ACT, type: esriFieldTypeString )
• year_4last_act ( modelName: year_4last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: YEAR_4LAST_ACT, type: esriFieldTypeString )
• aadt_4last_act ( modelName: aadt_4last_act, nullable: true, editable: true, defaultValue: null, length: 255, alias: AADT_4LAST_ACT, type: esriFieldTypeString )
• class_count_yr ( modelName: class_count_yr, nullable: true, editable: true, defaultValue: null, length: 255, alias: CLASS_COUNT_YR, type: esriFieldTypeString )
• class_count_month ( modelName: class_count_month, nullable: true, editable: true, defaultValue: null, length: 255, alias: CLASS_COUNT_MONTH, type: esriFieldTypeString )
• class_count_day ( modelName: class_count_day, nullable: true, editable: true, defaultValue: null, length: 255, alias: CLASS_COUNT_DAY, type: esriFieldTypeString )
• avg_wkday_f3_13 ( modelName: avg_wkday_f3_13, nullable: true, editable: true, defaultValue: null, length: 255, alias: AVG_WKDAY_F3_13, type: esriFieldTypeString )
• act_avg_truck_perc ( modelName: act_avg_truck_perc, nullable: true, editable: true, defaultValue: null, length: 255, alias: ACT_AVG_TRUCK_PERC, type: esriFieldTypeString )
• act_avg_su_perc ( modelName: act_avg_su_perc, nullable: true, editable: true, defaultValue: null, length: 255, alias: ACT_AVG_SU_PERC, type: esriFieldTypeString )
• act_avg_cu_perc ( modelName: act_avg_cu_perc, nullable: true, editable: true, defaultValue: null, length: 255, alias: ACT_AVG_CU_PERC, type: esriFieldTypeString )
• act_avg_mc_perc ( modelName: act_avg_mc_perc, nullable: true, editable: true, defaultValue: null, length: 255, alias: ACT_AVG_MC_PERC, type: esriFieldTypeString )
• act_avg_car_perc ( modelName: act_avg_car_perc, nullable: true, editable: true, defaultValue: null, length: 255, alias: ACT_AVG_CAR_PERC, type: esriFieldTypeString )
• act_avg_lt_perc ( modelName: act_avg_lt_perc, nullable: true, editable: true, defaultValue: null, length: 255, alias: ACT_AVG_LT_PERC, type: esriFieldTypeString )
• act_avg_bus_perc ( modelName: act_avg_bus_perc, nullable: true, editable: true, defaultValue: null, length: 255, alias: ACT_AVG_BUS_PERC, type: esriFieldTypeString )
• avg_wkday_f5_7 ( modelName: avg_wkday_f5_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: AVG_WKDAY_F5_7, type: esriFieldTypeString )
• axle_factor ( modelName: axle_factor, nullable: true, editable: true, defaultValue: null, length: 255, alias: AXLE_FACTOR, type: esriFieldTypeString )
• su_peak ( modelName: su_peak, nullable: true, editable: true, defaultValue: null, length: 255, alias: SU_PEAK, type: esriFieldTypeString )
• cu_peak ( modelName: cu_peak, nullable: true, editable: true, defaultValue: null, length: 255, alias: CU_PEAK, type: esriFieldTypeString )
• ph_perc_f1 ( modelName: ph_perc_f1, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F1, type: esriFieldTypeString )
• ph_perc_f2 ( modelName: ph_perc_f2, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F2, type: esriFieldTypeString )
• ph_perc_f3 ( modelName: ph_perc_f3, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F3, type: esriFieldTypeString )
• ph_perc_f4 ( modelName: ph_perc_f4, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F4, type: esriFieldTypeString )
• ph_perc_f4_7 ( modelName: ph_perc_f4_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F4_7, type: esriFieldTypeString )
• ph_perc_f5_7 ( modelName: ph_perc_f5_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F5_7, type: esriFieldTypeString )
• ph_perc_f8_13 ( modelName: ph_perc_f8_13, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F8_13, type: esriFieldTypeString )
• ph_perc_f4_13 ( modelName: ph_perc_f4_13, nullable: true, editable: true, defaultValue: null, length: 255, alias: PH_PERC_F4_13, type: esriFieldTypeString )
• class_est_yr ( modelName: class_est_yr, nullable: true, editable: true, defaultValue: null, length: 255, alias: CLASS_EST_YR, type: esriFieldTypeString )
• est_rg_fc_su ( modelName: est_rg_fc_su, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_SU, type: esriFieldTypeString )
• est_rg_fc_cu ( modelName: est_rg_fc_cu, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_CU, type: esriFieldTypeString )
• est_rg_fc_truck ( modelName: est_rg_fc_truck, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_TRUCK, type: esriFieldTypeString )
• est_rg_fc_su_peak ( modelName: est_rg_fc_su_peak, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_SU_PEAK, type: esriFieldTypeString )
• est_rg_fc_cu_peak ( modelName: est_rg_fc_cu_peak, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_CU_PEAK, type: esriFieldTypeString )
• est_rg_fc_axle_factr ( modelName: est_rg_fc_axle_factr, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_AXLE_FACTR, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f1 ( modelName: est_rg_fc_ph_perc_f1, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F1, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f2 ( modelName: est_rg_fc_ph_perc_f2, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F2, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f3 ( modelName: est_rg_fc_ph_perc_f3, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F3, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f4 ( modelName: est_rg_fc_ph_perc_f4, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F4, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f4_7 ( modelName: est_rg_fc_ph_perc_f4_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F4_7, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f5_7 ( modelName: est_rg_fc_ph_perc_f5_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F5_7, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f8_13 ( modelName: est_rg_fc_ph_perc_f8_13, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F8_13, type: esriFieldTypeString )
• est_rg_fc_ph_perc_f4_13 ( modelName: est_rg_fc_ph_perc_f4_13, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_RG_FC_PH_PERC_F4_13, type: esriFieldTypeString )
• est_fc_su ( modelName: est_fc_su, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_SU, type: esriFieldTypeString )
• est_fc_cu ( modelName: est_fc_cu, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_CU, type: esriFieldTypeString )
• est_fc_truck ( modelName: est_fc_truck, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_TRUCK, type: esriFieldTypeString )
• est_fc_su_peak ( modelName: est_fc_su_peak, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_SU_PEAK, type: esriFieldTypeString )
• est_fc_cu_peak ( modelName: est_fc_cu_peak, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_CU_PEAK, type: esriFieldTypeString )
• est_fc_axle_factr ( modelName: est_fc_axle_factr, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_AXLE_FACTR, type: esriFieldTypeString )
• est_fc_ph_perc_f1 ( modelName: est_fc_ph_perc_f1, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F1, type: esriFieldTypeString )
• est_fc_ph_perc_f2 ( modelName: est_fc_ph_perc_f2, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F2, type: esriFieldTypeString )
• est_fc_ph_perc_f3 ( modelName: est_fc_ph_perc_f3, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F3, type: esriFieldTypeString )
• est_fc_ph_perc_f4 ( modelName: est_fc_ph_perc_f4, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F4, type: esriFieldTypeString )
• est_fc_ph_perc_f4_7 ( modelName: est_fc_ph_perc_f4_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F4_7, type: esriFieldTypeString )
• est_fc_ph_perc_f5_7 ( modelName: est_fc_ph_perc_f5_7, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F5_7, type: esriFieldTypeString )
• est_fc_ph_perc_f8_13 ( modelName: est_fc_ph_perc_f8_13, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F8_13, type: esriFieldTypeString )
• est_fc_ph_perc_f4_13 ( modelName: est_fc_ph_perc_f4_13, nullable: true, editable: true, defaultValue: null, length: 255, alias: EST_FC_PH_PERC_F4_13, type: esriFieldTypeString )
• speed_count_yr ( modelName: speed_count_yr, nullable: true, editable: true, defaultValue: null, length: 255, alias: SPEED_COUNT_YR, type: esriFieldTypeString )
• speed_limit ( modelName: speed_limit, nullable: true, editable: true, defaultValue: null, length: 255, alias: SPEED_LIMIT, type: esriFieldTypeString )
• avg_speed ( modelName: avg_speed, nullable: true, editable: true, defaultValue: null, length: 255, alias: AVG_SPEED, type: esriFieldTypeString )
• perc_speed_50 ( modelName: perc_speed_50, nullable: true, editable: true, defaultValue: null, length: 255, alias: PERC_SPEED_50, type: esriFieldTypeString )
• perc_speed_85 ( modelName: perc_speed_85, nullable: true, editable: true, defaultValue: null, length: 255, alias: PERC_SPEED_85, type: esriFieldTypeString )
• exceeding_55 ( modelName: exceeding_55, nullable: true, editable: true, defaultValue: null, length: 255, alias: EXCEEDING_55, type: esriFieldTypeString )
• exceeding_65 ( modelName: exceeding_65, nullable: true, editable: true, defaultValue: null, length: 255, alias: EXCEEDING_65, type: esriFieldTypeString )
• avg_k_factor ( modelName: avg_k_factor, nullable: true, editable: true, defaultValue: null, length: 255, alias: AVG_K_FACTOR, type: esriFieldTypeString )
• avg_d_factor ( modelName: avg_d_factor, nullable: true, editable: true, defaultValue: null, length: 255, alias: AVG_D_FACTOR, type: esriFieldTypeString )
• dd_id ( modelName: dd_id, nullable: true, editable: true, defaultValue: null, alias: DD_ID, type: esriFieldTypeInteger )
• avg_above_posted ( modelName: avg_above_posted, nullable: true, editable: true, defaultValue: null, alias: avg above posted, type: esriFieldTypeDouble )

Templates:

• Name: Count_Stats_2022
  Description:
  Prototype:
  k_factor: null
  year_3last_act: null
  est_fc_truck: null
  day_last_act: null
  est_rg_fc_cu_peak: null
  est_rg_fc_ph_perc_f8_13: null
  dd_id: null
  est_rg_fc_cu: null
  exceeding_65: null
  est_rg_fc_ph_perc_f4_13: null
  cu_peak: null
  act_avg_cu_perc: null
  su_aadt: null
  est_fc_ph_perc_f2: null
  aadt_2last_act: null
  class_count_day: null
  est_fc_ph_perc_f1: null
  est_rg_fc_ph_perc_f5_7: null
  est_fc_ph_perc_f4: null
  est_fc_ph_perc_f3: null
  aadt: null
  act_avg_bus_perc: null
  su_peak: null
  ph_perc_f4_13: null
  ddhv: null
  speed_limit: null
  class_est_yr: null
  count_stats_id: null
  oneway_flag: null
  ae_flag: null
  est_rg_fc_su_peak: null
  federal_direction: null
  perc_speed_85: null
  aadt_4last_act: null
  axle_factor: null
  ph_perc_f5_7: null
  exceeding_55: null
  avg_wkday_f5_7: null
  full_count: null
  est_rg_fc_axle_factr: null
  est_fc_ph_perc_f4_7: null
  class_count_month: null
  ph_perc_f2: null
  ph_perc_f3: null
  rcsta: null
  ph_perc_f1: null
  region: null
  fc: null
  avg_k_factor: null
  month_last_act: null
  fg: null
  est_fc_cu_peak: null
  county_code: null
  cu_aadt: null
  avg_wkday_f3_13: null
  ph_perc_f4: null
  year_4last_act: null
  est_fc_su: null
  perc_speed_50: null
  year_2last_act: null
  est_rg_fc_ph_perc_f3: null
  est_rg_fc_ph_perc_f4: null
  est_rg_fc_ph_perc_f1: null
  calculation_year: null
  est_rg_fc_ph_perc_f2: null
  county_fips: null
  aadt_3last_act: null
  est_rg_fc_truck: null
  avg_above_posted: null
  station: null
  act_avg_su_perc: null
  est_fc_cu: null
  act_avg_truck_perc: null
  est_rg_fc_ph_perc_f4_7: null
  ph_perc_f8_13: null
  ccsta: null
  avg_speed: null
  year_last_act: null
  act_avg_mc_perc: null
  aadt_last_act: null
  speed_count_yr: null
  est_fc_axle_factr: null
  ph_perc_f4_7: null
  avg_d_factor: null
  dhv: null
  d_factor: null
  act_avg_lt_perc: null
  est_fc_ph_perc_f4_13: null
  est_fc_su_peak: null
  est_fc_ph_perc_f5_7: null
  act_avg_car_perc: null
  est_fc_ph_perc_f8_13: null
  est_rg_fc_su: null
  class_count_yr: null
  region_code: 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

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