Skip to content
BOL Conferences
Thread Options
#1703614 - 05/25/12 08:22 PM Mapping CRA and HMDA data
Jason L Offline
Junior Member
Joined: Feb 2011
Posts: 34
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.

Return to Top
CRA
#1703639 - 05/25/12 09:00 PM Re: Mapping CRA and HMDA data Jason L
manimal Offline
Diamond Poster
manimal
Joined: Feb 2008
Posts: 2,207
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

Return to Top
#1704380 - 05/30/12 02:50 PM Re: Mapping CRA and HMDA data Jason L
Dazed & Confused Offline
Junior Member
Dazed & Confused
Joined: Oct 2011
Posts: 38
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.

Return to Top
#1706310 - 06/04/12 07:19 PM Re: Mapping CRA and HMDA data Dazed & Confused
BankerBA Offline
Member
Joined: Jul 2006
Posts: 67
We use CRA Wiz from Wolters Kluwer for mapping HMDA and CRA data.

Return to Top
#1716269 - 07/02/12 04:31 PM Re: Mapping CRA and HMDA data Jason L
manimal Offline
Diamond Poster
manimal
Joined: Feb 2008
Posts: 2,207
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

Return to Top
#1716280 - 07/02/12 04:52 PM Re: Mapping CRA and HMDA data Jason L
bOaty Offline
Power Poster
bOaty
Joined: Aug 2006
Posts: 4,266
Chillin an grillin
What the heck? Why not?

I just got set up with RATA - Comply Suite and we just got the new software.
_________________________
HMDAHMDAHMDAHMDAHMDAHMDA

Return to Top
#1716290 - 07/02/12 05:10 PM Re: Mapping CRA and HMDA data Jason L
manimal Offline
Diamond Poster
manimal
Joined: Feb 2008
Posts: 2,207
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

Return to Top
#1716297 - 07/02/12 05:21 PM Re: Mapping CRA and HMDA data Jason L
Kathleen O. Blanchard Offline

10K Club
Kathleen O. Blanchard
Joined: Dec 2000
Posts: 21,293
Maptitude is wonderful. It is what I use.
_________________________
Kathleen O. Blanchard, CRCM "Kaybee"
HMDA/CRA Training/Consulting/Mapping
The HMDA Academy
www.kaybeescomplianceinsights.com

Return to Top
#1716318 - 07/02/12 06:06 PM Re: Mapping CRA and HMDA data Jason L
manimal Offline
Diamond Poster
manimal
Joined: Feb 2008
Posts: 2,207
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

Return to Top
#1716326 - 07/02/12 06:10 PM Re: Mapping CRA and HMDA data Jason L
Kathleen O. Blanchard Offline

10K Club
Kathleen O. Blanchard
Joined: Dec 2000
Posts: 21,293
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

Return to Top
#1716332 - 07/02/12 06:14 PM Re: Mapping CRA and HMDA data Jason L
manimal Offline
Diamond Poster
manimal
Joined: Feb 2008
Posts: 2,207
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

Return to Top
#1716358 - 07/02/12 06:41 PM Re: Mapping CRA and HMDA data Jason L
Kathleen O. Blanchard Offline

10K Club
Kathleen O. Blanchard
Joined: Dec 2000
Posts: 21,293
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

Return to Top
#1716360 - 07/02/12 06:46 PM Re: Mapping CRA and HMDA data Jason L
manimal Offline
Diamond Poster
manimal
Joined: Feb 2008
Posts: 2,207
Deleted
Got it! Thank you again!
_________________________
We're all here 'cause we've lost control.

Innerpartysystem

Return to Top
#1716452 - 07/02/12 08:32 PM Re: Mapping CRA and HMDA data Jason L
Pale Rider Offline
10K Club
Pale Rider
Joined: Aug 2002
Posts: 34,318
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.


Return to Top
#1716457 - 07/02/12 08:38 PM Re: Mapping CRA and HMDA data Kathleen O. Blanchard
Bullseye Offline
Platinum Poster
Bullseye
Joined: Jan 2004
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!

Return to Top
#1716474 - 07/02/12 08:58 PM Re: Mapping CRA and HMDA data Pale Rider
Kathleen O. Blanchard Offline

10K Club
Kathleen O. Blanchard
Joined: Dec 2000
Posts: 21,293
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

Return to Top
#1717958 - 07/06/12 09:36 PM Re: Mapping CRA and HMDA data Jason L
Jason L Offline
Junior Member
Joined: Feb 2011
Posts: 34
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.

Return to Top
#1718025 - 07/09/12 12:44 PM Re: Mapping CRA and HMDA data Jason L
manimal Offline
Diamond Poster
manimal
Joined: Feb 2008
Posts: 2,207
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

Return to Top
#1718028 - 07/09/12 12:46 PM Re: Mapping CRA and HMDA data Jason L
Kathleen O. Blanchard Offline

10K Club
Kathleen O. Blanchard
Joined: Dec 2000
Posts: 21,293
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

Return to Top