Legacy Points with Layers

Updated 1 month ago by Phil Vu

As stated on the Data Download  tutorial, the Points with Layer Data feature is the unique ability to find the geography and data in which an address sits. For our advanced GIS users, this will join an address to a geography and give the FIPS code and data for that geography.

Let’s start with something easy. We want to find a list of high schools which are in school districts with the highest graduation rates in Oregon.

  • On the Maps page, add Graduation Rate from the Education tab
  • Then add Public Schools points data also from the Education tab
    1. • Filter the school points so that only high schools are shown
  • public-schools-filter-2
  • Select the Data Download icon
  • Select Points with Layers which should state, “Graduation Rate for Public Schools…”
    graduation-rates-and-high-schools2
    1. • Select Next to Step 2
  • In Step 2, if you had Oregon located on the map, then it will be listed in Pre-Defined Location, otherwise;
    1. • Use the Change or Add buttons to add Oregon
    2. • Select the drop down menu for a location to determine what geography (called Shaded By) to download for. In our example, Graduation Rates are only available by School Districts
    graduation-rates-and-high-schools-shade-by2
    1. • Select Next to Step 3
  • The confirmation sentence now states that you are downloading “graduation data” in “2009-2010” for “public schools” by “school districts” in the “state of Oregon”.
    graduation-rates-and-high-schools-confirmation2
    1. • Select Download CSV
  • Selecting Download CSV will send an email to you with a CSV (comma separated value) file that can opened in Excel. This will also save a copy of this file in your My Saved Work
    1. • The file will show each high school with the school district and graduation rate for the districts.
graduation-rates-and-high-schools-results


In our next example, let’s say you want to find the Congressional Member who represents each university in Virginia.

  • Load 4-Year Colleges and Universities from the Education tab
  • Then load any data layer which has Congressional district aggregation, most Census has this aggregation, so select Population from the Demographics tab
    1. Why are you loading population data when you only care about Congressional Districts? Because the Points with Layer feature requires a data layer for it to work
    2. • Select the Data Download icon
  • Select the Points with Layer option which should state, “Population data for 4-Year Colleges and Universities”
    congressional-districts-step-1
    1. • Select Next to Step 2
  • In Step 2, if you had Virginia located on the map, then it will be listed in the Pre-Defined Locations, otherwise;
    1. • Use the Change or Add buttons to add a location
    2. • The drop down menu for a location will determine what geography to download data for. For our example, we will select Congressional Districts
    congressional-districts-step-2
    1. • Select Next to Step 3
  • The confirmation sentence will state that you are downloading; the “population” data from the “2010-2014” ACS for “Colleges and Universities” in “Congressional Districts” for “Virginia”.
  • congressional-districts-step-3
  • Selecting Download CSV will send an email to you with a CSV (comma separated value) file that can opened in Excel. This will also save a copy of this file in your My Saved work
    1. • This file will display all the addresses in each row, while also the congressional District, the location (Virginia) which the file was generated for, and the population of district
    2. • Leaving the population numbers aside, you now have a list of all universities in Virginia and the Congressional District the school is in
congressional-districts-step-results-2


Finally, and probably one of the main reasons why we wanted to create the Points with Layer feature, users that want to determine which addresses in their investment portfolio are in locations that are eligible for a federal program.

* Make sure your dataset has been uploaded using the Data Loader

  • Add your dataset onto the map from the My Data tab
  • Add an eligibility data layer for a federal program
    1. • We will use the CDFI Fund’s New Markets Tax Credit program under Federal Guidelines
  • Select the Data Download icon
  • Select Points with Layer which should state, “NMTC Program Eligibility data for [dataset name]”
    nmtc-step-1-3
    1. • Select Next to Step 2
  • Use the Add or Change button to find the state or area that your dataset is contained in.
    1. • New Markets data is only available at the Census Tract level
    nmtc-step-2-2
    1. • Select Next to Step 3
  • The confirmation sentence will now state that you are downloading; “New Markets Tax Credit eligible tracts” for “CY 2015”, for your dataset, “by tracts” and in the state or location you selected.
  • nmtc-step-3
  • The emailed CSV will show the Census Tract, the FIPS ID, if it’s eligible for New Markets, and the rest of your address data.

 

These are just a handful of examples that you can use the Points with Layer feature for. With over 37,000 data layers and hundreds of thousands of address, the combinations are endless. We hope this tutorial gives you some ideas on how to use the unique Points with Layer feature.

If you have any questions or want to lean more, visit our training calendar and attend a free session or contact us at any time.


How did we do?