{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 2,
 "name": "Core Layers",
 "type": "Table",
 "description": "The Core Layers Table contains general information related to layers described and or sampled within a core or boring. Attributes include Study Area ID, core ID, core layer ID, sample ID, top and bottom interval of the layer, Mean Phi, Munsell Color, lithologic description, sediment classification and classification system. Each entry in this table is related to a feature in the CoreSamples feature class of the MMIS geodatabase.",
 "copyrightText": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "StudyID",
 "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": "CoreLayerID",
   "type": "esriFieldTypeString",
   "alias": "Core Layer ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "SampleID",
   "type": "esriFieldTypeString",
   "alias": "Sample ID",
   "length": 100,
   "domain": null
  },
  {
   "name": "TopInterval",
   "type": "esriFieldTypeDouble",
   "alias": "Top of Layer Interval",
   "domain": null
  },
  {
   "name": "BottomInterval",
   "type": "esriFieldTypeDouble",
   "alias": "Bottom of Layer Interval",
   "domain": null
  },
  {
   "name": "PhiMean",
   "type": "esriFieldTypeDouble",
   "alias": "Mean Phi",
   "domain": null
  },
  {
   "name": "MunsellHueWet",
   "type": "esriFieldTypeString",
   "alias": "Munsell Hue Wet",
   "length": 10,
   "domain": null
  },
  {
   "name": "MunsellValueWet",
   "type": "esriFieldTypeDouble",
   "alias": "Munsell Value Wet",
   "domain": null
  },
  {
   "name": "MunsellChromaWet",
   "type": "esriFieldTypeDouble",
   "alias": "Munsell Chroma Wet",
   "domain": null
  },
  {
   "name": "SedimentClassification",
   "type": "esriFieldTypeString",
   "alias": "Sediment Classification",
   "length": 50,
   "domain": null
  },
  {
   "name": "ClassificationSystem",
   "type": "esriFieldTypeString",
   "alias": "Classification System",
   "length": 15,
   "domain": null
  },
  {
   "name": "SedimentDescription",
   "type": "esriFieldTypeString",
   "alias": "Sediment Description",
   "length": 1000,
   "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": "GlobalLayerID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Layer ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Layers_GlobalSampleID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Sample ID",
   "length": 38,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R15_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G36Layers_Global",
   "fields": "Layers_GlobalSampleID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G36GlobalLayerID",
   "fields": "GlobalLayerID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 5,
   "name": "Sample",
   "relatedTableId": 3,
   "role": "esriRelRoleOrigin",
   "keyField": "GlobalLayerID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{4282AE74-08AC-474A-803D-928ABBBD92E1}"
  },
  {
   "id": 0,
   "name": "CoreSamples",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "Layers_GlobalSampleID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{F189F59D-BC02-4143-85F9-4B19D85C48AA}"
  }
 ],
 "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"
}