Layers:

Layer: ugshazards.sde.borehole_locations (0)

Name: ugshazards.sde.borehole_locations

Display Field: project_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -1.2598418561999999E7
YMin: 4521214.215499997
XMax: -1.2191717555E7
YMax: 5125169.7092999965
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: exploration_method
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: CPT
  Label: Cone Penetration Test
  Description: N/A
  Symbol:
  
• Value: Drill
  Label: Drill
  Description: N/A
  Symbol:
  
• Value: Excavation
  Label: Trench
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• boreid ( type: esriFieldTypeString, alias: BoreID, length: 8000 )
• ugs_gdid ( type: esriFieldTypeInteger, alias: UGS_GDID )
• consultant ( type: esriFieldTypeString, alias: Consultant, length: 8000 )
• projectid ( type: esriFieldTypeString, alias: ProjectID, length: 8000 )
• udot_pin ( type: esriFieldTypeInteger, alias: UDOT_PIN )
• project_name ( type: esriFieldTypeString, alias: Project_Name, length: 8000 )
• latitude ( type: esriFieldTypeString, alias: Latitude, length: 8000 )
• longitude ( type: esriFieldTypeDouble, alias: Longitude )
• coordinate_source ( type: esriFieldTypeString, alias: Coordinate_Source, length: 8000 )
• elevation_ft ( type: esriFieldTypeDouble, alias: Elevation_Ft )
• elevation_source ( type: esriFieldTypeString, alias: Elevation_Source, length: 8000 )
• date_completed ( type: esriFieldTypeDate, alias: Date_Completed, length: 8 )
• geologic_unit ( type: esriFieldTypeString, alias: Geologic_Unit, length: 8000 )
• exploration_type ( type: esriFieldTypeString, alias: Exploration_Type, length: 8000 )
• exploration_method ( type: esriFieldTypeString, alias: Exploration_Method, length: 8000 )
• exploration_equiptment ( type: esriFieldTypeString, alias: Exploration_Equiptment, length: 8000 )
• gw_depth ( type: esriFieldTypeDouble, alias: GW_Depth )
• hammer_type ( type: esriFieldTypeString, alias: Hammer_Type, length: 8000 )
• correctedn1_60 ( type: esriFieldTypeString, alias: CorrectedN1_60, length: 8000 )
• completion ( type: esriFieldTypeString, alias: Completion, length: 8000 )
• bedrock_refusal ( type: esriFieldTypeInteger, alias: Bedrock_Refusal )
• enteredby ( type: esriFieldTypeString, alias: EnteredBy, length: 8000 )
• notes ( type: esriFieldTypeString, alias: Notes, length: 8000 )
• report_url ( type: esriFieldTypeString, alias: report_url, length: 100 )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• databasedate ( type: esriFieldTypeDate, alias: databasedate, length: 8 )
• shape ( type: esriFieldTypeGeometry, alias: shape )

Relationships:

• ugshazards.sde.borehole_unit_table (0) -- Related To: ugshazards.sde.borehole_unit_table (1)
• ugshazards.sde.borehole_sample_table (1) -- Related To: ugshazards.sde.borehole_sample_table (2)

Tables:

Table: ugshazards.sde.borehole_unit_table (1)

Name: ugshazards.sde.borehole_unit_table

Display Field: unitname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• boreid ( type: esriFieldTypeString, alias: BoreID, length: 8000 )
• upperdepth ( type: esriFieldTypeDouble, alias: UpperDepth )
• lowerdepth ( type: esriFieldTypeDouble, alias: LowerDepth )
• uscs ( type: esriFieldTypeString, alias: USCS, length: 8000 )
• unitname ( type: esriFieldTypeString, alias: UnitName, length: 8000 )
• fieldmoisture ( type: esriFieldTypeString, alias: FieldMoisture, length: 8000 )
• fieldcolor ( type: esriFieldTypeString, alias: FieldColor, length: 8000 )
• fielddensity ( type: esriFieldTypeString, alias: FieldDensity, length: 8000 )
• fieldconsistency ( type: esriFieldTypeString, alias: FieldConsistency, length: 40000 )
• notes ( type: esriFieldTypeString, alias: Notes, length: 8000 )

Relationships:

• ugshazards.sde.borehole_locations (0) -- Related To: ugshazards.sde.borehole_locations (0)

Table: ugshazards.sde.borehole_sample_table (2)

Name: ugshazards.sde.borehole_sample_table

Display Field: boreid

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• boreid ( type: esriFieldTypeString, alias: BoreID, length: 8000 )
• samplenumber ( type: esriFieldTypeString, alias: SampleNumber, length: 50 )
• sampleupperdepth ( type: esriFieldTypeDouble, alias: SampleUpperDepth )
• samplelower_depth ( type: esriFieldTypeDouble, alias: SampleLower Depth )
• samplemethod ( type: esriFieldTypeString, alias: SampleMethod, length: 8000 )
• nvalue ( type: esriFieldTypeString, alias: Nvalue, length: 50 )
• classification ( type: esriFieldTypeString, alias: Classification, length: 8000 )
• gravel_percent ( type: esriFieldTypeInteger, alias: Gravel_Percent )
• sand_percent ( type: esriFieldTypeInteger, alias: Sand_Percent )
• fines_percent ( type: esriFieldTypeInteger, alias: Fines_Percent )
• labmoisture_percent ( type: esriFieldTypeDouble, alias: LabMoisture_Percent )
• labdrydensity_pcf ( type: esriFieldTypeDouble, alias: LabDryDensity_pcf )
• ll ( type: esriFieldTypeString, alias: LL, length: 8000 )
• pl ( type: esriFieldTypeString, alias: PL, length: 8000 )
• pi ( type: esriFieldTypeString, alias: PI, length: 8000 )
• sct_percent ( type: esriFieldTypeDouble, alias: SCT_Percent )
• sct_dry_percent ( type: esriFieldTypeDouble, alias: SCT_Dry_Percent )
• shear_type ( type: esriFieldTypeString, alias: Shear_Type, length: 8000 )
• shearangle_degree ( type: esriFieldTypeString, alias: ShearAngle_Degree, length: 8000 )
• shearcohesion_psi ( type: esriFieldTypeString, alias: ShearCohesion_PSI, length: 8000 )
• resistivity_ohm_cm ( type: esriFieldTypeString, alias: Resistivity_ohm_cm, length: 8000 )
• sulfates_ppm ( type: esriFieldTypeString, alias: Sulfates_ppm, length: 8000 )
• chlorides_ppm ( type: esriFieldTypeString, alias: Chlorides_ppm, length: 8000 )
• organics_percent_weight ( type: esriFieldTypeString, alias: Organics_Percent_Weight, length: 8000 )
• ph ( type: esriFieldTypeString, alias: pH, length: 8000 )
• notes ( type: esriFieldTypeString, alias: Notes, length: 8000 )

Relationships:

• ugshazards.sde.borehole_locations (1) -- Related To: ugshazards.sde.borehole_locations (0)