trees
27,746 rows where qCaretaker_id = 1 sorted by qLegalStatus_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5639 | 85379 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3390 Cesar Chavez St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007302.06128 | 2100623.11206 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | 2 | 4 | 7 | 28859 | 19 | |||
| 6750 | 85484 | - 12 | Myoporum laetum :: Myoporum 62 | 2448 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | 5 | 1 | 1 | 28858 | 32 | |||
| 9662 | 113066 | - 12 | Cupressus macrocarpa :: Monterey Cypress 41 | 2X Cranleigh Dr | 7 | : | Tree | DPW 1 | 09/09/2015 01:08:00 PM | 3 | 5991370.3 | 2095943.7 | 37.7345659248964 | -122.472270103664 | (37.7345659248964, -122.472270103664) | 1 | 8 | 4 | 64 | 40 | |||
| 14210 | 85214 | - 12 | Jacaranda mimosifolia :: Jacaranda 50 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/13/2007 12:00:00 AM | 3 | 3x3 | under 3yr maintenance agreement. ends on 4/13/2007 | 6009588.01504 | 2102148.81833 | 37.7526413233918 | -122.409722943913 | (37.7526413233918, -122.409722943913) | 2 | 4 | 7 | 28859 | 19 |
| 15423 | 85309 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/26/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
| 23858 | 85447 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 29752 | 85380 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3390 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007302.06128 | 2100623.11206 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | 2 | 4 | 7 | 28859 | 19 | |||
| 29768 | 87422 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 6009092.517834 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | 7 | 10 | 9 | 28852 | 36 | ||||
| 44768 | 85446 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 49154 | 87400 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
| 55314 | 87432 | - 12 | Acer rubrum :: Red Maple 75 | 598X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||
| 63001 | 85312 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 1366 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6003535.85294 | 2112477.60862 | 37.7806606630436 | -122.431389631549 | (37.7806606630436, -122.431389631549) | 15 | 9 | 11 | 29490 | 41 | |||
| 72192 | 85433 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 75194 | 85483 | - 12 | Myoporum laetum :: Myoporum 62 | 2448 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | 5 | 1 | 1 | 28858 | 32 | |||
| 76766 | 85437 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 79095 | 85444 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 83738 | 85306 | - 12 | Ligustrum lucidum :: Glossy Privet 57 | 1661 Pine St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005989.138522 | 2115548.501173 | 37.7892313094718 | -122.423120870526 | (37.7892313094718, -122.423120870526) | 13 | 9 | 1 | 28858 | 41 | |||
| 85799 | 87431 | - 12 | Acer rubrum :: Red Maple 75 | 522X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006584.964111 | 2094794.1521 | 37.7322783147803 | -122.419586279513 | (37.7322783147803, -122.419586279513) | 2 | 7 | 7 | 28861 | 2 | ||
| 88049 | 87399 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
| 90185 | 85377 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3390 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6007302.06128 | 2100623.11206 | 37.7483237124677 | -122.417520070933 | (37.7483237124677, -122.417520070933) | 2 | 4 | 7 | 28859 | 19 | |||
| 94031 | 85448 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 96901 | 85439 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 109129 | 85445 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 111192 | 85440 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 113755 | 85435 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 116463 | 85443 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | |||
| 121864 | 87402 | - 12 | Prunus cerasifera :: Cherry Plum 7 | 1300 Webster St | 7 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 6003725.160049 | 2113179.069411 | 37.7825974263114 | -122.430784800607 | (37.7825974263114, -122.430784800607) | 15 | 9 | 11 | 29490 | 41 | ||
| 127776 | 87423 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 45X Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009092.517834 | 2112687.614007 | 37.7815506408215 | -122.412181237011 | (37.7815506408215, -122.412181237011) | 7 | 10 | 9 | 28852 | 36 | ||
| 129540 | 87430 | - 12 | Acer rubrum :: Red Maple 75 | 522X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006584.964111 | 2094794.1521 | 37.7322783147803 | -122.419586279513 | (37.7322783147803, -122.419586279513) | 2 | 7 | 7 | 28861 | 2 | ||
| 152280 | 87429 | - 12 | Acer rubrum :: Red Maple 75 | 500X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006724.46969 | 2094782.06277 | 37.7322529772765 | -122.419103118684 | (37.7322529772765, -122.419103118684) | 2 | 7 | 7 | 28861 | 2 | ||
| 161715 | 85436 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 1397X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/17/2007 12:00:00 AM | 3 | 3x3 | Maintenance agreement ends 8/17/2010 | 6004184.830731 | 2113056.513958 | 37.782286952179 | -122.429185796304 | (37.782286952179, -122.429185796304) | 7 | 9 | 11 | 29490 | 41 |
| 163157 | 85249 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 3 | 3x3 | under 3 yr maintenance agreement. expires 7/19/2010 | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 165300 | 85441 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y7 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 165385 | 87425 | - 12 | Tree(s) :: 17 | 25X Jones St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009102.081359 | 2112621.960117 | 37.781370907497 | -122.412143510234 | (37.781370907497, -122.412143510234) | 7 | 10 | 9 | 28852 | 36 | |||
| 168120 | 87401 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 11 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
| 170510 | 85434 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y2 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/23/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 175090 | 258068 | - 12 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2700 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5991795.11646 | 2097053.50144 | 37.7376377360918 | -122.470882201509 | (37.7376377360918, -122.470882201509) | 1 | 8 | 4 | 29491 | 40 | |||||
| 175372 | 85442 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y8 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 176108 | 87410 | - 12 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | ||
| 186429 | 91166 | - 12 | Cercis canadensis :: Eastern Redbud 346 | 1548x Quesada Ave | 4 | Median : Cutout | Tree | DPW 1 | 01/31/2009 12:00:00 AM | 3 | 6015526.48125 | 2094420.051093 | 37.7317507154659 | -122.388647039673 | (37.7317507154659, -122.388647039673) | 10 | 3 | 8 | 58 | 1 | |||
| 188548 | 85310 | - 12 | Olea europaea :: Olive Tree 9 | 1250 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/27/2007 12:00:00 AM | 3 | 3x3 | Under 3 yr maintenance agreement. Ends 7/27/2010. | 6000155.2862 | 2108898.36192 | 37.7706407896873 | -122.442827504693 | (37.7706407896873, -122.442827504693) | 15 | 5 | 11 | 29492 | 9 |
| 190505 | 85250 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 2730 | 138025 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 49 | Width 0ft | 6004878.9655 | 2114979.8902 | 37.7876073348692 | -122.426921423586 | (37.7876073348692, -122.426921423586) | 13 | 9 | 11 | 28858 | 27 | |||
| 2985 | 138087 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | 13 | 9 | 11 | 28858 | 27 | |||
| 3537 | 18548 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014665.0129 | 2095058.69239 | 37.7334565140045 | -122.391669970993 | (37.7334565140045, -122.391669970993) | 10 | 3 | 8 | 58 | 1 | |||
| 4739 | 138026 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 57 | Width 0ft | 6004881.8597 | 2114953.842 | 37.7875359766764 | -122.426909554358 | (37.7875359766764, -122.426909554358) | 13 | 9 | 11 | 28858 | 27 | |||
| 5001 | 138027 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 39 | Width 0ft | 6004885.3328 | 2114935.3188 | 37.7874853129815 | -122.426896218405 | (37.7874853129815, -122.426896218405) | 13 | 9 | 11 | 28858 | 27 | |||
| 6626 | 138028 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 49 | Width 0ft | 6004887.6482 | 2114917.9533 | 37.7874377625804 | -122.426886970359 | (37.7874377625804, -122.426886970359) | 13 | 9 | 11 | 28858 | 27 | |||
| 9418 | 251108 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 2 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 10155 | 251115 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 19 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 12966 | 251112 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 14 | Median : | Tree | DPW 1 | |||||||||||||||
| 13313 | 251111 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 7 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 13831 | 251113 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 13887 | 2618 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
| 15958 | 251109 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 15995 | 251116 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 18571 | 138024 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | Width 0ft | 6004873.7558 | 2115028.5137 | 37.7877405482561 | -122.42694291248 | (37.7877405482561, -122.42694291248) | 13 | 9 | 11 | 28858 | 27 | |||
| 19170 | 251114 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 16 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 19478 | 251110 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 5 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 25166 | 194288 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 37 | Median : Yard | Tree | DPW 1 | 34 | 6014411.93404 | 2095259.01392 | 37.7339925045513 | -122.392558950849 | (37.7339925045513, -122.392558950849) | 10 | 3 | 8 | 58 | 1 | ||||
| 28953 | 2619 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 10X10 | 6004877.75733 | 2115027.26874 | 37.7877373561683 | -122.426928979241 | (37.7877373561683, -122.426928979241) | 13 | 9 | 11 | 28858 | 27 | |||
| 37495 | 18550 | Landmark tree 11 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700X Quesada Ave | 5 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014656.2717 | 2095062.29209 | 37.733465912826 | -122.391700443637 | (37.733465912826, -122.391700443637) | 10 | 3 | 8 | 58 | 1 | |||
| 40122 | 2614 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
| 45318 | 194287 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 32 | Median : Yard | Tree | DPW 1 | 31 | 6014435.32238 | 2095233.37666 | 37.7339234087228 | -122.392476296866 | (37.7339234087228, -122.392476296866) | 10 | 3 | 8 | 58 | 1 | ||||
| 47435 | 2617 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
| 62567 | 194289 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 38 | Median : Yard | Tree | DPW 1 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.392613948889 | (37.734007417094, -122.392613948889) | 10 | 3 | 8 | 58 | 1 | ||||
| 65015 | 194291 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 41 | Median : Yard | Tree | DPW 1 | 38 | 6014364.32912 | 2095287.31351 | 37.7340675655682 | -122.392725516077 | (37.7340675655682, -122.392725516077) | 10 | 3 | 8 | 58 | 1 | ||||
| 135688 | 1716 | Landmark tree 11 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 555 Battery St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x15 | 6012528.51285 | 2117974.41064 | 37.7962591384932 | -122.400665775228 | (37.7962591384932, -122.400665775228) | 3 | 1 | 10 | 28860 | 4 | |||
| 146721 | 2615 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
| 165250 | 2616 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
| 177148 | 22364 | Landmark tree 11 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490X 03rd St | 1 | Median : Cutout | Tree | DPW 1 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | 10 | 3 | 8 | 58 | 1 | |||
| 177598 | 18547 | Landmark tree 11 | Prunus domestica 'Mariposa' :: Mariposa Plum 256 | 1700X Quesada Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014668.27449 | 2095058.71423 | 37.733456755021 | -122.391658696189 | (37.733456755021, -122.391658696189) | 10 | 3 | 8 | 58 | 1 | |||
| 183525 | 18555 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014626.04256 | 2095092.92008 | 37.7335483329791 | -122.391807096032 | (37.7335483329791, -122.391807096032) | 10 | 3 | 8 | 58 | 1 | |||
| 192277 | 18551 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014649.71614 | 2095074.32399 | 37.7334985860723 | -122.391723949223 | (37.7334985860723, -122.391723949223) | 10 | 3 | 8 | 58 | 1 | |||
| 189972 | 17872 | Section 143 10 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2148 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/21/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53638 | 6003654.7045158 | 2115269.5781823 | 37.7883334451781 | -122.431177809024 | (37.7883334451781, -122.431177809024) | 13 | 9 | 1 | 29490 | 27 |
| 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 | |
| 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 | |
| 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 | ||||
| 16189 | 104502 | Private 9 | Pinus radiata :: Monterey Pine 15 | 30X SATURN ST | 1 | Median : Yard | Tree | DPW 1 | 14 | 6000456 | 2106003 | 37.7627079858093 | -122.44157952537 | (37.7627079858093, -122.44157952537) | 15 | 5 | 5 | 28862 | 3 | ||||
| 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 | |
| 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 | |
| 342 | 115652 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 18 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 1189 | 261265 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 5 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 9214 | 264784 | Property Tree 8 | Pinus halepensis :: Allepo Pine 330 | 67 Rosenkranz St | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6009267 | 2098344 | 37.7421761391661 | -122.410564417702 | (37.7421761391661, -122.410564417702) | 10 | 7 | 7 | 28859 | 2 | ||||
| 12060 | 101900 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100 Ocean Ave | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
| 13075 | 261490 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1100X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
| 15695 | 262389 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 67 Rosenkranz St | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6009267 | 2098344 | 37.7421761391661 | -122.410564417702 | (37.7421761391661, -122.410564417702) | 10 | 7 | 7 | 28859 | 2 | ||||
| 18104 | 260417 | Property Tree 8 | Eucalyptus globulus :: Blue Gum 56 | 335 Corbett Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5999565 | 2105069 | 37.7600926500434 | -122.444594033425 | (37.7600926500434, -122.444594033425) | 15 | 5 | 5 | 28862 | 3 | ||||
| 22171 | 251481 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 32 Peralta Ave | 1 | Back Yard : Yard | Tree | DPW 1 | 3x3 | 6010779 | 2100499 | 37.7481779538542 | -122.405488104269 | (37.7481779538542, -122.405488104269) | 2 | 7 | 7 | 28859 | 2 | ||||
| 24981 | 115647 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 13 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 27745 | 115653 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 19 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 36364 | 115642 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 8 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 54121 | 101901 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Ocean Ave | 2 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
| 61637 | 115638 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 4 | Back Yard : Cutout | Tree | DPW 1 | 7 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | |||
| 67651 | 115641 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 7 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 69931 | 115646 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 12 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 75714 | 114950 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 2 | unknown : Yard | Tree | DPW 1 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | ||||
| 82655 | 115645 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 11 | Back Yard : Cutout | Tree | DPW 1 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 | ||||
| 92653 | 115639 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 81x ELSIE ST | 5 | Back Yard : Cutout | Tree | DPW 1 | 6 | 3x3 | 6007403 | 2098902 | 37.7436036039275 | -122.417049094013 | (37.7436036039275, -122.417049094013) | 2 | 7 | 7 | 28859 | 2 |
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) );