Same bill assigned different legislative sessions (resultantly, creating duplicates)

[reginafcompton]

Chicago Councilmatic recently had some difficulty importing bills, due to a duplicate bill in the OCD API. I queried the opencivicdata database like so:

# query
select created_at, identifier, title, legislative_session_id, classification, from_organization_id from opencivicdata_bill where identifier like '%O201
11-4305%'

# results

          created_at           | identifier |                      title                       |        legislative_session_id        | classification |                 from_organization_id
-------------------------------+------------+--------------------------------------------------+--------------------------------------+----------------+-------------------------------------------------------
 2015-12-22 04:53:52.333476+00 | O2011-4305 | Loading/Standing/Tow Zone(s) at 155 W Kinzie St  | 90625a3a-d0b3-4830-8aac-59031fd799ee | {ordinance}    | ocd-organization/ef168607-9135-4177-ad8e-c1f7a4806c3a
 2018-11-27 18:26:51.108115+00 | O2011-4305 | Loading/Standing/Tow Zone(s) at 155 W Kinzie St  | 2a37270a-5149-4e23-abac-a59cf6e149dc | {ordinance}    | ocd-organization/ef168607-9135-4177-ad8e-c1f7a4806c3a
(2 rows)

Apparently, the Chicago folks updated the bill, and the scraper created a new entry for it and assigned it a different legislative session. The different legislative sessions are:

                  id                  | identifier |         name         | classification | start_date |  end_date  |                        jurisdiction_id
--------------------------------------+------------+----------------------+----------------+------------+------------+---------------------------------------------------------------
 90625a3a-d0b3-4830-8aac-59031fd799ee | 2011       | 2011 Regular Session |                | 2011-05-18 | 2015-05-17 | ocd-jurisdiction/country:us/state:il/place:chicago/government
 2a37270a-5149-4e23-abac-a59cf6e149dc | 2007       | 2007 Regular Session |                | 2007-05-18 | 2011-05-17 | ocd-jurisdiction/country:us/state:il/place:chicago/government

It is not clear to me why this happened, since both bills have the same last action date (2011-05-04), e.g., as given in the OCD API for both bills:

Either way, It seems to me that if the legislative session changes than the Bill should not be created anew.

As an immediate solution, I deleted the older entry from the ocd api and Councilmatic databases.

[reginafcompton]

Two other bills were affected by this: O2011-2239 and O2011-1368.