USC CSCI 585 · Database Systems
CSCI 585 — Database Systems (USC, Spring 2023)
Two interactive demos from Yan Liu's CSCI 585. The Bay Area photo spatial demo plots 13 geotagged photos on a real map and runs convex-hull / k-NN queries client-side via turf.js. The YouTube SQL demo runs a 7-table relational schema on PGlite (real PostgreSQL compiled to WebAssembly), letting you execute the original 6 query exercises live in the browser.
Works
Loading embed…
13 geotagged photos around Fremont/Pleasanton on a maplibre-gl basemap. Toggle convex hull, click anywhere to find the 4 nearest photos, enable density to see a Gaussian kernel-density visualization. Same dataset as the original PostGIS HW3, computed client-side via turf.js.
sql postgresql pglite spatial postgis geospatial wasm