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

120 rows where street_name = "WALNUT" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, address_normalized, base_address, street_number

zipcode 1

  • 94704 · 120 ✖

street_type 1

street_name 1

  • WALNUT · 120 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
487 487 487 057 204600804 1922 Walnut St Apt 302 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 302 APT Berkeley 94704 37.87301096478544 -122.26741937740182
1204 1204 1204 057 204600804 1930 Walnut St 6 1930 WALNUT ST 6 1930 WALNUT ST 1930.0 WALNUT ST 6   Berkeley 94704 37.87269247261549 -122.26717808811988
2177 2177 2177 057 204600804 1922 Walnut St Apt 505 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 505 APT Berkeley 94704 37.87296353833269 -122.2673275821562
2922 2922 2922 057 204600804 1900 Walnut St 1900 WALNUT ST 1900 WALNUT ST 1900.0 WALNUT ST     Berkeley 94704 37.872622126820445 -122.2671592764995
3173 3173 3173 057 204600804 1924 Walnut St Apt 206 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 206 APT Berkeley 94704 37.872887830527006 -122.2672183335429
4260 4260 4260 057 204600804 1924 Walnut St Apt 202 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 202 APT Berkeley 94704 37.87287544242081 -122.26732185000635
5067 5067 5067 057 204600804 1924 Walnut St Apt 406 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 406 APT Berkeley 94704 37.87282890084748 -122.26720489744125
5102 5102 5102 057 204600804 1924 Walnut St Apt 605 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 605 APT Berkeley 94704 37.8727709915279 -122.2672166635748
5215 5215 5215 057 204600804 1922 Walnut St Apt 310 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 310 APT Berkeley 94704 37.87303400505884 -122.26722685316508
5945 5945 5945 057 204600804 1922 Walnut St Apt 410 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 410 APT Berkeley 94704 37.873004539574346 -122.26722013556338
5946 5946 5946 057 204600804 1924 Walnut St Apt 606 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 606 APT Berkeley 94704 37.87277388894503 -122.26719245667284
7625 7625 7625 057 204600804 1922 Walnut St Apt 211 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 211 APT Berkeley 94704 37.87306604671234 -122.2672120336578
7812 7812 7812 057 204600804 1924 Walnut St Apt 201 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 201 APT Berkeley 94704 37.87287234858492 -122.26734770262192
8013 8013 8013 057 204600804 1924 Walnut St Apt 604 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 604 APT Berkeley 94704 37.87276797285311 -122.2672418945562
8324 8324 8324 057 204600804 1922 Walnut St Apt 406 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 406 APT Berkeley 94704 37.872993888089134 -122.26730914243836
9773 9773 9773 057 204600804 1924 Walnut St Apt 306 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 306 APT Berkeley 94704 37.87285836569311 -122.26721161504292
10147 10147 10147 057 204600804 1922 Walnut St Apt 202 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 202 APT Berkeley 94704 37.87304043026735 -122.26742609590184
10154 10154 10154 057 204600804 1922 Walnut St Apt 305 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 305 APT Berkeley 94704 37.87302045617064 -122.26734006873863
10373 10373 10373 057 204600804 1922 Walnut St Apt 611 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 611 APT Berkeley 94704 37.87295210540599 -122.26718615678776
11524 11524 11524 057 204600804 1922 Walnut St 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST     Berkeley 94704 37.87308847288322 -122.2673174141255
11935 11935 11935 057 204600804 1924 Walnut St Apt 403 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 403 APT Berkeley 94704 37.87281981362913 -122.267280823049
12364 12364 12364 057 204600804 1922 Walnut St Apt 507 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 507 APT Berkeley 94704 37.87296909205539 -122.26728116979872
12412 12412 12412 057 204600804 1922 Walnut St Apt 402 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 402 APT Berkeley 94704 37.87298150000084 -122.26741265980012
12424 12424 12424 057 204600804 1922 Walnut St Apt 504 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 504 APT Berkeley 94704 37.87296051895668 -122.2673528131376
12917 12917 12917 057 204600804 1922 Walnut St Apt 510 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 510 APT Berkeley 94704 37.87297708723132 -122.26721436748092
12953 12953 12953 057 204600804 1922 Walnut St Apt 509 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 509 APT Berkeley 94704 37.872974401845084 -122.26723680560008
13799 13799 13799 057 204600804 1924 Walnut St Apt 603 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 603 APT Berkeley 94704 37.87276480242901 -122.26726838317896
14448 14448 14448 057 204500100 1921 Walnut St 7 1921 WALNUT ST 7 1921 WALNUT ST 1921.0 WALNUT ST 7   Berkeley 94704 37.87312847563548 -122.26682590451104
15729 15729 15729 057 204600804 1922 Walnut St Apt 306 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 306 APT Berkeley 94704 37.87302335357795 -122.26731586093835
15792 15792 15792 057 204600804 1922 Walnut St Apt 613 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 613 APT Berkeley 94704 37.87295740172386 -122.26714190128529
16687 16687 16687 057 204600804 1922 Walnut St Apt 602 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 602 APT Berkeley 94704 37.87292648892139 -122.26740021903174
16891 16891 16891 057 204600804 1924 Walnut St Apt 601 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 601 APT Berkeley 94704 37.872758406978996 -122.26732182485354
17436 17436 17436 057 204600804 1922 Walnut St Apt 303 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 303 APT Berkeley 94704 37.87301426638358 -122.2673917874445
17891 17891 17891 057 204600804 1924 Walnut St Apt 205 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 205 APT Berkeley 94704 37.87288493311435 -122.26724254044488
18615 18615 18615 057 204600804 1922 Walnut St Apt 503 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 503 APT Berkeley 94704 37.87295734854086 -122.26737930176036
19186 19186 19186 057 204600804 1922 Walnut St Apt 304 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 304 APT Berkeley 94704 37.87301743679696 -122.26736529972004
19474 19474 19474 057 204600804 1922 Walnut St Apt 208 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 208 APT Berkeley 94704 37.87305809905612 -122.26727844700513
20832 20832 20832 057 204600804 1922 Walnut St Apt 201 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 201 APT Berkeley 94704 37.87303733572932 -122.26745194851738
20849 20849 20849 057 204600804 1922 Walnut St Apt 204 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 204 APT Berkeley 94704 37.87304690156723 -122.26737201732172
21629 21629 21629 057 204600804 1922 Walnut St Apt 512 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 512 APT Berkeley 94704 37.87298218074296 -122.26717180350612
21876 21876 21876 057 204600804 1922 Walnut St Apt 513 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 513 APT Berkeley 94704 37.872984960440135 -122.26714857486952
21950 21950 21950 057 204600804 1922 Walnut St Apt 213 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 213 APT Berkeley 94704 37.873071343022026 -122.26716777815534
22592 22592 22592 057 204600804 1924 Walnut St Apt 302 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 302 APT Berkeley 94704 37.87284597758197 -122.26731513150636
23169 23169 23169 057 204600804 1924 Walnut St Apt 304 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 304 APT Berkeley 94704 37.87285244889892 -122.26726105382456
23439 23439 23439 057 204600804 1922 Walnut St Apt 506 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 506 APT Berkeley 94704 37.8729664357422 -122.26730337525424
23580 23580 23580 057 204600804 1924 Walnut St Apt 407 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 407 APT Berkeley 94704 37.87283155716564 -122.2671826919857
23762 23762 23762 057 204600804 1922 Walnut St Apt 203 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 203 APT Berkeley 94704 37.87304373115512 -122.26739850594451
24638 24638 24638 057 204600804 1922 Walnut St Apt 404 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 404 APT Berkeley 94704 37.87298797201495 -122.26735858122002
24642 24642 24642 057 204600804 1922 Walnut St Apt 601 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 601 APT Berkeley 94704 37.87292339437857 -122.267426070749
25338 25338 25338 057 204600804 1922 Walnut St Apt 603 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 603 APT Berkeley 94704 37.87292978981426 -122.26737262907442
25849 25849 25849 057 204600804 1922 Walnut St Apt 207 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 207 APT Berkeley 94704 37.87305547465589 -122.26730037398286
25925 25925 25925 057 204500100 1921 Walnut St 6 1921 WALNUT ST 6 1921 WALNUT ST 1921.0 WALNUT ST 6   Berkeley 94704 37.87312847563548 -122.26682590451104
26785 26785 26785 057 204600804 1924 Walnut St Apt 207 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 207 APT Berkeley 94704 37.872890487552105 -122.2671961280874
27165 27165 27165 057 204600804 1922 Walnut St Apt 501 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 501 APT Berkeley 94704 37.872950953107555 -122.26743274433323
27267 27267 27267 057 204600804 1930 Walnut St 2 1930 WALNUT ST 2 1930 WALNUT ST 1930.0 WALNUT ST 2   Berkeley 94704 37.87269247261549 -122.26717808811988
27408 27408 27408 057 204600804 1922 Walnut St Apt 604 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 604 APT Berkeley 94704 37.872932960231275 -122.26734614045164
27423 27423 27423 057 204600804 1922 Walnut St Apt 413 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 413 APT Berkeley 94704 37.87301241348929 -122.26715434205364
27826 27826 27826 057 204600804 1924 Walnut St Apt 501 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 501 APT Berkeley 94704 37.8727859657697 -122.26732849843778
28345 28345 28345 057 204500100 1921 Walnut St 8 1921 WALNUT ST 8 1921 WALNUT ST 1921.0 WALNUT ST 8   Berkeley 94704 37.87312847563548 -122.26682590451104
29844 29844 29844 057 204600804 1924 Walnut St Apt 507 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 507 APT Berkeley 94704 37.87280410475821 -122.26717692390324
30291 30291 30291 057 204600804 1924 Walnut St Apt 504 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 504 APT Berkeley 94704 37.87279553164025 -122.26724856814045
32761 32761 32761 057 204600804 1922 Walnut St Apt 408 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 408 APT Berkeley 94704 37.87299916951278 -122.26726501090336
33030 33030 33030 057 204600804 1922 Walnut St Apt 411 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 411 APT Berkeley 94704 37.873007117175376 -122.26719859755612
33215 33215 33215 057 204600804 1924 Walnut St Apt 204 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 204 APT Berkeley 94704 37.87288191444424 -122.26726777142628
33257 33257 33257 057 204600804 1922 Walnut St Apt 312 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 312 APT Berkeley 94704 37.873039098566544 -122.26718428919028
33762 33762 33762 057 204600804 1922 Walnut St Apt 605 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 605 APT Berkeley 94704 37.87293597960836 -122.26732090947026
34505 34505 34505 057 204600804 1922 Walnut St Apt 502 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 502 APT Berkeley 94704 37.87295404764922 -122.26740689171768
34927 34927 34927 057 204500100 1921 Walnut St 5 1921 WALNUT ST 5 1921 WALNUT ST 1921.0 WALNUT ST 5   Berkeley 94704 37.87312847563548 -122.26682590451104
35008 35008 35008 057 204600804 1924 Walnut St Apt 402 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 402 APT Berkeley 94704 37.87281651273139 -122.26730841390466
35161 35161 35161 057 204600804 1922 Walnut St Apt 209 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 209 APT Berkeley 94704 37.873060784439346 -122.26725600978423
35469 35469 35469 057 204600804 1922 Walnut St Apt 407 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 407 APT Berkeley 94704 37.87299654511046 -122.26728693698284
35772 35772 35772 057 204600804 1924 Walnut St Apt 305 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 305 APT Berkeley 94704 37.87285546827936 -122.2672358228432
36975 36975 36975 057 204500100 1921 Walnut St 2 1921 WALNUT ST 2 1921 WALNUT ST 1921.0 WALNUT ST 2   Berkeley 94704 37.87312847563548 -122.26682590451104
37637 37637 37637 057 204600804 1930 Walnut St 1930 WALNUT ST 1930 WALNUT ST 1930.0 WALNUT ST     Berkeley 94704 37.87269247261549 -122.26717808811988
38086 38086 38086 057 204600804 1922 Walnut St Apt 409 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 409 APT Berkeley 94704 37.873001854189056 -122.26724257278424
38168 38168 38168 057 204600804 1924 Walnut St Apt 404 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 404 APT Berkeley 94704 37.87282298405092 -122.26725433532457
38630 38630 38630 057 204600804 1924 Walnut St 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST     Berkeley 94704 37.87290619002269 -122.26727374342629
39002 39002 39002 057 204600804 1922 Walnut St Apt 608 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 608 APT Berkeley 94704 37.872944157737464 -122.267252570135
39157 39157 39157 057 204600804 1922 Walnut St Apt 301 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 301 APT Berkeley 94704 37.87300787095522 -122.2674452300174
39208 39208 39208 057 204600804 1924 Walnut St Apt 405 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 405 APT Berkeley 94704 37.87282600343252 -122.26722910434316
39945 39945 39945 057 204600804 1922 Walnut St Apt 412 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 412 APT Berkeley 94704 37.87300963308409 -122.26717757069028
40429 40429 40429 057 204600804 1922 Walnut St Apt 610 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 610 APT Berkeley 94704 37.87294952851211 -122.26720769479502
40833 40833 40833 057 204600804 1922 Walnut St Apt 609 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 609 APT Berkeley 94704 37.87294684312486 -122.26723013291418
41728 41728 41728 057 204500100 1921 Walnut St 3 1921 WALNUT ST 3 1921 WALNUT ST 1921.0 WALNUT ST 3   Berkeley 94704 37.87312847563548 -122.26682590451104
43598 43598 43598 057 204600804 1922 Walnut St Apt 606 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 606 APT Berkeley 94704 37.87293887701899 -122.26729670256827
43765 43765 43765 057 204600804 1924 Walnut St Apt 602 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 602 APT Berkeley 94704 37.87276150081967 -122.2672959731363
44179 44179 44179 057 204600804 1922 Walnut St Apt 313 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 313 APT Berkeley 94704 37.873041878261525 -122.26716106055366
44387 44387 44387 057 204600804 1922 Walnut St Apt 206 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 206 APT Berkeley 94704 37.873052818345805 -122.26732257943836
44571 44571 44571 057 204600804 1924 Walnut St Apt 401 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 401 APT Berkeley 94704 37.87281341818389 -122.26733426562193
44647 44647 44647 057 204600804 1930 Walnut St 1 1930 WALNUT ST 1 1930 WALNUT ST 1930.0 WALNUT ST 1   Berkeley 94704 37.87269247261549 -122.26717808811988
45765 45765 45765 057 204600804 1922 Walnut St Apt 309 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 309 APT Berkeley 94704 37.87303131967463 -122.26724929128424
46444 46444 46444 057 204600804 1922 Walnut St Apt 307 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 307 APT Berkeley 94704 37.87302600988904 -122.26729365548286
46805 46805 46805 057 204600804 1922 Walnut St Apt 205 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 205 APT Berkeley 94704 37.87304992093965 -122.26734678634033
46978 46978 46978 057 204600804 1930 Walnut St 4 1930 WALNUT ST 4 1930 WALNUT ST 1930.0 WALNUT ST 4   Berkeley 94704 37.87269247261549 -122.26717808811988
47093 47093 47093 057 204600804 1924 Walnut St Apt 503 1924 WALNUT ST 1924 WALNUT ST 1924.0 WALNUT ST 503 APT Berkeley 94704 37.87279236121732 -122.26727505586489
47452 47452 47452 057 204500100 1921 Walnut St 1921 WALNUT ST 1921 WALNUT ST 1921.0 WALNUT ST     Berkeley 94704 37.87312847563548 -122.26682590451104
48148 48148 48148 057 204600804 1922 Walnut St Apt 212 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 212 APT Berkeley 94704 37.873068563328104 -122.26719100769029
48234 48234 48234 057 204500600 1925 Walnut St 1925 WALNUT ST 1925 WALNUT ST 1925.0 WALNUT ST     Berkeley 94704 37.87300706753795 -122.26680047410368
48928 48928 48928 057 204600804 1922 Walnut St Apt 607 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 607 APT Berkeley 94704 37.87294153333318 -122.2672744971128
49298 49298 49298 057 204500100 1921 Walnut St 1 1921 WALNUT ST 1 1921 WALNUT ST 1921.0 WALNUT ST 1   Berkeley 94704 37.87312847563548 -122.26682590451104

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