GreenInfo-Network/caliparks.org

Sunsetting CaliParks

Closed this issue · 2 comments

danrademacher commented

OK, Parks California, the new nonprofit for statewide parks advocacy to which ownership of this application was transferred in mid-2019, has determined based on their mission/focus and changes in tech and media landscape since 2014 that CaliParks.org should be wound down.

But they would like an export of "enriched" parks data that is usable in spreadsheet format. I think this is achievable and have more details below. this is the most work here, and time goes to Resources Legacy Fund:CaliParks Takeover

  • Export a flattened parks data table that includes, for parks that have at least 1 activity associated, basic info from CPAD (as represented in CaliParks), the boolean values for all activities, and some new but simple geolocation data tp help non GIS users get benefit from the tables in future. The destination Google Sheet is here So we would add lat,lng,county where the point location is a simple centroid and county is the county where that centroid is located. Not worried about capturing multicounty parks. The idea is that ParksCA can use the tabular version for internal purposes like easy lists of parks with XYZ activities they could feature in a marketing campaign or reach out to managers, etc.

  • Export full database, standard pg_dump / SQL format

  • Archive both the spreadsheet and a SQL DB dump on P drive fileserver

  • Shut down and delete Heroku apps and EC2-hosted databases associated with the site

    • Heroku app
    • EC2 instance hosting the database (the one that's running)
    • older EC2 instance hosting the older 2015 edition of the database (this one is stopped, and was a backup/rollback)

  • Delete domains from Dreamhost. Confirmed with ParksCA that they do not want to hold onto these domains.

Other cleanup TBD

gregallensworth commented

The database dump was made using standard pg_dump and is plain SQL format for maximum compatibility.

pg_dump --clean --no-owner --table='public.*' --file=caliparks_dbdump.sql.gz --compress=9 --username=calipark2017 calipark2017

The CSV export was made using a custom Python program. This program is present in the same P folder. I also loaded the content into https://docs.google.com/spreadsheets/d/1GyL1lm0xSAHqJx-4OoLuhwACTF4wG3SGdgmKx1JUGaU/edit?folder=1-zK9ldHrPyUjCee9DgrsErFpT8JWnYkG#gid=0

The counties shapefile used for determining the county field of the lat,lng centroid, is included as well. This was the counties_24k_USGS.zip dated 2009, present on GIN's N drive.

danrademacher commented

Suspended that email account so it's no longer active. And pinged Outerspatial about the API key.