Name: Pile Cap

Display Field: COMP_DESC

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Pile Cap

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 421195.357630622
YMin: 819204.188910607
XMax: 421219.960173679
YMax: 819431.744102593
Spatial Reference: 2108 (2108)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"D1_Comments","fieldDelimiter":",","defaultSymbol":{"color":[216,220,240,255],"type":"esriSFS","style":"esriSFSSolid"},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"color":[242,221,157,255],"type":"esriSFS","style":"esriSFSSolid"},"value":"No defects were identified","label":"No defects were identified"}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: D1_Comments

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• COMP_DESC (type: esriFieldTypeString, alias: Component Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CB: Cross Beams], [CBR: Cross Braces], [CH: Cross Heads], ... 14 more ...)
• GPS (type: esriFieldTypeString, alias: GPS (Optional), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DESC_ (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• T_QUAN (type: esriFieldTypeString, alias: Total Quantity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UNIT (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Each: Each], [mm: Millimetres], [m2: Metres Squared], ... 1 more ...)
• MAT_TYPE (type: esriFieldTypeString, alias: Material Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ST: Steel], [SEC: Steel Encased Concrete], [R: Rubber], ... 3 more ...)
• P_SCORE (type: esriFieldTypeSmallInteger, alias: Peak Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• M_SCORE (type: esriFieldTypeSmallInteger, alias: Mean Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• C_SCORE (type: esriFieldTypeSmallInteger, alias: Condition Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CRIT (type: esriFieldTypeString, alias: Criticality, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• SAFETY (type: esriFieldTypeString, alias: Safety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• MAN_ITEMS (type: esriFieldTypeString, alias: Maintenance Items, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAN_RATINGS (type: esriFieldTypeString, alias: Maintenance Ratings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 2 more ...)
• MAN_COM (type: esriFieldTypeString, alias: Maintenance Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAST_INSPECT (type: esriFieldTypeDate, alias: Last Inspected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DOC_LINK (type: esriFieldTypeString, alias: Documentation Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COMP_ID (type: esriFieldTypeString, alias: Component ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D1_ExposureEnvironment (type: esriFieldTypeString, alias: Defect 1 - Exposure Environment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SB: Below Seabed], [SPR: Spary Zone], [PS: Permanently Submerged], ... 2 more ...)
• D1_DefectCode (type: esriFieldTypeString, alias: Defect 1 - Defect Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [C: Cracking], [D: Delamination/Spalling], [SL: Section Loss of Metal/Reinforcement], ... 13 more ...)
• D1_Ch1 (type: esriFieldTypeString, alias: Defect 1 - Ch1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D1_Ch2 (type: esriFieldTypeString, alias: Defect 1 - Ch2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D1_Q1 (type: esriFieldTypeString, alias: Defect 1 - Q1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D1_Q2 (type: esriFieldTypeString, alias: Defect 1 - Q2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D1_Location (type: esriFieldTypeString, alias: Defect 1 - Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D1_Comments (type: esriFieldTypeString, alias: Defect 1 - Comments or General Observations including safety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D1_PhotoNo (type: esriFieldTypeString, alias: Defect 1 - Photo No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D1_Drawing (type: esriFieldTypeString, alias: Defect 1 - Drawing/Sketch No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D1_Score (type: esriFieldTypeString, alias: Defect 1 - Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D2_ExposureEnvironment (type: esriFieldTypeString, alias: Defect 1 - Exposure Environment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SB: Below Seabed], [SPR: Spary Zone], [PS: Permanently Submerged], ... 2 more ...)
• D2_DefectCode (type: esriFieldTypeString, alias: Defect 1 - Defect Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [C: Cracking], [D: Delamination/Spalling], [SL: Section Loss of Metal/Reinforcement], ... 13 more ...)
• D2_Ch1 (type: esriFieldTypeString, alias: Defect 1 - Ch1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D2_Ch2 (type: esriFieldTypeString, alias: Defect 1 - Ch2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D2_Q1 (type: esriFieldTypeString, alias: Defect 1 - Q1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D2_Q2 (type: esriFieldTypeString, alias: Defect 1 - Q2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D2_Location (type: esriFieldTypeString, alias: Defect 1 - Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D2_Comments (type: esriFieldTypeString, alias: Defect 1 - Comments or General Observations including safety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D2_PhotoNo (type: esriFieldTypeString, alias: Defect 1 - Photo No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D2_Drawing (type: esriFieldTypeString, alias: Defect 1 - Drawing/Sketch No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D2_Score (type: esriFieldTypeString, alias: Defect 1 - Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D3_ExposureEnvironment (type: esriFieldTypeString, alias: Defect 1 - Exposure Environment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SB: Below Seabed], [SPR: Spary Zone], [PS: Permanently Submerged], ... 2 more ...)
• D3_DefectCode (type: esriFieldTypeString, alias: Defect 1 - Defect Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [C: Cracking], [D: Delamination/Spalling], [SL: Section Loss of Metal/Reinforcement], ... 13 more ...)
• D3_Ch1 (type: esriFieldTypeString, alias: Defect 1 - Ch1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D3_Ch2 (type: esriFieldTypeString, alias: Defect 1 - Ch2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D3_Q1 (type: esriFieldTypeString, alias: Defect 1 - Q1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D3_Q2 (type: esriFieldTypeString, alias: Defect 1 - Q2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D3_Location (type: esriFieldTypeString, alias: Defect 1 - Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D3_Comments (type: esriFieldTypeString, alias: Defect 1 - Comments or General Observations including safety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D3_PhotoNo (type: esriFieldTypeString, alias: Defect 1 - Photo No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D3_Drawing (type: esriFieldTypeString, alias: Defect 1 - Drawing/Sketch No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D3_Score (type: esriFieldTypeString, alias: Defect 1 - Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D4_ExposureEnvironment (type: esriFieldTypeString, alias: Defect 1 - Exposure Environment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SB: Below Seabed], [SPR: Spary Zone], [PS: Permanently Submerged], ... 2 more ...)
• D4_DefectCode (type: esriFieldTypeString, alias: Defect 1 - Defect Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [C: Cracking], [D: Delamination/Spalling], [SL: Section Loss of Metal/Reinforcement], ... 13 more ...)
• D4_Ch1 (type: esriFieldTypeString, alias: Defect 1 - Ch1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D4_Ch2 (type: esriFieldTypeString, alias: Defect 1 - Ch2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D4_Q1 (type: esriFieldTypeString, alias: Defect 1 - Q1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D4_Q2 (type: esriFieldTypeString, alias: Defect 1 - Q2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D4_Location (type: esriFieldTypeString, alias: Defect 1 - Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D4_Comments (type: esriFieldTypeString, alias: Defect 1 - Comments or General Observations including safety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D4_PhotoNo (type: esriFieldTypeString, alias: Defect 1 - Photo No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D4_Drawing (type: esriFieldTypeString, alias: Defect 1 - Drawing/Sketch No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D4_Score (type: esriFieldTypeString, alias: Defect 1 - Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D5_ExposureEnvironment (type: esriFieldTypeString, alias: Defect 1 - Exposure Environment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SB: Below Seabed], [SPR: Spary Zone], [PS: Permanently Submerged], ... 2 more ...)
• D5_DefectCode (type: esriFieldTypeString, alias: Defect 1 - Defect Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [C: Cracking], [D: Delamination/Spalling], [SL: Section Loss of Metal/Reinforcement], ... 13 more ...)
• D5_Ch1 (type: esriFieldTypeString, alias: Defect 1 - Ch1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D5_Ch2 (type: esriFieldTypeString, alias: Defect 1 - Ch2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D5_Q1 (type: esriFieldTypeString, alias: Defect 1 - Q1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D5_Q2 (type: esriFieldTypeString, alias: Defect 1 - Q2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D5_Location (type: esriFieldTypeString, alias: Defect 1 - Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D5_Comments (type: esriFieldTypeString, alias: Defect 1 - Comments or General Observations including safety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D5_PhotoNo (type: esriFieldTypeString, alias: Defect 1 - Photo No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D5_Drawing (type: esriFieldTypeString, alias: Defect 1 - Drawing/Sketch No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D5_Score (type: esriFieldTypeString, alias: Defect 1 - Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D6_ExposureEnvironment (type: esriFieldTypeString, alias: Defect 1 - Exposure Environment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SB: Below Seabed], [SPR: Spary Zone], [PS: Permanently Submerged], ... 2 more ...)
• D6_DefectCode (type: esriFieldTypeString, alias: Defect 1 - Defect Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [C: Cracking], [D: Delamination/Spalling], [SL: Section Loss of Metal/Reinforcement], ... 13 more ...)
• D6_Ch1 (type: esriFieldTypeString, alias: Defect 1 - Ch1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D6_Ch2 (type: esriFieldTypeString, alias: Defect 1 - Ch2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L], ... 2 more ...)
• D6_Q1 (type: esriFieldTypeString, alias: Defect 1 - Q1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D6_Q2 (type: esriFieldTypeString, alias: Defect 1 - Q2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [H: H], [M: M], [L: L])
• D6_Location (type: esriFieldTypeString, alias: Defect 1 - Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D6_Comments (type: esriFieldTypeString, alias: Defect 1 - Comments or General Observations including safety, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D6_PhotoNo (type: esriFieldTypeString, alias: Defect 1 - Photo No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D6_Drawing (type: esriFieldTypeString, alias: Defect 1 - Drawing/Sketch No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• D6_Score (type: esriFieldTypeString, alias: Defect 1 - Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• D1_PHOTO (type: esriFieldTypeString, alias: Defect 1 - Photo, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• D2_PHOTO (type: esriFieldTypeString, alias: Defect 2 - Photo, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• D3_Photo (type: esriFieldTypeString, alias: Defect 3 - Photo, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)

Types:

ID: No defects were identified
Name: No defects were identified
Domains:

• Field Name: COMP_DESC
  Inherited
  
• Field Name: UNIT
  Inherited
  
• Field Name: MAT_TYPE
  Inherited
  
• Field Name: CRIT
  Inherited
  
• Field Name: SAFETY
  Inherited
  
• Field Name: MAN_RATINGS
  Inherited
  
• Field Name: D1_ExposureEnvironment
  Inherited
  
• Field Name: D1_DefectCode
  Inherited
  
• Field Name: D1_Ch1
  Inherited
  
• Field Name: D1_Ch2
  Inherited
  
• Field Name: D1_Q1
  Inherited
  
• Field Name: D1_Q2
  Inherited
  
• Field Name: D2_ExposureEnvironment
  Inherited
  
• Field Name: D2_DefectCode
  Inherited
  
• Field Name: D2_Ch1
  Inherited
  
• Field Name: D2_Ch2
  Inherited
  
• Field Name: D2_Q1
  Inherited
  
• Field Name: D2_Q2
  Inherited
  
• Field Name: D3_ExposureEnvironment
  Inherited
  
• Field Name: D3_DefectCode
  Inherited
  
• Field Name: D3_Ch1
  Inherited
  
• Field Name: D3_Ch2
  Inherited
  
• Field Name: D3_Q1
  Inherited
  
• Field Name: D3_Q2
  Inherited
  
• Field Name: D4_ExposureEnvironment
  Inherited
  
• Field Name: D4_DefectCode
  Inherited
  
• Field Name: D4_Ch1
  Inherited
  
• Field Name: D4_Ch2
  Inherited
  
• Field Name: D4_Q1
  Inherited
  
• Field Name: D4_Q2
  Inherited
  
• Field Name: D5_ExposureEnvironment
  Inherited
  
• Field Name: D5_DefectCode
  Inherited
  
• Field Name: D5_Ch1
  Inherited
  
• Field Name: D5_Ch2
  Inherited
  
• Field Name: D5_Q1
  Inherited
  
• Field Name: D5_Q2
  Inherited
  
• Field Name: D6_ExposureEnvironment
  Inherited
  
• Field Name: D6_DefectCode
  Inherited
  
• Field Name: D6_Ch1
  Inherited
  
• Field Name: D6_Ch2
  Inherited
  
• Field Name: D6_Q1
  Inherited
  
• Field Name: D6_Q2
  Inherited
  
Templates:

Name: No defects were identified
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• COMP_DESC: PC
• DESC_: Concrete Pile Cap
• MAT_TYPE: C
• LAST_INSPECT: 1485993607000
• D1_Comments: No defects were identified

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/20/2018 4:18:18 AM

Schema Last Edit Date: 9/20/2018 4:18:18 AM

Data Last Edit Date: 9/20/2018 4:18:18 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat