Local Open Data Census - Data List: City-Regional and Provincial
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
NOTE: Information on proposed top 15 Datasets will be closed Monday March 27, 2017. at Noon. Top 20 local data sets used in the 2016 census are noted in yellow. For questions, contact jury.konga@outlook.com
Please also consider whether some of these datasets belong with either the regional dataset or provincial dataset
2
Dataset NameDescriptionG8 Category"Yes" Rationale (why key dataset)"No" Rationale (why not key)Other CommentsRelevant standardsGuides and policy
3
Address pointsJV - Municipalities have jurisdiction and this data is necessary to decipher most other layersThis is so basic and fundamental to making sense of other municipal open data that it should be considered table-stakes.JK: Agreed that this should be part of core GIS datasets which exists in most jurisdictions.
4
Air QualityData on air quality (e.g. levels of major pollutants) on a granular basis - that is at least broken down by month (preferably by day). Geographic breakdown (e.g. by grid point) would be nice but is not required.Energy and EnvironmentOpen Knowledge Default Local DatasetJK: This data may be collected more by provincial govs so recommend moving it to their dataset list JV - Provincial responsibility
http://www.w3.org/2005/Incubator/ssn/ssnx/ssn
5
Annual BudgetMunicipal budget at a high level (e.g. spending by sector, department etc). This category is about budgets which are plans for expenditure (not actual expenditure in the past).Finance and contractsOpen Knowledge Default Local Dataset.  RJ - This is an important dataset that supports the idea of transparency with public finances. 
https://github.com/openspending/budget-data-package/blob/master/specification.md#readme
https://github.com/open-data-standards/data-schemas/blob/gh-pages/schemas/Open_Budget.md
http://vocab.linkeddata.es/datosabiertos/def/hacienda/presupuestos.html
6
Asset DisclosureInformation about the financial stakes of elected or appointed officials that could impact their decision-makingGovernment Accountability and DemocracyUS City Open Data CensusThis is important for certain applications; I'd suggest it's too specialized to include as 'key'http://sunlightfoundation.com/policy/municipal_asset_disclosure/
7
Bicycle transportation networkThis is a subset of 'transportation network maps' JV - Agree.  RJ - agree
8
Builiding PermitsBuilding / construction permits
Local/Global Development
Open Knowledge Default Local Dataset, 2014 Top 10 ("Development permit applications")RJ - In Peel Region, building permits are issued by local municiaplities so this would not be applicable at a Regional level.http://permitdata.org/
9
Business ListingKey information for businesses in the municipal area, such as name, address, contact information, business type.CompaniesOpen Knowledge Default Local DatasetThis is doomed to be incomplete -- municipalities will know this only through permits (which are covered in 'building permits') and property tax (which is another story). JV -Niagara Falls agrees- we have found this impossible to maintain accurately.  RJ - Peel Region does not have an economic development function so we would reply on local municipal data which I am asusming would never be completely accurate.  BP/MP - Windsor does not collect this information.
10
Business PermitsBusiness Permits / LicensesCompaniesOpen Knowledge Default Local Dataset RJ -This is not a Regional Municipal dataset.  BP/MP - The province issues business permits, while the City issues business licences which are a subset of the various types of business permits.JV - NF provides this as yearly update "Business Licence Issued"
11
Campaign Finance ContributionsData related to the campaign finance contributions by individuals and organziations. The campaign may be either for election purposes or a community project or a development project.Government Accountability and Democracy2014 Top 10 ("Political financing"), US City Open Data Censushttp://sunlightfoundation.com/policy/municipal_campaign_finance/
12
CemeteryCemetary locations, plots within cemeteriesMedicine Hat mentioned that requests for this dataset outstripped all other requests 4:1. My guess this may be the same for other cities. RJ - In Peel Region we get a large number of downloads of cemetery data every month.JK: Consider this as part of Public Facilities
JV - In NF this is one of our most used and recognized data sets. Having a Genealogy Search component draws alot of users. I would keep it seperate
13
Child care centresLicensed child care centresGeospatialImportant for public to have knowledge of what locations have been granted licenses by the Province to operate. Also allows parents to find locations JV - I would suggest this be modified to Care Centres and include registered Senior Care facilities as well. In an aging population we have more seniors then children
14
Council and committee agendas, minutes and voting recordsThis is so basic and fundamental to making sense of other municipal open data that it should be considered table-stakes.JK: Agreed that this is fundamental and again I haven't seen any webistes that don't provide this information.
15
Crime StatisticsData on municipal crime, preferably at a reasonably disaggregated level (best would be exact date, location and type but per day per street or post/zip code would be acceptable). Also, description of police response.Crime and JusticeOpen Knowledge Default Local Dataset, 2014 Top 10 ("Crime information").  RJ - Crime data rolled up to some generalized categories at a sub-municipal aggregation (police zones) is a useful way to illustrate crime data without stigmatizing neibourhoods.In our jurisdiction we are using RCMP and they do not allow us to access this data. JV - Niagara Falls does not collect crime statistics as we have multi jurisdictions in our area (RCMP, OPP, Regional, Parks Commission). RJ - Peel Regional POlice are very guarded with crime statistics.  In past discussions there has always been concern about stigmatizing neighbourhoods.  BP/MP - In Windsor, the Police Department maintains its open datasets separately from the ones managed by the City.There are likely other circumstances when the data is collected by other levels of government or agencies. In these cases, for the census, I believe the approporiate census response would be Not Applicable.
http://blog.spotcrime.com/2014/03/the-spotcrime-open-crime-data-standard.html
http://sunlightfoundation.com/policy/municipal_crime/
16
District boundaries and informationThis is so basic and fundamental to making sense of other municipal open data that it should be considered table-stakes.JK: Agreed that this should be part of core GIS datasets which exists in most jurisdictions. JV - what Districts is this referring to? We have Planning Communities, Neighbourhood Districts, Tourist Districts, etc.RJ - are you referring to municipal ward boundaries?  Is this the boundaries of the jurisdictions represented by Council members? 
17
Elected Officials' Contact InformationThe contact information for each elected official, along with the name of the district they represent (if the municipality is subdivided into districts)
Government Accountability and DemocracyFundamental to many democratic use cases for open data. 25% of Canadian municipalities with open data use the Represent CSV Schema to publish this dataJK: I have yet to see to website that doesn't include contact info
http://represent.opennorth.ca/government/
18
Election resultsResults by constituency / district for all major local electoral contests in this municipalityGovernment Accountability and DemocracyOpen Knowledge Default Local Dataset RJ - Peel Region does not have a directly elected Regional Council and will for the first time have a directly elected Regional Chair in the next municipal election.  Election results are posted at the local municipal level.JV - I believe most municipalities post this already
https://github.com/popolo-project/popolo-spec/wiki/Miscellaneous-specifications#elections
19
Expenditure (detailed)Records of actual (past) municipal spending at a detailed transactional level, for example, at the level of month to month expenditure on specific items (usually this means individual records of spending amounts at a fairly granular level - e.g. $5-50k rather than at the $1m+ level). (Note: a database of contracts awarded or similar is not considered sufficient. This data category refers to detailed ongoing data on actual expenditure)Finance and contractsOpen Knowledge Default Local Dataset
https://github.com/openspending/budget-data-package/blob/master/specification.md#readme
https://github.com/open-data-standards/data-schemas/blob/gh-pages/schemas/Open_Expenditures.md
http://schemas.opendata.esd.org.uk/Spend
https://github.com/NYCComptroller/Checkbook
20
Food InspectionsFood premises food inspection dates and resultsHealthKey for transparency and health promotionJV - Is this a duplication of 14 - Food Safety InspectionsYelp LIVES standardhttps://www.yelp.ca/healthscores
21
Food Safety InspectionsOutcomes of food safety inspections of restaurants and other similar providers of food to the publicHealthOpen Knowledge Default Local DatasetJV - In NF this is Regional responsibility.  BP/MP - Food safety inspections are not issued by the City of Windsor; they are instead handled by the regional health unit.
http://www.yelp.ca/healthscores
22
Lobbyist ActivityThe expected data would include a Lobbyist Inventory and lobbyist as delegations to Council.
Government Accountability and DemocracyUS City Open Data Censushttp://sunlightfoundation.com/policy/municipal_lobbying/
23
Medical ServicesHealthJV - people coming to the area want to know the availability of medical services. Hospitals, Urgent Care centres, Walk-In-Clinics, Pharmacies, and other medical related buildings.  RJ - Agree that this is an important dataset for all residents.
24
Natural ResourcesList of natural assets and may include tree inventories, Environmentally Sensitive Areas, Areas of Scientific Interest, Endangered areas, etcEarth ObservationNatural resources for all jurisdictions is important in part of the assessment of the well-being of the communityJV - NF uses Provincial and Regional data
JK: Natural resource data should also be part of the provincial level open data census
25
Points of InterestGeneral points of interest - government buildings and offices, social service locations, major transit hubs, etc.GeospatialJV - some duplication to Public Facilities - need clear definition or re-definition and is this referring to Tourism Related Attractions, Recreational like Golf Courses and what about Wineries and Casinos etc.... Are these just commercial or does it include environmental or historical point of intersest
26
Procurement ContractsPer contract information on municipal contracts including amount, awardee (name, address), data awarded etcFinance and contractsOpen Knowledge Default Local Dataset
http://standard.opencontracting.org/
http://schemas.opendata.esd.org.uk/Contracts
27
Public FacilitiesLocation information about various Public facilities such as schools, parks, hospitals, daycare, etc.Transport and InfrastructureOpen Knowledge Default Local Dataset, 2014 Top 10 ("Locations of things (fire hydrants, drinking water fountains, public toilets, bike parking, ...)")JV - Too broad a category Is this publically owned or publically accessed. Is this buildings or properties ? Most people expect to be able to find this information online but whos responsibility is it and how do you categorize it. I see a Hydrant Asset as very different from a City Owned Facility like a Museum or land like a Park and different again from a building that allows public access like a Library or Community facility
28
Real-Time TrafficTransport and Infrastructure2014 Top 10 ("Real time traffic flow data and daily road usage patterns")
JM: Do many municipalities have real-time traffic counters installed in order to collect this data?
KF: Peel & local munis do not have live data collection JV - NF does not have live traffic collection
JM: Other levels of government have jurisdiction over some roads/bridges (e.g. provincial highways, federal bridges).
29
Real-Time TransitReal-time information about major municipal-run or commissioned transit services (buses, subway, rail, tram etc). Real-time transit information means things like the location of actual services (individual buses and trains, etc)Transport and InfrastructureOpen Knowledge Default Local Dataset, 2014 Top 10 ("Transit data")This could be seen as an extension of transit (schedule) data -- it doesn't need to be listed separately.  RJ - In Peel Region, transit is handled by MIssissauga and Brampton transit. Not a Regional responsibility .
http://www.siri.org.uk/
https://developers.google.com/transit/gtfs-realtime/
30
Rezoning Permit ApplicationsApplications for permits to rezone a parcel of land
Local/Global Development
2014 Top 10 ("Rezoning permit applications")RJ - In Peel Region, the rezoning applications are handled by the local municipalities.http://sunlightfoundation.com/policy/municipal_zoning/
31
Road ConstructionCurrent and planned road constructionTransport and Infrastructure2014 Top 10 ("Road construction (511 data)")JM: Other levels of government have jurisdiction over some roads/bridges (e.g. provincial highways, federal bridges).JV - Agree with JMhttp://open511.org/
32
Road Usage StatisticsTransport and Infrastructure2014 Top 10 ("Real time traffic flow data and daily road usage patterns")
JM: Do many municipalities have traffic counters (real-time or not) to collect this data?
KF: Most municipalities have counting loops or programs in the major urban areas JV - Traffic Counts are not tracked on every road, every time
JM: Other levels of government have jurisdiction over some roads/bridges (e.g. provincial highways, federal bridges).
JK: Correlation of usage stats with accidents is a useful analysis.
33
Service RequestsNon-Emergency service requests to municipal authorities, for example regarding potholes, graffiti, etc (311, D115 etc). Data should be at granular (per request) level.Open Knowledge Default Local Dataset
http://wiki.open311.org/GeoReport_v2/
34
Traffic AccidentsStatistics on road traffic accidents including type and severity of accident, date, time, location and injuries.Transport and InfrastructureOpen Knowledge Default Local Dataset
JM: Other levels of government have jurisdiction over some roads/bridges (e.g. provincial highways, federal bridges).
JK: Agreed - this might be useful to be a provincial dataset as well for those highways that are under their jurisdiction.  BP/MP - Agreed, this dataset might be better handled by a different level of goverment, so that info on all the roadways might be provided in one area.  JV - NF collects Accident data only own City Owned roads
35
Transport SchedulesTimetables (schedules) of all municipally run or commissioned transit services (buses, subway, rail tram etc). Stop locations (geodata), and service interruptions.Transport and InfrastructureOpen Knowledge Default Local Dataset, 2014 Top 10 ("Transit data")RJ - In Peel Region this is not a Regional responsibility.
https://developers.google.com/transit/gtfs/
36
Transportation network maps: roads, sidewalks and cycle pathsThis is so basic and fundamental to making sense of other municipal open data that it should be considered table-stakes.JK: Agreed that this should be part of core GIS datasets which exists in most jurisdictions. JV - Agree with Rail, Transit, Road, Bicycle Path, Sidewalk
37
Zoning (GIS)The type of development allowed on parcels of land, e.g. residential, mixed residential-commercial, commercial, industrial, specialLocal/Global Development2014 Top 10 ("Land use changes"), US City Open Data Census RJ - In Peel Region, zoning is a local municipal responsibilitytherefore it would not be applicable.JV - NF provides thishttp://sunlightfoundation.com/policy/municipal_zoning/
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
City Data
Regional Gov data
Prov/Terr Gov data
G8 categories
2014 Top 10
 
 
Main menu