Table pathways_us_2017-1-15.public.DemandServiceEfficiency
Service efficiency is the energy required per unit of service demand. This is rarely a direct input for a subsector, but is most of the time calculated as a function of technologies. One example from the U.S. database is freight rail, which is input in kiloBtu per ton mile.

 Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
subsector_id int4 10
DemandSubsectors.id DemandServiceEfficiency_subsector_id_fkey R
Parent subsector.
energy_unit text 2147483647  √  null Input energy unit
denominator_unit text 2147483647  √  null Service demand unit
geography_id int4 10  √  null
Geographies.id DemandServiceEfficiency_geography_id_fkey R
Input geography for the data (e.g. state)
other_index_1_id int4 10  √  null
OtherIndexes.id DemandServiceEfficiency_other_index_1_id_fkey R
First sub category for the input data (e.g. housing type)
other_index_2_id int4 10  √  null
OtherIndexes.id DemandServiceEfficiency_other_index_2_id_fkey R
Second sub category for the input data (e.g. housing type)
interpolation_method_id int4 10  √  null
CleaningMethods.id DemandServiceEfficiency_interpolation_method_id_fkey R
Cleaning method used to interpolate between missing years when data is entered.
extrapolation_method_id int4 10  √  null
CleaningMethods.id DemandServiceEfficiency_extrapolation_method_id_fkey R
Cleaning method used to extrapolate to missing years when data is entered.
extrapolation_growth float4 8,8  √  null If extrapolation method exponential is used, what is the year over year growth rate?
geography_map_key_id int4 10  √  null
GeographyMapKeys.id DemandServiceEfficiency_geography_map_key_id_fkey R
Basis for mapping between geographies. For example, if my input data is for the entire country and I want to allocate the data to each state, do it based on the proportional share of households in each state. For more information, see: https://docs.google.com/document/d/19cspAg2El5d1dvQggi7Vx8XJ1al-11IDf6DgRbpk-FU/edit#heading=h.n712kivlou9l

Table contained 3 rows at Tue Jan 17 22:23 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
subsector_id Primary key Asc DemandServiceEfficiency_pkey

Close relationships  within of separation: