Street_Tree_List

Data source: data.sfgov.org

837 rows where qSpecies = 42

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

SiteOrder

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
117 220007 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 929 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/12/2015 03:22:00 PM 1 Width 3ft Permit Number 24134 6006336.25046 2104153.4311599997 37.7579627654961 -122.421110461684 (37.7579627654961, -122.421110461684)
371 8188 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1272 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/19/1997 12:00:00 AM 10 3X4   6001679.2828 2111174.9406 37.7769784708042 -122.437719062833 (37.7769784708042, -122.437719062833)
1362 36186 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 133 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/04/1998 12:00:00 AM 8   Permit Number 39255 5995881.41756 2113499.8369 37.783030646722004 -122.45794382331002 (37.783030646722, -122.45794382331)
1434 20063 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
1536 251472 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Hiliritas Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/2017 12:00:00 AM 3 3x3 Permit Number 780012 6001589.0 2096875.0 37.7377091611847 -122.437007355935 (37.7377091611847, -122.437007355935)
1815 71427 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1852 Stockton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/06/2017 12:00:00 AM 3 4x4   6009993.7542 2120480.0499 37.802997311571104 -122.409613538987 (37.8029973115711, -122.409613538987)
2164 10688 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1221 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/18/1991 12:00:00 AM 6 3X3   6002001.6656 2110480.73 37.7750906677438 -122.43655414222 (37.7750906677438, -122.43655414222)
2515 124752 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2478 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2002 12:00:00 AM 9 Width 5ft   6002956.6534 2115870.86114 37.7899448329366 -122.433635939447 (37.7899448329366, -122.433635939447)
2637 37816 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003955.6668300005 2090537.19552 37.720441203374 -122.428373060073 (37.720441203374, -122.428373060073)
2638 37832 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 19 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048)
2661 37833 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 20 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003832.66245 2090342.4611400003 37.719899544415604 -122.428784371324 (37.7198995444156, -122.428784371324)
2852 215287 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 335 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft Permit Number 780412 5992944.71929 2103190.50616 37.7545548052666 -122.46735363008301 (37.7545548052666, -122.467353630083)
3060 203634 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 432 Flood Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM 11 Width 2ft Permit Number 42544 5997859.0322900005 2094116.10367 37.7299211747225 -122.449704832412 (37.7299211747225, -122.449704832412)
3716 20054 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
3793 39226 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 770 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1998 12:00:00 AM 9   Permit Number 40869 5984798.64138 2110605.0729799997 37.774439483359 -122.49607147975 (37.774439483359, -122.49607147975)
4165 253615 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2325 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/17/1998 12:00:00 AM   3x3 Permit Number 38749 6006221.0 2118816.0 37.7982161239914 -122.422550935399 (37.7982161239914, -122.422550935399)
5055 253765 Significant Tree 6 Acacia baileyana :: Bailey's Acacia 42 1366 Guerrero St 2 Front Yard : Yard 7 Tree 1 Private 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
5340 30595 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 265 Walter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34562          
5792 10690 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1233 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6001959.267000001 2110474.8139 37.7750720141838 -122.43670038449801 (37.7750720141838, -122.436700384498)
5920 139500 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 748 CENTRAL AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   5999620.0523 2111133.4316 37.776747194618395 -122.44483956661199 (37.7767471946184, -122.444839566612)
6724 102771 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1438 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6006063.66154 2119354.00796 37.7996844799161 -122.42313363592501 (37.7996844799161, -122.423133635925)
6851 20056 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
7439 19729 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY14 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 40ST            
7598 103885 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1750 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999418.3529 2110865.7399 37.7760006689038 -122.445518048679 (37.7760006689038, -122.445518048679)
7770 20060 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
8578 10632 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 830 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/1990 12:00:00 AM 12 3X3   6003878.786 2110787.057 37.7760382564385 -122.43008262774599 (37.7760382564385, -122.430082627746)
8838 10631 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 829 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/02/1990 12:00:00 AM 18 3X3   6003873.4823 2110738.4269 37.7759044297862 -122.430097504694 (37.7759044297862, -122.430097504694)
8932 19577 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY3 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 15ST            
8970 10634 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 830 Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/02/1990 12:00:00 AM 12 3X3   6003840.507 2110782.2115 37.7760227838468 -122.43021469913201 (37.7760227838468, -122.430214699132)
9300 1913 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 8 Bell Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/16/1992 12:00:00 AM 3 3X3   6016615.0158522995 2095214.1533182 37.7339914292631 -122.384939021898 (37.7339914292631, -122.384939021898)
10290 37814 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003977.37565 2090552.2455 37.720483755714 -122.428299091747 (37.720483755714, -122.428299091747)
10291 19793 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY19 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 20ST            
10474 34625 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1466 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 10 3x3 Permit Number 38307 5988697.9248 2105373.4338 37.76030245534 -122.482199912019 (37.76030245534, -122.482199912019)
11185 20057 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
12141 17224 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1880X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 3X3   6001029.5778 2091188.70927 37.72206410195621 -122.43853424087601 (37.7220641019562, -122.438534240876)
12540 108677 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 11 Otsego Ave 1 Front Yard : Yard 7 Tree 1 Private 1 FUF 1 12/30/2014 12:00:00 AM 3   Permit Number 773206 6000966.57436 2092971.8241299998 37.7269565451936 -122.438879746024 (37.7269565451936, -122.438879746024)
12807 17229 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1880X Alemany Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3X3   6000980.939130001 2091103.3398799999 37.7218269300432 -122.438696258244 (37.7218269300432, -122.438696258244)
12958 37815 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 450X Moscow St 2 Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 DPW for City Agency 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003965.721940001 2090553.1315400002 37.7204855291627 -122.42833943800899 (37.7204855291627, -122.428339438009)
13900 102846 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 29 Guy Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 1x1   6014262.35987 2114356.78408 37.786422526635604 -122.394412832193 (37.7864225266356, -122.394412832193)
15210 20061 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
15314 30594 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 265 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34562          
15394 20062 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
15615 30591 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 253 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/26/1995 12:00:00 AM     Permit Number 34560          
15903 20055 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
16172 20064 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
16814 105175 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1601X Newcomb Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Arts Commission 19     10 3x3   6015153.3918 2095715.6028 37.735287354242395 -122.390027366589 (37.7352873542424, -122.390027366589)
16839 20059 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 100 STAIRWAY54 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 15ST            
18171 1377 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 65 Amethyst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/1998 12:00:00 AM 3 1X1   5998937.99517 2100006.33795 37.746156024995706 -122.44639832203 (37.7461560249957, -122.44639832203)
18568 39703 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 634 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1999 12:00:00 AM     Permit Number 41088 5998596.64163755 2094795.02743762 37.7318275120035 -122.44720368280001 (37.7318275120035, -122.4472036828)
19047 23032 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 937 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2003 12:00:00 AM 8 3X3   6006338.92475 2104110.62405 37.757845377874204 -122.42109817336599 (37.7578453778742, -122.421098173366)
19290 24816 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 400X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/18/1996 12:00:00 AM 12 2x3   6008197.49032 2095113.0796700001 37.733244720069706 -122.414033944713 (37.7332447200697, -122.414033944713)
19697 85509 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
19744 66789 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1405 Greenwich St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/23/1991 12:00:00 AM 8 3x3 Permit Number 30063 6006130.65101914 2119658.78326709 37.80052509557579 -122.42292350049 (37.8005250955758, -122.42292350049)
19917 28134 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 400X Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/17/2016 12:00:00 AM 3 6x9   6006749.04287 2098002.24216 37.741096261078404 -122.41924650972 (37.7410962610784, -122.41924650972)
20126 22809 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 19 Turquoise Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/01/1998 12:00:00 AM 3 3x3   5998930.058209999 2099793.7189700003 37.745571771416294 -122.446410473673 (37.7455717714163, -122.446410473673)
20390 66640 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2620 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32335 6010387.14006944 2103433.53881978 37.756213630012496 -122.407049963033 (37.7562136300125, -122.407049963033)
21207 10209 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1301 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/17/1994 12:00:00 AM 12 3X3PL   6005849.39823 2101351.62015 37.7502421837319 -122.4225951102 (37.7502421837319, -122.4225951102)
21499 24820 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 400X Alemany Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   05/22/2008 12:00:00 AM 12 3x3   6007910.58435 2094958.48618 37.732804121515606 -122.415014921609 (37.7328041215156, -122.415014921609)
21718 22808 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 19 Turquoise Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/1991 12:00:00 AM 3 2X2   5998906.136630001 2099819.83871 37.745642123584105 -122.446495069307 (37.7456421235841, -122.446495069307)
22043 859 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 400X Alemany Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3x3   6008091.178180001 2095049.40427 37.7330639095777 -122.41439699202299 (37.7330639095777, -122.414396992023)
22329 248977 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 748 Central Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999650.0 2111146.0 37.7767834132689 -122.444736872581 (37.7767834132689, -122.444736872581)
23355 76748 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1501X 42nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/14/1994 12:00:00 AM 7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631)
23746 188514 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1 Mississippi St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6013990.927619999 2106981.7626099996 37.7661572890446 -122.394835230264 (37.7661572890446, -122.394835230264)
24164 54840 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 236 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/01/1983 12:00:00 AM 6 3x3 Permit Number 10695 5998822.5685 2109866.5256 37.77322305193879 -122.447507074191 (37.7732230519388, -122.447507074191)
24187 142264 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 575 LINDEN ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6004642.0376 2110688.0426 37.775809585078896 -122.427435282317 (37.7758095850789, -122.427435282317)
24270 188526 DPW Maintained 3 Acacia baileyana :: Bailey's Acacia 42 1427x Innes Ave 12 Median : Yard 3 Tree 1 DPW 2     13     6016254.90623 2096663.3838099998 37.7379507994938 -122.386285047323 (37.7379507994938, -122.386285047323)
24822 250192 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 11 Alta St 2 Back Yard : Yard 13 Tree 1 Private 1     9 Width 0ft   6011786.88966 2119947.0785 37.8016342173021 -122.403370805543 (37.8016342173021, -122.403370805543)
25195 203226 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1575 07th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5993976.59011 2104728.66377 37.7588377051234 -122.463896818678 (37.7588377051234, -122.463896818678)
25432 220094 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 436 Arlington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6003910.2005900005 2096060.2503799999 37.735603706528394 -122.42892377971 (37.7356037065284, -122.42892377971)
25501 141630 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1801 GROVE ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5999025.3732 2110414.9246 37.774740403045996 -122.446845016858 (37.774740403046, -122.446845016858)
25732 220090 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Ord Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000882.83826 2105748.10477 37.7620324153945 -122.44008496885401 (37.7620324153945, -122.440084968854)
26281 220668 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 680 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6007462.21417 2105696.0479 37.762261844143296 -122.417325709834 (37.7622618441433, -122.417325709834)
26472 220689 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 119 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6004994.550369999 2099284.37518 37.744517739909 -122.42540413451401 (37.744517739909, -122.425404134514)
26644 48033 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 61 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2002 12:00:00 AM     Permit Number 45754 6001724.06677399 2105480.90222389 37.761346597247794 -122.437156358638 (37.7613465972478, -122.437156358638)
26908 219997 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 80 Stoneman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6007927.7529 2099409.5439400002 37.7450267121064 -122.41527054312 (37.7450267121064, -122.41527054312)
27343 203223 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 25 Upland Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994463.96401 2093754.2883099997 37.7287328942013 -122.461415680898 (37.7287328942013, -122.461415680898)
27440 35252 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1385 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1998 12:00:00 AM 7   Permit Number 38738 6006246.10083 2119680.0646 37.8005900423666 -122.42252550983801 (37.8005900423666, -122.422525509838)
27735 38051 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2700 Bush St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM 0   Permit Number 40248 6000571.40891222 2114495.1875696997 37.786031962456896 -122.44178988005899 (37.7860319624569, -122.441789880059)
28541 220690 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 330 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003721.786040001 2099258.64688 37.7443751038286 -122.42980326002 (37.7443751038286, -122.42980326002)
29829 115807 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 742 Central Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5999623.0981 2111117.8642 37.7767046243395 -122.444827911038 (37.7767046243395, -122.444827911038)
30607 38043 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1523 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM 8   Permit Number 40245 6000097.0958 2114311.3232 37.7855000811005 -122.44341765838199 (37.7855000811005, -122.443417658382)
30672 220054 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 300 Virginia Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6006920.61613 2098340.82095 37.742035584087795 -122.418677274846 (37.7420355840878, -122.418677274846)
30832 203666 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 123 Detroit St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5999405.93855 2093561.74161 37.728487406244604 -122.44431719010001 (37.7284874062446, -122.4443171901)
30888 42696 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1751 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM 7   Permit Number 42713 6007796.58473 2118447.48214 37.7972930261196 -122.417072803384 (37.7972930261196, -122.417072803384)
31248 220041 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 890 Alvarado St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6000667.40596 2102598.56375 37.7533722777334 -122.440604151054 (37.7533722777334, -122.440604151054)
31368 40190 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 600 Silliman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/30/1999 12:00:00 AM 8   Permit Number 41375 6008992.69015 2093809.01989 37.729708681998 -122.411192625738 (37.729708681998, -122.411192625738)
31523 188515 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1401 25th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6014455.23285 2101981.54762 37.752453585184604 -122.39287941707799 (37.7524535851846, -122.392879417078)
31678 137728 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1989 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5999638.3271 2111189.9480000003 37.77690341710429 -122.444780412241 (37.7769034171043, -122.444780412241)
31819 220062 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 430 College Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6005376.5701 2095055.5296099999 37.7329278583224 -122.423782556133 (37.7329278583224, -122.423782556133)
32234 220023 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 89 Homestead St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6001002.01011 2101166.3716 37.749458870636396 -122.439344371761 (37.7494588706364, -122.439344371761)
32463 174965 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1645 Felton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6006090.3331 2092391.29935 37.725652733270294 -122.42112577893101 (37.7256527332703, -122.421125778931)
32571 69145 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 2419 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/18/1994 12:00:00 AM 6   Permit Number 33179 5983608.7607 2098659.5816 37.741570751884 -122.499304541285 (37.741570751884, -122.499304541285)
32938 203645 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 2450 17th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5991098.28096 2098726.3101 37.7421905156936 -122.473413447294 (37.7421905156936, -122.473413447294)
32980 30799 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 131 Brompton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1995 12:00:00 AM 8   Permit Number 34665 6002107.114019999 2095231.84638 37.733226875715296 -122.43509850062 (37.7332268757153, -122.43509850062)
33112 220001 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 88 Santa Marina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6006158.19776 2097552.9133 37.7398292116563 -122.4212575422 (37.7398292116563, -122.4212575422)
33288 220075 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 311 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6001146.06945 2104525.9934099996 37.758691778412704 -122.43908696419201 (37.7586917784127, -122.439086964192)
33357 220021 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1334 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6001964.613530001 2100084.23013 37.7465422991033 -122.435938247064 (37.7465422991033, -122.435938247064)
33499 174962 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 114 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6000450.3974 2092235.26707 37.724904747337106 -122.440611347459 (37.7249047473371, -122.440611347459)
33547 137666 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1901 GOLDEN GATE AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6000398.0082 2111639.7629 37.7781818179135 -122.442184748811 (37.7781818179135, -122.442184748811)
33826 184961 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1990 41st Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983548.8239 2101628.2630000003 37.7497184185455 -122.4997311455 (37.7497184185455, -122.4997311455)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 518.251ms · Data source: data.sfgov.org