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

576 rows where street_name = "ALLSTON"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 4

street_type 1

street_name 1

  • ALLSTON · 576 ✖
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
210 210 210 057 201800300 1872 Allston Way 1872 ALLSTON WAY 1872 ALLSTON WY 1872.0 ALLSTON WY     Berkeley 94703 37.86850615154113 -122.27318115276952
436 436 436 056 196300300 808 Allston Way 808 ALLSTON WAY 808 ALLSTON WY 808.0 ALLSTON WY     Berkeley 94710 37.86492207808195 -122.297379513549
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
479 479 479 056 198700400 1210 Allston Way 1210 ALLSTON WAY 1210 ALLSTON WY 1210.0 ALLSTON WY     Berkeley 94702 37.86654206559832 -122.2883503705585
496 496 496 056 199804803 1408 Allston Way 5 1408 ALLSTON WAY 5 1408 ALLSTON WY 1408.0 ALLSTON WY 5   Berkeley 94702 37.86662083005484 -122.28326691485844
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
713 713 713 056 197101600 941 Allston Way 941 ALLSTON WAY 941 ALLSTON WY 941.0 ALLSTON WY     Berkeley 94710 37.866056300656474 -122.29400711130994
722 722 722 056 200800500 1642 Allston Way A 1642 ALLSTON WAY A 1642 ALLSTON WY 1642.0 ALLSTON WY A   Berkeley 94703 37.86792976745935 -122.2775637590546
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
947 947 947 056 197101400 949 Allston Way 949 ALLSTON WAY 949 ALLSTON WY 949.0 ALLSTON WY     Berkeley 94710 37.866060598245234 -122.29377332475724
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
1087 1087 1087 056 200800500 1640 Allston Way A 1640 ALLSTON WAY A 1640 ALLSTON WY 1640.0 ALLSTON WY A   Berkeley 94703 37.86792976745935 -122.2775637590546
1195 1195 1195 056 196402501 830 Allston Way 830 ALLSTON WAY 830 ALLSTON WY 830.0 ALLSTON WY     Berkeley 94710 37.86510351265648 -122.2964232533358
1391 1391 1391 056 201001500 1723 Allston Way 1723 ALLSTON WAY 1723 ALLSTON WY 1723.0 ALLSTON WY     Berkeley 94703 37.86850842862019 -122.27627067822056
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
1473 1473 1473 056 195900901 739 Allston Way 739 ALLSTON WAY 739 ALLSTON WY 739.0 ALLSTON WY     Berkeley 94710 37.865244919207214 -122.29833229638372
1694 1694 1694 056 200508000 1609 Allston Way 55 1609 ALLSTON WAY 55 1609 ALLSTON WY 1609.0 ALLSTON WY 55   Berkeley 94703 37.86888959973757 -122.2788851853291
1760 1760 1760 057 202700500 2000 Allston Way 2000 ALLSTON WAY 2000 ALLSTON WY 2000.0 ALLSTON WY     Berkeley 94704 37.86866097148063 -122.26998257992788
1810 1810 1810 056 199703700 1415 Allston Way 1415 ALLSTON WAY 1415 ALLSTON WY 1415.0 ALLSTON WY     Berkeley 94702 37.86749470309471 -122.2831975343758
1954 1954 1954 056 200001600 1519 Allston Way 1519 ALLSTON WAY 1519 ALLSTON WY 1519.0 ALLSTON WY     Berkeley 94703 37.86777460558829 -122.28083632163464
2054 2054 2054 056 198901900 1229 Allston Way 1229 ALLSTON WAY 1229 ALLSTON WY 1229.0 ALLSTON WY     Berkeley 94702 37.86707558595424 -122.2876936302206
2061 2061 2061 056 197600200 1034 Allston Way 1034 ALLSTON WAY 1034 ALLSTON WY 1034.0 ALLSTON WY     Berkeley 94710 37.86599762010617 -122.292041961286
2405 2405 2405 056 196201700 805 Allston Way 805 ALLSTON WAY 805 ALLSTON WY 805.0 ALLSTON WY     Berkeley 94710 37.86531659112096 -122.29765322841943
2629 2629 2629 057 201400300 1826 Allston Way 1826 ALLSTON WAY 1826 ALLSTON WY 1826.0 ALLSTON WY     Berkeley 94703 37.86837572819408 -122.27417619684682
2899 2899 2899 057 201800200 1834 Allston Way 1834 ALLSTON WAY 1834 ALLSTON WY 1834.0 ALLSTON WY     Berkeley 94703 37.868571898890096 -122.273322444289
2966 2966 2966 056 198700100 1200 Allston Way 1200 ALLSTON WAY 1200 ALLSTON WY 1200.0 ALLSTON WY     Berkeley 94702 37.86648837018345 -122.28875615035211
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
3052 3052 3052 056 198800400 1236 Allston Way 1236 ALLSTON WAY 1236 ALLSTON WY 1236.0 ALLSTON WY     Berkeley 94702 37.86667856691658 -122.28732886301124
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
3359 3359 3359 056 198601000 1203 Allston Way 2 1203 ALLSTON WAY 2 1203 ALLSTON WY 1203.0 ALLSTON WY 2   Berkeley 94702 37.86694326873318 -122.2887125263653
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
3631 3631 3631 056 199800500 1418 Allston Way 1418 ALLSTON WAY 1418 ALLSTON WY 1418.0 ALLSTON WY     Berkeley 94702 37.86697576406395 -122.28287506434162
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
3802 3802 3802 056 201203300 1731 Allston Way 1731 ALLSTON WAY 1731 ALLSTON WY 1731.0 ALLSTON WY     Berkeley 94703 37.86855199307848 -122.27586519756592
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
3946 3946 3946 056 199800800 1430 Allston Way 1430 ALLSTON WAY 1430 ALLSTON WY 1430.0 ALLSTON WY     Berkeley 94702 37.867024428316135 -122.28249505362024
4108 4108 4108 056 197101800 935 Allston Way 935 ALLSTON WAY 935 ALLSTON WY 935.0 ALLSTON WY     Berkeley 94710 37.866008543507114 -122.29424410754314
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
4533 4533 4533 057 201300300 1750 Allston Way 1750 ALLSTON WAY 1750 ALLSTON WY 1750.0 ALLSTON WY     Berkeley 94703 37.86821100150672 -122.27543609840583
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
4808 4808 4808 056 199703300 1429 Allston Way B 1429 ALLSTON WAY B 1429 ALLSTON WY 1429.0 ALLSTON WY B   Berkeley 94702 37.86755231375062 -122.28267128511268
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
4908 4908 4908 056 199703001 1435 Allston Way 1435 ALLSTON WAY 1435 ALLSTON WY 1435.0 ALLSTON WY     Berkeley 94702 37.867490781443976 -122.28225335380822
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
4982 4982 4982 056 197000101 920 Allston Way 920 ALLSTON WAY 920 ALLSTON WY 920.0 ALLSTON WY     Berkeley 94710 37.865471802846045 -122.2940951336314
5018 5018 5018 056 200800400 1636 Allston Way 1636 ALLSTON WAY 1636 ALLSTON WY 1636.0 ALLSTON WY     Berkeley 94703 37.867912883893865 -122.27771486107528
5020 5020 5020 056 198700200 1206 Allston Way 1206 ALLSTON WAY 1206 ALLSTON WY 1206.0 ALLSTON WY     Berkeley 94702 37.86650713833669 -122.2886197097352
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
5328 5328 5328 056 198303900 1112 Allston Way 1112 ALLSTON WAY 1112 ALLSTON WY 1112.0 ALLSTON WY     Berkeley 94702 37.866270217442775 -122.29044880811276
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
6023 6023 6023 056 196801400 913 Allston Way 913 ALLSTON WAY 913 ALLSTON WY 913.0 ALLSTON WY     Berkeley 94710 37.86584379025258 -122.29506050365988
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
6185 6185 6185 056 198303900 1112 Allston Way B 1112 ALLSTON WAY B 1112 ALLSTON WY 1112.0 ALLSTON WY B   Berkeley 94702 37.866270217442775 -122.29044880811276
6207 6207 6207 057 203000200 2128 Allston Way 2128 ALLSTON WAY 2128 ALLSTON WY 2128.0 ALLSTON WY     Berkeley 94704 37.86925187591561 -122.2670315594223
6524 6524 6524 056 195800100 724 Allston Way 724 ALLSTON WAY 724 ALLSTON WY 724.0 ALLSTON WY     Berkeley 94710 37.8646316546055 -122.29862235699906
6659 6659 6659 056 199800202 1406 Allston Way D 1406 ALLSTON WAY D 1406 ALLSTON WY 1406.0 ALLSTON WY D   Berkeley 94702 37.866927184879465 -122.28335815314858
6747 6747 6747 056 197401600 1017 Allston Way B 1017 ALLSTON WAY B 1017 ALLSTON WY 1017.0 ALLSTON WY B   Berkeley 94710 37.8663056681847 -122.29277885650008
6827 6827 6827 056 198800500 1244 Allston Way 1244 ALLSTON WAY 1244 ALLSTON WY 1244.0 ALLSTON WY     Berkeley 94702 37.866770370667545 -122.2871387750056
7188 7188 7188 056 199703600 1417 Allston Way A 1417 ALLSTON WAY A 1417 ALLSTON WY 1417.0 ALLSTON WY A   Berkeley 94702 37.86750780551968 -122.28308276651342
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
7330 7330 7330 056 199402400 1339 Allston Way 1339 ALLSTON WAY 1339 ALLSTON WY 1339.0 ALLSTON WY     Berkeley 94702 37.8672790290155 -122.28410539785308
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
7766 7766 7766 056 201003200 1701 Allston Way 2 1701 ALLSTON WAY 2 1701 ALLSTON WY 1701.0 ALLSTON WY 2   Berkeley 94703 37.86843046964853 -122.27701192936544
7879 7879 7879 056 197701500 1033 Allston Way 1033 ALLSTON WAY 1033 ALLSTON WY 1033.0 ALLSTON WY     Berkeley 94710 37.86644882336764 -122.2920563846362
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
8104 8104 8104 056 195800100 726 Allston Way 726 ALLSTON WAY 726 ALLSTON WY 726.0 ALLSTON WY     Berkeley 94710 37.8646316546055 -122.29862235699906
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
8509 8509 8509 056 199703600 1417 Allston Way B 1417 ALLSTON WAY B 1417 ALLSTON WY 1417.0 ALLSTON WY B   Berkeley 94702 37.86750780551968 -122.28308276651342
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
9124 9124 9124 056 201003200 1701 Allston Way 5 1701 ALLSTON WAY 5 1701 ALLSTON WY 1701.0 ALLSTON WY 5   Berkeley 94703 37.86843046964853 -122.27701192936544
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
9356 9356 9356 056 198601000 1203 Allston Way 1 1203 ALLSTON WAY 1 1203 ALLSTON WY 1203.0 ALLSTON WY 1   Berkeley 94702 37.86694326873318 -122.2887125263653

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