186 rows where Supervisor Districts = 5 and qSpecies_id = 53

View and edit SQL

Supervisor Districts

rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
4294 117126 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 4 5 28862 3
7359 121255 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
8384 104821 Undocumented 4 Ficus nitida :: Laurel Fig 53 2173 15TH ST   Sidewalk: Curb side : Cutout Tree Private 2     20     6003063.7 2107068.1 37.7657807169148 -122.432636512343 (37.7657807169148, -122.432636512343) 15 5 5 28862 3
8959 113224 Undocumented 4 Ficus nitida :: Laurel Fig 53 4244 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001623 2102374 37.7528100494278 -122.437283434624 (37.7528100494278, -122.437283434624) 2 4 5 28862 22
10358 120965 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
11498 115743 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 1 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
13077 34262 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3618 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1997 12:00:00 AM 14 3x3 Permit Number 38067 6002793.22003166 2106527.80070587 37.7642818435653 -122.433533428216 (37.7642818435653, -122.433533428216) 15 5 5 28862 3
17055 104825 Undocumented 4 Ficus nitida :: Laurel Fig 53 45 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003350 2106266 37.7635945765505 -122.431588992909 (37.7635945765505, -122.431588992909) 15 4 5 28862 3
19867 48735 Permitted Site 7 Ficus nitida :: Laurel Fig 53 36 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/1969 12:00:00 AM     Permit Number 46015 6001979.18448022 2107865.24554965 37.7679079189757 -122.436444672891 (37.7679079189757, -122.436444672891) 15 5 5 29492 3
20606 15650 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3718 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6005292.79028 2096596.92241 37.7371554485093 -122.42418178869 (37.7371554485093, -122.42418178869) 2 7 5 28859 2
20709 109328 Undocumented 4 Ficus nitida :: Laurel Fig 53 1349 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2015 12:00:00 AM 3 3x3   5999000.5 2104870.1 37.7595142924854 -122.446532051538 (37.7595142924854, -122.446532051538) 15 5 5 28862 12
24098 50784 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4425@ EUREKA 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2004 12:00:00 AM     Permit Number 47310 6001319.3692016 2105218.84665198 37.760604043869 -122.438537258087 (37.760604043869, -122.438537258087) 2 4 5 28862 3
24151 96336 Undocumented 4 Ficus nitida :: Laurel Fig 53 1851 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005204.9 2107156.8 37.7661454629436 -122.42523686393 (37.7661454629436, -122.42523686393) 8 4 5 28853 19
24756 55741 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2289 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/1973 12:00:00 AM 13 3x3 Permit Number 11768 6002326.09413197 2107044.17123182 37.7656731563843 -122.435186018715 (37.7656731563843, -122.435186018715) 15 5 5 28862 3
27436 107660 Undocumented 4 Ficus nitida :: Laurel Fig 53 1316 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999083.9 2105040.7 37.7599874810533 -122.446255886285 (37.7599874810533, -122.446255886285) 15 5 5 28862 3
27757 16589 Permitted Site 7 Ficus nitida :: Laurel Fig 53 17 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4X4PL   6002850.124051 2108197.2585517 37.768868996076 -122.433455924251 (37.768868996076, -122.433455924251) 15 5 5 28862 3
28234 109001 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
29857 57300 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3178 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM 14 3x3 Permit Number 16122 6005671.4432239 2106688.52693537 37.7648860421109 -122.423589884437 (37.7648860421109, -122.423589884437) 8 4 5 28853 19
32408 54027 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2016 12:00:00 AM 3 6x6 Permit Number 778679 6004696.3346429 2103995.33974478 37.7574361004301 -122.426770728763 (37.7574361004301, -122.426770728763) 2 4 5 28862 3
32730 5389 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004827.24095 2106401.30238 37.7640497043733 -122.426489313449 (37.7640497043733, -122.426489313449) 8 4 5 28859 3
35179 95222 Undocumented 4 Ficus nitida :: Laurel Fig 53 299 on 16th St Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
38445 4501 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1748 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6004612.9512322 2098708.9638206 37.74291622476 -122.4266826598 (37.74291622476, -122.4266826598) 2 7 5 63 22
40868 173774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2239 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002625 2107043 37.7656869095489 -122.434152085943 (37.7656869095489, -122.434152085943) 15 5 5 28862 3
43227 110731 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
43367 116602 Undocumented 4 Ficus nitida :: Laurel Fig 53 3260x 16TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 9x9   6005124 2106632 37.764699916645 -122.425479329399 (37.764699916645, -122.425479329399) 8 4 5 28859 19
43513 120964 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
43818 24454 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
43985 111817 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 ORD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6000817 2105938 37.7625500726099 -122.440326296311 (37.7625500726099, -122.440326296311) 15 5 5 28862 3
44100 115215 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 9x5 Permit Number 779049 6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 28859 19
44231 57108 Permitted Site 7 Ficus nitida :: Laurel Fig 53 280 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 24 6x6 Permit Number 14378 6004748.38429029 2102046.50032189 37.7520879863161 -122.426451960244 (37.7520879863161, -122.426451960244) 2 4 5 28862 22
44509 60715 Permitted Site 7 Ficus nitida :: Laurel Fig 53 30 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/1983 12:00:00 AM 24 3x3 Permit Number 20368 6005215.9296478 2105282.4178358 37.7609994776864 -122.425065336381 (37.7609994776864, -122.425065336381) 2 4 5 28859 19
48272 95217 Undocumented 4 Ficus nitida :: Laurel Fig 53 135 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005910 2106464 37.7642830068396 -122.422748818687 (37.7642830068396, -122.422748818687) 8 4 5 28859 19
51694 173776 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 89 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001439 2105287 37.7607979807122 -122.438128392537 (37.7607979807122, -122.438128392537) 15 4 5 28862 3
51820 12942 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 725X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     16 6   6005046.7981655 2104134.69405 37.7578385432445 -122.425568603003 (37.7578385432445, -122.425568603003) 2 4 5 28859 19
53386 55163 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1328 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/1993 12:00:00 AM     Permit Number 31912 6002514.24849197 2101716.89965545 37.751056432833 -122.434154367056 (37.751056432833, -122.434154367056) 2 4 5 28862 22
53498 24453 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
54160 110730 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
56472 96337 Undocumented 4 Ficus nitida :: Laurel Fig 53 1851 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005204.9 2107156.8 37.7661454629436 -122.42523686393 (37.7661454629436, -122.42523686393) 8 4 5 28853 19
57759 4493 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1616 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004570.9658455 2099475.4807252 37.7450185306318 -122.426882412261 (37.7450185306318, -122.426882412261) 2 7 5 63 22
57818 111388 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
58653 24451 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
58860 111391 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
59221 48449 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1971 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2002 12:00:00 AM     Permit Number 45821 6004348.70626507 2107156.39257844 37.7660959373339 -122.428198241647 (37.7660959373339, -122.428198241647) 8 4 5 28862 3
60087 86905 Permitted Site 7 Ficus nitida :: Laurel Fig 53 36 Camp St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2007 12:00:00 AM   3x3 Permit Number 49869 6005775 2106383 37.7640529822515 -122.423209987967 (37.7640529822515, -122.423209987967) 8 4 5 28859 19
60853 97999 Undocumented 4 Ficus nitida :: Laurel Fig 53 30 Eagle St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
61113 57802 Permitted Site 7 Ficus nitida :: Laurel Fig 53 107 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/1988 12:00:00 AM 8 3x3 Permit Number 25561 6000622.33928566 2102551.03510935 37.7532392091702 -122.440756591601 (37.7532392091702, -122.440756591601) 2 4 5 28862 22
61233 28383 Permitted Site 7 Ficus nitida :: Laurel Fig 53 286 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6006047.68288 2107930.23885 37.7683167183705 -122.422376798825 (37.7683167183705, -122.422376798825) 8 4 5 28853 19
61535 5622 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1202 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     28 3X3   6005101.96034 2101291.72603 37.7500355321086 -122.425175538874 (37.7500355321086, -122.425175538874) 2 4 5 28862 22
61784 59066 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1658 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1980 12:00:00 AM     Permit Number 18361 6003975.177671 2098610.37486855 37.7426094440159 -122.428880876877 (37.7426094440159, -122.428880876877) 2 7 5 63 22
62161 109596 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3332 21ST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6006085.3 2103802.1 37.7569839418566 -122.421953398845 (37.7569839418566, -122.421953398845) 2 4 5 28859 19
62309 111394 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
63433 4418 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1128 Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004420.05713 2102283.99445 37.752721523998 -122.427604283815 (37.752721523998, -122.427604283815) 2 4 5 28862 22
64331 5481 Permitted Site 7 Ficus nitida :: Laurel Fig 53 700X Dolores St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     80 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166) 2 4 5 28862 3
65899 109000 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     6 2x2 circle   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
66076 112051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3748x 22ND ST 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6003448 2103060 37.7547972209553 -122.431021210073 (37.7547972209553, -122.431021210073) 2 4 5 28862 22
66858 173948 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1300 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999106 2105162 37.7603218028196 -122.446188178838 (37.7603218028196, -122.446188178838) 15 5 5 28862 3
69799 59060 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4437 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1992 12:00:00 AM 14 2x2 Permit Number 30882 6000423.21385776 2102243.23045707 37.7523827100743 -122.441423120737 (37.7523827100743, -122.441423120737) 2 4 5 28862 22
72643 24452 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
72782 58078 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4624 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM     Permit Number 17049 6000401 2105218 37.7605494356876 -122.441713410467 (37.7605494356876, -122.441713410467) 15 4 5 28862 3
73104 5386 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 325X Dolores St 4 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
74570 102020 Undocumented 4 Ficus nitida :: Laurel Fig 53 4149X 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6001459 2105817 37.7622543686513 -122.438097188092 (37.7622543686513, -122.438097188092) 15 5 5 28862 3
75176 173949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1306 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999102 2105133 37.7602419475954 -122.446199926833 (37.7602419475954, -122.446199926833) 15 5 5 28862 3
78708 120673 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3876 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780.8 2105549.3 37.761651098806 -122.430047862208 (37.761651098806, -122.430047862208) 8 4 5 28862 3
79391 96083 Undocumented 4 Ficus nitida :: Laurel Fig 53 2177 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003180 2107100 37.7658749013738 -122.432236534109 (37.7658749013738, -122.432236534109) 15 5 5 28862 3
80642 55728 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2158 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 15 4x4 Permit Number 11754 6003183.89247133 2107143.93253238 37.7659957501376 -122.432226208659 (37.7659957501376, -122.432226208659) 15 5 5 28862 3
81702 93042 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110X Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6000798.7 2105708.1 37.7619177818182 -122.440373100603 (37.7619177818182, -122.440373100603) 15 5 5 28862 3
81846 61476 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1942 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/1984 12:00:00 AM 20 4x3 Permit Number 21419 6004543.5 2107230.3 37.7663098890238 -122.427529754413 (37.7663098890238, -122.427529754413) 8 4 5 28862 3
82935 39773 Permitted Site 7 Ficus nitida :: Laurel Fig 53 112 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/29/2001 12:00:00 AM 14 6x6 Permit Number 41140 6005154.17276637 2099634.09116827 37.7454869972987 -122.424877067697 (37.7454869972987, -122.424877067697) 2 7 5 63 22
83519 57298 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3120 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM 20 5x5 Permit Number 16120 6006015.66145192 2106707.62529636 37.7649579052871 -122.422400676647 (37.7649579052871, -122.422400676647) 8 4 5 28853 19
84466 64020 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2344 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1987 12:00:00 AM     Permit Number 778144 6002015 2107091 37.7657840660528 -122.436265375372 (37.7657840660528, -122.436265375372) 15 5 5 28862 3
85172 98001 Undocumented 4 Ficus nitida :: Laurel Fig 53 30 Eagle St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6000135 2104379 37.7582305885461 -122.442573139957 (37.7582305885461, -122.442573139957) 2 4 5 28862 3
87381 5388 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004825.95108 2106424.13775 37.7641123319355 -122.426495400824 (37.7641123319355, -122.426495400824) 8 4 5 28859 3
87589 121254 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
89944 108971 Undocumented 4 Ficus nitida :: Laurel Fig 53 20x ROUSSEAU ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003466 2095297.3 37.7334836652593 -122.430405132046 (37.7334836652593, -122.430405132046) 2 7 5 28861 25
93022 5387 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 325X Dolores St 5 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
93614 109925 Undocumented 4 Ficus nitida :: Laurel Fig 53 375 FAIR OAKS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6005525.2 2101540.6 37.7507427833765 -122.423729644924 (37.7507427833765, -122.423729644924) 2 4 5 28859 19
93776 110724 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
93895 173772 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2235 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002649 2107045 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237) 15 5 5 28862 3
94921 109333 Undocumented 4 Ficus nitida :: Laurel Fig 53 1317 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   5999055 2105304 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866) 15 5 5 28862 12
95408 110726 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
95901 110725 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
95956 58140 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2168 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/08/1978 12:00:00 AM 16 3x3 Permit Number 17124 6003092.5 2107149.8 37.7660066784939 -122.432542735552 (37.7660066784939, -122.432542735552) 15 5 5 28862 3
97800 115748 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 6 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
99259 111393 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
100751 116905 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 Beaver St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002383 2106795 37.7649922243231 -122.434971372236 (37.7649922243231, -122.434971372236) 15 5 5 28862 3
102319 61449 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330-1332 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/1984 12:00:00 AM     Permit Number 21384 6002514.93546023 2101705.58374617 37.7510254010171 -122.434151182595 (37.7510254010171, -122.434151182595) 2 4 5 28862 22
103473 55732 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2229 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM 20   Permit Number 11758 6002695.31984114 2107064.65711257 37.7657503654861 -122.433910413324 (37.7657503654861, -122.433910413324) 15 5 5 28862 3
103514 4559 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1250X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 10x6   6005144.0595933 2101075.0968609 37.7494430966122 -122.425014546007 (37.7494430966122, -122.425014546007) 2 4 5 28862 22
103761 121256 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
106391 115747 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 5 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   16 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
107111 44172 Permitted Site 7 Ficus nitida :: Laurel Fig 53 59 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2000 12:00:00 AM     Permit Number 43639 6003760.97911216 2095401.48581894 37.733786440894 -122.429392732684 (37.733786440894, -122.429392732684) 2 7 5 28861 25
107245 58071 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4545 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/1977 12:00:00 AM 13   Permit Number 17041 6000791.5456109 2105188.83821507 37.7604916091053 -122.440360603481 (37.7604916091053, -122.440360603481) 2 4 5 28862 3
107985 115744 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 2 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
111149 53710 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4067 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/1970 12:00:00 AM 14   Permit Number 6657 6002578.30950532 2104703.42856113 37.7592603634983 -122.434146313573 (37.7592603634983, -122.434146313573) 2 4 5 28862 3
112309 115745 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 3 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   20 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
112589 115746 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 4 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   28 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
112940 106936 Undocumented 4 Ficus nitida :: Laurel Fig 53 98X EUREKA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 6x5   6001388 2105433 37.7611959604452 -122.438315238354 (37.7611959604452, -122.438315238354) 15 4 5 28862 3
113469 117124 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 4 5 28862 3
114066 54117 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4356 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1972 12:00:00 AM   3x3 Permit Number 52105 6001531.81835159 2105282.89107801 37.7607919769606 -122.437807081492 (37.7607919769606, -122.437807081492) 15 4 5 28862 3
114328 50197 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3279@ DOLORES 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/2003 12:00:00 AM     Permit Number 46903 6005006.02996154 2106599.52754391 37.7646040888867 -122.425885045341 (37.7646040888867, -122.425885045341) 8 4 5 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);