Top 10 Datasets

classic Classic list List threaded Threaded
31 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Top 10 Datasets

Herb Lainchbury
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

James McKinney-2
My focus is on transparency and participation, so I would add:

* elected officials contact information (this should be dead easy, but only three open data portals have it, and it would really help reduce the maintenance cost of http://represent.opennorth.ca/)
* completed access to information requests (as is done at the federal level)
* public documents released under access to information laws (as BC does, for most part)
* lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
* political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

Some other very popular datasets are:

* service requests (e.g. http://open311.org/)
* health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

The Ombudsman of Montreal does a yearly satisfaction survey. The 2012 report highlights in no particular order:
http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens

* development projects
* road maintenance and emergency work
* budget management
* transparency and access to information

The above come up frequently in studies of what information residents request from government. For instance, this survey of New Jersey municipal clerks has a top 10 datasets of (it doesn't add up to 100% because their survey accepted multiple responses):
http://www.monmouth.edu/assets/0/32212254770/32212254991/32212254992/32212254994/32212254995/30064771087/71c33dfad52a42589c8932fe5f2b784e.pdf

* 24% permits
* 23% minutes/agendas
* 19% construction/building
* 17% ordinances
* 15% tax records
* 14% planning/zoning
* 12% police information
* 10% environmental
* 10% contracts
* 8% resolutions

Planning and development datasets consistently occupy several slots in the top 10 in such studies. That would be the #1 category for me, especially since many cities have processes in place for residents to give feedback on development projects before any permits are issued. If that data is available, we can build tools like http://www.planningalerts.org.au/ (which is hugely successful) to get more people involved. I can maybe re-find other studies - ATI and 311 statistics are a great resource for identifying priority datasets based on existing demand.

"Financial data" is overbroad. I would split into (re-using categories from the federal government's proactive disclosure policies):

* planned expenditures (a.k.a. estimates, appropriations, supply)
* actual expenditures
* grant and contribution awards
* travel and hospitality expenses

For "contracts" and "tender opportunities", see Sunlight's procurement open data guidelines, which suggest more specific additional datasets: http://sunlightfoundation.com/procurement/opendataguidelines

Depending on the jurisdiction, the "budget" may not mean what you want it to mean. It can be a high-level document that simply establishes limits within which expenditures are planned. A budget is often a PDF with a lot of text - not a lot of spreadsheets - hence my choice of terms above.

Exceedingly few cities have hansards / transcripts. I would split "hansards/council a/v" into:

* calendar of meetings
* agendas of meetings
* minutes of meetings
* video of meetings (or at least audio)
* transcripts of meetings
* role call votes (if any, e.g. Montreal does not have role call votes)

Re: "vital stats / demographic data", I think that's usually various views on Census data - so federal level.

If it's in scope, I'd like to promote the use of standards (maybe this would happen in a second phase):

* calendar of meetings: iCal
* transit data: GTFS
* road construction: Open511
* building citations: http://housefacts.me/

I think the datasets should at least be categorized in the survey. Remove the "them" from the survey question to make it grammatical :)

Thanks for leading this, Herb!

James

On 2013-12-13, at 7:15 PM, Herb Lainchbury wrote:

> Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.
>
> The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.
>
> We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.
>
> Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.
>
> Here is the current list in no particular order:
> • financial data (revenue, expenses, liabilities, equity, etc..)
> • business license
> • development applications
> • property assessments
> • park boundaries
> • locations of things (fire hydrants, bike parking, ...)
> • tender opportunities
> • electoral districts
> • transit data
> • vital stats / demographic data
> • tax rates
> • service fees
> • infrastructure deficits
> • hansards/council a/v
> • petitions
> • annual return data (not just pdf reports)
> • stats relating to approval or non-approval of development applications
> • DCC (development cost charges) rates
> • salaries
> • consultant fees
> • traffic study data
> • orthophotos
> • lidar
> • stream health assessments
> • food bank usage stats
> • homelessness stats
> • transit data
> • contracts
> • road construction (511 data)
> • building citations (problems with structures etc...)
>
> The question I am thinking of sending is something like:
>
>  "Which of the following datasets should municipalities make a priority and release them as open data?"
>
> If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.
>
> Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.
>
> Thanks,
> H
>
> _______________________________________________
> CivicAccess-discuss mailing list
> [hidden email]
> http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Michael Lenczner-2
Hi Herb,

I just want to second James's request for grants and contributions. Ideally that should include the BN of the orgs or the Charity Numbers if they have them. And project descriptions. Like this goverment funder in the UK:

Thanks!




Michael Lenczner
CEO, Ajah
http://www.ajah.ca
514-708-5112


On Sat, Dec 14, 2013 at 12:11 AM, James McKinney <[hidden email]> wrote:
My focus is on transparency and participation, so I would add:

* elected officials contact information (this should be dead easy, but only three open data portals have it, and it would really help reduce the maintenance cost of http://represent.opennorth.ca/)
* completed access to information requests (as is done at the federal level)
* public documents released under access to information laws (as BC does, for most part)
* lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
* political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

Some other very popular datasets are:

* service requests (e.g. http://open311.org/)
* health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

The Ombudsman of Montreal does a yearly satisfaction survey. The 2012 report highlights in no particular order:
http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens

* development projects
* road maintenance and emergency work
* budget management
* transparency and access to information

The above come up frequently in studies of what information residents request from government. For instance, this survey of New Jersey municipal clerks has a top 10 datasets of (it doesn't add up to 100% because their survey accepted multiple responses):
http://www.monmouth.edu/assets/0/32212254770/32212254991/32212254992/32212254994/32212254995/30064771087/71c33dfad52a42589c8932fe5f2b784e.pdf

* 24% permits
* 23% minutes/agendas
* 19% construction/building
* 17% ordinances
* 15% tax records
* 14% planning/zoning
* 12% police information
* 10% environmental
* 10% contracts
* 8% resolutions

Planning and development datasets consistently occupy several slots in the top 10 in such studies. That would be the #1 category for me, especially since many cities have processes in place for residents to give feedback on development projects before any permits are issued. If that data is available, we can build tools like http://www.planningalerts.org.au/ (which is hugely successful) to get more people involved. I can maybe re-find other studies - ATI and 311 statistics are a great resource for identifying priority datasets based on existing demand.

"Financial data" is overbroad. I would split into (re-using categories from the federal government's proactive disclosure policies):

* planned expenditures (a.k.a. estimates, appropriations, supply)
* actual expenditures
* grant and contribution awards
* travel and hospitality expenses

For "contracts" and "tender opportunities", see Sunlight's procurement open data guidelines, which suggest more specific additional datasets: http://sunlightfoundation.com/procurement/opendataguidelines

Depending on the jurisdiction, the "budget" may not mean what you want it to mean. It can be a high-level document that simply establishes limits within which expenditures are planned. A budget is often a PDF with a lot of text - not a lot of spreadsheets - hence my choice of terms above.

Exceedingly few cities have hansards / transcripts. I would split "hansards/council a/v" into:

* calendar of meetings
* agendas of meetings
* minutes of meetings
* video of meetings (or at least audio)
* transcripts of meetings
* role call votes (if any, e.g. Montreal does not have role call votes)

Re: "vital stats / demographic data", I think that's usually various views on Census data - so federal level.

If it's in scope, I'd like to promote the use of standards (maybe this would happen in a second phase):

* calendar of meetings: iCal
* transit data: GTFS
* road construction: Open511
* building citations: http://housefacts.me/

I think the datasets should at least be categorized in the survey. Remove the "them" from the survey question to make it grammatical :)

Thanks for leading this, Herb!

James

On 2013-12-13, at 7:15 PM, Herb Lainchbury wrote:

> Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.
>
> The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.
>
> We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.
>
> Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.
>
> Here is the current list in no particular order:
>       • financial data (revenue, expenses, liabilities, equity, etc..)
>       • business license
>       • development applications
>       • property assessments
>       • park boundaries
>       • locations of things (fire hydrants, bike parking, ...)
>       • tender opportunities
>       • electoral districts
>       • transit data
>       • vital stats / demographic data
>       • tax rates
>       • service fees
>       • infrastructure deficits
>       • hansards/council a/v
>       • petitions
>       • annual return data (not just pdf reports)
>       • stats relating to approval or non-approval of development applications
>       • DCC (development cost charges) rates
>       • salaries
>       • consultant fees
>       • traffic study data
>       • orthophotos
>       • lidar
>       • stream health assessments
>       • food bank usage stats
>       • homelessness stats
>       • transit data
>       • contracts
>       • road construction (511 data)
>       • building citations (problems with structures etc...)
>
> The question I am thinking of sending is something like:
>
>  "Which of the following datasets should municipalities make a priority and release them as open data?"
>
> If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.
>
> Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.
>
> Thanks,
> H
>
> _______________________________________________
> CivicAccess-discuss mailing list
> [hidden email]
> http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
In reply to this post by James McKinney-2
Hi James,

Thanks for all of that.  Wow.  I have broken your notes down into bullets as best I can and have added them to the survey choices.

I don't think I am understanding your recommendation of "the datasets should be categorized" while also saying financials should be broken out.  I don't see how one can do both other than maybe having one survey question for each category.  The problem with doing that though is that then the categories are determining the outcome.  There may be entire categories that don't make it into the top 10.  I guess the other option would be to attempt to break all of these choices into categories and just vote on the categories but that would be an entirely different list.  

Right now I am thinking of putting in all of the choices and seeing what people vote on.  Somehow I think just providing the entire list will be more productive.  I'm open to more input on this.  Want to keep it as simple as possible.   Making this list is tricky but I think it's worth doing as a first attempt.  We can evolve it over time if think of ways to improve it.

Your comment about standards is well taken.  I too hope that if we can get some idea of what we think is most important it will help us focus our efforts a bit on evolving some standards around some of the most popular and common datasets for municipalities.

Thanks for your contribution.
H




On Fri, Dec 13, 2013 at 9:11 PM, James McKinney <[hidden email]> wrote:
My focus is on transparency and participation, so I would add:

* elected officials contact information (this should be dead easy, but only three open data portals have it, and it would really help reduce the maintenance cost of http://represent.opennorth.ca/)
* completed access to information requests (as is done at the federal level)
* public documents released under access to information laws (as BC does, for most part)
* lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
* political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

Some other very popular datasets are:

* service requests (e.g. http://open311.org/)
* health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

The Ombudsman of Montreal does a yearly satisfaction survey. The 2012 report highlights in no particular order:
http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens

* development projects
* road maintenance and emergency work
* budget management
* transparency and access to information

The above come up frequently in studies of what information residents request from government. For instance, this survey of New Jersey municipal clerks has a top 10 datasets of (it doesn't add up to 100% because their survey accepted multiple responses):
http://www.monmouth.edu/assets/0/32212254770/32212254991/32212254992/32212254994/32212254995/30064771087/71c33dfad52a42589c8932fe5f2b784e.pdf

* 24% permits
* 23% minutes/agendas
* 19% construction/building
* 17% ordinances
* 15% tax records
* 14% planning/zoning
* 12% police information
* 10% environmental
* 10% contracts
* 8% resolutions

Planning and development datasets consistently occupy several slots in the top 10 in such studies. That would be the #1 category for me, especially since many cities have processes in place for residents to give feedback on development projects before any permits are issued. If that data is available, we can build tools like http://www.planningalerts.org.au/ (which is hugely successful) to get more people involved. I can maybe re-find other studies - ATI and 311 statistics are a great resource for identifying priority datasets based on existing demand.

"Financial data" is overbroad. I would split into (re-using categories from the federal government's proactive disclosure policies):

* planned expenditures (a.k.a. estimates, appropriations, supply)
* actual expenditures
* grant and contribution awards
* travel and hospitality expenses

For "contracts" and "tender opportunities", see Sunlight's procurement open data guidelines, which suggest more specific additional datasets: http://sunlightfoundation.com/procurement/opendataguidelines

Depending on the jurisdiction, the "budget" may not mean what you want it to mean. It can be a high-level document that simply establishes limits within which expenditures are planned. A budget is often a PDF with a lot of text - not a lot of spreadsheets - hence my choice of terms above.

Exceedingly few cities have hansards / transcripts. I would split "hansards/council a/v" into:

* calendar of meetings
* agendas of meetings
* minutes of meetings
* video of meetings (or at least audio)
* transcripts of meetings
* role call votes (if any, e.g. Montreal does not have role call votes)

Re: "vital stats / demographic data", I think that's usually various views on Census data - so federal level.

If it's in scope, I'd like to promote the use of standards (maybe this would happen in a second phase):

* calendar of meetings: iCal
* transit data: GTFS
* road construction: Open511
* building citations: http://housefacts.me/

I think the datasets should at least be categorized in the survey. Remove the "them" from the survey question to make it grammatical :)

Thanks for leading this, Herb!

James

On 2013-12-13, at 7:15 PM, Herb Lainchbury wrote:

> Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.
>
> The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.
>
> We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.
>
> Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.
>
> Here is the current list in no particular order:
>       • financial data (revenue, expenses, liabilities, equity, etc..)
>       • business license
>       • development applications
>       • property assessments
>       • park boundaries
>       • locations of things (fire hydrants, bike parking, ...)
>       • tender opportunities
>       • electoral districts
>       • transit data
>       • vital stats / demographic data
>       • tax rates
>       • service fees
>       • infrastructure deficits
>       • hansards/council a/v
>       • petitions
>       • annual return data (not just pdf reports)
>       • stats relating to approval or non-approval of development applications
>       • DCC (development cost charges) rates
>       • salaries
>       • consultant fees
>       • traffic study data
>       • orthophotos
>       • lidar
>       • stream health assessments
>       • food bank usage stats
>       • homelessness stats
>       • transit data
>       • contracts
>       • road construction (511 data)
>       • building citations (problems with structures etc...)
>
> The question I am thinking of sending is something like:
>
>  "Which of the following datasets should municipalities make a priority and release them as open data?"
>
> If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.
>
> Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.
>
> Thanks,
> H
>
> _______________________________________________
> CivicAccess-discuss mailing list
> [hidden email]
> http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, CEO, Dynamic Solutions Inc.
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

James McKinney-2
Hi Herb,

In terms of categorization, I simply meant grouping datasets that fall within the same category/theme together - not eliminating any items from the list, just placing similar items near each other. If it's possible to put a heading for those groups/collections/categories of datasets, then that would also make browsing a long list of datasets easier. On the other hand, maybe presenting a totally random list of datasets each time would be better survey methodology.

James

On 2013-12-18, at 1:00 PM, Herb Lainchbury wrote:

Hi James,

Thanks for all of that.  Wow.  I have broken your notes down into bullets as best I can and have added them to the survey choices.

I don't think I am understanding your recommendation of "the datasets should be categorized" while also saying financials should be broken out.  I don't see how one can do both other than maybe having one survey question for each category.  The problem with doing that though is that then the categories are determining the outcome.  There may be entire categories that don't make it into the top 10.  I guess the other option would be to attempt to break all of these choices into categories and just vote on the categories but that would be an entirely different list.  

Right now I am thinking of putting in all of the choices and seeing what people vote on.  Somehow I think just providing the entire list will be more productive.  I'm open to more input on this.  Want to keep it as simple as possible.   Making this list is tricky but I think it's worth doing as a first attempt.  We can evolve it over time if think of ways to improve it.

Your comment about standards is well taken.  I too hope that if we can get some idea of what we think is most important it will help us focus our efforts a bit on evolving some standards around some of the most popular and common datasets for municipalities.

Thanks for your contribution.
H




On Fri, Dec 13, 2013 at 9:11 PM, James McKinney <[hidden email]> wrote:
My focus is on transparency and participation, so I would add:

* elected officials contact information (this should be dead easy, but only three open data portals have it, and it would really help reduce the maintenance cost of http://represent.opennorth.ca/)
* completed access to information requests (as is done at the federal level)
* public documents released under access to information laws (as BC does, for most part)
* lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
* political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

Some other very popular datasets are:

* service requests (e.g. http://open311.org/)
* health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

The Ombudsman of Montreal does a yearly satisfaction survey. The 2012 report highlights in no particular order:
http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens

* development projects
* road maintenance and emergency work
* budget management
* transparency and access to information

The above come up frequently in studies of what information residents request from government. For instance, this survey of New Jersey municipal clerks has a top 10 datasets of (it doesn't add up to 100% because their survey accepted multiple responses):
http://www.monmouth.edu/assets/0/32212254770/32212254991/32212254992/32212254994/32212254995/30064771087/71c33dfad52a42589c8932fe5f2b784e.pdf

* 24% permits
* 23% minutes/agendas
* 19% construction/building
* 17% ordinances
* 15% tax records
* 14% planning/zoning
* 12% police information
* 10% environmental
* 10% contracts
* 8% resolutions

Planning and development datasets consistently occupy several slots in the top 10 in such studies. That would be the #1 category for me, especially since many cities have processes in place for residents to give feedback on development projects before any permits are issued. If that data is available, we can build tools like http://www.planningalerts.org.au/ (which is hugely successful) to get more people involved. I can maybe re-find other studies - ATI and 311 statistics are a great resource for identifying priority datasets based on existing demand.

"Financial data" is overbroad. I would split into (re-using categories from the federal government's proactive disclosure policies):

* planned expenditures (a.k.a. estimates, appropriations, supply)
* actual expenditures
* grant and contribution awards
* travel and hospitality expenses

For "contracts" and "tender opportunities", see Sunlight's procurement open data guidelines, which suggest more specific additional datasets: http://sunlightfoundation.com/procurement/opendataguidelines

Depending on the jurisdiction, the "budget" may not mean what you want it to mean. It can be a high-level document that simply establishes limits within which expenditures are planned. A budget is often a PDF with a lot of text - not a lot of spreadsheets - hence my choice of terms above.

Exceedingly few cities have hansards / transcripts. I would split "hansards/council a/v" into:

* calendar of meetings
* agendas of meetings
* minutes of meetings
* video of meetings (or at least audio)
* transcripts of meetings
* role call votes (if any, e.g. Montreal does not have role call votes)

Re: "vital stats / demographic data", I think that's usually various views on Census data - so federal level.

If it's in scope, I'd like to promote the use of standards (maybe this would happen in a second phase):

* calendar of meetings: iCal
* transit data: GTFS
* road construction: Open511
* building citations: http://housefacts.me/

I think the datasets should at least be categorized in the survey. Remove the "them" from the survey question to make it grammatical :)

Thanks for leading this, Herb!

James

On 2013-12-13, at 7:15 PM, Herb Lainchbury wrote:

> Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.
>
> The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.
>
> We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.
>
> Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.
>
> Here is the current list in no particular order:
>       • financial data (revenue, expenses, liabilities, equity, etc..)
>       • business license
>       • development applications
>       • property assessments
>       • park boundaries
>       • locations of things (fire hydrants, bike parking, ...)
>       • tender opportunities
>       • electoral districts
>       • transit data
>       • vital stats / demographic data
>       • tax rates
>       • service fees
>       • infrastructure deficits
>       • hansards/council a/v
>       • petitions
>       • annual return data (not just pdf reports)
>       • stats relating to approval or non-approval of development applications
>       • DCC (development cost charges) rates
>       • salaries
>       • consultant fees
>       • traffic study data
>       • orthophotos
>       • lidar
>       • stream health assessments
>       • food bank usage stats
>       • homelessness stats
>       • transit data
>       • contracts
>       • road construction (511 data)
>       • building citations (problems with structures etc...)
>
> The question I am thinking of sending is something like:
>
>  "Which of the following datasets should municipalities make a priority and release them as open data?"
>
> If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.
>
> Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.
>
> Thanks,
> H
>
> _______________________________________________
> CivicAccess-discuss mailing list
> [hidden email]
> http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, CEO, Dynamic Solutions Inc.
250.704.6154


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
Okay, I see.  Well, yes, I was thinking I would use the randomizer feature of SurveyMonkey to eliminate the bias of things being in a certain order.  As it stands, the financial information is represented both as a general line item and there are also some specific financial items listed.  Hopefully that will work.  I'll post the entire list somewhere before I send it out in the survey so we can all have a look at it and make any final changes.

H


On Wed, Dec 18, 2013 at 10:45 AM, James McKinney <[hidden email]> wrote:
Hi Herb,

In terms of categorization, I simply meant grouping datasets that fall within the same category/theme together - not eliminating any items from the list, just placing similar items near each other. If it's possible to put a heading for those groups/collections/categories of datasets, then that would also make browsing a long list of datasets easier. On the other hand, maybe presenting a totally random list of datasets each time would be better survey methodology.

James

On 2013-12-18, at 1:00 PM, Herb Lainchbury wrote:

Hi James,

Thanks for all of that.  Wow.  I have broken your notes down into bullets as best I can and have added them to the survey choices.

I don't think I am understanding your recommendation of "the datasets should be categorized" while also saying financials should be broken out.  I don't see how one can do both other than maybe having one survey question for each category.  The problem with doing that though is that then the categories are determining the outcome.  There may be entire categories that don't make it into the top 10.  I guess the other option would be to attempt to break all of these choices into categories and just vote on the categories but that would be an entirely different list.  

Right now I am thinking of putting in all of the choices and seeing what people vote on.  Somehow I think just providing the entire list will be more productive.  I'm open to more input on this.  Want to keep it as simple as possible.   Making this list is tricky but I think it's worth doing as a first attempt.  We can evolve it over time if think of ways to improve it.

Your comment about standards is well taken.  I too hope that if we can get some idea of what we think is most important it will help us focus our efforts a bit on evolving some standards around some of the most popular and common datasets for municipalities.

Thanks for your contribution.
H




On Fri, Dec 13, 2013 at 9:11 PM, James McKinney <[hidden email]> wrote:
My focus is on transparency and participation, so I would add:

* elected officials contact information (this should be dead easy, but only three open data portals have it, and it would really help reduce the maintenance cost of http://represent.opennorth.ca/)
* completed access to information requests (as is done at the federal level)
* public documents released under access to information laws (as BC does, for most part)
* lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
* political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

Some other very popular datasets are:

* service requests (e.g. http://open311.org/)
* health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

The Ombudsman of Montreal does a yearly satisfaction survey. The 2012 report highlights in no particular order:
http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens

* development projects
* road maintenance and emergency work
* budget management
* transparency and access to information

The above come up frequently in studies of what information residents request from government. For instance, this survey of New Jersey municipal clerks has a top 10 datasets of (it doesn't add up to 100% because their survey accepted multiple responses):
http://www.monmouth.edu/assets/0/32212254770/32212254991/32212254992/32212254994/32212254995/30064771087/71c33dfad52a42589c8932fe5f2b784e.pdf

* 24% permits
* 23% minutes/agendas
* 19% construction/building
* 17% ordinances
* 15% tax records
* 14% planning/zoning
* 12% police information
* 10% environmental
* 10% contracts
* 8% resolutions

Planning and development datasets consistently occupy several slots in the top 10 in such studies. That would be the #1 category for me, especially since many cities have processes in place for residents to give feedback on development projects before any permits are issued. If that data is available, we can build tools like http://www.planningalerts.org.au/ (which is hugely successful) to get more people involved. I can maybe re-find other studies - ATI and 311 statistics are a great resource for identifying priority datasets based on existing demand.

"Financial data" is overbroad. I would split into (re-using categories from the federal government's proactive disclosure policies):

* planned expenditures (a.k.a. estimates, appropriations, supply)
* actual expenditures
* grant and contribution awards
* travel and hospitality expenses

For "contracts" and "tender opportunities", see Sunlight's procurement open data guidelines, which suggest more specific additional datasets: http://sunlightfoundation.com/procurement/opendataguidelines

Depending on the jurisdiction, the "budget" may not mean what you want it to mean. It can be a high-level document that simply establishes limits within which expenditures are planned. A budget is often a PDF with a lot of text - not a lot of spreadsheets - hence my choice of terms above.

Exceedingly few cities have hansards / transcripts. I would split "hansards/council a/v" into:

* calendar of meetings
* agendas of meetings
* minutes of meetings
* video of meetings (or at least audio)
* transcripts of meetings
* role call votes (if any, e.g. Montreal does not have role call votes)

Re: "vital stats / demographic data", I think that's usually various views on Census data - so federal level.

If it's in scope, I'd like to promote the use of standards (maybe this would happen in a second phase):

* calendar of meetings: iCal
* transit data: GTFS
* road construction: Open511
* building citations: http://housefacts.me/

I think the datasets should at least be categorized in the survey. Remove the "them" from the survey question to make it grammatical :)

Thanks for leading this, Herb!

James

On 2013-12-13, at 7:15 PM, Herb Lainchbury wrote:

> Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.
>
> The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.
>
> We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.
>
> Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.
>
> Here is the current list in no particular order:
>       • financial data (revenue, expenses, liabilities, equity, etc..)
>       • business license
>       • development applications
>       • property assessments
>       • park boundaries
>       • locations of things (fire hydrants, bike parking, ...)
>       • tender opportunities
>       • electoral districts
>       • transit data
>       • vital stats / demographic data
>       • tax rates
>       • service fees
>       • infrastructure deficits
>       • hansards/council a/v
>       • petitions
>       • annual return data (not just pdf reports)
>       • stats relating to approval or non-approval of development applications
>       • DCC (development cost charges) rates
>       • salaries
>       • consultant fees
>       • traffic study data
>       • orthophotos
>       • lidar
>       • stream health assessments
>       • food bank usage stats
>       • homelessness stats
>       • transit data
>       • contracts
>       • road construction (511 data)
>       • building citations (problems with structures etc...)
>
> The question I am thinking of sending is something like:
>
>  "Which of the following datasets should municipalities make a priority and release them as open data?"
>
> If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.
>
> Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.
>
> Thanks,
> H
>
> _______________________________________________
> CivicAccess-discuss mailing list
> [hidden email]
> http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, CEO, Dynamic Solutions Inc.
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Gerry Tychon-2
In reply to this post by Herb Lainchbury
Hi Herb ...

Just to put in my 5 cents. I would suggest putting everything out and not doing any pre-grouping/categorizing. A more bottom up approach to begin with.

And I have had some success using allourideas.org (it incorporates analytical hierarchical technique) for this kind of thing. But, it may not be what your looking for right now.

... gerry



On 18/12/2013 11:00 AM, Herb Lainchbury wrote:
Hi James,

Thanks for all of that.  Wow.  I have broken your notes down into bullets as best I can and have added them to the survey choices.

I don't think I am understanding your recommendation of "the datasets should be categorized" while also saying financials should be broken out.  I don't see how one can do both other than maybe having one survey question for each category.  The problem with doing that though is that then the categories are determining the outcome.  There may be entire categories that don't make it into the top 10.  I guess the other option would be to attempt to break all of these choices into categories and just vote on the categories but that would be an entirely different list.  

Right now I am thinking of putting in all of the choices and seeing what people vote on.  Somehow I think just providing the entire list will be more productive.  I'm open to more input on this.  Want to keep it as simple as possible.   Making this list is tricky but I think it's worth doing as a first attempt.  We can evolve it over time if think of ways to improve it.

Your comment about standards is well taken.  I too hope that if we can get some idea of what we think is most important it will help us focus our efforts a bit on evolving some standards around some of the most popular and common datasets for municipalities.

Thanks for your contribution.
H




On Fri, Dec 13, 2013 at 9:11 PM, James McKinney <[hidden email]> wrote:
My focus is on transparency and participation, so I would add:

* elected officials contact information (this should be dead easy, but only three open data portals have it, and it would really help reduce the maintenance cost of http://represent.opennorth.ca/)
* completed access to information requests (as is done at the federal level)
* public documents released under access to information laws (as BC does, for most part)
* lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
* political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

Some other very popular datasets are:

* service requests (e.g. http://open311.org/)
* health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

The Ombudsman of Montreal does a yearly satisfaction survey. The 2012 report highlights in no particular order:
http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens

* development projects
* road maintenance and emergency work
* budget management
* transparency and access to information

The above come up frequently in studies of what information residents request from government. For instance, this survey of New Jersey municipal clerks has a top 10 datasets of (it doesn't add up to 100% because their survey accepted multiple responses):
http://www.monmouth.edu/assets/0/32212254770/32212254991/32212254992/32212254994/32212254995/30064771087/71c33dfad52a42589c8932fe5f2b784e.pdf

* 24% permits
* 23% minutes/agendas
* 19% construction/building
* 17% ordinances
* 15% tax records
* 14% planning/zoning
* 12% police information
* 10% environmental
* 10% contracts
* 8% resolutions

Planning and development datasets consistently occupy several slots in the top 10 in such studies. That would be the #1 category for me, especially since many cities have processes in place for residents to give feedback on development projects before any permits are issued. If that data is available, we can build tools like http://www.planningalerts.org.au/ (which is hugely successful) to get more people involved. I can maybe re-find other studies - ATI and 311 statistics are a great resource for identifying priority datasets based on existing demand.

"Financial data" is overbroad. I would split into (re-using categories from the federal government's proactive disclosure policies):

* planned expenditures (a.k.a. estimates, appropriations, supply)
* actual expenditures
* grant and contribution awards
* travel and hospitality expenses

For "contracts" and "tender opportunities", see Sunlight's procurement open data guidelines, which suggest more specific additional datasets: http://sunlightfoundation.com/procurement/opendataguidelines

Depending on the jurisdiction, the "budget" may not mean what you want it to mean. It can be a high-level document that simply establishes limits within which expenditures are planned. A budget is often a PDF with a lot of text - not a lot of spreadsheets - hence my choice of terms above.

Exceedingly few cities have hansards / transcripts. I would split "hansards/council a/v" into:

* calendar of meetings
* agendas of meetings
* minutes of meetings
* video of meetings (or at least audio)
* transcripts of meetings
* role call votes (if any, e.g. Montreal does not have role call votes)

Re: "vital stats / demographic data", I think that's usually various views on Census data - so federal level.

If it's in scope, I'd like to promote the use of standards (maybe this would happen in a second phase):

* calendar of meetings: iCal
* transit data: GTFS
* road construction: Open511
* building citations: http://housefacts.me/

I think the datasets should at least be categorized in the survey. Remove the "them" from the survey question to make it grammatical :)

Thanks for leading this, Herb!

James

On 2013-12-13, at 7:15 PM, Herb Lainchbury wrote:

> Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.
>
> The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.
>
> We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.
>
> Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.
>
> Here is the current list in no particular order:
>       • financial data (revenue, expenses, liabilities, equity, etc..)
>       • business license
>       • development applications
>       • property assessments
>       • park boundaries
>       • locations of things (fire hydrants, bike parking, ...)
>       • tender opportunities
>       • electoral districts
>       • transit data
>       • vital stats / demographic data
>       • tax rates
>       • service fees
>       • infrastructure deficits
>       • hansards/council a/v
>       • petitions
>       • annual return data (not just pdf reports)
>       • stats relating to approval or non-approval of development applications
>       • DCC (development cost charges) rates
>       • salaries
>       • consultant fees
>       • traffic study data
>       • orthophotos
>       • lidar
>       • stream health assessments
>       • food bank usage stats
>       • homelessness stats
>       • transit data
>       • contracts
>       • road construction (511 data)
>       • building citations (problems with structures etc...)
>
> The question I am thinking of sending is something like:
>
>  "Which of the following datasets should municipalities make a priority and release them as open data?"
>
> If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.
>
> Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.
>
> Thanks,
> H
>
> _______________________________________________
> CivicAccess-discuss mailing list
> [hidden email]
> http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, CEO, Dynamic Solutions Inc.
250.704.6154




_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
Thanks Gerry.  Agreed.  I prefer a randomized bottom-up approach (as also suggested at the end of James' note).

I had forgotten about allourideas.org !  I will have another look at it.  Thanks!

H


On Wed, Dec 18, 2013 at 11:21 AM, Gerry Tychon <[hidden email]> wrote:
Hi Herb ...

Just to put in my 5 cents. I would suggest putting everything out and not doing any pre-grouping/categorizing. A more bottom up approach to begin with.

And I have had some success using allourideas.org (it incorporates analytical hierarchical technique) for this kind of thing. But, it may not be what your looking for right now.

... gerry




On 18/12/2013 11:00 AM, Herb Lainchbury wrote:
Hi James,

Thanks for all of that.  Wow.  I have broken your notes down into bullets as best I can and have added them to the survey choices.

I don't think I am understanding your recommendation of "the datasets should be categorized" while also saying financials should be broken out.  I don't see how one can do both other than maybe having one survey question for each category.  The problem with doing that though is that then the categories are determining the outcome.  There may be entire categories that don't make it into the top 10.  I guess the other option would be to attempt to break all of these choices into categories and just vote on the categories but that would be an entirely different list.  

Right now I am thinking of putting in all of the choices and seeing what people vote on.  Somehow I think just providing the entire list will be more productive.  I'm open to more input on this.  Want to keep it as simple as possible.   Making this list is tricky but I think it's worth doing as a first attempt.  We can evolve it over time if think of ways to improve it.

Your comment about standards is well taken.  I too hope that if we can get some idea of what we think is most important it will help us focus our efforts a bit on evolving some standards around some of the most popular and common datasets for municipalities.

Thanks for your contribution.
H




On Fri, Dec 13, 2013 at 9:11 PM, James McKinney <[hidden email]> wrote:
My focus is on transparency and participation, so I would add:

* elected officials contact information (this should be dead easy, but only three open data portals have it, and it would really help reduce the maintenance cost of http://represent.opennorth.ca/)
* completed access to information requests (as is done at the federal level)
* public documents released under access to information laws (as BC does, for most part)
* lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
* political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

Some other very popular datasets are:

* service requests (e.g. http://open311.org/)
* health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

The Ombudsman of Montreal does a yearly satisfaction survey. The 2012 report highlights in no particular order:
http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens

* development projects
* road maintenance and emergency work
* budget management
* transparency and access to information

The above come up frequently in studies of what information residents request from government. For instance, this survey of New Jersey municipal clerks has a top 10 datasets of (it doesn't add up to 100% because their survey accepted multiple responses):
http://www.monmouth.edu/assets/0/32212254770/32212254991/32212254992/32212254994/32212254995/30064771087/71c33dfad52a42589c8932fe5f2b784e.pdf

* 24% permits
* 23% minutes/agendas
* 19% construction/building
* 17% ordinances
* 15% tax records
* 14% planning/zoning
* 12% police information
* 10% environmental
* 10% contracts
* 8% resolutions

Planning and development datasets consistently occupy several slots in the top 10 in such studies. That would be the #1 category for me, especially since many cities have processes in place for residents to give feedback on development projects before any permits are issued. If that data is available, we can build tools like http://www.planningalerts.org.au/ (which is hugely successful) to get more people involved. I can maybe re-find other studies - ATI and 311 statistics are a great resource for identifying priority datasets based on existing demand.

"Financial data" is overbroad. I would split into (re-using categories from the federal government's proactive disclosure policies):

* planned expenditures (a.k.a. estimates, appropriations, supply)
* actual expenditures
* grant and contribution awards
* travel and hospitality expenses

For "contracts" and "tender opportunities", see Sunlight's procurement open data guidelines, which suggest more specific additional datasets: http://sunlightfoundation.com/procurement/opendataguidelines

Depending on the jurisdiction, the "budget" may not mean what you want it to mean. It can be a high-level document that simply establishes limits within which expenditures are planned. A budget is often a PDF with a lot of text - not a lot of spreadsheets - hence my choice of terms above.

Exceedingly few cities have hansards / transcripts. I would split "hansards/council a/v" into:

* calendar of meetings
* agendas of meetings
* minutes of meetings
* video of meetings (or at least audio)
* transcripts of meetings
* role call votes (if any, e.g. Montreal does not have role call votes)

Re: "vital stats / demographic data", I think that's usually various views on Census data - so federal level.

If it's in scope, I'd like to promote the use of standards (maybe this would happen in a second phase):

* calendar of meetings: iCal
* transit data: GTFS
* road construction: Open511
* building citations: http://housefacts.me/

I think the datasets should at least be categorized in the survey. Remove the "them" from the survey question to make it grammatical :)

Thanks for leading this, Herb!

James

On 2013-12-13, at 7:15 PM, Herb Lainchbury wrote:

> Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.
>
> The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.
>
> We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.
>
> Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.
>
> Here is the current list in no particular order:
>       • financial data (revenue, expenses, liabilities, equity, etc..)
>       • business license
>       • development applications
>       • property assessments
>       • park boundaries
>       • locations of things (fire hydrants, bike parking, ...)
>       • tender opportunities
>       • electoral districts
>       • transit data
>       • vital stats / demographic data
>       • tax rates
>       • service fees
>       • infrastructure deficits
>       • hansards/council a/v
>       • petitions
>       • annual return data (not just pdf reports)
>       • stats relating to approval or non-approval of development applications
>       • DCC (development cost charges) rates
>       • salaries
>       • consultant fees
>       • traffic study data
>       • orthophotos
>       • lidar
>       • stream health assessments
>       • food bank usage stats
>       • homelessness stats
>       • transit data
>       • contracts
>       • road construction (511 data)
>       • building citations (problems with structures etc...)
>
> The question I am thinking of sending is something like:
>
>  "Which of the following datasets should municipalities make a priority and release them as open data?"
>
> If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.
>
> Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.
>
> Thanks,
> H
>
> _______________________________________________
> CivicAccess-discuss mailing list
> [hidden email]
> http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, CEO, Dynamic Solutions Inc.
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154




_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
In reply to this post by Herb Lainchbury
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
Hi Folks,

Here is the entire list of datasets that I plan to send out.  I think I have captured everyone's suggestions so far.  Correct me if I am missing any.

I am thinking I will send the survey as one multiple choice question and allow respondents to select as many choices as they like.
The question will also allow for someone to add a choice that is not listed.
The 10 datasets with the most votes become the top 10.

I don't see any way to randomize the sequence of choices so they will go out as is in this order.

The system does check for ballot stuffing (as best it can).

I suggest we share this far and wide and allow two weeks or so for completion.  I'll send it to this group, to OpenDataBC and to the vancouver-data group as well as twitter, etc..

We will have no way of knowing who the respondents are.

I plan to send this in the next day or two so if anyone would like to provide any last minute feedback or suggestions please do so by responding on this list.

Thanks,
Herb

-------------

The choices are:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)
  • public consultations
  • land use changes
  • rezoning permit applications
  • development permit applications
  • elected officials contact information
  • completed access to information requests (as is done at the federal level)
  • public documents released under access to information laws (as BC does, for most part)
  • lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)
  • political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)
  • service requests (e.g. http://open311.org/)
  • health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  • satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)
  • road maintenance and emergency work
  • budget management
  • transparency and access to information
  • financial - planned expenditures (a.k.a. estimates, appropriations, supply)
  • financial - actual expenditures
  • financial - grant and contribution awards
  • financial - travel and hospitality expenses
  • crime information
  • calendar of meetings
  • agendas of meetings
  • minutes of meetings
  • video of meetings
  • audio of meetings
  • transcripts of meetings
  • role call votes
  • attendance records










On Fri, Mar 14, 2014 at 4:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154





--

Herb Lainchbury, Dynamic Solutions
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Tracey P. Lauriault
In reply to this post by Herb Lainchbury
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Jury Konga

Hi Tracey

 

This is a significant exercise and if I recall Herb’s initial idea – it was to get the “process” starting understanding that it wouldn’t be perfect and the community could build on it.  There is also a CODI project (described here http://opendatainstitute.ca/projects/open-data-reference-model/ ) with an editable Google doc https://docs.google.com/spreadsheet/ccc?key=0AkWBuXccNc3CdGZHVzVtcThoaHZiSzdpbHlTVXJLTFE&usp=sharing#gid=0

 

This is a long road with many local to global data standards related initiatives underway.  So as long as there’s value from an initial survey, suggest Herb simply go ahead with it and maybe rather than trying to capture all the data sets – maybe focus on ensuring we capture all the relevant data themes/categories.  Just a thought …

 

Cheers  Jury

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of Tracey P. Lauriault
Sent: March-20-14 5:37 AM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Datasets

 

Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:

  • Demographic Background Information (DBI)
  • Affordable, Appropriate Housing (AAH)
  • Civic Engagement (CE)
  • Community and Social Infrastructure (CSI)
  • Education (ED)
  • Employment and Local Economy (ELE)
  • Natural Environment (NE)
  • Personal & Community Health (PCH)
  • Personal Financial Security (PFS)
  • Personal Safety (PS)

The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.


I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

 

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses

 

Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)

 

Business

·         tender opportunities

 

Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)

 

Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)

 

Demographics

·         vital stats

·         demographic data (these are available)

 

Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)

 

Remote Sensing

·         orthophotos

·         lidar

 

User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)

 

Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)

 

Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)

 

Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)

 

Well Being

·         food bank usage stats

·         homelessness stats

 

Citizen Engagement

·         public consultations

 

Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information

 

Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information

 

Herb, you are super great at persistently keeping us going!

Cheers

Tracey

 

 

On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:

Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

 

I have compiled a list and plan to send out the survey in the near future.

 

Cheers,

Herb

 

 

 

On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:

Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

 

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

 

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

 

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

 

Here is the current list in no particular order:

  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

 

The question I am thinking of sending is something like:

 

 "Which of the following datasets should municipalities make a priority and release them as open data?"

 

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

 

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

 

Thanks,

H

 



 

--

 

Herb Lainchbury, Dynamic Solutions

<a href="tel:250.704.6154" target="_blank">250.704.6154

 


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss




--


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Gerry Tychon-2
In reply to this post by Tracey P. Lauriault
I am not sure where to toss this in but I would also like to see various infraction data. E.g., parking tickets. I suspect that organizations start to factor this into their budgets and rather than enforcement for public good, the goad becomes revenue generation.

... ggt


On Thu, Mar 20, 2014 at 3:36 AM, Tracey P. Lauriault <[hidden email]> wrote:
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
I'll add that Gerry.  Thanks.
H


On Thu, Mar 20, 2014 at 12:54 PM, Gerry Tychon <[hidden email]> wrote:
I am not sure where to toss this in but I would also like to see various infraction data. E.g., parking tickets. I suspect that organizations start to factor this into their budgets and rather than enforcement for public good, the goad becomes revenue generation.

... ggt


On Thu, Mar 20, 2014 at 3:36 AM, Tracey P. Lauriault <[hidden email]> wrote:
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss


_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
In reply to this post by Tracey P. Lauriault
HI Tracey,

The list was started on OpenDataBC and then moved here to get more input.  I have not taken it outside to other groups.

The idea is to generate a starting list of top 10 datasets.  Some of the datasets will already have been released by some municipalities.  Others may not have been made available by any municipalities.  The point is for publishers to be able to look at the list and see that people are interested.  I get asked over and over again "what do people want?" so I would like to be able to refer to a top ten list to give publishers and idea of what people are interested in.

For example, if it went out now I might choose:
I fully expect that the initial list will not be perfect but I think the people on the list have enough knowledge either on their own or with their networks to have a crack at it.

Also, I don't know of any group better than this one for getting things done so that's why I brought it here. :)

I am happy to help get this done however people think it should happen.  I like your categories suggestion - so maybe we should work that in somehow - but I was thinking more at the dataset level.

"Herb, you are super great at persistently keeping us going!"
Thank you!  :)

Given this discussion I won't send anything out now so we can hear from a few more voices.

Cheers,
Herb




On Thu, Mar 20, 2014 at 2:36 AM, Tracey P. Lauriault <[hidden email]> wrote:
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Tracey P. Lauriault
Cheers!


On Thu, Mar 20, 2014 at 11:18 PM, Herb Lainchbury <[hidden email]> wrote:
HI Tracey,

The list was started on OpenDataBC and then moved here to get more input.  I have not taken it outside to other groups.

The idea is to generate a starting list of top 10 datasets.  Some of the datasets will already have been released by some municipalities.  Others may not have been made available by any municipalities.  The point is for publishers to be able to look at the list and see that people are interested.  I get asked over and over again "what do people want?" so I would like to be able to refer to a top ten list to give publishers and idea of what people are interested in.

For example, if it went out now I might choose:
I fully expect that the initial list will not be perfect but I think the people on the list have enough knowledge either on their own or with their networks to have a crack at it.

Also, I don't know of any group better than this one for getting things done so that's why I brought it here. :)

I am happy to help get this done however people think it should happen.  I like your categories suggestion - so maybe we should work that in somehow - but I was thinking more at the dataset level.

"Herb, you are super great at persistently keeping us going!"
Thank you!  :)

Given this discussion I won't send anything out now so we can hear from a few more voices.

Cheers,
Herb




On Thu, Mar 20, 2014 at 2:36 AM, Tracey P. Lauriault <[hidden email]> wrote:
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Tracey P. Lauriault
In reply to this post by Herb Lainchbury
Just recalled something!

I do not think the folks that submitted this list are not capable, but I do know that it is a group that reflects a world view that is not necessarily the same the civil society groups doing social and environmental justice work, or work on accessibility, or health.  And I worry that if we continuously only have us as open data folks involved in making lists and setting trajectories, then we are missing out on telling really important public policy issues, as they are just not on our horizon.

This is harder to step out of our comfort zones, but I think there is merit in doing so.  I was just going through the G8 resolution (https://www.gov.uk/government/publications/open-data-charter/g8-open-data-charter-and-technical-annex) and if you scroll down to:

Action 2: Release of high value data, 

That list is pretty good.

Data Category* (alphabetical order) Example datasets
Companies Company/business register
Crime and Justice Crime statistics, safety
Earth observation Meteorological/weather, agriculture, forestry, fishing, and hunting
Education List of schools; performance of schools, digital skills
Energy and Environment Pollution levels, energy consumption
Finance and contracts Transaction spend, contracts let, call for tender, future tenders, local budget, national budget (planned and spent)
Geospatial Topography, postcodes, national maps, local maps
Global Development Aid, food security, extractives, land
Government Accountability and Democracy Government contact points, election results, legislation and statutes, salaries (pay scales), hospitality/gifts
Health Prescription data, performance data
Science and Research Genome data, research and educational activity, experiment results
Statistics National Statistics, Census, infrastructure, wealth, skills
Social mobility and welfare Housing, health insurance and unemployment benefits
Transport and Infrastructure Public transport timetables, access points broadband penetration


On Thu, Mar 20, 2014 at 11:18 PM, Herb Lainchbury <[hidden email]> wrote:
HI Tracey,

The list was started on OpenDataBC and then moved here to get more input.  I have not taken it outside to other groups.

The idea is to generate a starting list of top 10 datasets.  Some of the datasets will already have been released by some municipalities.  Others may not have been made available by any municipalities.  The point is for publishers to be able to look at the list and see that people are interested.  I get asked over and over again "what do people want?" so I would like to be able to refer to a top ten list to give publishers and idea of what people are interested in.

For example, if it went out now I might choose:
I fully expect that the initial list will not be perfect but I think the people on the list have enough knowledge either on their own or with their networks to have a crack at it.

Also, I don't know of any group better than this one for getting things done so that's why I brought it here. :)

I am happy to help get this done however people think it should happen.  I like your categories suggestion - so maybe we should work that in somehow - but I was thinking more at the dataset level.

"Herb, you are super great at persistently keeping us going!"
Thank you!  :)

Given this discussion I won't send anything out now so we can hear from a few more voices.

Cheers,
Herb




On Thu, Mar 20, 2014 at 2:36 AM, Tracey P. Lauriault <[hidden email]> wrote:
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

James McKinney-2
In reply to this post by Tracey P. Lauriault
To answer a few of the questions:

> tax rates (Do they mean property assessments?)

Tax rates are not property assessments. They are like this: http://www.newmarket.ca/en/townhall/resourcelibrary/2013TaxRatesScheduleA.pdf

> electoral districts (these are available)

These are most definitely not available for the vast majority. Open North has the electoral districts for 84 jurisdictions in Canada [1] (more than anyone?), of which only 54 make their data available online. Those 84 cover half the population at the municipal level. 25% of the population have no electoral districts at the municipal level.

We’ve requested the districts for another 106 jurisdictions in the last month (10% of pop.). There are another 544 we can request (for another 5% of pop.). There are 1,261 municipalities for which we don’t know if they have divisions or not (10% of pop.); we’re waiting to hear from MPAC, which it turns out is the only organization in Ontario that knows who has wards and who doesn’t. (We’d contacted the Province, AMO, AMTCO, and I forget who else - they don’t have it.)

So, we have between 66% and 77% of all municipal districts in Canada, depending on how many of those 1,261 small municipalities have divisions. Having this data available online in a geospatial format is way better than sending hundreds of emails each year. It’s also way better than having to submit access to information requests, which we sometimes must.

1. https://github.com/opennorth/represent-canada-data

> ·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

As far as I know, only the federal hansard is in a structured, machine-readable format. The others are HTML or PDF. The federal hansard is under a “speaker’s permission”. It is not open data: http://www.parl.gc.ca/SpeakerPermission.aspx?Language=E

> ·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

There is an HTML page, somewhere, on each government’s website, with contact information. That’s of bare minimum utility if you’re trying to build a database like Represent [1], which is of use to a wide variety of people. There are a small handful of governments that publish this information in machine readable format: Ottawa, Vancouver, Region of Peel, and a few others, but so few that there’s lots of room for improvement.

1. http://represent.opennorth.ca/

James
_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Herb Lainchbury
In reply to this post by Tracey P. Lauriault
I agree with the "world view" and "comfort zone" assertions and I would guess that each of these groups would come up with a different list.  Maybe we need to encourage these groups to create a list for their purposes?

Ultimately I suppose we need to look at the value of creating a list in the first place.  For me, I just want to give muni's an idea of what at least SOME people are interested in.  It's true we can't speak for everyone.

The G8 list is great but my intention was to construct a list specifically for Canadian municipalities.  This list is specific to nations, though some of them could be addressed at the municipal level (crime for example).

H



On Thu, Mar 20, 2014 at 6:16 PM, Tracey P. Lauriault <[hidden email]> wrote:
Just recalled something!

I do not think the folks that submitted this list are not capable, but I do know that it is a group that reflects a world view that is not necessarily the same the civil society groups doing social and environmental justice work, or work on accessibility, or health.  And I worry that if we continuously only have us as open data folks involved in making lists and setting trajectories, then we are missing out on telling really important public policy issues, as they are just not on our horizon.

This is harder to step out of our comfort zones, but I think there is merit in doing so.  I was just going through the G8 resolution (https://www.gov.uk/government/publications/open-data-charter/g8-open-data-charter-and-technical-annex) and if you scroll down to:

Action 2: Release of high value data, 

That list is pretty good.

Data Category* (alphabetical order) Example datasets
Companies Company/business register
Crime and Justice Crime statistics, safety
Earth observation Meteorological/weather, agriculture, forestry, fishing, and hunting
Education List of schools; performance of schools, digital skills
Energy and Environment Pollution levels, energy consumption
Finance and contracts Transaction spend, contracts let, call for tender, future tenders, local budget, national budget (planned and spent)
Geospatial Topography, postcodes, national maps, local maps
Global Development Aid, food security, extractives, land
Government Accountability and Democracy Government contact points, election results, legislation and statutes, salaries (pay scales), hospitality/gifts
Health Prescription data, performance data
Science and Research Genome data, research and educational activity, experiment results
Statistics National Statistics, Census, infrastructure, wealth, skills
Social mobility and welfare Housing, health insurance and unemployment benefits
Transport and Infrastructure Public transport timetables, access points broadband penetration


On Thu, Mar 20, 2014 at 11:18 PM, Herb Lainchbury <[hidden email]> wrote:
HI Tracey,

The list was started on OpenDataBC and then moved here to get more input.  I have not taken it outside to other groups.

The idea is to generate a starting list of top 10 datasets.  Some of the datasets will already have been released by some municipalities.  Others may not have been made available by any municipalities.  The point is for publishers to be able to look at the list and see that people are interested.  I get asked over and over again "what do people want?" so I would like to be able to refer to a top ten list to give publishers and idea of what people are interested in.

For example, if it went out now I might choose:
I fully expect that the initial list will not be perfect but I think the people on the list have enough knowledge either on their own or with their networks to have a crack at it.

Also, I don't know of any group better than this one for getting things done so that's why I brought it here. :)

I am happy to help get this done however people think it should happen.  I like your categories suggestion - so maybe we should work that in somehow - but I was thinking more at the dataset level.

"Herb, you are super great at persistently keeping us going!"
Thank you!  :)

Given this discussion I won't send anything out now so we can hear from a few more voices.

Cheers,
Herb




On Thu, Mar 20, 2014 at 2:36 AM, Tracey P. Lauriault <[hidden email]> wrote:
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
Reply | Threaded
Open this post in threaded view
|

Re: Top 10 Datasets

Tracey P. Lauriault
Hey Herb;

This report (http://www.opengovpartnership.org/country/canada/progress-report/report) includes references to many of the datasets I was pointing out, it is the OGP independent report and some of the complaints are the fact that most portals do not have the data I was refering to in them.  Again, I think reflective of who we are and what our interstest are.  Perhaps let muni gov know that this list is a developers/open data enthusiast list and not a list from civil society at large and more outreach would be required to include them. 

They will not make a list unless they are asked Herb as open data is not something they are necessarily engaged in.  The FCM report I pointed to is all about cities, and that list of indicators was created by community grouns and city officials in canada's top 24  cities in terms of population.  If you go throught that list, you will quickly see that most open data portals do not contain these data, and this is also why many civil society folks don't care about portals.  They do not contain the data they need and use.  These are not tek specialist in any way, but they are big data users, so you will  most likely not come accross them at open data events as that is not a space they would gravitate to.

James,

You are discussing wards and so on, so a different scale than federal electoral districts which to my understanding are contiguous with provincial and territorial electoral districts. At lower tiers I did not think they were electoral districts files, but are wards and so on. So on that one I agree. When you say 84, you mean 84 what?

Officials are listed, not in the format you want, but the data are available.

Thx for the clarification on the Hansard and Tax rates.

Cheers
t


On Fri, Mar 21, 2014 at 1:53 AM, Herb Lainchbury <[hidden email]> wrote:
I agree with the "world view" and "comfort zone" assertions and I would guess that each of these groups would come up with a different list.  Maybe we need to encourage these groups to create a list for their purposes?

Ultimately I suppose we need to look at the value of creating a list in the first place.  For me, I just want to give muni's an idea of what at least SOME people are interested in.  It's true we can't speak for everyone.

The G8 list is great but my intention was to construct a list specifically for Canadian municipalities.  This list is specific to nations, though some of them could be addressed at the municipal level (crime for example).

H



On Thu, Mar 20, 2014 at 6:16 PM, Tracey P. Lauriault <[hidden email]> wrote:
Just recalled something!

I do not think the folks that submitted this list are not capable, but I do know that it is a group that reflects a world view that is not necessarily the same the civil society groups doing social and environmental justice work, or work on accessibility, or health.  And I worry that if we continuously only have us as open data folks involved in making lists and setting trajectories, then we are missing out on telling really important public policy issues, as they are just not on our horizon.

This is harder to step out of our comfort zones, but I think there is merit in doing so.  I was just going through the G8 resolution (https://www.gov.uk/government/publications/open-data-charter/g8-open-data-charter-and-technical-annex) and if you scroll down to:

Action 2: Release of high value data, 

That list is pretty good.

Data Category* (alphabetical order) Example datasets
Companies Company/business register
Crime and Justice Crime statistics, safety
Earth observation Meteorological/weather, agriculture, forestry, fishing, and hunting
Education List of schools; performance of schools, digital skills
Energy and Environment Pollution levels, energy consumption
Finance and contracts Transaction spend, contracts let, call for tender, future tenders, local budget, national budget (planned and spent)
Geospatial Topography, postcodes, national maps, local maps
Global Development Aid, food security, extractives, land
Government Accountability and Democracy Government contact points, election results, legislation and statutes, salaries (pay scales), hospitality/gifts
Health Prescription data, performance data
Science and Research Genome data, research and educational activity, experiment results
Statistics National Statistics, Census, infrastructure, wealth, skills
Social mobility and welfare Housing, health insurance and unemployment benefits
Transport and Infrastructure Public transport timetables, access points broadband penetration


On Thu, Mar 20, 2014 at 11:18 PM, Herb Lainchbury <[hidden email]> wrote:
HI Tracey,

The list was started on OpenDataBC and then moved here to get more input.  I have not taken it outside to other groups.

The idea is to generate a starting list of top 10 datasets.  Some of the datasets will already have been released by some municipalities.  Others may not have been made available by any municipalities.  The point is for publishers to be able to look at the list and see that people are interested.  I get asked over and over again "what do people want?" so I would like to be able to refer to a top ten list to give publishers and idea of what people are interested in.

For example, if it went out now I might choose:
I fully expect that the initial list will not be perfect but I think the people on the list have enough knowledge either on their own or with their networks to have a crack at it.

Also, I don't know of any group better than this one for getting things done so that's why I brought it here. :)

I am happy to help get this done however people think it should happen.  I like your categories suggestion - so maybe we should work that in somehow - but I was thinking more at the dataset level.

"Herb, you are super great at persistently keeping us going!"
Thank you!  :)

Given this discussion I won't send anything out now so we can hear from a few more voices.

Cheers,
Herb




On Thu, Mar 20, 2014 at 2:36 AM, Tracey P. Lauriault <[hidden email]> wrote:
Hi Herb;

I think much more work needs to be done with these before you can do a survey is released and I think there is merit in grouping them.  Can you remind me how this list was made?  Looks like no social planners, community developers, health, environmentalists, or urban planners, housing experts, disability folks, were involved in the making of this list. What would they want?

Some of the data types are indicators and would require a number of datasets and research projects to get to these.  As I was sorting through them it reminded me of the Quality of life reporting systems of the federation of canadian municipalities, who collect these data from about 30 different institutions at all levels of jurisdiction (Grid of data - http://www.municipaldata-donneesmunicipales.ca/Site/Monitoring/grid.php?lang=en).  These data were decided upon as they told a story, overtime, and served a purpose to understand things in the city. Main headings of the report:
The issue of scale is also important here, is this for cities? if so do we want these data aggregated into neighbourhoods? Wards? electoral districts? dissemination areas? Postal Code areas?  GVRD/Metro van, or Van city? just to exemplify the difference.

I think we are maturing as a community, and maybe we can move beyond lists of datasets and start thinking about the best way for us to understand our cities/towns/etc.and think of the datasets that help us understand those things and then find the ways to communicate/discuss etc. these things. 

Also, some of the data on the list are already available.  Anyway, I have sorted the ones in your list.  I am super swamped for the next week, but I would be really happy to work with you and a few others (james?) to go through previous lists, and I would love to consult with some civil society groups and ask them what they want, environment? Community Health? Social Housing? Disability?  I don't know about you, but I find myself often circulating in the same circles and thus perpetuating ideals from a particular lens, this list I think reflects open data people but not necessarily, data users in the sense of actually using data to inform public policy in a real way, or a campaign, etc.  Open data folks like ourselves, got us here, and that is good, but now, I think we can do more, and communicate to people outside our 'open data circles', to those engaged in the day to day as non open data civil society groups and find out what their needs are.

Below is my first pass at classifying the list you shared, it is imperfect and not mutually exclusive, there are comments in brackets beside them.

Public Expenditures

·         financial data (revenue, expenses, liabilities, equity, etc..)

·         Salaries of public officials

·         consultant fees (Maybe a better statement are gov subcontracting by type)

·         contracts

·         budget management (Not sure what is meant here? Which datasets?)

·         financial - planned expenditures (a.k.a. estimates, appropriations, supply)

·         financial - actual expenditures

·         financial - grant and contribution awards

·         financial - travel and hospitality expenses


Economic Development

·         business license

·         development applications (had twice)

·         approval results of development applications

·         DCC (development cost charges) rates

·         property assessments

·         tax rates (Do they mean property assessments?)

·         annual return data (not just pdf reports) is this taxfiler returns, is so then available at a fee? Which returns?

·         building citations (problems with structures etc...)


Business

·         tender opportunities


Land Use

·         park boundaries (which ones?  National park data are available)

·         land use changes (this too is an indicator, which datasets would be required, for instance parks, building footprints and year of construction, air photos, forests, farm land, etc. With those layers and others over time then land use change analysis is possible, but this is a research project or a geomatics project, not just one dataset)


Infrastructure

·         locations of things (fire hydrants, bike parking, ...)

·         transit data

·         infrastructure deficits (which one? Roads? Power? Broadband?) also this is a measure, or an indicator, so there would need to be specificity in terms of a theme and then a way to measure that

·         road construction (511 data)

·         road maintenance and emergency work (I am guessing not ambulance emergencies but disruptions due to emergencies)


Demographics

·         vital stats

·         demographic data (these are available)


Framework Data

·         electoral districts (these are available)

·         transit data (Feeds? Routes? Schedules?)


Remote Sensing

·         orthophotos

·         lidar


User Fees

·         service fees (For what? Swimming pools? Rec Programs? School fees)


Democratic engagemet

·         hansards – Fed? Prov/ter? I think some are available, but not necessarily in a useful format.  Is the fed hansard now on open data licence?

·         council

·         petitions

·         elected officials contact information (is available at fed and provincial and I think all cities offer this too, was there something specific?)

·         satisfaction survey results (e.g. http://donnees.ville.montreal.qc.ca/dataset/sondage-satisfaction-citoyens)


Planning

·         traffic study data

·         rezoning permit applications

·         service requests (e.g. http://open311.org/)


Health

·         stream health assessments (i do not know what these are?  Wait times?  These data are available from CIHI but for a fee)

·         health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)


Well Being

·         food bank usage stats

·         homelessness stats


Citizen Engagement

·         public consultations


Freedom of Information

·         completed access to information requests (as is done at the federal level)

·         public documents released under access to information laws (as BC does, for most part)

·         transparency and access to information


Political Accountability

·         lobbying disclosures (see http://sunlightfoundation.com/policy/lobbying/guidelines/)

·         political financing (contribution and expenses e.g. http://www.elections.ca/content.aspx?section=fin&lang=e)

·         calendar of meetings

·         agendas of meetings

·         minutes of meetings

·         video of meetings

·         audio of meetings

·         transcripts of meetings

·         role call votes

·         attendance records

Safety

·         crime information


Herb, you are super great at persistently keeping us going!

Cheers
Tracey



On Fri, Mar 14, 2014 at 11:03 PM, Herb Lainchbury <[hidden email]> wrote:
Just in case people are wondering what ever happened to this idea... I haven't forgotten.  The Summit was more of a priority for a while there.

I have compiled a list and plan to send out the survey in the near future.

Cheers,
Herb




On Fri, Dec 13, 2013 at 4:15 PM, Herb Lainchbury <[hidden email]> wrote:
Over on the OpenDataBC google group we're developing a list of top 10 wanted datasets for municipal governments in Canada.

The intention is to simply create a "first cut" at this to use as a starting point and I'm guessing it will evolve over time.  It won't be perfect, but it'll be a place to start.

We would like input from this group.  Please have a look at this list and let me know what, if anything is missing, or if any of these could use some fine tuning.

Once we have a list my intention is to compile this into a SurveyMonkey survey and send it back out to OpenDataBC and this group for voting and we'll see what people think are the top 10.

Here is the current list in no particular order:
  • financial data (revenue, expenses, liabilities, equity, etc..)
  • business license
  • development applications
  • property assessments
  • park boundaries
  • locations of things (fire hydrants, bike parking, ...)
  • tender opportunities
  • electoral districts
  • transit data
  • vital stats / demographic data
  • tax rates
  • service fees
  • infrastructure deficits
  • hansards/council a/v
  • petitions
  • annual return data (not just pdf reports)
  • stats relating to approval or non-approval of development applications
  • DCC (development cost charges) rates
  • salaries
  • consultant fees
  • traffic study data
  • orthophotos
  • lidar
  • stream health assessments
  • food bank usage stats
  • homelessness stats
  • transit data
  • contracts
  • road construction (511 data)
  • building citations (problems with structures etc...)

The question I am thinking of sending is something like:

 "Which of the following datasets should municipalities make a priority and release them as open data?"

If there are any survey geeks out there that see a bias in this question and can suggest better wording please do so.

Also, if any of the bullets seems too ambiguous or vague to be a valid selection alternate suggestions for those would be appreciated.

Thanks,
H




--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" value="+12507046154" target="_blank">250.704.6154



_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss



--

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss
12