{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Core Samples", "type": "Feature Layer", "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.", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 5000000, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": true, "extent": { "xmin": -1.36564172306E7, "ymin": 2792520.0526, "xmax": -7684607.033, "ymax": 5312988.028099999, "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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ContactName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "length": 8, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "domain": null }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "length": 20, "domain": null }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "length": 20, "domain": null }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "length": 50, "domain": null }, { "name": "CoreType", "type": "esriFieldTypeString", "alias": "Method of Core Sample", "length": 30, "domain": null }, { "name": "Sampler", "type": "esriFieldTypeString", "alias": "Sampler Device", "length": 250, "domain": null }, { "name": "Elevation_ft", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "PenetrationDepth", "type": "esriFieldTypeDouble", "alias": "Penetration Depth (ft)", "domain": null }, { "name": "RecoveredLength", "type": "esriFieldTypeDouble", "alias": "Recovered Length (ft)", "domain": null }, { "name": "PercentRecovered", "type": "esriFieldTypeDouble", "alias": "Percent Recovered", "domain": null }, { "name": "CoreDiameter", "type": "esriFieldTypeDouble", "alias": "Core Diameter (in)", "domain": null }, { "name": "DepthRock", "type": "esriFieldTypeDouble", "alias": "Depth Rock (ft)", "domain": null }, { "name": "AgencyID", "type": "esriFieldTypeString", "alias": "Agency ID", "length": 50, "domain": null }, { "name": "ContactID", "type": "esriFieldTypeString", "alias": "Contact ID", "length": 50, "domain": null }, { "name": "ContactName", "type": "esriFieldTypeString", "alias": "Contact Name", "length": 50, "domain": null }, { "name": "DepthSandUnit", "type": "esriFieldTypeDouble", "alias": "Depth of Sand (ft)", "domain": null }, { "name": "Longitude_DD", "type": "esriFieldTypeDouble", "alias": "Longitude (DD)", "domain": null }, { "name": "Latitude_DD", "type": "esriFieldTypeDouble", "alias": "Latitude (DD)", "domain": null }, { "name": "IGSNLink", "type": "esriFieldTypeString", "alias": "International GeoSample Number Link", "length": 100, "domain": null }, { "name": "VertDatum", "type": "esriFieldTypeString", "alias": "Vertical Datum", "length": 20, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "length": 38, "domain": null }, { "name": "Core_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "CoreSamples_Rep_2_Rules", "description": "Representation rules", "codedValues": [ { "name": "Core Samples", "code": 1 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Override", "type": "esriFieldTypeBlob", "alias": "Override", "domain": null }, { "name": "Cores_GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R15_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_15", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S3_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Sample", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6BC9BAF9-7DA7-4506-A550-155E400B46C8}" }, { "id": 0, "name": "CoreLayers", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{834C69AD-30B4-4A75-A0A8-37E4AC90CF1C}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Grab Samples", "type": "Feature Layer", "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.", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 5000000, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ContactName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "GrabID", "type": "esriFieldTypeString", "alias": "Grab ID", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "length": 8, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "domain": null }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "length": 20, "domain": null }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "length": 20, "domain": null }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "length": 50, "domain": null }, { "name": "Sampler", "type": "esriFieldTypeString", "alias": "Sampler Device", "length": 250, "domain": null }, { "name": "Elevation_ft", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "PenetrationDepth", "type": "esriFieldTypeDouble", "alias": "Penetration Depth (ft)", "domain": null }, { "name": "SedimentClassification", "type": "esriFieldTypeString", "alias": "Sediment Classification", "length": 50, "domain": null }, { "name": "ClassificationSystem", "type": "esriFieldTypeString", "alias": "Classification System", "length": 15, "domain": null }, { "name": "SedimentDescription", "type": "esriFieldTypeString", "alias": "Sediment Description", "length": 300, "domain": null }, { "name": "AgencyID", "type": "esriFieldTypeString", "alias": "Agency ID", "length": 50, "domain": null }, { "name": "ContactID", "type": "esriFieldTypeString", "alias": "Contact ID", "length": 50, "domain": null }, { "name": "ContactName", "type": "esriFieldTypeString", "alias": "Contact Name", "length": 50, "domain": null }, { "name": "Longitude_DD", "type": "esriFieldTypeDouble", "alias": "Longitude (DD)", "domain": null }, { "name": "Latitude_DD", "type": "esriFieldTypeDouble", "alias": "Latitude (DD)", "domain": null }, { "name": "VertDatum", "type": "esriFieldTypeString", "alias": "Vertical Datum", "length": 20, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "length": 38, "domain": null }, { "name": "Grab_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "GrabSamples_Rep_2_Rules", "description": "Representation rules", "codedValues": [ { "name": "Grab Samples", "code": 1 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Override", "type": "esriFieldTypeBlob", "alias": "Override", "domain": null }, { "name": "Grabs_GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R22_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_22", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Sample", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0111C50A-D6D3-4A20-B169-C9B5459AB912}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "Core Layers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StudyID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "length": 50, "domain": null }, { "name": "CoreLayerID", "type": "esriFieldTypeString", "alias": "Core Layer ID", "length": 50, "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 100, "domain": null }, { "name": "TopInterval", "type": "esriFieldTypeDouble", "alias": "Top of Layer Interval", "domain": null }, { "name": "BottomInterval", "type": "esriFieldTypeDouble", "alias": "Bottom of Layer Interval", "domain": null }, { "name": "PhiMean", "type": "esriFieldTypeDouble", "alias": "Mean Phi", "domain": null }, { "name": "MunsellHueWet", "type": "esriFieldTypeString", "alias": "Munsell Hue Wet", "length": 10, "domain": null }, { "name": "MunsellValueWet", "type": "esriFieldTypeDouble", "alias": "Munsell Value Wet", "domain": null }, { "name": "MunsellChromaWet", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Wet", "domain": null }, { "name": "SedimentClassification", "type": "esriFieldTypeString", "alias": "Sediment Classification", "length": 50, "domain": null }, { "name": "ClassificationSystem", "type": "esriFieldTypeString", "alias": "Classification System", "length": 15, "domain": null }, { "name": "SedimentDescription", "type": "esriFieldTypeString", "alias": "Sediment Description", "length": 1000, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalLayerID", "type": "esriFieldTypeGUID", "alias": "Global Layer ID", "length": 38, "domain": null }, { "name": "Layers_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "length": 38, "domain": null } ], "indexes": [ { "name": "R14_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Sample", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4615BDA5-306A-438E-B54D-223D2B0B22B9}" }, { "id": 0, "name": "CoreSamples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Layers_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{834C69AD-30B4-4A75-A0A8-37E4AC90CF1C}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 3, "name": "Sample", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SourceName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "length": 50, "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "CoreLayerID", "type": "esriFieldTypeString", "alias": "Core Layer ID", "length": 50, "domain": null }, { "name": "AnalysisDate", "type": "esriFieldTypeDate", "alias": "Analysis Date", "length": 8, "domain": null }, { "name": "TopInterval", "type": "esriFieldTypeDouble", "alias": "Top of Sample Interval", "domain": null }, { "name": "BottomInterval", "type": "esriFieldTypeDouble", "alias": "Bottom of Sample Interval", "domain": null }, { "name": "GrabElevation", "type": "esriFieldTypeDouble", "alias": "Grab Elevation", "domain": null }, { "name": "SampleBase_ft", "type": "esriFieldTypeDouble", "alias": "Sample Base (ft)", "domain": null }, { "name": "SandUnitThickness", "type": "esriFieldTypeDouble", "alias": "Sand Unit Thickness", "domain": null }, { "name": "PhiMethod", "type": "esriFieldTypeString", "alias": "Phi Method", "length": 50, "domain": null }, { "name": "PhiMean", "type": "esriFieldTypeDouble", "alias": "Phi Mean", "domain": null }, { "name": "PhiMedian", "type": "esriFieldTypeDouble", "alias": "Phi Median", "domain": null }, { "name": "PhiSD", "type": "esriFieldTypeDouble", "alias": "Phi Standard Deviation", "domain": null }, { "name": "PhiSkewness", "type": "esriFieldTypeDouble", "alias": "Phi Skewness", "domain": null }, { "name": "PhiKurtosis", "type": "esriFieldTypeDouble", "alias": "Phi Kurtosis", "domain": null }, { "name": "PctGravel", "type": "esriFieldTypeDouble", "alias": "Percent Gravel", "domain": null }, { "name": "PctSand", "type": "esriFieldTypeDouble", "alias": "Percent Sand", "domain": null }, { "name": "PctClay", "type": "esriFieldTypeDouble", "alias": "Percent Clay", "domain": null }, { "name": "PctSilt", "type": "esriFieldTypeDouble", "alias": "Percent Silt", "domain": null }, { "name": "PctFines", "type": "esriFieldTypeDouble", "alias": "Percent Fines", "domain": null }, { "name": "PctPanFraction", "type": "esriFieldTypeDouble", "alias": "Percent Pan Fraction", "domain": null }, { "name": "PctCarbonate", "type": "esriFieldTypeDouble", "alias": "Percent Carbonate", "domain": null }, { "name": "PctCarbonateSand", "type": "esriFieldTypeDouble", "alias": "Percent Carbonate Sand", "domain": null }, { "name": "PctShellFragments", "type": "esriFieldTypeDouble", "alias": "Percent Shell Fragments", "domain": null }, { "name": "PctHeavyMinerals", "type": "esriFieldTypeDouble", "alias": "Percent Heavy Minerals", "domain": null }, { "name": "PctOrganics", "type": "esriFieldTypeDouble", "alias": "Percent Organics", "domain": null }, { "name": "CarbonateDissolved", "type": "esriFieldTypeString", "alias": "Carbonate Dissolved", "length": 1, "domain": null }, { "name": "HeavyMineralsDissolved", "type": "esriFieldTypeString", "alias": "Heavy Minerals Dissolved", "length": 1, "domain": null }, { "name": "OrganicsRemoved", "type": "esriFieldTypeString", "alias": "Organics Removed", "length": 1, "domain": null }, { "name": "ShellFragmentsRemoved", "type": "esriFieldTypeString", "alias": "Shell Fragments Removed", "length": 1, "domain": null }, { "name": "SortMethod", "type": "esriFieldTypeString", "alias": "Sort Method", "length": 50, "domain": null }, { "name": "Sphericity", "type": "esriFieldTypeDouble", "alias": "Sphericity", "domain": null }, { "name": "SpherDesc", "type": "esriFieldTypeString", "alias": "Sphericity Description", "length": 50, "domain": null }, { "name": "Roundness", "type": "esriFieldTypeDouble", "alias": "Roundness", "domain": null }, { "name": "RoundDesc", "type": "esriFieldTypeString", "alias": "Round Description", "length": 50, "domain": null }, { "name": "Sort_Descrpt", "type": "esriFieldTypeString", "alias": "Sorting Description", "length": 50, "domain": null }, { "name": "Porosity", "type": "esriFieldTypeDouble", "alias": "Porosity", "domain": null }, { "name": "OilPresent", "type": "esriFieldTypeString", "alias": "Oil Present", "length": 3, "domain": null }, { "name": "SourceID", "type": "esriFieldTypeString", "alias": "Source ID", "length": 50, "domain": null }, { "name": "SourceName", "type": "esriFieldTypeString", "alias": "Source Name", "length": 50, "domain": null }, { "name": "SCOrigin", "type": "esriFieldTypeString", "alias": "CMECS SC Origin", "length": 30, "domain": null }, { "name": "SCClass", "type": "esriFieldTypeString", "alias": "CMECS SC Class", "length": 50, "domain": null }, { "name": "SCSubclass", "type": "esriFieldTypeString", "alias": "CMECS SC Sublass", "length": 50, "domain": null }, { "name": "SCGroup", "type": "esriFieldTypeString", "alias": "CMECS SC Group", "length": 50, "domain": null }, { "name": "SCSubgroup", "type": "esriFieldTypeString", "alias": "CMECS SC Subgroup", "length": 50, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Samples_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Global Sample ID", "length": 38, "domain": null }, { "name": "Samples_GlobalLayerID", "type": "esriFieldTypeGUID", "alias": "Global Layer ID", "length": 38, "domain": null }, { "name": "Samples_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Global Table ID", "length": 38, "domain": null } ], "indexes": [ { "name": "R33_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Munsell", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B6DF4195-2CEE-4195-B7E1-4AE0D125B3AB}" }, { "id": 4, "name": "Phi", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{99E01F27-AF74-4B9E-971E-5D8B246B9119}" }, { "id": 1, "name": "CoreSamples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6BC9BAF9-7DA7-4506-A550-155E400B46C8}" }, { "id": 3, "name": "CoreLayers", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4615BDA5-306A-438E-B54D-223D2B0B22B9}" }, { "id": 2, "name": "GrabSamples", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0111C50A-D6D3-4A20-B169-C9B5459AB912}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 4, "name": "Phi", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Comments", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "PHI_N_10Less", "type": "esriFieldTypeDouble", "alias": "Phi -10 or less (% retained)", "domain": null }, { "name": "PHI_N_09", "type": "esriFieldTypeDouble", "alias": "Phi -9 (% retained)", "domain": null }, { "name": "PHI_N_08", "type": "esriFieldTypeDouble", "alias": "Phi -8 (% retained)", "domain": null }, { "name": "PHI_N_07", "type": "esriFieldTypeDouble", "alias": "Phi -7 (% retained)", "domain": null }, { "name": "PHI_N_06_75", "type": "esriFieldTypeDouble", "alias": "Phi -6.75 (% retained)", "domain": null }, { "name": "PHI_N_06_50", "type": "esriFieldTypeDouble", "alias": "Phi -6.5 (% retained)", "domain": null }, { "name": "PHI_N_06_25", "type": "esriFieldTypeDouble", "alias": "Phi -6.25 (% retained)", "domain": null }, { "name": "PHI_N_06", "type": "esriFieldTypeDouble", "alias": "Phi -6 (% retained)", "domain": null }, { "name": "PHI_N_05_75", "type": "esriFieldTypeDouble", "alias": "Phi -5.75 (% retained)", "domain": null }, { "name": "PHI_N_05_50", "type": "esriFieldTypeDouble", "alias": "Phi -5.5 (% retained)", "domain": null }, { "name": "PHI_N_05_25", "type": "esriFieldTypeDouble", "alias": "Phi -5.25 (% retained)", "domain": null }, { "name": "PHI_N_05", "type": "esriFieldTypeDouble", "alias": "Phi -5 (% retained)", "domain": null }, { "name": "PHI_N_04_75", "type": "esriFieldTypeDouble", "alias": "Phi -4.75 (% retained)", "domain": null }, { "name": "PHI_N_04_50", "type": "esriFieldTypeDouble", "alias": "Phi -4.5 (% retained)", "domain": null }, { "name": "PHI_N_04_25", "type": "esriFieldTypeDouble", "alias": "Phi -4.25 (% retained)", "domain": null }, { "name": "PHI_N_04", "type": "esriFieldTypeDouble", "alias": "Phi -4 (% retained)", "domain": null }, { "name": "PHI_N_03_75", "type": "esriFieldTypeDouble", "alias": "Phi -3.75 (% retained)", "domain": null }, { "name": "PHI_N_03_50", "type": "esriFieldTypeDouble", "alias": "Phi -3.5 (% retained)", "domain": null }, { "name": "PHI_N_03_25", "type": "esriFieldTypeDouble", "alias": "Phi -3.25 (% retained)", "domain": null }, { "name": "PHI_N_03", "type": "esriFieldTypeDouble", "alias": "Phi -3 (% retained)", "domain": null }, { "name": "PHI_N_02_75", "type": "esriFieldTypeDouble", "alias": "Phi -2.75 (% retained)", "domain": null }, { "name": "PHI_N_02_50", "type": "esriFieldTypeDouble", "alias": "Phi -2.5 (% retained)", "domain": null }, { "name": "PHI_N_02_25", "type": "esriFieldTypeDouble", "alias": "Phi -2.25 (% retained)", "domain": null }, { "name": "PHI_N_02", "type": "esriFieldTypeDouble", "alias": "Phi -2 (% retained)", "domain": null }, { "name": "PHI_N_01_75", "type": "esriFieldTypeDouble", "alias": "Phi -1.75 (% retained)", "domain": null }, { "name": "PHI_N_01_50", "type": "esriFieldTypeDouble", "alias": "Phi -1.5 (% retained)", "domain": null }, { "name": "PHI_N_01_25", "type": "esriFieldTypeDouble", "alias": "Phi -1.25 (% retained)", "domain": null }, { "name": "PHI_N_01", "type": "esriFieldTypeDouble", "alias": "Phi -1 (% retained)", "domain": null }, { "name": "PHI_N_00_75", "type": "esriFieldTypeDouble", "alias": "Phi -0.75 (% retained)", "domain": null }, { "name": "PHI_N_00_50", "type": "esriFieldTypeDouble", "alias": "Phi -0.5 (% retained)", "domain": null }, { "name": "PHI_N_00_25", "type": "esriFieldTypeDouble", "alias": "Phi -0.25 (% retained)", "domain": null }, { "name": "PHI_00", "type": "esriFieldTypeDouble", "alias": "Phi 0 (% retained)", "domain": null }, { "name": "PHI_00_25", "type": "esriFieldTypeDouble", "alias": "Phi 0.25 (% retained)", "domain": null }, { "name": "PHI_00_50", "type": "esriFieldTypeDouble", "alias": "Phi 0.5 (% retained)", "domain": null }, { "name": "PHI_00_75", "type": "esriFieldTypeDouble", "alias": "Phi 0.75 (% retained)", "domain": null }, { "name": "PHI_01", "type": "esriFieldTypeDouble", "alias": "Phi 1 (% retained)", "domain": null }, { "name": "PHI_01_25", "type": "esriFieldTypeDouble", "alias": "Phi 1.25 (% retained)", "domain": null }, { "name": "PHI_01_50", "type": "esriFieldTypeDouble", "alias": "Phi 1.5 (% retained)", "domain": null }, { "name": "PHI_01_75", "type": "esriFieldTypeDouble", "alias": "Phi 1.75 (% retained)", "domain": null }, { "name": "PHI_02", "type": "esriFieldTypeDouble", "alias": "Phi 2 (% retained)", "domain": null }, { "name": "PHI_02_25", "type": "esriFieldTypeDouble", "alias": "Phi 2.25 (% retained)", "domain": null }, { "name": "PHI_02_50", "type": "esriFieldTypeDouble", "alias": "Phi 2.5 (% retained)", "domain": null }, { "name": "PHI_02_75", "type": "esriFieldTypeDouble", "alias": "Phi 2.75 (% retained)", "domain": null }, { "name": "PHI_03", "type": "esriFieldTypeDouble", "alias": "Phi 3 (% retained)", "domain": null }, { "name": "PHI_03_25", "type": "esriFieldTypeDouble", "alias": "Phi 3.25 (% retained)", "domain": null }, { "name": "PHI_03_50", "type": "esriFieldTypeDouble", "alias": "Phi 3.5 (% retained)", "domain": null }, { "name": "PHI_03_75", "type": "esriFieldTypeDouble", "alias": "Phi 3.75 (% retained)", "domain": null }, { "name": "PHI_04", "type": "esriFieldTypeDouble", "alias": "Phi 4 (% retained)", "domain": null }, { "name": "PHI_04_25", "type": "esriFieldTypeDouble", "alias": "Phi 4.25 (% retained)", "domain": null }, { "name": "PHI_04_50", "type": "esriFieldTypeDouble", "alias": "Phi 4.5 (% retained)", "domain": null }, { "name": "PHI_04_75", "type": "esriFieldTypeDouble", "alias": "Phi 4.75 (% retained)", "domain": null }, { "name": "PHI_05", "type": "esriFieldTypeDouble", "alias": "Phi 5 (% retained)", "domain": null }, { "name": "PHI_06", "type": "esriFieldTypeDouble", "alias": "Phi 6 (% retained)", "domain": null }, { "name": "PHI_07", "type": "esriFieldTypeDouble", "alias": "Phi 7 (% retained)", "domain": null }, { "name": "PHI_08", "type": "esriFieldTypeDouble", "alias": "Phi 8 (% retained)", "domain": null }, { "name": "PHI_09", "type": "esriFieldTypeDouble", "alias": "Phi 9 (% retained)", "domain": null }, { "name": "PHI_10Greater", "type": "esriFieldTypeDouble", "alias": "Phi 10 or Greater (% retained)", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Phi_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Global Table ID", "length": 38, "domain": null } ], "indexes": [ { "name": "R32_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Sample", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "Phi_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{99E01F27-AF74-4B9E-971E-5D8B246B9119}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 5, "name": "Munsell", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MunsellHueWet", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "MunsellHueWet", "type": "esriFieldTypeString", "alias": "Munsell Hue Wet", "length": 10, "domain": null }, { "name": "MunsellValueWet", "type": "esriFieldTypeDouble", "alias": "Munsell Value Wet", "domain": null }, { "name": "MunsellChromaWet", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Wet", "domain": null }, { "name": "MunsellHueWashed", "type": "esriFieldTypeString", "alias": "Munsell Hue Washed", "length": 10, "domain": null }, { "name": "MunsellValueWashed", "type": "esriFieldTypeDouble", "alias": "Munsell Value Washed", "domain": null }, { "name": "MunsellChromaWashed", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Washed", "domain": null }, { "name": "MunsellHueDry", "type": "esriFieldTypeString", "alias": "Munsell Hue Dry", "length": 10, "domain": null }, { "name": "MunsellValueDry", "type": "esriFieldTypeDouble", "alias": "Munsell Value Dry", "domain": null }, { "name": "MunsellChromaDry", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Dry", "domain": null }, { "name": "MunsellHueUnknown", "type": "esriFieldTypeString", "alias": "Munsell Hue Unknown", "length": 10, "domain": null }, { "name": "MunsellValueUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Value Unknown", "domain": null }, { "name": "MunsellChromaUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Unknown", "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "Munsell_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Global Table ID", "length": 38, "domain": null } ], "indexes": [ { "name": "R28_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Sample", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "Munsell_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B6DF4195-2CEE-4195-B7E1-4AE0D125B3AB}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 6, "name": "SampMun", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MunsellHueWet", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "SampleID", "length": 50, "domain": null }, { "name": "MunsellHueWet", "type": "esriFieldTypeString", "alias": "MunsellHueWet", "length": 10, "domain": null }, { "name": "MunsellValueWet", "type": "esriFieldTypeDouble", "alias": "MunsellValueWet", "domain": null }, { "name": "MunsellChromaWet", "type": "esriFieldTypeDouble", "alias": "MunsellChromaWet", "domain": null }, { "name": "MunsellHueWashed", "type": "esriFieldTypeString", "alias": "MunsellHueWashed", "length": 10, "domain": null }, { "name": "MunsellValueWashed", "type": "esriFieldTypeDouble", "alias": "MunsellValueWashed", "domain": null }, { "name": "MunsellChromaWashed", "type": "esriFieldTypeDouble", "alias": "MunsellChromaWashed", "domain": null }, { "name": "MunsellHueDry", "type": "esriFieldTypeString", "alias": "MunsellHueDry", "length": 10, "domain": null }, { "name": "MunsellValueDry", "type": "esriFieldTypeDouble", "alias": "MunsellValueDry", "domain": null }, { "name": "MunsellChromaDry", "type": "esriFieldTypeDouble", "alias": "MunsellChromaDry", "domain": null }, { "name": "MunsellHueUnknown", "type": "esriFieldTypeString", "alias": "MunsellHueUnknown", "length": 10, "domain": null }, { "name": "MunsellValueUnknown", "type": "esriFieldTypeDouble", "alias": "MunsellValueUnknown", "domain": null }, { "name": "MunsellChromaUnknown", "type": "esriFieldTypeDouble", "alias": "MunsellChromaUnknown", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "StudyID", "length": 250, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "precision": 1, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "precision": 1, "domain": null }, { "name": "Samples_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Samples_GlobalSampleID", "length": 38, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 7, "name": "SampPhi", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Comments", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "SampleID", "length": 50, "domain": null }, { "name": "PHI_N_10Less", "type": "esriFieldTypeDouble", "alias": "PHI_N_10Less", "domain": null }, { "name": "PHI_N_09", "type": "esriFieldTypeDouble", "alias": "PHI_N_09", "domain": null }, { "name": "PHI_N_08", "type": "esriFieldTypeDouble", "alias": "PHI_N_08", "domain": null }, { "name": "PHI_N_07", "type": "esriFieldTypeDouble", "alias": "PHI_N_07", "domain": null }, { "name": "PHI_N_06_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_06_75", "domain": null }, { "name": "PHI_N_06_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_06_50", "domain": null }, { "name": "PHI_N_06_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_06_25", "domain": null }, { "name": "PHI_N_06", "type": "esriFieldTypeDouble", "alias": "PHI_N_06", "domain": null }, { "name": "PHI_N_05_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_05_75", "domain": null }, { "name": "PHI_N_05_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_05_50", "domain": null }, { "name": "PHI_N_05_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_05_25", "domain": null }, { "name": "PHI_N_05", "type": "esriFieldTypeDouble", "alias": "PHI_N_05", "domain": null }, { "name": "PHI_N_04_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_04_75", "domain": null }, { "name": "PHI_N_04_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_04_50", "domain": null }, { "name": "PHI_N_04_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_04_25", "domain": null }, { "name": "PHI_N_04", "type": "esriFieldTypeDouble", "alias": "PHI_N_04", "domain": null }, { "name": "PHI_N_03_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_03_75", "domain": null }, { "name": "PHI_N_03_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_03_50", "domain": null }, { "name": "PHI_N_03_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_03_25", "domain": null }, { "name": "PHI_N_03", "type": "esriFieldTypeDouble", "alias": "PHI_N_03", "domain": null }, { "name": "PHI_N_02_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_02_75", "domain": null }, { "name": "PHI_N_02_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_02_50", "domain": null }, { "name": "PHI_N_02_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_02_25", "domain": null }, { "name": "PHI_N_02", "type": "esriFieldTypeDouble", "alias": "PHI_N_02", "domain": null }, { "name": "PHI_N_01_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_01_75", "domain": null }, { "name": "PHI_N_01_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_01_50", "domain": null }, { "name": "PHI_N_01_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_01_25", "domain": null }, { "name": "PHI_N_01", "type": "esriFieldTypeDouble", "alias": "PHI_N_01", "domain": null }, { "name": "PHI_N_00_75", "type": "esriFieldTypeDouble", "alias": "PHI_N_00_75", "domain": null }, { "name": "PHI_N_00_50", "type": "esriFieldTypeDouble", "alias": "PHI_N_00_50", "domain": null }, { "name": "PHI_N_00_25", "type": "esriFieldTypeDouble", "alias": "PHI_N_00_25", "domain": null }, { "name": "PHI_00", "type": "esriFieldTypeDouble", "alias": "PHI_00", "domain": null }, { "name": "PHI_00_25", "type": "esriFieldTypeDouble", "alias": "PHI_00_25", "domain": null }, { "name": "PHI_00_50", "type": "esriFieldTypeDouble", "alias": "PHI_00_50", "domain": null }, { "name": "PHI_00_75", "type": "esriFieldTypeDouble", "alias": "PHI_00_75", "domain": null }, { "name": "PHI_01", "type": "esriFieldTypeDouble", "alias": "PHI_01", "domain": null }, { "name": "PHI_01_25", "type": "esriFieldTypeDouble", "alias": "PHI_01_25", "domain": null }, { "name": "PHI_01_50", "type": "esriFieldTypeDouble", "alias": "PHI_01_50", "domain": null }, { "name": "PHI_01_75", "type": "esriFieldTypeDouble", "alias": "PHI_01_75", "domain": null }, { "name": "PHI_02", "type": "esriFieldTypeDouble", "alias": "PHI_02", "domain": null }, { "name": "PHI_02_25", "type": "esriFieldTypeDouble", "alias": "PHI_02_25", "domain": null }, { "name": "PHI_02_50", "type": "esriFieldTypeDouble", "alias": "PHI_02_50", "domain": null }, { "name": "PHI_02_75", "type": "esriFieldTypeDouble", "alias": "PHI_02_75", "domain": null }, { "name": "PHI_03", "type": "esriFieldTypeDouble", "alias": "PHI_03", "domain": null }, { "name": "PHI_03_25", "type": "esriFieldTypeDouble", "alias": "PHI_03_25", "domain": null }, { "name": "PHI_03_50", "type": "esriFieldTypeDouble", "alias": "PHI_03_50", "domain": null }, { "name": "PHI_03_75", "type": "esriFieldTypeDouble", "alias": "PHI_03_75", "domain": null }, { "name": "PHI_04", "type": "esriFieldTypeDouble", "alias": "PHI_04", "domain": null }, { "name": "PHI_04_25", "type": "esriFieldTypeDouble", "alias": "PHI_04_25", "domain": null }, { "name": "PHI_04_50", "type": "esriFieldTypeDouble", "alias": "PHI_04_50", "domain": null }, { "name": "PHI_04_75", "type": "esriFieldTypeDouble", "alias": "PHI_04_75", "domain": null }, { "name": "PHI_05", "type": "esriFieldTypeDouble", "alias": "PHI_05", "domain": null }, { "name": "PHI_06", "type": "esriFieldTypeDouble", "alias": "PHI_06", "domain": null }, { "name": "PHI_07", "type": "esriFieldTypeDouble", "alias": "PHI_07", "domain": null }, { "name": "PHI_08", "type": "esriFieldTypeDouble", "alias": "PHI_08", "domain": null }, { "name": "PHI_09", "type": "esriFieldTypeDouble", "alias": "PHI_09", "domain": null }, { "name": "PHI_10Greater", "type": "esriFieldTypeDouble", "alias": "PHI_10Greater", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "StudyID", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "precision": 1, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "precision": 1, "domain": null }, { "name": "Phi_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Phi_GlobalTableID", "length": 38, "domain": null }, { "name": "Samples_GlobalSampleID", "type": "esriFieldTypeGUID", "alias": "Samples_GlobalSampleID", "length": 38, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c8b75f611f4a4e91a6acfd87548b6768" } ] }