Topic Options
#1703614 - 05/25/12 04:22 PM Mapping CRA and HMDA data
Jason L Offline
Junior Member

Registered: 02/22/11
Posts: 32
Loc: WI
We are currently looking at different options for mapping our CRA and HMDA data to help in analysis and for fair lending reviews. Right now I am using the free trail of Microsoft's Mappoint software. I was wondering if anyone else currently uses Mappoint and if so what kind of data are you mapping? I know the software is not strictly for mapping this type of data, so some of the options are limted, but i wanted to get other opions to see if it is worth buying.

We also use CRA Relief and HMDA Relief from Questsoft which has the option to create export files for Mappoint. Are there others using Questsoft that also use Mappoint, and what are your opinions? Or do you use something different?

Any feedback is appreciated.

Top
CRA
#1703639 - 05/25/12 05:00 PM Re: Mapping CRA and HMDA data [Re: Jason L]
manimal Offline
Diamond Poster

Registered: 02/26/08
Posts: 2207
Loc: Deleted
We use Microsoft Mappoint (the paid version). We export our data into excel from our core system's query program (not CRA Relief or HMDA Relief). Then we map addreses of accounts, branches, and census tract income data.

PM if you want to discuss more.
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Top
#1704380 - 05/30/12 10:50 AM Re: Mapping CRA and HMDA data [Re: Jason L]
Dazed & Confused Offline
Junior Member

Registered: 10/24/11
Posts: 38
Loc: KY
I have recently bought MapPoint and am using HMDA Relief. I was having a few fields not show up properly from the export that came from HMDA Relief. I currently am working with QuestSoft to see why the fields are not showing up as in the instructions.

If I can learn how to do the mapping, I think it will be good because I can take other data files we have and map those for fair lending assessment. That's a struggle in itself...learning how to use the MapPoint software.

If anyone is using other tools, I too would appreciate your comments.

Top
#1706310 - 06/04/12 03:19 PM Re: Mapping CRA and HMDA data [Re: Dazed & Confused]
BankerBA Offline
Member

Registered: 07/13/06
Posts: 67
We use CRA Wiz from Wolters Kluwer for mapping HMDA and CRA data.

Top
#1716269 - 07/02/12 12:31 PM Re: Mapping CRA and HMDA data [Re: Jason L]
manimal Offline
Diamond Poster

Registered: 02/26/08
Posts: 2207
Loc: Deleted
Just an FYI... the newest version of Mappoint coming out in the fall of 2012 will NOT include the new 2010 census tracts.
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Top
#1716280 - 07/02/12 12:52 PM Re: Mapping CRA and HMDA data [Re: Jason L]
bOaty Offline
Power Poster

Registered: 08/01/06
Posts: 4086
Loc: Need a new avi!!
What the heck? Why not?

I just got set up with RATA - Comply Suite and we just got the new software.
_________________________
Never be someone's option, always be their priority.

Top
#1716290 - 07/02/12 01:10 PM Re: Mapping CRA and HMDA data [Re: Jason L]
manimal Offline
Diamond Poster

Registered: 02/26/08
Posts: 2207
Loc: Deleted
Don't get me started!! mad laugh

We don't have the volume to justify getting a CRA/HMDA software solution. I just need software with the 2010 census tracts so I can import the income levels from the FFIEC and map our accounts by address. I am actually looking into Google Earth Pro or Maptitude (Caliper).
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Top
#1716297 - 07/02/12 01:21 PM Re: Mapping CRA and HMDA data [Re: Jason L]
Kathleen B Offline


10K Club

Registered: 12/27/00
Posts: 20990
Maptitude is wonderful. It is what I use.
_________________________
Kathleen O. Blanchard, CRCM "Kaybee"
HMDA/CRA Training/Consulting/Mapping
The HMDA Academy
www.kaybeescomplianceinsights.com

Top
#1716318 - 07/02/12 02:06 PM Re: Mapping CRA and HMDA data [Re: Jason L]
manimal Offline
Diamond Poster

Registered: 02/26/08
Posts: 2207
Loc: Deleted
Can I import the census tract income info from the FFIEC download? I like to create "heat maps" of the low and mod areas for the management.
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Top
#1716326 - 07/02/12 02:10 PM Re: Mapping CRA and HMDA data [Re: Jason L]
Kathleen B Offline


10K Club

Registered: 12/27/00
Posts: 20990
Yes, you just need it in an Excel file and have a matching column to link on (the combined state/county/tract number).
_________________________
Kathleen O. Blanchard, CRCM "Kaybee"
HMDA/CRA Training/Consulting/Mapping
The HMDA Academy
www.kaybeescomplianceinsights.com

Top
#1716332 - 07/02/12 02:14 PM Re: Mapping CRA and HMDA data [Re: Jason L]
manimal Offline
Diamond Poster

Registered: 02/26/08
Posts: 2207
Loc: Deleted
Thanks Kathleen! That is something I have been unable to accomplish in the free trial of Google Earth Pro. Can you explain what you mean by the combined state/county/tract number? Do you mean they all go in one cell together, versus in columns next to one another?
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Top
#1716358 - 07/02/12 02:41 PM Re: Mapping CRA and HMDA data [Re: Jason L]
Kathleen B Offline


10K Club

Registered: 12/27/00
Posts: 20990
Yes, and it is easy to accomplish. Perhaps I will do a webinar. :-)


State 01
County 01
Tract 24.02 would be


01001002402
_________________________
Kathleen O. Blanchard, CRCM "Kaybee"
HMDA/CRA Training/Consulting/Mapping
The HMDA Academy
www.kaybeescomplianceinsights.com

Top
#1716360 - 07/02/12 02:46 PM Re: Mapping CRA and HMDA data [Re: Jason L]
manimal Offline
Diamond Poster

Registered: 02/26/08
Posts: 2207
Loc: Deleted
Got it! Thank you again!
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Top
#1716452 - 07/02/12 04:32 PM Re: Mapping CRA and HMDA data [Re: Jason L]
Pale Rider Offline
10K Club

Registered: 08/09/02
Posts: 34233
Loc: under the Lone Star
so you add leading zeros to the county and tract...yes, you should definitely work up a seminar/webinar KB!
_________________________
Societies that do not find work in and of itself "pleasing to God and requisite to Man," tend to be highly corrupt.


Top
#1716457 - 07/02/12 04:38 PM Re: Mapping CRA and HMDA data [Re: Kathleen B]
Bullseye Offline
Platinum Poster

Registered: 01/27/04
Posts: 968
Originally Posted By: Kathleen B
Yes, and it is easy to accomplish. Perhaps I will do a webinar. :-)


State 01
County 01
Tract 24.02 would be


01001002402


I'd buy that! CRA training is difficult to come by. Thank goodness for BOL!

Top
#1716474 - 07/02/12 04:58 PM Re: Mapping CRA and HMDA data [Re: Pale Rider]
Kathleen B Offline


10K Club

Registered: 12/27/00
Posts: 20990
Originally Posted By: Pale Rider
so you add leading zeros to the county and tract...yes, you should definitely work up a seminar/webinar KB!


And eliminate the decimal..it can be done in one very cool formula.
_________________________
Kathleen O. Blanchard, CRCM "Kaybee"
HMDA/CRA Training/Consulting/Mapping
The HMDA Academy
www.kaybeescomplianceinsights.com

Top
#1717958 - 07/06/12 05:36 PM Re: Mapping CRA and HMDA data [Re: Jason L]
Jason L Offline
Junior Member

Registered: 02/22/11
Posts: 32
Loc: WI
Thanks for the ideas. I have been less than impressed with Mappoint. It is good to know that they won't have the updated census info in the next addition, before I bought it. Mapitude looks like it would work a lot better anyway. Does anyone know if they offer a free trial? I don't see it on their website, and there is no way I can justify the price to managment right now.

Top
#1718025 - 07/09/12 08:44 AM Re: Mapping CRA and HMDA data [Re: Jason L]
manimal Offline
Diamond Poster

Registered: 02/26/08
Posts: 2207
Loc: Deleted
I didn't see anything about a free trial on their website either. Maybe try calling and asking? The worst thing they could do is say 'No'... smile
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Top
#1718028 - 07/09/12 08:46 AM Re: Mapping CRA and HMDA data [Re: Jason L]
Kathleen B Offline


10K Club

Registered: 12/27/00
Posts: 20990
I don't recall a free trial, but they will demo it for you. We had about an hour demo session that they recorded for us.
_________________________
Kathleen O. Blanchard, CRCM "Kaybee"
HMDA/CRA Training/Consulting/Mapping
The HMDA Academy
www.kaybeescomplianceinsights.com

Top