Which of your locations sit in a forecast county?

import csv, os, requests

URL = os.environ.get("TRUEFIXR_URL", "https://data.truefixr.com/v1/portfolio/risk")
KEY = os.environ["TRUEFIXR_API_KEY"]
BATCH = 500  # max locations per call

with open("properties.csv", newline="") as f:  # columns: id,lat,lon
    rows = list(csv.DictReader(f))

out = []
for i in range(0, len(rows), BATCH):
    chunk = rows[i:i + BATCH]
    r = requests.post(
        URL,
        headers={"Authorization": f"Bearer {KEY}"},
        json={
            "locations": [{"lat": float(p["lat"]), "lon": float(p["lon"]), "label": p["id"]} for p in chunk],
            "window": "24h",
        },
        timeout=120,
    )
    r.raise_for_status()  # a 402 here means the balance cannot cover this batch
    results = r.json()["results"]
    assert len(results) == len(chunk), "expected one result per location"
    for p, res in zip(chunk, results):
        out.append({"id": p["id"], "lat": p["lat"], "lon": p["lon"],
                    "county": res.get("county"), "state": res.get("state"), "grade": res.get("grade")})
    print(f"batch {i // BATCH + 1}: {len(chunk)} locations scored")

with open("results.csv", "w", newline="") as f:
    w = csv.DictWriter(f, fieldnames=["id", "lat", "lon", "county", "state", "grade"])
    w.writeheader()
    w.writerows(out)
print(f"wrote results.csv, {len(out)} rows")

import { readFileSync, writeFileSync } from "node:fs";

const URL = process.env.TRUEFIXR_URL || "https://data.truefixr.com/v1/portfolio/risk";
const KEY = process.env.TRUEFIXR_API_KEY;
const BATCH = 500; // max locations per call

// columns: id,lat,lon (no quoted commas)
const [head, ...lines] = readFileSync("properties.csv", "utf8").trim().split(/\r?\n/);
const cols = head.split(",");
const rows = lines.map((l) => Object.fromEntries(l.split(",").map((v, i) => [cols[i], v])));

const out = ["id,lat,lon,county,state,grade"];
for (let i = 0; i < rows.length; i += BATCH) {
  const chunk = rows.slice(i, i + BATCH);
  const r = await fetch(URL, {
    method: "POST",
    headers: { Authorization: `Bearer ${KEY}`, "Content-Type": "application/json" },
    body: JSON.stringify({
      locations: chunk.map((p) => ({ lat: +p.lat, lon: +p.lon, label: p.id })),
      window: "24h",
    }),
  });
  if (!r.ok) throw new Error(`HTTP ${r.status}: ${await r.text()}`); // 402 = balance cannot cover this batch
  const { results } = await r.json();
  if (results.length !== chunk.length) throw new Error("expected one result per location");
  chunk.forEach((p, j) => {
    const x = results[j];
    out.push([p.id, p.lat, p.lon, x.county, x.state, x.grade].join(","));
  });
  console.log(`batch ${i / BATCH + 1}: ${chunk.length} locations scored`);
}
writeFileSync("results.csv", out.join("\n") + "\n");
console.log(`wrote results.csv, ${out.length - 1} rows`);