depiction 101

January 26, 2016 Webinar Video now available online.

The video of the January 26th Webinar on merging tabular data with shape files is now available on our website. You can find it here. You can also download the powerpoint from the video here.

March 24th Webinar recording now available online.

The March 24th webinar covering the Add, Display and Manage menu options is now available here.

Depiction and the National Grid

During our webinar today one of the participants asked if Depiction was compatible with the USNG.  At the time I wasn’t sure what he was referring to.  He was kind enough to have an expert in its use drop me a line and point me to some resources. So here is what I have found out so far.  USNG stands for US National Grid system.  You can find a very complete description here.

The USNG is a based on the UTM coordinate system.  Depiction does have the ability to display locations in the UTM format.

Tools-Settings MenuIf you go to the Tools menu and choose settings and then click on the Coordinate format.  The UTM format is the 5th one down.

There is a website called the US National Grid Information center where you can find shape files for download.  However what I discovered was that these downloads have lots of data in them and you can’t have a depiction boundary too large and load one of these shape files because it can bring Depiction to its knees.  A couple of them I checked out had around 65,000 shapes. When I tried to load one of these for a large area it brought Depiction to its knees.  However, for smaller areas you are able to import the file.

Depiction displaying the National Grid

This Depiction area is 65 x 39 miles and has about 6600 shape elements.  Depiction was able to read it and display it but I noticed the program was a little sluggish. Especially when it had to display all 6600 shapes.  If you turn off the display of the shapes and display the shapes in a smaller revealer you will get much better performance. It is having to redraw those 6600 shapes everytime that you do something that causes the program to slow down.

So in order to use this go to the US National Grid Info Center web site.

US National grid web site

Choose the region you are interested in.

Choose the zone that covers your area of interest. Click on it and will start a download. Choose a location were you want the file to be downloaded. Once it is downloaded open the zip file and do an “extract all” and place the results in  a folder of your choosing.  Then start a depiction, keeping the size to around 2500 square miles or less. Then go to the add menu and choose the file option and browse to your folder.  Choose the file with the .SHP extension and auto detect for element type and click add and it will bring the file in.  When the shapes come in they are assigned random colors but if you want no color then you can go to the manage menu.  Select all of the shapes and choose edit. That will bring up this screen.

Depiction Manage - Edit Properties menu

scroll down to the ZOI Fill field and click on it which will bring up the color palate.  In the bottom right there is an option for no color. Choose that say apply and the colors will disappear.

Hope that will help those of you interested in the national grid.

Video of January 27th Webinar now available online.

The recording of the January 27th webinar on Depiction Basics and Tips on use is now available and can be found here.

September 30 Webinar recording now available.

The recording of the September 30, 2014 webinar on how to import 2010 census data shape files into Depiction is now available here.

New easier to use 2010 Census data now available

One of the ongoing challenges of using census data with depiction in the past was that you first had to import the census tract shape file and then export it and rename the geoid to EID and then reimport it. Then you had to find the census data by tract and change the GEOID to EID and then import it to merge with the shapes.  This was a fairly complicated and at times messy process.  In looking at the current CENSUS.GOV website, I discovered a file that has the census tract shapes along with lots of data for each census tract.

The url for the website is

You will need to click on the + next to Demographic Profile 1 — Shapefile Format to see the dropdown choices.

Then if you choose the census tracts option that is highlighted to the left, it will download a zip file ( that contains census tract shapes along with census data for the entire USA.  This is a large file 400mb.

You need to extract the file and when you get done you should have the following files in your chosen directory.

When you import this file into Depiction you want to choose the .shp file, the one that is 591mb!  Remember to chose the crop to boundary option.

If you don’t choose the crop to boundary box then you will be loading all 590mb of data and Depiction will crash.

For an experiment I loaded the file for the entire state of Washington which had about 1600+ census tracts and data. It took 1 minute and 8 seconds to load and display. However once it was loaded it was kind of sluggish and if you had other data as well, would be unpleasant to work with.  However, if you were working at a county or even several counties it should be OK.

This is what it looked like.

So the good news is that you can easily import this file for anywhere in the USA and get the census tract shapes as well as population data.  The bad news is that rather than have descriptive property names they chose to use codes.  They include a .xls file (DP_TableDescriptions.xls) that gives a legend for the codes.  It would be possible to export the file to a csv file and copy in the descriptive property names over the codes but would take a bit of effort.

However there is lots of data over 200 data elements.  I’m going to list this all at the end of this post for your information.

I haven’t fully explored the other files they list on the web site but it looks like there is lots of interesting data to be had, and I urge you to explore and see what you can find of interest.  If you find something of interest please share it on our support page.

Below are the data elements that are included in the file.

Universe:  Total population
DP0010001 Total:
DP0010002 Under 5 years
DP0010003 5 to 9 years
DP0010004 10 to 14 years
DP0010005 15 to 19 years
DP0010006 20 to 24 years
DP0010007 25 to 29 years
DP0010008 30 to 34 years
DP0010009 35 to 39 years
DP0010010 40 to 44 years
DP0010011 45 to 49 years
DP0010012 50 to 54 years
DP0010013 55 to 59 years
DP0010014 60 to 64 years
DP0010015 65 to 69 years
DP0010016 70 to 74 years
DP0010017 75 to 79 years
DP0010018 80 to 84 years
DP0010019 85 years and over
DP0010020 Male:
DP0010021 Under 5 years
DP0010022 5 to 9 years
DP0010023 10 to 14 years
DP0010024 15 to 19 years
DP0010025 20 to 24 years
DP0010026 25 to 29 years
DP0010027 30 to 34 years
DP0010028 35 to 39 years
DP0010029 40 to 44 years
DP0010030 45 to 49 years
DP0010031 50 to 54 years
DP0010032 55 to 59 years
DP0010033 60 to 64 years
DP0010034 65 to 69 years
DP0010035 70 to 74 years
DP0010036 75 to 79 years
DP0010037 80 to 84 years
DP0010038 85 years and over
DP0010039 Female:
DP0010040 Under 5 years
DP0010041 5 to 9 years
DP0010042 10 to 14 years
DP0010043 15 to 19 years
DP0010044 20 to 24 years
DP0010045 25 to 29 years
DP0010046 30 to 34 years
DP0010047 35 to 39 years
DP0010048 40 to 44 years
DP0010049 45 to 49 years
DP0010050 50 to 54 years
DP0010051 55 to 59 years
DP0010052 60 to 64 years
DP0010053 65 to 69 years
DP0010054 70 to 74 years
DP0010055 75 to 79 years
DP0010056 80 to 84 years
DP0010057 85 years and over
DPSF2.  MEDIAN AGE BY SEX [3]  (1 expressed decimal)
Universe:  Total population
Median age-
DP0020001 Both sexes
DP0020002 Male
DP0020003 Female
Universe: Population 16 years and over
DP0030001 Total:
DP0030002 Male
DP0030003 Female
Universe:  Population 18 years and over
DP0040001 Total:
DP0040002 Male
DP0040003 Female
Universe:  Population 21 years and over
DP0050001 Total:
DP0050002 Male
DP0050003 Female
Universe:  Population 62 years and over
DP0060001 Total:
DP0060002 Male
DP0060003 Female
Universe:  Population 65 years and over
DP0070001 Total:
DP0070002 Male
DP0070003 Female
DPSF8.  RACE [24]
Universe:  Total population
DP0080001 Total:
DP0080002 Population of one race:
DP0080003 White
DP0080004 Black or African American
DP0080005 American Indian and Alaska Native
DP0080006 Asian:
DP0080007 Asian Indian
DP0080008 Chinese
DP0080009 Filipino
DP0080010 Japanese
DP0080011 Korean
DP0080012 Vietnamese
DP0080013 Other Asian
DP0080014 Native Hawaiian and Other Pacific Islander:
DP0080015 Native Hawaiian
DP0080016 Guamanian or Chamorro
DP0080017 Samoan
DP0080018 Other Pacific Islander
DP0080019 Some Other Race
DP0080020 Population of Two or More Races
DP0080021 White; American Indian and Alaska Native
DP0080022 White; Asian
DP0080023 White; Black or African American
DP0080024 White; Some Other Race
Universe:  Total races tallied
DP0090001 White alone or in combination with one or more other races
DP0090002 Black or African American alone or in combination with one or more other races
DP0090003 American Indian and Alaska Native alone or in combination with one or more other races
DP0090004 Asian alone or in combination with one or more other races
DP0090005 Native Hawaiian and Other Pacific Islander alone or in combination with one or more other races
DP0090006 Some Other Race alone or in combination with one or more other races
Universe:  Total population
DP0100001 Total:
DP0100002 Hispanic or Latino (of any race):
DP0100003 Mexican
DP0100004 Puerto Rican
DP0100005 Cuban
DP0100006 Other Hispanic or Latino
DP0100007 Not Hispanic or Latino
Universe:  Total population
DP0110001 Total:
DP0110002 Hispanic or Latino:
DP0110003 White alone
DP0110004 Black or African American alone
DP0110005 American Indian and Alaska Native alone
DP0110006 Asian alone
DP0110007 Native Hawaiian and Other Pacific Islander alone
DP0110008 Some Other Race alone
DP0110009 Two or More Races
DP0110010 Not Hispanic or Latino:
DP0110011 White alone
DP0110012 Black or African American alone
DP0110013 American Indian and Alaska Native alone
DP0110014 Asian alone
DP0110015 Native Hawaiian and Other Pacific Islander alone
DP0110016 Some Other Race alone
DP0110017 Two or More Races
Universe:  Total population
DP0120001 Total:
DP0120002 In households:
DP0120003 Householder
DP0120004 Spouse
DP0120005 Child
DP0120006 Own child under 18 years
DP0120007 Other relatives
DP0120008 Under 18 years
DP0120009 65 years and over
DP0120010 Nonrelatives
DP0120011 Under 18 years
DP0120012 65 years and over
DP0120013 Unmarried partner
DP0120014 In group quarters:
DP0120015 Institutionalized population:
DP0120016 Male
DP0120017 Female
DP0120018 Noninstitutionalized population:
DP0120019 Male
DP0120020 Female
Universe:  Households
DP0130001 Total:
DP0130002 Family households (families)
DP0130003 With own children under 18 years
DP0130004 Husband-wife family
DP0130005 With own children under 18 years
DP0130006 Male householder, no wife present
DP0130007 With own children under 18 years
DP0130008 Female householder, no husband present
DP0130009 With own children under 18 years
DP0130010 Nonfamily households
DP0130011 Householder living alone:
DP0130012 Male
DP0130013 65 years and over
DP0130014 Female
DP0130015 65 years and over
Universe:  Households with individuals under 18 years
DP0140001 Total
Universe:  Households with individuals 65 years and over
DP0150001 Total
DPSF16.  AVERAGE HOUSEHOLD SIZE [1]  (2 expressed decimals)
Universe: Households
DP0160001 Average household size
DPSF17.  AVERAGE FAMILY SIZE [1]  (2 expressed decimals)
Universe:  Families
DP0170001 Average family size
Universe:  Total housing units
DP0180001 Total:
DP0180002 Occupied housing units
DP0180003 Vacant housing units:
DP0180004 For rent
DP0180005 Rented, not occupied
DP0180006 For sale only
DP0180007 Sold, not occupied
DP0180008 For seasonal, recreational, or occasional use
DP0180009 All other vacants
DPSF19.  HOMEOWNER VACANCY RATE [1] (1 expressed decimal)
Universe:  Owner-occupied, vacant for sale only, and vacant sold but not occupied housing units
DP0190001 Homeowner vacancy rate (percent)
DPSF20.  RENTAL VACANCY RATE [1] (1 expressed decimal)
Universe:  Renter-occupied, vacant for rent, and vacant rented but not occupied housing units
DP0200001 Rental vacancy rate (percent)
Universe:  Occupied housing units
DP0210001 Total:
DP0210002 Owner-occupied housing units
DP0210003 Renter-occupied housing units
Universe: Population in occupied housing units
DP0220001 Owner-occupied housing units
DP0220002 Renter-occupied housing units
Universe: Occupied housing units
Average household size-
DP0230001 Owner occupied
DP0230002 Renter occupied

June 24th Webinar video on using Shapefiles now available.

The June 24th Webinar on using Shapefiles with Depiction is now available here.

You can download the powerpoint .pdf used in the webinar here.

You can download the American Fact Finder quick user guide here.

I learned something from this webinar. In the past when editing the exported csv from a shapefile, I always used a spreadsheet program but there is a problem with this method in many cases because complex shapes will create more lat/long sets than can be contained in a single cell. This messes up the file and those shapes won’t be reimported.  However, a webinar attendee suggested using a text editor to edit it.  Not sure why I hadn’t thought of it but that solves the problem.  And since you are only changing one field in the first row from “some property name” to “EID” it is pretty simple to do.

May 28th Webinar recording now available.

The May 28th webinar which was a demo and Q&A about the Depiction version 2.0 is now available and can be found here.

February 25th Webinar Recording Now Available

If you missed the Depiction 101 session “Getting Started with Depiction – the Basics” you can now watch the recording on our website. You will find it here.

This webinar covered the following topics.

  • How to find info on the Depiction website,
  • Discussion of Add-ons/ Elements/Icons
  • How to ask for assistance or report a problem
  • Review some of the add-ons and icon packs that are available
  • How to download and install the software
  • How to find free data on the internet
  • Discuss some key concepts
  • How to start a depiction and add information to it.
  • Tips, Techniques and Best Practices when using Depiction

Red Cross Webinar now online.

The repeat webinar we did for Red Cross Chapters is now available online. Watch on our website or watch it on YouTube.  This showcases the capabilities of Depiction More than Mapping software.