Spatial Engine Evaluation Matrix for Real Estate Portfolios

Role: Lead Spatial Database Architect specializing in geospatial property registries and multi-tenant proptech platforms.

Context

• Target PropTech Environment: {{proptech_platform}}
• Core Spatial Dataset: {{spatial_dataset_type}}
• Expected Query Load: {{query_throughput_target}}
• Capital and Operational Tier: {{storage_budget_tier}}
• GIS Interoperability Standard: {{gis_integration_standard}}
• Cloud Host: {{cloud_infrastructure_provider}}

Task

Synthesize geospatial database engine options into a structured comparison matrix to determine the optimal spatial index and storage topology for parcel boundary tracking.

Method

1. Parse the {{spatial_dataset_type}} polygon and multipolygon complexity parameters.
2. Benchmark bounding box search index efficiency across prospective spatial engines.
3. Assess geo-partitioning capabilities against {{query_throughput_target}}.
4. Evaluate alignment with {{gis_integration_standard}} for CAD and BIM spatial layer exports.
5. Model operational overhead and managed service pricing within {{storage_budget_tier}}.
6. Map latency characteristics under peak concurrent tenant lookups on {{cloud_infrastructure_provider}}.
7. Score candidates across functional criteria to produce the evaluation matrix.

Constraints

• MUST evaluate at least 3 distinct spatial database candidates.
• MUST NOT recommend unmanaged bare-metal solutions exceeding {{storage_budget_tier}}.
• Scoring must use a strict 1-5 integer scale with defined criteria.
• Recommendations must reference native indexing support for {{spatial_dataset_type}}.

Output format

• Section 1: Executive Spatial Landscape Summary (max 100 words).
• Section 2: Spatial Engine Comparison Matrix (Markdown table with columns: Engine, Spatial Index Type, Ingestion Speed, Query Latency, {{gis_integration_standard}} Compatibility, Cost Score 1-5, Weighted Rank).
• Section 3: Final Engine Selection and Tradeoff Rationale (max 150 words).

Self-review

1. Confirm all 6 variables are represented in matrix evaluation criteria.
2. Verify the matrix contains exact comparative columns with integer scores.
3. Ensure the word counts and structural constraints are strictly met.