trees
27,746 rows where qCaretaker_id = 1 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34548 | 3784 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 35 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/2014 10:43:00 AM | 3 | 3X4 | 6017319.3126468 | 2095790.6090322 | 37.7356131929747 | -122.382544123056 | (37.7356131929747, -122.382544123056) | 10 | 3 | 8 | 58 | 1 | ||
184795 | 29598 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 900X Junipero Serra Blvd | 7 | Median : Cutout | Tree | DPW 1 | 12/31/2014 08:52:00 AM | 3 | 5991178.77498 | 2091110.64652 | 37.7212844823864 | -122.472580013151 | (37.7212844823864, -122.472580013151) | 9 | 8 | 4 | 64 | 40 | |||
2232 | 26076 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 269 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994312.4294 | 2088054.8516 | 37.7130748868127 | -122.461526506385 | (37.7130748868127, -122.461526506385) | 9 | 8 | 6 | 28861 | 24 | ||
26655 | 26073 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 285 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 8 | 3x3 | 5994159.2599 | 2088057.6707 | 37.7130738098987 | -122.462056111894 | (37.7130738098987, -122.462056111894) | 9 | 8 | 6 | 28861 | 24 | ||
64906 | 26342 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2630 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 6 | 3X3 | 5997363.52119 | 2088889.57468 | 37.7155419900373 | -122.451041118862 | (37.7155419900373, -122.451041118862) | 9 | 8 | 6 | 28861 | 24 | ||
92590 | 26084 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 11 | 3X3 | 5995430.1902 | 2088042.6356 | 37.713105618543 | -122.457662291956 | (37.713105618543, -122.457662291956) | 9 | 8 | 6 | 28861 | 24 | ||
135759 | 22339 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5236 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 3 | 3X3 | 6014418.1916 | 2093832.59155 | 37.7300761861762 | -122.392437577641 | (37.7300761861762, -122.392437577641) | 10 | 3 | 8 | 58 | 1 | ||
31031 | 1693 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040295 | 37.7297694248505 | -122.381097672052 | (37.7297694248505, -122.381097672052) | 10 | 3 | 8 | 58 | 1 | ||
100935 | 1700 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 43 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1996 12:00:00 AM | 6 | 3X3 | 6017768.2322395 | 2093598.2442303 | 37.7296181792492 | -122.380839660676 | (37.7296181792492, -122.380839660676) | 10 | 3 | 8 | 58 | 1 | ||
102592 | 17145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
135876 | 17142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.70496 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | 10 | 3 | 8 | 58 | 1 | ||
153979 | 20164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1155X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1990 12:00:00 AM | 25 | 4X4 | 6002621 | 2112212 | 37.7798794773869 | -122.434535545992 | (37.7798794773869, -122.434535545992) | 15 | 5 | 11 | 29490 | 41 | ||
38398 | 26478 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | 2 | 7 | 5 | 63 | 7 | ||
52717 | 5516 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.7560425375576 | -122.425422183901 | (37.7560425375576, -122.425422183901) | 2 | 4 | 5 | 28859 | 19 | ||
130104 | 24041 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Westbrook Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1994 12:00:00 AM | 12 | 3X4 | 6017284.9951248 | 2095593.5314005 | 37.7350701611901 | -122.382649063918 | (37.7350701611901, -122.382649063918) | 10 | 3 | 8 | 58 | 1 | ||
8637 | 15022 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 825 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1992 12:00:00 AM | 18 | 3x3 | 6015991.79898 | 2096688.54395 | 37.7380053172864 | -122.387196501233 | (37.7380053172864, -122.387196501233) | 10 | 3 | 8 | 58 | 1 | ||
83965 | 15024 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 845 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1992 12:00:00 AM | 17 | 3X3 | 6015971.14204 | 2096622.00458 | 37.7378214697096 | -122.387263283018 | (37.7378214697096, -122.387263283018) | 10 | 3 | 8 | 58 | 1 | ||
165448 | 1764 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2000X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1992 12:00:00 AM | 12 | 3X3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
30303 | 1818 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 2100 Bay Shore Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 3 | 6 | 6012027.2003656 | 2087907.9406618 | 37.7136752340099 | -122.400287624748 | (37.7136752340099, -122.400287624748) | 10 | 7 | 8 | 309 | 39 | ||
37777 | 1780 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 6 | 3X3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | ||
72763 | 1820 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2100 Bay Shore Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | 10 | 7 | 8 | 309 | 1 | ||
79950 | 1821 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2100 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.46157 | 2087571.87835 | 37.7127407763393 | -122.400988964593 | (37.7127407763393, -122.400988964593) | 10 | 7 | 8 | 309 | 1 | ||
117140 | 1786 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 6 | 3X3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | ||
136421 | 1781 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 5 | 3x3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | ||
190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 | |
190391 | 17051 | DPW Maintained 1 | Tristania conferta :: 61 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | 15 | 5 | 11 | 29492 | 9 | |
12670 | 86450 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | 1 | 8 | 3 | 29491 | 35 | ||
35011 | 86446 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2426 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987996.8709 | 2098757.0924 | 37.7420949525843 | -122.484139283552 | (37.7420949525843, -122.484139283552) | 1 | 8 | 3 | 29491 | 35 | ||
39227 | 86445 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2434 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.5477 | 2098724.6039 | 37.7420057871296 | -122.484134561433 | (37.7420057871296, -122.484134561433) | 1 | 8 | 3 | 29491 | 35 | ||
42523 | 86453 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2330 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987973.3506 | 2099428.6905 | 37.7439376142067 | -122.484269851802 | (37.7439376142067, -122.484269851802) | 1 | 8 | 3 | 29491 | 35 | ||
45304 | 86448 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2410 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987993.1483 | 2098903.2906 | 37.7424961575573 | -122.484162874059 | (37.7424961575573, -122.484162874059) | 1 | 8 | 3 | 29491 | 35 | ||
46577 | 86562 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2207 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987900.988811 | 2100267.110901 | 37.746235480683 | -122.484581545679 | (37.746235480683, -122.484581545679) | 1 | 8 | 3 | 29491 | 35 | ||
57398 | 86435 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2578 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988030.7572 | 2097759.3623 | 37.7393574208367 | -122.483948972283 | (37.7393574208367, -122.483948972283) | 1 | 8 | 3 | 29491 | 35 | ||
77402 | 86563 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2215 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987902.745463 | 2100215.048221 | 37.7460926326953 | -122.484571653291 | (37.7460926326953, -122.484571653291) | 1 | 8 | 3 | 29491 | 35 | ||
85218 | 86561 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1891 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102437.7427 | 37.7521908954775 | -122.485011502397 | (37.7521908954775, -122.485011502397) | 1 | 8 | 3 | 56 | 35 | ||
93844 | 86451 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2358 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987978.4269 | 2099245.2659 | 37.7434342743144 | -122.484238850005 | (37.7434342743144, -122.484238850005) | 1 | 8 | 3 | 29491 | 35 | ||
98007 | 86566 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2291 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987915.7374 | 2099735.4596 | 37.7447765661609 | -122.484491558794 | (37.7447765661609, -122.484491558794) | 1 | 8 | 3 | 29491 | 35 | ||
98879 | 86567 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2307 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987921.2336 | 2099575.5655 | 37.7443378593723 | -122.484460828778 | (37.7443378593723, -122.484460828778) | 1 | 8 | 3 | 29491 | 35 | ||
100435 | 86565 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2243 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987907.2026 | 2100032.4695 | 37.7455915795676 | -122.484542851528 | (37.7455915795676, -122.484542851528) | 1 | 8 | 3 | 29491 | 35 | ||
110085 | 86443 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2450 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.37774 | 2098622.10748 | 37.741724349066 | -122.484127634313 | (37.741724349066, -122.484127634313) | 1 | 8 | 3 | 29491 | 35 | |
111221 | 86568 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2337 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987926.9868 | 2099392.4793 | 37.7438354881374 | -122.484427509802 | (37.7438354881374, -122.484427509802) | 1 | 8 | 3 | 29491 | 35 | ||
115502 | 86454 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2326 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987972.3353 | 2099456.4411 | 37.7440137508973 | -122.484275397242 | (37.7440137508973, -122.484275397242) | 1 | 8 | 3 | 29491 | 35 | ||
129692 | 86452 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2350 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987979.4422 | 2099298.3981 | 37.743580220411 | -122.484239235211 | (37.743580220411, -122.484239235211) | 1 | 8 | 3 | 29491 | 35 | ||
139761 | 86449 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2370 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987981.4727 | 2099180.2889 | 37.7432560419796 | -122.484223554257 | (37.7432560419796, -122.484223554257) | 1 | 8 | 3 | 29491 | 35 | ||
146666 | 86438 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2558 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.0275 | 2097893.3718 | 37.7397251004281 | -122.483975149426 | (37.7397251004281, -122.483975149426) | 1 | 8 | 3 | 29491 | 35 | ||
149689 | 86442 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2470 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988005.6699 | 2098496.5076 | 37.7413799676446 | -122.484089754678 | (37.7413799676446, -122.484089754678) | 1 | 8 | 3 | 29491 | 35 | ||
155873 | 86437 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2566 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988027.6041 | 2097846.7049 | 37.7395970571481 | -122.483966277165 | (37.7395970571481, -122.483966277165) | 1 | 8 | 3 | 29491 | 35 | ||
160836 | 86434 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2590 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988032.3338 | 2097694.7224 | 37.7391800283996 | -122.48393878255 | (37.7391800283996, -122.48393878255) | 1 | 8 | 3 | 29491 | 35 | ||
165460 | 86440 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2506 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988014.3608 | 2098206.7963 | 37.7405850025908 | -122.484038465173 | (37.7405850025908, -122.484038465173) | 1 | 8 | 3 | 29491 | 35 | ||
167442 | 86444 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2438 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988000.2551 | 2098696.1765 | 37.7419278906096 | -122.484123116004 | (37.7419278906096, -122.484123116004) | 1 | 8 | 3 | 29491 | 35 | ||
183145 | 86439 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2550 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988024.4509 | 2097942.8764 | 37.7398609352841 | -122.48398422975 | (37.7398609352841, -122.48398422975) | 1 | 8 | 3 | 29491 | 35 | ||
184811 | 86436 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.00444 | 2097787.220267 | 37.7394336348182 | -122.48396744726 | (37.7394336348182, -122.48396744726) | 1 | 8 | 3 | 29491 | 35 | ||
193554 | 86441 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | 1 | 8 | 3 | 29491 | 35 | ||
82046 | 23060 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1130X Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006285.82184 | 2102960.15037 | 37.7546834499434 | -122.42120013327 | (37.7546834499434, -122.42120013327) | 2 | 4 | 5 | 28859 | 19 | ||
94090 | 23057 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1125 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006400.53773 | 2103001.31347 | 37.7548029408293 | -122.420806336166 | (37.7548029408293, -122.420806336166) | 2 | 4 | 7 | 28859 | 19 | ||
134428 | 23096 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1387 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006465.03799 | 2101520.60096 | 37.7507408794773 | -122.420478177928 | (37.7507408794773, -122.420478177928) | 2 | 4 | 7 | 28859 | 19 | ||
169792 | 23059 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1130X Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006285.82184 | 2102960.15037 | 37.7546834499434 | -122.42120013327 | (37.7546834499434, -122.42120013327) | 2 | 4 | 5 | 28859 | 19 | ||
184474 | 23058 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1125 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 3 | 3X3 | 6006398.20766 | 2103046.47398 | 37.7549268098381 | -122.420817600178 | (37.7549268098381, -122.420817600178) | 2 | 4 | 7 | 28859 | 19 | ||
5567 | 6767 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1275 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 12 | 3x3 | 6017316.52552 | 2096883.88974 | 37.7386149694956 | -122.382629809543 | (37.7386149694956, -122.382629809543) | 10 | 3 | 8 | 58 | 1 | ||
158947 | 6731 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.47437 | 37.7392827179327 | -122.383402261517 | (37.7392827179327, -122.383402261517) | 10 | 3 | 8 | 58 | 1 | ||
179786 | 6751 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1215 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 7 | 6017537.38126 | 2096718.538 | 37.7381731451641 | -122.381854690145 | (37.7381731451641, -122.381854690145) | 10 | 3 | 8 | 58 | 1 | |||
189175 | 6662 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3X3 | 6016012.05161 | 2098330.17252 | 37.7425140162093 | -122.387240954701 | (37.7425140162093, -122.387240954701) | 10 | 3 | 8 | 58 | 1 | ||
4409 | 60582 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1426 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20198 | 6000937.5822 | 2111077.0426 | 37.7766674666338 | -122.440277805167 | (37.7766674666338, -122.440277805167) | 15 | 5 | 11 | 29492 | 41 | ||
78512 | 12132 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1400X La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 05:53:00 AM | 3 | 3X3 | 6016426.99502 | 2095242.04569 | 37.734057614557 | -122.385591017134 | (37.734057614557, -122.385591017134) | 10 | 3 | 8 | 58 | 1 | ||
123614 | 11975 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1200X La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:52:00 PM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.7316151284675 | -122.381940767084 | (37.7316151284675, -122.381940767084) | 10 | 3 | 8 | 58 | 1 | ||
51477 | 11891 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:46:00 PM | 3 | 3X4 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | ||
105797 | 91811 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2685 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:45:00 PM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | 2 | 4 | 7 | 28859 | 19 | ||
126961 | 26571 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 355 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:34:00 PM | 3 | 3X3 | 6010658.7520522 | 2098287.1955653 | 37.742098094898 | -122.4057481481 | (37.742098094898, -122.4057481481) | 10 | 3 | 8 | 58 | 1 | ||
1668 | 86560 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.485018839299 | (37.7522790893532, -122.485018839299) | 1 | 8 | 3 | 56 | 35 | ||
4308 | 86471 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1814 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987856.6219 | 2102916.0794 | 37.7535062555598 | -122.484929264335 | (37.7535062555598, -122.484929264335) | 1 | 8 | 3 | 56 | 35 | ||
8074 | 86491 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1610 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.6185 | 2104298.7956 | 37.7572997330502 | -122.485214007697 | (37.7572997330502, -122.485214007697) | 1 | 8 | 3 | 56 | 35 | ||
23307 | 86478 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.420576 | 2103380.975618 | 37.7547814420453 | -122.485040146314 | (37.7547814420453, -122.485040146314) | 1 | 8 | 3 | 56 | 35 | ||
27635 | 86483 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1706 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987833.1754 | 2103641.2255 | 37.7554959453769 | -122.485063545571 | (37.7554959453769, -122.485063545571) | 1 | 8 | 3 | 56 | 35 | ||
28164 | 86552 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1807 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987803.5941 | 2102964.5337 | 37.7536362092428 | -122.485116198466 | (37.7536362092428, -122.485116198466) | 1 | 8 | 3 | 56 | 35 | ||
32087 | 86468 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1830 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 10 | 3x3 | 5987859.0288 | 2102813.3889 | 37.753224435288 | -122.484913407703 | (37.753224435288, -122.484913407703) | 1 | 8 | 3 | 56 | 35 | ||
33162 | 86484 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1698 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987824.3728 | 2103790.6728 | 37.7559057744919 | -122.48510495178 | (37.7559057744919, -122.48510495178) | 1 | 8 | 3 | 56 | 35 | ||
33736 | 86479 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103389.1385 | 37.7548041785464 | -122.485021542908 | (37.7548041785464, -122.485021542908) | 1 | 8 | 3 | 56 | 35 | ||
34034 | 86470 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1822 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987859.0288 | 2102867.5421 | 37.7533731253955 | -122.484917380259 | (37.7533731253955, -122.484917380259) | 1 | 8 | 3 | 56 | 35 | ||
34767 | 86481 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1738 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987831.7029 | 2103459.302005 | 37.7549963468497 | -122.485055291033 | (37.7549963468497, -122.485055291033) | 1 | 8 | 3 | 56 | 35 | ||
38212 | 86551 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1801X 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987806.717124 | 2103025.494361 | 37.7538037727045 | -122.485109870887 | (37.7538037727045, -122.485109870887) | 1 | 8 | 3 | 56 | 35 | ||
39979 | 86489 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1642 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987810.0594 | 2104111.2911 | 37.7567852717409 | -122.485177975352 | (37.7567852717409, -122.485177975352) | 1 | 8 | 3 | 56 | 35 | ||
42487 | 86557 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1839 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987812.6165 | 2102765.0103 | 37.7530888972888 | -122.485070359602 | (37.7530888972888, -122.485070359602) | 1 | 8 | 3 | 56 | 35 | ||
45346 | 86480 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1742 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987841.1062 | 2103418.0293 | 37.7548835708771 | -122.485019744249 | (37.7548835708771, -122.485019744249) | 1 | 8 | 3 | 56 | 35 | ||
47107 | 86487 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1654 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987812.2064 | 2104044.7342 | 37.7566026495976 | -122.48516566702 | (37.7566026495976, -122.48516566702) | 1 | 8 | 3 | 56 | 35 | ||
51975 | 86558 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1867 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 7 | 3x3 | 5987816.4554 | 2102586.0208 | 37.7525976639013 | -122.48504395302 | (37.7525976639013, -122.48504395302) | 1 | 8 | 3 | 56 | 35 | ||
53898 | 86473 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1786 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987851.8695 | 2103141.0168 | 37.7541235962339 | -122.484962200288 | (37.7541235962339, -122.484962200288) | 1 | 8 | 3 | 56 | 35 | ||
64820 | 86482 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1722 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.8749 | 2103544.3561 | 37.7552300671815 | -122.485050561435 | (37.7552300671815, -122.485050561435) | 1 | 8 | 3 | 56 | 35 | ||
66881 | 86554 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1815 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987806.6182 | 2102907.2902 | 37.7534792101731 | -122.485101540922 | (37.7534792101731, -122.485101540922) | 1 | 8 | 3 | 56 | 35 | ||
74870 | 86472 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1810 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987855.0174 | 2102938.1418 | 37.7535667395127 | -122.484936431442 | (37.7535667395127, -122.484936431442) | 1 | 8 | 3 | 56 | 35 | ||
76997 | 86462 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1874 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x12 | 5987866.4109 | 2102544.1995 | 37.7524857435744 | -122.484868132588 | (37.7524857435744, -122.484868132588) | 1 | 8 | 3 | 56 | 35 | ||
94605 | 86474 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1774 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987847.9041 | 2103231.0884 | 37.754370677583 | -122.484982521185 | (37.754370677583, -122.484982521185) | 1 | 8 | 3 | 56 | 35 | ||
96987 | 86477 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 1754 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103364.7795 | 37.754737295309 | -122.485019755857 | (37.754737295309, -122.485019755857) | 1 | 8 | 3 | 56 | 35 | ||
98160 | 86455 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2274 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987957.131 | 2099832.7559 | 37.7450461263907 | -122.484355563995 | (37.7450461263907, -122.484355563995) | 1 | 8 | 3 | 29491 | 35 | ||
102550 | 86490 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 1618 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987805.7655 | 2104249.4147 | 37.7571642715643 | -122.485202959431 | (37.7571642715643, -122.485202959431) | 1 | 8 | 3 | 56 | 35 | ||
106457 | 86465 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1842 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 8 | 3x3 | 5987862.4384 | 2102740.1818 | 37.7530236268855 | -122.484896246512 | (37.7530236268855, -122.484896246512) | 1 | 8 | 3 | 56 | 35 | ||
109562 | 86555 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1819 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 5 | 3x3 | 5987809.0175 | 2102882.3372 | 37.7534108357177 | -122.48509141307 | (37.7534108357177, -122.48509141307) | 1 | 8 | 3 | 56 | 35 | ||
111046 | 86466 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1838 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987861.6361 | 2102765.0521 | 37.753091867307 | -122.484900845395 | (37.753091867307, -122.484900845395) | 1 | 8 | 3 | 56 | 35 | ||
113870 | 86463 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1866 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987865.2759 | 2102589.5992 | 37.7526103328382 | -122.484875387875 | (37.7526103328382, -122.484875387875) | 1 | 8 | 3 | 56 | 35 | ||
116041 | 86556 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1823 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987809.2575 | 2102855.2249 | 37.7533364066252 | -122.485088594036 | (37.7533364066252, -122.485088594036) | 1 | 8 | 3 | 56 | 35 | ||
117661 | 86488 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1646 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987812.9221 | 2104078.3705 | 37.7566950474544 | -122.485165659807 | (37.7566950474544, -122.485165659807) | 1 | 8 | 3 | 56 | 35 |
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) );