{ "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" }, "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": "UTC", "respectsDaylightSaving": false }, "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 }