{
"meta": {
"stats": {
"requestFetchMs": 49,
"vectorPreparationMs": 0,
"requestPreparationMs": 0,
"vectorResolutionMs": 0,
"vectorBuildingMs": -1,
"enhanceMs": 0
},
"resolvedPaths": [
"projectFeatured/projectConsortiaOrganizationRoleStage/consortia",
"projectFeatured/model",
"projectFeatured/projectProvince/province",
"projectFeatured/projectCity/city",
"projectFeatured/stage",
"projectFeatured/projectCostBenefit",
"projectFeatured/organization",
"projectFeatured/project"
],
"relations": [
{
"mapping": "projectFeatured=>project",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `project_description_ext2`.`refinance_descr` `refinanceNotes`, `project_description_ext2`.`proj_descr_short` `description`, `joinProject_featured`.`id` `projectFeaturedId`, `projects`.`vfm_date` `vfmDate`, `projects`.`year_psc` `yearPsc`, `projects`.`vfm_used` `vfmUsed`, `projects`.`year_debt` `yearDebt`, `projects`.`construct_jobs` `constructJobs`, `projects`.`year_cost_capital` `yearCostCapital`, `projects`.`greenfield_id` `greenfieldId`, `projects`.`preferred_consortia_id` `preferredConsortiaId`, `projects`.`year_fed_funding` `yearFedFunding`, `projects`.`project_id` `id`, `projects`.`year_prov_funding` `yearProvFunding`, `projects`.`year_cost_agreement` `yearCostAgreement`, `projects`.`construct_jobs_after` `constructJobsAfter`, `projects`.`cost_capital` `costCapital`, `projects`.`year_psc_cost` `yearPscCost`, `projects`.`projectname` `name`, `projects`.`year_project_cost` `yearProjectCost`, `projects`.`psc_cost` `pscCost`, `projects`.`stage_id` `stageId`, `projects`.`active` `active`, `projects`.`desc_other_funding` `descOtherFunding`, `projects`.`com_fin_time` `comFinTime`, `projects`.`process_advisor` `processAdvisor`, `projects`.`owner_organization_id` `ownerId`, `projects`.`year_muni_funding` `yearMuniFunding`, `projects`.`desc_psc` `descPsc`, `projects`.`consortia_id` `consortiaId`, `projects`.`psc` `psc`, `projects`.`procure_time_actual` `procureTimeActual`, `projects`.`is_horizontal` `isHorizontal`, `projects`.`cost_savings` `costSavings`, `projects`.`project_cost` `projectCost`, `projects`.`desc_psc_cost` `descPscCost`, `projects`.`post_construction_term` `postConstructionTerm`, `projects`.`tender_type_id` `tenderTypeId`, `projects`.`next_stage_id` `nextStageId`, `projects`.`year_other_funding` `yearOtherFunding`, `projects`.`desc_cost_capital` `descCostCapital`, `projects`.`desc_debt` `descDebt`, `projects`.`desc_muni_funding` `descMuniFunding`, `projects`.`fin_subcompletion_time` `finSubcompletionTime`, `projects`.`customers` `customers`, `projects`.`desc_fed_funding` `descFedFunding`, `projects`.`desc_cost_savings` `descCostSavings`, `projects`.`year_cost_savings` `yearCostSavings`, `projects`.`jobs` `jobs`, `projects`.`desc_equity` `descEquity`, `projects`.`desc_prov_funding` `descProvFunding`, `projects`.`model_id` `modelId`, `projects`.`sub_sector_id` `subSectorId`, `projects`.`desc_project_cost` `descProjectCost`, `projects`.`ontime_construction` `ontimeConstruction`, `projects`.`cost_agreement` `costAgreement`, `projects`.`sector_id` `sectorId`, `projects`.`year_equity` `yearEquity` FROM `project_featured` joinProject_featured JOIN `projects` ON `joinProject_featured`.`project_id` = `projects`.`project_id` LEFT JOIN `project_description_ext3` ON `projects`.`project_id` = `project_description_ext3`.`project_id` LEFT JOIN `project_description_ext2` ON `projects`.`project_id` = `project_description_ext2`.`project_id` LEFT JOIN `project_description_ext1` ON `projects`.`project_id` = `project_description_ext1`.`project_id` WHERE `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id"
},
{
"mapping": "projectProvince=>province",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "1",
"filteringMs": "0",
"sql": "SELECT `joinProject_province`.`index` `projectProvinceId`, `provinces`.`province_id` `id`, `provinces`.`name` `name` FROM `project_province` joinProject_province JOIN `provinces` ON `joinProject_province`.`province_id` = `provinces`.`province_id` WHERE `joinProject_province`.`index` IN (8363) ",
"ingestionMs": "0"
},
"keyPath": "project_province.province_id -> provinces.province_id"
},
{
"mapping": "projectFeatured=>projectProvince",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `project_province`.`project_id` `projectId`, `project_province`.`province_id` `provinceId`, `project_province`.`index` `id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_province` ON `joinProjects`.`project_id` = `project_province`.`project_id` WHERE `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id -> project_province.project_id"
},
{
"mapping": "projectConsortiaOrganizationRoleStage=>consortia",
"query": {
"resultCount": "5",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `consortia`.`imis_id` `imisId`, `consortia`.`name` `name`, `consortia`.`consortia_id` `id`, `consortia`.`url` `url`, `joinProject_consortia_organization_role_stage`.`mapping_id` `projectConsortiaOrganizationRoleStageId` FROM `project_consortia_organization_role_stage` joinProject_consortia_organization_role_stage JOIN `consortia` ON `joinProject_consortia_organization_role_stage`.`consortia_id` = `consortia`.`consortia_id` WHERE `joinProject_consortia_organization_role_stage`.`mapping_id` IN (7032,7033,7034,7035,7036) ",
"ingestionMs": "0"
},
"keyPath": "project_consortia_organization_role_stage.consortia_id -> consortia.consortia_id"
},
{
"mapping": "projectFeatured=>stage",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `stages`.`stage` `name`, `stages`.`stage_id` `id`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `stages` ON `joinProjects`.`stage_id` = `stages`.`stage_id` WHERE `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id -> stages.stage_id"
},
{
"mapping": "projectFeatured=>projectCostBenefit",
"query": {
"resultCount": "1",
"generationMs": "1",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `projects`.`project_id` `id` FROM `project_featured` joinProject_featured JOIN `projects` ON `joinProject_featured`.`project_id` = `projects`.`project_id` LEFT JOIN `project_description_ext3` ON `projects`.`project_id` = `project_description_ext3`.`project_id` LEFT JOIN `project_description_ext2` ON `projects`.`project_id` = `project_description_ext2`.`project_id` LEFT JOIN `project_description` ON `projects`.`project_id` = `project_description`.`project_id` WHERE `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id"
},
{
"mapping": "projectFeatured=>organization",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "1",
"filteringMs": "0",
"sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `organization`.`sponsor` `sponsor`, `organization`.`type_id` `typeId`, `organization`.`imis_id` `imisId`, `organization`.`organization_id` `id`, `organization`.`name` `name` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `organization` ON `joinProjects`.`owner_organization_id` = `organization`.`organization_id` WHERE `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id -> organization.organization_id"
},
{
"mapping": "projectFeatured=>projectCity",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `project_city`.`project_id` `projectId`, `project_city`.`index` `id`, `project_city`.`city_id` `cityId`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_city` ON `joinProjects`.`project_id` = `project_city`.`project_id` WHERE `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id -> project_city.project_id"
},
{
"mapping": "projectCity=>city",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `cities`.`city_name` `name`, `cities`.`province_id` `provinceId`, `cities`.`city_id` `id`, `joinProject_city`.`index` `projectCityId` FROM `project_city` joinProject_city JOIN `cities` ON `joinProject_city`.`city_id` = `cities`.`city_id` WHERE `joinProject_city`.`index` IN (7824) ",
"ingestionMs": "0"
},
"keyPath": "project_city.city_id -> cities.city_id"
},
{
"mapping": "projectFeatured=>projectConsortiaOrganizationRoleStage",
"query": {
"resultCount": "5",
"generationMs": "1",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id`, `project_consortia_organization_role_stage`.`project_id` `projectId`, `project_consortia_organization_role_stage`.`role_id` `roleId`, `project_consortia_organization_role_stage`.`stage_id` `stageId`, `project_consortia_organization_role_stage`.`mapping_id` `id`, `project_consortia_organization_role_stage`.`organization_id` `organizationId`, `project_consortia_organization_role_stage`.`consortia_id` `consortiaId` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` LEFT JOIN `project_consortia_organization_role_stage` ON `joinProjects`.`project_id` = `project_consortia_organization_role_stage`.`project_id` AND `project_consortia_organization_role_stage`.`stage_id` = '30' WHERE `project_consortia_organization_role_stage`.`stage_id` = '30' AND `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id -> project_consortia_organization_role_stage.project_id"
},
{
"mapping": "=>projectFeatured",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `project_featured`.`note` `note`, `project_featured`.`project_id` `projectId`, `project_featured`.`start` `start`, `project_featured`.`end` `end`, `project_featured`.`id` `id` FROM `project_featured` ",
"ingestionMs": "0"
}
},
{
"mapping": "projectFeatured=>model",
"query": {
"resultCount": "1",
"generationMs": "0",
"executionMs": "0",
"filteringMs": "0",
"sql": "SELECT `models`.`model_name` `name`, `models`.`model_id` `id`, `joinProject_featured`.`id` `projectFeaturedId`, `joinProjects`.`project_id` `project_id` FROM `project_featured` joinProject_featured LEFT JOIN `projects` joinProjects ON `joinProject_featured`.`project_id` = `joinProjects`.`project_id` JOIN `models` ON `joinProjects`.`model_id` = `models`.`model_id` WHERE `joinProject_featured`.`id` IN (16) ",
"ingestionMs": "0"
},
"keyPath": "project_featured.project_id -> projects.project_id -> models.model_id"
}
]
},
"projectFeatured": {
"stage": {
"project_id": 318,
"name": "Operational",
"projectFeaturedId": 16,
"id": 14
},
"projectCostBenefit": {
"projectFeaturedId": 16,
"id": 318
},
"projectCity": {
"project_id": 318,
"city": {
"projectCityId": 7824,
"name": "Calgary",
"id": 36
},
"projectFeaturedId": 16,
"cityId": 36,
"id": 7824,
"projectId": 318
},
"organization": {
"sponsor": false,
"project_id": 318,
"imisId": 617,
"projectFeaturedId": 16,
"name": "City of Calgary",
"typeId": 1,
"id": 42
},
"start": "2019-06-24",
"project": {
"postConstructionTerm": 30,
"descCostSavings": "Value for Money Report",
"vfmDate": "2016-10-05",
"modelId": 6,
"costSavings": 162000000,
"description": "The new facility will provide storage and maintenance space for the City of Calgary's new fleet of Compressed Natural Gas buses as well as diesel buses that are currently stored outside of the city's other bus garages. The facility will be capable of housing up to 400 Compressed Natural Gas buses, including indoor vehicle storage, 40 maintenance bays, two steam bays, on-site natural gas compression, and Compressed Natural Gas storage distribution infrastructure, and administrative facilities. The new facility will allow for the servicing of existing diesel buses until the Compressed Natural Gas bus fleet is large enough to occupy the entire facility.
\n",
"vfmUsed": true,
"ownerId": 42,
"yearCostCapital": "2016",
"isHorizontal": false,
"descProjectCost": "Value for Money Report",
"yearFedFunding": "2014",
"yearProjectCost": "2016",
"id": 318,
"descFedFunding": "PPP Canada",
"subSectorId": 10,
"stageId": 14,
"finSubcompletionTime": "889",
"sectorId": 4,
"greenfieldId": 1,
"yearCostSavings": "2016",
"pscCost": 467902000,
"costCapital": 174000000,
"active": true,
"marketValue": 174000000,
"descCostCapital": "City of Calgary Financial Close Press Release",
"yearMuniFunding": "2013",
"descMuniFunding": "City Council Transportation Report",
"projectCost": 305323000,
"procureTimeActual": "634",
"projectFeaturedId": 16,
"name": "Stoney CNG Transit Bus Garage",
"descPscCost": "Value for Money Report",
"yearPscCost": "2016",
"tenderTypeId": 2,
"comFinTime": "56",
"nextStageId": 15
},
"model": {
"project_id": 318,
"name": "Design-Build-Finance-Maintain",
"projectFeaturedId": 16,
"id": 6
},
"projectProvince": {
"province": {
"projectProvinceId": 8363,
"name": "Alberta",
"id": 1
},
"project_id": 318,
"projectFeaturedId": 16,
"id": 8363,
"projectId": 318,
"provinceId": 1
},
"id": 16,
"projectId": 318,
"projectConsortiaOrganizationRoleStages": [
{
"organizationId": 335,
"project_id": 318,
"roleId": 79,
"projectFeaturedId": 16,
"consortiaId": 864,
"id": 7032,
"projectId": 318,
"consortia": {
"name": "Plenary Infrastructure (City of Calgary Stoney CNG)",
"projectConsortiaOrganizationRoleStageId": 7032,
"id": 864
},
"stageId": 30
},
{
"organizationId": 1426,
"project_id": 318,
"roleId": 2,
"projectFeaturedId": 16,
"consortiaId": 864,
"id": 7033,
"projectId": 318,
"consortia": {
"name": "Plenary Infrastructure (City of Calgary Stoney CNG)",
"projectConsortiaOrganizationRoleStageId": 7033,
"id": 864
},
"stageId": 30
},
{
"organizationId": 1070,
"project_id": 318,
"roleId": 144,
"projectFeaturedId": 16,
"consortiaId": 864,
"id": 7034,
"projectId": 318,
"consortia": {
"name": "Plenary Infrastructure (City of Calgary Stoney CNG)",
"projectConsortiaOrganizationRoleStageId": 7034,
"id": 864
},
"stageId": 30
},
{
"organizationId": 1907,
"project_id": 318,
"roleId": 1,
"projectFeaturedId": 16,
"consortiaId": 864,
"id": 7035,
"projectId": 318,
"consortia": {
"name": "Plenary Infrastructure (City of Calgary Stoney CNG)",
"projectConsortiaOrganizationRoleStageId": 7035,
"id": 864
},
"stageId": 30
},
{
"organizationId": 599,
"project_id": 318,
"roleId": 14,
"projectFeaturedId": 16,
"consortiaId": 864,
"id": 7036,
"projectId": 318,
"consortia": {
"name": "Plenary Infrastructure (City of Calgary Stoney CNG)",
"projectConsortiaOrganizationRoleStageId": 7036,
"id": 864
},
"stageId": 30
}
]
}
}
Featured Project
Stoney CNG Transit Bus Garage
-
City of Calgary
-
Design-Build-Finance-Maintain
-
Alberta
-
Calgary
-
Operational
-
$174,000,000
-
$162,000,000
A monumental new bridge spanning the Saint Lawrence River and connecting the island metropolis of Montreal to the rest of Canada opened on June 24 after four years of construction. The slightly curved 3.4-kilometre cable-stayed span replaced the rusted and crumbling Champlain Bridge built in 1962. The bridge is used by some 50 million vehicles each year, connecting the city to surrounding suburbs and towns, and is a major thoroughfare for the transportation of goods to and from the United States.
some french content here
What are P3s?
Public-private partnerships, or P3s, are partnerships between governments and the private sector to build public infrastructure like roads, hospitals or schools, or to deliver services. Unlike traditional procurement, the public sector integrates all components of a P3 project into one contract.
P3 Myths vs. Facts
To better understand the benefits of public-private partnerships and dispel some of the myths, see the Myths and Facts page.
Previous
Next