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

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)
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
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
187091 100051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
179011 100052 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
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
147848 101072 Undocumented 4 Ficus nitida :: Laurel Fig 53 1828 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004239 2118751 37.7979256371892 -122.429404607028 (37.7979256371892, -122.429404607028) 13 9 1 57 17
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
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
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
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
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
188563 10618 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 350 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
83704 10626 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 414 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005955 2111106 37.7770313662769 -122.422923117926 (37.7770313662769, -122.422923117926) 7 9 11 28852 10
162520 10628 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 805 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 6 3X4   6003942.23141 2110755.32974 37.775954734286 -122.429860889744 (37.775954734286, -122.429860889744) 7 9 11 29492 10
172277 10647 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 913 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6003471.55966 2110689.4075 37.775747062973 -122.431484357932 (37.775747062973, -122.431484357932) 15 9 11 29492 10
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
151746 10712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003917.66999 2113282.5787 37.7828925420276 -122.430126185708 (37.7828925420276, -122.430126185708) 7 9 11 29490 41
110927 10713 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 4X4   6003918.21533 2113256.44585 37.7828208186367 -122.430122434181 (37.7828208186367, -122.430122434181) 7 9 11 29490 41
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
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
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
115288 107652 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
116014 107653 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
26376 107654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
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
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
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
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
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
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
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
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
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
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
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
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
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
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
90763 113321 Undocumented 4 Ficus nitida :: Laurel Fig 53 222 HERMANN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6004169 2108774 37.7705273263251 -122.428935147688 (37.7705273263251, -122.428935147688) 7 9 11 29492 10
117710 11445 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2191X Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6005072.64937 2117089.85961 37.7934117301419 -122.426401604865 (37.7934117301419, -122.426401604865) 13 9 1 28858 27
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
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
137864 115903 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 4x4   6003287.79827449 2108952.35112135 37.7709671172915 -122.431995967048 (37.7709671172915, -122.431995967048) 15 9 11 29492 9
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
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
71007 116518 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 480 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2016 12:00:00 AM 3 9x6   6003703 2109976 37.7738013362642 -122.430632829648 (37.7738013362642, -122.430632829648) 7 9 11 29492 10
129156 116906 Permitted Site 7 Ficus nitida :: Laurel Fig 53 358 Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2     30     6003554.93862357 2108664.35445356 37.7701914899734 -122.431051362966 (37.7701914899734, -122.431051362966) 15 9 11 29492 10
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
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
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
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
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
142334 12245 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 503 Laguna St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2015 03:15:00 PM 3 5x5 Permit Number 780762 6004995.5845 2110652.4736 37.7757319109571 -122.426209740207 (37.7757319109571, -122.426209740207) 7 9 11 28852 10
117462 12246 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 501 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2015 03:15:00 PM 3 5x5   6004973.20209 2110637.42143 37.775689316239 -122.426286094705 (37.775689316239, -122.426286094705) 7 9 11 28852 10
57513 12263 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 640 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004991.72568 2111198.95935 37.7772322091826 -122.426262005109 (37.7772322091826, -122.426262005109) 7 9 11 28852 10
119332 12427 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1710 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM 12 4X4   6004482.43729 2114709.16781 37.7868415701808 -122.428274031584 (37.7868415701808, -122.428274031584) 13 9 11 28858 27
96583 12428 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1710 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM 12 4X4   6004482.43729 2114709.16781 37.7868415701808 -122.428274031584 (37.7868415701808, -122.428274031584) 13 9 11 28858 27
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
147341 127216 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 5 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999932.8876 2117120.87416 37.7932050075595 -122.444187729973 (37.7932050075595, -122.444187729973) 13 9 1 57 27
109441 127217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 6 Front Yard : Yard Tree Private 2     7 Width 4ft Permit Number 782825 5999928.92975 2117120.95639 37.7932050075467 -122.444201430254 (37.7932050075467, -122.444201430254) 13 9 1 57 27
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
184158 127219 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 8 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999916.98549 2117117.82475 37.7931957274607 -122.444242532876 (37.7931957274607, -122.444242532876) 13 9 1 57 27
175212 13101 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005049.00181 2119804.80205 37.800864933484 -122.426676850993 (37.800864933484, -122.426676850993) 13 9 1 57 17
115585 13186 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2051X Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002574.7502816 2119473.5963948 37.7998153348368 -122.435215088035 (37.7998153348368, -122.435215088035) 13 9 1 57 17
135783 13192 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2095 Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002431.86629 2119459.61132 37.7997688205881 -122.435708517981 (37.7997688205881, -122.435708517981) 13 9 1 57 17
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
186277 13199 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 1 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
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
120658 13201 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
115478 13204 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2150 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6001979.60867 2119494.8171 37.7998397874351 -122.437276016047 (37.7998397874351, -122.437276016047) 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
193344 13225 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2265 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001602.67751 2119341.9386 37.799398588794 -122.438569375951 (37.799398588794, -122.438569375951) 13 9 1 57 17
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
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
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
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
18271 139433 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005406.0306 2111183.3028 37.7772126295238 -122.424827676313 (37.7772126295238, -122.424827676313) 7 9 11 28852 10
5715 140049 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 651 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6005353.1353 2111583.6293 37.778308840554 -122.42503914867 (37.778308840554, -122.42503914867) 7 9 11 28852 10
6753 140065 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 612 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005425.1416 2111379.12 37.7777513751906 -122.424775499228 (37.7777513751906, -122.424775499228) 7 9 11 28852 10
12493 140066 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 614 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005423.0428 2111393.287 37.7777901557735 -122.424783767818 (37.7777901557735, -122.424783767818) 7 9 11 28852 10
15896 140067 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 616 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005420.4192 2111411.6517 37.7778404325738 -122.424794150591 (37.7778404325738, -122.424794150591) 7 9 11 28852 10
2723 140583 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 FILLMORE ST 9 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6003424.6737 2111485.9504 37.7779315149131 -122.431703431668 (37.7779315149131, -122.431703431668) 15 9 11 29492 41
34775 14651 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 655X McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
83435 14655 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 655X McAllister St 5 Sidewalk: Curb side : Cutout Tree DPW 1     60 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
60815 14812 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1190X McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003455.90906 2111772.60341 37.7787203633271 -122.431615848033 (37.7787203633271, -122.431615848033) 15 9 11 29490 41
143080 16387 Permitted Site 7 Ficus nitida :: Laurel Fig 53 238 Myrtle St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006273.2682 2114060.52153 37.7851617148845 -122.42203206633 (37.7851617148845, -122.42203206633) 13 9 11 28858 41
176167 16388 Permitted Site 7 Ficus nitida :: Laurel Fig 53 238 Myrtle St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006262.13214 2114058.51032 37.7851555645201 -122.422070450769 (37.7851555645201, -122.422070450769) 13 9 11 28858 41
32727 16390 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Myrtle St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006205.61528 2114051.709 37.7851337020107 -122.422265498437 (37.7851337020107, -122.422265498437) 13 9 11 28858 41
49601 16393 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 250X Myrtle St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006231.99165 2114068.14091 37.7851803077551 -122.422175412097 (37.7851803077551, -122.422175412097) 13 9 11 28858 41
68956 16394 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 250X Myrtle St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006231.99165 2114068.14091 37.7851803077551 -122.422175412097 (37.7851803077551, -122.422175412097) 13 9 11 28858 41
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
120455 1669 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2679X LOMBARD ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     13 3X3   5999625 2119128 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769) 13 9 1 57 17
174162 16730 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 19X Hollis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003888.91549 2113509.70556 37.7835145469728 -122.430241873385 (37.7835145469728, -122.430241873385) 7 9 11 29490 41
10459 16731 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 19X Hollis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 4X4   6003892.01293 2113485.99196 37.7834496108007 -122.4302294651 (37.7834496108007, -122.4302294651) 7 9 11 29490 41
122936 16856 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 150 Oak St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6006257.87931 2110498.54999 37.7753805408795 -122.421832203671 (37.7753805408795, -122.421832203671) 7 9 11 28852 10
142032 16862 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 205 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 7x6   6005961.9803 2110311.49787 37.7748502496054 -122.422842492323 (37.7748502496054, -122.422842492323) 7 9 11 28852 10
72584 16863 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 215 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005958.79101 2110336.37823 37.774918385113 -122.422855293382 (37.774918385113, -122.422855293382) 7 9 11 28852 10
174129 16872 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6005773.57352 2110239.8238 37.7746428175577 -122.423489134945 (37.7746428175577, -122.423489134945) 7 9 11 28852 10
61171 16895 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 371 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005249.75731 2110166.87775 37.7744129459718 -122.425295929281 (37.7744129459718, -122.425295929281) 7 9 11 28852 10
191157 16897 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 385 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005198.99692 2110159.80887 37.7743906686767 -122.425471016021 (37.7743906686767, -122.425471016021) 7 9 11 28852 10

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