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

259 rows where street_name = "CENTER" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, unit_type

zipcode 1

street_type 1

  • ST · 259 ✖

street_name 1

  • CENTER · 259 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
60 60 60 057 202200800 1907 Center St 1 1907 CENTER ST 1 1907 CENTER ST 1907.0 CENTER ST 1   Berkeley 94704 37.87002797917772 -122.2722691830931
176 176 176 057 202302600 2055 Center St Apt 904 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 904 APT Berkeley 94704 37.87050590474006 -122.26952670648076
240 240 240 057 202302600 2055 Center St Apt 312 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 312 APT Berkeley 94704 37.87036130159193 -122.26926794047496
340 340 340 057 203101100 2130 Center St Unit 301 2130 CENTER ST 2130 CENTER ST 2130.0 CENTER ST 301 UNIT Berkeley 94704 37.87025257177367 -122.26709881718594
466 466 466 057 202200800 1907 Center St 2 1907 CENTER ST 2 1907 CENTER ST 1907.0 CENTER ST 2   Berkeley 94704 37.87002797917772 -122.2722691830931
589 589 589 057 202302600 2055 Center St Apt 817 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 817 APT Berkeley 94704 37.87052253455192 -122.2691756080368
879 879 879 057 202302600 2055 Center St Apt 415 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 415 APT Berkeley 94704 37.870400680371176 -122.2691960671674
2057 2057 2057 057 202200600 1947 Center St 1947 CENTER ST 1947 CENTER ST 1947.0 CENTER ST     Berkeley 94704 37.870162635964206 -122.2712285692781
2155 2155 2155 057 203100900 2112 Center St 2112 CENTER ST 2112 CENTER ST 2112.0 CENTER ST     Berkeley 94704 37.87015311584553 -122.26745737434167
2942 2942 2942 057 203101100 2130 Center St Unit 12 2130 CENTER ST 2130 CENTER ST 2130.0 CENTER ST 12 UNIT Berkeley 94704 37.87000368846822 -122.26696316528984
3152 3152 3152 057 203100102 2138 Center St 9 2138 CENTER ST 9 2138 CENTER ST 2138.0 CENTER ST 9   Berkeley 94704 37.87024313179856 -122.26677125011084
3252 3252 3252 057 202302600 2055 Center St Apt 604 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 604 APT Berkeley 94704 37.87041746834302 -122.26950128685314
3324 3324 3324 057 203100102 2154 Center St 2154 CENTER ST 2154 CENTER ST 2154.0 CENTER ST     Berkeley 94704 37.87028874249636 -122.26643335779988
3401 3401 3401 057 202302600 2055 Center St Apt 714 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 714 APT Berkeley 94704 37.870481938969846 -122.26924768077036
3421 3421 3421 057 202302600 2055 Center St Apt 603 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 603 APT Berkeley 94704 37.87041426448861 -122.26952566174003
3539 3539 3539 057 202302600 2041 Center St 2041 CENTER ST 2041 CENTER ST 2041.0 CENTER ST     Berkeley 94704 37.87026386683843 -122.269368922791
3543 3543 3543 057 202302600 2055 Center St Apt 207 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 207 APT Berkeley 94704 37.87031565477332 -122.26939253860148
3653 3653 3653 057 203100102 2140 Center St 2140 CENTER ST 2140 CENTER ST 2140.0 CENTER ST     Berkeley 94704 37.87019458951573 -122.2666843560734
3800 3800 3800 057 202302600 2055 Center St Apt 502 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 502 APT Berkeley 94704 37.87038227628496 -122.26954136698618
4128 4128 4128 057 202302600 2055 Center St Apt 519 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 519 APT Berkeley 94704 37.87044267511321 -122.26910069662692
4334 4334 4334 057 203101100 2130 Center St Unit 7 2130 CENTER ST 2130 CENTER ST 2130.0 CENTER ST 7 UNIT Berkeley 94704 37.870136628486165 -122.26697744940115
4337 4337 4337 057 202302600 2055 Center St Apt 419 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 419 APT Berkeley 94704 37.87041477009912 -122.26909326396628
5124 5124 5124 057 202302600 2055 Center St Apt 313 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 313 APT Berkeley 94704 37.87036482030307 -122.26924162971858
5161 5161 5161 057 202302600 2055 Center St Apt 407 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 407 APT Berkeley 94704 37.870371442883 -122.26940890949923
5333 5333 5333 057 202302600 2055 Center St Apt 907 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 907 APT Berkeley 94704 37.87051626158679 -122.2694507134993
5353 5353 5353 057 202200800 1907 Center St 9 1907 CENTER ST 9 1907 CENTER ST 1907.0 CENTER ST 9   Berkeley 94704 37.87002797917772 -122.2722691830931
5451 5451 5451 057 202302600 2055 Center St Apt 706 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 706 APT Berkeley 94704 37.8704528738327 -122.2694603066082
5462 5462 5462 057 203100102 2138 Center St 4 2138 CENTER ST 4 2138 CENTER ST 2138.0 CENTER ST 4   Berkeley 94704 37.87024313179856 -122.26677125011084
5567 5567 5567 057 202302600 2055 Center St Apt 816 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 816 APT Berkeley 94704 37.870518931461774 -122.26920189274198
6489 6489 6489 057 202301300 2001 Center St 2001 CENTER ST 2001 CENTER ST 2001.0 CENTER ST     Berkeley 94704 37.87021091021583 -122.27030719783389
6537 6537 6537 057 202302600 2055 Center St Apt 209 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 209 APT Berkeley 94704 37.87032241563833 -122.26934213592752
6909 6909 6909 057 202302600 2055 Center St Apt 406 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 406 APT Berkeley 94704 37.87036801210444 -122.26943497232055
7170 7170 7170 057 202302600 2055 Center St Apt 505 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 505 APT Berkeley 94704 37.87039261896643 -122.26946623369246
7464 7464 7464 057 202302600 2055 Center St Apt 716 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 716 APT Berkeley 94704 37.87048923875881 -122.2691944169622
7580 7580 7580 057 202302600 2055 Center St Apt 314 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 314 APT Berkeley 94704 37.87036858721012 -122.2692141466608
7622 7622 7622 057 202302600 2055 Center St Apt 509 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 509 APT Berkeley 94704 37.87040610877089 -122.26936593948592
7794 7794 7794 057 202302600 2055 Center St Apt 814 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 814 APT Berkeley 94704 37.87051163096667 -122.26925515655014
7882 7882 7882 057 202302600 2055 Center St Apt 411 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 411 APT Berkeley 94704 37.87038587441785 -122.26930401771509
8147 8147 8147 057 202302600 2055 Center St Apt 418 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 418 APT Berkeley 94704 37.87041140101698 -122.26911784277075
8641 8641 8641 057 202302600 2055 Center St Apt 820 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 820 APT Berkeley 94704 37.87053288714153 -122.26910007858602
8684 8684 8684 057 202200800 1907 Center St 3 1907 CENTER ST 3 1907 CENTER ST 1907.0 CENTER ST 3   Berkeley 94704 37.87002797917772 -122.2722691830931
9084 9084 9084 057 202302600 2055 Center St Apt 206 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 206 APT Berkeley 94704 37.870312224701316 -122.2694186014228
9182 9182 9182 057 203100102 2138 Center St 2 2138 CENTER ST 2 2138 CENTER ST 2138.0 CENTER ST 2   Berkeley 94704 37.87024313179856 -122.26677125011084
9226 9226 9226 057 203100102 2152 Center St 2152 CENTER ST 2152 CENTER ST 2152.0 CENTER ST     Berkeley 94704 37.87022541624108 -122.2664261362433
9452 9452 9452 057 202302600 2055 Center St Apt 205 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 205 APT Berkeley 94704 37.87030892581855 -122.26944243013403
9507 9507 9507 057 202302600 2055 Center St Apt 720 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 720 APT Berkeley 94704 37.87050319515327 -122.26909260370452
10046 10046 10046 057 203200503 2119 Center St 2119 CENTER ST 2119 CENTER ST 2119.0 CENTER ST     Berkeley 94704 37.87075645492686 -122.267187770162
10057 10057 10057 057 203100102 2138 Center St 17 2138 CENTER ST 17 2138 CENTER ST 2138.0 CENTER ST 17   Berkeley 94704 37.87024313179856 -122.26677125011084
10064 10064 10064 057 202302600 2055 Center St Apt 213 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 213 APT Berkeley 94704 37.87033752298549 -122.26923345864274
10514 10514 10514 057 202302600 2055 Center St Apt 310 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 310 APT Berkeley 94704 37.87035365786144 -122.26932385610982
10761 10761 10761 057 203100102 2144 Center St 2144 CENTER ST 2144 CENTER ST 2144.0 CENTER ST     Berkeley 94704 37.87019570143668 -122.26661007797584
10923 10923 10923 057 202302600 2055 Center St Apt 317 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 317 APT Berkeley 94704 37.87037949081655 -122.26913459814742
10936 10936 10936 057 203100102 2138 Center St 7 2138 CENTER ST 7 2138 CENTER ST 2138.0 CENTER ST 7   Berkeley 94704 37.87024313179856 -122.26677125011084
10957 10957 10957 057 203100102 2148 Center St 2148 CENTER ST 2148 CENTER ST 2148.0 CENTER ST     Berkeley 94704 37.870210571959326 -122.2665246940064
11013 11013 11013 057 202302600 2055 Center St Apt 901 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 901 APT Berkeley 94704 37.87049588118312 -122.26959987336232
11586 11586 11586 057 202302600 2055 Center St Apt 201 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 201 APT Berkeley 94704 37.87029527502329 -122.26954169846452
12342 12342 12342 057 203101100 2130 Center St Unit 5 2130 CENTER ST 2130 CENTER ST 2130.0 CENTER ST 5 UNIT Berkeley 94704 37.870189131316856 -122.26698339714667
12398 12398 12398 057 202302600 2055 Center St Apt 204 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 204 APT Berkeley 94704 37.870305297898376 -122.26946853158296
12409 12409 12409 057 202302600 2055 Center St Apt 708 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 708 APT Berkeley 94704 37.87045977154739 -122.26940930116469
12423 12423 12423 057 202302600 2055 Center St Apt 408 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 408 APT Berkeley 94704 37.87037491053622 -122.26938396597872
12450 12450 12450 057 202302600 2055 Center St Apt 309 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 309 APT Berkeley 94704 37.87034971367064 -122.26935030700336
12542 12542 12542 057 202600201 2080 Center St 2080 CENTER ST 2080 CENTER ST 2080.0 CENTER ST     Berkeley 94704 37.8700168202307 -122.26862356095536
12915 12915 12915 057 202302600 2055 Center St Apt 710 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 710 APT Berkeley 94704 37.870467008934995 -122.26935739021935
13081 13081 13081 057 203100102 2138 Center St 2138 CENTER ST 2138 CENTER ST 2138.0 CENTER ST     Berkeley 94704 37.87024313179856 -122.26677125011084
13179 13179 13179 057 202302600 2055 Center St Apt 902 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 902 APT Berkeley 94704 37.870499189985296 -122.2695757383256
13379 13379 13379 057 202200800 1907 Center St 5 1907 CENTER ST 5 1907 CENTER ST 1907.0 CENTER ST 5   Berkeley 94704 37.87002797917772 -122.2722691830931
13517 13517 13517 057 202302600 2055 Center St Apt 308 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 308 APT Berkeley 94704 37.8703464204627 -122.26937576705514
13689 13689 13689 057 203101100 2130 Center St Unit 101 2130 CENTER ST 2130 CENTER ST 2130.0 CENTER ST 101 UNIT Berkeley 94704 37.8702869313723 -122.2670334638507
13895 13895 13895 057 202302600 2055 Center St Apt 515 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 515 APT Berkeley 94704 37.87042858539066 -122.26920350072636
14345 14345 14345 057 202302600 2055 Center St Apt 715 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 715 APT Berkeley 94704 37.8704855420618 -122.26922140235332
14506 14506 14506 057 203100102 2138 Center St B 2138 CENTER ST B 2138 CENTER ST 2138.0 CENTER ST B   Berkeley 94704 37.87024313179856 -122.26677125011084
14559 14559 14559 057 202302600 2055 Center St Apt 707 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 707 APT Berkeley 94704 37.870456303898166 -122.26943424378688
14779 14779 14779 057 202302600 2055 Center St Apt 316 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 316 APT Berkeley 94704 37.870375887719405 -122.26916088285266
15410 15410 15410 057 202302600 2055 Center St Apt 413 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 413 APT Berkeley 94704 37.870393310369465 -122.2692498286422
15433 15433 15433 057 202302600 2055 Center St Apt 810 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 810 APT Berkeley 94704 37.870496701646985 -122.26936486599914
15588 15588 15588 057 202302600 2055 Center St Apt 811 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 811 APT Berkeley 94704 37.870500428126874 -122.26933682778252
15692 15692 15692 057 202302600 2055 Center St Apt 606 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 606 APT Berkeley 94704 37.870424395844545 -122.2694513557947
15722 15722 15722 057 202302600 2055 Center St Apt 806 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 806 APT Berkeley 94704 37.87048256584123 -122.269467782388
15906 15906 15906 057 203101000 2124 Center St 1 2124 CENTER ST 1 2124 CENTER ST 2124.0 CENTER ST 1   Berkeley 94704 37.870126144651096 -122.2671899566614
15920 15920 15920 057 202302600 2055 Center St Apt 302 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 302 APT Berkeley 94704 37.87032588116648 -122.26952573450362
15986 15986 15986 057 202302600 2055 Center St Apt 805 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 805 APT Berkeley 94704 37.87047926767524 -122.2694916110992
16506 16506 16506 057 202302600 2055 Center St Apt 711 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 711 APT Berkeley 94704 37.870470736125526 -122.26932935200271
16566 16566 16566 057 202302600 2055 Center St Apt 303 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 303 APT Berkeley 94704 37.87032939136975 -122.26950107844402
16676 16676 16676 057 202302600 2055 Center St Ste B 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST B STE Berkeley 94704 37.870274759823346 -122.26948433025385
16773 16773 16773 057 202302600 2057 Center St 2057 CENTER ST 2057 CENTER ST 2057.0 CENTER ST     Berkeley 94704 37.87028391401403 -122.26923255403928
16799 16799 16799 057 202200800 1907 Center St 7 1907 CENTER ST 7 1907 CENTER ST 1907.0 CENTER ST 7   Berkeley 94704 37.87002797917772 -122.2722691830931
17070 17070 17070 057 203100101 2160 Center St 2160 CENTER ST 2160 CENTER ST 2160.0 CENTER ST     Berkeley 94704 37.87025993966203 -122.26617633093244
17289 17289 17289 057 203100102 2136 Center St 2136 CENTER ST 2136 CENTER ST 2136.0 CENTER ST     Berkeley 94704 37.87018441912583 -122.26675842037196
17492 17492 17492 057 202601000 2016 Center St 2016 CENTER ST 2016 CENTER ST 2016.0 CENTER ST     Berkeley 94704 37.869781036022246 -122.26994524953794
17744 17744 17744 057 203100102 2146 Center St 2146 CENTER ST 2146 CENTER ST 2146.0 CENTER ST     Berkeley 94704 37.87026364346169 -122.26661169673996
18035 18035 18035 057 202302600 2055 Center St Apt 705 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 705 APT Berkeley 94704 37.870449574956275 -122.26948413531944
18330 18330 18330 057 203101000 2124 Center St 3 2124 CENTER ST 3 2124 CENTER ST 2124.0 CENTER ST 3   Berkeley 94704 37.870126144651096 -122.2671899566614
18983 18983 18983 057 202302600 2055 Center St Apt 301 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 301 APT Berkeley 94704 37.87032257235652 -122.26954986954034
19245 19245 19245 057 203100102 2138 Center St 15 2138 CENTER ST 15 2138 CENTER ST 2138.0 CENTER ST 15   Berkeley 94704 37.87024313179856 -122.26677125011084
20239 20239 20239 057 202302600 2057 Center St Ste 107 2057 CENTER ST 2057 CENTER ST 2057.0 CENTER ST 107 STE Berkeley 94704 37.87027622560016 -122.26928332142924
20490 20490 20490 057 202302600 2055 Center St Apt 704 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 704 APT Berkeley 94704 37.87044594704299 -122.2695102376666
20627 20627 20627 057 203100900 2110 Center St 2110 CENTER ST 2110 CENTER ST 2110.0 CENTER ST     Berkeley 94704 37.87015311584553 -122.26745737434167
20829 20829 20829 057 202302600 2057 Center St Ste 106 2057 CENTER ST 2057 CENTER ST 2057.0 CENTER ST 106 STE Berkeley 94704 37.87027291678796 -122.26930745646597
20861 20861 20861 057 202302600 2055 Center St Apt 802 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 802 APT Berkeley 94704 37.87046892500594 -122.26956674439296
20949 20949 20949 057 202302600 2055 Center St Apt 712 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 712 APT Berkeley 94704 37.87047465336285 -122.2693014745845

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