About this Dataset

Site Address Point

Site address points represent the location of site or service delivery addresses assigned by local governments. Used to standardize addresses across city departments. Uses ESRI Local Government Information schema, and is projected in Louisiana State Plane. Updated weekly based on changes made by Safety and Permits.
Organization: City of New Orleans
Last updated: 2021-08-07T12:07:37.449545
Tags: addresses, egis

Tables

Table 1

@usgov.city_of_new_orleans_site_address_point_eecff.table_1

19.88 MB
266,115 rows
23 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "site_address_id" BIGINT,
  "address_number_prefix" VARCHAR,
  "address_number_suffix" VARCHAR,
  "full_address_number" BIGINT,
  "address_unit_type" VARCHAR,
  "address_unit_number" VARCHAR,
  "full_road_name" VARCHAR,
  "full_address" VARCHAR,
  "place_name" VARCHAR,
  "location" VARCHAR,
  "capture_method" VARCHAR,
  "status" VARCHAR,
  "last_update_date" VARCHAR,
  "last_editor" VARCHAR,
  "address_source" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "addr_type" VARCHAR,
  "last_edited_user" VARCHAR,
  "last_edited_date" VARCHAR,
  "join_id" DOUBLE
);