4

I am attempting to pull a CSV file from a website that is updated daily. I would like to have a process that can automatically perform the process and save daily as a new layer. The CSV file is related to tracking forest fires and has multiple attributes. The CSV download url is http://www.wildfire.alberta.ca/reports/activedd.csv. I attempted to use the a vrt driver to load the file into QGIS as a layer but I was unable to pull the attributes as well as the lat/long locations.

I am fairly new to QGIS.

Improve this question

1 Answer 1

Reset to default
4

You can load the CSV file directly (or have ftp load the file to your local drive) QGIS will detect the change and reload the data on the fly.

If you want it to change use the 'watch file'

enter image description here

result enter image description here

use wget to get the csv (every minute,hour,day etc) (task scheduler)

enter image description here

Improve this answer
5
  • Do I utilize the "Add Delimited Layer" function to add the csv? If so, don't I have to have the csv saved locally first in which case the daily updates will not occur automatically?
    – Reggie
    Commented May 27, 2015 at 17:58
  • loosely based from fulcrumapp.com/blog/live-data-visualization-in-qgis which version of qgis are you using?
    – Mapperz ♦
    Commented May 27, 2015 at 18:15
  • I am using QGIS 2.8.2
    – Reggie
    Commented May 27, 2015 at 18:18
  • you can use wget to retrieve the file (and replace the existing one ) updated post
    – Mapperz ♦
    Commented May 27, 2015 at 18:36
  • Reggie so this is working for me using wget and using the watch option in qgis 'file:///C:/temp/activedd.csv?type=csv&skipEmptyFields=Yes&xField=fire_location_longitude&yField=fire_location_latitude&spatialIndex=no&subsetIndex=no&watchFile=yes'
    – Mapperz ♦
    Commented May 28, 2015 at 13:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.