{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Core Samples", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 5000000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "The Core Samples feature class is a collection of sediment core and borehole locations and their respective summary attributes. These data were compiled from multiple agencies conducting investigations and studies relevant to outer continental shelf (OCS) non-energy mineral resource (e.g. sand, gravel, shell) management. Many of these efforts were funded at least partially by the Bureau of Ocean Energy Management (BOEM) (formerly known as the Minerals Management Service). The summary information for each core and boring location includes (but is not limited to) core/borehole ID, state, date/time, x/y coordinates (and horizontal datum), method of sampling, sampling device, elevation (and vertical datum), penetration depth, percent recovery, study name, and source agency contact information. Digitized core/borelogs and sediment sample data (if available; e.g. layer descriptions, grain-size analyses, Munsell color, etc.) are contained in the related Core Layers and Samples tables, respectively. The associated study report(s) are linked via the Link Documents table. This feature class will be updated as new data are received.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "CoreLayers", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "composite": false, "catalogID": "{F189F59D-BC02-4143-85F9-4B19D85C48AA}" }, { "id": 1, "name": "SampleAttachments", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Cores_GlobalAttachID", "composite": false, "catalogID": "{3093D214-3D80-47BF-AF00-B589FA21297F}" }, { "id": 2, "name": "Sample", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "composite": false, "catalogID": "{71029C40-099F-4CD5-B96F-AE50467949F5}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": -1.36564172306E7, "ymin": 2792520.0526, "xmax": -7684607.033, "ymax": 5280526.0502, "zmin": -65.69999999999709, "zmax": 0, "mmin": 0, "mmax": 0, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "2c3b00fbb639fb15a99c1f5aebf32148", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABXklEQVQoka2Tu0tCYRiHn+M55q3CTEmzQcopgyAMAokkaxAaaolo6Q8IgoKWaGktqinaIposwrMEFd0UHLrsDm6RBWGgURGlZByh0KPSYL/pe3/f+z28Fz6JGiX9O2CYiVYRcU9P/Vex/8Zz8oTQ5J8ADcKmjxGfgFDip0mR4+P0AnmrKqCf0YCb7qD6saImbFiwL/jx70SI5CoCzFiXHbi0yjlPnjjXWGjBgatw76GvI0ZqBZgtAwwwNufB2/MTX3HMAdtIaJlnAxON1KGjDfeUn+BqhMNkCUBAaNAg/lYjUigEEYliX0LS5tAbyyqIEF4yYx33MtipxL0EaMaOGRsGTIWcHFluSYRiyImKM0jztJjift+GU6PE7XhKBhnnJmkhP1N1C1HCsgHTuQ3nkHoLr2R45G49ivxeFaAoy+f0JUdhHcZ8sf9C5iGKvKbOLwOcsav016X2q6nmv/ANynZS03vn4WQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": true, "enableZDefaults": false, "supportsVCSProjection": true, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ContactName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "OCSStudyAreaID" }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoreID" }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "State" }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CoreDate" }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Time" }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "X" }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Y" }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoordSystem" }, { "name": "CoreType", "type": "esriFieldTypeString", "alias": "Method of Core Sample", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CoreType" }, { "name": "Sampler", "type": "esriFieldTypeString", "alias": "Sampler Device", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Sampler" }, { "name": "Elevation_ft", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Depth_ft" }, { "name": "PenetrationDepth", "type": "esriFieldTypeDouble", "alias": "Penetration Depth (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PenetrationDepth" }, { "name": "RecoveredLength", "type": "esriFieldTypeDouble", "alias": "Recovered Length (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RecoveredLength" }, { "name": "PercentRecovered", "type": "esriFieldTypeDouble", "alias": "Percent Recovered", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PercentRecovered" }, { "name": "CoreDiameter", "type": "esriFieldTypeDouble", "alias": "Core Diameter (in)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CoreDiameter" }, { "name": "DepthRock", "type": "esriFieldTypeDouble", "alias": "Depth Rock (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DepthRock" }, { "name": "AgencyID", "type": "esriFieldTypeString", "alias": "Agency ID", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "AgencyID" }, { "name": "ContactID", "type": "esriFieldTypeString", "alias": "Contact ID", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "ContactID" }, { "name": "ContactName", "type": "esriFieldTypeString", "alias": "Contact Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ContactName" }, { "name": "NumberCoreBoxes", "type": "esriFieldTypeDouble", "alias": "Number of Core Boxes", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberCoreBoxes" }, { "name": "DepthSandUnit", "type": "esriFieldTypeDouble", "alias": "Depth of Sand (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DepthSandUnit" }, { "name": "Longitude_DD", "type": "esriFieldTypeDouble", "alias": "Longitude (DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude_DD" }, { "name": "Latitude_DD", "type": "esriFieldTypeDouble", "alias": "Latitude (DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude_DD" }, { "name": "GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Global Sample ID" }, { "name": "Core_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Core_GlobalLinkID" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "Comments" }, { "name": "IGSNLink", "type": "esriFieldTypeString", "alias": "International GeoSample Number Link", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "IGSNLink" }, { "name": "VertDatum", "type": "esriFieldTypeString", "alias": "Vertical Datum", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VertDatum" }, { "name": "Cores_GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Cores_GlobalAttachID" }, { "name": "Constraints", "type": "esriFieldTypeString", "alias": "Access Constraints", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Constraints" }, { "name": "AcquisitionFundingSource", "type": "esriFieldTypeString", "alias": "Acquisition Funding Source", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "AcquisitionFundingSource" }, { "name": "Category", "type": "esriFieldTypeString", "alias": "Category", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Category" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R25_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_25", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "G46Cores_GlobalA", "isAscending": true, "isUnique": false, "description": "", "fields": "Cores_GlobalAttachID" }, { "name": "G46GlobalSampleI", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalSampleID" }, { "name": "G46Core_GlobalLi", "isAscending": true, "isUnique": false, "description": "", "fields": "Core_GlobalLinkID" }, { "name": "S3_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "Shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Core Samples", "description": "", "prototype": { "attributes": { "last_edited_date": null, "created_date": null, "StudyID": null, "CoreID": null, "State": null, "SampleDate": null, "Time": null, "X_Coord": null, "Y_Coord": null, "CoordSystem": null, "CoreType": null, "Sampler": null, "Elevation_ft": null, "PenetrationDepth": null, "RecoveredLength": null, "PercentRecovered": null, "CoreDiameter": null, "DepthRock": null, "AgencyID": null, "ContactID": null, "ContactName": null, "NumberCoreBoxes": null, "DepthSandUnit": null, "Longitude_DD": null, "Latitude_DD": null, "GlobalSampleID": null, "Core_GlobalLinkID": null, "Comments": null, "IGSNLink": null, "VertDatum": null, "Cores_GlobalAttachID": null, "Constraints": null, "AcquisitionFundingSource": null, "Category": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Grab Samples", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 5000000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "The Grab Samples feature class is a collection of sediment grab locations and their respective summary attributes. These data were compiled from multiple agencies conducting investigations and studies relevant to outer continental shelf (OCS) non-energy mineral resource (e.g. sand, gravel, shell) management. Many of these efforts were funded at least partially by the Bureau of Ocean Energy Management (BOEM) (formerly known as the Minerals Management Service). The summary information for each grab location includes (but is not limited to) grab ID, state, date/time, x/y coordinates (and horizontal datum), sampling device, elevation (and vertical datum), penetration depth, study ID, and source agency contact information. Laboratory analyses of sediment sample data (if available; e.g. textural classification, grain-size analyses, Munsell color, etc.) are contained in the related Samples table. The associated study report(s) are linked via the Link Documents table. This feature class will be updated as new data are received.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "Sample", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "composite": false, "catalogID": "{44D3672C-CCCA-42CE-813B-09AF016A3591}" }, { "id": 4, "name": "SampleAttachments", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Grabs_GlobalAttachID", "composite": false, "catalogID": "{0176CDF2-8645-477F-947F-6C658D77046C}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": -1.30911714494E7, "ymin": 3043814.8607, "xmax": -7472843.954399999, "ymax": 5555379.583899997, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "c4748a54c8a5d856e6e7f6ae556b6f64", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAOCAYAAAAmL5yKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABYUlEQVQoka2TPUhCURzFf+Z7KGqhhBRJYViEEYQNNrRECuEQFEVES0PQEggVNFiDBTYo1VK4FbT0gR+jDRFNQe0RuBTxCkGCAqFPNJ4SPL9osDPdc+7/Hs7/f+8VqBHCvxv4p2jRC5wYDWSVevoVyXfI9J8GGjXhpREGVKpi/T4NmXfONuLsVTXwTeAa7sVTeliG1QxdFnz+QQ78F3xXNGg1EnRYEeV1NgexK7A1gaO9sD/ejy2UIgQslBmsjLE46qTvl++egncftCI8hMHcAHoNODuZWfawGUwgFRmo1dSLasUs8jlAFEBQ6gKiTouuLMF6hLW2RiZnXXTLfM4NHc2F3k36Qs3HF1wmOfLHSVacwV2a1dtHInYLdTIf6ikeZOwayZDFq9QEJQnEiJv0nNstuEtvIfUCNxLbgShvVQ1kZD6Z30kQMxrIKXXpmadAlK3S+vKXeJzvryR8ddT8F34A2SlRmGM5uowAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ContactName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "OCSStudyAreaID" }, { "name": "GrabID", "type": "esriFieldTypeString", "alias": "Grab ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Grab ID" }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "State" }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Sample Date" }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Time" }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "X_Coord" }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Y_Coord" }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoordSystem" }, { "name": "Sampler", "type": "esriFieldTypeString", "alias": "Sampler Device", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Sampler" }, { "name": "Elevation_ft", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Elevation_ft" }, { "name": "PenetrationDepth", "type": "esriFieldTypeDouble", "alias": "Penetration Depth (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PenetrationDepth" }, { "name": "SedimentClassification", "type": "esriFieldTypeString", "alias": "Sediment Classification", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SedimentClassification" }, { "name": "ClassificationSystem", "type": "esriFieldTypeString", "alias": "Classification System", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ClassificationSystem" }, { "name": "SedimentDescription", "type": "esriFieldTypeString", "alias": "Sediment Description", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "SedimentDescription" }, { "name": "AgencyID", "type": "esriFieldTypeString", "alias": "Agency ID", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Agency ID" }, { "name": "ContactID", "type": "esriFieldTypeString", "alias": "Contact ID", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Contact ID" }, { "name": "ContactName", "type": "esriFieldTypeString", "alias": "Contact Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Contact Name" }, { "name": "Longitude_DD", "type": "esriFieldTypeDouble", "alias": "Longitude (DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Longitude_DD" }, { "name": "Latitude_DD", "type": "esriFieldTypeDouble", "alias": "Latitude (DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Latitude_DD" }, { "name": "VertDatum", "type": "esriFieldTypeString", "alias": "Vertical Datum", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VertDatum" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "Comments" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Global Sample ID" }, { "name": "Grab_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Grab_GlobalLinkID" }, { "name": "Grabs_GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Grabs_GlobalAttachID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R31_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_31", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "G52Grabs_GlobalA", "isAscending": true, "isUnique": false, "description": "", "fields": "Grabs_GlobalAttachID" }, { "name": "G52Grab_GlobalLi", "isAscending": true, "isUnique": false, "description": "", "fields": "Grab_GlobalLinkID" }, { "name": "G52GlobalSampleI", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalSampleID" }, { "name": "S9_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "Shape" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Grab Samples", "description": "", "prototype": { "attributes": { "Grabs_GlobalAttachID": null, "Grab_GlobalLinkID": null, "StudyID": null, "GrabID": null, "State": null, "SampleDate": null, "Time": null, "X_Coord": null, "Y_Coord": null, "CoordSystem": null, "Sampler": null, "Elevation_ft": null, "PenetrationDepth": null, "SedimentClassification": null, "ClassificationSystem": null, "SedimentDescription": null, "AgencyID": null, "ContactID": null, "ContactName": null, "Longitude_DD": null, "Latitude_DD": null, "VertDatum": null, "Comments": null, "created_date": null, "last_edited_date": null, "GlobalSampleID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" } ], "tables": [ { "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": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 5, "name": "Sample", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalLayerID", "composite": false, "catalogID": "{4282AE74-08AC-474A-803D-928ABBBD92E1}" }, { "id": 0, "name": "CoreSamples", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Layers_GlobalSampleID", "composite": false, "catalogID": "{F189F59D-BC02-4143-85F9-4B19D85C48AA}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "StudyID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Study ID" }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoreID" }, { "name": "CoreLayerID", "type": "esriFieldTypeString", "alias": "Core Layer ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Core Layer ID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SampleID" }, { "name": "TopInterval", "type": "esriFieldTypeDouble", "alias": "Top of Layer Interval", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Top of Layer Interval" }, { "name": "BottomInterval", "type": "esriFieldTypeDouble", "alias": "Bottom of Layer Interval", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bottom of Layer Interval" }, { "name": "PhiMean", "type": "esriFieldTypeDouble", "alias": "Mean Phi", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mean Phi" }, { "name": "MunsellHueWet", "type": "esriFieldTypeString", "alias": "Munsell Hue Wet", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Wet" }, { "name": "MunsellValueWet", "type": "esriFieldTypeDouble", "alias": "Munsell Value Wet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Value Wet" }, { "name": "MunsellChromaWet", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Wet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Wet" }, { "name": "SedimentClassification", "type": "esriFieldTypeString", "alias": "Sediment Classification", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SedimentClassification" }, { "name": "ClassificationSystem", "type": "esriFieldTypeString", "alias": "Classification System", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ClassificationSystem" }, { "name": "SedimentDescription", "type": "esriFieldTypeString", "alias": "Sediment Description", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Comments" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalLayerID", "type": "esriFieldTypeGUID", "alias": "Global Layer ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GlobalLayerID" }, { "name": "Layers_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Global Sample ID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R15_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G36Layers_Global", "isAscending": true, "isUnique": false, "description": "", "fields": "Layers_GlobalSampleID" }, { "name": "G36GlobalLayerID", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalLayerID" }, { "name": "UUID_15", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Core Layers", "description": "", "prototype": { "attributes": { "Layers_GlobalSampleID": null, "GlobalLayerID": null, "StudyID": null, "CoreID": null, "CoreLayerID": null, "SampleID": null, "TopInterval": null, "BottomInterval": null, "PhiMean": null, "MunsellHueWet": null, "MunsellValueWet": null, "MunsellChromaWet": null, "SedimentClassification": null, "ClassificationSystem": null, "SedimentDescription": null, "created_date": null, "last_edited_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }, { "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": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "Munsell", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "composite": false, "catalogID": "{D8CAF564-0FA1-4A29-AC3F-410B6D714CC1}" }, { "id": 7, "name": "Phi", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "composite": false, "catalogID": "{B742ADA7-13D1-4017-B223-96D462F785CF}" }, { "id": 2, "name": "CoreSamples", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "composite": false, "catalogID": "{71029C40-099F-4CD5-B96F-AE50467949F5}" }, { "id": 5, "name": "CoreLayers", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Samples_GlobalLayerID", "composite": false, "catalogID": "{4282AE74-08AC-474A-803D-928ABBBD92E1}" }, { "id": 3, "name": "GrabSamples", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "composite": false, "catalogID": "{44D3672C-CCCA-42CE-813B-09AF016A3591}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "SourceName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Study ID" }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoreID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SampleID" }, { "name": "CoreLayerID", "type": "esriFieldTypeString", "alias": "Core Layer ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CoreLayerID" }, { "name": "AnalysisDate", "type": "esriFieldTypeDate", "alias": "Analysis Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Analysis Date" }, { "name": "TopInterval", "type": "esriFieldTypeDouble", "alias": "Top of Sample Interval", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Top of Sample Interval" }, { "name": "BottomInterval", "type": "esriFieldTypeDouble", "alias": "Bottom of Sample Interval", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Bottom of Sample Interval" }, { "name": "GrabElevation", "type": "esriFieldTypeDouble", "alias": "Grab Elevation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Grab Elevation" }, { "name": "SampleBase_ft", "type": "esriFieldTypeDouble", "alias": "Sample Base (ft)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SampleBase_ft" }, { "name": "SandUnitThickness", "type": "esriFieldTypeDouble", "alias": "Sand Unit Thickness", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SandUnitThickness" }, { "name": "PhiMethod", "type": "esriFieldTypeString", "alias": "Phi Method", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PhiMethod" }, { "name": "PhiMean", "type": "esriFieldTypeDouble", "alias": "Phi Mean", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi Mean" }, { "name": "PhiMedian", "type": "esriFieldTypeDouble", "alias": "Phi Median", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi Median" }, { "name": "PhiSD", "type": "esriFieldTypeDouble", "alias": "Phi Standard Deviation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi Standard Deviation" }, { "name": "PhiSkewness", "type": "esriFieldTypeDouble", "alias": "Phi Skewness", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi Skewness" }, { "name": "PhiKurtosis", "type": "esriFieldTypeDouble", "alias": "Phi Kurtosis", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi Kurtosis" }, { "name": "PctGravel", "type": "esriFieldTypeDouble", "alias": "Percent Gravel", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PctGravel" }, { "name": "PctSand", "type": "esriFieldTypeDouble", "alias": "Percent Sand", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PctSand" }, { "name": "PctClay", "type": "esriFieldTypeDouble", "alias": "Percent Clay", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PctClay" }, { "name": "PctSilt", "type": "esriFieldTypeDouble", "alias": "Percent Silt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PctSilt" }, { "name": "PctFines", "type": "esriFieldTypeDouble", "alias": "Percent Fines", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Percent Fines" }, { "name": "PctPanFraction", "type": "esriFieldTypeDouble", "alias": "Percent Pan Fraction", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Percent Pan Fraction" }, { "name": "PctCarbonate", "type": "esriFieldTypeDouble", "alias": "Percent Carbonate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Percent Carbonate" }, { "name": "PctCarbonateSand", "type": "esriFieldTypeDouble", "alias": "Percent Carbonate Sand", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PctCarbonateSand" }, { "name": "PctShellFragments", "type": "esriFieldTypeDouble", "alias": "Percent Shell Fragments", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Percent Shell Fragments" }, { "name": "PctHeavyMinerals", "type": "esriFieldTypeDouble", "alias": "Percent Heavy Minerals", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Percent Heavy Minerals" }, { "name": "PctOrganics", "type": "esriFieldTypeDouble", "alias": "Percent Organics", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Percent Organics" }, { "name": "CarbonateDissolved", "type": "esriFieldTypeString", "alias": "Carbonate Dissolved", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Carbonate Dissolved" }, { "name": "HeavyMineralsDissolved", "type": "esriFieldTypeString", "alias": "Heavy Minerals Dissolved", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Heavy Minerals Dissolved" }, { "name": "OrganicsRemoved", "type": "esriFieldTypeString", "alias": "Organics Removed", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Organics Removed" }, { "name": "ShellFragmentsRemoved", "type": "esriFieldTypeString", "alias": "Shell Fragments Removed", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Shell Fragments Removed" }, { "name": "SortMethod", "type": "esriFieldTypeString", "alias": "Sort Method", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Sort Method" }, { "name": "Sphericity", "type": "esriFieldTypeDouble", "alias": "Sphericity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Sphericity" }, { "name": "SpherDesc", "type": "esriFieldTypeString", "alias": "Sphericity Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Sphericity Description" }, { "name": "Roundness", "type": "esriFieldTypeDouble", "alias": "Roundness", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Roundness" }, { "name": "RoundDesc", "type": "esriFieldTypeString", "alias": "Round Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Round Description" }, { "name": "Sort_Descrpt", "type": "esriFieldTypeString", "alias": "Sorting Description", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Sort_Descrpt" }, { "name": "Porosity", "type": "esriFieldTypeDouble", "alias": "Porosity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Porosity" }, { "name": "OilPresent", "type": "esriFieldTypeString", "alias": "Oil Present", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "OilPresent" }, { "name": "SourceID", "type": "esriFieldTypeString", "alias": "Source ID", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Source ID" }, { "name": "SourceName", "type": "esriFieldTypeString", "alias": "Source Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Source Name" }, { "name": "SCOrigin", "type": "esriFieldTypeString", "alias": "CMECS SC Origin", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SCOrigin" }, { "name": "SCClass", "type": "esriFieldTypeString", "alias": "CMECS SC Class", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SCClass" }, { "name": "SCSubclass", "type": "esriFieldTypeString", "alias": "CMECS SC Sublass", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SCSubclass" }, { "name": "SCGroup", "type": "esriFieldTypeString", "alias": "CMECS SC Group", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SCGroup" }, { "name": "SCSubgroup", "type": "esriFieldTypeString", "alias": "CMECS SC Subgroup", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SCSubgroup" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "Comments" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Samples_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Global Sample ID" }, { "name": "Samples_GlobalLayerID", "type": "esriFieldTypeGUID", "alias": "Global Layer ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Samples_GlobalLayerID" }, { "name": "Samples_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Global Table ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Samples_GlobalTableID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R21_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G42Samples_Globa", "isAscending": true, "isUnique": false, "description": "", "fields": "Samples_GlobalSampleID" }, { "name": "G42Samples_Globa_1", "isAscending": true, "isUnique": false, "description": "", "fields": "Samples_GlobalLayerID" }, { "name": "G42Samples_Globa_2", "isAscending": true, "isUnique": false, "description": "", "fields": "Samples_GlobalTableID" }, { "name": "UUID_21", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Sample", "description": "", "prototype": { "attributes": { "Samples_GlobalTableID": null, "Samples_GlobalLayerID": null, "StudyID": null, "CoreID": null, "SampleID": null, "CoreLayerID": null, "AnalysisDate": null, "TopInterval": null, "BottomInterval": null, "GrabElevation": null, "SampleBase_ft": null, "SandUnitThickness": null, "PhiMethod": null, "PhiMean": null, "PhiMedian": null, "PhiSD": null, "PhiSkewness": null, "PhiKurtosis": null, "PctGravel": null, "PctSand": null, "PctClay": null, "PctSilt": null, "PctFines": null, "PctPanFraction": null, "PctCarbonate": null, "PctCarbonateSand": null, "PctShellFragments": null, "PctHeavyMinerals": null, "PctOrganics": null, "CarbonateDissolved": null, "HeavyMineralsDissolved": null, "OrganicsRemoved": null, "ShellFragmentsRemoved": null, "SortMethod": null, "Sphericity": null, "SpherDesc": null, "Roundness": null, "RoundDesc": null, "Sort_Descrpt": null, "Porosity": null, "OilPresent": null, "SourceID": null, "SourceName": null, "SCOrigin": null, "SCClass": null, "SCSubclass": null, "SCGroup": null, "SCSubgroup": null, "Comments": null, "created_date": null, "last_edited_date": null, "Samples_GlobalSampleID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }, { "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": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 7, "name": "Sample", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Phi_GlobalTableID", "composite": false, "catalogID": "{B742ADA7-13D1-4017-B223-96D462F785CF}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Comments", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "OCSStudyAreaID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SampleID" }, { "name": "PHI_N_10Less", "type": "esriFieldTypeDouble", "alias": "Phi -10 or less (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI -10 or less" }, { "name": "PHI_N_09", "type": "esriFieldTypeDouble", "alias": "Phi -9 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_09" }, { "name": "PHI_N_08", "type": "esriFieldTypeDouble", "alias": "Phi -8 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_08" }, { "name": "PHI_N_07", "type": "esriFieldTypeDouble", "alias": "Phi -7 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -7" }, { "name": "PHI_N_06_75", "type": "esriFieldTypeDouble", "alias": "Phi -6.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -6.75" }, { "name": "PHI_N_06_50", "type": "esriFieldTypeDouble", "alias": "Phi -6.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -6.5" }, { "name": "PHI_N_06_25", "type": "esriFieldTypeDouble", "alias": "Phi -6.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -6.25" }, { "name": "PHI_N_06", "type": "esriFieldTypeDouble", "alias": "Phi -6 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -6" }, { "name": "PHI_N_05_75", "type": "esriFieldTypeDouble", "alias": "Phi -5.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -5.75" }, { "name": "PHI_N_05_50", "type": "esriFieldTypeDouble", "alias": "Phi -5.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -5.5" }, { "name": "PHI_N_05_25", "type": "esriFieldTypeDouble", "alias": "Phi -5.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -5.25" }, { "name": "PHI_N_05", "type": "esriFieldTypeDouble", "alias": "Phi -5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -5" }, { "name": "PHI_N_04_75", "type": "esriFieldTypeDouble", "alias": "Phi -4.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -4.75" }, { "name": "PHI_N_04_50", "type": "esriFieldTypeDouble", "alias": "Phi -4.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_04_50" }, { "name": "PHI_N_04_25", "type": "esriFieldTypeDouble", "alias": "Phi -4.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -4.25" }, { "name": "PHI_N_04", "type": "esriFieldTypeDouble", "alias": "Phi -4 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -4" }, { "name": "PHI_N_03_75", "type": "esriFieldTypeDouble", "alias": "Phi -3.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -3.75" }, { "name": "PHI_N_03_50", "type": "esriFieldTypeDouble", "alias": "Phi -3.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -3.5" }, { "name": "PHI_N_03_25", "type": "esriFieldTypeDouble", "alias": "Phi -3.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -3.25" }, { "name": "PHI_N_03", "type": "esriFieldTypeDouble", "alias": "Phi -3 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -3" }, { "name": "PHI_N_02_75", "type": "esriFieldTypeDouble", "alias": "Phi -2.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -2.75" }, { "name": "PHI_N_02_50", "type": "esriFieldTypeDouble", "alias": "Phi -2.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -2.5" }, { "name": "PHI_N_02_25", "type": "esriFieldTypeDouble", "alias": "Phi -2.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -2.25" }, { "name": "PHI_N_02", "type": "esriFieldTypeDouble", "alias": "Phi -2 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -2" }, { "name": "PHI_N_01_75", "type": "esriFieldTypeDouble", "alias": "Phi -1.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -1.75" }, { "name": "PHI_N_01_50", "type": "esriFieldTypeDouble", "alias": "Phi -1.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_01_50" }, { "name": "PHI_N_01_25", "type": "esriFieldTypeDouble", "alias": "Phi -1.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -1.25" }, { "name": "PHI_N_01", "type": "esriFieldTypeDouble", "alias": "Phi -1 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -1" }, { "name": "PHI_N_00_75", "type": "esriFieldTypeDouble", "alias": "Phi -0.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -0.75" }, { "name": "PHI_N_00_50", "type": "esriFieldTypeDouble", "alias": "Phi -0.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -0.5" }, { "name": "PHI_N_00_25", "type": "esriFieldTypeDouble", "alias": "Phi -0.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi -0.25" }, { "name": "PHI_00", "type": "esriFieldTypeDouble", "alias": "Phi 0 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 0" }, { "name": "PHI_00_25", "type": "esriFieldTypeDouble", "alias": "Phi 0.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 0.25" }, { "name": "PHI_00_50", "type": "esriFieldTypeDouble", "alias": "Phi 0.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 0.5" }, { "name": "PHI_00_75", "type": "esriFieldTypeDouble", "alias": "Phi 0.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 0.75" }, { "name": "PHI_01", "type": "esriFieldTypeDouble", "alias": "Phi 1 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 1" }, { "name": "PHI_01_25", "type": "esriFieldTypeDouble", "alias": "Phi 1.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 1.25" }, { "name": "PHI_01_50", "type": "esriFieldTypeDouble", "alias": "Phi 1.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 1.5" }, { "name": "PHI_01_75", "type": "esriFieldTypeDouble", "alias": "Phi 1.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_01_75" }, { "name": "PHI_02", "type": "esriFieldTypeDouble", "alias": "Phi 2 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 2" }, { "name": "PHI_02_25", "type": "esriFieldTypeDouble", "alias": "Phi 2.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 2.25" }, { "name": "PHI_02_50", "type": "esriFieldTypeDouble", "alias": "Phi 2.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 2.5" }, { "name": "PHI_02_75", "type": "esriFieldTypeDouble", "alias": "Phi 2.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 2.75" }, { "name": "PHI_03", "type": "esriFieldTypeDouble", "alias": "Phi 3 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 3" }, { "name": "PHI_03_25", "type": "esriFieldTypeDouble", "alias": "Phi 3.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 3.25" }, { "name": "PHI_03_50", "type": "esriFieldTypeDouble", "alias": "Phi 3.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_03_50" }, { "name": "PHI_03_75", "type": "esriFieldTypeDouble", "alias": "Phi 3.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 3.75" }, { "name": "PHI_04", "type": "esriFieldTypeDouble", "alias": "Phi 4 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 4" }, { "name": "PHI_04_25", "type": "esriFieldTypeDouble", "alias": "Phi 4.25 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 4.25" }, { "name": "PHI_04_50", "type": "esriFieldTypeDouble", "alias": "Phi 4.5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 4.5" }, { "name": "PHI_04_75", "type": "esriFieldTypeDouble", "alias": "Phi 4.75 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 4.75" }, { "name": "PHI_05", "type": "esriFieldTypeDouble", "alias": "Phi 5 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 5" }, { "name": "PHI_06", "type": "esriFieldTypeDouble", "alias": "Phi 6 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 6" }, { "name": "PHI_07", "type": "esriFieldTypeDouble", "alias": "Phi 7 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 7" }, { "name": "PHI_08", "type": "esriFieldTypeDouble", "alias": "Phi 8 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 8" }, { "name": "PHI_09", "type": "esriFieldTypeDouble", "alias": "Phi 9 (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 9" }, { "name": "PHI_10Greater", "type": "esriFieldTypeDouble", "alias": "Phi 10 or Greater (% retained)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phi 10 or Greater" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Phi_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Global Table ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Phi_GlobalTableID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R20_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G41Phi_GlobalTab", "isAscending": true, "isUnique": false, "description": "", "fields": "Phi_GlobalTableID" }, { "name": "UUID_20", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Phi", "description": "", "prototype": { "attributes": { "Phi_GlobalTableID": null, "last_edited_date": null, "StudyID": null, "SampleID": null, "PHI_N_10Less": null, "PHI_N_09": null, "PHI_N_08": null, "PHI_N_07": null, "PHI_N_06_75": null, "PHI_N_06_50": null, "PHI_N_06_25": null, "PHI_N_06": null, "PHI_N_05_75": null, "PHI_N_05_50": null, "PHI_N_05_25": null, "PHI_N_05": null, "PHI_N_04_75": null, "PHI_N_04_50": null, "PHI_N_04_25": null, "PHI_N_04": null, "PHI_N_03_75": null, "PHI_N_03_50": null, "PHI_N_03_25": null, "PHI_N_03": null, "PHI_N_02_75": null, "PHI_N_02_50": null, "PHI_N_02_25": null, "PHI_N_02": null, "PHI_N_01_75": null, "PHI_N_01_50": null, "PHI_N_01_25": null, "PHI_N_01": null, "PHI_N_00_75": null, "PHI_N_00_50": null, "PHI_N_00_25": null, "PHI_00": null, "PHI_00_25": null, "PHI_00_50": null, "PHI_00_75": null, "PHI_01": null, "PHI_01_25": null, "PHI_01_50": null, "PHI_01_75": null, "PHI_02": null, "PHI_02_25": null, "PHI_02_50": null, "PHI_02_75": null, "PHI_03": null, "PHI_03_25": null, "PHI_03_50": null, "PHI_03_75": null, "PHI_04": null, "PHI_04_25": null, "PHI_04_50": null, "PHI_04_75": null, "PHI_05": null, "PHI_06": null, "PHI_07": null, "PHI_08": null, "PHI_09": null, "PHI_10Greater": null, "Comments": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 5, "name": "Munsell", "type": "Table", "description": "The Munsell table is a collection of datasets summarizing sediment colors using the Munsell color system, which is based on three color dimensions: hue, value (lightness), and chroma (color purity). The Munsell color of sediment is one of several factors used in the determination of sediment resource compatibility for renourishment of beaches and coastal habitat. The Munsell color 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. Attribution consists of sediment hue, value, and chroma for dry, washed and wet samples. The Munsell table is linked to the Samples table, which is subsequently linked to both the Grab Samples feature class and the Core Samples feature class. Updates to this dataset will occur regularly as new and existing reports and data are incorporated into the MMIS geodatabase.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "Sample", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Munsell_GlobalTableID", "composite": false, "catalogID": "{D8CAF564-0FA1-4A29-AC3F-410B6D714CC1}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "MunsellHueWet", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "OCSStudyAreaID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SampleID" }, { "name": "MunsellHueWet", "type": "esriFieldTypeString", "alias": "Munsell Hue Wet", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Wet" }, { "name": "MunsellValueWet", "type": "esriFieldTypeDouble", "alias": "Munsell Value Wet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Value Wet" }, { "name": "MunsellChromaWet", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Wet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Wet" }, { "name": "MunsellHueWashed", "type": "esriFieldTypeString", "alias": "Munsell Hue Washed", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Washed" }, { "name": "MunsellValueWashed", "type": "esriFieldTypeDouble", "alias": "Munsell Value Washed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Value Washed" }, { "name": "MunsellChromaWashed", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Washed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Washed" }, { "name": "MunsellHueDry", "type": "esriFieldTypeString", "alias": "Munsell Hue Dry", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Dry" }, { "name": "MunsellValueDry", "type": "esriFieldTypeDouble", "alias": "Munsell Value Dry", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Value Dry" }, { "name": "MunsellChromaDry", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Dry", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Dry" }, { "name": "MunsellHueUnknown", "type": "esriFieldTypeString", "alias": "Munsell Hue Unknown", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Munsell Hue Unknown" }, { "name": "MunsellValueUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Value Unknown", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellValueUnknown" }, { "name": "MunsellChromaUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Unknown", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Munsell Chroma Unknown" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "Munsell_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Global Table ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Munsell_GlobalTableID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R19_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G40Munsell_Globa", "isAscending": true, "isUnique": false, "description": "", "fields": "Munsell_GlobalTableID" }, { "name": "UUID_19", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Munsell", "description": "", "prototype": { "attributes": { "Munsell_GlobalTableID": null, "last_edited_date": null, "StudyID": null, "SampleID": null, "MunsellHueWet": null, "MunsellValueWet": null, "MunsellChromaWet": null, "MunsellHueWashed": null, "MunsellValueWashed": null, "MunsellChromaWashed": null, "MunsellHueDry": null, "MunsellValueDry": null, "MunsellChromaDry": null, "MunsellHueUnknown": null, "MunsellValueUnknown": null, "MunsellChromaUnknown": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "SampleAttachments", "type": "Table", "description": "The Sample Attachments table in the MMIS geodatabase contains BOEM-local file paths or weblinks to photos and datasheets associated with collection and analysis of sediment samples listed in the related Samples table. These attachments generally include sample photos (core and grabs), field logs, core logs, grain-size analyses, penetrometer logs, location maps, or data sheets from other analyses (e.g. benthic community biomass) conducted on individual samples. This 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": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "GrabSamples", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GlobalAttachID", "composite": false, "catalogID": "{0176CDF2-8645-477F-947F-6C658D77046C}" }, { "id": 1, "name": "CoreSamples", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GlobalAttachID", "composite": false, "catalogID": "{3093D214-3D80-47BF-AF00-B589FA21297F}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "SampleID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "OCSStudyAreaID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SampleID" }, { "name": "AttachmentType", "type": "esriFieldTypeString", "alias": "Attachment Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AttachmentType" }, { "name": "GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Global Table ID" }, { "name": "Public_AttachLink", "type": "esriFieldTypeString", "alias": "Public Attachment Link", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Public_AttachLink" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R22_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G43GlobalAttachI", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalAttachID" }, { "name": "UUID_22", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SampleAttachments", "description": "", "prototype": { "attributes": { "last_edited_date": null, "created_date": null, "StudyID": null, "SampleID": null, "AttachmentType": null, "GlobalAttachID": null, "Public_AttachLink": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 7, "name": "SampMun", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "MunsellHueWet", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "SampleID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SampleID" }, { "name": "MunsellHueWet", "type": "esriFieldTypeString", "alias": "MunsellHueWet", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MunsellHueWet" }, { "name": "MunsellValueWet", "type": "esriFieldTypeDouble", "alias": "MunsellValueWet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellValueWet" }, { "name": "MunsellChromaWet", "type": "esriFieldTypeDouble", "alias": "MunsellChromaWet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellChromaWet" }, { "name": "MunsellHueWashed", "type": "esriFieldTypeString", "alias": "MunsellHueWashed", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MunsellHueWashed" }, { "name": "MunsellValueWashed", "type": "esriFieldTypeDouble", "alias": "MunsellValueWashed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellValueWashed" }, { "name": "MunsellChromaWashed", "type": "esriFieldTypeDouble", "alias": "MunsellChromaWashed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellChromaWashed" }, { "name": "MunsellHueDry", "type": "esriFieldTypeString", "alias": "MunsellHueDry", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MunsellHueDry" }, { "name": "MunsellValueDry", "type": "esriFieldTypeDouble", "alias": "MunsellValueDry", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellValueDry" }, { "name": "MunsellChromaDry", "type": "esriFieldTypeDouble", "alias": "MunsellChromaDry", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellChromaDry" }, { "name": "MunsellHueUnknown", "type": "esriFieldTypeString", "alias": "MunsellHueUnknown", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MunsellHueUnknown" }, { "name": "MunsellValueUnknown", "type": "esriFieldTypeDouble", "alias": "MunsellValueUnknown", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellValueUnknown" }, { "name": "MunsellChromaUnknown", "type": "esriFieldTypeDouble", "alias": "MunsellChromaUnknown", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MunsellChromaUnknown" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "StudyID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "StudyID" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "last_edited_date" }, { "name": "Samples_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Samples_GlobalSampleID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Samples_GlobalSampleID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SampMun", "description": "", "prototype": { "attributes": { "last_edited_date": null, "Samples_GlobalSampleID": null, "SampleID": null, "MunsellHueWet": null, "MunsellValueWet": null, "MunsellChromaWet": null, "MunsellHueWashed": null, "MunsellValueWashed": null, "MunsellChromaWashed": null, "MunsellHueDry": null, "MunsellValueDry": null, "MunsellChromaDry": null, "MunsellHueUnknown": null, "MunsellValueUnknown": null, "MunsellChromaUnknown": null, "StudyID": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 8, "name": "SampPhi", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Comments", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "SampleID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SampleID" }, { "name": "PHI_N_10Less", "type": "esriFieldTypeDouble", "alias": "PHI_N_10Less", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_10Less" }, { "name": "PHI_N_09", "type": "esriFieldTypeDouble", "alias": "PHI_N_09", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_09" }, { "name": "PHI_N_08", "type": "esriFieldTypeDouble", "alias": "PHI_N_08", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_08" }, { "name": "PHI_N_07", "type": "esriFieldTypeDouble", "alias": "PHI_N_07", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_07" }, { "name": "PHI_N_06_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_06_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_06_75" }, { "name": "PHI_N_06_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_06_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_06_50" }, { "name": "PHI_N_06_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_06_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_06_25" }, { "name": "PHI_N_06", "type": "esriFieldTypeDouble", "alias": "PHI_N_06", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_06" }, { "name": "PHI_N_05_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_05_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_05_75" }, { "name": "PHI_N_05_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_05_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_05_50" }, { "name": "PHI_N_05_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_05_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_05_25" }, { "name": "PHI_N_05", "type": "esriFieldTypeDouble", "alias": "PHI_N_05", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_05" }, { "name": "PHI_N_04_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_04_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_04_75" }, { "name": "PHI_N_04_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_04_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_04_50" }, { "name": "PHI_N_04_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_04_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_04_25" }, { "name": "PHI_N_04", "type": "esriFieldTypeDouble", "alias": "PHI_N_04", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_04" }, { "name": "PHI_N_03_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_03_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_03_75" }, { "name": "PHI_N_03_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_03_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_03_50" }, { "name": "PHI_N_03_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_03_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_03_25" }, { "name": "PHI_N_03", "type": "esriFieldTypeDouble", "alias": "PHI_N_03", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_03" }, { "name": "PHI_N_02_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_02_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_02_75" }, { "name": "PHI_N_02_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_02_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_02_50" }, { "name": "PHI_N_02_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_02_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_02_25" }, { "name": "PHI_N_02", "type": "esriFieldTypeDouble", "alias": "PHI_N_02", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_02" }, { "name": "PHI_N_01_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_01_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_01_75" }, { "name": "PHI_N_01_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_01_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_01_50" }, { "name": "PHI_N_01_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_01_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_01_25" }, { "name": "PHI_N_01", "type": "esriFieldTypeDouble", "alias": "PHI_N_01", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_01" }, { "name": "PHI_N_00_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_00_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_00_75" }, { "name": "PHI_N_00_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_00_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_00_50" }, { "name": "PHI_N_00_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_00_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_N_00_25" }, { "name": "PHI_00", "type": "esriFieldTypeDouble", "alias": "PHI_00", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_00" }, { "name": "PHI_00_25", "type": "esriFieldTypeDouble", "alias": "PHI_00_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_00_25" }, { "name": "PHI_00_50", "type": "esriFieldTypeDouble", "alias": "PHI_00_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_00_50" }, { "name": "PHI_00_75", "type": "esriFieldTypeDouble", "alias": "PHI_00_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_00_75" }, { "name": "PHI_01", "type": "esriFieldTypeDouble", "alias": "PHI_01", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_01" }, { "name": "PHI_01_25", "type": "esriFieldTypeDouble", "alias": "PHI_01_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_01_25" }, { "name": "PHI_01_50", "type": "esriFieldTypeDouble", "alias": "PHI_01_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_01_50" }, { "name": "PHI_01_75", "type": "esriFieldTypeDouble", "alias": "PHI_01_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_01_75" }, { "name": "PHI_02", "type": "esriFieldTypeDouble", "alias": "PHI_02", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_02" }, { "name": "PHI_02_25", "type": "esriFieldTypeDouble", "alias": "PHI_02_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_02_25" }, { "name": "PHI_02_50", "type": "esriFieldTypeDouble", "alias": "PHI_02_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_02_50" }, { "name": "PHI_02_75", "type": "esriFieldTypeDouble", "alias": "PHI_02_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_02_75" }, { "name": "PHI_03", "type": "esriFieldTypeDouble", "alias": "PHI_03", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_03" }, { "name": "PHI_03_25", "type": "esriFieldTypeDouble", "alias": "PHI_03_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_03_25" }, { "name": "PHI_03_50", "type": "esriFieldTypeDouble", "alias": "PHI_03_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_03_50" }, { "name": "PHI_03_75", "type": "esriFieldTypeDouble", "alias": "PHI_03_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_03_75" }, { "name": "PHI_04", "type": "esriFieldTypeDouble", "alias": "PHI_04", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_04" }, { "name": "PHI_04_25", "type": "esriFieldTypeDouble", "alias": "PHI_04_25", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_04_25" }, { "name": "PHI_04_50", "type": "esriFieldTypeDouble", "alias": "PHI_04_50", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_04_50" }, { "name": "PHI_04_75", "type": "esriFieldTypeDouble", "alias": "PHI_04_75", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_04_75" }, { "name": "PHI_05", "type": "esriFieldTypeDouble", "alias": "PHI_05", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_05" }, { "name": "PHI_06", "type": "esriFieldTypeDouble", "alias": "PHI_06", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_06" }, { "name": "PHI_07", "type": "esriFieldTypeDouble", "alias": "PHI_07", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_07" }, { "name": "PHI_08", "type": "esriFieldTypeDouble", "alias": "PHI_08", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_08" }, { "name": "PHI_09", "type": "esriFieldTypeDouble", "alias": "PHI_09", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_09" }, { "name": "PHI_10Greater", "type": "esriFieldTypeDouble", "alias": "PHI_10Greater", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHI_10Greater" }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "StudyID", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "StudyID" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "created_date" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "precision": 1, "modelName": "last_edited_date" }, { "name": "Phi_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Phi_GlobalTableID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Phi_GlobalTableID" }, { "name": "Samples_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Samples_GlobalSampleID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Samples_GlobalSampleID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SampPhi", "description": "", "prototype": { "attributes": { "Phi_GlobalTableID": null, "Samples_GlobalSampleID": null, "SampleID": null, "PHI_N_10Less": null, "PHI_N_09": null, "PHI_N_08": null, "PHI_N_07": null, "PHI_N_06_75": null, "PHI_N_06_50": null, "PHI_N_06_25": null, "PHI_N_06": null, "PHI_N_05_75": null, "PHI_N_05_50": null, "PHI_N_05_25": null, "PHI_N_05": null, "PHI_N_04_75": null, "PHI_N_04_50": null, "PHI_N_04_25": null, "PHI_N_04": null, "PHI_N_03_75": null, "PHI_N_03_50": null, "PHI_N_03_25": null, "PHI_N_03": null, "PHI_N_02_75": null, "PHI_N_02_50": null, "PHI_N_02_25": null, "PHI_N_02": null, "PHI_N_01_75": null, "PHI_N_01_50": null, "PHI_N_01_25": null, "PHI_N_01": null, "PHI_N_00_75": null, "PHI_N_00_50": null, "PHI_N_00_25": null, "PHI_00": null, "PHI_00_25": null, "PHI_00_50": null, "PHI_00_75": null, "PHI_01": null, "PHI_01_25": null, "PHI_01_50": null, "PHI_01_75": null, "PHI_02": null, "PHI_02_25": null, "PHI_02_50": null, "PHI_02_75": null, "PHI_03": null, "PHI_03_25": null, "PHI_03_50": null, "PHI_03_75": null, "PHI_04": null, "PHI_04_25": null, "PHI_04_50": null, "PHI_04_75": null, "PHI_05": null, "PHI_06": null, "PHI_07": null, "PHI_08": null, "PHI_09": null, "PHI_10Greater": null, "StudyID": null, "Comments": null, "created_date": null, "last_edited_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "dd82a110975d470ba863b578cf6de2e1" } ] }