Name: Damage_Assessment

Display Field: assessmentdate

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 97b36e0aeda640b7a0893608e635e3ce

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• assessmentdate ( type: esriFieldTypeDate, alias: Assesment Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: assessmentdate )
• assessed_by ( type: esriFieldTypeString, alias: Assessed_By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assessed_by )
• impact ( type: esriFieldTypeString, alias: Impact, editable: true, nullable: true, length: 255, defaultValue: null, modelName: impact , Coded Values: [Caution: Caution] , [One Lane Closure: One Lane Closure] , [Full Road Closure: Full Road Closure] , ...1 more... )
• detour_length_if_closed ( type: esriFieldTypeString, alias: Detour Length if Closed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: detour_length_if_closed , Coded Values: [Not required: Not required] , [Short (<30mins): Short (<30mins)] , [Moderate (30-90mins): Moderate (30-90mins)] , ...2 more... )
• estimated_time_to_reopen ( type: esriFieldTypeString, alias: Estimated Time to Reopen for Temporary Emergency Access, editable: true, nullable: true, length: 255, defaultValue: null, modelName: estimated_time_to_reopen , Coded Values: [Under 12 hours: Under 12 hours] , [12 - 48 hours: 12 - 48 hours] , [48 hours - 7 days: 48 hours - 7 days] , ...4 more... )
• estimated_time_to_fully_repair ( type: esriFieldTypeString, alias: Estimated_Time_to_Fully_Repair, editable: true, nullable: true, length: 255, defaultValue: null, modelName: estimated_time_to_fully_repair , Coded Values: [Under 12 hours: Under 12 hours] , [12 - 48 hours: 12 - 48 hours] , [48 hours - 7 days: 48 hours - 7 days] , ...4 more... )
• asset_damaged ( type: esriFieldTypeString, alias: Asset_Damaged, editable: true, nullable: true, length: 255, defaultValue: null, modelName: asset_damaged , Coded Values: [Corridor: Corridor] , [Pavement: Pavement] , [Shoulder: Shoulder] , ...5 more... )
• asset_damaged_other ( type: esriFieldTypeString, alias: Asset_Damaged_Other, editable: true, nullable: true, length: 255, defaultValue: null, modelName: asset_damaged_other )
• defect_type ( type: esriFieldTypeString, alias: Defect_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: defect_type , Coded Values: [Overslip: Overslip] , [Rockfall: Rockfall] , [Dropout: Dropout] , ...9 more... )
• severity ( type: esriFieldTypeString, alias: Severity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: severity , Coded Values: [Minor: Minor] , [Moderate: Moderate] , [Major: Major] , ...2 more... )
• specialist_inspection_required ( type: esriFieldTypeString, alias: Specialist_Inspection_Required, editable: true, nullable: true, length: 255, defaultValue: null, modelName: specialist_inspection_required , Coded Values: [No: No] , [Yes - Structural: Yes - Structural] , [Yes - Geotechnical: Yes - Geotechnical] )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• repair_complexity ( type: esriFieldTypeString, alias: Repair_Complexity, editable: true, nullable: true, length: 255, defaultValue: null, modelName: repair_complexity , Coded Values: [Minor Repair - No Design: Minor Repair - No Design] , [Moderate Repair - No Design: Moderate Repair - No Design] , [Moderate Repair - Design Required: Moderate Repair - Design Required] , ...1 more... )
• probable_repair ( type: esriFieldTypeString, alias: Probable_Repair, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: probable_repair )
• estimated_cost_for_full_repair ( type: esriFieldTypeString, alias: Estimated Cost for Full Repair, editable: true, nullable: true, length: 255, defaultValue: null, modelName: estimated_cost_for_full_repair , Coded Values: [$50k - $100k: $50k - $100k] , [>$100k - $500k: >$100k - $500k] , [>$500k - $1M: >$500k - $1M] , ...1 more... )
• condition ( type: esriFieldTypeString, alias: condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...2 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• parentrowid ( type: esriFieldTypeGUID, alias: parentrowid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parentrowid )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Field ( type: esriFieldTypeString, alias: Field, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Field )
• bridge_name ( type: esriFieldTypeString, alias: Bridge Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: bridge_name )
• attachment_url ( type: esriFieldTypeString, alias: Attachment URL, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: attachment_url )

Templates:

• Name: Damage_Assessment
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• WSPGIS.GISADMIN.Canary_Wairoa_Bridges (0) -- Related To: Wairoa_Bridges (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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: true

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata