{
 "currentVersion": 10.81,
 "cimVersion": "2.6.0",
 "id": 8,
 "name": "TB_Projects",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ProjectName",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ProjectID",
   "type": "esriFieldTypeInteger",
   "alias": "Project ID",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGUID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "ProjectName",
   "type": "esriFieldTypeString",
   "alias": "Project Name",
   "length": 255,
   "domain": null
  },
  {
   "name": "ProjectType",
   "type": "esriFieldTypeString",
   "alias": "Project Type",
   "length": 50,
   "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"
   }
  },
  {
   "name": "FY_AnchorDate",
   "type": "esriFieldTypeDate",
   "alias": "FY_AnchorDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "IssueSolicitationDate",
   "type": "esriFieldTypeDate",
   "alias": "IssueSolicitationDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "ProjectStatus",
   "type": "esriFieldTypeString",
   "alias": "Project Status",
   "length": 25,
   "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"
   }
  },
  {
   "name": "Owner",
   "type": "esriFieldTypeString",
   "alias": "Project Owner",
   "length": 50,
   "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"
   }
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 255,
   "domain": null
  },
  {
   "name": "ProjectSubtype",
   "type": "esriFieldTypeString",
   "alias": "ProjectSubtype",
   "length": 255,
   "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"
   }
  },
  {
   "name": "FiscalYear",
   "type": "esriFieldTypeSmallInteger",
   "alias": "FiscalYear",
   "domain": null
  },
  {
   "name": "FileNumber",
   "type": "esriFieldTypeString",
   "alias": "FileNumber",
   "length": 255,
   "domain": null
  },
  {
   "name": "PONumber",
   "type": "esriFieldTypeString",
   "alias": "PONumber",
   "length": 255,
   "domain": null
  },
  {
   "name": "ContractName",
   "type": "esriFieldTypeString",
   "alias": "ContractName",
   "length": 255,
   "domain": null
  },
  {
   "name": "ProjectReach",
   "type": "esriFieldTypeString",
   "alias": "ProjectReach",
   "length": 255,
   "domain": null
  },
  {
   "name": "ProjectAOIStation",
   "type": "esriFieldTypeString",
   "alias": "ProjectAOIStation",
   "length": 255,
   "domain": null
  },
  {
   "name": "DredgeName",
   "type": "esriFieldTypeString",
   "alias": "DredgeName",
   "length": 255,
   "domain": null
  },
  {
   "name": "DredgeType",
   "type": "esriFieldTypeString",
   "alias": "DredgeType",
   "length": 255,
   "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"
   }
  },
  {
   "name": "CTRequiredDepthFT",
   "type": "esriFieldTypeDouble",
   "alias": "CTRequiredDepthFT",
   "domain": null
  },
  {
   "name": "BidOpeningDate",
   "type": "esriFieldTypeDate",
   "alias": "BidOpeningDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "AwardDate",
   "type": "esriFieldTypeDate",
   "alias": "AwardDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "RequiredCompletionDate",
   "type": "esriFieldTypeDate",
   "alias": "RequiredCompletionDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "ActualCompletionDate",
   "type": "esriFieldTypeDate",
   "alias": "ActualCompletionDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "SolicitationNumber",
   "type": "esriFieldTypeString",
   "alias": "SolicitationNumber",
   "length": 64,
   "domain": null
  },
  {
   "name": "ContractNumber",
   "type": "esriFieldTypeString",
   "alias": "ContractNumber",
   "length": 64,
   "domain": null
  },
  {
   "name": "Contractor",
   "type": "esriFieldTypeString",
   "alias": "Contractor",
   "length": 128,
   "domain": null
  },
  {
   "name": "ActiveConstruction",
   "type": "esriFieldTypeString",
   "alias": "ActiveConstruction",
   "length": 255,
   "domain": null
  },
  {
   "name": "PlacementAreaName",
   "type": "esriFieldTypeString",
   "alias": "PlacementAreaName",
   "length": 128,
   "domain": null
  },
  {
   "name": "FacilityName",
   "type": "esriFieldTypeString",
   "alias": "FacilityName",
   "length": 128,
   "domain": null
  },
  {
   "name": "LocationDescription",
   "type": "esriFieldTypeString",
   "alias": "LocationDescription",
   "length": 255,
   "domain": null
  },
  {
   "name": "DataSource",
   "type": "esriFieldTypeString",
   "alias": "DataSource",
   "length": 255,
   "domain": null
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 2000,
   "domain": null
  },
  {
   "name": "PrimaryDocURL",
   "type": "esriFieldTypeString",
   "alias": "PrimaryDocURL",
   "length": 1024,
   "domain": null
  },
  {
   "name": "SourceJobID",
   "type": "esriFieldTypeString",
   "alias": "SourceJobID",
   "length": 64,
   "domain": null
  },
  {
   "name": "SourceSystem",
   "type": "esriFieldTypeString",
   "alias": "SourceSystem",
   "length": 64,
   "domain": null
  },
  {
   "name": "StartDate",
   "type": "esriFieldTypeDate",
   "alias": "StartDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "EstimatedQuantityCY",
   "type": "esriFieldTypeDouble",
   "alias": "EstimatedQuantityCY",
   "domain": null
  },
  {
   "name": "CTAwardAmountUSD",
   "type": "esriFieldTypeDouble",
   "alias": "CTAwardAmountUSD",
   "domain": null
  },
  {
   "name": "CTFinalAmountUSD",
   "type": "esriFieldTypeDouble",
   "alias": "CTFinalAmountUSD",
   "domain": null
  },
  {
   "name": "ContractQuantityCY",
   "type": "esriFieldTypeDouble",
   "alias": "ContractQuantityCY",
   "domain": null
  },
  {
   "name": "FinalQuantityCY",
   "type": "esriFieldTypeDouble",
   "alias": "FinalQuantityCY",
   "domain": null
  },
  {
   "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": "DMPANames",
   "type": "esriFieldTypeString",
   "alias": "DMPANames",
   "length": 255,
   "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"
   }
  }
 ],
 "indexes": [
  {
   "name": "R1130_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "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
 },
 "dateFieldsTimeReference": null,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}