Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"

From CUOSGwiki
Jump to navigationJump to search
Line 1: Line 1:
==Introduction==
This is a 10 minute walk through
==Requirements==
* [http://mapbox.com/tilemill/ TileMill]
* [http://hub.qgis.org/projects/quantum-gis/wiki/Download QGIS]
* [http://plugins.qgis.org/plugins/timemanager/ Time Manager]
* [http://www.libreoffice.org/download/ LibreOffice]


==Getting Started (Vector Data)==
==Getting Data==
* Proceed to [https://data.seattle.gov/ data.seattle.gov]
* Search "GIS"

==Getting Started (Time Manager)==
{| border="1" cellpadding="5" cellspacing="0" align="center"
|+'''Table 1. Data
|-
! style="color:#FFFFFF; background:#FF0AFF;" | Vector Data (Base Map)
! style="color:#FFFFFF; background:#FF0AFF;" | Spreadsheet Data
|-
| Coming Soon
| [http://youtu.be/rsT6yOSJzZQ Video Demo]


===Getting the data===
===Getting CSV data===
* Proceed to [https://data.seattle.gov/ data.seattle.gov]
* Proceed to [https://data.seattle.gov/ data.seattle.gov]
* Search and open [https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj Seattle Real Time Fire 911 Calls]
* Search and open [https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj Seattle Real Time Fire 911 Calls]
Line 27: Line 8:
* Download a copy of this dataset in [https://data.seattle.gov/api/views/kzjm-xkqj/rows.xlsx?accessType=DOWNLOAD XLSX] format
* Download a copy of this dataset in [https://data.seattle.gov/api/views/kzjm-xkqj/rows.xlsx?accessType=DOWNLOAD XLSX] format


===Data preparation===
===Getting Vector data==

==Preparation of Data==

===Spreadsheet===
* Import to Libreoffice or Openoffice or Microsoft Excel
* Import to Libreoffice or Openoffice or Microsoft Excel


Line 41: Line 26:
* Change format to the following: YYYY-MM-DD HH:MM:SS
* Change format to the following: YYYY-MM-DD HH:MM:SS
* Save file in CSV format.
* Save file in CSV format.
|-
|}

==Loading data to QGSIS==


===Create new project of QGIS===
===Base Map===
===Load CSV file===
===Save as ESRI shapefile===


==Importing Data==


==Designing a heatmap==
===Importing a spreadsheet ===
* Start QGIS and click "Layer" on the toolbar. A drop down menu will appear.
* Click "Add Delimited Text Layer".
* Browse to location of your CSV file.
* Click on the "OK" button.


* Right click on the imported spreadsheet on the Layers panel. A drop down menu will appear.
* Click "Save As"
* Format should be "ESRI shapefile"
* CRS should be "WGS84"
* "Add saved file to map" should be enabled.
* Save file to a desired location.
* Click on the "OK" button.


===Importing a vector polyline/polygon===
==Visualization in QGIS==


* Start QGIS and click "Layer" on the toolbar. A dropdown menu will appear.
==Designing in TileMill==
* Click "Add Vector Layer".
* Browse to location of your WGS84 projected "shp" file.
* Click on the "Open" button.

Revision as of 14:05, 17 December 2012

Getting Data

Getting CSV data

=Getting Vector data

Preparation of Data

Spreadsheet

  • 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.


Importing Data

Importing a spreadsheet

  • Start QGIS and click "Layer" on the toolbar. A drop down menu will appear.
  • Click "Add Delimited Text Layer".
  • Browse to location of your CSV file.
  • Click on the "OK" button.
  • Right click on the imported spreadsheet on the Layers panel. A drop down menu will appear.
  • Click "Save As"
  • Format should be "ESRI shapefile"
  • CRS should be "WGS84"
  • "Add saved file to map" should be enabled.
  • Save file to a desired location.
  • Click on the "OK" button.

Importing a vector polyline/polygon

  • Start QGIS and click "Layer" on the toolbar. A dropdown menu will appear.
  • Click "Add Vector Layer".
  • Browse to location of your WGS84 projected "shp" file.
  • Click on the "Open" button.