Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"
From CUOSGwiki
Jump to navigationJump to search| Line 9: | Line 9: | ||
* [http://www.libreoffice.org/download/ LibreOffice] |
* [http://www.libreoffice.org/download/ LibreOffice] |
||
| + | |||
| ⚫ | |||
| + | |||
| ⚫ | |||
| ⚫ | |||
==Getting Started (Spreadsheet Data)== |
==Getting Started (Spreadsheet Data)== |
||
[http://youtu.be/rsT6yOSJzZQ Video Demo] |
[http://youtu.be/rsT6yOSJzZQ Video Demo] |
||
| Line 33: | Line 38: | ||
* Save file in CSV format. |
* Save file in CSV format. |
||
| + | ===Loading data to QGIS and Time Manager |
||
| ⚫ | |||
| − | |||
| ⚫ | |||
| ⚫ | |||
| − | |||
Revision as of 01:54, 15 December 2012
Contents
Disclaimer
Introduction
This is a 10 minute walk through
Requirements
Getting Started (Vector Data)
Getting Started (Time Manager)
Installing Time Manager Plugin
Getting Started (Spreadsheet Data)
Getting the data
- Proceed to data.seattle.gov
- Open Seattle Real Time Fire 911 Calls under "Search & Browse Datasets and Views"; first link.
- Hover over and click Export
- Download a copy of this dataset in XLSX format
Data preparation
- Import to Libreoffice or Openoffice or Microsoft Excel
LibreOffice Calc/OpenOffice Calc
- Right click on "datetime" column and proceed to "Format Cells".
- Find and click "User defined" in "Numbers" tab.
- Change format to the following: YYYY-MM-DD HH:MM:SS
- Save file in CSV format.
Microsoft Excel
- Right click on "datetime" column and proceed to "Format Cells".
- Find and click "Custom" in "Numbers" tab.
- Change format to the following: YYYY-MM-DD HH:MM:SS
- Save file in CSV format.
===Loading data to QGIS and Time Manager
