Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33703 | 33703 | 117914 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 839 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983220.24264 | 2110063.17362 | 37.7728590079713 | -122.501491276363 | (37.7728590079713, -122.501491276363) | |||
| 149632 | 149632 | 118249 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 735 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985364.18401 | 2110859.1562900003 | 37.7751702324246 | -122.49413391969101 | (37.7751702324246, -122.494133919691) | |||
| 71898 | 71898 | 119960 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 426 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5987190.151740001 | 2113069.49972 | 37.7813458874945 | -122.487980015327 | (37.7813458874945, -122.487980015327) | |||
| 46044 | 46044 | 120186 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 172 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987746.67951 | 2114854.71533 | 37.7862800304413 | -122.48618581827 | (37.7862800304413, -122.48618581827) | |||
| 30123 | 30123 | 120689 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 598 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989116.38632 | 2111294.87868 | 37.7765854515948 | -122.48118627511299 | (37.7765854515948, -122.481186275113) | |||
| 72944 | 72944 | 218771 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1418 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990557.09281 | 2105700.43464 | 37.7613082758806 | -122.47579386731701 | (37.7613082758806, -122.475793867317) | |||
| 154104 | 154104 | 218770 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1677 18th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990554.36808 | 2103987.92429 | 37.7566060203584 | -122.47567823607001 | (37.7566060203584, -122.47567823607) | |||
| 75932 | 75932 | 52909 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 618 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 1 | Permit Number 48899 | 5990985.73 | 2111152.4596 | 37.7763029054126 | -122.474709341958 | (37.7763029054126, -122.474709341958) | ||
| 182316 | 182316 | 219430 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2282 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990750.15323 | 2099879.22628 | 37.745335960182295 | -122.47470128006 | (37.7453359601823, -122.47470128006) | |||
| 57802 | 57802 | 218772 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1474 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990872.72127 | 2105363.26088 | 37.760400780802 | -122.474677643153 | (37.760400780802, -122.474677643153) | |||
| 151781 | 151781 | 218776 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1627 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991135.052630001 | 2104301.48993 | 37.7575006362752 | -122.473692913398 | (37.7575006362752, -122.473692913398) | |||
| 45312 | 45312 | 218780 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991161.31553 | 2104352.12104 | 37.7576411769241 | -122.47360577988199 | (37.7576411769241, -122.473605779882) | |||
| 109906 | 109906 | 218779 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991163.97274 | 2104338.9092599996 | 37.75760505475421 | -122.47359562653999 | (37.7576050547542, -122.47359562654) | |||
| 59386 | 59386 | 218777 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2097 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991278.3024699995 | 2101198.1006 | 37.74898783722271 | -122.472971202076 | (37.7489878372227, -122.472971202076) | |||
| 171649 | 171649 | 218778 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2097 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991279.88316 | 2101182.92802 | 37.748946268773 | -122.47296462983299 | (37.748946268773, -122.472964629833) | |||
| 186093 | 186093 | 219431 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2606 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991446.11027 | 2097653.6423299997 | 37.7392653798979 | -122.47213260314301 | (37.7392653798979, -122.472132603143) | |||
| 129527 | 129527 | 123027 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 744 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991973.40436 | 2110362.91938 | 37.774192223739796 | -122.471235197447 | (37.7741922237398, -122.471235197447) | |||
| 50177 | 50177 | 64157 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 744 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 1 | Permit Number 24936 | 5991974.2297 | 2110344.19587 | 37.7741408617904 | -122.471230978045 | (37.7741408617904, -122.471230978045) | |
| 69210 | 69210 | 219428 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 48 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991922.58848 | 2104984.44773 | 37.7594214379556 | -122.471019076096 | (37.7594214379556, -122.471019076096) | |||
| 50945 | 50945 | 123066 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 470 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992217.29456 | 2112247.9898099997 | 37.7793822197335 | -122.470528866493 | (37.7793822197335, -122.470528866493) | |||
| 29751 | 29751 | 219429 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5992085.46562 | 2105232.9931400004 | 37.7601132972171 | -122.47047387378099 | (37.7601132972171, -122.470473873781) | |||
| 136348 | 136348 | 37603 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 564 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2015 12:00:00 AM | 1 | Permit Number 774301 | 5992239.14476 | 2111629.05445 | 37.7776840552126 | -122.47040819043 | (37.7776840552126, -122.47040819043) | |
| 168734 | 168734 | 123204 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 471 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993099.47756 | 2112286.2327799997 | 37.7795381952063 | -122.467479832619 | (37.7795381952063, -122.467479832619) | |||
| 130241 | 130241 | 123203 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 471 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993099.80494 | 2112301.80229 | 37.7795809637616 | -122.467479832594 | (37.7795809637616, -122.467479832594) | |||
| 61139 | 61139 | 123206 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 471 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993100.221580001 | 2112267.5253 | 37.7794868724906 | -122.467475897994 | (37.7794868724906, -122.467475897994) | |||
| 168143 | 168143 | 123207 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 471 09th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993100.48671 | 2112253.0761700002 | 37.7794472144018 | -122.467473929791 | (37.7794472144018, -122.467473929791) | |||
| 131999 | 131999 | 123205 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 471 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993101.276869999 | 2112277.13231 | 37.7795133116616 | -122.467472946131 | (37.7795133116616, -122.467472946131) | |||
| 179834 | 179834 | 67320 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 641 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 1 | Permit Number 30802 | 5993536.200019999 | 2111377.87802 | 37.777069301498706 | -122.465903015306 | (37.7770693014987, -122.465903015306) | |
| 182428 | 182428 | 111054 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 5993558.15565 | 2111433.38928 | 37.777222987024004 | -122.465831098866 | (37.777222987024, -122.465831098866) | |||
| 167210 | 167210 | 100856 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 769158 | 5993666.6182699995 | 2115051.6302900002 | 37.7871639517517 | -122.46571883909701 | (37.7871639517517, -122.465718839097) | ||
| 136722 | 136722 | 124101 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4041 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994446.0022 | 2112769.4235900003 | 37.780942554537894 | -122.462856727556 | (37.7809425545379, -122.462856727556) | |||
| 151384 | 151384 | 123603 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 316 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5994658.00106 | 2113296.21915 | 37.782401201877796 | -122.46216154021799 | (37.7824012018778, -122.462161540218) | |||
| 188649 | 188649 | 123336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 723 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994711.02171 | 2110605.04952 | 37.7750150216931 | -122.461782919201 | (37.7750150216931, -122.461782919201) | |||
| 172118 | 172118 | 123717 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 211 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994941.53655 | 2111428.1304200003 | 37.7772882505489 | -122.46104519484301 | (37.7772882505489, -122.461045194843) | |||
| 78479 | 78479 | 122863 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2900X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 5996824.0 | 2087575.0 | 37.7119015691826 | -122.45281111027501 | (37.7119015691826, -122.452811110275) | |||
| 52564 | 52564 | 94720 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 24 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 53854 | 5997798.497 | 2113560.5927 | 37.7833074222878 | -122.451315930077 | (37.7833074222878, -122.451315930077) |
| 108044 | 108044 | 122872 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | |||
| 174103 | 174103 | 219442 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 534 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5997871.79595 | 2095275.0602799999 | 37.7331041245588 | -122.44974419306699 | (37.7331041245588, -122.449744193067) | |||
| 168165 | 168165 | 219450 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 275 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998266.83144 | 2093785.5483799998 | 37.729036870441796 | -122.44827123483999 | (37.7290368704418, -122.44827123484) | |||
| 170877 | 170877 | 242338 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1407 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5999569.11021 | 2107684.75025 | 37.7672750825135 | -122.44476784037701 | (37.7672750825135, -122.444767840377) | |||
| 179692 | 179692 | 246859 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001348.19607 | 2109746.2469900004 | 37.7730368059387 | -122.43876198966998 | (37.7730368059387, -122.43876198967) | |||
| 39512 | 39512 | 106411 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2159 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 1 | Permit Number 772621 | 6001561.17582 | 2119720.78456 | 37.8004364390406 | -122.438740147849 | (37.8004364390406, -122.438740147849) | ||
| 176191 | 176191 | 242339 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1035 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001342.6727 | 2100671.2124799998 | 37.748118662255294 | -122.438130887736 | (37.7481186622553, -122.438130887736) | |||
| 69123 | 69123 | 180485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1222 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001620.509380001 | 2087598.74128 | 37.712240447503 | -122.436234753557 | (37.712240447503, -122.436234753557) | |||
| 106701 | 106701 | 113812 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 1 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
| 153134 | 153134 | 242913 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 510 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003222.68782 | 2098941.90353 | 37.74347712448029 | -122.431506428479 | (37.7434771244803, -122.431506428479) | |||
| 36031 | 36031 | 103531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003099.91342 | 2086880.6888299999 | 37.7103527759382 | -122.43107027978901 | (37.7103527759382, -122.431070279789) | ||
| 26854 | 26854 | 103532 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2014 12:00:00 AM | 1 | Permit Number 770957 | 6003118.601980001 | 2086861.7562 | 37.7103018500205 | -122.431004337903 | (37.7103018500205, -122.431004337903) | ||
| 135967 | 135967 | 180423 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003317.211680001 | 2094273.79477 | 37.7306649221452 | -122.430846517675 | (37.7306649221452, -122.430846517675) | |||
| 38671 | 38671 | 180422 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003342.53075 | 2094283.93013 | 37.7306941860739 | -122.43075970881901 | (37.7306941860739, -122.430759708819) | |||
| 163126 | 163126 | 180411 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2 Still St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003370.62574 | 2094727.02091 | 37.731912405013 | -122.430694186892 | (37.731912405013, -122.430694186892) | |||
| 51014 | 51014 | 180421 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003365.77706 | 2094291.48085 | 37.7307162356701 | -122.430679881378 | (37.7307162356701, -122.430679881378) | |||
| 188836 | 188836 | 180410 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2 Still St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003389.548769999 | 2094727.9749900002 | 37.7319160967549 | -122.43062883406601 | (37.7319160967549, -122.430628834066) | |||
| 151084 | 151084 | 180420 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003421.2672 | 2094309.3598599997 | 37.7307684709799 | -122.430489318632 | (37.7307684709799, -122.430489318632) | |||
| 116442 | 116442 | 180419 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003443.67237 | 2094317.91582 | 37.7307932329079 | -122.43041247068001 | (37.7307932329079, -122.43041247068) | |||
| 66122 | 66122 | 180418 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003475.18041 | 2094328.74311 | 37.73082474696329 | -122.430304314596 | (37.7308247469633, -122.430304314596) | |||
| 57854 | 57854 | 180417 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003506.26836 | 2094339.1696799998 | 37.730855136838606 | -122.430197582161 | (37.7308551368386, -122.430197582161) | |||
| 166485 | 166485 | 180416 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003534.67772 | 2094349.44618 | 37.730884962851896 | -122.430100099258 | (37.7308849628519, -122.430100099258) | |||
| 64285 | 64285 | 180415 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003554.97456 | 2094355.58631 | 37.7309029717957 | -122.43003036762899 | (37.7309029717957, -122.430030367629) | |||
| 38497 | 38497 | 180409 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 141 Rousseau St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6003595.96524 | 2094719.6833400002 | 37.7319050215902 | -122.429914617678 | (37.7319050215902, -122.429914617678) | ||||
| 185852 | 185852 | 180408 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 141 Rousseau St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 7ft | 6003605.879 | 2094702.80598 | 37.731859241593106 | -122.429879140314 | (37.7318592415931, -122.429879140314) | |||
| 76907 | 76907 | 180414 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003758.53299 | 2094425.58203 | 37.73110669070989 | -122.42933162228 | (37.7311066907099, -122.42933162228) | |||
| 42765 | 42765 | 242336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1404 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003892.07763 | 2100038.4689599997 | 37.7465259566162 | -122.429270023211 | (37.7465259566162, -122.429270023211) | |||
| 180303 | 180303 | 180413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003786.93346 | 2094435.4492400002 | 37.731135391684 | -122.42923414026001 | (37.731135391684, -122.42923414026) | |||
| 183887 | 183887 | 180412 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003814.30975 | 2094445.54262 | 37.7311646556118 | -122.42914021505501 | (37.7311646556118, -122.429140215055) | |||
| 176200 | 176200 | 242869 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 348 Church St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004153.4659400005 | 2106885.51591 | 37.7653411264215 | -122.428854226135 | (37.7653411264215, -122.428854226135) | |||
| 38922 | 38922 | 180401 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 450 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003847.76406 | 2089839.62189 | 37.7185197127976 | -122.428696343867 | (37.7185197127976, -122.428696343867) | |||
| 136768 | 136768 | 109664 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 230X Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6004031.22514 | 2093803.38272 | 37.729413705278894 | -122.428344548862 | (37.7294137052789, -122.428344548862) | ||
| 152310 | 152310 | 242870 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 498 Oak St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004648.6662099995 | 2110205.3941200003 | 37.7744847252106 | -122.42737796202 | (37.7744847252106, -122.42737796202) | |||
| 181292 | 181292 | 242874 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 62 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005180.17722 | 2105756.65507 | 37.7622996012591 | -122.425222734963 | (37.7622996012591, -122.425222734963) | |||
| 156033 | 156033 | 180482 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 239 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004961.97444 | 2093812.29183 | 37.7294907906444 | -122.425127491367 | (37.7294907906444, -122.425127491367) | |||
| 74657 | 74657 | 86896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1515 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49845 | 6005504.575019999 | 2119576.847 | 37.8002647728594 | -122.42508414582 | (37.8002647728594, -122.42508414582) | |
| 126039 | 126039 | 108924 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 335-341 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6005380.1 | 2110235.1 | 37.7746076306443 | -122.42484990347602 | (37.7746076306443, -122.424849903476) | |||
| 165104 | 165104 | 242868 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 388 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005479.97294 | 2106783.54072 | 37.7651361178728 | -122.42425889015301 | (37.7651361178728, -122.424258890153) | |||
| 35758 | 35758 | 242888 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005717.8738400005 | 2102519.39452 | 37.753441201753205 | -122.423132926343 | (37.7534412017532, -122.423132926343) | |||
| 169009 | 169009 | 242902 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3666 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005844.93191 | 2104346.37616 | 37.7584648381049 | -122.42282336352801 | (37.7584648381049, -122.422823363528) | |||
| 35907 | 35907 | 242901 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3666 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005862.21716 | 2104347.95143 | 37.758470138701895 | -122.422763695285 | (37.7584701387019, -122.422763695285) | |||
| 38673 | 38673 | 242350 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006095.21609 | 2109159.69147 | 37.771695182903706 | -122.42229974855302 | (37.7716951829037, -122.422299748553) | |||
| 31159 | 31159 | 242866 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006095.439119999 | 2109158.70233 | 37.7716924795429 | -122.422298906788 | (37.7716924795429, -122.422298906788) | |||
| 63163 | 63163 | 242865 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006113.4001 | 2109160.84618 | 37.7716993791617 | -122.422236930889 | (37.7716993791617, -122.422236930889) | |||
| 184495 | 184495 | 242349 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006130.70544 | 2109162.10737 | 37.7717038181943 | -122.422177160163 | (37.7717038181943, -122.422177160163) | |||
| 176503 | 176503 | 242348 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 70 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006148.63629 | 2109163.83557 | 37.7717095747744 | -122.422115258931 | (37.7717095747744, -122.422115258931) | |||
| 61287 | 61287 | 242864 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006148.77092 | 2109162.88394 | 37.771706969419796 | -122.422114725619 | (37.7717069694198, -122.422114725619) | |||
| 36650 | 36650 | 242863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006168.47171 | 2109163.73568 | 37.7717104192431 | -122.422046639762 | (37.7717104192431, -122.422046639762) | |||
| 150139 | 150139 | 30670 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 33 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2004 12:00:00 AM | 1 | Permit Number 47746 | 6006381.58873 | 2109111.27047 | 37.7715783798663 | -122.421305726983 | (37.7715783798663, -122.421305726983) | |
| 147539 | 147539 | 43157 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 237 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 1 | Permit Number 42967 | 6006253.76789 | 2092738.7506400002 | 37.7266159710398 | -122.42058545006701 | (37.7266159710398, -122.420585450067) | |
| 160152 | 160152 | 242883 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 235 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007114.04394 | 2107899.15094 | 37.7682914540022 | -122.418686143969 | (37.7682914540022, -122.418686143969) | |||
| 158673 | 158673 | 242884 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 798 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007497.35986 | 2105057.20463 | 37.7605097057872 | -122.41715888377199 | (37.7605097057872, -122.417158883772) | |||
| 25281 | 25281 | 115053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1280 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 1 | Permit Number 773966 | 6007807.56108 | 2115848.6869799998 | 37.790157994733704 | -122.41685060786699 | (37.7901579947337, -122.416850607867) | ||
| 60515 | 60515 | 109905 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 224 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6007804.4869 | 2109016.66543 | 37.771398734904 | -122.416377125602 | (37.771398734904, -122.416377125602) | ||||
| 24076 | 24076 | 198405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 155 Grace St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008338.60303 | 2110264.2023400003 | 37.7748541981831 | -122.414617883501 | (37.7748541981831, -122.414617883501) | |||
| 45185 | 45185 | 198406 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 155 Grace St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008349.03666 | 2110252.77617 | 37.7748234108023 | -122.41458098254 | (37.7748234108023, -122.41458098254) | |||
| 74151 | 74151 | 180438 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008554.24555 | 2091384.77255 | 37.7230276158181 | -122.412537082542 | (37.7230276158181, -122.412537082542) | |||
| 29811 | 29811 | 180436 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008572.212 | 2091322.68535 | 37.722858145766004 | -122.412470589353 | (37.722858145766, -122.412470589353) | |||
| 170628 | 170628 | 242871 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1700 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009441.4286 | 2106739.88678 | 37.765239142394 | -122.410554039658 | (37.765239142394, -122.410554039658) | |||
| 9563 | 9563 | 108596 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 36 Bronte St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 770949 | 6009339.44395 | 2097251.26276 | 37.7391797819084 | -122.410236794344 | (37.7391797819084, -122.410236794344) | ||
| 13779 | 13779 | 101367 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 551 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 1 | 3x5 | Permit Number 769423 | 6009889.66847 | 2111940.62383 | 37.779544278688604 | -122.409370733267 | (37.7795442786886, -122.409370733267) | |
| 183492 | 183492 | 198353 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 529 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010041.14992 | 2112083.59388 | 37.7799453268562 | -122.408856781511 | (37.7799453268562, -122.408856781511) | |||
| 40310 | 40310 | 242898 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.25969 | 2103043.9270599997 | 37.755120337650105 | -122.408474577742 | (37.7551203376501, -122.408474577742) | |||
| 56748 | 56748 | 242899 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.68817 | 2103026.2265 | 37.7550717598627 | -122.408471847423 | (37.7550717598627, -122.408471847423) |
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");