Name: Speed Statistics

Display Field: COUNT_ID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 78ccda26e72e41d6a383567e7f592948

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: 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 )
• COUNT_ID ( type: esriFieldTypeString, alias: COUNT_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COUNT_ID )
• REGION ( type: esriFieldTypeString, alias: REGION, editable: true, nullable: true, length: 2, defaultValue: null, modelName: REGION )
• REGION_CODE ( type: esriFieldTypeDouble, alias: REGION_CODE, editable: true, nullable: true, defaultValue: null, modelName: REGION_CODE )
• COUNTY_CODE ( type: esriFieldTypeDouble, alias: COUNTY_CODE, editable: true, nullable: true, defaultValue: null, modelName: COUNTY_CODE )
• STATION ( type: esriFieldTypeString, alias: STATION, editable: true, nullable: true, length: 4, defaultValue: null, modelName: STATION )
• RCSTA ( type: esriFieldTypeString, alias: RCSTA, editable: true, nullable: true, length: 6, defaultValue: null, modelName: RCSTA )
• FUNCTIONAL_CLASS ( type: esriFieldTypeDouble, alias: FUNCTIONAL_CLASS, editable: true, nullable: true, defaultValue: null, modelName: FUNCTIONAL_CLASS )
• FACTOR_GROUP ( type: esriFieldTypeDouble, alias: FACTOR_GROUP, editable: true, nullable: true, defaultValue: null, modelName: FACTOR_GROUP )
• LATITUDE ( type: esriFieldTypeString, alias: LATITUDE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeString, alias: LONGITUDE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LONGITUDE )
• SPECIFIC_RECORDER_PLACEMENT ( type: esriFieldTypeString, alias: SPECIFIC_RECORDER_PLACEMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SPECIFIC_RECORDER_PLACEMENT )
• CHANNEL_NOTES ( type: esriFieldTypeString, alias: CHANNEL_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CHANNEL_NOTES )
• DATA_TYPE ( type: esriFieldTypeString, alias: DATA_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATA_TYPE )
• SPEED_LIMIT ( type: esriFieldTypeString, alias: SPEED_LIMIT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SPEED_LIMIT )
• YEAR_ ( type: esriFieldTypeDouble, alias: YEAR_, editable: true, nullable: true, defaultValue: null, modelName: YEAR_ )
• MONTH_ ( type: esriFieldTypeDouble, alias: MONTH_, editable: true, nullable: true, defaultValue: null, modelName: MONTH_ )
• DAY_OF_FIRST_DATA ( type: esriFieldTypeDouble, alias: DAY_OF_FIRST_DATA, editable: true, nullable: true, defaultValue: null, modelName: DAY_OF_FIRST_DATA )
• FEDERAL_DIRECTION ( type: esriFieldTypeDouble, alias: FEDERAL_DIRECTION, editable: true, nullable: true, defaultValue: null, modelName: FEDERAL_DIRECTION , Coded Values: [0: Combined Total] , [9: Combined Total] , [1: Northbound] , ...3 more... )
• FULL_COUNT ( type: esriFieldTypeString, alias: FULL_COUNT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FULL_COUNT )
• AVG_WKDAY_BIN_1 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_1, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_1 )
• AVG_WKDAY_BIN_2 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_2, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_2 )
• AVG_WKDAY_BIN_3 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_3, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_3 )
• AVG_WKDAY_BIN_4 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_4, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_4 )
• AVG_WKDAY_BIN_5 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_5, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_5 )
• AVG_WKDAY_BIN_6 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_6, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_6 )
• AVG_WKDAY_BIN_7 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_7, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_7 )
• AVG_WKDAY_BIN_8 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_8, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_8 )
• AVG_WKDAY_BIN_9 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_9, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_9 )
• AVG_WKDAY_BIN_10 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_10, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_10 )
• AVG_WKDAY_BIN_11 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_11, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_11 )
• AVG_WKDAY_BIN_12 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_12, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_12 )
• AVG_WKDAY_BIN_13 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_13, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_13 )
• AVG_WKDAY_BIN_14 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_14, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_14 )
• AVG_WKDAY_BIN_15 ( type: esriFieldTypeDouble, alias: AVG_WKDAY_BIN_15, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_BIN_15 )
• AVG_WKDAY_UNCLASSIFIED ( type: esriFieldTypeDouble, alias: AVG_WKDAY_UNCLASSIFIED, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_UNCLASSIFIED )
• AVG_WKDAY_TOTALS ( type: esriFieldTypeDouble, alias: AVG_WKDAY_TOTALS, editable: true, nullable: true, defaultValue: null, modelName: AVG_WKDAY_TOTALS )
• AVG_SPEED ( type: esriFieldTypeDouble, alias: AVG_SPEED, editable: true, nullable: true, defaultValue: null, modelName: AVG_SPEED )
• FIFTYTH_PERCENTILE_SPEED ( type: esriFieldTypeDouble, alias: FIFTYTH_PERCENTILE_SPEED, editable: true, nullable: true, defaultValue: null, modelName: FIFTYTH_PERCENTILE_SPEED )
• EIGHTYFIVETH_PERCENTILE_SPEED ( type: esriFieldTypeDouble, alias: EIGHTYFIVETH_PERCENTILE_SPEED, editable: true, nullable: true, defaultValue: null, modelName: EIGHTYFIVETH_PERCENTILE_SPEED )
• PERCENTILE_EXCEEDING_55 ( type: esriFieldTypeDouble, alias: PERCENTILE_EXCEEDING_55, editable: true, nullable: true, defaultValue: null, modelName: PERCENTILE_EXCEEDING_55 )
• PERCENTILE_EXCEEDING_65 ( type: esriFieldTypeDouble, alias: PERCENTILE_EXCEEDING_65, editable: true, nullable: true, defaultValue: null, modelName: PERCENTILE_EXCEEDING_65 )
• FLAG_FIELD ( type: esriFieldTypeString, alias: FLAG_FIELD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLAG_FIELD )
• BATCH_ID ( type: esriFieldTypeDouble, alias: BATCH_ID, editable: true, nullable: true, defaultValue: null, modelName: BATCH_ID )

Templates:

• Name: Speed Statistics
  Description:
  Prototype:
  FLAG_FIELD: null
  BATCH_ID: null
  COUNT_ID: null
  REGION: null
  REGION_CODE: null
  COUNTY_CODE: null
  STATION: null
  RCSTA: null
  FUNCTIONAL_CLASS: null
  FACTOR_GROUP: null
  LATITUDE: null
  LONGITUDE: null
  SPECIFIC_RECORDER_PLACEMENT: null
  CHANNEL_NOTES: null
  DATA_TYPE: null
  SPEED_LIMIT: null
  YEAR_: null
  MONTH_: null
  DAY_OF_FIRST_DATA: null
  FEDERAL_DIRECTION: null
  FULL_COUNT: null
  AVG_WKDAY_BIN_1: null
  AVG_WKDAY_BIN_2: null
  AVG_WKDAY_BIN_3: null
  AVG_WKDAY_BIN_4: null
  AVG_WKDAY_BIN_5: null
  AVG_WKDAY_BIN_6: null
  AVG_WKDAY_BIN_7: null
  AVG_WKDAY_BIN_8: null
  AVG_WKDAY_BIN_9: null
  AVG_WKDAY_BIN_10: null
  AVG_WKDAY_BIN_11: null
  AVG_WKDAY_BIN_12: null
  AVG_WKDAY_BIN_13: null
  AVG_WKDAY_BIN_14: null
  AVG_WKDAY_BIN_15: null
  AVG_WKDAY_UNCLASSIFIED: null
  AVG_WKDAY_TOTALS: null
  AVG_SPEED: null
  FIFTYTH_PERCENTILE_SPEED: null
  EIGHTYFIVETH_PERCENTILE_SPEED: null
  PERCENTILE_EXCEEDING_55: null
  PERCENTILE_EXCEEDING_65: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

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:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata