artemdevelop2023/guinea-cadastre-map

# Guinee Mining Cadastre Bot (Full, all statuses) ## What it does - Extracts *license-like* polygon layers from the official Guinea Mining Cadastre ArcGIS MapServer. - Writes an append-only CSV journal (crash-safe). - Rebuilds a single XLSX every 60 seconds from the CSV journal. - Optional Stage 2: best-effort company contact enrichment using **official sources only** (official website / official LinkedIn company page if found). ## Output (one Excel file) `guinee_licenses.xlsx` with columns: No | License No | Company Name | License Type | Date Granted | Date Expiry | Commodity | Area (km2) | Website | Email | Phone | Contact Person | Notes ## Requirements - Python 3.11+ - Playwright + Chromium (Playwright-managed) - Packages in `requirements.txt` ## Install (Debian/Ubuntu) ```bash sudo apt update sudo apt install -y python3 python3-venv python3-pip python3 -m venv venv source venv/bin/activate pip install -r requirements.txt python -m playwright install chromium python -m playwright install-deps chromium ``` ## Run ```bash source venv/bin/activate python guinee_cadastre_bot.py --out-dir ./out ``` Disable enrichment (Stage 2): ```bash python guinee_cadastre_bot.py --out-dir ./out --no-enrich ``` ## Notes - Required fields to write a row: **License No + Company Name**. - Dates are normalized to `dd/mm/yyyy`. - Area is normalized to **km²** and rounded to integers. - Progress is printed every 10 seconds. - XLSX is rebuilt every 60 seconds.