# -*- coding: utf-8 -*-
# Generated by Django 1.11.1 on 2017-07-12 07:30
from __future__ import unicode_literals

import django.contrib.gis.db.models.fields
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='avoided_c',
            fields=[
                ('avoided_c_id', models.AutoField(primary_key=True, serialize=False)),
                ('feat_id', models.IntegerField()),
                ('mgmt_unit', models.CharField(max_length=25)),
                ('yr_establi', models.IntegerField()),
                ('acres', models.FloatField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
        ),
        migrations.CreateModel(
            name='food_plots',
            fields=[
                ('food_plot_id', models.AutoField(primary_key=True, serialize=False)),
                ('objectid', models.IntegerField()),
                ('shape_leng', models.FloatField()),
                ('shape_area', models.FloatField()),
                ('area', models.CharField(max_length=50)),
                ('plot_numbe', models.IntegerField()),
                ('acres', models.FloatField()),
                ('crop_2014', models.CharField(max_length=50)),
                ('crop_2015', models.CharField(max_length=50)),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Food Plots',
            },
        ),
        migrations.CreateModel(
            name='grasslands',
            fields=[
                ('grasslands_id', models.AutoField(primary_key=True, serialize=False)),
                ('operator', models.CharField(max_length=50)),
                ('program', models.CharField(max_length=50)),
                ('location', models.CharField(max_length=50)),
                ('shape_area', models.FloatField()),
                ('year_done', models.IntegerField()),
                ('acres', models.FloatField()),
                ('cost', models.IntegerField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Grassland Exports',
            },
        ),
        migrations.CreateModel(
            name='habitat_leases',
            fields=[
                ('lease_id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=50)),
                ('lease_or_p', models.CharField(max_length=50)),
                ('start_date', models.DateField()),
                ('end_date', models.DateField()),
                ('annual_cos', models.IntegerField()),
                ('total_acre', models.IntegerField()),
                ('payment_du', models.CharField(max_length=50)),
                ('contract_l', models.IntegerField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Habitat Leases',
            },
        ),
        migrations.CreateModel(
            name='lbst_boundary',
            fields=[
                ('boundary_id', models.AutoField(primary_key=True, serialize=False)),
                ('objectid', models.BigIntegerField()),
                ('own_type', models.CharField(max_length=254)),
                ('own_name', models.CharField(max_length=254)),
                ('mgr_name_d', models.CharField(max_length=254)),
                ('p_des_tp', models.CharField(max_length=254)),
                ('p_loc_ds', models.CharField(max_length=254)),
                ('p_des_nm', models.CharField(max_length=254)),
                ('p_loc_nm', models.CharField(max_length=254)),
                ('s_des_tp', models.CharField(max_length=254)),
                ('s_loc_ds', models.CharField(max_length=254)),
                ('s_des_nm', models.CharField(max_length=254)),
                ('s_loc_nm', models.CharField(max_length=254)),
                ('t_des_tp', models.CharField(max_length=254)),
                ('t_loc_ds', models.CharField(max_length=254)),
                ('t_des_nm', models.CharField(max_length=254)),
                ('t_loc_nm', models.CharField(max_length=254)),
                ('state_nm', models.CharField(max_length=254)),
                ('gap_sts', models.CharField(max_length=254)),
                ('iucn_cat', models.CharField(max_length=254)),
                ('gis_src', models.CharField(max_length=254)),
                ('src_date', models.CharField(max_length=254)),
                ('comments', models.CharField(max_length=254)),
                ('gis_acres', models.FloatField()),
                ('status', models.CharField(max_length=254)),
                ('fia_code', models.CharField(max_length=254)),
                ('shape_leng', models.FloatField()),
                ('res_status', models.CharField(max_length=254)),
                ('shape_le_1', models.FloatField()),
                ('shape_area', models.FloatField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Reservation Boundary',
            },
        ),
        migrations.CreateModel(
            name='lbst_new_parcels',
            fields=[
                ('new_parcel_id', models.AutoField(primary_key=True, serialize=False)),
                ('objectid', models.BigIntegerField()),
                ('area', models.FloatField()),
                ('perimeter', models.FloatField()),
                ('bigplsc_field', models.BigIntegerField()),
                ('bigplsc_id', models.BigIntegerField()),
                ('sec', models.IntegerField()),
                ('town', models.CharField(max_length=3)),
                ('rng', models.CharField(max_length=3)),
                ('mer', models.IntegerField()),
                ('shape_leng', models.FloatField()),
                ('shape_area', models.FloatField()),
                ('remarks', models.CharField(max_length=150)),
                ('purch_name', models.CharField(max_length=50)),
                ('purch_date', models.CharField(max_length=50)),
                ('sect_t_r', models.CharField(max_length=50)),
                ('legal_desc', models.CharField(max_length=250)),
                ('acres_field', models.BigIntegerField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Newly Acquired Parcels',
            },
        ),
        migrations.CreateModel(
            name='lbst_parcels',
            fields=[
                ('parcel_id', models.AutoField(primary_key=True, serialize=False)),
                ('area', models.FloatField()),
                ('perimeter', models.FloatField()),
                ('biglst_field', models.FloatField()),
                ('biglst_id', models.FloatField()),
                ('pls_town', models.CharField(max_length=4)),
                ('pls_range', models.CharField(max_length=4)),
                ('pls_sec', models.CharField(max_length=2)),
                ('pls_pm', models.CharField(max_length=2)),
                ('lst_owntyp', models.CharField(max_length=1)),
                ('lst_restyp', models.CharField(max_length=1)),
                ('lst_open', models.CharField(max_length=2)),
                ('lst_tractn', models.CharField(max_length=8)),
                ('lst_suffix', models.CharField(max_length=3)),
                ('lst_mtract', models.CharField(max_length=8)),
                ('lst_msuffi', models.CharField(max_length=3)),
                ('lst_lot', models.CharField(max_length=3)),
                ('lst_area', models.FloatField()),
                ('lst_sym', models.IntegerField()),
                ('acres', models.BigIntegerField()),
                ('owntype', models.FloatField()),
                ('owner', models.FloatField()),
                ('own', models.FloatField()),
                ('num', models.FloatField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Reservation Boundary',
            },
        ),
        migrations.CreateModel(
            name='shelterbelts',
            fields=[
                ('shelterbelts_id', models.AutoField(primary_key=True, serialize=False)),
                ('objectid', models.IntegerField()),
                ('operator', models.CharField(max_length=50)),
                ('program', models.CharField(max_length=50)),
                ('location', models.CharField(max_length=25)),
                ('cost', models.IntegerField()),
                ('size_ac', models.FloatField()),
                ('number_of_field', models.IntegerField()),
                ('year_done', models.IntegerField()),
                ('fabric_ft', models.IntegerField()),
                ('irrigated_field', models.FloatField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPointField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Homesite Shelterbelts',
            },
        ),
        migrations.CreateModel(
            name='trees_shrubs',
            fields=[
                ('trees_shrubs_id', models.AutoField(primary_key=True, serialize=False)),
                ('operator', models.CharField(max_length=24)),
                ('program', models.CharField(max_length=16)),
                ('practice', models.CharField(max_length=20)),
                ('location', models.CharField(max_length=16)),
                ('cost_field', models.BigIntegerField()),
                ('size_ac_field', models.FloatField()),
                ('z_of_trees', models.BigIntegerField()),
                ('year_done', models.BigIntegerField()),
                ('fabric_ft', models.BigIntegerField()),
                ('irrigated', models.CharField(max_length=10)),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Trees and Shrubs',
            },
        ),
        migrations.CreateModel(
            name='wetlands',
            fields=[
                ('wetlands_id', models.AutoField(primary_key=True, serialize=False)),
                ('operator', models.CharField(max_length=20)),
                ('program', models.CharField(max_length=16)),
                ('practice', models.CharField(max_length=20)),
                ('location', models.CharField(max_length=16)),
                ('cost_field', models.BigIntegerField()),
                ('size_ac_field', models.FloatField()),
                ('year_done', models.IntegerField()),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(srid=4326)),
            ],
            options={
                'verbose_name_plural': 'Wetlands',
            },
        ),
    ]
