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
245026 252242 Point 6 Building 1671036916000 6 Thomas Gemmell Rd 6 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {5B4258A8-006F-40E5-BA24-0F1876447666} Yes 1671036989000 North Dumfries 252242 Ayr - -
245027 252243 Point 18 Building 1671036922000 18 Thomas Gemmell Rd 18 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {0D2FE360-D94D-490A-9B2C-26EE4034FF99} Yes 1671037005000 North Dumfries 252243 Ayr - -
245028 252244 Point 6 Building 1671036368000 6 John Carpenter Rd 6 John Carpenter Rd, Ayr John Carpenter Rd {767B7B26-B13C-4C22-A648-C00B5AE6F36A} Yes 1671036498000 North Dumfries 252244 Ayr - -
245029 252245 Point 5 Building 1671035739000 5 Robert Wylie St 5 Robert Wylie St, Ayr Robert Wylie St {A36EE842-9B1D-4916-A8C1-4C56BF634AFE} Yes 1671035829000 North Dumfries 252245 Ayr - -
245030 252246 Point 42 Building 1671036933000 42 Thomas Gemmell Rd 42 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {CEB5C519-3D62-4C63-8FB9-DE6C1EC1FB24} Yes 1671037040000 North Dumfries 252246 Ayr - -
245031 252247 Point 37 Building 1671201361000 2-37 Brubacher St 2-37 Brubacher St, Baden Brubacher St {04F5267E-4721-4E86-B375-BAB88802C044} No 1671201991000 Wilmot 252247 Baden 2 Townhouse
245032 252248 Point 217 Building 1671034389000 217 Leslie Davis St 217 Leslie Davis St, Ayr Leslie Davis St {A7D8F708-A670-49C2-BC76-27AF6FED5627} Yes 1671034507000 North Dumfries 252248 Ayr - -
245033 252249 Point 45 Building 1671035761000 45 Robert Wylie St 45 Robert Wylie St, Ayr Robert Wylie St {0202FCA5-2808-443A-B473-3FF07B307E27} Yes 1671035894000 North Dumfries 252249 Ayr - -
245034 252250 Point 34 Building 1671036383000 34 John Carpenter Rd 34 John Carpenter Rd, Ayr John Carpenter Rd {839AC71C-FBF2-4BD2-9C17-06B292FBA1E7} Yes 1671036537000 North Dumfries 252250 Ayr - -
245035 252251 Point 54 Building 1671035153000 54 Mary Watson St 54 Mary Watson St, Ayr Mary Watson St {C9E739E8-A2A1-4BA2-8613-34D00F5EBCB0} Yes 1671035410000 North Dumfries 252251 Ayr - -
245036 252252 Point 204 Building 1671034581000 204 Leslie Davis St 204 Leslie Davis St, Ayr Leslie Davis St {CF3EE2DF-2C9B-4ECC-B0D2-3DC9B173CABF} Yes 1671034681000 North Dumfries 252252 Ayr - -
245037 252253 Point 2 Building 1671036915000 2 Thomas Gemmell Rd 2 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {C957A86A-6959-4B27-9840-38D114BDC015} Yes 1671036985000 North Dumfries 252253 Ayr - -
245038 252254 Point 22 Building 1671036111000 22 Robert Wylie St 22 Robert Wylie St, Ayr Robert Wylie St {9CAC7BC5-019D-404E-9C5A-198B380E3EF6} Yes 1671036189000 North Dumfries 252254 Ayr - -
245039 252255 Point 13 Building 1671035167000 13 Mary Watson St 13 Mary Watson St, Ayr Mary Watson St {83D408C5-0B9B-4A29-AF1F-00E60D6F4203} Yes 1671035528000 North Dumfries 252255 Ayr - -
245040 252256 Point 38 Building 1671036384000 38 John Carpenter Rd 38 John Carpenter Rd, Ayr John Carpenter Rd {33295247-034E-44F4-9A2D-FA8EEC8A17EE} Yes 1671036543000 North Dumfries 252256 Ayr - -
245041 252257 Point 54 Building 1671036394000 54 John Carpenter Rd 54 John Carpenter Rd, Ayr John Carpenter Rd {63B34C47-8768-464E-87CE-33AD35EE264F} Yes 1671036570000 North Dumfries 252257 Ayr - -
245042 252258 Point 53 Building 1671036716000 53 John Carpenter Rd 53 John Carpenter Rd, Ayr John Carpenter Rd {4E4B1C82-376E-4684-B61E-3D7750D9A3AB} Yes 1671036817000 North Dumfries 252258 Ayr - -
245043 252259 Point 2 Building 1671036367000 2 John Carpenter Rd 2 John Carpenter Rd, Ayr John Carpenter Rd {73E9F65C-6908-4891-8CDB-9D25C572E6FC} Yes 1671036479000 North Dumfries 252259 Ayr - -
245044 252260 Point 26 Building 1671036925000 26 Thomas Gemmell Rd 26 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {96325598-5EDE-4CF8-B29D-D73E560E1BAB} Yes 1671037018000 North Dumfries 252260 Ayr - -
245045 252261 Point 22 Building 1671036378000 22 John Carpenter Rd 22 John Carpenter Rd, Ayr John Carpenter Rd {443191B0-EFAA-4B1D-ACCC-02AA5E540D9B} Yes 1671036515000 North Dumfries 252261 Ayr - -
245046 252262 Point 26 Building 1671036111000 26 Robert Wylie St 26 Robert Wylie St, Ayr Robert Wylie St {2D99A892-F8F6-4CE8-8525-0E5850C14CA1} Yes 1671036194000 North Dumfries 252262 Ayr - -
245047 252263 Point 14 Building 1671036111000 14 Robert Wylie St 14 Robert Wylie St, Ayr Robert Wylie St {25B6803E-340E-4686-8CE5-C7011558E088} Yes 1671036176000 North Dumfries 252263 Ayr - -
245048 252264 Point 26 Building 1671036379000 26 John Carpenter Rd 26 John Carpenter Rd, Ayr John Carpenter Rd {5F0454E5-5576-48D8-A081-A87AFFBBE866} Yes 1671036519000 North Dumfries 252264 Ayr - -
245049 252265 Point 37 Building 1671201500000 9-37 Brubacher St 9-37 Brubacher St, Baden Brubacher St {EC621E55-F33D-42DC-B6C7-D1E706EEB4A6} No 1671201991000 Wilmot 252265 Baden 9 Townhouse
245050 252266 Point 38 Building 1671036125000 38 Robert Wylie St 38 Robert Wylie St, Ayr Robert Wylie St {BBEA8953-7F15-4B55-837C-41EE88F0DA6A} Yes 1671036270000 North Dumfries 252266 Ayr - -
245051 252267 Point 69 Building 1671035195000 69 Mary Watson St 69 Mary Watson St, Ayr Mary Watson St {2B0D1F96-0433-4573-AFF3-7637735459DA} Yes 1671035639000 North Dumfries 252267 Ayr - -
245052 252268 Point 466 Building 1671042404000 466 Robert Woolner St 466 Robert Woolner St, Ayr Robert Woolner St {42DB8034-C0CB-4131-A2AA-5D92BEE332B3} Yes 1674136280000 North Dumfries 252268 Ayr - -
245053 252269 Point 9 Building 1671035166000 9 Mary Watson St 9 Mary Watson St, Ayr Mary Watson St {7B9A66EC-4063-425F-8994-03506605E4CA} Yes 1671035521000 North Dumfries 252269 Ayr - -
245054 252270 Point 482 Building 1671042398000 482 Robert Woolner St 482 Robert Woolner St, Ayr Robert Woolner St {C176986C-5DC4-4F75-9E8B-47DEA7B933A3} Yes 1674136280000 North Dumfries 252270 Ayr - -
245055 252271 Point 453 Building 1671042617000 453 Robert Woolner St 453 Robert Woolner St, Ayr Robert Woolner St {20AAAFC7-410D-448E-95EF-E327E59DAFC8} Yes 1674136252000 North Dumfries 252271 Ayr - -
245056 252272 Point 17 Building 1671035168000 17 Mary Watson St 17 Mary Watson St, Ayr Mary Watson St {DAE6A055-DE0A-4B46-B27C-B2F6A6522253} Yes 1671035540000 North Dumfries 252272 Ayr - -
245057 252273 Point 18 Building 1671036111000 18 Robert Wylie St 18 Robert Wylie St, Ayr Robert Wylie St {F74ECA2B-248C-4DCC-BD3A-194E66DDFC82} Yes 1671036181000 North Dumfries 252273 Ayr - -
245058 252274 Point 213 Building 1671034387000 213 Leslie Davis St 213 Leslie Davis St, Ayr Leslie Davis St {0EEAA9E6-2127-4ADA-9642-653BE4AA93CE} Yes 1671034502000 North Dumfries 252274 Ayr - -
245059 252275 Point 229 Building 1671034400000 229 Leslie Davis St 229 Leslie Davis St, Ayr Leslie Davis St {B0DCC8D4-FFF8-44F9-9ED2-9508017A6FF5} Yes 1671034531000 North Dumfries 252275 Ayr - -
245060 252276 Point 18 Building 1671035139000 18 Mary Watson St 18 Mary Watson St, Ayr Mary Watson St {72DF1F08-C8F9-4BD3-80C3-5A165A5F4182} Yes 1671035350000 North Dumfries 252276 Ayr - -
245061 252277 Point 37 Building 1671201450000 6-37 Brubacher St 6-37 Brubacher St, Baden Brubacher St {12052952-61C7-4BFD-A5CF-6A8599642A1E} No 1671201991000 Wilmot 252277 Baden 6 Townhouse
245062 252278 Point 6 Building 1671035135000 6 Mary Watson St 6 Mary Watson St, Ayr Mary Watson St {65167C8C-27D0-4720-B2A9-8B5A13044CC5} Yes 1671035335000 North Dumfries 252278 Ayr - -
245063 252279 Point 37 Building 1671201242000 37 Brubacher St 37 Brubacher St, Baden Brubacher St {147A3187-D95D-4C46-A801-E0FB41487DD2} Yes 1671201271000 Wilmot 252279 Baden - -
245064 252280 Point 70 Building 1671036404000 70 John Carpenter Rd 70 John Carpenter Rd, Ayr John Carpenter Rd {8F15BAA7-4781-4CE1-86FA-D75DBE1FDBC4} Yes 1671036635000 North Dumfries 252280 Ayr - -
245065 252281 Point 225 Building 1671034397000 225 Leslie Davis St 225 Leslie Davis St, Ayr Leslie Davis St {0C9F48D5-EFEE-400B-949C-D739174D7C0A} Yes 1671034524000 North Dumfries 252281 Ayr - -
245066 252282 Point 474 Building 1671042401000 474 Robert Woolner St 474 Robert Woolner St, Ayr Robert Woolner St {CE7AD2D0-57BD-4569-AA4F-D25D892E643D} Yes 1674136280000 North Dumfries 252282 Ayr - -
245067 252283 Point 50 Building 1671036125000 50 Robert Wylie St 50 Robert Wylie St, Ayr Robert Wylie St {5C4D40C1-0877-4F5B-ABE0-F8615E758547} Yes 1671036284000 North Dumfries 252283 Ayr - -
245068 252284 Point 185 Building 1671034369000 185 Leslie Davis St 185 Leslie Davis St, Ayr Leslie Davis St {753FBC72-E2CF-4C6D-B14C-C556C8F401EA} Yes 1671034445000 North Dumfries 252284 Ayr - -
245069 252285 Point 1 Building 1671035162000 1 Mary Watson St 1 Mary Watson St, Ayr Mary Watson St {E04B8554-48E9-45EC-B52C-11AE4D220BB2} Yes 1671035511000 North Dumfries 252285 Ayr - -
245070 252286 Point 249 Building 1671034729000 249 Leslie Davis St 249 Leslie Davis St, Ayr Leslie Davis St {99AAE0EB-D902-4FA9-9496-332DBF5938B6} Yes 1671034757000 North Dumfries 252286 Ayr - -
245071 252287 Point 33 Building 1671035755000 33 Robert Wylie St 33 Robert Wylie St, Ayr Robert Wylie St {CEAC1438-AE6B-4BCE-AFAC-1E003003E568} Yes 1671035873000 North Dumfries 252287 Ayr - -
245072 252288 Point 42 Building 1671036386000 42 John Carpenter Rd 42 John Carpenter Rd, Ayr John Carpenter Rd {19CDE028-08FE-48AB-8FAF-DD21738D31BE} Yes 1671036549000 North Dumfries 252288 Ayr - -
245073 252289 Point 25 Building 1671035171000 25 Mary Watson St 25 Mary Watson St, Ayr Mary Watson St {96F20D5C-CDCB-4326-8BCD-55FD8BED3AA2} Yes 1671035551000 North Dumfries 252289 Ayr - -
245074 252290 Point 10 Building 1671035136000 10 Mary Watson St 10 Mary Watson St, Ayr Mary Watson St {2C18372F-03C1-43A5-A372-9C3698AFAAFA} Yes 1671035340000 North Dumfries 252290 Ayr - -
245075 252291 Point 25 Building 1671036697000 25 John Carpenter Rd 25 John Carpenter Rd, Ayr John Carpenter Rd {996E43E2-DB8B-4B8F-9774-12CDFCFFDAED} Yes 1671036752000 North Dumfries 252291 Ayr - -
245076 252292 Point 37 Building 1671201486000 8-37 Brubacher St 8-37 Brubacher St, Baden Brubacher St {1A3A3BE2-00A3-4B19-AFDF-D738CC3C8B95} No 1671201991000 Wilmot 252292 Baden 8 Townhouse
245077 252293 Point 14 Building 1671036921000 14 Thomas Gemmell Rd 14 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {E5D8F9A7-903C-4CF1-9B9D-8B08A1B4FB00} Yes 1671037001000 North Dumfries 252293 Ayr - -
245078 252294 Point 221 Building 1671034393000 221 Leslie Davis St 221 Leslie Davis St, Ayr Leslie Davis St {8A96A340-9483-4355-AA99-35A9CE40C22E} Yes 1671034518000 North Dumfries 252294 Ayr - -
245079 252295 Point 37 Building 1671201543000 11-37 Brubacher St 11-37 Brubacher St, Baden Brubacher St {472FFC42-DF7B-4C97-BFC8-81C54D023CAF} No 1671201991000 Wilmot 252295 Baden 11 Townhouse
245080 252296 Point 200 Building 1671034579000 200 Leslie Davis St 200 Leslie Davis St, Ayr Leslie Davis St {3EED9C8B-7F12-449C-AB7B-DE5C46096838} Yes 1671034681000 North Dumfries 252296 Ayr - -
245081 252297 Point 449 Building 1671042615000 449 Robert Woolner St 449 Robert Woolner St, Ayr Robert Woolner St {2EE22FCE-478E-4BC9-AC48-482775FFFE37} Yes 1674136251000 North Dumfries 252297 Ayr - -
245082 252298 Point 29 Building 1671035173000 29 Mary Watson St 29 Mary Watson St, Ayr Mary Watson St {6DF6E1BB-8136-4079-A30C-6B01C24AFF86} Yes 1671035563000 North Dumfries 252298 Ayr - -
245083 252299 Point 30 Building 1671036381000 30 John Carpenter Rd 30 John Carpenter Rd, Ayr John Carpenter Rd {E3F1D6FF-E6B0-40A9-9BD5-FFCF476B7098} Yes 1671036524000 North Dumfries 252299 Ayr - -
245084 252300 Point 90 Building 1671036413000 90 John Carpenter Rd 90 John Carpenter Rd, Ayr John Carpenter Rd {F359D724-761E-4DED-A75F-BE69546D029A} Yes 1671036664000 North Dumfries 252300 Ayr - -
245085 252301 Point 197 Building 1671034380000 197 Leslie Davis St 197 Leslie Davis St, Ayr Leslie Davis St {FC558873-7B8F-4409-9962-8A4AFA212EB8} Yes 1671034468000 North Dumfries 252301 Ayr - -
245086 252302 Point 478 Building 1671042400000 478 Robert Woolner St 478 Robert Woolner St, Ayr Robert Woolner St {9106DBF8-E6B4-47F0-ACDE-8B0330D34BCE} Yes 1674136280000 North Dumfries 252302 Ayr - -
245087 252303 Point 196 Building 1671034578000 196 Leslie Davis St 196 Leslie Davis St, Ayr Leslie Davis St {4842A31A-A3F5-4927-8788-312F8162C628} Yes 1671034681000 North Dumfries 252303 Ayr - -
245088 252304 Point 37 Building 1671201373000 3-37 Brubacher St 3-37 Brubacher St, Baden Brubacher St {A44E6B62-0A3F-4296-AD17-3519D9B03021} No 1671201991000 Wilmot 252304 Baden 3 Townhouse
245089 252305 Point 17 Building 1671035745000 17 Robert Wylie St 17 Robert Wylie St, Ayr Robert Wylie St {962B445B-E0F5-4A57-AA55-9BFEB520BF23} Yes 1671035846000 North Dumfries 252305 Ayr - -
245090 252306 Point 34 Building 1671036929000 34 Thomas Gemmell Rd 34 Thomas Gemmell Rd, Ayr Thomas Gemmell Rd {B041507E-985D-4F9F-A8BC-99DF723250F6} Yes 1671037029000 North Dumfries 252306 Ayr - -
245091 252307 Point 58 Building 1671036125000 58 Robert Wylie St 58 Robert Wylie St, Ayr Robert Wylie St {EBC15E64-5BF9-4090-9466-05757D2D534A} Yes 1671036293000 North Dumfries 252307 Ayr - -
245092 252308 Point 42 Building 1671035148000 42 Mary Watson St 42 Mary Watson St, Ayr Mary Watson St {224E4F42-F9F5-4CE4-A6B5-457517B90364} Yes 1671035388000 North Dumfries 252308 Ayr - -
245093 252309 Point 66 Building 1671036399000 66 John Carpenter Rd 66 John Carpenter Rd, Ayr John Carpenter Rd {45DEE376-166F-459C-A442-D33D52C5D8BF} Yes 1671036627000 North Dumfries 252309 Ayr - -
245094 252310 Point 5 Building 1671035164000 5 Mary Watson St 5 Mary Watson St, Ayr Mary Watson St {4127B09D-C076-413A-9692-44FE23138959} Yes 1671035516000 North Dumfries 252310 Ayr - -
245095 252311 Point 78 Building 1671036407000 78 John Carpenter Rd 78 John Carpenter Rd, Ayr John Carpenter Rd {F8799DF9-FE07-47D8-AF54-A493CC923DF9} Yes 1671036643000 North Dumfries 252311 Ayr - -
245096 252312 Point 201 Building 1671034382000 201 Leslie Davis St 201 Leslie Davis St, Ayr Leslie Davis St {69AFABB3-31EC-4209-995A-0E1FA6ED291F} Yes 1671034478000 North Dumfries 252312 Ayr - -
245097 252313 Point 41 Building 1671035178000 41 Mary Watson St 41 Mary Watson St, Ayr Mary Watson St {9BAA7595-1168-4804-82EB-62C99F3A2FF6} Yes 1671035586000 North Dumfries 252313 Ayr - -
245098 252314 Point 245 Building 1671034726000 245 Leslie Davis St 245 Leslie Davis St, Ayr Leslie Davis St {3F36053D-2CF0-4F58-AC71-003FC8092359} Yes 1671034757000 North Dumfries 252314 Ayr - -
245099 252315 Point 69 Building 1671036716000 69 John Carpenter Rd 69 John Carpenter Rd, Ayr John Carpenter Rd {71931F99-61E2-4A70-AA00-A39842ADF5C7} Yes 1671036842000 North Dumfries 252315 Ayr - -
245100 252316 Point 46 Building 1671035149000 46 Mary Watson St 46 Mary Watson St, Ayr Mary Watson St {844795D0-10AE-4D6E-96D1-80F5A53B130F} Yes 1671035397000 North Dumfries 252316 Ayr - -
Showing 245026 to 245100 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