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