PostGIS with Plotly Dash to query and show lidar data

Description

The repository contains code to show how to use python and PostGIS for data analysis.

Original data on the Sketchfab

Requirements

1. Anaconda or Miniconda
2. docker compose v2

How to run

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