← back to Costa Rica
yolo tick 5: /pr/:slug province detail page with all cantones, top verticals, featured listings + /api/provinces/:slug + sitemap entries; provinces overview now drills into province detail
e8ab7d3ae65def8824a90a5f3bf9f01c9c1fcf3f · 2026-05-08 10:06:23 -0700 · Steve
Files touched
A public/province.htmlM public/provinces.htmlM server.js
Diff
commit e8ab7d3ae65def8824a90a5f3bf9f01c9c1fcf3f
Author: Steve <steve@designerwallcoverings.com>
Date: Fri May 8 10:06:23 2026 -0700
yolo tick 5: /pr/:slug province detail page with all cantones, top verticals, featured listings + /api/provinces/:slug + sitemap entries; provinces overview now drills into province detail
---
public/province.html | 144 ++++++++++++++++++++++++++++++++++++++++++++++++++
public/provinces.html | 14 +++--
server.js | 64 ++++++++++++++++++++++
3 files changed, 217 insertions(+), 5 deletions(-)
diff --git a/public/province.html b/public/province.html
new file mode 100644
index 0000000..5952a99
--- /dev/null
+++ b/public/province.html
@@ -0,0 +1,144 @@
+<!doctype html>
+<html lang="en" data-theme="light">
+<head>
+ <meta charset="utf-8" />
+ <meta name="viewport" content="width=device-width, initial-scale=1" />
+ <title>Loading… — Costa Rica Directory</title>
+ <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;--cols:4}
+ [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}
+
+ .crumbs{max-width:1320px;margin:0 auto;padding:14px 22px 0;color:var(--muted);font-size:13px}
+ .crumbs a{color:var(--accent);font-weight:600}
+ main{max-width:1320px;margin:0 auto;padding:18px 22px 40px}
+ .head{display:flex;flex-wrap:wrap;align-items:flex-end;justify-content:space-between;gap:14px;margin-bottom:8px}
+ .head h1{margin:0;font-size:clamp(36px,5.5vw,60px);letter-spacing:-.02em;line-height:1.05}
+ .head .meta{color:var(--muted);font-size:14px}
+ .strip{display:flex;flex-wrap:wrap;gap:10px;margin:14px 0 22px}
+ .pill{font-size:12px;color:var(--muted);background:var(--card);border:1px solid var(--card-line);border-radius:999px;padding:6px 12px}
+ .pill b{color:var(--fg);font-weight:700}
+
+ .cols{display:grid;grid-template-columns:1.3fr 1fr;gap:22px}
+ @media (max-width:980px){.cols{grid-template-columns:1fr}}
+ .panel{background:var(--card);border:1px solid var(--card-line);border-radius:14px;padding:18px}
+ .panel h2{margin:0 0 12px;font-size:18px;letter-spacing:-.01em}
+
+ .canton-grid{display:grid;grid-template-columns:repeat(auto-fill,minmax(220px,1fr));gap:12px}
+ .canton{background:var(--bg);border:1px solid var(--line);border-radius:12px;overflow:hidden;display:flex;flex-direction:column;transition:transform .15s ease,box-shadow .15s ease}
+ .canton:hover{transform:translateY(-2px);box-shadow:0 10px 22px rgba(0,0,0,.06)}
+ .canton .img{width:100%;aspect-ratio:16/9;background:linear-gradient(135deg, color-mix(in srgb, var(--accent) 30%, var(--card)), color-mix(in srgb, var(--accent-2) 25%, var(--card)));position:relative;overflow:hidden}
+ .canton .img img{width:100%;height:100%;object-fit:cover;display:block}
+ .canton .body{padding:10px 12px}
+ .canton .nm{font-weight:700;line-height:1.2}
+ .canton .ct{color:var(--muted);font-size:12px;margin-top:2px}
+ .canton .empty .img{opacity:.65}
+
+ .vert ul{margin:0;padding:0;list-style:none}
+ .vert li{display:flex;align-items:center;justify-content:space-between;padding:8px 4px;border-bottom:1px dashed var(--line);font-size:14px}
+ .vert li:last-child{border-bottom:0}
+ .vert .num{font-variant-numeric:tabular-nums;color:var(--muted)}
+
+ .samples{display:grid;grid-template-columns:repeat(auto-fill,minmax(180px,1fr));gap:10px;margin-top:8px}
+ .sample{background:var(--bg);border:1px solid var(--line);border-radius:10px;overflow:hidden}
+ .sample .si{aspect-ratio:1.4/1;background:linear-gradient(135deg,#ddd,#aaa)}
+ .sample .si img{width:100%;height:100%;object-fit:cover;display:block}
+ .sample .sb{padding:8px 10px;font-size:13px}
+ .sample .sn{font-weight:600;line-height:1.2}
+ .sample .sa{color:var(--muted);font-size:11px;margin-top:2px}
+
+ .skel{height:200px;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:14px}
+ @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>
+
+ <div class="crumbs"><a href="/provinces">Provinces</a> › <span id="bcurr">…</span></div>
+
+ <main id="main">
+ <div class="head"><h1 id="title">Loading…</h1></div>
+ <div class="skel"></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 slug=location.pathname.split('/').filter(Boolean)[1];
+ document.title='Costa Rica Directory';
+
+ fetch('/api/provinces/'+encodeURIComponent(slug)).then(r=>r.json()).then(p=>{
+ if(p.error){document.getElementById('main').innerHTML=`<p style="color:var(--muted)">${p.error}</p>`;return;}
+ document.title=`${p.name} — Costa Rica Directory`;
+ document.getElementById('bcurr').textContent=p.name;
+
+ const totalCantones=p.cantones.length;
+ const cantonesWithListings=p.cantones.filter(c=>c.n>0).length;
+ const topVerts=(p.by_vertical||[]).slice(0,5);
+
+ const cantonHtml=p.cantones.map(c=>`
+ <a class="canton ${c.n===0?'empty':''}" href="/r/${c.slug}">
+ <div class="img">${c.image_url?`<img loading="lazy" alt="${c.name}" src="${c.image_url}" />`:''}</div>
+ <div class="body"><div class="nm">${c.name}</div><div class="ct">${(c.n||0).toLocaleString()} listings</div></div>
+ </a>`).join('');
+
+ const vertHtml=`<ul>${topVerts.map(v=>`<li><span>${v.vertical}</span><span class="num">${v.n.toLocaleString()}</span></li>`).join('')||'<li style="color:var(--muted)">none</li>'}</ul>`;
+
+ const sampleHtml=(p.samples||[]).map(s=>`
+ <a class="sample" href="/p/${s.slug}">
+ <div class="si">${s.image_url?`<img loading="lazy" alt="${s.name}" src="${s.image_url}" />`:s.region_image_url?`<img loading="lazy" alt="${s.region_name}" src="${s.region_image_url}" />`:''}</div>
+ <div class="sb"><div class="sn">${s.name}</div><div class="sa">${s.region_name||''}${s.address?' · '+s.address.slice(0,40):''}</div></div>
+ </a>`).join('');
+
+ document.getElementById('main').innerHTML=`
+ <div class="head">
+ <div>
+ <h1 id="title">${p.name}</h1>
+ <div class="meta">Provincia · ${p.total.toLocaleString()} listings across ${cantonesWithListings} of ${totalCantones} cantones</div>
+ </div>
+ <div><a href="/?q=${encodeURIComponent(p.name)}" style="color:var(--accent);font-weight:600">Browse all listings →</a></div>
+ </div>
+ <div class="strip">
+ <span class="pill"><b>${p.total.toLocaleString()}</b> listings</span>
+ <span class="pill"><b>${totalCantones}</b> cantones</span>
+ <span class="pill"><b>${cantonesWithListings}</b> with coverage</span>
+ <span class="pill"><b>${(p.by_vertical||[]).length}</b> verticals</span>
+ </div>
+ <div class="cols">
+ <section class="panel">
+ <h2>All cantones</h2>
+ <div class="canton-grid">${cantonHtml}</div>
+ </section>
+ <aside style="display:flex;flex-direction:column;gap:18px">
+ <section class="panel vert">
+ <h2>Top verticals</h2>
+ ${vertHtml}
+ </section>
+ <section class="panel">
+ <h2>Featured listings</h2>
+ <div class="samples">${sampleHtml||'<span style="color:var(--muted);font-size:13px">no listings yet</span>'}</div>
+ </section>
+ </aside>
+ </div>`;
+ }).catch(e=>{document.getElementById('main').innerHTML=`<p style="color:var(--muted)">Could not load: ${e.message}</p>`;});
+ </script>
+</body>
+</html>
diff --git a/public/provinces.html b/public/provinces.html
index bdbe04b..e32f24b 100644
--- a/public/provinces.html
+++ b/public/provinces.html
@@ -75,19 +75,23 @@
// 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;}
+ const SLUGIFY={'San José':'san-jose','Alajuela':'alajuela','Heredia':'heredia','Cartago':'cartago','Guanacaste':'guanacaste','Puntarenas':'puntarenas','Limón':'limon'};
grid.innerHTML=ordered.map(p=>{
const tops=(p.top_regions||[]).filter(r=>r&&r.slug);
+ const provSlug=SLUGIFY[p.province]||p.province.toLowerCase().replace(/\s+/g,'-');
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>
+ <a href="/pr/${provSlug}" style="display:block">
+ <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>
+ </a>
<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>
+ <div class="pmore"><a href="/pr/${provSlug}">Open ${p.province} →</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>';});
diff --git a/server.js b/server.js
index b9dc982..1502c49 100644
--- a/server.js
+++ b/server.js
@@ -85,6 +85,65 @@ app.get('/api/provinces', async (_req, res) => {
} catch (e) { res.status(500).json({ error: e.message }); }
});
+// Province detail: all cantones + by-vertical totals + 8 sample places
+const PROVINCE_SLUGS = {
+ 'san-jose': 'San José',
+ 'alajuela': 'Alajuela',
+ 'heredia': 'Heredia',
+ 'cartago': 'Cartago',
+ 'guanacaste': 'Guanacaste',
+ 'puntarenas': 'Puntarenas',
+ 'limon': 'Limón',
+};
+
+app.get('/api/provinces/:slug', async (req, res) => {
+ try {
+ const provName = PROVINCE_SLUGS[req.params.slug];
+ if (!provName) return res.status(404).json({ error: 'unknown province' });
+
+ const [{ rows: cantones }, { rows: byVert }, { rows: samples }, { rows: totalRow }] = await Promise.all([
+ pool.query(
+ `SELECT r.slug, r.name, r.image_url, r.image_credit, r.image_source_url,
+ COUNT(p.id)::int AS n
+ FROM regions r LEFT JOIN places p ON p.region_id = r.id AND p.status='active'
+ WHERE r.province = $1
+ GROUP BY r.id
+ ORDER BY n DESC, r.name ASC`, [provName]
+ ),
+ pool.query(
+ `SELECT p.vertical, COUNT(*)::int AS n
+ FROM places p JOIN regions r ON r.id = p.region_id
+ WHERE r.province = $1 AND p.status='active'
+ GROUP BY p.vertical
+ ORDER BY n DESC LIMIT 12`, [provName]
+ ),
+ pool.query(
+ `SELECT p.slug, p.name, p.vertical, p.image_url, p.address,
+ r.slug AS region_slug, r.name AS region_name,
+ r.image_url AS region_image_url
+ FROM places p JOIN regions r ON r.id = p.region_id
+ WHERE r.province = $1 AND p.status='active'
+ ORDER BY (p.image_url IS NOT NULL) DESC, p.id DESC
+ LIMIT 8`, [provName]
+ ),
+ pool.query(
+ `SELECT COUNT(p.id)::int AS total
+ FROM places p JOIN regions r ON r.id = p.region_id
+ WHERE r.province = $1 AND p.status='active'`, [provName]
+ ),
+ ]);
+
+ res.json({
+ slug: req.params.slug,
+ name: provName,
+ total: totalRow[0]?.total || 0,
+ cantones,
+ by_vertical: byVert,
+ samples,
+ });
+ } catch (e) { res.status(500).json({ error: e.message }); }
+});
+
app.get('/api/regions', async (_req, res) => {
try {
const { rows } = await pool.query(`
@@ -300,6 +359,7 @@ app.get('/sitemap.xml', async (_req, res, next) => {
{ loc: '/?category=tourism', changefreq: 'daily', priority: '0.8' },
{ loc: '/?category=rentals', changefreq: 'daily', priority: '0.8' },
{ loc: '/?category=service', changefreq: 'daily', priority: '0.8' },
+ ...Object.keys(PROVINCE_SLUGS).map(s => ({ loc: `/pr/${s}`, changefreq: 'weekly', priority: '0.85' })),
];
const regionPages = regions.map(r => ({ loc: `/r/${r.slug}`, changefreq: 'weekly', priority: '0.7' }));
@@ -418,6 +478,10 @@ 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.get('/pr/:slug', async (req, res) => {
+ if (!PROVINCE_SLUGS[req.params.slug]) return res.status(404).sendFile(path.join(__dirname, 'public', '404.html'));
+ res.sendFile(path.join(__dirname, 'public', 'province.html'));
+});
app.use(express.static(path.join(__dirname, 'public')));
← 2a62e9f tick 4 log + hacienda smoke-test instructions for Steve
·
back to Costa Rica
·
yolo tick 6: /search global cross-entity search (places + re 635d444 →