<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_ym19_1_1546427625919_638250" dir="ltr"><span id="yui_3_16_0_ym19_1_1546427625919_639493">I suggest you look at the QGIS time manager plugin, or perhaps tools like Shiny & Plotly (which use R)</span></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1546427625919_638251"><div id="yui_3_16_0_ym19_1_1546427625919_648387"><br></div><div id="yui_3_16_0_ym19_1_1546427625919_648481" dir="ltr">In QGIS I have plotted 7 million (GBIF) points, which did take a couple of minutes - but it worked...<br></div><div id="yui_3_16_0_ym19_1_1546427625919_648482"><br></div><div id="yui_3_16_0_ym19_1_1546427625919_648386">Brent Wood<br></div><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1546427625919_638255" style="display: block;"> <div style="font-family: verdana, helvetica, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1546427625919_638254"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1546427625919_638253"> <div dir="ltr" id="yui_3_16_0_ym19_1_1546427625919_638252"> <font id="yui_3_16_0_ym19_1_1546427625919_648381" size="2" face="Arial"> <hr id="yui_3_16_0_ym19_1_1546427625919_648479" size="1"> <b><span style="font-weight:bold;">From:</span></b> suraj birla <surajbirla@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Saturday, January 5, 2019 2:01 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> [postgis-users] Timeseries display of points<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1546427625919_638256"><br><div id="yiv3540236016"><div dir="ltr" id="yui_3_16_0_ym19_1_1546427625919_648460">Need suggestions.<div id="yui_3_16_0_ym19_1_1546427625919_648478"><br></div><div id="yui_3_16_0_ym19_1_1546427625919_648461">I've postgis database which has a table with timestamp, lat/lon</div><div id="yui_3_16_0_ym19_1_1546427625919_648477"><br></div><div id="yui_3_16_0_ym19_1_1546427625919_648462">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</div><div id="yui_3_16_0_ym19_1_1546427625919_648517"><br></div><div id="yui_3_16_0_ym19_1_1546427625919_648463">I need to show this on a map and show when the sensor were active in time series manner.</div><div><br></div><div id="yui_3_16_0_ym19_1_1546427625919_648518">Question?</div><div id="yui_3_16_0_ym19_1_1546427625919_648476">What would be best approach to plot 600K points on a map?</div><div>How should I make the data available in time series manner?</div><div><br></div><div>Appreciate your help.<br></div><div><br></div><div>Thanks</div><div>Suraj</div></div></div>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br><br></div> </div> </div> </div></div></body></html>