{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.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": 4269, "latestWkid": 4269, "xyTolerance": 8.98315284119522E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "RuleID", "fieldDelimiter": ", ", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 0 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "defaultLabel": "Invalid Rule", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 0 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "1", "label": "Core Samples" } ] }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -88.36782484599996, "ymin": 30.015324504000034, "xmax": -87.56966506699996, "ymax": 30.213324451000062, "spatialReference": { "wkid": 4269, "latestWkid": 4269, "xyTolerance": 8.983152841195213E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 1.125899906842624E13, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CoreID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "length": 50, "domain": null }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "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": { "type": "codedValue", "name": "CoreType", "description": "", "codedValues": [ { "name": "Vibracore", "code": "Vibracore" }, { "name": "Push Core", "code": "Push Core" }, { "name": "Jet Probe", "code": "Jet Probe" }, { "name": "Box Core", "code": "Box Core" }, { "name": "Boring", "code": "Boring" }, { "name": "Air Rotary", "code": "Air Rotary" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Dug", "code": "Dug" }, { "name": "Dredge", "code": "Dredge" }, { "name": "Soil Auger", "code": "Soil Auger" }, { "name": "Gravity Core", "code": "Gravity" }, { "name": "Split Spoon Core", "code": "SplitSpoon" }, { "name": "Standard Penetration Testing", "code": "SPT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "NumberCoreBoxes", "type": "esriFieldTypeDouble", "alias": "Number of Core Boxes", "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": "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": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "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": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "Cores_GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "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": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G151Cores_Global", "fields": "Cores_GlobalAttachID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G151GlobalSample", "fields": "GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G151Core_GlobalL", "fields": "Core_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Core Layers", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{308CD7A7-A812-427C-A797-0FD5148B8DB5}" }, { "id": 1, "name": "SampleAttachments", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "Cores_GlobalAttachID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DF1081A0-D52E-4D10-97A3-7A912B2CC2C4}" }, { "id": 2, "name": "SampleTable", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2E37C26E-F628-4816-94A2-43C647F52A7D}" }, { "id": 3, "name": "LinkDocumentsTable", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Core_GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A0BC41E0-C0BB-4B16-8BB7-303AFE65CBF1}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 11.3, "cimVersion": "3.3.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": 4269, "latestWkid": 4269, "xyTolerance": 8.98315284119522E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "RuleID", "fieldDelimiter": ", ", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 0 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "defaultLabel": "Invalid Rule", "uniqueValueInfos": [ { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 0, 0, 0 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "1", "label": "Grab Samples" } ] }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -88.36782484599996, "ymin": 30.015324504000034, "xmax": -87.56966506699996, "ymax": 30.213324451000062, "spatialReference": { "wkid": 4269, "latestWkid": 4269, "xyTolerance": 8.983152841195213E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 1.125899906842624E13, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "GrabID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GrabID", "type": "esriFieldTypeString", "alias": "Grab ID", "length": 50, "domain": null }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "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": "PenetrationDepth", "type": "esriFieldTypeDouble", "alias": "Penetration Depth (ft)", "domain": null }, { "name": "SedimentClassification", "type": "esriFieldTypeString", "alias": "Sediment Classification", "length": 50, "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": "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": "SedimentDescription", "type": "esriFieldTypeString", "alias": "Sediment Description", "length": 300, "domain": null }, { "name": "ClassificationSystem", "type": "esriFieldTypeString", "alias": "Classification System", "length": 15, "domain": null }, { "name": "VertDatum", "type": "esriFieldTypeString", "alias": "Vertical Datum", "length": 20, "domain": null }, { "name": "Elevation_ft", "type": "esriFieldTypeDouble", "alias": "Elevation (ft)", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "Grabs_GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "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": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G148Grabs_Global", "fields": "Grabs_GlobalAttachID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G148GlobalSample", "fields": "GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G148Grab_GlobalL", "fields": "Grab_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "SampleAttachments", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "Grabs_GlobalAttachID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3FDC731A-ED75-42B0-B583-69D378BC44C7}" }, { "id": 5, "name": "Sample Table", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0E7E532E-7076-47E0-9F14-5CADC76AFB43}" }, { "id": 6, "name": "LinkDocuments Table", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "Grab_GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0A249965-5A5D-4F2A-8C16-D384CC63D107}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Offshore Study Areas", "type": "Feature Layer", "description": "The Shore Study Areas layer contains polygons delineating locations along the U.S. coastline that have experienced increased erosion and, as a result, prompted environmental studies to determine (1) the extent of erosion, (2) baseline documentation of shore sediment character, and (3) if the site could benefit from shoreline stabilization and beach nourishment in order to reduce coastal storm flooding and erosion, and provide economic, cultural, recreational, and environmental habitat benefits. If a shoreline area is designated as being in need of restoration and renourishment, and a composite match is made between the shore sand and sand in the Federal Outer Continental Shelf (OCS), then entities may enter into a Negotiated Non-Competitive Lease or Memoranda of Agreement with the Bureau of Ocean Energy Management (BOEM), in order to dredge sand, gravel, or shell resources from the OCS. Section 8 (k) of the OCS Lands Act (OCSLA) as amended by Public Law 103-426 (enacted in 1994) gives BOEM the authority to negotiate an agreement for the use of OCS sand, gravel, and shell resources for use in: (1) a project for shore protection, beach restoration, or coastal restoration undertaken by a Federal, State, or local government agency; or (2) for use in a construction project funded in whole or in part by or authorized by the Federal government. This dataset is a collection of previous and current shore study areas. Attribution consists of Study ID, year of study, and summarized sediment descriptions. The polygon extents are not guaranteed to be exact and may contain estimate boundaries delineated based on visual interpretation of drawings and descriptions found in study documents and post construction reports. The dataset will be updated on a regular basis to reflect new and previous study areas.", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 4269, "latestWkid": 4269, "xyTolerance": 8.98315284119522E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "RuleID", "fieldDelimiter": ", ", "defaultSymbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 255, 0, 0, 255 ], "outline": null }, "defaultLabel": "Invalid Rule", "uniqueValueInfos": [ { "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 240, 240, 240, 0 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 0, 112, 255, 255 ], "width": 1.5 } }, "value": "1", "label": "OCSStudyAreas" } ] }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -88.40613570499994, "ymin": 29.981681348000052, "xmax": -87.51859674899998, "ymax": 30.239852867000025, "spatialReference": { "wkid": 4269, "latestWkid": 4269, "xyTolerance": 8.983152841195213E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 1.125899906842624E13, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "StudyID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Study_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "StudyLink", "type": "esriFieldTypeString", "alias": "Study Link", "length": 200, "domain": null }, { "name": "SHAPE_Length", "type": "esriFieldTypeDouble", "alias": "SHAPE_Length", "domain": null }, { "name": "SHAPE_Area", "type": "esriFieldTypeDouble", "alias": "SHAPE_Area", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "Year", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "OCSStudyAreas_Rep_2_Rules", "description": "Representation rules", "codedValues": [ { "name": "OCSStudyAreas", "code": 1 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_SHAPE", "fields": "SHAPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G186Study_Global", "fields": "Study_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "Link Documents Table", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "Study_GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{22553242-04DC-4369-A2DA-234342C3DEBE}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": false, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "SHAPE_Area", "shapeLengthFieldName": "SHAPE_Length", "units": "esriDecimalDegrees", "mapUnits": {"uwkid": 9102} }, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": false } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "CoreLayers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CoreLayerID", "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": "SedimentDescription", "type": "esriFieldTypeString", "alias": "Sediment Description", "length": 1000, "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 }, { "name": "ClassificationSystem", "type": "esriFieldTypeString", "alias": "Classification System", "length": 15, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G102GlobalLayerI", "fields": "GlobalLayerID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G102Layers_Globa", "fields": "Layers_GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 8, "name": "Sample", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{84B12B0A-CE55-41F9-B107-4C94A64B2061}" }, { "id": 0, "name": "Core Samples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Layers_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{308CD7A7-A812-427C-A797-0FD5148B8DB5}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "LinkDocuments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ReportTitle", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ReportTitle", "type": "esriFieldTypeString", "alias": "Report Title", "length": 250, "domain": null }, { "name": "Constraints", "type": "esriFieldTypeString", "alias": "Access Constraints", "length": 3, "domain": { "type": "codedValue", "name": "Constraints", "description": "Access Constraints", "codedValues": [ { "name": "Option 1", "code": "1" }, { "name": "Option 2", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "Report", "type": "esriFieldTypeString", "alias": "Report", "length": 250, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 25, "domain": null }, { "name": "Year", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G112GlobalLinkID", "fields": "GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Grab Samples", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0A249965-5A5D-4F2A-8C16-D384CC63D107}" }, { "id": 7, "name": "OCS Study Areas", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{22553242-04DC-4369-A2DA-234342C3DEBE}" }, { "id": 3, "name": "CoreSamples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A0BC41E0-C0BB-4B16-8BB7-303AFE65CBF1}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "Munsell", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SampleID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "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": "MunsellChromaUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Unknown", "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "MunsellValueUnknown", "type": "esriFieldTypeDouble", "alias": "MunsellValueUnknown", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Munsell_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Munsell_GlobalTableID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G113Munsell_Glob", "fields": "Munsell_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 9, "name": "Sample", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "Munsell_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{61E27EF4-F597-4EFA-B3CD-EE892F394451}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Phi", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SampleID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "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": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Phi_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Phi_GlobalTableID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G114Phi_GlobalTa", "fields": "Phi_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "Sample", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "Phi_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9597531-81FF-42FA-B9E4-B08E70B51C2D}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "Sample", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SampleID", "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": "CoreLayerID", "type": "esriFieldTypeString", "alias": "Core Layer ID", "length": 50, "domain": null }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core 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": { "type": "codedValue", "name": "Yes_No", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HeavyMineralsDissolved", "type": "esriFieldTypeString", "alias": "Heavy Minerals Dissolved", "length": 1, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OrganicsRemoved", "type": "esriFieldTypeString", "alias": "Organics Removed", "length": 1, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ShellFragmentsRemoved", "type": "esriFieldTypeString", "alias": "Shell Fragments Removed", "length": 1, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SortMethod", "type": "esriFieldTypeString", "alias": "Sort Method", "length": 50, "domain": null }, { "name": "SpherDesc", "type": "esriFieldTypeString", "alias": "Sphericity Description", "length": 50, "domain": null }, { "name": "RoundDesc", "type": "esriFieldTypeString", "alias": "Round Description", "length": 50, "domain": null }, { "name": "OilPresent", "type": "esriFieldTypeString", "alias": "Oil Present", "length": 3, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes/No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SourceID", "type": "esriFieldTypeString", "alias": "Source ID", "length": 50, "domain": null }, { "name": "SourceName", "type": "esriFieldTypeString", "alias": "Source Name", "length": 50, "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": "SCOrigin", "type": "esriFieldTypeString", "alias": "CMECS SC Origin", "length": 30, "domain": { "type": "codedValue", "name": "SCOrigin", "description": "CMECS SC Origin", "codedValues": [ { "name": "Geologic Substrate", "code": "Geologic Substrate" }, { "name": "Biogenic Substrate", "code": "Biogenic Substrate" }, { "name": "Anthropogenic Substrate", "code": "Anthropogenic Substrate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SCClass", "type": "esriFieldTypeString", "alias": "CMECS SC Class\nCMECS SC Class", "length": 50, "domain": { "type": "codedValue", "name": "SCClass", "description": "SCClass", "codedValues": [ { "name": "Rock Substrate", "code": "s1.1-Rock Substrate" }, { "name": "Unconsolidated Mineral Substrate", "code": "s1.2-Unconsolidated Mineral Substrate" }, { "name": "Algal Substrate", "code": "s2.1-Algal Substrate" }, { "name": "Coral Substrate", "code": "s2.2-Coral Substrate" }, { "name": "Organic Substrate", "code": "s2.3-Organic Substrate" }, { "name": "Ooze Substrate", "code": "s2.4-Ooze Substrate" }, { "name": "Shell Substrate", "code": "s2.5-Shell Substrate" }, { "name": "Worm Substrate", "code": "s2.6-Worm Substrate" }, { "name": "Anthropogenic Rock", "code": "s3.1-Anthropogenic Rock" }, { "name": "Anthropogenic Wood", "code": "s3.2-Anthropogenic Wood" }, { "name": "Construction Materials", "code": "s3.3-Construction Materials" }, { "name": "Metal", "code": "s3.4-Metal" }, { "name": "Trash", "code": "s3.5-Trash" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SCSubclass", "type": "esriFieldTypeString", "alias": "CMECS SC Sublass", "length": 50, "domain": { "type": "codedValue", "name": "SCSubclass", "description": "CMECS SC Subclass", "codedValues": [ { "name": "Bedrock", "code": "s1.1.1-Bedrock" }, { "name": "Megaclast", "code": "s1.1.2-Megaclast" }, { "name": "Coarse Unconsolidated Substrate", "code": "s1.2.1-Coarse Unconsolidated Substrate" }, { "name": "Fine Unconsolidated Substrate", "code": "s1.2.2-Fine Unconsolidated Substrate" }, { "name": "Algal Sand", "code": "s2.1.1-Algal Sand" }, { "name": "Rhodolith Substrate", "code": "s2.1.2-Rhodolith Substrate" }, { "name": "Coral Reef Substrate", "code": "s2.2.1-Coral Reef Substrate" }, { "name": "Coral Rubble", "code": "s2.2.2-Coral Rubble" }, { "name": "Coral Hash", "code": "s2.2.3-Coral Hash" }, { "name": "Coral Sand", "code": "s2.2.4-Coral Sand" }, { "name": "Organic Debris", "code": "s2.3.1-Organic Debris" }, { "name": "Organic Detritus", "code": "s2.3.2-Organic Detritus" }, { "name": "Organic Mud", "code": "s2.3.3-Organic Mud" }, { "name": "Carbonate Ooze", "code": "s2.4.1-Carbonate Ooze" }, { "name": "Siliceous Ooze", "code": "s2.4.2-Siliceous Ooze" }, { "name": "Shell Reef Substrate", "code": "s2.5.1-Shell Reef Substrate" }, { "name": "Shell Rubble", "code": "s2.5.2-Shell Rubble" }, { "name": "Shell Hash", "code": "s2.5.3-Shell Hash" }, { "name": "Shell Sand", "code": "s2.5.4-Shell Sand" }, { "name": "Sabellariid Substrate", "code": "s2.6.1-Sabellariid Substrate" }, { "name": "Serpulid Substrate", "code": "s2.6.2-Serpulid Substrate" }, { "name": "Anthropogenic Rock Reef Substrate", "code": "s3.1.1-Anthropogenic Rock Reef Substrate" }, { "name": "Anthropogenic Rock Rubble", "code": "s3.1.2-Anthropogenic Rock Rubble" }, { "name": "Anthropogenic Rock Hash", "code": "s3.1.3-Anthropogenic Rock Hash" }, { "name": "Anthropogenic Rock Sand", "code": "s3.1.4-Anthropogenic Rock Sand" }, { "name": "Anthropogenic Rock Mud", "code": "s3.1.5-Anthropogenic Rock Mud" }, { "name": "Anthropogenic Wood Reef Substrate", "code": "s3.2.1-Anthropogenic Wood Reef Substrate" }, { "name": "Anthropogenic Wood Rubble", "code": "s3.2.2-Anthropogenic Wood Rubble" }, { "name": "Anthropogenic Wood Hash", "code": "s3.2.3-Anthropogenic Wood Hash" }, { "name": "Construction Reef", "code": "s3.3.1-Construction Reef" }, { "name": "Construction Rubble", "code": "s3.3.2-Construction Rubble" }, { "name": "Construction Hash", "code": "s3.3.3-Construction Hash" }, { "name": "Metal Reef Substrate", "code": "s3.4.1-Metal Reef Substrate" }, { "name": "Metal Rubble", "code": "s3.4.2-Metal Rubble" }, { "name": "Metal Hash", "code": "s3.4.3-Metal Hash" }, { "name": "Trash Rubble", "code": "s3.5.1-Trash Rubble" }, { "name": "Trash Bits", "code": "s3.5.2-Trash Bits" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SCGroup", "type": "esriFieldTypeString", "alias": "CMECS SC Group", "length": 50, "domain": { "type": "codedValue", "name": "SCGroup", "description": "CMECS SC Group", "codedValues": [ { "name": "Gravel", "code": "s1.2.1.1-Gravel" }, { "name": "Gravel Mixes", "code": "s1.2.1.2-Gravel Mixes" }, { "name": "Gravelly", "code": "s1.2.1.3-Gravelly" }, { "name": "Slightly Gravelly", "code": "s1.2.2.1-Slightly Gravelly" }, { "name": "Sand", "code": "s1.2.2.2-Sand" }, { "name": "Muddy Sand", "code": "s1.2.2.3-Muddy Sand" }, { "name": "Sandy Mud", "code": "s1.2.2.4-Sandy Mud" }, { "name": "Mud", "code": "s1.2.2.5-Mud" }, { "name": "Halimeda Sand", "code": "s2.1.1.1-Halimeda Sand" }, { "name": "Rhodolith Rubble", "code": "s2.1.2.1-Rhodolith Rubble" }, { "name": "Rhodoliith Hash", "code": "s2.1.2.2-Rhodoliith Hash" }, { "name": "Rhodolith Sand", "code": "s2.1.2.3-Rhodolith Sand" }, { "name": "Peat Debris", "code": "s2.3.1.1-Peat Debris" }, { "name": "Woody Debris", "code": "s2.3.1.2-Woody Debris" }, { "name": "Coccolithophore Ooze", "code": "s2.4.1.1-Coccolithophore Ooze" }, { "name": "Foraminiferan Ooze", "code": "s2.4.1.2-Foraminiferan Ooze" }, { "name": "Pteropod Ooze", "code": "s2.4.1.3-Pteropod Ooze" }, { "name": "Diatomaceous Ooze", "code": "s2.4.2.1-Diatomaceous Ooze" }, { "name": "Radiolarian Ooze", "code": "s2.4.2.2-Radiolarian Ooze" }, { "name": "Clam Reef Substrate", "code": "s2.5.1.1-Clam Reef Substrate" }, { "name": "Crepidula Reef Substrate", "code": "s2.5.1.2-Crepidula Reef Substrate" }, { "name": "Mussel Reef Substrate", "code": "s2.5.1.3-Mussel Reef Substrate" }, { "name": "Oyster Reef Substrate", "code": "s2.5.1.4-Oyster Reef Substrate" }, { "name": "Clam Rubble", "code": "s2.5.2.1-Clam Rubble" }, { "name": "Crepidula Rubble", "code": "s2.5.2.2-Crepidula Rubble" }, { "name": "Mussel Rubble", "code": "s2.5.2.3-Mussel Rubble" }, { "name": "Oyster Rubble", "code": "s2.5.2.4-Oyster Rubble" }, { "name": "Clam Hash", "code": "s2.5.3.1-Clam Hash" }, { "name": "Crepidula Hash", "code": "s2.5.3.2-Crepidula Hash" }, { "name": "Mussel Hash", "code": "s2.5.3.3-Mussel Hash" }, { "name": "Oyster Hash", "code": "s2.5.3.4-Oyster Hash" }, { "name": "Clam Sand", "code": "s2.5.4.1-Clam Sand" }, { "name": "Sabellariid Reef Substrate", "code": "s2.6.1.1-Sabellariid Reef Substrate" }, { "name": "Sabellariid Rubble", "code": "s2.6.1.2-Sabellariid Rubble" }, { "name": "Sabellariid Hash", "code": "s2.6.1.3-Sabellariid Hash" }, { "name": "Sepulid Reef Substrate", "code": "s2.6.2.1-Sepulid Reef Substrate" }, { "name": "Serpulid Rubble", "code": "s2.6.2.2-Serpulid Rubble" }, { "name": "Serpulid Hash", "code": "s2.6.2.3-Serpulid Hash" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SCSubgroup", "type": "esriFieldTypeString", "alias": "CMECS SC Subgroup", "length": 50, "domain": { "type": "codedValue", "name": "SCSubgroup", "description": "CMECS SC Subgroup", "codedValues": [ { "name": "Boulder", "code": "s1.2.1.1.1-Boulder" }, { "name": "Cobble", "code": "s1.2.1.1.2-Cobble" }, { "name": "Pebble", "code": "s1.2.1.1.3-Pebble" }, { "name": "Granule", "code": "s1.2.1.1.4-Granule" }, { "name": "Sandy Gravel", "code": "s1.2.1.2.1-Sandy Gravel" }, { "name": "Muddy Sandy Gravel", "code": "s1.2.1.2.2-Muddy Sandy Gravel" }, { "name": "Muddy Gravel", "code": "s1.2.1.2.3-Muddy Gravel" }, { "name": "Gravelly Sand", "code": "s1.2.1.3.1-Gravelly Sand" }, { "name": "Gravelly Muddy Sand", "code": "s1.2.1.3.2-Gravelly Muddy Sand" }, { "name": "Gravelly Mud", "code": "s1.2.1.3.3-Gravelly Mud" }, { "name": "Slightly Gravelly Sand", "code": "s1.2.2.1.1-Slightly Gravelly Sand" }, { "name": "Slightly Gravelly Muddy Sand", "code": "s1.2.2.1.2-Slightly Gravelly Muddy Sand" }, { "name": "Slightly Gravelly Sandy Mud", "code": "s1.2.2.1.3-Slightly Gravelly Sandy Mud" }, { "name": "Slightly Gravelly Mud", "code": "s1.2.2.1.4-Slightly Gravelly Mud" }, { "name": "Very Coarse Sand", "code": "s1.2.2.2.1-Very Coarse Sand" }, { "name": "Coarse Sand", "code": "s1.2.2.2.2-Coarse Sand" }, { "name": "Medium Sand", "code": "s1.2.2.2.3-Medium Sand" }, { "name": "Fine Sand", "code": "s1.2.2.2.4-Fine Sand" }, { "name": "Very Fine Sand", "code": "s1.2.2.2.5-Very Fine Sand" }, { "name": "Silty Sand", "code": "s1.2.2.3.1-Silty Sand" }, { "name": "Silty-Clayey Sand", "code": "s1.2.2.3.2-Silty-Clayey Sand" }, { "name": "Clayey Sand", "code": "s1.2.2.3.3-Clayey Sand" }, { "name": "Sandy Silt", "code": "s1.2.2.4.1-Sandy Silt" }, { "name": "Sandy Silt-Clay", "code": "s1.2.2.4.2-Sandy Silt-Clay" }, { "name": "Sandy Clay", "code": "s1.2.2.4.3-Sandy Clay" }, { "name": "Silt", "code": "s1.2.2.5.1-Silt" }, { "name": "Silt-Clay", "code": "s1.2.2.5.2-Silt-Clay" }, { "name": "Clay", "code": "s1.2.2.5.3-Clay" }, { "name": "Fine Woody Debris", "code": "s2.3.1.2.1-Fine Woody Debris" }, { "name": "Coarse Woody Debris", "code": "s2.3.1.2.2-Coarse Woody Debris" }, { "name": "Very Coarse Woody Debris", "code": "s2.3.1.2.3-Very Coarse Woody Debris" }, { "name": "Globigerina Ooze", "code": "s2.4.1.2.1-Globigerina Ooze" }, { "name": "Coquina Reef Substrate", "code": "s2.5.1.1.1-Coquina Reef Substrate" }, { "name": "Coquina Rubble", "code": "s2.5.2.1.1-Coquina Rubble" }, { "name": "Coquina Hash", "code": "s2.5.3.1.1-Coquina Hash" }, { "name": "Coquina Sand", "code": "s2.5.4.1.1-Coquina Sand" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sort_Descrpt", "type": "esriFieldTypeString", "alias": "Sorting Description", "length": 50, "domain": null }, { "name": "Sphericity", "type": "esriFieldTypeDouble", "alias": "Sphericity", "domain": null }, { "name": "Roundness", "type": "esriFieldTypeDouble", "alias": "Roundness", "domain": null }, { "name": "Porosity", "type": "esriFieldTypeDouble", "alias": "Porosity", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null }, { "name": "Samples_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Samples_GlobalTableID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G115Samples_Glob", "fields": "Samples_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G115Samples_Glob_1", "fields": "Samples_GlobalLayerID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G115Samples_Glob_2", "fields": "Samples_GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "Phi", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F9597531-81FF-42FA-B9E4-B08E70B51C2D}" }, { "id": 9, "name": "Munsell", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{61E27EF4-F597-4EFA-B3CD-EE892F394451}" }, { "id": 2, "name": "Core Samples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2E37C26E-F628-4816-94A2-43C647F52A7D}" }, { "id": 8, "name": "CoreLayers", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{84B12B0A-CE55-41F9-B107-4C94A64B2061}" }, { "id": 5, "name": "Grab Samples", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{0E7E532E-7076-47E0-9F14-5CADC76AFB43}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "SampleAttachments", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AttachmentType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "AttachmentType", "type": "esriFieldTypeString", "alias": "Attachment Type", "length": 50, "domain": { "type": "codedValue", "name": "AttachmentType", "description": "Attachment Type", "codedValues": [ { "name": "Penetration Graphs", "code": "PenGraphs" }, { "name": "Grain Size Table", "code": "GrainSizeTable" }, { "name": "Grain Size Plot", "code": "GrainSizePlot" }, { "name": "Data Sheets", "code": "DataSheets" }, { "name": "Photos", "code": "Photos" }, { "name": "gINT", "code": "gINT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AttachmentLink", "type": "esriFieldTypeString", "alias": "Attachment Link", "length": 250, "domain": null }, { "name": "GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach ID", "length": 38, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GlobalID", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G116GlobalAttach", "fields": "GlobalAttachID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "GrabSamples", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GlobalAttachID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3FDC731A-ED75-42B0-B583-69D378BC44C7}" }, { "id": 1, "name": "CoreSamples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GlobalAttachID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{DF1081A0-D52E-4D10-97A3-7A912B2CC2C4}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }