View In:   ArcGIS Online Map Viewer

Name: survey

Display Field: null

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 17bb0a78d1f6421dafb74c66e810cf06

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -180.0
YMin: -90.0
XMax: 180.0
YMax: 90.0
Spatial Reference: 4326  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: Survey Point
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Query With LOD Spatial Reference: true
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, defaultValue: null, editable: false, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• project_id ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Project_ID, type: esriFieldTypeString )
• organization ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Organization, type: esriFieldTypeString )
• collector_name ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Collector Name, type: esriFieldTypeString )
• collection_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Collection Date, type: esriFieldTypeDate )
• stage_number ( nullable: true, editable: true, defaultValue: null, alias: Stage Number, type: esriFieldTypeDouble )
• field_28 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Start Depth (ft), type: esriFieldTypeString )
• field_29 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: End Depth (ft), type: esriFieldTypeString )
• stage_length_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Stage Length (ft), type: esriFieldTypeString )
• field_31 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Stage ID, type: esriFieldTypeString )
• field_20 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Hole ID, type: esriFieldTypeString )
• field_21 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Stage ID, type: esriFieldTypeString )
• test_id ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Test ID, type: esriFieldTypeString )
• test_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Test Date, type: esriFieldTypeDate )
• field_23 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Test Pressure (psi), type: esriFieldTypeString )
• water_take_gpm ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Water Take (gpm), type: esriFieldTypeString )
• test_duration_minutes ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Test Duration (minutes), type: esriFieldTypeString )
• lugeon_value ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Lugeon Value, type: esriFieldTypeString )
• field_32 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Hole ID, type: esriFieldTypeString )
• field_33 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Stage ID, type: esriFieldTypeString )
• grout_volume_gal ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Grout Volume (gal), type: esriFieldTypeString )
• injection_pressure_psi ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Injection Pressure (psi), type: esriFieldTypeString )
• pump_rate_gpm ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Pump Rate (GPM), type: esriFieldTypeString )
• grout_start_time ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Grout Start Time, type: esriFieldTypeDate )
• grout_end_time ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Grout End Time, type: esriFieldTypeDate )
• stage_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Stage Status, type: esriFieldTypeString , Coded Values: [Not Started: Not Started] , [In Progress: In Progress] , [Complete: Complete] , ...1 more... )
• issue_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Issue Type, type: esriFieldTypeString , Coded Values: [Cross Hole Communication: Cross Hole Communication] , [Leaky Packer: Leaky Packer] , [Lost Tooling: Lost Tooling] , ...4 more... )
• issue_description ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Issue Description, type: esriFieldTypeString )
• corrective_action ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Corrective Action, type: esriFieldTypeString )
• issue_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Issue Status, type: esriFieldTypeString , Coded Values: [Open: Open] , [Under Review: Under Review] , [Resolved: Resolved] )
• verification_hole_id ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Verification Hole ID, type: esriFieldTypeString )
• related_hole_id ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Related Hole ID, type: esriFieldTypeString )
• field_46 ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Lugeon Value, type: esriFieldTypeString )
• verification_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Verification Status, type: esriFieldTypeString , Coded Values: [Pass: Pass] , [Fail: Fail] , [Pending Review: Pending Review] )
• reviewed_by ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Reviewed By, type: esriFieldTypeString )
• review_date ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Review Date, type: esriFieldTypeString )
• pile_id ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Pile ID, type: esriFieldTypeString )
• pile_installation_status ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Pile Installation Status, type: esriFieldTypeString , Coded Values: [Planned: Planned] , [Drilled: Drilled] , [Steel Installed: Steel Installed] , ...2 more... )
• installation_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date, type: esriFieldTypeDate )
• pile_collar_elevation_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Pile Collar Elevation (ft), type: esriFieldTypeString )
• borehole_diameter_in ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Borehole Diameter (in), type: esriFieldTypeString )
• borehole_depth_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Borehole Depth (ft), type: esriFieldTypeString )
• field_66 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Steel Pile Type, type: esriFieldTypeString , Coded Values: [Pipe Pile: Pipe Pile] , [H-Pile: H-Pile] , [Drilled Pile: Drilled Pile] )
• steel_pile_length_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Steel Pile Length (ft), type: esriFieldTypeString )
• concrete_backfill_volume ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Concrete Backfill Volume, type: esriFieldTypeString )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• borehole_id ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Borehole ID, type: esriFieldTypeString )
• project_name ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Project Name, type: esriFieldTypeString )
• ground_elevation_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Ground Elevation (ft), type: esriFieldTypeString )
• hole_type ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hole Type, type: esriFieldTypeString , Coded Values: [Soil boring: Soil boring] , [Rock core: Rock core] , [CPT: CPT] , ...2 more... )
• start_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Start Date, type: esriFieldTypeDate )
• completion_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Completion Date, type: esriFieldTypeDate )
• final_depth_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Final Depth (ft), type: esriFieldTypeString )
• drilling_contractor ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Drilling Contractor, type: esriFieldTypeString )
• rig_number ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Rig Number, type: esriFieldTypeString )
• drilling_method ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Drilling Method, type: esriFieldTypeString , Coded Values: [Hollow Stem Auger: Hollow Stem Auger] , [Mud Rotary: Mud Rotary] , [Sonic: Sonic] , ...3 more... )
• bit_type ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Bit Type, type: esriFieldTypeString )
• borehole_diameter ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Borehole Diameter, type: esriFieldTypeString )
• casing_depth ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Casing Depth, type: esriFieldTypeString )
• drilling_fluid ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Drilling Fluid, type: esriFieldTypeString )
• refusal_depth ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Refusal Depth, type: esriFieldTypeString )
• obstructions_encountered ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Obstructions Encountered, type: esriFieldTypeString )
• top_depth_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Top Depth (ft), type: esriFieldTypeString )
• bottom_depth_ft ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Bottom Depth (ft), type: esriFieldTypeString )
• material_description ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Material Description, type: esriFieldTypeString )
• uscs_classification ( nullable: true, editable: true, defaultValue: null, length: 255, alias: USCS Classification, type: esriFieldTypeString , Coded Values: [GW - Well-Graded Gravel: GW - Well-Graded Gravel] , [GP - Poorly Graded Gravel: GP - Poorly Graded Gravel] , [GM - Silty Gravel: GM - Silty Gravel] , ...11 more... )
• colour ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Colour, type: esriFieldTypeString , Coded Values: [Brown: Brown] , [Dark Brown: Dark Brown] , [Gray: Gray] , ...8 more... )
• other ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Other, type: esriFieldTypeString )
• moisture_condition ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Moisture Condition, type: esriFieldTypeString , Coded Values: [Dry: Dry] , [Moist: Moist] , [Wet: Wet] , ...1 more... )
• density_granular_soils ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Density (Granular Soils), type: esriFieldTypeString , Coded Values: [Very Loose: Very Loose] , [Loose: Loose] , [Medium Dense: Medium Dense] , ...2 more... )
• consistency_fine_grained_soils ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Consistency (Fine-Grained Soils), type: esriFieldTypeString , Coded Values: [Very Soft: Very Soft] , [Soft: Soft] , [Firm: Firm] , ...3 more... )
• grain_size ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Grain Size, type: esriFieldTypeString , Coded Values: [Clay: Clay] , [Silt: Silt] , [Sand: Sand] , ...4 more... )
• gravel_content ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Gravel Content, type: esriFieldTypeString , Coded Values: [None: None] , [Trace: Trace] , [Little: Little] , ...4 more... )
• organics ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Organics, type: esriFieldTypeString , Coded Values: [None: None] , [Trace: Trace] , [Present: Present] , ...1 more... )
• cementation ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cementation, type: esriFieldTypeString , Coded Values: [None: None] , [Weak: Weak] , [Moderate: Moderate] , ...1 more... )
• weathering ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Weathering, type: esriFieldTypeString , Coded Values: [Fresh: Fresh] , [Slightly Weathered: Slightly Weathered] , [Moderately Weathered: Moderately Weathered] , ...2 more... )
• relative_density_sand ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Relative Density (Sand), type: esriFieldTypeString , Coded Values: [Very Loose: Very Loose] , [Loose: Loose] , [Medium Dense: Medium Dense] , ...2 more... )
• consistency_clay ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Consistency (Clay), type: esriFieldTypeString , Coded Values: [Very Soft: Very Soft] , [Soft: Soft] , [Firm: Firm] , ...3 more... )

Templates:

• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• survey_sample_information (6) -- Related To: sample_information (7)
• survey_spt_data (7) -- Related To: spt_data (8)
• survey_rock_core_data (8) -- Related To: rock_core_data (9)

Capabilities: Create,Editing,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata