This is a repository for the TigerGraph Graph For All Million Dollar Challenge - UN Data submission. The aim of this repository is to enable anyone who wants to to create an end-to-end TigerGraph + UI solution for the storage, analysis and visualisation of a wide range of UN national and international datasets.

This README provides a guide to creating an implementation of the end-to-end solution which can store, in true related graph form, a broad set of UN Data, and present it in a user friendly web-based interface.

See DevPost submission for more details and background on the scope and goals of the solution: https://devpost.com/software/pinboard_consulting

Folder Structure

├── src
│     ├── app
│     │     ├── components
│     │     │     ├── chart
│     │     │     ├── graph
│     │     │     ├── map
│     │     │     ├── report
│     │     │     ├── route-builder
│     │     │     ├── side-menu
│     │     │     └── table
│     │     ├── screens
│     │     │     └── home
│     │     └── services
│     │         ├── get-data
│     │         └── routing-control
│     ├── assets
│     │     └── lib
│     └── environments
└── UN_Data_Load
    └── Batch_Load

The Major components with their descriptions are as follows:

1. TigerGraph Instance
2. UI build

1. Create a local instance in an environment with a minimum of 128GB RAM to prevent the server from hanging when querying lots of data. (We used a VM with 16 vCPUs and 128GB RAM).
2. Have a python environment with pyTigerGraph, os and Pandas modules installed.
3. If you're using TigerGraph Server (local instance) then you shouldn't need to but please check if Rest++ Authentication is turned off in Graph Studio.
4. Clone this repository
5. Open the "UN_Data_Load/Config.py" file and enter the details of TigerGraph instance (host, username and password)
6. Run python UN_Data_Load/Graph_and_Schema_creation.py
7. Run python UN_Data_Load/Load_jobs_for_all_UN_Datasets.py (This may take 5-10 minutes depending on the CPU capacity)
8. Run python UN_Data_Load/Query_creation_and_installation.py

1. Install Node.js version 16
2. Navigate to git root repository directory
3. Verify the parameters at "src/environments/environment.ts"

• For local instance you shouldn't need to edit the parameters but please verify that they're pointing to your local TigerGraph instance. For cloud instance please edit the parameters as per cloud environment variables (URL, login, etc.).

4. Run command npm install
5. Run command npm audit fix
6. Run command npm run start
7. Go to https://localhost:4200/ to access the locally hosted website.

We have added a guide for the UI interface. Please click here to access.