0xwumade/Nigeria-Conflict-Intelligence-Platform-NCIP-

# Nigeria Conflict Intelligence Platform (NCIP) Geospatial insecurity evolution system covering Nigeria 2009–2026. ## Quick start (local, no Docker) ### 1. Prerequisites - Python 3.11+ - PostgreSQL 14+ with PostGIS 3.x extension - Git ### 2. Clone and install ```bash git clone cd Anti_Naija pip install -r requirements.txt ``` ### 3. Configure environment ```bash copy .env.example .env # Windows # cp .env.example .env # Mac/Linux # Edit .env and set your PostgreSQL passwords ``` ### 4. Create the database ```bash # Connect to PostgreSQL as superuser and create the DB psql -U postgres -c "CREATE DATABASE ncip_db;" # Run the schema (creates all tables, roles, indexes, views) psql -U postgres -d ncip_db -f src/storage/schema.sql ``` ### 5. Set role passwords ```bash # Run this in psql connected to ncip_db psql -U postgres -d ncip_db -c "ALTER ROLE ncip_ingest PASSWORD 'ingest_dev_password';" psql -U postgres -d ncip_db -c "ALTER ROLE ncip_reader PASSWORD 'reader_dev_password';" psql -U postgres -d ncip_db -c "ALTER ROLE ncip_analytics PASSWORD 'analytics_dev_password';" ``` Use the same passwords you set in `.env`. ### 6. Run the dashboard ```bash streamlit run app.py ``` Open localhost --- ## Quick start (Docker) ```bash copy .env.example .env # fill in passwords docker compose up # starts DB + app + nginx ``` Open localhost (nginx) or localhost (direct). --- ## Ingest your first data file ```bash # ACLED Nigeria CSV export python scripts/run_ingestion.py --file data/raw/acled_nigeria.csv --source acled # GTD Nigeria Excel export python scripts/run_ingestion.py --file data/raw/gtd_nigeria.xlsx --source gtd ``` --- ## Project structure ``` app.py ← Streamlit entry point requirements.txt ← Python dependencies src/ ingestion/ ← ETL pipeline (extractors, normalizers, loader) cleaning/ ← Data cleaning passes + quality scoring analytics/ ← SQL …