models.txt

# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey has `on_delete` set to the desired behavior.
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from __future__ import unicode_literals

from django.contrib.gis.db import models


class Agency(models.Model):
    agency_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=34)
    statecode = models.CharField(max_length=4)

    class Meta:
        managed = False
        db_table = 'agency'


class Alarmlevel(models.Model):
    alarmlevel_id = models.IntegerField(primary_key=True)
    description = models.IntegerField()
    id_911 = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'alarmlevel'


class AuthGroup(models.Model):
    name = models.CharField(unique=True, max_length=80)

    class Meta:
        managed = False
        db_table = 'auth_group'


class AuthGroupPermissions(models.Model):
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)
    permission = models.ForeignKey('AuthPermission', models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_group_permissions'
        unique_together = (('group', 'permission'),)


class AuthPermission(models.Model):
    name = models.CharField(max_length=255)
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)
    codename = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'auth_permission'
        unique_together = (('content_type', 'codename'),)


class AuthUser(models.Model):
    password = models.CharField(max_length=128)
    last_login = models.DateTimeField(blank=True, null=True)
    is_superuser = models.BooleanField()
    username = models.CharField(unique=True, max_length=150)
    first_name = models.CharField(max_length=30)
    last_name = models.CharField(max_length=30)
    email = models.CharField(max_length=254)
    is_staff = models.BooleanField()
    is_active = models.BooleanField()
    date_joined = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'auth_user'


class AuthUserGroups(models.Model):
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    group = models.ForeignKey(AuthGroup, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_groups'
        unique_together = (('user', 'group'),)


class AuthUserUserPermissions(models.Model):
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)
    permission = models.ForeignKey(AuthPermission, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'auth_user_user_permissions'
        unique_together = (('user', 'permission'),)


class Ceblocks(models.Model):
    gid = models.AutoField(primary_key=True)
    statefp = models.CharField(max_length=2, blank=True, null=True)
    countyfp = models.CharField(max_length=3, blank=True, null=True)
    tractce = models.CharField(max_length=6, blank=True, null=True)
    blkgrpce = models.CharField(max_length=1, blank=True, null=True)
    geoid = models.CharField(max_length=12, blank=True, null=True)
    namelsad = models.CharField(max_length=13, blank=True, null=True)
    mtfcc = models.CharField(max_length=5, blank=True, null=True)
    funcstat = models.CharField(max_length=1, blank=True, null=True)
    aland = models.FloatField(blank=True, null=True)
    awater = models.FloatField(blank=True, null=True)
    intptlat = models.CharField(max_length=11, blank=True, null=True)
    intptlon = models.CharField(max_length=12, blank=True, null=True)
    geom = models.MultiPolygonField(srid=4269, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'ceblocks'


class CensusEducationalAttainment(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    total = models.IntegerField()
    no_school_completed = models.IntegerField()
    nursery_school = models.IntegerField()
    kindergarten = models.IntegerField()
    first_grade = models.IntegerField()
    second_grade = models.IntegerField()
    third_grade = models.IntegerField()
    fourth_grade = models.IntegerField()
    fifth_grade = models.IntegerField()
    sixth_grade = models.IntegerField()
    seventh_grade = models.IntegerField()
    eighth_grade = models.IntegerField()
    ninth_grade = models.IntegerField()
    tenth_grade = models.IntegerField()
    eleventh_grade = models.IntegerField()
    twelvth_grade_no_diploma = models.IntegerField()
    regular_hs_diploma = models.IntegerField()
    ged_or_alternative = models.IntegerField()
    some_college_less_than_year = models.IntegerField()
    some_college_more_than_year = models.IntegerField()
    associate_degree = models.IntegerField()
    bachelor_degree = models.IntegerField()
    master_degree = models.IntegerField()
    professional_school_degree = models.IntegerField()
    doctorate_degree = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_educational_attainment'


class CensusFoodStamps(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    total = models.IntegerField()
    hh_rec_fs = models.IntegerField()
    hh_rec_fs_omo_w_disability = models.IntegerField()
    hh_rec_fs_no_disability = models.IntegerField()
    hh_dn_rec_fs = models.IntegerField()
    hh_dn_rec_fs_omo_w_disability = models.IntegerField()
    hh_dn_rec_fs_no_disability = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_food_stamps'


class CensusGeographicalMobility(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    total = models.IntegerField()
    same_house_one_yr = models.IntegerField()
    diff_house_us_one_yr = models.IntegerField()
    diff_house_us_one_yr_same_metro = models.IntegerField()
    diff_house_us_one_yr_same_metro_moved_fr_principal_city = models.IntegerField()
    diff_house_us_one_yr_same_metro_moved_fr_rem_metro = models.IntegerField()
    diff_house_us_one_yr_diff_metro_field = models.IntegerField(db_column='diff_house_us_one_yr_diff_metro_')  # Field renamed because it ended with '_'.
    diff_house_us_one_yr_diff_metro_moved_fr_principal_city = models.IntegerField()
    diff_house_us_one_yr_diff_metro_moved_fr_rem_metro = models.IntegerField()
    diff_house_us_one_yr_micro_field = models.IntegerField(db_column='diff_house_us_one_yr_micro_')  # Field renamed because it ended with '_'.
    diff_house_us_one_yr_micro_moved_fr_principal_city = models.IntegerField()
    diff_house_us_one_yr_micro_moved_fr_rem_micro = models.IntegerField()
    diff_house_us_one_yr_not_metro_micro = models.IntegerField()
    abroad_one_yr = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_geographical_mobility'


class CensusHealthInsurance(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    with_health_insurance = models.IntegerField()
    no_health_insurance = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_health_insurance'


class CensusHouseholdIncome(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    estimate_total = models.IntegerField()
    total_less_than_10000 = models.IntegerField()
    total_10000_to_14999 = models.IntegerField()
    total_15000_to_19999 = models.IntegerField()
    total_20000_to_24999 = models.IntegerField()
    total_25000_to_29999 = models.IntegerField()
    total_30000_to_34999 = models.IntegerField()
    total_35000_to_39999 = models.IntegerField()
    total_40000_to_44999 = models.IntegerField()
    total_45000_to_49999 = models.IntegerField()
    total_50000_to_59999 = models.IntegerField()
    total_60000_to_74999 = models.IntegerField()
    total_75000_to_99999 = models.IntegerField()
    total_100000_to_124999 = models.IntegerField()
    total_125000_to_149999 = models.IntegerField()
    total_150000_to_199999 = models.IntegerField()
    total_200000_or_more = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_household_income'


class CensusHouseholdLanguage(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    estimate_total = models.IntegerField()
    english_only = models.IntegerField()
    spanish_total = models.IntegerField()
    spanish_lesh = models.IntegerField()
    spanish_notlesh = models.IntegerField()
    other_indo_euro_total = models.IntegerField()
    other_indo_euro_lesh = models.IntegerField()
    other_indo_euro_notlesh = models.IntegerField()
    asian_pacific_island_total = models.IntegerField()
    asian_pacific_island_lesh = models.IntegerField()
    asian_pacific_island_notlesh = models.IntegerField()
    other_total = models.IntegerField()
    other_lesh = models.IntegerField()
    other_notlesh = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_household_language'


class CensusHouseholds65Plus(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    totals = models.IntegerField()
    oneplus_people_65plus = models.IntegerField()
    one_or_more_people_65plus_1_person = models.IntegerField()
    oneplus_people_65plus_2plus_person = models.IntegerField()
    oneplus_people_65plus_2plus_person_family = models.IntegerField()
    oneplus_people_65plus_2plus_person_nonfamily = models.IntegerField()
    no_people_65plus = models.IntegerField()
    no_people_65plus_1_person = models.IntegerField()
    no_people_65plus_2plus_person = models.IntegerField()
    no_people_65plus_2plus_person_family = models.IntegerField()
    no_people_65plus_2plus_person_nonfamily = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_households_65plus'


class CensusHousingTenure(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    estimate_total_households = models.IntegerField()
    estimate_total_owner_occupied = models.IntegerField()
    estimate_total_renter_occupied = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_housing_tenure'


class CensusMedianHouseholdIncome(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    estimate_median_household_income = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_median_household_income'


class CensusPovertyStatusIndividuals(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    estimate_total = models.IntegerField()
    total_below = models.IntegerField()
    total_above = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_poverty_status_individuals'


class CensusRace(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    total = models.IntegerField()
    white_alone = models.IntegerField()
    black_alone = models.IntegerField()
    american_indian_alaska_native_alone = models.IntegerField()
    asian_alone = models.IntegerField()
    native_hawaiian_pacific_islander_alone = models.IntegerField()
    some_other_alone = models.IntegerField()
    two_or_more_races = models.IntegerField()
    two_or_more_some_other = models.IntegerField()
    two_or_more_excluding_some_other_three_or_more_races = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_race'


class CensusTotalPopulation(models.Model):
    id = models.CharField(max_length=21)
    id2 = models.CharField(max_length=12)
    geography = models.CharField(max_length=60)
    estimate_total = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'census_total_population'


class DjangoAdminLog(models.Model):
    action_time = models.DateTimeField()
    object_id = models.TextField(blank=True, null=True)
    object_repr = models.CharField(max_length=200)
    action_flag = models.SmallIntegerField()
    change_message = models.TextField()
    content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True)
    user = models.ForeignKey(AuthUser, models.DO_NOTHING)

    class Meta:
        managed = False
        db_table = 'django_admin_log'


class DjangoContentType(models.Model):
    app_label = models.CharField(max_length=100)
    model = models.CharField(max_length=100)

    class Meta:
        managed = False
        db_table = 'django_content_type'
        unique_together = (('app_label', 'model'),)


class DjangoMigrations(models.Model):
    app = models.CharField(max_length=255)
    name = models.CharField(max_length=255)
    applied = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_migrations'


class DjangoSession(models.Model):
    session_key = models.CharField(primary_key=True, max_length=40)
    session_data = models.TextField()
    expire_date = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'django_session'


class Fblocks(models.Model):
    gid = models.AutoField(primary_key=True)
    objectid_1 = models.DecimalField(max_digits=10, decimal_places=0, blank=True, null=True)
    objectid = models.DecimalField(max_digits=10, decimal_places=0, blank=True, null=True)
    fma = models.CharField(max_length=2, blank=True, null=True)
    resp_zone = models.CharField(max_length=6, blank=True, null=True)
    jurisdict = models.CharField(max_length=2, blank=True, null=True)
    dist_grp = models.CharField(max_length=2, blank=True, null=True)
    notes = models.CharField(max_length=60, blank=True, null=True)
    of_fma = models.CharField(max_length=26, blank=True, null=True)
    mv_label = models.CharField(max_length=15, blank=True, null=True)
    shape_star = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True)
    shape_stle = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True)
    shape_leng = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True)
    shape_area = models.DecimalField(max_digits=65535, decimal_places=65535, blank=True, null=True)
    geom = models.MultiPolygonField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fblocks'


class FcbProportion(models.Model):
    c_block = models.CharField(max_length=12, blank=True, null=True)
    fire_block = models.DecimalField(max_digits=10, decimal_places=0, blank=True, null=True)
    overlap_cbg = models.FloatField(blank=True, null=True)
    overlap_fb = models.FloatField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fcb_proportion'


class FmaApiRollup(models.Model):
    fma = models.IntegerField(primary_key=True)
    fma_population_total = models.IntegerField(blank=True, null=True)
    percent_owner_occ_hh = models.FloatField(blank=True, null=True)
    percent_renter_occ_hh = models.FloatField(blank=True, null=True)
    median_hh_income = models.IntegerField(blank=True, null=True)
    percent_w_hinsurance = models.FloatField(blank=True, null=True)
    percent_wo_hinsurance = models.FloatField(blank=True, null=True)
    percent_college_grad_or_higher = models.FloatField(blank=True, null=True)
    percent_rec_fs = models.FloatField(blank=True, null=True)
    percent_total_lesh = models.FloatField(blank=True, null=True)
    percent_non_white = models.FloatField(blank=True, null=True)
    percent_below_pov = models.FloatField(blank=True, null=True)
    percent_member_65plus = models.FloatField(blank=True, null=True)
    percent_diff_area = models.FloatField(blank=True, null=True)
    median_response_time = models.FloatField(blank=True, null=True)
    ave_weekly_incidents = models.FloatField(blank=True, null=True)
    fma_area_mi = models.FloatField(blank=True, null=True)
    num_incidents_med = models.IntegerField(blank=True, null=True)
    incidents_sqmi_med = models.IntegerField(blank=True, null=True)
    num_incidents_fire = models.IntegerField(blank=True, null=True)
    incidents_sqmi_fire = models.IntegerField(blank=True, null=True)
    fma_population_density = models.FloatField(blank=True, null=True)
    fire_incidents_2016 = models.IntegerField(blank=True, null=True)
    medical_incidents_2016 = models.IntegerField(blank=True, null=True)
    total_incidents_2016 = models.IntegerField(blank=True, null=True)
    fire_incidents_per_1000 = models.FloatField(blank=True, null=True)
    medical_incidents_per_1000 = models.FloatField(blank=True, null=True)
    total_incidents_per_1000 = models.FloatField(blank=True, null=True)
    weekly_total_incs = models.FloatField(blank=True, null=True)
    weekly_med_incs = models.FloatField(blank=True, null=True)
    weekly_fire_incs = models.FloatField(blank=True, null=True)
    median_resp_time_med = models.FloatField(blank=True, null=True)
    median_resp_time_fire = models.FloatField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fma_api_rollup'
# Unable to inspect table 'fma_med_resp_time'
# The error was: permission denied for relation fma_med_resp_time



class FmaShapes(models.Model):
    fma = models.IntegerField(blank=True, null=True)
    geom = models.GeometryField(srid=0, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fma_shapes'


class FmacProportion(models.Model):
    c_block = models.CharField(max_length=12, blank=True, null=True)
    fma = models.IntegerField(blank=True, null=True)
    overlap_cbg = models.FloatField(blank=True, null=True)
    overlap_fma = models.FloatField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fmac_proportion'


class Incident(models.Model):
    incident_id = models.IntegerField(primary_key=True)
    responderunit_id = models.IntegerField(blank=True, null=True)
    deptrespond_id = models.IntegerField(blank=True, null=True)
    runnumber = models.CharField(max_length=20, blank=True, null=True)
    incdate = models.DateField(blank=True, null=True)
    typenaturecode = models.ForeignKey('Typenaturecode', models.DO_NOTHING, blank=True, null=True)
    foundsituation = models.IntegerField(blank=True, null=True)
    incsitfoundprm = models.ForeignKey('Incsitfound', models.DO_NOTHING, blank=True, null=True)
    alarmlevel = models.ForeignKey(Alarmlevel, models.DO_NOTHING, blank=True, null=True)
    mutualaid = models.ForeignKey('Mutualaid', models.DO_NOTHING, blank=True, null=True)
    callreceived_id = models.IntegerField(blank=True, null=True)
    censustract = models.CharField(max_length=6, blank=True, null=True)
    fmarespcomp = models.CharField(max_length=10, blank=True, null=True)
    career = models.IntegerField(blank=True, null=True)
    engresp = models.IntegerField(blank=True, null=True)
    aaresp = models.IntegerField(blank=True, null=True)
    medresp = models.IntegerField(blank=True, null=True)
    othervehiclesresp = models.IntegerField(blank=True, null=True)
    firstonscene = models.CharField(max_length=10, blank=True, null=True)
    quad = models.CharField(max_length=2, blank=True, null=True)
    streettype = models.CharField(max_length=4, blank=True, null=True)
    streetname = models.CharField(max_length=30, blank=True, null=True)
    quad2 = models.CharField(max_length=4, blank=True, null=True)
    streetname2 = models.CharField(max_length=30, blank=True, null=True)
    streettype2 = models.CharField(max_length=4, blank=True, null=True)
    city = models.CharField(max_length=20, blank=True, null=True)
    state = models.CharField(max_length=2, blank=True, null=True)
    zip = models.CharField(max_length=10, blank=True, null=True)
    neighborassoc = models.CharField(max_length=20, blank=True, null=True)
    fireblock = models.CharField(max_length=10, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'incident'
# Unable to inspect table 'incidents_per1000_fma'
# The error was: permission denied for relation incidents_per1000_fma

# Unable to inspect table 'incidents_persqmi_fma'
# The error was: permission denied for relation incidents_persqmi_fma



class Incsitfound(models.Model):
    incsitfound_id = models.IntegerField(primary_key=True)
    incsitfoundsub = models.ForeignKey('Incsitfoundsub', models.DO_NOTHING, blank=True, null=True)
    description = models.CharField(max_length=50, blank=True, null=True)
    statecode = models.IntegerField(blank=True, null=True)
    sortorder = models.IntegerField(blank=True, null=True)
    inactive = models.IntegerField(blank=True, null=True)
    nfirs = models.CharField(max_length=3, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'incsitfound'


class Incsitfoundclass(models.Model):
    incsitfoundclass_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=42)
    sortorder = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'incsitfoundclass'


class Incsitfoundsub(models.Model):
    incsitfoundsub_id = models.IntegerField(primary_key=True)
    incsitfoundclass = models.ForeignKey(Incsitfoundclass, models.DO_NOTHING, blank=True, null=True)
    description = models.CharField(max_length=50, blank=True, null=True)
    sortorder = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'incsitfoundsub'


class Inctimes(models.Model):
    inctimes_id = models.IntegerField(primary_key=True)
    timedesc = models.ForeignKey('Timedesc', models.DO_NOTHING, blank=True, null=True)
    incident = models.ForeignKey('Responder', models.DO_NOTHING, blank=True, null=True)
    responder_id = models.IntegerField(blank=True, null=True)
    realtime = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'inctimes'


class Mutualaid(models.Model):
    mutualaid_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=19, blank=True, null=True)
    inactive = models.CharField(max_length=32, blank=True, null=True)
    nfirs = models.CharField(max_length=1, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'mutualaid'


class OrHolidays(models.Model):
    date = models.DateField()
    holiday = models.CharField(max_length=27)

    class Meta:
        managed = False
        db_table = 'or_holidays'


class Responder(models.Model):
    incident_id = models.IntegerField()
    responder_id = models.IntegerField()
    responderunit = models.ForeignKey('Responderunit', models.DO_NOTHING, blank=True, null=True)
    codetosc = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'responder'
        unique_together = (('incident_id', 'responder_id'),)


class Responderunit(models.Model):
    responderunit_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=6, blank=True, null=True)
    id_911 = models.CharField(max_length=6, blank=True, null=True)
    station = models.ForeignKey('Station', models.DO_NOTHING, blank=True, null=True)
    translateto = models.CharField(max_length=4, blank=True, null=True)
    agency = models.ForeignKey(Agency, models.DO_NOTHING, blank=True, null=True)
    process = models.IntegerField(blank=True, null=True)
    versaterm = models.CharField(max_length=6, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'responderunit'


class Situationfound(models.Model):
    situationfound_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=50, blank=True, null=True)
    review = models.IntegerField(blank=True, null=True)
    inactive = models.IntegerField(blank=True, null=True)
    nemsis = models.IntegerField(blank=True, null=True)
    e09_15 = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'situationfound'


class Station(models.Model):
    station_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=50, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'station'


class Timedesc(models.Model):
    timedesc_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=50, blank=True, null=True)
    id_911 = models.CharField(max_length=6, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'timedesc'


class Tl201641Bg(models.Model):
    gid = models.AutoField(primary_key=True)
    statefp = models.CharField(max_length=2, blank=True, null=True)
    countyfp = models.CharField(max_length=3, blank=True, null=True)
    tractce = models.CharField(max_length=6, blank=True, null=True)
    blkgrpce = models.CharField(max_length=1, blank=True, null=True)
    geoid = models.CharField(max_length=12, blank=True, null=True)
    namelsad = models.CharField(max_length=13, blank=True, null=True)
    mtfcc = models.CharField(max_length=5, blank=True, null=True)
    funcstat = models.CharField(max_length=1, blank=True, null=True)
    aland = models.FloatField(blank=True, null=True)
    awater = models.FloatField(blank=True, null=True)
    intptlat = models.CharField(max_length=11, blank=True, null=True)
    intptlon = models.CharField(max_length=12, blank=True, null=True)
    geom = models.MultiPolygonField(srid=0, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tl_2016_41_bg'


class Typenaturecode(models.Model):
    typenaturecode_id = models.IntegerField(primary_key=True)
    description = models.CharField(max_length=50, blank=True, null=True)
    id_911 = models.CharField(max_length=15, blank=True, null=True)
    category = models.IntegerField(blank=True, null=True)
    nemsis = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'typenaturecode'