{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 7,
"name": "TimeBands",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user",
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
}
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": true,
"relationships": [
{
"id": 2,
"name": "Signs",
"relatedTableId": 6,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "SIGNID",
"composite": true,
"catalogID": "{50F9905B-E5EA-43BE-BC3B-BB90188A0DAE}"
}
],
"isDataVersioned": false,
"isDataArchived": true,
"infoInEstimates": [
"count"
],
"isDataBranchVersioned": false,
"isDataReplicaTracked": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": true,
"archivingInfo": {
"supportsQueryWithHistoricMoment": true,
"startArchivingMoment": 1652714308000
},
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"supportsASyncCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsCurrentUserQueries": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsQueryAnalytic": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"advancedEditingCapabilities": {
"supportedSqlFormatsInCalculate": [
"standard"
],
"supportsAsyncApplyEdits": true,
"supportsApplyEditsbyUploadID": true,
"supportedApplyEditsUploadIDFormats": "JSON"
},
"hasMetadata": true,
"hasAttachments": false,
"supportsApplyEditsWithGlobalIds": true,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GLOBALID",
"displayField": "LINKID",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "LINKID",
"type": "esriFieldTypeString",
"alias": "LINKID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "LINKID"
},
{
"name": "HOURLIMIT",
"type": "esriFieldTypeDouble",
"alias": "HOURLIMIT",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "HOURLIMIT"
},
{
"name": "RESTRICTIONORDER",
"type": "esriFieldTypeInteger",
"alias": "RESTRICTIONORDER",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "RESTRICTIONORDER"
},
{
"name": "EXCEPTION",
"type": "esriFieldTypeSmallInteger",
"alias": "EXCEPTION",
"domain": {
"type": "codedValue",
"name": "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"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "EXCEPTION"
},
{
"name": "GLOBALID",
"type": "esriFieldTypeGlobalID",
"alias": "GLOBALID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GLOBALID"
},
{
"name": "ORIGIN_ID",
"type": "esriFieldTypeString",
"alias": "ORIGIN_ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "ORIGIN_ID"
},
{
"name": "SPACEID",
"type": "esriFieldTypeString",
"alias": "SpaceID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "SPACEID"
},
{
"name": "SPACEARROW",
"type": "esriFieldTypeInteger",
"alias": "SPACEARROW",
"domain": {
"type": "codedValue",
"name": "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"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SPACEARROW"
},
{
"name": "RESTRICTIONSTATUS",
"type": "esriFieldTypeInteger",
"alias": "RESTRICTIONSTATUS",
"domain": {
"type": "codedValue",
"name": "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"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "RESTRICTIONSTATUS"
},
{
"name": "SIGNID",
"type": "esriFieldTypeGUID",
"alias": "SIGNID",
"domain": null,
"editable": true,
"nullable": true,
"length": 38,
"defaultValue": null,
"modelName": "SIGNID"
},
{
"name": "STARTDAY",
"type": "esriFieldTypeInteger",
"alias": "STARTDAY",
"domain": {
"type": "codedValue",
"name": "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"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "STARTDAY1"
},
{
"name": "ENDDAY",
"type": "esriFieldTypeInteger",
"alias": "ENDDAY",
"domain": {
"type": "codedValue",
"name": "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"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ENDDAY1"
},
{
"name": "STARTTIME",
"type": "esriFieldTypeInteger",
"alias": "STARTTIME",
"domain": {
"type": "codedValue",
"name": "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"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "STARTHOUR1"
},
{
"name": "ENDTIME",
"type": "esriFieldTypeInteger",
"alias": "ENDTIME",
"domain": {
"type": "codedValue",
"name": "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"
},
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "ENDHOUR1"
},
{
"name": "CREATED_USER",
"type": "esriFieldTypeString",
"alias": "CREATED_USER",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "CREATED_USER"
},
{
"name": "CREATED_DATE",
"type": "esriFieldTypeDate",
"alias": "CREATED_DATE",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "CREATED_DATE"
},
{
"name": "LAST_EDITED_USER",
"type": "esriFieldTypeString",
"alias": "LAST_EDITED_USER",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "LAST_EDITED_USER"
},
{
"name": "LAST_EDITED_DATE",
"type": "esriFieldTypeDate",
"alias": "LAST_EDITED_DATE",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "LAST_EDITED_DATE"
},
{
"name": "SIGNWORKS_CREATED_BY",
"type": "esriFieldTypeString",
"alias": "SIGNWORKS_CREATED_BY",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "SIGNWORKS_CREATED_BY"
},
{
"name": "SIGNWORKS_LAST_EDITED_BY",
"type": "esriFieldTypeString",
"alias": "SIGNWORKS_LAST_EDITED_BY",
"domain": null,
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "SIGNWORKS_LAST_EDITED_BY"
}
],
"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": ""
}
],
"datesInUnknownTimezone": false,
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"types": [],
"templates": [
{
"name": "TimeBands",
"description": "",
"prototype": {
"attributes": {
"SIGNWORKS_CREATED_BY": null,
"ENDTIME": null,
"LINKID": null,
"HOURLIMIT": null,
"RESTRICTIONORDER": null,
"EXCEPTION": null,
"SIGNWORKS_LAST_EDITED_BY": null,
"ORIGIN_ID": null,
"SPACEID": null,
"SPACEARROW": null,
"RESTRICTIONSTATUS": null,
"SIGNID": null,
"STARTDAY": null,
"ENDDAY": null,
"STARTTIME": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 5000,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
"capabilities": "Query,ChangeTracking",
"useStandardizedQueries": true,
"bigIntegerRestrictedTo53Bits": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 5000,
"maxRecordCountFactor": 1
}