{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "Core Samples", "type": "Feature Layer", "description": "The Core Samples feature class is a collection of previously acquired sediment core samples, from multiple investigators and projects, collected during research funded completely or partially by the Bureau of Ocean Energy Management (BOEM) on or around the outer Continental Shelf (OCS) and related beach areas. Coring methods represented in this dataset include box, jet probe, core boring, push core, and vibracore. This layer contains information related to acquisition of the cores including study name, contact information, core locations, and core lengths. If samples have been processed from the cores, the associated data (e.g., Munsell color, gradation analyses, carbonate content) is contained in the related Sample and Core Layers tables. The intent is to update the feature class as additional cores are collected.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 5000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "e7795cdea5956c6750030d0979a438dd", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAALCAYAAABLcGxfAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAT5JREFUKJFlkbFLAmEYxn9yH9x1HQ4iamREBQ0ODQVCtEVTDq1BhEhBoOAcWBGSFbmERNAkYa4NEUVN/QVBi1uUJBlSEqdml5ENeUddz/Q98Pze9/ueT9DRLMsjCo4lbGrRPs+zfWp6YR401P0BhifswCPFUJz4ZYbMhwWEXYmIr+r/Fwbw4u+/Rd8Foh1gS2hVR6IL1Qq900RBARxISLjwzM2zks6xcSfCcj3tMQJDZrjANXl2mGGRIFMAuPE6dV72gJCQDXlcIFnTK5QAKFEk+OtqCuoogGhSSzbQT7pxSgBBJvHQSx/WUlq0eJP1AwwQOdJnC6xdDBKYBlDRCDD25+EVHgpZY3PdaukTYs883bjxOe0tNah/1Xoaq5R/vAA4JHkfIXEE7agdeKV6lSunjk1vfVyWVAyI2QG7vgGOrVaVjI66pQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 9, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.04884118466E7, "ymin": 2792519.5320999995, "xmax": -7684607.088400001, "ymax": 5312988.028099999, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ContactName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CoreID", "type": "esriFieldTypeString", "alias": "Core ID", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "length": 8, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "domain": null }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "length": 20, "domain": null }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "length": 20, "domain": null }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "length": 50, "domain": null }, { "name": "CoreType", "type": "esriFieldTypeString", "alias": "Method of Core Sample", "length": 30, "domain": { "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": "Core_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "CoreSamples_Rep_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": "IGSNLink", "type": "esriFieldTypeString", "alias": "International GeoSample Number Link", "length": 100, "domain": null }, { "name": "VertDatum", "type": "esriFieldTypeString", "alias": "Vertical Datum", "length": 20, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R473_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G3628Core_Global", "fields": "Core_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S304_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Core Layers", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "SampleTable", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "hasM": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 1, "name": "Grab Samples", "type": "Feature Layer", "description": "The Grab Samples feature class is a collection of previously acquired sediment grab samples, from multiple investigators and projects, collected during research funded completely or partially by the Bureau of Ocean Energy Management (BOEM) on or around the outer Continental Shelf (OCS) and related beach areas. This layer contains information related to acquisition of the cores including study name, contact information, core locations, and core lengths. If sub-samples have been processed from the grab samples, the associated data (e.g., Munsell color, gradation analyses, carbonate content) is contained in the related Samples table. The intent is to update the feature class as additional grab samples are collected.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 5000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "01cee30a55230b268988d6047ea3dc40", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAALCAYAAABLcGxfAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAT5JREFUKJFlkT1LQnEUxn/aP0RNhSAxMCIuDUo02CSNJly6H6GphIKE5sAEMSPBJSKCoLG5IcJKCaIPUNRgU9grhqGYCXILtMHu1W7Pcl54nsM5zxH8Ir/KZNvEEga02pzIaY61WmiJfYDd4DjTRsHtI0p+hVx4my9dkIsNzvu91X9kAP8Io+UPtoBlAJHfRAyZqzGXtUuqN8FhBRMgzCB5mDtdIyOnKAoalox/QpU0cvYalDTsL0Ik1OmNuXG+VNgBFOGwqcF+c3d64akTr4oQ6VnNZSMAIGo1kuVPjtwO+gAWZsDnhYDUJTe/oVy37IGKkDNkLxOcuX3MAgzaQZn6e/jdM4VwSk3oLqktovdv3EgenEaXKg1a743hOJTQBeEkD+dxDlrtjnW9eK1wIW+UDrVaf1xonSgQNQqM+AFf5VnbklMB2gAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 9, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.04867754498E7, "ymin": 3043814.2661999986, "xmax": -7472843.954399999, "ymax": 5555379.583899997, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ContactName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GrabID", "type": "esriFieldTypeString", "alias": "Grab ID", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "SampleDate", "type": "esriFieldTypeDate", "alias": "Sample Date", "length": 8, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "domain": null }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "length": 20, "domain": null }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "length": 20, "domain": null }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "length": 50, "domain": null }, { "name": "Sampler", "type": "esriFieldTypeString", "alias": "Sampler Device", "length": 250, "domain": null }, { "name": "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": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "GrabSamples_Rep_Rules", "description": "Representation rules", "codedValues": [ { "name": "Grab Samples", "code": 1 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R474_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_474", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3629GlobalSampl", "fields": "GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3629Grab_Global", "fields": "Grab_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_474", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S305_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Sample Table", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 2, "name": "Sediment Profile Image Samples", "type": "Feature Layer", "description": "The SPI Samples feature class is a collection of previously acquired sediment profile images of the sediment-water interface, collected using a sediment profiling camera, from multiple investigators and projects. These data were collected during research funded completely or partially by the Bureau of Ocean Energy Management (BOEM) on or around the outer Continental Shelf (OCS) and related beach areas. This layer contains information related to acquisition, processing, and interpretation of the images. If sub-samples have been processed from the grab samples, the associated data (e.g., Munsell color, gradation analyses, carbonate content) is contained in the related Samples table. The intent is to update the feature class as additional grab samples are collected.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 3000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "3255fb1e02ac1a08ad6884caedcfa8ff", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAALCAYAAABLcGxfAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAWJJREFUKJFlkM0rw3Ecx1/sq8xsM2M5iPSzg5WH5iRHrZYdHDSREIqy8g9IyWUHF0mKXDydFmuShy2SP0BxGIlQiD2YzNOoHxf7aT/v0+ddr1d9Ph/Bb0LtizXfKQZRRZbZcga6N9JdpAddtm6mQapvVAvH0VNXaHgu6Jga+FSEoHup12ay/oMBbIWV5ZGb2CQwBCBCeEVxbtGIUWtQoOf3JHptPllkITQCyVDWud2yMOEM9FwKWksnbEVWKQ1vXuzh8vcx7/DSX9sBQIWpzHCTfJgGXEKfo2/I0SinEH44B+DwLkx/7d9qRq3eDiCeUonxyGt83aIzawD66tqoKpawl1Qr8PtXishbdBZAOP29mwdtvh2LztwMUJhXgMvalHH4Sews7PB1jSlfSn19eC4S10eSqdyAKvG3hBz9eBxNdwHg8Hdd7bpXlmVZHlILty/3+87VnrUMAaDJ1+kBPGpBnR8ZLG1rw1pkLQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 9, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8454837.9827, "ymin": 4278522.801600002, "xmax": -8170849.5167, "ymax": 4946231.890600003, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "State", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 25, "domain": null }, { "name": "N", "type": "esriFieldTypeSmallInteger", "alias": "Number of Samples Collected", "domain": null }, { "name": "Year", "type": "esriFieldTypeSmallInteger", "alias": "Year", "domain": null }, { "name": "TimeofYear", "type": "esriFieldTypeString", "alias": "Time of Year", "length": 10, "domain": { "type": "codedValue", "name": "TimeofYear", "description": "Time of Year", "codedValues": [ { "name": "Spring", "code": "Spring" }, { "name": "Fall", "code": "Fall" }, { "name": "Winter", "code": "Winter" }, { "name": "Summer", "code": "Summer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "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": "Penetration", "type": "esriFieldTypeDouble", "alias": "Penetration in cm", "domain": null }, { "name": "RPD", "type": "esriFieldTypeDouble", "alias": "Redox Potential Discontinuity (cm)", "domain": null }, { "name": "SedType", "type": "esriFieldTypeString", "alias": "Primary sediment description", "length": 50, "domain": null }, { "name": "PhiMajorMode", "type": "esriFieldTypeString", "alias": "Phi Grain Size Major Mode", "length": 10, "domain": null }, { "name": "SurfaceRelief", "type": "esriFieldTypeDouble", "alias": "Difference between highest and lowest surface points in cm", "domain": null }, { "name": "ReliefType", "type": "esriFieldTypeString", "alias": "Structure primarily responsible for roughness", "length": 25, "domain": null }, { "name": "Epifauna", "type": "esriFieldTypeString", "alias": "Presence of Epifauna", "length": 1, "domain": { "type": "codedValue", "name": "Presence_Absence", "description": "Presence/Absence", "codedValues": [ { "name": "Present", "code": "+" }, { "name": "Absent", "code": "-" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EpifaunaType", "type": "esriFieldTypeString", "alias": "Type of Epifauna", "length": 50, "domain": null }, { "name": "Tubes", "type": "esriFieldTypeInteger", "alias": "# of tubes present", "domain": null }, { "name": "Pellets", "type": "esriFieldTypeString", "alias": "Presence of Fecal Pellets ", "length": 1, "domain": { "type": "codedValue", "name": "Presence_Absence", "description": "Presence/Absence", "codedValues": [ { "name": "Present", "code": "+" }, { "name": "Absent", "code": "-" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SubsurfShell", "type": "esriFieldTypeString", "alias": "Approximate shell presence", "length": 10, "domain": null }, { "name": "InfaunaNum", "type": "esriFieldTypeInteger", "alias": "Number of infauna present", "domain": null }, { "name": "InfaunaType", "type": "esriFieldTypeString", "alias": "Type of infauna", "length": 50, "domain": null }, { "name": "InfaunaDepth", "type": "esriFieldTypeDouble", "alias": "Depth of observed infauna (cm)", "domain": null }, { "name": "VoidNum", "type": "esriFieldTypeInteger", "alias": "Number of voids", "domain": null }, { "name": "VoidType", "type": "esriFieldTypeString", "alias": "Type of voids", "length": 50, "domain": null }, { "name": "VoidDepth", "type": "esriFieldTypeDouble", "alias": "Depth of void (cm)", "domain": null }, { "name": "GasNum", "type": "esriFieldTypeInteger", "alias": "Number of gas filled voids", "domain": null }, { "name": "GasDepth", "type": "esriFieldTypeDouble", "alias": "Depth of gas voids (cm)", "domain": null }, { "name": "BurrowNum", "type": "esriFieldTypeInteger", "alias": "Number of infaunal burrows present", "domain": null }, { "name": "BurrowType", "type": "esriFieldTypeString", "alias": "Oxidized or Anoxic sediments", "length": 2, "domain": { "type": "codedValue", "name": "BurrowType", "description": "Burrow Type", "codedValues": [ { "name": "Anoxic", "code": "AN" }, { "name": "Oxidized", "code": "OX" }, { "name": "Both", "code": "BO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InfaunalStage", "type": "esriFieldTypeString", "alias": "Infaunal Successional Stage", "length": 10, "domain": null }, { "name": "HabitatClass", "type": "esriFieldTypeString", "alias": "Habitat class determination", "length": 10, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "Longitude_DD", "type": "esriFieldTypeDouble", "alias": "Longitude (DD)", "domain": null }, { "name": "Latitude_DD", "type": "esriFieldTypeDouble", "alias": "Latitude (DD)", "domain": null }, { "name": "SPI_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "SPISamples_Rep_Rules", "description": "Representation rules", "codedValues": [ { "name": "SPISamples", "code": 1 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "G3626SPI_GlobalL", "fields": "SPI_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S302_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 3, "name": "Camera Stations", "type": "Feature Layer", "description": "The Camera Stations feature class is a collection of previously acquired video and still photo bottom imagery, from multiple investigators and projects, collected during research funded completely or partially by the Bureau of Ocean Energy Management (BOEM) on or around the outer Continental Shelf (OCS). This layer contains information related to the associated project, acquisition, and where available, a link to the images/video. The intent is to update the feature class as additional camera surveys are collected.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 3000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "0db3311ea0ed729544abd9c7e801a0bc", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAYAAACprHcmAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAACVJREFUGJVjYWdnv/Hz5091BsIgkoUIRXAwqphOin/+/KlBrGIA9UgHmDnZs2gAAAAASUVORK5CYII=", "contentType": "image/png", "width": 8, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8446339.2943, "ymin": 4440714.6613000035, "xmax": -7725450.392999999, "ymax": 5436818.426100001, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "State", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeString", "alias": "Project ID", "length": 50, "domain": null }, { "name": "BorrowArea", "type": "esriFieldTypeString", "alias": "Borrow ID", "length": 50, "domain": null }, { "name": "StationID", "type": "esriFieldTypeString", "alias": "Station ID", "length": 50, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "domain": null }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "length": 20, "domain": null }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "length": 20, "domain": null }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "length": 50, "domain": null }, { "name": "Latitude_DD", "type": "esriFieldTypeDouble", "alias": "Latitude (DD)", "domain": null }, { "name": "Longitude_DD", "type": "esriFieldTypeDouble", "alias": "Longitude (DD)", "domain": null }, { "name": "Camera_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "CameraStations_Rep_Rules", "description": "Representation rules", "codedValues": [ { "name": "CameraStations", "code": 1 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "Imagery", "type": "esriFieldTypeString", "alias": "Path to Imagery", "length": 500, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "G3625Camera_Glob", "fields": "Camera_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S301_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.81, "id": 4, "name": "Water Samples", "type": "Feature Layer", "description": "The Water Samples feature class is a collection of previously acquired water samples using various sensors, from multiple investigators and projects, collected during research funded completely or partially by the Bureau of Ocean Energy Management (BOEM) on or around the outer Continental Shelf (OCS). This layer contains information related to acquisition and measurement readings including temperature, pH, salinity, conductivity, oxygen, turbidity, pressure, density, etc. The intent is to update the feature class as additional samples are collected.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 3000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "d236a19cac6053f314e19c5e58812255", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAALCAYAAABLcGxfAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAATtJREFUKJFlkE1LAgEQhp9lF0zzI/JgQSIh1iHwYCfpWF3yB8gWHoIoUOgcmCD2SdshIoI6B+KlIKKoCPoDHSIo8JKCZFBtWEKsh63Dpovuexlm5n2GmZFoaikfRmCBTv1ywaZ81kylVsPh2mc4MmYBSk8xFg+v2J1vtIDedGFW9YesZgD/UICvtx0gaQAb15IqCGkcLtP0U4eubhAEEEXwDc6wnFdYlZ8lW11VtJFosGW+u4GtBMxtw+S0UfP53agve0BM0uzOKKJ5CpWiEcsP7avZ3RFjpZqao/ZxiscrAjAuw0AIgmHT3NCw1d4PNEBCSZyTPbnE450CwNkDoxPt0yvFR209njXfqjdSvJbv6Qu4LV/6/tT762qm+p8aQC5eIlM4QteTFkCt3lbX5GPaAICVeApIWYAO/QHBW1haUAkyqQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 9, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.04148987841E7, "ymin": 3123760.4864000008, "xmax": -8174181.6161, "ymax": 4945889.885399997, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "vcsWkid": 105703, "latestVcsWkid": 6360 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "State", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "StationID", "type": "esriFieldTypeString", "alias": "Station ID", "length": 20, "domain": null }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "Time", "type": "esriFieldTypeString", "alias": "Time", "length": 8, "domain": null }, { "name": "OceanColor", "type": "esriFieldTypeDouble", "alias": "Ocean Color", "domain": null }, { "name": "SeicheDepth", "type": "esriFieldTypeDouble", "alias": "Seiche Depth", "domain": null }, { "name": "X_Coord", "type": "esriFieldTypeString", "alias": "X", "length": 30, "domain": null }, { "name": "Y_Coord", "type": "esriFieldTypeString", "alias": "Y", "length": 30, "domain": null }, { "name": "CoordSystem", "type": "esriFieldTypeString", "alias": "Coordinate System", "length": 50, "domain": null }, { "name": "Instrument", "type": "esriFieldTypeString", "alias": "Instrument Used", "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": "Water_GlobalLinkID", "type": "esriFieldTypeGUID", "alias": "Global Link ID", "length": 38, "domain": null }, { "name": "RuleID", "type": "esriFieldTypeInteger", "alias": "RuleID", "domain": { "type": "codedValue", "name": "WaterSamples_Rep_Rules", "description": "Representation rules", "codedValues": [ { "name": "WaterSamples", "code": 1 }, { "name": "Free Representation", "code": -1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "G3627Water_Globa", "fields": "Water_GlobalLinkID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S303_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.81, "id": 5, "name": "MMISPUB.SDE.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": "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 }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "indexes": [ { "name": "R456_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G3609GlobalLayer", "fields": "GlobalLayerID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3609Layers_Glob", "fields": "Layers_GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Sample", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "Core Samples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Layers_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }, { "currentVersion": 10.81, "id": 6, "name": "MMISPUB.SDE.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": "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 (>=#4)", "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 (<=#230)", "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": "Sphericity", "type": "esriFieldTypeDouble", "alias": "Sphericity", "domain": null }, { "name": "SpherDesc", "type": "esriFieldTypeString", "alias": "Sphericity Description", "length": 50, "domain": null }, { "name": "Roundness", "type": "esriFieldTypeDouble", "alias": "Roundness", "domain": null }, { "name": "RoundDesc", "type": "esriFieldTypeString", "alias": "Round Description", "length": 50, "domain": null }, { "name": "Porosity", "type": "esriFieldTypeDouble", "alias": "Porosity", "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": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 300, "domain": null }, { "name": "SourceID", "type": "esriFieldTypeString", "alias": "Source ID", "length": 50, "domain": null }, { "name": "SourceName", "type": "esriFieldTypeString", "alias": "Source Name", "length": 50, "domain": null }, { "name": "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": "Samples_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Samples_GlobalTableID", "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 Group", "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": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "indexes": [ { "name": "R463_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G3616Samples_Glo", "fields": "Samples_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3616Samples_Glo_1", "fields": "Samples_GlobalLayerID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3616Samples_Glo_2", "fields": "Samples_GlobalAttachID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3616Samples_Glo_3", "fields": "Samples_GlobalSampleID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Munsell", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "Phi", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "Samples_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Core Samples", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Grab Samples", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalSampleID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "CoreLayers", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "Samples_GlobalLayerID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }, { "currentVersion": 10.81, "id": 7, "name": "MMISPUB.SDE.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": "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 }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "indexes": [ { "name": "R462_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_462", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3615Phi_GlobalT", "fields": "Phi_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_462", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Sample", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "Phi_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }, { "currentVersion": 10.81, "id": 8, "name": "MMISPUB.SDE.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": "MunsellValueUnknown", "type": "esriFieldTypeDouble", "alias": "MunsellValueUnknown", "domain": null }, { "name": "MunsellChromaUnknown", "type": "esriFieldTypeDouble", "alias": "Munsell Chroma Unknown", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Munsell_GlobalTableID", "type": "esriFieldTypeGUID", "alias": "Munsell_GlobalTableID", "length": 38, "domain": null }, { "name": "SampleID", "type": "esriFieldTypeString", "alias": "Sample ID", "length": 50, "domain": null }, { "name": "StudyID", "type": "esriFieldTypeString", "alias": "Study ID", "length": 250, "domain": null } ], "indexes": [ { "name": "R461_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_461", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G3614Munsell_Glo", "fields": "Munsell_GlobalTableID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_461", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "Sample", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "Munsell_GlobalTableID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } } ] }