Name: damages_repeat

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• brief_description (type: esriFieldTypeString, alias: Brief description of the damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• level_of_damage (type: esriFieldTypeString, alias: Level of Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [d1: Minor - 15%], [d2: 25%], [d3: Moderate - 35%], ... 4 more ...)
• damage_pct (type: esriFieldTypeDouble, alias: Percent Damaged, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ag_type_of_crop (type: esriFieldTypeString, alias: Type of crop, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cardamomo: Cardamomo], [maiz: Maíz], [frijol: Frijol], ... 92 more ...)
• ag_crop_code (type: esriFieldTypeString, alias: Crop Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ag_cultivated_area (type: esriFieldTypeDouble, alias: Cultivated Area (hectares), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ag_unit_cost (type: esriFieldTypeDouble, alias: Cost per Hectare, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ag_crop_area_affected (type: esriFieldTypeDouble, alias: Crop Area Affected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ag_totalcost (type: esriFieldTypeDouble, alias: Total cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• housing_land_area (type: esriFieldTypeDouble, alias: Land Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• housing_typology (type: esriFieldTypeString, alias: Description of building typology, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [un_nivel___pared_de_bloque_de_concreto___cubierta_de_lamina_de_zinc1: Un Nivel - Pared de bloque de concreto - cubierta de lamina de zinc], [un_nivel___pared_de_bloque_de_concreto___cubierta_de_lamina_decorativa_o_teja1: Un Nivel - Pared de bloque de concreto - cubierta de lamina decorativa o teja], [un_nivel___pared_de_bloque_de_concreto___cubierta_de_losa_de_concreto1: Un Nivel - Pared de bloque de concreto - cubierta de losa de concreto], ... 25 more ...)
• housing_code (type: esriFieldTypeString, alias: Building typology Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• housing_construction_area (type: esriFieldTypeDouble, alias: Construction area (M2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• housing_unit_cost (type: esriFieldTypeDouble, alias: Cost per M2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• housing_damaged_area (type: esriFieldTypeDouble, alias: Damaged Area (M2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• housing_totalcost (type: esriFieldTypeDouble, alias: Total damage cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• health_typology (type: esriFieldTypeString, alias: Description of building typology, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [un_nivel___pared_de_bloque_de_concreto___cubierta_de_lamina_de_zinc: Un Nivel - Pared de bloque de concreto - cubierta de lamina de zinc], [un_nivel___pared_de_bloque_de_concreto___cubierta_de_lamina_decorativa_o_teja: Un Nivel - Pared de bloque de concreto - cubierta de lamina decorativa o teja], [un_nivel___pared_de_bloque_de_concreto___cubierta_de_losa_de_concreto: Un Nivel - Pared de bloque de concreto - cubierta de losa de concreto], ... 27 more ...)
• health_code (type: esriFieldTypeString, alias: Building typology Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• health_construction_area (type: esriFieldTypeDouble, alias: Construction area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• health_unit_cost (type: esriFieldTypeDouble, alias: Cost per M2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• health_damaged_area (type: esriFieldTypeDouble, alias: Damaged Area (M2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• health_totalcost (type: esriFieldTypeDouble, alias: Total damage cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tnc_typology (type: esriFieldTypeString, alias: Infrastructure/Asset Typology Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [singlelane_reinforced_concrete_structure_bridge: Puente estructura de concreto Armado de un solo carril], [twolane_reinforced_concrete_structure_bridge: Puente estructura de concreto Armado de dos carriles], [fourlane_reinforced_concrete_structure_bridge: Puente estructura de concreto Armado de cuatro carriles], ... 31 more ...)
• tnc_asset_code (type: esriFieldTypeString, alias: Infrastructure/Asset Typoplogy Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tnc_material (type: esriFieldTypeString, alias: Consturction material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tnc_mat_code (type: esriFieldTypeString, alias: tnc_mat_code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tnc_type (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tnc_construction_area (type: esriFieldTypeDouble, alias: Dimension of affected asset, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tnc_measurement_unit (type: esriFieldTypeString, alias: Measurement unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tnc_unit_cost (type: esriFieldTypeDouble, alias: Unit cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tnc_damaged_area (type: esriFieldTypeDouble, alias: Damaged Area (M2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• tnc_totalcost (type: esriFieldTypeDouble, alias: Total cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• educ_buildings_name (type: esriFieldTypeString, alias: Building Name or Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• educ_builing_assettype (type: esriFieldTypeString, alias: Type of Asset/Infrastructure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [classrooms: Classrooms], [bathrooms: Bathrooms], [library: Library], ... 5 more ...)
• educ_damage_type (type: esriFieldTypeString, alias: Type of Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [damage_to_buldin: Damage to Bulding (classrooms, offices, gym, etc)], [damage_to_furnit: Damage to Furniture and equipment], [damage_to_servic: Damage to Services (WASH, electricity, internet)], ... 1 more ...)
• educ_building_desc (type: esriFieldTypeString, alias: Description of building typology, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [un_nivel___pared_de_manposteria_reforzada_block_cubierta_de_lamina_aluzinc___con_acabados: Un Nivel - Pared de manposteria reforzada block, cubierta de lamina aluzinc - con acabados], [un_nivel___pared_de_mamposteria_reforzada_block_visto___cubierta_de_lamina_aluzinc___sin_acabados_acabados: Un Nivel - Pared de mamposteria reforzada block visto - cubierta de lamina aluzinc - sin acabados acabados], [un_nivel___pared_de_mamposteria_reforzada_block___cubierta_de_lamina_zinc___con_acabados: Un Nivel - Pared de mamposteria reforzada block - cubierta de lamina zinc - con acabados], ... 21 more ...)
• educ_building_code (type: esriFieldTypeString, alias: Building typology Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• educ_con_area (type: esriFieldTypeDouble, alias: Construction area (M2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• educ_damage_area (type: esriFieldTypeDouble, alias: Damaged Area (M2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• educ_unit_cost (type: esriFieldTypeDouble, alias: Cost per M2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• educ_totalcost (type: esriFieldTypeString, alias: Total damage cost, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• educ_servicetype_damage (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [water: Water], [sewage: Sewage], [electricity: Electricity], ... 1 more ...)
• remarks (type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• 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)

Relationships:

• sector_template_damages_repeat (1) -- Related To: survey (0)
• damages_repeat_photos_repeat (2) -- Related To: photos_repeat (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/8/2025 4:37:16 AM

Schema Last Edit Date: 1/8/2025 4:37:16 AM

Data Last Edit Date: 1/8/2025 4:37:16 AM

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