Installation of Required Software(s)

Windows 11 OS

PostgreSQL (18)

- Used Application Stack Builder to obtain PostGIS Extension
- Installation of PostGIS Extension (v3.6.0)
    - Installed PostGIS extension on DB
    - Installed PostGIS Raster (pre-requisite for h3)
    - Installed h3
    - Installed h3_postgis
- Configuration
    - Created role for logins (user/pw), can login 
    ```sql 
     CREATE ROLE qgis WITH
        LOGIN
        NOSUPERUSER
        INHERIT
        NOCREATEDB
        NOCREATEROLE
        NOREPLICATION
        NOBYPASSRLS
        ENCRYPTED PASSWORD '';
    ```
    - Added permissions for the qgis role on the public schema in the HRVA  database. 
    - Apply permissions to all future tables in schema

    ``` sql 
    ALTER DEFAULT PRIVILEGES IN SCHEMA public
    GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO qgis;
    ```

Hex9

Hex9 is a global heirarchical half-hex (octohedral) projection system. It is currently a pet project on github so we are going to try to get it working and see if it can be used for effectively binning and aggregating values. It claims to not suffer from the edge issues prevalent in h3, so let's see.

• Cloned the git repo: https://github.com/MrBenGriffin/hex9/tree/main
• Created a new python virtualenv (hex9) with conda
• No requirements.txt is provided with the repo, so we need to build it ourselves. I did this through running the examples and installing the required packages