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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Item | item | item | Text | Indicates name of each cost item listed under work description. Example: 1∅ up to 20-1 or 10-2 pole breakers |
| Watts_Lamps | sign_lamp_wattage | sign_lamp_wattage | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the wattage of the lamps on the sign. |
| Switches | floor_switches | floor_switches | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of switches involved in the work on that floor. |
| Details_ID | unique_id | unique_id | Text | |
| Cost | item_cost | item_cost | Number | Indicates cost of each item listed under work description |
| Floor_Name | floor_name | floor_name | Text | If 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_AC | floor_ac_receptacles | floor_ac_receptacles | Text | If 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_Transformers | sign_transformers | sign_transformers | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate number of transformers for the sign. |
| Floor_Description | floor_detail | floor_detail | Text | If 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_Transformer | sign_va_per_transformer | sign_va_per_transformer | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate V.A. of each transformer. |
| Sign_Square_Footage | sign_sq_footage | sign_sq_footage | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total square footage of the sign. |
| Material_Gauge | sign_materials_guage | sign_materials_guage | Text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the details of the material and gauge used in the sign construction. |
| Floor_From | from_floor | from_floor | Text | If 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_VA | sign_total_watts_va | sign_total_watts_va | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total watts or V.A. (Volt Ampere) of the sign. |
| Fee_Amount | fee_amount | fee_amount | Number | Indicates total fee amount (quantity * cost) |
| Receptacles_ATT | floor_att_receptacles | floor_att_receptacles | Text | If 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_Circuit | sign_sockets_per_circuit | sign_sockets_per_circuit | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the number of sockets per circuit. |
| AWG | sign_total_aw_guage | sign_total_aw_guage | Text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the number of (American wire) AWG gauge of wire. |
| Sign_Manufacturer | sign_manufacturer | sign_manufacturer | Text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the manufacturer of the sign. |
| Manufacturer_Address | sign_manufacturer_address | sign_manufacturer_address | Text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the sign manufacturer's address. |
| Work_ID | work_id | work_id | Text | A unique identifier assigned to each item listed under work description |
| Total_KVA | floor_kva | floor_kva | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total kva of transformers involved in the work on that floor. |
| Floor_To | to_floor | to_floor | Text | If 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_Description | work_description | work_description | Text | Indicates a header for each group of items listed under work description. Example: Panels |
| Number_Size | item_detail | item_detail | Text | Includes more information to describe each item |
| Transformer | floor_transformers | floor_transformers | Number | Indicates number of transformers in the specified floor |
| Sign_Dimensions | sign_dimensions | sign_dimensions | Text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the dimensions of the sign in feet. This field is free text. |
| Sign_ID | sign_id | sign_id | Text | A unique identifier assigned to each electrical sig decscription under work description |
| Quantity | item_quantity | item_quantity | Text | Indicates quantity of each cost item listed under work description |
| Floor_ID | floor_id | floor_id | Text | A unique identifier assigned to each floor description under a work description |
| Job_Filing_Number | job_filing_number | job_filing_number | Text | A 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) |
| Outlets | floor_outlets | floor_outlets | Number | Indicates number of outlets in the specified floor |
| Heaters | floor_heaters | floor_heaters | Number | Indicates number of heaters in the specified floor |
| Sign_Make | sign_text | sign_text | Text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the text on the sign. |
| Total_Lamps | sign_lamps | sign_lamps | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total number of lamps on the sign. |
| Total_Circuits | sign_circuits | sign_circuits | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Signs", this will indicate the total number of circuits in the sign. |
| Total_KW | floor_kw | floor_kw | Number | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the total kw of heaters involved in the work on that floor. |
| Total HPKW | floor_hpkw | floor_hpkw | Number | If 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 Generators | floor_motors_generators | floor_motors_generators | Number | Indicates number of motors or generators in the specified floor |
| Fixture | floor_fixtures | floor_fixtures | Text | If the WORK_FLOOR_DESCTRIPTION_TYPE is "Floor Descriptions", this will indicate the number of fixtures involved in the work on that floor. |
Upstream Metadata