About this Dataset

Building And Safety - Building Permits Issued From 2020 To Present (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:29.607273
Tags: building-permit

Tables

Table 1

@usgov.city_of_los_angeles_building_and_safety_building_permi_fdf50553.table_1

48.67 MB
329,446 rows
38 columns

CREATE TABLE table_1 (
  "permit_nbr" VARCHAR,
  "primary_address" VARCHAR,
  "zip_code" DOUBLE,
  "cd" DOUBLE,
  "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" TIMESTAMP,
  "du_changed" DOUBLE,
  "adu_changed" DOUBLE,
  "junior_adu" DOUBLE,
  "square_footage" DOUBLE,
  "status_desc" VARCHAR,
  "status_date" TIMESTAMP,
  "valuation" DOUBLE,
  "construction" VARCHAR,
  "height" DOUBLE,
  "type_lat_lon" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "work_desc" VARCHAR,
  "ev" VARCHAR,
  "solar" VARCHAR,
  "business_unit" VARCHAR,
  "refresh_time" TIMESTAMP,
  "geolocation" VARCHAR
);