# 各個類別係數
以下是各個category在MongoDB的格式(以台灣為主)
```json
// 1.1
{
"methods": [
{
"sourceOfEmission": "test1.1",
"co2Factor": 3.1415926,
"ch4Factor": 0.000046,
"n2oFactor": 0.000005,
"baseUnit": "Liter",
"source": "EPA Taiwan",
"urlName": "EPA Taiwan",
"sheetName": "",
"file": "/upload/ef/溫室氣體排放係數管理表6.0.4版.ods",
"link": "https://ghgregistry.moenv.gov.tw/epa_ghg/Downloads/FileDownloads.aspx?Type_ID=1",
"year": 2023,
"emissionUnit": "kgCO₂",
"ch4Unit": "kgCH₄",
"n2oUnit": "kgN₂O"
}
],
"category": "Stationary Combustion",
"scope": "scope1",
"typeOfEmission": "Fuel gas",
"sourceType": "Fuel Type",
"sourceOfEmission": "Ethane",
"usedRegion": "Taiwan", // 台灣係數要加這個（否則1.3會顯示1.1的係數）
}
```
對應排放活動的參數：
Source: methods.source
Emission Source: typeOfEmission
Emission Type: methods.sourceOfEmission - methods.baseUnit(ex. test1.1 - Liter)
```json
//1.2
{
"type" : "Mobile Combustion",
"methods" : [
{
"sourceOfEmission" : "test1.2",
"vehicleType" : "General",
"co2Factor" : 3.1415926,
"ch4Factor" : 0.0002,
"n2oFactor" : 0.0003,
"source" : "EPA Taiwan",
"baseUnit" : "gal (US)",
"urlName" : "EPA GHG Emission Factors Hub",
"sheetName" : "Sheet Name : Emission Factors Hub",
"file" : "/upload/ef/EPA-ghg-emission-factors-hub.xlsx",
"link" : "https://www.epa.gov/climateleadership/ghg-emission-factors-hub",
"year" : "2023",
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope1",
"typeOfEmission" : "Fuel Use",
"category" : "Mobile Combustion"
}
```
對應排放活動的參數：
Source: methods.source
Emission Type: methods.sourceOfEmission - methods.baseUnit(ex. test1.2 - gal(US))
Activity Type: typeOfEmission
Activity Name: vehicleType
1.3 issue: Database 沒有任何和1.3相關的係數，但平台卻出現1.1的係數
```json
// 1.4
{
"type" : "Refrigerants",
"scope" : "scope1",
"methods" : [
{
"sourceOfEmission" : "test1.4",
"co2Factor" : 314.15926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "kg",
"source" : "EPA(Taiwan)",
"urlName" : "EPA(Taiwan)",
"sheetName" : "Sheet Name : IPCC AR6",
"file" : "/upload/ef/IPCC_AR6_WGI_Chapter_07_Supplementary_Material",
"link" : "https://www.ipcc.ch/report/ar6/wg1/downloads/report/IPCC_AR6_WGI_Chapter_07_Supplementary_Material.pdf",
"year" : 2021,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
},
{
"sourceOfEmission" : "test1.4 Spetic Tank",
"co2Factor" : 0,
"ch4Factor" : 0.00000314159,
"n2oFactor" : 0,
"baseUnit" : "passenger-hour",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/溫室氣體排放係數管理表6.0.4版.ods",
"link" : "https://ghgregistry.moenv.gov.tw/epa_ghg/Downloads/FileDownloads.aspx?Type_ID=1",
"year" : 2019,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "tonneCH₄",
"n2oUnit" : "tonneN₂O"
}
],
"category" : "Refrigerants and Fugitives"
},
```
##### 測試一下type是否為必須？
對應排放活動的參數：
Equiptment Category: 自行選擇
Activity Name: 自行選擇
Source: methods.source
Emission Type: methods.sourceOfEmission - methods.baseUnit(ex. test1.4 Spetic Tank - passenger-hour)
1.5 issue: 無法測試
```json
// 2.1
{
"type" : "Location Based",
"methods" : [
{
"sourceOfEmission" : "test2.1",
"co2Factor" : 0.31415926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "kWh",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/111年度電力排碳係數.pdf",
"link" : "https://www.moeaea.gov.tw/ecw/populace/content/SubMenu.aspx?menu_id=114",
"year" : 2022,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope2",
"category" : "Purchased Electricity"
}
```
對應排放活動的參數：
Energy Type: category
Method of Calculation: type
Source: methods.source
Emission Type: methods.sourceOfEmission - methods.baseUnit(ex. test2.1 - kWh)
2.2 issue: Database 沒有任何和2.2相關的係數，但平台卻出現1.1的係數（根據typeOfEmission可以找到）
```json
//3.1
{
"methods" : [
{
"sourceOfEmission" : "Commercial Car(Gasoline)(2014)",
"type" : "Car",
"co2Factor" : 0.133,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "passenger-km",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"year" : 2023,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope3",
"category" : "Upstream T&D"
}
```
對應排放活動的參數：
Source: methods.source
Mode of Transport: methods.type
Vehicle Type: methods.sourceOfEmission - methods.baseUnit(ex. test3.1 - passenger-km)
Method of Calculation: 自行選擇
```json
// 3.2
{
"methods" : [
{
"sourceOfEmission" : "test3.2",
"type" : "Car",
"co2Factor" : 0.31415926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "passenger-km",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"year" : 2023,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope3",
"category" : "Downstream T&D"
}
```
對應排放活動的參數：
Source: methods.source
Mode of Transport: methods.type
Vehicle Type: methods.sourceOfEmission - methods.baseUnit(ex. test3.2 - passenger-km)
Method of Calculation: 自行選擇
```json
// 3.3
{
"methods" : [
{
"sourceOfEmission" : "test3.3",
"type" : "Car",
"co2Factor" : 0.31415926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "passenger-km",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"year" : 2023,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope3",
"category" : "Employee Commuting"
}
```
對應排放活動的參數：
Source: methods.source
Mode of Transport: methods.type
Vehicle Type: methods.sourceOfEmission - methods.baseUnit(ex. test3.3 - passenger-km)
Method of Calculation: 自行選擇
```json
// 3.4
{
"methods" : [
{
"sourceOfEmission" : "test3.4",
"type" : "Car",
"co2Factor" : 0.31415926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "passenger-km",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"year" : 2023,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope3",
"category" : "Client and Visitor Transport"
}
```
對應排放活動的參數：
Source: methods.source
Mode of Transport: methods.type
Vehicle Type: methods.sourceOfEmission - methods.baseUnit(ex. test3.4 - passenger-km)
Method of Calculation: 自行選擇
```json
// 3.5
{
"methods" : [
{
"sourceOfEmission" : "test3.5",
"type" : "Car",
"co2Factor" : 0.31415926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "passenger-km",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"year" : 2023,
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope3",
"category" : "Business Travel"
}
```
對應排放活動的參數：
Source: methods.source
Mode of Transport: methods.type
Vehicle Type: methods.sourceOfEmission - methods.baseUnit(ex. test3.5 - passenger-km)
Method of Calculation: 自行選擇
```json
// 4.1
{
"scope" : "scope3",
"methods" : [
{
"co2Factor" : 0.31415926,
"baseUnit" : "m3",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"sourceOfEmission" : "test4.1",
"year" : "2022",
"emissionUnit" : "kgCO₂e",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"typeOfEmission" : "Water",
"category" : "Purchased Goods"
}
```
對應排放活動的參數：
Source: methods.source
Emission Soure: typeOfEmission
Emission Type: methods.sourceOfEmission - methods.baseUnit(ex. test4.1 - m3)
```json
// 4.2
{
"scope" : "scope3",
"methods" : [
{
"sourceOfEmission" : "test4.2",
"co2Factor" : 3.1415926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "2021 USD, purchaser price",
"source" : "EPA Taiwan",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"year" : "2021",
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O",
"urlName" : "EPA Taiwan",
"sheetName" : ""
}
],
"typeOfEmission" : "Supply Chain Emission Factors without Margins",
"category" : "Capital Goods that are Purchased and Amortized by an Organization"
}
```
對應排放活動的參數：
Source: methods.source
Emission Source: typeOfEmission
Emsision Type: methods.sourceOfEmission - methods.baseUnit(ex. test4.2 - 2021 USD, purchaser price)
```json
// 4.3
{
"methods": [
{
"sourceOfEmission": "岡山垃圾焚化廠",
"co2Factor": 360,
"ch4Factor": 0,
"n2oFactor": 0,
"baseUnit": "tonne",
"source": "產品碳足跡資訊網",
"urlName": null,
"sheetName": "",
"file": null,
"link": "https://cfp-calculate.tw/cfpc/WebPage/Index.aspx",
"year": 2020,
"emissionUnit": "kgCO₂",
"ch4Unit": "kgCH₄",
"n2oUnit": "kgN₂O"
}
],
"scope": "scope3",
"typeOfEmission": "焚化",
"category": "Waste"
}
```
對應排放活動的參數：
Method of Calculation: 自行選擇
Source: methods.source
Waste Treatment Method: typeOfEmission
Material: methods.sourceOfEmission - methods.baseUnit(ex. 岡山垃圾焚化廠 - tonne)
```json
//4.4
{
"methods" : [
{
"sourceOfEmission" : "test4.4",
"co2Factor" : 0.31415926,
"ch4Factor" : 0.0002,
"n2oFactor" : 0.0003,
"baseUnit" : "km",
"source" : "EPA Taiwan",
"urlName" : "DEFRA GHG reporting 2022",
"sheetName" : "Factors by Category",
"file" : "/upload/ef/DEFRA-ghg-conversion-factors-2022-flat-format.xlsx",
"link" : "https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2022",
"type" : "Managed cars (by market segment) - Mini",
"year" : "2022",
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope3",
"category" : "Use of Assets (through leased equipment) by an Organization"
}
```
對應排放活動的參數：
Source: methods.source
Mode of Transport: type
Vehicle Type: methods.sourceOfEmission
Method of Calculation: 自行選擇
4.5 issue: 無法測試，目前唯有自定義係數
5.1 issue: 無法測試，目前唯有自定義係數
5.2 issue: 無法測試，目前唯有自定義係數
```json
// 5.3
{
"methods" : [
{
"companyId" : ObjectId("652cf8aae76f185628e48db8"), // companyId 為 site_modules裡面公司的Id，只有該公司會有這個係數
"sourceOfEmission" : "test5.3",
"co2Factor" : 3.1415926,
"ch4Factor" : null,
"n2oFactor" : null,
"baseUnit" : "kg",
"source" : "EPA Taiwan",
"urlName" : null,
"sheetName" : "001-Knowles-KEM GHG Inventory_Mar2023",
"file" : null,
"link" : null,
"year" : "2023",
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O"
}
],
"scope" : "scope3",
"typeOfEmission" : "Recycled",
"category" : "End of Life Stage of the Product"
}
```
對應排放活動的參數：
Method of Calculation: 自行選擇
Emission Type: typeOfEmission
Source: methods.source
Material: methods.sourceOfEmission - methods.baseUnit(ex. test5.3 - kg)
5.4 issue: 無法測試，目前唯有自定義係數
```json
// 6.1
{
"methods" : [
{
"sourceOfEmission" : "test6.1",
"co2Factor" : 0.31415926,
"ch4Factor" : 0,
"n2oFactor" : 0,
"baseUnit" : "per FTE Working Hour",
"source" : "EPA Taiwan",
"urlName" : "EPA Taiwan",
"sheetName" : "",
"file" : "/upload/ef/碳係數明細-全.pdf",
"link" : "https://cfp-calculate.tw/cfpc/WebPage/LoginPage.aspx",
"emissionUnit" : "kgCO₂",
"ch4Unit" : "kgCH₄",
"n2oUnit" : "kgN₂O",
"year" : "2022"
}
],
"scope" : "scope3",
"category" : "GHG Emissions or Removals from Other Sources"
}
```
對應排放活動的參數：
Source: methods.source
Emission Type: methods.sourceOfEmission - methods.baseUnit(ex. test6.1 - per FTE Working Hour)
-----
```mermaid
graph TD
A["EF<br>----------------<br>EFId<br>companyId<br>name<br>vehicleType<br>fuelEfficiency<br>CO2<br>CH4<br>N2O<br>unit<br>type<br>year<br>urlName<br>sheetName<br>CO2Unit<br>CH4Unit<br>N2OUnit<br>sourceId<br>typeId<br>everTable<br>everId"]
B["EFCategory<br>----------------<br>EFC<br>category<br>key<br>Name"]
D["EFsource<br>---------------<br>sourceId<br>name<br>level<br>country<br>code<br>organize<br>link<br>file<br>latestId"]
E[EFxGWP<br>------------------<br>EFxGWPId<br>GasName<br>AR2<br>AR3<br>AR4<br>AR5<br>AR6]
F[GWP<br>--------------------<br>Year<br>IPCC<br>co2<br>ch4<br>n2o<br>sf6<br>nf3]
G["EFtype<br>---------------------<br>typeId<br>type<br>scope<br>typeOfEmission<br>category<br>categoryKey<br>nameKey<br>sourceType<br>usedRegion<br>sourceOfEmission"]
H["translation<br>--------------<br>tId<br>urlId<br>en<br>de<br>it<br>jp<br>th<br>tw<br>zh"]
I["url<br>---------------------<br>urlId<br>urlName"]
subgraph Emission Factor Database Relationship
A ---|"typeId(EF) is connected to <br>typeId(EFType)"| G
G ---|"Category(EFType) is connected to<br>EFC(EFCategory)"| B
A ---|"The latestId is the latest <br>number part of EFId<br><br>example:<br>the latestId is 2024,<br>then the next EF's EFId<br>is US02025"| D
end
subgraph GWP Database Relationship
E
F
end
subgraph Translations Database Relationship
H ---|"urlId(translations)<br>is connected to<br>urlId(url)"| I
end
```
### Emission Factor Databases Relationship
* EF
* EFId: Emission Factor No.
* companyId: The id of the company (id in MongoDB; only the company with this id can see this factor)
* name: The name of emission source
* EFtype
* EFsource
* EFCategory
Sign in with Wallet
Connect another wallet