trees
194,517 rows sorted by Fire Prevention Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
832 | 211486 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300 Junipero Serra Blvd | 17 | : | Tree | Private 2 | 56 | Width 0ft | 5991389.83684 | 2094502.84602 | 37.7306108333036 | -122.47209757005 | (37.7306108333036, -122.47209757005) | 9 | 8 | 4 | 64 | 40 | |||
840 | 1046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2009X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 12 | 4X4 | 6000674.20134 | 2090359.18139 | 37.7197661846273 | -122.439703245137 | (37.7197661846273, -122.439703245137) | 9 | 7 | 6 | 28861 | 25 | ||
851 | 175458 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1530 Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006357.8594 | 2092519.52911 | 37.72601990217 | -122.420210056863 | (37.72601990217, -122.420210056863) | 9 | 7 | 7 | 309 | 5 | |||
856 | 260411 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 10X Brotherhood Way | 2 | Side Yard : Yard | Tree | Private 2 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | ||||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
886 | 73449 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004263.46084 | 2092033.98232 | 37.7245684629353 | -122.427415688595 | (37.7245684629353, -122.427415688595) | 9 | 7 | 6 | 28861 | 5 | |||
902 | 213099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 48 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996420.67751 | 2095562.94637 | 37.733811460225 | -122.454781859719 | (37.733811460225, -122.454781859719) | 9 | 7 | 4 | 59 | 40 | |||
903 | 212156 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 Keystone Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 5994073.78533 | 2092644.48269 | 37.7256631735017 | -122.462684068539 | (37.7256631735017, -122.462684068539) | 9 | 8 | 4 | 59 | 40 | |||
930 | 73626 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 249 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994249.97744 | 2086699.51142 | 37.7093498474797 | -122.461644153659 | (37.7093498474797, -122.461644153659) | 9 | 8 | 6 | 28861 | 25 | |||
936 | 215389 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 83 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999561.07911 | 2095471.21433 | 37.7337392221924 | -122.443917999028 | (37.7337392221924, -122.443917999028) | 9 | 7 | 4 | 63 | 40 | ||||
937 | 95737 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 445 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | 9 | 7 | 6 | 28861 | 5 | |
943 | 103518 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5234 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770228 | 5999957.27012 | 2088737.63684 | 37.7152729578673 | -122.442065082634 | (37.7152729578673, -122.442065082634) | 9 | 7 | 6 | 28861 | 25 | |
944 | 211787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 145 Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994159.28368 | 2097331.60357 | 37.7385377797886 | -122.462728377219 | (37.7385377797886, -122.462728377219) | 9 | 8 | 4 | 59 | 40 | |||
950 | 72251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6001865.6588 | 2091176.05062 | 37.7220768687262 | -122.435643214558 | (37.7220768687262, -122.435643214558) | 9 | 7 | 6 | 28861 | 5 | |||
955 | 207211 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 351 Judson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5997557.05916 | 2093521.06587 | 37.7282700608095 | -122.450705899268 | (37.7282700608095, -122.450705899268) | 9 | 7 | 4 | 28861 | 40 | |||
967 | 78568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | 9 | 3 | 7 | 309 | 28 | |||
968 | 71603 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 171 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994523.67906 | 2086453.64687 | 37.7086905122192 | -122.460680397897 | (37.7086905122192, -122.460680397897) | 9 | 8 | 6 | 28861 | 25 | |||
976 | 258329 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 105 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5998052 | 2087327 | 37.7112909098977 | -122.448548966881 | (37.7112909098977, -122.448548966881) | 9 | 7 | 6 | 28861 | 25 | ||||
979 | 171867 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 825 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Width 3ft | 6009309.97305 | 2091452.93347 | 37.7232571551673 | -122.409929483882 | (37.7232571551673, -122.409929483882) | 9 | 3 | 7 | 309 | 28 | ||
997 | 42493 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 50 Phelan Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42614 | 5997102.28501 | 2092861.95301 | 37.7264342507672 | -122.452230525303 | (37.7264342507672, -122.452230525303) | 9 | 7 | 4 | 28861 | 40 | ||
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
1006 | 258081 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2019 03:01:00 PM | 3 | Width 2ft | 5995843.60881 | 2092100.29717 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | 9 | 7 | 4 | 28861 | 40 | ||
1021 | 213351 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 752 Head St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993534.80603 | 2090819.23886 | 37.7206204409725 | -122.464414798499 | (37.7206204409725, -122.464414798499) | 9 | 8 | 6 | 64 | 24 | |||
1026 | 209572 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100 Malta Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5999439.81114 | 2096263.84796 | 37.7359086891413 | -122.444394200825 | (37.7359086891413, -122.444394200825) | 9 | 7 | 4 | 63 | 40 | ||||
1031 | 203993 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Eastwood Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 5995660.26957 | 2093014.24924 | 37.7267697065318 | -122.457226490416 | (37.7267697065318, -122.457226490416) | 9 | 7 | 4 | 28861 | 40 | |||
1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
1052 | 65988 | Permitted Site 7 | Tree(s) :: 17 | 121 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1990 12:00:00 AM | Permit Number 29018 | 5995709.58889373 | 2096251.06183698 | 37.7356600432467 | -122.457290053496 | (37.7356600432467, -122.457290053496) | 9 | 7 | 4 | 59 | 40 | |||
1056 | 210964 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1 Pizarro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995081.73888 | 2093960.6107 | 37.7293349426397 | -122.459294943706 | (37.7293349426397, -122.459294943706) | 9 | 7 | 4 | 28861 | 40 | |||
1058 | 160441 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 201 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2019 12:00:00 AM | 3 | 4x6 | 6001628.58163 | 2090114.34641 | 37.7191481986061 | -122.436386782123 | (37.7191481986061, -122.436386782123) | 9 | 7 | 6 | 28861 | 5 | |
1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
1063 | 32734 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.7175397705127 | -122.458983271916 | (37.7175397705127, -122.458983271916) | 9 | 8 | 6 | 28861 | 24 | ||
1065 | 180355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 San Jose Ave | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999392.39561 | 2091826.25637 | 37.7237213933189 | -122.444239347485 | (37.7237213933189, -122.444239347485) | 9 | 7 | 6 | 28861 | 25 | |||
1075 | 209246 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 122 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001612.99048 | 2095459.00516 | 37.7338225308765 | -122.436823072927 | (37.7338225308765, -122.436823072927) | 9 | 7 | 5 | 63 | 40 | |||
1111 | 99485 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Miramar Ave | 6 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | 9 | 7 | 4 | 28861 | 40 | |||
1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 9 | 7 | 6 | 28861 | 5 | |||
1128 | 178845 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 Sawyer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007634.8415 | 2086934.39681 | 37.7107561785306 | -122.415400376427 | (37.7107561785306, -122.415400376427) | 9 | 7 | 8 | 309 | 39 | |||
1141 | 171735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1124 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 3x5 | 6007457.06473 | 2093337.1735 | 37.7283268529824 | -122.416468054284 | (37.7283268529824, -122.416468054284) | 9 | 3 | 7 | 309 | 5 | ||
1145 | 180443 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 599 University St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008502.54989 | 2091553.3243 | 37.7234875219066 | -122.412727694727 | (37.7234875219066, -122.412727694727) | 9 | 3 | 7 | 309 | 28 | |||
1152 | 259051 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 25 Baden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000711 | 2094308 | 37.7306108324003 | -122.439859019702 | (37.7306108324003, -122.439859019702) | 9 | 7 | 4 | 63 | 40 | ||||
1175 | 217424 | DPW Maintained 1 | Washingtonia filifera :: California Fan Palm 176 | 450 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5997245.21557 | 2095811.54229 | 37.7345413068394 | -122.451949128344 | (37.7345413068394, -122.451949128344) | 9 | 7 | 4 | 59 | 40 | |||
1182 | 922 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1253 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6002943.78693 | 2094101.1406 | 37.7301696879821 | -122.432125178253 | (37.7301696879821, -122.432125178253) | 9 | 7 | 6 | 28861 | 25 | |||
1194 | 213495 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 613 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994845.46831 | 2092391.05162 | 37.725011726204 | -122.45999808945 | (37.725011726204, -122.45999808945) | 9 | 8 | 4 | 28861 | 40 | |||
1200 | 216506 | DPW Maintained 1 | Quercus tomentella :: Island oak 178 | 900x Bosworth St | 13 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6001233.37936 | 2095653.14321 | 37.7343340068125 | -122.438149402085 | (37.7343340068125, -122.438149402085) | 9 | 7 | 5 | 63 | 40 | |||
1203 | 179432 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 122 Santos St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6006549.42501 | 2086808.72834 | 37.7103500527955 | -122.419142922204 | (37.7103500527955, -122.419142922204) | 9 | 7 | 8 | 309 | 39 | |||
1204 | 72270 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | 9 | 7 | 6 | 28861 | 5 | |||
1211 | 261654 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1150 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000820 | 2086851 | 37.7101418008042 | -122.43894799201 | (37.7101418008042, -122.43894799201) | 9 | 7 | 6 | 28861 | 5 | ||||
1214 | 44389 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 15 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/2001 12:00:00 AM | Permit Number 43749 | 6001647.0719332 | 2087964.37014378 | 37.7132458927569 | -122.436169094311 | (37.7132458927569, -122.436169094311) | 9 | 7 | 6 | 28861 | 5 | ||
1222 | 16326 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 789X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 3 | 3X3 | 5996873.6825 | 2094683.9462 | 37.7314239112697 | -122.45315226118 | (37.7314239112697, -122.45315226118) | 9 | 7 | 4 | 59 | 40 | ||
1225 | 70200 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 651 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002623.55844 | 2089844.48662 | 37.7184637093015 | -122.432928262055 | (37.7184637093015, -122.432928262055) | 9 | 7 | 6 | 28861 | 5 | |||
1231 | 15974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2016 12:00:00 AM | 3 | 3X3 | 5996593.31856 | 2086313.84227 | 37.7084254991124 | -122.453517403906 | (37.7084254991124, -122.453517403906) | 9 | 7 | 6 | 28861 | 5 | ||
1233 | 99298 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 50 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 4 | 3x3 | Permit Number 768888 | 6001844.05326 | 2092273.64854 | 37.7250893979513 | -122.435796391592 | (37.7250893979513, -122.435796391592) | 9 | 7 | 6 | 28861 | 25 | |
1245 | 213791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 209 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 768064 | 5995620.63174 | 2091343.81767 | 37.7221808240739 | -122.45724272857 | (37.7221808240739, -122.45724272857) | 9 | 8 | 4 | 28861 | 24 |
1246 | 160377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 824 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001767.32645 | 2089068.63157 | 37.7162847814869 | -122.435832414836 | (37.7162847814869, -122.435832414836) | 9 | 7 | 6 | 28861 | 5 | ||
1247 | 214916 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 13 | Width 2ft | Permit Number 32246 | 5993222.12997 | 2093186.27538 | 37.7271017173463 | -122.465667493867 | (37.7271017173463, -122.465667493867) | 9 | 8 | 4 | 59 | 40 | |
1269 | 262440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
1278 | 170724 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 540 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000352.85514 | 2092916.82872 | 37.7267706040626 | -122.440997412 | (37.7267706040626, -122.440997412) | 9 | 7 | 6 | 28861 | 25 | ||
1284 | 72257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 671 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6002561.32843 | 2089744.29585 | 37.7181850777589 | -122.433136210491 | (37.7181850777589, -122.433136210491) | 9 | 7 | 6 | 28861 | 5 | |||
1291 | 122854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3000X Alemany Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996671.62099 | 2087298.1542 | 37.7111326815096 | -122.453317797602 | (37.7111326815096, -122.453317797602) | 9 | 7 | 6 | 28861 | 25 | ||
1293 | 72151 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 209 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 22 | 6001102.51971 | 2093339.22374 | 37.7279730740759 | -122.438436097863 | (37.7279730740759, -122.438436097863) | 9 | 7 | 6 | 28861 | 25 | |||
1300 | 214130 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 459 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998397.60644 | 2095236.47729 | 37.7330282541307 | -122.447923556932 | (37.7330282541307, -122.447923556932) | 9 | 7 | 4 | 59 | 40 | |||
1306 | 78279 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 773 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6001349.14865 | 2092521.0021 | 37.7257404495571 | -122.437524926331 | (37.7257404495571, -122.437524926331) | 9 | 7 | 6 | 28861 | 25 | |||
1309 | 73822 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 118X Lowell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 5998761.76944 | 2087100.1867 | 37.7107086898252 | -122.44607953034 | (37.7107086898252, -122.44607953034) | 9 | 7 | 6 | 28861 | 5 | ||
1314 | 67685 | Permitted Site 7 | Tree(s) :: 17 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | Permit Number 31289 | 5997024.37469935 | 2095029.17182905 | 37.7323804536882 | -122.452656198743 | (37.7323804536882, -122.452656198743) | 9 | 7 | 4 | 59 | 40 | |||
1317 | 71329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 346 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6003746.38005 | 2089169.34853 | 37.7166735503194 | -122.428999024181 | (37.7166735503194, -122.428999024181) | 9 | 7 | 6 | 28861 | 5 | |||
1324 | 109608 | DPW Maintained 1 | Tree(s) :: 17 | 30 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781648 | 6000500.58572 | 2088469.85865 | 37.7145686465987 | -122.440167960077 | (37.7145686465987, -122.440167960077) | 9 | 7 | 6 | 28861 | 5 | |
1331 | 25415 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
1332 | 215594 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5994385 | 2087488 | 37.7115226229707 | -122.461234615187 | (37.7115226229707, -122.461234615187) | 9 | 8 | 6 | 28861 | 24 | |||
1338 | 261130 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 198 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003761.7429 | 2092753.33549 | 37.7265152577639 | -122.429201331188 | (37.7265152577639, -122.429201331188) | 9 | 7 | 6 | 28861 | 5 | ||
1339 | 73360 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 236 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6003402.60575 | 2092794.29016 | 37.72660737262 | -122.430445774353 | (37.72660737262, -122.430445774353) | 9 | 7 | 6 | 28861 | 5 | |||
1347 | 109892 | Permitted Site 7 | Tree(s) :: 17 | 205 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2015 12:00:00 AM | 3 | 3x6 | 5995308.1 | 2091295.6 | 37.7220304751495 | -122.458319579925 | (37.7220304751495, -122.458319579925) | 9 | 8 | 4 | 28861 | 24 | ||
1351 | 79811 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 514 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6003624.73165 | 2089487.21102 | 37.717539444554 | -122.429442157036 | (37.717539444554, -122.429442157036) | 9 | 7 | 6 | 28861 | 5 | |||
1357 | 54090 | Permitted Site 7 | Tree(s) :: 17 | 115 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1972 12:00:00 AM | Permit Number 9817 | 5991911.06498332 | 2095358.19732765 | 37.7329895631391 | -122.47035789011 | (37.7329895631391, -122.47035789011) | 9 | 8 | 4 | 59 | 40 | |||
1370 | 49770 | Permitted Site 7 | Olea Majestic Beauty :: 183 | 333 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46559 | 6008566.26332194 | 2086145.27295548 | 37.7086417136506 | -122.412125425298 | (37.7086417136506, -122.412125425298) | 9 | 7 | 8 | 309 | 39 | ||
1373 | 32746 | DPW Maintained 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 | 254 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 4 | Permit Number 37128 | 5994350.01319 | 2089345.90391 | 37.716621973312 | -122.461490145655 | (37.716621973312, -122.461490145655) | 9 | 8 | 6 | 28861 | 24 | |
1377 | 262327 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1403 | 77662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006681.78325 | 2093389.68756 | 37.7284274151839 | -122.419151965791 | (37.7284274151839, -122.419151965791) | 9 | 3 | 7 | 309 | 5 | ||
1406 | 75132 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002992.10347 | 2092540.72564 | 37.7258878789975 | -122.431846767938 | (37.7258878789975, -122.431846767938) | 9 | 7 | 6 | 28861 | 5 | ||
1407 | 177359 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 282 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003626.27943 | 2092029.25547 | 37.724519425612 | -122.429618004189 | (37.724519425612, -122.429618004189) | 9 | 7 | 6 | 28861 | 5 | |||
1409 | 178109 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 200 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6000643.20698 | 2087890.67148 | 37.7129864468306 | -122.439633507395 | (37.7129864468306, -122.439633507395) | 9 | 7 | 6 | 28861 | 5 | |||
1412 | 259415 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900x Geneva Ave | 4 | Median : Cutout | Tree | DPW 1 | 3x3 | 6000362 | 2089058 | 37.7161756595217 | -122.440689128694 | (37.7161756595217, -122.440689128694) | 9 | 7 | 6 | 28861 | 5 | ||||
1415 | 171287 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 339 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003711.94249 | 2092708.61039 | 37.7263896332495 | -122.429370301207 | (37.7263896332495, -122.429370301207) | 9 | 7 | 6 | 28861 | 5 | ||
1419 | 148015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002502.98722 | 2088786.72578 | 37.7155524923237 | -122.433269485517 | (37.7155524923237, -122.433269485517) | 9 | 7 | 6 | 28861 | 5 | |||
1424 | 264758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
1425 | 170341 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 56 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6001088.08008 | 2093656.24889 | 37.7288427310959 | -122.438508720824 | (37.7288427310959, -122.438508720824) | 9 | 7 | 6 | 28861 | 25 | ||
1430 | 67640 | Permitted Site 7 | Tree(s) :: 17 | 66 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1992 12:00:00 AM | Permit Number 31239 | 5999465.40351772 | 2088851.00886819 | 37.7155562089288 | -122.443773323232 | (37.7155562089288, -122.443773323232) | 9 | 7 | 6 | 28861 | 25 | |||
1437 | 109607 | DPW Maintained 1 | Shrub :: Shrub 66 | 775 Congo St | 1 | Front Yard : Yard | Landscaping | Private 2 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.441114705419 | (37.7350943222142, -122.441114705419) | 9 | 7 | 4 | 63 | 40 | |||||
1441 | 262458 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 236 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6002498 | 2094223 | 37.730479001636 | -122.433675025832 | (37.730479001636, -122.433675025832) | 9 | 7 | 5 | 28861 | 25 | ||
1448 | 178997 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 800 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001810.75276 | 2089136.90013 | 37.7164746985284 | -122.435687194116 | (37.7164746985284, -122.435687194116) | 9 | 7 | 6 | 28861 | 5 | |||
1455 | 176735 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1245 Bacon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007785.06482 | 2091940.88647 | 37.7245113883837 | -122.415235340041 | (37.7245113883837, -122.415235340041) | 9 | 3 | 7 | 309 | 28 | ||
1457 | 209974 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 634 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995417.8126 | 2093581.25052 | 37.7283126275124 | -122.458105669454 | (37.7283126275124, -122.458105669454) | 9 | 7 | 4 | 28861 | 40 | |||
1472 | 2091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2X2 | 6001433.65825 | 2095553.49813 | 37.7340717929056 | -122.437449841319 | (37.7340717929056, -122.437449841319) | 9 | 7 | 5 | 63 | 40 | ||
1473 | 170691 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 401X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000619.24687 | 2092677.737 | 37.7261292822292 | -122.440059368765 | (37.7261292822292, -122.440059368765) | 9 | 7 | 6 | 28861 | 25 | ||
1481 | 172310 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 63 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | Width 3ft | 6001999.53893 | 2087418.49495 | 37.7117670587831 | -122.434911834617 | (37.7117670587831, -122.434911834617) | 9 | 7 | 6 | 28861 | 5 | ||
1499 | 262277 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Lee Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996515 | 2091798 | 37.7234792274288 | -122.454183919247 | (37.7234792274288, -122.454183919247) | 9 | 8 | 4 | 28861 | 24 | ||||
1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
1523 | 260685 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 198X Miraloma Dr | 2 | Median : Yard | Tree | Private 2 | 10x10 | 5994595 | 2096392 | 37.7359829456919 | -122.461153801837 | (37.7359829456919, -122.461153801837) | 9 | 8 | 4 | 59 | 40 | ||||
1527 | 155727 | DPW Maintained 1 | Tree(s) :: 17 | 251 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787672 | 5993647.1889 | 2094105.14579 | 37.7296492188193 | -122.464264763718 | (37.7296492188193, -122.464264763718) | 9 | 8 | 4 | 59 | 40 | |
1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 |
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) );