File Information

Waterloo Region Addresses

ESRI harvest from utility.arcgis.com

ESRI_HARVEST Uploaded Oct 11, 2025 at 7:28 PM
Dataset Information
No Information Available

No additional information has been provided for this dataset.

Waterloo Region Addresses
259515 records
Advanced Filters
Quick Tips:
• Use Ctrl+F to focus search
• Use Ctrl+Shift+F to toggle filters
• Combine multiple filters for precise results
Operators:
Between for ranges (e.g., 10,100)
Regex for pattern matching
Case sensitive for exact matches
Showing all 259515 records
ID Feature ID Geometry Type AddressNumber AddressPointType CreatedDate FullAddress FullAddressWithSettlement FullStreetName GlobalID IsPrimary LastEditDate Municipality OBJECTID Settlement UnitNumber UnitType
244951 252074 Point 59 Building 1670356326000 1-59 Bruce St 1-59 Bruce St, Kitchener Bruce St {5BE5C0C7-1843-4799-A771-037C9B5589F8} No 1707488139000 Kitchener 252074 Kitchener 1 Unit
244952 252092 Point 39 Building 1670357782000 B-39 Kent Ave B-39 Kent Ave, Kitchener Kent Ave {94477489-0141-4220-9D14-CABDB4696822} No 1670357805000 Kitchener 252092 Kitchener B Unit
244953 252094 Point 274 Building 1670357844000 274 Krug St 274 Krug St, Kitchener Krug St {1F0D0D80-3C92-46E8-A0C8-ED79873F3276} Yes 1686843449000 Kitchener 252094 Kitchener - -
244954 252096 Point 135 Building 1670358064000 135 Rosenberg Way 135 Rosenberg Way, Kitchener Rosenberg Way {BE374597-60DC-4CBA-B1C5-C607794CD329} Yes 1689622549000 Kitchener 252096 Kitchener - -
244955 252107 Point 1673 Multiple 1670353157000 A-1673 Huron Rd A-1673 Huron Rd, Kitchener Huron Rd {38A6FCD9-72D2-4FD1-89D7-54DCB26723F7} No 1715365533000 Kitchener 252107 Kitchener A Apartment
244956 252123 Point 139 Building 1670358064000 139 Rosenberg Way 139 Rosenberg Way, Kitchener Rosenberg Way {F5EF9F6E-F823-46FF-9CA7-B7C71CC5E860} Yes 1689622549000 Kitchener 252123 Kitchener - -
244957 252127 Point 39 Building 1670357782000 A-39 Kent Ave A-39 Kent Ave, Kitchener Kent Ave {6335FF02-417F-461A-9012-B8C7F7BBEF42} No 1670357805000 Kitchener 252127 Kitchener A Unit
244958 252128 Point 57 Building 1670356251000 2-57 Bruce St 2-57 Bruce St, Kitchener Bruce St {10ABC0D9-84C4-473B-8076-0DB3DCE0425A} No 1707488183000 Kitchener 252128 Kitchener 2 Unit
244959 252133 Point 273 Building 1670356564000 1-273 Hartwood Ave 1-273 Hartwood Ave, Kitchener Hartwood Ave {6E0D13C5-2E10-48B5-A01E-02E110D7F88A} No 1676493152000 Kitchener 252133 Kitchener 1 Apartment
244960 252148 Point 271 Building 1670356599000 2-271 Hartwood Ave 2-271 Hartwood Ave, Kitchener Hartwood Ave {52388E80-B00A-4976-9882-D59F60B24E12} No 1676493152000 Kitchener 252148 Kitchener 2 Apartment
244961 252149 Point 77 Multiple 1670353352000 7-77 Lancaster St W 7-77 Lancaster St W, Kitchener Lancaster St W {E4C6A15D-F168-4437-9797-9880F6D2D44B} No 1670353365000 Kitchener 252149 Kitchener 7 Unit
244962 252154 Point 1673 Multiple 1670353157000 C-1673 Huron Rd C-1673 Huron Rd, Kitchener Huron Rd {45434B9A-6D1F-45E2-9AB1-CB88594122E3} No 1686794734000 Kitchener 252154 Kitchener C Apartment
244963 252158 Point 1673 Multiple 1670353157000 B-1673 Huron Rd B-1673 Huron Rd, Kitchener Huron Rd {F3E44825-C00D-48FF-97C0-7460F3A69E1A} No 1686794616000 Kitchener 252158 Kitchener B Apartment
244964 252168 Point 57 Building 1670356251000 1-57 Bruce St 1-57 Bruce St, Kitchener Bruce St {83609F66-4686-4C83-9BCC-8EC1C37F46E1} No 1707488183000 Kitchener 252168 Kitchener 1 Unit
244965 252181 Point 1700 Building 1670358094000 1700 Strasburg Rd 1700 Strasburg Rd, Kitchener Strasburg Rd {1FC2331A-0E9E-4A62-B66B-85B13A223780} Yes 1670358094000 Kitchener 252181 Kitchener - -
244966 252182 Point 271 Building 1670356599000 1-271 Hartwood Ave 1-271 Hartwood Ave, Kitchener Hartwood Ave {2BD4FBEC-8D96-4D30-B6E8-2FEBB0E93FA5} No 1676493152000 Kitchener 252182 Kitchener 1 Apartment
244967 252183 Point 143 Building 1670358064000 143 Rosenberg Way 143 Rosenberg Way, Kitchener Rosenberg Way {34BEEF5D-5692-4485-B26D-445157D1D736} Yes 1689622550000 Kitchener 252183 Kitchener - -
244968 252184 Point 86 Multiple 1670944006000 B-86 Captain McCallum Dr B-86 Captain McCallum Dr, New Hamburg Captain McCallum Dr {E2545772-B5A7-4AD6-B43C-66F2C13095DD} No 1671033621000 Wilmot 252184 New Hamburg B -
244969 252185 Point 86 Multiple 1670943841000 A-86 Captain McCallum Dr A-86 Captain McCallum Dr, New Hamburg Captain McCallum Dr {7150828F-BC2C-4E6E-AE5E-6895EB764A13} No 1671033634000 Wilmot 252185 New Hamburg A -
244970 252186 Point 14 Building 1671035137000 14 Mary Watson St 14 Mary Watson St, Ayr Mary Watson St {B2EB7976-2095-48DB-A1AD-2B7429C1ECCA} Yes 1671035345000 North Dumfries 252186 Ayr - -
244971 252187 Point 34 Building 1671036111000 34 Robert Wylie St 34 Robert Wylie St, Ayr Robert Wylie St {A57CD348-63A9-4BC1-9260-A6BF20F1453B} Yes 1671036204000 North Dumfries 252187 Ayr - -
244972 252188 Point 46 Building 1671036388000 46 John Carpenter Rd 46 John Carpenter Rd, Ayr John Carpenter Rd {F97D2067-DD3B-43AB-BB7C-81F779A6AC6F} Yes 1671036555000 North Dumfries 252188 Ayr - -
244973 252189 Point 461 Building 1671042620000 461 Robert Woolner St 461 Robert Woolner St, Ayr Robert Woolner St {9B629985-9132-4FB3-893A-D140CD76CD22} Yes 1674136252000 North Dumfries 252189 Ayr - -
244974 252190 Point 220 Building 1671034587000 220 Leslie Davis St 220 Leslie Davis St, Ayr Leslie Davis St {2CEE51EC-2D49-45C9-8BAF-04D14551C7DB} Yes 1671034682000 North Dumfries 252190 Ayr - -
244975 252191 Point 208 Building 1671034583000 208 Leslie Davis St 208 Leslie Davis St, Ayr Leslie Davis St {26A8475C-4453-4AC5-93F0-266C6AD7D51E} Yes 1671034681000 North Dumfries 252191 Ayr - -
244976 252192 Point 209 Building 1671034385000 209 Leslie Davis St 209 Leslie Davis St, Ayr Leslie Davis St {FC6236EE-33B6-4ADB-AF5B-00EB382B0D01} Yes 1671034496000 North Dumfries 252192 Ayr - -
244977 252193 Point 33 Building 1671035174000 33 Mary Watson St 33 Mary Watson St, Ayr Mary Watson St {C8F81706-B524-4B90-93B9-D5F77044E3D5} Yes 1671035568000 North Dumfries 252193 Ayr - -
244978 252194 Point 50 Building 1671035152000 50 Mary Watson St 50 Mary Watson St, Ayr Mary Watson St {8F718D90-4901-4C5C-908D-D2DFF57445C1} Yes 1671035405000 North Dumfries 252194 Ayr - -
244979 252195 Point 37 Building 1671035177000 37 Mary Watson St 37 Mary Watson St, Ayr Mary Watson St {91F6F7DF-054A-4251-BFFF-8405CCA2699B} Yes 1671035577000 North Dumfries 252195 Ayr - -
244980 252196 Point 30 Building 1671036111000 30 Robert Wylie St 30 Robert Wylie St, Ayr Robert Wylie St {7DA310E1-4343-4D30-A331-52AD3E0B2BE1} Yes 1671036200000 North Dumfries 252196 Ayr - -
244981 252197 Point 465 Building 1671042621000 465 Robert Woolner St 465 Robert Woolner St, Ayr Robert Woolner St {9625E510-8F94-45C4-ACA4-1165415CE323} Yes 1674136252000 North Dumfries 252197 Ayr - -
244982 252198 Point 18 Building 1671036376000 18 John Carpenter Rd 18 John Carpenter Rd, Ayr John Carpenter Rd {4E7F2FC8-2C41-418D-A61D-3EB9C180F250} Yes 1671036509000 North Dumfries 252198 Ayr - -
244983 252199 Point 22 Building 1671035141000 22 Mary Watson St 22 Mary Watson St, Ayr Mary Watson St {A1297DAE-8AF7-4272-8707-907DFACF7C2A} Yes 1671035355000 North Dumfries 252199 Ayr - -
244984 252200 Point 46 Building 1671036935000 46 Thomas Gemmell Rd 46 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {065E0845-1D74-43C4-B6E8-F21639A55FF2} Yes 1671037045000 North Dumfries 252200 Ayr - -
244985 252201 Point 462 Building 1671042405000 462 Robert Woolner St 462 Robert Woolner St, Ayr Robert Woolner St {891FC78C-217D-4B53-A707-3DCDA22A6D98} Yes 1674136280000 North Dumfries 252201 Ayr - -
244986 252202 Point 29 Building 1671036697000 29 John Carpenter Rd 29 John Carpenter Rd, Ayr John Carpenter Rd {A7E2D349-134A-4CA9-AC72-85F47246E821} Yes 1671036758000 North Dumfries 252202 Ayr - -
244987 252203 Point 58 Building 1671035156000 58 Mary Watson St 58 Mary Watson St, Ayr Mary Watson St {8B0D386A-C2EF-44FD-86C0-15A4D89C4094} Yes 1671035418000 North Dumfries 252203 Ayr - -
244988 252204 Point 181 Building 1671034316000 181 Leslie Davis St 181 Leslie Davis St, Ayr Leslie Davis St {2B919B89-94C9-41AA-BB1C-F66F5FC6D842} Yes 1671034425000 North Dumfries 252204 Ayr - -
244989 252205 Point 9 Building 1671033520000 9 Cochran Dr 9 Cochran Dr, North Dumfries Cochran Dr {38FE8106-2DA5-406B-9453-7EC668852B75} Yes 1671033545000 North Dumfries 252205 North Dumfries - -
244990 252206 Point 233 Building 1671034401000 233 Leslie Davis St 233 Leslie Davis St, Ayr Leslie Davis St {86A7ED06-1063-423F-BCAE-3F0EDFA56F3C} Yes 1671034541000 North Dumfries 252206 Ayr - -
244991 252207 Point 74 Building 1671036406000 74 John Carpenter Rd 74 John Carpenter Rd, Ayr John Carpenter Rd {85E49003-CC4F-4799-88E9-16A535C90D7E} Yes 1671036639000 North Dumfries 252207 Ayr - -
244992 252208 Point 49 Building 1671036716000 49 John Carpenter Rd 49 John Carpenter Rd, Ayr John Carpenter Rd {A7C07BDE-6FB2-4063-921B-FB37358768FE} Yes 1671036799000 North Dumfries 252208 Ayr - -
244993 252209 Point 37 Building 1671201426000 4-37 Brubacher St 4-37 Brubacher St, Baden Brubacher St {A813C9F9-D336-44E0-92B5-D815489EEFD6} No 1671201991000 Wilmot 252209 Baden 4 Townhouse
244994 252210 Point 65 Building 1671035193000 65 Mary Watson St 65 Mary Watson St, Ayr Mary Watson St {D88B4C93-0B29-419C-A206-910189BB0AB8} Yes 1671035630000 North Dumfries 252210 Ayr - -
244995 252211 Point 21 Building 1671035169000 21 Mary Watson St 21 Mary Watson St, Ayr Mary Watson St {ED23BF8A-E77D-4453-9453-AEC143EDEBC6} Yes 1671035547000 North Dumfries 252211 Ayr - -
244996 252212 Point 77 Building 1671035199000 77 Mary Watson St 77 Mary Watson St, Ayr Mary Watson St {133BDEED-1333-4DEC-AD90-5F0483F67699} Yes 1671035661000 North Dumfries 252212 Ayr - -
244997 252213 Point 61 Building 1671036716000 61 John Carpenter Rd 61 John Carpenter Rd, Ayr John Carpenter Rd {6E7FC656-E9E7-43E6-AA40-1C84098FE504} Yes 1671036829000 North Dumfries 252213 Ayr - -
244998 252214 Point 33 Building 1671036697000 33 John Carpenter Rd 33 John Carpenter Rd, Ayr John Carpenter Rd {72761C08-F826-469F-951F-271293268868} Yes 1671036764000 North Dumfries 252214 Ayr - -
244999 252215 Point 38 Building 1671035147000 38 Mary Watson St 38 Mary Watson St, Ayr Mary Watson St {09A0CBC5-E55F-4DA1-8666-EDB7A83D4550} Yes 1671035382000 North Dumfries 252215 Ayr - -
245000 252216 Point 50 Building 1671036391000 50 John Carpenter Rd 50 John Carpenter Rd, Ayr John Carpenter Rd {E2002D04-9238-4B50-8865-2A95FC446320} Yes 1671036567000 North Dumfries 252216 Ayr - -
245001 252217 Point 13 Building 1671035743000 13 Robert Wylie St 13 Robert Wylie St, Ayr Robert Wylie St {60EBD058-1C63-4640-A0F5-F8128F29B602} Yes 1671035839000 North Dumfries 252217 Ayr - -
245002 252218 Point 49 Building 1671035762000 49 Robert Wylie St 49 Robert Wylie St, Ayr Robert Wylie St {FE62EE6A-D8B1-4CEA-9EDD-6B37C2DA4187} Yes 1671035901000 North Dumfries 252218 Ayr - -
245003 252219 Point 470 Building 1671042402000 470 Robert Woolner St 470 Robert Woolner St, Ayr Robert Woolner St {56555274-CDDD-4124-8965-DB69EDA6C373} Yes 1674136280000 North Dumfries 252219 Ayr - -
245004 252220 Point 458 Building 1671042406000 458 Robert Woolner St 458 Robert Woolner St, Ayr Robert Woolner St {451E0AFC-4E94-4247-8CA2-67EA15E455DE} Yes 1674136280000 North Dumfries 252220 Ayr - -
245005 252221 Point 62 Building 1671036397000 62 John Carpenter Rd 62 John Carpenter Rd, Ayr John Carpenter Rd {A2848517-1A1C-460E-B284-A89161316D54} Yes 1671036621000 North Dumfries 252221 Ayr - -
245006 252222 Point 57 Building 1671036716000 57 John Carpenter Rd 57 John Carpenter Rd, Ayr John Carpenter Rd {6C51F969-4CB5-4455-9AC1-419FF5B4D989} Yes 1671036823000 North Dumfries 252222 Ayr - -
245007 252223 Point 21 Building 1671035746000 21 Robert Wylie St 21 Robert Wylie St, Ayr Robert Wylie St {1CDE797E-AADB-4E79-BA46-BF3C4B7B49F6} Yes 1671035853000 North Dumfries 252223 Ayr - -
245008 252224 Point 37 Building 1671201522000 10-37 Brubacher St 10-37 Brubacher St, Baden Brubacher St {5B22EEFA-FA8F-44D1-901F-E93AD99FBCA2} No 1671201991000 Wilmot 252224 Baden 10 Townhouse
245009 252225 Point 30 Building 1671035144000 30 Mary Watson St 30 Mary Watson St, Ayr Mary Watson St {805A4D7C-F0AD-4CBA-804F-AB97CD60F8D5} Yes 1671035371000 North Dumfries 252225 Ayr - -
245010 252226 Point 22 Building 1671036923000 22 Thomas Gemmell Rd 22 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {CD238687-576C-4CC4-A763-8182EB53A9E5} Yes 1671037009000 North Dumfries 252226 Ayr - -
245011 252227 Point 41 Building 1671035759000 41 Robert Wylie St 41 Robert Wylie St, Ayr Robert Wylie St {F93A5CAC-BD26-4F8A-9D51-B9369539E394} Yes 1671035888000 North Dumfries 252227 Ayr - -
245012 252228 Point 212 Building 1671034584000 212 Leslie Davis St 212 Leslie Davis St, Ayr Leslie Davis St {01B4CAD6-8C9C-4B4A-90A6-80DB3B9CE123} Yes 1671034681000 North Dumfries 252228 Ayr - -
245013 252229 Point 216 Building 1671034585000 216 Leslie Davis St 216 Leslie Davis St, Ayr Leslie Davis St {0AA9B585-D281-4014-9181-C00A72EE9E81} Yes 1671034682000 North Dumfries 252229 Ayr - -
245014 252230 Point 9 Building 1671035741000 9 Robert Wylie St 9 Robert Wylie St, Ayr Robert Wylie St {A9C0A391-F282-4769-89DA-A39D2198A53A} Yes 1671035833000 North Dumfries 252230 Ayr - -
245015 252231 Point 29 Building 1671035750000 29 Robert Wylie St 29 Robert Wylie St, Ayr Robert Wylie St {ECB7F927-C9F3-4224-B8DD-77B306E7136C} Yes 1671035867000 North Dumfries 252231 Ayr - -
245016 252232 Point 61 Building 1671035191000 61 Mary Watson St 61 Mary Watson St, Ayr Mary Watson St {28124345-381D-4A2A-8D91-08FE9AEAD5A8} Yes 1671035623000 North Dumfries 252232 Ayr - -
245017 252233 Point 86 Building 1671036411000 86 John Carpenter Rd 86 John Carpenter Rd, Ayr John Carpenter Rd {0939BDD5-D3E8-4EB4-8EA5-D3B9777048A1} Yes 1671036660000 North Dumfries 252233 Ayr - -
245018 252234 Point 65 Building 1671036716000 65 John Carpenter Rd 65 John Carpenter Rd, Ayr John Carpenter Rd {4D8CFB8A-722E-49C2-9A31-E248F4F5164D} Yes 1671036836000 North Dumfries 252234 Ayr - -
245019 252235 Point 37 Building 1671201471000 7-37 Brubacher St 7-37 Brubacher St, Baden Brubacher St {BCD3227D-400A-4BDB-AAE6-FED0AA12A6A0} No 1671201991000 Wilmot 252235 Baden 7 Townhouse
245020 252236 Point 2 Building 1671035133000 2 Mary Watson St 2 Mary Watson St, Ayr Mary Watson St {3E9605D8-78A9-4944-89FE-5D3FF08E849F} Yes 1671035329000 North Dumfries 252236 Ayr - -
245021 252237 Point 46 Building 1671036125000 46 Robert Wylie St 46 Robert Wylie St, Ayr Robert Wylie St {F14F8461-A9E0-4A65-A7F8-4C571FCA4BE6} Yes 1671036280000 North Dumfries 252237 Ayr - -
245022 252238 Point 37 Building 1671036697000 37 John Carpenter Rd 37 John Carpenter Rd, Ayr John Carpenter Rd {701D7AFF-2518-4F8C-B974-E5C000C7C832} Yes 1671036769000 North Dumfries 252238 Ayr - -
245023 252239 Point 54 Building 1671036125000 54 Robert Wylie St 54 Robert Wylie St, Ayr Robert Wylie St {CC63C468-B117-4499-B60D-86C98415E3F9} Yes 1671036289000 North Dumfries 252239 Ayr - -
245024 252240 Point 193 Building 1671034378000 193 Leslie Davis St 193 Leslie Davis St, Ayr Leslie Davis St {109BD988-8154-4D31-8865-C9955304DE3A} Yes 1671034461000 North Dumfries 252240 Ayr - -
245025 252241 Point 10 Building 1671036918000 10 Thomas Gemmell Rd 10 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {7A4F59D8-22F9-491E-A315-3343BF7378E5} Yes 1671036995000 North Dumfries 252241 Ayr - -
Showing 244951 to 245025 of 259515 records
Loading...
Loading Map...
Preparing spatial data visualization
Data Analysis
Chart Options
Export Spatial Data
CSV Export

Download data as a comma-separated values file with coordinates and properties.

Download CSV
GeoJSON Export

Download data in GeoJSON format, compatible with most GIS applications.

Download GeoJSON
KML Export

Download data in KML format for use with Google Earth and other mapping applications.

Download KML
Shapefile Export

Download data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.

Download Shapefile
Export Information
  • CSV: Contains coordinates and all properties in a tabular format
  • GeoJSON: Standard format for web mapping and GIS applications
  • KML: Compatible with Google Earth, Google Maps, and other mapping platforms
  • Shapefile: Industry standard format for GIS software (requires GDAL/ogr2ogr)
Export Details
Total Features: 259515
File Name: Waterloo Region Addresses
Original Type: ESRI_HARVEST
Properties: 14 fields

Note: Shapefile export requires GDAL/ogr2ogr to be installed on the server. If unavailable, a GeoJSON file will be provided instead. Check your server's error logs for more details.
API Endpoints
Dataset Details

Get detailed information about this dataset including metadata and available properties.

Test Endpoint
Query Data

Query spatial data with filtering, pagination, and spatial operations.

Test Endpoint
Query Parameters
Pagination
  • page - Page number (default: 1)
  • limit - Results per page (max: 1000, default: 100)
Property Filtering
  • properties - JSON object for property filtering
  • geometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)
Spatial Filtering
  • bbox - Bounding box (minX,minY,maxX,maxY)
  • lat - Center latitude for radius search
  • lon - Center longitude for radius search
  • radius - Search radius in meters
Response Format
  • Returns GeoJSON FeatureCollection
  • Includes pagination metadata
  • Contains query information
Example Queries
Basic Queries
Advanced Queries
API Information
Base URL: https://tor.datacatalog.ca//api.php
Dataset ID: 709
Total Features: 259515
Response Format: GeoJSON

Note: All API endpoints return JSON responses. The query endpoint returns GeoJSON FeatureCollection format for spatial data.
Rate Limiting: Consider implementing rate limiting for production use to prevent abuse.
Spatial Data Metadata
Basic Information
Not specified
Not specified
Not specified
Not specified
Not specified
Not specified
Not specified
Technical Information
Not specified
Not specified
Not specified
Not specified
Not specified
Not specified
Citation Information
Not specified
Not specified
Not specified
Not specified
Temporal Information
Not specified
Not specified
Not specified
Metadata Contact
Not specified
Not specified
Not specified
Not specified
Data Quality
Not specified
Not specified
Not specified
Constraints
Not specified
Not specified
Not specified
Distribution
Not specified
Not specified
Not specified
Not specified
Not specified
Additional Information
Not specified
Not specified

ESRI Service Metadata

Metadata automatically harvested from the ESRI service during import.

Service Metadata ISO19139
OpenData
A map service to provide data for the Region's Open Data site.
Open Data Data Open Data Data