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

272 rows where street_name = "ALLSTON" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn

zipcode 1

  • 94704 · 272 ✖

street_type 1

street_name 1

  • ALLSTON · 272 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
108 108 108 057 202601500 2001 Allston Way 325 2001 ALLSTON WAY 325 2001 ALLSTON WY 2001.0 ALLSTON WY 325   Berkeley 94704 37.86939494524181 -122.26998376660237
451 451 451 057 203100300 2161 Allston Way 204 2161 ALLSTON WAY 204 2161 ALLSTON WY 2161.0 ALLSTON WY 204   Berkeley 94704 37.86984650070638 -122.26642724386603
558 558 558 057 202601500 2001 Allston Way Apt 328 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 328 APT Berkeley 94704 37.86952136936425 -122.26994508963782
658 658 658 057 203000200 2116 Allston Way 411 2116 ALLSTON WAY 411 2116 ALLSTON WY 2116.0 ALLSTON WY 411   Berkeley 94704 37.86925187591561 -122.2670315594223
727 727 727 057 202601500 2001 Allston Way Apt 317 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 317 APT Berkeley 94704 37.86941884754291 -122.27024333210876
793 793 793 057 203000200 2116 Allston Way 515 2116 ALLSTON WAY 515 2116 ALLSTON WY 2116.0 ALLSTON WY 515   Berkeley 94704 37.86925187591561 -122.2670315594223
953 953 953 057 203100300 2161 Allston Way 304 2161 ALLSTON WAY 304 2161 ALLSTON WY 2161.0 ALLSTON WY 304   Berkeley 94704 37.86984650070638 -122.26642724386603
954 954 954 057 203000200 2116 Allston Way 509 2116 ALLSTON WAY 509 2116 ALLSTON WY 2116.0 ALLSTON WY 509   Berkeley 94704 37.86925187591561 -122.2670315594223
1444 1444 1444 057 203000200 2116 Allston Way 205 2116 ALLSTON WAY 205 2116 ALLSTON WY 2116.0 ALLSTON WY 205   Berkeley 94704 37.86925187591561 -122.2670315594223
1760 1760 1760 057 202700500 2000 Allston Way 2000 ALLSTON WAY 2000 ALLSTON WY 2000.0 ALLSTON WY     Berkeley 94704 37.86866097148063 -122.26998257992788
3026 3026 3026 057 203100300 2161 Allston Way 501 2161 ALLSTON WAY 501 2161 ALLSTON WY 2161.0 ALLSTON WY 501   Berkeley 94704 37.86984650070638 -122.26642724386603
3090 3090 3090 057 203100300 2161 Allston Way 507 2161 ALLSTON WAY 507 2161 ALLSTON WY 2161.0 ALLSTON WY 507   Berkeley 94704 37.86984650070638 -122.26642724386603
3360 3360 3360 057 203100300 2161 Allston Way 407 2161 ALLSTON WAY 407 2161 ALLSTON WY 2161.0 ALLSTON WY 407   Berkeley 94704 37.86984650070638 -122.26642724386603
3573 3573 3573 057 203100300 2161 Allston Way 512 2161 ALLSTON WAY 512 2161 ALLSTON WY 2161.0 ALLSTON WY 512   Berkeley 94704 37.86984650070638 -122.26642724386603
3649 3649 3649 057 203100300 2161 Allston Way 406 2161 ALLSTON WAY 406 2161 ALLSTON WY 2161.0 ALLSTON WY 406   Berkeley 94704 37.86984650070638 -122.26642724386603
3742 3742 3742 057 203000200 2116 Allston Way 605 2116 ALLSTON WAY 605 2116 ALLSTON WY 2116.0 ALLSTON WY 605   Berkeley 94704 37.86925187591561 -122.2670315594223
3809 3809 3809 057 203100300 2161 Allston Way 302 2161 ALLSTON WAY 302 2161 ALLSTON WY 2161.0 ALLSTON WY 302   Berkeley 94704 37.86984650070638 -122.26642724386603
3861 3861 3861 057 203100300 2161 Allston Way A 2161 ALLSTON WAY A 2161 ALLSTON WY 2161.0 ALLSTON WY A   Berkeley 94704 37.86984650070638 -122.26642724386603
4117 4117 4117 057 203100300 2161 Allston Way 212 2161 ALLSTON WAY 212 2161 ALLSTON WY 2161.0 ALLSTON WY 212   Berkeley 94704 37.86984650070638 -122.26642724386603
4167 4167 4167 057 203000200 2116 Allston Way 709 2116 ALLSTON WAY 709 2116 ALLSTON WY 2116.0 ALLSTON WY 709   Berkeley 94704 37.86925187591561 -122.2670315594223
4437 4437 4437 057 203000200 2116 Allston Way 312 2116 ALLSTON WAY 312 2116 ALLSTON WY 2116.0 ALLSTON WY 312   Berkeley 94704 37.86925187591561 -122.2670315594223
4555 4555 4555 057 203000200 2116 Allston Way 601 2116 ALLSTON WAY 601 2116 ALLSTON WY 2116.0 ALLSTON WY 601   Berkeley 94704 37.86925187591561 -122.2670315594223
4872 4872 4872 057 203000200 2116 Allston Way 301 2116 ALLSTON WAY 301 2116 ALLSTON WY 2116.0 ALLSTON WY 301   Berkeley 94704 37.86925187591561 -122.2670315594223
4924 4924 4924 057 202000503 1920 Allston Way 1920 ALLSTON WAY 1920 ALLSTON WY 1920.0 ALLSTON WY     Berkeley 94704 37.86842495104117 -122.27151646854686
4933 4933 4933 057 203000200 2116 Allston Way 416 2116 ALLSTON WAY 416 2116 ALLSTON WY 2116.0 ALLSTON WY 416   Berkeley 94704 37.86925187591561 -122.2670315594223
5057 5057 5057 057 203000200 2116 Allston Way 311 2116 ALLSTON WAY 311 2116 ALLSTON WY 2116.0 ALLSTON WY 311   Berkeley 94704 37.86925187591561 -122.2670315594223
5065 5065 5065 057 203100500 2115 Allston Way 3 2115 ALLSTON WAY 3 2115 ALLSTON WY 2115.0 ALLSTON WY 3   Berkeley 94704 37.86974358363872 -122.26720229142856
5073 5073 5073 057 202601500 2001 Allston Way Apt 308 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 308 APT Berkeley 94704 37.869460113848326 -122.26992768747412
5445 5445 5445 057 203000200 2116 Allston Way 212 2116 ALLSTON WAY 212 2116 ALLSTON WY 2116.0 ALLSTON WY 212   Berkeley 94704 37.86925187591561 -122.2670315594223
5463 5463 5463 057 203000200 2116 Allston Way 203 2116 ALLSTON WAY 203 2116 ALLSTON WY 2116.0 ALLSTON WY 203   Berkeley 94704 37.86925187591561 -122.2670315594223
5703 5703 5703 057 203000200 2116 Allston Way 516 2116 ALLSTON WAY 516 2116 ALLSTON WY 2116.0 ALLSTON WY 516   Berkeley 94704 37.86925187591561 -122.2670315594223
5816 5816 5816 057 202601500 2001 Allston Way Apt 326 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 326 APT Berkeley 94704 37.86952776864092 -122.26990115842716
5903 5903 5903 057 202601500 2001 Allston Way 433 2001 ALLSTON WAY 433 2001 ALLSTON WY 2001.0 ALLSTON WY 433   Berkeley 94704 37.86939494524181 -122.26998376660237
6044 6044 6044 057 202601500 2001 Allston Way Apt 306 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 306 APT Berkeley 94704 37.869472710306844 -122.2698412120516
6054 6054 6054 057 202700900 2086 Allston Way 222 2086 ALLSTON WAY 222 2086 ALLSTON WY 2086.0 ALLSTON WY 222   Berkeley 94704 37.869154525501344 -122.26848820729992
6057 6057 6057 057 203500302 2150 Allston Way Apt 100 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 100 APT Berkeley 94704 37.86939786973904 -122.266673775716
6094 6094 6094 057 203100300 2161 Allston Way 307 2161 ALLSTON WAY 307 2161 ALLSTON WY 2161.0 ALLSTON WY 307   Berkeley 94704 37.86984650070638 -122.26642724386603
6207 6207 6207 057 203000200 2128 Allston Way 2128 ALLSTON WAY 2128 ALLSTON WY 2128.0 ALLSTON WY     Berkeley 94704 37.86925187591561 -122.2670315594223
7315 7315 7315 057 203000200 2116 Allston Way 514 2116 ALLSTON WAY 514 2116 ALLSTON WY 2116.0 ALLSTON WY 514   Berkeley 94704 37.86925187591561 -122.2670315594223
7510 7510 7510 057 203500302 2150 Allston Way Apt 440 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 440 APT Berkeley 94704 37.869321597338235 -122.2665782488687
7537 7537 7537 057 202601500 2001 Allston Way Apt 312 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 312 APT Berkeley 94704 37.869436229289114 -122.27011038234504
7920 7920 7920 057 203100300 2161 Allston Way 209 2161 ALLSTON WAY 209 2161 ALLSTON WY 2161.0 ALLSTON WY 209   Berkeley 94704 37.86984650070638 -122.26642724386603
7950 7950 7950 057 202601500 2001 Allston Way Apt 310 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 310 APT Berkeley 94704 37.8694483442454 -122.27001771393697
8041 8041 8041 057 202601500 2001 Allston Way Apt 305 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 305 APT Berkeley 94704 37.86947949181435 -122.26979465326876
8094 8094 8094 057 203000200 2116 Allston Way 513 2116 ALLSTON WAY 513 2116 ALLSTON WY 2116.0 ALLSTON WY 513   Berkeley 94704 37.86925187591561 -122.2670315594223
8097 8097 8097 057 203000200 2116 Allston Way 702 2116 ALLSTON WAY 702 2116 ALLSTON WY 2116.0 ALLSTON WY 702   Berkeley 94704 37.86925187591561 -122.2670315594223
8197 8197 8197 057 202000400 1980 Allston Way 1980 ALLSTON WAY 1980 ALLSTON WY 1980.0 ALLSTON WY     Berkeley 94704 37.86880143371284 -122.27088160577937
8369 8369 8369 057 203000200 2116 Allston Way 708 2116 ALLSTON WAY 708 2116 ALLSTON WY 2116.0 ALLSTON WY 708   Berkeley 94704 37.86925187591561 -122.2670315594223
8436 8436 8436 057 203500302 2150 Allston Way Apt 350 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 350 APT Berkeley 94704 37.86937227329291 -122.266537836359
8716 8716 8716 057 202601500 2001 Allston Way 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY     Berkeley 94704 37.86934264395054 -122.2699734952654
8962 8962 8962 057 203000200 2116 Allston Way 404 2116 ALLSTON WAY 404 2116 ALLSTON WY 2116.0 ALLSTON WY 404   Berkeley 94704 37.86925187591561 -122.2670315594223
9073 9073 9073 057 202700900 2060 Allston Way A 2060 ALLSTON WAY A 2060 ALLSTON WY 2060.0 ALLSTON WY A   Berkeley 94704 37.86907236269832 -122.26902256116352
9291 9291 9291 057 203100300 2161 Allston Way 412 2161 ALLSTON WAY 412 2161 ALLSTON WY 2161.0 ALLSTON WY 412   Berkeley 94704 37.86984650070638 -122.26642724386603
9380 9380 9380 057 203500302 2150 Allston Way Apt 280 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 280 APT Berkeley 94704 37.86942168836059 -122.26649800685593
9417 9417 9417 057 203000200 2116 Allston Way 615 2116 ALLSTON WAY 615 2116 ALLSTON WY 2116.0 ALLSTON WY 615   Berkeley 94704 37.86925187591561 -122.2670315594223
9580 9580 9580 057 203000200 2116 Allston Way 701 2116 ALLSTON WAY 701 2116 ALLSTON WY 2116.0 ALLSTON WY 701   Berkeley 94704 37.86925187591561 -122.2670315594223
9583 9583 9583 057 203000200 2116 Allston Way 401 2116 ALLSTON WAY 401 2116 ALLSTON WY 2116.0 ALLSTON WY 401   Berkeley 94704 37.86925187591561 -122.2670315594223
9791 9791 9791 057 203100300 2161 Allston Way 309 2161 ALLSTON WAY 309 2161 ALLSTON WY 2161.0 ALLSTON WY 309   Berkeley 94704 37.86984650070638 -122.26642724386603
9863 9863 9863 057 203000200 2116 Allston Way 315 2116 ALLSTON WAY 315 2116 ALLSTON WY 2116.0 ALLSTON WY 315   Berkeley 94704 37.86925187591561 -122.2670315594223
10210 10210 10210 057 203100300 2161 Allston Way 311 2161 ALLSTON WAY 311 2161 ALLSTON WY 2161.0 ALLSTON WY 311   Berkeley 94704 37.86984650070638 -122.26642724386603
10874 10874 10874 057 203100500 2115 Allston Way 4 2115 ALLSTON WAY 4 2115 ALLSTON WY 2115.0 ALLSTON WY 4   Berkeley 94704 37.86974358363872 -122.26720229142856
10958 10958 10958 057 202700900 2060 Allston Way B 2060 ALLSTON WAY B 2060 ALLSTON WY 2060.0 ALLSTON WY B   Berkeley 94704 37.86907236269832 -122.26902256116352
11017 11017 11017 057 203500302 2150 Allston Way Apt 470 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 470 APT Berkeley 94704 37.86933119911569 -122.26650366803888
11153 11153 11153 057 203000200 2116 Allston Way 614 2116 ALLSTON WAY 614 2116 ALLSTON WY 2116.0 ALLSTON WY 614   Berkeley 94704 37.86925187591561 -122.2670315594223
11177 11177 11177 057 203000200 2116 Allston Way 314 2116 ALLSTON WAY 314 2116 ALLSTON WY 2116.0 ALLSTON WY 314   Berkeley 94704 37.86925187591561 -122.2670315594223
11215 11215 11215 057 203100300 2161 Allston Way 303 2161 ALLSTON WAY 303 2161 ALLSTON WY 2161.0 ALLSTON WY 303   Berkeley 94704 37.86984650070638 -122.26642724386603
11227 11227 11227 057 203000200 2116 Allston Way 511 2116 ALLSTON WAY 511 2116 ALLSTON WY 2116.0 ALLSTON WY 511   Berkeley 94704 37.86925187591561 -122.2670315594223
11258 11258 11258 057 203100600 2109 Allston Way 2109 ALLSTON WAY 2109 ALLSTON WY 2109.0 ALLSTON WY     Berkeley 94704 37.86965254307936 -122.2674885898995
11532 11532 11532 057 202601500 2001 Allston Way Apt 331 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 331 APT Berkeley 94704 37.86950324729606 -122.27008370866928
11563 11563 11563 057 203500302 2150 Allston Way Apt 210 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 210 APT Berkeley 94704 37.86940283939849 -122.26664441697586
11907 11907 11907 057 203000200 2116 Allston Way 207 2116 ALLSTON WAY 207 2116 ALLSTON WY 2116.0 ALLSTON WY 207   Berkeley 94704 37.86925187591561 -122.2670315594223
12522 12522 12522 057 203500302 2150 Allston Way Apt 230 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 230 APT Berkeley 94704 37.86940603053239 -122.26661963335552
12791 12791 12791 057 203100500 2115 Allston Way 2115 ALLSTON WAY 2115 ALLSTON WY 2115.0 ALLSTON WY     Berkeley 94704 37.86974358363872 -122.26720229142856
12803 12803 12803 057 203000200 2116 Allston Way 506 2116 ALLSTON WAY 506 2116 ALLSTON WY 2116.0 ALLSTON WY 506   Berkeley 94704 37.86925187591561 -122.2670315594223
13206 13206 13206 057 203100300 2161 Allston Way 511 2161 ALLSTON WAY 511 2161 ALLSTON WY 2161.0 ALLSTON WY 511   Berkeley 94704 37.86984650070638 -122.26642724386603
13575 13575 13575 057 203000200 2116 Allston Way 504 2116 ALLSTON WAY 504 2116 ALLSTON WY 2116.0 ALLSTON WY 504   Berkeley 94704 37.86925187591561 -122.2670315594223
13746 13746 13746 057 203000200 2116 Allston Way 406 2116 ALLSTON WAY 406 2116 ALLSTON WY 2116.0 ALLSTON WY 406   Berkeley 94704 37.86925187591561 -122.2670315594223
13974 13974 13974 057 202601500 2001 Allston Way Apt 329 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 329 APT Berkeley 94704 37.86951559271169 -122.26998927866494
14001 14001 14001 057 203500302 2150 Allston Way Apt 270 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 270 APT Berkeley 94704 37.8694186780583 -122.26652139179942
14171 14171 14171 057 203100300 2161 Allston Way 201 2161 ALLSTON WAY 201 2161 ALLSTON WY 2161.0 ALLSTON WY 201   Berkeley 94704 37.86984650070638 -122.26642724386603
14682 14682 14682 057 203000200 2116 Allston Way 213 2116 ALLSTON WAY 213 2116 ALLSTON WY 2116.0 ALLSTON WY 213   Berkeley 94704 37.86925187591561 -122.2670315594223
14875 14875 14875 057 203000200 2116 Allston Way 613 2116 ALLSTON WAY 613 2116 ALLSTON WY 2116.0 ALLSTON WY 613   Berkeley 94704 37.86925187591561 -122.2670315594223
15436 15436 15436 057 203500302 2150 Allston Way Apt 480 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 480 APT Berkeley 94704 37.869334209421545 -122.26648028309538
15457 15457 15457 057 202600501 2045 Allston Way 2045 ALLSTON WAY 2045 ALLSTON WY 2045.0 ALLSTON WY     Berkeley 94704 37.86944389722559 -122.2694840930986
15614 15614 15614 057 202700900 2060 Allston Way 2060 ALLSTON WAY 2060 ALLSTON WY 2060.0 ALLSTON WY     Berkeley 94704 37.86907236269832 -122.26902256116352
15677 15677 15677 057 202601500 2001 Allston Way 343 2001 ALLSTON WAY 343 2001 ALLSTON WY 2001.0 ALLSTON WY 343   Berkeley 94704 37.86939494524181 -122.26998376660237
15700 15700 15700 057 203000200 2116 Allston Way 302 2116 ALLSTON WAY 302 2116 ALLSTON WY 2116.0 ALLSTON WY 302   Berkeley 94704 37.86925187591561 -122.2670315594223
16348 16348 16348 057 202601500 2001 Allston Way 4 2001 ALLSTON WAY 4 2001 ALLSTON WY 2001.0 ALLSTON WY 4   Berkeley 94704 37.86939494524181 -122.26998376660237
16412 16412 16412 057 202601500 2001 Allston Way Apt 313 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 313 APT Berkeley 94704 37.86943041859118 -122.2701548264937
16595 16595 16595 057 203000200 2116 Allston Way 607 2116 ALLSTON WAY 607 2116 ALLSTON WY 2116.0 ALLSTON WY 607   Berkeley 94704 37.86925187591561 -122.2670315594223
16705 16705 16705 057 203500302 2150 Allston Way Apt 460 2150 ALLSTON WAY 2150 ALLSTON WY 2150.0 ALLSTON WY 460 APT Berkeley 94704 37.869328070383006 -122.26652797195888
16718 16718 16718 057 203100500 2115 Allston Way 5 2115 ALLSTON WAY 5 2115 ALLSTON WY 2115.0 ALLSTON WY 5   Berkeley 94704 37.86974358363872 -122.26720229142856
17198 17198 17198 057 203100300 2161 Allston Way 508 2161 ALLSTON WAY 508 2161 ALLSTON WY 2161.0 ALLSTON WY 508   Berkeley 94704 37.86984650070638 -122.26642724386603
17335 17335 17335 057 203100300 2161 Allston Way 207 2161 ALLSTON WAY 207 2161 ALLSTON WY 2161.0 ALLSTON WY 207   Berkeley 94704 37.86984650070638 -122.26642724386603
17402 17402 17402 057 202601500 2001 Allston Way Apt 319 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 319 APT Berkeley 94704 37.86941315385186 -122.27028687884048
17491 17491 17491 057 203000200 2116 Allston Way 602 2116 ALLSTON WAY 602 2116 ALLSTON WY 2116.0 ALLSTON WY 602   Berkeley 94704 37.86925187591561 -122.2670315594223
17663 17663 17663 057 203100300 2161 Allston Way 414 2161 ALLSTON WAY 414 2161 ALLSTON WY 2161.0 ALLSTON WY 414   Berkeley 94704 37.86984650070638 -122.26642724386603
17850 17850 17850 057 203000200 2116 Allston Way 704 2116 ALLSTON WAY 704 2116 ALLSTON WY 2116.0 ALLSTON WY 704   Berkeley 94704 37.86925187591561 -122.2670315594223
17960 17960 17960 057 202700203 2016 Allston Way 2016 ALLSTON WAY 2016 ALLSTON WY 2016.0 ALLSTON WY     Berkeley 94704 37.86893986610339 -122.2695232470686
18071 18071 18071 057 202601203 2061 Allston Way 2061 ALLSTON WAY 2061 ALLSTON WY 2061.0 ALLSTON WY     Berkeley 94704 37.869327243523905 -122.26900762128204

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);