Name: Code Enforcement Active Pipeline
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Code Enforcement Active Pipeline

Point dataset showing blighted properties reported via citizens. Updated weekly based on LAMA database. Also available via data.nola.gov as tabular dataset.
Organization: City of New Orleans
Last updated: 2022-01-24T23:27:04.995957
Tags: active, blight, code-enforcement

Tables

Table 1

@usgov.city_of_new_orleans_code_enforcement_active_pipeline_e8367.table_1

970.7 kB
9,928 rows
22 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "date_case_filed" DOUBLE,
  "case_id" BIGINT,
  "case_number" VARCHAR,
  "geoaddress" VARCHAR,
  "geopin" DOUBLE,
  "initial_inspection" DOUBLE,
  "initial_result" VARCHAR,
  "key_status" VARCHAR,
  "last_permit" VARCHAR,
  "location" VARCHAR,
  "next_hearing_date" DOUBLE,
  "open_closed" VARCHAR,
  "permit_filing_date" DOUBLE,
  "permit_status" VARCHAR,
  "permit_type" VARCHAR,
  "previous_hearing_date" DOUBLE,
  "prev_hearing_result" VARCHAR,
  "stage" VARCHAR,
  "status_date" DOUBLE,
  "zipcode" DOUBLE
);