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

628 rows where street_name = "GRANT" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

  • ST · 628 ✖

street_name 1

  • GRANT · 628 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
93 93 93 055 190601200 2426 Grant St 6 2426 GRANT ST 6 2426 GRANT ST 2426.0 GRANT ST 6   Berkeley 94703 37.86381528176066 -122.2748232838887
183 183 183 054 172800300 2716 Grant St 2716 GRANT ST 2716 GRANT ST 2716.0 GRANT ST     Berkeley 94703 37.858844865283885 -122.27357581141996
285 285 285 055 190302800 2411 Grant St 2411 GRANT ST 2411 GRANT ST 2411.0 GRANT ST     Berkeley 94703 37.864477207743384 -122.27419554026986
411 411 411 055 190302600 2417 Grant St 2417 GRANT ST 2417 GRANT ST 2417.0 GRANT ST     Berkeley 94703 37.8641895178636 -122.2741635476693
627 627 627 058 216401100 1618 Grant St 1618 GRANT ST 1618 GRANT ST 1618.0 GRANT ST     Berkeley 94703 37.87685140202168 -122.27607393100368
721 721 721 056 201200900 2114 Grant St A 2114 GRANT ST A 2114 GRANT ST 2114.0 GRANT ST A   Berkeley 94703 37.86959341012573 -122.27541204781076
735 735 735 057 201500100 2103 Grant St 4 2103 GRANT ST 4 2103 GRANT ST 2103.0 GRANT ST 4   Berkeley 94703 37.87012035173591 -122.2749160663828
1015 1015 1015 055 190600900 2416 Grant St 2416 GRANT ST 2416 GRANT ST 2416.0 GRANT ST     Berkeley 94703 37.86423830168138 -122.27486797237914
1031 1031 1031 057 201301200 2224 Grant St 2224 GRANT ST 2224 GRANT ST 2224.0 GRANT ST     Berkeley 94703 37.86747607276987 -122.2751993402262
1041 1041 1041 057 206402300 1801 Grant St 1801 GRANT ST 1801 GRANT ST 1801.0 GRANT ST     Berkeley 94703 37.87379732101668 -122.275269194121
1044 1044 1044 054 181201800 2607 Grant St 2607 GRANT ST 2607 GRANT ST 2607.0 GRANT ST     Berkeley 94703 37.8610303841532 -122.273561391663
1069 1069 1069 055 190601700 2446 Grant St 2446 GRANT ST 2446 GRANT ST 2446.0 GRANT ST     Berkeley 94703 37.863231466155995 -122.2747235726888
1121 1121 1121 055 190402400 2321 Grant St 2321 GRANT ST 2321 GRANT ST 2321.0 GRANT ST     Berkeley 94703 37.86587100058815 -122.27434498849208
1162 1162 1162 055 190500600 2302 Grant St 2302 GRANT ST 2302 GRANT ST 2302.0 GRANT ST     Berkeley 94703 37.86650317975663 -122.27499324963205
1285 1285 1285 057 201502401 2127 Grant St 2127 GRANT ST 2127 GRANT ST 2127.0 GRANT ST     Berkeley 94703 37.86926646084445 -122.2746912701695
1379 1379 1379 057 201601600 2017 Grant St 2017 GRANT ST 2017 GRANT ST 2017.0 GRANT ST     Berkeley 94703 37.87059838235933 -122.27498125352972
1449 1449 1449 059 227500700 1512 Grant St 4 1512 GRANT ST 4 1512 GRANT ST 1512.0 GRANT ST 4   Berkeley 94703 37.87883304291841 -122.27642154488262
1544 1544 1544 057 201502100 2199 Grant St 4 2199 GRANT ST 4 2199 GRANT ST 2199.0 GRANT ST 4   Berkeley 94703 37.86871720476951 -122.2747881426931
1614 1614 1614 054 172701900 2709 Grant St 2709 GRANT ST 2709 GRANT ST 2709.0 GRANT ST     Berkeley 94703 37.85929877127208 -122.2731683311155
1616 1616 1616 057 201502300 2133 Grant St 2133 GRANT ST 2133 GRANT ST 2133.0 GRANT ST     Berkeley 94703 37.86909799328754 -122.27467588562192
1650 1650 1650 055 190402400 2323 Grant St 2323 GRANT ST 2323 GRANT ST 2323.0 GRANT ST     Berkeley 94703 37.86587100058815 -122.27434498849208
1721 1721 1721 054 172900400 2738 Grant St 2738 GRANT ST 2738 GRANT ST 2738.0 GRANT ST     Berkeley 94703 37.858108439534256 -122.27354602508176
2031 2031 2031 059 227401400 1428 Grant St 1428 GRANT ST 1428 GRANT ST 1428.0 GRANT ST     Berkeley 94703 37.8800841072455 -122.27656241868549
2219 2219 2219 055 190501600 2340 Grant St B 2340 GRANT ST B 2340 GRANT ST 2340.0 GRANT ST B   Berkeley 94703 37.86538631555809 -122.27498647004656
2257 2257 2257 058 216502900 1619 Grant St 3 1619 GRANT ST 3 1619 GRANT ST 1619.0 GRANT ST 3   Berkeley 94703 37.876858028981935 -122.27555213199446
2310 2310 2310 058 216502900 1619 Grant St 2 1619 GRANT ST 2 1619 GRANT ST 1619.0 GRANT ST 2   Berkeley 94703 37.876858028981935 -122.27555213199446
2321 2321 2321 059 227202400 1531 Grant St 1531 GRANT ST 1531 GRANT ST 1531.0 GRANT ST     Berkeley 94703 37.87826244965214 -122.27567752602832
2334 2334 2334 059 227203100 1509 Grant St 6 1509 GRANT ST 6 1509 GRANT ST 1509.0 GRANT ST 6   Berkeley 94703 37.87902415010951 -122.27576939224087
2345 2345 2345 058 215900300 1732 Grant St 1732 GRANT ST 1732 GRANT ST 1732.0 GRANT ST     Berkeley 94703 37.87437088380724 -122.27591530918572
2361 2361 2361 059 227202100 1541 Grant St 1541 GRANT ST 1541 GRANT ST 1541.0 GRANT ST     Berkeley 94703 37.87792874747751 -122.27571979894896
2428 2428 2428 056 201201400 2132 Grant St 2132 GRANT ST 2132 GRANT ST 2132.0 GRANT ST     Berkeley 94703 37.86901826987883 -122.2753513953594
2464 2464 2464 057 201502300 2133 Grant St 2 2133 GRANT ST 2 2133 GRANT ST 2133.0 GRANT ST 2   Berkeley 94703 37.86909799328754 -122.27467588562192
2656 2656 2656 054 181201700 2609 Grant St B 2609 GRANT ST B 2609 GRANT ST 2609.0 GRANT ST B   Berkeley 94703 37.860917902963806 -122.27354051301916
2888 2888 2888 057 206000800 1933 Grant St 1933 GRANT ST 1933 GRANT ST 1933.0 GRANT ST     Berkeley 94703 37.87180852367496 -122.27504573280416
2975 2975 2975 059 227401000 1416 Grant St 4 1416 GRANT ST 4 1416 GRANT ST 1416.0 GRANT ST 4   Berkeley 94703 37.88052236378655 -122.27661701110192
3031 3031 3031 057 201301300 2232 Grant St 2232 GRANT ST 2232 GRANT ST 2232.0 GRANT ST     Berkeley 94703 37.8673377560591 -122.27518563912146
3053 3053 3053 057 201301400 2234 Grant St 4 2234 GRANT ST 4 2234 GRANT ST 2234.0 GRANT ST 4   Berkeley 94703 37.8672004709195 -122.27517019977668
3182 3182 3182 055 190603500 2420 Grant St 2420 GRANT ST 2420 GRANT ST 2420.0 GRANT ST     Berkeley 94703 37.86410100509386 -122.274851785636
3433 3433 3433 057 201402300 2215 Grant St 1 2215 GRANT ST 1 2215 GRANT ST 2215.0 GRANT ST 1   Berkeley 94703 37.86797782688169 -122.27456260986123
3490 3490 3490 054 181000400 2634 Grant St 2634 GRANT ST 2634 GRANT ST 2634.0 GRANT ST     Berkeley 94703 37.85986275171557 -122.27388253937708
3493 3493 3493 059 227501400 1540 Grant St 1540 GRANT ST 1540 GRANT ST 1540.0 GRANT ST     Berkeley 94703 37.87806760517 -122.27632783622543
3578 3578 3578 060 244502901 1337 Grant St 1337 GRANT ST 1337 GRANT ST 1337.0 GRANT ST     Berkeley 94703 37.881605948841134 -122.27607730327924
3628 3628 3628 058 216802000 1733 Grant St 4 1733 GRANT ST 4 1733 GRANT ST 1733.0 GRANT ST 4   Berkeley 94703 37.87449621873531 -122.27531185152056
3750 3750 3750 054 172900500 2740 Grant St 2740 GRANT ST 2740 GRANT ST 2740.0 GRANT ST     Berkeley 94703 37.85802727509699 -122.27346797136504
3776 3776 3776 054 172702000 2701 Grant St 6 2701 GRANT ST 6 2701 GRANT ST 2701.0 GRANT ST 6   Berkeley 94703 37.85942035231529 -122.2733237028287
3846 3846 3846 054 180800500 2536 Grant St 2536 GRANT ST 2536 GRANT ST 2536.0 GRANT ST     Berkeley 94703 37.861629707884674 -122.27426169939388
3867 3867 3867 055 190403100 2333 Grant St 3 2333 GRANT ST 3 2333 GRANT ST 2333.0 GRANT ST 3   Berkeley 94703 37.86547265456967 -122.27430508083556
3934 3934 3934 058 216401000 1614 Grant St A 1614 GRANT ST A 1614 GRANT ST 1614.0 GRANT ST A   Berkeley 94703 37.876949854084685 -122.2761710927848
4050 4050 4050 057 201401901 2233 Grant St 2233 GRANT ST 2233 GRANT ST 2233.0 GRANT ST     Berkeley 94703 37.86735926844739 -122.27449568986412
4163 4163 4163 055 190302000 2437 Grant St 2437 GRANT ST 2437 GRANT ST 2437.0 GRANT ST     Berkeley 94703 37.8634986902055 -122.27414528312296
4245 4245 4245 056 201200800 2110 Grant St 2110 GRANT ST 2110 GRANT ST 2110.0 GRANT ST     Berkeley 94703 37.86973026816083 -122.2754299772855
4253 4253 4253 053 167500500 2812 Grant St 2812 GRANT ST 2812 GRANT ST 2812.0 GRANT ST     Berkeley 94703 37.85722288010039 -122.2733707799395
4329 4329 4329 059 227203100 1509 Grant St D 1509 GRANT ST D 1509 GRANT ST 1509.0 GRANT ST D   Berkeley 94703 37.87902415010951 -122.27576939224087
4754 4754 4754 058 216503200 1607 Grant St A 1607 GRANT ST A 1607 GRANT ST 1607.0 GRANT ST A   Berkeley 94703 37.87718348815225 -122.27559199114192
4834 4834 4834 054 172601600 2737 Grant St 2737 GRANT ST 2737 GRANT ST 2737.0 GRANT ST     Berkeley 94703 37.8582180149646 -122.27294504407185
4843 4843 4843 057 201502300 2133 Grant St 3 2133 GRANT ST 3 2133 GRANT ST 2133.0 GRANT ST 3   Berkeley 94703 37.86909799328754 -122.27467588562192
4939 4939 4939 057 206200100 1904 Grant St 1904 GRANT ST 1904 GRANT ST 1904.0 GRANT ST     Berkeley 94703 37.87282505819165 -122.27564092866366
4963 4963 4963 054 181201600 2611 Grant St 2611 GRANT ST 2611 GRANT ST 2611.0 GRANT ST     Berkeley 94703 37.86080467408103 -122.27351442773995
5006 5006 5006 055 190501600 2340 Grant St D 2340 GRANT ST D 2340 GRANT ST 2340.0 GRANT ST D   Berkeley 94703 37.86538631555809 -122.27498647004656
5062 5062 5062 054 172702000 2701 Grant St 3 2701 GRANT ST 3 2701 GRANT ST 2701.0 GRANT ST 3   Berkeley 94703 37.85942035231529 -122.2733237028287
5100 5100 5100 055 190402600 2315 Grant St 8 2315 GRANT ST 8 2315 GRANT ST 2315.0 GRANT ST 8   Berkeley 94703 37.86615019511304 -122.27437142321594
5209 5209 5209 055 190601100 2422 Grant St G 2422 GRANT ST G 2422 GRANT ST 2422.0 GRANT ST G   Berkeley 94703 37.863956953894 -122.27483541922986
5212 5212 5212 055 190501300 2330 Grant St C 2330 GRANT ST C 2330 GRANT ST 2330.0 GRANT ST C   Berkeley 94703 37.86571488124894 -122.27501945169222
5327 5327 5327 057 201502100 2199 Grant St D 2199 GRANT ST D 2199 GRANT ST 2199.0 GRANT ST D   Berkeley 94703 37.86871720476951 -122.2747881426931
5329 5329 5329 057 201502300 2139 Grant St 4 2139 GRANT ST 4 2139 GRANT ST 2139.0 GRANT ST 4   Berkeley 94703 37.86909799328754 -122.27467588562192
5335 5335 5335 057 201402100 2223 Grant St 2223 GRANT ST 2223 GRANT ST 2223.0 GRANT ST     Berkeley 94703 37.86770120572156 -122.27453512321016
5337 5337 5337 058 216701600 1715 Grant St 1715 GRANT ST 1715 GRANT ST 1715.0 GRANT ST     Berkeley 94703 37.87522118358793 -122.2754219966525
5339 5339 5339 055 190302100 2435 Grant St 4 2435 GRANT ST 4 2435 GRANT ST 2435.0 GRANT ST 4   Berkeley 94703 37.8636047804312 -122.27410537456817
5398 5398 5398 055 190601200 2426 Grant St 3 2426 GRANT ST 3 2426 GRANT ST 2426.0 GRANT ST 3   Berkeley 94703 37.86381528176066 -122.2748232838887
5417 5417 5417 056 201100400 2016 Grant St A 2016 GRANT ST A 2016 GRANT ST 2016.0 GRANT ST A   Berkeley 94703 37.87052452578923 -122.27545856167782
5682 5682 5682 058 216502700 1627 Grant St 1627 GRANT ST 1627 GRANT ST 1627.0 GRANT ST     Berkeley 94703 37.87663614886632 -122.27553117789216
5799 5799 5799 055 190402600 2315 Grant St 1 2315 GRANT ST 1 2315 GRANT ST 2315.0 GRANT ST 1   Berkeley 94703 37.86615019511304 -122.27437142321594
5935 5935 5935 056 201201100 2120 Grant St 7 2120 GRANT ST 7 2120 GRANT ST 2120.0 GRANT ST 7   Berkeley 94703 37.86932045774757 -122.27538637485824
6076 6076 6076 059 227500800 1514 Grant St 1514 GRANT ST 1514 GRANT ST 1514.0 GRANT ST     Berkeley 94703 37.87872518142815 -122.2764050509157
6110 6110 6110 058 216802000 1733 Grant St M 1733 GRANT ST M 1733 GRANT ST 1733.0 GRANT ST M   Berkeley 94703 37.87449621873531 -122.27531185152056
6177 6177 6177 057 201401901 2233 Grant St 4 2233 GRANT ST 4 2233 GRANT ST 2233.0 GRANT ST 4   Berkeley 94703 37.86735926844739 -122.27449568986412
6209 6209 6209 055 190302400 2423 Grant St 2423 GRANT ST 2423 GRANT ST 2423.0 GRANT ST     Berkeley 94703 37.86400150185694 -122.27414606825052
6262 6262 6262 056 201201100 2120 Grant St 4 2120 GRANT ST 4 2120 GRANT ST 2120.0 GRANT ST 4   Berkeley 94703 37.86932045774757 -122.27538637485824
6285 6285 6285 057 201300900 2216 Grant St B 2216 GRANT ST B 2216 GRANT ST 2216.0 GRANT ST B   Berkeley 94703 37.86779807299306 -122.2752347688827
6448 6448 6448 058 216502800 1623 Grant St B 1623 GRANT ST B 1623 GRANT ST 1623.0 GRANT ST B   Berkeley 94703 37.87674700569196 -122.2755416351804
6467 6467 6467 057 201300700 2210 Grant St 2210 GRANT ST 2210 GRANT ST 2210.0 GRANT ST     Berkeley 94703 37.86802974478028 -122.27525930097478
6566 6566 6566 054 172601800 2731 Grant St 2 2731 GRANT ST 2 2731 GRANT ST 2731.0 GRANT ST 2   Berkeley 94703 37.85842914730556 -122.27305658967732
6580 6580 6580 058 216502700 1627 Grant St A 1627 GRANT ST A 1627 GRANT ST 1627.0 GRANT ST A   Berkeley 94703 37.87663614886632 -122.27553117789216
6734 6734 6734 059 227401000 1416 Grant St 2 1416 GRANT ST 2 1416 GRANT ST 1416.0 GRANT ST 2   Berkeley 94703 37.88052236378655 -122.27661701110192
6876 6876 6876 055 190402600 2315 Grant St 2 2315 GRANT ST 2 2315 GRANT ST 2315.0 GRANT ST 2   Berkeley 94703 37.86615019511304 -122.27437142321594
7183 7183 7183 059 227202400 1531 Grant St 2 1531 GRANT ST 2 1531 GRANT ST 1531.0 GRANT ST 2   Berkeley 94703 37.87826244965214 -122.27567752602832
7379 7379 7379 059 227500901 1516 Grant St 1516 GRANT ST 1516 GRANT ST 1516.0 GRANT ST     Berkeley 94703 37.87861731977994 -122.27639122853844
7519 7519 7519 055 190302300 2425 Grant St H 2425 GRANT ST H 2425 GRANT ST 2425.0 GRANT ST H   Berkeley 94703 37.86390070846205 -122.27413934885216
7543 7543 7543 055 190402600 2315 Grant St 4 2315 GRANT ST 4 2315 GRANT ST 2315.0 GRANT ST 4   Berkeley 94703 37.86615019511304 -122.27437142321594
7550 7550 7550 055 190403100 2333 Grant St 2333 GRANT ST 2333 GRANT ST 2333.0 GRANT ST     Berkeley 94703 37.86547265456967 -122.27430508083556
7597 7597 7597 055 190501600 2340 Grant St C 2340 GRANT ST C 2340 GRANT ST 2340.0 GRANT ST C   Berkeley 94703 37.86538631555809 -122.27498647004656
7728 7728 7728 057 201301200 2224 Grant St E 2224 GRANT ST E 2224 GRANT ST 2224.0 GRANT ST E   Berkeley 94703 37.86747607276987 -122.2751993402262
7892 7892 7892 057 201502300 2133 Grant St 4 2133 GRANT ST 4 2133 GRANT ST 2133.0 GRANT ST 4   Berkeley 94703 37.86909799328754 -122.27467588562192
7928 7928 7928 055 190302800 2411 Grant St B 2411 GRANT ST B 2411 GRANT ST 2411.0 GRANT ST B   Berkeley 94703 37.864477207743384 -122.27419554026986
7929 7929 7929 058 216200800 1642 Grant St 1642 GRANT ST 1642 GRANT ST 1642.0 GRANT ST     Berkeley 94703 37.87596817235296 -122.27596566784226
7945 7945 7945 059 227203100 1509 Grant St 3 1509 GRANT ST 3 1509 GRANT ST 1509.0 GRANT ST 3   Berkeley 94703 37.87902415010951 -122.27576939224087
8028 8028 8028 054 172702000 2701 Grant St 2701 GRANT ST 2701 GRANT ST 2701.0 GRANT ST     Berkeley 94703 37.85942035231529 -122.2733237028287
8093 8093 8093 055 190302100 2435 Grant St 2 2435 GRANT ST 2 2435 GRANT ST 2435.0 GRANT ST 2   Berkeley 94703 37.8636047804312 -122.27410537456817
8098 8098 8098 059 227303400 1405 Grant St 1405 GRANT ST 1405 GRANT ST 1405.0 GRANT ST     Berkeley 94703 37.88085230911069 -122.2760471100042
8242 8242 8242 059 227302600 1431 Grant St 1431 GRANT ST 1431 GRANT ST 1431.0 GRANT ST     Berkeley 94703 37.8800334336958 -122.27588628641551

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