About this Dataset

Accela Legacy Hearings

A number of historical records did not successfully migrate during the City's transition to LAMA, a new data management system for land use regulation, in 2012. This dataset gives information on hearings from cases held before that transition. This is not an exhaustive list of all cases, and it contains some records that did migrate successfully, causing duplicates between this dataset and the dataset "CE All Hearings." That data can be found at: https://data.nola.gov/dataset/CE-All-Hearings/44ct-56tr.
Organization: City of New Orleans
Last updated: 2020-11-12T13:56:02.358752
Tags: code-enforcement, hearings, legacy

Tables

Table 1

@usgov.city_of_new_orleans_accela_legacy_hearings.table_1

176.2 kB
2,957 rows
17 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "casenumber" VARCHAR,
  "propertyaddress" VARCHAR,
  "propertydetail" VARCHAR,
  "councildistrict" VARCHAR,
  "geopin" DOUBLE,
  "inspectiondate" VARCHAR,
  "noticedate" TIMESTAMP,
  "postingstatusdate" TIMESTAMP,
  "prevhearingdate" TIMESTAMP,
  "prevhearingtime" VARCHAR,
  "casehistory" VARCHAR,
  "hearingdate" TIMESTAMP,
  "hearingtime" VARCHAR,
  "judgment" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);