Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 110986 | 110986 | 12738 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/2013 12:00:00 AM | 100 | 4x4 | 5990343.3046 | 2114764.5197400004 | 37.7861833727245 | -122.47719566934299 | (37.7861833727245, -122.477195669343) | ||
| 125579 | 125579 | 1467 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5995559.29766 | 2114744.3111900003 | 37.786429126950104 | -122.45914836167401 | (37.7864291269501, -122.459148361674) | |||
| 18818 | 18818 | 10127 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 892 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6005646.424 | 2103793.6441599997 | 37.7569359627397 | -122.42347059841002 | (37.7569359627397, -122.42347059841) | |||
| 108155 | 108155 | 12781 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1914 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1997 12:00:00 AM | 40 | 3X3 | 5989486.1909300005 | 2114733.67338 | 37.786048911885096 | -122.48015876501101 | (37.7860489118851, -122.480158765011) | ||
| 128353 | 128353 | 432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 30 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
| 21052 | 21052 | 16925 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 512 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 6004419.62206 | 2110173.45228 | 37.7743840640969 | -122.42816799305099 | (37.7743840640969, -122.428167993051) | ||||
| 77386 | 77386 | 29759 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
| 110018 | 110018 | 29757 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
| 88350 | 88350 | 62378 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1985 12:00:00 AM | 24 | Permit Number 22527 | 5986003.033530001 | 2111613.32749 | 37.7772783336166 | -122.491979564694 | (37.7772783336166, -122.491979564694) | |
| 78031 | 78031 | 12721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1535 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5990655.40582 | 2114718.61196 | 37.7860754253896 | -122.476112538286 | (37.7860754253896, -122.476112538286) | ||
| 92244 | 92244 | 12608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5993288.45121 | 2114872.37286 | 37.786649939560796 | -122.46701416661199 | (37.7866499395608, -122.467014166612) | |||
| 118517 | 118517 | 431 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
| 128148 | 128148 | 12774 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989637.59951 | 2114741.75598 | 37.7860799008728 | -122.479635529609 | (37.7860799008728, -122.479635529609) | ||
| 128791 | 128791 | 12775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989652.1071 | 2114741.09637 | 37.786078932501 | -122.47958528952 | (37.786078932501, -122.47958528952) | ||
| 2885 | 2885 | 205488 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5990862.44739 | 2105654.74875 | 37.761200533507 | -122.474734450646 | (37.761200533507, -122.474734450646) | |||
| 163820 | 163820 | 117670 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7751 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5982957.689809999 | 2112492.79061 | 37.779514605287794 | -122.502579326611 | (37.7795146052878, -122.502579326611) | |||
| 16106 | 16106 | 12141 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016374.05041 | 2095443.42618 | 37.7346076354195 | -122.38578809634899 | (37.7346076354195, -122.385788096349) | |||
| 164940 | 164940 | 123706 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 448 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5994137.21954 | 2111457.4203 | 37.7773223559503 | -122.46382969194201 | (37.7773223559503, -122.463829691942) | |||
| 21591 | 21591 | 27507 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1398 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6005804.30319 | 2100875.6461400003 | 37.7489327240794 | -122.42271723090799 | (37.7489327240794, -122.422717230908) | |||
| 16442 | 16442 | 68888 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1958 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32860 | 6011521.066430001 | 2093598.7946799998 | 37.7292729200062 | -122.40243692791701 | (37.7292729200062, -122.402436927917) | |
| 5559 | 5559 | 98004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1908 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2015 12:00:00 AM | 14 | 5x5 | Permit Number 775450 | 6003753.55269 | 2119031.9849799997 | 37.79866965343071 | -122.43110445762301 | (37.7986696534307, -122.431104457623) | |
| 47439 | 47439 | 21845 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 211X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994919.338930001 | 2111427.06219 | 37.7772840400997 | -122.461121905578 | (37.7772840400997, -122.461121905578) | |||
| 54192 | 54192 | 242340 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 232 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997593.66914 | 2106162.79262 | 37.76298324339871 | -122.45149078527099 | (37.7629832433987, -122.451490785271) | |||
| 73194 | 73194 | 68936 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 478 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 14 | Permit Number 32920 | 5992529.16235 | 2112200.80939 | 37.7792707032176 | -122.46944655916401 | (37.7792707032176, -122.469446559164) | |
| 155194 | 155194 | 61450 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 640 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1984 12:00:00 AM | 13 | Permit Number 21385 | 5994737.55869 | 2111158.11086 | 37.7765351088199 | -122.46173123194299 | (37.7765351088199, -122.461731231943) | ||
| 11259 | 11259 | 25305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 12 | 3X3 | 5999583.38871 | 2091602.23425 | 37.7231171747905 | -122.443563033915 | (37.7231171747905, -122.443563033915) | ||
| 14912 | 14912 | 61587 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 835 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/2010 12:00:00 AM | 12 | 6x4.5 | Permit Number 53711 | 6012777.55952 | 2103581.4940400003 | 37.7567533616886 | -122.39879340469999 | (37.7567533616886, -122.3987934047) |
| 15469 | 15469 | 12131 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016434.11275 | 2095220.18267 | 37.7339979769066 | -122.38556488553499 | (37.7339979769066, -122.385564885535) | |||
| 16089 | 16089 | 71389 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770154 | 6015658.34523 | 2096378.9353200002 | 37.7371367232675 | -122.388327823184 | (37.7371367232675, -122.388327823184) | |
| 21230 | 21230 | 28488 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1056 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 12 | 3X3 | 6005699.27295 | 2102829.0400099996 | 37.754290366819 | -122.423219261259 | (37.754290366819, -122.423219261259) | ||
| 22160 | 22160 | 24821 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 12 | 3x3 | 6007884.87342 | 2094945.99869 | 37.7327683887373 | -122.41510292745701 | (37.7327683887373, -122.415102927457) | ||
| 31345 | 31345 | 54056 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1972 12:00:00 AM | 12 | Permit Number 9778 | 5985079.18018 | 2110144.91058 | 37.7731924364746 | -122.495067118327 | (37.7731924364746, -122.495067118327) | ||
| 46161 | 46161 | 219422 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5992066.9106 | 2106337.95166 | 37.7631461484089 | -122.470618527048 | (37.7631461484089, -122.470618527048) | |||
| 76812 | 76812 | 26075 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 279 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | 12 | 3X3 | 5994244.197480001 | 2088053.67853 | 37.7130677382333 | -122.46176225203001 | (37.7130677382333, -122.46176225203) | ||
| 79471 | 79471 | 26094 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 21 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5996391.73364 | 2088029.79177 | 37.71312554209 | -122.454337965939 | (37.71312554209, -122.454337965939) | ||
| 80755 | 80755 | 115918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3100X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989005.40184 | 2111951.8122900003 | 37.7783827554231 | -122.481618324321 | (37.7783827554231, -122.481618324321) | |||
| 106958 | 106958 | 111435 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3498x SANTIAGO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 12 | 3x3 | Permit Number 776176 | 5982094.0 | 2099503.0 | 37.7437975622932 | -122.50460445512199 | (37.7437975622932, -122.504604455122) | |
| 113119 | 113119 | 26066 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 252 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 12 | 3X3 | 5994485.32272 | 2088110.77616 | 37.7132383925183 | -122.46093298415701 | (37.7132383925183, -122.460932984157) | ||
| 113738 | 113738 | 26400 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 272 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994293.52025 | 2088114.03225 | 37.7132362944599 | -122.46159615030899 | (37.7132362944599, -122.461596150309) | ||
| 117433 | 117433 | 115917 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3100X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989023.45884 | 2111952.8782599997 | 37.7783867322409 | -122.481555937234 | (37.7783867322409, -122.481555937234) | |||
| 141503 | 141503 | 22770 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1720 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/1997 12:00:00 AM | 12 | 4X4 | 6001784.069495 | 2112233.869511 | 37.7798919802951 | -122.437432420828 | (37.7798919802951, -122.437432420828) | ||
| 163180 | 163180 | 101682 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2584 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1987 12:00:00 AM | 12 | Permit Number 24610 | 6000585.65494 | 2118590.7735099997 | 37.7972781827952 | -122.44203467567301 | (37.7972781827952, -122.442034675673) | ||
| 180988 | 180988 | 198416 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013254.09143 | 2089864.5252900003 | 37.7191159651107 | -122.396184055957 | (37.7191159651107, -122.396184055957) | |||
| 186062 | 186062 | 198417 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013234.80615 | 2089878.55725 | 37.719153420980604 | -122.39625170116301 | (37.7191534209806, -122.396251701163) | |||
| 29092 | 29092 | 242342 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004264.15883 | 2097942.68629 | 37.740792476382 | -122.427834099074 | (37.740792476382, -122.427834099074) | |||
| 29520 | 29520 | 32018 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 729 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 11 | Permit Number 35411 | 6009321.52864 | 2119764.77649 | 37.800995657295395 | -122.41188922351101 | (37.8009956572954, -122.411889223511) | ||
| 36902 | 36902 | 136926 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6000573.99959 | 2121502.15962 | 37.805271409309 | -122.442284116143 | (37.805271409309, -122.442284116143) | |||
| 37968 | 37968 | 136932 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6000587.38423 | 2121403.46977 | 37.8050011962985 | -122.442230708079 | (37.8050011962985, -122.442230708079) | |||
| 48324 | 48324 | 219420 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5992057.8729 | 2106495.38821 | 37.7635779048182 | -122.470661252913 | (37.7635779048182, -122.470661252913) | |||
| 53925 | 53925 | 68894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 47 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 11 | Permit Number 32866 | 6012572.9149400005 | 2090991.6774900001 | 37.722172972090505 | -122.39861769156799 | (37.7221729720905, -122.398617691568) | |
| 60774 | 60774 | 67952 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 564 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 11 | Permit Number 31667 | 5988466.35449 | 2112153.3787599998 | 37.778904841146 | -122.48349784875201 | (37.778904841146, -122.483497848752) | |
| 67427 | 67427 | 31660 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1120 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 11 | Permit Number 35168 | 6009328.60385 | 2117080.0959 | 37.7936245817471 | -122.411674942066 | (37.7936245817471, -122.411674942066) | ||
| 67644 | 67644 | 70573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 862 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 11 | 5982961.78283 | 2109923.12422 | 37.772459289826 | -122.502374937437 | (37.772459289826, -122.502374937437) | ||
| 153280 | 153280 | 180402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 675 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001637.22764 | 2093149.1062200002 | 37.727481455185 | -122.436573998515 | (37.727481455185, -122.436573998515) | |||
| 163334 | 163334 | 136930 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6000585.214790001 | 2121429.39855 | 37.8050722661295 | -122.442240078135 | (37.8050722661295, -122.442240078135) | |||
| 166295 | 166295 | 242330 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005175.96727 | 2099631.57497 | 37.745481319400795 | -122.424801526695 | (37.7454813194008, -122.424801526695) | |||
| 168128 | 168128 | 219421 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5992063.34343 | 2106423.60328 | 37.7633811187784 | -122.470637103423 | (37.7633811187784, -122.470637103423) | |||
| 172491 | 172491 | 63900 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2584 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1987 12:00:00 AM | 11 | Permit Number 24610 | 6000600.04945 | 2118593.6977 | 37.7972870321295 | -122.441985077154 | (37.7972870321295, -122.441985077154) | ||
| 185243 | 185243 | 72258 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 230 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 11 | 6002786.80425 | 2092214.2025900001 | 37.7249796797621 | -122.432533160192 | (37.7249796797621, -122.432533160192) | ||
| 13359 | 13359 | 99591 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1855X Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769738 | 6014314.47679 | 2099474.93569 | 37.745563139741996 | -122.39319079741301 | (37.745563139742, -122.393190797413) | |
| 15030 | 15030 | 101775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1700 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 3x3 | Permit Number 19103 | 6014052.75296 | 2093112.8912 | 37.728079734566606 | -122.393650601914 | (37.7280797345666, -122.393650601914) | |
| 15099 | 15099 | 99592 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1855X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014373.22453 | 2099430.50237 | 37.7454443986533 | -122.392984546922 | (37.7454443986533, -122.392984546922) | |||
| 23892 | 23892 | 180452 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008393.709980001 | 2091906.0725900002 | 37.724449984452704 | -122.413128866997 | (37.7244499844527, -122.413128866997) | |||
| 26966 | 26966 | 70402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006462.64225 | 2092921.27798 | 37.727128920939606 | -122.419876323835 | (37.7271289209396, -122.419876323835) | ||
| 27006 | 27006 | 35019 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 27 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38594 | 6001880.48988 | 2120550.7716599996 | 37.8027335251878 | -122.437694670695 | (37.8027335251878, -122.437694670695) | ||
| 37559 | 37559 | 35018 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 15 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | 10 | Permit Number 38593 | 6001898.27273 | 2120571.24867 | 37.8027907607435 | -122.437634600462 | (37.8027907607435, -122.437634600462) | ||
| 46135 | 46135 | 180483 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 321 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009804.862930001 | 2094010.61906 | 37.7303077455958 | -122.40839905808998 | (37.7303077455958, -122.40839905809) | |||
| 48947 | 48947 | 180450 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008413.5895 | 2091843.5213400002 | 37.7242793479848 | -122.413055725159 | (37.7242793479848, -122.413055725159) | |||
| 50620 | 50620 | 180458 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008265.9310099995 | 2092323.59976 | 37.725589251032 | -122.41360010007901 | (37.725589251032, -122.413600100079) | |||
| 52023 | 52023 | 68238 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 290 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32036 | 6000949.5088599995 | 2120925.17442 | 37.8037085566624 | -122.440943204485 | (37.8037085566624, -122.440943204485) | |
| 67824 | 67824 | 198414 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013355.178590001 | 2089895.60565 | 37.71920692974621 | -122.39583681063299 | (37.7192069297462, -122.395836810633) | |||
| 76747 | 76747 | 69489 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 675 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 10 | Permit Number 33611 | 6001629.6307 | 2093134.5419700001 | 37.7274410333571 | -122.436599219094 | (37.7274410333571, -122.436599219094) | |
| 83999 | 83999 | 26042 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | 10 | 3X3 | 5996190.731819999 | 2088089.91613 | 37.7132791004475 | -122.455037033861 | (37.7132791004475, -122.455037033861) | ||
| 92825 | 92825 | 25288 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1996 12:00:00 AM | 10 | 3x3 | 6000890.43944 | 2091777.01619 | 37.7236715433472 | -122.43905734896299 | (37.7236715433472, -122.439057348963) | ||
| 112572 | 112572 | 45297 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 608 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | 10 | 2x3 | Permit Number 44137 | 6008675.13295434 | 2095998.82519754 | 37.7357036012205 | -122.412445185237 | (37.7357036012205, -122.412445185237) |
| 123561 | 123561 | 95485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.777159118639496 | -122.49196396094601 | (37.7771591186395, -122.491963960946) | |||
| 142332 | 142332 | 95517 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.49203365493601 | (37.778128454962, -122.492033654936) | |||
| 144893 | 144893 | 117180 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | |||
| 147132 | 147132 | 68240 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3235 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32038 | 6000367.65651 | 2119408.48932 | 37.799510988101396 | -122.442847752719 | (37.7995109881014, -122.442847752719) | |
| 148867 | 148867 | 44382 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1257 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2001 12:00:00 AM | 10 | Permit Number 43744 | 6001457.21112 | 2087559.6242799999 | 37.71212376138379 | -122.43679636128901 | (37.7121237613838, -122.436796361289) | |
| 159162 | 159162 | 219449 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Detroit St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999411.789580001 | 2094299.60071 | 37.7305137290122 | -122.444349966799 | (37.7305137290122, -122.444349966799) | |||
| 162109 | 162109 | 70404 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 218 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006477.26442 | 2092881.04144 | 37.7270192639056 | -122.41982292118601 | (37.7270192639056, -122.419822921186) | ||
| 168983 | 168983 | 68254 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32056 | 6000569.04912 | 2121537.58273 | 37.8053683895105 | -122.44230379238199 | (37.8053683895105, -122.442303792382) | |
| 184089 | 184089 | 180430 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 122 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000838.328869999 | 2091757.95651 | 37.723616244584704 | -122.43923612035299 | (37.7236162445847, -122.439236120353) | |||
| 14258 | 14258 | 100759 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 362 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014440.04423 | 2112282.11717 | 37.780735840838396 | -122.39365282322201 | (37.7807358408384, -122.393652823222) | |||
| 28712 | 28712 | 82088 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50668 | 5996122.25454 | 2115757.75082 | 37.789244107281604 | -122.45727402588001 | (37.7892441072816, -122.45727402588) | |
| 31564 | 31564 | 242341 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1867 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004609.18081 | 2097837.81117 | 37.7405240251544 | -122.426633675907 | (37.7405240251544, -122.426633675907) | |||
| 33462 | 33462 | 68846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 731 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1993 12:00:00 AM | 9 | Permit Number 32807 | 5982263.55129 | 2110779.79011 | 37.774770393997706 | -122.50485363813101 | (37.7747703939977, -122.504853638131) | ||
| 36218 | 36218 | 31084 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1397 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34820 | 6006995.97256 | 2107440.57968 | 37.7670256771058 | -122.419062011995 | (37.7670256771058, -122.419062011995) | |
| 39438 | 39438 | 180429 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 220 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000152.41454 | 2091672.2540900002 | 37.723341869512204 | -122.441601052259 | (37.7233418695122, -122.441601052259) | |||
| 39912 | 39912 | 68348 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 518 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32167 | 5990339.7966 | 2111825.86021 | 37.7781144278241 | -122.476992997759 | (37.7781144278241, -122.476992997759) | |
| 54781 | 54781 | 6305 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1797X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | 9 | 3X3 | 6002532.11938 | 2112833.28187 | 37.781580315205396 | -122.434887466275 | (37.7815803152054, -122.434887466275) | ||
| 62144 | 62144 | 180456 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008358.46394 | 2092021.93043 | 37.7247661267393 | -122.41325889728998 | (37.7247661267393, -122.41325889729) | |||
| 64622 | 64622 | 198302 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011892.6623 | 2093405.69149 | 37.7287634360827 | -122.40113871700301 | (37.7287634360827, -122.401138717003) | |||
| 67459 | 67459 | 219423 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1301 Funston Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992070.57915 | 2106257.11168 | 37.7629243953779 | -122.470599950627 | (37.7629243953779, -122.470599950627) | |||
| 76791 | 76791 | 180463 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008211.686319999 | 2092495.1796099998 | 37.7260573265766 | -122.41379975137698 | (37.7260573265766, -122.413799751377) | |||
| 82751 | 82751 | 34551 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3662 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | 9 | 3x2 | Permit Number 778622 | 6008447.76168785 | 2097836.53869706 | 37.7407367985354 | -122.413361219105 | (37.7407367985354, -122.413361219105) |
| 113312 | 113312 | 26041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 9 | 3X3 | 5996239.04821 | 2088090.4012099998 | 37.7132832040965 | -122.454870071763 | (37.7132832040965, -122.454870071763) | ||
| 129794 | 129794 | 123883 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992072.431890001 | 2114857.09467 | 37.7865377268901 | -122.471220147048 | (37.7865377268901, -122.471220147048) | |||
| 130049 | 130049 | 218781 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1436 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5991498.75753 | 2105657.77331 | 37.7612456893572 | -122.472533966988 | (37.7612456893572, -122.472533966988) |
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");