{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 5, "name": "Speed Statistics", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "COUNT_ID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "COUNT_ID", "type": "esriFieldTypeString", "alias": "COUNT_ID", "length": 50, "domain": null }, { "name": "REGION", "type": "esriFieldTypeString", "alias": "REGION", "length": 2, "domain": null }, { "name": "REGION_CODE", "type": "esriFieldTypeDouble", "alias": "REGION_CODE", "domain": null }, { "name": "COUNTY_CODE", "type": "esriFieldTypeDouble", "alias": "COUNTY_CODE", "domain": null }, { "name": "STATION", "type": "esriFieldTypeString", "alias": "STATION", "length": 4, "domain": null }, { "name": "RCSTA", "type": "esriFieldTypeString", "alias": "RCSTA", "length": 6, "domain": null }, { "name": "FUNCTIONAL_CLASS", "type": "esriFieldTypeDouble", "alias": "FUNCTIONAL_CLASS", "domain": null }, { "name": "FACTOR_GROUP", "type": "esriFieldTypeDouble", "alias": "FACTOR_GROUP", "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeString", "alias": "LATITUDE", "length": 50, "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeString", "alias": "LONGITUDE", "length": 50, "domain": null }, { "name": "SPECIFIC_RECORDER_PLACEMENT", "type": "esriFieldTypeString", "alias": "SPECIFIC_RECORDER_PLACEMENT", "length": 255, "domain": null }, { "name": "CHANNEL_NOTES", "type": "esriFieldTypeString", "alias": "CHANNEL_NOTES", "length": 255, "domain": null }, { "name": "DATA_TYPE", "type": "esriFieldTypeString", "alias": "DATA_TYPE", "length": 50, "domain": null }, { "name": "SPEED_LIMIT", "type": "esriFieldTypeString", "alias": "SPEED_LIMIT", "length": 50, "domain": null }, { "name": "YEAR_", "type": "esriFieldTypeDouble", "alias": "YEAR_", "domain": null }, { "name": "MONTH_", "type": "esriFieldTypeDouble", "alias": "MONTH_", "domain": null }, { "name": "DAY_OF_FIRST_DATA", "type": "esriFieldTypeDouble", "alias": "DAY_OF_FIRST_DATA", "domain": null }, { "name": "FEDERAL_DIRECTION", "type": "esriFieldTypeDouble", "alias": "FEDERAL_DIRECTION", "domain": { "type": "codedValue", "name": "dFederalDirection", "description": "Federal Direction", "codedValues": [ { "name": "Combined Total", "code": 0 }, { "name": "Combined Total", "code": 9 }, { "name": "Northbound", "code": 1 }, { "name": "Eastbound", "code": 3 }, { "name": "Southbound", "code": 5 }, { "name": "Westbound", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FULL_COUNT", "type": "esriFieldTypeString", "alias": "FULL_COUNT", "length": 10, "domain": null }, { "name": "AVG_WKDAY_BIN_1", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_1", "domain": null }, { "name": "AVG_WKDAY_BIN_2", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_2", "domain": null }, { "name": "AVG_WKDAY_BIN_3", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_3", "domain": null }, { "name": "AVG_WKDAY_BIN_4", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_4", "domain": null }, { "name": "AVG_WKDAY_BIN_5", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_5", "domain": null }, { "name": "AVG_WKDAY_BIN_6", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_6", "domain": null }, { "name": "AVG_WKDAY_BIN_7", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_7", "domain": null }, { "name": "AVG_WKDAY_BIN_8", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_8", "domain": null }, { "name": "AVG_WKDAY_BIN_9", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_9", "domain": null }, { "name": "AVG_WKDAY_BIN_10", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_10", "domain": null }, { "name": "AVG_WKDAY_BIN_11", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_11", "domain": null }, { "name": "AVG_WKDAY_BIN_12", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_12", "domain": null }, { "name": "AVG_WKDAY_BIN_13", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_13", "domain": null }, { "name": "AVG_WKDAY_BIN_14", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_14", "domain": null }, { "name": "AVG_WKDAY_BIN_15", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_BIN_15", "domain": null }, { "name": "AVG_WKDAY_UNCLASSIFIED", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_UNCLASSIFIED", "domain": null }, { "name": "AVG_WKDAY_TOTALS", "type": "esriFieldTypeDouble", "alias": "AVG_WKDAY_TOTALS", "domain": null }, { "name": "AVG_SPEED", "type": "esriFieldTypeDouble", "alias": "AVG_SPEED", "domain": null }, { "name": "FIFTYTH_PERCENTILE_SPEED", "type": "esriFieldTypeDouble", "alias": "FIFTYTH_PERCENTILE_SPEED", "domain": null }, { "name": "EIGHTYFIVETH_PERCENTILE_SPEED", "type": "esriFieldTypeDouble", "alias": "EIGHTYFIVETH_PERCENTILE_SPEED", "domain": null }, { "name": "PERCENTILE_EXCEEDING_55", "type": "esriFieldTypeDouble", "alias": "PERCENTILE_EXCEEDING_55", "domain": null }, { "name": "PERCENTILE_EXCEEDING_65", "type": "esriFieldTypeDouble", "alias": "PERCENTILE_EXCEEDING_65", "domain": null }, { "name": "FLAG_FIELD", "type": "esriFieldTypeString", "alias": "FLAG_FIELD", "length": 50, "domain": null }, { "name": "BATCH_ID", "type": "esriFieldTypeDouble", "alias": "BATCH_ID", "domain": null } ], "indexes": [ { "name": "R68_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "GDW_Roadway.ROADWAY.TrafficStationCountStatistics", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "RCSTA", "cardinality": "esriRelCardinalityManyToMany", "composite": false }, { "id": 4, "name": "GDW_Roadway.ROADWAY.TrafficStationCountStatistics", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "RCSTA", "cardinality": "esriRelCardinalityManyToMany", "composite": false }, { "id": 7, "name": "GDW_Roadway.ROADWAY.TrafficStationCountStatistics", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "RCSTA", "cardinality": "esriRelCardinalityManyToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7d15bdd2d8c44c01b755744751b42cb7" }