{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 8,
 "name": "Lease Documents",
 "type": "Table",
 "description": "Federal Outer Continental Shelf (OCS) Sand and Gravel Lease Documents Table is maintained by the Bureau of Ocean Energy Management (BOEM), part of the U.S. Department of the Interior. This table exists to keep all records of Negotiated Non-Competitive Leases or Memorandums of Agreement with BOEM. Section 8 (k) of the OCS Lands Act (OCSLA) as amended by Public Law 103-426 (enacted in 1994) gives BOEM the authority to negotiate an agreement for the use of OCS sand, gravel, and shell resources for use in: (1) a project for shore protection, beach restoration, or coastal restoration undertaken by a Federal, State, or local government agency; or (2) for use in a construction project funded in whole or part by or authorized by the Federal government. This table is a collection of completed projects and ones that are in progress under BOEM's purview. The intent is to update the dataset when new dredging occurs, in tandem with new or amended leases. Attribution consists of the number of parties, agreement types, hyperlink to the lease document, and the existence of environmental reports related to the project.",
 "copyrightText": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "LeaseNo",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "LeaseNo",
   "type": "esriFieldTypeString",
   "alias": "Lease Number",
   "length": 20,
   "domain": null
  },
  {
   "name": "ProjectID",
   "type": "esriFieldTypeString",
   "alias": "Project ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "State_",
   "type": "esriFieldTypeString",
   "alias": "State",
   "length": 2,
   "domain": null
  },
  {
   "name": "FiscalYear",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Fiscal Year",
   "domain": null
  },
  {
   "name": "FiscalYear_text",
   "type": "esriFieldTypeString",
   "alias": "FiscalYear_text",
   "length": 4,
   "domain": null
  },
  {
   "name": "EffectiveDate",
   "type": "esriFieldTypeDate",
   "alias": "Agreement Initiation Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "NumberParties",
   "type": "esriFieldTypeString",
   "alias": "Number of Parties",
   "length": 10,
   "domain": null
  },
  {
   "name": "AgreementType",
   "type": "esriFieldTypeString",
   "alias": "Type of Agreement",
   "length": 10,
   "domain": null
  },
  {
   "name": "EA_EIS",
   "type": "esriFieldTypeString",
   "alias": "EA/EIS",
   "length": 20,
   "domain": null
  },
  {
   "name": "ROD_FONSI",
   "type": "esriFieldTypeString",
   "alias": "ROD/FONSI",
   "length": 20,
   "domain": null
  },
  {
   "name": "BOEMWebLink",
   "type": "esriFieldTypeString",
   "alias": "BOEM Web Link",
   "length": 1000,
   "domain": null
  },
  {
   "name": "OtherLink",
   "type": "esriFieldTypeString",
   "alias": "Other Link",
   "length": 1000,
   "domain": null
  },
  {
   "name": "SandAllocated",
   "type": "esriFieldTypeDouble",
   "alias": "Sand Allocated (cu yd)",
   "domain": null
  },
  {
   "name": "MMSRegion",
   "type": "esriFieldTypeString",
   "alias": "MMS Region",
   "length": 25,
   "domain": null
  },
  {
   "name": "LeaseMilesRestoredPlanned",
   "type": "esriFieldTypeDouble",
   "alias": "Planned Miles Restored",
   "domain": null
  },
  {
   "name": "GlobalLeaseID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Lease ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R17_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G38GlobalLeaseID",
   "fields": "GlobalLeaseID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "LeaseAreas",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "GlobalLeaseID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{8D45E3FB-3A66-4AE8-82E3-2C5AF2A6F8BF}"
  },
  {
   "id": 3,
   "name": "ShorePlacement",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "GlobalLeaseID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{AE81A621-E4F0-44A0-9C25-42B647847C62}"
  },
  {
   "id": 2,
   "name": "DredgeAreas",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "GlobalLeaseID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{0C4E4782-4061-4945-A556-55BA1B296583}"
  }
 ],
 "capabilities": "Map,Query,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,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "6308daaffcd2473da6104623e81e18d1"
}