{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 4,
 "name": "Phi",
 "type": "Table",
 "description": "The Phi table is a collection of datasets summarizing the grain size distribution of a sediment sample. Sets of sieves with known mesh sizes are used to sort sediment particles based on their sizes. Each \"phi\" represents a particular sieve level, or mesh screen size. The sieves are arranged in downward decreasing mesh size. The sieves are vibrated for a fixed period of time. The weight of sediment retained on each sieve is measured and converted into a percentage of the total sediment sample. The grain size data gathered into this MMIS table were acquired from multiple investigators and projects, whose research on or around the Outer Continental Shelf (OCS) was funded fully or partially by the Bureau of Ocean Energy Management (BOEM) or partner/stakeholder agencies. The intent is to build on the dataset as new reports and data become available. Data from pre-existing reports will be added to the dataset as time permits. Attribution consists of over 60 phi levels which represent the percentage of weight retained of a sample after smaller particles have been sieved. The Phi table is linked to the Samples table, which is subsequently linked to both the Grab Samples feature class and the Core Samples feature class.",
 "copyrightText": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "Comments",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "StudyID",
   "type": "esriFieldTypeString",
   "alias": "Study ID",
   "length": 250,
   "domain": null
  },
  {
   "name": "SampleID",
   "type": "esriFieldTypeString",
   "alias": "Sample ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "PHI_N_10Less",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -10 or less (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_09",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -9 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_08",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -8 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_07",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -7 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_06_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -6.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_06_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -6.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_06_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -6.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_06",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -6 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_05_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -5.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_05_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -5.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_05_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -5.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_05",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_04_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -4.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_04_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -4.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_04_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -4.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_04",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -4 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_03_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -3.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_03_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -3.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_03_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -3.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_03",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -3 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_02_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -2.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_02_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -2.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_02_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -2.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_02",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -2 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_01_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -1.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_01_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -1.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_01_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -1.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_01",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -1 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_00_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -0.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_00_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -0.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_N_00_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi -0.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_00",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 0 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_00_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 0.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_00_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 0.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_00_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 0.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_01",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 1 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_01_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 1.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_01_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 1.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_01_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 1.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_02",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 2 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_02_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 2.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_02_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 2.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_02_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 2.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_03",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 3 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_03_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 3.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_03_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 3.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_03_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 3.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_04",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 4 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_04_25",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 4.25 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_04_50",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 4.5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_04_75",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 4.75 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_05",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 5 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_06",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 6 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_07",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 7 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_08",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 8 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_09",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 9 (% retained)",
   "domain": null
  },
  {
   "name": "PHI_10Greater",
   "type": "esriFieldTypeDouble",
   "alias": "Phi 10 or Greater (% retained)",
   "domain": null
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 250,
   "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
  },
  {
   "name": "Phi_GlobalTableID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Table ID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R20_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G41Phi_GlobalTab",
   "fields": "Phi_GlobalTableID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 7,
   "name": "Sample",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "Phi_GlobalTableID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B742ADA7-13D1-4017-B223-96D462F785CF}"
  }
 ],
 "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": "0629188a35044eb780eb59f53dc8d8be"
}