Datamodels API Reference

Auto-generated reference for ca_biositing.datamodels — the SQLModel-based database models used across the project.

Base Classes

Base mixin classes for SQLModel models.

These are non-table mixins that provide shared fields to entity tables. They replace the concrete BaseEntity and LookupBase tables from the LinkML-generated code.

Classes

`BaseEntity`

Bases: SQLModel

Mixin for all main entity tables. Provides id, timestamps, lineage.

This is NOT a table itself - it's a mixin that child classes inherit from.

Attributes

`id: Optional[int]`

`created_at: Optional[datetime]`

`updated_at: Optional[datetime]`

`etl_run_id: Optional[int]`

`lineage_group_id: Optional[int]`

`LookupBase`

Bases: SQLModel

Mixin for enum/ontology-like lookup tables. Provides id, name, description, uri.

This is NOT a table itself - it's a mixin that child classes inherit from.

Attributes

`id: Optional[int]`

`name: Optional[str]`

`description: Optional[str]`

`uri: Optional[str]`

`Aim1RecordBase`

Bases: BaseEntity

Mixin for Aim1 analytical records. Adds record_id + common experiment/sample fields.

Inherits from BaseEntity, so also includes id, timestamps, and lineage fields.

Attributes

`record_id: str`

`dataset_id: Optional[int]`

`experiment_id: Optional[int]`

`resource_id: Optional[int]`

`prepared_sample_id: Optional[int]`

`technical_replicate_no: Optional[int]`

`technical_replicate_total: Optional[int]`

`method_id: Optional[int]`

`analyst_id: Optional[int]`

`raw_data_id: Optional[int]`

`qc_pass: Optional[str]`

`note: Optional[str]`

`Aim2RecordBase`

Bases: BaseEntity

Mixin for Aim2 processing records. Adds record_id + common experiment/sample fields.

Inherits from BaseEntity, so also includes id, timestamps, and lineage fields.

Attributes

`record_id: str`

`dataset_id: Optional[int]`

`experiment_id: Optional[int]`

`resource_id: Optional[int]`

`prepared_sample_id: Optional[int]`

`technical_replicate_no: Optional[int]`

`technical_replicate_total: Optional[int]`

`method_id: Optional[int]`

`analyst_id: Optional[int]`

`raw_data_id: Optional[int]`

`qc_pass: Optional[str]`

`note: Optional[str]`

Resource & Biomass Models

Classes

Modules

`primary_ag_product`

Classes

`PrimaryAgProduct`

Bases: LookupBase

`resource`

Classes

`ResourceMorphology`

Bases: SQLModel

Attributes

id: Optional[int]

resource_id: Optional[int]

morphology_uri: Optional[str]

resource: Optional[Resource]

`Resource`

Bases: BaseEntity

Attributes

name: Optional[str]

primary_ag_product_id: Optional[int]

resource_class_id: Optional[int]

resource_subclass_id: Optional[int]

resource_code: Optional[str]

description: Optional[str]

uri: Optional[str]

primary_ag_product: Optional[PrimaryAgProduct]

resource_class: Optional[ResourceClass]

resource_subclass: Optional[ResourceSubclass]

`ResourceSubclass`

Bases: LookupBase

`ResourceClass`

Bases: LookupBase

`resource_availability`

Classes

`ResourceAvailability`

Bases: BaseEntity

Attributes

resource_id: Optional[int]

geoid: Optional[str]

from_month: Optional[int]

to_month: Optional[int]

year_round: Optional[bool]

residue_factor_dry_tons_acre: Optional[float]

residue_factor_wet_tons_acre: Optional[float]

note: Optional[str]

resource: Optional[Resource]

place: Optional[Place]

`resource_counterfactual`

Classes

`ResourceCounterfactual`

Bases: BaseEntity

Attributes

geoid: Optional[str]

resource_id: Optional[int]

counterfactual_description: Optional[str]

animal_bedding_percent: Optional[Decimal]

animal_bedding_source_id: Optional[int]

animal_feed_percent: Optional[Decimal]

animal_feed_source_id: Optional[int]

bioelectricty_percent: Optional[Decimal]

bioelectricty_source_id: Optional[int]

burn_percent: Optional[Decimal]

burn_source_id: Optional[int]

compost_percent: Optional[Decimal]

compost_source_id: Optional[int]

landfill_percent: Optional[Decimal]

landfill_source_id: Optional[int]

counterfactual_date: Optional[date]

place: Optional[Place]

resource: Optional[Resource]

Geographic Models

Classes

Modules

`location_address`

Classes

`LocationAddress`

Bases: BaseEntity

Attributes

geography_id: Optional[str]

address_line1: Optional[str]

address_line2: Optional[str]

city: Optional[str]

zip: Optional[str]

lat: Optional[float]

lon: Optional[float]

is_anonymous: Optional[bool]

geography: Optional[Place]

`place`

Classes

`Place`

Bases: SQLModel

Attributes

geoid: Optional[str]

state_name: Optional[str]

state_fips: Optional[str]

county_name: Optional[str]

county_fips: Optional[str]

region_name: Optional[str]

agg_level_desc: Optional[str]

Field Sampling

Classes

Modules

`ag_treatment`

Classes

`AgTreatment`

Bases: LookupBase

`collection_method`

Classes

`CollectionMethod`

Bases: LookupBase

`field_sample`

Classes

`FieldSample`

Bases: BaseEntity

Attributes

name: Optional[str]

resource_id: Optional[int]

provider_id: Optional[int]

collector_id: Optional[int]

sample_collection_source: Optional[str]

amount_collected: Optional[Decimal]

amount_collected_unit_id: Optional[int]

sampling_location_id: Optional[int]

field_storage_method_id: Optional[int]

field_storage_duration_value: Optional[Decimal]

field_storage_duration_unit_id: Optional[int]

field_storage_location_id: Optional[int]

collection_timestamp: Optional[datetime]

collection_method_id: Optional[int]

harvest_method_id: Optional[int]

harvest_date: Optional[date]

field_sample_storage_location_id: Optional[int]

note: Optional[str]

resource: Optional[Resource]

provider: Optional[Provider]

collector: Optional[Contact]

amount_collected_unit: Optional[Unit]

sampling_location: Optional[LocationAddress]

field_storage_method: Optional[FieldStorageMethod]

field_storage_duration_unit: Optional[Unit]

field_storage_location: Optional[LocationAddress]

collection_method: Optional[CollectionMethod]

harvest_method: Optional[HarvestMethod]

field_sample_storage_location: Optional[LocationAddress]

`field_sample_condition`

Classes

`FieldSampleCondition`

Bases: BaseEntity

Attributes

field_sample_id: Optional[int]

ag_treatment_id: Optional[int]

last_application_date: Optional[date]

treatment_amount_per_acre: Optional[float]

processing_method_id: Optional[int]

field_sample: Optional[FieldSample]

ag_treatment: Optional[AgTreatment]

processing_method: Optional[ProcessingMethod]

`field_storage_method`

Classes

`FieldStorageMethod`

Bases: LookupBase

`harvest_method`

Classes

`HarvestMethod`

Bases: LookupBase

`physical_characteristic`

Classes

`PhysicalCharacteristic`

Bases: BaseEntity

Attributes

field_sample_id: Optional[int]

particle_length: Optional[Decimal]

particle_width: Optional[Decimal]

particle_height: Optional[Decimal]

particle_unit_id: Optional[int]

field_sample: Optional[FieldSample]

particle_unit: Optional[Unit]

`processing_method`

Classes

`ProcessingMethod`

Bases: LookupBase

`soil`

Classes

`SoilType`

Bases: LookupBase

`LocationSoilType`

Bases: BaseEntity

Attributes

location_id: Optional[int]

soil_type_id: Optional[int]

location: Optional[LocationAddress]

soil_type: Optional[SoilType]

Aim 1 Analytical Records

Classes

Modules

`calorimetry_record`

Classes

`CalorimetryRecord`

Bases: Aim1RecordBase

`compositional_record`

Classes

`CompositionalRecord`

Bases: Aim1RecordBase

`ftnir_record`

Classes

`FtnirRecord`

Bases: Aim1RecordBase

`icp_record`

Classes

`IcpRecord`

Bases: Aim1RecordBase

`proximate_record`

Classes

`ProximateRecord`

Bases: Aim1RecordBase

`rgb_record`

Classes

`RgbRecord`

Bases: Aim1RecordBase

`ultimate_record`

Classes

`UltimateRecord`

Bases: Aim1RecordBase

`xrd_record`

Classes

`XrdRecord`

Bases: Aim1RecordBase

Attributes

scan_low_nm: Optional[int]

scan_high_nm: Optional[int]

`xrf_record`

Classes

`XrfRecord`

Bases: Aim1RecordBase

Attributes

wavelength_nm: Optional[Decimal]

intensity: Optional[Decimal]

energy_slope: Optional[Decimal]

energy_offset: Optional[Decimal]

Aim 2 Processing Records

Classes

Modules

`autoclave_record`

Classes

`AutoclaveRecord`

Bases: Aim2RecordBase

`fermentation_record`

Classes

`FermentationRecord`

Bases: Aim2RecordBase

Attributes

strain_id: Optional[int]

pretreatment_method_id: Optional[int]

eh_method_id: Optional[int]

well_position: Optional[str]

vessel_id: Optional[int]

analyte_detection_equipment_id: Optional[int]

`gasification_record`

Classes

`GasificationRecord`

Bases: Aim2RecordBase

Attributes

reactor_type_id: Optional[int]

`pretreatment_record`

Classes

`PretreatmentRecord`

Bases: Aim2RecordBase

Attributes

pretreatment_method_id: Optional[int]

eh_method_id: Optional[int]

reaction_block_id: Optional[int]

vessel_id: Optional[int]

block_position: Optional[str]

temperature: Optional[Decimal]

replicate_no: Optional[int]

`strain`

Classes

`Strain`

Bases: LookupBase

Attributes

parent_strain_id: Optional[int]

External Data (USDA, LandIQ, Billion Ton)

Classes

Modules

`billion_ton`

Classes

`BillionTon2023Record`

Bases: BaseEntity

Attributes

dataset_id: Optional[int]

subclass_id: Optional[int]

resource_id: Optional[int]

geoid: Optional[str]

county_square_miles: Optional[float]

model_name: Optional[str]

scenario_name: Optional[str]

price_offered_usd: Optional[Decimal]

production: Optional[int]

production_unit_id: Optional[int]

btu_ton: Optional[int]

production_energy_content: Optional[int]

energy_content_unit_id: Optional[int]

product_density_dtpersqmi: Optional[Decimal]

land_source: Optional[str]

dataset: Optional[Dataset]

subclass: Optional[ResourceSubclass]

resource: Optional[Resource]

place: Optional[Place]

production_unit: Optional[Unit]

energy_content_unit: Optional[Unit]

`landiq_record`

Classes

`LandiqRecord`

Bases: BaseEntity

Attributes

record_id: str

dataset_id: Optional[int]

polygon_id: Optional[int]

main_crop: Optional[int]

secondary_crop: Optional[int]

tertiary_crop: Optional[int]

quaternary_crop: Optional[int]

confidence: Optional[int]

irrigated: Optional[bool]

acres: Optional[float]

county: Optional[str]

version: Optional[str]

note: Optional[str]

pct1: Optional[float]

pct2: Optional[float]

pct3: Optional[float]

pct4: Optional[float]

polygon: Optional[Polygon]

dataset: Optional[Dataset]

main_crop_product: Optional[PrimaryAgProduct]

secondary_crop_product: Optional[PrimaryAgProduct]

tertiary_crop_product: Optional[PrimaryAgProduct]

quaternary_crop_product: Optional[PrimaryAgProduct]

`landiq_resource_mapping`

Classes

`LandiqResourceMapping`

Bases: BaseEntity

Attributes

landiq_crop_name: Optional[int]

resource_id: Optional[int]

landiq_crop: Optional[PrimaryAgProduct]

resource: Optional[Resource]

`polygon`

Classes

`Polygon`

Bases: BaseEntity

Geographic polygon with MD5-based unique constraint on geometry.

Attributes

geoid: Optional[str]

geom: Optional[Any]

dataset_id: Optional[int]

dataset: Optional[Dataset]

`resource_usda_commodity_map`

Classes

`ResourceUsdaCommodityMap`

Bases: BaseEntity

Attributes

resource_id: Optional[int]

primary_ag_product_id: Optional[int]

usda_commodity_id: Optional[int]

match_tier: Optional[str]

note: Optional[str]

resource: Optional[Resource]

primary_ag_product: Optional[PrimaryAgProduct]

usda_commodity: Optional[UsdaCommodity]

`usda_census`

Classes

`UsdaCommodity`

Bases: LookupBase

Attributes

usda_source: Optional[str]

usda_code: Optional[str]

api_name: Optional[str]

created_at: Optional[datetime]

updated_at: Optional[datetime]

parent_commodity_id: Optional[int]

parent_commodity: Optional[UsdaCommodity]

`UsdaCensusRecord`

Bases: BaseEntity

Attributes

dataset_id: Optional[int]

geoid: Optional[str]

commodity_code: Optional[int]

year: Optional[int]

source_reference: Optional[str]

note: Optional[str]

dataset: Optional[Dataset]

place: Optional[Place]

commodity: Optional[UsdaCommodity]

`UsdaDomain`

Bases: LookupBase

`UsdaStatisticCategory`

Bases: LookupBase

`usda_survey`

Classes

`UsdaMarketReport`

Bases: BaseEntity

Attributes

slug_id: Optional[int]

slug_name: Optional[str]

report_series_title: Optional[str]

frequency: Optional[str]

office_name: Optional[str]

office_city_id: Optional[int]

office_state_fips: Optional[str]

source_id: Optional[int]

office_city: Optional[LocationAddress]

source: Optional[DataSource]

`UsdaMarketRecord`

Bases: BaseEntity

Attributes

report_id: Optional[int]

dataset_id: Optional[int]

report_begin_date: Optional[datetime]

report_end_date: Optional[datetime]

report_date: Optional[datetime]

commodity_id: Optional[int]

market_type_id: Optional[int]

market_type_category: Optional[str]

grp: Optional[str]

market_category_id: Optional[int]

class_: Optional[str]

grade: Optional[str]

variety: Optional[str]

protein_pct: Optional[Decimal]

application: Optional[str]

pkg: Optional[str]

sale_type: Optional[str]

price_unit_id: Optional[int]

freight: Optional[str]

trans_mode: Optional[str]

report: Optional[UsdaMarketReport]

dataset: Optional[Dataset]

commodity: Optional[UsdaCommodity]

price_unit: Optional[Unit]

`UsdaSurveyProgram`

Bases: LookupBase

`UsdaSurveyRecord`

Bases: BaseEntity

Attributes

dataset_id: Optional[int]

geoid: Optional[str]

commodity_code: Optional[int]

year: Optional[int]

survey_program_id: Optional[int]

survey_period: Optional[str]

begin_code: Optional[str]

end_code: Optional[str]

reference_month: Optional[str]

seasonal_flag: Optional[bool]

note: Optional[str]

dataset: Optional[Dataset]

place: Optional[Place]

commodity: Optional[UsdaCommodity]

survey_program: Optional[UsdaSurveyProgram]

`UsdaTermMap`

Bases: BaseEntity

Attributes

source_system: Optional[str]

source_context: Optional[str]

raw_term: Optional[str]

usda_commodity_id: Optional[int]

is_verified: Optional[bool]

note: Optional[str]

usda_commodity: Optional[UsdaCommodity]

General Analysis

Classes

Modules

`analysis_type`

Classes

`AnalysisType`

Bases: LookupBase

`dataset`

Classes

`Dataset`

Bases: BaseEntity

Attributes

name: Optional[str]

record_type: Optional[str]

source_id: Optional[int]

start_date: Optional[date]

end_date: Optional[date]

description: Optional[str]

source: Optional[DataSource]

`dimension_type`

Classes

`DimensionType`

Bases: LookupBase

`observation`

Classes

`Observation`

Bases: BaseEntity

Attributes

record_id: str

dataset_id: Optional[int]

record_type: Optional[str]

parameter_id: Optional[int]

value: Optional[Decimal]

unit_id: Optional[int]

dimension_type_id: Optional[int]

dimension_value: Optional[Decimal]

dimension_unit_id: Optional[int]

note: Optional[str]

dataset: Optional[Dataset]

parameter: Optional[Parameter]

unit: Optional[Unit]

dimension_type: Optional[DimensionType]

dimension_unit: Optional[Unit]

People & Organizations

Classes

Modules

`contact`

Classes

`Contact`

Bases: BaseEntity

Attributes

name: Optional[str]

first_name: Optional[str]

last_name: Optional[str]

email: Optional[str]

affiliation: Optional[str]

`provider`

Classes

`Provider`

Bases: BaseEntity

Attributes

codename: Optional[str]

Experiment & Equipment

Classes

Modules

`decon_vessel`

Classes

`DeconVessel`

Bases: LookupBase

Attributes

vessel_uuid: Optional[str]

serial_number: Optional[str]

volume_numeric_per_well: Optional[Decimal]

volume_unit: Optional[str]

`equipment`

Classes

`Equipment`

Bases: LookupBase

Attributes

equipment_location_id: Optional[int]

equipment_location: Optional[LocationAddress]

`experiment`

Classes

`Experiment`

Bases: BaseEntity

Attributes

name: Optional[str]

analyst_id: Optional[int]

exper_start_date: Optional[date]

exper_duration: Optional[Decimal]

exper_duration_unit_id: Optional[int]

exper_location_id: Optional[int]

description: Optional[str]

analyst: Optional[Contact]

exper_duration_unit: Optional[Unit]

exper_location: Optional[LocationAddress]

`experiment_links`

Classes

`ExperimentAnalysis`

Bases: SQLModel

Attributes

id: Optional[int]

experiment_id: Optional[int]

analysis_type_id: Optional[int]

experiment: Optional[Experiment]

analysis_type: Optional[AnalysisType]

`ExperimentEquipment`

Bases: SQLModel

Attributes

id: Optional[int]

experiment_id: Optional[int]

equipment_id: Optional[int]

experiment: Optional[Experiment]

equipment: Optional[Equipment]

`ExperimentMethod`

Bases: SQLModel

Attributes

id: Optional[int]

experiment_id: Optional[int]

method_id: Optional[int]

experiment: Optional[Experiment]

method: Optional[Method]

`ExperimentPreparedSample`

Bases: SQLModel

Attributes

id: Optional[int]

experiment_id: Optional[int]

prepared_sample_id: Optional[int]

experiment: Optional[Experiment]

prepared_sample: Optional[PreparedSample]

Methods, Parameters & Units

Classes

Modules

`method`

Classes

`Method`

Bases: BaseEntity

Attributes

name: Optional[str]

method_abbrev_id: Optional[int]

method_category_id: Optional[int]

method_standard_id: Optional[int]

description: Optional[str]

detection_limits: Optional[str]

source_id: Optional[int]

method_abbrev: Optional[MethodAbbrev]

method_category: Optional[MethodCategory]

method_standard: Optional[MethodStandard]

source: Optional[DataSource]

`parameter`

Classes

`ParameterCategoryParameter`

Bases: SQLModel

Attributes

id: Optional[int]

parameter_id: Optional[int]

parameter_category_id: Optional[int]

parameter: Optional[Parameter]

parameter_category: Optional[ParameterCategory]

`ParameterUnit`

Bases: SQLModel

Attributes

id: Optional[int]

parameter_id: Optional[int]

alternate_unit_id: Optional[int]

parameter: Optional[Parameter]

alternate_unit: Optional[Unit]

`Parameter`

Bases: BaseEntity

Attributes

name: Optional[str]

standard_unit_id: Optional[int]

calculated: Optional[bool]

description: Optional[str]

standard_unit: Optional[Unit]

`ParameterCategory`

Bases: LookupBase

`unit`

Classes

`Unit`

Bases: LookupBase

Core Metadata (ETL Lineage)

Classes

Modules

`etl_run`

Classes

`EtlRun`

Bases: SQLModel

Attributes

id: Optional[int]

run_id: Optional[str]

started_at: Optional[datetime]

completed_at: Optional[datetime]

pipeline_name: Optional[str]

status: Optional[str]

records_ingested: Optional[int]

note: Optional[str]

`lineage`

Classes

`LineageGroup`

Bases: SQLModel

Attributes

id: Optional[int]

etl_run_id: Optional[int]

note: Optional[str]

etl_run: Optional[EtlRun]

`EntityLineage`

Bases: SQLModel

Attributes

id: Optional[int]

lineage_group_id: Optional[int]

source_table: Optional[str]

source_row_id: Optional[str]

note: Optional[str]

Data Sources Metadata

Classes

Modules

`data_source`

Classes

`DataSource`

Bases: BaseEntity

Attributes

name: Optional[str]

description: Optional[str]

data_source_type_id: Optional[int]

full_title: Optional[str]

creator: Optional[str]

subject: Optional[str]

publisher: Optional[str]

contributor: Optional[str]

date: Optional[datetime]

type: Optional[str]

biocirv: Optional[bool]

format: Optional[str]

language: Optional[str]

relation: Optional[str]

temporal_coverage: Optional[str]

location_coverage_id: Optional[int]

rights: Optional[str]

license: Optional[str]

uri: Optional[str]

note: Optional[str]

data_source_type: Optional[DataSourceType]

location_coverage: Optional[LocationResolution]

`DataSourceType`

Bases: BaseEntity

Attributes

source_type_id: Optional[int]

source_type: Optional[SourceType]

`SourceType`

Bases: LookupBase

`file_object_metadata`

Classes

`FileObjectMetadata`

Bases: BaseEntity

Attributes

uri: Optional[str]

data_source_id: Optional[int]

bucket_path: Optional[str]

file_format: Optional[str]

file_size: Optional[int]

checksum_md5: Optional[str]

checksum_sha256: Optional[str]

data_source: Optional[DataSource]

`location_resolution`

Classes

`LocationResolution`

Bases: LookupBase

Sample Preparation

Classes

Modules

`preparation_method`

Classes

`PreparationMethod`

Bases: BaseEntity

Attributes

name: Optional[str]

description: Optional[str]

prep_method_abbrev_id: Optional[int]

prep_temp_c: Optional[Decimal]

uri: Optional[str]

drying_step: Optional[bool]

prep_method_abbrev: Optional[PreparationMethodAbbreviation]

`PreparationMethodAbbreviation`

Bases: LookupBase

`prepared_sample`

Classes

`PreparedSample`

Bases: BaseEntity

Attributes

name: Optional[str]

field_sample_id: Optional[int]

prep_method_id: Optional[int]

prep_date: Optional[date]

preparer_id: Optional[int]

note: Optional[str]

field_sample: Optional[FieldSample]

prep_method: Optional[PreparationMethod]

preparer: Optional[Contact]

Infrastructure

Classes

Modules

`biodiesel_plants`

Classes

`InfrastructureBiodieselPlants`

Bases: SQLModel

Biodiesel plants infrastructure.

Attributes

biodiesel_plant_id: Optional[int]

company: Optional[str]

bbi_index: Optional[int]

city: Optional[str]

state: Optional[str]

capacity_mmg_per_y: Optional[int]

feedstock: Optional[str]

status: Optional[str]

address: Optional[str]

coordinates: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

source: Optional[str]

`biosolids_facilities`

Classes

`InfrastructureBiosolidsFacilities`

Bases: SQLModel

Attributes

biosolid_facility_id: Optional[int]

report_submitted_date: Optional[date]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

facility: Optional[str]

authority: Optional[str]

plant_type: Optional[str]

aqmd: Optional[str]

facility_address: Optional[str]

facility_city: Optional[str]

state: Optional[str]

facility_zip: Optional[str]

facility_county: Optional[str]

mailing_street_1: Optional[str]

mailing_city: Optional[str]

mailing_state: Optional[str]

mailing_zip: Optional[str]

biosolids_number: Optional[str]

biosolids_contact: Optional[str]

biosolids_contact_phone: Optional[str]

biosolids_contact_email: Optional[str]

adwf: Optional[Decimal]

potw_biosolids_generated: Optional[int]

twtds_biosolids_treated: Optional[int]

class_b_land_app: Optional[int]

class_b_applier: Optional[str]

class_a_compost: Optional[int]

class_a_heat_dried: Optional[int]

class_a_other: Optional[int]

class_a_other_applier: Optional[str]

twtds_transfer_to_second_preparer: Optional[int]

twtds_second_preparer_name: Optional[str]

adc_or_final_c: Optional[int]

landfill: Optional[int]

landfill_name: Optional[str]

surface_disposal: Optional[int]

deepwell_injection: Optional[str]

stored: Optional[int]

longterm_treatment: Optional[int]

other: Optional[int]

name_of_other: Optional[str]

incineration: Optional[int]

`cafo_manure_locations`

Classes

`InfrastructureCafoManureLocations`

Bases: SQLModel

Attributes

cafo_manure_id: Optional[int]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

owner_name: Optional[str]

facility_name: Optional[str]

address: Optional[str]

town: Optional[str]

state: Optional[str]

zip: Optional[str]

animal: Optional[str]

animal_feed_operation_type: Optional[str]

animal_units: Optional[int]

animal_count: Optional[int]

manure_total_solids: Optional[Decimal]

source: Optional[str]

date_accessed: Optional[date]

`combustion_plants`

Classes

`InfrastructureCombustionPlants`

Bases: SQLModel

Attributes

combustion_fid: Optional[int]

objectid: Optional[int]

status: Optional[str]

city: Optional[str]

name: Optional[str]

county: Optional[str]

equivalent_generation: Optional[Decimal]

np_mw: Optional[Decimal]

cf: Optional[Decimal]

yearload: Optional[int]

fuel: Optional[str]

notes: Optional[str]

type: Optional[str]

wkt_geom: Optional[str]

geom: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

`district_energy_systems`

Classes

`InfrastructureDistrictEnergySystems`

Bases: SQLModel

Attributes

des_fid: Optional[int]

cbg_id: Optional[int]

name: Optional[str]

system: Optional[str]

object_id: Optional[int]

city: Optional[str]

state: Optional[str]

primary_fuel: Optional[str]

secondary_fuel: Optional[str]

usetype: Optional[str]

cap_st: Optional[Decimal]

cap_hw: Optional[Decimal]

cap_cw: Optional[Decimal]

chpcg_cap: Optional[Decimal]

excess_c: Optional[Decimal]

excess_h: Optional[Decimal]

type: Optional[str]

wkt_geom: Optional[str]

geom: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

`ethanol_biorefineries`

Classes

`InfrastructureEthanolBiorefineries`

Bases: SQLModel

Attributes

ethanol_biorefinery_id: Optional[int]

name: Optional[str]

city: Optional[str]

state: Optional[str]

address: Optional[str]

type: Optional[str]

capacity_mgy: Optional[int]

production_mgy: Optional[int]

constr_exp: Optional[int]

`facility_record`

Classes

`FacilityRecord`

Bases: BaseEntity

Attributes

dataset_id: Optional[int]

facility_name: Optional[str]

location_id: Optional[int]

capacity_mw: Optional[Decimal]

resource_id: Optional[int]

operator: Optional[str]

start_year: Optional[int]

note: Optional[str]

dataset: Optional[Dataset]

location: Optional[LocationAddress]

resource: Optional[Resource]

`food_processing_facilities`

Classes

`InfrastructureFoodProcessingFacilities`

Bases: SQLModel

Attributes

processing_facility_id: Optional[int]

address: Optional[str]

county: Optional[str]

city: Optional[str]

company: Optional[str]

join_count: Optional[int]

master_type: Optional[str]

state: Optional[str]

subtype: Optional[str]

target_fid: Optional[int]

processing_type: Optional[str]

zip: Optional[str]

type: Optional[str]

wkt_geom: Optional[str]

geom: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

`landfills`

Classes

`InfrastructureLandfills`

Bases: SQLModel

Attributes

project_id: Optional[str]

project_int_id: Optional[int]

ghgrp_id: Optional[str]

landfill_id: Optional[int]

landfill_name: Optional[str]

state: Optional[str]

physical_address: Optional[str]

city: Optional[str]

county: Optional[str]

zip_code: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

ownership_type: Optional[str]

landfill_owner_orgs: Optional[str]

landfill_opened_year: Optional[date]

landfill_closure_year: Optional[date]

landfill_status: Optional[str]

waste_in_place: Optional[int]

waste_in_place_year: Optional[date]

lfg_system_in_place: Optional[bool]

lfg_collected: Optional[Decimal]

lfg_flared: Optional[Decimal]

project_status: Optional[str]

project_name: Optional[str]

project_start_date: Optional[date]

project_shutdown_date: Optional[date]

project_type_category: Optional[str]

lfg_energy_project_type: Optional[str]

rng_delivery_method: Optional[str]

actual_mw_generation: Optional[Decimal]

rated_mw_capacity: Optional[Decimal]

lfg_flow_to_project: Optional[Decimal]

direct_emission_reductions: Optional[Decimal]

avoided_emission_reductions: Optional[Decimal]

`livestock_anaerobic_digesters`

Classes

`InfrastructureLivestockAnaerobicDigesters`

Bases: SQLModel

Attributes

digester_id: Optional[int]

project_name: Optional[str]

project_type: Optional[str]

city: Optional[str]

state: Optional[str]

digester_type: Optional[str]

profile: Optional[str]

year_operational: Optional[date]

animal_type_class: Optional[str]

animal_types: Optional[str]

pop_feeding_digester: Optional[str]

total_pop_feeding_digester: Optional[int]

cattle: Optional[int]

dairy: Optional[int]

poultry: Optional[int]

swine: Optional[int]

codigestion: Optional[str]

biogas_generation_estimate: Optional[int]

electricity_generated: Optional[int]

biogas_end_uses: Optional[str]

methane_emission_reductions: Optional[int]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

`msw_to_energy_anaerobic_digesters`

Classes

`InfrastructureMswToEnergyAnaerobicDigesters`

Bases: SQLModel

Attributes

wte_id: Optional[int]

city: Optional[str]

county: Optional[str]

equivalent_generation: Optional[Decimal]

feedstock: Optional[str]

dayload: Optional[Decimal]

dayload_bdt: Optional[Decimal]

facility_type: Optional[str]

status: Optional[str]

notes: Optional[str]

source: Optional[str]

type: Optional[str]

wkt_geom: Optional[str]

geom: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

`saf_and_renewable_diesel_plants`

Classes

`InfrastructureSafAndRenewableDieselPlants`

Bases: SQLModel

Attributes

ibcc_index: Optional[int]

company: Optional[str]

city: Optional[str]

state: Optional[str]

country: Optional[str]

capacity: Optional[str]

feedstock: Optional[str]

products: Optional[str]

status: Optional[str]

address: Optional[str]

coordinates: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

`wastewater_treatment_plants`

Classes

`InfrastructureWastewaterTreatmentPlants`

Bases: SQLModel

Attributes

plant_id: Optional[int]

name: Optional[str]

state: Optional[str]

codigestion: Optional[str]

flow_design_adjusted: Optional[Decimal]

flow_average: Optional[Decimal]

biosolids: Optional[Decimal]

excess_flow: Optional[Decimal]

biogas_utilized: Optional[bool]

flaring: Optional[bool]

excess_mass_loading_rate: Optional[Decimal]

excess_mass_loading_rate_wet: Optional[Decimal]

methane_production: Optional[Decimal]

energy_content: Optional[Decimal]

electric_kw: Optional[Decimal]

thermal_mmbtu_d: Optional[Decimal]

electric_kwh: Optional[Decimal]

thermal_annual_mmbtu_y: Optional[Decimal]

anaerobic_digestion_facility: Optional[str]

county: Optional[str]

dayload_bdt: Optional[Decimal]

dayload: Optional[Decimal]

equivalent_generation: Optional[Decimal]

facility_type: Optional[str]

feedstock: Optional[str]

type: Optional[str]

city: Optional[str]

latitude: Optional[Decimal]

longitude: Optional[Decimal]

zipcode: Optional[str]