— Base dataset fields —
All fields from Adjudicated Property Dataset included
— Blight Priority Index —
blight_priority_index (BPI)
Composite blight urgency score (0–100). Sum of three sub-scores: flood severity, ground instability, and environmental burden. Higher = greater remediation urgency.
blight_tier
BPI tier label: Baseline (0–25) / Elevated (26–50) / High Priority (51–75) / Critical (76–100)
flood_score
BPI sub-score (0–40): FEMA flood zone severity + SFHA designation + soil flooding frequency + hydric soil
ground_score
BPI sub-score (0–30): shrink-swell LEP + hydric soil + drainage class
environmental_score
BPI sub-score (0–30): cumulative weighted EPA facility burden within 0.5 miles + historical brownfield sites + corrosion ratings
— Redevelopment Opportunity Score —
redevelopment_opportunity_score (ROS)
Composite acquisition attractiveness score (0–100). Sum of four sub-scores: location & zoning, construction feasibility, acquisition readiness, and redevelopment upside. Higher = more attractive target.
opportunity_tier
ROS tier label: Low Opportunity (0–40) / Moderate (41–60) / Good (61–80) / Prime (81–100)
location_score
ROS sub-score (0–40): zoning classification — Commercial (38) → Mixed Use (34) → Industrial (28) → Residential (20)
construction_feasibility_score
ROS sub-score (0–30): starts at 30, deducts for SFHA, flood zone, high LEP, hydric soil, and historical brownfield proximity
readiness_score
ROS sub-score (0–20): acquisition path clarity — Monition judgment filed (20) / Private standard (14) / Government-held (5)
upside_score
ROS sub-score (0–10): MPC Future Land Use alignment — General/Neighborhood Commercial or Mixed Use (10) → High-density Residential/Institutional (7) → Industrial (6)
flood_zone / in_sfha
FEMA flood zone designation (AE, A, X, etc.) and Special Flood Hazard Area flag
freeboard_ft / years_until_entry
Current margin above BFE; projected years until parcel enters Zone AE at current subsidence rate
velocity_vert_mmyr
Vertical ground subsidence rate (mm/yr) — multi-track Sentinel-1 InSAR average, CORS-calibrated and ERA5-corrected
lep (shrink_swell_lep)
Linear Extensibility Percent — USDA measure of shrink-swell severity in expansive clay soils. Range 4.5–14.6 across dataset.
drainage_class / hydric_soil
SSURGO soil drainage classification and hydric soil designation
brownfield_count_half_mi / brownfield_detail
Count and per-site detail (name, type, distance) of Sanborn-derived historical contamination sites within 0.5 miles
nearest_epa_facility / nearest_epa_mi
Closest EPA-registered facility name and distance in miles
corrosion_concrete / corrosion_steel
SSURGO-derived soil corrosivity ratings for concrete and steel infrastructure
— Permit & Violation History —
permit_count / last_permit_date / last_permit_type
Building permit history from Caddo records: total permit count, most recent permit date and type, demo/new construction/utility disconnect flags
violation_count / violation_ratio
Cumulative code violations and violation-to-permit ratio — Caddo only
parcel_score / urgency_tier
Composite distress score (0–100) and urgency tier 1–3 — Caddo only
lisa_quadrant
LISA spatial cluster type: HH / HL / LH / LL (assessor value Moran's I) — in DB, not yet included in export
future_land_use
MPC Future Land Use map designation — drives the ROS upside sub-score
insar_track
'multi' (dual-geometry T63+T136 average) / 'T63' / 'T136' — indicates subsidence measurement confidence level