{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "TrafficSignalInfo", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "munOwnAndOpSgnl", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "munOwnAndOpSgnl", "type": "esriFieldTypeString", "alias": "Municipality Own And Operate Signals", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "munOwnAndOpSgnl" }, { "name": "munOwnAndOpSgnlExpln", "type": "esriFieldTypeString", "alias": "Explanation Of Municipality Not Own And Operate Signals", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "munOwnAndOpSgnlExpln" }, { "name": "availTrafficSgnlInfo", "type": "esriFieldTypeString", "alias": "Currently Available Traffic Signal Information", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "availTrafficSgnlInfo" }, { "name": "availTrafficSgnlInfoOthrExpln", "type": "esriFieldTypeString", "alias": "Explanation Of Other Traffic Signal Information", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "availTrafficSgnlInfoOthrExpln" }, { "name": "congDurationAtSgnl", "type": "esriFieldTypeString", "alias": "Congestion Duration At Signals", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "congDurationAtSgnl" }, { "name": "congDurationAtSgnlOthrExpln", "type": "esriFieldTypeString", "alias": "Explanation Of Other Congestion Duration", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "congDurationAtSgnlOthrExpln" }, { "name": "sgnlWorkingVehDetect", "type": "esriFieldTypeString", "alias": "Signals Have Working Vehicle Detection", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "sgnlWorkingVehDetect" }, { "name": "sgnlWorkingVehDetectOpt", "type": "esriFieldTypeString", "alias": "Working Vehicle Detection List Type Of Yes", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "sgnlWorkingVehDetectOpt" }, { "name": "sgnlWorkingVehDetectPartialOpt", "type": "esriFieldTypeString", "alias": "Working Vehicle Detection List Type Of Partial", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "sgnlWorkingVehDetectPartialOpt" }, { "name": "sgnlCoordinated", "type": "esriFieldTypeString", "alias": "Signals Coordinated", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "sgnlCoordinated" }, { "name": "sgnlCoordinatedOpt", "type": "esriFieldTypeString", "alias": "Signals Coordinated List Type Of Yes", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "sgnlCoordinatedOpt" }, { "name": "sgnlAdjacentToOther", "type": "esriFieldTypeString", "alias": "Signals Adjacent To Other Signals", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "sgnlAdjacentToOther" }, { "name": "sgnlAdjacentToOtherOpt", "type": "esriFieldTypeString", "alias": "Signals Adjacent To Other Signals List Type Of Yes", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "sgnlAdjacentToOtherOpt" }, { "name": "sgnlOpEmergencyPAndT", "type": "esriFieldTypeString", "alias": "Signals Operate With Emergency Preemption Or Transit", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "sgnlOpEmergencyPAndT" }, { "name": "sgnlOpEmergencyPAndTOpt", "type": "esriFieldTypeString", "alias": "Signals Operate With Emergency List Type Of Yes", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "sgnlOpEmergencyPAndTOpt" }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "ProjectID\t36\ttext\nStepID \t\t50\ttext\nIsComplete\t\tshort int dbool", "domain": null, "editable": true, "nullable": true, "length": 36, "defaultValue": null, "modelName": "ProjectID" }, { "name": "StepID", "type": "esriFieldTypeString", "alias": "StepID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StepID" }, { "name": "IsComplete", "type": "esriFieldTypeSmallInteger", "alias": "IsComplete", "domain": { "type": "codedValue", "name": "dBooleanValue", "description": "Valid values are True and False.", "codedValues": [ { "name": "false", "code": 0 }, { "name": "true", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsComplete" }, { "name": "congDurationAtSgnlWeekendExpln", "type": "esriFieldTypeString", "alias": "congDurationAtSgnlWeekendExpln", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "congDurationAtSgnlWeekendExpln" }, { "name": "congDurationAtSgnlSEExpln", "type": "esriFieldTypeString", "alias": "congDurationAtSgnlSEExpln", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "congDurationAtSgnlSEExpln" }, { "name": "fixedTransitRouteSgnl", "type": "esriFieldTypeString", "alias": "fixedTransitRouteSgnl", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "fixedTransitRouteSgnl" }, { "name": "fixedTransitRouteSgnlOpt", "type": "esriFieldTypeString", "alias": "fixedTransitRouteSgnlOpt", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "fixedTransitRouteSgnlOpt" }, { "name": "munUtilizeSgnl", "type": "esriFieldTypeString", "alias": "munUtilizeSgnl", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "munUtilizeSgnl" }, { "name": "munUtilizeSgnlExpln", "type": "esriFieldTypeString", "alias": "munUtilizeSgnlExpln", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "munUtilizeSgnlExpln" }, { "name": "saSchoolOpt", "type": "esriFieldTypeString", "alias": "saSchoolOpt", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "saSchoolOpt" }, { "name": "saSeniorDestinationOpt", "type": "esriFieldTypeString", "alias": "saSeniorDestinationOpt", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "saSeniorDestinationOpt" }, { "name": "saTransitStopOpt", "type": "esriFieldTypeString", "alias": "saTransitStopOpt", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "saTransitStopOpt" }, { "name": "saMultFmlyHousDevlpOpt", "type": "esriFieldTypeString", "alias": "saMultFmlyHousDevlpOpt", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "saMultFmlyHousDevlpOpt" }, { "name": "saHSIPClusterLocOpt", "type": "esriFieldTypeString", "alias": "saHSIPClusterLocOpt", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "saHSIPClusterLocOpt" }, { "name": "saHSIPClusterLoc", "type": "esriFieldTypeString", "alias": "saHSIPClusterLoc", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "saHSIPClusterLoc" }, { "name": "saMultFmlyHousDevlp", "type": "esriFieldTypeString", "alias": "saMultFmlyHousDevlp", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "saMultFmlyHousDevlp" }, { "name": "saTransitStop", "type": "esriFieldTypeString", "alias": "saTransitStop", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "saTransitStop" }, { "name": "saSeniorDestination", "type": "esriFieldTypeString", "alias": "saSeniorDestination", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "saSeniorDestination" }, { "name": "saSchool", "type": "esriFieldTypeString", "alias": "saSchool", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "saSchool" }, { "name": "TrafficSignalInfoApprovedBy", "type": "esriFieldTypeString", "alias": "TrafficSignalInfoApprovedBy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TrafficSignalInfoApprovedBy" }, { "name": "TrafficSignalInfoDateApproved", "type": "esriFieldTypeDate", "alias": "TrafficSignalInfoDateApproved", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TrafficSignalInfoDateApproved" } ], "indexes": [ { "name": "R189_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "TrafficSignalInfo", "description": "", "prototype": { "attributes": { "TrafficSignalInfoApprovedBy": null, "TrafficSignalInfoDateApproved": null, "munOwnAndOpSgnl": null, "munOwnAndOpSgnlExpln": null, "availTrafficSgnlInfo": null, "availTrafficSgnlInfoOthrExpln": null, "congDurationAtSgnl": null, "congDurationAtSgnlOthrExpln": null, "sgnlWorkingVehDetect": null, "sgnlWorkingVehDetectOpt": null, "sgnlWorkingVehDetectPartialOpt": null, "sgnlCoordinated": null, "sgnlCoordinatedOpt": null, "sgnlAdjacentToOther": null, "sgnlAdjacentToOtherOpt": null, "sgnlOpEmergencyPAndT": null, "sgnlOpEmergencyPAndTOpt": null, "ProjectID": null, "StepID": null, "IsComplete": null, "congDurationAtSgnlWeekendExpln": null, "congDurationAtSgnlSEExpln": null, "fixedTransitRouteSgnl": null, "fixedTransitRouteSgnlOpt": null, "munUtilizeSgnl": null, "munUtilizeSgnlExpln": null, "saSchoolOpt": null, "saSeniorDestinationOpt": null, "saTransitStopOpt": null, "saMultFmlyHousDevlpOpt": null, "saHSIPClusterLocOpt": null, "saHSIPClusterLoc": null, "saMultFmlyHousDevlp": null, "saTransitStop": null, "saSeniorDestination": null, "saSchool": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "52a9435a94e84733be7ce94b8d028452" }