60,049
Index PostGIS Anchors
GCP Cloud SQL (last-meter tenant)
53,618
Sub-Building Interface Points
Park, Drop & Access (AWS S3)
72,731
Building-Location Graph Edges
Curb-to-Door M:N Links + 943 Spaces
5,802
Scored Dashboard Buildings
5,693 map-dev + 56 master + 53 Heba
22,261
Geocoded Service Events
4 Google MyMaps KML Datasets
79
Archived Sheet & Doc Feeds
70 HTML Sheets + 4 XLSX + 3 PDFs + 2 TXT
1. Where All Data Is Stored & How It Is Organized (The 4 Data Pillars)
Every dataset recovered from GCP Cloud SQL, AWS S3 (s3://lastmeter-data), Google Drive JSONP/XLSX feeds, Google MyMaps KML layers, and Webflow API tokens is consolidated under /Users/jmanooch/Documents/Code/b2/lastmeter/data/ and exposed via live JSON/GeoJSON APIs.
2. Closing the Building Envelope Blindspot: 6-Zone Curb-to-Cupboard PostGIS Architecture
Reconciles the exterior municipal datasets with the recovered 2022 sub-building spatial graph (building.csv, location.csv, space.csv, security.csv) and MSheetsAO building scores inside a dedicated lastmeter schema in PostGIS.
Zone 1lastmeter.building_interface_points (point_type = PARK)
Curb & Park Interface
Recovered Source: 18,412 Park points (AWS S3 location.csv) + 5,693 Park lvl# scores (map-dev)
Key Attributes: Distance to loading bay (m), max vehicle class (van/rigid truck/cargo bike), curb regulation window, Park lvl# (1–10)
Zone 2lastmeter.building_interface_points (ACCESS/DROP) + lastmeter.building_security_systems
Threshold & Access Control
Recovered Source: 35,206 Access/Drop points + 5,721 Security records (Aptus, Axema, RCO, Dinbox, Portkod)
Key Attributes: Clear door width (mm), step/ramp gradient, lock vendor, unattended digital access readiness, Entry lvl# (1–10)
Zone 3lastmeter.building_spaces (space_type = SERVICEPOINT | LOBBY)
Lobby & Servicepoint™ Envelope
Recovered Source: 943 Interior spaces (AWS S3 space.csv) + DP # and DP m² in map-master / heba-dev
Key Attributes: Delivery Point count (DP #), floor area (DP m²), staging clearance, power/network availability, Store lvl# (1–10)
Zone 4lastmeter.building_traversal_edges
Horizontal & Vertical Circulation
Recovered Source: 72,731 Building-Location graph edges (AWS S3 building_location.csv) + IX SCORE (map-dev)
Key Attributes: Corridor width, elevator cabin dimensions (L×W×H), kg payload, floor-to-floor traversal time (sec), IX SCORE (1–10)
Zone 5lastmeter.building_spaces (space_type = CUPBOARD | LOCKER)
Cupboard, Cold-Chain & Circular Return
Recovered Source: SP # and SP m³ in map-master / heba-dev + Station 1901 Space Engine sizing models
Key Attributes: Servicepoint™ cubic volume (SP m³), modular locker bays, chilled/frozen compartments, circular return bins, Design lvl# (1–10)
Zone 6lastmeter.service_events
Unit Threshold & Live Telemetry
Recovered Source: 22,261 Geocoded service actions (4 MyMaps KMLs) + 21-tab BASE2_DASH_DEV.xlsx weekly flows
Key Attributes: Weekly deliveries/cleaning/tech/mobility events (v25–v34), dwell time, CO₂ & noise reduction, LMV INDEX & IoT INDEX (1–10)
3. Live Recovered Building Dataset Explorer (map-dev · map-master · heba-dev)
Querying live records parsed from recovered MSheetsAO JSONP feeds (
/api/v1/index-bridge/buildings)| Address | Owner | Resi Units | Park lvl# (Z1) | Entry lvl# (Z2) | Store lvl# (Z3) | IX SCORE (Z4) | Design lvl# (Z5) | IoT INDEX (Z6) | UV SCORE | LMV INDEX | Lat / Lng |
|---|
4. Archived Google Sheet Dashboard Feeds Inspector (70 HTML Tables)
Directly inspect the original Google Sheets HTML tables archived from RE-DASH, HS-DASH, Weekly Landlord Pages & Promo Pages