Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114819 | 114819 | 115563 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 600x JUNIPERO SERRA BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 40 | 3x3 | 5991349.0 | 2093478.0 | 37.7277944993603 | -122.47216407308998 | (37.7277944993603, -122.47216407309) | |||
115225 | 115225 | 99164 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 48 | Median : Cutout 11 | Tree 1 | Private 1 | 24 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
115321 | 115321 | 99126 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 9 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
115393 | 115393 | 99134 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 17 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
115847 | 115847 | 23311 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 11/18/2010 12:00:00 AM | 6 | 3X3 | 6006537.8278087005 | 2113902.4302931 | 37.7847425526754 | -122.421105541385 | (37.7847425526754, -122.421105541385) | ||
116259 | 116259 | 122587 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 45 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
116269 | 116269 | 96365 | Undocumented 2 | Tree(s) :: 17 | 2017 Grant Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767883 | 6010284.4 | 2121422.5 | 37.805601328212795 | -122.408674274121 | (37.8056013282128, -122.408674274121) | |
117015 | 117015 | 97487 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
117426 | 117426 | 106344 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2428 14th Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 3x3 | 5992079.0 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | |||
118159 | 118159 | 99144 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 27 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
118496 | 118496 | 99484 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |||
118992 | 118992 | 114058 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 58 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
119431 | 119431 | 99122 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
119712 | 119712 | 122589 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2500X Lyon St | 9 | Median : Cutout 11 | Tree 1 | Private 1 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
119791 | 119791 | 99453 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |||
120095 | 120095 | 99457 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 550X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
120510 | 120510 | 97485 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 500X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
120664 | 120664 | 99135 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 302X Pacheco St | 18 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
121555 | 121555 | 99465 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 550X Miramar Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
122205 | 122205 | 99146 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 30 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
122644 | 122644 | 110235 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2346x CASTRO ST | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 6002664.5 | 2098664.4 | 37.742683511585206 | -122.43341667357402 | (37.7426835115852, -122.433416673574) | ||||
122780 | 122780 | 99495 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Plymouth Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 5995903.0 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | |||||
123808 | 123808 | 99468 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |||
124400 | 124400 | 105235 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 182X LOWER TER | 27 | Median : Cutout 11 | Tree 1 | Private 1 | 24 | 200x30 | 6000081.0 | 2106216.0 | 37.763271458828704 | -122.442891809215 | (37.7632714588287, -122.442891809215) | |||
124634 | 124634 | 99132 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 15 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
125523 | 125523 | 106883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 4 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
125989 | 125989 | 87027 | Permitted Site 1 | Pinus muricata :: Bishop Pine 302 | 23 Magellan Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | Permit Number 49971 | 5994623.4 | 2101166.9 | 37.74909526366879 | -122.461401658799 | (37.7490952636688, -122.461401658799) | |||
126256 | 126256 | 97490 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 500X Miramar Ave | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 12 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
126291 | 126291 | 99460 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 550X Miramar Ave | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
126354 | 126354 | 114055 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 50 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
126415 | 126415 | 99483 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |||
127626 | 127626 | 97493 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Miramar Ave | 9 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |||
127755 | 127755 | 83007 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 1058 De Haro St | 1 | Median : Cutout 11 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52381 | 6012170.46860809 | 2103464.70975517 | 37.7563988530014 | -122.40088475581499 | (37.7563988530014, -122.400884755815) | ||
127993 | 127993 | 122585 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
128319 | 128319 | 99451 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 400X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |||
128399 | 128399 | 99493 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |||
128652 | 128652 | 99121 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
128765 | 128765 | 99475 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 650X Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 44 | 15x280 | Permit Number 772553 | 5995425.4 | 2093662.3 | 37.728535605791 | -122.45808530293199 | (37.728535605791, -122.458085302932) | |
128923 | 128923 | 92212 | Permitted Site 1 | Tree(s) :: 17 | 300x Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
129106 | 129106 | 99131 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 14 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
138468 | 138468 | 99139 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 22 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
138905 | 138905 | 99128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 11 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
139081 | 139081 | 92211 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 12/29/2010 12:00:00 AM | 2x2 | Permit Number 54064 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
139244 | 139244 | 99492 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |||
139369 | 139369 | 97491 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500X Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 30 | 15x280 | Permit Number 768370 | 5995423.2 | 2092691.6 | 37.7258701708071 | -122.45802268806801 | (37.7258701708071, -122.458022688068) | |
139448 | 139448 | 99461 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 550X Miramar Ave | 8 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
140517 | 140517 | 86969 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
141106 | 141106 | 99467 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 6 | 15x280 | 5995435.2 | 2093399.0 | 37.727813210556704 | -122.458032376835 | (37.7278132105567, -122.458032376835) | |||
141458 | 141458 | 99133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 16 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
141756 | 141756 | 99152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 36 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
142086 | 142086 | 110077 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4099x ALEMANY BLVD | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5991599.0 | 2086829.0 | 37.7095524384103 | -122.470815701049 | (37.7095524384103, -122.470815701049) | |||||
142441 | 142441 | 99120 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 302X Pacheco St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
142707 | 142707 | 99458 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 550X Miramar Ave | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995413.0 | 2092983.7 | 37.7266716211667 | -122.45807907885799 | (37.7266716211667, -122.458079078858) | |||
142725 | 142725 | 112581 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 274X SAN MARCOS AVE | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 3x20 | 5993121.0 | 2100271.0 | 37.7465487656332 | -122.46653182115801 | (37.7465487656332, -122.466531821158) | ||||
142943 | 142943 | 114059 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 38 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
143403 | 143403 | 122586 | Undocumented 2 | Prunus spp :: Cherry 84 | 2500X Lyon St | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 12 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
144189 | 144189 | 106345 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2428 14th Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 04/18/2014 12:00:00 AM | 3x3 | 5992079.0 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | |||
145354 | 145354 | 99455 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 400X Miramar Ave | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 15x280 | 5995388.7 | 2092398.7 | 37.7250639553871 | -122.45812076272101 | (37.7250639553871, -122.458120762721) | |||
145757 | 145757 | 99163 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 47 | Median : Cutout 11 | Tree 1 | Private 1 | 18 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
145855 | 145855 | 122584 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2500X Lyon St | 4 | Median : Cutout 11 | Tree 1 | Private 1 | 11 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
146162 | 146162 | 114057 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 700X LAKE MERCED BLVD | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 46 | 5987837.0 | 2092819.0 | 37.7257811856502 | -122.484256664993 | (37.7257811856502, -122.484256664993) | ||||
213 | 213 | 28640 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 20 | 6003714.7015 | 2113244.5448 | 37.782776612799296 | -122.430825656777 | (37.7827766127993, -122.430825656777) | ||
215 | 215 | 17196 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2235X Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 6004629.787409999 | 2116932.39582 | 37.792954330542 | -122.42792271466601 | (37.792954330542, -122.427922714666) | |||
223 | 223 | 23789 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003791.7059 | 2112684.1999 | 37.7812424081927 | -122.43051925893299 | (37.7812424081927, -122.430519258933) | |||
248 | 248 | 23733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 20 | 6003923.026000001 | 2111743.9893 | 37.7786682616238 | -122.429997867276 | (37.7786682616238, -122.429997867276) | |||
497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
503 | 503 | 8533 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6001504.6387 | 2113566.4305 | 37.783534963845 | -122.43849459602801 | (37.783534963845, -122.438494596028) | |||
605 | 605 | 23903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | |||
656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
727 | 727 | 221435 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:58:00 AM | 1 | Width 3ft | 6005438.10251 | 2108158.21074 | 37.768908269319795 | -122.424501499347 | (37.7689082693198, -122.424501499347) | ||
733 | 733 | 221433 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:32:00 AM | 1 | Width 3ft | 6005435.4614 | 2108218.9893400003 | 37.7690750036386 | -122.42451495861201 | (37.7690750036386, -122.424514958612) | ||
737 | 737 | 221436 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:05:00 AM | 1 | Width 3ft | 6005440.21619 | 2108132.10005 | 37.768836694985396 | -122.424492330751 | (37.7688366949854, -122.424492330751) | ||
745 | 745 | 221429 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:39:00 AM | 1 | Width 3ft | 6005428.96653 | 2108339.30361 | 37.76940499098671 | -122.424545983407 | (37.7694049909867, -122.424545983407) | ||
754 | 754 | 221432 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:53:00 AM | 1 | Width 3ft | 6005434.00046 | 2108253.10785 | 37.769168602384205 | -122.42452243915301 | (37.7691686023842, -122.424522439153) | ||
759 | 759 | 221434 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:56:00 AM | 1 | Width 3ft | 6005437.11129 | 2108190.56795 | 37.7689970584876 | -122.42450722982001 | (37.7689970584876, -122.42450722982) | ||
766 | 766 | 221431 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:43:00 AM | 1 | Width 3ft | 6005433.2519 | 2108280.1340799998 | 37.769242767658 | -122.424526951068 | (37.769242767658, -122.424526951068) | ||
772 | 772 | 221430 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:19:00 AM | 1 | Width 3ft | 6005430.67341 | 2108312.23866 | 37.7693307735195 | -122.424538153922 | (37.7693307735195, -122.424538153922) | ||
773 | 773 | 221437 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 06:48:00 AM | 1 | Width 3ft | 6005441.98545 | 2108105.3361400003 | 37.7687633076137 | -122.424484307027 | (37.7687633076137, -122.424484307027) | ||
787 | 787 | 221428 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 100x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/15/2016 05:47:00 AM | 1 | Width 3ft | 6005427.7802 | 2108362.05998 | 37.769467407522896 | -122.424551705821 | (37.7694674075229, -122.424551705821) | ||
815 | 815 | 8534 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1994 12:00:00 AM | 6 | 6 | 6001381.7916 | 2113512.2830000003 | 37.78337929999999 | -122.43891571692801 | (37.7833793, -122.438915716928) | ||
828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
890 | 890 | 23729 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 800X Webster St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003943.6522 | 2111620.2321 | 37.7783296231018 | -122.42991768322901 | (37.7783296231018, -122.429917683229) | ||
1116 | 1116 | 8576 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2200 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 6 | 6001010.5429 | 2113459.32 | 37.7832127479531 | -122.440196288881 | (37.7832127479531, -122.440196288881) | |||
1149 | 1149 | 19194 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150 Sanchez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003510.8594 | 2107438.4604 | 37.7668229855288 | -122.43111632094801 | (37.7668229855288, -122.431116320948) | |||
1183 | 1183 | 119797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1185 | 1185 | 119832 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1189 | 1189 | 119798 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1191 | 1191 | 119838 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1196 | 1196 | 119750 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1199 | 1199 | 119799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1201 | 1201 | 119839 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1203 | 1203 | 119796 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1206 | 1206 | 119801 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1208 | 1208 | 119803 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");