trees
194,517 rows 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
24954 | 255884 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |
34844 | 102134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 769373 | 6015285.47231 | 2114577.79035 | 37.7870861804203 | -122.390888542866 | (37.7870861804203, -122.390888542866) | 6 | 2 | 9 | 28855 | 6 |
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 | |||
43430 | 112751 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
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 | ||
46746 | 117011 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 457X CASTRO ST | 1 | Back Yard : Cutout | Tree | MTA 3 | Private | 27 | 3x6 | 6002348 | 2105584 | 37.7616651256499 | -122.435005811888 | (37.7616651256499, -122.435005811888) | 15 | 4 | 5 | 28862 | 3 | ||
49983 | 110536 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X ASHBURY ST | 4 | Sidewalk: Curb side : Cutout | Tree | City College 20 | Private | 05/29/2015 02:12:00 PM | 3 | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |
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 | |
58440 | 112748 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 135X TRENTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
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 | |
65041 | 115392 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800x Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 6 | 3x3 | 6009912.44669 | 2087490.89947 | 37.7124119734081 | -122.407567629444 | (37.7124119734081, -122.407567629444) | 9 | 7 | 8 | 309 | 39 | ||
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 | |
78526 | 254583 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1439 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 08/02/2016 06:38:00 AM | 3x3 | 6005488 | 2119883 | 37.8011044543754 | -122.425163298445 | (37.8011044543754, -122.425163298445) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
84101 | 255881 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
86960 | 115393 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800x Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 4 | 3x3 | 6009906.50061 | 2087474.92929 | 37.712367789705 | -122.407587055718 | (37.712367789705, -122.407587055718) | 9 | 7 | 8 | 309 | 39 | ||
92394 | 115396 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800x Rutland St | 5 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 5 | 3x3 | 6009890.08055 | 2087427.6888 | 37.7122371577831 | -122.407640479942 | (37.7122371577831, -122.407640479942) | 9 | 7 | 8 | 309 | 39 | ||
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 | |||
99464 | 112750 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135X TRENTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6009947 | 2118097 | 37.7964514227226 | -122.409607037418 | (37.7964514227226, -122.409607037418) | 3 | 1 | 10 | 308 | 4 | |||
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 | |
101029 | 108939 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.429019881342 | (37.7968282226561, -122.429019881342) | 13 | 9 | 1 | 57 | 17 |
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 | ||
115211 | 59556 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 4079 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | Private | 02/03/1981 12:00:00 AM | 15 | Permit Number 18942 | 6003404.16952868 | 2100363.87266154 | 37.7473918055728 | -122.430980375601 | (37.7473918055728, -122.430980375601) | 2 | 4 | 5 | 63 | 22 | |
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 | |||
116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 | |
117347 | 49668 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Private | 04/18/2011 12:00:00 AM | Permit Number 46510 | 6000239.54014865 | 2120711.44405841 | 37.8030812490195 | -122.443384720262 | (37.8030812490195, -122.443384720262) | 13 | 9 | 1 | 57 | 17 | ||
117714 | 109910 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 425 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | Private | 9 | 3x3 | 6011008.58026 | 2110233.67588 | 37.7749200231853 | -122.40537967513 | (37.7749200231853, -122.40537967513) | 14 | 2 | 9 | 28853 | 34 | ||
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 | ||
125354 | 253413 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 2433 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 3x3 | 5989193.66308 | 2098780.80152 | 37.7422296590049 | -122.480002935505 | (37.7422296590049, -122.480002935505) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |
127267 | 115394 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800x Rutland St | 3 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 4 | 3x3 | 6009899.82351 | 2087457.5745 | 37.7123197632209 | -122.407608911042 | (37.7123197632209, -122.407608911042) | 9 | 7 | 8 | 309 | 39 | ||
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 |
129891 | 106680 | Permitted Site 7 | Tree(s) :: 17 | 2200 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 06/24/2014 12:00:00 AM | 20 | 3x3 | Permit Number 773028 | 5999398.2 | 2116386.7 | 37.7911586409716 | -122.445984946853 | (37.7911586409716, -122.445984946853) | 13 | 6 | 1 | 29490 | 27 |
133801 | 102879 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1680X Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 07/23/2010 12:00:00 AM | 2 | 4x4 | Permit Number 53643 | 6014844.7 | 2094689.6 | 37.7324530338407 | -122.391022948435 | (37.7324530338407, -122.391022948435) | 10 | 3 | 8 | 58 | 1 |
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 | |||
138944 | 114692 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | ||
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 | |||
144881 | 106120 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 849X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 6x9 | 5992954.7 | 2110649.6 | 37.7750360842588 | -122.467861605393 | (37.7750360842588, -122.467861605393) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||
154708 | 110535 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 100X ASHBURY ST | 3 | Sidewalk: Curb side : Cutout | Tree | City College 20 | Private | 04/21/2015 04:52:00 PM | 3 | 3x3 | 5998750 | 2110223 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | 15 | 5 | 11 | 29492 | 16 | |
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 | |
155752 | 115341 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 1514 SUNNYDALE AVE | 2 | Sidewalk: Property side : Yard | Tree | Housing Authority 15 | Private | 3x3 | 6006572 | 2087815 | 37.7131143345755 | -122.419136228821 | (37.7131143345755, -122.419136228821) | 9 | 7 | 8 | 309 | 39 | |||
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 |
162723 | 114914 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200x MIDDLE POINT RD | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | Private | 3x3 | 6017974 | 2095171 | 37.7339480130439 | -122.380237547959 | (37.7339480130439, -122.380237547959) | 10 | 3 | 8 | 58 | 1 | |||
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 |
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) );