trees
7,157 rows where qSpecies_id = 36 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 191932 | 211830 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151 Lippard Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001876.91497 | 2095339.24636 | 37.733508697157 | -122.435902042166 | (37.733508697157, -122.435902042166) | 9 | 7 | 5 | 63 | 40 | |||
| 191882 | 133188 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | 6010540.31188 | 2121313.86259 | 37.8053173664783 | -122.407780985508 | (37.8053173664783, -122.407780985508) | 3 | 1 | 10 | 308 | 23 | ||||
| 191862 | 195003 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 11 Dedman Ct | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016650.36466 | 2096329.60482 | 37.7370561907825 | -122.384894493113 | (37.7370561907825, -122.384894493113) | 10 | 3 | 8 | 58 | 1 | |||
| 191860 | 139905 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1601 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002075.3025 | 2112225.8571 | 37.7798865329889 | -122.436424344582 | (37.7798865329889, -122.436424344582) | 15 | 5 | 11 | 29490 | 41 | |||
| 191859 | 180628 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 339 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:40:00 AM | 3 | Width 8ft | 6001976.18123 | 2086917.49182 | 37.7103900879138 | -122.434956757573 | (37.7103900879138, -122.434956757573) | 9 | 7 | 6 | 28861 | 5 | ||
| 191852 | 143230 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 268 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010512.5066 | 2121014.371 | 37.8044934800863 | -122.407856077689 | (37.8044934800863, -122.407856077689) | 3 | 1 | 10 | 308 | 23 | |||
| 191818 | 234085 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 417 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005953.7113 | 2107838.16046 | 37.768058591661 | -122.422695293762 | (37.768058591661, -122.422695293762) | 8 | 4 | 5 | 28853 | 19 | |||
| 191817 | 25614 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1049 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/1997 12:00:00 AM | 3 | 3X3 | 6008552.94277 | 2097277.47143 | 37.7392076272162 | -122.412958022793 | (37.7392076272162, -122.412958022793) | 10 | 7 | 7 | 28859 | 2 | ||
| 191767 | 133035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 53 Priest St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6008303.98083 | 2117175.19405 | 37.793828167583 | -122.415226969163 | (37.793828167583, -122.415226969163) | 5 | 1 | 10 | 28858 | 21 | |||
| 191763 | 22740 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1575 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002565.8449 | 2112291.0033 | 37.7800932694814 | -122.434732002721 | (37.7800932694814, -122.434732002721) | 15 | 5 | 11 | 29490 | 41 | |||
| 191715 | 1476 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 240 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5995566.85724 | 2114603.3643 | 37.7860425593171 | -122.459111997897 | (37.7860425593171, -122.459111997897) | 11 | 6 | 1 | 54 | 31 | |||
| 191670 | 19263 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1331 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6001755.6631 | 2113036.885 | 37.782095242341 | -122.437588214617 | (37.782095242341, -122.437588214617) | 15 | 5 | 11 | 29490 | 41 | |||
| 191648 | 121037 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1830 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006566 | 2117108 | 37.7935458417616 | -122.421235781398 | (37.7935458417616, -122.421235781398) | 13 | 9 | 10 | 28858 | 32 | ||||
| 191641 | 133118 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2033 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007662.56848 | 2119407.98169 | 37.7999227777616 | -122.417604646263 | (37.7999227777616, -122.417604646263) | 5 | 1 | 1 | 28858 | 32 | |||
| 191610 | 250894 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 250 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986839.6011 | 2114252.83409 | 37.7845745295398 | -122.489279763454 | (37.7845745295398, -122.489279763454) | 11 | 6 | 1 | 55 | 33 | |||
| 191569 | 6084 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1989 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000943.5354 | 2112412.0737 | 37.7803334620648 | -122.440352977968 | (37.7803334620648, -122.440352977968) | 15 | 5 | 11 | 29490 | 41 | |||
| 191555 | 194905 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 401 Mission Rock St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015281.73268 | 2109381.67848 | 37.7728186178107 | -122.390538262332 | (37.7728186178107, -122.390538262332) | 14 | 3 | 9 | 310 | 20 | |||
| 191543 | 66934 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3701 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2018 12:00:00 AM | 3 | Permit Number 30259 | 6000148.61542 | 2121009.60368 | 37.8038947298108 | -122.443720799286 | (37.8038947298108, -122.443720799286) | 13 | 9 | 1 | 57 | 17 | ||
| 191384 | 33672 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 630 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 8 | Permit Number 37755 | 6004311.7858 | 2111011.0585 | 37.7766778233724 | -122.428600737755 | (37.7766778233724, -122.428600737755) | 7 | 9 | 11 | 28852 | 10 | ||
| 191371 | 7566 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2939 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008395.50826 | 2101303.3159 | 37.750252864993 | -122.413787053846 | (37.750252864993, -122.413787053846) | 2 | 4 | 7 | 28859 | 19 | |||
| 191362 | 97733 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005736.8865 | 2120695.23683 | 37.8033487055393 | -122.424359846228 | (37.8033487055393, -122.424359846228) | 5 | 9 | 1 | 28858 | 32 | |
| 191346 | 30439 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 387 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 15 | Permit Number 92 | 6011071.27916 | 2119657.83609 | 37.8008000340602 | -122.405826771312 | (37.8008000340602, -122.405826771312) | 3 | 1 | 10 | 308 | 23 | ||
| 191247 | 142717 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008054.1886 | 2121138.8091 | 37.8046972234707 | -122.41637215184 | (37.8046972234707, -122.41637215184) | 5 | 1 | 10 | 308 | 23 | |||
| 191243 | 139458 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 812 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001030.0868 | 2111486.7439 | 37.7777976690573 | -122.439987189169 | (37.7777976690573, -122.439987189169) | 15 | 5 | 11 | 29490 | 41 | |||
| 191238 | 140515 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1291 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003468.9224 | 2112069.276 | 37.7795356900249 | -122.431592015758 | (37.7795356900249, -122.431592015758) | 15 | 9 | 11 | 29490 | 41 | |||
| 191215 | 140598 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 926 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003471.9246 | 2111490.4849 | 37.7779466437583 | -122.431540298035 | (37.7779466437583, -122.431540298035) | 15 | 9 | 11 | 29492 | 41 | |||
| 191214 | 194752 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Fairfax Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6015647.85994 | 2098132.60328 | 37.7419513562614 | -122.388486445597 | (37.7419513562614, -122.388486445597) | 10 | 3 | 8 | 58 | 1 | |||
| 191211 | 147488 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 5x5 | 5989696.24786 | 2111204.44404 | 37.7763708364839 | -122.479173771363 | (37.7763708364839, -122.479173771363) | 11 | 6 | 2 | 55 | 26 | ||
| 191201 | 201929 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 118 Elmira St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6011180.45656 | 2096032.84214 | 37.7359372821822 | -122.40378565649 | (37.7359372821822, -122.40378565649) | 10 | 3 | 8 | 58 | 1 | |||
| 191166 | 91936 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1015 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5992649.184657 | 2106593.110978 | 37.7638804015817 | -122.468623221089 | (37.7638804015817, -122.468623221089) | 1 | 8 | 11 | 56 | 12 | ||
| 191159 | 47901 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1380 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | Permit Number 45642 | 6001204.25243548 | 2110765.42075726 | 37.775827010926 | -122.439332974554 | (37.775827010926, -122.439332974554) | 15 | 5 | 11 | 29492 | 10 | ||
| 191146 | 249398 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 350 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008259.14419 | 2113134.32287 | 37.7827303995415 | -122.41509594873 | (37.7827303995415, -122.41509594873) | 7 | 10 | 9 | 28852 | 36 | |||
| 191131 | 132529 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2201 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000188.88591 | 2120224.7314 | 37.8017419776577 | -122.443525026756 | (37.8017419776577, -122.443525026756) | 13 | 9 | 1 | 57 | 17 | |||
| 191123 | 96426 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2001 Market St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | 3x3 | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | |||
| 191067 | 122969 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 106 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993365.06329 | 2114771.95593 | 37.786378643894 | -122.466741807319 | (37.786378643894, -122.466741807319) | 11 | 6 | 2 | 54 | 11 | |||
| 191053 | 236041 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 51 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001471.0294 | 2107935.88017 | 37.7680729763034 | -122.438207380469 | (37.7680729763034, -122.438207380469) | 15 | 5 | 5 | 29492 | 3 | |||
| 191039 | 120193 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 400 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5987807.29514 | 2113237.3235 | 37.7818426655183 | -122.485857349295 | (37.7818426655183, -122.485857349295) | 11 | 6 | 2 | 55 | 26 | |||
| 191019 | 67877 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1345 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1993 12:00:00 AM | Permit Number 31567 | 6003285.36844159 | 2100415.0335047 | 37.7475255489997 | -122.43139483292 | (37.7475255489997, -122.43139483292) | 2 | 4 | 5 | 63 | 22 | |||
| 191018 | 15517 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2763 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6007153.55731 | 2102312.38165 | 37.7529537060435 | -122.418153340617 | (37.7529537060435, -122.418153340617) | 2 | 4 | 7 | 28859 | 19 | |||
| 190980 | 234165 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1800 Alabama St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6009310.70035 | 2099068.1056 | 37.7441668244386 | -122.410464433884 | (37.7441668244386, -122.410464433884) | 2 | 7 | 7 | 28859 | 2 | |||
| 190979 | 104758 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 50 Walnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998501.2 | 2116298 | 37.790863832623 | -122.449082132455 | (37.790863832623, -122.449082132455) | 13 | 6 | 1 | 54 | 31 | ||||
| 190949 | 19267 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1348 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6001785.67354 | 2113071.66768 | 37.7821924529795 | -122.437486883879 | (37.7821924529795, -122.437486883879) | 15 | 5 | 11 | 29490 | 41 | |||
| 190919 | 2570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1635 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005649.96237 | 2115147.50764 | 37.7881111350574 | -122.424265849113 | (37.7881111350574, -122.424265849113) | 13 | 9 | 1 | 28858 | 41 | |||
| 190917 | 2579 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1668 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 4X4 | 6005479.75685 | 2115179.20105 | 37.7881885451021 | -122.424856986956 | (37.7881885451021, -122.424856986956) | 13 | 9 | 1 | 28858 | 41 | |||
| 190889 | 194677 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 707 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011020.4817 | 2104988.18697 | 37.7605177691018 | -122.404969096842 | (37.7605177691018, -122.404969096842) | 10 | 3 | 8 | 28856 | 29 | |||
| 190872 | 2652 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004122.1657 | 2114993.8546 | 37.7876028567046 | -122.42954079807 | (37.7876028567046, -122.42954079807) | 13 | 9 | 11 | 29490 | 27 | |||
| 190867 | 9511 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1014 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6004702.17435 | 2112293.48025 | 37.7802211234107 | -122.427341644353 | (37.7802211234107, -122.427341644353) | 7 | 9 | 11 | 29490 | 41 | |||
| 190866 | 124490 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3145 Turk Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995952.95635 | 2111382.91428 | 37.7772222485889 | -122.4575431172 | (37.7772222485889, -122.4575431172) | 11 | 6 | 2 | 54 | 16 | |||
| 190845 | 56300 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 122 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1973 12:00:00 AM | 10 | Permit Number 12432 | 5993061.69304 | 2114648.40732 | 37.786021900719 | -122.467782393287 | (37.786021900719, -122.467782393287) | 11 | 6 | 2 | 54 | 11 | ||
| 190807 | 234042 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Camp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005802.3158 | 2106388.95293 | 37.7640708691043 | -122.42311593367 | (37.7640708691043, -122.42311593367) | 8 | 4 | 5 | 28859 | 19 | |||
| 190794 | 16744 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1740X O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002974.690387 | 2113440.8663141 | 37.7832737070954 | -122.433399814283 | (37.7832737070954, -122.433399814283) | 13 | 9 | 11 | 29490 | 41 | |||
| 190743 | 22670 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1301 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003735.5706 | 2112459.3542 | 37.7806218577845 | -122.430697409583 | (37.7806218577845, -122.430697409583) | 15 | 9 | 11 | 29490 | 41 | |||
| 190634 | 43225 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1426 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43014 | 5990267.64228129 | 2105665.07486788 | 37.7611944016156 | -122.476792360506 | (37.7611944016156, -122.476792360506) | 1 | 8 | 4 | 56 | 12 | ||
| 190594 | 234082 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 433 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005857.13819 | 2107828.22352 | 37.7680258581293 | -122.423028623885 | (37.7680258581293, -122.423028623885) | 8 | 4 | 5 | 28853 | 19 | |||
| 190570 | 194866 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 409 China Basin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015868.42271 | 2109073.181 | 37.7720040811672 | -122.388487279274 | (37.7720040811672, -122.388487279274) | 14 | 3 | 9 | 310 | 20 | |||
| 190552 | 66133 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 64 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 13 | Permit Number 29195 | 6001738.9264 | 2120869.24898 | 37.8035999293564 | -122.438207379562 | (37.8035999293564, -122.438207379562) | 13 | 9 | 1 | 57 | 17 | ||
| 190486 | 133214 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013155.79356 | 2118418.98395 | 37.7975147962162 | -122.398526451738 | (37.7975147962162, -122.398526451738) | 3 | 1 | 10 | 28860 | 6 | |||
| 190464 | 132960 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1772 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005135.19766 | 2118180.85721 | 37.7964108685226 | -122.42626289354 | (37.7964108685226, -122.42626289354) | 13 | 9 | 1 | 28858 | 17 | |||
| 190459 | 114808 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1794 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004381 | 2119146 | 37.7990182441371 | -122.428941422903 | (37.7990182441371, -122.428941422903) | 13 | 9 | 1 | 57 | 17 | ||||
| 190390 | 9549 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1195X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.430062547125 | (37.7797350134544, -122.430062547125) | 7 | 9 | 11 | 29490 | 41 | ||
| 190381 | 57164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2989 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1974 12:00:00 AM | 15 | Permit Number 14441 | 5999884.50215 | 2116380.66792 | 37.7911698354787 | -122.444301928598 | (37.7911698354787, -122.444301928598) | 13 | 6 | 1 | 29490 | 27 | ||
| 190345 | 132889 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2691 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000206.94163 | 2117801.65331 | 37.7950898786361 | -122.443288407953 | (37.7950898786361, -122.443288407953) | 13 | 9 | 1 | 57 | 27 | |||
| 190325 | 178442 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 250 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012271.63627 | 2087156.60492 | 37.7116258427271 | -122.399390046427 | (37.7116258427271, -122.399390046427) | 10 | 3 | 8 | 309 | 1 | |||
| 190314 | 60419 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 956 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1982 12:00:00 AM | 11 | Permit Number 20001 | 6012141.03119 | 2103925.82718 | 37.7576633380176 | -122.401018959679 | (37.7576633380176, -122.401018959679) | 10 | 3 | 8 | 28856 | 29 | ||
| 190303 | 33537 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 221 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2009 12:00:00 AM | 3x3 | Permit Number 53057 | 6007140.41280467 | 2097686.07908747 | 37.7402501811426 | -122.417870884768 | (37.7402501811426, -122.417870884768) | 2 | 7 | 7 | 28859 | 2 | ||
| 190283 | 46203 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 81 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | 6 | Permit Number 44519 | 5996677.8978 | 2112518.169 | 37.7803809745963 | -122.455117383614 | (37.7803809745963, -122.455117383614) | 11 | 6 | 2 | 54 | 16 | ||
| 190253 | 206110 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 344X Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5994629.06969 | 2107042.01405 | 37.7652271454495 | -122.461807997542 | (37.7652271454495, -122.461807997542) | 15 | 5 | 11 | 56 | 12 | |||
| 190160 | 65958 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2636 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 12 | Permit Number 28980 | 5987794.4947 | 2098312.0677 | 37.7408612472153 | -122.484806388592 | (37.7408612472153, -122.484806388592) | 1 | 8 | 3 | 29491 | 35 | |
| 190152 | 1508 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 363 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3X3 | 5995531.01478 | 2113825.63159 | 37.7839050536381 | -122.459179664391 | (37.7839050536381, -122.459179664391) | 11 | 6 | 2 | 54 | 11 | |||
| 190147 | 7778 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 320X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2012 12:00:00 AM | 3 | 3X3 | 6006210.940911 | 2111809.7702747 | 37.7789781871097 | -122.422087746504 | (37.7789781871097, -122.422087746504) | 7 | 9 | 11 | 28852 | 10 | ||
| 190090 | 95076 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1357 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6006388.20719 | 2119695.22507 | 37.8006396849333 | -122.422034840657 | (37.8006396849333, -122.422034840657) | 13 | 9 | 1 | 28858 | 32 | |||
| 190067 | 236023 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 702 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003021.56781 | 2104045.03564 | 37.7574777215383 | -122.432566284911 | (37.7574777215383, -122.432566284911) | 2 | 4 | 5 | 28862 | 3 | |||
| 190006 | 8056 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 612 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1990 12:00:00 AM | 10 | 3X3 | 6004763.84585 | 2111612.61975 | 37.7783551358069 | -122.427079785356 | (37.7783551358069, -122.427079785356) | 7 | 9 | 11 | 28852 | 41 | ||
| 189974 | 40620 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3367 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1999 12:00:00 AM | 8 | Permit Number 41625 | 6001284.18567 | 2120046.72207 | 37.8013156153844 | -122.439722023163 | (37.8013156153844, -122.439722023163) | 13 | 9 | 1 | 57 | 17 | ||
| 189909 | 132629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 316 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5997161.48031 | 2115268.11655 | 37.7879593340148 | -122.453643079677 | (37.7879593340148, -122.453643079677) | 11 | 6 | 1 | 54 | 31 | |||
| 189905 | 108399 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 854 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772652 | 6009900.25097 | 2104235.81272 | 37.7583892353961 | -122.40879039773 | (37.7583892353961, -122.40879039773) | 2 | 4 | 7 | 28859 | 19 |
| 189892 | 108400 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1145 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772606 | 6010035.09265 | 2102537.48598 | 37.7537335619184 | -122.408204273916 | (37.7537335619184, -122.408204273916) | 2 | 4 | 7 | 28859 | 19 |
| 189889 | 234053 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Brook St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005540.23116 | 2097855.95931 | 37.7406264489433 | -122.423415751429 | (37.7406264489433, -122.423415751429) | 2 | 7 | 7 | 28859 | 2 | |||
| 189788 | 8198 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1310X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/01/2006 12:00:00 AM | 3 | 3X3 | 6001445.5559 | 2111147.0928 | 37.7768887152736 | -122.438525598793 | (37.7768887152736, -122.438525598793) | 15 | 5 | 11 | 29492 | 41 | ||
| 189779 | 97860 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 895 Indiana St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 189717 | 88780 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3047 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2008 12:00:00 AM | 10 | 3x3 | Permit Number 51697 | 6000453.5671 | 2118800.21451 | 37.797845724244 | -122.44250677659 | (37.797845724244, -122.44250677659) | 13 | 9 | 1 | 57 | 17 | |
| 189684 | 9734 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 727X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6005653.63672 | 2112026.60995 | 37.7795421273786 | -122.424031111893 | (37.7795421273786, -122.424031111893) | 7 | 9 | 11 | 28852 | 41 | |||
| 189637 | 123240 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | Permit Number 780398 | 5993479.44876 | 2111515.72827 | 37.777444527227 | -122.466109353825 | (37.777444527227, -122.466109353825) | 11 | 6 | 2 | 54 | 11 | ||
| 189624 | 30581 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 562 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 6 | Permit Number 34555 | 6003882.9857 | 2109746.0047 | 37.7731800204909 | -122.429993820689 | (37.7731800204909, -122.429993820689) | 7 | 9 | 11 | 29492 | 10 | |
| 189525 | 249564 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1251 Franklin St | 2 | : | Tree | Private 2 | 1 | Width 2ft | 6005929.24831 | 2114394.73993 | 37.7860599874291 | -122.423246035899 | (37.7860599874291, -122.423246035899) | 13 | 9 | 1 | 28858 | 41 | |||
| 189454 | 235082 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 167 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007949.52436 | 2097853.13146 | 37.7407543721126 | -122.415085114589 | (37.7407543721126, -122.415085114589) | 2 | 7 | 7 | 28859 | 2 | |||
| 189421 | 19156 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 71 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003511.34851 | 2107903.37532 | 37.7680995566712 | -122.431147816639 | (37.7680995566712, -122.431147816639) | 7 | 9 | 5 | 28862 | 3 | |||
| 189406 | 53579 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 136 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1970 12:00:00 AM | 12 | Permit Number 6505 | 5993991.22494 | 2114646.21157 | 37.7860695009431 | -122.464566330251 | (37.7860695009431, -122.464566330251) | 11 | 6 | 1 | 54 | 11 | ||
| 189387 | 251132 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 354 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875 | 2111882 | 37.7794943458843 | -122.402498458881 | (37.7794943458843, -122.402498458881) | 14 | 2 | 9 | 28856 | 34 | |
| 189358 | 103035 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 147 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5993637.70862 | 2114534.07495 | 37.7857412186942 | -122.465781241486 | (37.7857412186942, -122.465781241486) | 11 | 6 | 2 | 54 | 11 | |||
| 189341 | 211742 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 700 Junipero Serra Blvd | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5991230.19236 | 2092152.91218 | 37.7241492619617 | -122.472478226094 | (37.7241492619617, -122.472478226094) | 9 | 8 | 4 | 64 | 40 | |||
| 189337 | 51041 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 219 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47514 | 5994588.50149 | 2113969.44319 | 37.7842456916479 | -122.4624508229 | (37.7842456916479, -122.4624508229) | 11 | 6 | 2 | 54 | 11 | ||
| 189312 | 9539 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1100X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004035.7284 | 2112200.9821 | 37.779929432705 | -122.429640587781 | (37.779929432705, -122.429640587781) | 7 | 9 | 11 | 29490 | 41 | ||
| 189273 | 20165 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1175 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 3 | 4X4 | 6002839.5551 | 2112216.2896 | 37.7799036597579 | -122.433779774463 | (37.7799036597579, -122.433779774463) | 15 | 9 | 11 | 29490 | 41 | ||
| 189270 | 132727 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2699 Filbert St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6000163.64493 | 2118477.26495 | 37.7969424604902 | -122.443486775009 | (37.7969424604902, -122.443486775009) | 13 | 9 | 1 | 57 | 17 | |||
| 189222 | 38241 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 328 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2001 12:00:00 AM | Permit Number 44248 | 6007507.98543931 | 2097166.42044649 | 37.7388439928098 | -122.416563160642 | (37.7388439928098, -122.416563160642) | 2 | 7 | 7 | 28859 | 2 | |||
| 189219 | 7186 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 901X FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6003221 | 2111367 | 37.7775933596503 | -122.432399512389 | (37.7775933596503, -122.432399512389) | 15 | 9 | 11 | 29492 | 10 | |||
| 189171 | 225288 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 160 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997996.86697 | 2105372.945 | 37.7608376012854 | -122.450039337952 | (37.7608376012854, -122.450039337952) | 15 | 5 | 11 | 29492 | 12 | |||
| 189164 | 121816 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 154 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5989939.71416 | 2114371.60407 | 37.7850811128207 | -122.478563226802 | (37.7850811128207, -122.478563226802) | 11 | 6 | 2 | 55 | 26 | |||
| 189157 | 132799 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2625 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002188.60004 | 2116046.49179 | 37.7903834601686 | -122.436305907014 | (37.7903834601686, -122.436305907014) | 13 | 6 | 1 | 29490 | 27 |
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) );