{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 22,
"name": "TOA.TimeBands",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "LINKID",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "LINKID",
"type": "esriFieldTypeString",
"alias": "LINKID",
"length": 50,
"domain": null
},
{
"name": "HOURLIMIT",
"type": "esriFieldTypeDouble",
"alias": "HOURLIMIT",
"domain": null
},
{
"name": "RESTRICTIONORDER",
"type": "esriFieldTypeInteger",
"alias": "RESTRICTIONORDER",
"domain": null
},
{
"name": "EXCEPTION",
"type": "esriFieldTypeSmallInteger",
"alias": "EXCEPTION",
"domain": {
"type": "codedValue",
"name": "WS1_ParkingExceptions",
"description": "List of possible exceptions to the current sign restriction",
"codedValues": [
{
"name": "Government (Fed)",
"code": 1
},
{
"name": "Government (DC)",
"code": 2
},
{
"name": "Theater",
"code": 3
},
{
"name": "Hospital",
"code": 4
},
{
"name": "Hotel",
"code": 5
},
{
"name": "Club/Restaurant",
"code": 6
},
{
"name": "Church",
"code": 7
},
{
"name": "Housing/Apartment",
"code": 8
},
{
"name": "Valet",
"code": 9
},
{
"name": "Embassy/Diplomatic",
"code": 10
},
{
"name": "Mobile Vending",
"code": 11
},
{
"name": "Loading Zone",
"code": 12
},
{
"name": "Other",
"code": 13
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"length": 38,
"domain": null
},
{
"name": "ORIGIN_ID",
"type": "esriFieldTypeString",
"alias": "ORIGIN_ID",
"length": 255,
"domain": null
},
{
"name": "SPACEID",
"type": "esriFieldTypeString",
"alias": "SpaceID",
"length": 50,
"domain": null
},
{
"name": "SPACEARROW",
"type": "esriFieldTypeInteger",
"alias": "SPACEARROW",
"domain": {
"type": "codedValue",
"name": "WS1_SignArrowDirection",
"description": "Direction of the signs arrow",
"codedValues": [
{
"name": "Left",
"code": 1
},
{
"name": "Right",
"code": 2
},
{
"name": "Bi-directional",
"code": 3
},
{
"name": "Up",
"code": 4
},
{
"name": "Down",
"code": 5
},
{
"name": "Diagonal, Left, Up",
"code": 6
},
{
"name": "Diagonal, Left, Down",
"code": 7
},
{
"name": "Diagonal, Right, Up",
"code": 8
},
{
"name": "Diagonal, Right, Down",
"code": 9
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "RESTRICTIONSTATUS",
"type": "esriFieldTypeInteger",
"alias": "RESTRICTIONSTATUS",
"domain": {
"type": "codedValue",
"name": "WS1_SignStatus",
"description": "Current Status of a Traffic Sign",
"codedValues": [
{
"name": "Active",
"code": 1
},
{
"name": "Prospective",
"code": 2
},
{
"name": "Temporarily Out of Service",
"code": 3
},
{
"name": "Temporary",
"code": 4
},
{
"name": "Retired",
"code": 5
},
{
"name": "Requested (New)",
"code": 6
},
{
"name": "Requested (Change)",
"code": 7
},
{
"name": "Requested (Remove)",
"code": 8
},
{
"name": "Requested (Swap)",
"code": 9
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "SIGNID",
"type": "esriFieldTypeGUID",
"alias": "SIGNID",
"length": 38,
"domain": null
},
{
"name": "STARTDAY",
"type": "esriFieldTypeInteger",
"alias": "STARTDAY",
"domain": {
"type": "codedValue",
"name": "WS1_SignWorks_Days",
"description": "SignWorks Days of the week (includes 'Anytime' and 'Schooldays')",
"codedValues": [
{
"name": "Monday",
"code": 1
},
{
"name": "Tuesday",
"code": 2
},
{
"name": "Wednesday",
"code": 3
},
{
"name": "Thursday",
"code": 4
},
{
"name": "Friday",
"code": 5
},
{
"name": "Saturday",
"code": 6
},
{
"name": "Sunday",
"code": 7
},
{
"name": "ANYTIME",
"code": 8
},
{
"name": "Schooldays",
"code": 9
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ENDDAY",
"type": "esriFieldTypeInteger",
"alias": "ENDDAY",
"domain": {
"type": "codedValue",
"name": "WS1_SignWorks_Days",
"description": "SignWorks Days of the week (includes 'Anytime' and 'Schooldays')",
"codedValues": [
{
"name": "Monday",
"code": 1
},
{
"name": "Tuesday",
"code": 2
},
{
"name": "Wednesday",
"code": 3
},
{
"name": "Thursday",
"code": 4
},
{
"name": "Friday",
"code": 5
},
{
"name": "Saturday",
"code": 6
},
{
"name": "Sunday",
"code": 7
},
{
"name": "ANYTIME",
"code": 8
},
{
"name": "Schooldays",
"code": 9
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "STARTTIME",
"type": "esriFieldTypeInteger",
"alias": "STARTTIME",
"domain": {
"type": "codedValue",
"name": "WS1_SignWorks_Hours",
"description": "SignWorks hours of the day (includes quarter hours)",
"codedValues": [
{
"name": "0400A",
"code": 1
},
{
"name": "0415A",
"code": 2
},
{
"name": "0430A",
"code": 3
},
{
"name": "0445A",
"code": 4
},
{
"name": "0500A",
"code": 5
},
{
"name": "0515A",
"code": 6
},
{
"name": "0530A",
"code": 7
},
{
"name": "0545A",
"code": 8
},
{
"name": "0600A",
"code": 9
},
{
"name": "0615A",
"code": 10
},
{
"name": "0630A",
"code": 11
},
{
"name": "0645A",
"code": 12
},
{
"name": "0700A",
"code": 13
},
{
"name": "0715A",
"code": 14
},
{
"name": "0730A",
"code": 15
},
{
"name": "0745A",
"code": 16
},
{
"name": "0800A",
"code": 17
},
{
"name": "0815A",
"code": 18
},
{
"name": "0830A",
"code": 19
},
{
"name": "0845A",
"code": 20
},
{
"name": "0900A",
"code": 21
},
{
"name": "0915A",
"code": 22
},
{
"name": "0930A",
"code": 23
},
{
"name": "0945A",
"code": 24
},
{
"name": "1000A",
"code": 25
},
{
"name": "1015A",
"code": 26
},
{
"name": "1030A",
"code": 27
},
{
"name": "1045A",
"code": 28
},
{
"name": "1100A",
"code": 29
},
{
"name": "1115A",
"code": 30
},
{
"name": "1130A",
"code": 31
},
{
"name": "1145A",
"code": 32
},
{
"name": "1200P",
"code": 33
},
{
"name": "1215P",
"code": 34
},
{
"name": "1230P",
"code": 35
},
{
"name": "1245P",
"code": 36
},
{
"name": "0100P",
"code": 37
},
{
"name": "0115P",
"code": 38
},
{
"name": "0130P",
"code": 39
},
{
"name": "0145P",
"code": 40
},
{
"name": "0200P",
"code": 41
},
{
"name": "0215P",
"code": 42
},
{
"name": "0230P",
"code": 43
},
{
"name": "0245P",
"code": 44
},
{
"name": "0300P",
"code": 45
},
{
"name": "0315P",
"code": 46
},
{
"name": "0330P",
"code": 47
},
{
"name": "0345P",
"code": 48
},
{
"name": "0400P",
"code": 49
},
{
"name": "0415P",
"code": 50
},
{
"name": "0430P",
"code": 51
},
{
"name": "0445P",
"code": 52
},
{
"name": "0500P",
"code": 53
},
{
"name": "0515P",
"code": 54
},
{
"name": "0530P",
"code": 55
},
{
"name": "0545P",
"code": 56
},
{
"name": "0600P",
"code": 57
},
{
"name": "0615P",
"code": 58
},
{
"name": "0630P",
"code": 59
},
{
"name": "0645P",
"code": 60
},
{
"name": "0700P",
"code": 61
},
{
"name": "0715P",
"code": 62
},
{
"name": "0730P",
"code": 63
},
{
"name": "0745P",
"code": 64
},
{
"name": "0800P",
"code": 65
},
{
"name": "0815P",
"code": 66
},
{
"name": "0830P",
"code": 67
},
{
"name": "0845P",
"code": 68
},
{
"name": "0900P",
"code": 69
},
{
"name": "0915P",
"code": 70
},
{
"name": "0930P",
"code": 71
},
{
"name": "0945P",
"code": 72
},
{
"name": "1000P",
"code": 73
},
{
"name": "1015P",
"code": 74
},
{
"name": "1030P",
"code": 75
},
{
"name": "1045P",
"code": 76
},
{
"name": "1100P",
"code": 77
},
{
"name": "1115P",
"code": 78
},
{
"name": "1130P",
"code": 79
},
{
"name": "1145P",
"code": 80
},
{
"name": "1200A",
"code": 81
},
{
"name": "1215A",
"code": 82
},
{
"name": "1230A",
"code": 83
},
{
"name": "1245A",
"code": 84
},
{
"name": "0100A",
"code": 85
},
{
"name": "0115A",
"code": 86
},
{
"name": "0130A",
"code": 87
},
{
"name": "0145A",
"code": 88
},
{
"name": "0200A",
"code": 89
},
{
"name": "0215A",
"code": 90
},
{
"name": "0230A",
"code": 91
},
{
"name": "0245A",
"code": 92
},
{
"name": "0300A",
"code": 93
},
{
"name": "0315A",
"code": 94
},
{
"name": "0330A",
"code": 95
},
{
"name": "0345A",
"code": 96
},
{
"name": "BLANK",
"code": 97
},
{
"name": "BLANK",
"code": 98
},
{
"name": "BLANK",
"code": 99
},
{
"name": "ANYTIME",
"code": 100
},
{
"name": "0000A",
"code": 0
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "ENDTIME",
"type": "esriFieldTypeInteger",
"alias": "ENDTIME",
"domain": {
"type": "codedValue",
"name": "WS1_SignWorks_Hours",
"description": "SignWorks hours of the day (includes quarter hours)",
"codedValues": [
{
"name": "0400A",
"code": 1
},
{
"name": "0415A",
"code": 2
},
{
"name": "0430A",
"code": 3
},
{
"name": "0445A",
"code": 4
},
{
"name": "0500A",
"code": 5
},
{
"name": "0515A",
"code": 6
},
{
"name": "0530A",
"code": 7
},
{
"name": "0545A",
"code": 8
},
{
"name": "0600A",
"code": 9
},
{
"name": "0615A",
"code": 10
},
{
"name": "0630A",
"code": 11
},
{
"name": "0645A",
"code": 12
},
{
"name": "0700A",
"code": 13
},
{
"name": "0715A",
"code": 14
},
{
"name": "0730A",
"code": 15
},
{
"name": "0745A",
"code": 16
},
{
"name": "0800A",
"code": 17
},
{
"name": "0815A",
"code": 18
},
{
"name": "0830A",
"code": 19
},
{
"name": "0845A",
"code": 20
},
{
"name": "0900A",
"code": 21
},
{
"name": "0915A",
"code": 22
},
{
"name": "0930A",
"code": 23
},
{
"name": "0945A",
"code": 24
},
{
"name": "1000A",
"code": 25
},
{
"name": "1015A",
"code": 26
},
{
"name": "1030A",
"code": 27
},
{
"name": "1045A",
"code": 28
},
{
"name": "1100A",
"code": 29
},
{
"name": "1115A",
"code": 30
},
{
"name": "1130A",
"code": 31
},
{
"name": "1145A",
"code": 32
},
{
"name": "1200P",
"code": 33
},
{
"name": "1215P",
"code": 34
},
{
"name": "1230P",
"code": 35
},
{
"name": "1245P",
"code": 36
},
{
"name": "0100P",
"code": 37
},
{
"name": "0115P",
"code": 38
},
{
"name": "0130P",
"code": 39
},
{
"name": "0145P",
"code": 40
},
{
"name": "0200P",
"code": 41
},
{
"name": "0215P",
"code": 42
},
{
"name": "0230P",
"code": 43
},
{
"name": "0245P",
"code": 44
},
{
"name": "0300P",
"code": 45
},
{
"name": "0315P",
"code": 46
},
{
"name": "0330P",
"code": 47
},
{
"name": "0345P",
"code": 48
},
{
"name": "0400P",
"code": 49
},
{
"name": "0415P",
"code": 50
},
{
"name": "0430P",
"code": 51
},
{
"name": "0445P",
"code": 52
},
{
"name": "0500P",
"code": 53
},
{
"name": "0515P",
"code": 54
},
{
"name": "0530P",
"code": 55
},
{
"name": "0545P",
"code": 56
},
{
"name": "0600P",
"code": 57
},
{
"name": "0615P",
"code": 58
},
{
"name": "0630P",
"code": 59
},
{
"name": "0645P",
"code": 60
},
{
"name": "0700P",
"code": 61
},
{
"name": "0715P",
"code": 62
},
{
"name": "0730P",
"code": 63
},
{
"name": "0745P",
"code": 64
},
{
"name": "0800P",
"code": 65
},
{
"name": "0815P",
"code": 66
},
{
"name": "0830P",
"code": 67
},
{
"name": "0845P",
"code": 68
},
{
"name": "0900P",
"code": 69
},
{
"name": "0915P",
"code": 70
},
{
"name": "0930P",
"code": 71
},
{
"name": "0945P",
"code": 72
},
{
"name": "1000P",
"code": 73
},
{
"name": "1015P",
"code": 74
},
{
"name": "1030P",
"code": 75
},
{
"name": "1045P",
"code": 76
},
{
"name": "1100P",
"code": 77
},
{
"name": "1115P",
"code": 78
},
{
"name": "1130P",
"code": 79
},
{
"name": "1145P",
"code": 80
},
{
"name": "1200A",
"code": 81
},
{
"name": "1215A",
"code": 82
},
{
"name": "1230A",
"code": 83
},
{
"name": "1245A",
"code": 84
},
{
"name": "0100A",
"code": 85
},
{
"name": "0115A",
"code": 86
},
{
"name": "0130A",
"code": 87
},
{
"name": "0145A",
"code": 88
},
{
"name": "0200A",
"code": 89
},
{
"name": "0215A",
"code": 90
},
{
"name": "0230A",
"code": 91
},
{
"name": "0245A",
"code": 92
},
{
"name": "0300A",
"code": 93
},
{
"name": "0315A",
"code": 94
},
{
"name": "0330A",
"code": 95
},
{
"name": "0345A",
"code": 96
},
{
"name": "BLANK",
"code": 97
},
{
"name": "BLANK",
"code": 98
},
{
"name": "BLANK",
"code": 99
},
{
"name": "ANYTIME",
"code": 100
},
{
"name": "0000A",
"code": 0
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
}
},
{
"name": "CREATED_USER",
"type": "esriFieldTypeString",
"alias": "CREATED_USER",
"length": 255,
"domain": null
},
{
"name": "CREATED_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATED_DATE",
"length": 8,
"domain": null
},
{
"name": "LAST_EDITED_USER",
"type": "esriFieldTypeString",
"alias": "LAST_EDITED_USER",
"length": 255,
"domain": null
},
{
"name": "LAST_EDITED_DATE",
"type": "esriFieldTypeDate",
"alias": "LAST_EDITED_DATE",
"length": 8,
"domain": null
},
{
"name": "SIGNWORKS_CREATED_BY",
"type": "esriFieldTypeString",
"alias": "SIGNWORKS_CREATED_BY",
"length": 100,
"domain": null
},
{
"name": "SIGNWORKS_LAST_EDITED_BY",
"type": "esriFieldTypeString",
"alias": "SIGNWORKS_LAST_EDITED_BY",
"length": 100,
"domain": null
}
],
"indexes": [
{
"name": "UUID_314",
"fields": "GLOBALID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "G973SIGNID",
"fields": "SIGNID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "gdb_ct3_314",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 1,
"name": "Signs",
"relatedTableId": 21,
"role": "esriRelRoleDestination",
"keyField": "SIGNID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": true,
"catalogID": "{50F9905B-E5EA-43BE-BC3B-BB90188A0DAE}"
}
],
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"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,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1652714308000
}
}