Click pins on the map or select neighborhood buttons below to pan and explore.
WHAT'S HAPPENING
BUY BLACK. BUILD COMMUNITY.
YOUR PHILLY LIST
COMMUNITY SUBMISSION
NOT CONFIGURED
Paste your project URL and public anon key below. They are stored only in this browser. The page will then load approved listings and submit new listings for review.
create table public.listings (
id bigint generated by default as identity primary key,
type text not null check (type in ('event','business')),
title text not null, category text not null, neighborhood text not null,
address text not null, description text not null, image text,
event_date date, lat double precision default 39.9526,
lng double precision default -75.1652, approved boolean default false,
created_at timestamptz default now()
);
alter table public.listings enable row level security;
create policy "read approved listings" on public.listings for select using (approved = true);
create policy "submit listings" on public.listings for insert with check (approved = false);