Tuesday, June 27, 2017

2016 Census – here comes the data!

Tuesday 27 of June 2017 is the official release date of 2016 Census data. The first batch of information contains a comprehensive list of demographic and socio-economic topics for areas down to local neighbourhood level.

The ABS Census of Population and Housing is conducted every five years and provides a comprehensive picture of Australia's people, how they live and where they reside. The information collected during the Census is used to distribute government funds and plan services for the community – including those relating to housing, transport, education, industry, hospitals and the environment.

Census data is also used by individuals and organisations in the public and private sectors to make informed decisions on policy and planning issues that impact the lives of all Australians. And of course, Census data is also a valuable source of statistics for research and data analysis in support of business activities as it provides comprehensive information on potential customers and markets.

MapDeck will be adding the 2016 Census data to its inventory progressively from the day of its official release, starting with free excerpts of statistics for Postal Areas.

All relevant Census 2016 related statistical geography is already available on MapDeck for immediate perusal. This includes, for example, Mesh Blocks, the smallest statistical geography units and building blocks for all other larger structures, like suburbs or postal and local government areas, etc.

A unique feature of Mesh Blocks is that each one is classified according to a dominant use of the area, like residential, parkland, education, commercial, etc. This makes it possible to use mesh blocks to create simple maps of land use, as the one below for the ACT.




Imagine the possibilities… Sign up for free MapDeck account today (your invite code is: c3df6244 )!


Map: ACT Mesh Blocks by Category, 2017

 

Tuesday, April 11, 2017

Small area population estimates for Australia

The Australian Bureau of Statistics has recently updated its population estimates for Statistical Areas Level 2. This data set tracks 25 years of population changes in Australia back to 1991. The data is current as at 30 June 2016.

The Estimated Resident Population data set can be considered a prelude to the upcoming 2016 Census data release in late June 2017. It is still based on the 2011 edition of the Australian Statistical Geography Standard (ASGS2011) so, the figures for the SA2 areas will differ from the 2016 Census data, but ERP data is a good proxy of what to expect.

According to the ABS estimates, in 2016 there were 24,128,876 individuals residing in Australia, with the majority of people settled along the coast line. An interesting pattern of change over time is that, while the population in coastal areas continues to grow, there is long term depopulation occurring in the red centre - as depicted by blue polygons on the map below.

Population change 1991-2016 (blue - decline; orange and red - increase)


However, there is a notable positive change in the population of the Northern Australia, with some areas close to doubling its population in the last 25 years.

While population density in coastal areas has increased significantly over time, population growth is not uniformly distributed. Zooming in on capital cities allows pinpointing which areas have grown faster than the others.

For example, in the case of Sydney, the areas that stand out include Sydney City – Pyrmont – Ultimo, with a growth factor of around 9 (where 1 = no change and values below 1 indicate decline in population).

But the highest growth factor of 37.5 was recorded in Glenwood in the North West, followed by Parklea - Kellyville Ridge with 21.0 and Hoxton Park - Horningsea Park with growth factor of 12.7 over the last 25 years.

Population change by Statistical Area Level 2 (SA2)

An interactive map featuring several more data layers can be explored on MapDeck.com (please use this code to create a free account: c3df6244).

MapDeck.com Products List:
Population Estimates by SA2, Australia 2016 (free data table)
Population Estimates by LGA, Australia 2016 (free data table)
Estimated Resident Population 1991-2016 (free interactive map)




Thursday, March 30, 2017

2016 Census Data is Coming!

On Tuesday 11 April 2017 the Australian Bureau of Statistics (ABS) will release a teaser, or snapshot if you like, of what attributes make up a ‘typical’ Australian in 2016. This information will only be available at the national and state/territory level. The first detailed 2016 Australian Census data will be officially released on Tuesday, 27 June 2017.

In preparation for this occasion, MapDeck.com is making its 2011 version of the Basic Community Profiles for Postal Areas dataset freely available. This free data release gives MapDeck.com users a chance to experience its unique capabilities of custom-map creation and personalised in-map analytics – and get ready for the avalanche of information that will be published in coming months!

It is a “big data set about small areas” - in total there are 7,942 individual data items, spread across 66 tables, which can all be used for mapping. There is also a companion data set in Excel format which helps explain the structure of the data and what is specifically available in individual tables.

Postal Area Boundaries 2011 and 2016 are already available for free perusal on the MapDeck.com platform and both versions can be conveniently compared on the Australian Postcodes map.

Below you will find links to several public maps - they are published as examples of what can be created with MapDeck’s Thematic Mapper app:

Population by Postal Areas, Australia 2011
Dwellings by Postal Areas, Australia 2011
Selected Averages by Postal Areas, Australia 2011


Proportions of females to males by Postal Area, 2011


And you can experience the full in-map analytical capabilities and create private maps by subscribing to the Thematic Mapper app for 30 days for just a U$100 (thereafter, any maps you create can be viewed with free Thematic Mapper Basic app). 

Learn how to create a map by following these few simple steps (login required): How to create maps with coloured polygons in Thematic Mapper


Get the tools ready! Brash up on map making skills and start analysing the data for better decisions!

Your invitation code to create a free MapDeck.com account is: c3df6244

Tuesday, March 7, 2017

Dissecting Australian Property Investors

Is Sydney the epicentre of property speculation in Australia? ATO data provides a surprising answer…

A lot has been said about Sydney property investors in recent years, mostly in derogatory terms. Commentators usually criticise their financial irresponsibility, or even sheer madness, for “piling into the residential property market with excessive leverage” - something which is said to inevitably end badly for each and every one of them. But are these opinions justified?

The Australian Taxation Office (ATO) data summary of 2013-14 individual tax returns for postcodes, the latest available, paints a surprisingly different picture.

In particular, it is true that property investment is quite popular amongst Sydneysiders. This is clearly illustrated on the following map - purple shaded polygons mark postcodes with the above average proportions of property investors amongst the residents, comparing to figures for Australia as the whole.

Postcodes with the above average proportions of property investors, 2013-14
Source: Australian Investor Profiles by MapDeck.com

However, the big surprise revealed in the ATO data is that a significant proportion of Sydney-based property investors are actually netting hard cash from renting out residential properties. That is, their residential property portfolios are not negatively geared at all!

The following map points out postcodes in the Greater Sydney area with a positive average net rental income per investor. There are quite a few of them. So, it turns out, Sydney-based property investors are not leveraged to the hilt en masse as is commonly assumed.

Postcodes with a positive average net rental income per investor, 2013-14
Source: Australian Investor Profiles by MapDeck.com

There are actually only a handful of postcodes in Greater Sydney with residents who very aggressively gear their investment property portfolios. That is, postcodes which have above average proportions of property investors, and where residents report rental losses at above the national average level. These are marked on the following map as areas with red background.

Property investors by Postcode 2013-14
Source: Australian Investor Profiles by MapDeck.com

And of those, there are only six postcodes where 6,268 property investors (out of the total of 2,672,004 taxpayers counted in the Greater Sydney area) potentially fit the common stereotype of a property speculator. That is, property investors residing in these postcodes invest in rental properties in above average proportions comparing to the national average and have no or very limited other investments (i.e. are categorised as “Property Centric” investors). AND, at the same time, they are also highly leveraged (i.e. report above average rental losses to the ATO).

These are postcodes 2745, 2768, 2769, 2171, 2173 and 2231 - marked on the map as red polygons with black horizontal stripes.

Concluding, it is very unlikely that things have changed dramatically in the last two and a half years. So claims of irresponsible, mass scale residential property speculation by Sydneysiders are rather exaggerated. In fact, it appears that quite the opposite is true.

Only aggregated data is available for analysis, nevertheless, it suggests that large proportions of Sydney-based taxpayers are playing very safely with residential property investments and are generally diversified into several investment classes, including shares, cash and equivalent.

A full set of ATO statistics for postcodes, with extended investor profile information, has been published by MapDeck.com and is accessible online.

===========

About MapDeck

MapDeck empowers individuals and organisations to make better choices and more informed decisions. By providing easy access to a wealth of statistical information and simple to use location intelligence tools we help our clients in reaching their goals sooner, succeeding faster and on a grander scale.

Invitation code: c3df6244 for a free service.

Friday, December 16, 2016

Australian generosity mapped – how charitable are we really?

Many Australians are happy to give a helping hand to various worthy causes throughout the year. Indeed, each year Australians hand over an impressive $2+ billion in tax deductible gifts and donations, and probably a bit extra in non-declared funds. But collectively, are we as generous as we claim to be? The facts may surprise you.

A new analysis of 2013-14 taxation data by MapDeck.com sheds some very interesting light on the donations habits of Australians. It provides a detailed picture of charitable donations made across neighbourhoods of our eight capital cities: Adelaide, Brisbane, Canberra, Darwin, Hobart, Melbourne, Perth and Sydney. MapDeck also provides a State/Territory specific view of donations for cross-border comparisons.

Looking at the findings first at a national level, it is encouraging that almost one in three Australian taxpayers is actively donating money for charitable purposes. However, a significant proportion of donations – amounting to 37% of the value of all donations – come from only 5.3% of taxpayers. These taxpayers live in 195 postcodes around Australia categorised as the ‘most generous’ in terms of the rate of donations per local population, as well as the average value of donations. In the 2013/14 tax year, these 677,093 individual donors collectively contributed a billion dollars for charitable purposes (or, on average, $1,416 per donor).


The remaining 3.8 million donors provided $1.6 billion of the total $2.6 billion donated that year (or, on average, $424 per donor). In addition, the fact remains that almost 8.3 million taxpayers (or 65% of all Australian taxpayers) reported no donations at all. So, it appears that Australians are not so charitable after all…

The level of generosity of donors differs significantly from one location to another. So, where do the most generous Australians live?


New South Wales was the state with the highest number of donors (1.45 million) but Victoria was not far behind, with just over 1.2 million. Interestingly however, the generosity of NSW donors far exceed that of Victorians – NSW residents donated $1 billion that year, a whopping 45% more than Victorians.

The average value of donations per donor was $707 in NSW and only $571 in Victoria. However, 38% of Victorian taxpayers made tax deductible donations, comparing to only 36% of NSW taxpayers. So, while NSW donors appear more generous, donating for charitable purposes is slightly more prevalent among Victorian taxpayers.

With exception of the ACT, the rate of donation and average values per donor for the other States and Territories are substantially below the two most populous Australian states.

Given the distribution of the Australian population, it is not surprising that almost 82% of all donations come from capital-city residents. The average donation per capital city resident was $655 in 2013/14, comparing to an average of $573 for all Australian donors.

On a city by city level, close to 40% of all gifts and donations reported to ATO in the 2013/14 financial year came from Sydney residents ($848 million), while residents of Melbourne contributed only 27%, or just over $607 million. Sydney, Melbourne and Brisbane accounted for a combined total of 80% of reported gifts and donations, while the remaining five capital cities made up only 20% of the overall sum.


Sydney-based donors contributed on average $872 in gifts and donations in 2013/14, and were followed by Melbourne and Canberra donors with average donations per donor of $638 and $603 respectively.


But which of our Australian capital cities has the most engaged community in terms of contributions to charitable causes? It turns out it is Canberra - the nation’s capital, filled with hardworking public servants and households with the highest average incomes. The city had the most generous population with 45% all tax paying individuals reporting gifts or donations on their statements. This compares to 39% for Melbourne taxpayers and just 36% in the case of Sydney taxpayers.

Hobart stands out amongst the smaller cities with 38% of taxpayers making tax deductible gifts and donations. Brisbane with Gold Coast and Perth closed the list at 33% each.

Putting the data published by the ATO through a slightly more advanced analysis can reveal even deeper insights about the generosity of Australians. For example, by comparing gifts and donations claimed by individual postcodes with averages for capital cities or Australia as a whole, it is possible to create a simple classification that reflects common patterns of behaviour across local communities.

Looking more specifically at the four categories of donors, of the most generous donors (that is, those that donate above average amounts and in above average proportions comparing to the national average) 42% live in NSW. Out of the 677,000 most generous Australian taxpayers, this amounts to a total of 287,000 individuals. Only 30% of the most generous donors, or 204,000 individuals, are located in Victoria.


However, 40% of the second most generous group of donors (that is, those who contribute at higher than average rates but tend to donate below average amounts) are from Victoria. NSW has only 34% of all donors in this category.

Without trying to fuel the animosity between the two states any further, this seems to be a typical pattern that distinguishes NSW residents from Victorians across several measures analysed in this study. That is, when NSW residents, and Sydneysiders in particular, decide to give, they give generously. Much more generously than residents of any other capital city or State or Territory in Australia. However, donating to charitable causes is more widespread amongst the population of Victoria.

Nevertheless, it is interesting to note that the postcode with the highest donation per donor was actually in Greater Melbourne area: it is 3944 (Portsea) with an average donation per donor of a whopping $19,187. Sydney postcode 2027 (covering the exclusive suburbs of Darling Point and Point Piper) with an average donation of $14,180 per donor is only third on the list - after Brisbane postcode of 4009 (Eagle Farm) with average donation of $18,490.


The following maps show how average donations compared across Greater Melbourne and Greater Sydney postcodes.


Map 1: Average Donations by Postcode – Greater Sydney, FY13/14


Map 2: Average Donations by Postcode – Greater Melbourne, FY13/14

The richness of information contained in this ATO data also makes it possible to investigate some more controversial aspects of our generosity. For example, pinpointing postcodes where residents earn the most but donate very little. There could be many colourful ways of describing the residents of such postcodes but, for the purposes of this article, let’s use a less judgemental label for them, such as “Well-to-do non-participants”. Which State or Territory do you think has the most residents in this category?

Log into your MapDeck.com account and find out!  A full deck of interactive maps is accessible to all registered MapDeck users via the links listed below. You will need this invitation code to create a free account if you are not yet a MapDeck user: f10dc1f2 .

And if you wish to explore the entire Generosity Profile of Taxpayers by Postcode, Australia 2014 data set and draw your own conclusions, or if you would just like to identify where those 195 postcodes with the most generous donors are located, it is available for a small fee for download in Microsoft Excel format and/or as a subscription for use with MapDeck’s Thematic Mapper app.

Implying that “Australians are charitable folks” would be an overstatement - the evidence summarised in this article points rather to the contrary. True, Australians are one nation but we tend to differ quite significantly as individuals, including how generous we are with gifts and charitable donations. However, not to affront our national pride, let’s draw the final conclusion borrowing from George Orwell’s famous quote. That is: it is quite likely all Australians are charitable by nature but some of us are more charitable in practice then others.


About Generosity Profile of Australian Taxpayers

The profiles area based on the Australian Taxation Office statistics for residential postcodes sourced from 2014 individual income tax returns processed by 31 October 2015. The statistics are not necessarily complete.

The information can be used for marketing and promotional purposes, or for profiling existing or prospective customers based on their place of residence.

Map (free):  Gifts and Donations by Individuals, Australia 2013-14
Map (free):  Gifts and Donations: Well-to-do Non-participants, Australia 2014
Data (free): ATO Gifts and Donations by Individuals, Australia 2014
Data (paid download): Generosity Profile Table, Postcodes, Australia 2014
Data (paid subscription): Generosity Profile of Taxpayers by Postcode, Australia 2014


About MapDeck:

MapDeck’s mission is to empower individuals and organisations to make better choices, more informed decisions – so they can reach their goals sooner, succeed faster and on a grander scale.

MapDeck is an online marketplace for spatial information and simple-to-use, task-oriented tools to support a variety of activities, be it business or investment related, environmental, community or policy focused.


Monday, November 28, 2016

Do the rich always get richer?

Let’s tackle this controversial topic as an example of how thematic maps and simple in-map analysis can bring clarity when dealing with complex issues or situations. 

'The rich get richer and the poor get poorer' is a common catchphrase that is often evoked in discussions about economic inequality. However, is this a true reflection of reality or just a widely held belief that is taken at face value? How do we tell?

It would probably take a few months to fully investigate all the factors that play a role in the complex issue of wealth concentration and to formulate a solid argument which could withstand full academic scrutiny.

However, as often happens in real life, we rarely have the necessary resources at our disposal, or the time, to do extensive research to get to the bottom of the issues we encounter. Therefore, a credible, quickly-determinable clue as to what that answer may be, and which allows us to make a more informed decision, is very often the most practical approach.

Map Deck's newly released Thematic Mapper app - with a unique in-map analytics functionality - offers everyone, even the most novice users, a simple solution that can aid in the search for answers to complex questions. Let’s explore how…

To begin our analysis we need information on the wealth of individuals, as well as statistics on how that wealth is changing over time.

Data on taxable incomes for postcodes for 2003–04 and 2013–14 income years, published by the Australian Taxation Office (ATO) and available for free perusal with MapDeck apps, is a good proxy. This information will give us an opportunity to test whether this widely held belief about rich getting always richer holds true in a spatial context. And in the process, we will also demonstrate how simple mapping tools can provide a reasonable answer - and quickly.

Distribution of taxable incomes (deciles) by postal areas - Adelaide [click to enlarge]

The objective here is to test if top taxable incomes grow consistently at or above the growth rate of taxable incomes of the entire population of Australian taxpayers.

If yes, then this would indicate that wealth of the richest individuals is increasing faster than wealth of the rest of the population and consequently, that poorer people are becoming relatively poorer over time. This is a simple argument but proving or disproving it will be enough to give us a strong clue as to the likely conclusions that would be obtained from more thorough research.

Change in taxable incomes over a decade to 2013-14 - Adelaide [click to enlarge]

It is always a good idea to clearly articulate assumptions and to identify limitations of the data you work with as it is not always possible to have the best and the most accurate information on hand for analysis.

In this case, for example, we defined “the rich” as taxpayers residing in postcodes with median taxable incomes in the top 10% in 2003-4 and in 2013-14.

The limitation of this approach is that we are looking only at the incomes and not the overall wealth of individuals. However, taxable incomes are a reasonable proxy for wealth. That is, wealth usually generates an income stream and even if only a part of that income is attributable to an individual, for example, due to the use of various tax minimisation schemes, growing wealth will be reflected in the growth of taxable incomes of those individuals.

We also assume here that residents of any given postcode are all alike which is an oversimplification but not an unreasonable one. In particular, it is true that postcodes comprise of populations with varying demographic and socio-economic status but summarising their collective characteristics into a single measure is an acceptable practice in data analysis. Therefore, a change in median taxable income for a postcode is a good representation of the change in wealth of its residents.

More of an issue is the fact that we are assuming that the 2016 postcode boundaries are exactly the same as those in 2013-14 and in 2003-04. However, yet again, this is a reasonable assumption since postcodes with the top taxable incomes are predominantly in capital cities and capital city postcodes remain relatively stable over time.

More assumptions and caveats could be listed but the main point here is the importance of being aware of the limitation of the data you are working with. It applies to any data and information, not only to that with spatial context.

It takes just a few moments to set up a map ready for analysis using MapDeck’s Thematic Mapper app. Firstly, we select and import into Thematic Mapper the postcode boundaries and ATO data, then join them using the data mixer functionality.

Thematic Mapper: data mixer

We are interested in only 3 columns from the newly created table: the median taxable incomes for both 2003-4 and 2013-14, and the percent growth of median taxable incomes over the 10 year period. The information on the number of individual taxpayers per postcode is included just for context.

Selecting the “complex legend” option enables advanced data filtering functionality in Thematic Mapper. We set taxable income values to show the top 10% range only (these values are calculated and can be looked up when setting up legend styles for individual data sets from our table).

The last step is to remove empty postcodes from the map (that is, those with no data) and to import a map overlay showing main roads and localities to give our map additional spatial context (the Stamen’s Hybrid layer in this case).

Let’s now review the map, summarise the data and draw some conclusions.

From the map legend we know that:

  • Top deciles of median taxable income were $33,503 to $68,017 in 2003-4 and $51,128 to $113,687 in 2013-14;
  • Median taxable incomes for individual postcodes grew between 7% and 257% over a decade to 2013-14;
  • Median growth in median taxable incomes was 50% (that is, in half of postcodes, median taxable incomes grew by less than 50% in the 10 year period and in the other half the growth was equal to, or greater than, 50% -  therefore the 50% growth rate can be used as a national benchmark for further comparisons). 
Growth in median taxable incomes 2003-04 to 2013-14, top income decile - Perth [click to enlarge]
Growth in median taxable incomes 2003-04 to 2013-14, top income decile - Brisbane [click to enlarge]
The pattern we were looking for (that is, where all top postcodes are coloured in shades of green, indicating growth rates over 50%) is present on both the Perth and Brisbane maps but not on the Melbourne or Sydney maps. Therefore, we can conclude with confidence that it is not entirely true that the rich are getting richer and the poor are getting poorer all the time and in every place.

Growth in median taxable incomes 2003-04 to 2013-14, top income decile - Sydney [click to enlarge]
Growth in median taxable incomes 2003-04 to 2013-14, top income decile - Melbourne [click to enlarge]

In other words, our data and simple in-map analysis indicate that some rich neighbourhoods grew their incomes at less than the national median rate, hence getting relatively ''poorer'' over time with respect to the rest of the population.

Of course, this is only a clue as to what conclusions may possibly be drawn from more thorough research. However, the point is that is takes very little effort to conduct this kind of analysis using MapDeck’s online app and huge range of available data. This approach is not suited for all situations but it can provide valuable insight, and fast, to adequately support many important every day decisions.

Median Taxable Incomes, Australia 2003-4 and 2013-14 map and ATO data table used in this case study are available for free perusal for registered MapDeck users.

And for a limited time, all MapDeck users have the opportunity to try Thematic Mapper at no cost. The app is available for a free one month subscription until 20 December. 

So, what is the big issue you would like to explore next? Use this invite code to sign up if you are not yet MapDeck user: f10dc1f2

About MapDeck:
MapDeck is an online marketplace for spatial information and simple-to-use, task-oriented tools to support a variety of activities, be it business or investment related, environment, community or policy focused.

We make spatial information and analysis ready data accessible to all. Locate, map, act!

Monday, November 21, 2016

Thematic Mapper for easy in-map analytics

The updated Thematic Mapper app, recently released on MapDeck.com's platform, unlocks in-map analytic capabilities for organisations of any size or budget.

Traditionally, access to spatial information, and the tools required for analysing and visualising that information, was restricted to only companies with substantial budgets. The two choices for an organisation were to either deploy a suitable infrastructure in-house and employ expert analysts, or alternatively, source specialist advice from external consultants.

Both these options have one thing in common - cost. We are talking about tens of thousands, and very often hundreds of thousands of dollars in annual expenditure. It's no surprise that many organisations could not afford location intelligence at these prices.

The arrival of cloud-based online mapping tools is changing all that, democratising access to vital information for everybody, even the smallest companies, as well as individuals.

Early adopters of cloud-based mapping solutions are realising enormous benefits - both monetary and strategic.

In particular, instant and on-demand access to inexpensive analytical tools and information (on any device) allows individuals at all levels in an organisation to take advantage of location intelligence while making important business decisions. This leads to better outcomes. 

And since better outcomes accumulate over time, it allows an organisation to reach its goals faster, more effectively, and with minimal expense. The benefits of using cloud-based mapping and spatial analysis tools are too good to remain the best kept secret for much longer.

With the release of the upgraded Thematic Mapper app MapDeck is taking the concept of in-map DIY spatial analytics to a whole new level.

Customised thematic map example

Thematic Mapper is an example of the new generation of online mapping tools which allow full personalisation of information content on maps. That is, unlike traditional online maps which require an administrator to configure for end users what data to display and how, Thematic Mapper gives each user full control over the entire map creation and map publishing/sharing process. It is a whole new approach to creating online maps.

Thematic Mapper users can now:
  • filter national and regional data to show just a selection of areas of interest, such as a single sales or franchise territory, retail catchment area, or a local neighbourhood;
  • combine public and private data, such as demographic statistics from Census surveys with company sales and customer data;
  • carry out in-map analysis on data and visualise results on maps and in summary tables;
  • customise presentation of information, from arrangement of preferred base maps and top overlays, to polygon styling according to personal preferences; and
  • publish or share privately all created content and information.

For a limited time, all MapDeck users have the opportunity to try Thematic Mapper at no cost. The app is available on a one month free subscription until 20 December 2016.

Use this invite code to sign up: f10dc1f2

About MapDeck:
MapDeck is an online marketplace for spatial information and simple-to-use, task-oriented tools to support a variety of activities, be it business or investment related, environmental, community or policy focused.

By collecting the most useful spatial data in one place, and providing simple tools to interact with it, MapDeck makes it easy for anybody to take advantage of location intelligence technology and to derive invaluable, personalised information for decision making.