search

hackoregon / btc-backend

Backend implemented with a combination of Postgres, OpenResty and Nginx
12 stars 6 forks source link

money by oregon county #5

Open ninjascience opened 9 years ago

ninjascience commented 9 years ago

We need a money by Oregon county endpoint, similar to the money by state endpoint.

http://54.213.83.132/hackoregon/http/candidate_in_by_county/Brad Avakian/

znmeb commented 9 years ago

How about money by US county? We have contributors from all over the USA. And the geospatial table for county boundaries covers the whole USA anyway.

ninjascience commented 9 years ago

Sure. You'll have to group the results by state as I'm sure just about every state has a Washington and/or Jefferson county On Sep 27, 2014 3:14 PM, "M. Edward (Ed) Borasky" notifications@github.com wrote:

How about money by US county? We have contributors from all over the USA. And the geospatial table for county boundaries covers the whole USA anyway.

— Reply to this email directly or view it on GitHub https://github.com/hackoregon/backend/issues/5#issuecomment-57067519.

znmeb commented 9 years ago

I can also get you ZIP code without too much trouble. I thought that's what people wanted, actually.

swoolley commented 9 years ago

I don't think the data for county outside Oregon is populated, if at all.

The web form for data entry doesn't make the county even required, I believe, and it's pre-populated only for Oregon, so I suspect much of the data is either missing and in a lot of other cases wrong.

Unless you geocode the address and reverse it to the actual county.

Zip code is missing in some cases too, but that's almost always populated in my analyses. It's often typo'd though. Zip is still probably your best spatial key unless you do more complex analysis to clean up and validate the data.

Seth

On Sat, Sep 27, 2014 at 06:26:32PM -0700, Ryan Miller wrote:

Sure. You'll have to group the results by state as I'm sure just about every state has a Washington and/or Jefferson county On Sep 27, 2014 3:14 PM, "M. Edward (Ed) Borasky" notifications@github.com wrote:

How about money by US county? We have contributors from all over the USA. And the geospatial table for county boundaries covers the whole USA anyway.

— Reply to this email directly or view it on GitHub https://github.com/hackoregon/backend/issues/5#issuecomment-57067519.

— Reply to this email directly or view it on GitHub.*

Seth Alan Woolley 3403 NE Stanton St Portland, OR 97212-2744-03 USA Sr. Software Engineer, http://www.decarta.com/ swoolley@decarta.com 4 N 2nd St #950, San Jose, CA 95113 +1-408-625-3578 +1-503-953-3943 http://swoolley.org seth@swoolley.org WGS84 45.5438N 122.6295W @47M DE KF7IOR QTH CN85QN QRG 146520 APRS 7+9 DNS KF7IOR.US GMRS WQLN518 UTM 10T 528930 5043428; BLM Meridian Oregon Willamette: S25 T1N R1E PGP key BF9D99FB=6FC0 A371 4E97 06D3 B796 ACE3 32D8 0CCA BF9D 99FB linkedin, google, freenode: swoolley twitter, facebook: sethwoolley DPBC ||.|..|...|..|.|...||..|.|..|.||...|.|..|.|..|||.....||.|.|..|