trees
3,267 rows where qSpecies_id = 67 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20971 | 9178 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987973.0454 | 2112592.9065 | 37.7800829358976 | -122.485236638901 | (37.7800829358976, -122.485236638901) | 11 | 6 | 2 | 55 | 26 | |||
21089 | 184538 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1939 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5982255.8834 | 2101901.5386 | 37.7503928027278 | -122.504222349881 | (37.7503928027278, -122.504222349881) | 1 | 8 | 3 | 29491 | 35 | |||
21122 | 125778 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 20 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5997378.69619 | 2114327.82413 | 37.7853899906986 | -122.452823661499 | (37.7853899906986, -122.452823661499) | 15 | 6 | 1 | 54 | 31 | |||
21131 | 220820 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005416.76341 | 2103047.49805 | 37.7548742543519 | -122.42421178725 | (37.7548742543519, -122.42421178725) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
21349 | 200220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014047.4712 | 2090254.411 | 37.7202306272165 | -122.393468896776 | (37.7202306272165, -122.393468896776) | 10 | 3 | 8 | 58 | 1 | |||
21381 | 8899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
21490 | 222211 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Chenery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001126.04303 | 2096135.59352 | 37.7356525981802 | -122.43855505387 | (37.7356525981802, -122.43855505387) | 2 | 7 | 5 | 63 | 7 | |||
21567 | 25601 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1425 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009396.61831 | 2097480.31655 | 37.7398119185732 | -122.410055276551 | (37.7398119185732, -122.410055276551) | 10 | 7 | 7 | 28859 | 2 | |||
21650 | 218260 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x Portola Dr | 18 | Median : Yard | Tree | DPW 1 | 12 | 5992795.95946 | 2097207.23373 | 37.738117677685 | -122.46743301504 | (37.738117677685, -122.46743301504) | 1 | 8 | 4 | 59 | 40 | ||||
21676 | 9094 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989203.8431 | 2112625.0148 | 37.7802427184836 | -122.480981153199 | (37.7802427184836, -122.480981153199) | 11 | 6 | 2 | 55 | 26 | |||
21698 | 222228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5735 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6000718.4413 | 2097027.59574 | 37.7380786327218 | -122.440028227017 | (37.7380786327218, -122.440028227017) | 2 | 7 | 5 | 63 | 7 | |||
21707 | 204401 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5994301.11248 | 2105797.04761 | 37.7617899068936 | -122.462851987244 | (37.7617899068936, -122.462851987244) | 1 | 5 | 11 | 56 | 12 | |||
21777 | 66859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | 1 | 8 | 3 | 29491 | 35 | ||
21896 | 184581 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1747 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984379.9879 | 2103282.638 | 37.7543096128776 | -122.496979084355 | (37.7543096128776, -122.496979084355) | 1 | 8 | 3 | 56 | 35 | |||
22003 | 125776 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997332.30363 | 2114303.61712 | 37.7853208661167 | -122.452982417028 | (37.7853208661167, -122.452982417028) | 15 | 6 | 1 | 54 | 31 | |||
22061 | 119944 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 378 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5986559.93935 | 2113398.94352 | 37.7822136625365 | -122.49018445318 | (37.7822136625365, -122.49018445318) | 11 | 6 | 2 | 55 | 26 | |||
22105 | 175678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 147 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004344.1962 | 2094346.31946 | 37.7309221929871 | -122.42730123817 | (37.7309221929871, -122.42730123817) | 9 | 7 | 6 | 28861 | 5 | |||
22168 | 188924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6012576.69697 | 2101839.95145 | 37.7519602710713 | -122.399365809709 | (37.7519602710713, -122.399365809709) | 10 | 3 | 8 | 28856 | 29 | |||
22190 | 222467 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 222 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004131.97597 | 2097627.84522 | 37.7399205162221 | -122.428268704549 | (37.7399205162221, -122.428268704549) | 2 | 7 | 5 | 63 | 7 | |||
22346 | 93056 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 2.5x8 | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
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 | |||
22444 | 204402 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5994299.73168 | 2105778.36459 | 37.7617385286395 | -122.462855407375 | (37.7617385286395, -122.462855407375) | 1 | 5 | 11 | 56 | 12 | |||
22495 | 204586 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 231 Edna St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 5998760.41171 | 2095319.00684 | 37.7332755919857 | -122.446675184631 | (37.7332755919857, -122.446675184631) | 9 | 7 | 4 | 59 | 40 | ||||
22678 | 199908 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6017309.9205 | 2093127.3901 | 37.7283000004206 | -122.382391361643 | (37.7283000004206, -122.382391361643) | 10 | 3 | 8 | 58 | 1 | |||
22729 | 125756 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2495 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001066.19876 | 2118613.86954 | 37.7973689711697 | -122.440373533438 | (37.7973689711697, -122.440373533438) | 13 | 9 | 1 | 57 | 17 | |||
22792 | 175701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Yale St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6007087.6481 | 2092939.47489 | 37.7272140768676 | -122.417716969765 | (37.7272140768676, -122.417716969765) | 9 | 3 | 7 | 309 | 5 | |||
22795 | 55186 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.12637 | 37.7312427671323 | -122.395999500683 | (37.7312427671323, -122.395999500683) | 10 | 3 | 8 | 58 | 1 | ||
22832 | 4862 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6000700.354 | 2098195.46944 | 37.7412843093321 | -122.440174488273 | (37.7412843093321, -122.440174488273) | 2 | 7 | 5 | 63 | 7 | |||
22850 | 4230 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3987 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004020.01969 | 2100398.84161 | 37.7475226986238 | -122.428853300761 | (37.7475226986238, -122.428853300761) | 2 | 4 | 5 | 63 | 22 | |||
23198 | 21529 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6006199.49469 | 2114932.42153 | 37.7875515759816 | -122.422349271528 | (37.7875515759816, -122.422349271528) | 13 | 9 | 1 | 28858 | 41 | |||
23213 | 188987 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 305 Bridgeview Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012918.63111 | 2094968.59879 | 37.7331120403799 | -122.397701430785 | (37.7331120403799, -122.397701430785) | 10 | 3 | 8 | 58 | 1 | |||
23298 | 4375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1035 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000885.93841 | 2096177.1796 | 37.7357531225975 | -122.43938816603 | (37.7357531225975, -122.43938816603) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
23306 | 92939 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 363 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5992054.1 | 2096847.4 | 37.7370868080983 | -122.469971777828 | (37.7370868080983, -122.469971777828) | 1 | 8 | 4 | 59 | 40 | ||||
23330 | 188972 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 55 Vesta St | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6012266.05718 | 2094101.57422 | 37.7306950098702 | -122.399896704685 | (37.7306950098702, -122.399896704685) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
23402 | 105461 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
23424 | 188870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300x De Haro St | 30 | Median : Yard | Tree | DPW 1 | 15 | 6012283.09076 | 2102020.40062 | 37.7524393767806 | -122.400393822023 | (37.7524393767806, -122.400393822023) | 10 | 3 | 8 | 28856 | 29 | ||||
23425 | 222331 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4335 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001694.76804 | 2101151.85746 | 37.749458417373 | -122.436947761251 | (37.749458417373, -122.436947761251) | 2 | 4 | 5 | 28862 | 22 | |||
23457 | 8744 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
23467 | 117983 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Shore View Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5984187.50987 | 2112858.34 | 37.7805904888414 | -122.498351927647 | (37.7805904888414, -122.498351927647) | 11 | 6 | 2 | 55 | 26 | |||
23515 | 188900 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1336 20th St | 1 | : | Tree | Private 2 | 16 | Width 3ft | 6013884.30991 | 2104803.71969 | 37.7601709320582 | -122.395051432701 | (37.7601709320582, -122.395051432701) | 10 | 3 | 8 | 28856 | 29 | |||
23517 | 189018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 La Salle Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014940.20739 | 2096568.46333 | 37.7376173092958 | -122.390824013816 | (37.7376173092958, -122.390824013816) | 10 | 3 | 8 | 58 | 1 | |||
23518 | 175745 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 52 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6003007.00361 | 2086627.02122 | 37.7096509944604 | -122.431373299139 | (37.7096509944604, -122.431373299139) | 9 | 7 | 6 | 28861 | 5 | |||
23558 | 220848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 239 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010197.64417 | 2100009.63679 | 37.7468017463196 | -122.407463927738 | (37.7468017463196, -122.407463927738) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
23868 | 205774 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 367 Kensington Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5994104.03782 | 2099097.57437 | 37.7433835122355 | -122.463047484554 | (37.7433835122355, -122.463047484554) | 1 | 8 | 4 | 59 | 40 | |||
23892 | 57845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 153 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1977 12:00:00 AM | 10 | Permit Number 16786 | 6004375.10165 | 2094347.97988 | 37.7309284999329 | -122.427194511121 | (37.7309284999329, -122.427194511121) | 9 | 7 | 6 | 28861 | 5 | ||
23969 | 118556 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8100 Geary Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5981834.60643 | 2112394.66752 | 37.7791791285364 | -122.506457204565 | (37.7791791285364, -122.506457204565) | 11 | 6 | 2 | 55 | 26 | |||
24252 | 112667 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 IRVING ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988170 | 2106474 | 37.7632935889767 | -122.48410644406 | (37.7632935889767, -122.48410644406) | 1 | 8 | 3 | 56 | 35 | ||||
24262 | 222328 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3420 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006741.0618 | 2104981.3995 | 37.760258986489 | -122.419769198407 | (37.760258986489, -122.419769198407) | 2 | 4 | 7 | 28859 | 19 | |||
24265 | 143366 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1745 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004644.9873 | 2118760.3647 | 37.7979743272134 | -122.428000442989 | (37.7979743272134, -122.428000442989) | 13 | 9 | 1 | 57 | 17 | |||
24420 | 55329 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 241 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 10 | Permit Number 11260 | 6011497.74978 | 2089236.66648 | 37.7172941095093 | -122.402210970564 | (37.7172941095093, -122.402210970564) | 10 | 7 | 8 | 309 | 39 | ||
24438 | 188936 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 501 Hampshire St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010113.25727 | 2105784.21674 | 37.7626527317506 | -122.408162927599 | (37.7626527317506, -122.408162927599) | 8 | 4 | 8 | 28859 | 19 | |||
24493 | 222374 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 237 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004025.35278 | 2105686.39209 | 37.7620413681468 | -122.429211828984 | (37.7620413681468, -122.429211828984) | 8 | 4 | 5 | 28862 | 3 | |||
24630 | 199971 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016740.2994 | 2092779.7041 | 37.7273138422776 | -122.384336380249 | (37.7273138422776, -122.384336380249) | 10 | 3 | 8 | 58 | 1 | |||
24664 | 200704 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1466 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6015947.4931 | 2095190.3982 | 37.7338892579459 | -122.387245217903 | (37.7338892579459, -122.387245217903) | 10 | 3 | 8 | 58 | 1 | |||
24776 | 188249 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 950 Key Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013627.87026 | 2089584.47389 | 37.718367790327 | -122.394872433433 | (37.718367790327, -122.394872433433) | 10 | 3 | 8 | 58 | 1 | |||
24787 | 188993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 150 Topeka Ave | 3 | : | Tree | Private 2 | 15 | Width 3ft | 6012747.96084 | 2095104.27422 | 37.7334750715082 | -122.398301003391 | (37.7334750715082, -122.398301003391) | 10 | 3 | 8 | 58 | 1 | |||
24802 | 122162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 553 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5991248.88976 | 2111615.51669 | 37.7775895788166 | -122.473832798234 | (37.7775895788166, -122.473832798234) | 11 | 6 | 2 | 54 | 26 | |||
24875 | 205662 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1598 10th Ave | 12 | : | Tree | Private 2 | 13 | Width 2ft | 5993106.37013 | 2104709.96458 | 37.7587361743455 | -122.466905058137 | (37.7587361743455, -122.466905058137) | 1 | 8 | 4 | 56 | 12 | |||
24983 | 220898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998243.00011 | 2106881.99825 | 37.7649951626328 | -122.449296801911 | (37.7649951626328, -122.449296801911) | 15 | 5 | 11 | 29492 | 9 | |||
25143 | 112508 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 648 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993454.86238 | 2113520.61586 | 37.7829479875441 | -122.466340150769 | (37.7829479875441, -122.466340150769) | 11 | 6 | 2 | 54 | 11 | |||
25231 | 116687 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777961 | 6002117.845 | 2092646.43529 | 37.7261285348836 | -122.434876571303 | (37.7261285348836, -122.434876571303) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |||
25438 | 123463 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 640 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5995355.59472 | 2111175.27155 | 37.7766177851051 | -122.459594525244 | (37.7766177851051, -122.459594525244) | 11 | 6 | 2 | 54 | 11 | |||
25457 | 189004 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1743 La Salle Ave | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6014780.96102 | 2096683.31962 | 37.7379238441057 | -122.391382635804 | (37.7379238441057, -122.391382635804) | 10 | 3 | 8 | 58 | 1 | |||
25461 | 188931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012684.2362 | 2101844.79492 | 37.751979563304 | -122.398994261091 | (37.751979563304, -122.398994261091) | 10 | 3 | 8 | 28856 | 29 | |||
25501 | 8742 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 | |||
25506 | 220787 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3737 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005401.46257 | 2100766.89141 | 37.7486113720262 | -122.424102523213 | (37.7486113720262, -122.424102523213) | 2 | 4 | 5 | 28859 | 19 | |||
25523 | 102538 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 295X Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994650.9 | 2113509.7 | 37.7829869539372 | -122.462201593946 | (37.7829869539372, -122.462201593946) | 11 | 6 | 2 | 54 | 11 | ||||
25629 | 8812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
25786 | 4863 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000706.81411 | 2098191.78506 | 37.7412745606821 | -122.440151887408 | (37.7412745606821, -122.440151887408) | 2 | 7 | 5 | 63 | 7 | |||
25795 | 119380 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 318 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5986236.40881 | 2113747.95294 | 37.7831530428525 | -122.491329403602 | (37.7831530428525, -122.491329403602) | 11 | 6 | 2 | 55 | 26 | |||
25945 | 62056 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1985 12:00:00 AM | 8 | Permit Number 22136 | 6002013.39133 | 2121163.89045 | 37.8044245429292 | -122.437278691955 | (37.8044245429292, -122.437278691955) | 13 | 9 | 1 | 57 | 17 | ||
26052 | 94065 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 5 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
26162 | 205755 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 36 | Median : Yard | Tree | DPW 1 | 5 | 5993878.86602 | 2096471.77214 | 37.7361607421118 | -122.463635532375 | (37.7361607421118, -122.463635532375) | 1 | 8 | 4 | 59 | 40 | ||||
26172 | 205731 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 391 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992455.63344 | 2094179.85071 | 37.7297855875292 | -122.468389493495 | (37.7297855875292, -122.468389493495) | 9 | 8 | 4 | 59 | 40 | |||
26176 | 220905 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 306 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007720.61353 | 2097651.96548 | 37.7401891482 | -122.415862362667 | (37.7401891482, -122.415862362667) | 2 | 7 | 7 | 28859 | 2 | |||
26306 | 188877 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 711 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011296.96428 | 2105014.49573 | 37.7606054583887 | -122.404014716503 | (37.7606054583887, -122.404014716503) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
26339 | 222392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4507 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001052.02782 | 2104620.927 | 37.758947091453 | -122.439419007375 | (37.758947091453, -122.439419007375) | 2 | 4 | 5 | 28862 | 38 | |||
26342 | 220895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 842 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998713.61111 | 2107159.2684 | 37.7657833842225 | -122.447689044327 | (37.7657833842225, -122.447689044327) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
26473 | 21538 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1350 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006090.48396 | 2114915.15347 | 37.787498012379 | -122.42272519983 | (37.787498012379, -122.42272519983) | 13 | 9 | 1 | 28858 | 41 | |||
26597 | 205699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993054.98439 | 2099411.54148 | 37.7441851013744 | -122.46669763039 | (37.7441851013744, -122.46669763039) | 1 | 8 | 4 | 29491 | 40 | |||
26606 | 8945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
26637 | 55149 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4201-4203 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1972 12:00:00 AM | Permit Number 11053 | 6001854.68954035 | 2102324.20100835 | 37.7526864815527 | -122.436478647094 | (37.7526864815527, -122.436478647094) | 2 | 4 | 5 | 28862 | 22 | |||
26672 | 90184 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1718 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990253.28479 | 2111313.46411 | 37.7767025104427 | -122.477254814454 | (37.7767025104427, -122.477254814454) | 11 | 6 | 2 | 55 | 26 | ||
26918 | 9019 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 8M | 5990422.2126 | 2112674.4808 | 37.780449286015 | -122.476769912257 | (37.780449286015, -122.476769912257) | 11 | 6 | 2 | 55 | 26 | ||
27048 | 220828 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008890.85265 | 2099117.25191 | 37.7442782234756 | -122.411919652972 | (37.7442782234756, -122.411919652972) | 2 | 7 | 7 | 28859 | 2 | |||
27096 | 204488 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993862.27446 | 2102337.63255 | 37.7522659605301 | -122.464118595998 | (37.7522659605301, -122.464118595998) | 1 | 8 | 4 | 29491 | 40 | |||
27106 | 222267 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 252 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006992.10855 | 2097505.51767 | 37.7397460522488 | -122.418370863232 | (37.7397460522488, -122.418370863232) | 2 | 7 | 7 | 28859 | 2 | |||
27126 | 205835 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 815 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994339.81958 | 2090564.44928 | 37.7199672210772 | -122.46161367654 | (37.7199672210772, -122.46161367654) | 9 | 8 | 6 | 28861 | 24 | |||
27200 | 103055 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2301 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 29932 | 5986892 | 2102979 | 37.7536227864704 | -122.488269714105 | (37.7536227864704, -122.488269714105) | 1 | 8 | 3 | 56 | 35 | ||||
27241 | 121845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 518 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990042.03941 | 2111801.50629 | 37.7780302806256 | -122.478021255234 | (37.7780302806256, -122.478021255234) | 11 | 6 | 2 | 55 | 26 | |||
27339 | 205714 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 141 Taraval St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993201.34966 | 2099148.16346 | 37.7434703777616 | -122.46617239935 | (37.7434703777616, -122.46617239935) | 1 | 8 | 4 | 59 | 40 | |||
27573 | 248415 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998794.3313 | 2108066.9818 | 37.7682803489291 | -122.447475194488 | (37.7682803489291, -122.447475194488) | 15 | 5 | 11 | 29492 | 9 |
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) );