Prototype. Every figure on this page is illustrative. The register holds 8 sample assets from the MoPED data-model workbook and 112 generated to match its schema — no real asset, valuation or coordinate.
Data Dictionary
The field-level contract
One row per field: type, unit, who supplies it, whether it is mandatory, and the vocabulary it must draw from. Labels on every other page are read from here rather than duplicated, so the sheet stays the single source of truth. Fill rate is measured against the 120 rows currently loaded.
Fields
96
across 10 groups
Mandatory
38
Conditional
8
Optional
37
Derived
13
formula-driven, never typed
Controlled lists
22
171 values in total
| # | Field | DB code | Type | Source | Status | Fill rate | Notes |
|---|---|---|---|---|---|---|---|
| 1 | Asset ID كود الأصل | asset_id | Text | Computed / Entlaq | Mandatory | 100% | Unique key. Format: GOV-SECTOR-#### |
| 2 | Asset Name (EN) اسم الأصل (إنجليزي) | asset_name_en | Text | Government | Mandatory | 100% | Common / official name |
| 3 | Asset Name (AR) اسم الأصل (عربي) | asset_name_ar | Text | Government | Mandatory | 100% | Official Arabic name as per government records |
| 4 | Custodian Entity الجهة الحائزة | custodian_entity | Text | Government | Mandatorydv_custodian | 100% | Ministry, governorate, authority or SOE holding the asset |
| 5 | Custodian Sub-Unit / Directorate الإدارة التابعة | custodian_sub | Text | Government | Optional | 79% | |
| 6 | Ownership Type نوع الملكية | ownership_type | Text | Government | Mandatorydv_ownership | 100% | |
| 7 | Title / Registration Status حالة التسجيل العقاري | title_status | Text | Government | Mandatorydv_title | 100% | |
| 8 | Real-Estate Registry No. رقم الشهر العقاري | registry_no | Text | Government | Optional | 71% | |
| 9 | Asset Class تصنيف الأصل | asset_class | Text | Government | Mandatorydv_class | 100% | Land / Building / Villa / Apartment / Office / Retail / Warehouse / Industrial / Mixed-use / Other |
| 10 | Asset Sub-Type النوع الفرعي | asset_subtype | Text | Government | Optionaldv_subtype | 93% | |
| 11 | Current Use الاستخدام الحالي | current_use | Text | Field survey | Mandatory | 98% | |
| 12 | Utilization Status حالة الاستغلال | utilization_status | Text | Field survey | Mandatorydv_util | 100% | |
| 13 | Years Vacant / Underused عدد سنوات عدم الاستغلال | vacancy_years | Numeric | Government | Optional | 100% | |
| 14 | Occupied By / Encumbrances شاغلو العقار / الأعباء | occupied_by | Text | Field survey | Optional | 100% | Squatters, tenants, litigation, mortgages |
| 15 | Governorate المحافظة | governorate | Text | Government | Mandatorydv_gov | 100% | |
| 16 | City / Markaz المدينة / المركز | city | Text | Government | Mandatory | 100% | |
| 17 | District / Neighbourhood الحي / القرية | district | Text | Government | Mandatory | 100% | |
| 18 | Full Address (EN) العنوان التفصيلي (إنجليزي) | address_en | Text | Government | Mandatory | 100% | |
| 19 | Full Address (AR) العنوان التفصيلي (عربي) | address_ar | Text | Government | Mandatory | 96% | |
| 20 | Latitude خط العرض | latitude | DecimalDecimal degrees | Field survey | Mandatory | 100% | Decimal degrees, WGS84 |
| 21 | Longitude خط الطول | longitude | DecimalDecimal degrees | Field survey | Mandatory | 100% | Decimal degrees, WGS84 |
| 22 | Google Maps Pin رابط الموقع على الخرائط | maps_pinƒ | TextURL | Computed in-sheet | Derived | 0% | Auto-generated from lat/long. Clickable. |
| 23 | Plot / Block No. رقم القطعة / البلوك | plot_no | Text | Government | Optional | 83% | |
| 24 | Zoning Classification التصنيف التخطيطي | zoning | Text | Government | Mandatorydv_zoning | 100% | |
| 25 | Permitted Use per Detailed Plan الاستخدام المسموح به | permitted_use | Text | Government | Optional | 82% | |
| 26 | Distance to Main Road (km) المسافة للطريق الرئيسي (كم) | dist_main_road | Numeric | Desktop research | Optional | 100% | |
| 27 | Distance to Transport Node (km) المسافة لأقرب محور نقل (كم) | dist_transport | Numeric | Desktop research | Optional | 100% | |
| 28 | Catchment Population (000s) عدد السكان بالنطاق (ألف) | catchment_pop | NumericEGP / count | Desktop research | Optional | 100% | |
| 29 | Land Area (m2) مساحة الأرض (م٢) | land_area | Numericm2 / EGP per m2 | Government | Mandatory | 82% | |
| 30 | Built-Up Area / BUA (m2) المساحة المبنية (م٢) | bua | Numericm2 / EGP per m2 | Government | Mandatory | 83% | Leave blank for vacant land |
| 31 | Gross Leasable Area (m2) المساحة القابلة للتأجير (م٢) | gla | Numericm2 / EGP per m2 | Government | Optional | 83% | |
| 32 | Number of Floors عدد الأدوار | floors_count | Numeric | Government | Optional | 83% | |
| 33 | Number of Units عدد الوحدات | units_count | Numeric | Government | Optional | 83% | |
| 34 | Year Built سنة الإنشاء | year_built | Numeric | Government | Optional | 83% | |
| 35 | Building Age (yrs) عمر المبنى (سنة) | building_ageƒ | Numeric | Computed in-sheet | Derived | 83% | |
| 36 | Structure Type نظام الإنشاء | structure_type | Text | Government | Optionaldv_structure | 83% | |
| 37 | Finishing Level مستوى التشطيب | finishing_level | Text | Government | Optionaldv_finish | 100% | |
| 38 | Utilities Connected المرافق المتاحة | utilities | Text | Field survey | Mandatory | 98% | Electricity / Water / Gas / Sewage / Internet — list what is connected |
| 39 | Heritage-Listed? مبنى ذو طراز معماري متميز؟ | heritage_listed | Text | Government | Optionaldv_yn | 100% | Affects permitted interventions |
| 40 | Internally Divided? هل يوجد تقسيم داخلي؟ | has_internal_division | Text | Field survey | Mandatorydv_yn | 100% | No for open land/plots — then leave the layout fields blank |
| 41 | Number of Rooms عدد الغرف | rooms_count | Numeric | Field survey | Conditional | 80% | |
| 42 | Number of Bathrooms عدد الحمامات | bathrooms_count | Numeric | Field survey | Conditional | 83% | |
| 43 | Reception / Halls عدد الصالات | reception_count | Numeric | Field survey | Optional | 83% | |
| 44 | Kitchens عدد المطابخ | kitchens_count | Numeric | Field survey | Optional | 83% | |
| 45 | Open-Plan Area (m2) المساحة المفتوحة (م٢) | open_plan_area | Numericm2 / EGP per m2 | Field survey | Optional | 83% | For offices/warehouses without partitions |
| 46 | Partition Flexibility قابلية إعادة التقسيم | partition_flexibility | Text | Field survey | Optionaldv_flex | 100% | |
| 47 | Parking Spaces عدد أماكن الانتظار | parking_spaces | Numeric | Field survey | Optional | 83% | |
| 48 | Layout Notes ملاحظات التقسيم | layout_notes | Text | Field survey | Optional | 100% | |
| 49 | Physical Condition الحالة الإنشائية | condition_rating | Text | Field survey | Mandatorydv_condition | 100% | |
| 50 | Condition Notes (EN) وصف الحالة (إنجليزي) | condition_notes_en | Text | Field survey | Mandatory | 100% | |
| 51 | Condition Notes (AR) وصف الحالة (عربي) | condition_notes_ar | Text | Field survey | Optional | 100% | |
| 52 | Renovation Required? هل يحتاج ترميم؟ | renovation_required | Text | Field survey | Mandatorydv_yn | 100% | |
| 53 | Renovation Scope نطاق أعمال الترميم | renovation_scope | Text | Field survey | Conditionaldv_renoscope | 99% | |
| 54 | Renovation Cost (EGP/m2) تكلفة الترميم (جنيه/م٢) | reno_cost_sqm | Numericm2 / EGP per m2 | Desktop research | Conditional | 76% | Benchmark rate — see 'Valuation Assumptions' tab |
| 55 | Est. Renovation Cost (EGP) إجمالي تكلفة الترميم (جنيه) | reno_cost_totalƒ | NumericEGP / count | Computed in-sheet | Derived | 77% | |
| 56 | Renovation Duration (months) مدة التنفيذ (شهر) | reno_duration_months | Numeric | Desktop research | Optional | 76% | |
| 57 | Licensing / Compliance Status الموقف الترخيصي | compliance_status | Text | Government | Optionaldv_compliance | 100% | |
| 58 | Valuation Method منهجية التقييم | valuation_method | Text | Entlaq analysis | Mandatorydv_valmethod | 100% | |
| 59 | Land Value (EGP/m2) سعر الأرض (جنيه/م٢) | land_value_sqm | Numericm2 / EGP per m2 | Desktop research | Mandatory | 82% | |
| 60 | Building Value (EGP/m2) سعر المباني (جنيه/م٢) | building_value_sqm | Numericm2 / EGP per m2 | Desktop research | Conditional | 83% | |
| 61 | Est. Market Value (EGP) القيمة السوقية التقديرية (جنيه) | market_valueƒ | NumericEGP / count | Computed in-sheet | Derived | 100% | |
| 62 | Value After Renovation (EGP) القيمة بعد الترميم (جنيه) | value_post_renoƒ | NumericEGP / count | Computed in-sheet | Derived | 98% | Market value uplifted by the condition-based renovation premium on the Assumptions tab |
| 63 | Government Book Value (EGP) القيمة الدفترية (جنيه) | book_value | NumericEGP / count | Government | Optional | 100% | |
| 64 | Valuation Date تاريخ التقييم | valuation_date | DateISO 8601 | Entlaq analysis | Mandatory | 98% | |
| 65 | Valuation Source مصدر التقييم | valuation_source | Text | Entlaq analysis | Optional | 100% | |
| 66 | ADR - Residential (EGP/day) السعر اليومي - سكني (جنيه) | adr_residential | NumericEGP / count | Desktop research | Conditional | 100% | |
| 67 | ADR - Commercial / Retail (EGP/day) السعر اليومي - تجاري (جنيه) | adr_commercial | NumericEGP / count | Desktop research | Conditional | 100% | |
| 68 | ADR - Office (EGP/day) السعر اليومي - إداري (جنيه) | adr_office | NumericEGP / count | Desktop research | Conditional | 100% | |
| 69 | ADR Applied (EGP/day) السعر اليومي المُطبق (جنيه) | adr_applicableƒ | NumericEGP / count | Computed in-sheet | Derived | 83% | Highest of the three ADR scenarios — override manually if the highest-and-best use differs |
| 70 | Assumed Occupancy Rate معدل الإشغال المفترض | occupancy_rate | Decimal (0-1)Percentage | Desktop research | Mandatory | 100% | Stored as a fraction, e.g. 0.65 = 65% |
| 71 | Gross Annual Revenue (EGP) الإيراد السنوي الإجمالي (جنيه) | gross_annual_revenueƒ | NumericEGP / count | Computed in-sheet | Derived | 83% | |
| 72 | Monthly Rent Equivalent (EGP) ما يعادل الإيجار الشهري (جنيه) | monthly_rent_equivƒ | NumericEGP / count | Computed in-sheet | Derived | 83% | |
| 73 | Annual Operating Cost (EGP) التكاليف التشغيلية السنوية (جنيه) | annual_opex | NumericEGP / count | Entlaq analysis | Mandatory | 84% | Default = OPEX ratio x gross revenue; see Assumptions tab |
| 74 | Net Operating Income (EGP) صافي الدخل التشغيلي (جنيه) | noiƒ | NumericEGP / count | Computed in-sheet | Derived | 83% | |
| 75 | Gross Yield (%) العائد الإجمالي (%) | gross_yieldƒ | Decimal (0-1)Percentage | Computed in-sheet | Derived | 83% | |
| 76 | Renovation Payback (yrs) فترة استرداد الترميم (سنة) | reno_payback_yearsƒ | Numeric | Computed in-sheet | Derived | 76% | |
| 77 | Current Actual Income (EGP/yr) الدخل الفعلي الحالي (جنيه/سنة) | current_annual_income | NumericEGP / count | Government | Mandatory | 100% | |
| 78 | Annual Revenue Gap (EGP) فجوة الإيراد السنوي (جنيه) | revenue_gapƒ | NumericEGP / count | Computed in-sheet | Derived | 83% | |
| 79 | Highest & Best Use أفضل استخدام ممكن | highest_best_use | Text | Entlaq analysis | Mandatorydv_hbu | 100% | |
| 80 | Recommended Monetization Route آلية الاستثمار المقترحة | monetization_option | Text | Entlaq analysis | Mandatorydv_monet | 100% | |
| 81 | CapEx to Activate (EGP) الاستثمار المطلوب للتفعيل (جنيه) | capex_to_activateƒ | NumericEGP / count | Computed in-sheet | Derived | 100% | |
| 82 | Priority Tier أولوية التدخل | priority_tier | Text | Entlaq analysis | Mandatorydv_priority | 100% | 1 = quick win, 2 = medium term, 3 = long term / complex |
| 83 | Key Blockers معوقات رئيسية | blockers | Text | Entlaq analysis | Optional | 100% | |
| 84 | Photos Folder (URL) رابط مجلد الصور | photos_link | TextURL | Field survey | Mandatory | 100% | Drive/S3 folder of geotagged photos. One row = one folder. |
| 85 | Number of Photos عدد الصور | photos_count | NumericURL | Field survey | Optional | 100% | |
| 86 | Primary Photo (URL) الصورة الرئيسية | primary_photo | TextURL | Field survey | Optional | 0% | Direct image link for the platform thumbnail |
| 87 | Floor Plan / Survey (URL) رابط الرسم المساحي | floorplan_link | TextURL | Government | Optional | 65% | |
| 88 | Title Deed & Docs (URL) رابط المستندات | deed_docs_link | TextURL | Government | Optional | 45% | |
| 89 | Video / 360 Tour (URL) رابط الفيديو / الجولة | video_link | TextURL | Field survey | Optional | 24% | |
| 90 | Primary Data Source المصدر الأساسي للبيانات | data_source | Text | Government | Mandatorydv_source | 100% | |
| 91 | Data Confidence درجة الثقة في البيانات | confidence_level | Text | Entlaq analysis | Mandatorydv_conf | 100% | |
| 92 | Site Visit Date تاريخ الزيارة الميدانية | site_visit_date | DateISO 8601 | Field survey | Optional | 97% | |
| 93 | Surveyor / Analyst المسؤول عن الحصر | surveyor | Text | Field survey | Optional | 100% | |
| 94 | Last Updated تاريخ آخر تحديث | last_updated | DateISO 8601 | Computed / Entlaq | Mandatory | 100% | |
| 95 | Record Status حالة السجل | record_status | Text | Entlaq analysis | Mandatorydv_recstatus | 100% | |
| 96 | General Notes ملاحظات عامة | notes | Text | Entlaq analysis | Optional | 100% |