Readme
Updated 1 day ago
‧ Indexed 1 hour ago
Mechanical Permits
List of permits regarding mechanical work for commercial and residential buildings. Includes work involving heating/cooling systems, electrical systems, and home renovations.
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
Location (city) | geocoded_column_city | geocoded_column_city | Text | |
Police Neighborhood Regions | :@computed_region_guic_hr4a | :@computed_region_guic_hr4a | Number | |
Police Response Districts | :@computed_region_v7jj_366k | :@computed_region_v7jj_366k | Number | |
cambridge_neighborhoods | :@computed_region_rffn_qbt6 | :@computed_region_rffn_qbt6 | Number | |
cambridge_cdd_zoning | :@computed_region_swkg_bavi | :@computed_region_swkg_bavi | Number | |
Census Blocks 2010 | :@computed_region_e4yd_rwk4 | :@computed_region_e4yd_rwk4 | Number | |
Steam Generator Count | _of_steam_generators | _of_steam_generators | Text | Number of steam generators |
Temporary Heat Cout | _of_temporary_heat_and_l | _of_temporary_heat_and_l | Text | Number of Temporary Heat and L.P. Installation Natural Gas |
Solar Heat Count | _of_solar_heat_systems | _of_solar_heat_systems | Text | Number of solar heat systems |
Cooling Tower | does_the_proposed_work_include_2 | does_the_proposed_work_include_2 | Checkbox | Does the proposed work include installation or replacement of a cooling tower? |
Direct Vent Fireplaces Count | _of_direct_vent_fireplaces | _of_direct_vent_fireplaces | Text | Number of direct vent fireplaces |
Cooling Tower Weight | weight_of_cooling_tower_in | weight_of_cooling_tower_in | Text | Weight of Cooling Tower (in pounds) |
AC Unit Count (<25 tons) | number_of_ac_units_up_to | number_of_ac_units_up_to | Text | Number of AC Units up to 25 Tons |
Ventilation Unit Count | _of_ventilation_units | _of_ventilation_units | Text | Number of ventilation units |
Exterior Work | does_the_proposed_work_include | does_the_proposed_work_include | Checkbox | Does the proposed work include exterior work? |
Location (state) | geocoded_column_state | geocoded_column_state | Text | |
Refigeration Unit Count | _of_refrigeration_units | _of_refrigeration_units | Text | Number of refrigeration units |
Energy Recovery System Count | _of_energy_recovery_systems | _of_energy_recovery_systems | Text | Number of energy recovery systems |
Building Permit Number | building_permit_number | building_permit_number | Text | Building permit number |
Stove Hood Count | _of_stove_hoods_commercial | _of_stove_hoods_commercial | Text | Number of stove hoods (commercial) |
Range Hood Count | _of_range_hoods_residential | _of_range_hoods_residential | Text | Number of range hoods (residential) |
Pool Heater Count | _of_pool_heaters | _of_pool_heaters | Text | Number of pool heaters |
Cogen Generator Count | _of_cogen_generators | _of_cogen_generators | Text | Number of cogen generators |
Draft Inducer Count | _of_draft_inducers | _of_draft_inducers | Text | Number of draft inducers |
AC Unit Count (>25 tons) | number_of_ac_units_over_25 | number_of_ac_units_over_25 | Text | Number of AC Units over 25 Tons |
Latitude | latitude | latitude | Number | |
Permit Type | permit_type | permit_type | Text | Name of worker conducting mechanical work |
Gas Generator Count | _of_gas_generators | _of_gas_generators | Text | Number of gas generators |
Location (zip) | geocoded_column_zip | geocoded_column_zip | Text | |
Bathroom Exhaust Fan Count | _of__bathroom_exhaust_fans | _of__bathroom_exhaust_fans | Text | Number of bathroom exhaust fans (residential) |
Boiler count | _of_boilers | _of_boilers | Text | Number of boilers |
Roof Top AC Unit | does_the_proposed_work_include_1 | does_the_proposed_work_include_1 | Checkbox | Does the proposed work include installation or replacement of a roof top AC unit? |
High Pressure Unit Count | _of_high_pressure_unit_psi | _of_high_pressure_unit_psi | Text | Number of high pressure units |
Cooling Tower Location | cooling_tower_location | cooling_tower_location | Text | |
Cooling Tower Units Count (<25 tons) | number_of_cooling_tower_units_1 | number_of_cooling_tower_units_1 | Text | Number of Cooling Tower Units up to 25 Tons |
Air Handling Unit Duct Coil Count | _of_air_handling_unit_duct | _of_air_handling_unit_duct | Text | Number of air handling unit duct coils |
Total Tonnage | total_tonnage_for_cooling | total_tonnage_for_cooling | Text | Total Tonnage for Cooling Tower Units over 25 Tons |
Cooling Tower Unit Count (>25 tons) | number_of_cooling_tower_units | number_of_cooling_tower_units | Text | Number of Cooling Tower Units over 25 Tons |
ID | id | id | Number | ID |
Down Draft Exhaust Count | _of__down_draft_exhaust | _of__down_draft_exhaust | Text | Number of down draft exhaust |
Condenser Count | _of_condensers | _of_condensers | Text | Number of condensers |
Applicant Submit Date | applicant_submit_date | applicant_submit_date | Calendar date | Date when application was submitted |
Location | geocoded_column | geocoded_column | Point | Location of the permitted project |
Location (address) | geocoded_column_address | geocoded_column_address | Text | |
Longitude | longitude | longitude | Number | |
Radiant Heat Unit Count | _of_radiant_heat_units | _of_radiant_heat_units | Text | Number of radiant heat units |
Furnace Count | _of_furnaces | _of_furnaces | Text | Number of furnaces |
Heat Pump Count | _of_heat_pumps | _of_heat_pumps | Text | Number of heat pumps |
AC Units >25 tons Tonnage | total_tonnage_for_ac_units | total_tonnage_for_ac_units | Text | Total Tonnage for AC Units over 25 Tons |
Issue Date | issue_date | issue_date | Calendar date | Date when permit was issued |
Fan Coil Count | _of_fan_coils | _of_fan_coils | Text | Number of fan coils |
Ductless Split System Count | _of_ductless_split_systems | _of_ductless_split_systems | Text | Number of ductless split systems |
Company Name | company_name | company_name | Text | Name of company |
Hydro Air System Count | _of_hydro_air_systems | _of_hydro_air_systems | Text | Number of hyrdo air systems |
Process Piping Length | _of_process_piping_feet | _of_process_piping_feet | Text | Length of process piping, in feet |
Evaporative Coil Count | _of_evaporative_coils | _of_evaporative_coils | Text | Number of evaporative coils |
Upstream Metadata