[postgis-users] Timeseries display of points

Brent Wood pcreso at yahoo.com
Sat Jan 5 12:06:09 PST 2019

I suggest you look at the QGIS time manager plugin, or perhaps tools like Shiny & Plotly (which use R)
In QGIS I have plotted 7 million (GBIF) points, which did take a couple of minutes - but it worked...

Brent Wood

      From: suraj birla <surajbirla at gmail.com>
 To: PostGIS Users Discussion <postgis-users at lists.osgeo.org> 
 Sent: Saturday, January 5, 2019 2:01 PM
 Subject: [postgis-users] Timeseries display of points
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.

postgis-users mailing list
postgis-users at lists.osgeo.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190105/e87b5475/attachment.html>

More information about the postgis-users mailing list