Home › Forums › Purchase Program › FFIEC missing data
- This topic has 10 replies, 4 voices, and was last updated 2 years, 1 month ago by
Peapod0609.
-
AuthorPosts
-
March 6, 2020 at 4:33 am #66005
Elliott Balsley
ParticipantI am searching for a home in priority areas, using the data from FFIEC. What should I do if FFIEC has incorrect or missing data? For example this address:
108 W 2nd St, Los Angeles, CA 90012
FFIEC shows the estimated income for this tract as $0. This is surely an error, but would this location qualify?I downloaded the entire FFIEC dataset and built a web app integration with Redfin to make it easier to search. Using this method, I actually found 60 tracts within LA County that show zero income. I’m curious how this happened.
March 6, 2020 at 11:09 am #66022TTrumble
MemberHello @llamafilm,
Unfortunately, only the FFIEC or more likely the Census Bureau can answer that question. Just for reference, that address is the Higgins Building, a mixed-use commercial and condo building in downtown L.A.
I can only take a guess that there may not be enough data for that Census Tract to have calculated a median income since the area is much more commercial than residential, but again that’s only a guess.
I’m going to do a little digging to see what I can find out about how we would handle that, and I’ll update this thread when I learn something.
Tim Trumble
Online Operations, NACA
ttrumble@naca.com-
This reply was modified 2 years, 2 months ago by
TTrumble.
March 14, 2020 at 4:33 pm #66245Elliott Balsley
ParticipantThat particular building has a few condos for sale, that’s how I found it on Redfin. There seem to be at least several dozen homes in this tract. I’m actually not interested in this location myself; the question just came up as I was building my application, and I was just curious how it would be handled. I suppose maybe NACA would look at this kind of location on a case by case basis.
March 15, 2020 at 1:16 pm #66272TTrumble
MemberHello llamafilm,
After consulting with one of the regional directors, I was advised that we would take that “zero” median income literally!
Our system probably wouldn’t take the zero figure and we would have to enter it as 1%, but it would be considered without question a priority area under 80% of the median income for the MSA.
That location isn’t far at all from landmarks such as the Westin Boanventure Hotel, 7th & Figueroa with it’s mall and farmers market, and of course LA Live and the Staples Center. Might actually be worth considering!
Tim Trumble
Online Operations, NACA
ttrumble@naca.comMarch 17, 2020 at 4:06 pm #66313TheLongJourneyHome
ParticipantCan you share this app?
March 17, 2020 at 7:28 pm #66322TTrumble
MemberHello TheLongJourneyHome,
It’s actually websites, for the Federal Financial Industry Examination Council (FFIEC) and Census Bureau:
http://www.ffiec.gov
http://www.census.govTim Trumble
Online Operations, NACA
ttrumble@naca.comMarch 18, 2020 at 8:57 pm #66372Elliott Balsley
ParticipantYes I’m happy to share. Let me know if you find any problems with it. This shortcut works with the Redfin iOS app only. I may try to add a computer web browser option in the future if I have time. To clarify, this is my own work and is not affiliated with NACA in any way. I’m using US Census data to geocode the address and then look it up in the FFIEC database.
Instructions:
- If you have never used iOS Shortcuts before, you may need to open the Settings app and allow untrusted shortcuts.
- Click this link on your iOS device and follow the prompt to “add untrusted shortcut” https://www.icloud.com/shortcuts/c09841427d8b4033a15fd8afc48d7ae4
- Find a house in the Redfin app and tap Share
- Tap More Options
- Tap NACA Lookup
- Wait a few seconds and you will see a notification. Deep press that to see a map, which is useful to make sure it found the right house.
P.S. For some reason this forum keeps deleting my post. Maybe because I’m trying to include a screenshot.
March 19, 2020 at 9:59 am #66380Peapod0609
MemberI don’t have an iPhone but that is really cool! I am sure that will help members a lot. Anyone else able to use this tool that @llamafilm made?
March 22, 2020 at 2:16 am #66441TheLongJourneyHome
ParticipantMy ipad is outdated so it wont work right now, I’ll try it again later
March 22, 2020 at 7:09 pm #66445Elliott Balsley
ParticipantFor anyone using a regular computer, you can access it here in a web browser. Just paste in either a Redfin URL or a street address
March 23, 2020 at 10:25 am #66457Peapod0609
MemberI just tried it and it worked! That is very cool!
@TTrumble, has NACA ever considered using something like this to assist members and agents in finding priority areas? This seems to be an extremely useful tool.At the very least I think @llamafilm should get some volunteer credits out of this, because this could help a ton of NACA members.
-
This reply was modified 2 years, 2 months ago by
-
AuthorPosts
- You must be logged in to reply to this topic.