Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181815 | 181815 | 54243 | Permitted Site 1 | Tristania conferta :: 79 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.777602735942295 | -122.45061099973499 | (37.7776027359423, -122.450610999735) | ||
| 151406 | 151406 | 30437 | Permitted Site 1 | Tristania conferta :: 79 | 567 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 12 | Permit Number 90 | 6010234.0616 | 2119544.2672 | 37.8004413456091 | -122.40871589046002 | (37.8004413456091, -122.40871589046) | ||
| 96267 | 96267 | 115369 | Permitted Site 1 | Tristania conferta :: 79 | 720 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777460 | 5993541.3 | 2110551.9 | 37.7748016816289 | -122.465825344597 | (37.7748016816289, -122.465825344597) | ||
| 85477 | 85477 | 49069 | Permitted Site 1 | Tristania conferta :: 79 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.724031921729704 | -122.45654557668001 | (37.7240319217297, -122.45654557668) | ||
| 98092 | 98092 | 115300 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 99519 | 99519 | 115299 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 99798 | 99798 | 111746 | Permitted Site 1 | Tristania conferta :: 79 | 398X 03rd St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.047180001 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | |
| 140674 | 140674 | 111747 | Permitted Site 1 | Tristania conferta :: 79 | 398X 03rd St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/22/2015 12:00:00 AM | 3 | 10x20 | Permit Number 775763 | 6013296.047180001 | 2113048.21405 | 37.7827757318295 | -122.397664238011 | (37.7827757318295, -122.397664238011) | |
| 126523 | 126523 | 115380 | Permitted Site 1 | Tristania conferta :: 79 | 1657X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.2132599996 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | ||
| 108387 | 108387 | 114594 | Permitted Site 1 | Tristania conferta :: 79 | 2584 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.78500729421621 | -122.442863075731 | (37.7850072942162, -122.442863075731) | |||
| 114827 | 114827 | 114595 | Permitted Site 1 | Tristania conferta :: 79 | 2584 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.78500729421621 | -122.442863075731 | (37.7850072942162, -122.442863075731) | |||
| 80311 | 80311 | 108697 | Permitted Site 1 | Tristania conferta :: 79 | 2414 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774621 | 6000824.14262 | 2119316.97174 | 37.7992857188841 | -122.441261581656 | (37.7992857188841, -122.441261581656) |
| 22266 | 22266 | 17051 | DPW Maintained 3 | Tristania conferta :: 79 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | |
| 160132 | 160132 | 96027 | Permitted Site 1 | Tristania conferta :: 79 | 724 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 1 | 3x3 | Permit Number 773631 | 6007519.56601 | 2113828.09623 | 37.7845937435516 | -122.41770377222001 | (37.7845937435516, -122.41770377222) |
| 70474 | 70474 | 103963 | Permitted Site 1 | Tristania conferta :: 79 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467.0 | 2114127.0 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | ||
| 102667 | 102667 | 98999 | DPW Maintained 3 | Tristania conferta :: 79 | 2190X North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771149 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | |
| 121378 | 121378 | 99007 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
| 126814 | 126814 | 99009 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
| 96334 | 96334 | 109151 | Permitted Site 1 | Tristania conferta :: 79 | 727 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769036 | 5986896.6 | 2110966.4 | 37.7755542438819 | -122.48884090533001 | (37.7755542438819, -122.48884090533) |
| 8882 | 8882 | 99306 | Permitted Site 1 | Tristania conferta :: 79 | 1345 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | 3x3 | Permit Number 768843 | 6003605.0174 | 2112439.8748 | 37.780560974986 | -122.43114766452 | (37.780560974986, -122.43114766452) | ||
| 153307 | 153307 | 50650 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2012 12:00:00 AM | 2 | Permit Number 768661 | 6012184.2732 | 2112660.7106 | 37.7816497657614 | -122.401483287822 | (37.7816497657614, -122.401483287822) | ||
| 68582 | 68582 | 53100 | Permitted Site 1 | Tristania conferta :: 79 | 560@ PINE Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 1 | Permit Number 767803 | 5999200.432999999 | 2114690.2424 | 37.7864893192828 | -122.446547106561 | (37.7864893192828, -122.446547106561) | ||
| 154567 | 154567 | 89052 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767132 | 6000895.8744 | 2114188.3074 | 37.7852078310557 | -122.440645300245 | (37.7852078310557, -122.440645300245) | |
| 171370 | 171370 | 89051 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767132 | 6000933.3562 | 2114194.3706 | 37.7852266134024 | -122.440516060128 | (37.7852266134024, -122.440516060128) | |
| 46832 | 46832 | 94612 | Permitted Site 1 | Tristania conferta :: 79 | 5600@ Armstrong 03rd St | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6013990.2772 | 2092621.1644 | 37.726726080275604 | -122.393832179047 | (37.7267260802756, -122.393832179047) | ||
| 13376 | 13376 | 22408 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53653 | 6013764.0013 | 2092044.0283 | 37.7251288035961 | -122.394574017561 | (37.7251288035961, -122.394574017561) | |
| 13516 | 13516 | 22409 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53653 | 6013757.7359 | 2092026.1961 | 37.7250794916417 | -122.394594428416 | (37.7250794916417, -122.394594428416) | |
| 15366 | 15366 | 22406 | DPW Maintained 3 | Tristania conferta :: 79 | 5800 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/29/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53653 | 6013782.5564 | 2092078.9697 | 37.7252257771905 | -122.394512319608 | (37.7252257771905, -122.394512319608) | |
| 16375 | 16375 | 22415 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53653 | 6013701.5886 | 2091876.0685 | 37.7246641498069 | -122.39477801609101 | (37.7246641498069, -122.394778016091) | |
| 171611 | 171611 | 94414 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53653 | 6013808.0998 | 2092150.7804 | 37.7254243749067 | -122.394429043825 | (37.7254243749067, -122.394429043825) | |
| 14284 | 14284 | 22410 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53565 | 6013752.9164 | 2092008.8459 | 37.7250315835443 | -122.39460987462401 | (37.7250315835443, -122.394609874624) | |
| 16334 | 16334 | 22388 | Permitted Site 1 | Tristania conferta :: 79 | 5600 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2010 12:00:00 AM | 9 | 3X3 | Permit Number 53445 | 6014004.2537 | 2092658.7566 | 37.7268300775798 | -122.393786492489 | (37.7268300775798, -122.393786492489) | |
| 162998 | 162998 | 93016 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; Tree #1 on the Scott St frontage | 6000962.9097 | 2119261.1002 | 37.7991402141254 | -122.440777390622 | (37.7991402141254, -122.440777390622) | |
| 69366 | 69366 | 93014 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) |
| 171968 | 171968 | 93015 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001036.8533 | 2119267.6007 | 37.7991622735558 | -122.440521987709 | (37.7991622735558, -122.440521987709) |
| 30165 | 30165 | 40033 | Permitted Site 1 | Tristania conferta :: 79 | 1526 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53136 | 6015229.2383 | 2095373.744 | 37.7343528855845 | -122.389741265179 | (37.7343528855845, -122.389741265179) | |
| 2981 | 2981 | 245990 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.76949368743671 | -122.44394249781901 | (37.7694936874367, -122.443942497819) | |
| 2995 | 2995 | 245989 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 14 | Width 0ft | Permit Number 53135 | 5999854.6873 | 2108493.8194 | 37.7695128761205 | -122.443838207787 | (37.7695128761205, -122.443838207787) | |
| 31623 | 31623 | 92117 | Permitted Site 1 | Tristania conferta :: 79 | 2012 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52450 | 6004206.4384 | 2115352.2396 | 37.788591662793 | -122.42927479639401 | (37.788591662793, -122.429274796394) | |
| 50817 | 50817 | 82772 | Permitted Site 1 | Tristania conferta :: 79 | 1410 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52295 | 6016233.7032 | 2093926.9573 | 37.7304359474549 | -122.38616764377399 | (37.7304359474549, -122.386167643774) | |
| 169224 | 169224 | 89053 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 11 | 3x3 | Permit Number 51790 | 6000877.1335 | 2114188.3074 | 37.7852067638224 | -122.440710137812 | (37.7852067638224, -122.440710137812) | |
| 134454 | 134454 | 54141 | Permitted Site 1 | Tristania conferta :: 79 | 1432 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51418 | 5984351.9621 | 2105403.8517 | 37.7601322321577 | -122.497232578221 | (37.7601322321577, -122.497232578221) | |
| 25813 | 25813 | 50649 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51399 | 6012160.9197 | 2112637.3571 | 37.7815843393908 | -122.401562438489 | (37.7815843393908, -122.401562438489) | |
| 149440 | 149440 | 61393 | Permitted Site 1 | Tristania conferta :: 79 | 926 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50349 | 5990253.2983 | 2099081.9773 | 37.743118118565505 | -122.47636107832199 | (37.7431181185655, -122.476361078322) | |
| 40296 | 40296 | 51914 | Permitted Site 1 | Tristania conferta :: 79 | 1738 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50190 | 6004049.1514 | 2119767.1187 | 37.8007048866604 | -122.43013406376998 | (37.8007048866604, -122.43013406377) | |
| 147212 | 147212 | 51915 | Permitted Site 1 | Tristania conferta :: 79 | 1738 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50190 | 6004018.6596 | 2119764.7731 | 37.8006967192313 | -122.430239410546 | (37.8006967192313, -122.430239410546) | |
| 62156 | 62156 | 51913 | Permitted Site 1 | Tristania conferta :: 79 | 1734 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50189 | 6004067.1338 | 2119771.0279 | 37.8007166387692 | -122.43007211626801 | (37.8007166387692, -122.430072116268) | |
| 59402 | 59402 | 82190 | Permitted Site 1 | Tristania conferta :: 79 | 1954 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49859 | 5989124.369 | 2102026.7679 | 37.751138201669 | -122.48048007964701 | (37.751138201669, -122.480480079647) | |
| 60940 | 60940 | 81428 | Permitted Site 1 | Tristania conferta :: 79 | 2015 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49852 | 5990022.9826 | 2101627.3481 | 37.7500936819126 | -122.477343424721 | (37.7500936819126, -122.477343424721) | |
| 61656 | 61656 | 51541 | Permitted Site 1 | Tristania conferta :: 79 | 672 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2005 12:00:00 AM | 6 | Permit Number 47838 | 6004139.9693 | 2110987.3251 | 37.776602932276 | -122.42919340888001 | (37.776602932276, -122.42919340888) | ||
| 69416 | 69416 | 50978 | Permitted Site 1 | Tristania conferta :: 79 | 807REVISED Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2004 12:00:00 AM | 11 | Permit Number 47464 | 6008954.8893 | 2120241.9921 | 37.8022853965169 | -122.413191720991 | (37.8022853965169, -122.413191720991) | ||
| 53004 | 53004 | 50647 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012121.5394 | 2112599.3505 | 37.781477784622204 | -122.401696004131 | (37.7814777846222, -122.401696004131) | ||
| 156938 | 156938 | 50648 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | 4 | Permit Number 47233 | 6012137.5662 | 2112614.0037 | 37.7815189132409 | -122.401641589024 | (37.7815189132409, -122.401641589024) | ||
| 178219 | 178219 | 48780 | Permitted Site 1 | Tristania conferta :: 79 | 1366(REVISED) Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 5 | Permit Number 46035 | 6003524.5015 | 2112470.6769 | 37.780640986928894 | -122.431428406628 | (37.7806409869289, -122.431428406628) | ||
| 170807 | 170807 | 47606 | Permitted Site 1 | Tristania conferta :: 79 | 965 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45442 | 6011251.7668 | 2111767.4922 | 37.779145121392105 | -122.404646435966 | (37.7791451213921, -122.404646435966) | |
| 29017 | 29017 | 47568 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014701.4667 | 2115063.502 | 37.7883874115209 | -122.392943084604 | (37.7883874115209, -122.392943084604) | ||
| 47239 | 47239 | 47570 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 8 | Permit Number 45427 | 6014687.0712 | 2115049.1066 | 37.788347085442 | -122.39299188352699 | (37.788347085442, -122.392991883527) | ||
| 72028 | 72028 | 47574 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014716.8904 | 2115082.0105 | 37.7884390883158 | -122.39289101606899 | (37.7884390883158, -122.392891016069) | ||
| 153754 | 153754 | 47567 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014670.6192 | 2115035.7393 | 37.7883094680316 | -122.39304786956801 | (37.7883094680316, -122.393047869568) | ||
| 171512 | 171512 | 47581 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 10 | Permit Number 45427 | 6014732.3141 | 2115093.3212 | 37.7884710015858 | -122.39283844369801 | (37.7884710015858, -122.392838443698) | ||
| 186876 | 186876 | 47069 | Permitted Site 1 | Tristania conferta :: 79 | 606 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | 5 | Permit Number 45052 | 6004039.0188 | 2110889.0487 | 37.7763273741764 | -122.429535615559 | (37.7763273741764, -122.429535615559) | ||
| 3260 | 3260 | 42633 | DPW Maintained 3 | Tristania conferta :: 79 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) |
| 46505 | 46505 | 45601 | Permitted Site 1 | Tristania conferta :: 79 | 1100 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 10 | Permit Number 44335 | 6003419.3416 | 2112114.1133 | 37.7796559917005 | -122.431766739067 | (37.7796559917005, -122.431766739067) | ||
| 64979 | 64979 | 41551 | Permitted Site 1 | Tristania conferta :: 79 | 627 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 11 | Permit Number 42073 | 6000076.2449 | 2111080.2993 | 37.7766273307268 | -122.443257648559 | (37.7766273307268, -122.443257648559) | |
| 58534 | 58534 | 41235 | Permitted Site 1 | Tristania conferta :: 79 | 270 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | 14 | Permit Number 41940 | 5998984.5808 | 2112167.7332 | 37.7795508339841 | -122.44711229551001 | (37.7795508339841, -122.44711229551) | ||
| 181635 | 181635 | 38378 | Permitted Site 1 | Tristania conferta :: 79 | 2027 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1998 12:00:00 AM | 11 | Permit Number 40437 | 6009441.5117 | 2120654.7585 | 37.8034460574359 | -122.411536943543 | (37.8034460574359, -122.411536943543) | ||
| 159336 | 159336 | 38128 | Permitted Site 1 | Tristania conferta :: 79 | 2817 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 6 | Permit Number 40292 | 5986952.8937 | 2107070.8859 | 37.764861536167395 | -122.48835982667299 | (37.7648615361674, -122.488359826673) | |
| 51989 | 51989 | 38089 | Permitted Site 1 | Tristania conferta :: 79 | 2516 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40261 | 6000533.9120000005 | 2114143.0655 | 37.785062989588496 | -122.44189432664 | (37.7850629895885, -122.44189432664) | |
| 28394 | 28394 | 36794 | Permitted Site 1 | Tristania conferta :: 79 | 1350 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 5 | 3x3 | Permit Number 39527 | 6015278.7143 | 2090801.8757 | 37.721802191533705 | -122.38925107024599 | (37.7218021915337, -122.389251070246) | |
| 28652 | 28652 | 35644 | Permitted Site 1 | Tristania conferta :: 79 | 635 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | 9 | Permit Number 38976 | 6004498.2203 | 2110755.6153 | 37.7759869880383 | -122.427937599156 | (37.7759869880383, -122.427937599156) | ||
| 179350 | 179350 | 34684 | Permitted Site 1 | Tristania conferta :: 79 | 1863 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38349 | 6003454.9512 | 2119604.4954 | 37.800224693559606 | -122.43217862062099 | (37.8002246935596, -122.432178620621) | |
| 131053 | 131053 | 33674 | Permitted Site 1 | Tristania conferta :: 79 | 672 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 4 | Permit Number 37756 | 6004147.6576 | 2110988.6622 | 37.7766070388542 | -122.429166908178 | (37.7766070388542, -122.429166908178) | ||
| 167083 | 167083 | 32805 | Permitted Site 1 | Tristania conferta :: 79 | 1690 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 18 | Permit Number 37166 | 5999795.9625 | 2110223.9545 | 37.774260039648 | -122.444165674595 | (37.774260039648, -122.444165674595) | |
| 32641 | 32641 | 32360 | Permitted Site 1 | Tristania conferta :: 79 | 1660 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 12 | Permit Number 36912 | 6010075.9386 | 2119846.6344 | 37.8012627139137 | -122.409284411348 | (37.8012627139137, -122.409284411348) | ||
| 153560 | 153560 | 32359 | Permitted Site 1 | Tristania conferta :: 79 | 1660 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36912 | 6010078.2473 | 2119834.5139 | 37.8012295633542 | -122.40927556638901 | (37.8012295633542, -122.409275566389) | |
| 42950 | 42950 | 32145 | Permitted Site 1 | Tristania conferta :: 79 | 563 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | 11 | Permit Number 35498 | 6003116.0093 | 2110209.6426 | 37.77440958934721 | -122.432680016089 | (37.7744095893472, -122.432680016089) | ||
| 132695 | 132695 | 32143 | Permitted Site 1 | Tristania conferta :: 79 | 563 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | 9 | Permit Number 35498 | 6003111.4815 | 2110262.0358 | 37.774553191336004 | -122.432699422008 | (37.774553191336, -122.432699422008) | ||
| 58537 | 58537 | 68157 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1994 12:00:00 AM | 8 | Permit Number 33474 | 6005184.9642 | 2114742.2338 | 37.786972087045605 | -122.425845804507 | (37.7869720870456, -122.425845804507) | ||
| 37744 | 37744 | 68143 | Permitted Site 1 | Tristania conferta :: 79 | 2540 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 14 | Permit Number 31897 | 6000418.1917 | 2114124.8356 | 37.7850063402866 | -122.442293372082 | (37.7850063402866, -122.442293372082) | |
| 164839 | 164839 | 68142 | Permitted Site 1 | Tristania conferta :: 79 | 2532 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 1 | Permit Number 31896 | 6000452.2737 | 2114128.7986 | 37.785019164077 | -122.442175744115 | (37.785019164077, -122.442175744115) | |
| 163961 | 163961 | 68141 | Permitted Site 1 | Tristania conferta :: 79 | 2528 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 14 | Permit Number 31895 | 6000471.2962 | 2114132.7617 | 37.7850311298137 | -122.442110217066 | (37.7850311298137, -122.442110217066) | |
| 149964 | 149964 | 68137 | Permitted Site 1 | Tristania conferta :: 79 | 2786 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 9 | Permit Number 31889 | 6000193.312999999 | 2114445.5102 | 37.7858740103556 | -122.443094416733 | (37.7858740103556, -122.443094416733) | |
| 135276 | 135276 | 57431 | Permitted Site 1 | Tristania conferta :: 79 | 1933 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1991 12:00:00 AM | 8 | Permit Number 30044 | 6003885.286 | 2115132.8962 | 37.787971214872705 | -122.43037027907499 | (37.7879712148727, -122.430370279075) | ||
| 131538 | 131538 | 65984 | Permitted Site 1 | Tristania conferta :: 79 | 1520 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1990 12:00:00 AM | 14 | Permit Number 29013 | 6010137.4433 | 2119339.4921 | 37.7998736715658 | -122.409035773182 | (37.7998736715658, -122.409035773182) | |
| 42287 | 42287 | 65948 | Permitted Site 1 | Tristania conferta :: 79 | 550 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 12 | Permit Number 28969 | 6007606.7794 | 2113206.8791 | 37.7828929393541 | -122.41735800368299 | (37.7828929393541, -122.417358003683) | |
| 69089 | 69089 | 99869 | Permitted Site 1 | Tristania conferta :: 79 | 550 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 28969 | 6007604.2335 | 2113225.7913 | 37.7829447244363 | -122.417368152144 | (37.7829447244363, -122.417368152144) | |||
| 39695 | 39695 | 65945 | Permitted Site 1 | Tristania conferta :: 79 | 528 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/1991 12:00:00 AM | 12 | Permit Number 28966 | 6007615.5081 | 2113146.6876 | 37.7827281591619 | -122.41732353906299 | (37.7827281591619, -122.417323539063) | |
| 44249 | 44249 | 99868 | Permitted Site 1 | Tristania conferta :: 79 | 532 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 28966 | 6007610.0526 | 2113183.9663 | 37.7828302105112 | -122.41734505547599 | (37.7828302105112, -122.417345055476) | |||
| 137978 | 137978 | 65429 | Permitted Site 1 | Tristania conferta :: 79 | 679 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/1989 12:00:00 AM | 9 | Permit Number 28288 | 6010678.2615 | 2116199.1916 | 37.791281448138704 | -122.406942874303 | (37.7912814481387, -122.406942874303) | |
| 23576 | 23576 | 59517 | Permitted Site 1 | Tristania conferta :: 79 | 1649 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1988 12:00:00 AM | 11 | Permit Number 25365 | 5999918.6069 | 2110540.6202 | 37.7751365191945 | -122.443764181481 | (37.7751365191945, -122.443764181481) | ||
| 133582 | 133582 | 64370 | Permitted Site 1 | Tristania conferta :: 79 | 525 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 7 | Permit Number 25209 | 6010332.9517 | 2120250.0174 | 37.8023847002257 | -122.408423498481 | (37.8023847002257, -122.408423498481) | |
| 25331 | 25331 | 64367 | Permitted Site 1 | Tristania conferta :: 79 | 545 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 10 | Permit Number 25206 | 6010276.1583 | 2120241.7062 | 37.8023586991127 | -122.408619445814 | (37.8023586991127, -122.408619445814) | |
| 151070 | 151070 | 64341 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1988 12:00:00 AM | 11 | Permit Number 25170 | 6010046.9071 | 2120063.9383 | 37.80185775026089 | -122.40940021798299 | (37.8018577502609, -122.409400217983) | |
| 159584 | 159584 | 62838 | Permitted Site 1 | Tristania conferta :: 79 | 936 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1986 12:00:00 AM | 12 | Permit Number 23205 | 6001983.1694 | 2111715.7917 | 37.7784807863281 | -122.43670655164699 | (37.7784807863281, -122.436706551647) | ||
| 174641 | 174641 | 61380 | Permitted Site 1 | Tristania conferta :: 79 | 200 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1984 12:00:00 AM | 4 | Permit Number 21292 | 6014918.427 | 2115358.6091 | 37.78920975665721 | -122.392213077943 | (37.7892097566572, -122.392213077943) | ||
| 54892 | 54892 | 61330 | Permitted Site 1 | Tristania conferta :: 79 | 1660 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1984 12:00:00 AM | 17 | Permit Number 21234 | 5999839.3496 | 2110922.2564 | 37.77617987402729 | -122.444065777165 | (37.7761798740273, -122.444065777165) | |
| 170282 | 170282 | 61323 | Permitted Site 1 | Tristania conferta :: 79 | 1662 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1984 12:00:00 AM | 14 | Permit Number 21226 | 5999808.8917 | 2110918.1953 | 37.776166985726704 | -122.444170847057 | (37.7761669857267, -122.444170847057) | |
| 48481 | 48481 | 60596 | Permitted Site 1 | Tristania conferta :: 79 | 1773 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 18 | Permit Number 20216 | 6000702.1439 | 2111336.8084 | 37.7773673101232 | -122.44111089446899 | (37.7773673101232, -122.441110894469) | |
| 70395 | 70395 | 57906 | Permitted Site 1 | Tristania conferta :: 79 | 643 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 13 | Permit Number 20197 | 6000071.8454 | 2111132.0779 | 37.7767692506982 | -122.443276587526 | (37.7767692506982, -122.443276587526) | |
| 187473 | 187473 | 60579 | Permitted Site 1 | Tristania conferta :: 79 | 556 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 13 | Permit Number 20193 | 6000143.5821 | 2110857.5211 | 37.7760194779825 | -122.443008707696 | (37.7760194779825, -122.443008707696) |
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");