{
 "currentVersion": 10.81,
 "cimVersion": "2.6.0",
 "id": 8,
 "name": "TB_Projects",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user"
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [],
 "isDataVersioned": false,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": true,
 "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,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ]
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "ProjectName",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "ProjectID",
   "type": "esriFieldTypeInteger",
   "alias": "Project ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ProjectID"
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGUID",
   "alias": "GlobalID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 38,
   "defaultValue": null,
   "modelName": "GlobalID"
  },
  {
   "name": "ProjectName",
   "type": "esriFieldTypeString",
   "alias": "Project Name",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "ProjectName"
  },
  {
   "name": "ProjectType",
   "type": "esriFieldTypeString",
   "alias": "Project Type",
   "domain": {
    "type": "codedValue",
    "name": "ProjectType",
    "description": "Top-level project classification.",
    "codedValues": [
     {
      "name": "Dredging",
      "code": "Dredging"
     },
     {
      "name": "PlacementArea",
      "code": "PlacementArea"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ProjectType"
  },
  {
   "name": "FY_AnchorDate",
   "type": "esriFieldTypeDate",
   "alias": "FY_AnchorDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "FY_AnchorDate"
  },
  {
   "name": "IssueSolicitationDate",
   "type": "esriFieldTypeDate",
   "alias": "IssueSolicitationDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "IssueSolicitationDate"
  },
  {
   "name": "ProjectStatus",
   "type": "esriFieldTypeString",
   "alias": "Project Status",
   "domain": {
    "type": "codedValue",
    "name": "ProjectStatus",
    "description": "Procurement/construction state.",
    "codedValues": [
     {
      "name": "Advertised",
      "code": "Advertised"
     },
     {
      "name": "Awarded",
      "code": "Awarded"
     },
     {
      "name": "In Progress",
      "code": "In Progress"
     },
     {
      "name": "Completed",
      "code": "Completed"
     },
     {
      "name": "On Hold",
      "code": "On Hold"
     },
     {
      "name": "Cancelled",
      "code": "Cancelled"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 25,
   "defaultValue": null,
   "modelName": "ProjectStatus"
  },
  {
   "name": "Owner",
   "type": "esriFieldTypeString",
   "alias": "Project Owner",
   "domain": {
    "type": "codedValue",
    "name": "Owner",
    "description": "Owning agency.",
    "codedValues": [
     {
      "name": "USACE",
      "code": "USACE"
     },
     {
      "name": "PHA",
      "code": "PHA"
     },
     {
      "name": "OTHER",
      "code": "OTHER"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Owner"
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Notes"
  },
  {
   "name": "ProjectSubtype",
   "type": "esriFieldTypeString",
   "alias": "ProjectSubtype",
   "domain": {
    "type": "codedValue",
    "name": "ProjectType",
    "description": "Top-level project classification.",
    "codedValues": [
     {
      "name": "Dredging",
      "code": "Dredging"
     },
     {
      "name": "PlacementArea",
      "code": "PlacementArea"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "ProjectSubtype"
  },
  {
   "name": "FiscalYear",
   "type": "esriFieldTypeSmallInteger",
   "alias": "FiscalYear",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "FiscalYear"
  },
  {
   "name": "FileNumber",
   "type": "esriFieldTypeString",
   "alias": "FileNumber",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "FileNumber"
  },
  {
   "name": "PONumber",
   "type": "esriFieldTypeString",
   "alias": "PONumber",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "PONumber"
  },
  {
   "name": "ContractName",
   "type": "esriFieldTypeString",
   "alias": "ContractName",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "ContractName"
  },
  {
   "name": "ProjectReach",
   "type": "esriFieldTypeString",
   "alias": "ProjectReach",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "ProjectReach"
  },
  {
   "name": "ProjectAOIStation",
   "type": "esriFieldTypeString",
   "alias": "ProjectAOIStation",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "ProjectAOIStation"
  },
  {
   "name": "DredgeName",
   "type": "esriFieldTypeString",
   "alias": "DredgeName",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "DredgeName"
  },
  {
   "name": "DredgeType",
   "type": "esriFieldTypeString",
   "alias": "DredgeType",
   "domain": {
    "type": "codedValue",
    "name": "DredgeType",
    "description": "Primary dredge equipment type.",
    "codedValues": [
     {
      "name": "CSD",
      "code": "CSD"
     },
     {
      "name": "TSHD",
      "code": "TSHD"
     },
     {
      "name": "Mechanical",
      "code": "Mechanical"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "DredgeType"
  },
  {
   "name": "CTRequiredDepthFT",
   "type": "esriFieldTypeDouble",
   "alias": "CTRequiredDepthFT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "CTRequiredDepthFT"
  },
  {
   "name": "BidOpeningDate",
   "type": "esriFieldTypeDate",
   "alias": "BidOpeningDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "BidOpeningDate"
  },
  {
   "name": "AwardDate",
   "type": "esriFieldTypeDate",
   "alias": "AwardDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "AwardDate"
  },
  {
   "name": "RequiredCompletionDate",
   "type": "esriFieldTypeDate",
   "alias": "RequiredCompletionDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "RequiredCompletionDate"
  },
  {
   "name": "ActualCompletionDate",
   "type": "esriFieldTypeDate",
   "alias": "ActualCompletionDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "ActualCompletionDate"
  },
  {
   "name": "SolicitationNumber",
   "type": "esriFieldTypeString",
   "alias": "SolicitationNumber",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 64,
   "defaultValue": null,
   "modelName": "SolicitationNumber"
  },
  {
   "name": "ContractNumber",
   "type": "esriFieldTypeString",
   "alias": "ContractNumber",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 64,
   "defaultValue": null,
   "modelName": "ContractNumber"
  },
  {
   "name": "Contractor",
   "type": "esriFieldTypeString",
   "alias": "Contractor",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 128,
   "defaultValue": null,
   "modelName": "Contractor"
  },
  {
   "name": "ActiveConstruction",
   "type": "esriFieldTypeString",
   "alias": "ActiveConstruction",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "ActiveConstruction"
  },
  {
   "name": "PlacementAreaName",
   "type": "esriFieldTypeString",
   "alias": "PlacementAreaName",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 128,
   "defaultValue": null,
   "modelName": "PlacementAreaName"
  },
  {
   "name": "FacilityName",
   "type": "esriFieldTypeString",
   "alias": "FacilityName",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 128,
   "defaultValue": null,
   "modelName": "FacilityName"
  },
  {
   "name": "LocationDescription",
   "type": "esriFieldTypeString",
   "alias": "LocationDescription",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "LocationDescription"
  },
  {
   "name": "DataSource",
   "type": "esriFieldTypeString",
   "alias": "DataSource",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "DataSource"
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 2000,
   "defaultValue": null,
   "modelName": "Comments"
  },
  {
   "name": "PrimaryDocURL",
   "type": "esriFieldTypeString",
   "alias": "PrimaryDocURL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 1024,
   "defaultValue": null,
   "modelName": "PrimaryDocURL"
  },
  {
   "name": "SourceJobID",
   "type": "esriFieldTypeString",
   "alias": "SourceJobID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 64,
   "defaultValue": null,
   "modelName": "SourceJobID"
  },
  {
   "name": "SourceSystem",
   "type": "esriFieldTypeString",
   "alias": "SourceSystem",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 64,
   "defaultValue": null,
   "modelName": "SourceSystem"
  },
  {
   "name": "StartDate",
   "type": "esriFieldTypeDate",
   "alias": "StartDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "StartDate"
  },
  {
   "name": "EstimatedQuantityCY",
   "type": "esriFieldTypeDouble",
   "alias": "EstimatedQuantityCY",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "EstimatedQuantityCY"
  },
  {
   "name": "CTAwardAmountUSD",
   "type": "esriFieldTypeDouble",
   "alias": "CTAwardAmountUSD",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "CTAwardAmountUSD"
  },
  {
   "name": "CTFinalAmountUSD",
   "type": "esriFieldTypeDouble",
   "alias": "CTFinalAmountUSD",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "CTFinalAmountUSD"
  },
  {
   "name": "ContractQuantityCY",
   "type": "esriFieldTypeDouble",
   "alias": "ContractQuantityCY",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ContractQuantityCY"
  },
  {
   "name": "FinalQuantityCY",
   "type": "esriFieldTypeDouble",
   "alias": "FinalQuantityCY",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "FinalQuantityCY"
  },
  {
   "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": "DMPANames",
   "type": "esriFieldTypeString",
   "alias": "DMPANames",
   "domain": {
    "type": "codedValue",
    "name": "DMPA Names",
    "description": "Placement Area Names",
    "codedValues": [
     {
      "name": "Alexander Island PA",
      "code": "Alexander_Island_PA"
     },
     {
      "name": "Bolivar Marsh",
      "code": "Bolivar"
     },
     {
      "name": "Atikinson M12",
      "code": "Atikinson_M12"
     },
     {
      "name": "Atkinson Is. Marsh",
      "code": "Atkinson_Is_Marsh"
     },
     {
      "name": "Atkinson M10",
      "code": "Atkinson_M10"
     },
     {
      "name": "Atkinson M11",
      "code": "Atkinson_M11"
     },
     {
      "name": "Atkinson M5/M6",
      "code": "Atkinson_M5_M6"
     },
     {
      "name": "Atkinson M7/8/9",
      "code": "Atkinson_M7_8_9"
     },
     {
      "name": "Beltway 8 PA",
      "code": "Beltway_8_PA"
     },
     {
      "name": "E2 Clinton PA",
      "code": "E2_Clinton_PA"
     },
     {
      "name": "East Clinton PA",
      "code": "East_Clinton_PA"
     },
     {
      "name": "Filter Bed",
      "code": "Filter_Bed"
     },
     {
      "name": "Glendale PA",
      "code": "Glendale_PA"
     },
     {
      "name": "Greens Bayou PA",
      "code": "Greens_Bayou_PA"
     },
     {
      "name": "House Tract PA",
      "code": "House_Tract_PA"
     },
     {
      "name": "Lost Lake PA",
      "code": "Lost_Lake_PA"
     },
     {
      "name": "Mid Bay PA",
      "code": "Mid_Bay_PA"
     },
     {
      "name": "Peggy Lake PA",
      "code": "Peggy_Lake_PA"
     },
     {
      "name": "PA 13",
      "code": "PA_13"
     },
     {
      "name": "PA 14",
      "code": "PA_14"
     },
     {
      "name": "PA 15",
      "code": "PA_15"
     },
     {
      "name": "PA 16",
      "code": "PA_16"
     },
     {
      "name": "Rosa Allen PA",
      "code": "Rosa_Allen_PA"
     },
     {
      "name": "Spilman Island PA",
      "code": "Spilman_Island_PA"
     },
     {
      "name": "West Clinton PA",
      "code": "West_Clinton_PA"
     },
     {
      "name": "Long Bird Island",
      "code": "Long_Bird_Island"
     },
     {
      "name": "Three Bird Island",
      "code": "Three_Bird_Island"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "DMPANames"
  }
 ],
 "indexes": [
  {
   "name": "R1130_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "types": [],
 "templates": [
  {
   "name": "TB_Projects",
   "description": "",
   "prototype": {
    "attributes": {
     "FinalQuantityCY": null,
     "DMPANames": null,
     "ProjectID": null,
     "GlobalID": null,
     "ProjectName": null,
     "ProjectType": null,
     "FY_AnchorDate": null,
     "IssueSolicitationDate": null,
     "ProjectStatus": null,
     "Owner": null,
     "Notes": null,
     "ProjectSubtype": null,
     "FiscalYear": null,
     "FileNumber": null,
     "PONumber": null,
     "ContractName": null,
     "ProjectReach": null,
     "ProjectAOIStation": null,
     "DredgeName": null,
     "DredgeType": null,
     "CTRequiredDepthFT": null,
     "BidOpeningDate": null,
     "AwardDate": null,
     "RequiredCompletionDate": null,
     "ActualCompletionDate": null,
     "SolicitationNumber": null,
     "ContractNumber": null,
     "Contractor": null,
     "ActiveConstruction": null,
     "PlacementAreaName": null,
     "FacilityName": null,
     "LocationDescription": null,
     "DataSource": null,
     "Comments": null,
     "PrimaryDocURL": null,
     "SourceJobID": null,
     "SourceSystem": null,
     "StartDate": null,
     "EstimatedQuantityCY": null,
     "CTAwardAmountUSD": null,
     "CTFinalAmountUSD": null,
     "ContractQuantityCY": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1
}