trees
3,267 rows where qSpecies_id = 67 sorted by Police Districts
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );