search

ghing / learning-collaborative-maps

Web map to help coordinate healthy relationships education in the Chicago area.
0 stars 0 forks source link

CSV export of data #52

Open ghing opened 7 years ago

ghing commented 7 years ago

Pam said she would like a report that shows the full scope of programming, including:

These would be displayed as a list rather than spatially.

We decided that rather than implementing some kind of reporting interface, it might make more sense to implement some kind of data export and use pivot tables in a spreadsheet program. Ideally, the spreadsheet file could automatically pull data from the web. This would minimize the number of individual files, which can be confusing and is a concern at Between Friends.

ghing commented 7 years ago

It looks like a CSV URL can be imported into a Google Sheet using the IMPORTDATA function.

ghing commented 6 years ago

Are the data reporting asks the same as the ones in the issue description above or have they changed?

I think the easiest useful thing would be to generate a list of all programs, which includes school name, which you could then use a pivot table in Excel (or Google Sheets) to get the count of programs per school.

The number of programs by neighborhood is the trickiest one because I don't think we assign a neighborhood to the schools when we geocode them. Also for neighborhoods, do you want community areas, for which you can get demographic information because they mostly match census boundaries, or neighborhoods which might more closely match what people call neighborhoods. E.g. Humboldt Park is mostly in the "West Town" community area.

Mattwalsh129 commented 6 years ago

I think just generating a list of all the programs is the hope.

At this point we don’t need to think about neighborhoods.

On Thu, Nov 1, 2018 at 11:44 AM Geoffrey Hing notifications@github.com wrote:

Are the data reporting asks the same as the ones in the issue description above or have they changed?

I think the easiest useful thing would be to generate a list of all programs, which includes school name, which you could then use a pivot table in Excel (or Google Sheets) to get the count of programs per school.

The number of programs by neighborhood is the trickiest one because I don't think we assign a neighborhood to the schools when we geocode them. Also for neighborhoods, do you want community areas https://data.cityofchicago.org/Facilities-Geographic-Boundaries/Boundaries-Community-Areas-current-/cauq-8yn6, for which you can get demographic information because they mostly match census boundaries, or neighborhoods https://data.cityofchicago.org/Facilities-Geographic-Boundaries/Boundaries-Neighborhoods/bbvz-uum9 which might more closely match what people call neighborhoods. E.g. Humboldt Park is mostly in the "West Town" community area.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ghing/learning-collaborative-maps/issues/52#issuecomment-435099876, or mute the thread https://github.com/notifications/unsubscribe-auth/ARceHG-oS3pmtrXjYEPwtBVod0mRrtBtks5uqyTWgaJpZM4LSKBY .