Street_Tree_List

Data source: data.sfgov.org

994 rows where qSpecies = 39 sorted by PlantDate descending

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
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)
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)
127440 57737 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 373 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/1976 12:00:00 AM 16 3x3 Permit Number 16655 6005509.467344999 2101546.81860372 37.75075897011 -122.423784491996 (37.75075897011, -122.423784491996)
51940 74090 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2301 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/16/1995 12:00:00 AM 5     5986841.7666 2102304.3098 37.751767339194394 -122.488393849306 (37.7517673391944, -122.488393849306)
73794 73855 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2301 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/16/1995 12:00:00 AM 6     5986859.2227 2102304.8233 37.7517697676229 -122.488333522296 (37.7517697676229, -122.488333522296)
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)
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)
146660 73675 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 510 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/02/1995 12:00:00 AM 11     6010458.2549 2119616.6906 37.80065275675229 -122.407945198153 (37.8006527567523, -122.407945198153)
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)
115512 41136 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1890 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/18/1999 12:00:00 AM     Permit Number 41875 5997533.67783563 2108867.16274176 37.7704053182028 -122.451893385496 (37.7704053182028, -122.451893385496)
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)
179972 70461 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1130 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/18/1995 12:00:00 AM 17     6007328.122269999 2115219.69478 37.7884039579183 -122.418464813605 (37.7884039579183, -122.418464813605)
141513 39210 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 101 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/10/1999 12:00:00 AM     Permit Number 41852 5998202.98711321 2108218.1904746 37.7686617185434 -122.449531484363 (37.7686617185434, -122.449531484363)
4669 253646 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/09/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
20904 12016 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1230X La Salle Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/09/1992 12:00:00 AM 6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
86885 11999 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200X La Salle Ave 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/09/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
87797 11991 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200X La Salle Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/09/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
128523 11995 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200X La Salle Ave 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/09/1992 12:00:00 AM 18 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
4668 253644 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200x La Salle Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 11/05/1992 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
94658 11363 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1351X Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/05/1992 12:00:00 AM 45 3X3   6017270.42563 2093912.097264 37.730452470679005 -122.38258247713001 (37.730452470679, -122.38258247713)
128842 11364 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1351X Ingalls St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/05/1992 12:00:00 AM 45 3X3   6017270.42563 2093912.097264 37.730452470679005 -122.38258247713001 (37.730452470679, -122.38258247713)
142345 11985 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200X La Salle Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/05/1992 12:00:00 AM 12 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
115961 11336 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1279 Ingalls St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/04/1992 12:00:00 AM 6 3X3   6017412.9471167 2093950.7223454 37.7305663998171 -122.38209244081101 (37.7305663998171, -122.382092440811)
104 251210 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1170 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM                
109373 11264 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1176X Ingalls St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM 45 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
123755 11255 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1145X Ingalls St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM 80 3x4   6017856.860905 2093896.4273305 37.7304418229718 -122.380553976439 (37.7304418229718, -122.380553976439)
138783 11294 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1199X Ingalls St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM 20 3X3   6017612.0195749 2093925.7037957 37.730508696225705 -122.38140247160801 (37.7305086962257, -122.381402471608)
144239 11273 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1176X Ingalls St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/1992 12:00:00 AM 18 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
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)
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)
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)
14285 11226 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/29/1992 12:00:00 AM 35 3X4   6018091.97554 2094860.3210200001 37.7331014580651 -122.379808087687 (37.7331014580651, -122.379808087687)
14846 11225 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/29/1992 12:00:00 AM 35 3X4   6018100.6161400005 2094835.81488 37.733034645636394 -122.37977651247101 (37.7330346456364, -122.379776512471)
13889 11219 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1050X Ingalls St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/1992 12:00:00 AM 30 3X4   6018141.66576 2094727.81231 37.7327403559813 -122.379627091035 (37.7327403559813, -122.379627091035)
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)
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)
172347 32599 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1488 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/23/1996 12:00:00 AM 10   Permit Number 770751 5985602.7329 2105115.8853 37.7594147799348 -122.492885607985 (37.7594147799348, -122.492885607985)
157487 38868 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2439 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/2006 12:00:00 AM 7   Permit Number 40694 5987331.8721 2098675.8712 37.7418332004815 -122.486432648249 (37.7418332004815, -122.486432648249)
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)
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)
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)
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)
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)
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)
123872 38685 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1785 Fulton St 4 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)
139196 72854 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 24 Lunado Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/26/1998 12:00:00 AM       5991516.52955398 2091408.89207172 37.722122935753106 -122.47143422303499 (37.7221229357531, -122.471434223035)
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)
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)
178982 51993 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1260 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/29/2005 12:00:00 AM 14   Permit Number 48211 6007573.69475 2118185.59644 37.796561412322795 -122.417825488274 (37.7965614123228, -122.417825488274)
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)
105361 11992 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1200X La Salle Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/26/2016 12:00:00 AM 18 3X3   6017464.4799176 2094331.6246005 37.731615128467496 -122.381940767084 (37.7316151284675, -122.381940767084)
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)
151143 32218 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 531 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1995 12:00:00 AM 12   Permit Number 35539 6009507.28652 2100275.95799 37.7474943402867 -122.40986992446399 (37.7474943402867, -122.409869924464)
165058 32220 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 564 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1995 12:00:00 AM 13   Permit Number 35541 6009560.76026 2100252.78986 37.7474337224079 -122.409683379895 (37.7474337224079, -122.409683379895)
36064 73981 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1020 Post St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/20/1988 12:00:00 AM 22     6007232.56543 2114727.7662400003 37.7870478630276 -122.418760525075 (37.7870478630276, -122.418760525075)
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)
177926 68258 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 324 Holyoke St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM 13   Permit Number 32064 6009622.37802 2092856.7691 37.7271292968784 -122.408948556441 (37.7271292968784, -122.408948556441)
184713 66497 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2468 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 3 3x3 Permit Number 51581 6001708.326 2114654.8124 37.786534966555 -122.43786789884399 (37.786534966555, -122.437867898844)
153144 54678 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 425 Wheeler Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/1972 12:00:00 AM 10   Permit Number 10509 6011983.59997 2086741.2167599997 37.7104692111425 -122.40035642553002 (37.7104692111425, -122.40035642553)
175378 38350 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1666 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/31/1998 12:00:00 AM 0   Permit Number 40417 5981619.44120207 2103744.31851256 37.7554151050669 -122.506559824318 (37.7554151050669, -122.506559824318)
147701 34714 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 823 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 14   Permit Number 38369 5981667.161280001 2110126.53179 37.7729416344047 -122.506868172148 (37.7729416344047, -122.506868172148)
167098 43384 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 127 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2000 12:00:00 AM 16   Permit Number 43132 5993941.8721 2114666.09803 37.7861212585447 -122.464738521118 (37.7861212585447, -122.464738521118)
132134 66037 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2000 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1990 12:00:00 AM 11   Permit Number 29074 5986756.4233 2096936.5987 37.7370240595256 -122.488294548713 (37.7370240595256, -122.488294548713)
119632 45473 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1301 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM     Permit Number 44252 5993960.36650023 2094413.72258595 37.730514541433 -122.463204465727 (37.730514541433, -122.463204465727)
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)
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)
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)
118408 43517 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 165 Newman St 3 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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
19977 29369 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 9 Median : Cutout 11 Tree 1 DPW 2   07/06/2005 12:00:00 AM 3 3X3   6002638.340030001 2095276.9082799999 37.733380755998894 -122.43326512830099 (37.7333807559989, -122.433265128301)
21793 29370 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 500X Bosworth St 10 Median : Cutout 11 Tree 1 DPW 2   07/06/2005 12:00:00 AM 3 3X3   6002650.152480001 2095274.05972 37.733373604614 -122.433224085933 (37.733373604614, -122.433224085933)
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)
134985 49935 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2526 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/02/2003 12:00:00 AM 14   Permit Number 46695 5988329.1563 2098089.6264 37.7402816069206 -122.48294145156 (37.7402816069206, -122.48294145156)
138666 42670 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1575 Broadway 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM     Permit Number 42698 6006081.025120299 2117910.0746573997 37.7957207841663 -122.422970868865 (37.7957207841663, -122.422970868865)
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)
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)
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)
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)
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)
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)
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)
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)
117157 42476 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 50 Phelan Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM     Permit Number 42614 5997093.60501 2092371.5010099998 37.725087088302104 -122.452225158319 (37.7250870883021, -122.452225158319)
119378 42217 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 661 Howard St 6 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)
138113 37523 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1112 Larkin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/22/1998 12:00:00 AM 10   Permit Number 39974 6007334.6804 2115172.44683 37.7882745958345 -122.41843877194599 (37.7882745958345, -122.418438771946)
153704 37522 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1112 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/22/1998 12:00:00 AM 9   Permit Number 39974 6007335.91955 2115154.21819 37.7882246142201 -122.418433191643 (37.7882246142201, -122.418433191643)
111119 42127 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 57 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42423 5999631.06894657 2093753.11151717 37.729025705554704 -122.44355264659401 (37.7290257055547, -122.443552646594)
127455 42182 Permitted Site 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 715 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42466 6012416.63723338 2111137.79713862 37.77748115885579 -122.400572401541 (37.7774811588558, -122.400572401541)

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