Ontario Address Change Tracker
We periodically compare each municipality's official open address list to spot new buildings, retired addresses, and corrections over time.
Every day each dataset is re-downloaded and diffed against the previous snapshot. History is kept as a Slowly-Changing-Dimension Type-2 table, so every address records the span of snapshots it was valid for — letting us replay exactly when an address first appeared, was corrected, or retired.
The hard part is identity: ESRI OBJECTIDs are reassigned on
every republish, so records are matched on a stable source ID where one exists, or on a
synthesized key (street + number + unit + rounded coordinates)
otherwise. Adding a city is a config file, not code.
An independent civic-data project — not affiliated with any municipality. Each source keeps its own open licence.
- Street number (ADDRNUMBER)
- Street name (SSTRNAME)
- Unit (UNITNUMBER)
- Full address (FULLADDR)
- Coordinates (latitude, longitude)
- ADDRESSID
- COMMENT
- OBJECTID_1
- PARCELID
- SSTRDIR
- SSTRSUFF
- STATUS
- LASTUPDATE
- Street number (CIVIC_NUMBER)
- Street name (STREET_NAME)
- Unit (UNIT_NO)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- ADDRESS_ID
- ADDRESS_TYPE
- BLOCK_PLAN
- CITY
- CITY_FILE
- CITY_GRID
- CONDO_PLAN_NUMBER
- CON_NUM
- C_OF_A
- DRAFT_PLAN_NUMBER
- GIS_ID
- HERITAGE
- LOT_NUM
- OCCUPANCY_DATE
- PERMIT_ISSUEDATE
- PERMIT_NO
- PERMIT_TYPE
- POSTAL_CODE
- PROP_CODE_DESC
- PROVINCE
- REG_PLAN_ASSUMP_DATE
- REG_PLAN_NUMBER
- SEC_PLAN_AREA
- SITE_PLAN_NUMBER
- STREET_DIRECTION
- STREET_TYPE
- SUB_TYPE
- TOWNSHIP
- WARD
- WORK_TYPE
None — every source field is compared.
- Street number (STREETNUM)
- Street name (STREETNAME)
- Full address (FULLADDRESS)
- Coordinates (latitude, longitude)
- OBJECTID_1
- POSTALCODE
- STNUMSUFF
- STREETNUMIN
- STREETTYPE
None — every source field is compared.
- Street number (HOUSENUM)
- Street name (STREET)
- Unit (UNIT)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- CITY
- COUNTRY
- COUNTRYCODE
- LATITUDE
- LONGITUDE
- NAME
- PROPCODE
- PROPDESC
- PROPERTYRSN
- PROPINFOVALUE_WARD
- PROPSTATUSCODE
- PROPSTATUSDESC
- PROVINCE
- STRDIR
- STRTYPE
- UNITTYPE
None — every source field is compared.
- Street number (HOUSE_NUMBER)
- Street name (STREET_NAME)
- Unit (UNIT_NUMBER)
- Full address (ADDRESS_LABEL)
- Coordinates (latitude, longitude)
- ADDRESS_POINT_ID
- STATUS
- WARD_ID
None — every source field is compared.
- Street number (ST_NUMBER)
- Street name (STREET)
- Unit (UNIT)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- ADD_TYPE
- AddressID
- BUILDING
- CITY
- COUNTRY
- DIRECTION
- FLOOR
- LAST_EDIT
- POLY_ID
- POSTAL
- PROVINCE
- STREET_LNG
- SUFFIX
None — every source field is compared.
- Street number (ADDRESSNUMBER)
- Street name (FULLSTREETNAME)
- Unit (UNIT_OR_AMENITY)
- Full address (FULLADDRESSTEXT)
- Coordinates (latitude, longitude)
- ADDRESSALIAS
- ADDRESSID
- ADDRESSLIFECYCLESTATUS
- ADDRESSNUMBERPREFIX
- ADDRESSNUMBERSUFFIX
- ALTERNATENAME1
- ALTERNATENAME2
- ALTERNATENAME3
- ASSIGNEDADDRESSID
- BASESTREETNAME
- COMMUNITY
- NAME
- STREETSUFFIX
- STREETTYPE
- STYPE
- UNIT_AMENITY_TYPE
- VERIFIED_DATE
- CREATEDATE
- LASTUPDATE
- Street number (STREETNO)
- Street name (FULLNAME)
- Unit (UNIT_NO)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- ADDID
- ADDLEG
- ADDLOCINFO
- AMAID
- GPID
- HAS_UNIT
- LABEL
- LANDMKNAME
- LAT
- LONG
- NAME
- PARITY
- PIN
- PLACE
- POSTCODE
- QUALIFIER
- ROLL_NO
- SEGMENTID
- STATUS
- STDIR
- STNAME
- STREETID
- STREETNAME
- STSUF
- UTM_X
- UTM_Y
- WARD
None — every source field is compared.
- Street number (NUMBER_COMPLETE)
- Street name (FULL_STREET_NAME)
- Unit (UNIT_NUMBER_COMPLETE)
- Coordinates (latitude, longitude)
- COMMUNITY
- COUNTRY
- MUNICIPALITY
- POSTAL_CODE
- PROVINCE
- STREET_NAME
- STREET_SUFFIX_DIRECTION
- STREET_SUFFIX_TYPE
None — every source field is compared.
- Street number (StreetNumber)
- Street name (StreetNameFull)
- Unit (UnitNumber)
- Full address (FullAddress)
- Coordinates (latitude, longitude)
- ARUApproved
- AddressID
- HwyCountyNum
- MultiUnitLot
- PlaceName
- SingleLowerTier
- StreetAddress
- StreetDirectionAbrv
- StreetDirectionSuffix
- StreetNameAlt
- StreetNameBody
- StreetNumSuffixConcat
- StreetNumberPrefix
- StreetNumberSuffix
- StreetSegmentID
- StreetTypeSuffix
- StreetTypeSuffixAbrv
- Xlong
- Ylat
None — every source field is compared.
- Street number (ADDRESS_NUMBER)
- Street name (STREET)
- Unit (UNIT)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- ADDRESS_ID
- ADDRESS_NUMBER_SUFFIX
- COLLECTION_TYPE
- DIRECTION_SUFFIX
- ELECTORAL_DISTRICT_NAME
- GARBAGE_DAY
- MUNICIPALITY
- NEIGHBOURHOOD
- POSTAL_CODE
- RECYCLING_DAY
- STREET_BODY_NAME
- STREET_TYPE_SUFFIX
- UNIT_TYPE
None — every source field is compared.
- Street number (CIVIC_NO)
- Street name (STREET)
- Unit (UNIT)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- PARCELID
- POLL
- PROPERTY_UNIT_ID
- ROADSEGMENTID
- ROLL_REFERENCE
- STATUS
- UNIT_TYPE
- WARD
- X_COORD
- Y_COORD
- UPDATE_DATE
- Street number (MunicipalNumber)
- Street name (FullStreetName)
- Unit (UnitNumber)
- Full address (FullAddress)
- Coordinates (latitude, longitude)
- CondoNumber
- ElectionWard
- FullNumber
- FullStreetName_ID
- GIS_ID
- IntegerMunicipalNumber
- MunicipalNumberQualifier
- Status
- StreetClassification
- StreetDirection
- StreetName
- StreetType
- UnitFullAddress
- LastEditDate
- Street number (Full_StreetNo)
- Street name (StreetName)
- Unit (Unit)
- Coordinates (latitude, longitude)
- GSmartID
- LifeCycleStatus
- Municipality
- Qualifier
- StreetDir
- StreetType
- CreateDate
- StreetNo
- Xcoord
- Ycoord
- Street number (ADDRNUM)
- Street name (FULLNAME)
- Unit (UNITID)
- Full address (FULLADDR)
- Coordinates (latitude, longitude)
- ADDRTYPE
- PI_MUNICIPAL_ADDRESS_ID
- QUALIFIER
- CREATED_DATE
- MODIFIED_DATE
- Street number (address_nu)
- Street name (street_nam)
- Unit (unit_num)
- Full address (address)
- Coordinates (latitude, longitude)
- label
- lat
- long
- objectid_1
- unit_type
- ward
None — every source field is compared.
- Street number (STNUM)
- Street name (STNAME)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- CITY
- OBJECTID_1
- STDIR
- STDIR_A
- STTYPE
- STTYPE_A
- TOWNSHIP
- created_date
- created_user
- last_edited_date
- last_edited_user
- Street number (ADDRESS_NUMBER)
- Street name (STREET)
- Full address (COMPLETE)
- Coordinates (latitude, longitude)
- ADDRESS
- ADDRESS_QUALIFIER
- CITY
- CTB_TYPE
- PCL_PIN
- PROVINCE
- REFNAME
- ROOT
- ROWTYPE
- RSN
- SPLITLOC
- TYPE
None — every source field is compared.
- Street number (ADDRESS_NUMBER)
- Street name (LINEAR_NAME_FULL)
- Full address (ADDRESS_FULL)
- Coordinates (latitude, longitude)
- ADDRESS_POINT_ID
- ADDRESS_STATUS
- GENERAL_USE
- GENERAL_USE_CODE
- LINEAR_NAME_DESC
- MAINT_STAGE
- MUNICIPALITY
- MUNICIPALITY_NAME
- PLACE_NAME
- PLACE_NAME_ALL
- WARD
- WARD_NAME
- ADDRESS_CLASS
- ADDRESS_CLASS_DESC
- ADDRESS_ID
- ADDRESS_ID_LINK
- ADDRESS_POINT_ID_LINK
- ADDRESS_STRING_ID
- CENTRELINE_ID
- CENTRELINE_MEASURE
- CENTRELINE_OFFSET
- CENTRELINE_SIDE
- CLASS_FAMILY
- CLASS_FAMILY_DESC
- HI_NUM
- HI_NUM_SUF
- LINEAR_NAME
- LINEAR_NAME_DIR
- LINEAR_NAME_ID
- LINEAR_NAME_TYPE
- LO_NUM
- LO_NUM_SUF
- Street name (STREET_NM)
- Full address (CIVIC_ADDR)
- Coordinates (latitude, longitude)
- ADDRESS_ID
- LATITUDE
- LONGITUDE
- OBJECTID_1
- SEGMENT_ID
- WARD
None — every source field is compared.
- Street number (street_address)
- Street name (street_name)
- Unit (unit_number)
- Full address (Address)
- Coordinates (latitude, longitude)
- AmandaArea
- Depth
- Frontage
- Legal1
- Legal2
- Legal3
- PROP_RSN
- PropCode
- RollNumber
- Ward
- Zoning
- gisid
- propertyrsn
- roll_number
- street_direction
- street_name_alias
- street_suffix
- created_date
- created_user
- last_edited_date
- last_edited_user
- Street number (STREET_NUMBER)
- Street name (STREET_NAME)
- Unit (STREET_UNIT_NUMBER)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- CIVIC_ADDRESS_TYPE
- PLACE_NAME
- POSTAL_CODE
- PROVINCE
- STREET_DIRECTION_PREFIX
- STREET_DIRECTION_SUFFIX
- STREET_NUMBER_ALPHA
- STREET_TYPE
- CREATED_DATE
- EDITED_DATE
- Street number (AddrNum)
- Street name (RoadName)
- Unit (Unit)
- Full address (CivicAddress)
- Coordinates (latitude, longitude)
- ARN
- Municipality
None — every source field is compared.
- Street number (STREETNUM)
- Street name (STREETNAME)
- Full address (FULLADDY)
- Coordinates (latitude, longitude)
- EASTINGX
- ID
- LATITUDEY
- LONGITUDEX
- NORTHINGY
None — every source field is compared.
- Street number (StrNUM)
- Street name (StrFULL)
- Unit (StrUNIT)
- Full address (StrNUM_StrFULL)
- Coordinates (latitude, longitude)
- ARN
- Condition
- MUNI
- StrNum2
- x
- y
None — every source field is compared.
- Street number (StreetNumber)
- Street name (StreetName)
- Unit (UnitNumber)
- Full address (Location)
- Coordinates (latitude, longitude)
- Municipality
- Qualifier
- UpperNumber
- Verified
- EditDate
- Street number (House_No)
- Street name (Rd_Name)
- Unit (Unit)
- Full address (Full_Add)
- Coordinates (latitude, longitude)
- ADDRESS_NU
- GISCODE
- House_Suf
- LAT
- LONG
- Landmark_Name
- MUNICIPALI
- OBJECTID_12
- Rd_Dir
- Rd_Suf
- RnoTXT2
- STREET_NAM
- UNIQUE_ID
- UNIT_NUM
- UNIT_TYPE
- X
- Y
- DateEdit
- Street number (StreetNumber)
- Street name (StreetName)
- Unit (Unit)
- Full address (FullAddress)
- Coordinates (latitude, longitude)
- A3
- AddNum_Suf
- Add_Number
- FullAddress_Mun
- HuronID
- Mun
- St_Name
- St_PosDir
- St_PosTyp
- St_PreSep
- St_PreTyp
- DateUpdate
- Street number (STNUM)
- Street name (STNAME)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- CITY
- MUNICIPALITY
- STDIR
- STDIR_A
- STTYPE
- STTYPE_A
- UPDATED
- Street number (Number)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- ADD_LABEL
- BELL_MUNIC
- GlobalID_1
None — every source field is compared.
- Street number (ADDRNUM)
- Street name (FULLNAME)
- Full address (FULLADDR)
- Coordinates (latitude, longitude)
- AddressCla
- MUNICIPALI
- PLACENAME
- SITEADDID
None — every source field is compared.
- Street number (Add_Number)
- Street name (St_Name)
- Unit (Unit)
- Full address (Full_Address)
- Coordinates (latitude, longitude)
- A1
- A2
- A3
- A4
- ADDRRANGE
- AddNum_Cmp
- AddNum_Suf
- CAPTUREMETH
- Comment
- Country
- DiscrpAgID
- Effective
- Latitude
- Longitude
- NGUID
- POINTTYPE
- Placement
- RollNumber
- STATUS
- Site
- St_PosDir
- St_PosTyp
- St_PreDir
- St_PreTyp
- SubSite
- UnitPreTyp
- UnitValue
- DateUpdate
- Street number (Address)
- Street name (WC_FullNam)
- Unit (Unit)
- Coordinates (latitude, longitude)
- Municipality
- RoadClass
- UrbanCentre
- WC_Dir
- WC_Name
- WC_Number
- WC_Prefix
- WC_Sign
- WC_Suffix
None — every source field is compared.
- Street number (StreetNumber)
- Street name (StreetName)
- Unit (StreetUnit)
- Full address (Location)
- Coordinates (latitude, longitude)
- Municipality
- PropertyNum
- StreetAlias
- StreetQual
None — every source field is compared.
- Street number (ADDRESS_NUMBER)
- Street name (STREET_NAME)
- Full address (BASE_ADDRESS)
- Coordinates (latitude, longitude)
- ADDRESS_ID
- COMMUNITY_NAME
- COMMUNITY_TYPE
- GISID
- STREET_DIR
None — every source field is compared.
- Street number (CIVIC_NUM)
- Street name (ROAD_NAME)
- Unit (UNIT_NUM)
- Coordinates (latitude, longitude)
- CIVIC_SFX
- DIR_SHORT
- MUNICIPALITY
- MXADDRESSCODE
- MXCREATIONSTATE
- MXORGID
- POSTAL_CODE
- REGION_ID
- ROAD_DIR
- ROAD_TYPE
- TOWN
- TYPE_SHORT
- UNIT
- UNIT_RANGE
- UNIT_TYPE
- EDIT_DATE
- Street number (STREETNUM)
- Street name (STREETNAME)
- Unit (UNIT_IDENTIFIER)
- Coordinates (latitude, longitude)
- HOUSESTYLE
- LANDUSE
- LATITUDE
- LINK_ID
- LONGITUDE
- MUNICIPALITY
- ROPADRID
- SIDE_OF_RD
- STREETDIRECTION
- STREETTYPE
- WARD
None — every source field is compared.
- Street number (ADDRESS_NUMBER)
- Street name (FULL_STREET_NAME)
- Unit (SUITE_NUMBER)
- Full address (FULL_CIVIC_ADDR)
- Coordinates (latitude, longitude)
- ADDRS_PNT_TYPE
- ADD_NUM_SUFFIX
- COUNTRY
- LIFESTATUS
- MAIL_ADDRESS_NUMBER
- MAIL_ADDRESS_NUMBER_SUFFIX
- MAIL_COMMUNITY_NAME
- MAIL_FULL_ADDRESS_TEXT
- MAIL_POSTAL_CODE
- MAIL_PROVINCE
- MAIL_STATUS
- MAIL_STREET_NAME
- MAIL_STREET_TYPE
- MAIL_SUITE_NUMBER
- MAIL_UNIT_DESIGNATOR
- MUNICIPALITY
- PARID
- PNT_GIS_ID
- PREFIX_DIRECTION
- PREFIX_TYPE
- PRO_DATE
- STREET_NAME
- STREET_NAME_ID
- STREET_TYPE
- SUFFIX_DIRECTION
- UNIT_DESIGNATOR
- CREATE_DATE
- MODDATE
- Street number (ADDRESS_NUM)
- Street name (STREET_NAME)
- Unit (UNIT_NUMBER)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- ADU
- ADU_UNIT_NO
- ASSIGNED_BY
- Address_ID
- BLOCK
- DESCRIPTION
- DISPLAY_NAME
- GEOSTNAME
- HISTORY
- LABEL_ANGLE
- LOT
- POLL
- PROP_RSN
- STATUS
- STREET_TYPE
- ST_DIR_SUFFIX
- SUBDIVISION_PLAN
- WARD
None — every source field is compared.
- Street number (STREET_NUM)
- Street name (SNAME)
- Unit (UNIT)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- LABEL
- STREET_DIR
- STREET_NAME
- STREET_TYPE
- SUFFIX
- created_date
- created_user
- last_edited_date
- last_edited_user
- Street number (CIVICNUM)
- Street name (STREET)
- Unit (UNITNUM)
- Full address (ADDRESSAGOL)
- Coordinates (latitude, longitude)
- ADDRESS911
- ARN
- GEOTOWNSHP
- Id
- LABEL
- MUN
- OBJECTID_1
- OWNER
- REFORMLOC
- TYPE
None — every source field is compared.
- Street number (Address_Nu)
- Street name (Street_Nam)
- Unit (UnitNum)
- Full address (LabelFull)
- Coordinates (latitude, longitude)
- Civic_Num
- EmilyProj
- Label
- Municipali
- SDGCivicID
- Settlement
- StrNamAlia
- Unique_ID
- Unit_Type
- AddDate
- EditDate