186 rows where Supervisor Districts = 5 and qSpecies_id = 53 sorted by Zip Codes

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)
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
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
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
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
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
132426 95220 Undocumented 4 Ficus nitida :: Laurel Fig 53 3208 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005461 2106663 37.7648040703693 -122.424315938973 (37.7648040703693, -122.424315938973) 8 4 5 28853 19
143541 28384 Permitted Site 7 Ficus nitida :: Laurel Fig 53 286 Valencia St 2 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
177897 100470 Undocumented 4 Ficus nitida :: Laurel Fig 53 5X Pearl St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6005567.3 2108720.4 37.7704592014806 -122.424094599295 (37.7704592014806, -122.424094599295) 8 2 5 28853 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
115099 110727 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
120502 57735 Permitted Site 7 Ficus nitida :: Laurel Fig 53 364 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/1993 12:00:00 AM 16   Permit Number 31982 6005454.9599493 2101588.78174199 37.7508711140338 -122.423975967283 (37.7508711140338, -122.423975967283) 2 4 5 28859 19
123770 5390 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 330X Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6004823.7091277 2106419.4754114 37.7640994035261 -122.426502823086 (37.7640994035261, -122.426502823086) 8 4 5 28859 3
123934 110723 Undocumented 4 Ficus nitida :: Laurel Fig 53 3514 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006378 2101471 37.7505997812246 -122.420775642469 (37.7505997812246, -122.420775642469) 2 4 5 28859 19
125549 110733 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
127066 96913 Undocumented 4 Ficus nitida :: Laurel Fig 53 65X Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005919.1 2102263.8 37.7527507518094 -122.422418882903 (37.7527507518094, -122.422418882903) 2 4 5 28859 19
139295 59013 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3755 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1980 12:00:00 AM 20   Permit Number 18304 6005291.98683548 2104267.80164023 37.7582178764875 -122.424730106513 (37.7582178764875, -122.424730106513) 2 4 5 28859 19
141296 15649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3718 Mission St 1 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
144703 220211 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1399 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 7ft   6005241 2100194 37.747029282671 -122.424616654405 (37.747029282671, -122.424616654405) 2 7 5 28859 22
150324 702 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1399X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005246.2674799 2100192.367786 37.74702509847 -122.424598323807 (37.74702509847, -122.424598323807) 2 7 5 28859 22
155548 115216 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 3x3   6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 28859 19
161145 706 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1509X Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6005302.49516 2099477.85942 37.7450663972586 -122.424353081707 (37.7450663972586, -122.424353081707) 2 7 5 28859 22
162339 10147 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 940 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 2x3   6005660.7422371 2103489.3240903 37.7561011788947 -122.423399446987 (37.7561011788947, -122.423399446987) 2 4 5 28859 19
165318 93031 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 5.5x9   6005231 2106625 37.7646867413409 -122.425108746155 (37.7646867413409, -122.425108746155) 8 4 5 28859 19
168783 96335 Undocumented 4 Ficus nitida :: Laurel Fig 53 3705 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 28622 6005781 2101380 37.7503162492489 -122.422833652647 (37.7503162492489, -122.422833652647) 2 4 5 28859 19
171840 69122 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3744 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/1994 12:00:00 AM 22 5x9 Permit Number 33140 6005352.36529805 2104323.23161765 37.7583734841408 -122.424525234112 (37.7583734841408, -122.424525234112) 2 4 5 28859 19
173374 98862 Undocumented 4 Ficus nitida :: Laurel Fig 53 25 OAKWOOD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005344.6 2105317.5 37.7611030726424 -122.424622816907 (37.7611030726424, -122.424622816907) 2 4 5 28859 19
177096 51793 Permitted Site 7 Ficus nitida :: Laurel Fig 53 65 Oakwood St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2005 12:00:00 AM     Permit Number 48042 6005279.64463313 2105087.60921781 37.7604681781651 -122.42483111417 (37.7604681781651, -122.42483111417) 2 4 5 28859 19
188704 57306 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3265 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1992 12:00:00 AM   5.5x9 Permit Number 30983 6005094.29272651 2106604.42467206 37.7646225228273 -122.425580116407 (37.7646225228273, -122.425580116407) 8 4 5 28859 19
190351 110732 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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)
);