issues
search
Open-Earth-Foundation
/
OpenClimate-Schema
Schema for OpenClimate database
Apache License 2.0
7
stars
2
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Add table for GHGs and Scope
#59
lgloege
opened
1 year ago
0
feat(ON-179): add table for uses datasources approved for
#58
lgloege
closed
1 year ago
0
feat(emissions): Revisit and review EmissionsBreakdown
#57
yeozy95
closed
1 year ago
1
Documentation for baseline value
#56
yeozy95
opened
1 year ago
0
Tracking sector of targets
#55
yeozy95
opened
1 year ago
0
feat(target): add initiative_id; closes #53
#54
lgloege
closed
1 year ago
0
Link InitiativePledge to Target table through `initiative_id`
#53
lgloege
opened
1 year ago
0
DataSource dependencies
#52
evanp
opened
1 year ago
0
Add `url` and `summary` to `Targets` table
#51
lgloege
closed
1 year ago
1
Change `data_source` to `datasource_id` in `Target.sql`
#50
lgloege
closed
1 year ago
1
How we determine which is the preferred name of an actor?
#49
yeozy95
opened
1 year ago
2
How do we record target year emissions for fixed level targets with a target of achieving a set emissions number by the target year?
#48
yeozy95
closed
1 year ago
1
How do we tell what the administrative/emissions boundary of the targets are?
#47
yeozy95
closed
1 year ago
0
Baseline emissions in `Targets` table
#46
yeozy95
closed
1 year ago
1
Reconciling `EmissionsAgg` and `EmissionsBreakdown` with `EmissionsByScope` and `EmissionsBySector`
#45
yeozy95
opened
1 year ago
0
Fixes to SQL + Updated Target table
#44
yeozy95
closed
1 year ago
0
actor_id in the InitiativesPledges table
#43
yeozy95
closed
1 year ago
1
Latitude, longitude definitions
#42
evanp
closed
1 year ago
0
Population, GDP change over time
#41
evanp
closed
1 year ago
0
Update the diagram to match the schema
#40
evanp
opened
1 year ago
0
Sector vocabulary
#39
evanp
opened
1 year ago
3
Backticks vs double quotation marks in SQL files
#38
yeozy95
closed
1 year ago
1
Schema documentation
#37
lgloege
opened
1 year ago
4
DataSource versioning
#36
evanp
opened
2 years ago
1
DataSource for Actor
#35
evanp
closed
2 years ago
0
What is `InitiativePledge` for?
#34
evanp
opened
2 years ago
2
What is EmissionsBreakdown for?
#33
evanp
closed
1 year ago
1
EmissionsAgg foreign keys
#32
evanp
closed
2 years ago
0
`DataSource.publisher` is a foreign key to `Publisher.id`
#31
evanp
closed
2 years ago
0
`Action.actor_id` is a foreign key to `Actor.actor_id`
#30
evanp
closed
2 years ago
0
Timestamps on all tables
#29
evanp
closed
2 years ago
1
Foreign key from ActorIdentifier to Actor
#28
evanp
closed
2 years ago
0
ActorIdentifier is unique for an identifier and a namespace
#27
evanp
closed
2 years ago
0
Change `bool` to `boolean`
#26
evanp
closed
2 years ago
0
Foreign key from ActorName to Actor
#25
evanp
closed
2 years ago
1
ActorName primary key should be (actor_id, language, name)
#24
evanp
closed
2 years ago
0
Add `language` column to `ActorName`
#23
evanp
closed
2 years ago
0
Add attributes total_Co2_emissions_year and total_Co2_emissions to Emissions_Scope table
#22
AyinawuT
opened
2 years ago
1
The CDP data model has the following attributes which I think can be added to the target table
#21
AyinawuT
opened
2 years ago
0
Add emissions_unit as an attribute to the Emissions_Scope table
#20
AyinawuT
closed
1 year ago
1
Add ghgs_unit as an attribute to Actor_to_Sector_Emissions table
#19
AyinawuT
opened
2 years ago
1
Breakdown of emissions based on sectors of actors
#18
AyinawuT
opened
2 years ago
2
methodology_id and tag_id should be represented as primary keys in the methodology_to_tags table
#17
AyinawuT
opened
2 years ago
1
Actor and Target tables have a many-to-many relationship based on CDP data model
#16
AyinawuT
opened
2 years ago
1
DataSource and Publisher tables may have a many-to-many relationship
#15
AyinawuT
opened
2 years ago
1
datasource_id in TradesTransfer table.
#14
AyinawuT
opened
2 years ago
0
Different tables with the same primary key
#13
AyinawuT
closed
1 year ago
1
Emissions calculation algorithm in data model?
#12
yeozy95
closed
1 year ago
2
Actor type vocabulary
#11
evanp
opened
2 years ago
0
What is "hq"?
#10
evanp
opened
2 years ago
1
Next