{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 7, "name": "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": "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": "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": "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": "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": "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": "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": "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": 2, "name": "Signs", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "SIGNID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{50F9905B-E5EA-43BE-BC3B-BB90188A0DAE}" } ], "capabilities": "Data,Map,Query", "maxRecordCount": 5000, "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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1652714308000 } }