trees
3,587 rows where qSpecies_id = 28 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18822 | 65766 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1937 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 15 | Permit Number 28729 | 6003642.45675 | 2118972.66599 | 37.7985004828598 | -122.431484647806 | (37.7985004828598, -122.431484647806) | 13 | 9 | 1 | 57 | 17 | |
18977 | 97306 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 47 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997949.8 | 2111441.7 | 37.7774981585608 | -122.450639669067 | (37.7774981585608, -122.450639669067) | 15 | 6 | 2 | 54 | 16 | |||||
19385 | 16804 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2060 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Mayor Office of Housing 11 | 18 | 4x3 | 6001450.7704065 | 2113227.696464 | 37.7826018222756 | -122.438656679492 | (37.7826018222756, -122.438656679492) | 15 | 5 | 11 | 29490 | 41 | |||
19608 | 189403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012367.68824 | 2104717.66867 | 37.7598502014559 | -122.400290696781 | (37.7598502014559, -122.400290696781) | 10 | 3 | 8 | 28856 | 29 | |||
19666 | 98539 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4x4 | 5991968.21537 | 2110556.64654 | 37.774723845896 | -122.471267264576 | (37.774723845896, -122.471267264576) | 11 | 6 | 2 | 54 | 11 | |||
19682 | 16216 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 527-529 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | Also has partial frontage shared with 535 Monterey Blvd. | 5998570.71989 | 2094653.44366 | 37.7314372752037 | -122.447283112845 | (37.7314372752037, -122.447283112845) | 9 | 7 | 4 | 59 | 40 | ||
19688 | 126199 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3045 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999577.09584 | 2116663.67012 | 37.7919293417196 | -122.44538589855 | (37.7919293417196, -122.44538589855) | 13 | 6 | 1 | 29490 | 27 | |||
19739 | 119985 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 5987666.80033 | 2110540.30319 | 37.7744292202448 | -122.486145343797 | (37.7744292202448, -122.486145343797) | 11 | 6 | 2 | 55 | 26 | |||
19759 | 206343 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 320 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5993037.90763 | 2099693.34054 | 37.7449578645128 | -122.46677715836 | (37.7449578645128, -122.46677715836) | 1 | 8 | 4 | 29491 | 40 | |||
19936 | 206425 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 197 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6000818.65749 | 2094921.32163 | 37.7323009993923 | -122.439530782334 | (37.7323009993923, -122.439530782334) | 9 | 7 | 4 | 63 | 40 | |||
20078 | 248752 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1179 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007686.46628 | 2102816.39807 | 37.7543676015089 | -122.416346131374 | (37.7543676015089, -122.416346131374) | 2 | 4 | 7 | 28859 | 19 | |||
20135 | 248904 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4109 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1976 12:00:00 AM | 28 | Width 5ft | Permit Number 16599 | 6001658.90013 | 2103489.46423 | 37.7558748868343 | -122.437239147875 | (37.7558748868343, -122.437239147875) | 2 | 4 | 5 | 28862 | 22 | |
20154 | 126324 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 514 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012230.12166 | 2117309.16104 | 37.7944158754575 | -122.401651495115 | (37.7944158754575, -122.401651495115) | 3 | 1 | 10 | 28860 | 4 | |||
20178 | 6025 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1791 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001894.3231 | 2112551.24042 | 37.7807696680583 | -122.437073734016 | (37.7807696680583, -122.437073734016) | 15 | 5 | 11 | 29490 | 41 | |||
20259 | 26515 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2886 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6008938.68629 | 2101687.00134 | 37.7513368683627 | -122.411935812817 | (37.7513368683627, -122.411935812817) | 2 | 4 | 7 | 28859 | 19 | ||||
20268 | 248759 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2987 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008379.36946 | 2103275.26244 | 37.7556664788408 | -122.413982346112 | (37.7556664788408, -122.413982346112) | 2 | 4 | 7 | 28859 | 19 | |||
20402 | 257888 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 155X Magellan Ave | 1 | Front Yard : Yard | Tree | MTA 3 | 10x10 | 5995070 | 2100842 | 37.7482288640106 | -122.459833790503 | (37.7482288640106, -122.459833790503) | 1 | 8 | 4 | 29491 | 40 | ||||
20491 | 118331 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007461 | 2099574 | 37.7454520282724 | -122.416896144845 | (37.7454520282724, -122.416896144845) | 2 | 7 | 7 | 28859 | 2 | ||||
20962 | 116910 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 351X HERMANN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6003606 | 2108630 | 37.7701000542623 | -122.430872290016 | (37.7701000542623, -122.430872290016) | 15 | 9 | 5 | 29492 | 10 | |||
20969 | 212079 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 121 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5994275.39415 | 2097162.78754 | 37.7380809394917 | -122.462314685482 | (37.7380809394917, -122.462314685482) | 9 | 8 | 4 | 59 | 40 | |||
21189 | 14933 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | 10 | 3 | 8 | 58 | 1 | |||
21249 | 112640 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 299X STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x9 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
21784 | 123231 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 759 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 6ft | 5993483.55222 | 2110312.60045 | 37.7741412977795 | -122.466007712161 | (37.7741412977795, -122.466007712161) | 11 | 6 | 2 | 54 | 11 | |||
21817 | 222088 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3757 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003335.69899 | 2103576.63958 | 37.7562094265452 | -122.431446457193 | (37.7562094265452, -122.431446457193) | 2 | 4 | 5 | 28862 | 22 | |||
21900 | 176048 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | 1 | 8 | 4 | 64 | 14 | ||||
21966 | 14887 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.383596739007 | (37.7429202372855, -122.383596739007) | 10 | 3 | 8 | 58 | 1 | ||
22374 | 12660 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1045 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 4X4 | 5992154.39933 | 2114773.56456 | 37.7863131171963 | -122.470930475416 | (37.7863131171963, -122.470930475416) | 11 | 6 | 2 | 54 | 11 | |||
22417 | 58653 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1041 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17875 | 5997239.92048014 | 2106921.18918515 | 37.7650453439116 | -122.452769014505 | (37.7650453439116, -122.452769014505) | 15 | 5 | 11 | 29492 | 12 | ||
22477 | 248840 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 65 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006855.4137 | 2099329.69653 | 37.7447471434584 | -122.418972846027 | (37.7447471434584, -122.418972846027) | 2 | 7 | 7 | 28859 | 2 | |||
22614 | 142207 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 427 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 0ft | 5999714.6993 | 2110123.1538 | 37.7739786302184 | -122.444439532021 | (37.7739786302184, -122.444439532021) | 15 | 5 | 11 | 29492 | 16 | |||
22660 | 33533 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.417422147014 | (37.7409482571652, -122.417422147014) | 2 | 7 | 7 | 28859 | 2 | |||
22671 | 248642 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 101 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007785.69421 | 2107933.31633 | 37.7684230563089 | -122.416365384082 | (37.7684230563089, -122.416365384082) | 8 | 4 | 7 | 28853 | 19 | |||
22924 | 246218 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1378 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999578.5072 | 2107913.2961 | 37.7679031482442 | -122.444751767156 | (37.7679031482442, -122.444751767156) | 15 | 5 | 11 | 29492 | 9 | |||
23052 | 3754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1020 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 36 | 18 | 6012443.0515847 | 2103208.5839527 | 37.755710788358 | -122.399924077269 | (37.755710788358, -122.399924077269) | 10 | 3 | 8 | 28856 | 29 | |||
23077 | 16168 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 425 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 28 | 3X3 | 5999268.01839 | 2094645.05904 | 37.7314540727301 | -122.444871826278 | (37.7314540727301, -122.444871826278) | 9 | 7 | 4 | 59 | 40 | ||
23094 | 248636 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 83 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6005406.472 | 2103224.32125 | 37.7553591885768 | -122.42425995315 | (37.7553591885768, -122.42425995315) | 2 | 4 | 5 | 28859 | 19 | |||
23313 | 67885 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 558 Commercial St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/22/1993 12:00:00 AM | 11 | 4x4 | Permit Number 31579 | 6012000.40021 | 2117278.49262 | 37.7943188457921 | -122.402444206153 | (37.7943188457921, -122.402444206153) | 3 | 1 | 10 | 28860 | 4 | |
23438 | 5987 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1640 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5x6 | 6002592.39189 | 2112708.53671 | 37.7812412183178 | -122.434670029614 | (37.7812412183178, -122.434670029614) | 15 | 5 | 11 | 29490 | 41 | |||
23442 | 1196 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.454118486498 | (37.7108640234246, -122.454118486498) | 9 | 7 | 6 | 28861 | 25 | ||
23632 | 222089 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3751 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003397.45281 | 2103581.47899 | 37.7562262141931 | -122.43123323693 | (37.7562262141931, -122.43123323693) | 2 | 4 | 5 | 28862 | 22 | |||
23645 | 16758 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1900X O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002203.1786904 | 2113328.4738156 | 37.7829213052255 | -122.43606088796 | (37.7829213052255, -122.43606088796) | 13 | 5 | 11 | 29490 | 41 | |||
23933 | 251069 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 5200x Geary Blvd | 1 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 5990794.5513 | 2112690.3427 | 37.7805144291466 | -122.475482989541 | (37.7805144291466, -122.475482989541) | 11 | 6 | 2 | 54 | 26 | |||
24024 | 54655 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 280 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10479 | 6012382.77536 | 2087271.8623 | 37.7119485104815 | -122.399014002112 | (37.7119485104815, -122.399014002112) | 10 | 3 | 8 | 309 | 1 | ||
24372 | 212187 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | 2 | 7 | 5 | 63 | 7 | ||||
24554 | 142386 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 MAYFAIR DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 0ft | 5998114.6675 | 2114591.1717 | 37.7861552196694 | -122.450296423393 | (37.7861552196694, -122.450296423393) | 11 | 6 | 1 | 54 | 31 | |||
24625 | 199947 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1322 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6016399.8746 | 2093108.561 | 37.7281979890567 | -122.385536147419 | (37.7281979890567, -122.385536147419) | 10 | 3 | 8 | 58 | 1 | |||
24635 | 251248 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001839 | 2095802 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | 2 | 7 | 5 | 63 | 7 | ||||
24682 | 50574 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
24726 | 14899 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 160 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6016997.24223 | 2098390.01536 | 37.7427328424729 | -122.383838589425 | (37.7427328424729, -122.383838589425) | 10 | 3 | 8 | 58 | 1 | |||
24910 | 50685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.7654709832109 | -122.446105453704 | (37.7654709832109, -122.446105453704) | 15 | 5 | 11 | 29492 | 9 | ||||
25454 | 96949 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 798X 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5988521.18817 | 2110597.78203 | 37.7746367985505 | -122.483194104095 | (37.7746367985505, -122.483194104095) | 11 | 6 | 2 | 55 | 26 | |||
25608 | 212004 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 135 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 5992880.81315 | 2095779.08404 | 37.7342012344874 | -122.467035834859 | (37.7342012344874, -122.467035834859) | 9 | 8 | 4 | 59 | 40 | |||
25688 | 4330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 831 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001821.43184 | 2095823.4199 | 37.7348349741444 | -122.436128498656 | (37.7348349741444, -122.436128498656) | 2 | 7 | 5 | 63 | 7 | |||
25864 | 5789 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 551 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6003097.4127 | 2108300.15747 | 37.7691655581641 | -122.432607921711 | (37.7691655581641, -122.432607921711) | 15 | 5 | 5 | 28862 | 3 | |||
26412 | 34885 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.8048079563004 | -122.434374036967 | (37.8048079563004, -122.434374036967) | 13 | 9 | 1 | 57 | 17 | ||||
26456 | 206405 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 160 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 3ft | 5994407.40356 | 2096440.94307 | 37.7361065336912 | -122.461805940812 | (37.7361065336912, -122.461805940812) | 9 | 8 | 4 | 59 | 40 | |||
26494 | 222099 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 58 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003922.64158 | 2105116.71076 | 37.7604713442974 | -122.429526437895 | (37.7604713442974, -122.429526437895) | 2 | 4 | 5 | 28862 | 3 | |||
26824 | 139535 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2171 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6000955.3801 | 2113112.4377 | 37.7822571572358 | -122.440362244117 | (37.7822571572358, -122.440362244117) | 15 | 5 | 11 | 29490 | 41 | |||
27149 | 206329 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 218 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5996602.13864 | 2105802.63508 | 37.7619375135335 | -122.454894104978 | (37.7619375135335, -122.454894104978) | 15 | 5 | 11 | 29492 | 12 | |||
27213 | 87671 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50395 | 5987244 | 2115292 | 37.7874513785554 | -122.487957078163 | (37.7874513785554, -122.487957078163) | 11 | 6 | 1 | 55 | 33 | ||
27659 | 206363 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 136 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 5992358.97952 | 2095954.25785 | 37.7346520835226 | -122.468852706414 | (37.7346520835226, -122.468852706414) | 9 | 8 | 4 | 59 | 40 | |||
27989 | 248699 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 839 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998645.80739 | 2107339.54148 | 37.7662744931923 | -122.447936542246 | (37.7662744931923, -122.447936542246) | 15 | 5 | 11 | 29492 | 9 | |||
28361 | 5082 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2563 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002286.6614 | 2096942.37452 | 37.7379337860994 | -122.434600024386 | (37.7379337860994, -122.434600024386) | 2 | 7 | 5 | 63 | 7 | |||
28428 | 126195 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2315 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6000798.79511 | 2116331.19704 | 37.7910861220794 | -122.441134960611 | (37.7910861220794, -122.441134960611) | 13 | 6 | 1 | 29490 | 27 | |||
28434 | 248681 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 325 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6004375.69481 | 2100128.24838 | 37.7467998370462 | -122.427604122635 | (37.7467998370462, -122.427604122635) | 2 | 7 | 5 | 63 | 22 | |||
28594 | 2069 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 843 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001701.03191 | 2095490.91331 | 37.7339151466682 | -122.436520970873 | (37.7339151466682, -122.436520970873) | 9 | 7 | 5 | 63 | 40 | |||
28699 | 40132 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 697 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1999 12:00:00 AM | Permit Number 41337 | 6008515.22056385 | 2095655.65791493 | 37.7347523629036 | -122.412973810281 | (37.7347523629036, -122.412973810281) | 10 | 7 | 7 | 28859 | 2 | |||
29045 | 54788 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 266 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 17 | Permit Number 10637 | 6012648.47164 | 2087248.62221 | 37.7118995001448 | -122.398094045129 | (37.7118995001448, -122.398094045129) | 10 | 3 | 8 | 309 | 1 | ||
29128 | 16829 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2185 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6000864.446233 | 2113095.7481361 | 37.7822061539958 | -122.440675636453 | (37.7822061539958, -122.440675636453) | 15 | 5 | 11 | 29490 | 41 | |||
29258 | 100577 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1201 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5982377.2 | 2106858.6 | 37.7640106245379 | -122.504169987001 | (37.7640106245379, -122.504169987001) | 1 | 8 | 3 | 56 | 35 | |||
29506 | 33680 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37760 | 6005344.46198727 | 2111116.85391927 | 37.7770266994083 | -122.425035932953 | (37.7770266994083, -122.425035932953) | 7 | 9 | 11 | 28852 | 10 | ||
29621 | 222097 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 473 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003000.51199 | 2105495.76492 | 37.7614598817955 | -122.432742735504 | (37.7614598817955, -122.432742735504) | 15 | 4 | 5 | 28862 | 3 | |||
29844 | 53048 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 65@ APPLETON Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2006 12:00:00 AM | Permit Number 49026 | 6005683.68607987 | 2097324.15915168 | 37.7391743410359 | -122.422881952522 | (37.7391743410359, -122.422881952522) | 2 | 7 | 7 | 28859 | 2 | |||
29861 | 248698 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 833 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998642.47639 | 2107361.06094 | 37.7663333897933 | -122.447949612988 | (37.7663333897933, -122.447949612988) | 15 | 5 | 11 | 29492 | 9 | |||
29918 | 248823 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 179 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007303.73593 | 2098009.03207 | 37.7411461284786 | -122.417329058008 | (37.7411461284786, -122.417329058008) | 2 | 7 | 7 | 28859 | 2 | |||
30283 | 94848 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 55X Heron St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53927 | 6009970 | 2109980 | 37.7741653653004 | -122.408954458449 | (37.7741653653004, -122.408954458449) | 8 | 2 | 9 | 28853 | 34 | |
30405 | 189433 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 301 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016822.99867 | 2097792.72493 | 37.7410831705501 | -122.384399488272 | (37.7410831705501, -122.384399488272) | 10 | 3 | 8 | 58 | 1 | |||
30445 | 248753 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 955 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007616.90844 | 2104099.62454 | 37.7578871360994 | -122.416677581009 | (37.7578871360994, -122.416677581009) | 2 | 4 | 7 | 28859 | 19 | |||
30760 | 12633 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 901 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 5992608.24045 | 2114791.4731 | 37.7863885262578 | -122.469361619855 | (37.7863885262578, -122.469361619855) | 11 | 6 | 2 | 54 | 11 | |||
30991 | 183274 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1243 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5983025.1929 | 2106638.7454 | 37.7634450534429 | -122.50191253924 | (37.7634450534429, -122.50191253924) | 1 | 8 | 3 | 56 | 35 | |||
31073 | 248785 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 451 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002208.61184 | 2101471.13901 | 37.7503642811001 | -122.435193711819 | (37.7503642811001, -122.435193711819) | 2 | 4 | 5 | 28862 | 22 | |||
31664 | 115699 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 2840 LAKE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x15 | 5986626 | 2114487 | 37.785205010982 | -122.490035970437 | (37.785205010982, -122.490035970437) | 11 | 6 | 1 | 55 | 33 | ||||
32152 | 56296 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 153 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1973 12:00:00 AM | 19 | Permit Number 12428 | 5993949.48549 | 2114460.3201 | 37.7855566873358 | -122.464697232751 | (37.7855566873358, -122.464697232751) | 11 | 6 | 2 | 54 | 11 | ||
32181 | 248898 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 4330 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6001712.82144 | 2101195.45283 | 37.7495791459828 | -122.436888452739 | (37.7495791459828, -122.436888452739) | 2 | 4 | 5 | 28862 | 22 | |||
32404 | 248827 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 213 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007154.16839 | 2097734.34433 | 37.7403834809037 | -122.417826743732 | (37.7403834809037, -122.417826743732) | 2 | 7 | 7 | 28859 | 2 | |||
32440 | 201455 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Catalina St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6018178.0225 | 2096034.88004 | 37.7363313120402 | -122.379592166743 | (37.7363313120402, -122.379592166743) | 10 | 3 | 8 | 58 | 1 | |||
32581 | 212070 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 85 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 6ft | 5994305.10268 | 2097598.14525 | 37.7392780342424 | -122.462243534727 | (37.7392780342424, -122.462243534727) | 1 | 8 | 4 | 59 | 40 | |||
32650 | 126192 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2546 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 4ft | 6001970.71981 | 2116718.3057 | 37.7922157056542 | -122.437107876546 | (37.7922157056542, -122.437107876546) | 13 | 6 | 1 | 29490 | 27 | |||
32688 | 248685 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 630 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998697.21442 | 2105503.72681 | 37.7612367456105 | -122.447626571109 | (37.7612367456105, -122.447626571109) | 15 | 5 | 11 | 29492 | 12 | |||
32700 | 248638 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 77 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6005405.81973 | 2103265.52882 | 37.7554722981298 | -122.424265139522 | (37.7554722981298, -122.424265139522) | 2 | 4 | 5 | 28859 | 19 | |||
32983 | 38841 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1817 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 40670 | 6005665.65244341 | 2115853.93139831 | 37.7900516844756 | -122.42426182602 | (37.7900516844756, -122.42426182602) | 13 | 9 | 1 | 28858 | 41 | ||||
32986 | 251533 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1201X Pierce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6002292 | 2112799 | 37.7814725496882 | -122.435715710029 | (37.7814725496882, -122.435715710029) | 15 | 5 | 11 | 29490 | 41 | ||||
33019 | 212055 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 55 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 6ft | 5993982.62743 | 2097474.6766 | 37.7389204467323 | -122.463349544345 | (37.7389204467323, -122.463349544345) | 1 | 8 | 4 | 59 | 40 | |||
33171 | 33502 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 155 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | Permit Number 37596 | 6006575.63931047 | 2098797.68147059 | 37.7432705917121 | -122.419902509091 | (37.7432705917121, -122.419902509091) | 2 | 7 | 7 | 28859 | 2 | ||
33180 | 37143 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2155 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Permit Number 39724 | 6003778.52248 | 2115919.83113 | 37.7901258907459 | -122.430795841768 | (37.7901258907459, -122.430795841768) | 13 | 9 | 1 | 29490 | 27 | |||
33481 | 113160 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 256 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6009932.6 | 2099477 | 37.7453244036246 | -122.408342866431 | (37.7453244036246, -122.408342866431) | 2 | 7 | 7 | 28859 | 2 | |||
33780 | 12632 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 900 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5992668.91715 | 2114851.34382 | 37.7865564209787 | -122.469156054781 | (37.7865564209787, -122.469156054781) | 11 | 6 | 1 | 54 | 11 | |||
33937 | 248728 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2200 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008109.15568 | 2105563.16428 | 37.7619333532611 | -122.41507876989 | (37.7619333532611, -122.41507876989) | 2 | 4 | 7 | 28859 | 19 | |||
33952 | 212068 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 65 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 6ft | 5994349.34377 | 2097659.88165 | 37.7394500943456 | -122.462095045855 | (37.7394500943456, -122.462095045855) | 1 | 8 | 4 | 59 | 40 | |||
34008 | 32073 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 3254 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Permit Number 35447 | 5999189.55674 | 2115674.61094 | 37.7891915158244 | -122.446655586587 | (37.7891915158244, -122.446655586587) | 13 | 6 | 1 | 29490 | 31 |
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) );