{ "meta": { "stats": { "requestFetchMs": 48, "vectorPreparationMs": 0, "requestPreparationMs": 1, "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": "0", "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 (8715) ", "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": "11", "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 (1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436) ", "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 (8118) ", "ingestionMs": "0" }, "keyPath": "project_city.city_id -> cities.city_id" }, { "mapping": "projectFeatured=>projectConsortiaOrganizationRoleStage", "query": { "resultCount": "11", "generationMs": "0", "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": 216, "name": "Operational", "projectFeaturedId": 16, "id": 14 }, "projectCostBenefit": { "projectFeaturedId": 16, "id": 216 }, "projectCity": { "project_id": 216, "city": { "projectCityId": 8118, "name": "Montréal", "id": 25 }, "projectFeaturedId": 16, "cityId": 25, "id": 8118, "projectId": 216 }, "organization": { "sponsor": false, "project_id": 216, "imisId": 387, "projectFeaturedId": 16, "name": "Transport Canada", "typeId": 1, "id": 7 }, "start": "2019-06-24", "project": { "psc": 3931500000, "postConstructionTerm": 30, "descCostSavings": "VFM Report (2014$)", "vfmDate": "2015-07-01", "preferredConsortiaId": 371, "modelId": 22, "costSavings": 1747000000, "description": "

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.

\n", "vfmUsed": true, "ownerId": 7, "isHorizontal": false, "descProjectCost": "VFM Report (2014$)", "ontimeConstruction": 0, "yearProjectCost": "2015", "customers": 50000000, "id": 216, "subSectorId": 68, "stageId": 14, "finSubcompletionTime": "1467", "sectorId": 4, "greenfieldId": 1, "descPsc": "VFM Report (2014$)", "yearCostSavings": "2015", "constructJobs": 1300, "pscCost": 5178600000, "active": true, "marketValue": 3225200000, "costAgreement": 3225200000, "yearCostAgreement": "2015", "yearPsc": "2015", "projectCost": 3431600000, "procureTimeActual": "459", "projectFeaturedId": 16, "name": "New Bridge for the St. Lawrence (Champlain replacement)", "descPscCost": "VFM Report (2014$)", "yearPscCost": "2015", "consortiaId": 371, "tenderTypeId": 2, "comFinTime": "65", "nextStageId": 15 }, "model": { "project_id": 216, "name": "Design-Build-Finance-Maintain-Operate", "projectFeaturedId": 16, "id": 22 }, "projectProvince": { "province": { "projectProvinceId": 8715, "name": "Quebec", "id": 11 }, "project_id": 216, "projectFeaturedId": 16, "id": 8715, "projectId": 216, "provinceId": 11 }, "id": 16, "projectId": 216, "projectConsortiaOrganizationRoleStages": [ { "organizationId": 669, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1426, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1426, "id": 371 }, "stageId": 30 }, { "organizationId": 1022, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1427, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1427, "id": 371 }, "stageId": 30 }, { "organizationId": 1552, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1428, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1428, "id": 371 }, "stageId": 30 }, { "organizationId": 1858, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1429, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1429, "id": 371 }, "stageId": 30 }, { "organizationId": 1859, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1430, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1430, "id": 371 }, "stageId": 30 }, { "organizationId": 413, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1431, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1431, "id": 371 }, "stageId": 30 }, { "organizationId": 339, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1432, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1432, "id": 371 }, "stageId": 30 }, { "organizationId": 455, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1433, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1433, "id": 371 }, "stageId": 30 }, { "organizationId": 1861, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1434, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1434, "id": 371 }, "stageId": 30 }, { "organizationId": 817, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1435, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1435, "id": 371 }, "stageId": 30 }, { "organizationId": 1188, "project_id": 216, "roleId": 669, "projectFeaturedId": 16, "consortiaId": 371, "id": 1436, "projectId": 216, "consortia": { "name": "Signature on the St. Lawrence Group", "projectConsortiaOrganizationRoleStageId": 1436, "id": 371 }, "stageId": 30 } ] } }