tag:blogger.com,1999:blog-57934767436157641342024-03-01T20:50:41.183-08:00RUSSIAN SPHINXOn this blog I publish charts, maps, data visualizations and provide links to interesting sources of data around the web. I am interested in Russia and the CISRussian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.comBlogger112125tag:blogger.com,1999:blog-5793476743615764134.post-49566642945055141882018-05-11T13:38:00.001-07:002018-05-11T13:42:03.012-07:00Talend Data Preparation – Tutorial – Part 1<!--[if gte mso 9]>
<![endif]--><!--[if gte mso 9]>
Normal
0
21
false
false
false
DE
X-NONE
X-NONE
<![endif]--><!--[if gte mso 9]>
Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-26594266220289230132015-12-11T10:08:00.000-08:002015-12-14T08:54:49.082-08:00Ausländer in Deutschland
Ich habe Daten über in Deutschland ansässige Ausländer gefunden. Solche Daten gibt es schon seit langer Zeit, denn Deutschland hat mindestens seit dem Mittelalter das „Meldewesen“: alle müssen sich in der Stadt, in der sie wohnen, melden, auch die Deutschen – einfach so vor sich hin leben geht nicht!
Aus diesen Daten habe ich eine Visualisierung gebastelt. Vieles daran kann man sich Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-36630565857716549842015-03-22T11:04:00.002-07:002015-03-22T11:04:50.799-07:00Energy from renewable sources in the EUEurostat has published statistics on renewable energy sources in the European Union.
Below my data visualization showing how countries are dealing with their energy targets.
Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-80680931309100217842015-03-09T07:02:00.003-07:002015-03-09T07:02:58.944-07:00German food mappedYou don't need any geo software to produce a map, a cupboard is perfectly enough.
Some time ago I've found in museum of Haus der Geschichte in Bonn this map of German local food specialties. The map is fully interactive, you can open each part to check what is inside. No computer, no programming involved and a nice interactive map was created.
(You can click on the photos to enlarge them, yes Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-3545251051459401472015-01-16T02:29:00.000-08:002015-01-16T03:07:51.517-08:00Free data journalism tools - data extracting and cleaning
Extracting data from PDF
There are plenty of people who strongly believe that the best place for their data is PDF, everyone does it, statistical offices, international organizations. There is only one reason behind it, their pleasure, yes they find it pleasurable to imagine people who try to extract their data from PDF.
OK the reality is a bit different the format was created to present Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-109792280907289922014-12-10T03:24:00.001-08:002014-12-10T03:25:07.851-08:00Free data journalism tools - time linesThis 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, youRussian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-87717486955561962852014-12-09T05:10:00.003-08:002014-12-09T05:12:20.892-08:00Creating and saving path as KML file in Google EarthYou 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.
// Please select Settings => Quality => 720p HD and Full Screen at the bottom of the youtube film for your own comfort and mental stability, Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com1tag:blogger.com,1999:blog-5793476743615764134.post-23681036509626584722014-12-03T05:36:00.000-08:002014-12-04T05:01:25.194-08:00How 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 Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-73996346887786206772014-11-25T10:36:00.002-08:002014-11-25T10:36:39.188-08:00Shape file directoryIt'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 Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-91827951271253277752014-11-18T05:14:00.000-08:002014-11-18T05:30:16.862-08:00Велодорожки Москвы / Cycle lanes of MoscowПортал открытых данных правительства Москвы опубликовал географические координаты московских велодорожек.
Общая длина велодорожек состоит 111 км. Самая длинная велодорожка находится в парке «Лосиный Остров».
Я хотела сделать карту поинтереснее и добавить другие данные к велосипедным геоданным, но не нашла ничего подходящего.
На моей карте можно включить Street View чтобы увидеть фотографии.
===Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-8379155518615748552014-11-17T01:09:00.000-08:002014-11-17T01:17:17.556-08:00Reshaping 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 Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-604161531209370142014-11-10T05:14:00.001-08:002014-11-10T10:30:46.302-08:00Something 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 Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-45740488731111119142014-11-06T07:38:00.001-08:002014-11-06T09:42:22.592-08:00Simplifying 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.
==============================================
SimpliPy was successfully Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-13150956911202341162014-11-05T00:40:00.000-08:002014-11-12T13:49:24.563-08:00How 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.
The biggest growth of the population
was caused by discovering oil. Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-3972224336565806412014-10-28T07:20:00.000-07:002014-11-17T06:09:45.449-08:00Cycling in LondonI'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.
There'sRussian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-6006809125191680602014-10-24T04:34:00.000-07:002014-10-24T04:34:22.426-07:00Simplifying 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.
Polygons are drawn by joining vertices
by lines. Simplifying them means getting rid of some vertices. As you
can see on the image, it slightly changes
shape of the polygon.
Many shape files consists of
big Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-54394128295489439052014-10-20T09:57:00.000-07:002014-10-20T09:57:22.506-07:00How to export a point shape file to csv in QGIS
A point shape file in QGIS looks like
this:
This tutorial can't be used for a line shape file or...
...polygon one.
Open your shape file in QGIS:
Right click on layer and select Open
Attribute Table...
Enable editing.
Open the field calculator by clicking
on the icon with an abacus :)
Double-click on the $x in Geometry and give a name to theRussian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-75817873877016619062014-08-08T03:15:00.000-07:002014-08-08T03:15:26.359-07:00Maps in Tableau 8.2 - street levelThere'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).
You switch between the two options here:
Enter Map Options to get a variety of choices that will blow your mind (hmmm not so many but still useful and worth checking).
Tick the Streets and Highways box.
Compare the maps Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-30157021249849055682014-08-06T13:14:00.001-07:002014-08-06T13:14:51.910-07:00Tableau Mapping Template for London BoroughsFeel 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.
Learn About Tableau
Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-27782331925085166722014-08-06T13:01:00.000-07:002014-08-07T05:18:53.306-07:00Tableau Mapping Template for London WardsIf 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 forRussian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-44460679918474880522014-06-26T09:43:00.000-07:002014-06-26T09:44:10.807-07:00Devil'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.
Let's analyse this example.
After clicking on the text in the
heading, the tooltip pops up.
&Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com2tag:blogger.com,1999:blog-5793476743615764134.post-9233681595533147292014-06-15T03:23:00.001-07:002014-12-10T04:30:06.887-08:00Simplifying 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 freeRussian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com2tag:blogger.com,1999:blog-5793476743615764134.post-11765522049963673882014-06-11T13:28:00.000-07:002014-06-11T13:29:46.926-07:00Arithmeum, 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 Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-54086889844083355572014-06-11T12:02:00.000-07:002014-06-11T12:03:39.599-07:00Население наиболее многочисленных национальностей по субъектам Российской Федерации
Если тебе интересна
эта тема тоже стоит посмотреть эту визуализацию данных.
Я сравнила данные с
переписи населения 2010 года с 1926 годом.
English version is here.
Learn About Tableau
Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0tag:blogger.com,1999:blog-5793476743615764134.post-78800159467454104962014-05-25T10:38:00.000-07:002014-06-11T11:29:45.415-07:00Poor diet
I've decided to spend one
week living on the edge of poverty to get the data
for the Tableau's Quantified Self Viz Contest. My food budget
was $2.35 per day (it's
calculated by government organization), I stayed in Poland so
prices are from there.
Learn About Tableau
It's
impossible to create a good diet with such
budget and any social campaignes promoting healthy food wouldn't
Russian Sphinxhttp://www.blogger.com/profile/17187348086686401548noreply@blogger.com0