Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
823 rows where street_type = "ST" and zipcode = 94707
This data as json, CSV (advanced)
| 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 |
Advanced export
JSON shape: default, array, newline-delimited
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);