# Generated by Django 2.1.5 on 2019-04-07 01:19

import datasets.utils.BaseDatasetModel
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
        ('datasets', '0019_conhrecord'),
    ]

    operations = [
        migrations.CreateModel(
            name='DOBNowFiledPermit',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('jobfilingnumber', models.TextField()),
                ('filingstatus', models.TextField(blank=True, null=True)),
                ('houseno', models.TextField(blank=True, null=True)),
                ('streetname', models.TextField(blank=True, null=True)),
                ('borough', models.TextField(blank=True, null=True)),
                ('block', models.TextField(blank=True, null=True)),
                ('lot', models.TextField(blank=True, null=True)),
                ('commmunityboard', models.TextField(blank=True, null=True)),
                ('workonfloor', models.TextField(blank=True, null=True)),
                ('aptcondonos', models.TextField(blank=True, null=True)),
                ('applicantprofessionaltitle', models.TextField(blank=True, null=True)),
                ('applicantlicense', models.TextField(blank=True, null=True)),
                ('applicantfirstname', models.TextField(blank=True, null=True)),
                ('applicantsmiddleinitial', models.TextField(blank=True, null=True)),
                ('applicantlastname', models.TextField(blank=True, null=True)),
                ('ownersbusinessname', models.TextField(blank=True, null=True)),
                ('ownersstreetname', models.TextField(blank=True, null=True)),
                ('city', models.TextField(blank=True, null=True)),
                ('state', models.TextField(blank=True, null=True)),
                ('zip', models.TextField(blank=True, null=True)),
                ('filingrepresentativefirstname', models.TextField(blank=True, null=True)),
                ('filingrepresentativemiddleinitial', models.TextField(blank=True, null=True)),
                ('filingrepresentativelastname', models.TextField(blank=True, null=True)),
                ('filingrepresentativebusinessname', models.TextField(blank=True, null=True)),
                ('filingrepresentativestreetname', models.TextField(blank=True, null=True)),
                ('filingrepresentativecity', models.TextField(blank=True, null=True)),
                ('filingrepresentativestate', models.TextField(blank=True, null=True)),
                ('filingrepresentativezip', models.TextField(blank=True, null=True)),
                ('sprinklerworktype', models.BooleanField(blank=True, null=True)),
                ('plumbingworktype', models.BooleanField(blank=True, null=True)),
                ('initialcost', models.IntegerField(blank=True, null=True)),
                ('totalconstructionfloorarea', models.IntegerField(blank=True, null=True)),
                ('reviewbuildingcode', models.IntegerField(blank=True, null=True)),
                ('littlee', models.BooleanField(blank=True, null=True)),
                ('unmappedccostreet', models.BooleanField(blank=True, null=True)),
                ('requestlegalization', models.BooleanField(blank=True, null=True)),
                ('includespermanentremoval', models.BooleanField(blank=True, null=True)),
                ('incompliancewithnycecc', models.BooleanField(blank=True, null=True)),
                ('exemptfromnycecc', models.BooleanField(blank=True, null=True)),
                ('buildingtype', models.TextField(blank=True, null=True)),
                ('existingstories', models.IntegerField(blank=True, null=True)),
                ('existingheight', models.IntegerField(blank=True, null=True)),
                ('existingdwellingunits', models.IntegerField(blank=True, null=True)),
                ('proposednoofstories', models.IntegerField(blank=True, null=True)),
                ('proposedheight', models.IntegerField(blank=True, null=True)),
                ('proposeddwellingunits', models.IntegerField(blank=True, null=True)),
                ('specialinspectionrequirement', models.TextField(blank=True, null=True)),
                ('specialinspectionagencynumber', models.TextField(blank=True, null=True)),
                ('progressinspectionrequirement', models.TextField(blank=True, null=True)),
                ('built1informationvalue', models.TextField(blank=True, null=True)),
                ('built2informationvalue', models.TextField(blank=True, null=True)),
                ('built2ainformationvalue', models.TextField(blank=True, null=True)),
                ('built2binformationvalue', models.TextField(blank=True, null=True)),
                ('standpipe', models.BooleanField(blank=True, null=True)),
                ('antenna', models.BooleanField(blank=True, null=True)),
                ('curbcut', models.BooleanField(blank=True, null=True)),
                ('sign', models.BooleanField(blank=True, null=True)),
                ('fence', models.BooleanField(blank=True, null=True)),
                ('scaffold', models.BooleanField(blank=True, null=True)),
                ('shed', models.BooleanField(blank=True, null=True)),
                ('latitude', models.DecimalField(blank=True, decimal_places=16, max_digits=32, null=True)),
                ('longitude', models.DecimalField(blank=True, decimal_places=16, max_digits=32, null=True)),
                ('councildistrict', models.TextField(blank=True, null=True)),
                ('censustract', models.TextField(blank=True, null=True)),
                ('nta', models.TextField(blank=True, null=True)),
                ('bbl', models.ForeignKey(db_column='bbl', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Property')),
                ('bin', models.ForeignKey(blank=True, db_column='bin', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Building')),
            ],
            bases=(datasets.utils.BaseDatasetModel.BaseDatasetModel, models.Model),
        ),
    ]
