{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 3,
 "name": "Sample",
 "type": "Table",
 "description": "The Samples Table contains information and data pertaining to sediment samples derived from cores (including borings) and grab samples (see Core and Grab Samples feature classes). The attributes in this table summarize sample acquisition (study and sample ID, elevation ,interval, source agency, contact info, etc.), processing and analysis (analysis date, dissolutions, removals, data reduction methods, etc.), and results of laboratory grain-size analyses. Each respective sample entry in this table is related to it's respective Core or Grab Sample feature. If available, data and additional content (e.g. photos, pdf logs, imagery, spreadsheets, weblinks, etc.) associated with individual sediment sample analyses (e.g. phi size distributions, Munsell color, age dating, heavy mineral content, and infauna) are provided within related MMIS geodatabase tables.",
 "copyrightText": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SourceName",
 "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": "CoreID",
   "type": "esriFieldTypeString",
   "alias": "Core ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "SampleID",
   "type": "esriFieldTypeString",
   "alias": "Sample ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "CoreLayerID",
   "type": "esriFieldTypeString",
   "alias": "Core Layer ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "AnalysisDate",
   "type": "esriFieldTypeDate",
   "alias": "Analysis Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "TopInterval",
   "type": "esriFieldTypeDouble",
   "alias": "Top of Sample Interval",
   "domain": null
  },
  {
   "name": "BottomInterval",
   "type": "esriFieldTypeDouble",
   "alias": "Bottom of Sample Interval",
   "domain": null
  },
  {
   "name": "GrabElevation",
   "type": "esriFieldTypeDouble",
   "alias": "Grab Elevation",
   "domain": null
  },
  {
   "name": "SampleBase_ft",
   "type": "esriFieldTypeDouble",
   "alias": "Sample Base (ft)",
   "domain": null
  },
  {
   "name": "SandUnitThickness",
   "type": "esriFieldTypeDouble",
   "alias": "Sand Unit Thickness",
   "domain": null
  },
  {
   "name": "PhiMethod",
   "type": "esriFieldTypeString",
   "alias": "Phi Method",
   "length": 50,
   "domain": null
  },
  {
   "name": "PhiMean",
   "type": "esriFieldTypeDouble",
   "alias": "Phi Mean",
   "domain": null
  },
  {
   "name": "PhiMedian",
   "type": "esriFieldTypeDouble",
   "alias": "Phi Median",
   "domain": null
  },
  {
   "name": "PhiSD",
   "type": "esriFieldTypeDouble",
   "alias": "Phi Standard Deviation",
   "domain": null
  },
  {
   "name": "PhiSkewness",
   "type": "esriFieldTypeDouble",
   "alias": "Phi Skewness",
   "domain": null
  },
  {
   "name": "PhiKurtosis",
   "type": "esriFieldTypeDouble",
   "alias": "Phi Kurtosis",
   "domain": null
  },
  {
   "name": "PctGravel",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Gravel",
   "domain": null
  },
  {
   "name": "PctSand",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Sand",
   "domain": null
  },
  {
   "name": "PctClay",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Clay",
   "domain": null
  },
  {
   "name": "PctSilt",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Silt",
   "domain": null
  },
  {
   "name": "PctFines",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Fines",
   "domain": null
  },
  {
   "name": "PctPanFraction",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Pan Fraction",
   "domain": null
  },
  {
   "name": "PctCarbonate",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Carbonate",
   "domain": null
  },
  {
   "name": "PctCarbonateSand",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Carbonate Sand",
   "domain": null
  },
  {
   "name": "PctShellFragments",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Shell Fragments",
   "domain": null
  },
  {
   "name": "PctHeavyMinerals",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Heavy Minerals",
   "domain": null
  },
  {
   "name": "PctOrganics",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Organics",
   "domain": null
  },
  {
   "name": "CarbonateDissolved",
   "type": "esriFieldTypeString",
   "alias": "Carbonate Dissolved",
   "length": 3,
   "domain": null
  },
  {
   "name": "HeavyMineralsDissolved",
   "type": "esriFieldTypeString",
   "alias": "Heavy Minerals Dissolved",
   "length": 3,
   "domain": null
  },
  {
   "name": "OrganicsRemoved",
   "type": "esriFieldTypeString",
   "alias": "Organics Removed",
   "length": 3,
   "domain": null
  },
  {
   "name": "ShellFragmentsRemoved",
   "type": "esriFieldTypeString",
   "alias": "Shell Fragments Removed",
   "length": 3,
   "domain": null
  },
  {
   "name": "SortMethod",
   "type": "esriFieldTypeString",
   "alias": "Sort Method",
   "length": 50,
   "domain": null
  },
  {
   "name": "Sphericity",
   "type": "esriFieldTypeDouble",
   "alias": "Sphericity",
   "domain": null
  },
  {
   "name": "SpherDesc",
   "type": "esriFieldTypeString",
   "alias": "Sphericity Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "Roundness",
   "type": "esriFieldTypeDouble",
   "alias": "Roundness",
   "domain": null
  },
  {
   "name": "RoundDesc",
   "type": "esriFieldTypeString",
   "alias": "Round Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "Sort_Descrpt",
   "type": "esriFieldTypeString",
   "alias": "Sorting Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "Porosity",
   "type": "esriFieldTypeDouble",
   "alias": "Porosity",
   "domain": null
  },
  {
   "name": "OilPresent",
   "type": "esriFieldTypeString",
   "alias": "Oil Present",
   "length": 3,
   "domain": null
  },
  {
   "name": "SourceID",
   "type": "esriFieldTypeString",
   "alias": "Source ID",
   "length": 150,
   "domain": null
  },
  {
   "name": "SourceName",
   "type": "esriFieldTypeString",
   "alias": "Source Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "SCOrigin",
   "type": "esriFieldTypeString",
   "alias": "CMECS SC Origin",
   "length": 30,
   "domain": null
  },
  {
   "name": "SCClass",
   "type": "esriFieldTypeString",
   "alias": "CMECS SC Class",
   "length": 50,
   "domain": null
  },
  {
   "name": "SCSubclass",
   "type": "esriFieldTypeString",
   "alias": "CMECS SC Sublass",
   "length": 50,
   "domain": null
  },
  {
   "name": "SCGroup",
   "type": "esriFieldTypeString",
   "alias": "CMECS SC Group",
   "length": 50,
   "domain": null
  },
  {
   "name": "SCSubgroup",
   "type": "esriFieldTypeString",
   "alias": "CMECS SC Subgroup",
   "length": 50,
   "domain": null
  },
  {
   "name": "Comments",
   "type": "esriFieldTypeString",
   "alias": "Comments",
   "length": 300,
   "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": "Samples_GlobalSampleID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Sample ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Samples_GlobalLayerID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Layer ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Samples_GlobalTableID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Table ID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R21_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G42Samples_Globa",
   "fields": "Samples_GlobalSampleID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G42Samples_Globa_1",
   "fields": "Samples_GlobalLayerID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G42Samples_Globa_2",
   "fields": "Samples_GlobalTableID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 6,
   "name": "Munsell",
   "relatedTableId": 5,
   "role": "esriRelRoleOrigin",
   "keyField": "Samples_GlobalTableID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{D8CAF564-0FA1-4A29-AC3F-410B6D714CC1}"
  },
  {
   "id": 7,
   "name": "Phi",
   "relatedTableId": 4,
   "role": "esriRelRoleOrigin",
   "keyField": "Samples_GlobalTableID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B742ADA7-13D1-4017-B223-96D462F785CF}"
  },
  {
   "id": 1,
   "name": "CoreSamples",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "Samples_GlobalSampleID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{71029C40-099F-4CD5-B96F-AE50467949F5}"
  },
  {
   "id": 5,
   "name": "CoreLayers",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "Samples_GlobalLayerID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{4282AE74-08AC-474A-803D-928ABBBD92E1}"
  },
  {
   "id": 3,
   "name": "GrabSamples",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "Samples_GlobalSampleID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{44D3672C-CCCA-42CE-813B-09AF016A3591}"
  }
 ],
 "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"
}