{ "meta": { "stats": { "requestFetchMs": 40, "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": "1", "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 (7) ", "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 (7996) ", "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 (7) ", "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 (1192,1193,1195,1196,1197,1198,1199,1200,1201,1202,1203) ", "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 (7) ", "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 (7) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id" }, { "mapping": "projectFeatured=>organization", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "0", "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 (7) ", "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 (7) ", "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 (7589) ", "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 (7) ", "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": "1", "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": "1", "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 (7) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> models.model_id" } ] }, "projectFeatured": { "stage": { "project_id": 299, "name": "Under Construction", "projectFeaturedId": 7, "id": 12 }, "projectCostBenefit": { "projectFeaturedId": 7, "id": 299 }, "projectCity": { "project_id": 299, "city": { "projectCityId": 7589, "name": "Regina", "id": 116 }, "projectFeaturedId": 7, "cityId": 116, "id": 7589, "projectId": 299 }, "organization": { "sponsor": false, "project_id": 299, "imisId": 1875, "projectFeaturedId": 7, "name": "Saskatchewan Ministry of Highways and Infrastructure", "typeId": 1, "id": 147 }, "start": "2017-12-05", "project": { "psc": 1646200000, "postConstructionTerm": 30, "descCostSavings": "VFM Report (2015$)", "vfmDate": "2015-11-01", "preferredConsortiaId": 382, "modelId": 22, "costSavings": 379900000, "description": "

Saskatchewan has experienced unprecedented economic and population growth, putting increasing pressure on its transportation infrastructure and causing safety and environmental concerns. On May 5, 2014 the government announced its decision to move forward with this project, the largest transportation infrastructure project in the province’s history, as a public-private partnership. That same month the Government of Canada announced its plan to invest up to $200 million in the project through the P3 Canada Fund.

\n\n

The first phase of the project between Balognie and Highway 33 was completed in November 2017 after two years of construction. This section will help divert large truck traffic around the city. The entire project is scheduled to be wrapped up in the fall of 2019 and will encompass 60-kilometres of roads, service roads, 12 overpasses and 32 bridges.

\n", "vfmUsed": true, "ownerId": 147, "yearCostCapital": "2015", "isHorizontal": false, "descProjectCost": "VFM Report (2015$)", "ontimeConstruction": 0, "yearFedFunding": "2014", "yearProjectCost": "2015", "id": 299, "descFedFunding": "PPP Canada (2014$)", "subSectorId": 69, "stageId": 12, "finSubcompletionTime": "0", "sectorId": 4, "greenfieldId": 1, "descPsc": "VFM Report (2015$)", "yearCostSavings": "2015", "constructJobs": 8200, "pscCost": 2261400000, "costCapital": 1200000000, "active": true, "marketValue": 1880000000, "descCostCapital": "VFM Report (2015$)", "costAgreement": 1880000000, "yearCostAgreement": "2015", "yearPsc": "2015", "projectCost": 2260000000, "procureTimeActual": "1 Year 2 Months 17 Days", "projectFeaturedId": 7, "name": "Regina Bypass", "descPscCost": "VFM Report (2015$)", "yearPscCost": "2015", "consortiaId": 607, "tenderTypeId": 2, "comFinTime": "2 Months 1 Day", "nextStageId": 22 }, "end": "2018-01-01", "model": { "project_id": 299, "name": "Design-Build-Finance-Maintain-Operate", "projectFeaturedId": 7, "id": 22 }, "projectProvince": { "province": { "projectProvinceId": 7996, "name": "Saskatchewan", "id": 12 }, "project_id": 299, "projectFeaturedId": 7, "id": 7996, "projectId": 299, "provinceId": 12 }, "id": 7, "projectId": 299, "projectConsortiaOrganizationRoleStages": [ { "organizationId": 1821, "project_id": 299, "roleId": 326, "projectFeaturedId": 7, "consortiaId": 607, "id": 1192, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1192, "id": 607 }, "stageId": 30 }, { "organizationId": 2416, "project_id": 299, "roleId": 330, "projectFeaturedId": 7, "consortiaId": 607, "id": 1193, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1193, "id": 607 }, "stageId": 30 }, { "organizationId": 2376, "project_id": 299, "roleId": 331, "projectFeaturedId": 7, "consortiaId": 607, "id": 1195, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1195, "id": 607 }, "stageId": 30 }, { "organizationId": 818, "project_id": 299, "roleId": 298, "projectFeaturedId": 7, "consortiaId": 607, "id": 1196, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1196, "id": 607 }, "stageId": 30 }, { "organizationId": 491, "project_id": 299, "roleId": 298, "projectFeaturedId": 7, "consortiaId": 607, "id": 1197, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1197, "id": 607 }, "stageId": 30 }, { "organizationId": 1945, "project_id": 299, "roleId": 298, "projectFeaturedId": 7, "consortiaId": 607, "id": 1198, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1198, "id": 607 }, "stageId": 30 }, { "organizationId": 393, "project_id": 299, "roleId": 669, "projectFeaturedId": 7, "consortiaId": 607, "id": 1199, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1199, "id": 607 }, "stageId": 30 }, { "organizationId": 334, "project_id": 299, "roleId": 329, "projectFeaturedId": 7, "consortiaId": 607, "id": 1200, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1200, "id": 607 }, "stageId": 30 }, { "organizationId": 2386, "project_id": 299, "roleId": 298, "projectFeaturedId": 7, "consortiaId": 607, "id": 1201, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1201, "id": 607 }, "stageId": 30 }, { "organizationId": 528, "project_id": 299, "roleId": 298, "projectFeaturedId": 7, "consortiaId": 607, "id": 1202, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1202, "id": 607 }, "stageId": 30 }, { "organizationId": 725, "project_id": 299, "roleId": 315, "projectFeaturedId": 7, "consortiaId": 607, "id": 1203, "projectId": 299, "consortia": { "name": "SGTP Highway Bypass Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1203, "id": 607 }, "stageId": 30 } ] } }