194 rows where Supervisor Districts = 1 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)
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
3559 55849 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2801X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/13/2003 12:00:00 AM     Permit Number 46336 6001333.31634171 2116022.21010841 37.7902681559585 -122.439263383199 (37.7902681559585, -122.439263383199) 13 6 1 29490 27
3916 261241 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 840 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2020 12:00:00 AM 3 Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
4658 46466 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3310X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2002 12:00:00 AM 12 3x3 Permit Number 44668 6002328.64862435 2119517.88465055 37.7999229605029 -122.436069860968 (37.7999229605029, -122.436069860968) 13 9 1 57 17
6921 95036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
11093 95037 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3224 Pierce St 8 Sidewalk: Property side : Cutout Tree Dept of Real Estate 7     10 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
11207 108105 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
11487 260838 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 1 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
11744 56147 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2311 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/1973 12:00:00 AM 16   Permit Number 12254 6001277.58181 2116437.20889 37.7914044631939 -122.439485981699 (37.7914044631939, -122.439485981699) 13 6 1 29490 27
11986 95043 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 4 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     9 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
12511 260840 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 3 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
13236 92386 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2810 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2015 12:00:00 AM 3 4x4 Permit Number 774470 6001269 2116290 37.7909997773984 -122.439505117215 (37.7909997773984, -122.439505117215) 13 6 1 29490 27
14328 104230 Undocumented 4 Ficus nitida :: Laurel Fig 53 409 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2       14x8   5998587.6 2115205.6 37.787869332154 -122.448704479556 (37.787869332154, -122.448704479556) 13 6 1 54 31
15062 102786 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3345 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4.5x6 Permit Number 772480 6003174.4 2119873.2 37.8009465759098 -122.433168646536 (37.8009465759098, -122.433168646536) 13 9 1 57 17
16842 261242 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 840 El Camino Del Mar 2 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2020 12:00:00 AM 3 Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
16922 59787 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1755 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1981 12:00:00 AM     Permit Number 19237 6004552.42886001 2119092.68520918 37.7988815571833 -122.428344419585 (37.7988815571833, -122.428344419585) 13 9 1 57 17
20994 100049 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 768990 6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
21498 98979 Undocumented 4 Ficus nitida :: Laurel Fig 53 38 MILEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778225 5999656 2118689 37.7974948649915 -122.4452585722 (37.7974948649915, -122.4452585722) 13 9 1 57 17
22585 23704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2119X Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6005103.6033 2116867.23334 37.7928022043515 -122.426278644375 (37.7928022043515, -122.426278644375) 13 9 1 28858 27
23488 1442 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 144 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   5995540.31731 2115189.6989 37.7876509503315 -122.459246293031 (37.7876509503315, -122.459246293031) 11 6 1 54 31
26003 20242 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801X Steiner St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27
28409 23540 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005743.06666 2119831.60651 37.8009777467475 -122.424276999326 (37.8009777467475, -122.424276999326) 13 9 1 28858 32
28739 11129 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2140 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6007198.4118085 2119638.2581616 37.8005289300711 -122.419227150729 (37.8005289300711, -122.419227150729) 5 1 1 28858 32
29680 65045 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1066 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM     Permit Number 45972 6007827.74406772 2119607.84984942 37.8004808586212 -122.417047244449 (37.8004808586212, -122.417047244449) 5 1 1 308 32
29776 44063 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
31137 4747 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1199X Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     22 3X4   6007816.30894 2121179.41413 37.8047953349468 -122.417198239329 (37.8047953349468, -122.417198239329) 5 1 1 308 32
34974 253521 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2626 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6006643 2120264 37.8022157634914 -122.42119356192 (37.8022157634914, -122.42119356192) 5 1 1 28858 32
36964 11109 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2022 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6007225.09879 2119363.63368 37.7997763833106 -122.419115312272 (37.7997763833106, -122.419115312272) 5 1 1 28858 32
37162 18698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 5 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
37406 18007 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700X Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x4   6001006.5406952 2114902.0443839 37.7871738702805 -122.440313633737 (37.7871738702805, -122.440313633737) 13 6 1 29490 27
38327 17368 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2308X Gough St 5 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005067.32521 2117488.78546 37.794506778582 -122.426448444628 (37.794506778582, -122.426448444628) 13 9 1 28858 27
38373 52226 Permitted Site 7 Ficus nitida :: Laurel Fig 53 423 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2005 12:00:00 AM     Permit Number 48405 5997634.34727934 2115023.86499621 37.7873157808513 -122.451989424725 (37.7873157808513, -122.451989424725) 11 6 1 54 31
38651 113775 Undocumented 4 Ficus nitida :: Laurel Fig 53 1712 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6000121 2114885 37.7870766118482 -122.443376178084 (37.7870766118482, -122.443376178084) 13 6 1 29490 27
38667 21584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1499 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005574.52113 2114792.70084 37.787132663766 -122.424501615425 (37.787132663766, -122.424501615425) 13 9 1 28858 41
39309 61493 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3149 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1984 12:00:00 AM     Permit Number 777095 5999649.96958977 2116015.59113069 37.7901540469754 -122.445087143888 (37.7901540469754, -122.445087143888) 13 6 1 29490 27
39319 23703 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2119X Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005103.6033 2116867.23334 37.7928022043515 -122.426278644375 (37.7928022043515, -122.426278644375) 13 9 1 28858 27
39370 107630 Undocumented 4 Ficus nitida :: Laurel Fig 53 2164 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001495 2119755 37.8005266206576 -122.438971595662 (37.8005266206576, -122.438971595662) 13 9 1 57 17
40606 18940 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2770 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6001564.88968 2115697.48907 37.7893897308811 -122.438438883241 (37.7893897308811, -122.438438883241) 13 6 1 29490 27
41017 11117 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2054 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6007235.1189832 2119374.3616564 37.7998064039059 -122.419081399975 (37.7998064039059, -122.419081399975) 5 1 1 28858 32
41634 13254 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2408 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1993 12:00:00 AM 45 3X3   6000832.23006 2119380.36917 37.7994602521243 -122.441238147567 (37.7994602521243, -122.441238147567) 13 9 1 57 17
43653 95034 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
45310 11177 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
47028 110967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2439 WASHINGTON ST   Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003043 2116458 37.7915618650441 -122.433379161821 (37.7915618650441, -122.433379161821) 13 9 1 29490 27
48110 108103 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 5 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
48350 111430 Undocumented 4 Ficus nitida :: Laurel Fig 53 500X PRESIDIO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999200 2114887 37.7870295394193 -122.446562765799 (37.7870295394193, -122.446562765799) 15 6 1 29490 31
49311 8762 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3360 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638) 11 6 1 54 31
49412 94931 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1771 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6004522 2118744 37.7979224352085 -122.428424847305 (37.7979224352085, -122.428424847305) 13 9 1 57 17
50801 95033 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
50810 20244 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1801X Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27
50984 95035 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
51742 11446 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2191X Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005072.64937 2117089.85961 37.7934117301419 -122.426401604865 (37.7934117301419, -122.426401604865) 13 9 1 28858 27
52557 106525 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 5 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
53504 11175 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
55002 13200 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
55261 11108 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2022 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007226.47271 2119353.11491 37.799747578786 -122.419109811467 (37.799747578786, -122.419109811467) 5 1 1 28858 32
55528 23492 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2510 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005839.2618 2119053.89467 37.7988477792821 -122.423888789861 (37.7988477792821, -122.423888789861) 13 9 1 28858 32
56427 44064 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
57729 16813 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2097X O'Farrell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5999009.37837 2112716.355 37.7810586242256 -122.447066002739 (37.7810586242256, -122.447066002739) 15 5 1 54 16
57812 13193 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2095 Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002451.4681 2119463.3271 37.7997801365268 -122.435640954547 (37.7997801365268, -122.435640954547) 13 9 1 57 17
58920 11130 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2140 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6007198.4118085 2119638.2581616 37.8005289300711 -122.419227150729 (37.8005289300711, -122.419227150729) 5 1 1 28858 32
59694 127215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 4 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999937.99418 2117121.61309 37.7932073277938 -122.44417011406 (37.7932073277938, -122.44417011406) 13 9 1 57 27
60447 20241 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801X Steiner St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27
60795 94982 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002562.1 2117394.1 37.7941048599095 -122.435110049481 (37.7941048599095, -122.435110049481) 13 9 1 29490 27
62202 23539 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     23 3x3   6005738.98285 2119846.6704 37.8010188777475 -122.424292203059 (37.8010188777475, -122.424292203059) 13 9 1 28858 32
62457 96407 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2           5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
63529 56688 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6002930 2119911 37.801036497901 -122.434017077007 (37.801036497901, -122.434017077007) 13 9 1 57 17
63549 18006 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2700X Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6001006.5406952 2114902.0443839 37.7871738702805 -122.440313633737 (37.7871738702805, -122.440313633737) 13 6 1 29490 27
65216 23529 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 18 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005762.85494 2119704.71005 37.8006304387912 -122.42419949344 (37.8006304387912, -122.42419949344) 13 9 1 28858 32
65259 105658 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
65947 103484 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 9x6   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
66108 92850 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3150 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4 Permit Number 53071 5999589 2116381 37.7911538835614 -122.445324377175 (37.7911538835614, -122.445324377175) 13 6 1 29490 27
66213 50374 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
67334 99615 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
69533 8763 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3360 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638) 11 6 1 54 31
70447 44061 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
70974 23955 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1985X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6002890.93346 2119517.51166 37.7999538645084 -122.434124118866 (37.7999538645084, -122.434124118866) 13 9 1 57 17
72126 106522 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 2 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
73128 63094 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2780 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1986 12:00:00 AM   3x3 Permit Number 23579 6001505.6405737 2115674.07424093 37.789322069479 -122.438642199545 (37.789322069479, -122.438642199545) 13 6 1 29490 27
75083 46223 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1888 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2002 12:00:00 AM     Permit Number 44530 6003335.27744655 2119677.01043482 37.8004170150887 -122.432597920925 (37.8004170150887, -122.432597920925) 13 9 1 57 17
75386 23542 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6005753.45253 2119744.59142 37.8007394119615 -122.424234867659 (37.8007394119615, -122.424234867659) 13 9 1 28858 32
76207 127218 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 7 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999923.49955 2117118.25276 37.7931972742965 -122.44422002466 (37.7931972742965, -122.44422002466) 13 9 1 57 27
77560 95038 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
77688 1668 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2679X LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   5999625 2119128 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769) 13 9 1 57 17
77847 13285 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2576 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1993 12:00:00 AM 3 3X3   6000068.81033 2119230.46658 37.799005143246 -122.443869066799 (37.799005143246, -122.443869066799) 13 9 1 57 17
77904 56931 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1909 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 17   Permit Number 14175 6004317.92538 2118019.69798 37.795922137343 -122.429079333669 (37.795922137343, -122.429079333669) 13 9 1 28858 27
77923 256355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
79887 16728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1519 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   5999136.4110982 2112734.4359693 37.7811155269813 -122.446627836224 (37.7811155269813, -122.446627836224) 15 5 1 54 16
80144 96411 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2012 12:00:00 AM     Permit Number 768662 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
82597 21583 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1499 Sutter St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005557.61202 2114792.21407 37.7871303723087 -122.424560082666 (37.7871303723087, -122.424560082666) 13 9 1 28858 41
83449 106526 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 6 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
84337 9917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1905X Gough St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3x3 Permit Number 768908 6005198.9827241 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562) 13 9 1 28858 27
84820 98591 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2375 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 9808 6002830 2116793 37.7924696026791 -122.434140096981 (37.7924696026791, -122.434140096981) 13 9 1 29490 27
85440 96410 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767718 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
85651 100050 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
87780 95040 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 13 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
90065 13211 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2190 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6001897.52108 2119466.22991 37.7997566277665 -122.437558020868 (37.7997566277665, -122.437558020868) 13 9 1 57 17
90875 110969 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2475 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6002881.27515757 2116466.21692287 37.7915752502174 -122.433939314763 (37.7915752502174, -122.433939314763) 13 9 1 29490 27
90878 106915 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3832 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772728 5995876.04542 2115884.62189 37.7895783172049 -122.458135060161 (37.7895783172049, -122.458135060161) 11 6 1 54 31

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