markevich / co2_offset Goto Github PK

We need a table that will store distances between all of earth planet capitals.

Table layout -
|id|capital_a|capital_b|distance|transport_type(enum: car train plane fallback)|

We can use google api to fetch distances by different transport type.

If we don't have available transport from point A to point B (for example train from europe to africa) then we will use fallback distance for those cities.

1 human 1 day = 1kg co2

1 km = 0.0225 kg co2

https://stackoverflow.com/questions/42362376/phoenix-framework-page-titles-per-route

Fix tests as well

1 kg meat production = 34.6 kg

We need variables support

1 liter = 2.34 kg co2

1 kg of chicken meat production = 4.67kg

https://www.postgresql.org/docs/9.1/datatype-enum.html

1. add validation from current transport type(?)

2.1 current string field has to be migrated from simple string to PG ENUM TYPE
or
2.2 just add some checks to application level

https://github.com/jpatokal/openflights/tree/master/data

We need name, city, country, iata, lat, long

Airport ID | Unique OpenFlights identifier for this airport.

Name | Name of airport. May or may not contain the City name.

City | Main city served by airport. May be spelled differently from Name.

Country | Country or territory where airport is located. See countries.dat to cross-reference to ISO 3166-1 codes.

IATA | 3-letter IATA code. Null if not assigned/unknown.

ICAO | 4-letter ICAO code.Null if not assigned.

Latitude | Decimal degrees, usually to six significant digits. Negative is South, positive is North.

Longitude | Decimal degrees, usually to six significant digits. Negative is West, positive is East.

Altitude | In feet.

Timezone | Hours offset from UTC. Fractional hours are expressed as decimals, eg. India is 5.5.
DST | Daylight savings time. One of E (Europe), A (US/Canada), S (South America), O (Australia), Z (New Zealand), N (None) or U (Unknown). See also: Help: Time

Tz database time zone | Timezone in "tz" (Olson) format, eg. "America/Los_Angeles".

Type | Type of the airport. Value "airport" for air terminals, "station" for train stations, "port" for ferry terminals and "unknown" if not known.  In airports.csv, only type=airport is included.

Source | Source of this data. "OurAirports" for data sourced from OurAirports, "Legacy" for old data not matched to OurAirports (mostly DAFIF), "User" for unverified user contributions.  In airports.csv, only source=OurAirports is included.

The emissions of planes are around 90 kg CO2 per hour.

These CO2 emissions are generally into the high atmosphere, and this is thought to have a greater greenhouse effect than CO2 released at sea level. The emissions are therefore adjusted by multiplication by a factor of 2.00 (see 'Radiative forcing' below) to give 180 kg CO2 equivalent per hour.

Add channels to read the updated co2 input value

From [co2, %{ type: car, km: km, co2: co2}] to %{co2: co2, car: %{km: km}}

We can measure the degassing of Mt. Etna extremely well, and find that it adds about 16,000 tons of CO2 to the atmosphere each day

1 day = 16000 kg CO2

https://www.amberbit.com/blog/2018/11/27/deploy-elixir-app-to-a-vps-part-2/

See design in figma

1 km = 0.132 kg co2

relates to #48

• Create a CSV file with distances between capitals.
• Create a mix task that imports this CSV into capitals_distances table.

https://www.ossec.net/docs/