{ "meta": { "stats": { "requestFetchMs": 45, "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": "1", "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 (14) ", "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 (8482) ", "ingestionMs": "0" }, "keyPath": "project_province.province_id -> provinces.province_id" }, { "mapping": "projectFeatured=>projectProvince", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "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 (14) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> project_province.project_id" }, { "mapping": "projectConsortiaOrganizationRoleStage=>consortia", "query": { "resultCount": "4", "generationMs": "0", "executionMs": "1", "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 (1462,1463,1464,1465) ", "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 (14) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> stages.stage_id" }, { "mapping": "projectFeatured=>projectCostBenefit", "query": { "resultCount": "1", "generationMs": "0", "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 (14) ", "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 (14) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> organization.organization_id" }, { "mapping": "projectFeatured=>projectCity", "query": { "resultCount": "1", "generationMs": "0", "executionMs": "1", "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 (14) ", "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 (7466) ", "ingestionMs": "0" }, "keyPath": "project_city.city_id -> cities.city_id" }, { "mapping": "projectFeatured=>projectConsortiaOrganizationRoleStage", "query": { "resultCount": "4", "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 (14) ", "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 (14) ", "ingestionMs": "0" }, "keyPath": "project_featured.project_id -> projects.project_id -> models.model_id" } ] }, "projectFeatured": { "stage": { "project_id": 305, "name": "Under Construction", "projectFeaturedId": 14, "id": 12 }, "projectCostBenefit": { "projectFeaturedId": 14, "id": 305 }, "projectCity": { "project_id": 305, "city": { "projectCityId": 7466, "name": "Fort McMurray", "id": 151 }, "projectFeaturedId": 14, "cityId": 151, "id": 7466, "projectId": 305 }, "organization": { "sponsor": false, "project_id": 305, "imisId": 3561, "projectFeaturedId": 14, "name": "Alberta Electric System Operator AESO", "typeId": 1, "id": 151 }, "project": { "yearDebt": "2017", "postConstructionTerm": 35, "descCostSavings": "AESO Project Website", "preferredConsortiaId": 523, "modelId": 22, "costSavings": 400000000, "description": "

 

\n\n
    \n
\n", "vfmUsed": true, "ownerId": 151, "isHorizontal": false, "ontimeConstruction": 0, "id": 305, "subSectorId": 36, "stageId": 12, "descDebt": "ATCO Press Release", "sectorId": 12, "greenfieldId": 1, "yearCostSavings": "2015", "pscCost": 1800000000, "active": true, "marketValue": 1430000000, "costAgreement": 1430000000, "yearCostAgreement": "2015", "projectCost": 1430000000, "procureTimeActual": "507", "projectFeaturedId": 14, "name": "Fort McMurray West Transmission Project", "consortiaId": 523, "tenderTypeId": 2, "comFinTime": "0", "nextStageId": 13 }, "model": { "project_id": 305, "name": "Design-Build-Finance-Maintain-Operate", "projectFeaturedId": 14, "id": 22 }, "projectProvince": { "province": { "projectProvinceId": 8482, "name": "Alberta", "id": 1 }, "project_id": 305, "projectFeaturedId": 14, "id": 8482, "projectId": 305, "provinceId": 1 }, "id": 14, "projectId": 305, "projectConsortiaOrganizationRoleStages": [ { "organizationId": 1832, "project_id": 305, "roleId": 669, "projectFeaturedId": 14, "consortiaId": 523, "id": 1462, "projectId": 305, "consortia": { "name": "Alberta PowerLine Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1462, "id": 523 }, "stageId": 30 }, { "organizationId": 1836, "project_id": 305, "roleId": 669, "projectFeaturedId": 14, "consortiaId": 523, "id": 1463, "projectId": 305, "consortia": { "name": "Alberta PowerLine Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1463, "id": 523 }, "stageId": 30 }, { "organizationId": 1837, "project_id": 305, "roleId": 669, "projectFeaturedId": 14, "consortiaId": 523, "id": 1464, "projectId": 305, "consortia": { "name": "Alberta PowerLine Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1464, "id": 523 }, "stageId": 30 }, { "organizationId": 2810, "project_id": 305, "roleId": 669, "projectFeaturedId": 14, "consortiaId": 523, "id": 1465, "projectId": 305, "consortia": { "name": "Alberta PowerLine Limited Partnership", "projectConsortiaOrganizationRoleStageId": 1465, "id": 523 }, "stageId": 30 } ] } }