← back to Costa Rica
yolo tick 4: /provinces overview page (7 provinces, top-6 cantones each, drill links) + /api/provinces endpoint + nav links + sitemap entries
3d52097819e527317baa6932a9ccd66e208110a3 · 2026-05-08 09:23:18 -0700 · Steve
Files touched
A public/favicon.svgM public/index.htmlA public/provinces.htmlM server.js
Diff
commit 3d52097819e527317baa6932a9ccd66e208110a3
Author: Steve <steve@designerwallcoverings.com>
Date: Fri May 8 09:23:18 2026 -0700
yolo tick 4: /provinces overview page (7 provinces, top-6 cantones each, drill links) + /api/provinces endpoint + nav links + sitemap entries
---
public/favicon.svg | 6 ++++
public/index.html | 4 +++
public/provinces.html | 96 +++++++++++++++++++++++++++++++++++++++++++++++++++
server.js | 30 ++++++++++++++++
4 files changed, 136 insertions(+)
diff --git a/public/favicon.svg b/public/favicon.svg
new file mode 100644
index 0000000..7b57a2b
--- /dev/null
+++ b/public/favicon.svg
@@ -0,0 +1,6 @@
+<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64" width="64" height="64">
+ <rect width="64" height="64" rx="10" fill="#0a0a0a"/>
+ <text x="50%" y="50%" text-anchor="middle" dominant-baseline="central"
+ font-family="Georgia, 'Times New Roman', serif" font-weight="700"
+ font-size="32" fill="#ffffff">CO</text>
+</svg>
diff --git a/public/index.html b/public/index.html
index 128575e..f1e353b 100644
--- a/public/index.html
+++ b/public/index.html
@@ -1,6 +1,8 @@
<!doctype html>
<html lang="en" data-theme="light">
<head>
+ <link rel="icon" type="image/svg+xml" href="/favicon.svg">
+
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<title>Costa Rica Directory — tourism · rentals · local services</title>
@@ -75,6 +77,8 @@
<a href="#" data-cat="tourism">Tourism</a>
<a href="#" data-cat="rentals">Rentals</a>
<a href="#" data-cat="service">Local services</a>
+ <a href="/provinces">Provinces</a>
+ <a href="/stats">Stats</a>
</nav>
<div class="ml-auto" style="display:flex;gap:8px;align-items:center">
<span id="stat-total" class="badge">—</span>
diff --git a/public/provinces.html b/public/provinces.html
new file mode 100644
index 0000000..bdbe04b
--- /dev/null
+++ b/public/provinces.html
@@ -0,0 +1,96 @@
+<!doctype html>
+<html lang="en" data-theme="light">
+<head>
+ <meta charset="utf-8" />
+ <meta name="viewport" content="width=device-width, initial-scale=1" />
+ <title>The 7 Provinces — Costa Rica Directory</title>
+ <meta name="description" content="Browse Costa Rica businesses by province — San José, Alajuela, Heredia, Cartago, Guanacaste, Puntarenas, Limón." />
+ <script>(function(){try{var t=localStorage.getItem('cr-theme');if(t)document.documentElement.setAttribute('data-theme',t);}catch(e){}})();</script>
+ <style>
+ :root{--bg:#fafaf7;--fg:#0e1015;--muted:#5a6270;--line:#e3e0d6;--card:#fff;--card-line:#ebe7da;--accent:#0a7a3a;--accent-2:#c2a85a}
+ [data-theme="dark"]{--bg:#0e1015;--fg:#f3f1ea;--muted:#9aa3b2;--line:#23262d;--card:#15181f;--card-line:#262932;--accent:#3ec07a;--accent-2:#d8c074}
+ *{box-sizing:border-box}
+ body{margin:0;background:var(--bg);color:var(--fg);font-family:-apple-system,BlinkMacSystemFont,'Inter','Segoe UI',Roboto,sans-serif;line-height:1.55}
+ a{color:inherit;text-decoration:none} a:hover{color:var(--accent)}
+ .nav{position:sticky;top:0;z-index:30;background:color-mix(in srgb,var(--bg) 88%,transparent);backdrop-filter:saturate(160%) blur(10px);border-bottom:1px solid var(--line)}
+ .nav-in{max-width:1320px;margin:0 auto;padding:14px 22px;display:flex;align-items:center;gap:18px;flex-wrap:wrap}
+ .brand{font-weight:700;font-size:18px} .brand .pin{color:var(--accent)}
+ .nav-links{display:flex;gap:14px;flex-wrap:wrap;color:var(--muted);font-size:14px}
+ .nav-links a.active{color:var(--fg);font-weight:600}
+ .ml-auto{margin-left:auto} .icon-btn{appearance:none;background:transparent;color:inherit;border:1px solid var(--line);border-radius:999px;width:36px;height:36px;display:inline-flex;align-items:center;justify-content:center;cursor:pointer}
+
+ main{max-width:1320px;margin:0 auto;padding:32px 22px 40px}
+ .head{display:flex;flex-wrap:wrap;align-items:end;gap:14px;margin-bottom:18px}
+ .head h1{margin:0;font-size:clamp(32px,4.5vw,48px);letter-spacing:-.02em;line-height:1.05}
+ .head .lead{color:var(--muted);max-width:680px}
+ .grid{display:grid;grid-template-columns:repeat(auto-fill,minmax(380px,1fr));gap:18px}
+ .pcard{background:var(--card);border:1px solid var(--card-line);border-radius:18px;overflow:hidden;display:flex;flex-direction:column;transition:transform .15s ease,box-shadow .15s ease}
+ .pcard:hover{transform:translateY(-2px);box-shadow:0 12px 28px rgba(0,0,0,.08)}
+ .ptop{display:flex;align-items:flex-start;justify-content:space-between;padding:18px 18px 0;gap:12px}
+ .pname{font-size:24px;font-weight:800;letter-spacing:-.01em;margin:0}
+ .ptotal{font-size:14px;color:var(--muted);margin:2px 0 0}
+ .pbadge{font-size:11px;text-transform:uppercase;letter-spacing:.08em;color:var(--accent);background:color-mix(in srgb,var(--accent) 12%,transparent);padding:4px 10px;border-radius:999px;flex:0 0 auto}
+ .prgs{padding:14px 18px 18px;display:grid;grid-template-columns:repeat(2,1fr);gap:6px}
+ .prg{display:flex;align-items:center;gap:10px;padding:8px;border-radius:10px;border:1px solid transparent;font-size:14px}
+ .prg:hover{border-color:var(--line);background:color-mix(in srgb,var(--bg) 60%,var(--card))}
+ .prg img{width:38px;height:38px;border-radius:8px;object-fit:cover;background:color-mix(in srgb,var(--accent) 14%,transparent)}
+ .prg .nm{font-weight:600;line-height:1.2}
+ .prg .ct{color:var(--muted);font-size:12px}
+ .pmore{margin-top:8px;padding:0 18px 18px;font-size:13px;color:var(--muted)}
+ .pmore a{color:var(--accent);font-weight:600}
+ .skel{height:280px;background:linear-gradient(110deg,var(--card) 8%,var(--bg) 18%,var(--card) 33%);background-size:200% 100%;animation:s 1.6s linear infinite;border-radius:18px}
+ @keyframes s{0%{background-position:200% 0}100%{background-position:-200% 0}}
+ </style>
+</head>
+<body>
+ <header class="nav"><div class="nav-in">
+ <a class="brand" href="/"><span class="pin">●</span> Costa Rica Directory</a>
+ <nav class="nav-links">
+ <a href="/">Browse</a>
+ <a href="/provinces" class="active">Provinces</a>
+ <a href="/stats">Stats</a>
+ </nav>
+ <div class="ml-auto"><button class="icon-btn" id="themeBtn" aria-label="Theme">◐</button></div>
+ </div></header>
+
+ <main>
+ <div class="head">
+ <h1>The 7 Provinces of Costa Rica</h1>
+ </div>
+ <p class="lead" style="color:var(--muted);max-width:760px;margin:0 0 22px">Costa Rica is divided into seven provinces. Pick one to drill into its top cantones — listings sorted by depth of coverage.</p>
+ <div class="grid" id="grid">
+ <div class="skel"></div><div class="skel"></div><div class="skel"></div><div class="skel"></div>
+ </div>
+ </main>
+
+ <script>
+ const themeBtn=document.getElementById('themeBtn');
+ themeBtn.addEventListener('click',()=>{const cur=document.documentElement.getAttribute('data-theme')||'light';const nx=cur==='light'?'dark':'light';document.documentElement.setAttribute('data-theme',nx);try{localStorage.setItem('cr-theme',nx);}catch{}});
+
+ const PROV_ORDER=['San José','Alajuela','Heredia','Cartago','Guanacaste','Puntarenas','Limón'];
+ fetch('/api/provinces').then(r=>r.json()).then(d=>{
+ const grid=document.getElementById('grid');
+ const map=new Map((d.provinces||[]).map(p=>[p.province,p]));
+ const ordered=PROV_ORDER.map(n=>map.get(n)).filter(Boolean);
+ // any provinces not in the canonical list (shouldn't happen but safe)
+ for(const p of (d.provinces||[])) if(!PROV_ORDER.includes(p.province)) ordered.push(p);
+ if(!ordered.length){grid.innerHTML='<p style="color:var(--muted);grid-column:1/-1">No data yet.</p>';return;}
+ grid.innerHTML=ordered.map(p=>{
+ const tops=(p.top_regions||[]).filter(r=>r&&r.slug);
+ const list=tops.map(r=>`<a class="prg" href="/r/${r.slug}">
+ <img loading="lazy" alt="" src="${r.image_url||''}" onerror="this.style.visibility='hidden'"/>
+ <span><span class="nm">${r.name}</span><br/><span class="ct">${(r.n||0).toLocaleString()} listings</span></span>
+ </a>`).join('');
+ return `<article class="pcard">
+ <div class="ptop">
+ <div><h2 class="pname">${p.province}</h2><p class="ptotal">${(p.total_places||0).toLocaleString()} total listings</p></div>
+ <span class="pbadge">Provincia</span>
+ </div>
+ <div class="prgs">${list||'<span style="color:var(--muted);font-size:13px;padding:8px">no listings yet</span>'}</div>
+ <div class="pmore"><a href="/?q=${encodeURIComponent(p.province)}">Browse all ${p.province} listings →</a></div>
+ </article>`;
+ }).join('');
+ }).catch(e=>{document.getElementById('grid').innerHTML='<p style="color:var(--muted);grid-column:1/-1">Could not load provinces: '+e.message+'</p>';});
+ </script>
+</body>
+</html>
diff --git a/server.js b/server.js
index ddeca29..b9dc982 100644
--- a/server.js
+++ b/server.js
@@ -58,6 +58,33 @@ function sortClause(sort) {
}
}
+app.get('/api/provinces', async (_req, res) => {
+ try {
+ const { rows } = await pool.query(`
+ WITH province_totals AS (
+ SELECT r.province AS name, COUNT(p.id)::int AS total_places
+ FROM regions r LEFT JOIN places p ON p.region_id = r.id AND p.status='active'
+ GROUP BY r.province
+ ),
+ top_regions AS (
+ SELECT r.province, r.slug, r.name AS region_name, r.image_url,
+ COUNT(p.id)::int AS n,
+ ROW_NUMBER() OVER (PARTITION BY r.province ORDER BY COUNT(p.id) DESC, r.name ASC) AS rk
+ FROM regions r LEFT JOIN places p ON p.region_id = r.id AND p.status='active'
+ GROUP BY r.id
+ )
+ SELECT pt.name AS province, pt.total_places,
+ json_agg(json_build_object('slug', tr.slug, 'name', tr.region_name, 'image_url', tr.image_url, 'n', tr.n)
+ ORDER BY tr.rk) FILTER (WHERE tr.rk <= 6) AS top_regions
+ FROM province_totals pt
+ LEFT JOIN top_regions tr ON tr.province = pt.name
+ WHERE pt.name IS NOT NULL
+ GROUP BY pt.name, pt.total_places
+ ORDER BY pt.total_places DESC, pt.name ASC`);
+ res.json({ provinces: rows });
+ } catch (e) { res.status(500).json({ error: e.message }); }
+});
+
app.get('/api/regions', async (_req, res) => {
try {
const { rows } = await pool.query(`
@@ -268,6 +295,8 @@ app.get('/sitemap.xml', async (_req, res, next) => {
const staticPages = [
{ loc: '/', changefreq: 'daily', priority: '1.0' },
+ { loc: '/provinces', changefreq: 'weekly', priority: '0.8' },
+ { loc: '/stats', changefreq: 'weekly', priority: '0.5' },
{ loc: '/?category=tourism', changefreq: 'daily', priority: '0.8' },
{ loc: '/?category=rentals', changefreq: 'daily', priority: '0.8' },
{ loc: '/?category=service', changefreq: 'daily', priority: '0.8' },
@@ -388,6 +417,7 @@ app.get('/p/:slug', async (req, res) => {
});
app.get('/stats', (_req, res) => res.sendFile(path.join(__dirname, 'public', 'stats.html')));
+app.get('/provinces', (_req, res) => res.sendFile(path.join(__dirname, 'public', 'provinces.html')));
app.use(express.static(path.join(__dirname, 'public')));
← 4cbc62e tick 4 wip: Hacienda (CR MoF) enricher + migration (HACIENDA
·
back to Costa Rica
·
tick 4 log + hacienda smoke-test instructions for Steve 2a62e9f →