trees
27,746 rows where qCaretaker_id = 1 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57656 | 23112 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1448 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/1992 12:00:00 AM | 20 | 3X3 | Permit Number 779902 | 6006436.39627 | 2101132.22455 | 37.7496728724239 | -122.420549657939 | (37.7496728724239, -122.420549657939) | 2 | 4 | 5 | 28859 | 19 | |
| 24197 | 200971 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1408 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | Width 0ft | Permit Number 779898 | 6007408.8361 | 2110843.7597 | 37.7763932439775 | -122.417875241075 | (37.7763932439775, -122.417875241075) | 7 | 2 | 9 | 28852 | 36 | ||
| 125445 | 14079 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1420 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | Permit Number 779898 | 6007326.0633 | 2110762.9345 | 37.7761666587056 | -122.418155844592 | (37.7761666587056, -122.418155844592) | 7 | 2 | 9 | 28852 | 36 | ||
| 151201 | 200973 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1416 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | Permit Number 779898 | 6007323 | 2110807 | 37.7762874795996 | -122.418169566224 | (37.7762874795996, -122.418169566224) | 7 | 9 | 9 | 28852 | 36 | ||
| 157714 | 200974 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1422 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 0ft | Permit Number 779898 | 6007323 | 2110807 | 37.7762874795996 | -122.418169566224 | (37.7762874795996, -122.418169566224) | 7 | 9 | 9 | 28852 | 36 | ||
| 52904 | 200966 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1438 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | Permit Number 779897 | 6007276.3996 | 2110716.1923 | 37.7760355203152 | -122.418324330264 | (37.7760355203152, -122.418324330264) | 7 | 2 | 9 | 28852 | 36 | ||
| 136109 | 14087 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1446 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | Permit Number 779892 | 6007224.7884 | 2110663.6072 | 37.7758882288397 | -122.418499137854 | (37.7758882288397, -122.418499137854) | 7 | 2 | 9 | 28852 | 36 | ||
| 173970 | 14085 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1446 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | Permit Number 779892 | 6007257.8975 | 2110700.6115 | 37.7759916976491 | -122.418387229062 | (37.7759916976491, -122.418387229062) | 7 | 2 | 9 | 28852 | 36 | ||
| 189524 | 14089 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1446X Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | Permit Number 779892 | 6007243.2905 | 2110686.0046 | 37.7759507683181 | -122.418436722662 | (37.7759507683181, -122.418436722662) | 7 | 2 | 9 | 28852 | 36 | ||
| 135786 | 200342 | DPW Maintained 1 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | Permit Number 779844 | 6015273.79393 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | 10 | 3 | 8 | 58 | 1 | ||
| 81944 | 123453 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 713 02nd Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 05/30/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779827 | 5995319.78488 | 2110672.17713 | 37.7752343616797 | -122.459681952866 | (37.7752343616797, -122.459681952866) | 11 | 6 | 2 | 54 | 11 | |
| 110211 | 252861 | DPW Maintained 1 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |
| 53308 | 116632 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2332 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:42:00 AM | 3 | 3x3 | Permit Number 779740 | 5991403.36215 | 2112037.81363 | 37.7787580362874 | -122.473329239514 | (37.7787580362874, -122.473329239514) | 11 | 6 | 2 | 54 | 26 | |
| 84502 | 4457 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1408 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779671 | 6004499.90701 | 2100635.94447 | 37.7482008782693 | -122.427210766376 | (37.7482008782693, -122.427210766376) | 2 | 4 | 5 | 63 | 22 | |
| 10316 | 142205 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | DPW for City Agency | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.444030632037 | (37.774143230926, -122.444030632037) | 15 | 5 | 11 | 29492 | 16 | |
| 7810 | 192162 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | Width 5ft | Permit Number 779453 | 6007414.0762 | 2109937.75552 | 37.7739058675964 | -122.417792878858 | (37.7739058675964, -122.417792878858) | 8 | 2 | 9 | 28853 | 19 | ||
| 97452 | 192163 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | Width 5ft | Permit Number 779453 | 6007335.7591 | 2109863.52425 | 37.7736976385647 | -122.41805852779 | (37.7736976385647, -122.41805852779) | 8 | 2 | 9 | 28853 | 19 | ||
| 117535 | 192160 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | Permit Number 779453 | 6007491.12658 | 2110012.65001 | 37.7741158457908 | -122.417531657267 | (37.7741158457908, -122.417531657267) | 8 | 2 | 9 | 28853 | 19 | ||
| 134339 | 192165 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/30/2008 12:00:00 AM | 29 | Width 4ft | Permit Number 779453 | 6007288.76075 | 2109818.60353 | 37.7735716516336 | -122.418217917334 | (37.7735716516336, -122.418217917334) | 8 | 2 | 9 | 28853 | 19 | |
| 143773 | 192161 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | Width 5ft | Permit Number 779453 | 6007448.61966 | 2109968.27436 | 37.7739916089565 | -122.417675550588 | (37.7739916089565, -122.417675550588) | 8 | 2 | 9 | 28853 | 19 | ||
| 191031 | 192164 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | Width 5ft | Permit Number 779453 | 6007314.84465 | 2109842.28548 | 37.7736381448041 | -122.418129368272 | (37.7736381448041, -122.418129368272) | 8 | 2 | 9 | 28853 | 19 | ||
| 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 | |
| 136185 | 28906 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2014 12:00:00 AM | 5 | 3X3 | Permit Number 779305 | 6011835.68516 | 2111895.24936 | 37.7795285306637 | -122.402635398413 | (37.7795285306637, -122.402635398413) | 14 | 2 | 9 | 28856 | 34 | |
| 68985 | 27385 | DPW Maintained 1 | Tree(s) :: 17 | 2200 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/07/2016 12:00:00 AM | 3 | 3X3 | Permit Number 779236 | 6007159.91681 | 2119895.63544 | 37.8012334551161 | -122.419378628241 | (37.8012334551161, -122.419378628241) | 5 | 1 | 1 | 28858 | 32 | |
| 50974 | 36881 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | 13 | 9 | 1 | 29490 | 27 | |
| 102588 | 36883 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002662.87522 | 2116961.24208 | 37.7929220655455 | -122.434730389195 | (37.7929220655455, -122.434730389195) | 13 | 9 | 1 | 29490 | 27 | |
| 108926 | 14097 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 1455 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2016 12:00:00 AM | 3 | 4X4 | Permit Number 778907 | 6007200 | 2110540 | 37.7755474375327 | -122.418576120309 | (37.7755474375327, -122.418576120309) | 8 | 2 | 9 | 28853 | 34 | |
| 113478 | 120550 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 298x Corbett Ave | 1 | Side Yard : Yard | Tree | DPW 1 | 10 | Permit Number 778898 | 5999572 | 2105342 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | 15 | 5 | 5 | 28862 | 3 | |||
| 153252 | 251819 | DPW Maintained 1 | Acer macrophyllum :: Big Leaf Maple 180 | 298X Corbett Ave | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | Permit Number 778898 | 5999572 | 2105342 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | 15 | 5 | 5 | 28862 | 3 | |||
| 65099 | 28133 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/16/2018 12:00:00 AM | 3 | 6x9 | Permit Number 778832 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | 2 | 7 | 7 | 28859 | 2 | |
| 96468 | 37606 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 443 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778736 | 5990893.15619 | 2112363.88273 | 37.7796237756063 | -122.475118033183 | (37.7796237756063, -122.475118033183) | 11 | 6 | 2 | 54 | 26 |
| 164090 | 18540 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 60 Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 2x2 | Permit Number 778371 | 5999060.6585186 | 2099832.0947892 | 37.7456846005578 | -122.445961639207 | (37.7456846005578, -122.445961639207) | 2 | 7 | 5 | 63 | 22 | ||
| 118546 | 123760 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 201 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778327 | 5994952.60534 | 2110751.23907 | 37.7754303235309 | -122.460957832773 | (37.7754303235309, -122.460957832773) | 11 | 6 | 2 | 54 | 11 | |
| 119007 | 109908 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1401 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/2015 02:04:00 PM | 3 | 3x3 | Permit Number 778313 | 6008340.42119 | 2109862.66125 | 37.7737517633724 | -122.414583173274 | (37.7737517633724, -122.414583173274) | 8 | 2 | 9 | 28853 | 34 | |
| 117353 | 122682 | DPW Maintained 1 | Tree(s) :: 17 | 2160X 09th Ave | 2 | Median : Cutout | Tree | DPW 1 | 02/03/2017 12:00:00 AM | 3 | 6x10 | Permit Number 778226 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | |
| 77889 | 4254 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4079 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777901 | 6003404.0668529 | 2100364.8685588 | 37.7473945342564 | -122.430980801713 | (37.7473945342564, -122.430980801713) | 2 | 4 | 5 | 63 | 22 | |
| 83492 | 116067 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 4150X CLEMENT ST | 5 | Front Yard : Yard | Tree | DPW 1 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |
| 115574 | 15276 | DPW Maintained 1 | :: 45 | 1563X Mission St | 1 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | Permit Number 777705 | 6007259.77782 | 2109715.95764 | 37.7732881790271 | -122.418310894637 | (37.7732881790271, -122.418310894637) | 8 | 2 | 9 | 28853 | 19 | ||
| 176729 | 15277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1563X Mission St | 2 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.56082 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | 8 | 2 | 9 | 28853 | 19 | |
| 116862 | 2287 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X Brotherhood Way | 2 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989126.18342 | 2088688.61813 | 37.7145151729252 | -122.47949804711 | (37.7145151729252, -122.47949804711) | 1 | 8 | 4 | 64 | 14 | |
| 138420 | 2286 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
| 139557 | 2290 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Brotherhood Way | 5 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
| 151272 | 2289 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Brotherhood Way | 4 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
| 161304 | 2288 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
| 178308 | 9009 | DPW Maintained 1 | Tree(s) :: 17 | 5255 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777115 | 5990680.0267 | 2112634.9623 | 37.7803557304658 | -122.4758751346 | (37.7803557304658, -122.4758751346) | 11 | 6 | 2 | 54 | 26 | |
| 25316 | 7336 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2100 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002905.15105 | 2115557.99031 | 37.789082847149 | -122.433791761396 | (37.789082847149, -122.433791761396) | 13 | 9 | 1 | 29490 | 27 | |
| 74534 | 24573 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 2100 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/22/2016 12:00:00 AM | 3 | 3X3 | Permit Number 777018 | 6002899.36519 | 2115591.06429 | 37.78917333154 | -122.433814144628 | (37.78917333154, -122.433814144628) | 13 | 9 | 1 | 29490 | 27 | |
| 171919 | 91592 | DPW Maintained 1 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 | 590 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | Permit Number 776895 | 6007446.606402 | 2106234.50211 | 37.7637394360724 | -122.417417852739 | (37.7637394360724, -122.417417852739) | 8 | 4 | 7 | 28859 | 19 | ||
| 85535 | 90656 | DPW Maintained 1 | Tree(s) :: 17 | 3450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.736244 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) | 11 | 6 | 2 | 55 | 26 |
| 144927 | 90657 | DPW Maintained 1 | Tree(s) :: 17 | 3450 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.736244 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) | 11 | 6 | 2 | 55 | 26 |
| 85487 | 28521 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 363 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 776437 | 6011229.90589 | 2111312.47666 | 37.777894532647 | -122.404690021046 | (37.777894532647, -122.404690021046) | 14 | 2 | 9 | 28856 | 34 | ||
| 125685 | 28519 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 363 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/18/2015 12:28:00 PM | 3 | 3X3 | Permit Number 776437 | 6011256.2125 | 2111285.60514 | 37.7778222199543 | -122.404597124655 | (37.7778222199543, -122.404597124655) | 14 | 2 | 9 | 28856 | 34 | |
| 140141 | 28520 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 363 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 776437 | 6011243.37931 | 2111294.78009 | 37.7778466950054 | -122.404642165409 | (37.7778466950054, -122.404642165409) | 14 | 2 | 9 | 28856 | 34 | ||
| 20897 | 23686 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 332 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 776287 | 6006868.2665484 | 2098036.0093442 | 37.7411956919963 | -122.418836670708 | (37.7411956919963, -122.418836670708) | 2 | 7 | 7 | 28859 | 2 | |
| 139823 | 106726 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2803 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2015 12:00:00 AM | 15 | 4x4 | Permit Number 776229 | 6000064.2 | 2114352.6 | 37.785611540482 | -122.443534433928 | (37.785611540482, -122.443534433928) | 15 | 6 | 1 | 29490 | 31 | |
| 23268 | 36880 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2015 12:00:00 AM | 2 | 3x3 | Permit Number 776215 | 6002666.11082 | 2116940.62149 | 37.7928656304089 | -122.434717718651 | (37.7928656304089, -122.434717718651) | 13 | 9 | 1 | 29490 | 27 |
| 121828 | 36882 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2015 12:00:00 AM | 2 | Permit Number 776215 | 6002659.25886 | 2116979.55031 | 37.7929721299187 | -122.434744211776 | (37.7929721299187, -122.434744211776) | 13 | 9 | 1 | 29490 | 27 | |
| 13976 | 1368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.7461879050589 | -122.445863385507 | (37.7461879050589, -122.445863385507) | 2 | 7 | 5 | 63 | 22 | ||
| 169502 | 1367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 33 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | Permit Number 776000 | 5999068.70954 | 2100015.22991 | 37.7461879050483 | -122.445946969396 | (37.7461879050483, -122.445946969396) | 2 | 7 | 5 | 63 | 22 | ||
| 76245 | 90154 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 638 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775919 | 5993572.64081 | 2111433.85169 | 37.7772250922406 | -122.465781024081 | (37.7772250922406, -122.465781024081) | 11 | 6 | 2 | 54 | 11 | |
| 102625 | 52820 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 PM | 3 | Permit Number 775537 | 5989777.02787 | 2111978.29339 | 37.778500303461 | -122.478950948669 | (37.778500303461, -122.478950948669) | 11 | 6 | 2 | 55 | 26 | ||
| 146964 | 52821 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:32:00 PM | 3 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | 11 | 6 | 2 | 55 | 26 | ||
| 35127 | 115231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 326 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Permit Number 775467 | 5986882.9 | 2113733.3 | 37.7831505651894 | -122.489091757795 | (37.7831505651894, -122.489091757795) | 11 | 6 | 2 | 55 | 26 | ||
| 7505 | 247942 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.407057283984 | (37.7437730949632, -122.407057283984) | 2 | 7 | 7 | 28859 | 2 | |||
| 37358 | 247943 | Planning Code 138.1 required 2 | Maytenus boaria :: Mayten 58 | 29 Joy St | 6 | Unaccepted Street : Yard | Tree | DPW 1 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | 2 | 7 | 7 | 28859 | 2 | |||
| 60942 | 247939 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 29 Joy St | 2 | Unaccepted Street : Yard | Tree | DPW 1 | 12 | Permit Number 775404 | 6010258.29977 | 2098917.51569 | 37.7438064148349 | -122.40717721395 | (37.7438064148349, -122.40717721395) | 2 | 7 | 7 | 28859 | 2 | |||
| 126738 | 247941 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 4 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.407074570729 | (37.743786764646, -122.407074570729) | 2 | 7 | 7 | 28859 | 2 | |||
| 128791 | 247940 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 29 Joy St | 3 | Unaccepted Street : Yard | Tree | DPW 1 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.28814 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | 2 | 7 | 7 | 28859 | 2 | |||
| 162044 | 247938 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 29 Joy St | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 9 | Permit Number 775404 | 6010254.90659 | 2098918.71089 | 37.7438095066969 | -122.407189031056 | (37.7438095066969, -122.407189031056) | 2 | 7 | 7 | 28859 | 2 | |||
| 179537 | 86402 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1715 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775346 | 5988092.6268 | 2103602.7043 | 37.7554052860025 | -122.484163468892 | (37.7554052860025, -122.484163468892) | 1 | 8 | 3 | 56 | 35 | |
| 7342 | 26844 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | 7 | 9 | 9 | 28852 | 36 | ||
| 61265 | 26845 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | Permit Number 775213 | 6006964.16578 | 2111032.60038 | 37.7768867199943 | -122.419426884038 | (37.7768867199943, -122.419426884038) | 7 | 9 | 9 | 28852 | 36 | ||
| 73121 | 26842 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | Permit Number 775213 | 6006970.058 | 2110963.93279 | 37.7766985071661 | -122.419401628405 | (37.7766985071661, -122.419401628405) | 7 | 9 | 9 | 28852 | 36 | ||
| 102599 | 26840 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2014 12:00:00 AM | 3 | 3X3 | Permit Number 775213 | 6006995.01563 | 2110975.40829 | 37.7767314217787 | -122.419316106666 | (37.7767314217787, -122.419316106666) | 7 | 9 | 9 | 28852 | 36 | |
| 109974 | 26839 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 775213 | 6006995.01563 | 2110975.40829 | 37.7767314217787 | -122.419316106666 | (37.7767314217787, -122.419316106666) | 7 | 9 | 9 | 28852 | 36 | |
| 164272 | 26843 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | Permit Number 775213 | 6006968.35618 | 2110982.6622 | 37.7767498377733 | -122.419408844544 | (37.7767498377733, -122.419408844544) | 7 | 9 | 9 | 28852 | 36 | ||
| 63629 | 28861 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 386 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014571.11028 | 2114290.34716 | 37.7862572644936 | -122.393339974287 | (37.7862572644936, -122.393339974287) | 6 | 2 | 9 | 28855 | 6 | |
| 156677 | 91796 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 500x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 775014 | 6014662.1325 | 2114223.547757 | 37.7860789052247 | -122.39302038306 | (37.7860789052247, -122.39302038306) | 6 | 2 | 9 | 28855 | 6 | |
| 39158 | 109206 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2322 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774968 | 5991447.56759 | 2112037.47435 | 37.7787596643252 | -122.473176292359 | (37.7787596643252, -122.473176292359) | 11 | 6 | 2 | 54 | 26 | |
| 12632 | 67562 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1165 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 774855 | 6011714 | 2102959 | 37.7549848131441 | -122.402427835541 | (37.7549848131441, -122.402427835541) | 10 | 3 | 8 | 28856 | 29 | |
| 190391 | 17051 | DPW Maintained 1 | Tristania conferta :: 61 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | 15 | 5 | 11 | 29492 | 9 | |
| 39762 | 1462 | DPW Maintained 1 | Acer x freemanii :: Freeman Maple 276 | 182 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2009 12:00:00 AM | 3 | 3X3 | Permit Number 774484 | 5995551.94489 | 2114937.12028 | 37.7869581060564 | -122.459187767204 | (37.7869581060564, -122.459187767204) | 11 | 6 | 1 | 54 | 31 | |
| 96062 | 108035 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 945 Market St | unknown : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774370 | 6010085.91267 | 2113154.0076 | 37.7828869372518 | -122.408777465126 | (37.7828869372518, -122.408777465126) | 14 | 2 | 9 | 28853 | 34 | ||||
| 37732 | 4165 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 3770 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2016 12:00:00 AM | 3 | 3X3 | Permit Number 774303 | 6005421.09901 | 2100523.30385 | 37.7479436451767 | -122.424017300779 | (37.7479436451767, -122.424017300779) | 2 | 4 | 5 | 28859 | 19 | |
| 14808 | 43442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.7222544731451 | -122.443973794765 | (37.7222544731451, -122.443973794765) | 9 | 7 | 6 | 28861 | 25 | |
| 74998 | 43439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 12 | Permit Number 774294 | 5999436.71838 | 2091300.71882 | 37.7222809168058 | -122.444048388121 | (37.7222809168058, -122.444048388121) | 9 | 7 | 6 | 28861 | 25 | |
| 99974 | 43441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 7 | Permit Number 774294 | 5999448.10749 | 2091294.70392 | 37.7222650509726 | -122.444008586831 | (37.7222650509726, -122.444008586831) | 9 | 7 | 6 | 28861 | 25 | |
| 31901 | 26849 | DPW Maintained 1 | Tree(s) :: 17 | 130 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006960.268726 | 2111024.2991523 | 37.7768637073231 | -122.4194397761 | (37.7768637073231, -122.4194397761) | 7 | 9 | 9 | 28852 | 36 | |
| 35245 | 26847 | DPW Maintained 1 | Tree(s) :: 17 | 130 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006976.7555 | 2111107.62587 | 37.7770934310359 | -122.419388656004 | (37.7770934310359, -122.419388656004) | 7 | 9 | 9 | 28852 | 36 | |
| 50319 | 26848 | DPW Maintained 1 | Tree(s) :: 17 | 130 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2016 12:00:00 AM | 3 | 4x14 | Permit Number 774227 | 6006976.7555 | 2111107.62587 | 37.7770934310359 | -122.419388656004 | (37.7770934310359, -122.419388656004) | 7 | 9 | 9 | 28852 | 36 | |
| 2201 | 107549 | Significant Tree 6 | Tree(s) :: 17 | 198X Jennings St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | ||
| 9426 | 107555 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 14319 | 107554 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |||
| 22721 | 199372 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 2 Newhall St | 2 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 15 | Width 3ft | Permit Number 774049 | 6018530.30847 | 2097200.55685 | 37.7395514542225 | -122.378455061265 | (37.7395514542225, -122.378455061265) | 10 | 3 | 8 | 58 | 1 | |
| 32524 | 107556 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 33892 | 191798 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 2 Newhall St | 3 | : | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 6 | Width 3ft | Permit Number 774049 | 6018546.98738 | 2097184.73725 | 37.7395089360924 | -122.378396294176 | (37.7395089360924, -122.378396294176) | 10 | 3 | 8 | 58 | 1 | |
| 36574 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 38316 | 107558 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
| 40220 | 107562 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
| 41288 | 107545 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 |
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) );