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
- PARCELID
- SSTRDIR
- SSTRSUFF
- STATUS
- COMMENT
- 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_GRID
- CON_NUM
- GIS_ID
- HERITAGE
- LOT_NUM
- POSTAL_CODE
- PROP_CODE_DESC
- PROVINCE
- REG_PLAN_ASSUMP_DATE
- SEC_PLAN_AREA
- SITE_PLAN_NUMBER
- STREET_DIRECTION
- STREET_TYPE
- TOWNSHIP
- WARD
- CITY_FILE
- CONDO_PLAN_NUMBER
- C_OF_A
- DRAFT_PLAN_NUMBER
- OCCUPANCY_DATE
- PERMIT_ISSUEDATE
- PERMIT_NO
- PERMIT_TYPE
- REG_PLAN_NUMBER
- SUB_TYPE
- WORK_TYPE
- Street number (STREETNUM)
- Street name (STREETNAME)
- Full address (FULLADDRESS)
- Coordinates (latitude, longitude)
- 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
- NAME
- PROPCODE
- PROPDESC
- PROPINFOVALUE_WARD
- PROPSTATUSCODE
- PROPSTATUSDESC
- PROVINCE
- STRDIR
- STRTYPE
- UNITTYPE
- LATITUDE
- LONGITUDE
- PROPERTYRSN
- 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
- POLY_ID
- POSTAL
- PROVINCE
- STREET_LNG
- SUFFIX
- LAST_EDIT
- Street number (ADDRESSNUMBER)
- Street name (FULLSTREETNAME)
- Unit (UNIT_OR_AMENITY)
- Full address (FULLADDRESSTEXT)
- Coordinates (latitude, longitude)
- ADDRESSALIAS
- ADDRESSID
- ADDRESSLIFECYCLESTATUS
- ADDRESSNUMBERPREFIX
- ADDRESSNUMBERSUFFIX
- ALTERNATENAME1
- ALTERNATENAME2
- ALTERNATENAME3
- COMMUNITY
- NAME
- STREETSUFFIX
- STYPE
- UNIT_AMENITY_TYPE
- VERIFIED_DATE
- ASSIGNEDADDRESSID
- BASESTREETNAME
- STREETTYPE
- Street number (STREETNO)
- Street name (FULLNAME)
- Unit (UNIT_NO)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- ADDID
- ADDLOCINFO
- HAS_UNIT
- LANDMKNAME
- NAME
- PARITY
- PLACE
- POSTCODE
- QUALIFIER
- SEGMENTID
- STATUS
- STDIR
- STNAME
- STREETID
- STREETNAME
- STSUF
- WARD
- ADDID_TEXT
- ADDLEG
- AMAID
- GPID
- LABEL
- LAT
- LONG
- PIN
- ROLL_NO
- STATION_RESPONSE_ORDER
- UTM_X
- UTM_Y
- 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
- Street number (StreetNumber)
- Street name (StreetNameFull)
- Unit (UnitNumber)
- Full address (FullAddress)
- Coordinates (latitude, longitude)
- ARUApproved
- AddressID
- HwyCountyNum
- MultiUnitLot
- PlaceName
- SingleLowerTier
- StreetNameAlt
- StreetNumberPrefix
- StreetNumberSuffix
- StreetAddress
- StreetDirectionAbrv
- StreetDirectionSuffix
- StreetNameBody
- StreetNumSuffixConcat
- StreetSegmentID
- StreetTypeSuffix
- StreetTypeSuffixAbrv
- Xlong
- Ylat
- Street number (ADDRESS_NUMBER)
- Street name (STREET)
- Unit (UNIT)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- ADDRESS_ID
- ADDRESS_NUMBER_SUFFIX
- DIRECTION_SUFFIX
- ELECTORAL_DISTRICT_NAME
- GARBAGE_DAY
- MUNICIPALITY
- NEIGHBOURHOOD
- POSTAL_CODE
- RECYCLING_DAY
- COLLECTION_TYPE
- STREET_BODY_NAME
- STREET_TYPE_SUFFIX
- UNIT_TYPE
- Street number (CIVIC_NO)
- Street name (STREET)
- Unit (UNIT)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- POLL
- PROPERTY_UNIT_ID
- STATUS
- UNIT_TYPE
- WARD
- LATITUDE
- LONGITUDE
- PARCELID
- ROADSEGMENTID
- ROLL_REFERENCE
- X_COORD
- Y_COORD
- Street number (MunicipalNumber)
- Street name (FullStreetName)
- Unit (UnitNumber)
- Full address (FullAddress)
- Coordinates (latitude, longitude)
- CondoNumber
- ElectionWard
- GIS_ID
- MunicipalNumberQualifier
- Status
- StreetClassification
- FullNumber
- FullStreetName_ID
- IntegerMunicipalNumber
- StreetDirection
- StreetName
- StreetType
- UnitFullAddress
- Street number (Full_StreetNo)
- Street name (StreetName)
- Unit (Unit)
- Coordinates (latitude, longitude)
- GSmartID
- LifeCycleStatus
- Municipality
- Qualifier
- StreetDir
- StreetType
- StreetNo
- Xcoord
- Ycoord
- Street number (ADDRNUM)
- Street name (FULLNAME)
- Unit (UNITID)
- Full address (FULLADDR)
- Coordinates (latitude, longitude)
- ADDRTYPE
- PI_MUNICIPAL_ADDRESS_ID
- QUALIFIER
None — every source field is compared.
- Street number (address_nu)
- Street name (street_nam)
- Unit (unit_num)
- Full address (address)
- Coordinates (latitude, longitude)
- unit_type
- ward
- label
- lat
- long
- Street number (STNUM)
- Street name (STNAME)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- CITY
- STDIR
- STDIR_A
- STTYPE
- STTYPE_A
- TOWNSHIP
None — every source field is compared.
- Street number (ST_NUMBER)
- Street name (ST_NAME)
- Unit (UNIT)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- Address
- G_COLL
None — every source field is compared.
- Street number (ADDRESS_NUMBER)
- Street name (STREET)
- Full address (COMPLETE)
- Coordinates (latitude, longitude)
- ADDRESS
- ADDRESS_QUALIFIER
- CITY
- PCL_PIN
- PROVINCE
- REFNAME
- ROOT
- ROWTYPE
- RSN
- SPLITLOC
- TYPE
- CTB_TYPE
- Street number (ADDRESS_NUMBER)
- Street name (LINEAR_NAME_FULL)
- Full address (ADDRESS_FULL)
- Coordinates (latitude, longitude)
- ADDRESS_POINT_ID
- 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
- SEGMENT_ID
- WARD
- LATITUDE
- LONGITUDE
- 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
- JOIN_FID
- Join_Count
- TARGET_FID
- X
- Y
- 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
None — every source field is compared.
- Street number (AddrNum)
- Street name (RoadName)
- Unit (Unit)
- Full address (CivicAddress)
- Coordinates (latitude, longitude)
- Municipality
- ARN
- Street number (STREETNUM)
- Street name (STREETNAME)
- Full address (FULLADDY)
- Coordinates (latitude, longitude)
- ID
- EASTINGX
- LATITUDEY
- LONGITUDEX
- NORTHINGY
- Street number (StrNUM)
- Street name (StrFULL)
- Unit (StrUNIT)
- Full address (StrNUM_StrFULL)
- Coordinates (latitude, longitude)
- ARN
- MUNI
- StrNum2
- Condition
- x
- y
- Street number (StreetNumber)
- Street name (StreetName)
- Unit (UnitNumber)
- Full address (Location)
- Coordinates (latitude, longitude)
- Municipality
- Qualifier
- UpperNumber
- Verified
None — every source field is compared.
- Street number (House_No)
- Street name (Rd_Name)
- Unit (Unit)
- Full address (Full_Add)
- Coordinates (latitude, longitude)
- GISCODE
- House_Suf
- Landmark_Name
- MUNICIPALI
- Rd_Dir
- Rd_Suf
- UNIT_TYPE
- ADDRESS_NU
- LAT
- LONG
- OBJECTID_12
- RnoTXT2
- STREET_NAM
- UNIQUE_ID
- UNIT_NUM
- X
- Y
- Street number (StreetNumber)
- Street name (StreetName)
- Unit (Unit)
- Full address (FullAddress)
- Coordinates (latitude, longitude)
- AddNum_Suf
- Add_Number
- HuronID
- Mun
- St_Name
- St_PosDir
- St_PosTyp
- St_PreSep
- St_PreTyp
- Status
- A3
- FullAddress_Mun
- Street number (Add_Number)
- Street name (St_Name)
- Unit (Unit)
- Full address (full_add)
- Coordinates (latitude, longitude)
- AddNum_Suf
- Country
- County
- Inc_Muni
- St_PosDir
- St_PosTyp
- St_PreDir
- St_PreTyp
- activedate
- approveddate
- currentstatus
- pointtype
- province
- unitnumsuffix
None — every source field is compared.
- Street number (ADD_LABEL)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- BELL_MUNIC
- Number
None — every source field is compared.
- Street number (MUNNUMBER)
- Street name (STREET_NAM)
- Unit (UNIT)
- Full address (FULLADDRES)
- Coordinates (latitude, longitude)
- MUNCODE
- STREET_DIR
- STREET_TYP
None — every source field is compared.
- Street number (Full_AddNum)
- Unit (Unit)
- Full address (Full_Add)
- Coordinates (latitude, longitude)
- Addtl_Loc
- Inc_Muni
- Property_Number
- Latitude
- Longitude
- Street number (STNUM)
- Street name (FULLNAME)
- Unit (Unit)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- ADDRESSID
- DIR
- DIRPREF
- MUNI
- PREFIX
- STNAME
- SUFFIX
- ARN
- ChildARN
- X_COORD
- Y_COORD
- 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 (ADDR_HN)
- Street name (ADDR_SN)
- Unit (ADDR_UN)
- Full address (FullAddress)
- Coordinates (latitude, longitude)
- ADDR_PD
- ADDR_PT
- ADDR_SD
- ADDR_ST
- ADDR_UT
- EMILY_PROJECT
- IssCivic
- PCL_RN
- RANK
- Status
- TMP_PCL_RN
- ZONE_MUN
- CENTROID_X
- CENTROID_Y
- 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 (NUMBER_)
- Street name (ROAD_NAME)
- Unit (UnitNumber)
- Full address (CIVIC_ADD)
- Coordinates (latitude, longitude)
- Bell_Dir
- Bell_Name
- Bell_Suf
- CityViewID
- NGIS_RD_ID
- ROLLNUM
- TYPE
- LAT
- LONG
- Street number (CIVIC_NUM)
- Street name (ROAD_NAME)
- Unit (UNIT_NUM)
- Coordinates (latitude, longitude)
- CIVIC_SFX
- DIR_SHORT
- MUNICIPALITY
- MXADDRESSCODE
- MXCREATIONSTATE
- MXORGID
- REGION_ID
- ROAD_DIR
- ROAD_TYPE
- TOWN
- TYPE_SHORT
- UNIT
- UNIT_RANGE
- UNIT_TYPE
- POSTAL_CODE
- Street number (STREETNUM)
- Street name (STREETNAME)
- Unit (UNIT_IDENTIFIER)
- Coordinates (latitude, longitude)
- HOUSESTYLE
- LANDUSE
- LINK_ID
- MUNICIPALITY
- ROPADRID
- SIDE_OF_RD
- STREETDIRECTION
- STREETTYPE
- WARD
- LATITUDE
- LONGITUDE
- 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
- PNT_GIS_ID
- PREFIX_DIRECTION
- PREFIX_TYPE
- STREET_NAME
- STREET_NAME_ID
- STREET_TYPE
- SUFFIX_DIRECTION
- UNIT_DESIGNATOR
- PARID
- PRO_DATE
- Street number (Add_Number)
- Street name (St_Name)
- Unit (Unit)
- Coordinates (latitude, longitude)
- ADDRCLASS_pec
- AddNum_Suf
- Addtl_Loc
- Building
- CAPTUREMETH_pec
- COMMENT_pec
- Country
- County
- DiscrpAgID
- Effective
- EntrancePermitNumber
- Inc_Muni
- LandmkName
- NGUID
- POINTTYPE_pec
- Place_Type
- Placement
- SADDGUID_pec
- STATUS_pec
- St_PosTyp
- St_PreDir
- St_PreTyp
- State
None — every source field is compared.
- Street number (Add1)
- Street name (FullStName)
- Coordinates (latitude, longitude)
- ARN
- Add2
- GISID
- Municipali
- Type
None — every source field is compared.
- Street number (STR_NUM)
- Street name (STR_NAME)
- Unit (STR_UNIT)
- Full address (ADDR_FULL)
- Coordinates (latitude, longitude)
- ADDR_COMM
- ADDR_ID
- ADDR_STAT
- ADDR_TYPE
- STR_DIR
- STR_FULL
- STR_PREF
- STR_SUFF
- TOHH
- ADDRE
- ADDRN
- Latitude
- Longitude
- Street number (ADDRESS_NUM)
- Street name (STREET_NAME)
- Unit (UNIT_NUMBER)
- Full address (FULL_ADDRESS)
- Coordinates (latitude, longitude)
- ADU
- ADU_UNIT_NO
- Address_ID
- BLOCK
- DESCRIPTION
- GEOSTNAME
- HISTORY
- LOT
- POLL
- STATUS
- STREET_TYPE
- ST_DIR_SUFFIX
- SUBDIVISION_PLAN
- WARD
- ASSIGNED_BY
- DISPLAY_NAME
- LABEL_ANGLE
- PROP_RSN
- Street number (STREET_NUM)
- Street name (SNAME)
- Unit (UNIT)
- Full address (ADDRESS)
- Coordinates (latitude, longitude)
- LABEL
- STREET_DIR
- STREET_NAME
- STREET_TYPE
- SUFFIX
None — every source field is compared.
- Street number (CIVICNUM)
- Street name (STREET)
- Unit (UNITNUM)
- Full address (ADDRESSAGOL)
- Coordinates (latitude, longitude)
- ADDRESS911
- ARN
- GEOTOWNSHP
- Id
- LABEL
- MUN
- OWNER
- REFORMLOC
- TYPE
None — every source field is compared.
- Street number (CivicNumber)
- Street name (CivicAddress)
- Unit (CivicUnit)
- Full address (Civic_FullAddress)
- Coordinates (latitude, longitude)
- CODE
- Comments
- Municipality
- Questions
- Retired
- Rollnumber
- Verified
- CreationDate
- ModificationDate