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

273 rows where street_type = "PL"

✎ View and edit SQL

This data as json, CSV (advanced)

street_name 12

zipcode 5

street_type 1

  • PL · 273 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
826 826 826 061 260202000 853 Station Pl 853 STATION PL 853 STATION PL 853.0 STATION PL     Berkeley 94707 37.89217451521174 -122.27813980373054
1422 1422 1422 064 423900600 2 Encina Pl 2 ENCINA PL 2 ENCINA PL 2.0 ENCINA PL     Berkeley 94705 37.85503624186746 -122.2466433822592
1774 1774 1774 061 262001200 1564 Beverly Pl 1564 BEVERLY PL 1564 BEVERLY PL 1564.0 BEVERLY PL     Berkeley 94707 37.88545578507559 -122.28094874669075
2028 2028 2028 062 289401000 14 Menlo Pl 14 MENLO PL 14 MENLO PL 14.0 MENLO PL     Berkeley 94707 37.89785729329466 -122.28295823216727
2273 2273 2273 060 246501000 1304 Bay View Pl 2 1304 BAY VIEW PL 2 1304 BAY VIEW PL 1304.0 BAY VIEW PL 2   Berkeley 94708 37.88441967577247 -122.26332487250647
2295 2295 2295 061 260700300 1608 Beverly Pl 1608 BEVERLY PL 1608 BEVERLY PL 1608.0 BEVERLY PL     Berkeley 94707 37.88521445423515 -122.28023074125048
2380 2380 2380 052 156708500 2723 Ashby Pl D 2723 ASHBY PL D 2723 ASHBY PL 2723.0 ASHBY PL D   Berkeley 94705 37.85771382194868 -122.2524407857094
2967 2967 2967 058 220300401 1771 Highland Pl 305 1771 HIGHLAND PL 305 1771 HIGHLAND PL 1771.0 HIGHLAND PL 305   Berkeley 94709 37.8765999380066 -122.25547659190642
3042 3042 3042 060 246501600 1324 Bay View Pl 1324 BAY VIEW PL 1324 BAY VIEW PL 1324.0 BAY VIEW PL     Berkeley 94708 37.88397975287476 -122.26448519132468
3259 3259 3259 058 220300300 1735 Highland Pl 36 1735 HIGHLAND PL 36 1735 HIGHLAND PL 1735.0 HIGHLAND PL 36   Berkeley 94709 37.876824649545625 -122.25551614742336
3260 3260 3260 062 289500400 84 Menlo Pl 84 MENLO PL 84 MENLO PL 84.0 MENLO PL     Berkeley 94707 37.898546813434166 -122.28199914046432
3688 3688 3688 058 220300401 1771 Highland Pl 308 1771 HIGHLAND PL 308 1771 HIGHLAND PL 1771.0 HIGHLAND PL 308   Berkeley 94709 37.8765999380066 -122.25547659190642
4457 4457 4457 052 157501600 2400 Dowling Pl 8 2400 DOWLING PL 8 2400 DOWLING PL 2400.0 DOWLING PL 8   Berkeley 94705 37.85416096991615 -122.25960038816824
4730 4730 4730 058 220300401 1771 Highland Pl 202 1771 HIGHLAND PL 202 1771 HIGHLAND PL 1771.0 HIGHLAND PL 202   Berkeley 94709 37.8765999380066 -122.25547659190642
4943 4943 4943 052 157400700 2417 Dowling Pl 2417 DOWLING PL 2417 DOWLING PL 2417.0 DOWLING PL     Berkeley 94705 37.85469074764908 -122.25917767243656
5178 5178 5178 061 260601001 1735 Beverly Pl 1735 BEVERLY PL 1735 BEVERLY PL 1735.0 BEVERLY PL     Berkeley 94707 37.88479963655695 -122.27685088479122
5525 5525 5525 062 290702300 11 Menlo Pl 11 MENLO PL 11 MENLO PL 11.0 MENLO PL     Berkeley 94707 37.89764983175333 -122.28348776477274
5577 5577 5577 061 262000900 1554 Beverly Pl 1554 BEVERLY PL 1554 BEVERLY PL 1554.0 BEVERLY PL     Berkeley 94707 37.88549813069102 -122.28143754429136
5759 5759 5759 062 290701700 45 Menlo Pl 45 MENLO PL 45 MENLO PL 45.0 MENLO PL     Berkeley 94707 37.89845860706008 -122.28314852498885
5910 5910 5910 062 290702400 7 Menlo Pl 7 MENLO PL 7 MENLO PL 7.0 MENLO PL     Berkeley 94707 37.897508785841 -122.28347207749292
6025 6025 6025 062 290702100 25 Menlo Pl 25 MENLO PL 25 MENLO PL 25.0 MENLO PL     Berkeley 94707 37.89792755544235 -122.28360701702502
6174 6174 6174 061 262901800 1555 Beverly Pl 1555 BEVERLY PL 1555 BEVERLY PL 1555.0 BEVERLY PL     Berkeley 94707 37.88591424683435 -122.28124739609856
6338 6338 6338 058 220300401 1771 Highland Pl 207 1771 HIGHLAND PL 207 1771 HIGHLAND PL 1771.0 HIGHLAND PL 207   Berkeley 94709 37.8765999380066 -122.25547659190642
6437 6437 6437 052 156708500 2723 Ashby Pl C 2723 ASHBY PL C 2723 ASHBY PL 2723.0 ASHBY PL C   Berkeley 94705 37.85771382194868 -122.2524407857094
6477 6477 6477 058 220200500 1812 Highland Pl 1812 HIGHLAND PL 1812 HIGHLAND PL 1812.0 HIGHLAND PL     Berkeley 94709 37.876390321251925 -122.25600438088192
6719 6719 6719 052 156701000 2737 Ashby Pl 3 2737 ASHBY PL 3 2737 ASHBY PL 2737.0 ASHBY PL 3   Berkeley 94705 37.857924003209256 -122.25182836555268
7004 7004 7004 063 316101200 11 Ajax Pl 11 AJAX PL 11 AJAX PL 11.0 AJAX PL     Berkeley 94708 37.888678382933215 -122.250078273106
7167 7167 7167 061 257800400 30 Somerset Pl 30 SOMERSET PL 30 SOMERSET PL 30.0 SOMERSET PL     Berkeley 94707 37.89446933965975 -122.27363931063242
7178 7178 7178 060 243700300 1712 Beverly Pl 1712 BEVERLY PL 1712 BEVERLY PL 1712.0 BEVERLY PL     Berkeley 94707 37.8846386759032 -122.27793248244444
7553 7553 7553 058 220300401 1771 Highland Pl 6 1771 HIGHLAND PL 6 1771 HIGHLAND PL 1771.0 HIGHLAND PL 6   Berkeley 94709 37.8765999380066 -122.25547659190642
7569 7569 7569 052 157400800 2407 Dowling Pl 3 2407 DOWLING PL 3 2407 DOWLING PL 2407.0 DOWLING PL 3   Berkeley 94705 37.85466371263424 -122.25938489939958
7639 7639 7639 058 220300300 1735 Highland Pl 21 1735 HIGHLAND PL 21 1735 HIGHLAND PL 1735.0 HIGHLAND PL 21   Berkeley 94709 37.876824649545625 -122.25551614742336
7953 7953 7953 060 246501501 1322 Bay View Pl 1322 BAY VIEW PL 1322 BAY VIEW PL 1322.0 BAY VIEW PL     Berkeley 94708 37.88411425086696 -122.26435509281364
8586 8586 8586 060 249501001 1 Atlas Pl 1 ATLAS PL 1 ATLAS PL 1.0 ATLAS PL     Berkeley 94708 37.887317614279674 -122.24982396903224
8613 8613 8613 058 220300401 1771 Highland Pl 304 1771 HIGHLAND PL 304 1771 HIGHLAND PL 1771.0 HIGHLAND PL 304   Berkeley 94709 37.8765999380066 -122.25547659190642
8794 8794 8794 063 316102200 7 Ajax Pl 7 AJAX PL 7 AJAX PL 7.0 AJAX PL     Berkeley 94708 37.88848865561094 -122.24961051225274
9043 9043 9043 062 290700900 89 Menlo Pl 89 MENLO PL 89 MENLO PL 89.0 MENLO PL     Berkeley 94707 37.89890859073553 -122.28180234563668
9469 9469 9469 058 220300401 1771 Highland Pl 203 1771 HIGHLAND PL 203 1771 HIGHLAND PL 1771.0 HIGHLAND PL 203   Berkeley 94709 37.8765999380066 -122.25547659190642
10053 10053 10053 052 156701200 2731 Ashby Pl 1 2731 ASHBY PL 1 2731 ASHBY PL 2731.0 ASHBY PL 1   Berkeley 94705 37.85792729342615 -122.25217050330168
10089 10089 10089 061 260700600 1618 Beverly Pl 1618 BEVERLY PL 1618 BEVERLY PL 1618.0 BEVERLY PL     Berkeley 94707 37.88511460303892 -122.27980553538885
10149 10149 10149 061 260603900 1631 Beverly Pl 1631 BEVERLY PL 1631 BEVERLY PL 1631.0 BEVERLY PL     Berkeley 94707 37.88539819551001 -122.27902470626914
10511 10511 10511 061 260601400 1721 Beverly Pl 1721 BEVERLY PL 1721 BEVERLY PL 1721.0 BEVERLY PL     Berkeley 94707 37.88502249317518 -122.27741202641658
10529 10529 10529 058 220300401 1771 Highland Pl 107 1771 HIGHLAND PL 107 1771 HIGHLAND PL 1771.0 HIGHLAND PL 107   Berkeley 94709 37.8765999380066 -122.25547659190642
10670 10670 10670 060 243700200 1708 Beverly Pl 1708 BEVERLY PL 1708 BEVERLY PL 1708.0 BEVERLY PL     Berkeley 94707 37.88467857950481 -122.27806227552828
11233 11233 11233 060 246501700 1328 Bay View Pl 1328 BAY VIEW PL 1328 BAY VIEW PL 1328.0 BAY VIEW PL     Berkeley 94708 37.88371953928389 -122.26447552814716
11628 11628 11628 061 260700500 1614 Beverly Pl 1614 BEVERLY PL 1614 BEVERLY PL 1614.0 BEVERLY PL     Berkeley 94707 37.88514826940391 -122.27994842680782
11732 11732 11732 062 289400100 30 Menlo Pl 30 MENLO PL 30 MENLO PL 30.0 MENLO PL     Berkeley 94707 37.89806584732095 -122.28313994338296
11804 11804 11804 058 220300300 1735 Highland Pl 37 1735 HIGHLAND PL 37 1735 HIGHLAND PL 1735.0 HIGHLAND PL 37   Berkeley 94709 37.876824649545625 -122.25551614742336
12205 12205 12205 058 220300801 1831 Highland Pl 1831 HIGHLAND PL 1831 HIGHLAND PL 1831.0 HIGHLAND PL     Berkeley 94709 37.87589902022836 -122.25549635394437
12444 12444 12444 060 243700500 1718 Beverly Pl 1718 BEVERLY PL 1718 BEVERLY PL 1718.0 BEVERLY PL     Berkeley 94707 37.884584961772894 -122.2776764006047
12469 12469 12469 061 260601500 1717 Beverly Pl 1717 BEVERLY PL 1717 BEVERLY PL 1717.0 BEVERLY PL     Berkeley 94707 37.885058605598466 -122.2775601154878
12939 12939 12939 058 220300401 1771 Highland Pl 306 1771 HIGHLAND PL 306 1771 HIGHLAND PL 1771.0 HIGHLAND PL 306   Berkeley 94709 37.8765999380066 -122.25547659190642
13010 13010 13010 052 156708500 2723 Ashby Pl E 2723 ASHBY PL E 2723 ASHBY PL 2723.0 ASHBY PL E   Berkeley 94705 37.85771382194868 -122.2524407857094
13075 13075 13075 052 156701000 2737 Ashby Pl Frnt 2737 ASHBY PL FRNT 2737 ASHBY PL 2737.0 ASHBY PL FRNT   Berkeley 94705 37.857924003209256 -122.25182836555268
13772 13772 13772 063 316102100 9 Ajax Pl 9 AJAX PL 9 AJAX PL 9.0 AJAX PL     Berkeley 94708 37.888822628968185 -122.24963385587372
13987 13987 13987 052 156700800 2741 Ashby Pl 2741 ASHBY PL 2741 ASHBY PL 2741.0 ASHBY PL     Berkeley 94705 37.85794590063194 -122.2515413089036
14518 14518 14518 062 289500200 66 Menlo Pl 66 MENLO PL 66 MENLO PL 66.0 MENLO PL     Berkeley 94707 37.8984702387616 -122.28222084108312
14638 14638 14638 061 260604400 1615 Beverly Pl 1615 BEVERLY PL 1615 BEVERLY PL 1615.0 BEVERLY PL     Berkeley 94707 37.88555482331191 -122.2796973701438
14837 14837 14837 058 220405300 1780 Highland Pl 1780 HIGHLAND PL 1780 HIGHLAND PL 1780.0 HIGHLAND PL     Berkeley 94709 37.8768542943148 -122.25618647567823
14912 14912 14912 062 290701500 53 Menlo Pl 53 MENLO PL 53 MENLO PL 53.0 MENLO PL     Berkeley 94707 37.898658472313414 -122.28287663729168
15037 15037 15037 058 220300401 1771 Highland Pl 105 1771 HIGHLAND PL 105 1771 HIGHLAND PL 1771.0 HIGHLAND PL 105   Berkeley 94709 37.8765999380066 -122.25547659190642
15110 15110 15110 052 157400800 2407 Dowling Pl 2 2407 DOWLING PL 2 2407 DOWLING PL 2407.0 DOWLING PL 2   Berkeley 94705 37.85466371263424 -122.25938489939958
15322 15322 15322 052 157501600 2400 Dowling Pl 3 2400 DOWLING PL 3 2400 DOWLING PL 2400.0 DOWLING PL 3   Berkeley 94705 37.85416096991615 -122.25960038816824
15366 15366 15366 052 156701300 2727 Ashby Pl A 2727 ASHBY PL A 2727 ASHBY PL 2727.0 ASHBY PL A   Berkeley 94705 37.85793532569679 -122.2523830518844
15674 15674 15674 061 260601001 1733 Beverly Pl 1733 BEVERLY PL 1733 BEVERLY PL 1733.0 BEVERLY PL     Berkeley 94707 37.88479963655695 -122.27685088479122
16005 16005 16005 058 220300300 1735 Highland Pl 4 1735 HIGHLAND PL 4 1735 HIGHLAND PL 1735.0 HIGHLAND PL 4   Berkeley 94709 37.876824649545625 -122.25551614742336
16079 16079 16079 058 220300401 1771 Highland Pl 2 1771 HIGHLAND PL 2 1771 HIGHLAND PL 1771.0 HIGHLAND PL 2   Berkeley 94709 37.8765999380066 -122.25547659190642
16231 16231 16231 058 220300300 1735 Highland Pl 2 1735 HIGHLAND PL 2 1735 HIGHLAND PL 1735.0 HIGHLAND PL 2   Berkeley 94709 37.876824649545625 -122.25551614742336
16267 16267 16267 061 260604600 1609 Beverly Pl 1609 BEVERLY PL 1609 BEVERLY PL 1609.0 BEVERLY PL     Berkeley 94707 37.88561620795077 -122.27996225726991
16435 16435 16435 061 259803300 49 Somerset Pl 49 SOMERSET PL 49 SOMERSET PL 49.0 SOMERSET PL     Berkeley 94707 37.895056384131095 -122.27383130755813
16731 16731 16731 061 262901900 1551 Beverly Pl 1551 BEVERLY PL 1551 BEVERLY PL 1551.0 BEVERLY PL     Berkeley 94707 37.88594647005621 -122.28138594056988
16751 16751 16751 061 260700100 1600 Beverly Pl 1600 BEVERLY PL 1600 BEVERLY PL 1600.0 BEVERLY PL     Berkeley 94707 37.88528595074499 -122.2805461855608
17280 17280 17280 052 157400700 2415 Dowling Pl 2415 DOWLING PL 2415 DOWLING PL 2415.0 DOWLING PL     Berkeley 94705 37.85469074764908 -122.25917767243656
17511 17511 17511 060 246501200 1310 Bay View Pl 1310 BAY VIEW PL 1310 BAY VIEW PL 1310.0 BAY VIEW PL     Berkeley 94708 37.884325615297165 -122.26363545333788
17516 17516 17516 058 220300300 1735 Highland Pl 28 1735 HIGHLAND PL 28 1735 HIGHLAND PL 1735.0 HIGHLAND PL 28   Berkeley 94709 37.876824649545625 -122.25551614742336
17672 17672 17672 061 262902100 1545 Beverly Pl 1545 BEVERLY PL 1545 BEVERLY PL 1545.0 BEVERLY PL     Berkeley 94707 37.8860111397866 -122.28166300705465
17841 17841 17841 061 260701100 1634 Beverly Pl 1634 BEVERLY PL 1634 BEVERLY PL 1634.0 BEVERLY PL     Berkeley 94707 37.88494536205615 -122.27908667115916
18290 18290 18290 060 243700600 1722 Beverly Pl 1722 BEVERLY PL 1722 BEVERLY PL 1722.0 BEVERLY PL     Berkeley 94707 37.884599122523305 -122.2775206947182
18312 18312 18312 061 260604300 1619 Beverly Pl 1619 BEVERLY PL 1619 BEVERLY PL 1619.0 BEVERLY PL     Berkeley 94707 37.88552305508754 -122.27956058816704
18706 18706 18706 062 290701600 51 Menlo Pl 51 MENLO PL 51 MENLO PL 51.0 MENLO PL     Berkeley 94707 37.89855667580671 -122.28301222900068
18742 18742 18742 052 156708500 2723 Ashby Pl B 2723 ASHBY PL B 2723 ASHBY PL 2723.0 ASHBY PL B   Berkeley 94705 37.85771382194868 -122.2524407857094
19043 19043 19043 062 289400900 12 Menlo Pl 12 MENLO PL 12 MENLO PL 12.0 MENLO PL     Berkeley 94707 37.89766898751591 -122.28291041035313
19311 19311 19311 062 290701900 31 Menlo Pl 31 MENLO PL 31 MENLO PL 31.0 MENLO PL     Berkeley 94707 37.898267525494575 -122.28347464577632
19329 19329 19329 061 262000200 1532 Beverly Pl 1532 BEVERLY PL 1532 BEVERLY PL 1532.0 BEVERLY PL     Berkeley 94707 37.88572537805887 -122.28241427441496
19529 19529 19529 058 220300401 1771 Highland Pl 4 1771 HIGHLAND PL 4 1771 HIGHLAND PL 1771.0 HIGHLAND PL 4   Berkeley 94709 37.8765999380066 -122.25547659190642
19987 19987 19987 061 260601700 1711 Beverly Pl 1711 BEVERLY PL 1711 BEVERLY PL 1711.0 BEVERLY PL     Berkeley 94707 37.88512069751356 -122.27782584792864
20152 20152 20152 060 246501100 1306 Bay View Pl 1 1306 BAY VIEW PL 1 1306 BAY VIEW PL 1306.0 BAY VIEW PL 1   Berkeley 94708 37.88438925627893 -122.26348220344536
20249 20249 20249 061 262001000 1558 Beverly Pl 1558 BEVERLY PL 1558 BEVERLY PL 1558.0 BEVERLY PL     Berkeley 94707 37.88546794206349 -122.28130771707156
20299 20299 20299 058 220300401 1771 Highland Pl 206 1771 HIGHLAND PL 206 1771 HIGHLAND PL 1771.0 HIGHLAND PL 206   Berkeley 94709 37.8765999380066 -122.25547659190642
20863 20863 20863 061 262902600 1527 Beverly Pl 1527 BEVERLY PL 1527 BEVERLY PL 1527.0 BEVERLY PL     Berkeley 94707 37.886176740546645 -122.28237669159842
21138 21138 21138 061 260700700 1622 Beverly Pl 1622 BEVERLY PL 1622 BEVERLY PL 1622.0 BEVERLY PL     Berkeley 94707 37.88508048361394 -122.2796591387436
21238 21238 21238 061 262000300 1534 Beverly Pl 1534 BEVERLY PL 1534 BEVERLY PL 1534.0 BEVERLY PL     Berkeley 94707 37.88569274211153 -122.2822766210724
21517 21517 21517 061 262000500 1542 Beverly Pl 1542 BEVERLY PL 1542 BEVERLY PL 1542.0 BEVERLY PL     Berkeley 94707 37.8856283783829 -122.28199866076392
21525 21525 21525 061 260601600 1715 Beverly Pl 1715 BEVERLY PL 1715 BEVERLY PL 1715.0 BEVERLY PL     Berkeley 94707 37.88508892981084 -122.27769081676836
21671 21671 21671 052 157501300 2414 Dowling Pl 2414 DOWLING PL 2414 DOWLING PL 2414.0 DOWLING PL     Berkeley 94705 37.85431432127092 -122.25916440701477
21729 21729 21729 058 220300300 1735 Highland Pl 34 1735 HIGHLAND PL 34 1735 HIGHLAND PL 1735.0 HIGHLAND PL 34   Berkeley 94709 37.876824649545625 -122.25551614742336
21794 21794 21794 058 220300401 1771 Highland Pl 7 1771 HIGHLAND PL 7 1771 HIGHLAND PL 1771.0 HIGHLAND PL 7   Berkeley 94709 37.8765999380066 -122.25547659190642
21795 21795 21795 052 156700900 2739 Ashby Pl 2739 ASHBY PL 2739 ASHBY PL 2739.0 ASHBY PL     Berkeley 94705 37.85793422068337 -122.25168997469326
21887 21887 21887 062 289500500 90 Menlo Pl 90 MENLO PL 90 MENLO PL 90.0 MENLO PL     Berkeley 94707 37.8985607949932 -122.2818196561722
21890 21890 21890 061 260604100 1625 Beverly Pl 1625 BEVERLY PL 1625 BEVERLY PL 1625.0 BEVERLY PL     Berkeley 94707 37.885457843971906 -122.27928263953667

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