auto-data-snapshot: 2026-08-10T21:49:05 (1 data files) — PARCEL-COVERAGE.md

9a7dd5f96df889a14d1c7a6b8e595cf7b1a30908 · 2026-08-10 21:49:32 -0700 · auto-commit-fleet
Files touched

M PARCEL-COVERAGE.md
Diff

commit 9a7dd5f96df889a14d1c7a6b8e595cf7b1a30908
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Mon Aug 10 21:49:32 2026 -0700

    auto-data-snapshot: 2026-08-10T21:49:05 (1 data files) — PARCEL-COVERAGE.md
---
 PARCEL-COVERAGE.md | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/PARCEL-COVERAGE.md b/PARCEL-COVERAGE.md
index b620f84..d6d0f01 100644
--- a/PARCEL-COVERAGE.md
+++ b/PARCEL-COVERAGE.md
@@ -7,7 +7,7 @@ LA reads in place from CRCP's SQLite (`source_kind='sqlite'`); every other
 covered county lives in the generic `parcel` PG table (`source_kind='pg'`,
 migration 004, adapters in `src/ingest/parcels/`).
 
-## Live coverage snapshot (2026-07-29) — 6.6M parcels, 28 counties, 11 states
+## Live coverage snapshot (2026-08-10) — 6.6M parcels loaded across 28 counties/11 states; +4 metro adapters ready (Dallas·Harris·Clark·Philadelphia, backfill Steve-gated)
 
 Coverage has expanded significantly via the ArcGIS-sales pipeline (arcgis_sales.ts)
 and dedicated adapters. The hourly loop (`src/jobs/hourly_loop.ts`) runs these
@@ -34,6 +34,10 @@ ingests continuously. Current state from `parcel` + `ingest_cursor` tables:
 | OR | Klamath (41035) | 1,000 | 🔄 Stub | 38k total |
 | TX | Tarrant (48439) | ~714,982 | ✅ Complete | Fort Worth; owner, market value |
 | TX | Bexar (48029) | ~721,005 | ✅ Complete | San Antonio; owner, address |
+| TX | Dallas (48113) | ~548,830 | 🆕 Adapter ready | Dallas/DCAD; owner, market value (backfill Steve-gated) |
+| TX | Harris (48201) | ~1,548,457 | 🆕 Adapter ready | Houston/HCAD; owner, market value, deed date (backfill Steve-gated) |
+| NV | Clark (32003) | ~839,630 | 🆕 Adapter ready | Las Vegas; owner, **priced sale**, year built (backfill Steve-gated) |
+| PA | Philadelphia (42101) | ~583,688 | 🆕 Adapter ready | Owner, market value, **priced sale**, year, **beds/baths**, zoning (backfill Steve-gated) |
 | UT | Salt Lake (49035) | 391,370 | ✅ Complete | Market value; no owner/price |
 | WA | King (53033) | 628,417 | ✅ Complete | Seattle; full deed history w/ prices |
 | WA | Thurston (53067) | 80,124 | ✅ Complete | Olympia; free priced deeds |
@@ -55,6 +59,10 @@ ingests continuously. Current state from `parcel` + `ingest_cursor` tables:
 | Tarrant, TX — Fort Worth (48439) | ~714,982 | TAD appraisal roll via City-of-Fort-Worth hosted `Parcels_Public_Vview` FeatureServer (keyless ArcGIS, `COUNTYNAME='Tarrant'` filter; `ingest:parcels tarrant`) | re-run adapter (remote-runnable, no GDAL) | Details (sqft/living-area 89%, year-built 90%, state use code), **Ownership (owner 100%)**, site address + real city name, LAND+IMPR + **TRUE MARKET value (99%)** + appraised value, **Property History: deed/ownership-change DATE (98%, no price in this feed) → parcel_event `deed` rows w/ amount NULL**, Map (polygon centroid). **No beds/baths or sale PRICE** (TAD withholds them in the public view). Feed sentinel `12-31-1900` (~18k, "no deed on record") dropped. The TAD county's own `gis.tad.org` 000s to plain curl — this CFW-hosted public view is the reachable authoritative copy |
 | Bexar, TX — San Antonio (48029) | ~721,005 | BCAD appraisal roll via City-of-San-Antonio open-data hosted `BCAD_Parcels` FeatureServer (keyless ArcGIS, `PropID>0` filter, `outSR=4326` server-side reproject; `ingest:parcels bexar`) | re-run adapter (remote-runnable, no GDAL) | Details (living-area sqft 87%, state use code, land sqft, legal acreage), **Ownership (owner 99%)**, `Situs` **property** address parsed → street+city+zip (99%; the mailing `addr_*` fields are the owner's, so we read situs instead), Map (polygon centroid, WGS84). **No appraised value / year-built / beds-baths / sale-or-deed feed** in this CoSA-hosted BCAD open view → parcel-DETAIL-only (like Salt Lake); **zero parcel_event rows** (no fabricated sales). The authoritative `maps.bcad.org` PAMapSearch service DOES carry appraised value + owner but blocks bulk paging (no offset/orderBy) — so the pageable CoSA layer is the full-universe backfill source (Tarrant precedent) |
 | Fulton, GA — Atlanta (13121) | ~373,004 | Board of Assessors tax digest via Fulton County DoIT/GIS hosted `Tax_Parcels` FeatureServer (keyless ArcGIS, `ParcelID<>''` filter, `outSR=4326`; `ingest:parcels fulton`) | re-run adapter (remote-runnable, no GDAL) | Details (living/dwelling units `LivUnits` 86%, land-use `LUCode` 100%, class code, land acres), **Ownership (owner 99.98%)**, property address assembled from the structured `AddrNumber`/`AddrPreDir`/`AddrStreet`/`AddrSuffix`/`AddrPosDir`/unit components (100%), tax year 2026, Map (polygon centroid, WGS84). **No market/assessed value / year-built / building sqft / beds-baths / sale-or-deed feed** in this open assessor view → parcel-DETAIL-only (like Bexar/Salt Lake); **zero parcel_event rows** (no fabricated sales). The layer serviceDescription self-identifies as the Fulton Board of Assessors annual tax digest. No separate city column (county spans Atlanta + ~14 municipalities) — city left null rather than guessed |
+| Dallas, TX — Dallas (48113) | ~548,830 | DCAD appraisal accounts via City-of-Dallas GIS `CRMHostedLayers` "Tax Account Points" (keyless ArcGIS, POINT geom, `outSR=4326`; `ingest:parcels dallas`) — **adapter built + bounded-verified, full backfill Steve-gated** | re-run adapter (remote-runnable, no GDAL) | **Ownership (Owner1 ~95%)**, situs address (`SiteAddrNum`+`SiteStreetname`), LAND+IMP + **TRUE MARKET/total value (~93%)**, property-class use, appraisal year, jurisdiction city, Map (point lat/lng). **No sqft / year-built / beds-baths / sale-or-deed feed** in this layer (deed instrument text lives unparsed in `Legal4`) → parcel-DETAIL+value (like Bexar but WITH value); **zero parcel_event rows** (no fabricated sales). DCAD's own hosts (`maps.dcad.org`/`gis.dcad.org`) 404 to headless — this City mirror is the reachable full-county account universe |
+| Harris, TX — Houston (48201) | ~1,548,457 | HCAD appraisal roll via Harris County public GIS `HCAD/Parcels` MapServer (keyless ArcGIS, `outSR=4326`; `ingest:parcels harris`) — **adapter built + bounded-verified, full backfill Steve-gated** | re-run adapter (remote-runnable, no GDAL) | **Largest county in system (1.55M). Ownership (owner_name_1 ~98%)**, situs address (assembled from the `site_str_*` parts), LAND+BLDG + **TRUE MARKET value (~98%)** + appraised value, lot sqft (~66%), land-use + state class, **Property History: deed/ownership-change DATE (`new_owner_date`, ~98%, no price in this feed) → parcel_event `deed` rows w/ amount NULL**, Map (polygon centroid). **No building sqft / year-built / beds-baths / sale PRICE** (deed date only, like Tarrant). Owner+value live in ONE layer — no bulk-text-download detour; the `services.arcgis.com` COH layers are project subsets, only `www.gis.hctx.net` has the full feed |
+| Clark, NV — Las Vegas (32003) | ~839,630 | Clark County GIS Office hosted `CC_PARCELS_SHP` FeatureServer **layer 1** (keyless ArcGIS, `orderBy OBJECTID_1`, `outSR=4326`; `ingest:parcels clark`) — **adapter built + bounded-verified, full backfill Steve-gated** | re-run adapter (remote-runnable, no GDAL) | **Ownership (OWNER ~90%)**, situs address (~90%), **Property History: PRICED last-sale (`SALEPRICE`+`SALEDATE`+recorded `DOCNO`, ~81%) → parcel_event `sale` rows w/ real amount**, year-built (`CONSTYR` ~82%), lot sqft, land-use code, Map (polygon centroid). **Assessed/market VALUE NOT in this GIS layer** (the value columns exist but are 100% zero — left NULL, never fabricated). Low-id head is blank-owner shells (real but empty parcels); gisgate REST + Hub open-data hosts are blocked/private to headless — this hosted layer is the reachable path |
+| Philadelphia, PA (42101) | ~583,688 | Philadelphia OPA `opa_properties_public` via keyless **Carto SQL API** (`phl.carto.com/api/v2/sql`, LIMIT/OFFSET, `ST_Y/ST_X` centroids; `ingest:parcels philadelphia`) — **adapter built + bounded-verified, full backfill Steve-gated** | re-run adapter (remote-runnable, no GDAL) | **Richest county in system. Ownership (owner_1 ~100%)**, situs address, **TRUE market value (~100%)**, **Property History: PRICED last-sale (price+date, ~99%; 73% arm's-length >$1, rest nominal $1 family/deed transfers kept as legit low-consideration) → parcel_event `sale` rows w/ real amount**, year-built (~92%), living-area sqft (~92%), **beds + baths (the FIRST full-universe county with beds/baths)**, zoning, use, lat/lng direct from PostGIS. First adapter over a Carto SQL feed (all others are ArcGIS/Socrata). `taxable_land`/`taxable_building` (post-abatement split) carried in `extra` |
 
 ## Probed — gated or absent
← cd7be34 auto-data-snapshot: 2026-08-10T21:18:09 (1 data files) — pac · back to Nationalrealestate · TK-5: add 4 metro parcel adapters — Dallas TX, Harris TX, Cl 709c182 →