Street_Tree_List

Data source: data.sfgov.org

994 rows where qSpecies = 39 sorted by qLegalStatus

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1985 252841 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1763 Golden Gate Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/1998 12:00:00 AM   3x3 Permit Number 40601 6001163.0 2111730.0 37.7784731541065 -122.43954484007 (37.7784731541065, -122.43954484007)
4251 246122 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1518 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft Permit Number 46036 5998379.9097 2108286.3815 37.768859073318 -122.448924438468 (37.768859073318, -122.448924438468)
5531 7687 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 521 Francisco St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6008787.0132 2121079.8095 37.8045764073538 -122.413831954826 (37.8045764073538, -122.413831954826)
8274 41820 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 848 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/2016 12:00:00 AM 3   Permit Number 42207 6000005.683999999 2111868.9913 37.7787888536845 -122.44355840768 (37.7787888536845, -122.44355840768)
11531 43168 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 285 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 14 3x3 Permit Number 42977 6005738.99154 2092366.96158 37.7255660943895 -122.422338611837 (37.7255660943895, -122.422338611837)
12964 44723 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1946 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2001 12:00:00 AM 13   Permit Number 43842 5989432.8015 2102080.7043 37.751304216428 -122.47941744514699 (37.751304216428, -122.479417445147)
13735 22066 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2955 03rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/2000 12:00:00 AM 14 3X3   6015999.04813 2101774.12278 37.751969669865396 -122.387526128851 (37.7519696698654, -122.387526128851)
14844 12128 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1400X La Salle Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6016480.84106 2095117.09347 37.73371749994771 -122.385396148429 (37.7337174999477, -122.385396148429)
17255 32525 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 864 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/15/1996 12:00:00 AM 14 3x3 Permit Number 37027 6007539.30835 2095267.7389900002 37.7336323917164 -122.41632041617399 (37.7336323917164, -122.416320416174)
17710 4470 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1500 Church St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004528.8343 2100105.60966 37.746746337268206 -122.42707296863999 (37.7467463372682, -122.42707296864)
17771 16032 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 155 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5993339.50797 2095294.7939400002 37.7328979594755 -122.465414825734 (37.7328979594755, -122.465414825734)
18999 4466 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1484 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6004525.42539 2100206.65772 37.747023599154204 -122.427091952431 (37.7470235991542, -122.427091952431)
19052 22819 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 61 Turquoise Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 2X2 10/31/08 5999145.766480001 2099274.26515 37.7441577943622 -122.445627242426 (37.7441577943622, -122.445627242426)
19220 4482 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1551 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004606.71516 2099825.83197 37.7459825358766 -122.426783743093 (37.7459825358766, -122.426783743093)
21257 4479 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1542 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6004543.28364 2099929.0819200003 37.7462624498637 -122.427010433384 (37.7462624498637, -122.427010433384)
24685 32723 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1082 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM 12   Permit Number 37114 6007012.43686 2114697.78275 37.786953139214894 -122.419519994465 (37.7869531392149, -122.419519994465)
26017 82939 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 741 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2009 12:00:00 AM 7 3x3 Permit Number 52449 6009171.80953 2110382.94472 37.775227013061 -122.411744028881 (37.775227013061, -122.411744028881)
26530 32698 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 665 Geary St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM 11   Permit Number 37104 6008567.49434 2114513.32482 37.7865341297888 -122.41412677632799 (37.7865341297888, -122.414126776328)
27432 66268 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2008 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/1990 12:00:00 AM 12   Permit Number 29375 5986711.6119 2096941.9622 37.7370361716902 -122.488449873835 (37.7370361716902, -122.488449873835)
30141 42966 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 160 Belgrave Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/13/2000 12:00:00 AM     Permit Number 42854 5997814.60948514 2104925.35351079 37.75959819679839 -122.45063741216002 (37.7595981967984, -122.45063741216)
30876 37950 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 609 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/08/1998 12:00:00 AM 17   Permit Number 40190 6013298.71774 2104246.1656 37.7586074292188 -122.397037638472 (37.7586074292188, -122.397037638472)
37807 32670 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 450 Clementina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 25   Permit Number 37094 6011135.7894 2112024.86418 37.7798453222359 -122.405065778479 (37.7798453222359, -122.405065778479)
40072 37951 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 609 Connecticut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/08/1998 12:00:00 AM 12   Permit Number 40190 6013298.65055 2104257.08873 37.7586374180095 -122.397038636728 (37.7586374180095, -122.397038636728)
40488 32598 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1488 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/23/1996 12:00:00 AM 10   Permit Number 770751 5985603.1005 2105094.5695 37.759356274150704 -122.492882766578 (37.7593562741507, -122.492882766578)
41375 45055 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2311 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/23/2011 12:00:00 AM 1   Permit Number 767715 5988234.443 2099548.661 37.7442822204704 -122.483375858058 (37.7442822204704, -122.483375858058)
43900 31372 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 608 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/13/1997 12:00:00 AM 16   Permit Number 34974 5991288.7498699995 2099114.74799 37.7432680941565 -122.472783188016 (37.7432680941565, -122.472783188016)
43975 43992 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 141 Hampshire St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2000 12:00:00 AM 13   Permit Number 43551 6010011.61771 2107517.81839 37.7674071146631 -122.408636765987 (37.7674071146631, -122.408636765987)
46907 68269 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 424 Somerset St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 13   Permit Number 32076 6010049.762159999 2092483.07672 37.7261271472388 -122.40744475327499 (37.7261271472388, -122.407444753275)
48476 36977 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 181 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 16   Permit Number 39602 5993647.32145 2114324.1067 37.7851652576674 -122.46573272346599 (37.7851652576674, -122.465732723466)
50789 30773 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 548 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1995 12:00:00 AM 34   Permit Number 34652 6014000.72465 2112264.48181 37.7806629966488 -122.395171417543 (37.7806629966488, -122.395171417543)
55781 115288 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3096 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   5999946.68734 2116109.2112 37.7904280341715 -122.44406725681002 (37.7904280341715, -122.44406725681)
65760 32217 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 525 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1995 12:00:00 AM 24   Permit Number 35538 6009485.22492 2100263.16237 37.747457969910705 -122.409945309239 (37.7474579699107, -122.409945309239)
65910 38340 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1517 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/08/2000 12:00:00 AM 14   Permit Number 40407 5982158.3822 2104738.8652 37.7581775666431 -122.504769723467 (37.7581775666431, -122.504769723467)
73688 30472 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 524 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/02/1995 12:00:00 AM 11 3x3 Permit Number 119 6010416.9297 2119611.1498 37.8006352293469 -122.408087810014 (37.8006352293469, -122.408087810014)
74701 35839 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 518 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1998 12:00:00 AM 13   Permit Number 39066 6001544.15137 2090744.8292200002 37.7208745650816 -122.43672373202601 (37.7208745650816, -122.436723732026)
75335 67222 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 5428 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1992 12:00:00 AM 12   Permit Number 30681 5981782.23642 2111693.16407 37.7772499233167 -122.506586330196 (37.7772499233167, -122.506586330196)
76522 36974 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 181 07th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/29/1998 12:00:00 AM 10   Permit Number 39602 5993649.0736 2114306.93888 37.7851182205824 -122.46572541386601 (37.7851182205824, -122.465725413866)
77352 36702 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698x 19th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1998 12:00:00 AM     Permit Number 39496 6005001.97582164 2104885.80884876 37.759898394802605 -122.42577707942199 (37.7598983948026, -122.425777079422)
78184 42222 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
78767 12056 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1330X La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
78814 42223 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
79414 55370 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 177 San Aleso Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/2011 12:00:00 AM   2x3 Permit Number 767959 5993373.59500695 2094436.22943113 37.7305425193622 -122.465234638195 (37.7305425193622, -122.465234638195)
79810 68817 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 125 Congo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2007 12:00:00 AM     Permit Number 49379 6000058.92001633 2094143.32486819 37.730121532663105 -122.442101535638 (37.7301215326631, -122.442101535638)
80578 36705 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3690x 19TH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1998 12:00:00 AM     Permit Number 39496 6005025.9 2104880.3 37.759884620726204 -122.425693945182 (37.7598846207262, -122.425693945182)
80819 12055 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1300X La Salle Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     18 3X3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
81989 39617 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 143 Parnassus Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/1998 12:00:00 AM     Permit Number 41017 5997752.15145133 2106762.51515119 37.7646390036764 -122.45098590004999 (37.7646390036764, -122.45098590005)
82285 50882 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2055 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2004 12:00:00 AM     Permit Number 47392 5991593.93786831 2101441.81632133 37.7496752859252 -122.471897503797 (37.7496752859252, -122.471897503797)
82947 46916 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 161 Newman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/2013 12:00:00 AM     Permit Number 769519 6007338.4828929 2096787.18196624 37.7377931534639 -122.41712235805201 (37.7377931534639, -122.417122358052)
84579 49746 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 40@ LELAND Britton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM     Permit Number 46545 6008551.24165341 2087877.47374564 37.7133971377495 -122.412299691068 (37.7133971377495, -122.412299691068)
84687 41668 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500 Corbett Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2000 12:00:00 AM     Permit Number 42131 5999528.76445246 2104225.15584588 37.7577735947767 -122.44465870166599 (37.7577735947767, -122.444658701666)
85345 36703 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3690x 19TH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1998 12:00:00 AM     Permit Number 39496 6005025.9 2104880.3 37.759884620726204 -122.425693945182 (37.7598846207262, -122.425693945182)
86261 42484 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 50 Phelan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42614 5997088.18001 2092254.3140099999 37.7247650096883 -122.452235460018 (37.7247650096883, -122.452235460018)
87641 87256 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2 Garrison Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 50279 6008242.3 2086782.6 37.710373499787394 -122.413290127101 (37.7103734997874, -122.413290127101)
87838 1360 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1 Amethyst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5999260.364281501 2099960.847629 37.7460495263909 -122.445280344305 (37.7460495263909, -122.445280344305)
87952 111303 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3690x 19TH ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         6005025.9 2104880.3 37.759884620726204 -122.425693945182 (37.7598846207262, -122.425693945182)
89160 73475 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 340 Ritch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/04/2008 12:00:00 AM   3x3 Permit Number 50288 6014252.15043428 2111690.62627274 37.7791012985319 -122.394261419296 (37.7791012985319, -122.394261419296)
89550 52895 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1642 12th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2006 12:00:00 AM   3x3 Permit Number 48894 5992495.5632863 2104272.70590883 37.757500303864 -122.468985668503 (37.757500303864, -122.468985668503)
90863 43515 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 165 Newman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2000 12:00:00 AM     Permit Number 43192 6007354.1406378 2096784.95342482 37.7377879152119 -122.41706806363999 (37.7377879152119, -122.41706806364)
90990 84960 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2616 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2007 12:00:00 AM     Permit Number 49352 5988993.8 2097500.0 37.7387012975774 -122.48060025376301 (37.7387012975774, -122.480600253763)
91033 56997 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 469 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/1974 12:00:00 AM 14 4x4 Permit Number 14254 6003301.68334873 2103280.29729908 37.7553938131292 -122.431542939454 (37.7553938131292, -122.431542939454)
91233 44205 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 341 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/25/1986 12:00:00 AM     Permit Number 43653 6007751.99799899 2097517.30165944 37.739821155436 -122.415744314793 (37.739821155436, -122.415744314793)
92147 42218 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
92358 42224 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
92407 37521 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1112 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/22/1998 12:00:00 AM   3x3 Permit Number 39974 6007343.449516599 2115114.77721986 37.7881167428842 -122.41840434148199 (37.7881167428842, -122.418404341482)
92477 12059 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1330X La Salle Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
93198 12058 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1330X La Salle Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
93935 38688 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1763 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1998 12:00:00 AM     Permit Number 40601 6001154.46973963 2111747.51694807 37.7785207657155 -122.439575605477 (37.7785207657155, -122.439575605477)
93982 69756 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2 Garrison Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/19/2008 12:00:00 AM   3x3 Permit Number 50279 6008252.26832326 2086801.73422247 37.710426598074605 -122.41325702656601 (37.7104265980746, -122.413257026566)
94001 43523 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1442 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2000 12:00:00 AM     Permit Number 43199 6000900.07851404 2110723.16086375 37.7756936614931 -122.44038215551001 (37.7756936614931, -122.44038215551)
94433 38683 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1785 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/1998 12:00:00 AM     Permit Number 40599 5999225.65056076 2110784.42467282 37.7757663950795 -122.446178803683 (37.7757663950795, -122.446178803683)
94979 38022 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 180 Madrone Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/1998 12:00:00 AM     Permit Number 40233 5992584.62016279 2098022.80205393 37.740344819144795 -122.468223027257 (37.7403448191448, -122.468223027257)
95191 39732 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1999 12:00:00 AM     Permit Number 41104 6004245.08369654 2106017.71232833 37.7629635309961 -122.428475481414 (37.7629635309961, -122.428475481414)
95502 106502 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 420X Shrader St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5997462.73555 2109001.92463 37.770771276139705 -122.452148498658 (37.7707712761397, -122.452148498658)
95530 42477 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 50 Phelan Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42614 5997094.69001 2092414.90401 37.7252063248445 -122.45222453793501 (37.7252063248445, -122.452224537935)
96781 42220 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
97152 39662 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 340 Grafton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1998 12:00:00 AM     Permit Number 41053 5995802.87923545 2090583.42381532 37.7201034282275 -122.45655778592199 (37.7201034282275, -122.456557785922)
97389 38684 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1785 Fulton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/05/1998 12:00:00 AM     Permit Number 40599 5999225.65056076 2110784.42467282 37.7757663950795 -122.446178803683 (37.7757663950795, -122.446178803683)
98015 38023 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 180 Madrone Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1998 12:00:00 AM     Permit Number 40233 5992584.62016279 2098022.80205393 37.740344819144795 -122.468223027257 (37.7403448191448, -122.468223027257)
98607 39097 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3014 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/18/1998 12:00:00 AM 12 5x9 Permit Number 40786 6008165.45158313 2103310.33864273 37.7557507733516 -122.414724626281 (37.7557507733516, -122.414724626281)
99031 32507 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 100x OGDEN AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/15/1996 12:00:00 AM     Permit Number 37009 6007659.0 2096105.0 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682)
99641 48625 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1548 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/30/2002 12:00:00 AM     Permit Number 45922 5992473.51988967 2104913.75628044 37.7592591867123 -122.46910855694901 (37.7592591867123, -122.469108556949)
100770 35831 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 800 Edinburg St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1998 12:00:00 AM     Permit Number 39062 6001828.61140297 2089175.38471651 37.7165813830219 -122.435628217621 (37.7165813830219, -122.435628217621)
101395 46613 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 394 Fair Oaks St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/2002 12:00:00 AM     Permit Number 44735. Tree 4 on 25th St. 6005464.68638444 2101420.18882448 37.750408745884 -122.423930345056 (37.750408745884, -122.423930345056)
101434 43022 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 71 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM     Permit Number 42883 6005491.3790617995 2109225.31619528 37.7718412930396 -122.424393129042 (37.7718412930396, -122.424393129042)
102286 113325 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1234 10th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3   5993019.12807809 2107069.22790191 37.76520905664 -122.467378332531 (37.76520905664, -122.467378332531)
102771 38682 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1785 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/19/2000 12:00:00 AM     Permit Number 41971 5999225.65056076 2110784.42467282 37.7757663950795 -122.446178803683 (37.7757663950795, -122.446178803683)
103843 43507 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 161 Newman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/04/2013 12:00:00 AM     Permit Number 769519 6007338.4828929 2096787.18196624 37.7377931534639 -122.41712235805201 (37.7377931534639, -122.417122358052)
104567 54684 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1234 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1992 12:00:00 AM 14 3x3 Permit Number 30565 5993019.12807809 2107069.22790191 37.76520905664 -122.467378332531 (37.76520905664, -122.467378332531)
105824 97405 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2@Melrose Stanford Heights Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5997807.0 2095590.8 37.7339673631019 -122.449990957178 (37.7339673631019, -122.449990957178)
105957 42221 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
108241 87255 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2 Garrison Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/19/2008 12:00:00 AM   3x3 Permit Number 50279 6008242.3 2086782.6 37.710373499787394 -122.413290127101 (37.7103734997874, -122.413290127101)
108488 105973 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1336 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 771235 6006462.9 2119771.0 37.8008519560253 -122.421781757787 (37.8008519560253, -122.421781757787)
108551 43516 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 165 Newman St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2000 12:00:00 AM     Permit Number 43192 6007354.1406378 2096784.95342482 37.7377879152119 -122.41706806363999 (37.7377879152119, -122.41706806364)
109004 42219 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42483 6012771.23281155 2114106.53972764 37.785652410342 -122.399554213705 (37.785652410342, -122.399554213705)
109085 39733 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3698 17th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1999 12:00:00 AM     Permit Number 41104 6004245.08369654 2106017.71232833 37.7629635309961 -122.428475481414 (37.7629635309961, -122.428475481414)
109212 12062 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1330X La Salle Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
110154 92101 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1076 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/25/2009 12:00:00 AM   3x3 Permit Number 52984 6005698.0 2102695.0 37.7539222521842 -122.42321413605801 (37.7539222521842, -122.423214136058)
110365 46585 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 496 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/05/2002 12:00:00 AM     Permit Number 44714 6005497.60346294 2100827.74105942 37.748783878914296 -122.423774394842 (37.7487838789143, -122.423774394842)
110400 12057 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1330X La Salle Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     12 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
110912 35830 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 800 Edinburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1998 12:00:00 AM     Permit Number 39062 6001828.61140297 2089175.38471651 37.7165813830219 -122.435628217621 (37.7165813830219, -122.435628217621)

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 628.736ms · Data source: data.sfgov.org