Exporting Maps

When creating maps in CRA Wiz & Fair Lending Wiz with the installed map tool, users can both print and export their maps. In our digital world, users may prefer to export their maps to keep an electronic copy of the document. Once saved, these files can be easily added to documents and presentations.

This month’s Getting the Most Out of Wiz article will focus on utilizing the mapper to export maps. It will also include tips and tricks for adding polish to your maps.

How to export Map

  1. Create your desired map:

    Get the most out of Wiz
  2. In the upper left-hand corner or the Map window, click the File menu, then select Export…:

    Get the most out of Wiz
  3. In the Export Map As Image dialog box, select the file type that you would like to save it as. Note: Bitmap is the default option, but if you select the Save as type: menu, you will see a variety of file types to save your file. Wolters Kluwer recommends saving your map as a .jpeg file (Joint Photographics Experts Group Format(c)):

    Get the most out of Wiz
  4. Select a location where you want to save the file to, enter a file name, and click Save:

    Get the most out of Wiz

Enhancing Your Exported Maps

Adding Map Legends

A map legend is a great way to provide stakeholders with additional context for the map they are looking at. 

When exporting your map, you can add a legend to your map view that will be included in the exported map view.

To add a legend to your map, select the Tools menu then select Show Legend on Map:

Get the most out of Wiz

Get the most out of Wiz

Note:  When you have added the legend  to your map view, you  can select and move the legend to  the desired location.

Adding Text to Exported Maps

To add text or a title to your map, follow these steps:

  1. Click the Text button drop-down menu from the toolbar and then select Text Style:

    Get the most out of Wiz
  2. In the Text Style dialog box, select the font and style for the text you would like to add to your map, then click OK:

    Get the most out of Wiz
  3. Click in the area of your map where you would like to add text, then type the text you would like to add:

Example:
Sample Bank
2021 Atlanta Assessment Area

Get the most out of Wiz

Note:   Use the Select tool to select the text and move it (hold your left mouse button down and drag it) to the desired location on the map window:

Get the most out of Wiz

Get the most out of Wiz

Save Your Work

Once you have the template for your perfect map, make sure to save it so that next time you need it, you won’t have to create it from scratch!

Simply select Save Map As… from the File menu and in the resultant dialog box, enter a name for your saved map, then click the Save button:

Get the most out of Wiz Get the most out of Wiz

Analysis with OCC’s list of Distressed and Underserved Middle Income Census Tracts

On January 29th, 2021, the Office of the Comptroller of the Currency (OCC) released the Distressed and Underserved Middle income census tract listing:

https://www.occ.treas.gov/news-issuances/news-releases/2021/nr-occ-2021-16.html

Starting October 1st, 2020, any bank revitalization or stabilization activities in any one of these 6,588 Census Tracts will receive Community Reinvestment Act (CRA) consideration as a qualified activity.

This list will be updated annually and will be included as part of the annual Census update provided by Wolters Kluwer  You can find this list in the CRA Wiz Web Center as an MDB file. You can install this file into the Create Areas module of CRA Wiz and Fair Lending Wiz and then use the area in various ways including with custom tables, maps, and other analysis.

Download: OCC’s 2020 Distressed and Underserved Assessment Area for CRA Wiz & Fair Lending Wiz

Installing the Assessment Area

  1. Access Create Areas.
  2. Open the Saved Areas folder.
  3. Right-click in the white space below the list of saved areas.
  4. From the contextual menu, select Install….
  5. Install the OCC Distressed Underserved 2020 area.

Assign the OCC Distressed Underserved 2020 AA to a File

  1. Access Create Areas.
  2. Select the OCC Distressed Underserved 2020 assessment area.
  3. Right-click on the OCC Distressed Underserved 2020 entry and choose Assign Areas to File from the contextual menu.
  4. Select Clear previous assignments and then add.
  5. Select the file you want to run the report with.
  6. Click Open.

A message will indicate how many records were updated during this process – this should be the total number of records that fall within the distressed/underserved assessment area.

Create Custom tables

  1. Open the file you want to create the report with.
  2. Create a Custom Table with the following variables:
    • ROW - Assessment Area (located in the User Defined Folder)
    • COLUMN - Any other variable you would like to see displayed (ex.Action, Purpose, Tract Income Level, etc.)

    Note: You can also choose other options like using Display Subtotals.

  3. In the select Data Content Field, choose the following variables:
    • Count
    • Income (Count, Sum, Average, Greatest Value and Least Value)
    • Loan Amount (Count, Sum, Average, Greatest Value and Least Value)
      Note: To get both count and amount of the loans choose Loan Amount and select both Count and Sum.
  4. Click on Generate Icon or To Excel Icon to send the report to Excel.

Fair Lending Wiz: Did you know?

…that you can leverage CRA Wiz and Fair Lending Wiz to generate GMI (Race/Ethnicity) information for non-mortgage data by triggering BISG Proxy when conducting Fair Lending analysis using Fair Lending Wiz?

What is BISG?

The Bayesian Improved Surname Geocoding (BISG) methodology assumes that the probability of residing in each Block Group, given a person's race/ethnicity, does not vary by surname. Instead of calculating each separately, comparing the two and taking the highest value, Bayes' Theorem is applied to the stated assumption to calculate the outcome.

Link to the CFPB methodology for reference: https://github.com/cfpb/proxy-methodology

How does it work in CRA Wiz and Fair Lending Wiz?

For the BISG method, determination of race/ethnicity involves three simultaneous steps:

  1. Wiz looks up the surname of the applicant.
  2. The software then finds the Block Group where the applicant resides and determines the percentages of each Race and/or Ethnicity within the Block Group.
  3. For each Race/Ethnicity combination, the software determines the probability that the person is of a particular Race or Ethnicity. This is done by using the Bayesian method to calculate the probability by multiplying the name percentage times the Race/Ethnicity percentage, then dividing that number by the combined probabilities of each Race/Ethnicity added together.
  4. Lastly, the result is a combined probability of being a particular Race or Ethnicity. The individual is assigned to the highest probability.

Note: There is no benchmark for the Race/Ethnicity percentage that is chosen; the software merely picks the higher percentage. In other words, if the probability of being Asian is 43%, and the probability of being Hawaiian is 42.5%, then the software selects the 43% Race/Ethnicity.

In addition, Ethnicity is considered a Race (alongside American Indian/Alaska Native, Asian/Pacific Islander, Black/African American, Native Hawaiian and Whites). All reports will show Hispanic within the Race grouping.

Triggering BISG:

Get the most out of Wiz

Output View:

Get the most out of Wiz

All the Fair Lending Wiz modules (Reports, Comparative File Review, Regression Analysis, Custom Tables) will populate and reflect corresponding BISG values in reports. For screenshots and references, please refer to the Fair Lending Wiz Online Help.

If you would like to learn more information about using accessing and utilizing BISG in CRA Wiz and Fair Lending Wiz, please contact us at [email protected].

Stay informed

Find links below to this month's newsletter.