{
 "layers": [],
 "tables": [
  {
   "currentVersion": 11.5,
   "cimVersion": "3.5.0",
   "id": 0,
   "name": "Signals Projects",
   "type": "Table",
   "description": "The table has active (including proposed projects) and completed traffic signal projects post 2011. Projects with current schedule phase of \"Design missing dates\" are excluded from this dataset.",
   "copyrightText": "AEC Applications, Traffic Unit, EGIS",
   "editFieldsInfo": {
    "creationDateField": "created_date",
    "creatorField": "created_user",
    "editDateField": "last_edited_date",
    "editorField": "last_edited_user"
   },
   "ownershipBasedAccessControlForFeatures": null,
   "syncCanReturnChanges": true,
   "relationships": [],
   "isDataVersioned": true,
   "isDataArchived": false,
   "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,
    "supportsQueryWithDistance": true,
    "supportsReturningQueryExtent": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsCurrentUserQueries": true,
    "supportsFullTextSearch": true,
    "fullTextSearchCapabilities": {
     "supportsSearchOperator": true,
     "supportsOperator": false,
     "supportsSqlExpressionInFullText": true
    },
    "fullTextSearchableFields": [],
    "supportsQueryWithResultType": true,
    "supportsReturningGeometryCentroid": false,
    "supportsReturningGeometryEnvelope": false,
    "supportsSqlExpression": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsQueryAnalytic": true,
    "supportsQueryWithCacheHint": false
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": true,
    "supportsPercentileAnalytic": true
   },
   "advancedEditingCapabilities": {
    "supportedSqlFormatsInCalculate": [
     "standard"
    ],
    "supportsAsyncApplyEdits": true,
    "supportsApplyEditsbyUploadID": true,
    "supportedApplyEditsUploadIDFormats": "JSON,PBF"
   },
   "hasMetadata": true,
   "hasAttachments": false,
   "supportsApplyEditsWithGlobalIds": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "objectIdField": "OBJECTID",
   "globalIdField": "GlobalID",
   "displayField": "ProjectNumber",
   "typeIdField": "",
   "subtypeField": "",
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "defaultValue": null,
     "modelName": "OBJECTID"
    },
    {
     "name": "ProjectNumber",
     "type": "esriFieldTypeString",
     "alias": "Project Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 20,
     "defaultValue": null,
     "modelName": "ProjectNumber"
    },
    {
     "name": "ProposedProjectNumber",
     "type": "esriFieldTypeString",
     "alias": "Proposed Project Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 20,
     "defaultValue": null,
     "modelName": "ProposedProjectNumber"
    },
    {
     "name": "SignalNumber",
     "type": "esriFieldTypeString",
     "alias": "Signal Number",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 20,
     "defaultValue": null,
     "modelName": "SignalNumber"
    },
    {
     "name": "WorkType",
     "type": "esriFieldTypeString",
     "alias": "Work Type",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 10,
     "defaultValue": null,
     "modelName": "WorkType"
    },
    {
     "name": "WorkCodes",
     "type": "esriFieldTypeString",
     "alias": "Work Codes",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "WorkCodes"
    },
    {
     "name": "CurrentSchedulePhase",
     "type": "esriFieldTypeString",
     "alias": "Current Schedule Phase",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "CurrentSchedulePhase"
    },
    {
     "name": "ProjectTitle",
     "type": "esriFieldTypeString",
     "alias": "Project Title",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 255,
     "defaultValue": null,
     "modelName": "ProjectTitle"
    },
    {
     "name": "ProjectDescription",
     "type": "esriFieldTypeString",
     "alias": "Project Description",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 500,
     "defaultValue": null,
     "modelName": "ProjectDescription"
    },
    {
     "name": "CurrentFDPdate",
     "type": "esriFieldTypeDate",
     "alias": "Current FDP Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "CurrentFDPdate"
    },
    {
     "name": "AwardDate",
     "type": "esriFieldTypeDate",
     "alias": "Award Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "AwardDate"
    },
    {
     "name": "NoticeToProceedDate",
     "type": "esriFieldTypeDate",
     "alias": "Notice To Proceed Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "NoticeToProceedDate"
    },
    {
     "name": "EstConstrCompletionDate",
     "type": "esriFieldTypeDate",
     "alias": "Estimated Construction Completion Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "EstConstrCompletionDate"
    },
    {
     "name": "ConstructionCompletionDate",
     "type": "esriFieldTypeDate",
     "alias": "Construction Completion Date",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 8,
     "defaultValue": null,
     "modelName": "ConstructionCompletionDate"
    },
    {
     "name": "ProjectManager",
     "type": "esriFieldTypeString",
     "alias": "Project Manager",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 50,
     "defaultValue": null,
     "modelName": "ProjectManager"
    },
    {
     "name": "ControlArea",
     "type": "esriFieldTypeString",
     "alias": "Control Area",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 20,
     "defaultValue": null,
     "modelName": "ControlArea"
    },
    {
     "name": "ProjectStatus",
     "type": "esriFieldTypeString",
     "alias": "Project Status",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 20,
     "defaultValue": null,
     "modelName": "ProjectStatus"
    },
    {
     "name": "DocumentLink",
     "type": "esriFieldTypeString",
     "alias": "Document Link",
     "domain": null,
     "editable": true,
     "nullable": true,
     "length": 150,
     "defaultValue": null,
     "modelName": "DocumentLink"
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "domain": null,
     "editable": false,
     "nullable": false,
     "length": 38,
     "defaultValue": null,
     "modelName": "GlobalID"
    },
    {
     "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"
    }
   ],
   "indexes": [
    {
     "name": "R447_SDE_ROWID_UK",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "OBJECTID"
    },
    {
     "name": "UUID_447",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID"
    },
    {
     "name": "UUID_OID_447",
     "isAscending": true,
     "isUnique": true,
     "description": "",
     "fields": "GlobalID,OBJECTID"
    }
   ],
   "datesInUnknownTimezone": false,
   "dateFieldsTimeReference": {
    "timeZone": "UTC",
    "timeZoneIANA": "Etc/UTC",
    "respectsDaylightSaving": false
   },
   "preferredTimeReference": null,
   "types": [],
   "templates": [
    {
     "name": "Signals Projects",
     "description": "",
     "prototype": {
      "attributes": {
       "DocumentLink": null,
       "ProjectStatus": null,
       "ProjectNumber": null,
       "ProposedProjectNumber": null,
       "SignalNumber": null,
       "WorkType": null,
       "WorkCodes": null,
       "CurrentSchedulePhase": null,
       "ProjectTitle": null,
       "ProjectDescription": null,
       "CurrentFDPdate": null,
       "AwardDate": null,
       "NoticeToProceedDate": null,
       "EstConstrCompletionDate": null,
       "ConstructionCompletionDate": null,
       "ProjectManager": null,
       "ControlArea": null
      }
     },
     "drawingTool": "esriFeatureEditToolNone"
    }
   ],
   "maxRecordCount": 2000,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
   "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
   "useStandardizedQueries": true,
   "bigIntegerRestrictedTo53Bits": true,
   "supportsAppend": true,
   "supportedAppendFormats": "FILEGDB,PBF",
   "standardMaxRecordCount": 32000,
   "tileMaxRecordCount": 2000,
   "maxRecordCountFactor": 1,
   "serviceItemId": "1455a48d91f746bd8e51db746f8bf673"
  }
 ]
}