About this Dataset

Building And Safety - Mechanical Permits Submitted Before 2010 (N)

The Department of Building and Safety issues permits for the construction, remodeling, and repair of buildings and structures in the City of Los Angeles. Permits are categorized into building permits, electrical permits, and mechanical permits (which include plumbing, HVAC systems, fire sprinklers, elevators, and pressure vessels). Depending on the complexity of a project, a permit may be issued the same day with Express Permit or e-Permit ("No Plan Check" category), or a permit may require that the plans be reviewed ("Plan Check" category) by a Building and Safety Plan Check personnel.
Organization: City of Los Angeles
Last updated: 2023-04-22T05:23:51.733747
Tags: mechanical

Tables

Table 1

@usgov.city_of_los_angeles_building_and_safety_mechanical_per_3c5f69fc.table_1

5.73 MB
54,774 rows
30 columns

CREATE TABLE table_1 (
  "permit_nbr" VARCHAR,
  "primary_address" VARCHAR,
  "zip_code" DOUBLE,
  "cd" VARCHAR,
  "pin_nbr" VARCHAR,
  "apn" VARCHAR,
  "zone" VARCHAR,
  "apc" VARCHAR,
  "cpa" VARCHAR,
  "cnc" VARCHAR,
  "hl" VARCHAR,
  "ct" VARCHAR,
  "permit_group" VARCHAR,
  "permit_type" VARCHAR,
  "permit_sub_type" VARCHAR,
  "use_code" DOUBLE,
  "use_desc" VARCHAR,
  "submitted_date" TIMESTAMP,
  "issue_date" TIMESTAMP,
  "cofo_date" VARCHAR,
  "status_desc" VARCHAR,
  "status_date" TIMESTAMP,
  "type_lat_lon" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "work_desc" VARCHAR,
  "ev" VARCHAR,
  "solar" VARCHAR,
  "business_unit" VARCHAR,
  "refresh_time" TIMESTAMP
);