Name: building_assesment_structure_BLC

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: 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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• _name_of_the_block_or_building (type: esriFieldTypeString, alias: Name of the block or building you are assessing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• purpose_of_the_building (type: esriFieldTypeString, alias: Purpose of the building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• health_facility_status (type: esriFieldTypeString, alias: Health Facility Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Inact, can be rehabilitated: Inact, can be rehabilitated], [Minor damaged: Minor damaged], [Severely damaged_: Severely damaged], ... 1 more ...)
• building_construction_type (type: esriFieldTypeString, alias: Building Construction Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Multi-story building: Multi-story building], [One story Building with a concr: One story Building with a concrete slab roof], [One story Building with a corru: One story Building with a corrugated steel roof], ... 3 more ...)
• building_area_in_square_meters (type: esriFieldTypeDouble, alias: Building area in square meters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_of_floors (type: esriFieldTypeDouble, alias: Number of floors, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_area_m2 (type: esriFieldTypeDouble, alias: Estimation of total Area/surface (M2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• are_elevators_available_in_the (type: esriFieldTypeString, alias: Are elevators available in the building?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• field_3082 (type: esriFieldTypeDouble, alias: how many?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• field_2363 (type: esriFieldTypeDouble, alias: how many are functioning?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• are_there_significant_cracks_in (type: esriFieldTypeString, alias: Are there significant cracks in the load-bearing walls and columns?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• field_2369 (type: esriFieldTypeString, alias: Are there significant cracks in slabs and stairs?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• is_the_roof_damaged (type: esriFieldTypeString, alias: Is the roof damaged?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• are_the_block_walling_internal (type: esriFieldTypeString, alias: Are the block walling (Internal / External ) in the building intact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• are_ceiling_panels_and_overhead (type: esriFieldTypeString, alias: Are ceiling panels and overhead lighting intact?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• are_windows_and_doors_in_place (type: esriFieldTypeString, alias: Are windows and doors in place and able to close?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• is_the_flooring_tiles_in_the_bu (type: esriFieldTypeString, alias: Is the flooring ( Tiles ) in the building intact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• is_there_a_perceived_imminent_d (type: esriFieldTypeString, alias: Is there a perceived imminent danger to patients and staff?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• is_the_condition_of_the_structu (type: esriFieldTypeString, alias: Is the condition of the structure adequate to allow medical activities in a safe manner?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• recommended_next_actions_for_th (type: esriFieldTypeString, alias: Recommended next actions for this building, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• are_further_technical_assessmen (type: esriFieldTypeString, alias: Are further technical assessments needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• if_yes_please_specify_which_pro (type: esriFieldTypeString, alias: If yes, please specify which profiles need to be involved in future assessments, SQL Type: sqlTypeOther, length: 1000, 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:

• form_building_assesment_structure_BLC (1) -- Related To: survey (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/5/2025 9:47:24 AM

Schema Last Edit Date: 5/20/2025 11:50:14 AM

Data Last Edit Date: 6/5/2025 9:47:24 AM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat