Database for funding ecosystem players information (Partner Identification sheet)

[sayalikotkar]

Overview

This database captures key information of the organizations in the climate project funding ecosystem.

Find out what funders are in the space of climate investing and what kinds of projects they invest in. More specifically, how this is relevant to our mission of propelling open-source climate software/hardware.

Action Items

• Create template for partner identification sheet with all fields needed
• Create list of organizations in the climate project funding ecosystem that could be potential partners
• Populate information for each organization through researching their website

Resources/Instructions

Partner Identification sheet

GEOS: Open Source projects - Funder data

#151

[angle-zhang]

2/21 Updates

Progress

• split database into funders and project supporters
• customized fields based on these two parties^.

Blockers

• don't understand the scope of this map: is this a global, national, or local ecosystem map? hard to find players without knowing what scale to stick with

Availability: 3 hours

[sayalikotkar]

@angle-zhang I suggest we make the map US-focused. This could include organizations that are outside of the US as well, if they are open to and do fund or support US-based projects in any way. At the same time, if we come across non-US based organizations in this process, we should record their high-level information (organization name, url, what they do in 2 lines) without doing a deep dive at this point.

[sayalikotkar]

@angle-zhang Based on our slack conversation, would you like to work on user interviews with projects if you don't have the time to work on research for this database? If so could you make notes about what work you have done on the database so far and what's to be next, and keep it ready for the next UX researcher we get onboard? Also, could you make a role description for the UX researcher, we'll review it in the next team meeting.

Link to the board with project openings for your reference - https://github.com/hackforla/UI-UX/projects/2

Opened a new issue #60

[vaisali89]

Progress: None
Blockers: none
Availability: 4 hours/day
ETA: January 12th

[vaisali89]

Progress: organising the content present on the file
Blockers: since we had decided on focussing on funders of only open source projects, I am scanning the projects listed on opensustain.tech( https://opensustain.tech/). Not sure if this is the right approach but started with that. I may need one more person for help.
Availability: 2 hours/day
ETA: end of January 2021

[vaisali89]

Progress: None.
Blockers: The list is too long so I may need one more person for help to complete asap.
Availability: 3 hours/day
ETA: 31st January 2021

[vaisali89]

Progress: 55 out of 1186 projects reviewed for funders.
Blockers: The list is too long so I may need one more person for help to complete it asap.
Availability: 3 hours/day
ETA: Mid-February 2022

[vaisali89]

Progress: None
Blockers: Couldn't work on it due to some personal commitments
Availability: 3 hours/day
ETA: End of February 2022

[vaisali89]

Progress: 70 projects reviewed
Blockers: Taking more time than expected
Availability: 3 hours/day
ETA: End of February 2022

[vaisali89]

Add to next agenda
Turns out if we know the name of repo's organization we can check to see if its uses the sponsor function. We would like to figure out how to Take this list GEOS: Open Source projects - Funder data

Find out the name of each org (not the end url)
And then do this search, but using the api
https://github.com/search?q=is%3Asponsorable+user%3Aopenclimatefix&type=Repositories&ref=advsearch&l=&l=

Anyone want to take a look

[vaisali89]

Progress: 100 odd project's reviewed
Blockers: none
Availability: 3 hours/day
ETA: End of March /April 2022🤞🏼

[ExperimentsInHonesty]

@vaisali89 I added the following columns so that I could work with Data Science, in case they will be able to build us a script that checks for the status. You can ignore those columns. It's more of a long term ask.

• Project_URL
• Last_Active_Date
• Contributors_Count

[ExperimentsInHonesty]

@vaisali89 Hi. Just checking in with you. We were looking at the projects that have been reviewed in the spreadsheet. It seems like we have some subcategories where there are no activity. Let's make sure we don't review anymore in the sub categories that have been reviewed already. There are 34 subcategories, so at the rate we are going, we should be able to find one project per subcategory in a little over a month.