mss_Temperature

tables.auto_generated.mss_Temperature

Classes

Name Description
mss_TemperatureTable Table for mss_Temperature (Climatology).
mss_TemperatureTableColumns Column names for mss_Temperature (Climatology).

mss_TemperatureTable

tables.auto_generated.mss_Temperature.mss_TemperatureTable(net_table)

Table for mss_Temperature (Climatology).

Attributes

Name Description
columns Get the columns for the table.
description Get the table description.
display_name Get the display name for the table.
name Get the table name.

Methods

Name Description
delete Create a DELETE query for this table.
get_muids Get a list of MUIDs for the table.
insert Insert a row with the given values.
select Create a SELECT query for this table.
update Create an UPDATE query for this table.
delete
tables.auto_generated.mss_Temperature.mss_TemperatureTable.delete()

Create a DELETE query for this table.

Returns
Name Type Description
DeleteQuery A new DeleteQuery object
get_muids
tables.auto_generated.mss_Temperature.mss_TemperatureTable.get_muids(
    order_by=None,
    descending=False,
)

Get a list of MUIDs for the table.

Parameters
Name Type Description Default
order_by str or None Column to order the MUIDs by None
descending bool Whether to order in descending order False
Returns
Name Type Description
list of str A list of MUIDs
insert
tables.auto_generated.mss_Temperature.mss_TemperatureTable.insert(
    values,
    execute=True,
)

Insert a row with the given values.

Parameters
Name Type Description Default
values dict of str to Any Column-value pairs to insert required
execute bool Whether to execute the query immediately (default: True) True
Returns
Name Type Description
str or InsertQuery If execute is True, returns the ID of the newly inserted row (MUID) If execute is False, returns an InsertQuery instance
select
tables.auto_generated.mss_Temperature.mss_TemperatureTable.select(columns=[])

Create a SELECT query for this table.

Parameters
Name Type Description Default
columns list of str The columns to select []
Returns
Name Type Description
SelectQuery A new SelectQuery object
update
tables.auto_generated.mss_Temperature.mss_TemperatureTable.update(values)

Create an UPDATE query for this table.

Parameters
Name Type Description Default
values dict of str to Any Column-value pairs to set in the UPDATE required
Returns
Name Type Description
UpdateQuery A new UpdateQuery object

mss_TemperatureTableColumns

tables.auto_generated.mss_Temperature.mss_TemperatureTableColumns(table)

Column names for mss_Temperature (Climatology).

Attributes

Name Description
ADCNo ADC type
AdcImPerv0 AdcImPerv0
AdcImPerv1 AdcImPerv1
AdcImPerv2 AdcImPerv2
AdcImPerv3 AdcImPerv3
AdcImPerv4 AdcImPerv4
AdcImPerv5 AdcImPerv5
AdcImPerv6 AdcImPerv6
AdcImPerv7 AdcImPerv7
AdcImPerv8 AdcImPerv8
AdcImPerv9 AdcImPerv9
AdcPerv0 AdcPerv0
AdcPerv1 AdcPerv1
AdcPerv2 AdcPerv2
AdcPerv3 AdcPerv3
AdcPerv4 AdcPerv4
AdcPerv5 AdcPerv5
AdcPerv6 AdcPerv6
AdcPerv7 AdcPerv7
AdcPerv8 AdcPerv8
AdcPerv9 AdcPerv9
Atiwt ATI weight
Dtlong Longitude correction [min]
Elev Elevation above MSL [m]
FileName Climatological file (NCDC)
Lat Latitude [degN50]
MUID ID
Rnm Negative melt ratio
SnowTemp Dividing temperature between snow and rain [deg C]
StartDate Start reading file at
StartNo Start reading file at
TimeSeriesID Time series ID
TypeNo Type
Value1 Speed in Jan [km/h]
Value10 Speed in Oct [km/h]
Value11 Speed in Nov [km/h]
Value12 Speed in Dec [km/h]
Value2 Speed in Feb [km/h]
Value3 Speed in Mar [km/h]
Value4 Speed in Apr [km/h]
Value5 Speed in May [km/h]
Value6 Speed in June [km/h]
Value7 Speed in July [km/h]
Value8 Speed in Aug [km/h]
Value9 Speed in Sep [km/h]
WindSpeedTypeNo Wind speed type