Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"
From CUOSGwiki
Jump to navigationJump to search| Line 14: | Line 14: | ||
* Import spreedsheet |
* Import spreedsheet |
||
| + | ====LibreOffice Calc/OpenOffice Calc===== |
||
| − | Libreoffice |
||
| + | * 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 |
||
| ⚫ | |||
| − | Openoffice |
||
| − | |||
| ⚫ | |||
* Right click on "datetime" column and proceed to "Format Cells" |
* Right click on "datetime" column and proceed to "Format Cells" |
||
Revision as of 20:08, 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
- Open Libreoffice or Openoffice or Microsoft Excel
- Import spreedsheet
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
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
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===
