trees
27,746 rows where qCaretaker_id = 1 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13646 | 259034 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 13846 | 262084 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 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 |
| 14634 | 259029 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 71 Stanton St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | |||
| 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 |
| 15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
| 15519 | 262098 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 10x Cuesta Ct | 2 | Unaccepted Street : Yard | Tree | DPW 1 | Private | 3x3 | 5999757 | 2101744 | 37.7509739685765 | -122.443691128062 | (37.7509739685765, -122.443691128062) | 2 | 5 | 5 | 63 | 38 | |||
| 15523 | 248949 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1500x Galvez Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 09:13:00 AM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 17225 | 253199 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 11/02/2019 06:04:00 AM | 3 | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |
| 17261 | 261487 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1100X Portola Dr | 2 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
| 18853 | 262082 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 498X Burnett Ave | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 3x3 | 5999387 | 2102682 | 37.7535283774883 | -122.445038044935 | (37.7535283774883, -122.445038044935) | 2 | 5 | 5 | 63 | 38 | |||
| 19694 | 91181 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
| 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 | ||
| 28453 | 248943 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1500x Galvez Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/10/2017 01:08:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 30044 | 254525 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/07/2012 12:00:00 AM | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | ||
| 33666 | 201689 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009821.14 | 2110064.65257 | 37.7743894618352 | -122.409475369404 | (37.7743894618352, -122.409475369404) | 8 | 2 | 9 | 28853 | 34 |
| 34591 | 251286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 34689 | 251592 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1999X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6007220 | 2119146 | 37.799178528828 | -122.419117510386 | (37.799178528828, -122.419117510386) | 5 | 1 | 10 | 28858 | 32 | |||
| 34752 | 248944 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1500x Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/10/2017 12:58:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 36901 | 91180 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
| 37129 | 253672 | DPW Maintained 1 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 40337 | 254524 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/10/2015 07:56:00 AM | 3 | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |
| 41344 | 254527 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4016 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:17:00 PM | 3x3 | 5982022 | 2105615 | 37.7605751592951 | -122.505306319772 | (37.7605751592951, -122.505306319772) | 1 | 8 | 3 | 56 | 35 | ||
| 41708 | 251371 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 44511 | 258444 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 598 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010091 | 2105516 | 37.7619150231034 | -122.408220989844 | (37.7619150231034, -122.408220989844) | 8 | 4 | 8 | 28859 | 19 | |||
| 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 | ||
| 45337 | 251284 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/21/1996 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 50094 | 253202 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800 Oak St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |||
| 50943 | 258449 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
| 51281 | 187631 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4255x Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/28/2017 11:56:00 AM | 3 | 3x3 | 5981269 | 2105492 | 37.7601930989218 | -122.507901429287 | (37.7601930989218, -122.507901429287) | 1 | 8 | 3 | 56 | 35 | |
| 58619 | 252878 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/30/2014 01:34:00 PM | 3x3 | 6014268 | 2110701 | 37.7763848891878 | -122.394137287636 | (37.7763848891878, -122.394137287636) | 6 | 2 | 9 | 28856 | 20 | ||
| 59222 | 106322 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1040 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6012164.19951 | 2103531.96134 | 37.7565831613987 | -122.400911161547 | (37.7565831613987, -122.400911161547) | 10 | 3 | 8 | 28856 | 29 | |
| 65819 | 91179 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
| 66795 | 251421 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 300X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/30/2014 01:37:00 PM | 3x3 | 6014268 | 2110701 | 37.7763848891878 | -122.394137287636 | (37.7763848891878, -122.394137287636) | 6 | 2 | 9 | 28856 | 20 | ||
| 72004 | 87557 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 408X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/03/2007 12:00:00 AM | 3 | 3x3 | 5994236.22519 | 2114896.53302 | 37.7867709361644 | -122.463736876784 | (37.7867709361644, -122.463736876784) | 11 | 6 | 1 | 54 | 11 | |
| 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 | ||
| 74841 | 91191 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 818 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52040 | 6006711.43287 | 2113326.57189 | 37.7831711713524 | -122.420464034549 | (37.7831711713524, -122.420464034549) | 7 | 9 | 9 | 28858 | 36 | |
| 76027 | 251368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 270 06th St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010822 | 2111616 | 37.7787051302825 | -122.406122506892 | (37.7787051302825, -122.406122506892) | 14 | 2 | 9 | 28853 | 34 | |||
| 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 | ||
| 77056 | 251288 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1335 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 01:58:00 PM | 3 | 3x3 | 6016828 | 2097292 | 37.7397085577181 | -122.384347329812 | (37.7397085577181, -122.384347329812) | 10 | 3 | 8 | 58 | 1 | |
| 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 | ||
| 81089 | 258450 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
| 83418 | 251282 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/07/2016 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 94306 | 95177 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1227 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3 | 3x3 | 6001304.8007 | 2112660.3061 | 37.7810356079674 | -122.439120992436 | (37.7810356079674, -122.439120992436) | 15 | 5 | 11 | 29490 | 41 | ||
| 94501 | 258447 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 598 Hampshire St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010091 | 2105516 | 37.7619150231034 | -122.408220989844 | (37.7619150231034, -122.408220989844) | 8 | 4 | 8 | 28859 | 19 | |||
| 94996 | 91190 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 818 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52040 | 6006711.43287 | 2113326.57189 | 37.7831711713524 | -122.420464034549 | (37.7831711713524, -122.420464034549) | 7 | 9 | 9 | 28858 | 36 | |
| 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 | ||
| 98805 | 254526 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |||
| 99706 | 85477 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1711 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/10/2011 12:00:00 AM | 18 | 4x4 | Permit Number 56911 | 6007344.49108 | 2118216.09025 | 37.7966322393414 | -122.418620748847 | (37.7966322393414, -122.418620748847) | 5 | 1 | 10 | 28858 | 32 |
| 100931 | 248948 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1500x Galvez Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/10/2017 01:15:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 101337 | 95167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1300 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3 | 3x3 | 6001355 | 2112906 | 37.7817130771674 | -122.43896494142 | (37.7817130771674, -122.43896494142) | 15 | 5 | 11 | 29490 | 41 | ||
| 103935 | 21639 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1641 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/14/2010 12:00:00 AM | 18 | 4X4 | Permit Number 53778 | 6004750.8195846 | 2114677.2774985 | 37.7867691895303 | -122.427343218264 | (37.7867691895303, -122.427343218264) | 13 | 9 | 11 | 28858 | 13 |
| 105019 | 95178 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3 | 3x3 | 6001286.14287 | 2112595.80793 | 37.7808574507306 | -122.439180914838 | (37.7808574507306, -122.439180914838) | 15 | 5 | 11 | 29490 | 41 | ||
| 106854 | 251131 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 354 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/14/2014 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875 | 2111882 | 37.7794943458843 | -122.402498458881 | (37.7794943458843, -122.402498458881) | 14 | 2 | 9 | 28856 | 34 | |
| 108393 | 251275 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1175x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/16/2011 12:00:00 AM | 3x3 | 6017547 | 2094834 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 112603 | 251276 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/09/1998 12:00:00 AM | 3x3 | 6017547 | 2094834 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | 10 | 3 | 8 | 58 | 1 | ||
| 113064 | 251280 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275x Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/11/2006 12:00:00 AM | 3x3 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 118523 | 251277 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/26/2011 12:00:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||
| 126440 | 95163 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 998 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001491.8688 | 2111772.0851 | 37.7786074207661 | -122.438410176931 | (37.7786074207661, -122.438410176931) | 15 | 5 | 11 | 29490 | 41 | |
| 128759 | 251281 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1275x Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/23/2006 12:00:00 AM | 3x3 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
| 129646 | 11066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1711 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/10/2011 12:00:00 AM | 60 | 4x4 | Permit Number 56911 | 6007343.19343 | 2118232.87472 | 37.7966782522465 | -122.418626429868 | (37.7966782522465, -122.418626429868) | 5 | 1 | 10 | 28858 | 32 |
| 134323 | 253646 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1200x La Salle Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/09/1992 12:00:00 AM | 3x3 | 6017461 | 2094327 | 37.7316022380495 | -122.381952476407 | (37.7316022380495, -122.381952476407) | 10 | 3 | 8 | 58 | 1 | ||
| 134399 | 251283 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/06/1997 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 135367 | 251278 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1200x Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 01/27/2016 09:31:00 AM | 3x3 | 6017356 | 2095183 | 37.733946845802 | -122.382375019073 | (37.733946845802, -122.382375019073) | 10 | 3 | 8 | 58 | 1 | ||
| 136011 | 100962 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 18 | 3x3 | Permit Number 768706 | 6013015.61085 | 2114021.62606 | 37.7854328757839 | -122.39870276924 | (37.7854328757839, -122.39870276924) | 6 | 2 | 9 | 28855 | 6 |
| 136047 | 255721 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2597 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6001584 | 2114910 | 37.7872285756824 | -122.438316324014 | (37.7872285756824, -122.438316324014) | 13 | 6 | 11 | 29490 | 27 | |||
| 137810 | 248950 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1500x Galvez Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/10/2017 01:18:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 138459 | 258445 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 598 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010091 | 2105516 | 37.7619150231034 | -122.408220989844 | (37.7619150231034, -122.408220989844) | 8 | 4 | 8 | 28859 | 19 | |||
| 141293 | 91178 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.418299173193 | (37.7785341058364, -122.418299173193) | 7 | 9 | 9 | 28852 | 36 | ||
| 144516 | 254523 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 3906 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5982400 | 2105639 | 37.7606632919303 | -122.504000789622 | (37.7606632919303, -122.504000789622) | 1 | 8 | 3 | 56 | 35 | |||
| 146805 | 121136 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 1875 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/04/2017 12:00:00 AM | 3 | 3x3 | 6006784.10346 | 2107469.87255 | 37.7670941752111 | -122.419796914586 | (37.7670941752111, -122.419796914586) | 8 | 4 | 7 | 28853 | 19 | |
| 146849 | 258446 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 598 Hampshire St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010091 | 2105516 | 37.7619150231034 | -122.408220989844 | (37.7619150231034, -122.408220989844) | 8 | 4 | 8 | 28859 | 19 | |||
| 147738 | 248946 | DPW Maintained 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 1500x Galvez Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/10/2017 01:12:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 148594 | 253644 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1200x La Salle Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/05/1992 12:00:00 AM | 3x3 | 6017461 | 2094327 | 37.7316022380495 | -122.381952476407 | (37.7316022380495, -122.381952476407) | 10 | 3 | 8 | 58 | 1 | ||
| 149723 | 254437 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1408 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:04:00 PM | 3x3 | 5981264 | 2105479 | 37.7601571100533 | -122.507917756824 | (37.7601571100533, -122.507917756824) | 1 | 8 | 3 | 56 | 35 | ||
| 154786 | 248942 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1500x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/18/2017 12:56:00 PM | 3 | 3x3 | 6016393 | 2097292 | 37.7396844950272 | -122.385851388433 | (37.7396844950272, -122.385851388433) | 10 | 3 | 8 | 58 | 1 | |
| 157938 | 251285 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1299x Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/11/2006 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 158891 | 251370 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 390 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 159974 | 187630 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 4255x Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/23/2015 05:35:00 PM | 3x3 | 5981269 | 2105492 | 37.7601930989218 | -122.507901429287 | (37.7601930989218, -122.507901429287) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||
| 166528 | 258443 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 598 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010091 | 2105516 | 37.7619150231034 | -122.408220989844 | (37.7619150231034, -122.408220989844) | 8 | 4 | 8 | 28859 | 19 | |||
| 167923 | 251287 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 171910 | 91184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | 5 | Permit Number 51891 | 6007394.40571 | 2110929.76906 | 37.776628592972 | -122.417931258428 | (37.776628592972, -122.417931258428) | 7 | 9 | 9 | 28852 | 36 | |
| 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 | ||
| 177293 | 253645 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 03/11/2006 12:00:00 AM | 3x3 | 6017461 | 2094327 | 37.7316022380495 | -122.381952476407 | (37.7316022380495, -122.381952476407) | 10 | 3 | 8 | 58 | 1 | ||
| 179423 | 258451 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
| 183105 | 253639 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4405 California St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5993893 | 2114132 | 37.7846519530642 | -122.464868802518 | (37.7846519530642, -122.464868802518) | 11 | 6 | 2 | 54 | 11 | |||
| 186181 | 251369 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 186546 | 258448 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 540 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6010043 | 2105722 | 37.7624779645344 | -122.408401534669 | (37.7624779645344, -122.408401534669) | 8 | 4 | 8 | 28859 | 19 | |||
| 186945 | 254438 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1412 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/06/2015 01:14:00 PM | 3x3 | 5981265 | 2105453 | 37.7600857804311 | -122.507912368787 | (37.7600857804311, -122.507912368787) | 1 | 8 | 3 | 56 | 35 | ||
| 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 |
| 189797 | 201693 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009930.21878 | 2109950.89592 | 37.7740832238052 | -122.409090015305 | (37.7740832238052, -122.409090015305) | 8 | 2 | 9 | 28853 | 34 |
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) );