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

823 rows where street_type = "ST" and zipcode = 94707

✎ View and edit SQL

This data as json, CSV (advanced)

street_name 15

zipcode 1

  • 94707 · 823 ✖

street_type 1

  • ST · 823 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
36 36 36 061 257000700 1971 Hopkins St 1971 HOPKINS ST 1971 HOPKINS ST 1971.0 HOPKINS ST     Berkeley 94707 37.887872896105094 -122.27334417094248
112 112 112 062 284800400 826 Neilson St 826 NEILSON ST 826 NEILSON ST 826.0 NEILSON ST     Berkeley 94707 37.892314541992846 -122.2868151281784
201 201 201 061 256500800 1970 Hopkins St 1970 HOPKINS ST 1970 HOPKINS ST 1970.0 HOPKINS ST     Berkeley 94707 37.88759802777184 -122.2728641624586
267 267 267 062 286902500 773 Neilson St 773 NEILSON ST 773 NEILSON ST 773.0 NEILSON ST     Berkeley 94707 37.893341150688194 -122.28624717911975
485 485 485 061 258803900 1019 Oxford St 1019 OXFORD ST 1019 OXFORD ST 1019.0 OXFORD ST     Berkeley 94707 37.89002782944345 -122.2678847406516
508 508 508 062 289600100 6 Vallejo St 6 VALLEJO ST 6 VALLEJO ST 6.0 VALLEJO ST     Berkeley 94707 37.89938893605816 -122.28104150942195
569 569 569 061 255702300 1188 Spruce St 1188 SPRUCE ST 1188 SPRUCE ST 1188.0 SPRUCE ST     Berkeley 94707 37.88628578362558 -122.26686644188658
574 574 574 063 295904700 769 Spruce St 769 SPRUCE ST 769 SPRUCE ST 769.0 SPRUCE ST     Berkeley 94707 37.89578253531088 -122.2689920031725
577 577 577 061 258402000 814 Oxford St 814 OXFORD ST 814 OXFORD ST 814.0 OXFORD ST     Berkeley 94707 37.89244302234366 -122.27196616338144
594 594 594 062 286000400 626 Neilson St 626 NEILSON ST 626 NEILSON ST 626.0 NEILSON ST     Berkeley 94707 37.89609381043969 -122.286638429562
854 854 854 060 243800300 1620 Hopkins St 1620 HOPKINS ST 1620 HOPKINS ST 1620.0 HOPKINS ST     Berkeley 94707 37.88212473093657 -122.28050979570698
906 906 906 063 295904800 765 Spruce St 765 SPRUCE ST 765 SPRUCE ST 765.0 SPRUCE ST     Berkeley 94707 37.89592158051158 -122.26897045977532
955 955 955 061 255604200 1139 Spruce St 1139 SPRUCE ST 1139 SPRUCE ST 1139.0 SPRUCE ST     Berkeley 94707 37.88782112973 -122.26636239718064
997 997 997 061 258301200 843 Oxford St 843 OXFORD ST 843 OXFORD ST 843.0 OXFORD ST     Berkeley 94707 37.89203636184776 -122.2702095392844
1110 1110 1110 061 255702300 1194 Spruce St 1194 SPRUCE ST 1194 SPRUCE ST 1194.0 SPRUCE ST     Berkeley 94707 37.88628578362558 -122.26686644188658
1179 1179 1179 060 242902700 1547 Hopkins St 3 1547 HOPKINS ST 3 1547 HOPKINS ST 1547.0 HOPKINS ST 3   Berkeley 94707 37.88163074834889 -122.28258261690256
1252 1252 1252 060 243502701 1607 Hopkins St 4 1607 HOPKINS ST 4 1607 HOPKINS ST 1607.0 HOPKINS ST 4   Berkeley 94707 37.882316135172914 -122.28145627416504
1253 1253 1253 063 295801700 671 Spruce St 671 SPRUCE ST 671 SPRUCE ST 671.0 SPRUCE ST     Berkeley 94707 37.898779200862606 -122.26978066560144
1255 1255 1255 061 256800100 1938 Hopkins St 1938 HOPKINS ST 1938 HOPKINS ST 1938.0 HOPKINS ST     Berkeley 94707 37.886398438782294 -122.273591901145
1259 1259 1259 060 244505301 1632 Hopkins St 1632 HOPKINS ST 1632 HOPKINS ST 1632.0 HOPKINS ST     Berkeley 94707 37.88244583333378 -122.27981002606695
1318 1318 1318 061 257100307 2003 Hopkins St 2003 HOPKINS ST 2003 HOPKINS ST 2003.0 HOPKINS ST     Berkeley 94707 37.888976852517885 -122.27268739018037
1321 1321 1321 063 295207200 531 Spruce St 531 SPRUCE ST 531 SPRUCE ST 531.0 SPRUCE ST     Berkeley 94707 37.90131821926596 -122.26930336374151
1501 1501 1501 063 297405301 995 Spruce St 995 SPRUCE ST 995 SPRUCE ST 995.0 SPRUCE ST     Berkeley 94707 37.89075655616146 -122.26689231336675
1541 1541 1541 061 255703900 1133 Oxford St 1133 OXFORD ST 1133 OXFORD ST 1133.0 OXFORD ST     Berkeley 94707 37.8878949569058 -122.2678214453567
1575 1575 1575 062 291402201 630 Spruce St 630 SPRUCE ST 630 SPRUCE ST 630.0 SPRUCE ST     Berkeley 94707 37.89888357021265 -122.2708383725597
1635 1635 1635 060 243800100 1612 Hopkins St 3 1612 HOPKINS ST 3 1612 HOPKINS ST 1612.0 HOPKINS ST 3   Berkeley 94707 37.882046960083265 -122.28087905000112
1665 1665 1665 061 256204200 1163 Sutter St 1163 SUTTER ST 1163 SUTTER ST 1163.0 SUTTER ST     Berkeley 94707 37.886756355162554 -122.27192214054264
1707 1707 1707 061 255801900 1156 Oxford St 1156 OXFORD ST 1156 OXFORD ST 1156.0 OXFORD ST     Berkeley 94707 37.88708877876863 -122.26818694559128
1745 1745 1745 061 255800900 1106 Oxford St A 1106 OXFORD ST A 1106 OXFORD ST 1106.0 OXFORD ST A   Berkeley 94707 37.88862199544134 -122.26815518745104
1753 1753 1753 061 258802300 1062 Spruce St 1062 SPRUCE ST 1062 SPRUCE ST 1062.0 SPRUCE ST     Berkeley 94707 37.889448211512835 -122.26720607513252
1800 1800 1800 061 255802300 1170 Oxford St 1170 OXFORD ST 1170 OXFORD ST 1170.0 OXFORD ST     Berkeley 94707 37.88665098456124 -122.26813837727714
1889 1889 1889 063 295205300 635 Spruce St 635 SPRUCE ST 635 SPRUCE ST 635.0 SPRUCE ST     Berkeley 94707 37.899287453165975 -122.27037919870224
1989 1989 1989 061 258403000 844 Oxford St 844 OXFORD ST 844 OXFORD ST 844.0 OXFORD ST     Berkeley 94707 37.89183893858327 -122.2706498880468
2011 2011 2011 063 295905400 741 Spruce St 741 SPRUCE ST 741 SPRUCE ST 741.0 SPRUCE ST     Berkeley 94707 37.89675426682092 -122.2689521305503
2046 2046 2046 060 243800100 1600 Hopkins St 1600 HOPKINS ST 1600 HOPKINS ST 1600.0 HOPKINS ST     Berkeley 94707 37.882046960083265 -122.28087905000112
2105 2105 2105 062 286903600 707 Neilson St 707 NEILSON ST 707 NEILSON ST 707.0 NEILSON ST     Berkeley 94707 37.89445178234233 -122.28619588891031
2115 2115 2115 061 258301100 845 Oxford St 845 OXFORD ST 845 OXFORD ST 845.0 OXFORD ST     Berkeley 94707 37.891925973949064 -122.2701349180304
2133 2133 2133 060 242906600 1515 Hopkins St 1515 HOPKINS ST 1515 HOPKINS ST 1515.0 HOPKINS ST     Berkeley 94707 37.881380615892816 -122.28296645714198
2231 2231 2231 063 295205600 615 Spruce St 615 SPRUCE ST 615 SPRUCE ST 615.0 SPRUCE ST     Berkeley 94707 37.89961993431722 -122.27071652327794
2300 2300 2300 061 261800200 1714 Madera St 1714 MADERA ST 1714 MADERA ST 1714.0 MADERA ST     Berkeley 94707 37.888656629345014 -122.28087307171292
2308 2308 2308 060 243502205 1619 Hopkins St 202 1619 HOPKINS ST 202 1619 HOPKINS ST 1619.0 HOPKINS ST 202   Berkeley 94707 37.88244543557616 -122.28110589078004
2350 2350 2350 061 256100200 1108 Walnut St 1108 WALNUT ST 1108 WALNUT ST 1108.0 WALNUT ST     Berkeley 94707 37.88760582072267 -122.26990698220514
2381 2381 2381 061 258805400 915 Oxford St 915 OXFORD ST 915 OXFORD ST 915.0 OXFORD ST     Berkeley 94707 37.89157620488004 -122.26923038370956
2494 2494 2494 061 261201800 913 Modoc St 913 MODOC ST 913 MODOC ST 913.0 MODOC ST     Berkeley 94707 37.89064140016444 -122.27984718128542
2765 2765 2765 061 258804900 935 Oxford St 935 OXFORD ST 935 OXFORD ST 935.0 OXFORD ST     Berkeley 94707 37.89129817082039 -122.2684906165815
2810 2810 2810 062 286903500 713 Neilson St 713 NEILSON ST 713 NEILSON ST 713.0 NEILSON ST     Berkeley 94707 37.894350301149885 -122.28620198397952
2884 2884 2884 060 243701800 1735 Hopkins St 1735 HOPKINS ST 1735 HOPKINS ST 1735.0 HOPKINS ST     Berkeley 94707 37.883936469086905 -122.27817113067944
2993 2993 2993 061 258802200 1054 Spruce St B 1054 SPRUCE ST B 1054 SPRUCE ST 1054.0 SPRUCE ST B   Berkeley 94707 37.889581478001915 -122.2672500126314
3055 3055 3055 061 255804000 1141 Walnut St 1141 WALNUT ST 1141 WALNUT ST 1141.0 WALNUT ST     Berkeley 94707 37.886782870069894 -122.26861378998
3147 3147 3147 061 256203900 1169 Sutter St 1169 SUTTER ST 1169 SUTTER ST 1169.0 SUTTER ST     Berkeley 94707 37.88642027598801 -122.2715901330951
3201 3201 3201 061 261500700 1735 Madera St 1735 MADERA ST 1735 MADERA ST 1735.0 MADERA ST     Berkeley 94707 37.889149501377766 -122.27989655987992
3382 3382 3382 063 295206500 557 Spruce St 557 SPRUCE ST 557 SPRUCE ST 557.0 SPRUCE ST     Berkeley 94707 37.90047341590298 -122.26986087437656
3439 3439 3439 061 255603700 1133 Spruce St 1133 SPRUCE ST 1133 SPRUCE ST 1133.0 SPRUCE ST     Berkeley 94707 37.88798380124233 -122.26645915561822
3530 3530 3530 061 261201900 911 Modoc St 911 MODOC ST 911 MODOC ST 911.0 MODOC ST     Berkeley 94707 37.89074069089643 -122.27986775719698
3597 3597 3597 061 261703100 1029 Sierra St 1029 SIERRA ST 1029 SIERRA ST 1029.0 SIERRA ST     Berkeley 94707 37.88789454783422 -122.28038605996308
3763 3763 3763 061 261601900 1051 Merced St 1051 MERCED ST 1051 MERCED ST 1051.0 MERCED ST     Berkeley 94707 37.88696408561848 -122.27969484767443
3891 3891 3891 063 297405200 999 Spruce St 999 SPRUCE ST 999 SPRUCE ST 999.0 SPRUCE ST     Berkeley 94707 37.89065174000136 -122.26682597637628
3951 3951 3951 061 255701100 1128 Spruce St 1128 SPRUCE ST 1128 SPRUCE ST 1128.0 SPRUCE ST     Berkeley 94707 37.88781570403158 -122.26714472828348
3985 3985 3985 063 295801300 693 Spruce St 693 SPRUCE ST 693 SPRUCE ST 693.0 SPRUCE ST     Berkeley 94707 37.89822166984301 -122.26962775976368
4061 4061 4061 061 258700702 910 Oxford St 910 OXFORD ST 910 OXFORD ST 910.0 OXFORD ST     Berkeley 94707 37.89118607258184 -122.26975642905508
4091 4091 4091 061 258805000 933 Oxford St 933 OXFORD ST 933 OXFORD ST 933.0 OXFORD ST     Berkeley 94707 37.891422522725286 -122.26859836590658
4131 4131 4131 061 256900700 1931 Hopkins St 1931 HOPKINS ST 1931 HOPKINS ST 1931.0 HOPKINS ST     Berkeley 94707 37.88654302462929 -122.27423131837097
4152 4152 4152 061 256901000 1921 Hopkins St 1921 HOPKINS ST 1921 HOPKINS ST 1921.0 HOPKINS ST     Berkeley 94707 37.88621943102024 -122.2745094358846
4450 4450 4450 062 286802000 677 Neilson St 677 NEILSON ST 677 NEILSON ST 677.0 NEILSON ST     Berkeley 94707 37.89520598753071 -122.28615949456491
4475 4475 4475 062 284901100 768 Neilson St 768 NEILSON ST 768 NEILSON ST 768.0 NEILSON ST     Berkeley 94707 37.89342840404004 -122.28676222639128
4486 4486 4486 061 255703400 1147 Oxford St 1147 OXFORD ST 1147 OXFORD ST 1147.0 OXFORD ST     Berkeley 94707 37.887243690105215 -122.26753410484
4563 4563 4563 061 258203100 818 Spruce St 818 SPRUCE ST 818 SPRUCE ST 818.0 SPRUCE ST     Berkeley 94707 37.894505068897665 -122.26892717535168
4624 4624 4624 061 256801701 1922 Hopkins St 1922 HOPKINS ST 1922 HOPKINS ST 1922.0 HOPKINS ST     Berkeley 94707 37.88581709213993 -122.2739466287827
4663 4663 4663 061 255604100 1109 Spruce St 1109 SPRUCE ST 1109 SPRUCE ST 1109.0 SPRUCE ST     Berkeley 94707 37.888479220099626 -122.26644746224817
5096 5096 5096 060 243502205 1619 Hopkins St 304 1619 HOPKINS ST 304 1619 HOPKINS ST 1619.0 HOPKINS ST 304   Berkeley 94707 37.88244543557616 -122.28110589078004
5148 5148 5148 061 258802900 1104 Spruce St 1104 SPRUCE ST 1104 SPRUCE ST 1104.0 SPRUCE ST     Berkeley 94707 37.888567032908625 -122.26707579695848
5296 5296 5296 062 286000500 630 Neilson St 630 NEILSON ST 630 NEILSON ST 630.0 NEILSON ST     Berkeley 94707 37.89598904724715 -122.2866454067768
5391 5391 5391 061 257000500 1977 Hopkins St 1977 HOPKINS ST 1977 HOPKINS ST 1977.0 HOPKINS ST     Berkeley 94707 37.88812877815848 -122.2732726102486
5481 5481 5481 060 243401600 1510 Hopkins St 1510 HOPKINS ST 1510 HOPKINS ST 1510.0 HOPKINS ST     Berkeley 94707 37.88095041336467 -122.28286796585428
5825 5825 5825 062 284800800 848 Neilson St 848 NEILSON ST 848 NEILSON ST 848.0 NEILSON ST     Berkeley 94707 37.89190140972671 -122.286835501969
5848 5848 5848 061 258202900 800 Spruce St 800 SPRUCE ST 800 SPRUCE ST 800.0 SPRUCE ST     Berkeley 94707 37.89476341825562 -122.26895341064956
5895 5895 5895 063 297400100 959 Spruce St 959 SPRUCE ST 959 SPRUCE ST 959.0 SPRUCE ST     Berkeley 94707 37.89168180237869 -122.26697626182836
5975 5975 5975 061 255602400 1191 Spruce St 1191 SPRUCE ST 1191 SPRUCE ST 1191.0 SPRUCE ST     Berkeley 94707 37.886402288528814 -122.26628273458124
5984 5984 5984 062 287002000 893 Neilson St 4 893 NEILSON ST 4 893 NEILSON ST 893.0 NEILSON ST 4   Berkeley 94707 37.891231209506856 -122.28639025738836
6043 6043 6043 063 295205400 625 Spruce St 625 SPRUCE ST 625 SPRUCE ST 625.0 SPRUCE ST     Berkeley 94707 37.89939766202801 -122.27048320384918
6051 6051 6051 061 261701700 1060 Merced St 1060 MERCED ST 1060 MERCED ST 1060.0 MERCED ST     Berkeley 94707 37.88678134719464 -122.28035843766642
6075 6075 6075 062 286801900 683 Neilson St 683 NEILSON ST 683 NEILSON ST 683.0 NEILSON ST     Berkeley 94707 37.895089871562575 -122.28616448290968
6142 6142 6142 062 293902400 560 Spruce St 560 SPRUCE ST 560 SPRUCE ST 560.0 SPRUCE ST     Berkeley 94707 37.90077528546027 -122.270483462564
6167 6167 6167 061 258200700 738 Spruce St 738 SPRUCE ST 738 SPRUCE ST 738.0 SPRUCE ST     Berkeley 94707 37.89659434883341 -122.26964890251222
6170 6170 6170 060 242902700 1547 Hopkins St 7 1547 HOPKINS ST 7 1547 HOPKINS ST 1547.0 HOPKINS ST 7   Berkeley 94707 37.88163074834889 -122.28258261690256
6186 6186 6186 061 255701900 1166 Spruce St 1166 SPRUCE ST 1166 SPRUCE ST 1166.0 SPRUCE ST     Berkeley 94707 37.88696931357651 -122.26702629798967
6270 6270 6270 062 293902500 562 Spruce St 562 SPRUCE ST 562 SPRUCE ST 562.0 SPRUCE ST     Berkeley 94707 37.90067775555263 -122.27058466586558
6313 6313 6313 062 291403000 670 Spruce St 670 SPRUCE ST 670 SPRUCE ST 670.0 SPRUCE ST     Berkeley 94707 37.8981893229803 -122.27042018793033
6328 6328 6328 063 297304800 925 Spruce St 925 SPRUCE ST 925 SPRUCE ST 925.0 SPRUCE ST     Berkeley 94707 37.89280814807832 -122.26682711094848
6416 6416 6416 061 258802000 1030 Spruce St 1030 SPRUCE ST 1030 SPRUCE ST 1030.0 SPRUCE ST     Berkeley 94707 37.88997941221138 -122.26737468352148
6418 6418 6418 061 258302300 821 Oxford St 821 OXFORD ST 821 OXFORD ST 821.0 OXFORD ST     Berkeley 94707 37.89279554993896 -122.27148589348784
6504 6504 6504 062 286100400 526 Neilson St 526 NEILSON ST 526 NEILSON ST 526.0 NEILSON ST     Berkeley 94707 37.897705438246525 -122.2865645754692
6519 6519 6519 062 289600200 28 Vallejo St 28 VALLEJO ST 28 VALLEJO ST 28.0 VALLEJO ST     Berkeley 94707 37.899353220532475 -122.28073913200572
6760 6760 6760 062 286702900 517 Neilson St 517 NEILSON ST 517 NEILSON ST 517.0 NEILSON ST     Berkeley 94707 37.8978352950239 -122.28606953996729
6794 6794 6794 060 243402800 1584 Hopkins St 7000 1584 HOPKINS ST 7000 1584 HOPKINS ST 1584.0 HOPKINS ST 7000   Berkeley 94707 37.88165945031035 -122.28146144666444
6837 6837 6837 061 258803200 1053 Oxford St 1053 OXFORD ST 1053 OXFORD ST 1053.0 OXFORD ST     Berkeley 94707 37.888970993025694 -122.2674555103375
6854 6854 6854 060 244505301 1642 Hopkins St 1642 HOPKINS ST 1642 HOPKINS ST 1642.0 HOPKINS ST     Berkeley 94707 37.88244583333378 -122.27981002606695
6869 6869 6869 062 284900800 750 Neilson St 750 NEILSON ST 750 NEILSON ST 750.0 NEILSON ST     Berkeley 94707 37.89374054902714 -122.28674979640272
7031 7031 7031 061 258900200 976 Spruce St 976 SPRUCE ST 976 SPRUCE ST 976.0 SPRUCE ST     Berkeley 94707 37.89125295240941 -122.26751215899762
7105 7105 7105 060 243502204 1629 Hopkins St 1629 HOPKINS ST 1629 HOPKINS ST 1629.0 HOPKINS ST     Berkeley 94707 37.88250242975147 -122.28088056006912

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