--- a/index.md
+++ b/index.md
@@ -1,6 +1,89 @@
-Below is a whole bunch of information to help you prepare mashups!
-
-# [Hosted Developer Tools](#hosted-developer-tools)
+#GovHack Toolkit
+Welcome to the GovHack toolkit. This page provides all the information you need to prepare hackfest entries.
+These tools can be used to make entries like mobile apps, web apps and data visualisations/infographics.
+
+The text of this toolkit is open for reuse under a Creative Commons Attribution licence and improvements are encouraged via Git http://github.com/maxious/govhack-tools or via email patches to govhack@lambdacomplex.org
+
+# How to register and submit your entry
+## Registering your team
+Coming Soon: how to use the website "Hacker Space" to register and find teams.
+
+## Preparing your submission
+
+You should record a 3 minute speech and mix images/text to accompany.
+http://www.screenr.com/ and other screencasting tools allow you to demo apps.
+To mix together clips, you can use youtube video editor http://www.youtube.com/editor or local software like http://www.videolan.org/vlmc/ or http://www.lwks.com/
+
+You also need to submit your "source material". For an application this may be source code, for another work it might be your notes or prototypes.
+The key thing here is that your source material demonstrates to the judges that some of the end result was your own work and that it is possible for another person to replicate that work.
+
+
+# General References {#general-data-hacking-and-programming-references}
+
+## The basics of being a data scientist
+
+* Have a hypothesis - even if you're making a tool/api that helps people with their questions too, remember what the objective of that is.
+* Find the people and tools you need to prove/show/find. This rest of this page will help with the latter.
+* Analyse and present results - were they what you expected? Do they help explain to others what you have found out?
+Can present as a interactive data visualisation or a web/mobile application or just a infographic/motion graphics video that tells a story.
+
+[![](img/How-to-participate-in-GovHack_html_m6a65720f-300x199.gif "Data Journalism Diagram")](img/How-to-participate-in-GovHack_html_m6a65720f.gif)
+Illustration from Data Journalism Handbook, CC BY-SA 3.0
+
+The best high level reference is the 'Understanding Data' and 'Delivering Data' chapters of the Data Journalism Handbook which is available online for free at
+[datajournalismhandbook.org](http://datajournalismhandbook.org/)
+
+You can learn the technical skills from scratch in Visualize This: The FlowingData Guide to Design, Visualization, and Statistics by Nathan Yau or for more advanced
+practical advice check out Data Analysis with Open Source Tools by Philipp K. Janert
+For further reading in this space
+[http://flowingdata.com/2012/04/27/data-and-visualization-blogs-worth-following/](http://flowingdata.com/2012/04/27/data-and-visualization-blogs-worth-following/)
+
+
+**Statistics**
+
+A great guide to statistics is
+[Think Stats](http://greenteapress.com/thinkstats/html/index.html)
+
+**Programming**
+
+Programming is valuable skill for manipulating and displaying data.
+Basic tutorials for a variety of languages are available for free online or you can learn interactively with websites like [Codecademy for JavaScript](http://www.codecademy.com/#!/exercises/0), [Learn Python](http://www.learnpython.org/) or [Try Ruby](http://tryruby.org/)
+
+For web applications and visualisations, you'll need a basic understanding of JavaScript in order to configure pre made libraries like jQuery. A good source for Javascript information is the [Mozilla Development Network Javascript Page](https://developer.mozilla.org/en/JavaScript)
+
+**Accessibility/User Experience**
+
+Following accessibility guidelines not only make a application accessible but make it a better experience for all users! Even if not making an app, good to consider these things to do and not do when designing for humans: [http://www.w3.org/TR/WCAG/](http://www.w3.org/TR/WCAG/)
+
+
+
+# Developer Tools For Your Computer {#developer-tools-for-your-computer}
+No matter what kind of application you have for the data, there are many tools you can use to better collaborate and manage your project.
+
+### Source Control
+Using a version control system like Git or Subversion allows you to keep many different versions of what you have been working on so you can collaborate with others or simply back up your files so you don't lose them!
+
+[![](img/Screenshot-at-2012-04-29-172132-300x235.png "Git Screenshot")](http://progit.org/book/)
+
+[tutorials on git](http://progit.org/book/) and
+[GUIs to help you](http://code.google.com/p/tortoisegit/)
+
+[manual for Subversion](http://svnbook.red-bean.com/)
+and a [similar GUI for Subversion](http://tortoisesvn.net/)
+
+
+### Task Tracking
+
+Issue/task trackers allow you to outline the tasks required for your project and assign them to people to do.
+
+[Trello](https://trello.com/) and [Workflowy](https://workflowy.com/) are free, lightweight project management tools suitable for a rapid project!
+
+## Hosted Developer Tools {#hosted-developer-tools}
+
+Can get many tools (source control, issue tracking) combined into one service cloud hosted so there's no setup required.
+
+### Github
+Git obviously but svn/hg interfaces are also available. Provide their own GUI for Windows/OSX or use a variety of Git capable tools
### Sourceforge
@@ -15,18 +98,12 @@
You can host your Google Code project and get access to developer tools, APIs and documentation at [http://code.google.com/](http://code.google.com/)
-
-# The basics of being a data scientist
-
-* Have a hypothesis – even if you’re making a tool/api that helps people with their questions too, remember what the objective of that is.
-* Find the people and tools you need to prove/show/find. This rest of this page will help with the latter.
-* Analyse and present results – were they what you expected? Do they help explain to others what you have found out? Can present as a interactive data visualisation or a web/mobile application or just a infographic/motion graphics video that tells a story.
-Please note, there are a combination of Analysis and Visualisation tools in each of the major categories below.
-
-# [API Development](#api-development)
-
-
-So an API isn’t just an XML file ![;)](http://www.govhack.org/wp-includes/images/smilies/icon_wink.gif)
+# Applications of data hacking
+
+## API Development {#api-development}
+
+
+So an API isn't just an XML file ![;)](http://www.govhack.org/wp-includes/images/smilies/icon_wink.gif)
A good web based data API:
@@ -40,281 +117,322 @@
Some people like sensis [http://](http://developers.sensis.com.au/)[developers.sensis.com.au](http://developers.sensis.com.au/)[/](http://developers.sensis.com.au/) use a provider like[http://](http://mashery.com/)[mashery.com](http://mashery.com/)[/](http://mashery.com/) or [https](https://apigee.com/)[://](https://apigee.com/)[apigee.com](https://apigee.com/) or [http://](http://apiaxle.com/)[apiaxle.com](http://apiaxle.com/)[/](http://apiaxle.com/) or [http://www.3scale.net/](http://www.3scale.net/) which handles making a good API for them.
-Atlassian have a great page on what makes a good API [https](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1)[://](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1)[developer.atlassian.com](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1)[/display/REST/](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1)[Atlassian](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1)[+REST+API+Design+Guidelines+version+1](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1)
-
-
-
-
-
-# [Data Visualisation](#data-visualisation)
+Atlassian have a great page on what makes a good API https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1)
+
+HowTo.gov has a bunch of api resources about choosing SOAP vs. REST etc. http://www.howto.gov/mobile/apis-in-government
+
+API documentation is important too! Traditionally for SOAP APIs, you use WSDL but for REST try [Swagger](http://swagger.wordnik.com/) or [iodocs](https://github.com/mashery/iodocs)
+Many web app frameworks can generate the documentation for you. For example Symfony for PHP http://symfony.com/ https://github.com/FriendsOfSymfony/FOSRestBundle http://williamdurand.fr/2012/08/02/rest-apis-with-symfony2-the-right-way/ https://github.com/nelmio/NelmioApiDocBundle
+Or for Ruby on Rails there is is https://github.com/elc/rapi_doc https://github.com/Pajk/apipie-rails
+
+ better apis https://github.com/liip/LiipHelloBundle
+
+ http://amberonrails.com/building-stripes-api/
+
+example WeatherTree weather API
+
+
+## Infographics and Data Visualisation {#data-visualisation}
+
+Infographics try to contextualise charts and graphs to tell a story. Data vis builds on this to find new ways to design insight.
Most of the categories to follow have visualisation tools specific to their purpose.
-You can find some data visualisation “essential”\. tools below:
+You can find some data visualisation tools below:
[http://www.visualisingdata.com/index.php/2011/07/part-6-the-essential-collection-of-visualisation-resources/](http://www.visualisingdata.com/index.php/2011/07/part-6-the-essential-collection-of-visualisation-resources/)
Also check out [http://thejit.org](http://thejit.org/) & [http://www.senchalabs.org/philogl/](http://www.senchalabs.org/philogl/) (contributed by Matt Adcock)
-
-
-# [Augmented Reality Tools](#augmented-reality-tools)
-
-### buildAR
-
-buildAR was the world’s first AR Content Management System with the first early version launched back in 200\. as a bit of a test to see if people were interested in being able to create their own augmented experiences. MOB Labs officially launched the new improved buildAR at the Augmented Reality event in Silicon Valley in May 2011.
-
-[http://buildAR.com](http://buildar.com/) (normally a 1\. day free trial but GovHack attendees on the day will get a fully activated account for a month. If you are a GovHack attendee want full access now to play, just sign up for a trial and then forward your GovHack Eventbrite registration email to govhack [at] buildar.com and they’ll set you up for the free month fully activated account within a couple of days.
-
-### Other AR tools and references
-
-theAWEsomeWEB –\. Future of the Augmented Web [http://theAWEsomeWEB.com](http://theawesomeweb.com/)
-
-Layar –\. AR Browser - [http://layar.com](http://layar.com/)
-
-Junaio –\. AR Browser - [http://junaio.com](http://junaio.com/)
-
-Aurasma –\. AR Browser - [http://aurasma.com/](http://aurasma.com/)
-
-Vuforia –\. NFT based AR SDK - [http://qualcomm.com/solutions/augmented-reality](http://qualcomm.com/solutions/augmented-reality)
-
-String –\. Marker based AR SDK - [http://poweredbystring.com/](http://poweredbystring.com/)
-
-[pointcloud.io](http://pointcloud.io/) - SLAM based AR SDK - [http://pointcloud.io/](http://pointcloud.io/)
-
-ARToolkit –\. Marker based AR SDK - [http://en.wikipedia.org/wiki/ARToolKit](http://en.wikipedia.org/wiki/ARToolKit)
-
-FLARToolkit –\. Marker based AR SDK - [http://saqoo.sh/a/en/flartoolkit/start-up-guide](http://saqoo.sh/a/en/flartoolkit/start-up-guide)
-
-Kooaba –\. Visual search platform - [http://kooaba.com](http://kooaba.com/)
-
-Catchoom –\. Visual search platform - [http://catchoom.com/](http://catchoom.com/)
-
-Google Googles –\. Visual search app - [http://www.google.com/mobile/goggles/#text](http://www.google.com/mobile/goggles/#text)
-
-Vuzix 920AR –\. Wearable display - [http://www.vuzix.com/consumer/products_wrap920ar.html](http://www.vuzix.com/consumer/products_wrap920ar.html)
-
-Project Glass –\. Googles wearable display project - [http://www.youtube.com/watch?v=9c6W4CCU9M4](http://www.youtube.com/watch?v=9c6W4CCU9M4)
-
-Mixed Reality –\. Nokia’s vision for wearable displays [http://www.youtube.com/watch?v=CGwvZWyLiBU](http://www.youtube.com/watch?v=CGwvZWyLiBU)
-
-City Lens –\. Nokia’s latest AR app - [http://www.youtube.com/watch?v=63lNPkl-EPE&feature=youtu.be](http://www.youtube.com/watch?v=63lNPkl-EPE&feature=youtu.be)
-
-AR –\. Wikipedia page - [http://en.wikipedia.org/wiki/Augmented_reality](http://en.wikipedia.org/wiki/Augmented_reality)
-
-Steve Mann –\. Wearable Computing Pioneer - [http://en.wikipedia.org/wiki/Steve_Mann](http://en.wikipedia.org/wiki/Steve_Mann)
-
-Thad Starner –\. Wearable Computing Pioneer [http://en.wikipedia.org/wiki/Thad_Starner](http://en.wikipedia.org/wiki/Thad_Starner)
-
-Mark Weiser –\. Father of Pervasive Computing [http://en.wikipedia.org/wiki/Mark_Weiser](http://en.wikipedia.org/wiki/Mark_Weiser)
-
-Geographical Data Tools](#geographical-data-tools)
-
-Check out the[ GeoRabble Boundary Mapper’s Cookbook](http://georabble.org/2012/05/31/the-boundary-mappers-cookbook/) to see how you can tie all these things together!
+Have to use visual art concepts, good color schemes http://www.r-bloggers.com/the-paul-tol-21-color-salute/
+
+
+ - https://graphics.stanford.edu/wikis/cs448b-12-fall/ data viz theory
+ - http://drawingbynumbers.org/toolsandresources
+ - http://selection.datavisualization.ch/ data viz tools catalog
+
+examples - http://sunfoundation.tumblr.com/
+### The Open Budget
+
+
+## Web Applications
+
+With the rise of HTML5 technologies it is easier than ever to make a web application for engaging use of data.
+
+ - css framework like bootstrap or zurb foundation
+- css gauges http://www.larentis.eu/donuts/
+- bootstrap themes, web fonts, css sprites, icon fonts
+ - http://designmodo.com/flat-free/ http://designmodo.github.com/Flat-UI/
+
+### Examples
+
+
+#### PlanningAlerts
+
+[![Planning Alerts Screenshot](img/How-to-participate-in-GovHack_html_2f0199ff1-300x221.png "Planning Alerts Screenshot")](img/How-to-participate-in-GovHack_html_2f0199ff1.png)Description: Planning Alerts takes data from local government development applications and sends alerts to users based on what applications are lodged in their area.
+
+Programming Language: Ruby
+
+Source Control: [Git](https://github.com/openaustralia/planningalerts-app)
+
+Issue Tracking: [Atlassian JIRA](http://tickets.openaustraliafoundation.org.au/browse/PA/)
+
+#### LobbyLens
+
+[![](img/129-Screenshot-LobbyClue_-_Chromium-300x180.png "LobbyLens screenshot")](img/129-Screenshot-LobbyClue_-_Chromium.png)
+
+Description: Displays connections between government contracts, business details, politician responsibilities, lobbyists, clients of lobbyists, political donors and the location of these entities.
+
+Programing Language: PHP
+
+Source Control: SVN (Subversion)
+
+Issue Tracking: A whiteboard
+
+#### bus.lambdacomplex.org
+
+[![](img/How-to-participate-in-GovHack_html_3789acae-300x253.jpg "Bus.lambda screenshot")](img/How-to-participate-in-GovHack_html_3789acae.jpg)
+
+Description: Online Canberra Bus Timetables and Trip Planner.
+
+Programing Language: PHP/Ruby
+
+Source Control: Git
+
+Issue Tracking: Github
+
+## Mobile
+
+Frameworks, http://www.sencha.com/products/touch http://phonegap.com/ http://cordova.apache.org/
+
+html5 jquery mobile like directory.gov.au
+
+For data visualisation, there are a variety of graph widgets http://code.google.com/p/afreechart/ http://code.google.com/p/snowdon/ http://code.google.com/p/chartdroid/ http://androidplot.com/ http://code.google.com/p/achartengine/
+
+
+Backend frameworks http://helios.io/ https://www.parse.com/
+### Examples
+
+Bureau of Meteorology Water Storage App http://icelab.com.au/work/bureau-of-meteorology/
+
+NZ Gov budget http://www.treasury.govt.nz/budget/app
+
+
+# Geographical Data Tools {#geographical-data-tools}
+
+Check out the [GeoRabble Boundary Mapper's Cookbook](http://georabble.org/2012/05/31/the-boundary-mappers-cookbook/) to see how you can tie all these things together!
+
+## Key datasets
+base layers like agri http://agri.openstreetmap.org/, http://irs.gis-lab.info/ wms or http://www.gdal.org/frmt_wms_openstreetmap_tms.xml
+
+ASGS from ABS including suburbs/postcodes andrewharvey4.wordpress.com postgis/asgs tutorial
+You can also get KML layers for various statistical measures on the ABS TableBuilder tool.
+
+## Wrangling
+
+### Converting
+There are many spatial data formats and often the one your tool requires is not the one the dataset is provided in
+Online
+ - http://converter.mygeodata.eu/vector kml exporter for shp
+or locally using GDAL (better for many megabyte datasets)
+
+### Geocoding
+cloudmade, google (but you must display on a Google Map).
+
+Easiest way to do is with a Google Spreadsheet/Fusion Table http://williamparry.blogspot.com.au/2011/04/putting-data-into-google-fusion-tables.htm http://support.google.com/fusiontables/answer/1012281?hl=en&ref_topic=2592806
+
## Analysis
+
### PostGIS
-[![](http://www.govhack.org/wp-content/uploads/postgisexample-300x130.jpg "postgisexample")](http://www.govhack.org/wp-content/uploads/postgisexample.jpg)PostGIS is an extension for the PostgreSQL database server that allows you to store and manipulate geospatial data on a large scale. For example finding which points are in an area or what points are closest . It is also very useful for storing geospatial data because it can convert between all major formats including ESRI Shape files and Google Earth/Maps KML.
+[![](img/postgisexample-300x130.jpg "postgisexample")](img/postgisexample.jpg)PostGIS is an extension for the PostgreSQL database server that allows you to store and manipulate geospatial data on a large scale. For example finding which points are in an area or what points are closest . It is also very useful for storing geospatial data because it can convert between all major formats including ESRI Shape files and Google Earth/Maps KML.
### Quantum GIS
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m50afbe88-300x160.jpg "QGIS Screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m50afbe88.jpg)QGIS is a graphical desktop application that allows viewing and editing of geospatial data. Some good base maps are available by adding the WMS layer/server [http://irs.gis-lab.info/](http://irs.gis-lab.info/)
+[![](img/How-to-participate-in-GovHack_html_m50afbe88-300x160.jpg "QGIS Screenshot")](img/How-to-participate-in-GovHack_html_m50afbe88.jpg)QGIS is a graphical desktop application that allows viewing and editing of geospatial data. Some good base maps are available by adding the WMS layer/server [http://irs.gis-lab.info/](http://irs.gis-lab.info/)
## Visualisation
+### Layar and other augmented reality tools
+
### Google Fusion Tables/ChartsBin/[OpenHeatMap](http://www.openheatmap.com/)
-[![](http://www.govhack.org/wp-content/uploads/fusiontablesscreenshot-300x168.jpg "fusiontablesscreenshot")](http://www.govhack.org/wp-content/uploads/fusiontablesscreenshot.jpg)Input a numerical values and areas to a spreadsheet and maps are produced
+[![](img/fusiontablesscreenshot-300x168.jpg "fusiontablesscreenshot")](img/fusiontablesscreenshot.jpg)Input numerical values and areas to a spreadsheet and maps are produced where the areas are colored on a scale of the values
+
+http://www.peteraldhous.com/CAR/Making_maps_with_Google_Fusion_Tables.pdf tutorial or http://support.google.com/fusiontables/topic/2592754?hl=en&ref_topic=27020 for google help files
### [Cartographer.js](http://cartographer.visualmotive.com/)
-[![](http://www.govhack.org/wp-content/uploads/cartographerjs-300x187.png "cartographerjs screenshot")](http://www.govhack.org/wp-content/uploads/cartographerjs.png)Input data as JSON and maps are produced.
-
+[![](img/cartographerjs-300x187.png "cartographerjs screenshot")](img/cartographerjs.png)Input data as JSON and maps are produced.
+See also d3 maps.
+ - http://bost.ocks.org/mike/map/
### OpenLayers/Google Maps/[Leaflet](http://leaflet.cloudmade.com/)
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_512fcbe1-300x173.jpg "OpenLayers Screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_512fcbe1.jpg)Display points and different layers. Leaflet is the easiest to use if you just want to show points with popups when clicked on.
+[![](img/How-to-participate-in-GovHack_html_512fcbe1-300x173.jpg "OpenLayers Screenshot")](img/How-to-participate-in-GovHack_html_512fcbe1.jpg)Display points and different layers. Leaflet is the easiest to use if you just want to show points with popups when clicked on.
+There are wrappers for Google maps like http://hpneo.github.com/gmaps/examples.html and Mapstraction that can make it easier to use too.
### NASA World Wind/Google Earth
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_4dda24a4-300x261.jpg "WorldWind screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_4dda24a4.jpg)Google Earth provides 3\. viewing of KML/GML files which represent points and shapes, both through a desktop application and a web plugin. These can be extended with interactive features that allow you to view by timeline or have animated tours between different points. You can also develop and customise your own viewer with the open source [NASA World Wind toolkit.](http://goworldwind.org/demos/)
+[![](img/How-to-participate-in-GovHack_html_4dda24a4-300x261.jpg "WorldWind screenshot")](img/How-to-participate-in-GovHack_html_4dda24a4.jpg)Google Earth provides 3\. viewing of KML/GML files which represent points and shapes, both through a desktop application and a web plugin. These can be extended with interactive features that allow you to view by timeline or have animated tours between different points. You can also develop and customise your own viewer with the open source [NASA World Wind toolkit.](http://goworldwind.org/demos/)
###
-Tabular Data Tools](#tabular-data-tools)
+# Tabular Data Tools {#tabular-data-tools}
+
+## Wrangling
+
+Converting formats json/xml/csv etc.
+ - http://shancarter.com/data_converter/
+
+
+Tabular data may have duplicate entries or incorrect formats (varying ways to enter dates/phonenumbers etc.). There are tools to quickly fix common problems
+
+[DataWrangler](http://vis.stanford.edu/wrangler/)/[Google Refine](http://code.google.com/p/google-refine/)
+
+[![](img/google_refine_interface.png "google_refine_interface")](img/google_refine_interface.png)Clean up duplicate or inconsistent data entries.
+
+Can also use general purpose tools; grep/awk/sed
+regex http://www.regexper.com/ http://www.debuggex.com/?re=&str=
## Analysis
-### Excel / Calc
+### Excel / Google Docs
Great basic analysis and viewing. Older versions can be limited to 6500\. or so rows. Eg [http://www.tcij.org/training-material/car/data-mining/3474](http://www.tcij.org/training-material/car/data-mining/3474)
-### [DataWrangler](http://vis.stanford.edu/wrangler/)/[Google Refine](http://code.google.com/p/google-refine/)
-
-[![](http://www.govhack.org/wp-content/uploads/google_refine_interface.png "google_refine_interface")](http://www.govhack.org/wp-content/uploads/google_refine_interface.png)Clean up duplicate or inconsistent data entries.
+http://training.sunlightfoundation.com/module/data-visualizations-google-docs/
### PostgreSQL/MySQL
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_209ee972.jpg "SQL screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_209ee972.jpg)Next step up, large datasets can be manipulated/extracted efficiently for example [http://www.postgresql.org/docs/8.4/static/tutorial-window.html](http://www.postgresql.org/docs/8.4/static/tutorial-window.html) , no built-in data visualisation though.
-
-[Miso Dataset](http://misoproject.com/dataset/)
-
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m53b7ee38-293x300.png "miso screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m53b7ee38.png)Javascript data transformation library – especially good if you want to use the output for javascript interactive visualisations because the transformations can be done on-the-fly by users.
+[![](img/How-to-participate-in-GovHack_html_209ee972.jpg "SQL screenshot")](img/How-to-participate-in-GovHack_html_209ee972.jpg)Next step up, large datasets can be manipulated/extracted efficiently for example [http://www.postgresql.org/docs/8.4/static/tutorial-window.html](http://www.postgresql.org/docs/8.4/static/tutorial-window.html) , no built-in data visualisation though.
### R Statistical Language
-[![](http://www.govhack.org/wp-content/uploads/rstudio-windows-300x249.png "rstudio-windows")](http://www.govhack.org/wp-content/uploads/rstudio-windows.png)Advanced data analysis, can find and visualise trends in large datasets. Some reference resources to learn the language [http://cran.r-project.org/doc/manuals/R-intro.html ](http://cran.r-project.org/doc/manuals/R-intro.html)There are also some addons that provide graphical interfaces that make it easier to use such as Rattle [http://rattle.togaware.com/](http://rattle.togaware.com/) , RStudio [http://rstudio.org/](http://rstudio.org/) or Deducer [http://www.deducer.org/pmwiki/pmwiki.php?n=Main.DeducerManual](http://www.deducer.org/pmwiki/pmwiki.php?n=Main.DeducerManual)
+[![](img/rstudio-windows-300x249.png "rstudio-windows")](img/rstudio-windows.png)Advanced data analysis, can find and visualise trends in large datasets. Some reference resources to learn the language [http://cran.r-project.org/doc/manuals/R-intro.html ](http://cran.r-project.org/doc/manuals/R-intro.html)There are also some addons that provide graphical interfaces that make it easier to use such as Rattle [http://rattle.togaware.com/](http://rattle.togaware.com/) , RStudio [http://rstudio.org/](http://rstudio.org/) or Deducer [http://www.deducer.org/pmwiki/pmwiki.php?n=Main.DeducerManual](http://www.deducer.org/pmwiki/pmwiki.php?n=Main.DeducerManual)
+
+ - http://blog.yhathq.com/posts/10-R-packages-I-wish-I-knew-about-earlier.html
+ - excel -> R/rattle/ deducer? http://www.r-bloggers.com/updates-to-the-deducer-family-of-packages/
+ - http://www.twotorials.com/ for R
+ - http://www.r-bloggers.com/gradient-word-clouds/ http://www.rstudio.com/shiny/ http://blog.ouseful.info/2012/11/28/quick-shiny-demo-exploring-nhs-winter-sit-rep-data/ https://github.com/timelyportfolio/shiny-d3-plot https://github.com/trestletech/shiny-sandbox/tree/master/grn
+ - http://www.r-bloggers.com/video-simpler-tricks-and-tools-help-debugging-git-latex-and-workflow-with-r-by-prof-rob-hyndman/
+ - http://yihui.name/knitr/ makes reports including google widgets/charts/maps via http://www.r-bloggers.com/googlevis-0-3-2-is-released-better-integration-with-knitr/
+ - http://chartsnthings.tumblr.com/post/36978271916/r-tutorial-simple-charts http://flowingdata.com/2012/12/17/getting-started-with-charts-in-r/
+
+ http://www.r-bloggers.com/to-plot-them-is-my-real-test/
+ http://blog.revolutionanalytics.com/2013/04/visualize-large-data-sets-with-the-bigvis-package.html 10 Million Points in 5 seconds.
## Visualisation
### [Tableau Desktop](http://www.tableausoftware.com/)
-Create visualisations from various data formats by dragging and dropping. Free trial available on website. [![](http://www.govhack.org/wp-content/uploads/Tableau-Screenshot-300x190.jpg "Tableau Screenshot")](http://www.govhack.org/wp-content/uploads/Tableau-Screenshot.jpg)
-
-### [Flotr2](http://www.humblesoftware.com/flotr2/)/[Google Chart Tools](https://developers.google.com/chart/)
-
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m11006fce-300x199.jpg "flotr2 screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m11006fce.jpg)Javascript based charts for webpages.
+Create visualisations from various data formats by dragging and dropping. Free trial available on website. [![](img/Tableau-Screenshot-300x190.jpg "Tableau Screenshot")](img/Tableau-Screenshot.jpg)
+
+### Web page (Javascript) graphs
+[Flotr2](http://www.humblesoftware.com/flotr2/)/[Google Chart Tools](https://developers.google.com/chart/)
+[![](img/How-to-participate-in-GovHack_html_m11006fce-300x199.jpg "flotr2 screenshot")](img/How-to-participate-in-GovHack_html_m11006fce.jpg)Javascript based charts for webpages.
+http://www.polychartjs.com/ Allows facetting and easy use of JSON data sets.
### D3.js (Data-Driven Documents)
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m90d8020-300x277.jpg "d3 screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m90d8020.jpg)Javascript visualisations that are more interactive or intricate than charts. Can be hard to learn but there are examples and easier to use premade visualisations such as [word clouds](http://www.jasondavies.com/wordcloud/), [realtime filtering of barcharts](http://square.github.com/crossfilter/), or [bubble trees for comparing amount sizes](https://github.com/okfn/bubbletree).
+[![](img/How-to-participate-in-GovHack_html_m90d8020-300x277.jpg "d3 screenshot")](img/How-to-participate-in-GovHack_html_m90d8020.jpg)Javascript visualisations that are more interactive or intricate than charts. Can be hard to learn but there are examples and easier to use premade visualisations such as [word clouds](http://www.jasondavies.com/wordcloud/), [realtime filtering of barcharts](http://square.github.com/crossfilter/), or [bubble trees for comparing amount sizes](https://github.com/okfn/bubbletree).
+d3
+ - http://datadrivenjournalism.net/resources/data_driven_documents_defined
+ - http://www.benmcmahen.com/blog/posts/50eb57d55a94d35262000001 d3 svg
+ - d3 tools and tutorial http://enjalot.com/ http://news.ycombinator.com/item?id=4608440
+ - Why d3 is the way it is and how to make charts http://bost.ocks.org/mike/chart/
+ - how to make an xkcd chart http://bl.ocks.org/3914862
### Processing.js
-Graph (relationships and networks) Data Tools](#graph-relationships-and-networks-data-tools)
+# Unstructured (Text) Data Tools
+Most of the world's data isn't structured because it is contained in documents (webpages, tweets etc.). Sometimes it is possible to structure it, sometimes there are tools that are better suited it unstructured data.
+## Wrangling
+For extracting data from webpages, checkout Scraperwiki pytemplate scrapy
+
+PDFs - http://source.mozillaopennews.org/en-US/articles/introducing-tabula/ for text PDFs or http://www.reporterslab.org/dochive/ for imafges
+
+If there is no way to form a table structure to be able to apply tabular data techniques , you need a more sophisticated analysis as detailed below.
+
+## Analysing
+Natural Language Processing
+ - opennlp/nltk / https://github.com/clips/pattern
+
+A search engine just for your dataset can also help
+ - lucene/solr
+
+For light weight analysis, try R or Ruby
+ - http://www.r-bloggers.com/simple-text-mining-with-r/
+
+ - http://blog.josephwilk.net/ruby/latent-semantic-analysis-in-ruby.html similar terms usually found together
+
+## Visualising
+
+Make word trees of blocks of text, webpages or twitter account and share them http://www.jasondavies.com/wordtree/
+
+"Overview automatically sorts thousands of documents into topics and sub-topics, by reading the full text of each one." Simply make a CSV file with two columns, id and text. 10,000 documents is a good limit for the current state of the system. https://www.overviewproject.org/
+
+For larger document sets or for alternative visualisations, try Jigsaw a desktop based application. http://www.cc.gatech.edu/gvu/ii/jigsaw/
+
+
+
+# Graph (relationships and networks) Data Tools {#graph-relationships-and-networks-data-tools}
+
+Why? Find communities, hubs, connections between (the X degrees of separation)
+ - http://www.slideshare.net/OReillyStrata/visualizing-networks-beyond-the-hairball
+ - http://blog.sciencenet.cn/blog-554179-622011.html SNA tools catalog
+ - https://github.com/jacomyal/osdc2012-sigmajs-demo sigmajs filtering/searching
+
## Analysis
-### Neo4j
-
-[![](http://www.govhack.org/wp-content/uploads/webadmin-data-300x127.png "Neo4\. web admin screenshot")](http://www.govhack.org/wp-content/uploads/webadmin-data.png)Help understand relationships – how is X connected to Y and via what other entities they both are connected to. Imports and exports
-
-can be done using a preexisting tool like Gremlin or by writing a simple Java/Python/Ruby application. Queries can be tested in the built in data browser.
+### R
+http://www.slideshare.net/ianmcook/social-network-analysis-in-r
+- http://is-r.tumblr.com/post/38240018815/making-prettier-network-graphs-with-sna-and-igraph
+
+
+### Graph Databases
+
+[![](img/webadmin-data-300x127.png "Neo4\. web admin screenshot")](img/webadmin-data.png)Help understand relationships - how is X connected to Y and via what other entities they both are connected to. Imports and exports
+
+ - http://www.slideshare.net/maxdemarzi/etl-into-neo4j
+ http://blog.neo4j.org/2013/03/importing-data-into-neo4j-spreadsheet.html
+
+There are other graph databases worth considering like [OrientDB](http://www.orientdb.org/) or [Titan](http://thinkaurelius.github.com/titan/)
+Major graph databases like these can be accessed using a common syntax called Gremlin or by writing a simple Java/Python/Ruby application. Queries can be tested in the built in data browser.
+
+
### [NetworkX](http://networkx.lanl.gov/index.html)
-[![](http://www.govhack.org/wp-content/uploads/chess_masters-300x300.png "NetworkX")](http://www.govhack.org/wp-content/uploads/chess_masters.png)
+[![](img/chess_masters-300x300.png "NetworkX")](img/chess_masters.png)
NetworkX is a social network analysis library for python. Many advanced analyses built in like finding communities within a graph. Also good for converting data into graphs.
-### Palantir
-
-Palantir make a good computer forensics tool, which they will showcase and give GovHack attendees access to for GovHack data analysis purposes. For more information check out:
-
-[http://palantir.com.au/](http://palantir.com.au/)
+tutorial/intro http://www.cl.cam.ac.uk/~cm542/teaching/2011/stna-pdfs/stna-lecture11.pdf
+
## Visualisation
+### Tree/Hierarchy visualisation
+Sometimes what you actually have is a tree/hierarchy with no interconnections. In these cases, it's better to use a Tree visualisation.
+ http://www.randelshofer.ch/treeviz/ http://thejit.org/demos/ http://mbostock.github.com/protovis/ex/treemap.html http://blog.pixelingene.com/2011/07/building-a-tree-diagram-in-d3-js/d3 for Trees and Hierarchies
+ http://mbostock.github.com/d3/ex/pack.html http://mbostock.github.com/d3/ex/tree.html
+
+### NodeXL for Microsoft Excel
+ - http://nodexl.codeplex.com/ network graphs for excel
### [Graphviz](http://www.graphviz.org/)
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_7579906d-300x184.png "Graphviz Screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_7579906d.png)Classic directed graph visualisation tool, can even [generate images online without installing](http://ashitani.jp/gv/) or use in webpages with [javascript port of software](http://code.google.com/p/canviz/). File format [“dot” very easy to learn](http://en.wikipedia.org/wiki/DOT_language)
+[![](img/How-to-participate-in-GovHack_html_7579906d-300x184.png "Graphviz Screenshot")](img/How-to-participate-in-GovHack_html_7579906d.png)Classic directed graph visualisation tool, can even [generate images online without installing](http://ashitani.jp/gv/) or use in webpages with [javascript port of software](http://code.google.com/p/canviz/). File format ["dot" very easy to learn](http://en.wikipedia.org/wiki/DOT_language)
### Gephi
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_74d01d05-300x195.jpg "Gephi Screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_74d01d05.jpg)Desktop graph editor and renderer. Many good automatic layout algorithms even for very large graphs.
+[![](img/How-to-participate-in-GovHack_html_74d01d05-300x195.jpg "Gephi Screenshot")](img/How-to-participate-in-GovHack_html_74d01d05.jpg)Desktop graph editor and renderer. Many good automatic layout algorithms even for very large graphs.
### [sigma.js](http://sigmajs.org/)
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m6006eaf3-300x130.jpg "Sigma.js Screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m6006eaf3.jpg)Javascript graph viewer, can use GEXF files exported from tools like neo4j, gephi and NetworkX.
-
-
-
-Below is some additional information including a few previous GovHack projects to get you thinking ![:)](http://www.govhack.org/wp-includes/images/smilies/icon_smile.gif) More examples are available at [http://mashupaustralia.org/](http://mashupaustralia.org/).
-
-Previous Project Examples](#previous-project-examples)
-
-## PlanningAlerts
-
-[![Planning Alerts Screenshot](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_2f0199ff1-300x221.png "Planning Alerts Screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_2f0199ff1.png)Description: Planning Alerts takes data from local government development applications and sends alerts to users based on what applications are lodged in their area.
-
-Programming Language: Ruby
-
-Source Control: [Git](https://github.com/openaustralia/planningalerts-app)
-
-Issue Tracking: [Atlassian JIRA](http://tickets.openaustraliafoundation.org.au/browse/PA/)
-
-## LobbyLens
-
-[![](http://www.govhack.org/wp-content/uploads/129-Screenshot-LobbyClue_-_Chromium-300x180.png "LobbyLens screenshot")](http://www.govhack.org/wp-content/uploads/129-Screenshot-LobbyClue_-_Chromium.png)
-
-Description: Displays connections between government contracts, business details, politician responsibilities, lobbyists, clients of lobbyists, political donors and the location of these entities.
-
-Programing Language: PHP
-
-Source Control: SVN (Subversion)
-
-Issue Tracking: A whiteboard
-
-## Bus.lambdacomplex.org
-
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_3789acae-300x253.jpg "Bus.lambda screenshot")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_3789acae.jpg)
-
-Description: Online Canberra Bus Timetables and Trip Planner.
-
-Programing Language: PHP/Ruby
-
-Source Control: Git
-
-Issue Tracking: Github
-
-# General Data Hacking and Programming References](#general-data-hacking-and-programming-references)
-
-
-[![](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m6a65720f-300x199.gif "Data Journalism Diagram")](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m6a65720f.gif)
-Illustration from Data Journalism Handbook, CC BY-SA 3.0
-
-
-The best high level reference is the “Understanding Data” and “Delivering Data” chapters of the Data Journalism Handbook which is available online for free at
-
-[datajournalismhandbook.org](http://datajournalismhandbook.org/)
-
-You can learn the technical skills from scratch in Visualize This: The FlowingData Guide to Design, Visualization, and Statistics by Nathan Yau or for more advanced
-
-practical advice check out Data Analysis with Open Source Tools by Philipp K. Janert
-
-For further reading in this space
-
-[http://flowingdata.com/2012/04/27/data-and-visualization-blogs-worth-following/](http://flowingdata.com/2012/04/27/data-and-visualization-blogs-worth-following/)
-
-**Statistics**
-
-[http://greenteapress.com/thinkstats/html/index.html](http://greenteapress.com/thinkstats/html/index.html)
-
-**Programming**
-
-Programming is valuable skill for manipulating and displaying data.
-
-Basic tutorials for a variety of languages are available for free online or you can learn
-
-interactively with websites like [http://www.codecademy.com/](http://www.codecademy.com/#!/exercises/0\. for JavaScript or [http://www.learnpython.org/ ](http://www.learnpython.org/)or [http://tryruby.org](http://tryruby.org/)
-
-[https://developer.mozilla.org/en/JavaScript](https://developer.mozilla.org/en/JavaScript) –\. especially for web applications and visualisations, you’ll need a basic understanding of JS. Common libraries like prototype or jQuery can help
-
-**Accessibility/User Experience**
-
-WCAG guidelines not only make a web app accessible but make it a better experience for all users! Even if not making an app, good to consider these things to do and not do: [http://www.w3.org/TR/WCAG/](http://www.w3.org/TR/WCAG/)
-
-
-
-#[Developer Tools For Your Computer](#developer-tools-for-your-computer)
-
-### Source Control –\. Git / Subversion
-
-[![](http://www.govhack.org/wp-content/uploads/Screenshot-at-2012-04-29-172132-300x235.png "Git Screenshot")](http://progit.org/book/)
-
-[http://progit.org/book/](http://progit.org/book/)
-
-[http://svnbook.red-bean.com/](http://svnbook.red-bean.com/)
-
-[http://tortoisesvn.net/](http://tortoisesvn.net/)
-
-[http://code.google.com/p/tortoisegit/](http://code.google.com/p/tortoisegit/)
-
-### Task Tracking - [Trac](http://trac.edgewall.org/) / [Redmine](http://www.redmine.org/) / [Bugzilla](http://www.bugzilla.org/)
-
-## [![](http://www.govhack.org/wp-content/uploads/trac-300x207.png "trac screenshot")](http://www.govhack.org/wp-content/uploads/trac.png)
-
-Issue/task trackers allow you to outline the tasks required for your project and assign them to people to do.
+[![](img/How-to-participate-in-GovHack_html_m6006eaf3-300x130.jpg "Sigma.js Screenshot")](img/How-to-participate-in-GovHack_html_m6006eaf3.jpg)Javascript graph viewer, can use GEXF files exported from tools like neo4j, gephi and NetworkX.
+