Master Address Table

62,226 Berkeley addresses with APNs and coordinates

Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS

228 rows where street_name = "BERKELEY" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn

zipcode 1

  • 94704 · 228 ✖

street_type 1

street_name 1

  • BERKELEY · 228 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
184 184 184 057 204600100 2114 Berkeley Way 2114 BERKELEY WAY 2114 BERKELEY WY 2114.0 BERKELEY WY     Berkeley 94704 37.87295479646589 -122.26800428665298
368 368 368 057 205602300 1945 Berkeley Way 328 1945 BERKELEY WAY 328 1945 BERKELEY WY 1945.0 BERKELEY WY 328   Berkeley 94704 37.8728988635272 -122.27127748703688
534 534 534 057 205102700 2005 Berkeley Way D 2005 BERKELEY WAY D 2005 BERKELEY WY 2005.0 BERKELEY WY D   Berkeley 94704 37.87301017200475 -122.2704268749893
537 537 537 057 205900200 1910 Berkeley Way 1910 BERKELEY WAY 1910 BERKELEY WY 1910.0 BERKELEY WY     Berkeley 94704 37.872302906128674 -122.27245870516016
565 565 565 057 206000100 1888 Berkeley Way Apt 201 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 201 APT Berkeley 94704 37.87222175590544 -122.27384508142632
677 677 677 057 205602300 1933 Berkeley Way 1933 BERKELEY WAY 1933 BERKELEY WY 1933.0 BERKELEY WY     Berkeley 94704 37.8728988635272 -122.27127748703688
815 815 815 057 205602300 1941 Berkeley Way 1941 BERKELEY WAY 1941 BERKELEY WY 1941.0 BERKELEY WY     Berkeley 94704 37.8728988635272 -122.27127748703688
817 817 817 057 205900200 1912 Berkeley Way 1912 BERKELEY WAY 1912 BERKELEY WY 1912.0 BERKELEY WY     Berkeley 94704 37.872302906128674 -122.27245870516016
1014 1014 1014 057 205102700 2005 Berkeley Way A 2005 BERKELEY WAY A 2005 BERKELEY WY 2005.0 BERKELEY WY A   Berkeley 94704 37.87301017200475 -122.2704268749893
1283 1283 1283 057 205602300 1945 Berkeley Way 318 1945 BERKELEY WAY 318 1945 BERKELEY WY 1945.0 BERKELEY WY 318   Berkeley 94704 37.8728988635272 -122.27127748703688
1332 1332 1332 057 205103000 2017 Berkeley Way 9 2017 BERKELEY WAY 9 2017 BERKELEY WY 2017.0 BERKELEY WY 9   Berkeley 94704 37.87306930079794 -122.26996137160236
1571 1571 1571 057 206000100 1888 Berkeley Way Apt 507 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 507 APT Berkeley 94704 37.872135402819296 -122.2736785706036
1722 1722 1722 057 205103000 2017 Berkeley Way 7 2017 BERKELEY WAY 7 2017 BERKELEY WY 2017.0 BERKELEY WY 7   Berkeley 94704 37.87306930079794 -122.26996137160236
1730 1730 1730 057 205602300 1945 Berkeley Way 206 1945 BERKELEY WAY 206 1945 BERKELEY WY 1945.0 BERKELEY WY 206   Berkeley 94704 37.8728988635272 -122.27127748703688
1749 1749 1749 057 205800900 1913 Berkeley Way A 1913 BERKELEY WAY A 1913 BERKELEY WY 1913.0 BERKELEY WY A   Berkeley 94704 37.8727526986547 -122.27249023063672
1887 1887 1887 057 205602300 1945 Berkeley Way 123 1945 BERKELEY WAY 123 1945 BERKELEY WY 1945.0 BERKELEY WY 123   Berkeley 94704 37.8728988635272 -122.27127748703688
2122 2122 2122 057 206000100 1888 Berkeley Way Apt 213 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 213 APT Berkeley 94704 37.87224946310159 -122.2735342194223
2375 2375 2375 057 206000100 1888 Berkeley Way Apt 207 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 207 APT Berkeley 94704 37.8722350992976 -122.27369465853202
2588 2588 2588 057 205602300 1945 Berkeley Way 303 1945 BERKELEY WAY 303 1945 BERKELEY WY 1945.0 BERKELEY WY 303   Berkeley 94704 37.8728988635272 -122.27127748703688
2774 2774 2774 057 205102800 2009 Berkeley Way 2009 BERKELEY WAY 2009 BERKELEY WY 2009.0 BERKELEY WY     Berkeley 94704 37.87302994046354 -122.270274013169
2834 2834 2834 057 206000100 1888 Berkeley Way Apt 510 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 510 APT Berkeley 94704 37.87213815063826 -122.2736513291926
3004 3004 3004 057 205800900 1911 Berkeley Way A 1911 BERKELEY WAY A 1911 BERKELEY WY 1911.0 BERKELEY WY A   Berkeley 94704 37.8727526986547 -122.27249023063672
3196 3196 3196 057 206000100 1888 Berkeley Way Apt 301 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 301 APT Berkeley 94704 37.872188492790315 -122.2738409698373
3586 3586 3586 057 205800900 1913 Berkeley Way B 1913 BERKELEY WAY B 1913 BERKELEY WY 1913.0 BERKELEY WY B   Berkeley 94704 37.8727526986547 -122.27249023063672
3702 3702 3702 057 205602300 1945 Berkeley Way 309 1945 BERKELEY WAY 309 1945 BERKELEY WY 1945.0 BERKELEY WY 309   Berkeley 94704 37.8728988635272 -122.27127748703688
3897 3897 3897 057 206000100 1888 Berkeley Way Apt 307 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 307 APT Berkeley 94704 37.872201836897624 -122.27369054694296
3919 3919 3919 057 206000100 1888 Berkeley Way Apt 205 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 205 APT Berkeley 94704 37.872230723357326 -122.27374496328964
4168 4168 4168 057 205602300 1945 Berkeley Way 214 1945 BERKELEY WAY 214 1945 BERKELEY WY 1945.0 BERKELEY WY 214   Berkeley 94704 37.8728988635272 -122.27127748703688
4492 4492 4492 057 205602300 1945 Berkeley Way 127 1945 BERKELEY WAY 127 1945 BERKELEY WY 1945.0 BERKELEY WY 127   Berkeley 94704 37.8728988635272 -122.27127748703688
4627 4627 4627 057 205602300 1945 Berkeley Way 315 1945 BERKELEY WAY 315 1945 BERKELEY WY 1945.0 BERKELEY WY 315   Berkeley 94704 37.8728988635272 -122.27127748703688
4703 4703 4703 057 206000100 1888 Berkeley Way Apt 506 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 506 APT Berkeley 94704 37.87213320243673 -122.27370484452904
5640 5640 5640 057 206000100 1888 Berkeley Way Apt 212 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 212 APT Berkeley 94704 37.87224718613819 -122.27356074757094
5708 5708 5708 057 206000100 1888 Berkeley Way Apt 513 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 513 APT Berkeley 94704 37.87214543466255 -122.27356841199696
5807 5807 5807 057 205103000 2017 Berkeley Way 10 2017 BERKELEY WAY 10 2017 BERKELEY WY 2017.0 BERKELEY WY 10   Berkeley 94704 37.87306930079794 -122.26996137160236
5870 5870 5870 057 206000100 1888 Berkeley Way Apt 210 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 210 APT Berkeley 94704 37.87224218050582 -122.2736171384146
6064 6064 6064 057 206000100 1888 Berkeley Way Apt 404 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 404 APT Berkeley 94704 37.872160903993326 -122.27376051761875
6331 6331 6331 057 206000100 1888 Berkeley Way Apt 403 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 403 APT Berkeley 94704 37.87215884968907 -122.2737850910334
6443 6443 6443 057 206000100 1888 Berkeley Way Apt 309 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 309 APT Berkeley 94704 37.87220622134896 -122.2736397265524
6803 6803 6803 057 206000100 1888 Berkeley Way Apt 304 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 304 APT Berkeley 94704 37.87219506485922 -122.27376718221988
6850 6850 6850 057 205602300 1945 Berkeley Way 406 1945 BERKELEY WAY 406 1945 BERKELEY WY 1945.0 BERKELEY WY 406   Berkeley 94704 37.8728988635272 -122.27127748703688
6998 6998 6998 057 205103000 2017 Berkeley Way 5 2017 BERKELEY WAY 5 2017 BERKELEY WY 2017.0 BERKELEY WY 5   Berkeley 94704 37.87306930079794 -122.26996137160236
7100 7100 7100 057 205801000 1909 Berkeley Way 1909 BERKELEY WAY 1909 BERKELEY WY 1909.0 BERKELEY WY     Berkeley 94704 37.87274164861403 -122.27263815172302
7227 7227 7227 057 205103000 2017 Berkeley Way 8 2017 BERKELEY WAY 8 2017 BERKELEY WY 2017.0 BERKELEY WY 8   Berkeley 94704 37.87306930079794 -122.26996137160236
7272 7272 7272 057 205103000 2017 Berkeley Way 1 2017 BERKELEY WAY 1 2017 BERKELEY WY 2017.0 BERKELEY WY 1   Berkeley 94704 37.87306930079794 -122.26996137160236
7758 7758 7758 057 206000100 1888 Berkeley Way Apt 409 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 409 APT Berkeley 94704 37.87217206048823 -122.27363306195129
7787 7787 7787 057 206000100 1888 Berkeley Way Apt 305 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 305 APT Berkeley 94704 37.872197461664506 -122.2737408534972
7906 7906 7906 057 206000100 1888 Berkeley Way Apt 209 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 209 APT Berkeley 94704 37.872239483037816 -122.27364383814144
8027 8027 8027 057 205301500 2008 Berkeley Way 1 2008 BERKELEY WAY 1 2008 BERKELEY WY 2008.0 BERKELEY WY 1   Berkeley 94704 37.87252513257821 -122.27021079962076
8342 8342 8342 057 205800602 1917 Berkeley Way 1917 BERKELEY WAY 1917 BERKELEY WY 1917.0 BERKELEY WY     Berkeley 94704 37.87276375507574 -122.27233727000174
8628 8628 8628 057 205602300 1945 Berkeley Way 106 1945 BERKELEY WAY 106 1945 BERKELEY WY 1945.0 BERKELEY WY 106   Berkeley 94704 37.8728988635272 -122.27127748703688
9447 9447 9447 057 206000100 1888 Berkeley Way Apt 310 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 310 APT Berkeley 94704 37.872208918109045 -122.27361302682554
9601 9601 9601 057 205602300 1945 Berkeley Way 125 1945 BERKELEY WAY 125 1945 BERKELEY WY 1945.0 BERKELEY WY 125   Berkeley 94704 37.8728988635272 -122.27127748703688
10297 10297 10297 057 205602300 1945 Berkeley Way 308 1945 BERKELEY WAY 308 1945 BERKELEY WY 1945.0 BERKELEY WY 308   Berkeley 94704 37.8728988635272 -122.27127748703688
10444 10444 10444 057 206000100 1888 Berkeley Way Apt 408 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 408 APT Berkeley 94704 37.872169968601234 -122.27365872322574
10814 10814 10814 057 205602300 1945 Berkeley Way 326 1945 BERKELEY WAY 326 1945 BERKELEY WY 1945.0 BERKELEY WY 326   Berkeley 94704 37.8728988635272 -122.27127748703688
11170 11170 11170 057 205100901 2029 Berkeley Way 2029 BERKELEY WAY 2029 BERKELEY WY 2029.0 BERKELEY WY     Berkeley 94704 37.873187521368514 -122.26931352099248
11895 11895 11895 057 205602300 1945 Berkeley Way 126 1945 BERKELEY WAY 126 1945 BERKELEY WY 1945.0 BERKELEY WY 126   Berkeley 94704 37.8728988635272 -122.27127748703688
11932 11932 11932 057 206000100 1888 Berkeley Way Apt 406 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 406 APT Berkeley 94704 37.87216547565327 -122.27371015447068
12594 12594 12594 057 206000100 1888 Berkeley Way Apt 402 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 402 APT Berkeley 94704 37.872156503229654 -122.2738099662819
12823 12823 12823 057 205602300 1945 Berkeley Way 103 1945 BERKELEY WAY 103 1945 BERKELEY WY 1945.0 BERKELEY WY 103   Berkeley 94704 37.8728988635272 -122.27127748703688
12894 12894 12894 057 205602300 1945 Berkeley Way 108 1945 BERKELEY WAY 108 1945 BERKELEY WY 1945.0 BERKELEY WY 108   Berkeley 94704 37.8728988635272 -122.27127748703688
13156 13156 13156 057 206000100 1888 Berkeley Way Apt 512 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 512 APT Berkeley 94704 37.87214315627769 -122.2735949401456
13214 13214 13214 057 206000100 1888 Berkeley Way Apt 217 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 217 APT Berkeley 94704 37.8722590850618 -122.27342627695944
13305 13305 13305 057 205102700 2005 Berkeley Way B 2005 BERKELEY WAY B 2005 BERKELEY WY 2005.0 BERKELEY WY B   Berkeley 94704 37.87301017200475 -122.2704268749893
13367 13367 13367 057 204700302 2151 Berkeley Way 2151 BERKELEY WAY 2151 BERKELEY WY 2151.0 BERKELEY WY     Berkeley 94704 37.87359226147651 -122.26753351285024
13439 13439 13439 057 205103000 2017 Berkeley Way 2017 BERKELEY WAY 2017 BERKELEY WY 2017.0 BERKELEY WY     Berkeley 94704 37.87306930079794 -122.26996137160236
13477 13477 13477 057 205602300 1945 Berkeley Way 221 1945 BERKELEY WAY 221 1945 BERKELEY WY 1945.0 BERKELEY WY 221   Berkeley 94704 37.8728988635272 -122.27127748703688
13843 13843 13843 057 206000100 1888 Berkeley Way Apt 203 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 203 APT Berkeley 94704 37.87222627225075 -122.27379586542688
13930 13930 13930 057 205102700 2005 Berkeley Way 2005 BERKELEY WAY 2005 BERKELEY WY 2005.0 BERKELEY WY     Berkeley 94704 37.87301017200475 -122.2704268749893
14029 14029 14029 057 205602300 1945 Berkeley Way 122 1945 BERKELEY WAY 122 1945 BERKELEY WY 1945.0 BERKELEY WY 122   Berkeley 94704 37.8728988635272 -122.27127748703688
14084 14084 14084 057 205301500 2008 Berkeley Way 6 2008 BERKELEY WAY 6 2008 BERKELEY WY 2008.0 BERKELEY WY 6   Berkeley 94704 37.87252513257821 -122.27021079962076
14227 14227 14227 057 204600100 2116 Berkeley Way 2116 BERKELEY WAY 2116 BERKELEY WY 2116.0 BERKELEY WY     Berkeley 94704 37.87296293771937 -122.26794704690136
14257 14257 14257 057 205602300 1945 Berkeley Way 327 1945 BERKELEY WAY 327 1945 BERKELEY WY 1945.0 BERKELEY WY 327   Berkeley 94704 37.8728988635272 -122.27127748703688
14290 14290 14290 057 205602300 1945 Berkeley Way 322 1945 BERKELEY WAY 322 1945 BERKELEY WY 1945.0 BERKELEY WY 322   Berkeley 94704 37.8728988635272 -122.27127748703688
14331 14331 14331 057 205602300 1945 Berkeley Way 105 1945 BERKELEY WAY 105 1945 BERKELEY WY 1945.0 BERKELEY WY 105   Berkeley 94704 37.8728988635272 -122.27127748703688
14363 14363 14363 057 205602300 1945 Berkeley Way 316 1945 BERKELEY WAY 316 1945 BERKELEY WY 1945.0 BERKELEY WY 316   Berkeley 94704 37.8728988635272 -122.27127748703688
14547 14547 14547 057 205602300 1945 Berkeley Way 102 1945 BERKELEY WAY 102 1945 BERKELEY WY 1945.0 BERKELEY WY 102   Berkeley 94704 37.8728988635272 -122.27127748703688
14716 14716 14716 057 205602300 1945 Berkeley Way 209 1945 BERKELEY WAY 209 1945 BERKELEY WY 1945.0 BERKELEY WY 209   Berkeley 94704 37.8728988635272 -122.27127748703688
14760 14760 14760 057 205602300 1945 Berkeley Way 312 1945 BERKELEY WAY 312 1945 BERKELEY WY 1945.0 BERKELEY WY 312   Berkeley 94704 37.8728988635272 -122.27127748703688
14828 14828 14828 057 205602300 1945 Berkeley Way 304 1945 BERKELEY WAY 304 1945 BERKELEY WY 1945.0 BERKELEY WY 304   Berkeley 94704 37.8728988635272 -122.27127748703688
15164 15164 15164 057 205602300 1945 Berkeley Way 226 1945 BERKELEY WAY 226 1945 BERKELEY WY 1945.0 BERKELEY WY 226   Berkeley 94704 37.8728988635272 -122.27127748703688
15275 15275 15275 057 205602300 1945 Berkeley Way 324 1945 BERKELEY WAY 324 1945 BERKELEY WY 1945.0 BERKELEY WY 324   Berkeley 94704 37.8728988635272 -122.27127748703688
15346 15346 15346 057 205602300 1945 Berkeley Way 325 1945 BERKELEY WAY 325 1945 BERKELEY WY 1945.0 BERKELEY WY 325   Berkeley 94704 37.8728988635272 -122.27127748703688
15994 15994 15994 057 206000100 1888 Berkeley Way Apt 316 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 316 APT Berkeley 94704 37.87222345990575 -122.2734486746544
16195 16195 16195 057 206000100 1888 Berkeley Way Apt 417 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 417 APT Berkeley 94704 37.87219166323922 -122.27341550076927
16304 16304 16304 057 205602300 1945 Berkeley Way 204 1945 BERKELEY WAY 204 1945 BERKELEY WY 1945.0 BERKELEY WY 204   Berkeley 94704 37.8728988635272 -122.27127748703688
16447 16447 16447 057 205602300 1945 Berkeley Way 219 1945 BERKELEY WAY 219 1945 BERKELEY WY 1945.0 BERKELEY WY 219   Berkeley 94704 37.8728988635272 -122.27127748703688
16803 16803 16803 057 206000100 1888 Berkeley Way Apt 312 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 312 APT Berkeley 94704 37.87221392374367 -122.27355663598188
17655 17655 17655 057 205602300 1929 Berkeley Way 1929 BERKELEY WAY 1929 BERKELEY WY 1929.0 BERKELEY WY     Berkeley 94704 37.8728988635272 -122.27127748703688
17764 17764 17764 057 205602300 1945 Berkeley Way 203 1945 BERKELEY WAY 203 1945 BERKELEY WY 1945.0 BERKELEY WY 203   Berkeley 94704 37.8728988635272 -122.27127748703688
17897 17897 17897 057 205602300 1945 Berkeley Way 228 1945 BERKELEY WAY 228 1945 BERKELEY WY 1945.0 BERKELEY WY 228   Berkeley 94704 37.8728988635272 -122.27127748703688
18177 18177 18177 057 206000100 1888 Berkeley Way Apt 216 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 216 APT Berkeley 94704 37.87225672158683 -122.27345278624344
18375 18375 18375 057 206000100 1888 Berkeley Way Apt 503 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 503 APT Berkeley 94704 37.872126575760504 -122.2737797801934
18712 18712 18712 057 205602300 1945 Berkeley Way 212 1945 BERKELEY WAY 212 1945 BERKELEY WY 1945.0 BERKELEY WY 212   Berkeley 94704 37.8728988635272 -122.27127748703688
19205 19205 19205 057 206000100 1888 Berkeley Way Apt 211 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 211 APT Berkeley 94704 37.87224458440073 -122.27358886843258
19404 19404 19404 057 205301500 2008 Berkeley Way 7 2008 BERKELEY WAY 7 2008 BERKELEY WY 2008.0 BERKELEY WY 7   Berkeley 94704 37.87252513257821 -122.27021079962076
20135 20135 20135 057 205602300 1945 Berkeley Way 310 1945 BERKELEY WAY 310 1945 BERKELEY WY 1945.0 BERKELEY WY 310   Berkeley 94704 37.8728988635272 -122.27127748703688
20433 20433 20433 057 205103000 2017 Berkeley Way 11 2017 BERKELEY WAY 11 2017 BERKELEY WY 2017.0 BERKELEY WY 11   Berkeley 94704 37.87306930079794 -122.26996137160236
20646 20646 20646 057 205602300 1945 Berkeley Way 404 1945 BERKELEY WAY 404 1945 BERKELEY WY 1945.0 BERKELEY WY 404   Berkeley 94704 37.8728988635272 -122.27127748703688
20811 20811 20811 057 205301500 2008 Berkeley Way 5 2008 BERKELEY WAY 5 2008 BERKELEY WY 2008.0 BERKELEY WY 5   Berkeley 94704 37.87252513257821 -122.27021079962076

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "addresses" (
"address_id" INTEGER,
  "apn" TEXT,
  "address_full" TEXT,
  "address_normalized" TEXT,
  "base_address" TEXT,
  "street_number" REAL,
  "street_name" TEXT,
  "street_type" TEXT,
  "unit" TEXT,
  "unit_type" TEXT,
  "city" TEXT,
  "zipcode" INTEGER,
  "latitude" REAL,
  "longitude" REAL
);
CREATE INDEX idx_addresses_apn ON addresses(apn);
CREATE INDEX idx_addresses_base ON addresses(base_address);
CREATE INDEX idx_addresses_street ON addresses(street_name);
CREATE INDEX idx_addresses_zipcode ON addresses(zipcode);
CREATE INDEX idx_addresses_coords ON addresses(latitude, longitude);