cityofnewyork-us/dob-now-electrical-permit-details-xmmq-y7za
Icon for Socrata external plugin
 
Readme
Updated 10 hours ago
Indexed 1 hour ago

DOB NOW: Electrical Permit Details

This dataset is part of the DOB NOW Electrical Permit Data Collection: https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=DOB+NOW+Electrical+Permits+Data

This dataset contains details of the electrical scope of work. For each Job Filing Number, there can be multiple rows/records in this dataset. For example, there might be electrical work being performed in the basement as well as on the 4th floor. One row/record for Basement and one for the floor. The job might have some 101 to 200 amps Service Switches as well as some Up to 100 amps Service Switches, and there would be one row/record for each.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
ItemitemitemTextIndicates name of each cost item listed under work description. Example: 1∅ up to 20-1 or 10-2 pole breakers
Watts_Lampssign_lamp_wattagesign_lamp_wattageNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the wattage of the lamps on the sign.
Switchesfloor_switchesfloor_switchesNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of switches involved in the work on that floor.
Details_IDunique_idunique_idText
Costitem_costitem_costNumberIndicates cost of each item listed under work description
Floor_Namefloor_namefloor_nameTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the name of the floor of the building. (Example: Mezzanine, Lobby, Basement) If the floor doesn't have a name, this field will display "Floor Number(s)".
Receptacles_ACfloor_ac_receptaclesfloor_ac_receptaclesTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of A/C Receptacles involved in the work on that floor.
Sign_Transformerssign_transformerssign_transformersNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate number of transformers for the sign.
Floor_Descriptionfloor_detailfloor_detailTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will provide more detail about the floor on which the work will be performed. This field is free text.
VA_Transformersign_va_per_transformersign_va_per_transformerNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate V.A. of each transformer.
Sign_Square_Footagesign_sq_footagesign_sq_footageNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total square footage of the sign.
Material_Gaugesign_materials_guagesign_materials_guageTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the details of the material and gauge used in the sign construction.
Floor_Fromfrom_floorfrom_floorTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", and the FLOORNAME is "Floor Number(s)", this will indicate the floor on which the work will be performed. (Or in the case of a range of floors, this will be the lowest floor number.)
Total_Watts_VAsign_total_watts_vasign_total_watts_vaNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total watts or V.A. (Volt Ampere) of the sign.
Fee_Amountfee_amountfee_amountNumberIndicates total fee amount (quantity * cost)
Receptacles_ATTfloor_att_receptaclesfloor_att_receptaclesTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of ATT Receptacles involved in the work on that floor.
Sockets_Per_Circuitsign_sockets_per_circuitsign_sockets_per_circuitNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the number of sockets per circuit.
AWGsign_total_aw_guagesign_total_aw_guageTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the number of (American wire) AWG gauge of wire.
Sign_Manufacturersign_manufacturersign_manufacturerTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the manufacturer of the sign.
Manufacturer_Addresssign_manufacturer_addresssign_manufacturer_addressTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the sign manufacturer's address.
Work_IDwork_idwork_idTextA unique identifier assigned to each item listed under work description
Total_KVAfloor_kvafloor_kvaNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total kva of transformers involved in the work on that floor.
Floor_Toto_floorto_floorTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", and the FLOORNAME is "Floor Number(s)", this will indicate the floor on which the work will be performed. (Or in the case of a range of floors, this will be the highest floor number.)
Work_Descriptionwork_descriptionwork_descriptionTextIndicates a header for each group of items listed under work description. Example: Panels
Number_Sizeitem_detailitem_detailTextIncludes more information to describe each item
Transformerfloor_transformersfloor_transformersNumberIndicates number of transformers in the specified floor
Sign_Dimensionssign_dimensionssign_dimensionsTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the dimensions of the sign in feet. This field is free text.
Sign_IDsign_idsign_idTextA unique identifier assigned to each electrical sig decscription under work description
Quantityitem_quantityitem_quantityTextIndicates quantity of each cost item listed under work description
Floor_IDfloor_idfloor_idTextA unique identifier assigned to each floor description under a work description
Job_Filing_Numberjob_filing_numberjob_filing_numberTextA unique identifier assigned to a job filing. It consists of job number (a letter indicating the borough followed by an 8-digit number) hyphenated with Filing Number (a 2-digit code identifying the filing type). Once the permit is issued, a suffix "-EL" is added to the job filing number. (Example: M00000001-I1-EL)
Outletsfloor_outletsfloor_outletsNumberIndicates number of outlets in the specified floor
Heatersfloor_heatersfloor_heatersNumberIndicates number of heaters in the specified floor
Sign_Makesign_textsign_textTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the text on the sign.
Total_Lampssign_lampssign_lampsNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total number of lamps on the sign.
Total_Circuitssign_circuitssign_circuitsNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total number of circuits in the sign.
Total_KWfloor_kwfloor_kwNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total kw of heaters involved in the work on that floor.
Total HPKWfloor_hpkwfloor_hpkwNumberIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total hpkw of motors or generators involved in the work on that floor.
Motors Generatorsfloor_motors_generatorsfloor_motors_generatorsNumberIndicates number of motors or generators in the specified floor
Fixturefloor_fixturesfloor_fixturesTextIf the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of fixtures involved in the work on that floor.
 
Preview
  • dob_now_electrical_permit_details
     
Upstream Metadata