[postgis-users] postgis-users Digest, Vol 203, Issue 1

[Faustin Gashakamba]

Hello,
For making the map, can look into 'heat maps'?


Message sent from mobile
Beware of the typos

On Sat, Jan 5, 2019, 22:00 <postgis-users-request at lists.osgeo.org wrote:

> Send postgis-users mailing list submissions to
>         postgis-users at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.osgeo.org/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
>         postgis-users-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         postgis-users-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
>
>
> Today's Topics:
>
>    1. Timeseries display of points (suraj birla)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 4 Jan 2019 17:01:06 -0800
> From: suraj birla <surajbirla at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: [postgis-users] Timeseries display of points
> Message-ID:
>         <
> CACA5SkDfKmgSST73RVWBuRTCiNaMn+pffQQYTXp4R0GYX_1XzQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Need suggestions.
>
> I've postgis database which has a table with timestamp, lat/lon
>
> we have 600K sensors around the world and it send sends data for every 30
> seconds if the sensor is active.. Data get stored in the database table
>
> I need to show this on a map and show when the sensor were active in time
> series manner.
>
> Question?
> What would be best approach to plot 600K points on a map?
> How should I make the data available in time series  manner?
>
> Appreciate your help.
>
> Thanks
> Suraj
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/postgis-users/attachments/20190104/e1891754/attachment-0001.html
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> ------------------------------
>
> End of postgis-users Digest, Vol 203, Issue 1
> *********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190106/ca0483f8/attachment.html>