trees
27,746 rows where qCaretaker_id = 1 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6088 | 258369 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 998 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007899.48346 | 2093470.38454 | 37.7287174922185 | -122.414948012993 | (37.7287174922185, -122.414948012993) | 9 | 3 | 7 | 309 | 28 | |||
157338 | 13860 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 998 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6009623.0562505 | 2112946.0496627 | 37.7822899983627 | -122.410364073822 | (37.7822899983627, -122.410364073822) | 14 | 2 | 9 | 28852 | 36 | |||
77489 | 10156 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 998 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6005679.7391 | 2103202.59116 | 37.7553149491356 | -122.423313367215 | (37.7553149491356, -122.423313367215) | 2 | 4 | 5 | 28859 | 19 | |||
58926 | 5867 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 998 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/1997 12:00:00 AM | 3 | 3X3 | 6005664.38993 | 2113122.17635 | 37.782550891124 | -122.424071844531 | (37.782550891124, -122.424071844531) | 7 | 9 | 11 | 28858 | 41 | ||
172587 | 5866 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 998 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 3 | 3X3 | 6005664.38993 | 2113122.17635 | 37.782550891124 | -122.424071844531 | (37.782550891124, -122.424071844531) | 7 | 9 | 11 | 28858 | 41 | ||
126440 | 95163 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 998 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001491.8688 | 2111772.0851 | 37.7786074207661 | -122.438410176931 | (37.7786074207661, -122.438410176931) | 15 | 5 | 11 | 29490 | 41 | |
29558 | 5562 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 997 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768456 | 6005129.17531 | 2102577.95802 | 37.7535687642998 | -122.425172939503 | (37.7535687642998, -122.425172939503) | 2 | 4 | 5 | 28859 | 19 | |
33002 | 7862 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 995X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.422728012058 | (37.7835590051167, -122.422728012058) | 7 | 9 | 11 | 28858 | 41 | |||
37014 | 7863 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 995X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.422728012058 | (37.7835590051167, -122.422728012058) | 7 | 9 | 11 | 28858 | 41 | |||
42261 | 7861 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 995X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 6 | 4x4 | 6006060.20594 | 2113481.194 | 37.7835590051167 | -122.422728012058 | (37.7835590051167, -122.422728012058) | 7 | 9 | 11 | 28858 | 41 | ||
7560 | 13858 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 995 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/1990 12:00:00 AM | 35 | 4X4 | 6009732.8033 | 2112958.8474 | 37.7823312894321 | -122.409985299939 | (37.7823312894321, -122.409985299939) | 14 | 2 | 9 | 28853 | 34 | ||
109018 | 13859 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 995 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6009742.5413 | 2112949.1095 | 37.7823050972444 | -122.409950922983 | (37.7823050972444, -122.409950922983) | 14 | 2 | 9 | 28853 | 34 | |||
425 | 10157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x7 | 6005745.76106 | 2103227.37374 | 37.7553867222415 | -122.423086804612 | (37.7553867222415, -122.423086804612) | 2 | 4 | 5 | 28859 | 19 | |||
79322 | 25364 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000636.2417 | 2088870.05563 | 37.7156752201082 | -122.43972775363 | (37.7156752201082, -122.43972775363) | 9 | 7 | 6 | 28861 | 5 | |||
27485 | 173729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
192871 | 173728 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 8 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
54540 | 13856 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 991 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6009733.8299349 | 2112955.195175 | 37.7823213188284 | -122.409981490315 | (37.7823213188284, -122.409981490315) | 14 | 2 | 9 | 28853 | 34 | |||
68947 | 13857 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 991 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4X4 | 6009733.8299349 | 2112955.195175 | 37.7823213188284 | -122.409981490315 | (37.7823213188284, -122.409981490315) | 14 | 2 | 9 | 28853 | 34 | ||
149211 | 20131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 990X Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003129.07268 | 2110685.22533 | 37.7757161626447 | -122.432668806584 | (37.7757161626447, -122.432668806584) | 15 | 9 | 11 | 29492 | 10 | ||
34275 | 25053 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 990X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | 2 | 4 | 5 | 28862 | 22 | ||
37730 | 25055 | DPW Maintained 1 | Brahea edulis :: Guadalupe Palm 218 | 990X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | 2 | 4 | 5 | 28862 | 22 | |||
158030 | 27482 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 990X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | 2 | 4 | 5 | 28862 | 22 | ||
163406 | 85562 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018144.213614 | 2092843.516343 | 37.7275665867834 | -122.379487431767 | (37.7275665867834, -122.379487431767) | 10 | 3 | 8 | 58 | 1 | ||
188775 | 85561 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 990 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018144.213614 | 2092843.516343 | 37.7275665867834 | -122.379487431767 | (37.7275665867834, -122.379487431767) | 10 | 3 | 8 | 58 | 1 | ||
119848 | 13854 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 990 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/1995 12:00:00 AM | 12 | 4x4 | 6009687.490187 | 2113021.5868707 | 37.7825010173778 | -122.410146494728 | (37.7825010173778, -122.410146494728) | 14 | 2 | 9 | 28852 | 36 | ||
163687 | 8144 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 990 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6003074.2562 | 2111370.9925 | 37.7775960000162 | -122.432907433505 | (37.7775960000162, -122.432907433505) | 15 | 9 | 11 | 29492 | 41 | |||
38416 | 93248 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
87561 | 93246 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
122662 | 93247 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
156552 | 93245 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
103215 | 3751 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 990 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.7560772927341 | -122.399959384248 | (37.7560772927341, -122.399959384248) | 10 | 3 | 8 | 28856 | 29 | |||
19843 | 23974 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99 West Portal Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5993014.5056 | 2097814.877 | 37.7397987281257 | -122.466721556006 | (37.7397987281257, -122.466721556006) | 1 | 8 | 4 | 59 | 40 | |||
48934 | 23972 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5993001.2031 | 2097804.4048 | 37.7397692063869 | -122.466766788992 | (37.7397692063869, -122.466766788992) | 1 | 8 | 4 | 59 | 40 | |||
164489 | 23973 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 99 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5993007.7128 | 2097807.2351 | 37.7397773533681 | -122.466744487082 | (37.7397773533681, -122.466744487082) | 1 | 8 | 4 | 59 | 40 | |||
23030 | 135979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.7882275541095 | -122.419939904112 | (37.7882275541095, -122.419939904112) | 13 | 9 | 10 | 28858 | 21 | ||
60351 | 135978 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.7882128537759 | -122.420019889812 | (37.7882128537759, -122.420019889812) | 13 | 9 | 10 | 28858 | 21 | ||
20607 | 123755 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | 5995425.06371 | 2110766.64717 | 37.7754998049095 | -122.459324614731 | (37.7754998049095, -122.459324614731) | 11 | 6 | 2 | 54 | 11 | |||
75705 | 123754 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 5995442.56449 | 2110764.47311 | 37.7754948416879 | -122.459263918278 | (37.7754948416879, -122.459263918278) | 11 | 6 | 2 | 54 | 11 | |||
98015 | 123756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 4 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 16 | Width 4ft | 5995405.24475 | 2110764.0495 | 37.7754915329037 | -122.459392984631 | (37.7754915329037, -122.459392984631) | 11 | 6 | 2 | 54 | 11 | |||
113228 | 123753 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 99 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 4ft | 5995463.5723 | 2110766.04178 | 37.7755003566036 | -122.459191361341 | (37.7755003566036, -122.459191361341) | 11 | 6 | 2 | 54 | 11 | |||
20089 | 10729 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Ardath Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.5110714 | 2095183.8764266 | 37.7339566260964 | -122.381913486724 | (37.7339566260964, -122.381913486724) | 10 | 3 | 8 | 58 | 1 | ||
144838 | 196944 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 99 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6007258.22618 | 2109464.26228 | 37.7725969960897 | -122.418298412965 | (37.7725969960897, -122.418298412965) | 8 | 2 | 9 | 28853 | 19 | |||
48391 | 102422 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 99 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4x4 | 6010101 | 2112468 | 37.7810041676544 | -122.408676858386 | (37.7810041676544, -122.408676858386) | 14 | 2 | 9 | 28853 | 34 | |||
120179 | 102423 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 99 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4x4 | 6010101 | 2112468 | 37.7810041676544 | -122.408676858386 | (37.7810041676544, -122.408676858386) | 14 | 2 | 9 | 28853 | 34 | |||
1202 | 254563 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 98x High St | 1 | unknown : Yard | Tree | DPW 1 | 3x3 | 5999731 | 2100707 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | 2 | 4 | 5 | 63 | 22 | ||||
2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
15847 | 259635 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
122841 | 258453 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 98x 12th St | 4 | Median : Cutout | Tree | DPW 1 | Width 3ft | 6007064.67073 | 2109775.44951 | 37.7734405448826 | -122.41899001857 | (37.7734405448826, -122.41899001857) | 8 | 2 | 9 | 28853 | 19 | ||||
174742 | 258452 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 98x 12th St | 3 | Median : Cutout | Tree | DPW 1 | Width 3ft | 6007064.67073 | 2109775.44951 | 37.7734405448826 | -122.41899001857 | (37.7734405448826, -122.41899001857) | 8 | 2 | 9 | 28853 | 19 | ||||
72518 | 105133 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 98X WINFIELD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007331 | 2099216 | 37.7444617271859 | -122.417320300114 | (37.7444617271859, -122.417320300114) | 2 | 7 | 7 | 28859 | 2 | |||
133348 | 105134 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 98X WINFIELD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | Neighbor said they are not going to replant trees because ther eis no one to take care of them | 6007331 | 2099216 | 37.7444617271859 | -122.417320300114 | (37.7444617271859, -122.417320300114) | 2 | 7 | 7 | 28859 | 2 | ||
53526 | 23607 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
73356 | 23610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
86278 | 23605 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
143584 | 23609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
177886 | 23608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
182892 | 23611 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
193092 | 23606 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98X Vega St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999213.8529577 | 2112334.5164276 | 37.7800218746026 | -122.446331149287 | (37.7800218746026, -122.446331149287) | 15 | 5 | 1 | 54 | 16 | |||
35864 | 17319 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006649.48331 | 2109199.16396 | 37.7718348142851 | -122.420385302261 | (37.7718348142851, -122.420385302261) | 8 | 2 | 9 | 28853 | 19 | |||
39323 | 17318 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006649.48331 | 2109199.16396 | 37.7718348142851 | -122.420385302261 | (37.7718348142851, -122.420385302261) | 8 | 2 | 9 | 28853 | 19 | |||
109043 | 103832 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
122072 | 103833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
133115 | 103831 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
138328 | 25209 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 98X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/2014 12:00:00 AM | 3 | 3x3 | 6006534 | 2110441 | 37.775238090111 | -122.420872949151 | (37.775238090111, -122.420872949151) | 7 | 9 | 11 | 28852 | 10 | ||
24117 | 27426 | DPW Maintained 1 | Tree(s) :: 17 | 98X Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2012 12:00:00 AM | 1 | 3x3 | 6006094.6477071 | 2108521.7458746 | 37.7699435048383 | -122.422256382252 | (37.7699435048383, -122.422256382252) | 8 | 4 | 7 | 28853 | 19 | ||
21275 | 13852 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
24010 | 13853 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 989 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
61106 | 13850 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 989 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
132804 | 13847 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 989 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4X4 | 6009762.991 | 2112988.0614 | 37.7824131960024 | -122.409882926294 | (37.7824131960024, -122.409882926294) | 14 | 2 | 9 | 28853 | 34 | |||
158342 | 13849 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 989 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
166567 | 13851 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2004 12:00:00 AM | 6 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | ||
174587 | 13848 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 989 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6009772.729 | 2112975.402 | 37.7823789820398 | -122.409848343044 | (37.7823789820398, -122.409848343044) | 14 | 2 | 9 | 28853 | 34 | |||
39280 | 247443 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 988 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/2015 11:46:00 AM | 20 | Width 0ft | 6002297.3139 | 2109877.1332 | 37.7734501371932 | -122.43548824232 | (37.7734501371932, -122.43548824232) | 15 | 5 | 11 | 29492 | 10 | ||
139652 | 17005 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 988 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/05/2015 11:46:00 AM | 3 | 3X3 | 6002274.9132 | 2109899.1296 | 37.7735092615764 | -122.435567303378 | (37.7735092615764, -122.435567303378) | 15 | 5 | 11 | 29492 | 10 | ||
79096 | 13845 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 988 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6009746.4364 | 2113096.1529 | 37.7827090617985 | -122.40994783109 | (37.7827090617985, -122.40994783109) | 14 | 2 | 9 | 28852 | 36 | |||
163499 | 13846 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 988 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6009730.4123 | 2113083.3933 | 37.7826731288826 | -122.410002366849 | (37.7826731288826, -122.410002366849) | 14 | 2 | 9 | 28852 | 36 | |||
2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
110211 | 252861 | DPW Maintained 1 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |
90032 | 10155 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 988 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005676.86794 | 2103220.79798 | 37.7553647787894 | -122.423324590769 | (37.7553647787894, -122.423324590769) | 2 | 4 | 5 | 28859 | 19 | |||
50450 | 27604 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003185.1314 | 2111389.5656 | 37.7776532852192 | -122.43252520607 | (37.7776532852192, -122.43252520607) | 15 | 9 | 11 | 29492 | 41 | |
56063 | 27606 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/09/2017 12:00:00 AM | 3 | 4X4 | Permit Number 780706 | 6003145.1713 | 2111385.063 | 37.7776386560762 | -122.432663119808 | (37.7776386560762, -122.432663119808) | 15 | 9 | 11 | 29492 | 41 | |
75623 | 27603 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6003200.8903 | 2111391.8168 | 37.7776603600919 | -122.432470851555 | (37.7776603600919, -122.432470851555) | 15 | 9 | 11 | 29492 | 41 | |||
182070 | 27605 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 988 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6003164.87 | 2111386.7515 | 37.7776444094038 | -122.432595096019 | (37.7776444094038, -122.432595096019) | 15 | 9 | 11 | 29492 | 41 | |||
177259 | 14765 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 987 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6004437.97734 | 2111858.52426 | 37.7790118963921 | -122.428224615869 | (37.7790118963921, -122.428224615869) | 7 | 9 | 11 | 29490 | 41 | |||
88197 | 5561 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 987 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005127.60414 | 2102608.85255 | 37.7536535047293 | -122.425180571123 | (37.7536535047293, -122.425180571123) | 2 | 4 | 5 | 28859 | 19 | |||
140454 | 91265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 986x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005700.008282 | 2103231.505425 | 37.7553954849101 | -122.423245325469 | (37.7553954849101, -122.423245325469) | 2 | 4 | 5 | 28859 | 19 | ||
134026 | 5560 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 986 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6005042.03687 | 2102621.31719 | 37.7536828954567 | -122.425477369008 | (37.7536828954567, -122.425477369008) | 2 | 4 | 5 | 28862 | 22 | |||
183075 | 17003 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | 15 | 5 | 11 | 29492 | 9 | |||
62081 | 93297 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 985 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004420 | 2103163 | 37.7551350639762 | -122.427667103261 | (37.7551350639762, -122.427667103261) | 2 | 4 | 5 | 28862 | 22 | ||
28099 | 13844 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 984 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6009734.6170855 | 2113066.6079832 | 37.7826272760546 | -122.409986634697 | (37.7826272760546, -122.409986634697) | 14 | 2 | 9 | 28852 | 36 | |||
142044 | 85758 | DPW Maintained 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 | 984 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011059 | 2111650 | 37.7788117396287 | -122.405305022469 | (37.7788117396287, -122.405305022469) | 14 | 2 | 9 | 28853 | 34 | ||
88665 | 5559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.7537630358578 | -122.425481873703 | (37.7537630358578, -122.425481873703) | 2 | 4 | 5 | 28862 | 22 | |||
167118 | 14763 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 983 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004471.7203 | 2111860.4178 | 37.7790190047533 | -122.428108020326 | (37.7790190047533, -122.428108020326) | 7 | 9 | 11 | 29490 | 41 | |||
19650 | 119 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 983 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6002320.92055 | 2107634.67153 | 37.7672942317745 | -122.435246153987 | (37.7672942317745, -122.435246153987) | 15 | 5 | 5 | 28862 | 3 | |||
144850 | 13843 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 982X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6009750.0747082 | 2113081.3749081 | 37.7826686888528 | -122.409934200489 | (37.7826686888528, -122.409934200489) | 14 | 2 | 9 | 28852 | 36 | |||
14797 | 264653 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 982 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:50:00 PM | 3x3 | 6014279.95597 | 2089795.48577 | 37.71898342396 | -122.39263318135 | (37.71898342396, -122.39263318135) | 10 | 3 | 8 | 58 | 1 | |||
77689 | 102432 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 982 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 4x4 | 6010557.78599 | 2112071.21552 | 37.7799402636687 | -122.407068625328 | (37.7799402636687, -122.407068625328) | 14 | 2 | 9 | 28853 | 34 | |||
115969 | 102431 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 982 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6010575.87494 | 2112088.03468 | 37.7799874573922 | -122.407007233096 | (37.7799874573922, -122.407007233096) | 14 | 2 | 9 | 28853 | 34 | |||
103838 | 23040 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 981 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/1994 12:00:00 AM | 6 | 3X3 | 6006351.67952 | 2103895.42013 | 37.7572551968739 | -122.421038782125 | (37.7572551968739, -122.421038782125) | 2 | 4 | 7 | 28859 | 19 | ||
94079 | 10152 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 981 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005742.33218 | 2103287.18966 | 37.7555507693625 | -122.423102914188 | (37.7555507693625, -122.423102914188) | 2 | 4 | 5 | 28859 | 19 |
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) );