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