4 ms·

I'm working on a dashboard to map each of these loans geographically: https://www.quiverquant.com/sources/sbaloans https://www.quiverquant.com/sources/sbaloans

I'm working on a dashboard to map each of these loans geographically: https://www.quiverquant.com/sources/sbaloans https://www.quiverquant.com/sources/sbaloans It's a slow process (as I've been respectful of the rate-limit on the reverse geocoding API I'm using), but I finished mapping four states and hope to complete the other 46 by the end of this week.

polote 6y ago
Did you try to use the openstreemap database locally ? http://nominatim.org/release-docs/latest/admin/Installation/ http://nominatim.org/release-docs/latest/admin/Installation/
c0nsumer 6y ago
How about adding something to the page itself about completion status? I went and looked, before reading your second paragraph, and the clusters immediately jumped out, and it either seemed suspect or wrong. Then I had to come back here to see why it was wrong.
- greatwave1 6y ago
  Good idea, just added!
antisthenes 6y ago
Wouldn't you just end up with a population density map? Cool project though.
- fullshark 6y ago
  Yeah i'd try to normalize somehow to get a sense if a geographic area over or underutilized the program compared to expectation.
- greatwave1 6y ago
  My goal for this map was a tool to search for PPP recipients within your own neighborhood. You're right that it would be interesting to do analysis on population-adjusted loan amounts for different regions... maybe something like a loan $ per capita map?
  - mbesto 6y ago
    I was thinking the same thing about the author from above as well. What I think would be much more interesting is to see what businesses have physical B&M locations. In other words, cross reference Yelp/Google Places with the legal entity's address. Or maybe cross referenced against unemployment numbers by state/city (if that data exists).
wavefunction 6y ago
Are the locations in Canada the headquarters of a Canadian company? I've read about non-US companies receiving PPP money so I'm just curious about that.
- greenshackle2 6y ago
  I checked a bunch and they were all geocoding fails. If you zoom out you can find examples in several countries. Examples: All the ones in Ontario, Canada, e.g. Fullmer Construction, are really in Ontario, California. The Christian Valley School on Artesia boulevard in Alberta was picked up instead of the one in Artesia, CA. Simpson Labs is geocoded to Valencia, Spain instead of Valencia, CA. GW Lawrence on Wilson street in Cordoba, Argentina instead of Cordoba, AR.
1-6 6y ago
Great, we can now walk around with pitchforks. I'm kidding These loans have benefited numerous small businesses but we can now keep an eye on those who did not really need it.
- _curious_ 6y ago
  "but we can now keep an eye on those who did not really need it." Who's to say?
  - PascLeRasc 6y ago
    The invisible hand of the market. Of course the people of the "we can't improve anything" mindset don't need to participate.
    - _curious_ 6y ago
      How does the invisible hand of the market determine "those who did not really need it" ?
texasbigdata 6y ago
This is beautiful!
greenshackle2 6y ago
If your API allows it you might want to limit results to US, there's like a dozen that are miscoded to different countries. https://news.ycombinator.com/item?id=23763048 https://news.ycombinator.com/item?id=23763048
Firerouge 6y ago
One thing I noticed is that my local Domino's got $150-300k, but that it was behind a different LLC name. Is it possible to add a ggogle maps business name listing based on address next to the reported company name?
- three_seagrass 6y ago
  Yep, automotive car dealers in my area have different names on their LLC and the dealership. It's a tough one to crack but implementing google street view would solve 70% of the checks.
jcfrei 6y ago
Make sure to prioritize Delaware ;)
H8crilA 6y ago
> reverse geocoding Nit: what you're doing is geocoding, not reverse geocoding. Geocoding is the process of turning strings into lats/longs. Reverse is the reverse of that, namely lats/longs into strings.
matiasfernandez 6y ago
Really cool! Don't forget Puerto Rico too :)

polote 6y ago

Did you try to use the openstreemap database locally ? http://nominatim.org/release-docs/latest/admin/Installation/ http://nominatim.org/release-docs/latest/admin/Installation/

c0nsumer 6y ago

How about adding something to the page itself about completion status? I went and looked, before reading your second paragraph, and the clusters immediately jumped out, and it either seemed suspect or wrong. Then I had to come back here to see why it was wrong.

greatwave1 6y ago
Good idea, just added!

antisthenes 6y ago

Wouldn't you just end up with a population density map? Cool project though.

fullshark 6y ago
Yeah i'd try to normalize somehow to get a sense if a geographic area over or underutilized the program compared to expectation.
greatwave1 6y ago
My goal for this map was a tool to search for PPP recipients within your own neighborhood. You're right that it would be interesting to do analysis on population-adjusted loan amounts for different regions... maybe something like a loan $ per capita map?
- mbesto 6y ago
  I was thinking the same thing about the author from above as well. What I think would be much more interesting is to see what businesses have physical B&M locations. In other words, cross reference Yelp/Google Places with the legal entity's address. Or maybe cross referenced against unemployment numbers by state/city (if that data exists).

wavefunction 6y ago

Are the locations in Canada the headquarters of a Canadian company? I've read about non-US companies receiving PPP money so I'm just curious about that.

greenshackle2 6y ago
I checked a bunch and they were all geocoding fails. If you zoom out you can find examples in several countries. Examples: All the ones in Ontario, Canada, e.g. Fullmer Construction, are really in Ontario, California. The Christian Valley School on Artesia boulevard in Alberta was picked up instead of the one in Artesia, CA. Simpson Labs is geocoded to Valencia, Spain instead of Valencia, CA. GW Lawrence on Wilson street in Cordoba, Argentina instead of Cordoba, AR.

1-6 6y ago

Great, we can now walk around with pitchforks. I'm kidding These loans have benefited numerous small businesses but we can now keep an eye on those who did not really need it.

_curious_ 6y ago
"but we can now keep an eye on those who did not really need it." Who's to say?
- PascLeRasc 6y ago
  The invisible hand of the market. Of course the people of the "we can't improve anything" mindset don't need to participate.
  - _curious_ 6y ago
    How does the invisible hand of the market determine "those who did not really need it" ?

texasbigdata 6y ago

This is beautiful!

greenshackle2 6y ago

If your API allows it you might want to limit results to US, there's like a dozen that are miscoded to different countries. https://news.ycombinator.com/item?id=23763048 https://news.ycombinator.com/item?id=23763048

Firerouge 6y ago

One thing I noticed is that my local Domino's got $150-300k, but that it was behind a different LLC name. Is it possible to add a ggogle maps business name listing based on address next to the reported company name?

three_seagrass 6y ago
Yep, automotive car dealers in my area have different names on their LLC and the dealership. It's a tough one to crack but implementing google street view would solve 70% of the checks.

jcfrei 6y ago

Make sure to prioritize Delaware ;)

H8crilA 6y ago

> reverse geocoding Nit: what you're doing is geocoding, not reverse geocoding. Geocoding is the process of turning strings into lats/longs. Reverse is the reverse of that, namely lats/longs into strings.

matiasfernandez 6y ago

Really cool! Don't forget Puerto Rico too :)