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

From CUOSGwiki
Jump to navigationJump to search
Line 5: Line 5:
 
* Search & open [https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj Seattle Real Time Fire 911 Calls]
  
* Search & open [https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj Seattle Real Time Fire 911 Calls]
 
* Click "Export", A drop down menu will appear.
 
* Click "Export", A drop down menu will appear.
−
* Click "XLSX" from "Download As"
 +
* Scroll down to "Download As"
 
* 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
   
 
===Getting Vector data===
  
===Getting Vector data===
  +
* Proceed to [https://data.seattle.gov/ data.seattle.gov]
  +
* Search & open [https://data.seattle.gov/dataset/Street-Network-Database/afip-2mzr Street Network Database]
   
 
==Preparation of Data==
  
==Preparation of Data==

Revision as of 13:14, 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.
Retrieved from "https://dges.carleton.ca/CUOSGwiki/index.php?title=Visualizing_Multi-Temporal_Data_with_Time_Manager&oldid=3228"