Location Intelligence

// bootstrap loader — one script tag, then importLibrary per need
(g=>{ /* official inline bootstrap */ })({
  key: "WF_MAPS_JS_KEY",          // domain-restricted, browser key
  v: "weekly"
});

const { Map }               = await google.maps.importLibrary("maps");
const { AdvancedMarkerElement } = await google.maps.importLibrary("marker");

const map = new Map(document.getElementById("map"), {
  center: { lat: 39.2511, lng: -94.6316 },   // 8630 N Green Hills Rd
  zoom: 15,
  mapId: "WF_LI_DARK",      // cloud-styled map → tokens.json palette mapped in console
  tilt: 0, heading: 0
});

new AdvancedMarkerElement({ map, position: map.getCenter(),
  content: buildPin({ label: "8630", color: "#1db954" }) });

POST https://places.googleapis.com/v1/places:searchNearby
Content-Type: application/json
X-Goog-Api-Key: {SERVER_KEY}
X-Goog-FieldMask: places.id,places.displayName,places.types,places.location,
                  places.rating,places.userRatingCount,places.businessStatus

{
  "includedTypes": ["doctor","dentist","physiotherapist","chiropractor","pharmacy"],
  "maxResultCount": 20,
  "locationRestriction": { "circle": {
      "center": { "latitude": 39.2511, "longitude": -94.6316 },
      "radius": 4828.0   // 3 mi in meters — outer study ring
  }},
  "rankPreference": "DISTANCE"
}

POST https://places.googleapis.com/v1/places:searchText
X-Goog-FieldMask: places.id,places.displayName,places.types,places.location,places.rating

{
  "textQuery": "med spa near Tiffany Springs Kansas City MO",
  "locationBias": { "circle": {
      "center": { "latitude": 39.2511, "longitude": -94.6316 },
      "radius": 3218.0 }},          // 2 mi competitive ring
  "maxResultCount": 20
}

// probe battery: "med spa", "urgent care", "walk-in clinic", "title company",
// "tutoring center", "compounding pharmacy", "imaging center", "coworking"

GET https://places.googleapis.com/v1/places/{PLACE_ID}
X-Goog-Api-Key: {SERVER_KEY}
X-Goog-FieldMask: id,displayName,nationalPhoneNumber,websiteUri,regularOpeningHours,
                  rating,userRatingCount,priceLevel,businessStatus,googleMapsUri

POST https://areainsights.googleapis.com/v1:computeInsights

{
  "insights": ["INSIGHT_COUNT"],
  "filter": {
    "locationFilter": { "circle": {
        "latLng": { "latitude": 39.2511, "longitude": -94.6316 },
        "radius": 4828 }},
    "typeFilter": { "includedTypes": ["doctor"] },
    "operatingStatus": ["OPERATING_STATUS_OPERATIONAL"]
  }
}

GET https://maps.googleapis.com/maps/api/geocode/json
    ?address=8630%20N%20Green%20Hills%20Rd%2C%20Kansas%20City%2C%20MO%2064154
    &key={SERVER_KEY}

// → 39.2511, -94.6316 · plus_code 87F4+XW · stored once in li_runs, reused everywhere

// 1) free metadata check — never render a "no imagery" tile
GET https://maps.googleapis.com/maps/api/streetview/metadata
    ?location=39.2511,-94.6316&key={SERVER_KEY}

// 2) four headings, matches the mock strip in §01
GET https://maps.googleapis.com/maps/api/streetview
    ?size=640x400&location=39.2511,-94.6316
    &fov=80&pitch=0&heading=235&key={SERVER_KEY}     // SW · building face
// heading=000 N Green Hills north · 090 toward I-29 · 180 toward NW Barry

GET https://tile.googleapis.com/v1/3dtiles/root.json?key={SERVER_KEY}
// consumed by CesiumJS / deck.gl Tiles3DLoader — massing + roof context
// session-token flow per tile fetch; render clipped to the 1-mi ring to cap tile spend

POST https://routes.googleapis.com/distanceMatrix/v2:computeRouteMatrix
X-Goog-FieldMask: originIndex,destinationIndex,duration,distanceMeters,condition

{
  "origins": [{ "waypoint": { "location": { "latLng": {
      "latitude": 39.2511, "longitude": -94.6316 }}}}],
  "destinations": [
    { "waypoint": { "placeId": "ChIJ..KCI" }},
    { "waypoint": { "placeId": "ChIJ..ZonaRosa" }},
    { "waypoint": { "placeId": "ChIJ..StLukesN" }},
    { "waypoint": { "placeId": "ChIJ..DowntownKC" }}
  ],
  "travelMode": "DRIVE",
  "routingPreference": "TRAFFIC_AWARE",
  "departureTime": "2026-07-15T13:30:00Z"   // weekday 08:30 CT
}

GET https://roads.googleapis.com/v1/snapToRoads
    ?path=39.2515,-94.6316|39.2507,-94.6316&interpolate=true&key={SERVER_KEY}
// → placeId per road segment → joined to MoDOT TMS station AADT in li_traffic_counts

GET https://solar.googleapis.com/v1/buildingInsights:findClosest
    ?location.latitude=39.2511&location.longitude=-94.6316&key={SERVER_KEY}
// → maxArrayAreaMeters2, yearlyEnergyDcKwh — investor memo opex-reduction line

POST https://airquality.googleapis.com/v1/currentConditions:lookup
{ "location": { "latitude": 39.2511, "longitude": -94.6316 } }

POST https://aerialview.googleapis.com/v1/videos:renderVideo
{ "address": "8630 N Green Hills Rd, Kansas City, MO 64154" }
// poll videos:lookupVideo until ACTIVE → mp4 URIs for LinkedIn ad unit

POST https://addressvalidation.googleapis.com/v1:validateAddress
{ "address": { "regionCode": "US", "addressLines": ["8630 N Green Hills Rd, Kansas City MO 64154"] },
  "enableUspsCass": true }

-- category density inside the 3-mi study circle vs KC-North benchmark circle
WITH study AS (
  SELECT COUNT(*) n, 'study' ring
  FROM `places_insights___us.places`
  WHERE 'doctor' IN UNNEST(types)
    AND ST_DWITHIN(point, ST_GEOGPOINT(-94.6316, 39.2511), 4828)
), bench AS (
  SELECT COUNT(*) n, 'bench' ring
  FROM `places_insights___us.places`
  WHERE 'doctor' IN UNNEST(types)
    AND ST_DWITHIN(point, ST_GEOGPOINT(-94.6096, 39.2154), 4828)  -- KC-North centroid
)
SELECT * FROM study UNION ALL SELECT * FROM bench;

create table li_runs (
  id text primary key,                 -- 'LI-1616772-0714'
  property_id bigint not null,        -- 1616772
  centroid geography(Point,4326), run_at timestamptz default now(),
  config jsonb                        -- frozen scoring_config.json snapshot
);
create table li_pois (
  id text primary key, run_id text references li_runs,
  place_id text, name text, cat text, types text[],
  loc geography(Point,4326), dist_mi numeric, ring text,
  rating numeric, reviews int, src text default 'places'   -- 'places' | 'parcel'
);
create index on li_pois using gist(loc);
create table li_use_cases        (id text primary key, label text, grp text, gate numeric);
create table li_use_case_scores  (run_id text, uc_id text,
  dg int, df int, tv int, cs int, cp int, zb int, pa int, cm int,
  lus numeric generated always as (/* §04 formula in SQL */) stored,
  primary key(run_id, uc_id));
create table li_demographics     (run_id text, radius_mi int, pop int, hh int,
  hhi numeric, med_age numeric, growth numeric, pct_65 numeric);
create table li_traffic_counts   (run_id text, segment text, aadt_lo int, aadt_hi int,
  source text, is_estimate boolean, road_place_id text);
create table li_assets_streetview(run_id text, heading int, pano_id text,
  captured_on date, storage_url text);
create table li_prospect_matches (run_id text, prospect text, uc_id text,
  prospect_score int, tb numeric, msg_cell text);
-- RLS: enable on all; policy = auth.jwt() ->> 'org' = 'windfield'

{
  "version": "lus-1.0",
  "weights": { "dg": 0.22, "zb": 0.15, "df": 0.15, "tv": 0.12,
               "cs": 0.12, "cp": 0.12, "pa": 0.06, "cm": 0.06 },
  "gates": { "as_of_right": 1.00, "conditional": 0.85, "conversion": 0.80,
             "assembly": 0.75, "unverified": 0.62 },
  "tiers": { "A": [80,100], "B": [60,79], "C": [40,59], "D": [20,39] },
  "tb_blend": { "prospect": 0.6, "lus": 0.4 },
  "rings_mi": [0.5, 1, 3], "competitive_ring_mi": 2
}

GET https://{project}.functions.supabase.co/li-run?property=1616772
Accept: text/event-stream

// NDJSON events — exactly what the §00 console renders:
data: {"t":"stage", "id":"sweep", "n":2, "of":7}
data: {"t":"call", "api":"places:searchNearby", "cat":"medical", "rows":12, "ms":284}
data: {"t":"gap",  "probe":"med spa", "rows":0, "ring_mi":2}
data: {"t":"score", "uc":"profsvc", "lus":86.4, "tier":"A"}
data: {"t":"done", "run":"LI-1616772-0714-r2", "dur_s":9.8}

// row inserts fan out on Realtime — the page patches map / census / rankings:
supabase.channel('li:1616772')
  .on('postgres_changes', { event: 'INSERT', table: 'li_pois' }, patchMap)
  .on('postgres_changes', { event: 'INSERT', table: 'li_use_case_scores' }, patchRanks)
  .subscribe();

// automations — same function on a schedule, or fired by webhooks:
select cron.schedule('li-nightly', '0 6 * * *', $$ select net.http_post(edge_url) $$);