{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "Damage_Assessment", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "WSPGIS.GISADMIN.Canary_Wairoa_Bridges", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "parentrowid", "composite": false } ], "isDataVersioned": false, "isDataArchived": true, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1750805219000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "assessmentdate", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "assessmentdate", "type": "esriFieldTypeDate", "alias": "Assesment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "assessmentdate" }, { "name": "assessed_by", "type": "esriFieldTypeString", "alias": "Assessed_By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "assessed_by" }, { "name": "impact", "type": "esriFieldTypeString", "alias": "Impact", "domain": { "type": "codedValue", "name": "Impact", "description": "", "codedValues": [ { "name": "Caution", "code": "Caution" }, { "name": "One Lane Closure", "code": "One Lane Closure" }, { "name": "Full Road Closure", "code": "Full Road Closure" }, { "name": "No Damage", "code": "No Damage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "impact" }, { "name": "detour_length_if_closed", "type": "esriFieldTypeString", "alias": "Detour Length if Closed", "domain": { "type": "codedValue", "name": "Detour Length", "description": "", "codedValues": [ { "name": "Not required", "code": "Not required" }, { "name": "Short (<30mins)", "code": "Short (<30mins)" }, { "name": "Moderate (30-90mins)", "code": "Moderate (30-90mins)" }, { "name": "Long (>90mins)", "code": "Long (>90mins)" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "detour_length_if_closed" }, { "name": "estimated_time_to_reopen", "type": "esriFieldTypeString", "alias": "Estimated Time to Reopen for Temporary Emergency Access", "domain": { "type": "codedValue", "name": "Time", "description": "", "codedValues": [ { "name": "Under 12 hours", "code": "Under 12 hours" }, { "name": "12 - 48 hours", "code": "12 - 48 hours" }, { "name": "48 hours - 7 days", "code": "48 hours - 7 days" }, { "name": "7 days to 1 month", "code": "7 days to 1 month" }, { "name": "2 - 3 months", "code": "2 - 3 months" }, { "name": "4 - 6 months", "code": "4 - 6 months" }, { "name": "Longer than 6 months", "code": "Longer than 6 months" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "estimated_time_to_reopen" }, { "name": "estimated_time_to_fully_repair", "type": "esriFieldTypeString", "alias": "Estimated_Time_to_Fully_Repair", "domain": { "type": "codedValue", "name": "Time", "description": "", "codedValues": [ { "name": "Under 12 hours", "code": "Under 12 hours" }, { "name": "12 - 48 hours", "code": "12 - 48 hours" }, { "name": "48 hours - 7 days", "code": "48 hours - 7 days" }, { "name": "7 days to 1 month", "code": "7 days to 1 month" }, { "name": "2 - 3 months", "code": "2 - 3 months" }, { "name": "4 - 6 months", "code": "4 - 6 months" }, { "name": "Longer than 6 months", "code": "Longer than 6 months" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "estimated_time_to_fully_repair" }, { "name": "asset_damaged", "type": "esriFieldTypeString", "alias": "Asset_Damaged", "domain": { "type": "codedValue", "name": "Asset Damaged", "description": "", "codedValues": [ { "name": "Corridor", "code": "Corridor" }, { "name": "Pavement", "code": "Pavement" }, { "name": "Shoulder", "code": "Shoulder" }, { "name": "Drainage", "code": "Drainage" }, { "name": "Bridge", "code": "Bridge" }, { "name": "Other Structure", "code": "Other Structure" }, { "name": "Geotechnical", "code": "Geotechnical" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asset_damaged" }, { "name": "asset_damaged_other", "type": "esriFieldTypeString", "alias": "Asset_Damaged_Other", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asset_damaged_other" }, { "name": "defect_type", "type": "esriFieldTypeString", "alias": "Defect_Type", "domain": { "type": "codedValue", "name": "Defect Type", "description": "", "codedValues": [ { "name": "Overslip", "code": "Overslip" }, { "name": "Rockfall", "code": "Rockfall" }, { "name": "Dropout", "code": "Dropout" }, { "name": "Scour", "code": "Scour" }, { "name": "Flooding", "code": "Flooding" }, { "name": "Debris", "code": "Debris" }, { "name": "Silt / Sediment", "code": "Silt / Sediment" }, { "name": "Coastal Flooding", "code": "Coastal Flooding" }, { "name": "Coastal Erosion", "code": "Coastal Erosion" }, { "name": "Damage to Structures", "code": "Damage to Structures" }, { "name": "Dangerous / Fallen Trees", "code": "Dangerous / Fallen Trees" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "defect_type" }, { "name": "severity", "type": "esriFieldTypeString", "alias": "Severity", "domain": { "type": "codedValue", "name": "Severity", "description": "", "codedValues": [ { "name": "Minor", "code": "Minor" }, { "name": "Moderate", "code": "Moderate" }, { "name": "Major", "code": "Major" }, { "name": "Extreme", "code": "Extreme" }, { "name": "Resolved", "code": "Resolved" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "severity" }, { "name": "specialist_inspection_required", "type": "esriFieldTypeString", "alias": "Specialist_Inspection_Required", "domain": { "type": "codedValue", "name": "Inspection Required", "description": "", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes - Structural", "code": "Yes - Structural" }, { "name": "Yes - Geotechnical", "code": "Yes - Geotechnical" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "specialist_inspection_required" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "repair_complexity", "type": "esriFieldTypeString", "alias": "Repair_Complexity", "domain": { "type": "codedValue", "name": "Complexity", "description": "", "codedValues": [ { "name": "Minor Repair - No Design", "code": "Minor Repair - No Design" }, { "name": "Moderate Repair - No Design", "code": "Moderate Repair - No Design" }, { "name": "Moderate Repair - Design Required", "code": "Moderate Repair - Design Required" }, { "name": "Major Repair - Design Required", "code": "Major Repair - Design Required" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "repair_complexity" }, { "name": "probable_repair", "type": "esriFieldTypeString", "alias": "Probable_Repair", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "probable_repair" }, { "name": "estimated_cost_for_full_repair", "type": "esriFieldTypeString", "alias": "Estimated Cost for Full Repair", "domain": { "type": "codedValue", "name": "Cost", "description": "", "codedValues": [ { "name": "$50k - $100k", "code": "$50k - $100k" }, { "name": ">$100k - $500k", "code": ">$100k - $500k" }, { "name": ">$500k - $1M", "code": ">$500k - $1M" }, { "name": ">$1M - $5M", "code": ">$1M - $5M" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "estimated_cost_for_full_repair" }, { "name": "condition", "type": "esriFieldTypeString", "alias": "condition", "domain": { "type": "codedValue", "name": "Condition Status", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Critical", "code": "Critical" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "condition" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "parentrowid", "type": "esriFieldTypeGUID", "alias": "parentrowid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentrowid" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Field", "type": "esriFieldTypeString", "alias": "Field", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Field" }, { "name": "bridge_name", "type": "esriFieldTypeString", "alias": "Bridge Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "bridge_name" }, { "name": "attachment_url", "type": "esriFieldTypeString", "alias": "Attachment URL", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "attachment_url" } ], "indexes": [ { "name": "UUID_1627", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_587615_paren", "fields": "parentrowid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_1627", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Damage_Assessment", "description": "", "prototype": { "attributes": { "bridge_name": null, "attachment_url": null, "assessmentdate": null, "assessed_by": null, "impact": null, "detour_length_if_closed": null, "estimated_time_to_reopen": null, "estimated_time_to_fully_repair": null, "asset_damaged": null, "asset_damaged_other": null, "defect_type": null, "severity": null, "specialist_inspection_required": null, "comments": null, "repair_complexity": null, "probable_repair": null, "estimated_cost_for_full_repair": null, "condition": null, "Field": null, "parentrowid": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Sync,Extract,ChangeTracking", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "97b36e0aeda640b7a0893608e635e3ce" }