Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"
From CUOSGwiki
Jump to navigationJump to search| Line 12: | Line 12: | ||
===Data preparation=== |
===Data preparation=== |
||
* Import to Libreoffice or Openoffice or Microsoft Excel |
* Import to Libreoffice or Openoffice or Microsoft Excel |
||
| − | |||
====LibreOffice Calc/OpenOffice Calc===== |
====LibreOffice Calc/OpenOffice Calc===== |
||
Revision as of 21:11, 12 December 2012
Contents
Introduction
This is a 10 minute walk through
Requirements
Make sure you have the following programs
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 a 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.
Getting Started (Vector Data)
Getting Started (Time Manager)
Loading data to QGSIS
Create new project of QGIS
Base Map
Load CSV file
Save as ESRI shapefile
===Create a heatmap===
