Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"
From CUOSGwiki
Jump to navigationJump to search| Line 20: | Line 20: | ||
Microsoft Excel |
Microsoft Excel |
||
| − | Right click on " |
+ | * Right click on "datetime" column and proceed to "Format Cells" |
| + | * Find and click "Custom" in "Numbers" tab |
||
==Getting Started (Vector Data)== |
==Getting Started (Vector Data)== |
||
Revision as of 20:03, 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
Openoffice
Microsoft Excel
- Right click on "datetime" column and proceed to "Format Cells"
- Find and click "Custom" in "Numbers" tab
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===
