Building and Safety Code Enforcement Case

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.lacity.org
Id 2uz8-3tj3
Name Building and Safety Code Enforcement Case
Category A Safe City
Tags ladbs, department of building and safety, building and safety, building, safety, construction services, construction, code enforcement, case number, case, violation, citation, billboard, sign, aim…
Created 2014-05-28T22:36:18Z
Publication Date 2017-01-05T22:50:39Z

Description

The Department of Building and Safety is tasked with the enforcement of the City’s building, electrical, mechanical and zoning regulations, which are elements of the Los Angeles Municipal Code. A Code Enforcement Case may originate from a customer service request to investigate a possible Code violation, from a planned and authorized inspection of a neighborhood for the purpose of reducing blight, or from a proactive inspection of a site due to an observed hazardous condition. A case is closed (indicated by a “C” status) when the site satisfies the requirements for Code compliance, or when no Code violation is found. A case remains open (indicated by an “O” status) until the site satisfies the requirements for Code compliance.

Columns

| Included | Schema Type | Field Name                           | Name                               | Data Type     | Render Type   |
| ======== | =========== | ==================================== | ================================== | ============= | ============= |
| Yes      | series tag  | case_number                          | Case Number                        | text          | text          |
| Yes      | series tag  | ladbs_inspection_district            | LADBS Inspection District          | text          | text          |
| No       |             | address_house_number                 | Address House Number               | text          | text          |
| No       |             | address_house_fraction_number        | Address House Fraction Number      | text          | text          |
| Yes      | series tag  | address_street_direction             | Address Street Direction           | text          | text          |
| Yes      | series tag  | address_street_name                  | Address Street Name                | text          | text          |
| Yes      | series tag  | address_street_suffix                | Address Street Suffix              | text          | text          |
| Yes      | series tag  | address_street_suffix_direction      | Address Street Suffix Direction    | text          | text          |
| No       |             | address_zip                          | Address Zip                        | text          | text          |
| Yes      | time        | date_case_generated                  | Date Case Generated                | calendar_date | calendar_date |
| No       |             | date_case_closed                     | Date Case Closed                   | calendar_date | calendar_date |
| Yes      | series tag  | gis_parcel_identification_number_pin | Parcel Identification Number (PIN) | text          | text          |
| Yes      | series tag  | case_type                            | Case Type                          | text          | text          |
| Yes      | series tag  | area_planning_commission_apc         | Area Planning Commission (APC)     | text          | text          |
| Yes      | series tag  | status_of_case                       | Status of Case                     | text          | text          |

Time Field

Value = date_case_generated
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = address_house_number,address_house_fraction_number,address_zip,date_case_closed

Data Commands

series e:2uz8-3tj3 d:2005-05-25T00:00:00.000Z t:ladbs_inspection_district=1114 t:area_planning_commission_apc="South Los Angeles" t:case_number=143586 t:gis_parcel_identification_number_pin="105B197  1500" t:address_street_name=65TH t:case_type=GENERAL t:status_of_case=O t:address_street_suffix=ST t:address_street_direction=W m:row_number.2uz8-3tj3=1

series e:2uz8-3tj3 d:2011-04-04T00:00:00.000Z t:ladbs_inspection_district=3101 t:area_planning_commission_apc="South Valley" t:case_number=411656 t:gis_parcel_identification_number_pin="186B129   921" t:address_street_name=MANTECA t:case_type=GENERAL t:status_of_case=O t:address_street_suffix=ST t:address_street_direction=W m:row_number.2uz8-3tj3=2

series e:2uz8-3tj3 d:2011-04-04T00:00:00.000Z t:ladbs_inspection_district=2143 t:area_planning_commission_apc=Central t:case_number=411692 t:gis_parcel_identification_number_pin="144B197   955" t:address_street_name=NORMANDIE t:case_type=GENERAL t:status_of_case=O t:address_street_suffix=AVE t:address_street_direction=N m:row_number.2uz8-3tj3=3

Meta Commands

metric m:row_number.2uz8-3tj3 p:long l:"Row Number"

entity e:2uz8-3tj3 l:"Building and Safety Code Enforcement Case" t:url=https://data.lacity.org/api/views/2uz8-3tj3

property e:2uz8-3tj3 t:meta.view v:id=2uz8-3tj3 v:category="A Safe City" v:averageRating=0 v:name="Building and Safety Code Enforcement Case"

property e:2uz8-3tj3 t:meta.view.license v:name="Creative Commons 1.0 Universal (Public Domain Dedication)" v:termsLink=http://creativecommons.org/publicdomain/zero/1.0/legalcode v:logoUrl=images/licenses/ccZero.png

property e:2uz8-3tj3 t:meta.view.owner v:id=tdwf-cih6 v:profileImageUrlMedium=/api/users/tdwf-cih6/profile_images/THUMB v:profileImageUrlLarge=/api/users/tdwf-cih6/profile_images/LARGE v:screenName="Building and Safety OpenData" v:profileImageUrlSmall=/api/users/tdwf-cih6/profile_images/TINY v:displayName="Building and Safety OpenData"

property e:2uz8-3tj3 t:meta.view.tableauthor v:id=tdwf-cih6 v:profileImageUrlMedium=/api/users/tdwf-cih6/profile_images/THUMB v:profileImageUrlLarge=/api/users/tdwf-cih6/profile_images/LARGE v:screenName="Building and Safety OpenData" v:profileImageUrlSmall=/api/users/tdwf-cih6/profile_images/TINY v:roleName=publisher v:displayName="Building and Safety OpenData"

Top Records

| case_number | ladbs_inspection_district | address_house_number | address_house_fraction_number | address_street_direction | address_street_name | address_street_suffix | address_street_suffix_direction | address_zip | date_case_generated | date_case_closed    | gis_parcel_identification_number_pin | case_type | area_planning_commission_apc | status_of_case | 
| =========== | ========================= | ==================== | ============================= | ======================== | =================== | ===================== | =============================== | =========== | =================== | =================== | ==================================== | ========= | ============================ | ============== | 
| 143586      | 1114                      | 1316                 |                               | W                        | 65TH                | ST                    |                                 | 90044       | 2005-05-25T00:00:00 | 2013-01-10T00:00:00 | 105B197 1500                         | GENERAL   | South Los Angeles            | O              | 
| 411656      | 3101                      | 17442                |                               | W                        | MANTECA             | ST                    |                                 | 91406       | 2011-04-04T00:00:00 |                     | 186B129 921                          | GENERAL   | South Valley                 | O              | 
| 411692      | 2143                      | 1042                 |                               | N                        | NORMANDIE           | AVE                   |                                 | 90029       | 2011-04-04T00:00:00 |                     | 144B197 955                          | GENERAL   | Central                      | O              | 
| 228766      | 2102                      | 2425                 |                               | N                        | MOUNT OLYMPUS       | DR                    |                                 | 90046       | 2008-06-04T00:00:00 | 2014-09-16T00:00:00 | 153B173 324                          | GENERAL   | South Valley                 | O              | 
| 411775      | 2133                      | 3512                 |                               | N                        | SIERRA              | ST                    |                                 | 90031       | 2011-04-05T00:00:00 |                     | 142-5A227 113                        | GENERAL   | East Los Angeles             | O              | 
| 479793      | 2133                      | 3406                 |                               | N                        | NORTH BROADWAY      |                       |                                 | 90031       | 2012-09-24T00:00:00 |                     | 138A225 45                           | GENERAL   | East Los Angeles             | O              | 
| 229273      | 2144                      | 3118                 |                               | W                        | WELDON              | AVE                   |                                 | 90065       | 2008-06-12T00:00:00 | 2014-08-19T00:00:00 | 156B213 344                          | GENERAL   | East Los Angeles             | O              | 
| 480197      | 3101                      | 15235                |                               | W                        | VALERIO             | ST                    |                                 | 91405       | 2012-09-27T00:00:00 |                     | 186B145 490                          | GENERAL   | South Valley                 | O              | 
| 480317      | 1121                      | 6121                 |                               | S                        | SAN PEDRO           | ST                    |                                 | 90003       | 2012-09-28T00:00:00 |                     | 105B205 738                          | GENERAL   | South Los Angeles            | O              | 
| 250906      | 1112                      | 6208                 |                               | S                        | WEST                | BLVD                  |                                 | 90043       | 2009-02-09T00:00:00 | 2015-06-22T00:00:00 | 105B185 750                          | GENERAL   | South Los Angeles            | O              |