Class 1.2 – Import

Go to https://data.greensboro-nc.gov/browse?limitTo=datasets and get BI Permits.

create table "bi_permits" (
    "sakey" integer,
    "permitnum" integer,
    "adsakey" integer,
    "contractor" text,
    "issueddate" text,
    "permitfee" text,
    "statuscurrent" text,
    "applicationtype" text,
    "totalcost" text,
    "generalcost" text,
    "electricalcost" text,
    "eleccontractor" text,
    "plumbingcost" text,
    "plumbcontractor" text,
    "mechanicalcost" text,
    "mechcontractor" text,
    "ownerdoingwork" text,
    "septictanknum" real,
    "description" text,
    "soilerosionfee" text,
    "housingrecoveryfee" text,
    "typeconstructiondesc" text,
    "basement" text,
    "numbaths" real,
    "numunits" integer,
    "numrooms" integer,
    "numstories" real,
    "buildingsqft" real,
    "occupancydesc" text,
    "canceldate" text,
    "censustract" text,
    "floodplain" text,
    "zoning" text,
    "historicdistrict" text,
    "cancelreason" text,
    "tempcoexpdate" text,
    "finalco" text,
    "finalcodate" text,
    "stname" text,
    "sttype" text,
    "stprefix" text,
    "stsfxdir" text,
    "stnumber" text,
    "stapt" text,
    "city" text,
    "state" text,
    "ownername" text,
    "ownername2" text,
    "mailaddress" text,
    "mailaddress2" text,
    "mailcity" text,
    "mailstate" text,
    "mailzip" text,
    "planreviewnum" text,
    "multifamily" text,
    "localhistdistrict" text,
    "annexdate" text,
    "xcoord" real,
    "ycoord" real,
    "fulladdress" text 
);

copy bi_permits from '/Users/brendanyounger/Downloads/BI_Permits.csv' delimiter ',' csv header;

https://s3.amazonaws.com/brendanyounger/BI_Permits.csv

We do: find permits on your house.

Find permits on your street. How many?
We do: Find most recent permit on your street.