September 16, 2016 / by Open Data Portal Team / In Open Data , Data Portal

New columns in Transportation Department Permits

We have added three columns to the Transportation Department Permits dataset:

  • UNIQUEKEY - A permanent, unique identifier for the record. The APPLICATIONNUMBER column cannot be used as a unique ID because, while it is unique for an application, a single application covering a long address range can be broken into multiple records.
  • XCOORDINATE and YCOORDINATE - Supplementing LATITUDE and LONGITUDE, these columns contain the starting position of the address range in State Plane Illinois East NAD 1983 projection.