Top 10 Municipal Datasets

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

Top 10 Municipal Datasets

Herb Lainchbury
Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

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 Municipal Datasets

James McKinney-2
These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

Herb Lainchbury, Dynamic Solutions
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 Municipal Datasets

James McKinney-2
It’s also in keeping the the Ombudsman of Montreal report, which reports the following top themes:

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


On May 5, 2014, at 8:56 PM, James McKinney <[hidden email]> wrote:

These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

Herb Lainchbury, Dynamic Solutions
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 Municipal Datasets

Herb Lainchbury
In reply to this post by James McKinney-2
I think your edits are right on the mark James.   Thanks for doing that.

Does anyone else have any feedback or suggestions on this before we consider it done?

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

Herb



On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

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 Municipal Datasets

Heather Leson
HI Herb, James and others,

This great list serves early adopters who want access to Open Data for business, civil society or government.

How does this list compare to:
1. Top Searches on Government Websites
2.  A needs assessment for the community (What are the top community needs by area, city, province and country?)

While I think we all have instincts, research on datasets and our own community perspectives, I just want to know if we are targeting our requests to scale and relevancy. "Open Data" is a fairly niche concept still. With the survey, I honestly selected items that I know developers and some community members want. But now, I wonder if we are missing regional/national park data or other services (day cares, public health clinics, etc.)

I am learning as I go with you as my teachers.

Heather





On 7 May 2014 17:30, Herb Lainchbury <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.

Does anyone else have any feedback or suggestions on this before we consider it done?

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

Herb



On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

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



--


 

Heather Leson, Community Engagement Director

Open Knowledge Foundation, Empowering through Open Knowledge

IRC/skype: heatherleson  | @heatherleson

http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |  Newsletter

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

Top 10 municipal datasets

OpenData - Vancouver
In reply to this post by Herb Lainchbury

Hi,

 

My name is Linda Low and I am the Open Data Coordinator for City of Vancouver.  I heard from Herb Lainchbury about the Top 10 survey via a different Google group (OpenDataBC)

 

First of all.  Thanks for the idea and appreciate the effort in driving the survey to the finish line.  It is good to have an indication on what the public wants.  I have since shared the result with my G4 counterparts (Edmonton, Toronto and Ottawa) and on Twitter.

 

A couple of feedback:

·         Advance notice on when the survey will be ran and duration so we could help with promotion and ultimately have a better representative sample

·         Can the list be sorted in descending order so the top 10 could be identified more easily

 

It is still a great idea and I look forward in seeing and sharing future iterations.

 

Linda

 


_______________________________________________
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 Municipal Datasets

Colleen Hardwick
In reply to this post by Herb Lainchbury

Hey Herb.  Just had a great visit with Jury Konga.  PS the rezoing and development permit data was what I was looking for, as puboic consultation is too difficult to define in the short term. It is all good.

On 2014-05-07 2:30 PM, "Herb Lainchbury" <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.

Does anyone else have any feedback or suggestions on this before we consider it done?

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

Herb



On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

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 Municipal Datasets

Herb Lainchbury
awesome!  Thanks Colleen.

H


On Wed, May 7, 2014 at 5:16 PM, Colleen Hardwick <[hidden email]> wrote:

Hey Herb.  Just had a great visit with Jury Konga.  PS the rezoing and development permit data was what I was looking for, as puboic consultation is too difficult to define in the short term. It is all good.

On 2014-05-07 2:30 PM, "Herb Lainchbury" <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.

Does anyone else have any feedback or suggestions on this before we consider it done?

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

Herb



On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

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 Municipal Datasets

Bigelow, Sue

I’ve been watching this discussion with interest since last year, wondering if there would be anything in the Top 10 that the Archives could contribute. Most of the Top 10 are current data, but Land Use Changes looks like one for which we’d have some archival records that could be turned into data.

 

As Herb has pointed out, this is not one existing set of data but more of a project, with the goal of showing different aspects of land use changes.

 

We’d be interested in discussing this further if anyone wants to define the types of records that could be used in such a project, and to suggest preferred formats in which to release them. We’d also be interested in the suggested time span over which a researcher would like to study these changes. For us, older records are easier to release (especially if they no longer under copyright to a 3rd party) but may be of less interest to the researcher. To be clear: we don’t have funding to do all this work as a project ourselves.

 

We’d like to understand

·         what types of archival records would provide the researchers with data on land use changes

·         what formats would be useful

·         how much added value the researchers might be willing or able to add to analogue records

 

Examples:

·         a longitudinal study of zoning plans might be useful to show one aspect of land use changes, but you would probably want to have the plans digitized, georectified and also have (for instance) shapefiles made of the zoning areas? Or could we expect researchers to do all but the digitization themselves? This would also apply to plans showing other features, like municipal parkland

·         Copyright for older ortho air photos was usually held by the company who created them. It wasn’t until recent decades that bodies asked for the rights to re-use them. Anything taken before 1949 would be public domain, but might not be useful for research. The copyright for air photos from an oblique angle was not as carefully protected: those might be re-usable, but not as useful. When we look at our own holdings, we find that we don’t have complete sets of orthophotos for the entire city, and this might be a problem for researchers.

·         Building footprints are available on Fire Insurance Plans but the copyright for these published works makes it difficult to use the more recent ones. Paper plans would have to be digitized and presented in a meaningful way, the same as the zoning plans. I see that Vancouver has one set of digital building footprints for the downtown core for 1999 available, but that looks like a one-off. http://data.vancouver.ca/datacatalogue/buildingFootprint1999.htm

·         For Vancouver, I see that the year of construction for existing buildings is available in Vanmap in the tax attributes table for each property, but I don’t know if it’s available as a data set. Year of construction for demolished buildings is harder to find but is available, but probably not always aggregated. For example, here’s one growing database of building permits for Vancouver: http://permits.heritagevancouver.org/

 

Sue

 

Sue Bigelow
Digital Conservator
City of Vancouver Archives

From: [hidden email] [mailto:[hidden email]] On Behalf Of Herb Lainchbury
Sent: Wednesday, May 07, 2014 5:25 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets

 

awesome!  Thanks Colleen.

 

H

 

On Wed, May 7, 2014 at 5:16 PM, Colleen Hardwick <[hidden email]> wrote:

Hey Herb.  Just had a great visit with Jury Konga.  PS the rezoing and development permit data was what I was looking for, as puboic consultation is too difficult to define in the short term. It is all good.

On 2014-05-07 2:30 PM, "Herb Lainchbury" <[hidden email]> wrote:

I think your edits are right on the mark James.   Thanks for doing that.

 

Does anyone else have any feedback or suggestions on this before we consider it done?

 

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

 

Herb

 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:

These are very useful results!

 

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:

 

 

They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:

 

 

It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

 

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

 

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns

Great work!

 

James

 

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

 

Hey All,

 

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

 

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

 

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

 

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

 

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings

Cheers,

Herb

 

 

--

 

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



 

--

 

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



 

--

 

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 Municipal Datasets

James McKinney-2
Hi Sue,

I haven’t dug into zoning data myself, but the Sunlight Foundation has done great research into zoning data and its uses (including historical data), which it has collected at this address: http://sunlightfoundation.com/policy/municipal_zoning/

I’ll see if anyone from their team might have more specific answers to your questions.

Cheers,

--
James McKinney
Open North
+1.514.247.0223
http://opennorth.ca/


On May 14, 2014, at 7:51 PM, Bigelow, Sue <[hidden email]> wrote:

I’ve been watching this discussion with interest since last year, wondering if there would be anything in the Top 10 that the Archives could contribute. Most of the Top 10 are current data, but Land Use Changes looks like one for which we’d have some archival records that could be turned into data.
 
As Herb has pointed out, this is not one existing set of data but more of a project, with the goal of showing different aspects of land use changes.
 
We’d be interested in discussing this further if anyone wants to define the types of records that could be used in such a project, and to suggest preferred formats in which to release them. We’d also be interested in the suggested time span over which a researcher would like to study these changes. For us, older records are easier to release (especially if they no longer under copyright to a 3rd party) but may be of less interest to the researcher. To be clear: we don’t have funding to do all this work as a project ourselves.
 
We’d like to understand
·         what types of archival records would provide the researchers with data on land use changes
·         what formats would be useful
·         how much added value the researchers might be willing or able to add to analogue records
 
Examples:
·         a longitudinal study of zoning plans might be useful to show one aspect of land use changes, but you would probably want to have the plans digitized, georectified and also have (for instance) shapefiles made of the zoning areas? Or could we expect researchers to do all but the digitization themselves? This would also apply to plans showing other features, like municipal parkland
·         Copyright for older ortho air photos was usually held by the company who created them. It wasn’t until recent decades that bodies asked for the rights to re-use them. Anything taken before 1949 would be public domain, but might not be useful for research. The copyright for air photos from an oblique angle was not as carefully protected: those might be re-usable, but not as useful. When we look at our own holdings, we find that we don’t have complete sets of orthophotos for the entire city, and this might be a problem for researchers.
·         Building footprints are available on Fire Insurance Plans but the copyright for these published works makes it difficult to use the more recent ones. Paper plans would have to be digitized and presented in a meaningful way, the same as the zoning plans. I see that Vancouver has one set of digital building footprints for the downtown core for 1999 available, but that looks like a one-off.http://data.vancouver.ca/datacatalogue/buildingFootprint1999.htm
·         For Vancouver, I see that the year of construction for existing buildings is available in Vanmap in the tax attributes table for each property, but I don’t know if it’s available as a data set. Year of construction for demolished buildings is harder to find but is available, but probably not always aggregated. For example, here’s one growing database of building permits for Vancouver: http://permits.heritagevancouver.org/
 
Sue
 
Sue Bigelow 
Digital Conservator 
City of Vancouver Archives
From: [hidden email] [[hidden email]] On Behalf Of Herb Lainchbury
Sent: Wednesday, May 07, 2014 5:25 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
awesome!  Thanks Colleen.
 
H

 

On Wed, May 7, 2014 at 5:16 PM, Colleen Hardwick <[hidden email]> wrote:

Hey Herb.  Just had a great visit with Jury Konga.  PS the rezoing and development permit data was what I was looking for, as puboic consultation is too difficult to define in the short term. It is all good.

On 2014-05-07 2:30 PM, "Herb Lainchbury" <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.
 
Does anyone else have any feedback or suggestions on this before we consider it done?
 
Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.
 
Herb
 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!
 
I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:
 
 
They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:
 
 
It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.
 
I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:
 
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns
Great work!
 
James
 
On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:
 
Hey All,
 
The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/
 
I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.
 
We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  
 
Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.
 
Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb
 
 
--
 
Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" target="_blank" style="color: purple; text-decoration: underline;">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" target="_blank" style="color: purple; text-decoration: underline;">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


_______________________________________________
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 Municipal Datasets

Herb Lainchbury
In reply to this post by Herb Lainchbury
Hello All,

Thanks to everyone who helped out, voted, shared, discussed and otherwise furthered this project.  Much appreciated.  James, thanks for removing the duplicates.  I suggest we consider it complete at this point.

Canadian Open Data Community Top Ten Wanted Municipal Datasets - May 2014
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
With #1 being the most desired.

Tracey, could we please post this on datalibre so we can all refer to it there and let our various networks know about it?

Thank you!
Herb

ps: I also suggest we review it on a regular basis, perhaps yearly to start?






On Wed, May 7, 2014 at 2:30 PM, Herb Lainchbury <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.

Does anyone else have any feedback or suggestions on this before we consider it done?

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

Herb



On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

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



--

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 Municipal Datasets

James McKinney-2
In reply to this post by James McKinney-2
Hi again Sue,

I just heard back from Alisha Green of the Sunlight Foundation (cc), who had this to add:


"I'm excited that Sue wants to put effort into changing archival land use records into data. Every municipality is a bit different in terms of how it categorizes and stores such records. The information in the records might vary, too. Based on my understanding of this situation, though, here are some ideas that might be of interest: 

· what types of archival records would provide the researchers with data on land use changes

I think providing as much information as possible is the way to move forward here. Researchers can be as selective as they wish within the broad body of information available, but it can't hurt to have more information available in the first place. If there isn't funding available for Sue's team to take on this project, the most meaningful steps would be to sort through what can legally be re-used and to proceed with digitizing that set of records. It could also be useful to get feedback from any groups that might be interested in doing research based on land use records. They could provide specific recommendations about what kind of records would be most useful to have digitized. 

· what formats would be useful

It depends on what kind of information is in the records. If some of the information is in tables, CSV or XML could be useful digital formats. If the records have geographic or geospatial components, it would be good to consider shapefiles and GeoJSON as potential digital formats. 

The last two examples Sue provides seem to be good frameworks for digitizing archival information. If other people have already tried digitizing some kinds of records that Sue's team is considering digitizing, it would be good to ask those who have already gone through the process about their experience. What was their process? What would they do differently if they could do it again? 

I've copied the local team on this email in case they have additional ideas. Please feel free to send this information to the list. I hope it can be of help! 

Best wishes,
Alisha"



On May 14, 2014, at 11:01 PM, James McKinney <[hidden email]> wrote:

Hi Sue,

I haven’t dug into zoning data myself, but the Sunlight Foundation has done great research into zoning data and its uses (including historical data), which it has collected at this address: http://sunlightfoundation.com/policy/municipal_zoning/

I’ll see if anyone from their team might have more specific answers to your questions.

Cheers,

--
James McKinney
Open North
+1.514.247.0223
http://opennorth.ca/


On May 14, 2014, at 7:51 PM, Bigelow, Sue <[hidden email]> wrote:

I’ve been watching this discussion with interest since last year, wondering if there would be anything in the Top 10 that the Archives could contribute. Most of the Top 10 are current data, but Land Use Changes looks like one for which we’d have some archival records that could be turned into data.
 
As Herb has pointed out, this is not one existing set of data but more of a project, with the goal of showing different aspects of land use changes.
 
We’d be interested in discussing this further if anyone wants to define the types of records that could be used in such a project, and to suggest preferred formats in which to release them. We’d also be interested in the suggested time span over which a researcher would like to study these changes. For us, older records are easier to release (especially if they no longer under copyright to a 3rd party) but may be of less interest to the researcher. To be clear: we don’t have funding to do all this work as a project ourselves.
 
We’d like to understand
·         what types of archival records would provide the researchers with data on land use changes
·         what formats would be useful
·         how much added value the researchers might be willing or able to add to analogue records
 
Examples:
·         a longitudinal study of zoning plans might be useful to show one aspect of land use changes, but you would probably want to have the plans digitized, georectified and also have (for instance) shapefiles made of the zoning areas? Or could we expect researchers to do all but the digitization themselves? This would also apply to plans showing other features, like municipal parkland
·         Copyright for older ortho air photos was usually held by the company who created them. It wasn’t until recent decades that bodies asked for the rights to re-use them. Anything taken before 1949 would be public domain, but might not be useful for research. The copyright for air photos from an oblique angle was not as carefully protected: those might be re-usable, but not as useful. When we look at our own holdings, we find that we don’t have complete sets of orthophotos for the entire city, and this might be a problem for researchers.
·         Building footprints are available on Fire Insurance Plans but the copyright for these published works makes it difficult to use the more recent ones. Paper plans would have to be digitized and presented in a meaningful way, the same as the zoning plans. I see that Vancouver has one set of digital building footprints for the downtown core for 1999 available, but that looks like a one-off.http://data.vancouver.ca/datacatalogue/buildingFootprint1999.htm
·         For Vancouver, I see that the year of construction for existing buildings is available in Vanmap in the tax attributes table for each property, but I don’t know if it’s available as a data set. Year of construction for demolished buildings is harder to find but is available, but probably not always aggregated. For example, here’s one growing database of building permits for Vancouver: http://permits.heritagevancouver.org/
 
Sue
 
Sue Bigelow 
Digital Conservator 
City of Vancouver Archives
From: [hidden email] [[hidden email]] On Behalf Of Herb Lainchbury
Sent: Wednesday, May 07, 2014 5:25 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
awesome!  Thanks Colleen.
 
H

 

On Wed, May 7, 2014 at 5:16 PM, Colleen Hardwick <[hidden email]> wrote:

Hey Herb.  Just had a great visit with Jury Konga.  PS the rezoing and development permit data was what I was looking for, as puboic consultation is too difficult to define in the short term. It is all good.

On 2014-05-07 2:30 PM, "Herb Lainchbury" <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.
 
Does anyone else have any feedback or suggestions on this before we consider it done?
 
Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.
 
Herb
 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!
 
I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:
 
 
They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:
 
 
It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.
 
I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:
 
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns
Great work!
 
James
 
On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:
 
Hey All,
 
The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/
 
I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.
 
We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  
 
Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.
 
Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb
 
 
--
 
Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" target="_blank" style="color: purple; text-decoration: underline;">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" target="_blank" style="color: purple; text-decoration: underline;">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



_______________________________________________
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 Municipal Datasets

Bigelow, Sue
Thanks, that's helpful!

We'll take a look at what we've got and what we can do with it.

At least, readers of this list will know we're interested in pursuing this, so if anyone wants to research land use change in Vancouver, we might be contacted.

Sue Bigelow

Digital Conservator

City of Vancouver Archives

1150 Chestnut Street
Vancouver, BC V6J 3J9
Tel 604.829.4271
Fax 604.736.0626


http://vancouver.ca/archives

See us on YouTube

Follow us on Twitter

Our Flickr stream

Our blog, AuthentiCity


From: [hidden email] [[hidden email]] on behalf of James McKinney [[hidden email]]
Sent: May 15, 2014 7:43 PM
To: civicaccess discuss
Cc: Alisha Green
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets

Hi again Sue,

I just heard back from Alisha Green of the Sunlight Foundation (cc), who had this to add:


"I'm excited that Sue wants to put effort into changing archival land use records into data. Every municipality is a bit different in terms of how it categorizes and stores such records. The information in the records might vary, too. Based on my understanding of this situation, though, here are some ideas that might be of interest: 

· what types of archival records would provide the researchers with data on land use changes

I think providing as much information as possible is the way to move forward here. Researchers can be as selective as they wish within the broad body of information available, but it can't hurt to have more information available in the first place. If there isn't funding available for Sue's team to take on this project, the most meaningful steps would be to sort through what can legally be re-used and to proceed with digitizing that set of records. It could also be useful to get feedback from any groups that might be interested in doing research based on land use records. They could provide specific recommendations about what kind of records would be most useful to have digitized. 

· what formats would be useful

It depends on what kind of information is in the records. If some of the information is in tables, CSV or XML could be useful digital formats. If the records have geographic or geospatial components, it would be good to consider shapefiles and GeoJSON as potential digital formats. 

The last two examples Sue provides seem to be good frameworks for digitizing archival information. If other people have already tried digitizing some kinds of records that Sue's team is considering digitizing, it would be good to ask those who have already gone through the process about their experience. What was their process? What would they do differently if they could do it again? 

I've copied the local team on this email in case they have additional ideas. Please feel free to send this information to the list. I hope it can be of help! 

Best wishes,
Alisha"



On May 14, 2014, at 11:01 PM, James McKinney <[hidden email]> wrote:

Hi Sue,

I haven’t dug into zoning data myself, but the Sunlight Foundation has done great research into zoning data and its uses (including historical data), which it has collected at this address: http://sunlightfoundation.com/policy/municipal_zoning/

I’ll see if anyone from their team might have more specific answers to your questions.

Cheers,

--
James McKinney
Open North
+1.514.247.0223
http://opennorth.ca/


On May 14, 2014, at 7:51 PM, Bigelow, Sue <[hidden email]> wrote:

I’ve been watching this discussion with interest since last year, wondering if there would be anything in the Top 10 that the Archives could contribute. Most of the Top 10 are current data, but Land Use Changes looks like one for which we’d have some archival records that could be turned into data.
 
As Herb has pointed out, this is not one existing set of data but more of a project, with the goal of showing different aspects of land use changes.
 
We’d be interested in discussing this further if anyone wants to define the types of records that could be used in such a project, and to suggest preferred formats in which to release them. We’d also be interested in the suggested time span over which a researcher would like to study these changes. For us, older records are easier to release (especially if they no longer under copyright to a 3rd party) but may be of less interest to the researcher. To be clear: we don’t have funding to do all this work as a project ourselves.
 
We’d like to understand
·         what types of archival records would provide the researchers with data on land use changes
·         what formats would be useful
·         how much added value the researchers might be willing or able to add to analogue records
 
Examples:
·         a longitudinal study of zoning plans might be useful to show one aspect of land use changes, but you would probably want to have the plans digitized, georectified and also have (for instance) shapefiles made of the zoning areas? Or could we expect researchers to do all but the digitization themselves? This would also apply to plans showing other features, like municipal parkland
·         Copyright for older ortho air photos was usually held by the company who created them. It wasn’t until recent decades that bodies asked for the rights to re-use them. Anything taken before 1949 would be public domain, but might not be useful for research. The copyright for air photos from an oblique angle was not as carefully protected: those might be re-usable, but not as useful. When we look at our own holdings, we find that we don’t have complete sets of orthophotos for the entire city, and this might be a problem for researchers.
·         Building footprints are available on Fire Insurance Plans but the copyright for these published works makes it difficult to use the more recent ones. Paper plans would have to be digitized and presented in a meaningful way, the same as the zoning plans. I see that Vancouver has one set of digital building footprints for the downtown core for 1999 available, but that looks like a one-off.http://data.vancouver.ca/datacatalogue/buildingFootprint1999.htm
·         For Vancouver, I see that the year of construction for existing buildings is available in Vanmap in the tax attributes table for each property, but I don’t know if it’s available as a data set. Year of construction for demolished buildings is harder to find but is available, but probably not always aggregated. For example, here’s one growing database of building permits for Vancouver: http://permits.heritagevancouver.org/
 
Sue
 
Sue Bigelow 
Digital Conservator 
City of Vancouver Archives
From: [hidden email] [[hidden email]] On Behalf Of Herb Lainchbury
Sent: Wednesday, May 07, 2014 5:25 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
awesome!  Thanks Colleen.
 
H

 

On Wed, May 7, 2014 at 5:16 PM, Colleen Hardwick <[hidden email]> wrote:

Hey Herb.  Just had a great visit with Jury Konga.  PS the rezoing and development permit data was what I was looking for, as puboic consultation is too difficult to define in the short term. It is all good.

On 2014-05-07 2:30 PM, "Herb Lainchbury" <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.
 
Does anyone else have any feedback or suggestions on this before we consider it done?
 
Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.
 
Herb
 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!
 
I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:
 
 
They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:
 
 
It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.
 
I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:
 
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns
Great work!
 
James
 
On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:
 
Hey All,
 
The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/
 
I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.
 
We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  
 
Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.
 
Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb
 
 
--
 
Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" style="color:purple; text-decoration:underline" 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" style="color:purple; text-decoration:underline" 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



_______________________________________________
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 Municipal Datasets

James McKinney-2
In reply to this post by Herb Lainchbury
Awesome! And now to share the list with open data municipalities, so that we get more datasets released from this list, and fewer datasets like helicopter landing sites. Nelson mentioned sharing with MISA, for instance.

I don’t know if the list will change every year, but I think it would be worthwhile to repeat next year, based on what we’ve learned. For example, as Linda wrote, we can work with open data municipalities to do better promotion. And as Heather wrote, we should think of ways to get the survey to people outside of open data. We can also make it bilingual. I’m sure we can continue to improve the list of survey options; my only comment at this point is to split up “locations of things” to be more specific.

Following up on another of Heather’s comments, if we can get municipalities to release "Top Searches on Government Websites” as a dataset, that would help inform the list of wanted datasets as well.

Thanks, Herb, and everyone who helped make this first top 10 list!

James


On May 14, 2014, at 11:13 PM, Herb Lainchbury <[hidden email]> wrote:

Hello All,

Thanks to everyone who helped out, voted, shared, discussed and otherwise furthered this project.  Much appreciated.  James, thanks for removing the duplicates.  I suggest we consider it complete at this point.

Canadian Open Data Community Top Ten Wanted Municipal Datasets - May 2014
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
With #1 being the most desired.

Tracey, could we please post this on datalibre so we can all refer to it there and let our various networks know about it?

Thank you!
Herb

ps: I also suggest we review it on a regular basis, perhaps yearly to start?






On Wed, May 7, 2014 at 2:30 PM, Herb Lainchbury <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.

Does anyone else have any feedback or suggestions on this before we consider it done?

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

Herb



On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:


They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:


It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
Great work!

James

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

Hey All,

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb


--

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



--

Herb Lainchbury, Dynamic Solutions
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 Municipal Datasets

Jury Konga

Hello all,

 

Agreed this is a great start and something to build on over time.  Yesterday, at the GO Open Data Conference in Toronto #GOOD14,  I announced that the Open Knowledge Foundation – Canada will be ramping up to launch a Canadian Local Open Data Census this summer.  The OKF local version template began in February with a number of countries participating – here’s the U.S.  version  http://us-city.census.okfn.org/    Here’s the initial blog post by Rufus Pollock http://blog.okfn.org/2014/02/04/announcing-the-local-open-data-census/

 

I’ve talked to Herb and a few others about this project and looking for others that might be interested in assisting.  See some similarities in the Top 10 and the OKF list – there is some latitude in changing data sets used in the census although the idea with standardizing the data sets is to allow comparisons not only within our country but also with other countries local data.

 

Let me know if you’re interested.

 

Cheers  Jury Konga

 

OKF Canada Ambassador

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of James McKinney
Sent: May-16-14 1:26 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets

 

Awesome! And now to share the list with open data municipalities, so that we get more datasets released from this list, and fewer datasets like helicopter landing sites. Nelson mentioned sharing with MISA, for instance.

 

I don’t know if the list will change every year, but I think it would be worthwhile to repeat next year, based on what we’ve learned. For example, as Linda wrote, we can work with open data municipalities to do better promotion. And as Heather wrote, we should think of ways to get the survey to people outside of open data. We can also make it bilingual. I’m sure we can continue to improve the list of survey options; my only comment at this point is to split up “locations of things” to be more specific.

 

Following up on another of Heather’s comments, if we can get municipalities to release "Top Searches on Government Websites” as a dataset, that would help inform the list of wanted datasets as well.

 

Thanks, Herb, and everyone who helped make this first top 10 list!

 

James

 

 

On May 14, 2014, at 11:13 PM, Herb Lainchbury <[hidden email]> wrote:



Hello All,

 

Thanks to everyone who helped out, voted, shared, discussed and otherwise furthered this project.  Much appreciated.  James, thanks for removing the duplicates.  I suggest we consider it complete at this point.

 

Canadian Open Data Community Top Ten Wanted Municipal Datasets - May 2014

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns

With #1 being the most desired.

 

Tracey, could we please post this on datalibre so we can all refer to it there and let our various networks know about it?

 

Thank you!

Herb

 

ps: I also suggest we review it on a regular basis, perhaps yearly to start?

 

 

 

 

 

On Wed, May 7, 2014 at 2:30 PM, Herb Lainchbury <[hidden email]> wrote:

I think your edits are right on the mark James.   Thanks for doing that.

 

Does anyone else have any feedback or suggestions on this before we consider it done?

 

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

 

Herb

 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:

These are very useful results!

 

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:

 

 

They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:

 

 

It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

 

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

 

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns

Great work!

 

James

 

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

 

Hey All,

 

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

 

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

 

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

 

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

 

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings

Cheers,

Herb

 

 

--

 

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



 

--

 

Herb Lainchbury, Dynamic Solutions

<a href="tel:250.704.6154" 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

 


_______________________________________________
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 Municipal Datasets

James McKinney-2
Can you describe what tasks people can assist with?

James

On May 16, 2014, at 2:15 PM, Jury Konga <[hidden email]> wrote:

Hello all,
 
Agreed this is a great start and something to build on over time.  Yesterday, at the GO Open Data Conference in Toronto #GOOD14,  I announced that the Open Knowledge Foundation – Canada will be ramping up to launch a Canadian Local Open Data Census this summer.  The OKF local version template began in February with a number of countries participating – here’s the U.S.  version  http://us-city.census.okfn.org/    Here’s the initial blog post by Rufus Pollock http://blog.okfn.org/2014/02/04/announcing-the-local-open-data-census/
 
I’ve talked to Herb and a few others about this project and looking for others that might be interested in assisting.  See some similarities in the Top 10 and the OKF list – there is some latitude in changing data sets used in the census although the idea with standardizing the data sets is to allow comparisons not only within our country but also with other countries local data.
 
Let me know if you’re interested.
 
Cheers  Jury Konga
 
OKF Canada Ambassador
 
From: [hidden email] [[hidden email]] On Behalf OfJames McKinney
Sent: May-16-14 1:26 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
Awesome! And now to share the list with open data municipalities, so that we get more datasets released from this list, and fewer datasets like helicopter landing sites. Nelson mentioned sharing with MISA, for instance.
 
I don’t know if the list will change every year, but I think it would be worthwhile to repeat next year, based on what we’ve learned. For example, as Linda wrote, we can work with open data municipalities to do better promotion. And as Heather wrote, we should think of ways to get the survey to people outside of open data. We can also make it bilingual. I’m sure we can continue to improve the list of survey options; my only comment at this point is to split up “locations of things” to be more specific.
 
Following up on another of Heather’s comments, if we can get municipalities to release "Top Searches on Government Websites” as a dataset, that would help inform the list of wanted datasets as well.
 
Thanks, Herb, and everyone who helped make this first top 10 list!
 
James
 
 
On May 14, 2014, at 11:13 PM, Herb Lainchbury <[hidden email]> wrote:


Hello All,
 
Thanks to everyone who helped out, voted, shared, discussed and otherwise furthered this project.  Much appreciated.  James, thanks for removing the duplicates.  I suggest we consider it complete at this point.
 
Canadian Open Data Community Top Ten Wanted Municipal Datasets - May 2014
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
With #1 being the most desired.
 
Tracey, could we please post this on datalibre so we can all refer to it there and let our various networks know about it?
 
Thank you!
Herb
 
ps: I also suggest we review it on a regular basis, perhaps yearly to start?
 
 
 
 

 

On Wed, May 7, 2014 at 2:30 PM, Herb Lainchbury <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.
 
Does anyone else have any feedback or suggestions on this before we consider it done?
 
Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.
 
Herb
 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!
 
I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:
 
 
They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:
 
 
It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.
 
I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:
 
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns
Great work!
 
James
 
On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:
 
Hey All,
 
The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/
 
I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.
 
We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  
 
Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.
 
Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb
 
 
--
 
Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" target="_blank" style="color: purple; text-decoration: underline;">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" target="_blank" style="color: purple; text-decoration: underline;">250.704.6154


 
--
 
Herb Lainchbury, Dynamic Solutions
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 Municipal Datasets

Jury Konga

Hi James

 

Catching up … there’s essentially three tasks that require assistance:

1.        Community/Custodian input to the census (series of questions to answer for each of the pre-defined data sets);

2.       Census “Editor” or “Validator” – this requires someone that can assess and confirm/edit the community input.  This task must be undertaken by a community member and not the data custodian.

3.       Census Administration – initial setup and updates to the website and census config and updating to new versions.  The census is a work-in-progress - see Github  https://github.com/okfn/opendatacensus

 

The initial input can be done by anyone – I’ll be reaching out to the local municipal open data custodians and encourage them to input the initial info.  This can also be done by the members of the local open data community.

 

The initial work was done by the OKF UK but this initiative is for Canada’s version of the Local Open Data Census.  I’m wide open to suggestions on the process as James you and Tracey had experience with the national census.  There are a number of ways to possible approach the editing/validation task – Herb had an excellent suggestion that looked to thematic SMEs to look at their speciality datasets across all the jurisdictions – example being Stephane for Transportation.  I’ll be having discussions with the census coordinators in other countries and would welcome everyone’s suggestions to make a Made in Canada solution for us.  Thanks.

 

Cheers  Jury

 

From: [hidden email] [mailto:[hidden email]] On Behalf Of James McKinney
Sent: May-16-14 2:49 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets

 

Can you describe what tasks people can assist with?

 

James

 

On May 16, 2014, at 2:15 PM, Jury Konga <[hidden email]> wrote:



Hello all,

 

Agreed this is a great start and something to build on over time.  Yesterday, at the GO Open Data Conference in Toronto #GOOD14,  I announced that the Open Knowledge Foundation – Canada will be ramping up to launch a Canadian Local Open Data Census this summer.  The OKF local version template began in February with a number of countries participating – here’s the U.S.  version  http://us-city.census.okfn.org/    Here’s the initial blog post by Rufus Pollock http://blog.okfn.org/2014/02/04/announcing-the-local-open-data-census/

 

I’ve talked to Herb and a few others about this project and looking for others that might be interested in assisting.  See some similarities in the Top 10 and the OKF list – there is some latitude in changing data sets used in the census although the idea with standardizing the data sets is to allow comparisons not only within our country but also with other countries local data.

 

Let me know if you’re interested.

 

Cheers  Jury Konga

 

OKF Canada Ambassador

 

From: [hidden email] [[hidden email]] On Behalf OfJames McKinney
Sent: May-16-14 1:26 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets

 

Awesome! And now to share the list with open data municipalities, so that we get more datasets released from this list, and fewer datasets like helicopter landing sites. Nelson mentioned sharing with MISA, for instance.

 

I don’t know if the list will change every year, but I think it would be worthwhile to repeat next year, based on what we’ve learned. For example, as Linda wrote, we can work with open data municipalities to do better promotion. And as Heather wrote, we should think of ways to get the survey to people outside of open data. We can also make it bilingual. I’m sure we can continue to improve the list of survey options; my only comment at this point is to split up “locations of things” to be more specific.

 

Following up on another of Heather’s comments, if we can get municipalities to release "Top Searches on Government Websites” as a dataset, that would help inform the list of wanted datasets as well.

 

Thanks, Herb, and everyone who helped make this first top 10 list!

 

James

 

 

On May 14, 2014, at 11:13 PM, Herb Lainchbury <[hidden email]> wrote:




Hello All,

 

Thanks to everyone who helped out, voted, shared, discussed and otherwise furthered this project.  Much appreciated.  James, thanks for removing the duplicates.  I suggest we consider it complete at this point.

 

Canadian Open Data Community Top Ten Wanted Municipal Datasets - May 2014

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns

With #1 being the most desired.

 

Tracey, could we please post this on datalibre so we can all refer to it there and let our various networks know about it?

 

Thank you!

Herb

 

ps: I also suggest we review it on a regular basis, perhaps yearly to start?

 

 

 

 

 

On Wed, May 7, 2014 at 2:30 PM, Herb Lainchbury <[hidden email]> wrote:

I think your edits are right on the mark James.   Thanks for doing that.

 

Does anyone else have any feedback or suggestions on this before we consider it done?

 

Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.

 

Herb

 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:

These are very useful results!

 

I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:

 

 

They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:

 

 

It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.

 

I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:

 

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns

Great work!

 

James

 

On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:

 

Hey All,

 

The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/

 

I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.

 

We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  

 

Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.

 

Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.

  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings

Cheers,

Herb

 

 

--

 

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



 

--

 

Herb Lainchbury, Dynamic Solutions

<a href="tel:250.704.6154" 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

 

_______________________________________________
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 Municipal Datasets

James McKinney-2
Thanks, Jury.

With the local census, I think there’s a greater opportunity to engage the municipalities themselves in filling in the census. By filling it in themselves, they’ll recognize what’s missing, and maybe add some datasets to improve their score in the index. This would also help us identify the open data leads in each municipality and build relationships.

However, it should not only be about municipalities with open data. Half of the 50 largest municipalities don’t have open data yet. This census should be used to motivate those cities to adopt open data. We should reach out to clerks in municipalities without open data to ask them to fill in the survey, and ideally use the opportunity to better understand whether they are considering open data, what the challenges are, etc.

Open North is starting a new project that will involve the more labor-intensive, talking-to-cities activities that I described, so it won’t be difficult to add in a request to participate in the census. We’ll be starting that project next month, at which point I’ll be able to give more details (not my choice, the funder’s).

I also really need to stress that it’s very important for the census to be bilingual.

What are the timelines / time-windows for the Canadian version? (e.g. timing of initial outreach to custodians, amount of time reserved for validation, ultimate deadline, etc.)

James


On May 19, 2014, at 1:43 PM, Jury Konga <[hidden email]> wrote:

Hi James
 
Catching up … there’s essentially three tasks that require assistance:
1.        Community/Custodian input to the census (series of questions to answer for each of the pre-defined data sets);
2.       Census “Editor” or “Validator” – this requires someone that can assess and confirm/edit the community input.  This task must be undertaken by a community member and not the data custodian.
3.       Census Administration – initial setup and updates to the website and census config and updating to new versions.  The census is a work-in-progress - see Github  https://github.com/okfn/opendatacensus
 
The initial input can be done by anyone – I’ll be reaching out to the local municipal open data custodians and encourage them to input the initial info.  This can also be done by the members of the local open data community.
 
The initial work was done by the OKF UK but this initiative is for Canada’s version of the Local Open Data Census.  I’m wide open to suggestions on the process as James you and Tracey had experience with the national census.  There are a number of ways to possible approach the editing/validation task – Herb had an excellent suggestion that looked to thematic SMEs to look at their speciality datasets across all the jurisdictions – example being Stephane for Transportation.  I’ll be having discussions with the census coordinators in other countries and would welcome everyone’s suggestions to make a Made in Canada solution for us.  Thanks.
 
Cheers  Jury
 
From: [hidden email] [[hidden email]] On Behalf OfJames McKinney
Sent: May-16-14 2:49 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
Can you describe what tasks people can assist with?
 
James
 
On May 16, 2014, at 2:15 PM, Jury Konga <[hidden email]> wrote:


Hello all,
 
Agreed this is a great start and something to build on over time.  Yesterday, at the GO Open Data Conference in Toronto #GOOD14,  I announced that the Open Knowledge Foundation – Canada will be ramping up to launch a Canadian Local Open Data Census this summer.  The OKF local version template began in February with a number of countries participating – here’s the U.S.  version  http://us-city.census.okfn.org/    Here’s the initial blog post by Rufus Pollock http://blog.okfn.org/2014/02/04/announcing-the-local-open-data-census/
 
I’ve talked to Herb and a few others about this project and looking for others that might be interested in assisting.  See some similarities in the Top 10 and the OKF list – there is some latitude in changing data sets used in the census although the idea with standardizing the data sets is to allow comparisons not only within our country but also with other countries local data.
 
Let me know if you’re interested.
 
Cheers  Jury Konga
 
OKF Canada Ambassador
 
From: [hidden email] [[hidden email]] On Behalf OfJames McKinney
Sent: May-16-14 1:26 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
Awesome! And now to share the list with open data municipalities, so that we get more datasets released from this list, and fewer datasets like helicopter landing sites. Nelson mentioned sharing with MISA, for instance.
 
I don’t know if the list will change every year, but I think it would be worthwhile to repeat next year, based on what we’ve learned. For example, as Linda wrote, we can work with open data municipalities to do better promotion. And as Heather wrote, we should think of ways to get the survey to people outside of open data. We can also make it bilingual. I’m sure we can continue to improve the list of survey options; my only comment at this point is to split up “locations of things” to be more specific.
 
Following up on another of Heather’s comments, if we can get municipalities to release "Top Searches on Government Websites” as a dataset, that would help inform the list of wanted datasets as well.
 
Thanks, Herb, and everyone who helped make this first top 10 list!
 
James
 
 
On May 14, 2014, at 11:13 PM, Herb Lainchbury <[hidden email]> wrote:



Hello All,
 
Thanks to everyone who helped out, voted, shared, discussed and otherwise furthered this project.  Much appreciated.  James, thanks for removing the duplicates.  I suggest we consider it complete at this point.
 
Canadian Open Data Community Top Ten Wanted Municipal Datasets - May 2014
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
With #1 being the most desired.
 
Tracey, could we please post this on datalibre so we can all refer to it there and let our various networks know about it?
 
Thank you!
Herb
 
ps: I also suggest we review it on a regular basis, perhaps yearly to start?
 
 
 
 

 

On Wed, May 7, 2014 at 2:30 PM, Herb Lainchbury <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.
 
Does anyone else have any feedback or suggestions on this before we consider it done?
 
Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.
 
Herb
 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!
 
I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:
 
 
They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:
 
 
It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.
 
I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:
 
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns
Great work!
 
James
 
On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:
 
Hey All,
 
The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/
 
I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.
 
We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  
 
Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.
 
Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb
 
 
--
 
Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" target="_blank" style="color: purple; text-decoration: underline;">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" target="_blank" style="color: purple; text-decoration: underline;">250.704.6154


 
--
 
Herb Lainchbury, Dynamic Solutions
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


_______________________________________________
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 Municipal Datasets

Tracey P. Lauriault
Jury,

A bilingual survey is absolutely necessary. Has France not translated it?  I also like the idea of independent reviewers and James' deeper relationship building approach, as well as your suggestion of enlisting the assistance of subject matter specialists.

I participated in the Irish Census with Denis Parfenov, and being able to consult with experts was key as it was when James and I did it.  The biggest issue however was the census was always changeable by just about anyone.

A truly canadian census would also include an examination of provinces and territories as they too hold very important datasets such as cadastres, health and education data, student loans, business registries, different environmental datasets and so on as they have different jurisdictional powers than the feds. In fact most of social and health spending is at that level, as it much infrastructure spending.

The UK is a unitary state, as are many countries in Europe, and the census was based on it, however, had the EU had to fill out the census, they too would encounter the complexities we have.

Cheers
T

On Tuesday, May 20, 2014, James McKinney <[hidden email]> wrote:
Thanks, Jury.

With the local census, I think there’s a greater opportunity to engage the municipalities themselves in filling in the census. By filling it in themselves, they’ll recognize what’s missing, and maybe add some datasets to improve their score in the index. This would also help us identify the open data leads in each municipality and build relationships.

However, it should not only be about municipalities with open data. Half of the 50 largest municipalities don’t have open data yet. This census should be used to motivate those cities to adopt open data. We should reach out to clerks in municipalities without open data to ask them to fill in the survey, and ideally use the opportunity to better understand whether they are considering open data, what the challenges are, etc.

Open North is starting a new project that will involve the more labor-intensive, talking-to-cities activities that I described, so it won’t be difficult to add in a request to participate in the census. We’ll be starting that project next month, at which point I’ll be able to give more details (not my choice, the funder’s).

I also really need to stress that it’s very important for the census to be bilingual.

What are the timelines / time-windows for the Canadian version? (e.g. timing of initial outreach to custodians, amount of time reserved for validation, ultimate deadline, etc.)

James


On May 19, 2014, at 1:43 PM, Jury Konga <<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;jkonga@sympatico.ca&#39;);" target="_blank">jkonga@...> wrote:

Hi James
 
Catching up … there’s essentially three tasks that require assistance:
1.        Community/Custodian input to the census (series of questions to answer for each of the pre-defined data sets);
2.       Census “Editor” or “Validator” – this requires someone that can assess and confirm/edit the community input.  This task must be undertaken by a community member and not the data custodian.
3.       Census Administration – initial setup and updates to the website and census config and updating to new versions.  The census is a work-in-progress - see Github  https://github.com/okfn/opendatacensus
 
The initial input can be done by anyone – I’ll be reaching out to the local municipal open data custodians and encourage them to input the initial info.  This can also be done by the members of the local open data community.
 
The initial work was done by the OKF UK but this initiative is for Canada’s version of the Local Open Data Census.  I’m wide open to suggestions on the process as James you and Tracey had experience with the national census.  There are a number of ways to possible approach the editing/validation task – Herb had an excellent suggestion that looked to thematic SMEs to look at their speciality datasets across all the jurisdictions – example being Stephane for Transportation.  I’ll be having discussions with the census coordinators in other countries and would welcome everyone’s suggestions to make a Made in Canada solution for us.  Thanks.
 
Cheers  Jury
 
From: <a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;civicaccess-discuss-bounces@civicaccess.ca&#39;);" target="_blank">civicaccess-discuss-bounces@... [<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;civicaccess-discuss-bounces@civicaccess.ca&#39;);" target="_blank">mailto:civicaccess-discuss-bounces@...] On Behalf OfJames McKinney
Sent: May-16-14 2:49 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
Can you describe what tasks people can assist with?
 
James
 
On May 16, 2014, at 2:15 PM, Jury Konga <[hidden email]> wrote:


Hello all,
 
Agreed this is a great start and something to build on over time.  Yesterday, at the GO Open Data Conference in Toronto #GOOD14,  I announced that the Open Knowledge Foundation – Canada will be ramping up to launch a Canadian Local Open Data Census this summer.  The OKF local version template began in February with a number of countries participating – here’s the U.S.  version  http://us-city.census.okfn.org/    Here’s the initial blog post by Rufus Pollock http://blog.okfn.org/2014/02/04/announcing-the-local-open-data-census/
 
I’ve talked to Herb and a few others about this project and looking for others that might be interested in assisting.  See some similarities in the Top 10 and the OKF list – there is some latitude in changing data sets used in the census although the idea with standardizing the data sets is to allow comparisons not only within our country but also with other countries local data.
 
Let me know if you’re interested.
 
Cheers  Jury Konga
 
OKF Canada Ambassador
 
_______________________________________________
CivicAccess-discuss mailing list
<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;CivicAccess-discuss@civicaccess.ca&#39;);" style="color:purple;text-decoration:underline" target="_blank">CivicAccess-discuss@...
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 Municipal Datasets

Jury Konga
In reply to this post by James McKinney-2
Hey James

Great feedback - thank you! I particularly like the use of the census to encourage other cities to go open. I agree with the need for the census to be bilingual and looking for help in that area. 

Looking forward to hearing from others :-)

Cheers Jury

Jury Konga, Principal
eGovFutures Group
 
Open Knowledge Foundation - Canada Ambassador
Canadian Open Data Institute - Co-Founder
Ontario IPC "Access by Design" Ambassador

T.  905-640-7377
C. 647-393-8045
Skype.  jury.konga
Twitter @jkonga


Sent from my iPhone

On May 19, 2014, at 10:51 PM, James McKinney <[hidden email]> wrote:

Thanks, Jury.

With the local census, I think there’s a greater opportunity to engage the municipalities themselves in filling in the census. By filling it in themselves, they’ll recognize what’s missing, and maybe add some datasets to improve their score in the index. This would also help us identify the open data leads in each municipality and build relationships.

However, it should not only be about municipalities with open data. Half of the 50 largest municipalities don’t have open data yet. This census should be used to motivate those cities to adopt open data. We should reach out to clerks in municipalities without open data to ask them to fill in the survey, and ideally use the opportunity to better understand whether they are considering open data, what the challenges are, etc.

Open North is starting a new project that will involve the more labor-intensive, talking-to-cities activities that I described, so it won’t be difficult to add in a request to participate in the census. We’ll be starting that project next month, at which point I’ll be able to give more details (not my choice, the funder’s).

I also really need to stress that it’s very important for the census to be bilingual.

What are the timelines / time-windows for the Canadian version? (e.g. timing of initial outreach to custodians, amount of time reserved for validation, ultimate deadline, etc.)

James


On May 19, 2014, at 1:43 PM, Jury Konga <[hidden email]> wrote:

Hi James
 
Catching up … there’s essentially three tasks that require assistance:
1.        Community/Custodian input to the census (series of questions to answer for each of the pre-defined data sets);
2.       Census “Editor” or “Validator” – this requires someone that can assess and confirm/edit the community input.  This task must be undertaken by a community member and not the data custodian.
3.       Census Administration – initial setup and updates to the website and census config and updating to new versions.  The census is a work-in-progress - see Github  https://github.com/okfn/opendatacensus
 
The initial input can be done by anyone – I’ll be reaching out to the local municipal open data custodians and encourage them to input the initial info.  This can also be done by the members of the local open data community.
 
The initial work was done by the OKF UK but this initiative is for Canada’s version of the Local Open Data Census.  I’m wide open to suggestions on the process as James you and Tracey had experience with the national census.  There are a number of ways to possible approach the editing/validation task – Herb had an excellent suggestion that looked to thematic SMEs to look at their speciality datasets across all the jurisdictions – example being Stephane for Transportation.  I’ll be having discussions with the census coordinators in other countries and would welcome everyone’s suggestions to make a Made in Canada solution for us.  Thanks.
 
Cheers  Jury
 
From: [hidden email] [[hidden email]] On Behalf OfJames McKinney
Sent: May-16-14 2:49 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
Can you describe what tasks people can assist with?
 
James
 
On May 16, 2014, at 2:15 PM, Jury Konga <[hidden email]> wrote:


Hello all,
 
Agreed this is a great start and something to build on over time.  Yesterday, at the GO Open Data Conference in Toronto #GOOD14,  I announced that the Open Knowledge Foundation – Canada will be ramping up to launch a Canadian Local Open Data Census this summer.  The OKF local version template began in February with a number of countries participating – here’s the U.S.  version  http://us-city.census.okfn.org/    Here’s the initial blog post by Rufus Pollock http://blog.okfn.org/2014/02/04/announcing-the-local-open-data-census/
 
I’ve talked to Herb and a few others about this project and looking for others that might be interested in assisting.  See some similarities in the Top 10 and the OKF list – there is some latitude in changing data sets used in the census although the idea with standardizing the data sets is to allow comparisons not only within our country but also with other countries local data.
 
Let me know if you’re interested.
 
Cheers  Jury Konga
 
OKF Canada Ambassador
 
From: [hidden email] [[hidden email]] On Behalf OfJames McKinney
Sent: May-16-14 1:26 PM
To: civicaccess discuss
Subject: Re: [CivicAccess-discuss] Top 10 Municipal Datasets
 
Awesome! And now to share the list with open data municipalities, so that we get more datasets released from this list, and fewer datasets like helicopter landing sites. Nelson mentioned sharing with MISA, for instance.
 
I don’t know if the list will change every year, but I think it would be worthwhile to repeat next year, based on what we’ve learned. For example, as Linda wrote, we can work with open data municipalities to do better promotion. And as Heather wrote, we should think of ways to get the survey to people outside of open data. We can also make it bilingual. I’m sure we can continue to improve the list of survey options; my only comment at this point is to split up “locations of things” to be more specific.
 
Following up on another of Heather’s comments, if we can get municipalities to release "Top Searches on Government Websites” as a dataset, that would help inform the list of wanted datasets as well.
 
Thanks, Herb, and everyone who helped make this first top 10 list!
 
James
 
 
On May 14, 2014, at 11:13 PM, Herb Lainchbury <[hidden email]> wrote:



Hello All,
 
Thanks to everyone who helped out, voted, shared, discussed and otherwise furthered this project.  Much appreciated.  James, thanks for removing the duplicates.  I suggest we consider it complete at this point.
 
Canadian Open Data Community Top Ten Wanted Municipal Datasets - May 2014
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Crime information
  8. Road construction (511 data)
  9. Political financing
  10. Real time traffic flow data and daily road usage patterns
With #1 being the most desired.
 
Tracey, could we please post this on datalibre so we can all refer to it there and let our various networks know about it?
 
Thank you!
Herb
 
ps: I also suggest we review it on a regular basis, perhaps yearly to start?
 
 
 
 

 

On Wed, May 7, 2014 at 2:30 PM, Herb Lainchbury <[hidden email]> wrote:
I think your edits are right on the mark James.   Thanks for doing that.
 
Does anyone else have any feedback or suggestions on this before we consider it done?
 
Keep in mind, this is our first attempt.  I expect we will do this once per year at a minimum - so we will have more opportunities to refine it.
 
Herb
 

 

On Mon, May 5, 2014 at 5:56 PM, James McKinney <[hidden email]> wrote:
These are very useful results!
 
I knew from other studies that planning & development was of great interest, but this shows which datasets are prioritized within that theme: i.e. zoning data (1,2) is more in-demand than development applications (6,11). Sunlight has a series on zoning data:
 
 
They also dove into Asset Disclosure, Campaign Finance (12), Crime (8) and Lobbying:
 
 
It’s interesting to see that health inspections (16) and building citations (19) are as low as they are. Health inspections are published by several cities in Canada, and both datasets have seen standardizations efforts by Code for America. However, this result is in keeping with the results of similar studies, like Monmouth which I had shared previously.
 
I’m not sure that there is a clear distinction between "development permit applications" and "development applications”. The wording of “Financial data (revenue, expenses…)” seems to overlap with “Financial - actual expenditures”. If we merge those and also “transit data”, we get:
 
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  1. Crime information
  2. Road construction (511 data)
  1. Political financing
  2. Real time traffic flow data and daily road usage patterns
Great work!
 
James
 
On May 1, 2014, at 12:35 PM, Herb Lainchbury <[hidden email]> wrote:
 
Hey All,
 
The results from the top 10 datasets survey are in.   You can find them here: https://www.surveymonkey.net/results/SM-7Y5RDST/
 
I have to apologize, somehow Transit got in there twice.  It's clearly in the top ten in both cases so I think it's safe to say it's in the top ten.
 
We intentionally left the overlapping items and so we also see a few entries near the top around "Development Permits", "Land Use Changes", and "Rezoning Permits".  
 
Most of the entries are fairly distinct but there are a few that seem to me to be a bit overlapping.  So, we could either take the top 10 with the most votes (combining the two "Transit data" entries into one) - or we could attempt to eliminate any redundancy so we have 10 fairly distinct entries.  I am open to suggestions.
 
Here are the top 20 for your reference which should be enough to get us down to 10.  Please look at the link above for the actual numbers.
  1. Rezoning permit applications
  2. Land use changes
  3. Financial data (revenue, expenses, liabilities, equity, etc..)
  4. Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)
  5. Transit data
  6. Development permit applications
  7. Financial - actual expenditures
  8. Crime information
  9. Road construction (511 data)
  10. Transit data
  11. Development applications
  12. Political financing
  13. Real time traffic flow data and daily road usage patterns
  14. Contracts
  15. Property assessments
  16. Health inspections (e.g. Yelp's LIVES specification http://www.yelp.ca/healthscores)
  17. Public consultations
  18. Salaries
  19. Building citations (problems with structures etc...)
  20. Minutes of meetings
Cheers,
Herb
 
 
--
 
Herb Lainchbury, Dynamic Solutions
<a href="tel:250.704.6154" target="_blank" style="color: purple; text-decoration: underline;">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" target="_blank" style="color: purple; text-decoration: underline;">250.704.6154


 
--
 
Herb Lainchbury, Dynamic Solutions
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

_______________________________________________
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