About this Dataset

Address Points

**Download In State Plane Projection Here. **

These address points were developed for a myriad of uses including general public geocoding in Lake County web sites and NG-911 emergency dispatch. All addresses are reviewed on a monthly basis against the United States Post Office delivery database to ensure that they are still active. New addresses are added at this time or earlier if they are made known to Lake County GIS by local data partners. Attributes DiscrpAgID through Elev reflect the NENA NG-911 / State of Illinois GIS Data model. Additional local data fields have also been included. The fields LSt_PreDir, LSt_Name, LSt_Type and LSt_PosDir are formatted according to United States Postal Service standards.

Update Frequency:
This dataset is updated on a weekly basis.
Organization: Lake County, Illinois
Last updated: 2024-02-09T11:27:21.724185
Tags: address-points, lake-county-illinois

Tables

Table 1

@usgov.lake_county_illinois_address_points_068aa.table_1

13.11 MB
313,436 rows
51 columns


CREATE TABLE table_1 (
  "fulladdr" VARCHAR,
  "objectid" BIGINT,
  "discrepancy_agency_id" VARCHAR,
  "date_updated" VARCHAR,
  "effective_date" VARCHAR,
  "expiration_date" VARCHAR,
  "site_nena_globally_unique_id" VARCHAR,
  "country" VARCHAR,
  "state" VARCHAR,
  "county" VARCHAR,
  "additional_code" VARCHAR,
  "additional_data_uri" VARCHAR,
  "incorporated_municipality" VARCHAR,
  "unincorporated_community" VARCHAR,
  "neighborhood_community" VARCHAR,
  "address_number_prefix" VARCHAR,
  "address_number" BIGINT,
  "address_number_suffix" VARCHAR,
  "street_name_pre_modifier" VARCHAR,
  "street_name_pre_directional" VARCHAR,
  "street_name_pre_type" VARCHAR,
  "street_name_pre_type_separator" VARCHAR,
  "street_name" VARCHAR,
  "street_name_post_type" VARCHAR,
  "street_name_post_directional" VARCHAR,
  "street_name_post_modifier" VARCHAR,
  "legacy_street_name_pre_directional" VARCHAR,
  "legacy_street_name" VARCHAR,
  "legacy_street_name_type" VARCHAR,
  "legacy_street_post_directional" VARCHAR,
  "esn" DOUBLE,
  "msag_community_name" VARCHAR,
  "postal_community_name" VARCHAR,
  "postal_code" BIGINT,
  "zip_plus_4" DOUBLE,
  "building" VARCHAR,
  "floor" VARCHAR,
  "unit" VARCHAR,
  "room" VARCHAR,
  "seat" VARCHAR,
  "additional_location_information" VARCHAR,
  "complete_landmark_name" VARCHAR,
  "mile_post" VARCHAR,
  "place_type" VARCHAR,
  "placement_method" VARCHAR,
  "longitude" VARCHAR,
  "latitude" VARCHAR,
  "elevation" VARCHAR,
  "status" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);