Name: Sample

Display Field: SourceName

Type: Table

Geometry Type: N/A

Description: The Samples Table contains information and data pertaining to sediment samples derived from cores (including borings) and grab samples (see Core and Grab Samples feature classes). The attributes in this table summarize sample acquisition (study and sample ID, elevation ,interval, source agency, contact info, etc.), processing and analysis (analysis date, dissolutions, removals, data reduction methods, etc.), and results of laboratory grain-size analyses. Each respective sample entry in this table is related to it's respective Core or Grab Sample feature. If available, data and additional content (e.g. photos, pdf logs, imagery, spreadsheets, weblinks, etc.) associated with individual sediment sample analyses (e.g. phi size distributions, Munsell color, age dating, heavy mineral content, and infauna) are provided within related MMIS geodatabase tables.

Service Item Id: dd82a110975d470ba863b578cf6de2e1

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• StudyID ( type: esriFieldTypeString, alias: Study ID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Study ID )
• CoreID ( type: esriFieldTypeString, alias: Core ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CoreID )
• SampleID ( type: esriFieldTypeString, alias: Sample ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SampleID )
• CoreLayerID ( type: esriFieldTypeString, alias: Core Layer ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CoreLayerID )
• AnalysisDate ( type: esriFieldTypeDate, alias: Analysis Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Analysis Date )
• TopInterval ( type: esriFieldTypeDouble, alias: Top of Sample Interval, editable: true, nullable: true, defaultValue: null, modelName: Top of Sample Interval )
• BottomInterval ( type: esriFieldTypeDouble, alias: Bottom of Sample Interval, editable: true, nullable: true, defaultValue: null, modelName: Bottom of Sample Interval )
• GrabElevation ( type: esriFieldTypeDouble, alias: Grab Elevation, editable: true, nullable: true, defaultValue: null, modelName: Grab Elevation )
• SampleBase_ft ( type: esriFieldTypeDouble, alias: Sample Base (ft), editable: true, nullable: true, defaultValue: null, modelName: SampleBase_ft )
• SandUnitThickness ( type: esriFieldTypeDouble, alias: Sand Unit Thickness, editable: true, nullable: true, defaultValue: null, modelName: SandUnitThickness )
• PhiMethod ( type: esriFieldTypeString, alias: Phi Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PhiMethod )
• PhiMean ( type: esriFieldTypeDouble, alias: Phi Mean, editable: true, nullable: true, defaultValue: null, modelName: Phi Mean )
• PhiMedian ( type: esriFieldTypeDouble, alias: Phi Median, editable: true, nullable: true, defaultValue: null, modelName: Phi Median )
• PhiSD ( type: esriFieldTypeDouble, alias: Phi Standard Deviation, editable: true, nullable: true, defaultValue: null, modelName: Phi Standard Deviation )
• PhiSkewness ( type: esriFieldTypeDouble, alias: Phi Skewness, editable: true, nullable: true, defaultValue: null, modelName: Phi Skewness )
• PhiKurtosis ( type: esriFieldTypeDouble, alias: Phi Kurtosis, editable: true, nullable: true, defaultValue: null, modelName: Phi Kurtosis )
• PctGravel ( type: esriFieldTypeDouble, alias: Percent Gravel, editable: true, nullable: true, defaultValue: null, modelName: PctGravel )
• PctSand ( type: esriFieldTypeDouble, alias: Percent Sand, editable: true, nullable: true, defaultValue: null, modelName: PctSand )
• PctClay ( type: esriFieldTypeDouble, alias: Percent Clay, editable: true, nullable: true, defaultValue: null, modelName: PctClay )
• PctSilt ( type: esriFieldTypeDouble, alias: Percent Silt, editable: true, nullable: true, defaultValue: null, modelName: PctSilt )
• PctFines ( type: esriFieldTypeDouble, alias: Percent Fines, editable: true, nullable: true, defaultValue: null, modelName: Percent Fines )
• PctPanFraction ( type: esriFieldTypeDouble, alias: Percent Pan Fraction, editable: true, nullable: true, defaultValue: null, modelName: Percent Pan Fraction )
• PctCarbonate ( type: esriFieldTypeDouble, alias: Percent Carbonate, editable: true, nullable: true, defaultValue: null, modelName: Percent Carbonate )
• PctCarbonateSand ( type: esriFieldTypeDouble, alias: Percent Carbonate Sand, editable: true, nullable: true, defaultValue: null, modelName: PctCarbonateSand )
• PctShellFragments ( type: esriFieldTypeDouble, alias: Percent Shell Fragments, editable: true, nullable: true, defaultValue: null, modelName: Percent Shell Fragments )
• PctHeavyMinerals ( type: esriFieldTypeDouble, alias: Percent Heavy Minerals, editable: true, nullable: true, defaultValue: null, modelName: Percent Heavy Minerals )
• PctOrganics ( type: esriFieldTypeDouble, alias: Percent Organics, editable: true, nullable: true, defaultValue: null, modelName: Percent Organics )
• CarbonateDissolved ( type: esriFieldTypeString, alias: Carbonate Dissolved, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Carbonate Dissolved )
• HeavyMineralsDissolved ( type: esriFieldTypeString, alias: Heavy Minerals Dissolved, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Heavy Minerals Dissolved )
• OrganicsRemoved ( type: esriFieldTypeString, alias: Organics Removed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Organics Removed )
• ShellFragmentsRemoved ( type: esriFieldTypeString, alias: Shell Fragments Removed, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Shell Fragments Removed )
• SortMethod ( type: esriFieldTypeString, alias: Sort Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sort Method )
• Sphericity ( type: esriFieldTypeDouble, alias: Sphericity, editable: true, nullable: true, defaultValue: null, modelName: Sphericity )
• SpherDesc ( type: esriFieldTypeString, alias: Sphericity Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sphericity Description )
• Roundness ( type: esriFieldTypeDouble, alias: Roundness, editable: true, nullable: true, defaultValue: null, modelName: Roundness )
• RoundDesc ( type: esriFieldTypeString, alias: Round Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Round Description )
• Sort_Descrpt ( type: esriFieldTypeString, alias: Sorting Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sort_Descrpt )
• Porosity ( type: esriFieldTypeDouble, alias: Porosity, editable: true, nullable: true, defaultValue: null, modelName: Porosity )
• OilPresent ( type: esriFieldTypeString, alias: Oil Present, editable: true, nullable: true, length: 3, defaultValue: null, modelName: OilPresent )
• SourceID ( type: esriFieldTypeString, alias: Source ID, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Source ID )
• SourceName ( type: esriFieldTypeString, alias: Source Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source Name )
• SCOrigin ( type: esriFieldTypeString, alias: CMECS SC Origin, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SCOrigin )
• SCClass ( type: esriFieldTypeString, alias: CMECS SC Class, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SCClass )
• SCSubclass ( type: esriFieldTypeString, alias: CMECS SC Sublass, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SCSubclass )
• SCGroup ( type: esriFieldTypeString, alias: CMECS SC Group, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SCGroup )
• SCSubgroup ( type: esriFieldTypeString, alias: CMECS SC Subgroup, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SCSubgroup )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Comments )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Samples_GlobalSampleID ( type: esriFieldTypeGUID, alias: Global Sample ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Global Sample ID )
• Samples_GlobalLayerID ( type: esriFieldTypeGUID, alias: Global Layer ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Samples_GlobalLayerID )
• Samples_GlobalTableID ( type: esriFieldTypeGUID, alias: Global Table ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: Samples_GlobalTableID )

Templates:

• Name: Sample
  Description:
  Prototype:
  Samples_GlobalLayerID: null
  Samples_GlobalTableID: null
  StudyID: null
  CoreID: null
  SampleID: null
  CoreLayerID: null
  AnalysisDate: null
  TopInterval: null
  BottomInterval: null
  GrabElevation: null
  SampleBase_ft: null
  SandUnitThickness: null
  PhiMethod: null
  PhiMean: null
  PhiMedian: null
  PhiSD: null
  PhiSkewness: null
  PhiKurtosis: null
  PctGravel: null
  PctSand: null
  PctClay: null
  PctSilt: null
  PctFines: null
  PctPanFraction: null
  PctCarbonate: null
  PctCarbonateSand: null
  PctShellFragments: null
  PctHeavyMinerals: null
  PctOrganics: null
  CarbonateDissolved: null
  HeavyMineralsDissolved: null
  OrganicsRemoved: null
  ShellFragmentsRemoved: null
  SortMethod: null
  Sphericity: null
  SpherDesc: null
  Roundness: null
  RoundDesc: null
  Sort_Descrpt: null
  Porosity: null
  OilPresent: null
  SourceID: null
  SourceName: null
  SCOrigin: null
  SCClass: null
  SCSubclass: null
  SCGroup: null
  SCSubgroup: null
  Comments: null
  created_date: null
  last_edited_date: null
  Samples_GlobalSampleID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Munsell (6) -- Related To: Munsell (5)
• Phi (7) -- Related To: Phi (4)
• CoreSamples (1) -- Related To: Core Samples (0)
• CoreLayers (5) -- Related To: Core Layers (2)
• GrabSamples (3) -- Related To: Grab Samples (1)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata