Graphs: Difference between revisions

From canbudget Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 25: Line 25:
|format=csv
|format=csv
}}.
}}.
Finally, a lousy example of the facet browser, where you can narrow down data dynamically using different facets of information.
{{ #ask: [[Canadian dollar cost 2010::>500000]]
|?Description
|?Topic
|?Canadian dollar cost 2010
|?Start date
|?GPS location
|sort=Canadian dollar cost 2010
|format=exhibit
|facets=Topic,Canadian dollar cost 2010,Start date,Responsible person
|views=timeline,table,map
}}

Revision as of 23:46, 2 October 2010

Graph of procurement process and topic

Below is an example of a chart generated from site data. Click the Edit button to see how it's done, copy and paste it on the Sandbox to experiment on your own

Or you can export data to formats like CSV.

Finally, a lousy example of the facet browser, where you can narrow down data dynamically using different facets of information.

 DescriptionTopicCanadian dollar cost 2010Start dateGPS location
2010/G20 and G8 Budget/Baggage HandlingBaggage Handling2010/G20517,983.4
2010/G20 and G8 Budget/Transportation - vehicle lease - unmarked cars 3Transportation - vehicle lease - unmarked cars2010/G20
2010/G8
539,278
2010/G20 and G8 Budget/Toronto Accommodations 32Toronto Accommodations2010/G20645,780
2010/G8/Roadwork, signageRoadwork, signage2010/G8650,00045° 0' 44.11" N, 79° 36' 49.26" W
2010/G20 and G8 Budget/Two Way Radio RentalTwo Way Radio Rental2010/G20
2010/G8
702,597
2010/G20 and G8 Budget/Toronto Accommodations 33Toronto Accommodations2010/G20721,860
2010/G8/Renovation of bridge, Main Street and town centreRenovation of bridge, Main Street and town centre2010/G8730,00045° 33' 19.74" N, 79° 13' 26.76" W
2010/G8/Improvements to downtown areas, new signage, fencing and landscapingImprovements to downtown areas, new signage, fencing and landscaping2010/G8745,000
2010/G20 and G8 Budget/Tent rentalTent rental2010/G20800,000
2010/G20 and G8 Budget/Food cateringFood catering2010/G20
2010/G8
805,376
2010/G8/New sidewalks, various civic improvementsNew sidewalks, various civic improvements2010/G8875,00045° 46' 15.88" N, 79° 23' 44.77" W
2010/G8/Upgrades to streets, signageUpgrades to streets, signage2010/G8894,00045° 40' 3.10" N, 80° 6' 19.90" W
2010/G20 and G8 Budget/Food catering 3Food catering2010/G20904,753
2010/G20 and G8 Budget/Supply, delivery, installation and operation of printing centres at various locationsSupply, delivery, installation and operation of printing centres at various locations2010/G20910,350
2010/G8/Downtown improvements (Gravenhurst)Downtown improvements (Gravenhurst)2010/G81,002,00044° 55' 2.68" N, 79° 22' 23.27" W
2010/G8/Signage, downtown improvementsSignage, downtown improvements2010/G81,045,00045° 2' 29.43" N, 79° 18' 39.56" W
2010/G20 and G8 Budget/Video control systemVideo control systemNot identified1,050,694
2010/G20 and G8 Budget/Toronto Accommodations 34Toronto Accommodations2010/G201,104,600
2010/G20 and G8 Budget/Apts - Condominium rentalApts - Condominium rental2010/G201,199,614
2010/G20 and G8 Budget/Rental of motor and other vehicles 6Rental of motor and other vehicles2010/G201,223,985
2010/G20 and G8 Budget/AV conference systems - G8—G20 combinedAV conference systems - G8/G20 combined2010/G20
2010/G8
1,300,389
2010/G20 and G8 Budget/G8—G20 communications materialsG8/G20 communications materials2010/G20
2010/G8
1,333,500
2010/G20 and G8 Budget/Vehicle lease (motorcade) 3Vehicle lease (motorcade)2010/G20
2010/G8
1,340,711
2010/G20 and G8 Budget/Cabling requirement at DeerhurstCabling requirement at Deerhurst2010/G201,446,383
2010/G20 and G8 Budget/Transportation - vehicle lease - unmarked carsTransportation - vehicle lease - unmarked cars2010/G20
2010/G8
1,462,526
2010/G20 and G8 Budget/RCMP Frame Relay ServicesRCMP Frame Relay Services2010/G201,500,000
2010/G20 and G8 Budget/AccreditationAccreditation2010/G20
2010/G8
1,569,621
2010/G20 and G8 Budget/Exhibit MaterialsExhibit Materials2010/G20
2010/G8
1,575,000
2010/G20 and G8 Budget/Moving servicesMoving services2010/G20
2010/G8
1,606,113
2010/G20 and G8 Budget/Receiver and signalReceiver and signal2010/G201,685,861
2010/G20 and G8 Budget/Lease, rooms, food services 5Lease, rooms, food services2010/G201,734,274.42
2010/G20 and G8 Budget/Exhibit - Invest In Canada (G8 & G20)Exhibit - Invest In Canada (G8 & G20)2010/G20
2010/G8
1,961,899
2010/G8/Signage, streetscaping, park improvementSignage, streetscaping, park improvement2010/G82,000,00044° 48' 13.84" N, 79° 43' 13.77" W
2010/G20 and G8 Budget/Host Broadcaster (For G8 & G20)Host Broadcaster (For G8 & G20)2010/G20
2010/G8
2,629,018
2010/G20 and G8 Budget/Transportation - Fleet (Vans, Mini buses, trucks)Transportation - Fleet (Vans, Mini buses, trucks)2010/G20
2010/G8
2,971,271
2010/G20 and G8 Budget/General Contractor 'Umbrella' for both G8 and G20General Contractor "Umbrella" lor both G8 and G202010/G20
2010/G8
2,982,036
2010/G20 and G8 Budget/Transportation - Shuttle Bus ServicesTransportation - Shuttle Bus Services2010/G20
2010/G8
3,233,790
2010/G20 and G8 Budget/Lease, rooms, food services 4Lease, rooms, food services2010/G203,648,639.73
2010/G20 and G8 Budget/Lease, rooms, food services 3Lease, rooms, food services2010/G203,730,530.22
2010/G20 and G8 Budget/License for use of location, fit up, general services 3License for use of location, fit up, general services2010/G204,227,298.62
2010/G20 and G8 Budget/Security fenceSecurity fence2010/G204,413,039
2010/G8/Improvements to Jack Garland AirportImprovements to Jack Garland Airport2010/G85,000,00046° 18' 33.16" N, 79° 27' 38.74" W
2010/G20 and G8 Budget/Lease, rooms, food servicesLease, rooms, food services2010/G205,128,519.44
2010/G20 and G8 Budget/License for use of location, fit up, general servicesLicense for use of location, fit up, general services2010/G205,276,122.21
2010/G20 and G8 Budget/Protection servicesProtection services2010/G207,726,235.68
2010/G20 and G8 Budget/Local access requirements - national Centrex servicesLocal access requirements - national Centrex services2010/G209,035,236
2010/G20 and G8 Budget/P25 encrypted portable radio equipmentP25 encrypted portable radio equipment2010/G20
2010/G8
9,283,529
2010/G20 and G8 Budget/License for use of location, filup, security, General servicesLicense for use of location, filup, security, General services2010/G2011,850,485.08
2010/G8/Expansion of Huntsville Centennial Centre and Summit Management Office, rebuilding Deerhurst DriveExpansion of Huntsville Centennial Centre and Summit Management Office, rebuilding Deerhurst Drive2010/G828,001,00045° 19' 35.01" N, 79° 13' 6.36" W