addresses_with_projects (view)

Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS

62,234 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: street_type, unit_type, project_status, data_source

address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude project_id net_units project_status data_source
1 059 231000205 1080 Jones St Apt 106 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 106 APT Berkeley 94710 37.875857552605694 -122.29526674876428        
2 053 169302100 2823 Regent St 2823 REGENT ST 2823 REGENT ST 2823.0 REGENT ST     Berkeley 94705 37.85894520458626 -122.25658232100312        
3 063 314011500 1079 Creston Rd 1079 CRESTON RD 1079 CRESTON RD 1079.0 CRESTON RD     Berkeley 94708 37.89348404845872 -122.25700367039724        
4 055 182001500 2605 Milvia St 2605 MILVIA ST 2605 MILVIA ST 2605.0 MILVIA ST     Berkeley 94704 37.86164004895787 -122.26941061539996        
5 054 170901900 2793 Benvenue Ave 4 2793 BENVENUE AVE 4 2793 BENVENUE AV 2793.0 BENVENUE AV 4   Berkeley 94705 37.86022211620459 -122.2543164419715        
6 059 226101000 1467 Shattuck Ave 1467 SHATTUCK AVE 1467 SHATTUCK AV 1467.0 SHATTUCK AV     Berkeley 94709 37.88086633869915 -122.26894662836916        
7 052 155200400 1924 Woolsey St 1924 WOOLSEY ST 1924 WOOLSEY ST 1924.0 WOOLSEY ST     Berkeley 94703 37.85185178785158 -122.2684793382331        
8 053 160002800 2913 Harper St 2913 HARPER ST 2913 HARPER ST 2913.0 HARPER ST     Berkeley 94703 37.855467068807606 -122.27198809844408        
9 055 183202000 2529 Ellsworth St 3 2529 ELLSWORTH ST 3 2529 ELLSWORTH ST 2529.0 ELLSWORTH ST 3   Berkeley 94704 37.863535204658334 -122.26252992007392        
10 064 425001100 145 Hillcrest Rd 145 HILLCREST RD 145 HILLCREST RD 145.0 HILLCREST RD     Berkeley 94705 37.853069712308425 -122.24551551058904        
11 055 183800201 2430 Dwight Way 102 2430 DWIGHT WAY 102 2430 DWIGHT WY 2430.0 DWIGHT WY 102   Berkeley 94704 37.86431751538991 -122.25900638616976        
12 059 231000205 1080 Jones St Apt 512 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 512 APT Berkeley 94710 37.876038373846576 -122.29539666491728        
13 054 171400300 2706 Telegraph Ave Front 2706 TELEGRAPH AVE FRONT 2706 TELEGRAPH AV 2706.0 TELEGRAPH AV FRONT   Berkeley 94705 37.86119392760136 -122.25934374667808        
14 064 423901200 3027 Claremont Ave 3027 CLAREMONT AVE 3027 CLAREMONT AV 3027.0 CLAREMONT AV     Berkeley 94705 37.85486984834304 -122.24748219942713        
15 052 145200200 3218 Idaho St 3218 IDAHO ST 3218 IDAHO ST 3218.0 IDAHO ST     Berkeley 94702 37.8491320149456 -122.281982332087        
16 056 199601203 1414 University Ave 1414 UNIVERSITY AVE 1414 UNIVERSITY AV 1414.0 UNIVERSITY AV     Berkeley 94702 37.86948675482731 -122.28358104044192        
17 063 295200200 30 Alta Rd 30 ALTA RD 30 ALTA RD 30.0 ALTA RD     Berkeley 94708 37.902526297842634 -122.27036099254636        
18 055 183002100 2222 Dwight Way 3 2222 DWIGHT WAY 3 2222 DWIGHT WY 2222.0 DWIGHT WY 3   Berkeley 94704 37.8641122429479 -122.26413389165808        
19 058 217700100 1709 Shattuck Ave 222 1709 SHATTUCK AVE 222 1709 SHATTUCK AV 1709.0 SHATTUCK AV 222   Berkeley 94709 37.87615366613259 -122.26846057871502        
20 058 212803500 1644 San Pablo Ave A 1644 SAN PABLO AVE A 1644 SAN PABLO AV 1644.0 SAN PABLO AV A   Berkeley 94702 37.87397257310421 -122.2941110679479        
21 063 296505500 663 Grizzly Peak Blvd 663 GRIZZLY PEAK BLVD 663 GRIZZLY PEAK BL 663.0 GRIZZLY PEAK BL     Berkeley 94708 37.90001301041502 -122.26535644216594        
22 056 197300501 1040 University Ave 327 1040 UNIVERSITY AVE 327 1040 UNIVERSITY AV 1040.0 UNIVERSITY AV 327   Berkeley 94710 37.86854806864747 -122.29348350219549        
23 055 189500500 2035 Channing Way 303 2035 CHANNING WAY 303 2035 CHANNING WY 2035.0 CHANNING WY 303   Berkeley 94704 37.86597060980446 -122.26833746011376        
24 052 155700500 2311 Woolsey St D 2311 WOOLSEY ST D 2311 WOOLSEY ST 2311.0 WOOLSEY ST D   Berkeley 94705 37.853073541808456 -122.26134864176348        
25 058 218203600 1729 Spruce St 1729 SPRUCE ST 1729 SPRUCE ST 1729.0 SPRUCE ST     Berkeley 94709 37.87652044749161 -122.26508568993928        
26 056 199400503 1320 Addison St Unit C232 1320 ADDISON ST 1320 ADDISON ST 1320.0 ADDISON ST C232 UNIT Berkeley 94702 37.86831066712861 -122.28464976433882        
27 052 155701400 2314 Prince St C 2314 PRINCE ST C 2314 PRINCE ST 2314.0 PRINCE ST C   Berkeley 94705 37.85347146826686 -122.26118578888055        
28 057 206802100 1510 Hearst Ave 3 1510 HEARST AVE 3 1510 HEARST AV 1510.0 HEARST AV 3   Berkeley 94703 37.871979332917654 -122.28150346356524        
29 055 184600101 2501 Benvenue Ave 30 2501 BENVENUE AVE 30 2501 BENVENUE AV 2501.0 BENVENUE AV 30   Berkeley 94704 37.8653038478608 -122.25491987717878        
30 059 228301400 1421 Mcgee Ave B 1421 MCGEE AVE B 1421 MCGEE AV 1421.0 MCGEE AV B   Berkeley 94703 37.879495986894675 -122.27933884353074        
31 054 174204900 2762 Mathews St 2762 MATHEWS ST 2762 MATHEWS ST 2762.0 MATHEWS ST     Berkeley 94702 37.85573149668548 -122.28609082644626        
32 056 201000800 2112 Roosevelt Ave A 2112 ROOSEVELT AVE A 2112 ROOSEVELT AV 2112.0 ROOSEVELT AV A   Berkeley 94703 37.86957367691092 -122.27655582145805        
33 055 191402700 2415 Sacramento St 2415 SACRAMENTO ST 2415 SACRAMENTO ST 2415.0 SACRAMENTO ST     Berkeley 94702 37.86349379177683 -122.28089092572915        
34 059 229300106 1290 Hopkins St 9 1290 HOPKINS ST 9 1290 HOPKINS ST 1290.0 HOPKINS ST 9   Berkeley 94702 37.8775084403227 -122.28851462481325        
35 058 219300102 1708 Euclid Ave 2 1708 EUCLID AVE 2 1708 EUCLID AV 1708.0 EUCLID AV 2   Berkeley 94709 37.87740017556253 -122.26087638214726        
36 061 257000700 1971 Hopkins St 1971 HOPKINS ST 1971 HOPKINS ST 1971.0 HOPKINS ST     Berkeley 94707 37.887872896105094 -122.27334417094248        
37 055 190700700 2416 Roosevelt Ave 5 2416 ROOSEVELT AVE 5 2416 ROOSEVELT AV 2416.0 ROOSEVELT AV 5   Berkeley 94703 37.86411656476258 -122.2759929784235        
38 052 154000600 1453 66th St 1453 66TH ST 1453 66TH ST 1453.0 66TH ST     Berkeley 94702 37.850494098299066 -122.27898201383526        
39 062 286101200 1545 Thousand Oaks Blvd 1545 THOUSAND OAKS BLVD 1545 THOUSAND OAKS BL 1545.0 THOUSAND OAKS BL     Berkeley 94707 37.89679278792589 -122.28652091914304        
40 052 156902000 2925 Hillegass Ave 2925 HILLEGASS AVE 2925 HILLEGASS AV 2925.0 HILLEGASS AV     Berkeley 94705 37.85726900739488 -122.25521665090425        
41 057 207500500 1435 Berkeley Way 1435 BERKELEY WAY 1435 BERKELEY WY 1435.0 BERKELEY WY     Berkeley 94702 37.87129018445151 -122.2828227940702        
42 055 181603000 1936 Blake St 18 1936 BLAKE ST 18 1936 BLAKE ST 1936.0 BLAKE ST 18   Berkeley 94704 37.86238468255223 -122.27022266726398        
43 059 226503700 2008 Rose St 2008 ROSE ST 2008 ROSE ST 2008.0 ROSE ST     Berkeley 94709 37.88150576234678 -122.27100827631928        
44 060 246401100 2249 Glen Ave 2249 GLEN AVE 2249 GLEN AV 2249.0 GLEN AV     Berkeley 94709 37.88469248925343 -122.26526777844737        
45 061 257702700 929 Mendocino Ave 929 MENDOCINO AVE 929 MENDOCINO AV 929.0 MENDOCINO AV     Berkeley 94707 37.89092911152244 -122.27396082216418        
46 058 219400100 1652 Euclid Ave 3 1652 EUCLID AVE 3 1652 EUCLID AV 1652.0 EUCLID AV 3   Berkeley 94709 37.87841445612566 -122.26101042875396        
47 062 288803300 1886 San Pedro Ave 1886 SAN PEDRO AVE 1886 SAN PEDRO AV 1886.0 SAN PEDRO AV     Berkeley 94707 37.893759925568006 -122.277405502851        
48 053 159100802 2916 Newbury St 2916 NEWBURY ST 2916 NEWBURY ST 2916.0 NEWBURY ST     Berkeley 94703 37.85579849311087 -122.26775051528016        
49 052 157300900 2631 Webster St 2631 WEBSTER ST 2631 WEBSTER ST 2631.0 WEBSTER ST     Berkeley 94705 37.856236198329135 -122.25370512135268        
50 056 192701900 2365 San Pablo Ave 2365 SAN PABLO AVE 2365 SAN PABLO AV 2365.0 SAN PABLO AV     Berkeley 94702 37.86357401901893 -122.28998707046344        
51 055 189800700 1931 Dwight Way 15 1931 DWIGHT WAY 15 1931 DWIGHT WY 1931.0 DWIGHT WY 15   Berkeley 94704 37.863819744722456 -122.27057484368626        
52 060 246302300 2290 Eunice St 2290 EUNICE ST 2290 EUNICE ST 2290.0 EUNICE ST     Berkeley 94709 37.88593906545171 -122.26556284986536        
53 057 206001200 1810 Berkeley Way 4 1810 BERKELEY WAY 4 1810 BERKELEY WY 1810.0 BERKELEY WY 4   Berkeley 94703 37.87197267857206 -122.27469630343002        
54 055 188500201 2315 Durant Ave 307 2315 DURANT AVE 307 2315 DURANT AV 2315.0 DURANT AV 307   Berkeley 94704 37.86767914241777 -122.262294565961        
55 052 157403700 3009 Dana St D 3009 DANA ST D 3009 DANA ST 3009.0 DANA ST D   Berkeley 94705 37.85498171317734 -122.25837304694502        
56 052 154503100 1632 Prince St C 1632 PRINCE ST C 1632 PRINCE ST 1632.0 PRINCE ST C   Berkeley 94703 37.851748615836954 -122.27494754694362        
57 054 180401201 1621 Carleton St 1621 CARLETON ST 1621 CARLETON ST 1621.0 CARLETON ST     Berkeley 94703 37.860271015415954 -122.27712902745768        
58 053 159402400 2030 Essex St A 2030 ESSEX ST A 2030 ESSEX ST 2030.0 ESSEX ST A   Berkeley 94703 37.85352297506441 -122.26683968466747        
59 058 218600400 1640 Scenic Ave 2 1640 SCENIC AVE 2 1640 SCENIC AV 1640.0 SCENIC AV 2   Berkeley 94709 37.878542616840186 -122.26311174810364        
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        
61 057 207201501 1440 Berkeley Way 1440 BERKELEY WAY 1440 BERKELEY WY 1440.0 BERKELEY WY     Berkeley 94702 37.87090866835336 -122.28249569501736        
62 052 153803300 3234 Baker St 3234 BAKER ST 3234 BAKER ST 3234.0 BAKER ST     Berkeley 94702 37.84884470212363 -122.28009767650238        
63 052 158401600 3042 Fulton St C 3042 FULTON ST C 3042 FULTON ST 3042.0 FULTON ST C   Berkeley 94705 37.85405530514662 -122.26350854294776        
64 060 245501000 1222 Shattuck Ave A 1222 SHATTUCK AVE A 1222 SHATTUCK AV 1222.0 SHATTUCK AV A   Berkeley 94709 37.88473974934014 -122.27023117610636        
65 059 231000205 1080 Jones St Apt 551 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 551 APT Berkeley 94710 37.87615380369332 -122.29482956566495        
66 053 161300700 1531 Prince St 2 1531 PRINCE ST 2 1531 PRINCE ST 1531.0 PRINCE ST 2   Berkeley 94703 37.85190834535323 -122.27751938317788        
67 063 314009500 1064 Overlook Rd 1064 OVERLOOK RD 1064 OVERLOOK RD 1064.0 OVERLOOK RD     Berkeley 94708 37.89259905172096 -122.2550630237193        
68 053 168200100 2870 Adeline St 602 2870 ADELINE ST 602 2870 ADELINE ST 2870.0 ADELINE ST 602   Berkeley 94703 37.85692293566353 -122.2687468205921        
69 059 228703100 1609 San Pablo Ave B 1609 SAN PABLO AVE B 1609 SAN PABLO AV 1609.0 SAN PABLO AV B   Berkeley 94702 37.87486099453608 -122.29363781748992        
70 055 182100700 2037 Parker St Apt 306 2037 PARKER ST 2037 PARKER ST 2037.0 PARKER ST 306 APT Berkeley 94704 37.862287718095075 -122.26793969598742        
71 060 248604400 1259 Queens Rd 1259 QUEENS RD 1259 QUEENS RD 1259.0 QUEENS RD     Berkeley 94708 37.88677757474611 -122.25360426120751        
72 053 159500200 2008 Emerson St 3 2008 EMERSON ST 3 2008 EMERSON ST 2008.0 EMERSON ST 3   Berkeley 94703 37.85409548349568 -122.26858630961712        
73 056 197700300 1046 Addison St 1046 ADDISON ST 1046 ADDISON ST 1046.0 ADDISON ST     Berkeley 94710 37.86745915647912 -122.29232508870398        
74 057 202301701 2002 Addison St 2 2002 ADDISON ST 2 2002 ADDISON ST 2002.0 ADDISON ST 2   Berkeley 94704 37.8707665181595 -122.27030273500355        
75 055 183002001 2220 Dwight Way 204 2220 DWIGHT WAY 204 2220 DWIGHT WY 2220.0 DWIGHT WY 204   Berkeley 94704 37.864077629415895 -122.26438686712356        
76 059 227802500 1629 Cedar St 1629 CEDAR ST 1629 CEDAR ST 1629.0 CEDAR ST     Berkeley 94703 37.87733495867239 -122.27923421944456        
77 058 217700100 1709 Shattuck Ave 311 1709 SHATTUCK AVE 311 1709 SHATTUCK AV 1709.0 SHATTUCK AV 311   Berkeley 94709 37.87615366613259 -122.26846057871502        
78 055 189901700 2409 Martin Luther King Jr Way 2409 MARTIN LUTHER KING JR WAY 2409 MARTIN LUTHER KING JR WY 2409.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.86496930901207 -122.2719699569669        
79 060 248201600 1340 Queens Rd 1340 QUEENS RD 1340 QUEENS RD 1340.0 QUEENS RD     Berkeley 94708 37.88525257867311 -122.25265455779756        
80 059 229000300 1208 Rose St 1208 ROSE ST 1208 ROSE ST 1208.0 ROSE ST     Berkeley 94702 37.87634690040688 -122.29120824924382        
81 057 203201200 2112 Addison St 310 2112 ADDISON ST 310 2112 ADDISON ST 2112.0 ADDISON ST 310   Berkeley 94704 37.87110287937675 -122.26706095589168        
82 055 188100400 2449 Dwight Way 33 2449 DWIGHT WAY 33 2449 DWIGHT WY 2449.0 DWIGHT WY 33   Berkeley 94704 37.86530920217209 -122.25876941598769 38 27.0 In Review both
83 062 288502900 1836 Capistrano Ave 1836 CAPISTRANO AVE 1836 CAPISTRANO AV 1836.0 CAPISTRANO AV     Berkeley 94707 37.89411625933739 -122.27977139311984        
84 052 158403200 3021 Wheeler St 3021 WHEELER ST 3021 WHEELER ST 3021.0 WHEELER ST     Berkeley 94705 37.85462077193717 -122.26407099252022        
85 062 287401100 1561 Capistrano Ave 1561 CAPISTRANO AVE 1561 CAPISTRANO AV 1561.0 CAPISTRANO AV     Berkeley 94707 37.89159855168666 -122.2854602621174        
86 062 289500100 551 Santa Rosa Ave 551 SANTA ROSA AVE 551 SANTA ROSA AV 551.0 SANTA ROSA AV     Berkeley 94707 37.8984196827758 -122.28244555824472 72 1.0 Under Review official_permit
87 056 192002100 1315 Dwight Way 1315 DWIGHT WAY 1315 DWIGHT WY 1315.0 DWIGHT WY     Berkeley 94702 37.862281240176614 -122.28538183110828        
88 052 156103600 3005 Hillegass Ave 3005 HILLEGASS AVE 3005 HILLEGASS AV 3005.0 HILLEGASS AV     Berkeley 94705 37.85560371476175 -122.25469746778914        
89 060 249400301 104 Hill Rd 104 HILL RD 104 HILL RD 104.0 HILL RD     Berkeley 94708 37.887867387461775 -122.25092691155494        
90 055 184600500 2504 College Ave 6 2504 COLLEGE AVE 6 2504 COLLEGE AV 2504.0 COLLEGE AV 6   Berkeley 94704 37.865504616537685 -122.25408878642062        
91 053 160400900 2912 Ellis St 2912 ELLIS ST 2912 ELLIS ST 2912.0 ELLIS ST     Berkeley 94703 37.855169596152535 -122.27364212685085        
92 056 199100111 2207 Bonar St D 2207 BONAR ST D 2207 BONAR ST 2207.0 BONAR ST D   Berkeley 94702 37.866568106966895 -122.28655615556006        
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        
94 060 248100300 1224 Queens Rd 1224 QUEENS RD 1224 QUEENS RD 1224.0 QUEENS RD     Berkeley 94708 37.887553409000624 -122.25383277824274        
95 060 242800107 1302 Albina Ave A 1302 ALBINA AVE A 1302 ALBINA AV 1302.0 ALBINA AV A   Berkeley 94706 37.88199322421002 -122.2840703159463 33 50.0 In Review official_permit
96 057 205001302 2015 Hearst Ave 2015 HEARST AVE 2015 HEARST AV 2015.0 HEARST AV     Berkeley 94709 37.87395294459053 -122.27023887017674        
97 055 189801700 2441 Martin Luther King Jr Way 2441 MARTIN LUTHER KING JR WAY 2441 MARTIN LUTHER KING JR WY 2441.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.86375817951277 -122.2719193701383 27 65.0 Incomplete Pending Applicant both
98 053 167000603 2836 Sacramento St 2836 SACRAMENTO ST 2836 SACRAMENTO ST 2836.0 SACRAMENTO ST     Berkeley 94702 37.85619717370725 -122.27995025128617        
99 060 243003201 1330 Sacramento St 35 1330 SACRAMENTO ST 35 1330 SACRAMENTO ST 1330.0 SACRAMENTO ST 35   Berkeley 94702 37.880523567725994 -122.28353562701108        
100 055 182202600 2030 Dwight Way 201 2030 DWIGHT WAY 201 2030 DWIGHT WY 2030.0 DWIGHT WY 201   Berkeley 94704 37.863593502784774 -122.2682385169734        

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW addresses_with_projects AS
SELECT 
    a.*,
    p.project_id,
    p.net_units,
    p.status as project_status,
    p.data_source
FROM addresses a
LEFT JOIN projects p ON a.address_id = p.address_id;