PROPPLY AI SYSTEM ARCHITECTURE

2 Netlify Functions • Supabase PostgreSQL • Claude AI • Socrata / CARTO Data Sources
API Functions
Database
External
2
API Functions
12
API Actions
38+
Cities Covered
10
State Registries
4
External Services
10+
DB Tables
Propply AI API Functions
🧠
Propply AI API
api-propply.js
Main API with 12 actions: requirements, location_services, coverage, equipment_lookup, interpret_notice, vote_suggestion, stats, suggestions, update_suggestion, update_requirement
GET POST PATCH API Key / JWT
📍
Compliance Local Intel
compliance-local-intel.js
Real-time city compliance data engine. 38+ cities via Socrata/CARTO/ArcGIS. Area-level, building-level, and state licensing queries.
GET Public
Supabase Database (PostgreSQL)
📋
compliance_service_map
Supabase table
Which compliance services are required where (state/metro, confidence, source type)
💡
compliance_suggestions
Supabase table
AI discoveries and user reports for admin review/merge into service map
🏷️
service_types
Supabase table
21 pre-populated service types across 3 categories (inspections, certifications, consulting)
🔑
api_subscriptions
Supabase table
Developer and partner API keys, tiers, usage counters, Stripe integration
🗺️
metro_areas
Supabase table
25 major US metros (reference data for service map joins)
External Services & Data Sources
🐘
Supabase / PostgreSQL
Primary database, Auth
10+ tables
🧠
Claude AI (Anthropic)
Notice interpretation (Vision),
compliance research
📊
Socrata Open Data
38+ city open data portals
Violations, permits, devices
🗺️
CARTO / ArcGIS
Philadelphia, other cities
Geospatial compliance data
💳
Stripe
Developer subscription
billing & payments

Key Data Flows

How the Propply AI components connect and share data

REQUIREMENTS
Developer → api-propply.js (requirements) → compliance_service_map → JSON response
EQUIPMENT
Developer → api-propply.js (equipment_lookup) → compliance-local-intel.js + Supabase (FL/TX/JRS)
LOCAL INTEL
Developer → compliance-local-intel.js → Socrata / CARTO APIs → Building-level response
NOTICE AI
Developer → api-propply.js (interpret_notice) → Claude Vision AI → Structured extraction
LEARNING
Users / AI → vote_suggestion → compliance_suggestions → Admin merges → compliance_service_map