trees
215 rows where qLegalStatus_id = 9 sorted by PlotSize
This data as json, CSV (advanced)
PlantType ✖
- Tree 112
- Landscaping 3
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10283 | 264747 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
10609 | 262014 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
10772 | 264676 | Private 9 | Cassia leptophylla :: Gold Medallion Tree 152 | 668 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | 3x3 | 6003797.75621 | 2110080.31484 | 37.7740931268852 | -122.430312496695 | (37.7740931268852, -122.430312496695) | 7 | 9 | 11 | 29492 | 10 | ||
11394 | 260246 | Private 9 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784595 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |
11563 | 259753 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1229 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6013525 | 2101361 | 37.7506979810533 | -122.396052856578 | (37.7506979810533, -122.396052856578) | 10 | 3 | 8 | 28856 | 1 | ||||
12794 | 262012 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
12902 | 262013 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
13028 | 264748 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
13426 | 260872 | Private 9 | Tree(s) :: 17 | 1736 Fitzgerald Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011805.50809 | 2092676.7551 | 37.7267570649137 | -122.401388810186 | (37.7267570649137, -122.401388810186) | 10 | 3 | 8 | 58 | 1 | |||
14046 | 262297 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 666 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009767 | 2091318 | 37.722912259595 | -122.408340109411 | (37.722912259595, -122.408340109411) | 9 | 3 | 7 | 309 | 28 | ||||
14848 | 260375 | Private 9 | Tree(s) :: 17 | 67 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784562 | 5999904.1409 | 2088281.96487 | 37.714018757491 | -122.442216028541 | (37.714018757491, -122.442216028541) | 9 | 7 | 6 | 28861 | 5 |
15590 | 260947 | Private 9 | Tree(s) :: 17 | 143 Gambier St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6005856 | 2093079 | 37.72752779603 | -122.421984681693 | (37.72752779603, -122.421984681693) | 9 | 7 | 7 | 309 | 5 | ||||
16349 | 259165 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
17012 | 262011 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
18909 | 262153 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
34779 | 104448 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
57138 | 104401 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 727 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999017 | 2108166 | 37.768564950056 | -122.44671213341 | (37.768564950056, -122.44671213341) | 15 | 5 | 11 | 29492 | 9 | ||||
64208 | 71505 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 328 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774557 | 6006691.32680411 | 2104197.11487977 | 37.7581027211657 | -122.419885554796 | (37.7581027211657, -122.419885554796) | 2 | 4 | 7 | 28859 | 19 | |
65512 | 108459 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | 11 | 6 | 2 | 54 | 11 | |||
68698 | 104451 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
91676 | 104449 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
99316 | 108440 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | ||||
107120 | 121090 | Private 9 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
108854 | 104446 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
110382 | 108170 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | 2 | 7 | 7 | 28859 | 2 | |
112431 | 104768 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 912 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6002431.1 | 2102873.8 | 37.7542282864134 | -122.434524613527 | (37.7542282864134, -122.434524613527) | 2 | 4 | 5 | 28862 | 22 | |||
137357 | 117353 | Private 9 | Pittosporum crassifolium :: Karo Tree 95 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.7710574836343 | -122.390397474374 | (37.7710574836343, -122.390397474374) | 14 | 3 | 9 | 310 | 20 | |||
141599 | 251417 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990003 | 2112517 | 37.7799925618685 | -122.478208632121 | (37.7799925618685, -122.478208632121) | 11 | 6 | 2 | 55 | 26 | ||||
142770 | 150735 | Private 9 | Cordyline australis :: Dracena Palm 64 | 783 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778950 | 6012760.80751 | 2103885.27159 | 37.7575865350131 | -122.398872659244 | (37.7575865350131, -122.398872659244) | 10 | 3 | 8 | 28856 | 29 | |
156160 | 108314 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2501X DIAMOND ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002141 | 2097265 | 37.7388113707969 | -122.435126715418 | (37.7388113707969, -122.435126715418) | 2 | 7 | 5 | 63 | 7 | ||||
165242 | 104317 | Private 9 | Pyrus calleryana :: Ornamental Pear 44 | 13011305 SANCHEZ ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003956 | 2100665 | 37.7482498839608 | -122.429093651106 | (37.7482498839608, -122.429093651106) | 2 | 4 | 5 | 63 | 22 | |||
168048 | 122898 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006160 | 2102149 | 37.7524491239798 | -122.421577653162 | (37.7524491239798, -122.421577653162) | 2 | 4 | 5 | 28859 | 19 | |||
170397 | 36938 | Private 9 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 351 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774744 | 5992449.52236815 | 2113091.823439 | 37.781712581861 | -122.469786951776 | (37.781712581861, -122.469786951776) | 11 | 6 | 2 | 54 | 11 | |
171901 | 82180 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 105 Lake St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.7867910649613 | -122.460471849521 | (37.7867910649613, -122.460471849521) | 11 | 6 | 1 | 54 | 11 | ||
176299 | 104400 | Private 9 | Maytenus boaria :: Mayten 58 | 755 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5999044 | 2107976 | 37.768044800389 | -122.446605071221 | (37.768044800389, -122.446605071221) | 15 | 5 | 11 | 29492 | 9 | ||||
181524 | 121089 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
181589 | 73314 | Private 9 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2014 12:00:00 AM | 3 | 3x3 | 6009184.98526399 | 2102501.75487234 | 37.7535878144828 | -122.411141625253 | (37.7535878144828, -122.411141625253) | 2 | 4 | 7 | 28859 | 19 | ||
186484 | 109125 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
187934 | 108441 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Front Yard : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773769 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | |||
188939 | 104962 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 74 Aztec St. | 6008023 | 2099506 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | 2 | 7 | 7 | 28859 | 2 | ||
190320 | 72375 | Private 9 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.477688796337 | (37.773031079694, -122.477688796337) | 11 | 6 | 2 | 55 | 26 | |
193423 | 108885 | Private 9 | Cupaniopsis anacardioides :: Carrotwood 195 | 707 NOE ST | 5 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003152.4 | 2104071.5 | 37.7575578048507 | -122.432115704961 | (37.7575578048507, -122.432115704961) | 2 | 4 | 5 | 28862 | 3 | ||||
193685 | 104552 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
194501 | 265145 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2021 12:00:00 AM | 3 | 3x3 | Permit Number 782838 | 5997529.09133 | 2109900.74605 | 37.7732430089022 | -122.451983830898 | (37.7732430089022, -122.451983830898) | 15 | 5 | 11 | 29492 | 16 | |
194517 | 265144 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2166 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782839 | 5997501.55835 | 2109896.92898 | 37.773230951126 | -122.452078795234 | (37.773230951126, -122.452078795234) | 15 | 5 | 11 | 29492 | 16 | ||
3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8479 | 204048 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
8858 | 261455 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
11157 | 261456 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
15121 | 261452 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
15415 | 261457 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
16566 | 261453 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
51620 | 26198 | Private 9 | Lophostemon confertus :: Brisbane Box 11 | 3830 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x4 | 6015747.5106038 | 2098323.3315623 | 37.742480578689 | -122.388155190044 | (37.742480578689, -122.388155190044) | 10 | 3 | 8 | 58 | 1 | |||
190102 | 104109 | Private 9 | Maytenus boaria :: Mayten 58 | 342-346 MOULTRIE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | 6007700 | 2097518 | 37.7398201496863 | -122.415924151926 | (37.7398201496863, -122.415924151926) | 2 | 7 | 7 | 28859 | 2 | |||
2295 | 193115 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014511.3912 | 2096886.32335 | 37.7384662854853 | -122.392328872775 | (37.7384662854853, -122.392328872775) | 10 | 3 | 8 | 58 | 1 | |
4984 | 154060 | Private 9 | Tree(s) :: 17 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014554.77098 | 2096926.88452 | 37.7385800668269 | -122.392181721216 | (37.7385800668269, -122.392181721216) | 10 | 3 | 8 | 58 | 1 | |
8224 | 254835 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 250 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2019 12:00:00 AM | 3 | 4x3 | Permit Number 784635 | 5989365 | 2113673 | 37.7831295589045 | -122.480500378386 | (37.7831295589045, -122.480500378386) | 11 | 6 | 2 | 55 | 26 |
10549 | 38556 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014562.13286 | 2096849.44481 | 37.7383678420956 | -122.39215085288 | (37.7383678420956, -122.39215085288) | 10 | 3 | 8 | 58 | 1 |
12863 | 154063 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1781 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014599.10763 | 2096821.84485 | 37.7382941111836 | -122.392021081628 | (37.7382941111836, -122.392021081628) | 10 | 3 | 8 | 58 | 1 |
16385 | 154062 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014575.41577 | 2096839.56035 | 37.7383414389075 | -122.392104235638 | (37.7383414389075, -122.392104235638) | 10 | 3 | 8 | 58 | 1 | |
17564 | 38555 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014548.4967 | 2096859.88077 | 37.7383957399564 | -122.392198730091 | (37.7383957399564, -122.392198730091) | 10 | 3 | 8 | 58 | 1 |
15228 | 261687 | Private 9 | Tree(s) :: 17 | 2067 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 02/20/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782291 | 6011786.16554 | 2094038.32843 | 37.730494584078 | -122.401551330673 | (37.730494584078, -122.401551330673) | 10 | 3 | 8 | 58 | 1 |
165107 | 104627 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5X5 | 6001306 | 2108720 | 37.7702165872443 | -122.438834395611 | (37.7702165872443, -122.438834395611) | 15 | 5 | 11 | 29492 | 9 | |||
585 | 75271 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015975.8041 | 2106880.05369 | 37.7659881814233 | -122.387962771269 | (37.7659881814233, -122.387962771269) | 14 | 3 | 9 | 310 | 20 | ||
4077 | 102546 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015961.34604 | 2107137.76144 | 37.7666949900978 | -122.388030764508 | (37.7666949900978, -122.388030764508) | 14 | 3 | 9 | 310 | 20 | ||
5551 | 74240 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015971.85212 | 2106927.76687 | 37.7661189725478 | -122.387979770277 | (37.7661189725478, -122.387979770277) | 14 | 3 | 9 | 310 | 20 | ||
6900 | 102545 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015962.79104 | 2107111.95809 | 37.7666242197475 | -122.38802396564 | (37.7666242197475, -122.38802396564) | 14 | 3 | 9 | 310 | 20 | ||
7177 | 74026 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015970.5058 | 2106958.46215 | 37.7662031805546 | -122.387986569137 | (37.7662031805546, -122.387986569137) | 14 | 3 | 9 | 310 | 20 | ||
17556 | 75105 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2016 12:00:00 AM | 3 | 5x5 | 6015973.99843 | 2106904.23323 | 37.7660544731729 | -122.387970704195 | (37.7660544731729, -122.387970704195) | 14 | 3 | 9 | 310 | 20 | ||
95724 | 85741 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 601X Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798 | 2114488.497614 | 37.7867229411628 | -122.398229721423 | (37.7867229411628, -122.398229721423) | 6 | 2 | 9 | 28855 | 6 | |
97720 | 104310 | Private 9 | Brachychiton populneus :: Bottle Tree 348 | 3747 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | |||
122325 | 104309 | Private 9 | Myoporum laetum :: Myoporum 62 | 3747 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | ||||
156773 | 85739 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 601X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798 | 2114488.497614 | 37.7867229411628 | -122.398229721423 | (37.7867229411628, -122.398229721423) | 6 | 2 | 9 | 28855 | 6 | |
171374 | 85740 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 601X Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798 | 2114488.497614 | 37.7867229411628 | -122.398229721423 | (37.7867229411628, -122.398229721423) | 6 | 2 | 9 | 28855 | 6 | |
194402 | 265049 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1595 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 5x5 | 5999367.57953 | 2109424.62482 | 37.7720408355473 | -122.445590032014 | (37.7720408355473, -122.445590032014) | 15 | 5 | 11 | 29492 | 9 | ||
120017 | 105072 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 88X PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5x6 | 6007074 | 2099135 | 37.7442248567037 | -122.418203213837 | (37.7442248567037, -122.418203213837) | 2 | 7 | 7 | 28859 | 2 | |||
35396 | 104626 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6X5 | 6001285 | 2108936 | 37.7708084746611 | -122.438922516011 | (37.7708084746611, -122.438922516011) | 15 | 5 | 11 | 29492 | 9 | |||
91085 | 111308 | Private 9 | Pinus radiata :: Monterey Pine 15 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x90 | 6015099 | 2088640 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | 10 | 3 | 8 | 58 | 1 | ||||
85052 | 258602 | Private 9 | :: 45 | 682 12th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/29/2019 12:00:00 AM | 3 | 8X4 | 5992266.47414 | 2110804.58144 | 37.7754218561197 | -122.470253595146 | (37.7754218561197, -122.470253595146) | 11 | 6 | 2 | 54 | 11 | ||
54959 | 258601 | Private 9 | :: 45 | 682 12th Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 05/29/2019 12:00:00 AM | 3 | 9X2 | 5992266.47414 | 2110804.58144 | 37.7754218561197 | -122.470253595146 | (37.7754218561197, -122.470253595146) | 11 | 6 | 2 | 54 | 11 | ||
675 | 150019 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.62882 | 2105456.11878 | 37.7620514180509 | -122.389544911688 | (37.7620514180509, -122.389544911688) | 10 | 3 | 8 | 28856 | 29 | |
3212 | 150016 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.18586 | 2105386.64383 | 37.7618609074738 | -122.389524298311 | (37.7618609074738, -122.389524298311) | 10 | 3 | 8 | 28856 | 29 | |
8842 | 150020 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.50926 | 2105477.62507 | 37.7621104630605 | -122.389546827243 | (37.7621104630605, -122.389546827243) | 10 | 3 | 8 | 28856 | 29 | |
14649 | 150018 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015492.47093 | 2105432.35195 | 37.7619863170408 | -122.389533421936 | (37.7619863170408, -122.389533421936) | 10 | 3 | 8 | 28856 | 29 | |
15916 | 150017 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.08881 | 2105409.25245 | 37.7619229804945 | -122.389526212978 | (37.7619229804945, -122.389526212978) | 10 | 3 | 8 | 28856 | 29 | |
985 | 262391 | Private 9 | Pinus Spp :: Pine Spp 100 | 2646 38th Ave | 1 | Back Yard : Yard | Tree | Private 2 | Width 0ft | 5984657 | 2097167 | 37.7375339667511 | -122.495570077384 | (37.7375339667511, -122.495570077384) | 1 | 8 | 3 | 29491 | 35 | ||||
192405 | 238576 | Private 9 | Prunus x yedoensis :: Yoshino Cherry 77 | 127 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 782890 | 6004764 | 2108902 | 37.7709124438039 | -122.42688615445 | (37.7709124438039, -122.42688615445) | 7 | 9 | 11 | 28852 | 10 | |
1077 | 149677 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011154.9566 | 2106050.92707 | 37.7634433311543 | -122.404578819881 | (37.7634433311543, -122.404578819881) | 8 | 3 | 8 | 28856 | 29 | |
3416 | 262187 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 4 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
7435 | 239668 | Private 9 | Butia capitata :: Pindo Palm 313 | 180 Dolores St | 3 | Sidewalk: Property side : Pot | Landscaping | Private 2 | 23 | Width 4ft | 6004776.3298 | 2107329.36682 | 37.7665950691341 | -122.426731495165 | (37.7665950691341, -122.426731495165) | 8 | 4 | 5 | 28862 | 3 | |||
8898 | 149678 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 2 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
18413 | 149679 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 3 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
18526 | 250107 | Private 9 | Tree(s) :: 17 | 1688 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005911.45005 | 2115583.38163 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | 13 | 9 | 1 | 28858 | 41 | |||
2898 | 191530 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016138.64503 | 2107209.62915 | 37.7669021444474 | -122.387422526024 | (37.7669021444474, -122.387422526024) | 14 | 3 | 9 | 310 | 20 | |||
3180 | 191527 | Private 9 | Liquidambar styraciflua :: American Sweet Gum 37 | 201 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016025.61335 | 2107205.30438 | 37.7668840087222 | -122.387813186138 | (37.7668840087222, -122.387813186138) | 14 | 3 | 9 | 310 | 20 | |||
5864 | 189275 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 409 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015964.59668 | 2107087.77889 | 37.7665579289401 | -122.388016032733 | (37.7665579289401, -122.388016032733) | 14 | 3 | 9 | 310 | 20 |
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) );