Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 130307 | 130307 | 36947 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 121 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/1998 12:00:00 AM | 9 | 6x9 | Permit Number 39582 | 5994567.08556 | 2114703.52353 | 37.78626004419979 | -122.46257818064801 | (37.7862600441998, -122.462578180648) | |
| 133964 | 133964 | 114471 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2351 Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009306.05236 | 2121599.3882299997 | 37.806032175519 | -122.41207250624599 | (37.806032175519, -122.412072506246) | |||
| 148742 | 148742 | 242886 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 435 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007448.19697 | 2107143.49662 | 37.766235412247894 | -122.417476777052 | (37.7662354122479, -122.417476777052) | |||
| 149884 | 149884 | 68246 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3475 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32046 | 6001228.52061 | 2120448.06456 | 37.8024144268505 | -122.43994344164301 | (37.8024144268505, -122.439943441643) | |
| 150623 | 150623 | 180454 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008374.23169 | 2091967.3383 | 37.7246171135761 | -122.413200531303 | (37.7246171135761, -122.413200531303) | |||
| 151102 | 151102 | 68380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | 3x8 | Permit Number 32204 | 6002292.26866 | 2094136.6804799999 | 37.7302303121653 | -122.43438009877701 | (37.7302303121653, -122.434380098777) |
| 152635 | 152635 | 136916 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1921 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6000038.63255 | 2121244.89177 | 37.804534494021794 | -122.444118317601 | (37.8045344940218, -122.444118317601) | |||
| 153986 | 153986 | 68245 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3471 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32045 | 6001229.5729 | 2120436.05695 | 37.802381517044104 | -122.439938938746 | (37.8023815170441, -122.439938938746) | |
| 159051 | 159051 | 180448 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008430.60445 | 2091787.20061 | 37.7241256583517 | -122.4129929264 | (37.7241256583517, -122.4129929264) | |||
| 159394 | 159394 | 33106 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2953 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37345 | 5999975.52574 | 2118733.08238 | 37.7976341371664 | -122.444156101749 | (37.7976341371664, -122.444156101749) | |
| 159638 | 159638 | 219424 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1351 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992069.53986 | 2106182.25369 | 37.76271879506721 | -122.470598092623 | (37.7627187950672, -122.470598092623) | |||
| 168577 | 168577 | 180460 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008247.39503 | 2092379.68479 | 37.7257422077099 | -122.41366814277 | (37.7257422077099, -122.41366814277) | |||
| 168908 | 168908 | 242881 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1334 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007152.90115 | 2107695.77387 | 37.767735216134604 | -122.41853731696301 | (37.7677352161346, -122.418537316963) | |||
| 170868 | 170868 | 62135 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 9 | Permit Number 31835 | 6001148.79085 | 2092353.9589200001 | 37.7252703936925 | -122.43820558541901 | (37.7252703936925, -122.438205585419) | |
| 174546 | 174546 | 219447 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5999412.642419999 | 2094330.1651599999 | 37.730597700505 | -122.44434921406601 | (37.730597700505, -122.444349214066) | |||
| 177030 | 177030 | 124216 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.45575789701401 | (37.7796587851836, -122.455757897014) | |||
| 177790 | 177790 | 36989 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 711 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 9 | Permit Number 39610 | 5993273.5401 | 2114815.16246 | 37.7864919948194 | -122.46706159406999 | (37.7864919948194, -122.46706159407) | |
| 182275 | 182275 | 136954 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011359.28517 | 2121128.07702 | 37.8048530581732 | -122.404933719313 | (37.8048530581732, -122.404933719313) | |||
| 187335 | 187335 | 33110 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2626 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37348 | 6000381.41365 | 2118563.70291 | 37.7971922129921 | -122.442739455458 | (37.7971922129921, -122.442739455458) | |
| 187872 | 187872 | 136933 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999921.83043 | 2119840.52401 | 37.8006718131986 | -122.44442153123998 | (37.8006718131986, -122.44442153124) | |||
| 12240 | 12240 | 44475 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 275 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | 3x3 | Permit Number 43789 | 6006290.74635 | 2092615.37122 | 37.726279281939895 | -122.42044886282301 | (37.7262792819399, -122.420448862823) |
| 20785 | 20785 | 856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2001 12:00:00 AM | 8 | 3x3 | 6008178.91279 | 2095102.6011299998 | 37.7332149048351 | -122.414097431452 | (37.7332149048351, -122.414097431452) | ||
| 23782 | 23782 | 219426 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991173.89859 | 2105672.02771 | 37.7612660194265 | -122.473658544928 | (37.7612660194265, -122.473658544928) | |||
| 27967 | 27967 | 44472 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 236 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43786 | 6006212.75467 | 2092719.23658 | 37.726560078178395 | -122.420725846847 | (37.7265600781784, -122.420725846847) | |
| 31207 | 31207 | 198409 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Washburn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008437.7646 | 2110373.29523 | 37.7751593120891 | -122.41428258206801 | (37.7751593120891, -122.414282582068) | |||
| 33652 | 33652 | 180465 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008194.47669 | 2092552.7848 | 37.7262145316512 | -122.413863317257 | (37.7262145316512, -122.413863317257) | |||
| 38435 | 38435 | 136931 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000586.31642 | 2121417.2428200003 | 37.805038952541295 | -122.442235392672 | (37.8050389525413, -122.442235392672) | |||
| 38608 | 38608 | 180407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6002242.22225 | 2094108.3589599999 | 37.7301497068323 | -122.434551091376 | (37.7301497068323, -122.434551091376) | |||
| 38853 | 38853 | 70336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 324 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009735.9866 | 2094035.87413 | 37.7303732333298 | -122.408638954927 | (37.7303732333298, -122.408638954927) | ||
| 44658 | 44658 | 180462 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008228.9593 | 2092440.66794 | 37.725908619167704 | -122.413736185485 | (37.7259086191677, -122.413736185485) | |||
| 45366 | 45366 | 70407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 231 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006535.83698 | 2092862.23217 | 37.7269709172726 | -122.419619102459 | (37.7269709172726, -122.419619102459) | ||
| 56808 | 56808 | 47721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001839.98608 | 2118371.66878 | 37.7967479784971 | -122.437678679828 | (37.7967479784971, -122.437678679828) | |
| 57296 | 57296 | 47722 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001852.4852599995 | 2118373.09609 | 37.796752608195796 | -122.437635532153 | (37.7967526081958, -122.437635532153) | |
| 58632 | 58632 | 180467 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008177.51533 | 2092609.86875 | 37.72637031941721 | -122.413925988288 | (37.7263703194172, -122.413925988288) | |||
| 58932 | 58932 | 40193 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3430 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41376 | 6000802.81629 | 2120169.1836 | 37.801624451566894 | -122.441396561715 | (37.8016244515669, -122.441396561715) | ||
| 59288 | 59288 | 219438 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2551 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991712.62848 | 2098073.6420400003 | 37.74043401203279 | -122.471241703239 | (37.7404340120328, -122.471241703239) | |||
| 60291 | 60291 | 180468 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008161.02959 | 2092664.87988 | 37.7265204423377 | -122.413986868806 | (37.7265204423377, -122.413986868806) | |||
| 65259 | 65259 | 136914 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001866.38234 | 2118375.10794 | 37.7967589223518 | -122.437587589309 | (37.7967589223518, -122.437587589309) | |||
| 65789 | 65789 | 219445 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 332 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000112.34279 | 2094905.0087400002 | 37.73221598377361 | -122.441971496493 | (37.7322159837736, -122.441971496493) | |||
| 71395 | 71395 | 136927 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000575.8794 | 2121488.3697200003 | 37.8052336530829 | -122.44227662028 | (37.8052336530829, -122.44227662028) | |||
| 97843 | 97843 | 29758 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
| 116305 | 116305 | 26040 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 12:00:00 AM | 8 | 3x3 | 5996258.07972 | 2088089.3008299998 | 37.7132812744111 | -122.45480421322901 | (37.7132812744111, -122.454804213229) | ||
| 118573 | 118573 | 120668 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998951.0 | 2105925.0 | 37.76240795737721 | -122.44677915122601 | (37.7624079573772, -122.446779151226) | |||
| 130711 | 130711 | 75004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997965.54363 | 2116098.57851 | 37.7902856238171 | -122.450921084564 | (37.7902856238171, -122.450921084564) | ||
| 132171 | 132171 | 242912 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004415.185819999 | 2102148.8561 | 37.7523501901347 | -122.427611502469 | (37.7523501901347, -122.427611502469) | |||
| 134180 | 134180 | 219427 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5991170.38541 | 2105691.7804 | 37.7613200515933 | -122.47367213637101 | (37.7613200515933, -122.473672136371) | |||
| 134417 | 134417 | 198415 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013330.68803 | 2089861.99882 | 37.7191132896144 | -122.39591911208299 | (37.7191132896144, -122.395919112083) | |||
| 136729 | 136729 | 136918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001921.35919 | 2120601.2758299997 | 37.8028745199931 | -122.437556861278 | (37.8028745199931, -122.437556861278) | |||
| 154342 | 154342 | 136919 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5997971.7056 | 2116051.1115099997 | 37.790155644821 | -122.450896340588 | (37.790155644821, -122.450896340588) | |||
| 156961 | 156961 | 32340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36902 | 6010864.0771699995 | 2093419.2397900003 | 37.7287432013131 | -122.40469557435 | (37.7287432013131, -122.40469557435) | ||
| 159217 | 159217 | 47193 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987133.5813 | 2113398.4948 | 37.7822459140534 | -122.488199902231 | (37.7822459140534, -122.488199902231) | |
| 159263 | 159263 | 120760 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989219.70066 | 2114726.96958 | 37.7860150171 | -122.481080247842 | (37.7860150171, -122.481080247842) | |||
| 161848 | 161848 | 70149 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 754 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 8 | 5989468.1167 | 2110177.57013 | 37.773538072981204 | -122.479887770247 | (37.7735380729812, -122.479887770247) | ||
| 163030 | 163030 | 136929 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000583.85394 | 2121442.09911 | 37.8051070609006 | -122.442245699797 | (37.8051070609006, -122.442245699797) | |||
| 163047 | 163047 | 44470 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 128 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43784 | 6005782.65957 | 2093100.8203 | 37.727583573204896 | -122.422239770059 | (37.7275835732049, -122.422239770059) | |
| 167045 | 167045 | 219446 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 762 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5997041.47466 | 2095025.35 | 37.7323709396524 | -122.45259680479201 | (37.7323709396524, -122.452596804792) | ||||
| 167505 | 167505 | 62133 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 221 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | Permit Number 31836 | 6001106.23705 | 2092334.34097 | 37.7252141069394 | -122.43835128458599 | (37.7252141069394, -122.438351284586) | |
| 169678 | 169678 | 198407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 42 Washburn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008385.72143 | 2110427.77402 | 37.7753059744256 | -122.414466467358 | (37.7753059744256, -122.414466467358) | |||
| 171114 | 171114 | 136915 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2301 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001927.36855 | 2118383.65644 | 37.796785861541096 | -122.43737717584101 | (37.7967858615411, -122.437377175841) | |||
| 172853 | 172853 | 123882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992074.12323 | 2114872.38939 | 37.7865798197895 | -122.47121541022601 | (37.7865798197895, -122.471215410226) | |||
| 173810 | 173810 | 75766 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009894.26848 | 2094011.0737400001 | 37.730314000377 | -122.408090001562 | (37.730314000377, -122.408090001562) | ||
| 176376 | 176376 | 70562 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 8 | 6014127.69322 | 2112419.53716 | 37.7810958034577 | -122.39474303089199 | (37.7810958034577, -122.394743030892) | ||
| 180856 | 180856 | 72281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.242880001 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | ||
| 181702 | 181702 | 70405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006525.54367 | 2092869.6574799998 | 37.726990725739 | -122.41965521291999 | (37.726990725739, -122.41965521292) | ||
| 182709 | 182709 | 180445 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008486.19305 | 2091610.48343 | 37.723643550705 | -122.412788276664 | (37.723643550705, -122.412788276664) | |||
| 183248 | 183248 | 136920 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 207 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996591.90102 | 2115549.28793 | 37.788698686447894 | -122.45563404108499 | (37.7886986864479, -122.455634041085) | |||
| 185844 | 185844 | 68890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 35 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32862 | 6012596.9510699995 | 2091063.5496200002 | 37.7223716575091 | -122.398539644797 | (37.7223716575091, -122.398539644797) | |
| 187668 | 187668 | 180443 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008502.54989 | 2091553.3243 | 37.7234875219066 | -122.412727694727 | (37.7234875219066, -122.412727694727) | |||
| 188081 | 188081 | 47192 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987134.96931 | 2113380.92602 | 37.782197756171705 | -122.488193808962 | (37.7821977561717, -122.488193808962) | |
| 2511 | 2511 | 246852 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Broderick St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001238.428669999 | 2109976.67902 | 37.7736632691848 | -122.43915820668998 | (37.7736632691848, -122.43915820669) | |||
| 23639 | 23639 | 51486 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2576 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 7 | Permit Number 47799 | 5999551.99541 | 2119490.69699 | 37.799690173532 | -122.445676136766 | (37.799690173532, -122.445676136766) | ||
| 24845 | 24845 | 31207 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 141 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34899 | 6004741.8201 | 2109004.9334 | 37.7711938198687 | -122.42697020763 | (37.7711938198687, -122.42697020763) | ||
| 27116 | 27116 | 136928 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6000577.85991 | 2121479.43113 | 37.8052092229902 | -122.442269124421 | (37.8052092229902, -122.442269124421) | |||
| 29284 | 29284 | 198256 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 718 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6015417.87325 | 2105664.96075 | 37.762620874174104 | -122.38980767650499 | (37.7626208741741, -122.389807676505) | |||
| 31927 | 31927 | 117672 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7751 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5982922.15587 | 2112497.69809 | 37.77952599164671 | -122.502702614984 | (37.7795259916467, -122.502702614984) | |||
| 32179 | 32179 | 180406 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 23 Gorham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002284.81507 | 2094188.8168099998 | 37.7303730435723 | -122.43440959293999 | (37.7303730435723, -122.43440959294) | |||
| 32498 | 32498 | 136953 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 685 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007628.69919 | 2121609.81563 | 37.8059665519739 | -122.41787801227 | (37.8059665519739, -122.41787801227) | |||
| 34216 | 34216 | 32016 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2920 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2002 12:00:00 AM | 7 | Permit Number 46155 | 5989557.12792 | 2111970.2291 | 37.7784653891782 | -122.479711067145 | (37.7784653891782, -122.479711067145) | |
| 36732 | 36732 | 54017 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 848 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49959 | 5985128.25093 | 2110100.49047 | 37.7730733441171 | -122.494894102815 | (37.7730733441171, -122.494894102815) | |
| 40418 | 40418 | 42151 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 554 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 7 | Permit Number 42446 | 5989728.75072 | 2111581.12126 | 37.7774069754215 | -122.47908889577499 | (37.7774069754215, -122.479088895775) | |
| 40561 | 40561 | 180403 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 428 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002092.324580001 | 2093893.81656 | 37.7295521118195 | -122.435053967971 | (37.7295521118195, -122.435053967971) | |||
| 44344 | 44344 | 67959 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 7 | Permit Number 31679 | 5987285.58651 | 2110436.7954700002 | 37.774122792273204 | -122.48745641247 | (37.7741227922732, -122.48745641247) | |
| 45388 | 45388 | 118167 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3238 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985487.69599 | 2111143.2321 | 37.775957450089 | -122.493727608092 | (37.775957450089, -122.493727608092) | |||
| 45764 | 45764 | 117863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 798 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983563.66024 | 2110432.70706 | 37.7738938035198 | -122.50033069971902 | (37.7738938035198, -122.500330699719) | |||
| 45828 | 45828 | 242335 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 240 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004310.20228 | 2099583.9062799998 | 37.7453014945788 | -122.427791810249 | (37.7453014945788, -122.427791810249) | |||
| 46824 | 46824 | 180405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 23 Gorham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002276.91097 | 2094198.0072599999 | 37.73039782978879 | -122.434437575327 | (37.7303978297888, -122.434437575327) | |||
| 47843 | 47843 | 49309 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | 7 | Permit Number 46312 | 6000570.14327 | 2093666.4250900003 | 37.7288411968484 | -122.440299988657 | (37.7288411968484, -122.440299988657) | ||
| 47862 | 47862 | 68175 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 58 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | 7 | Permit Number 31946 | 5996349.990780001 | 2111854.0137 | 37.778538561885796 | -122.45620372641399 | (37.7785385618858, -122.456203726414) | |
| 50074 | 50074 | 198300 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011874.28273 | 2093380.6999 | 37.7286937889864 | -122.40120050131 | (37.7286937889864, -122.40120050131) | |||
| 55075 | 55075 | 74119 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014130.8006 | 2112451.57445 | 37.7811839433263 | -122.39473452509199 | (37.7811839433263, -122.394734525092) | ||
| 56868 | 56868 | 180428 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 223 San Juan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001082.08541 | 2092350.7648 | 37.7252578292825 | -122.438435950363 | (37.7252578292825, -122.438435950363) | |||
| 58219 | 58219 | 118168 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3238 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985471.03875 | 2111143.13059 | 37.775956196854 | -122.493785221511 | (37.775956196854, -122.493785221511) | |||
| 58664 | 58664 | 242887 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005696.3409 | 2102856.44643 | 37.754365453022 | -122.423231349069 | (37.754365453022, -122.423231349069) | |||
| 61605 | 61605 | 219448 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Detroit St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999411.63335 | 2094313.0513799998 | 37.7305506524938 | -122.44435147316003 | (37.7305506524938, -122.44435147316) | |||
| 61797 | 61797 | 180472 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008124.54519 | 2092780.38973 | 37.726835558508704 | -122.414121162755 | (37.7268355585087, -122.414121162755) | |||
| 62996 | 62996 | 242904 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3699 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005195.07588 | 2101930.11385 | 37.7517936572624 | -122.424898952928 | (37.7517936572624, -122.424898952928) | |||
| 64340 | 64340 | 242880 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1321 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007174.89238 | 2107740.52123 | 37.7678593198724 | -122.41846442511101 | (37.7678593198724, -122.418464425111) | |||
| 66456 | 66456 | 51487 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2576 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 7 | Permit Number 47799 | 5999531.677519999 | 2119487.78648 | 37.7996810220155 | -122.44574623442101 | (37.7996810220155, -122.445746234421) | ||
| 67087 | 67087 | 136917 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1921 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000998.90013 | 2120967.06154 | 37.803826380442096 | -122.44077529025499 | (37.8038263804421, -122.440775290255) | |||
| 68356 | 68356 | 47196 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 430 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 7 | Permit Number 45156 | 5986884.14198 | 2113014.7647599997 | 37.781177745194995 | -122.48903462038 | (37.781177745195, -122.48903462038) |
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");