Prototype·Built by Concourse for Arizona State Historic Preservation Office

About the data

Every record in this prototype carries one of three labels. We care a lot about being precise about what's real and what isn't — if we're going to argue for a production build, you should be able to trust the provenance.

Real data

Real, loaded from authoritative public sources

  • NPS NRIS All_Data (Arizona):1,533 listed properties pulled from the NPS's periodically-released XLSX spreadsheet. Contains address, city, county, listed date, category, levels of significance, MPS, acreage, and external link. Source: national-register-listed_20250624.xlsx.
  • NPS ArcGIS National_Register_Points (AZ subset): 123 geocoded point features with NPS form / photo PDF URLs, filtered from the national service by Arizona bounding envelope.
  • NPS ArcGIS National_Register_District (AZ subset): 216 historic district polygons.
  • Wikipedia NRHP listings (Arizona): 1,251 rows parsed from 15 county pages and break-out city pages via the MediaWiki API. Provides coordinates for 1,126 properties (often more precise than the NPS address-only records), plus Wikipedia article titles and Commons image filenames. CC BY-SA 4.0.
  • Merged AZ NRHP catalog: 1,602 distinct properties keyed by NRIS refnum. 1,128 with coordinates, 1,251 with Wikipedia articles, 959 with photographs. 113 records are present in all three sources. Drives the /property/[refnum] profile pages and the public map.
  • Federally Recognized Native Nations in Arizona: 28 polygons from the ADHS hosted ArcGIS service. Drives tribal-consultation triggers in the Section 106 workflow.
  • Arizona counties: 15 polygon features from the AZGeo Arizona_Counties FeatureServer.
  • Arizona state legislative districts (2022-): 30 polygons from the AZGeo State_of_Arizona_Legislative_Districts service.
  • Tucson historic districts: 45 polygons from the City of Tucson official ArcGIS service (HCD_DIST_HIST).
  • Tucson individually-listed historic properties: 98 records from the City of Tucson.
  • Tucson historic markers: 122 point features from the City of Tucson.
  • Phoenix historic properties: 1,138 polygons from the City of Phoenix ArcGIS FeatureServer.
  • NRIS-listed cemeteries (Arizona): 7 records derived from the merged catalog by category/name filter.
  • BLM Arizona Surface Management Agency: 18,025 polygons covering every parcel of land in Arizona with ownership category (BLM, USFS, NPS, Military, Indian Lands, State, Private, etc.). Geometry simplified with maxAllowableOffset=0.0015 (~150m) to keep file size manageable. Drives the jurisdiction page and joins 1,122 NRHP properties to their managing agency.
  • BLM National Monuments & Conservation Areas (Arizona): 9 polygons with full attribution.
  • NPS park unit boundaries (Arizona):22 named units (National Parks, Monuments, Historic Sites, etc.) from the NPS ArcGIS hosted mirror. Joins 67 NRHP properties to their parent park. (The USFS dedicated service returned HTTP 500 for any geometry query; USFS polygons are derived from BLM SMA CATEGORY='USFS' subset instead — 370 polygons.)
  • FEMA National Flood Hazard Layer — Arizona:42,724 flood hazard zone polygons from hazards.fema.gov, filtered by DFIRM_ID LIKE '04%'. Zones: 4,655 A / 16,950 AE / 1,859 AO / 538 AH (Special Flood Hazard Areas) plus 18,154 X (minimal risk), 568 D (undetermined). Joins 1,111 NRHP properties to a flood zone.
  • ADOT Historic and Scenic Routes:114 polyline features (71 historic, 43 scenic) including Route 66, Apache Trail, and the state's other legislatively designated scenic byways.
  • USGS GNIS placenames (Arizona): 27,837 named geographic features across 7 leaf layers of The National Map geonames service (landforms, streams, hydrographic, crossings, historical cultural/political, historical hydrographic, historical physical). Every geocoded NRHP property gets up to 5 nearby placenames.
  • Library of Congress HABS/HAER/HALS — Arizona: 653 items (Historic American Buildings/Engineering/Landscapes Surveys) from loc.gov. 258 have coordinates, 586 have thumbnails. 417 NRHP properties have token-match candidates.
  • NRHP nomination PDFs and photo PDFs: Linked directly to NPS NPGallery URLs from the ArcGIS points.
  • Certified Local Government city names: 22 real Arizona CLGs from the SHPO public roster.
  • Arizona Dude Ranch names: Publicly known working dude/guest ranches.
  • Statute and regulation language: NHPA (54 USC 300101-320303), Section 106 (36 CFR 800), ARS 41-861-864, ARS 41-503, ARS 41-867, ARS 41-511.04, ARS 41-1604, 26 USC §47.
  • Program volume figures: Drawn from the 2023 RFI (BPM005339) — 1,428 undertakings / 567 reports / 892 determinations (2022), 8,000+ SPT enrollees, 22 CLGs, 15 annual nominations, 691 cemeteries, ~800,000 inventory records, 37,000 digitized.
  • RFI questions and 2023 recommendation ($3.5M): From the RFI PDF and July 2023 SHOPP slide deck.
  • National Historic Landmarks (47):Parsed from Wikipedia’sList_of_National_Historic_Landmarks_in_Arizonavia the MediaWiki Action API; cross-referenced to NRIS by normalized name (35 matched). Drives the “NHL” pill on property profiles and the screening tool.
  • Wikidata (1,169 records): SPARQL pull of all items in Arizona (P131*=Q816) carrying NRHP refnum (P649). 251 with year built, 111 with architect, 331 with architectural style, 988 with Commons image, 599 with English Wikipedia article. Drives the architecture card on property pages.
  • USACE National Inventory of Dams (393 AZ dams): Filtered from the full national CSV. Used for Section 4(f) / safety screening — 40 NRHP properties have a dam within 1 km, with hazard classification.
  • FHWA National Bridge Inventory (8,573 AZ bridges): 2024 delimited file. 975 pre-1945 bridges flagged as Section 4(f) eligibility candidates; 357 NRHP properties have a pre-1945 bridge within 0.5 km.
  • HIFLD Cellular Towers (443 AZ): FCC ASR registry mirror. 98 NRHP properties have a cell tower within 1 km — visual-impact / Section 106 review triggers.
  • NPS NPGallery NRIS submission images (1,485 properties): Polite HTML scrape of /AssetDetail/NRIS/[refnum] for the first 1,602 properties; extracted lo-res image URLs.
  • OpenStreetMap historic features (2,332 in AZ): Overpass API pull ofhistoric=* tagged nodes/ways/relations within the Arizona admin boundary. Includes 1,400+ archaeological sites, 200 ruins, 200 memorials, plus monuments, milestones, Spanish colonial mission ruins, etc.
  • AZ State Parks (31): Visitor-center point features from the AZ State Parks ArcGIS service. 144 NRHP properties are within 3 km of a state park.
  • EPA Superfund / SEMS (184 AZ sites, 13 NPL):From the EPA FRS_INTERESTS hosted service (PGM_SYS_ACRNM='SEMS'). 580 NRHP properties have a Superfund site within 5 km. NPL-tier sites flagged for EPA Region 9 coordination.
  • U.S. Census Bureau Geocoder: Public address-to-coordinate service powering /locate. No API key required.
Synthetic

Synthetic, deterministically generated for demonstration

  • 300 active Review & Compliance projects clustered on real NRHP locations
  • ~1,960 correspondence log items (incoming + outgoing)
  • 8,000 State Property Tax reclassification enrollments, county-distributed by population weight
  • 20 Historic Tax Credit commercial projects
  • 15 NRHP nominations in pipeline phases
  • 12 SHPO staff roster entries
  • CLG coordinator contact names (names synthetic; city names real)
  • Heritage Fund grant cycle figures
  • Audit log entries

Synthetic data uses a deterministic PRNG (mulberry32, seed 0xa21af0) so every demo run is identical. Volumes are modeled on the RFI numbers.

Placeholder

Placeholder / intentionally not implemented in prototype

  • AZSITE (archaeological data): Confidential under AZ state law; shown as a blurred mock layer with integration placeholder.
  • Full IAHC cemetery inventory (691 items): The Arizona Memory Project site is behind a Cloudflare challenge that rejects non-browser requests. A full scrape would require a headful browser automation run. The prototype shows only the subset of cemeteries that are also NRHP-listed (7 items with real data).
  • E-signature: UI visible; not wired to DocuSign/Adobe Sign in prototype. Production integration pattern documented.
  • FedRAMP / AZ-RAMP compliance: Prototype runs on Vercel standard. Production path is AWS GovCloud + RDS PostGIS; described in the proposal.
  • FileMaker Pro migration: Out of scope for prototype. Field-mapping workbook is a Phase 0 deliverable in the proposed engagement.
  • Full 800,000-record inventory: Only the 1,602 NRHP-listed properties appear in the prototype. Production post-migration would include the survey inventory.

Reproducing the data

All loaders live in /scripts.

# Real public data — Phase 2 (NRHP + cities + tribal)
npx tsx scripts/load-nrhp.ts                # NPS ArcGIS NRHP points (AZ)
npx tsx scripts/load-nrhp-districts.ts      # NPS ArcGIS district polygons (AZ)
npx tsx scripts/load-nris-alldata.ts        # NPS NRIS All_Data XLSX (AZ filter)
npx tsx scripts/load-wikipedia-nrhp.ts      # Wikipedia MediaWiki API scrape
npx tsx scripts/load-arcgis-layers.ts       # Tribal lands, counties, leg. districts
npx tsx scripts/load-city-historic.ts       # Tucson + Phoenix city layers

# Real public data — Phase 3 (federal, environmental, archive)
npx tsx scripts/load-federal-jurisdiction.ts  # BLM SMA + NMNCA + NPS boundaries
npx tsx scripts/load-flood.ts                 # FEMA NFHL flood hazard zones (AZ)
npx tsx scripts/load-adot-historic.ts         # ADOT historic + scenic routes
npx tsx scripts/load-gnis.ts                  # USGS GNIS placenames (AZ subset)
npx tsx scripts/load-habs-haer.ts             # LoC HABS/HAER/HALS (AZ items)

# Merge + derive
npx tsx scripts/merge-properties.ts         # Joins all 3 NRHP sources by refnum
                                             # + point-in-polygon joins to BLM SMA,
                                             #   NPS, tribal, FEMA, GNIS, HABS, ADOT
npx tsx scripts/derive-cemeteries.ts        # Cemetery subset (NRHP-listed only)

# Synthetic workflow data
npx tsx scripts/seed-synthetic.ts