| Welcome to the GovHack toolkit. This page provides all the information you need to prepare hackfest entries. | 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, data visualisations/infographics | These tools can be used to make entries like: mobile apps, web apps, data visualisations/infographics |
| - govhack toolkit!!!! | - govhack toolkit!!!! |
| - key datasets, directory.gov.au gazetter/AEC electorates/suburbs/postcodes/LGAs | - key datasets, directory.gov.au gazetter/AEC electorates/suburbs/postcodes/LGAs |
| - definitions, open licence reuse permissive hacker hack data journalism data bis UCX etc. | - definitions, open licence reuse permissive hacker hack data journalism data bis UCX etc. |
| - what do govhack entries look like? | - what do govhack entries look like? |
| - roles; coder, designer UX/graphics | - roles; coder, designer UX/graphics |
| server admin / technical tools | |
| many projects will require some kind of internet presence, webpage etc. | |
| video tools, youtube slideshow, FOSS video editing tools | |
| - http://ubuntu-tutorials.com/2008/11/11/relaying-postfix-smtp-via-smtpgmailcom/ | |
| - amon | |
| geo | geo |
| - http://converter.mygeodata.eu/vector kml exporter for shp | - http://converter.mygeodata.eu/vector kml exporter for shp |
| - http://bost.ocks.org/mike/map/ | - http://bost.ocks.org/mike/map/ |
| R | R |
| - http://blog.yhathq.com/posts/10-R-packages-I-wish-I-knew-about-earlier.html | - 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/ | - excel -> R/rattle/ deducer? http://www.r-bloggers.com/updates-to-the-deducer-family-of-packages/ |
| d3 | |
| - http://datadrivenjournalism.net/resources/data_driven_documents_defined | |
| - http://www.benmcmahen.com/blog/posts/50eb57d55a94d35262000001 d3 svg | |
| API | |
| - howto.gov api tutorial | |
| - http://shancarter.com/data_converter/ | |
| - http://training.sunlightfoundation.com/module/data-visualizations-google-docs/ | |
| - api documentation | |
| - WSDL or http://swagger.wordnik.com/ or https://github.com/mashery/iodocs | |
| - 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 better apis https://github.com/liip/LiipHelloBundle | |
| - https://github.com/elc/rapi_doc https://github.com/Pajk/apipie-rails | |
| - | |
| - tools.disclo.gs - how to use data | - tools.disclo.gs - how to use data |
| - https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet#wiki-images reference style images? | |
| - developer tools inc. linked data | - developer tools inc. linked data |
| - gephi -> neo4j | - gephi -> neo4j |
| - neo4j lets you build on, do massive queries of who is friends with who | - neo4j lets you build on, do massive queries of who is friends with who |
| - don't use network viz if what you actually have is a tree/hierarchy with no interconnections 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/ | - don't use network viz if what you actually have is a tree/hierarchy with no interconnections 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/ |
| - http://mbostock.github.com/d3/ex/pack.html http://mbostock.github.com/d3/ex/tree.html | - http://mbostock.github.com/d3/ex/pack.html http://mbostock.github.com/d3/ex/tree.html |
| - postgis/quantum gis | - postgis/quantum gis |
| - (google earth is alright but many limitations) NASA World Wind? | - (google earth is alright but many limitations) NASA World Wind? |
| - ABS statistical areas | - ABS statistical areas |
| - http://irs.gis-lab.info/ wms or http://www.gdal.org/frmt_wms_openstreetmap_tms.xml | - http://irs.gis-lab.info/ wms or http://www.gdal.org/frmt_wms_openstreetmap_tms.xml |
| - can do nearest/isin/union queries - personal geocoder | - can do nearest/isin/union queries - personal geocoder |
| - cloudmade geocoder, google maps my maps | - cloudmade geocoder, google maps my maps |
| - base layers like agri or nearmap | - base layers like agri or nearmap |
| - scraperwiki with new pytemplate libraries | - scraperwiki with new pytemplate libraries |
| - makes an API for your data to get in sqlite/json/csv | - makes an API for your data to get in sqlite/json/csv |
| - three.js with cables vis? Overviewer from AP? | - three.js with cables vis? Overviewer from AP? |
| - govhack library | - govhack library |
| - http://hpneo.github.com/gmaps/examples.html | - http://hpneo.github.com/gmaps/examples.html |
| - android datviz | |
| - 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/ | |
| - https://graphics.stanford.edu/wikis/cs448b-12-fall/ data viz theory | - https://graphics.stanford.edu/wikis/cs448b-12-fall/ data viz theory |
| - https://mixpanel.com/education/understanding-the-first-five-minutes | - https://mixpanel.com/education/understanding-the-first-five-minutes |
| - http://drawingbynumbers.org/toolsandresources | - http://drawingbynumbers.org/toolsandresources |
| - http://wmbriggs.com/blog/?p=6465 | - http://wmbriggs.com/blog/?p=6465 |
| - http://ofps.oreilly.com/titles/9781449339739/k_00000002.html list of d3 alternatives | - http://ofps.oreilly.com/titles/9781449339739/k_00000002.html list of d3 alternatives |
| - http://craigkerstiens.com/2012/10/01/understanding-postgres-performance/ | - http://craigkerstiens.com/2012/10/01/understanding-postgres-performance/ |
| - https://github.com/clips/pattern for easy NLP/network analysis/data mining | - https://github.com/clips/pattern for easy NLP/network analysis/data mining |
| - https://github.com/theodi/open-data-tech-review/wiki othr cleanup/linked data toola | - https://github.com/theodi/open-data-tech-review/wiki othr cleanup/linked data toola |
| - http://www.opentripplanner.org/apidoc/rest.plan.html | |
| - http://selection.datavisualization.ch/ data viz tools catalog | - http://selection.datavisualization.ch/ data viz tools catalog |
| - 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 | |
| - manipulating data - grep/find replace/sed/regex | - manipulating data - grep/find replace/sed/regex |
| - d3 tools and tutorial http://enjalot.com/ http://news.ycombinator.com/item?id=4608440 | - 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/ | - 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 | - how to make an xkcd chart http://bl.ocks.org/3914862 |
| - http://blog.josephwilk.net/ruby/latent-semantic-analysis-in-ruby.html similar terms usually found together | |
| - data viz | - data viz |
| - http://k2company.com/blog/2012/09/06/toolbox-for-learning-machine-learning-and-data-science/ | - http://k2company.com/blog/2012/09/06/toolbox-for-learning-machine-learning-and-data-science/ |
| - http://williamparry.blogspot.com.au/2011/04/putting-data-into-google-fusion-tables.html google fusion tutorial | - http://williamparry.blogspot.com.au/2011/04/putting-data-into-google-fusion-tables.html google fusion tutorial |
| - andrewharvey4.wordpress.com postgis/asgs tutorial | - andrewharvey4.wordpress.com postgis/asgs tutorial |
| - http://www.slideshare.net/maxdemarzi/etl-into-neo4j | - http://www.slideshare.net/maxdemarzi/etl-into-neo4j |
| - http://www.twotorials.com/ for R | - 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/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://is-r.tumblr.com/post/38240018815/making-prettier-network-graphs-with-sna-and-igraph | - http://is-r.tumblr.com/post/38240018815/making-prettier-network-graphs-with-sna-and-igraph |
| - http://www.r-bloggers.com/video-simpler-tricks-and-tools-help-debugging-git-latex-and-workflow-with-r-by-prof-rob-hyndman/ | - 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://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://chartsnthings.tumblr.com/post/36978271916/r-tutorial-simple-charts http://flowingdata.com/2012/12/17/getting-started-with-charts-in-r/ |
| - http://dydra.com/ | |
| - http://dydra.com/ | |
| - http://selection.datavisualization.ch/ data viz tools list | - http://selection.datavisualization.ch/ data viz tools list |
| - http://nodexl.codeplex.com/ network graphs for excel | - http://nodexl.codeplex.com/ network graphs for excel |
| - http://sunfoundation.tumblr.com/ | - http://sunfoundation.tumblr.com/ |
| - css framework like bootstrap or zurb foundation | |
| - analysing - linked data tools | - analysing - linked data tools |
| - http://govcampau.wikispaces.com/useful+tools | - http://govcampau.wikispaces.com/useful+tools |
| - http://linkeddata.org/home | - http://linkeddata.org/home |
| - analysing - unstructured/nlp incl overviewer, opennlp/nltk, lucene/solr | |
| - http://www.r-bloggers.com/simple-text-mining-with-r/ | |
| # Hosted Developer Tools {#hosted-developer-tools} | # Hosted Developer Tools {#hosted-developer-tools} |
| ### Sourceforge | ### Sourceforge |
| Subversion, Git, Mercurial, Bazaar, CVS, issue tracker, wiki, release file downloads. Unlimited free use for open source projects. | Subversion, Git, Mercurial, Bazaar, CVS, issue tracker, wiki, release file downloads. Unlimited free use for open source projects. |
| You can create your own Sourceforge project at [http://sourceforge.net/](http://sourceforge.net/) | You can create your own Sourceforge project at [http://sourceforge.net/](http://sourceforge.net/) |
| ### Google Code Project Hosting | ### Google Code Project Hosting |
| Git, Mercurial, and Subversion code. Issue tracker, wiki, release file downloads. Unlimited free use for open source projects. | Git, Mercurial, and Subversion code. Issue tracker, wiki, release file downloads. Unlimited free use for open source projects. |
| 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/) | 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 | # 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. | * 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. | * 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. | * 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. | Please note, there are a combination of Analysis and Visualisation tools in each of the major categories below. |
| # API Development {#api-development} | # API Development {#api-development} |
| So an API isn’t just an XML file  | So an API isn’t just an XML file  |
| A good web based data API: | A good web based data API: |
| * Is logically organised | * Is logically organised |
| * Can filter returned data | * Can filter returned data |
| * Can return results in different open formats (CSV/JSON etc.) | * Can return results in different open formats (CSV/JSON etc.) |
| * Is efficient and responsive by using caching and databases appropriately | * Is efficient and responsive by using caching and databases appropriately |
| * Handles errors gracefully | * Handles errors gracefully |
| * Monitors and controls access (to show benefit realised of API and prevent abuse) | * Monitors and controls access (to show benefit realised of API and prevent abuse) |
| * Provides appropriate documentation with examples | * Provides appropriate documentation with examples |
| Some people like sensis [http://](http://developers.sensis.com.au/)[developers.sensis.com.<wbr>au</wbr>](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. | Some people like sensis [http://](http://developers.sensis.com.au/)[developers.sensis.com.<wbr>au</wbr>](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.<wbr>com</wbr>](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)[+<wbr>REST+API+Design+Guidelines+<wbr>version+1</wbr></wbr>](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1) | 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.<wbr>com</wbr>](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)[+<wbr>REST+API+Design+Guidelines+<wbr>version+1</wbr></wbr>](https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1) |
| API | |
| - howto.gov api tutorial | |
| - http://shancarter.com/data_converter/ | |
| - http://training.sunlightfoundation.com/module/data-visualizations-google-docs/ | |
| - api documentation | |
| - WSDL or http://swagger.wordnik.com/ or https://github.com/mashery/iodocs | |
| - 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 better apis https://github.com/liip/LiipHelloBundle | |
| - https://github.com/elc/rapi_doc https://github.com/Pajk/apipie-rails | |
| - | |
| # Infographics and Data Visualisation {#data-visualisation} | # 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. | 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. | 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 “essential”\. 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/) | [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/<wbr>philogl/</wbr>](http://www.senchalabs.org/philogl/) (contributed by Matt Adcock) | Also check out [http://thejit.org](http://thejit.org/) & [http://www.senchalabs.org/<wbr>philogl/</wbr>](http://www.senchalabs.org/philogl/) (contributed by Matt Adcock) |
| # Mobile | |
| html5 jquery mobile like directory.gov.au | |
| - android datviz | |
| - 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/ | |
| # Geographical Data Tools {#geographical-data-tools} | # 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! | 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! |
| ## Analysis | ## Analysis |
| ### PostGIS | ### PostGIS |
| [](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. | [](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. |
| ### Quantum GIS | ### Quantum GIS |
| [](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/) | [](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/) |
| ## Visualisation | ## Visualisation |
| ### Layar and other augmented reality tools | ### Layar and other augmented reality tools |
| ### Google Fusion Tables/ChartsBin/[OpenHeatMap](http://www.openheatmap.com/) | ### Google Fusion Tables/ChartsBin/[OpenHeatMap](http://www.openheatmap.com/) |
| [](http://www.govhack.org/wp-content/uploads/fusiontablesscreenshot.jpg)Input a numerical values and areas to a spreadsheet and maps are produced | [](http://www.govhack.org/wp-content/uploads/fusiontablesscreenshot.jpg)Input a numerical values and areas to a spreadsheet and maps are produced |
| ### [Cartographer.js](http://cartographer.visualmotive.com/) | ### [Cartographer.js](http://cartographer.visualmotive.com/) |
| [](http://www.govhack.org/wp-content/uploads/cartographerjs.png)Input data as JSON and maps are produced. | [](http://www.govhack.org/wp-content/uploads/cartographerjs.png)Input data as JSON and maps are produced. |
| ### OpenLayers/Google Maps/[Leaflet](http://leaflet.cloudmade.com/) | ### OpenLayers/Google Maps/[Leaflet](http://leaflet.cloudmade.com/) |
| [](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. | [](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. |
| ### NASA World Wind/Google Earth | ### NASA World Wind/Google Earth |
| [](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/) | [](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/) |
| ### | ### |
| # Tabular Data Tools {#tabular-data-tools} | # Tabular Data Tools {#tabular-data-tools} |
| ## Analysis | ## Analysis |
| ### Excel / Calc | ### Excel / Calc |
| 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) | 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/) | ### [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)Clean up duplicate or inconsistent data entries. | [](http://www.govhack.org/wp-content/uploads/google_refine_interface.png)Clean up duplicate or inconsistent data entries. |
| ### PostgreSQL/MySQL | ### PostgreSQL/MySQL |
| [](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. | [](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/) | [Miso Dataset](http://misoproject.com/dataset/) |
| [](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. | [](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. |
| ### R Statistical Language | ### R Statistical Language |
| [](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) | [](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) |
| ## Visualisation | ## Visualisation |
| ### [Tableau Desktop](http://www.tableausoftware.com/) | ### [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.jpg) | Create visualisations from various data formats by dragging and dropping. Free trial available on website. [](http://www.govhack.org/wp-content/uploads/Tableau-Screenshot.jpg) |
| ### [Flotr2](http://www.humblesoftware.com/flotr2/)/[Google Chart Tools](https://developers.google.com/chart/) | ### [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.jpg)Javascript based charts for webpages. | [](http://www.govhack.org/wp-content/uploads/How-to-participate-in-GovHack_html_m11006fce.jpg)Javascript based charts for webpages. |
| ### D3.js (Data-Driven Documents) | ### D3.js (Data-Driven Documents) |
| [](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). | [](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). |
| d3 | |
| - http://datadrivenjournalism.net/resources/data_driven_documents_defined | |
| - http://www.benmcmahen.com/blog/posts/50eb57d55a94d35262000001 d3 svg | |
| ### Processing.js | ### Processing.js |
| # Unstructured (text documents, webpages, metadata, tweets etc) Data Tools | # Unstructured (text documents, webpages, metadata, tweets etc) Data Tools |