trees
7,157 rows where qSpecies_id = 36 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9312 | 31473 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 578 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 11 | Permit Number 35039 | 6002695.22363 | 2102125.35397 | 37.7521882213307 | -122.433557724529 | (37.7521882213307, -122.433557724529) | 2 | 4 | 5 | 28862 | 22 | |
| 9407 | 51009 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2502 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2004 12:00:00 AM | 6 | Permit Number 47486 | 6002662.86161 | 2116482.89118 | 37.7916086362759 | -122.434696214977 | (37.7916086362759, -122.434696214977) | 13 | 9 | 1 | 29490 | 27 | ||
| 9496 | 36851 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 9583 | 259871 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 901x Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 9649 | 85308 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 95 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2007 12:00:00 AM | 14 | Permit Number 49592 | 5994244.83288 | 2114975.13056 | 37.7869872396049 | -122.463712803164 | (37.7869872396049, -122.463712803164) | 11 | 6 | 1 | 54 | 11 | ||
| 9673 | 73533 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2167 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988506.4537 | 2100580.6191 | 37.7471315320336 | -122.482510915675 | (37.7471315320336, -122.482510915675) | 1 | 8 | 3 | 29491 | 35 | |||
| 9769 | 72164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1555 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004416.60562 | 2120115.89629 | 37.8016833445826 | -122.42888739946 | (37.8016833445826, -122.42888739946) | 13 | 9 | 1 | 57 | 17 | |||
| 9786 | 72365 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 670 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5991322.83408 | 2110838.60197 | 37.7754606658684 | -122.47352031836 | (37.7754606658684, -122.47352031836) | 11 | 6 | 2 | 54 | 26 | |||
| 9825 | 259868 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 9991 | 43309 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 120 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 11 | Permit Number 43075 | 6003986.124 | 2093106.13854 | 37.727496676222 | -122.428450790296 | (37.727496676222, -122.428450790296) | 9 | 7 | 6 | 28861 | 5 | |
| 10117 | 247028 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 550x Valley St | 6 | Median : Yard | Tree | DPW 1 | 10 | 6002355.44127 | 2099181.99154 | 37.7440871579993 | -122.434522308567 | (37.7440871579993, -122.434522308567) | 2 | 7 | 5 | 63 | 22 | ||||
| 10120 | 65814 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 90 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1990 12:00:00 AM | 12 | Permit Number 28802 | 5995920.72408 | 2113894.39262 | 37.7841162495703 | -122.457836400071 | (37.7841162495703, -122.457836400071) | 11 | 6 | 1 | 54 | 31 | |
| 10359 | 40375 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2728 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1999 12:00:00 AM | 4 | Permit Number 41487 | 5996505.83385 | 2111300.90589 | 37.7770288177662 | -122.455624619381 | (37.7770288177662, -122.455624619381) | 11 | 6 | 2 | 54 | 16 | ||
| 10403 | 58111 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 424 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/1978 12:00:00 AM | Permit Number 17089 | 5994475.54876777 | 2106701.69853806 | 37.7642838888462 | -122.462314301289 | (37.7642838888462, -122.462314301289) | 11 | 5 | 11 | 56 | 12 | |||
| 10530 | 50696 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015925.73831 | 2115354.86226 | 37.7892553479159 | -122.388727611399 | (37.7892553479159, -122.388727611399) | 6 | 2 | 9 | 28855 | 6 | |
| 10534 | 80777 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 307 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6012947.09697 | 2105591.10387 | 37.7622807541866 | -122.398348076615 | (37.7622807541866, -122.398348076615) | 10 | 3 | 8 | 28856 | 29 | |||
| 10587 | 72371 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 656 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5990684.35587 | 2110897.8962 | 37.7755864763334 | -122.475733274071 | (37.7755864763334, -122.475733274071) | 11 | 6 | 2 | 54 | 26 | |||
| 10692 | 72329 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2618 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5996593.28486 | 2110816.23096 | 37.7757030454034 | -122.455287065722 | (37.7757030454034, -122.455287065722) | 11 | 6 | 2 | 54 | 16 | |||
| 10738 | 50688 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015806.91345 | 2115242.27212 | 37.7889396148166 | -122.389130870094 | (37.7889396148166, -122.389130870094) | 6 | 2 | 9 | 28855 | 6 | |
| 10854 | 31785 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 15 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35256 | 6001632.60531 | 2108617.48502 | 37.7699536826355 | -122.437697329081 | (37.7699536826355, -122.437697329081) | 15 | 5 | 5 | 29492 | 9 | |
| 11072 | 73642 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1453 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002204.6528 | 2111546.6075 | 37.7780288334744 | -122.435928249132 | (37.7780288334744, -122.435928249132) | 15 | 5 | 11 | 29492 | 41 | |||
| 11158 | 70931 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6007940.72744 | 2117762.47273 | 37.7954202679833 | -122.416525483181 | (37.7954202679833, -122.416525483181) | 5 | 1 | 10 | 28858 | 21 | |||
| 11221 | 62565 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 480 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 8 | Permit Number 22766 | 6011454.23146 | 2106177.44439 | 37.7638074405886 | -122.403552620571 | (37.7638074405886, -122.403552620571) | 8 | 3 | 8 | 28856 | 29 | |
| 11236 | 36848 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 11314 | 36850 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 11400 | 65756 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2902 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 12 | Permit Number 28719 | 6004350.14123 | 2119136.9474 | 37.7989916413017 | -122.429047558797 | (37.7989916413017, -122.429047558797) | 13 | 9 | 1 | 57 | 17 | |
| 11460 | 63576 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1338 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 15 | Permit Number 24199 | 6006572.91263 | 2119424.6078 | 37.7999070540349 | -122.421376454187 | (37.7999070540349, -122.421376454187) | 13 | 9 | 1 | 28858 | 32 | |
| 11479 | 110887 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 800 INDIANA ST | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
| 11527 | 50695 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 4 | Permit Number 47259 | 6015937.15224 | 2115364.30383 | 37.7892819048945 | -122.388688779581 | (37.7892819048945, -122.388688779581) | 6 | 2 | 9 | 28855 | 6 | |
| 11546 | 60372 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1447 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | Permit Number 19950 | 6015678.2715 | 2094616.9279 | 37.7322997108216 | -122.388135999617 | (37.7322997108216, -122.388135999617) | 10 | 3 | 8 | 58 | 1 | |
| 11557 | 74123 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1810 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989871.6002 | 2113390.52641 | 37.7823833935167 | -122.47872710108 | (37.7823833935167, -122.47872710108) | 11 | 6 | 2 | 55 | 26 | |||
| 11570 | 66036 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3737 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1990 12:00:00 AM | 7 | Permit Number 29073 | 6000613.44807 | 2121211.22675 | 37.8044748339084 | -122.442126703295 | (37.8044748339084, -122.442126703295) | 13 | 9 | 1 | 57 | 17 | ||
| 11627 | 62574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 821 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 11 | Permit Number 22777 | 6011604.66558 | 2104535.51426 | 37.759307468671 | -122.402916822353 | (37.759307468671, -122.402916822353) | 10 | 3 | 8 | 28856 | 29 | |
| 11780 | 73541 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1944 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003405.1717 | 2115462.6704 | 37.7888494837108 | -122.432054945508 | (37.7888494837108, -122.432054945508) | 13 | 9 | 1 | 29490 | 27 | |||
| 11842 | 37629 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 767 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 7 | Permit Number 40047 | 5990664.28221 | 2110159.18013 | 37.7735570004083 | -122.475748756519 | (37.7735570004083, -122.475748756519) | 11 | 6 | 2 | 55 | 26 | |
| 11879 | 61558 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2115 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 12 | Permit Number 21518 | 6012123.87713 | 2102790.03416 | 37.7545437427056 | -122.400998483915 | (37.7545437427056, -122.400998483915) | 10 | 3 | 8 | 28856 | 29 | |
| 12182 | 50691 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015877.9319 | 2115306.82257 | 37.7891207922267 | -122.388889662052 | (37.7891207922267, -122.388889662052) | 6 | 2 | 9 | 28855 | 6 | |
| 12283 | 69918 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1285 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986443.4748 | 2106504.0514 | 37.7632754302753 | -122.490080055854 | (37.7632754302753, -122.490080055854) | 1 | 8 | 3 | 56 | 35 | |||
| 12340 | 100198 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 81 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 22 | Permit Number 769099 | 5994239.22854 | 2115068.80691 | 37.7872441264014 | -122.463738994433 | (37.7872441264014, -122.463738994433) | 11 | 6 | 1 | 54 | 11 | ||
| 12585 | 50687 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015799.79693 | 2115231.88408 | 37.7889106971282 | -122.389154766877 | (37.7889106971282, -122.389154766877) | 6 | 2 | 9 | 28855 | 6 | |
| 12632 | 67562 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1165 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 774855 | 6011714 | 2102959 | 37.7549848131441 | -122.402427835541 | (37.7549848131441, -122.402427835541) | 10 | 3 | 8 | 28856 | 29 | |
| 12719 | 49732 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1300@ REVERE Griffith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | 10 | 3 | 8 | 58 | 1 | ||
| 12731 | 107057 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 601X Davis St | 2 | Front Yard : Yard | Tree | Private 2 | 07/23/2014 12:00:00 AM | 9 | Permit Number 771755 | 6013145.32204 | 2118507.86888 | 37.7977582696821 | -122.398568926718 | (37.7977582696821, -122.398568926718) | 3 | 1 | 10 | 28860 | 6 | ||
| 12732 | 36844 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 12805 | 47349 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 247 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45275 | 5994440.83573449 | 2091551.9214492 | 37.7226843967426 | -122.461336047264 | (37.7226843967426, -122.461336047264) | 9 | 8 | 4 | 28861 | 24 | ||
| 12875 | 211638 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 605x Saint Francis Blvd | 1 | Median : Yard | Tree | DPW 1 | 12 | 5993404.24438 | 2096035.52879 | 37.7349355669295 | -122.465244802603 | (37.7349355669295, -122.465244802603) | 9 | 8 | 4 | 59 | 40 | ||||
| 12945 | 259352 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 515 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010484.82001 | 2092237.9164 | 37.7254783296878 | -122.405923513526 | (37.7254783296878, -122.405923513526) | 10 | 3 | 7 | 309 | 28 | ||
| 13361 | 72451 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 414 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988763.49233 | 2112460.48142 | 37.7797653488678 | -122.48249245159 | (37.7797653488678, -122.48249245159) | 11 | 6 | 2 | 55 | 26 | |||
| 13453 | 51040 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 217 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47513 | 5994587.75822 | 2113987.88412 | 37.7842962826563 | -122.46245473237 | (37.7842962826563, -122.46245473237) | 11 | 6 | 2 | 54 | 11 | ||
| 13476 | 259858 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 13547 | 61789 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1261 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 12 | Permit Number 21811 | 6012000.09719 | 2102515.85031 | 37.753783988256 | -122.401407282443 | (37.753783988256, -122.401407282443) | 10 | 3 | 8 | 28856 | 29 | |
| 13628 | 73441 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1840 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989754.2501 | 2113384.48014 | 37.7823599777377 | -122.479132633835 | (37.7823599777377, -122.479132633835) | 11 | 6 | 2 | 55 | 26 | |||
| 13629 | 37178 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 83 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39751 | 6006286.91240997 | 2099581.31244652 | 37.7454059949527 | -122.420956479029 | (37.7454059949527, -122.420956479029) | 2 | 7 | 7 | 28859 | 2 | ||
| 13693 | 61142 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2187 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1983 12:00:00 AM | 14 | Permit Number 20995 | 5997376.3253 | 2110185.1441 | 37.7740151408996 | -122.452532794364 | (37.7740151408996, -122.452532794364) | 15 | 5 | 11 | 29492 | 16 | |
| 13694 | 50607 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 4067X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2003 12:00:00 AM | 1 | Permit Number 47206 | 6002720.98280679 | 2102371.33873302 | 37.7528650986203 | -122.43348622256 | (37.7528650986203, -122.43348622256) | 2 | 4 | 5 | 28862 | 22 | ||
| 13807 | 71448 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1030 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011614.73256 | 2118874.74994 | 37.7986802465545 | -122.403891048929 | (37.7986802465545, -122.403891048929) | 3 | 1 | 10 | 308 | 23 | |||
| 13826 | 71652 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 403 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5998109.83834 | 2115116.24613 | 37.7875966590072 | -122.450350995309 | (37.7875966590072, -122.450350995309) | 11 | 6 | 1 | 54 | 31 | |||
| 13913 | 70514 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3466 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5997689.04386 | 2116122.25538 | 37.7903348014597 | -122.451879457883 | (37.7903348014597, -122.451879457883) | 11 | 6 | 1 | 54 | 31 | |||
| 14041 | 71278 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2906 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004343.56511 | 2119183.30119 | 37.7991185446364 | -122.42907362116 | (37.7991185446364, -122.42907362116) | 13 | 9 | 1 | 57 | 17 | |||
| 14161 | 78432 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 507 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013000.32671 | 2104653.2248 | 37.7597085096455 | -122.398098173887 | (37.7597085096455, -122.398098173887) | 10 | 3 | 8 | 28856 | 29 | |||
| 14162 | 72634 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2010 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6003244.46137 | 2118963.59637 | 37.7984530148543 | -122.432861186113 | (37.7984530148543, -122.432861186113) | 13 | 9 | 1 | 57 | 17 | |||
| 14419 | 61787 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1273 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 14 | Permit Number 21809 | 6012001.97986 | 2102456.42522 | 37.7536209249885 | -122.401396595781 | (37.7536209249885, -122.401396595781) | 10 | 3 | 8 | 28856 | 29 | |
| 14544 | 105135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X ESMERALDA AVE | 1 | unknown : Yard | Tree | DPW 1 | 26 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
| 14597 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 38 08th St | 4 | Front Yard : Cutout | Tree | Private 2 | Permit Number 769156 | 6008506.93846 | 2111466.36236 | 37.7781645006636 | -122.414120641632 | (37.7781645006636, -122.414120641632) | 8 | 2 | 9 | 28853 | 34 | ||||
| 14640 | 50694 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 3 | Permit Number 47259 | 6015915.16555 | 2115344.32909 | 37.7892258402606 | -122.388763456582 | (37.7892258402606, -122.388763456582) | 6 | 2 | 9 | 28855 | 6 | |
| 14693 | 43323 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 32 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2000 12:00:00 AM | 7 | Permit Number 43085 | 6004093.33375 | 2093284.16065 | 37.7279915515619 | -122.428092846628 | (37.7279915515619, -122.428092846628) | 9 | 7 | 6 | 28861 | 5 | ||
| 14694 | 62570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 724 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1986 12:00:00 AM | 3 | Permit Number 22772 | 6011520.14488 | 2104981.06827 | 37.7605261408991 | -122.403240480274 | (37.7605261408991, -122.403240480274) | 10 | 3 | 8 | 28856 | 29 | |
| 14729 | 259859 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 14960 | 45753 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 806 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | Permit Number 44399 | 6011825.65444004 | 2104622.45579414 | 37.7595585281932 | -122.402158643537 | (37.7595585281932, -122.402158643537) | 10 | 3 | 8 | 28856 | 29 | |||
| 15061 | 60493 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1239 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/1982 12:00:00 AM | 10 | Permit Number 20091 | 6001789.8437 | 2112780.6997 | 37.7813937658258 | -122.437451614492 | (37.7813937658258, -122.437451614492) | 15 | 5 | 11 | 29490 | 41 | |
| 15088 | 259098 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 845 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2019 12:00:00 AM | 3 | 6009938.01454 | 2087068.94557 | 37.7112548049103 | -122.407449529399 | (37.7112548049103, -122.407449529399) | 9 | 7 | 8 | 309 | 39 | |||
| 15148 | 260466 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1 Masonic Ave | 1 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
| 15320 | 80077 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2410 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6001426.32378 | 2118363.43589 | 37.7967018441792 | -122.439109452666 | (37.7967018441792, -122.439109452666) | 13 | 9 | 1 | 57 | 17 | |||
| 15510 | 72306 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3434 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5997784.02089 | 2116132.98563 | 37.7903697032501 | -122.451551619911 | (37.7903697032501, -122.451551619911) | 11 | 6 | 1 | 54 | 31 | |||
| 15705 | 260554 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151x Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 08/26/2017 12:00:00 AM | 3 | ||||||||||||
| 15850 | 57517 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3561 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 11 | Permit Number 16372 | 6001170.69813 | 2120846.62572 | 37.8035054780598 | -122.440172132938 | (37.8035054780598, -122.440172132938) | 13 | 9 | 1 | 57 | 17 | ||
| 15854 | 50686 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015866.59166 | 2115301.03346 | 37.7891042680871 | -122.388928493857 | (37.7891042680871, -122.388928493857) | 6 | 2 | 9 | 28855 | 6 | |
| 15909 | 133179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Francisco St | 14 | Front Yard : Yard | Tree | Private 2 | 4 | 6010446.38311 | 2121337.68774 | 37.8053775257257 | -122.408107720898 | (37.8053775257257, -122.408107720898) | 3 | 1 | 10 | 308 | 23 | ||||
| 15935 | 259870 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 16266 | 60348 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1404 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 6 | Permit Number 19926 | 6015899.7652 | 2094527.3411 | 37.7320659929368 | -122.387363991073 | (37.7320659929368, -122.387363991073) | 10 | 3 | 8 | 58 | 1 | |
| 16287 | 72074 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 237 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994282.02701 | 2113925.93358 | 37.7841085727696 | -122.463507949558 | (37.7841085727696, -122.463507949558) | 11 | 6 | 2 | 54 | 11 | |||
| 16317 | 61784 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1285 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 8 | Permit Number 21806 | 6012002.08043 | 2102385.34291 | 37.7534257541042 | -122.401391252916 | (37.7534257541042, -122.401391252916) | 10 | 3 | 8 | 28856 | 29 | |
| 16340 | 96970 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 900 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 17188 | 6009149.94694 | 2116056.12479 | 37.7908029831285 | -122.412220707334 | (37.7908029831285, -122.412220707334) | 5 | 1 | 10 | 28857 | 21 | |||
| 16440 | 71588 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 133 Goethe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5994866.39831 | 2086497.93294 | 37.7088318236054 | -122.45949912848 | (37.7088318236054, -122.45949912848) | 9 | 8 | 6 | 28861 | 25 | |||
| 16511 | 72028 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2034 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007710.76257 | 2119396.18485 | 37.7998930983429 | -122.417437039611 | (37.7998930983429, -122.417437039611) | 5 | 1 | 1 | 308 | 32 | |||
| 16736 | 73545 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1620 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007910.76881 | 2117984.0068 | 37.7960268607141 | -122.4166448466 | (37.7960268607141, -122.4166448466) | 5 | 1 | 10 | 28858 | 21 | |||
| 16905 | 35711 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 271 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40008 | 6002102.4473232 | 2104292.82421891 | 37.7581059239319 | -122.435762694984 | (37.7581059239319, -122.435762694984) | 2 | 4 | 5 | 28862 | 3 | ||
| 16925 | 63583 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2351 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 9 | Permit Number 24208 | 6006705.30109 | 2119319.99984 | 37.7996272902269 | -122.420910908407 | (37.7996272902269, -122.420910908407) | 5 | 9 | 1 | 28858 | 32 | |
| 17026 | 259869 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99x Peabody St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 17075 | 70582 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 378 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5989683.1552 | 2112826.61361 | 37.7808241030077 | -122.479337763252 | (37.7808241030077, -122.479337763252) | 11 | 6 | 2 | 55 | 26 | |||
| 17094 | 58287 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 335 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1978 12:00:00 AM | Permit Number 17301 | 6002954.56301529 | 2106290.38431517 | 37.7636391085514 | -122.432958425945 | (37.7636391085514, -122.432958425945) | 15 | 4 | 5 | 28862 | 3 | |||
| 17431 | 78218 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1127 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6009634.99445 | 2090933.49058 | 37.7218490839521 | -122.408769313469 | (37.7218490839521, -122.408769313469) | 10 | 3 | 7 | 309 | 28 | |||
| 17836 | 72303 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 665 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009725.8283 | 2120167.3092 | 37.8021235862289 | -122.410518608839 | (37.8021235862289, -122.410518608839) | 3 | 1 | 10 | 308 | 23 | |||
| 17981 | 50697 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2004 12:00:00 AM | 5 | Permit Number 47259 | 6015787.30845 | 2115222.67912 | 37.7888847301024 | -122.389197332691 | (37.7888847301024, -122.389197332691) | 6 | 2 | 9 | 28855 | 6 | |
| 18045 | 36852 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 18121 | 49353 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1875@ EVANS Marin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 6 | Permit Number 46338 | 6013883.32752 | 2100506.62327 | 37.7483719742819 | -122.394753893798 | (37.7483719742819, -122.394753893798) | 10 | 3 | 8 | 58 | 1 | ||
| 18207 | 77894 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 479 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991229.4686 | 2112148.09149 | 37.7790507581941 | -122.47393884707 | (37.7790507581941, -122.47393884707) | 11 | 6 | 2 | 54 | 26 | |||
| 18552 | 60416 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19997 | 6015487.5561 | 2094405.0524 | 37.7317073747329 | -122.388780566326 | (37.7317073747329, -122.388780566326) | 10 | 3 | 8 | 58 | 1 | |
| 18627 | 95959 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 5100 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 1 | 5991179.18244 | 2112771.35122 | 37.780759144985 | -122.474158294453 | (37.780759144985, -122.474158294453) | 11 | 6 | 2 | 54 | 26 | |||
| 18639 | 261254 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 245 Euclid Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | 5998181.06314 | 2113969.03195 | 37.7844507871641 | -122.450021856673 | (37.7844507871641, -122.450021856673) | 15 | 6 | 1 | 54 | 31 |
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) );