Name: MemorialsInspectionsTable

Display Field: OBJECTID

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Views

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• InspectionDate (type: esriFieldTypeDate, alias: InspectionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• FoundCondition (type: esriFieldTypeString, alias: Found Condition, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [Pass: Pass], [Fail: Fail], [No Foundation: No Foundation], ... 1 more ...)
• InscriptionLegible (type: esriFieldTypeString, alias: Inscription Legible, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• AdditionalMemorials (type: esriFieldTypeString, alias: Additional Memorials / Plaques, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• KerbGravelFenceEtc (type: esriFieldTypeString, alias: Kerb / Gravel / Fences Etc., SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• LeanAngle (type: esriFieldTypeString, alias: Lean Angle °, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Defect (type: esriFieldTypeString, alias: Defect, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [No Defect: No Defect], [Crack: Crack], [Moving Joint: Moving Joint], ... 3 more ...)
• Actions (type: esriFieldTypeString, alias: Actions, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [No Action Required: No Action Required], [Erect Barrier: Erect Barrier], [Laid Flat: Laid Flat], ... 4 more ...)
• PriorityCode (type: esriFieldTypeString, alias: Priority Code, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [Cat 1 - Immediate Action: Cat 1 - Immediate Action], [Cat 2 - Re-Inspect in 1 yr: Cat 2 - Re-Inspect in 1 yr], [Cat 3 - Re-Inspect in 5 yrs: Cat 3 - Re-Inspect in 5 yrs])
• AdditionalComments (type: esriFieldTypeString, alias: Additional Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• ContractorWorkDetails (type: esriFieldTypeString, alias: Contractor - Work Details, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true, Coded Values: [Visited by contractor: Visited by contractor])
• ContractorCostEstimate (type: esriFieldTypeString, alias: Contractor - Cost Estimate, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ContractorWorkETA (type: esriFieldTypeString, alias: Contractor - Work Completion ETA, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ContractorApprovalStatus (type: esriFieldTypeString, alias: Contractor - Approval Status, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [Submitted for approval: Submitted for approval], [Approved and ready for work: Approved and ready for work], [Work in progress: Work in progress], ... 1 more ...)
• SafetyBarrierInPlace (type: esriFieldTypeString, alias: Safety Barrier In Place, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• 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)
• TextGUID (type: esriFieldTypeString, alias: TextGUID, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)

Templates:

Name: MemorialsInspectionsTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• MemorialsInspectionsLocations (0) -- Related To: MemorialsInspectionsLocations (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/30/2025 3:12:47 PM

Schema Last Edit Date: 4/30/2025 3:12:47 PM

Data Last Edit Date: 4/30/2025 3:12:47 PM

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