Name: Piles_Actual

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 4514

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 19693829.4108234
YMin: -4789830.93209662
XMax: 19694316.6465863
YMax: -4789690.47090619
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"pileStatus","defaultSymbol":null,"uniqueValueInfos":[{"value":"Incomplete","label":"Incomplete","symbol":{"color":[194,194,194,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Pile complete","label":"Pile complete","symbol":{"color":[0,112,255,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Top of rock observed","label":"Top of rock observed","symbol":{"color":[255,255,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Drive casing - 1.5m Embedment","label":"Drive casing - 1.5m Embedment","symbol":{"color":[152,230,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Drive casing - Initial","label":"Drive casing - Initial","symbol":{"color":[158,85,156,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}}]},"transparency":0}

HasZ: true

HasM: false

Time Info:

Start Time Field: dateSignedOff
End Time Field: null
Track ID Field: null
Time Extent
[5/2/2020 12:00:00 AM UTC, 7/28/2020 12:00:00 AM UTC]

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: pileStatus

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PileNo (type: esriFieldTypeString, alias: Pile Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• pileStatus (type: esriFieldTypeString, alias: Pile Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Incomplete: Incomplete], [Pile complete: Pile complete], [Drive casing - 1.5m Embedment: Drive casing - 1.5m Embedment], ... 2 more ...)
• dTOR (type: esriFieldTypeDouble, alias: Design Top of Rock, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hETOR (type: esriFieldTypeDouble, alias: HEB Estimated Top of Rock, SQL Type: sqlTypeOther, nullable: true, editable: true)
• aTOR (type: esriFieldTypeDouble, alias: Actual - Top Of Rock, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tORfLongSec (type: esriFieldTypeDouble, alias: Top of Rock for Long Section, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dateTORConfirmed (type: esriFieldTypeDate, alias: Date Top of Rock Confirmed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• tORObBy (type: esriFieldTypeString, alias: Top of Rock Observed by, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• dLofToe (type: esriFieldTypeDouble, alias: Design level of toe of permamant casing (m CD), SQL Type: sqlTypeOther, nullable: true, editable: true)
• dPileToeFound (type: esriFieldTypeDouble, alias: Design Pile Toe Founding Level (m CD), SQL Type: sqlTypeOther, nullable: true, editable: true)
• aMeasToeLevCast (type: esriFieldTypeDouble, alias: Actual (measured) Toe Level of Casing (m CD), SQL Type: sqlTypeOther, nullable: true, editable: true)
• aMeasPileFoundLev (type: esriFieldTypeDouble, alias: Actual (Measured) Pile Founding Level (m CD), SQL Type: sqlTypeOther, nullable: true, editable: true)
• linMMforLongSec (type: esriFieldTypeDouble, alias: Length in mm for long section, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dMinSocketLen (type: esriFieldTypeDouble, alias: Design Minimum Socket Length (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• aSocketLen (type: esriFieldTypeDouble, alias: Actual Socket Length (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• baseCleaning (type: esriFieldTypeInteger, alias: Base cleaning, SQL Type: sqlTypeOther, nullable: true, editable: true)
• medOfConcPlace (type: esriFieldTypeString, alias: Method of concrete placement, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• pileCageChecked (type: esriFieldTypeString, alias: Pile cage checked, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• dateSignedOff (type: esriFieldTypeDate, alias: Date Signed Off, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• verifiedBy (type: esriFieldTypeString, alias: Verified By, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• calcDvsActual (type: esriFieldTypeDouble, alias: Calculate Design vs Actual, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: Incomplete
Name: Incomplete
Domains:

Templates:

Name: Incomplete
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• pileStatus: Incomplete

---

ID: Pile complete
Name: Pile complete
Domains:

Templates:

Name: Pile complete
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• pileStatus: Pile complete

---

ID: Top of rock observed
Name: Top of rock observed
Domains:

Templates:

Name: Top of rock observed
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• pileStatus: Top of rock observed

---

ID: Drive casing - 1.5m Embedment
Name: Drive casing - 1.5m Embedment
Domains:

Templates:

Name: Drive casing - 1.5m Embedment
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• pileStatus: Drive casing - 1.5m Embedment

---

ID: Drive casing - Initial
Name: Drive casing - Initial
Domains:

Templates:

Name: Drive casing - Initial
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• pileStatus: Drive casing - Initial

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/25/2023 11:05:17 PM

Schema Last Edit Date: 6/25/2023 11:05:14 PM

Data Last Edit Date: 6/25/2023 11:05:14 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat