open-city / chicago-river-sewage

Is there sewage in the Chicago River?
http://istheresewageinthechicagoriver.com
29 stars 12 forks source link

changed absolute path to ../data #19

Closed bsuman79 closed 10 years ago

bsuman79 commented 10 years ago

lat/long included in cso_events* file (50% of the original entries contains the coord info) nocoord.csv contain the list of location that do not contain the lat/long info

fgregg commented 10 years ago

@derekeder how does this lat long merging compare with the work you recently did?

derekeder commented 10 years ago

@fgregg about the same

Original manual matching by me: https://www.google.com/fusiontables/embedviz?q=select+col13+from+1FkrNfgMvyi5z2fLAbjxm9Gp-vbbXYHImfy4IOW8&viz=MAP&h=false&lat=41.8781136&lng=-87.62979819999998&t=1&z=10&l=col13&y=2&tmplt=2&hml=TWO_COL_LAT_LNG

Matched using csvlink: https://www.google.com/fusiontables/embedviz?q=select+col13+from+1k2DCFpcrf5suym-ockTzqF1yZ_Ei39mzE9ltjuA&viz=MAP&h=false&lat=41.87793706657346&lng=-87.58893930877889&t=1&z=10&l=col13&y=2&tmplt=2&hml=TWO_COL_LAT_LNG

Matching by @bsuman79: https://www.google.com/fusiontables/embedviz?q=select+col13+from+1xG7ndilTeCvK4-btOG_2eh2ixx04XTm2zF_ReK4&viz=MAP&h=false&lat=41.91644080711403&lng=-87.70171708386033&t=1&z=10&l=col13&y=2&tmplt=2&hml=TWO_COL_LAT_LNG

I found that the inherent matching issue is with MWRD's own TARP database and the scraped CSO event data that @sbeslow got.

derekeder commented 10 years ago

@bsuman79 will you be at the hack night tonight? It would be useful to go over this PR in person

bsuman79 commented 10 years ago

is the hack night in chicago?

On Tue, Jan 28, 2014 at 3:20 PM, Derek Eder notifications@github.comwrote:

@bsuman79 https://github.com/bsuman79 will you be at the hack night tonight? It would be useful to go over this PR in person

Reply to this email directly or view it on GitHubhttps://github.com/open-city/chicago-river-sewage/pull/19#issuecomment-33539347 .

derekeder commented 10 years ago

It is: http://opengovhacknight.org/

If you're not in town, maybe we could do a Skype/Google Hangout?

bsuman79 commented 10 years ago

I live in sf. I would be happy to join. Can give me a skype contact i can call into? I am in road now, but probably can call in another 30 min. Suman On Jan 28, 2014 3:36 PM, "Derek Eder" notifications@github.com wrote:

It is: http://opengovhacknight.org/

If you're not in town, maybe we could do a Skype/Google Hangout?

Reply to this email directly or view it on GitHubhttps://github.com/open-city/chicago-river-sewage/pull/19#issuecomment-33540581 .

derekeder commented 10 years ago

looks good! merging.

derekeder commented 10 years ago

relates to #11