10 December 2014

Free data journalism tools - time lines

This post starts series of posts with free tools for data journalism. To make everything clear, I have nothing against paid apps but I just wanted to show that having strong willingness to work with data and no budget is enough to build a working place for a data journalist / yourself / data blogger / student / random person who likes data. In more romantic words, love for data is everything, you don't need more :)

09 December 2014

Creating and saving path as KML file in Google Earth

You can use KML files to store routes of your trips, bird migration, geographical discoveries or whatever you want. Later you can use KML files to present created geo data in Google Fusion Tables.

03 December 2014

How to create KML file to store your geo data

You can use KML files to create maps in Google Fusion Tables. 

Comments to the tutorial: I keep everything in folders, it's not a must but when you have a few polygons or lines or points it's easier to keep order. I segregate everything by type, so for example polygons and points are never in the same folder, I do this just in case if I wanted to export KML to shape file.
This tutorial is useful when you want to create geographic files of places that are hard to find in ready geo files. It's recommended for smaller projects, as everything is done by hand. Easy to imagine that mapping all buildings in a selected country isn't this case :)

25 November 2014

Shape file directory

It's a list from my perspective, I work mainly with geo data for Europe and Asian post Soviet Union countries. I wanted to keep all my sources in one place so I started this list, which I am planning to update when I find something interesting. I focus on open source shape files.

If you came across a website with shape files and you want to share it with me, it will be the happiest day of my life.

18 November 2014

Велодорожки Москвы / Cycle lanes of Moscow

Портал открытых данных правительства Москвы опубликовал географические координаты московских велодорожек.
Общая длина велодорожек состоит 111 км. Самая длинная велодорожка находится в парке «Лосиный Остров».

Я хотела сделать карту поинтереснее и добавить другие данные к велосипедным геоданным, но не нашла ничего подходящего.

На моей карте можно включить Street View чтобы увидеть фотографии.
========================================================

English version :)

17 November 2014

Reshaping data in Data Wrangler

Data Wrangler is a hero of this tutorial. It's free online tool to transform data.

There are three reasons why it's worth to use Data Wrangler:
  • it's very easy to use
  • although it's simple it offers many useful functions
  • the app's done by nice people

The app has limitations, Wrangler only supports up to 40 columns and 1000 rows. If you are planning to work with something bigger than that, then you have to divide your data. This limitation is the most painful part of this tutorial so you can relax and keep reading, now there will be only positive things.

10 November 2014

Something old, something new

I'm totally addicted to archaeological documentaries. My favourite archaeological site is Göbekli Tepe, google it, it's just WOW. In July 2014 Klaus Schmidt, who headed the excavations at the site, passed away. I started to thinking about doing something in this field. I wanted to analyse some data devoted to Göbekli Tepe, but I couldn't find anything. Archaeological data published in the internet are rarity.


06 November 2014

Simplifying geometries of polygon shape files in QGIS's SimpliPy

First you have to install SimpliPy

Note that the plug-in says: You must have installed Shapely 1.2.18 or you will get an error installing or using this plug-in. Shapely is open source.

==============================================
Here you can learn what simplifying geometries of shape files is.
==============================================

05 November 2014

How the world has changed from 1960, population comparator

I was playing with population data but I wanted to do something different so I took into account data for a long period.

I prepared population comparator, a tool to compare how the growth of population proceed in countries. Don't get wild and don't select too many countries as it will be impossible to see anything.

28 October 2014

Cycling in London

I've done a cycling map of London.
Not everything was as I planned. I was searching for a line shape file of the London's cycle lanes, as logical would be adding length of cycle lanes per ward or any data set saying about an average commuting distance to work. I asked Transport for London and a few cycling organizations based in London for the shape file but nobody was able to help me.

24 October 2014

Simplifying geometries of polygon shape files

If your map works very slowly and you have to wait for a respond for a loooooooooong time, it's a clear sign that you need to simplify the geometries of the shape files.

14 August 2014

Tableau's culture

I applied for work and I was rejected. The HR lady called me to provide me with the feedback, she said shortly that nothing was wrong with my application but the successful candidate had better experience.

08 August 2014

Maps in Tableau 8.2 - street level

There're new maps in Tableau 8.2. Now you can choose between Tableau (the new maps) and Tableau Classic (the old ones, not medieval maps but just from 8.1 version).


06 August 2014

Tableau Mapping Template for London Boroughs

Feel free to use this template in your Tableau projects, just remember about placing the information about the owner of the original shape file.

You can check Tableau template for London wards too.

Tableau Mapping Template for London Wards

If you've searched for a Tableau mapping template for London, you can stop googling :) If you need other templates for the UK, you should check http://tableaumapping.bi

Tableau Mapping is a website where Tableau users share their maps created from open shape files, feel free to join them. Situation with shape files is complex as only in some countries the Statistics Offices publish them for free, so if you spot such file it's worth to give the link to Tableau Mapping.

26 June 2014

Devil's tooltip (ubertip) in Tableau

The official name of this tooltip's the ubertip, but the devil's tooltip shows its real nature.


Ubertips appear after clicking on row or column headers, when clicking on a mark or data item in the view, they don't appear.


15 June 2014

Simplifying shapefiles in MapShaper

Maps should be simple, simple to make and simple to use.

I simplify shape files to use them in Tableau but you can use them in other apps too.

Why should you do this?

Speaking in simple words Tableau draws maps by joining nodes with lines in order given by ShapeToTab. If there are many nodes Tableau has to work harder and performs slower. Besides that it is a great way of spending free time :)

==============================================
Here you can learn what simplifying geometries of shape files is.
==============================================

11 June 2014

Arithmeum, part 1

I am planning to add a few posts about data in the real world, yes life and data also exist outside the internet. I have no idea how I will achieve this as I do not go out so often. Keep your fingers crossed :) 

If you are into a data analysis, you have argued with your data more than once. Pieces of data software have made you crazy. Be honest, you have insulted Excel or any other application. After reading this magical blog post you will appreciate modern data programs. You will purr like a kitty thinking of calculating on your computer.


I have visited Arithmeum, a museum devoted to calculating methods and machines. It is placed in Bonn, Germany

Население наиболее многочисленных национальностей по субъектам Российской Федерации

Если тебе интересна эта тема тоже стоит посмотреть эту визуализацию данных.
Я сравнила данные с переписи населения 2010 года с 1926 годом.


English version is here.