{ "currentVersion": 10.71, "id": 1, "name": "Assets.DBO.TrafficCameraSummary", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "site", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "site", "type": "esriFieldTypeString", "alias": "site", "length": 1073741822, "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "ID", "length": 1073741822, "domain": null }, { "name": "small_vehicles", "type": "esriFieldTypeInteger", "alias": "small_vehicles", "domain": null }, { "name": "large_vehicles", "type": "esriFieldTypeInteger", "alias": "large_vehicles", "domain": null }, { "name": "total_vehicles", "type": "esriFieldTypeInteger", "alias": "total_vehicles", "domain": null }, { "name": "red_and_speed_violations", "type": "esriFieldTypeInteger", "alias": "red_and_speed_violations", "domain": null }, { "name": "red_violations", "type": "esriFieldTypeInteger", "alias": "red_violations", "domain": null }, { "name": "speed_violations", "type": "esriFieldTypeInteger", "alias": "speed_violations", "domain": null }, { "name": "total_violations", "type": "esriFieldTypeInteger", "alias": "total_violations", "domain": null }, { "name": "max_speed", "type": "esriFieldTypeInteger", "alias": "max_speed", "domain": null }, { "name": "S0_9", "type": "esriFieldTypeInteger", "alias": "S0_9", "domain": null }, { "name": "S10_19", "type": "esriFieldTypeInteger", "alias": "S10_19", "domain": null }, { "name": "S20_29", "type": "esriFieldTypeInteger", "alias": "S20_29", "domain": null }, { "name": "S30_39", "type": "esriFieldTypeInteger", "alias": "S30_39", "domain": null }, { "name": "S40_49", "type": "esriFieldTypeInteger", "alias": "S40_49", "domain": null }, { "name": "S50_59", "type": "esriFieldTypeInteger", "alias": "S50_59", "domain": null }, { "name": "S60_69", "type": "esriFieldTypeInteger", "alias": "S60_69", "domain": null }, { "name": "S70_79", "type": "esriFieldTypeInteger", "alias": "S70_79", "domain": null }, { "name": "S80_89", "type": "esriFieldTypeInteger", "alias": "S80_89", "domain": null }, { "name": "S90_99", "type": "esriFieldTypeInteger", "alias": "S90_99", "domain": null }, { "name": "S100_109", "type": "esriFieldTypeInteger", "alias": "S100_109", "domain": null }, { "name": "S110_119", "type": "esriFieldTypeInteger", "alias": "S110_119", "domain": null }, { "name": "S120_", "type": "esriFieldTypeInteger", "alias": "S120_", "domain": null }, { "name": "DateText", "type": "esriFieldTypeString", "alias": "DateText", "length": 12, "domain": null }, { "name": "date_", "type": "esriFieldTypeDate", "alias": "date_", "length": 8, "domain": null } ], "indexes": [ { "name": "R106_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "TrafficCameraLocation", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }