Name: AP AREA 27
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

AP AREA 27

This Address Point feature class contains one point for every address in Survey Township 27 (Township 36 N, Range 12 E; see ccgisdata - Survey Township (Area) 2014).
Organization: Cook County of Illinois
Last updated: 2024-12-07T00:55:37.063902
Tags: address, cook-county, gis, inactive, pin, property-and-land-records, survey-township-27

Tables

Table 1

@usgov.cook_county_of_illinois_ap_area_27_0f8dc.table_1

4.94 MB
33510 rows
95 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "addrnopref" VARCHAR,
  "addrno" BIGINT,
  "addrnosuff" VARCHAR,
  "addrnosep" VARCHAR,
  "addrnocom" VARCHAR,
  "stnameprm" VARCHAR,
  "stnameprd" VARCHAR,
  "stnameprt" VARCHAR,
  "stname" VARCHAR,
  "stnamepot" VARCHAR,
  "stnamepod" VARCHAR,
  "stnamepom" VARCHAR,
  "stnamecom" VARCHAR,
  "subaddtype" VARCHAR,
  "subaddid" VARCHAR,
  "subaddelem" VARCHAR,
  "subaddcom" VARCHAR,
  "lndmrkname" VARCHAR,
  "placename" VARCHAR,
  "uspspn" VARCHAR,
  "uspspngnis" BIGINT,
  "uspsst" VARCHAR,
  "zip5" BIGINT,
  "zip4" VARCHAR,
  "country" VARCHAR,
  "gnismuni" BIGINT,
  "gnistwp" BIGINT,
  "gniscnty" BIGINT,
  "gnisstate" BIGINT,
  "uspsboxtyp" VARCHAR,
  "uspsboxid" VARCHAR,
  "uspsbox" VARCHAR,
  "uspsgrptyp" VARCHAR,
  "uspsgrpid" VARCHAR,
  "uspsroute" VARCHAR,
  "uspsadd" VARCHAR,
  "uspsgndypt" VARCHAR,
  "addrdeliv" VARCHAR,
  "cmpaddabrv" VARCHAR,
  "addrlastli" VARCHAR,
  "addressid" VARCHAR,
  "aauthority" VARCHAR,
  "reladdid" VARCHAR,
  "addreltype" VARCHAR,
  "xposition" DOUBLE,
  "yposition" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "usgridcord" VARCHAR,
  "addrelev" BIGINT,
  "pinsource" VARCHAR,
  "pin" BIGINT,
  "addrngtyp" VARCHAR,
  "addrngprty" VARCHAR,
  "addrngside" VARCHAR,
  "addrngdirc" VARCHAR,
  "addrngspan" VARCHAR,
  "addrclass" VARCHAR,
  "addrfetype" VARCHAR,
  "offstatus" VARCHAR,
  "anomaly" VARCHAR,
  "addrsos" VARCHAR,
  "addrzlev" BIGINT,
  "locdesc" VARCHAR,
  "mailaddr" VARCHAR,
  "opstatus" VARCHAR,
  "saustatus" VARCHAR,
  "coordaccu" BIGINT,
  "addrnopar" VARCHAR,
  "attachele" VARCHAR,
  "subaddord" BIGINT,
  "elemseqnum" BIGINT,
  "pntype" VARCHAR,
  "lndmrkgnis" BIGINT,
  "deladdtype" VARCHAR,
  "addsrtdate" VARCHAR,
  "addenddate" VARCHAR,
  "datasetid" VARCHAR,
  "univrsldt" TIMESTAMP,
  "editor" VARCHAR,
  "edittime" VARCHAR,
  "edittype" VARCHAR,
  "pwaeditor" VARCHAR,
  "pwaedtdate" VARCHAR,
  "pwa_commen" VARCHAR,
  "pwa_status" VARCHAR,
  "geocode_mu" VARCHAR,
  "document_l" VARCHAR,
  "document_s" VARCHAR,
  "comment" VARCHAR,
  "created_us" VARCHAR,
  "created_da" VARCHAR,
  "last_edite" VARCHAR,
  "last_edi_1" VARCHAR
);