Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2575 | 2575 | 253126 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 182 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779117 | 6002742.73008 | 2092646.2038099999 | 37.726163358663705 | -122.432716365158 | (37.7261633586637, -122.432716365158) | ||
| 2650 | 2650 | 253148 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 375 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | 3x3 | Permit Number 43092 | 6003622.0 | 2091383.0 | 37.722744709081205 | -122.42958672889 | (37.7227447090812, -122.42958672889) | |||
| 81435 | 81435 | 94362 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 507 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | 3x3 | Permit Number 53636 | 5992474.9 | 2111972.9 | 37.7786417900192 | -122.469617677573 | (37.7786417900192, -122.469617677573) | |||
| 83545 | 83545 | 107135 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 86663 | 86663 | 88313 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 638 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51304 | 6003091.0 | 2089648.0 | 37.7179507025626 | -122.43129849323799 | (37.7179507025626, -122.431298493238) | |||
| 93904 | 93904 | 118327 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 109 ALPINE TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x7 | 6001716.4 | 2108199.1 | 37.7688096651516 | -122.43737752181002 | (37.7688096651516, -122.43737752181) | ||||
| 101846 | 101846 | 88384 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 326 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51362 | 5990315.5 | 2113175.5 | 37.7818187550425 | -122.477175701056 | (37.7818187550425, -122.477175701056) | |||
| 102154 | 102154 | 108715 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 9 Harper St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774631 | 6003684.36385 | 2098301.3643799997 | 37.7417445077158 | -122.42986438956999 | (37.7417445077158, -122.42986438957) | |
| 104797 | 104797 | 88078 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1733 McKinnon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51075 | 6014551.6 | 2096479.2 | 37.737350641187206 | -122.392161384541 | (37.7373506411872, -122.392161384541) | |||
| 106637 | 106637 | 105696 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 324 Maple St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5X4.7 | Permit Number 772550 | 5996728.0 | 2115070.1 | 37.7873907738138 | -122.45512851997 | (37.7873907738138, -122.45512851997) | ||||
| 108378 | 108378 | 85171 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3065 Clay St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2007 12:00:00 AM | 3x3 | Permit Number 52052 | 6000093.0 | 2115759.0 | 37.789474791284206 | -122.44353585838999 | (37.7894747912842, -122.44353585839) | |||
| 116297 | 116297 | 108705 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1044 Castro St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774628 | 6002474.51663 | 2102543.7681400003 | 37.7533245621187 | -122.43435087414801 | (37.7533245621187, -122.434350874148) | |
| 118986 | 118986 | 113148 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 470X BEACON ST | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6002259.0 | 2098542.0 | 37.7423244157255 | -122.43481002285499 | (37.7423244157255, -122.434810022855) | ||||
| 121228 | 121228 | 88378 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 479 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51356 | 5991211.4 | 2112156.0 | 37.7790714261909 | -122.474001930206 | (37.7790714261909, -122.474001930206) | |||
| 122257 | 122257 | 96425 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 3x3 | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 124799 | 124799 | 88126 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2202 Sutter St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51132 | 6002003.4 | 2114360.3 | 37.785743085515705 | -122.436825926477 | (37.7857430855157, -122.436825926477) | |||
| 145413 | 145413 | 96426 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2001 Market St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 3x3 | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | |||
| 148243 | 148243 | 88380 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 367 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51358 | 5990874.63059 | 2112938.50877 | 37.781200466277205 | -122.47522408292299 | (37.7812004662772, -122.475224082923) | ||
| 154018 | 154018 | 88388 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 234 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51366 | 5989027.83428 | 2113749.89051 | 37.7833210783883 | -122.481672455004 | (37.7833210783883, -122.481672455004) | ||
| 54 | 54 | 121137 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 102 | 102 | 98037 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 1384X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2017 12:00:00 AM | 3 | Permit Number 767782 | 6001197.2582 | 2110764.9293 | 37.775825263482105 | -122.439357134105 | (37.7758252634821, -122.439357134105) | ||
| 153 | 153 | 5972 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 8 | 3X3 | 6003044.0843 | 2112751.363 | 37.7813844410266 | -122.43311045884899 | (37.7813844410266, -122.433110458849) | ||
| 234 | 234 | 26932 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1570 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2000 12:00:00 AM | 3 | 3X3 | 6002097.1307 | 2111930.5841 | 37.7790770280177 | -122.43632769328998 | (37.7790770280177, -122.43632769329) | ||
| 377 | 377 | 250072 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 386 | 386 | 2602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1760 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005112.3923 | 2115130.7833 | 37.7880348455319 | -122.42612455857201 | (37.7880348455319, -122.426124558572) | |||
| 491 | 491 | 236057 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004642.9908 | 2107763.18347 | 37.767778685763 | -122.427223596101 | (37.767778685763, -122.427223596101) | |||
| 496 | 496 | 245474 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | |||
| 615 | 615 | 2703 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2123 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1987 12:00:00 AM | 12 | 3X3 | 6003147.2203 | 2114799.0941 | 37.7870128441602 | -122.432899995096 | (37.7870128441602, -122.432899995096) | ||
| 653 | 653 | 144739 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | |||
| 658 | 658 | 147406 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 515 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 6x10 | 5989054.53583 | 2111789.60329 | 37.7779402316839 | -122.48143647103201 | (37.7779402316839, -122.481436471032) | |||
| 957 | 957 | 141829 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1058 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 0ft | 6004468.2701 | 2112261.9634 | 37.780121354581105 | -122.42814858004101 | (37.7801213545811, -122.428148580041) | |||
| 1019 | 1019 | 5195 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 625 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001591.0229 | 2110593.2492 | 37.7753762735578 | -122.437982704394 | (37.7753762735578, -122.437982704394) | ||
| 1110 | 1110 | 14853 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1351 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6002697.0103 | 2111613.4514 | 37.778240327396105 | -122.434229790526 | (37.7782403273961, -122.434229790526) | ||
| 1159 | 1159 | 112361 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 561X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11/16/2015 12:00:00 AM | 3 | 10x30 | Permit Number 775828 | 6013749.7362 | 2114198.9064599997 | 37.785960521430205 | -122.396175324952 | (37.7859605214302, -122.396175324952) | |
| 1255 | 1255 | 65778 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3101 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1990 12:00:00 AM | 5 | Permit Number 28743 | 6000913.14979 | 2119077.92932 | 37.7986344413927 | -122.440936428972 | (37.7986344413927, -122.440936428972) | |
| 1268 | 1268 | 221739 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 960 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 3ft | 5997261.09109 | 2107110.0824 | 37.7655652095945 | -122.452709425124 | (37.7655652095945, -122.452709425124) | |||
| 1300 | 1300 | 14826 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1269 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6003119.6747 | 2111677.9775 | 37.7784414803533 | -122.432772251133 | (37.7784414803533, -122.432772251133) | |||
| 1314 | 1314 | 92967 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3022 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779165 | 6000091.47375 | 2115801.73595 | 37.7895920459934 | -122.443544210206 | (37.7895920459934, -122.443544210206) | |
| 1328 | 1328 | 236115 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 410 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1992 12:00:00 AM | 6 | Width 3ft | Permit Number 780066 | 6003708.0 | 2109045.0 | 37.771245321662896 | -122.4305490898 | (37.7712453216629, -122.4305490898) | |
| 1331 | 1331 | 14830 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1284 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6003046.0718 | 2111709.6378 | 37.778524236985895 | -122.433029133637 | (37.7785242369859, -122.433029133637) | |||
| 1339 | 1339 | 66377 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 621 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 12 | Permit Number 29502 | 6003558.1677 | 2110522.6128 | 37.775293994216 | -122.431172851087 | (37.775293994216, -122.431172851087) | |
| 1351 | 1351 | 5208 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 802 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001567.0603 | 2111230.6559 | 37.777125069374705 | -122.438111266341 | (37.7771250693747, -122.438111266341) | |||
| 1572 | 1572 | 9622 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1404 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002793.2644 | 2112026.6959 | 37.7793804561129 | -122.433926358604 | (37.7793804561129, -122.433926358604) | |||
| 1589 | 1589 | 45715 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 475 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2017 12:00:00 AM | 3 | Permit Number 44386 | 6010097.78481 | 2106045.52558 | 37.7633693601423 | -122.40823487245301 | (37.7633693601423, -122.408234872453) | ||
| 1667 | 1667 | 251648 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2649 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007031.0 | 2102934.0 | 37.7546536287073 | -122.41862124555 | (37.7546536287073, -122.41862124555) | ||||
| 1704 | 1704 | 251429 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1345 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779991 | 6003307.0 | 2100429.0 | 37.7475651236724 | -122.43132102920099 | (37.7475651236724, -122.431321029201) | |
| 1714 | 1714 | 115408 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 889 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6006526.39743 | 2121457.3012099997 | 37.8054856898732 | -122.42168186931801 | (37.8054856898732, -122.421681869318) | |||
| 1986 | 1986 | 251131 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/14/2014 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 2129 | 2129 | 156905 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 3201x 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417.0 | 2106083.0 | 37.763321780718705 | -122.417509514421 | (37.7633217807187, -122.417509514421) | |
| 2130 | 2130 | 18891 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2513 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/1990 12:00:00 AM | 8 | 3X3 | 6002620.56709 | 2115777.954 | 37.7896706584215 | -122.434792120457 | (37.7896706584215, -122.434792120457) | ||
| 2143 | 2143 | 252905 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2368 | 2368 | 68207 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.80491086613029 | -122.41001577934601 | (37.8049108661303, -122.410015779346) | |
| 2418 | 2418 | 235026 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 541 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1991 12:00:00 AM | 7 | Width 3ft | Permit Number 29690 | 6001207.084969999 | 2103119.58489 | 37.7548335932981 | -122.43877516473499 | (37.7548335932981, -122.438775164735) | |
| 2428 | 2428 | 235022 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 571 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 14 | Width 3ft | Permit Number 22679 | 6001215.76301 | 2102992.6268700003 | 37.7544854909317 | -122.43873605683399 | (37.7544854909317, -122.438736056834) | |
| 2432 | 2432 | 235024 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 553 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 12 | Width 3ft | Permit Number 22676 | 6001208.88522 | 2103083.2214200003 | 37.754733850411 | -122.4387663334 | (37.754733850411, -122.4387663334) | |
| 2443 | 2443 | 235025 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 547 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 12 | Width 3ft | Permit Number 22675 | 6001207.505890001 | 2103104.6823400003 | 37.754792698442294 | -122.43877264125099 | (37.7547926984423, -122.438772641251) | |
| 2450 | 2450 | 235023 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 559 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1986 12:00:00 AM | 14 | Width 3ft | Permit Number 22677 | 6001213.00854 | 2103053.34864 | 37.7546520615499 | -122.438749933385 | (37.7546520615499, -122.438749933385) | |
| 2600 | 2600 | 143226 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1931 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010322.1986 | 2121149.6678 | 37.804854315613 | -122.408524208369 | (37.804854315613, -122.408524208369) | |||
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 2612 | 2612 | 120193 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 400 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5987807.29514 | 2113237.3235 | 37.7818426655183 | -122.485857349295 | (37.7818426655183, -122.485857349295) | |||
| 2649 | 2649 | 97548 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2812 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003949.4047300005 | 2118518.5197799997 | 37.7972709063909 | -122.43039009285299 | (37.7972709063909, -122.430390092853) | |||
| 2694 | 2694 | 6083 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1981 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4X4 | 6000965.1944 | 2112415.458 | 37.780343987670996 | -122.44027829238199 | (37.780343987671, -122.440278292382) | |||
| 2723 | 2723 | 18890 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2509 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1990 12:00:00 AM | 12 | 3X3 | 6002664.991880001 | 2115784.46882 | 37.7896910685235 | -122.434638881376 | (37.7896910685235, -122.434638881376) | ||
| 2787 | 2787 | 247283 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 521 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/1999 12:00:00 AM | 5 | Width 0ft | Permit Number 41847 | 5998913.4577 | 2108893.2022 | 37.7705557475505 | -122.44712261725799 | (37.7705557475505, -122.447122617258) | |
| 2789 | 2789 | 214105 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 252 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779963 | 5994448.04607 | 2088422.67439 | 37.714092646244396 | -122.46108441741801 | (37.7140926462444, -122.461084417418) | |
| 2804 | 2804 | 5964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1521X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1995 12:00:00 AM | 6 | 3X3 | 6003157.2632 | 2112724.1229 | 37.7813160659364 | -122.432716968768 | (37.7813160659364, -122.432716968768) | ||
| 2889 | 2889 | 102687 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2155 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6001348.89021 | 2115903.63348 | 37.7899434614624 | -122.43920099642901 | (37.7899434614624, -122.439200996429) | |||
| 2925 | 2925 | 26961 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2075X Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002606.079 | 2114377.3094 | 37.7858240230682 | -122.434742047375 | (37.7858240230682, -122.434742047375) | |||
| 2930 | 2930 | 246112 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1261 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 10 | Width 0ft | Permit Number 17674 | 5999700.0931 | 2108425.5315 | 37.7693165555408 | -122.44436803302901 | (37.7693165555408, -122.444368033029) | |
| 3003 | 3003 | 139363 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1590 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 0ft | 5999671.8855 | 2114244.4195 | 37.7852921232377 | -122.444883944489 | (37.7852921232377, -122.444883944489) | ||
| 3149 | 3149 | 253338 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 324 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 5996595.0 | 2107026.0 | 37.7652961513923 | -122.455007196131 | (37.7652961513923, -122.455007196131) | ||||
| 3183 | 3183 | 132950 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2074 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6004267.0 | 2117052.0 | 37.7932622027482 | -122.42918651023999 | (37.7932622027482, -122.42918651024) | |||
| 3192 | 3192 | 5265 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1245 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6001286.0183 | 2112790.7677 | 37.781392753559 | -122.439195323402 | (37.781392753559, -122.439195323402) | ||
| 3223 | 3223 | 8124 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 875 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6003614.3663 | 2111395.0391 | 37.777692645638794 | -122.431040728139 | (37.7776926456388, -122.431040728139) | ||
| 3304 | 3304 | 2735 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2261 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2003 12:00:00 AM | 3 | 3x3 | 6002669.315 | 2114735.7471 | 37.786811791741 | -122.434548907064 | (37.786811791741, -122.434548907064) | ||
| 3310 | 3310 | 8019 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 457 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/1992 12:00:00 AM | 12 | 3X3 | 6005584.1273 | 2111672.955 | 37.7785671526871 | -122.42424641558901 | (37.7785671526871, -122.424246415589) | ||
| 3312 | 3312 | 19273 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1355 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001744.1568 | 2113114.3836 | 37.7823073795972 | -122.437633572993 | (37.7823073795972, -122.437633572993) | |||
| 3341 | 3341 | 8013 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 440 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2014 12:00:00 AM | 3 | 3X3 | 6005616.7891 | 2111728.1123 | 37.7787204453524 | -122.424137349487 | (37.7787204453524, -122.424137349487) | ||
| 3359 | 3359 | 20213 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1428 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6002747.1929 | 2113184.3178 | 37.7825563803095 | -122.4341685179 | (37.7825563803095, -122.4341685179) | |||
| 3411 | 3411 | 181033 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 39 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 4ft | 6000587.53239 | 2088326.47 | 37.71417988317489 | -122.439857163381 | (37.7141798831749, -122.439857163381) | |||
| 3438 | 3438 | 2733 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2256 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002707.4731 | 2114797.1964 | 37.786982681927796 | -122.43442128422 | (37.7869826819278, -122.43442128422) | |||
| 3509 | 3509 | 235175 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 410 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43122 | 6001776.62521 | 2103418.64193 | 37.7556871173699 | -122.436826947206 | (37.7556871173699, -122.436826947206) | |
| 3522 | 3522 | 7953 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1745 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2008 12:00:00 AM | 6 | 3X3 | 6005687.08424 | 2116140.5409 | 37.790839852634605 | -122.424208065867 | (37.7908398526346, -122.424208065867) | ||
| 3558 | 3558 | 7824 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 807 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1992 12:00:00 AM | 3 | 4x4 | 6006129.00475 | 2112968.14036 | 37.7821541670221 | -122.42245352721001 | (37.7821541670221, -122.42245352721) | ||
| 3664 | 3664 | 18949 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2838 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001202.00999 | 2115627.7019 | 37.7891774657247 | -122.43968939755699 | (37.7891774657247, -122.439689397557) | |||
| 3700 | 3700 | 152810 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 2901 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2017 12:00:00 AM | 3 | 6x6 | Permit Number 777487 | 6009973.24314 | 2101608.01571 | 37.751177979599206 | -122.408352609887 | (37.7511779795992, -122.408352609887) | |
| 3720 | 3720 | 54865 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1845 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1972 12:00:00 AM | 14 | Permit Number 10724 | 5998997.2724 | 2110063.1394 | 37.77377288550579 | -122.44691690335199 | (37.7737728855058, -122.446916903352) | ||
| 3746 | 3746 | 253553 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | ||||
| 3778 | 3778 | 23411 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1755 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006198.56305 | 2116531.68812 | 37.7919427119246 | -122.42246617527799 | (37.7919427119246, -122.422466175278) | |||
| 3907 | 3907 | 253159 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 500 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2017 02:21:00 PM | 3 | 3x3 | 6004815.0 | 2092724.0 | 37.7264942782417 | -122.425558174045 | (37.7264942782417, -122.425558174045) | ||
| 3975 | 3975 | 102690 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2121 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6001369.63978 | 2115762.6346400003 | 37.789557495824106 | -122.43911909516501 | (37.7895574958241, -122.439119095165) | |||
| 4014 | 4014 | 216033 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:13:00 PM | 3 | 5996833.19651 | 2088697.5304900003 | 37.7149843051513 | -122.452860296276 | (37.7149843051513, -122.452860296276) | |||
| 4026 | 4026 | 216034 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 8 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:11:00 PM | 3 | 5996778.28459 | 2088695.06883 | 37.714974399131705 | -122.45304991653099 | (37.7149743991317, -122.453049916531) | |||
| 4056 | 4056 | 6316 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1830 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002062.1887 | 2112973.0079 | 37.7819372750965 | -122.43652320334299 | (37.7819372750965, -122.436523203343) | |||
| 4146 | 4146 | 216707 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Faxon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:46:00 AM | 3 | Width 3ft | 5994758.05727 | 2090129.91465 | 37.7187981581945 | -122.460136518501 | (37.7187981581945, -122.460136518501) | ||
| 4153 | 4153 | 216751 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 31 Granada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:38:00 AM | 3 | Width 3ft | 5995599.77101 | 2090122.1597400003 | 37.718825243070604 | -122.45722650749799 | (37.7188252430706, -122.457226507498) | ||
| 4159 | 4159 | 216846 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 246 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:48:00 PM | 3 | Width 3ft | 5994526.67673 | 2088421.6269099999 | 37.7140942946914 | -122.460812565857 | (37.7140942946914, -122.460812565857) | ||
| 4180 | 4180 | 180661 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 551 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:41:00 PM | 3 | Width 5ft | 6002181.0 | 2086340.0 | 37.7088160489029 | -122.434207604104 | (37.7088160489029, -122.434207604104) | ||
| 4280 | 4280 | 6310 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1810 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002083.1708 | 2112974.3616 | 37.7819421842971 | -122.43645071198 | (37.7819421842971, -122.43645071198) | |||
| 4308 | 4308 | 102694 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2799 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001416.78196 | 2115941.58593 | 37.7900515321059 | -122.43896881846202 | (37.7900515321059, -122.438968818462) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");