{ "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.983152841195213E-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.46199999999999, "ymin": 29.401000000000067, "xmax": -87.08663208499996, "ymax": 30.545800000000042, "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": "ContactName", "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": "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": "G147Core_GlobalL", "fields": "Core_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G147GlobalSample", "fields": "GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LinkDocumentsTable", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "Core_GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECCB16B3-DE2B-4F68-88DE-8457693B75D5}" }, { "id": 1, "name": "SampleTable", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{256F0C39-0FAA-4177-872C-72C0B7426749}" }, { "id": 2, "name": "Core Layers", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BA5763C4-E946-4F20-A958-CF6E13664D8B}" } ], "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 } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "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": "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": "Samples_GlobalAttachID", "type": "esriFieldTypeGUID", "alias": "Global Attach 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": "G116Samples_Glob", "fields": "Samples_GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G116Samples_Glob_1", "fields": "Samples_GlobalAttachID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G116Samples_Glob_2", "fields": "Samples_GlobalLayerID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G116Samples_Glob_3", "fields": "Samples_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Munsell", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BF8B2C98-9613-436B-ADBB-12B9224E1F2C}" }, { "id": 4, "name": "Phi", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A361294F-E747-4C98-AE18-07A774A9F7BE}" }, { "id": 5, "name": "Sample Attachments", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalAttachID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{53C1FFEB-AF10-43B7-9489-B525F2DF00B2}" }, { "id": 1, "name": "Core Samples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{256F0C39-0FAA-4177-872C-72C0B7426749}" }, { "id": 6, "name": "CoreLayers", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3C8DA5D3-3D20-411A-AEAE-119C2F891237}" } ], "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": 2, "name": "CoreLayers", "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": "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": "G119Layers_Globa", "fields": "Layers_GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G119GlobalLayerI", "fields": "GlobalLayerID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "Sample", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{3C8DA5D3-3D20-411A-AEAE-119C2F891237}" }, { "id": 2, "name": "Core Samples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Layers_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BA5763C4-E946-4F20-A958-CF6E13664D8B}" } ], "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": 3, "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": "G118GlobalLinkID", "fields": "GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "CoreSamples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GlobalLinkID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECCB16B3-DE2B-4F68-88DE-8457693B75D5}" } ], "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": "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": "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": "G124Munsell_Glob", "fields": "Munsell_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Sample", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Munsell_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{BF8B2C98-9613-436B-ADBB-12B9224E1F2C}" } ], "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": "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": "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": "G121Phi_GlobalTa", "fields": "Phi_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Sample", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Phi_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A361294F-E747-4C98-AE18-07A774A9F7BE}" } ], "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": "SampleAttachments", "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": "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": "G125GlobalAttach", "fields": "GlobalAttachID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Sample", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GlobalAttachID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{53C1FFEB-AF10-43B7-9489-B525F2DF00B2}" } ], "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 } } ] }