The repository contains code to show how to use python and PostGIS for data analysis.
Original data on the Sketchfab
- Anaconda or Miniconda
- docker compose v2
Install dependencies:
conda env create -n env_name --file ./environment.yaml
conda activate env_name
Use Mamba instead conda to speedup dependency resolving.
Run PostGIS:
docker compose up -d
Check connection to the database.
Download data from the Sketchfab or any PLY file with color.
Modify config: insert_data.yaml. By default, drop_tables is true.
Insert data:
python ./insert_data.py
Run dashboard:
python ./dashboard.py