I am working on a project where I have to map Green house gases emissions from all city buildings for the current year and for next 30 years with 10 years gap, i.e: emissions for 2020, 2030, 2040 and 2050. Now I have all the equations and scenarios that I am considering for the future state mapping. I am able to do all these calculation within ArcPro environment, however, I have hit the roadblock at this stage of my project where I want to create a custom tool (either on Model Builder or in python) to carry out these calculations.
Information about the feature class:
Equations for Emission Calculations:
2020 Gas Emissions: Gas consumption * 0.0561 -- Natural Gas emission factor
2030 Gas Emissions: Gas consumption * (0.0561*0.95)
2040 Gas Emissions: Gas consumption * (0.0561*0.9)
2050 Gas Emissions: Gas consumption * (0.0561*0.8)
2020 Electricity Emissions: (Electricity consumption * 1000)*0.0005 --- Electric emission factor
2030 Electricity Emissions: (Electricity consumption * 1000)*0.00031
2040 Electricity Emissions: (Electricity consumption * 1000)*0.00017
2050 Electricity Emissions: (Electricity consumption * 1000)*0.00009
These calculations provide emissions in tonnesCO2e/year
Our calculations are based on an assumption that emissions will reduce from the transportation and buildings due to improvements in technology.
So, Idea is to create a tool where we have specific variables that would help reduce the emission in the future by some percentage, I have attached an excel table from where I can choose some of the variable for calculations.
I want to start simple at this point and built my model on a specific template where I could add as many variables as needed also If required, I can share test data privately as well.
I am still a beginner in Python and model builder so any help would be highly appreciated.
Thanks in advance
Write back if it works out. I will try to create a model and post back later today.
Hello Shitij Mehta
Thanks for getting back to me, the excel table that i have attached is not my primary data its just a reference table for variables that i will add into my final feature class, i have a shape file that has polygons and energy values in it, and the values for these parameters are derived from those energy values. please let me know how i can share my data with you, it would be much easier for you to work on the shape file.
Really appreciate you working with me.