Source code for eeweather.summaries
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
Copyright 2018 Open Energy Efficiency, Inc.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
"""
from .connections import metadata_db_connection_proxy
__all__ = ("get_zcta_ids", "get_isd_station_usaf_ids")
[docs]def get_zcta_ids(state=None):
""" Get ids of all supported ZCTAs, optionally by state.
Parameters
----------
state : str, optional
Select zipcodes only from this state or territory, given as 2-letter
abbreviation (e.g., ``'CA'``, ``'PR'``).
Returns
-------
results : list of str
List of all supported selected ZCTA IDs.
"""
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
if state is None:
cur.execute(
"""
select zcta_id from zcta_metadata
"""
)
else:
cur.execute(
"""
select zcta_id from zcta_metadata where state = ?
""",
(state,),
)
return [row[0] for row in cur.fetchall()]
[docs]def get_isd_station_usaf_ids(state=None):
""" Get USAF IDs of all supported ISD stations, optionally by state.
Parameters
----------
state : str, optional
Select ISD station USAF IDs only from this state or territory, given
as 2-letter abbreviation (e.g., ``'CA'``, ``'PR'``).
Returns
-------
results : list of str
List of all supported selected ISD station USAF IDs.
"""
conn = metadata_db_connection_proxy.get_connection()
cur = conn.cursor()
if state is None:
cur.execute(
"""
select usaf_id from isd_station_metadata
"""
)
else:
cur.execute(
"""
select usaf_id from isd_station_metadata where state = ?
""",
(state,),
)
return [row[0] for row in cur.fetchall()]