Skip to content

Datamodels API Reference

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

How to use this page

This page documents every SQLModel class — their fields, types, and inheritance — rendered directly from source-code docstrings.

Who this is for: developers who need to understand how the database schema is organized, what fields a model contains, or how models relate to each other when writing custom queries, extending existing models, or debugging data issues.

This is not the HTTP REST API reference. For endpoint usage (parameters, request bodies, response schemas), see the Webservice API page or the interactive Swagger UI at http://localhost:8000/docs while the service is running.

Contents

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]

resource_end_use_record

Classes

ResourceEndUseRecord

Bases: BaseEntity

Attributes
dataset_id: int
method_id: int
geoid: Optional[str]
resource_id: Optional[int]
note: Optional[str]

resource_price_record

Resource Price Record model for PR f989683 integration.

Classes

ResourcePriceRecord

Bases: BaseEntity

Market price observation record for a resource.

Attributes
dataset_id: int
method_id: Optional[int]
geoid: Optional[str]
resource_id: Optional[int]
primary_ag_product_id: Optional[int]
source_id: int
report_start_date: date
report_end_date: date
freight_terms: Optional[str]
transport_mode: Optional[str]
note: Optional[str]

resource_production_record

Classes

ResourceProductionRecord

Bases: BaseEntity

Attributes
dataset_id: int
method_id: Optional[int]
geoid: Optional[str]
primary_ag_product_id: Optional[int]
resource_id: Optional[int]
report_date: date
scenario: Optional[str]
note: Optional[str]

resource_storage_record

Classes

ResourceStorageRecord

Bases: BaseEntity

Attributes
dataset_id: int
method_id: int
geoid: Optional[str]
storage_description: str
resource_id: Optional[int]
note: Optional[str]

resource_transport_record

Classes

ResourceTransportRecord

Bases: BaseEntity

Attributes
dataset_id: int
method_id: int
geoid: Optional[str]
transport_description: str
resource_id: Optional[int]
note: Optional[str]

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]
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]
MethodAbbrev

Bases: LookupBase

MethodCategory

Bases: LookupBase

MethodStandard

Bases: LookupBase

method_assumption

Classes

MethodAssumption

Bases: SQLModel

Attributes
id: Optional[int]
method_id: int
technical_assumption_id: int

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

technical_assumption

Classes

TechnicalAssumption

Bases: BaseEntity

Attributes
assumption_name: str
assumption_value: Decimal
unit_id: Optional[int]
source_id: Optional[int]
note: Optional[str]

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]