408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by DBH

View and edit SQL

Police 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
349 253694 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 536 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005450 2111168 37.7771730951376 -122.424674483112 (37.7771730951376, -122.424674483112) 7 9 11 28852 10
1142 260393 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
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
7085 260395 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
9194 260391 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
10644 260392 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
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
13855 260394 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
14920 255508 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
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
21029 102504 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
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
35407 94294 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
37838 102503 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x9   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
39669 95554 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1333@ Larkin Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007121 2115358 37.7887720478953 -122.419191239667 (37.7887720478953, -122.419191239667) 13 9 10 28858 21
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
46032 121039 Undocumented 4 Ficus nitida :: Laurel Fig 53 2101 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118098 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697) 13 9 10 28858 32
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
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
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
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
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
61596 102505 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x7   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
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
66280 94296 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
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
72817 121043 Undocumented 4 Ficus nitida :: Laurel Fig 53 2125 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118096 37.7962471953974 -122.422008397548 (37.7962471953974, -122.422008397548) 13 9 10 28858 32
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
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
78831 99639 Undocumented 4 Ficus nitida :: Laurel Fig 53 2201 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
79513 47917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 999 Revised) Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2002 12:00:00 AM     Permit Number 45655 6006486.39229912 2113910.68802822 37.7847623267063 -122.421284078173 (37.7847623267063, -122.421284078173) 13 9 11 28858 41
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
86887 94302 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
87750 53929 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1700 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM   3x3 Permit Number 9642 6004487.99959123 2114676.46033991 37.786752078395 -122.428252455396 (37.786752078395, -122.428252455396) 13 9 11 28858 27
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
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
99392 94300 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park     6x6   6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
104082 105456 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003203 2116540 37.7917960919718 -122.432831424804 (37.7917960919718, -122.432831424804) 13 9 1 29490 27
105203 107284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2260 JACKSON ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6003354.3 2116979.4 37.7930111519645 -122.432339323402 (37.7930111519645, -122.432339323402) 13 9 1 29490 27
110239 94295 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
118707 94293 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
121115 94298 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
121324 98594 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 10141 6003182 2116842 37.79262411554 -122.432925669748 (37.79262411554, -122.432925669748) 13 9 1 29490 27
122270 95039 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 11 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
125851 253693 Undocumented 4 Ficus nitida :: Laurel Fig 53 536 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005450 2111168 37.7771730951376 -122.424674483112 (37.7771730951376, -122.424674483112) 7 9 11 28852 10
127089 108101 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 3 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
128624 117343 Undocumented 4 Ficus nitida :: Laurel Fig 53 372 HAYES ST 5 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6006019 2111114 37.7770569433878 -122.422702290381 (37.7770569433878, -122.422702290381) 7 9 11 28852 10
129349 95041 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 12 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
131050 110659 Undocumented 4 Ficus nitida :: Laurel Fig 53 2393 FILBERT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001559 2118656 37.7975126970015 -122.438671337949 (37.7975126970015, -122.438671337949) 13 9 1 57 17
134290 94304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
141424 95044 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 6 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
147353 52716 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
155737 117286 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3500 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6002513 2120207 37.8018255621759 -122.435481260672 (37.8018255621759, -122.435481260672) 13 9 1 57 17
156157 59335 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1980 12:00:00 AM   4x4 Permit Number 18682 6003287.79827449 2108952.35112135 37.7709671172915 -122.431995967048 (37.7709671172915, -122.431995967048) 15 9 11 29492 9
156467 109326 Undocumented 4 Ficus nitida :: Laurel Fig 53 1624 VALLEJO ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005582.1 2118270.7 37.7966828044962 -122.424722909098 (37.7966828044962, -122.424722909098) 13 9 1 57 17
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
162297 108098 Undocumented 4 Ficus nitida :: Laurel Fig 53 2800X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999639 2117762 37.7949485989127 -122.445250712888 (37.7949485989127, -122.445250712888) 13 9 1 57 17
163074 110027 Undocumented 4 Ficus nitida :: Laurel Fig 53 1101X WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6003707 2112516 37.7807757743573 -122.430800292528 (37.7807757743573, -122.430800292528) 15 9 11 29490 41
169402 50375 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 5 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
170574 114952 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X OCTAVIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
172169 117345 Undocumented 4 Ficus nitida :: Laurel Fig 53 395 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006014 2111158 37.7771774746178 -122.422722714586 (37.7771774746178, -122.422722714586) 7 9 11 28852 10
177482 255340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1           6003626.50122 2114526.01983 37.7862902235864 -122.431222292272 (37.7862902235864, -122.431222292272) 13 9 11 29490 13
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
183408 50980 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Richardson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2004 12:00:00 AM   3x3 Permit Number 47465 5999116.7 2119758.3 37.8004000774175 -122.447201682136 (37.8004000774175, -122.447201682136) 13 9 1 57 17
184329 173906 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2510 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1           6005854.79213 2118988.36383 37.7986687249765 -122.423830387644 (37.7986687249765, -122.423830387644) 13 9 1 28858 32
184672 113275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2147 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002730.25600058 2118492.02135193 37.7971290147198 -122.43460675571 (37.7971290147198, -122.43460675571) 13 9 1 57 17
186252 116029 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
186717 107211 Undocumented 4 Ficus nitida :: Laurel Fig 53 2255 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6003966.3 2116269.9 37.7910977281266 -122.430171131086 (37.7910977281266, -122.430171131086) 13 9 1 29490 27
190125 52718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
192777 48866 Permitted Site 7 Ficus nitida :: Laurel Fig 53 129 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2002 12:00:00 AM     Permit Number 46075 6006370.62112219 2110394.65908683 37.7751016387897 -122.421434823029 (37.7751016387897, -122.421434823029) 7 9 11 28852 10
193625 255507 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
193965 108150 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
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
142881 95042 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 2 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     11 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
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
2956 139431 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005398.6042 2111220.8061 37.7773151849796 -122.424856035409 (37.7773151849796, -122.424856035409) 7 9 11 28852 10
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
7742 21626 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1610 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004833.69671 2114745.44523 37.7869610478907 -122.427061339905 (37.7869610478907, -122.427061339905) 13 9 11 28858 27
11809 7237 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1065 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003359.4574 2111944.18191 37.7791860077197 -122.431961766737 (37.7791860077197, -122.431961766737) 15 9 11 29490 41
15312 59957 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1981 12:00:00 AM 12   Permit Number 19434 6005396.005 2111241.6 37.7773721331465 -122.424866506623 (37.7773721331465, -122.424866506623) 7 9 11 28852 10
18607 139432 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005403.0601 2111196.299 37.77724814614 -122.424838877048 (37.77724814614, -122.424838877048) 7 9 11 28852 10
20638 21644 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1657 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004676.7022509 2114666.9735246 37.7867367053745 -122.427598912468 (37.7867367053745, -122.427598912468) 13 9 11 28858 13
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
21570 7202 Permitted Site 7 Ficus nitida :: Laurel Fig 53 926 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003476.58431 2111463.23602 37.7778720892035 -122.431522232661 (37.7778720892035, -122.431522232661) 15 9 11 29492 41
24683 16945 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 602 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004026.09211 2110141.24132 37.7742733469863 -122.429526989132 (37.7742733469863, -122.429526989132) 7 9 11 29492 10
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
29416 7261 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1727 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003024.60166 2114236.6744 37.7854616266825 -122.433284024643 (37.7854616266825, -122.433284024643) 13 9 11 29490 13
35689 7151 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 708 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003574.54383 2110759.08622 37.775944219835 -122.431133084506 (37.775944219835, -122.431133084506) 7 9 11 29492 10
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
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
41963 21634 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1629 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004806.293908 2114684.9896753 37.786793502462 -122.427151839633 (37.786793502462, -122.427151839633) 13 9 11 28858 13
43740 9577 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 5x5   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
43983 10710 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003901.15311 2113362.61867 37.7831113762968 -122.430189039187 (37.7831113762968, -122.430189039187) 7 9 11 29490 41
46932 17830 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1961 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004561.39396 2115345.0767756 37.7885920838825 -122.428046192771 (37.7885920838825, -122.428046192771) 13 9 11 28858 27
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

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