3,267 rows where qSpecies_id = 67 sorted by Police Districts

View and edit SQL

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)
1799 125860 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2130 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007669.37183 2119725.10958 37.8007939141569 -122.417603593144 (37.8007939141569, -122.417603593144) 5 1 1 308 32
10172 100673 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
17521 142554 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 670 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6008032.7708 2121023.624 37.8043797498479 -122.416438106574 (37.8043797498479, -122.416438106574) 5 1 10 308 32
21332 16375 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1400X Montgomery St 8 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
22395 142555 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 680 Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6008015.0924 2121019.6955 37.8043679690114 -122.4164990059 (37.8043679690114, -122.4164990059) 5 1 10 308 32
23377 100670 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
23405 30475 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 424 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/1956 12:00:00 AM 8   Permit Number 123 6010870.8148 2119673.484 37.8008317865696 -122.406521568491 (37.8008317865696, -122.406521568491) 3 1 10 308 23
23528 42672 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 581 Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 4   Permit Number 42700 6008565.6692 2121051.5528 37.8044863886348 -122.414595938174 (37.8044863886348, -122.414595938174) 3 1 10 308 23
23657 143056 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 30 EDITH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6010306.5322 2120406.926 37.8028140529926 -122.408525998217 (37.8028140529926, -122.408525998217) 3 1 10 308 23
25371 250208 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 212 Union St 4 Front Yard : Yard Tree Private 2     5 Width 0ft   6011783.4083 2119794.63457 37.8012154488822 -122.403372122131 (37.8012154488822, -122.403372122131) 3 1 10 308 23
26428 125859 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 774 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009302.33361 2119112.65566 37.7992040180028 -122.411909538305 (37.7992040180028, -122.411909538305) 3 1 10 308 4
31686 142559 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2520 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007970.2417 2121076.9865 37.8045227532503 -122.416658276978 (37.8045227532503, -122.416658276978) 5 1 10 308 32
34574 27624 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 583 Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6008543.93216 2121005.06507 37.8043575237734 -122.414667869562 (37.8043575237734, -122.414667869562) 3 1 10 308 23
37878 7694 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 581 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6008552.9537 2121047.3143 37.8044740363975 -122.414639641316 (37.8044740363975, -122.414639641316) 3 1 10 308 23
39118 32369 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 858 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM 6   Permit Number 36919 6008860.83914 2119402.12264 37.7999740436362 -122.413457749072 (37.7999740436362, -122.413457749072) 3 1 10 308 32
39297 69323 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2130 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1994 12:00:00 AM 8   Permit Number 33406 6007673.53376 2119706.35756 37.8007426600105 -122.417587861288 (37.8007426600105, -122.417587861288) 5 1 1 308 32
40060 112793 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 23x Joice St 4 Unaccepted Street : Cutout Tree Private 2     8     6010304.6147 2116218.08658 37.7913124139936 -122.408237021841 (37.7913124139936, -122.408237021841) 5 1 10 28857 21
45883 125838 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 114 Leroy Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008325.43827 2116645.82165 37.7923758470246 -122.415115235581 (37.7923758470246, -122.415115235581) 5 1 10 28858 21
46684 125865 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1306x Montgomery St 47 Median : Yard Tree DPW 1     8 Width 8ft   6011401.82838 2120281.49833 37.8025309385205 -122.404726857271 (37.8025309385205, -122.404726857271) 3 1 10 308 23
50289 97454 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 758 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2011 12:00:00 AM 3 3x3   6007159.12761 2121599.09194 37.8059106699013 -122.419502281419 (37.8059106699013, -122.419502281419) 5 1 1 28858 32
53751 125862 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 440 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011367.34488 2119048.19509 37.7991426608692 -122.4047593111 (37.7991426608692, -122.4047593111) 3 1 10 308 23
55568 142560 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2530 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007965.9858 2121094.0101 37.8045692563949 -122.416674211666 (37.8045692563949, -122.416674211666) 5 1 10 308 32
62693 142558 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2510 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6007972.8607 2121055.3796 37.8044635734573 -122.416647682082 (37.8044635734573, -122.416647682082) 5 1 10 308 32
63822 125875 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 532 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6011598.44427 2118378.74815 37.7973174355031 -122.40391248968 (37.7973174355031, -122.40391248968) 3 1 10 308 23
69722 42673 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 581 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42700 6008532.69397696 2121039.56256614 37.8044516138202 -122.414709203199 (37.8044516138202, -122.414709203199) 3 1 10 308 23
74151 125870 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 14 Joice St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6010321.02235 2116231.3383 37.791349718756 -122.408181186526 (37.791349718756, -122.408181186526) 5 1 10 28857 21
75799 250223 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 312 Filbert St 4 Side Yard : Yard Tree Private 2     17 Width 0ft   6011234.32087 2120070.95666 37.8019434788798 -122.405291684587 (37.8019434788798, -122.405291684587) 3 1 10 308 23
75829 125871 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 909 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6011628.14364 2118497.28701 37.7976445738046 -122.403818067153 (37.7976445738046, -122.403818067153) 3 1 10 308 23
76357 142553 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 660 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6008051.1039 2121026.5704 37.8043888708704 -122.416374871972 (37.8043888708704, -122.416374871972) 5 1 10 308 32
76395 125851 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1359 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007069.22573 2118411.66691 37.7971537427193 -122.419587113579 (37.7971537427193, -122.419587113579) 5 1 10 28858 32
76408 125873 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 909 Montgomery St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011640.68248 2118420.88773 37.7974355002954 -122.403769300527 (37.7974355002954, -122.403769300527) 3 1 10 308 23
78634 112789 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 23x Joice St 1 Unaccepted Street : Cutout Tree Private 2     8 3x3   6010300.14411 2116243.45137 37.7913818092657 -122.408254279811 (37.7913818092657, -122.408254279811) 5 1 10 28857 21
80554 100671 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
84171 125876 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 532 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6011549.44134 2118372.57887 37.7972977583346 -122.404081618882 (37.7972977583346, -122.404081618882) 3 1 10 308 23
86197 250229 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 312 Filbert St 9 Side Yard : Yard Tree Private 2     20 Width 0ft   6011206.62982 2120043.61841 37.8018668665295 -122.405385582777 (37.8018668665295, -122.405385582777) 3 1 10 308 23
86554 125874 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 532 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6011617.36417 2118380.15479 37.797322354795 -122.403847120659 (37.797322354795, -122.403847120659) 3 1 10 308 23
87622 7688 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 545 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 0   6008696.1209 2121067.5649 37.8045376819256 -122.414145630391 (37.8045376819256, -122.414145630391) 3 1 10 308 23
88291 125872 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 909 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011632.89499 2118465.53836 37.7975576651089 -122.403799390925 (37.7975576651089, -122.403799390925) 3 1 10 308 23
92147 250226 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 312 Filbert St 6 Side Yard : Yard Tree Private 2     13 Width 0ft   6011217.04209 2120062.49723 37.8019192853099 -122.405350881537 (37.8019192853099, -122.405350881537) 3 1 10 308 23
95733 125869 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 14 Joice St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 4ft   6010322.99586 2116220.1954 37.7913192335393 -122.408173571972 (37.7913192335393, -122.408173571972) 5 1 10 28857 21
100416 112791 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 23x Joice St 2 Unaccepted Street : Cutout Tree Private 2     7     6010302.18584 2116235.66689 37.7913605492861 -122.408246666156 (37.7913605492861, -122.408246666156) 5 1 10 28857 21
102190 125867 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1306x Montgomery St 49 Median : Yard Tree DPW 1     7 Width 8ft   6011400.22925 2120293.8654 37.8025648060933 -122.404733262242 (37.8025648060933, -122.404733262242) 3 1 10 308 23
102204 125878 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 712 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6011759.18652 2117854.8104 37.7958878075263 -122.403319400277 (37.7958878075263, -122.403319400277) 3 1 10 28860 4
102481 125868 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1306x Montgomery St 50 Median : Yard Tree DPW 1     9 Width 8ft   6011397.07627 2120306.83138 37.8026002312778 -122.404745086537 (37.8026002312778, -122.404745086537) 3 1 10 308 23
102674 125864 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1306x Montgomery St 46 Median : Yard Tree DPW 1     11 Width 8ft   6011404.31889 2120270.95614 37.8025021314422 -122.404717496217 (37.8025021314422, -122.404717496217) 3 1 10 308 23
102922 142659 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 83 VANDEWATER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6009018.8867 2121294.5746 37.8051791175282 -122.41304472676 (37.8051791175282, -122.41304472676) 3 1 10 308 23
106867 7689 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 545 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008705.23662 2121043.72673 37.8044727403042 -122.414112396989 (37.8044727403042, -122.414112396989) 3 1 10 308 23
108556 42674 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 581 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42700 6008532.69397696 2121039.56256614 37.8044516138202 -122.414709203199 (37.8044516138202, -122.414709203199) 3 1 10 308 23
112318 125866 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1306x Montgomery St 48 Median : Yard Tree DPW 1     6 Width 8ft   6011400.87154 2120290.44992 37.802555463919 -122.404730798994 (37.802555463919, -122.404730798994) 3 1 10 308 23
112326 125848 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1156 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 5ft   6008008.91714 2118589.10669 37.7976938341652 -122.416348113498 (37.7976938341652, -122.416348113498) 5 1 10 28858 21
120711 125863 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 150 Francisco St 11 Front Yard : Yard Tree Private 2     4     6010483.33133 2121337.12789 37.8053780572129 -122.407979816633 (37.8053780572129, -122.407979816633) 3 1 10 308 23
121340 143083 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 439 Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6010755.7275 2120312.9864 37.8025812640991 -122.406964920001 (37.8025812640991, -122.406964920001) 3 1 10 308 23
129268 125861 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2456 Leavenworth St 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6007523.93323 2120832.54539 37.8038264685723 -122.418185431117 (37.8038264685723, -122.418185431117) 5 1 1 308 32
130865 125839 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 114 Leroy Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008323.23734 2116659.17104 37.7924123774867 -122.415123796229 (37.7924123774867, -122.415123796229) 5 1 10 28858 21
131813 125852 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1294 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6006829.97271 2119121.43017 37.799089094537 -122.420465395978 (37.799089094537, -122.420465395978) 5 1 1 28858 32
133972 142557 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2500 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6007977.1166 2121032.7906 37.8044017891252 -122.416631352939 (37.8044017891252, -122.416631352939) 5 1 10 308 32
138476 100672 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
138696 125840 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 114 Leroy Pl 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008320.5619 2116673.51568 37.7924516139938 -122.415134069189 (37.7924516139938, -122.415134069189) 5 1 10 28858 21
140447 64202 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 712 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1987 12:00:00 AM 7   Permit Number 24989 6007253.84118 2121612.31265 37.8059523049123 -122.419175447994 (37.8059523049123, -122.419175447994) 5 1 1 28858 32
142772 125847 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1752 Taylor St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 5ft   6008754.65133 2118947.56933 37.7987199902862 -122.413793029843 (37.7987199902862, -122.413793029843) 3 1 10 308 21
142883 250210 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 212 Union St 6 Front Yard : Yard Tree Private 2     3 Width 0ft   6011753.31095 2119788.98637 37.8011982592529 -122.403475875111 (37.8011982592529, -122.403475875111) 3 1 10 308 23
147927 142556 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 690 Francisco St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6007998.3962 2121018.0586 37.8043625355363 -122.416556668642 (37.8043625355363, -122.416556668642) 5 1 10 308 32
147993 125853 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 743 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6007172.66204 2121545.51126 37.8057643133355 -122.419451639674 (37.8057643133355, -122.419451639674) 5 1 1 28858 32
148411 125841 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 114 Leroy Pl 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008319.99153 2116681.90431 37.7924746150586 -122.415136636746 (37.7924746150586, -122.415136636746) 5 1 10 28858 21
149540 16376 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1400X Montgomery St 9 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
162263 250228 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 312 Filbert St 8 Side Yard : Yard Tree Private 2     16 Width 0ft   6011211.17154 2120049.40021 37.8018829958704 -122.405370273631 (37.8018829958704, -122.405370273631) 3 1 10 308 23
163739 125858 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 774 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6009308.82699 2119113.84916 37.7992076593521 -122.411887153278 (37.7992076593521, -122.411887153278) 3 1 10 308 4
163752 250225 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 312 Filbert St 5 Side Yard : Yard Tree Private 2     18 Width 0ft   6011230.02021 2120062.52676 37.8019200919915 -122.405305972987 (37.8019200919915, -122.405305972987) 3 1 10 308 23
168757 125837 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 114 Leroy Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6008328.08599 2116630.12257 37.7923328899977 -122.415104962639 (37.7923328899977, -122.415104962639) 5 1 10 28858 21
172754 142661 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 83 VANDEWATER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6009007.035 2121293.544 37.8051756224473 -122.41308566824 (37.8051756224473, -122.41308566824) 3 1 10 308 23
173812 250203 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 203 Union St 4 Side Yard : Yard Tree Private 2     7 Width 0ft   6011748.49406 2119742.37279 37.8010700006395 -122.403489262419 (37.8010700006395, -122.403489262419) 3 1 10 308 23
177709 42671 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1115 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM 3 3x3 Permit Number 49824 6007552.92747 2119520.43861 37.8002253861525 -122.417992022918 (37.8002253861525, -122.417992022918) 5 1 1 28858 32
185615 125836 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 12 Golden Ct 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 5ft   6008214.16509 2116540.37994 37.7920800761809 -122.415492776366 (37.7920800761809, -122.415492776366) 5 1 10 28858 21
186698 125877 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 532 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011538.01485 2118371.01947 37.7972928381608 -122.404121047862 (37.7972928381608, -122.404121047862) 3 1 10 308 23
187045 112794 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 21x JOICE ST 5 Unaccepted Street : Cutout Tree Private 2           6010276 2116206 37.7912776248382 -122.408335175586 (37.7912776248382, -122.408335175586) 5 1 10 28857 21
187196 125857 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1148 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6007410.78308 2119548.4108 37.8002941896961 -122.418485883829 (37.8002941896961, -122.418485883829) 5 1 1 28858 32
187357 250224 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 312 Filbert St 6 Side Yard : Yard Tree Private 2     9 Width 0ft   6011221.34302 2120070.92711 37.8019426721638 -122.405336592216 (37.8019426721638, -122.405336592216) 3 1 10 308 23
190625 112792 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 23x Joice St 3 Unaccepted Street : Cutout Tree Private 2     5     6010303.89255 2116225.84414 37.7913336739481 -122.408240067851 (37.7913336739481, -122.408240067851) 5 1 10 28857 21
194032 7693 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 581 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6008532.7031 2121045.4305 37.804467726204 -122.414709587149 (37.804467726204, -122.414709587149) 3 1 10 308 23
12381 65434 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 555 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/1999 12:00:00 AM     Permit Number 33170 6008638.12512872 2114173.69680574 37.785605560242 -122.41385837708 (37.785605560242, -122.41385837708) 7 10 9 28852 36
159951 43090 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 146 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2000 12:00:00 AM     Permit Number 42926 6008611.57202226 2112975.23965235 37.7823133939911 -122.413865436957 (37.7823133939911, -122.413865436957) 7 10 9 28852 36
336 189035 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 50 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010091.10409 2111787.20644 37.7791343146469 -122.408663052281 (37.7791343146469, -122.408663052281) 14 2 9 28853 34
6660 189023 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 955 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2018 12:00:00 AM 3 Width 3ft   6010789.05197 2109573.65252 37.7730954749965 -122.406092565024 (37.7730954749965, -122.406092565024) 14 2 9 28853 34
6771 43351 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 385 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/1977 12:00:00 AM 26 3x3 Permit Number 43103 6010005.03169 2109964.91982 37.7741259209126 -122.408832212936 (37.7741259209126, -122.408832212936) 8 2 9 28853 34
10766 189037 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 90 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010129.26407 2111748.29533 37.7790296110535 -122.408528295169 (37.7790296110535, -122.408528295169) 14 2 9 28853 34
10778 189038 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 90 Russ St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010137.33918 2111739.58339 37.7790061423445 -122.408499745276 (37.7790061423445, -122.408499745276) 14 2 9 28853 34
10999 31902 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 965 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 14   Permit Number 35327 6008027.66279 2109898.08591 37.7738314549808 -122.415667565898 (37.7738314549808, -122.415667565898) 8 2 9 28853 34
12936 189036 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 90 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010111.83402 2111767.71706 37.7790819623998 -122.408589963453 (37.7790819623998, -122.408589963453) 14 2 9 28853 34
16254 189034 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 50 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010058.78317 2111821.06751 37.7792254789148 -122.408777253584 (37.7792254789148, -122.408777253584) 14 2 9 28853 34
16632 42238 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 479 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM 3   Permit Number 42487 6010497.26908 2112250.8624 37.7804301450699 -122.407290649051 (37.7804301450699, -122.407290649051) 14 2 9 28853 34
17030 220770 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 54 Pearl St 1 : Tree Private 2     10 Width 3ft   6005613.92059 2108688.47135 37.7703741651755 -122.423931067487 (37.7703741651755, -122.423931067487) 8 2 5 28853 19
17297 189039 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 90 Russ St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010144.76793 2111731.54232 37.7789844794824 -122.408473478765 (37.7789844794824, -122.408473478765) 14 2 9 28853 34
17841 107624 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 467 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011064.4697 2111919.17259 37.7795511306237 -122.405305061079 (37.7795511306237, -122.405305061079) 14 2 9 28853 34
20306 121801 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1235 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6008572.2717 2110960.39862 37.7767789137416 -122.413858829626 (37.7767789137416, -122.413858829626) 8 2 9 28853 34
20794 60190 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1235 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/18/1982 12:00:00 AM 10   Permit Number 19735 6008544.7327 2110936.08659 37.776710612043 -122.413952375309 (37.776710612043, -122.413952375309) 8 2 9 28853 34
23301 121802 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1235 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     8     6008587.55783 2110975.09573 37.776820126979 -122.413806990012 (37.776820126979, -122.413806990012) 8 2 9 28853 34
26334 82890 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 1325 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52441 6008634.678811 2110151.0598083 37.7745601652378 -122.413585687931 (37.7745601652378, -122.413585687931) 8 2 9 28853 34
29618 189028 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 22 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6009991.59212 2111891.52885 37.7794151855119 -122.409014669189 (37.7794151855119, -122.409014669189) 14 2 9 28853 34
38323 100251 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 540 Delancey St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6015234.41692 2113622.27838 37.7844597292764 -122.390998376191 (37.7844597292764, -122.390998376191) 6 2 9 28856 6
40381 42165 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 354 05th St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM 4   Permit Number 779305 6011856.41574 2111871.95313 37.7794657219919 -122.402562043425 (37.7794657219919, -122.402562043425) 14 2 9 28856 34

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