rcpch-census-platform

RCPCH Census Database Dump v1.1.0 Total Size: 4.8G Added: Adds geometry/shape files support for LSOAs, SOAs, Data ZOnes, LADs for multiple years, tagged with IMD ranks/quantiles and optimized for pg_tileserv ⚠️ Large File - Assembly Required This dump has been split into 3 parts due to GitHub's file size limits. Download and reassemble: # Download all parts wget https://github.com/rcpch/rcpch-census-platform/releases/download/v1.1.0/rcpch-census-v1.1.0.dump.part-aa wget https://github.com/rcpch/rcpch-census-platform/releases/download/v1.1.0/rcpch-census-v1.1.0.dump.part-ab # ... (download all parts) # Reassemble cat rcpch-census-v1.1.0.dump.part-* > rcpch-census-v1.1.0.dump # Verify integrity (optional) ls -lh rcpch-census-v1.1.0.dump # Clean up parts rm rcpch-census-v1.1.0.dump.part-* Or use this one-liner: # Download and reassemble automatically for part in {a..z}; do wget -q https://github.com/rcpch/rcpch-census-platform/releases/download/v1.1.0/rcpch-census-v1.1.0.dump.part-a${part} 2>/dev/null || break done cat rcpch-census-v1.1.0.dump.part-* > rcpch-census-v1.1.0.dump rm rcpch-census-v1.1.0.dump.part-* How to use this dump: Option 1: Using Docker Compose # docker-compose.yml services: db: image: postgis/postgis:15-3.4 environment: POSTGRES_USER: rcpchCensususer POSTGRES_PASSWORD: ${DB_PASSWORD} POSTGRES_DB: rcpchCensusdb volumes: - ./init-db:/docker-entrypoint-initdb.d - pgdata:/var/lib/postgresql/data ports: - "5432:5432" volumes: pgdata: # Download and prepare mkdir -p init-db cd init-db ## ⚠️ Large File - Assembly Required This dump has been split into 3 parts due to GitHub's file size limits. **Download and reassemble:** ```bash # Download all parts wget https://github.com/rcpch/rcpch-census-platform/releases/download/v1.1.0/rcpch-census-v1.1.0.dump.part-aa wget https://github.com/rcpch/rcpch-census-platform/releases/download/v1.1.0/rcpch-census-v1.1.0.dump.part-ab # ... (download all parts) # Reassemble cat rcpch-census-v1.1.0.dump.part-* > rcpch-census-v1.1.0.dump # Verify integrity (optional) ls -lh rcpch-census-v1.1.0.dump # Clean up parts rm rcpch-census-v1.1.0.dump.part-* Or use this one-liner: # Download and reassemble automatically for part in {a..z}; do wget -q https://github.com/rcpch/rcpch-census-platform/releases/download/v1.1.0/rcpch-census-v1.1.0.dump.part-a${part} 2>/dev/null || break done cat rcpch-census-v1.1.0.dump.part-* > rcpch-census-v1.1.0.dump rm rcpch-census-v1.1.0.dump.part-* Create restore script cat > restore.sh