search

GreenInfo-Network / caliparks.org

Mapping social media in parks and other open spaces
http://www.caliparks.org/
22 stars 3 forks source link

CPAD 2017a #661

Closed mojodna closed 6 years ago

mojodna commented 6 years ago

This updates the version of CPAD to 2017a and applies changes based on CPAD_ChangeLog-CPAD_2015a_SuperUnits-CPAD_2017a_SuperUnits.xls.

Re-associating flickr_photos and instagram_photos will take a long time (~hours). Photos without associated superunits in the new CPAD will have superunit_id values of -1. Many of these result from CPAD now excluding road right-of-ways (GitHub isn't allowing me to upload screenshots right now). This could be mitigated by buffering CPAD geometries by ~250m at the expense of additional migration time, but I (currently) think it makes the most sense to post-process them after based on @danrademacher and @gregallensworth's thoughts.

Refs #656

danrademacher commented 6 years ago

Thanks, @mojodna! Greg's going to look this over. I assume the changes you made here need to be merged in (of course) and then somehow applied to the production database, right?

mojodna commented 6 years ago

Yup!

make db/migrate (pointed to the production database) will apply all of the database changes.