Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |||||
| 3436 | 3436 | 100973 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 0 | Permit Number 37341 | 6009614.0 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | ||
| 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) | ||
| 4004 | 4004 | 251722 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 18 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:08:00 PM | 3 | 5996685.56427 | 2088703.70423 | 37.7149927956564 | -122.45337101855101 | (37.7149927956564, -122.453371018551) | |||
| 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) | |||
| 5207 | 5207 | 100153 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 590 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 780398 | 5993481.43699 | 2111479.23814 | 37.7773444498569 | -122.46609982361299 | (37.7773444498569, -122.466099823613) | |||
| 6932 | 6932 | 36849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7065 | 7065 | 34676 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2000 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2015 12:00:00 AM | 3 | Permit Number 775668 | 6003314.31901 | 2118972.51824 | 37.7984814738846 | -122.432620094941 | (37.7984814738846, -122.432620094941) | |
| 7300 | 7300 | 36853 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7845 | 7845 | 36850 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7928 | 7928 | 62385 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 642 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/1987 12:00:00 AM | 12 | Permit Number 22535 | 6001098.1348 | 2110956.5992 | 37.776345899243495 | -122.439713770865 | (37.7763458992435, -122.439713770865) | |
| 8953 | 8953 | 58805 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1258 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1979 12:00:00 AM | 24 | Permit Number 18054 | 6006987.6862 | 2119143.01841 | 37.7991572568655 | -122.419921185614 | (37.7991572568655, -122.419921185614) | ||
| 10011 | 10011 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10111 | 10111 | 67877 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1345 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1993 12:00:00 AM | Permit Number 31567 | 6003285.36844159 | 2100415.0335047003 | 37.747525548999704 | -122.43139483291999 | (37.7475255489997, -122.43139483292) | |||
| 10591 | 10591 | 36848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 11799 | 11799 | 117444 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1133 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776191 | 6004090.20732 | 2089350.17003 | 37.7171895030573 | -122.427823460996 | (37.7171895030573, -122.427823460996) | ||
| 13322 | 13322 | 56800 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 109 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2017 12:00:00 AM | 3 | Permit Number 14027 | 5999450.563708 | 2107695.23005942 | 37.7672970916375 | -122.44517862777701 | (37.7672970916375, -122.445178627777) | ||
| 13591 | 13591 | 104984 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 246 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2013 12:00:00 AM | 3 | Permit Number 58498 | 6013841.693969999 | 2112138.9388200003 | 37.780309438982 | -122.39571278601801 | (37.780309438982, -122.395712786018) | ||
| 13709 | 13709 | 115878 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 1125X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6014969.9373 | 2096433.719 | 37.737248978447 | -122.390711808999 | (37.737248978447, -122.390711808999) | ||
| 13714 | 13714 | 36844 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 13940 | 13940 | 78887 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 701 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 3 | 6008828.13605 | 2110926.3802099996 | 37.7766998732463 | -122.412971309379 | (37.7766998732463, -122.412971309379) | |||
| 14514 | 14514 | 114502 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 701 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6008840.773440001 | 2110939.06685 | 37.7767354171383 | -122.412928489958 | (37.7767354171383, -122.412928489958) | ||||
| 14679 | 14679 | 36852 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14747 | 14747 | 36851 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16177 | 16177 | 41588 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 230 Ritch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2000 12:00:00 AM | 2 | Permit Number 769146 | 6013784.01078 | 2112196.71087 | 37.7804648589114 | -122.395916389851 | (37.7804648589114, -122.395916389851) | ||
| 16842 | 16842 | 36847 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 17887 | 17887 | 58111 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 424 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1978 12:00:00 AM | Permit Number 17089 | 5994475.54876777 | 2106701.69853806 | 37.7642838888462 | -122.462314301289 | (37.7642838888462, -122.462314301289) | |||
| 17888 | 17888 | 44169 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2100 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43638 | 6003503.99505303 | 2117958.62597334 | 37.795708342081 | -122.43189132313299 | (37.795708342081, -122.431891323133) | |||
| 18153 | 18153 | 40872 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3456 Washington St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41788 | 5998239.16759035 | 2115871.78992415 | 37.7896785829725 | -122.449958017829 | (37.7896785829725, -122.449958017829) | |||
| 19425 | 19425 | 37331 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 700 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39840 | 6003021.44463533 | 2104165.68333023 | 37.7578089842605 | -122.432575328482 | (37.7578089842605, -122.432575328482) | ||
| 20655 | 20655 | 30721 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 273 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1995 12:00:00 AM | Permit Number 34621 | 6005264.06153495 | 2109890.21668057 | 37.7736541098939 | -122.42522675761002 | (37.7736541098939, -122.42522675761) | |||
| 21240 | 21240 | 95973 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100 Geary Blvd | 2 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5988036.984 | 2112655.97284 | 37.780259822750295 | -122.48502007741101 | (37.7802598227503, -122.485020077411) | |||
| 23257 | 23257 | 22677 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1345 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6003521.2975 | 2112426.6123 | 37.7805198149428 | -122.43143634423402 | (37.7805198149428, -122.431436344234) | ||||
| 23513 | 23513 | 56574 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1931 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6010338.9406 | 2121168.3232 | 37.804906476308204 | -122.40846758735701 | (37.8049064763082, -122.408467587357) | ||||
| 23521 | 23521 | 38242 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 39 Castle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 9 | Permit Number 40356 | 6011256.15882 | 2119540.9542099996 | 37.8004894423957 | -122.40517877199301 | (37.8004894423957, -122.405178771993) | ||
| 23526 | 23526 | 64392 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1201 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1988 12:00:00 AM | 5 | Permit Number 25234 | 6006983.90328 | 2119787.2735 | 37.8009260056774 | -122.419980019268 | (37.8009260056774, -122.419980019268) | ||
| 23560 | 23560 | 53287 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2650 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1969 12:00:00 AM | 20 | Permit Number 6177 | 6005318.17677 | 2119173.14554 | 37.7991457806045 | -122.425700408062 | (37.7991457806045, -122.425700408062) | ||
| 23610 | 23610 | 107057 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 601X Davis St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/23/2014 12:00:00 AM | 9 | Permit Number 771755 | 6013145.32204 | 2118507.86888 | 37.7977582696821 | -122.398568926718 | (37.7977582696821, -122.398568926718) | ||
| 23788 | 23788 | 68963 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4620 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32952 | 5989023.65164 | 2109910.1989 | 37.772778113288396 | -122.481405638323 | (37.7727781132884, -122.481405638323) | |
| 23871 | 23871 | 66028 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3571 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1990 12:00:00 AM | 8 | Permit Number 29064 | 6001165.44461 | 2120888.94858 | 37.80362138626779 | -122.440193349751 | (37.8036213862678, -122.440193349751) | ||
| 23980 | 23980 | 57517 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3561 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 11 | Permit Number 16372 | 6001170.69813 | 2120846.62572 | 37.8035054780598 | -122.440172132938 | (37.8035054780598, -122.440172132938) | ||
| 24045 | 24045 | 211638 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993404.24438 | 2096035.5287900001 | 37.7349355669295 | -122.465244802603 | (37.7349355669295, -122.465244802603) | ||||
| 24161 | 24161 | 43309 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 120 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 11 | Permit Number 43075 | 6003986.124 | 2093106.1385400002 | 37.727496676222 | -122.428450790296 | (37.727496676222, -122.428450790296) | |
| 24242 | 24242 | 62534 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1215 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1986 12:00:00 AM | 7 | Permit Number 23530 | 6006929.966580001 | 2119780.20931 | 37.8009035702931 | -122.420166161845 | (37.8009035702931, -122.420166161845) | ||
| 24462 | 24462 | 211631 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993552.90123 | 2096075.99565 | 37.735055250506704 | -122.464733785358 | (37.7350552505067, -122.464733785358) | ||||
| 24815 | 24815 | 50693 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015899.29772 | 2115328.09963 | 37.789180398403396 | -122.388817224359 | (37.7891803984034, -122.388817224359) | |
| 25150 | 25150 | 68170 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 60 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | 4 | Permit Number 31941 | 5995910.11041 | 2112337.20723 | 37.77984002336311 | -122.45776040350201 | (37.7798400233631, -122.457760403502) | |
| 25178 | 25178 | 71050 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 11 | 6011229.446 | 2095779.1610400002 | 37.735243464197296 | -122.403598436523 | (37.7352434641973, -122.403598436523) | ||
| 25457 | 25457 | 43325 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 32 Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | 7 | Permit Number 43085 | 6004107.248369999 | 2093308.4055400002 | 37.728058909881604 | -122.42804647039301 | (37.7280589098816, -122.428046470393) | ||
| 25482 | 25482 | 66331 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1221 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 8 | Permit Number 29450 | 5986429.897000001 | 2106906.0714 | 37.7643784727426 | -122.490156589457 | (37.7643784727426, -122.490156589457) | |
| 25651 | 25651 | 113259 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3355 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | 1 | Permit Number 773558 | 6004080.684669999 | 2120720.3601599997 | 37.803324026346395 | -122.430092985602 | (37.8033240263464, -122.430092985602) | ||
| 25858 | 25858 | 34664 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3027 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 9 | Permit Number 38337 | 6003380.81501 | 2118778.72984 | 37.797953151882794 | -122.432376150266 | (37.7979531518828, -122.432376150266) | |
| 26288 | 26288 | 247985 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 495 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009773.5395 | 2099699.6998799997 | 37.7459269802441 | -122.40890858338001 | (37.7459269802441, -122.40890858338) | ||||
| 26442 | 26442 | 104409 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2601 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 5 | Permit Number 770702 | 6001086.06637 | 2117214.60045 | 37.7935280764126 | -122.44020439161301 | (37.7935280764126, -122.440204391613) | ||
| 26676 | 26676 | 247028 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 550x Valley St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6002355.441269999 | 2099181.9915400003 | 37.744087157999296 | -122.43452230856701 | (37.7440871579993, -122.434522308567) | ||||
| 26740 | 26740 | 47428 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 822 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45339 | 5983574.08653 | 2110178.2628599997 | 37.773195785140295 | -122.500275818952 | (37.7731957851403, -122.500275818952) | |
| 26874 | 26874 | 36893 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2544 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39546 | 6002527.89033 | 2116468.95933 | 37.791562719595 | -122.43516221668399 | (37.791562719595, -122.435162216684) | |
| 26880 | 26880 | 45750 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1047 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | 4 | Permit Number 44397 | 6014253.80968 | 2102241.0378400004 | 37.7531548998939 | -122.393594137083 | (37.7531548998939, -122.393594137083) | ||
| 26989 | 26989 | 30434 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 312 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 20 | Permit Number 87 | 6011372.10185 | 2119743.57684 | 37.8010522759047 | -122.40479183327601 | (37.8010522759047, -122.404791833276) | ||
| 27034 | 27034 | 43662 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 527 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 10 | Permit Number 43305 | 5992496.2384 | 2111852.6220400003 | 37.7783127726779 | -122.469535102532 | (37.7783127726779, -122.469535102532) | |
| 27043 | 27043 | 194682 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6012380.91774 | 2104784.0825900002 | 37.760033297111704 | -122.400249606728 | (37.7600332971117, -122.400249606728) | ||||
| 27094 | 27094 | 30439 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 387 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 15 | Permit Number 92 | 6011071.279159999 | 2119657.8360900003 | 37.8008000340602 | -122.40582677131201 | (37.8008000340602, -122.405826771312) | ||
| 27305 | 27305 | 66143 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 39 Capra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1990 12:00:00 AM | 11 | Permit Number 29207 | 6001439.51232 | 2120575.2104599997 | 37.8027755442143 | -122.439222426376 | (37.8027755442143, -122.439222426376) | ||
| 27338 | 27338 | 30314 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 501 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1955 12:00:00 AM | 16 | Permit Number 11 | 6012997.66979 | 2104676.5076900003 | 37.759772291367895 | -122.39810899635401 | (37.7597722913679, -122.398108996354) | ||
| 27457 | 27457 | 50206 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 718@ BALBOA 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 8 | Permit Number 46914 | 5987576.49801 | 2111020.59392 | 37.7757427005024 | -122.486492983703 | (37.7757427005024, -122.486492983703) | |
| 27517 | 27517 | 69385 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1994 12:00:00 AM | 9 | Permit Number 33487 | 6002040.76284 | 2120656.7267400003 | 37.80303356151371 | -122.437147636457 | (37.8030335615137, -122.437147636457) | ||
| 27715 | 27715 | 42726 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42732 | 6013650.2169699995 | 2093413.4098599998 | 37.728882521597704 | -122.395063232696 | (37.7288825215977, -122.395063232696) | |
| 27995 | 27995 | 211600 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5993318.7926 | 2096075.03242 | 37.7350391058631 | -122.465543105951 | (37.7350391058631, -122.465543105951) | ||||
| 28084 | 28084 | 77894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 479 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 6 | 5991229.4686 | 2112148.09149 | 37.7790507581941 | -122.47393884706999 | (37.7790507581941, -122.47393884707) | ||
| 28117 | 28117 | 30895 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 277 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 0 | Permit Number 34722 | 6007546.16633 | 2097390.33337 | 37.7394609554657 | -122.416447004725 | (37.7394609554657, -122.416447004725) | ||
| 28193 | 28193 | 46643 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2101 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2006 12:00:00 AM | 12 | Permit Number 48782 | 6000895.24514 | 2115599.57572 | 37.789082773401 | -122.440748744963 | (37.789082773401, -122.440748744963) | ||
| 28237 | 28237 | 62186 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 174 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1985 12:00:00 AM | 17 | Permit Number 22304 | 6000257.89906 | 2092372.7858099998 | 37.7252713784684 | -122.44128665285601 | (37.7252713784684, -122.441286652856) | |
| 28296 | 28296 | 33101 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 450X Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11/01/1997 12:00:00 AM | 14 | Permit Number 37341 | 6009682.3141 | 2120901.0273 | 37.804135754366996 | -122.410721035819 | (37.804135754367, -122.410721035819) | |
| 28585 | 28585 | 31675 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2785 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1995 12:00:00 AM | 14 | Permit Number 35181 | 6000858.21025 | 2116517.52276 | 37.7916011080616 | -122.440942759298 | (37.7916011080616, -122.440942759298) | ||
| 28816 | 28816 | 61080 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 241 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/1983 12:00:00 AM | 8 | Permit Number 20917 | 5994283.18498 | 2113897.36917 | 37.784030209353205 | -122.463501869751 | (37.7840302093532, -122.463501869751) | |
| 28992 | 28992 | 211670 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 217 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5999288.54786 | 2094050.18318 | 37.7298218544765 | -122.444758108808 | (37.7298218544765, -122.444758108808) | ||||
| 29314 | 29314 | 39772 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1910 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/1999 12:00:00 AM | 8 | Permit Number 41139 | 6003764.46206 | 2118338.94532 | 37.7967673633795 | -122.431017217997 | (37.7967673633795, -122.431017217997) | ||
| 29475 | 29475 | 55471 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1255 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 14 | Permit Number 11423 | 6001823.2847 | 2110804.4651 | 37.77596942496589 | -122.437194384356 | (37.7759694249659, -122.437194384356) | ||
| 29479 | 29479 | 41090 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 786 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2012 12:00:00 AM | 2 | Permit Number 769357 | 6008584.67431 | 2110730.60611 | 37.7761486544591 | -122.41379966681801 | (37.7761486544591, -122.413799666818) | |
| 29574 | 29574 | 66047 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 465 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 9 | Permit Number 29210 | 6001137.14728 | 2121594.78406 | 37.805557811007795 | -122.44034192404399 | (37.8055578110078, -122.440341924044) | |
| 29576 | 29576 | 51040 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 217 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47513 | 5994587.758219999 | 2113987.88412 | 37.7842962826563 | -122.46245473236999 | (37.7842962826563, -122.46245473237) | ||
| 29654 | 29654 | 71164 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2118 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 8 | 5988230.9552 | 2100880.1949 | 37.7479380567645 | -122.483485514105 | (37.7479380567645, -122.483485514105) | ||
| 29746 | 29746 | 60372 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1447 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 16 | Permit Number 19950 | 6015678.2715 | 2094616.9279 | 37.7322997108216 | -122.388135999617 | (37.7322997108216, -122.388135999617) | |
| 29781 | 29781 | 59800 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2546 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1983 12:00:00 AM | 9 | Permit Number 20230 | 6000723.39827 | 2118960.2545 | 37.7983005284994 | -122.441584578488 | (37.7983005284994, -122.441584578488) | ||
| 29812 | 29812 | 64453 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1460 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1988 12:00:00 AM | 10 | Permit Number 25320 | 6015347.6836 | 2092145.065 | 37.7254941474159 | -122.389106397393 | (37.7254941474159, -122.389106397393) | ||
| 29970 | 29970 | 46826 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 328 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44903 | 6002917.81279 | 2091602.47659 | 37.723307445271395 | -122.432036615698 | (37.7233074452714, -122.432036615698) | |
| 30023 | 30023 | 70582 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 378 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | 11 | 5989683.1552 | 2112826.61361 | 37.7808241030077 | -122.47933776325199 | (37.7808241030077, -122.479337763252) | ||
| 30097 | 30097 | 72634 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2010 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/1997 12:00:00 AM | 12 | 6003244.46137 | 2118963.59637 | 37.798453014854296 | -122.432861186113 | (37.7984530148543, -122.432861186113) | ||
| 30272 | 30272 | 62301 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 120 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 5 | Permit Number 22439 | 5996807.1749 | 2112239.3094 | 37.7796227154139 | -122.45465000433701 | (37.7796227154139, -122.454650004337) | |
| 30290 | 30290 | 44181 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3731 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2000 12:00:00 AM | 8 | Permit Number 43642 | 6000618.49035 | 2121167.17319 | 37.8043541619898 | -122.442106089925 | (37.8043541619898, -122.442106089925) | ||
| 30364 | 30364 | 33258 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1339 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2010 12:00:00 AM | 1 | Permit Number 53720 | 5989000.4071 | 2098969.5467 | 37.742736673646704 | -122.480684961581 | (37.7427366736467, -122.480684961581) | ||
| 30771 | 30771 | 38849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1567 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 7 | Permit Number 40677 | 5989916.7814 | 2104701.8649 | 37.7585293267062 | -122.477935407418 | (37.7585293267062, -122.477935407418) | |
| 30890 | 30890 | 64882 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 132 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1989 12:00:00 AM | 9 | Permit Number 25905 | 5998296.6179 | 2110156.857 | 37.7739901566936 | -122.449347321383 | (37.7739901566936, -122.449347321383) | |
| 31060 | 31060 | 50697 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015787.30845 | 2115222.67912 | 37.7888847301024 | -122.389197332691 | (37.7888847301024, -122.389197332691) |
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");