File: //home/arjun/projects/env/lib64/python3.10/site-packages/uszipcode/__pycache__/model.cpython-38.pyc
U
��a� � @ s� d dl Z d dlZd dlZd dlmZ d dlmZ d dlZd dl m
Z
d dl Z ddl
mZ d dlmZmZ e
�� ZG dd� dej�ZeG d d
� d
ee j��ZG d d � d e�ZG d
d� de�ZG dd� de�ZdS )� N)�total_ordering)�Path� )� MAPPER_STATE_ABBR_SHORT_TO_LONG)� haversine�Unitc @ s e Zd ZdZdZdZdZdZdS )�ZipcodeTypeEnumz%
zipcode type visitor class.
ZSTANDARDzPO BOXZUNIQUEZMILITARYN)�__name__�
__module__� __qualname__�__doc__�StandardZPO_BoxZUniqueZMilitary� r r �D/Users/sanhehu/Documents/GitHub/uszipcode-project/uszipcode/model.pyr s
r c @ s� e Zd ZdZdZejejdd�Ze�ej�Z e�ej�Z
e�ej�Z e�e j
j�Ze�ej�Ze�ej�Zejejdd�Zejejdd�Ze�ej�Ze�ej�Ze�e j
j�Ze�ej�Ze�ej�Ze�ej�Ze�ej�Z e�ej�Z e�ej�Z e�ej�Z e�ej�Z e�ej�Z!e�ej�Z"e�ej�Z#e�ej�Z$d�%d�Z&e'dd� �Z(e'e)d �d
d ��Z*e'e+d �d d
��Z,e'e+d �dd��Z-dd� Z.d d�dd�Z/d d�dd�Z0dd� Z1e2j3fe4e4e2d�dd�Z5d e6d �d d �Z7d S )!�AbstractSimpleZipcodez!
Base class for Zipcode.
T)� primary_key)�indexz7zipcode,zipcode_type,city,county,state,lat,lng,timezone�,c C s | j S )z+
Alias of ``.major_city``.
)�
major_city��selfr r r �cityG s zAbstractSimpleZipcode.city)�returnc C s | j | j| j| jd�S )z"
Border boundary.
)ZwestZeastZnorthZsouth)� bounds_west� bounds_east� bounds_north� bounds_southr r r r �boundsN s
�z AbstractSimpleZipcode.boundsc C s
| j �� S )zH
Return state abbreviation, two letters, all uppercase.
)�state�upperr r r r �
state_abbrZ s z AbstractSimpleZipcode.state_abbrc C s t �| j�� �S )z)
Return state full name.
)r �getr r r r r r �
state_longa s z AbstractSimpleZipcode.state_longc C s
| j dk S )z,
For Python3 bool() method.
N��zipcoder r r r �__bool__h s z AbstractSimpleZipcode.__bool__)�otherc C s. | j dks|j dkr td��n | j |j k S dS )z0
For ``>`` comparison operator.
Nz2Empty Zipcode instance doesn't support comparison.)r$ �
ValueError�r r& r r r �__lt__n s
�z AbstractSimpleZipcode.__lt__c C s | j |j kS )z1
For ``==`` comparison operator.
r# r( r r r �__eq__x s z AbstractSimpleZipcode.__eq__c C s
t | j�S )z#
For hash() method
)�hashr$ r r r r �__hash__~ s z AbstractSimpleZipcode.__hash__)�lat�lng�unitc C s t | j| jf||f|d�S )z�
Calculate the distance of the center of this zipcode from a coordinator.
:param lat: latitude.
:param lng: longitude.
)r/ )r r- r. )r r- r. r/ r r r � dist_from� s z AbstractSimpleZipcode.dist_from�� include_nullc C s | j |d�}tj|dd�S )z"
Convert to json.
r1 � )�indent)�to_OrderedDict�json�dumps)r r2 �datar r r �to_json� s z AbstractSimpleZipcode.to_jsonN)T)8r r
r r � __abstract__�sa�Column�Stringr$ � zipcode_typer Zpost_office_city�sam�types�CompressedJSONTypeZcommon_city_listZcountyr �Floatr- r. �timezoneZradius_in_milesZarea_code_list�Integer�
population�population_density�land_area_in_sqmi�water_area_in_sqmi�
housing_units�occupied_housing_units�median_home_value�median_household_incomer r r r �split�_settings_major_attrs�propertyr �dictr �strr r" r% r) r* r, r ZMILES�floatr0 �boolr9 r r r r r sV �
r c @ s� e Zd ZdZe�ejj�Z e�ejj�Z
e�ejj�Z e�ejj�Z e�ejj�Z
e�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Ze�ejj�Z e�ejj�Z e�ejj�Z e�ejj�Z e�ejj�Z e�ejj�Z!e�ejj�Z"e�ejj�Z#e�ejj�Z$e�ejj�Z%e�ejj�Z&e�ejj�Z'e�ejj�Z(e�ejj�Z)e�ejj�Z*dS )� AbstractComprehensiveZipcodeTN)+r r
r r: r; r< r? r@ rA ZpolygonZpopulation_by_yearZpopulation_by_ageZpopulation_by_genderZpopulation_by_raceZhead_of_household_by_ageZfamilies_vs_singlesZhouseholds_with_kidsZchildren_by_ageZ housing_typeZyear_housing_was_builtZhousing_occupancyZvacancy_reasonZowner_occupied_home_valuesZ$rental_properties_by_number_of_roomsZ+monthly_rent_including_utilities_studio_aptZ$monthly_rent_including_utilities_1_bZ$monthly_rent_including_utilities_2_bZ(monthly_rent_including_utilities_3plus_bZemployment_statusZ"average_household_income_over_timeZhousehold_incomeZannual_individual_earningsZEsources_of_household_income____percent_of_households_receiving_incomeZLsources_of_household_income____average_income_per_household_by_income_sourceZPhousehold_investment_income____percent_of_households_receiving_investment_incomeZLhousehold_investment_income____average_income_per_household_by_income_sourceZOhousehold_retirement_income____percent_of_households_receiving_retirement_incomZLhousehold_retirement_income____average_income_per_household_by_income_sourceZsource_of_earningsZ7means_of_transportation_to_work_for_workers_16_and_overZ travel_time_to_work_in_minutesZ1educational_attainment_for_population_25_and_overZ school_enrollment_age_3_to_17r r r r rT � sf ��������rT c @ s e Zd ZdZdS )�
SimpleZipcodeZsimple_zipcodeN�r r
r �
__tablename__r r r r rU � s rU c @ s e Zd ZdZdS )�ComprehensiveZipcodeZcomprehensive_zipcodeNrV r r r r rX � s rX )r6 �enum�typing� functoolsr � pathlib_mater �
sqlalchemyr; �sqlalchemy.orm�orm�sqlalchemy_mater? r r r r �declarative_base�Base�Enumr � ExtendedBaser rT rU rX r r r r �<module> s
w<