I have a table with 2 million records in PostGIS:
```sql
    CREATE TABLE public.trips(
    id int4 NULL,
    name text NULL,
    public_start_point public.geometry(point, 4326) NULL,
    stop_point public.geometry(point, 4326) NULL,
    route public.geometry(linestring, 4326) NULL);
```

So far, I have successfully generated a vector tile of the trips using [Tippecanoe][1] and developed a Node.js app to serve them to the client, which is built using React.js and Mapbox GL. As a backend developer working on a GIS project for the first time, I am trying to build a map similar to the [Strava heatmap][2] where I can display the lines (routes) based on their density in a neon style, as well as a heatmap based on the start points. My goal is to have roads with more activity appear darker than those with less.

As an example of what I need, below is a picture of traffic data in the United States, which illustrates the kind of visualization I am aiming for.

[![enter image description here][3]][3]

I have done some research on creating heatmaps, but most resources focus on regular heatmaps rather than linestring-based ones.

My questions are:

Can this be done using vector tiles, or must it be in the form of a raster?
What approaches, concepts, or tools should I be aware of to create a linestring-based heatmap?


  [1]: https://github.com/felt/tippecanoe
  [2]: https://www.strava.com/maps/global-heatmap?sport=EBikeRide&style=dark&terrain=false&labels=true&poi=true&cPhotos=true&gColor=blue&gOpacity=100#6.16/51.682/7.461
  [3]: https://i.sstatic.net/oO20cJA4.webp