View In:   ArcGIS Online Map Viewer

Name: Geotech Bore Hole Locations

Display Field: BORING_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Locations of historical borehole targets from ODOT projects going back to the 1920's

Service Item Id: a40aa8dd56b048bfaf714cc371334011

Copyright Text: ODOT Office of Geotechnical Engineering

Default Visibility: false

MaxRecordCount: 2000000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.0000000066

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -9442132.9751
YMin: 4637259.374399997
XMax: -8963344.809
YMax: 5154741.212200001
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CONF
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Confidence <= 2
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Confidence <= 2
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Confidence => 3
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Confidence => 3
  Description: N/A
  Symbol:
  
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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: CONF

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• NLFID ( type: esriFieldTypeString, alias: NLFID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLFID )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL_BEGIN_NBR, editable: true, nullable: true, defaultValue: null, modelName: CTL_BEGIN_NBR )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT_DISTRICT, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ODOT_DISTRICT )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COUNTY )
• COUNTY_CD ( type: esriFieldTypeString, alias: COUNTY_CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COUNTY_CD )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: ROUTE_TYPE, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE_TYPE )
• ROUTE_NBR ( type: esriFieldTypeString, alias: ROUTE_NBR, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROUTE_NBR )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: ROUTE_SUFFIX, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ROUTE_SUFFIX )
• PERP_DATE ( type: esriFieldTypeDate, alias: PERP_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PERP_DATE )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LATITUDE_DD_BEGIN, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_DD_BEGIN )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LONGITUDE_DD_BEGIN, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_DD_BEGIN )
• SUB_BATCH ( type: esriFieldTypeString, alias: SUB_BATCH, editable: true, nullable: true, length: 12, defaultValue: null, modelName: SUB_BATCH )
• STATION ( type: esriFieldTypeString, alias: STATION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATION )
• OFFSET ( type: esriFieldTypeDouble, alias: OFFSET, editable: true, nullable: true, defaultValue: null, modelName: OFFSET )
• DIRECTION ( type: esriFieldTypeString, alias: DIRECTION, editable: true, nullable: true, length: 2, defaultValue: null, modelName: DIRECTION )
• BORING_ID ( type: esriFieldTypeString, alias: BORING_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BORING_ID )
• CONF ( type: esriFieldTypeSmallInteger, alias: CONF, editable: true, nullable: true, defaultValue: null, modelName: CONF )
• MISC ( type: esriFieldTypeString, alias: MISC, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MISC )
• ALIAS ( type: esriFieldTypeString, alias: ALIAS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ALIAS )
• DATA_URL ( type: esriFieldTypeString, alias: PROJECT INFORMATION, editable: true, nullable: true, length: 500, defaultValue: null, modelName: DATA_URL )
• LOG_URL ( type: esriFieldTypeString, alias: LOG, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LOG_URL )
• PLAN_URL ( type: esriFieldTypeString, alias: PLAN, editable: true, nullable: true, length: 500, defaultValue: null, modelName: PLAN_URL )
• PROFILE_URL ( type: esriFieldTypeString, alias: PROFILE, editable: true, nullable: true, length: 500, defaultValue: null, modelName: PROFILE_URL )
• DIGGS_URL ( type: esriFieldTypeString, alias: DIGGS_URL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DIGGS_URL )

Types:

ID: 1
Name: Confidence <= 2
Domains:
Templates:
• Name: Confidence <= 2
  Description:
  Prototype:
  BORING_ID: null
  PROFILE_URL: null
  NLFID: null
  CTL_BEGIN_NBR: null
  ODOT_DISTRICT: null
  COUNTY: null
  COUNTY_CD: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  PERP_DATE: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  SUB_BATCH: null
  STATION: null
  OFFSET: null
  DIRECTION: null
  CONF: 1
  MISC: null
  ALIAS: null
  DATA_URL: null
  LOG_URL: null
  PLAN_URL: null
  DIGGS_URL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Confidence <= 2
Domains:
Templates:
• Name: Confidence <= 2 (1)
  Description:
  Prototype:
  BORING_ID: null
  PROFILE_URL: null
  NLFID: null
  CTL_BEGIN_NBR: null
  ODOT_DISTRICT: null
  COUNTY: null
  COUNTY_CD: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  PERP_DATE: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  SUB_BATCH: null
  STATION: null
  OFFSET: null
  DIRECTION: null
  CONF: 2
  MISC: null
  ALIAS: null
  DATA_URL: null
  LOG_URL: null
  PLAN_URL: null
  DIGGS_URL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Confidence => 3
Domains:
Templates:
• Name: Confidence => 3
  Description:
  Prototype:
  BORING_ID: null
  PROFILE_URL: null
  NLFID: null
  CTL_BEGIN_NBR: null
  ODOT_DISTRICT: null
  COUNTY: null
  COUNTY_CD: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  PERP_DATE: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  SUB_BATCH: null
  STATION: null
  OFFSET: null
  DIRECTION: null
  CONF: 3
  MISC: null
  ALIAS: null
  DATA_URL: null
  LOG_URL: null
  PLAN_URL: null
  DIGGS_URL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Confidence => 3
Domains:
Templates:
• Name: Confidence => 3 (1)
  Description:
  Prototype:
  BORING_ID: null
  PROFILE_URL: null
  NLFID: null
  CTL_BEGIN_NBR: null
  ODOT_DISTRICT: null
  COUNTY: null
  COUNTY_CD: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  PERP_DATE: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  SUB_BATCH: null
  STATION: null
  OFFSET: null
  DIRECTION: null
  CONF: 4
  MISC: null
  ALIAS: null
  DATA_URL: null
  LOG_URL: null
  PLAN_URL: null
  DIGGS_URL: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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