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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28847 | 28847 | 198338 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 474 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010471.529619999 | 2112264.21742 | 37.7804653742171 | -122.40738063611299 | (37.7804653742171, -122.407380636113) | |||
| 28936 | 28936 | 49804 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1112SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46599 | 6014208.95643 | 2105755.12489 | 37.7628013312333 | -122.39399522840799 | (37.7628013312333, -122.393995228408) | |
| 29033 | 29033 | 123711 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 437 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994213.82065 | 2111401.8338099997 | 37.777174144242295 | -122.46356067075199 | (37.7771741442423, -122.463560670752) | |||
| 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) | |||
| 29107 | 29107 | 86900 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1515 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49845 | 6005565.12531 | 2119584.9629 | 37.8002904772924 | -122.424875195545 | (37.8002904772924, -122.424875195545) | |
| 29241 | 29241 | 180442 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008511.7814 | 2091523.97842 | 37.723407462461296 | -122.412693709355 | (37.7234074624613, -122.412693709355) | |||
| 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) | |||
| 29317 | 29317 | 217810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 198 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996576.41484 | 2091837.9853700001 | 37.7235925393546 | -122.453974506819 | (37.7235925393546, -122.453974506819) | |||
| 29488 | 29488 | 219440 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 142 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001119.093859999 | 2094963.2287700002 | 37.732433161058395 | -122.438495108681 | (37.7324331610584, -122.438495108681) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 29877 | 29877 | 102353 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 662 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52560 | 5992263.7285400005 | 2110921.14049 | 37.775741736970204 | -122.470271582701 | (37.7757417369702, -122.470271582701) |
| 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) | |||
| 30440 | 30440 | 123815 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1951 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992581.39914 | 2112024.84953 | 37.7787905839512 | -122.469253041386 | (37.7787905839512, -122.469253041386) | |||
| 30456 | 30456 | 198402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 85 Harriet St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010657.10977 | 2111573.60472 | 37.778579498568604 | -122.406689940589 | (37.7785794985686, -122.406689940589) | |||
| 30575 | 30575 | 42240 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 532 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 2 | Permit Number 42489 | 6010157.096530001 | 2111965.88499 | 37.7796286197948 | -122.408447363381 | (37.7796286197948, -122.408447363381) | |
| 30659 | 30659 | 51400 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 421 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3 | 3c3 | Permit Number 50561 | 6011183.79367 | 2112305.04226 | 37.7806173092731 | -122.404919441686 | (37.7806173092731, -122.404919441686) | |
| 30819 | 30819 | 123714 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 339 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994520.39053 | 2111414.8777 | 37.7772276185203 | -122.462501102485 | (37.7772276185203, -122.462501102485) | |||
| 30849 | 30849 | 198285 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017793.32679 | 2099592.23757 | 37.7460778765941 | -122.381169499371 | (37.7460778765941, -122.381169499371) | |||
| 30973 | 30973 | 198274 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1236 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011932.48905 | 2102621.16084 | 37.7540693755115 | -122.401648489597 | (37.7540693755115, -122.401648489597) | |||
| 31042 | 31042 | 198387 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011311.4774 | 2113337.57021 | 37.7834595257768 | -122.404550424668 | (37.7834595257768, -122.404550424668) | |||
| 31127 | 31127 | 92816 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 410 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53025 | 5997688.97866 | 2114964.50163 | 37.787155913848 | -122.451796128513 | (37.787155913848, -122.451796128513) | |
| 31158 | 31158 | 198377 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011450.02335 | 2113431.79039 | 37.7837259742093 | -122.404077740098 | (37.7837259742093, -122.404077740098) | |||
| 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) | |||
| 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) | |||
| 31240 | 31240 | 53102 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 429@ GEARY BL 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 4 | Permit Number 49065 | 5994018.99484 | 2112572.39265 | 37.7803769568855 | -122.46431963578999 | (37.7803769568855, -122.46431963579) | ||
| 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) | ||
| 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) | |||
| 31590 | 31590 | 198270 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014327.719219999 | 2106393.16587 | 37.764559852075 | -122.39362912521099 | (37.764559852075, -122.393629125211) | ||||
| 31735 | 31735 | 198284 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017813.21777 | 2099593.44192 | 37.74608228148 | -122.381100801954 | (37.74608228148, -122.381100801954) | |||
| 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) | |||
| 32025 | 32025 | 242890 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009606.26166 | 2104418.84355 | 37.7588753255595 | -122.40982006693999 | (37.7588753255595, -122.40982006694) | |||
| 32167 | 32167 | 198365 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011243.08951 | 2113235.2529700003 | 37.7831747644438 | -122.404779815658 | (37.7831747644438, -122.404779815658) | |||
| 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) | |||
| 32574 | 32574 | 52874 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3476@ LAUREL Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2006 12:00:00 AM | 4 | Permit Number 48886 | 5998188.79133 | 2115538.04458 | 37.7887593241423 | -122.45010824850701 | (37.7887593241423, -122.450108248507) | ||
| 32694 | 32694 | 104489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101X Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012893.40207 | 2106545.4722700003 | 37.7648982471715 | -122.398600762736 | (37.7648982471715, -122.398600762736) | |||
| 32706 | 32706 | 120106 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987317.09594 | 2110472.8163099997 | 37.7742235329464 | -122.487350063639 | (37.7742235329464, -122.487350063639) | |||
| 32720 | 32720 | 198344 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 451 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010981.61371 | 2112109.48263 | 37.780069044799106 | -122.40560510460101 | (37.7800690447991, -122.405605104601) | |||
| 33164 | 33164 | 44473 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 258 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 6 | Permit Number 43787 | 6006246.79793 | 2092607.35071 | 37.7262547826049 | -122.420600221446 | (37.7262547826049, -122.420600221446) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 33722 | 33722 | 242337 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 157 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004758.7797 | 2102744.04826 | 37.754003877891606 | -122.42646567447599 | (37.7540038778916, -122.426465674476) | |||
| 33820 | 33820 | 198396 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 16 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010197.36501 | 2111335.28961 | 37.7778994078643 | -122.408263568012 | (37.7778994078643, -122.408263568012) | |||
| 33823 | 33823 | 136938 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1277 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008610.97542 | 2116946.31505 | 37.7932169703383 | -122.41414853544201 | (37.7932169703383, -122.414148535442) | |||
| 33869 | 33869 | 198258 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015275.05109 | 2107162.53945 | 37.766724978901 | -122.390406293135 | (37.766724978901, -122.390406293135) | |||
| 33902 | 33902 | 201660 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009127.89234 | 2109540.91695 | 37.7729125385177 | -122.411836435997 | (37.7729125385177, -122.411836435997) | |||
| 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) | |
| 34285 | 34285 | 242910 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 360 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004800.5697 | 2110038.5843599997 | 37.774035296231105 | -122.426840616201 | (37.7740352962311, -122.426840616201) | |||
| 34306 | 34306 | 44480 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 295 Harvard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43790 | 6006326.11018523 | 2092518.45956429 | 37.72601517641179 | -122.420319736223 | (37.7260151764118, -122.420319736223) | ||
| 34908 | 34908 | 52183 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | 5 | Permit Number 48373 | 6011742.35118 | 2096927.06221 | 37.738423995777104 | -122.401905791943 | (37.7384239957771, -122.401905791943) | |
| 35027 | 35027 | 242906 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2641 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010204.149619999 | 2104543.2646 | 37.759250446279005 | -122.407761055636 | (37.759250446279, -122.407761055636) | |||
| 35277 | 35277 | 136947 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 915 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012726.66985 | 2119026.8860400002 | 37.799160033972 | -122.400054056345 | (37.799160033972, -122.400054056345) | |||
| 35317 | 35317 | 123509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2636 Fulton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5995163.8038800005 | 2110297.4884900004 | 37.77419659482779 | -122.46019437077899 | (37.7741965948278, -122.460194370779) | |||
| 35409 | 35409 | 78535 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 62 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | 6 | 6007981.72204 | 2093794.7148099998 | 37.7296126541786 | -122.41468665108 | (37.7296126541786, -122.41468665108) | ||
| 35682 | 35682 | 198337 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 474 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010500.52756 | 2112291.4654599996 | 37.7805418139019 | -122.407282239501 | (37.7805418139019, -122.407282239501) | |||
| 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) | |||
| 35858 | 35858 | 246494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 365 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004182.0093 | 2099825.58993 | 37.745957849487795 | -122.428252301803 | (37.7459578494878, -122.428252301803) | |||
| 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) | |||
| 35932 | 35932 | 52449 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 447 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48562 | 5992476.75463 | 2112405.61073 | 37.779830003091504 | -122.469642770977 | (37.7798300030915, -122.469642770977) |
| 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) | ||
| 36175 | 36175 | 52474 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 576 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | 2 | 3x3 | Permit Number 48585 | 5991932.93207 | 2111539.52731 | 37.777420528381796 | -122.471460949443 | (37.7774205283818, -122.471460949443) |
| 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) | |
| 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) | |||
| 36728 | 36728 | 136945 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 805 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008467.13732 | 2120338.97067 | 37.802524280839705 | -122.414886453447 | (37.8025242808397, -122.414886453447) | |||
| 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) | |
| 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) | |||
| 36919 | 36919 | 43183 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 350 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 42986 | 6008206.3757 | 2092356.2981200002 | 37.7256756893785 | -122.41380829041401 | (37.7256756893785, -122.413808290414) | |
| 36920 | 36920 | 242908 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004832.66793 | 2110043.51339 | 37.7740506449575 | -122.426729933953 | (37.7740506449575, -122.426729933953) | |||
| 37242 | 37242 | 87382 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Moss St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50362 | 6010348.37894 | 2111212.00043 | 37.777569339594706 | -122.407732459893 | (37.7775693395947, -122.407732459893) | |
| 37378 | 37378 | 198292 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017651.2465699995 | 2099584.75723 | 37.7460494930826 | -122.381660279195 | (37.7460494930826, -122.381660279195) | |||
| 37392 | 37392 | 45242 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 604 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44093 | 6008555.70872799 | 2091212.30248413 | 37.7225541315384 | -122.41251983895201 | (37.7225541315384, -122.412519838952) | ||
| 37463 | 37463 | 101234 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 251 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994788.53914 | 2111424.28345 | 37.7772688824616 | -122.46157417945801 | (37.7772688824616, -122.461574179458) | |||
| 37494 | 37494 | 70335 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 6 | 6009780.67381 | 2094049.10859 | 37.7304120750579 | -122.408485397509 | (37.7304120750579, -122.408485397509) | ||
| 37498 | 37498 | 198311 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 75 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014300.67476 | 2114126.83927 | 37.7857932808859 | -122.394264166169 | (37.7857932808859, -122.394264166169) | |||
| 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) | ||
| 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) | |||
| 38368 | 38368 | 124531 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 821 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993023.60492 | 2111359.71361 | 37.776989843561 | -122.46767490536301 | (37.776989843561, -122.467674905363) | |||
| 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) | |||
| 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) | ||||
| 38531 | 38531 | 86963 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49931 | 6005615.529680001 | 2119592.0276 | 37.8003127220137 | -122.42470127923401 | (37.8003127220137, -122.424701279234) | |
| 38555 | 38555 | 198390 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6011047.1046400005 | 2113083.17782 | 37.7827462455888 | -122.405447134184 | (37.7827462455888, -122.405447134184) | |||
| 38574 | 38574 | 219441 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 147 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5999786.27103 | 2095740.5208700001 | 37.734491517651 | -122.443158781469 | (37.734491517651, -122.443158781469) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38795 | 38795 | 198287 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017753.37339 | 2099590.18904 | 37.7460700461913 | -122.38130751204399 | (37.7460700461913, -122.381307512044) | |||
| 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) | ||
| 38905 | 38905 | 65281 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 443 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 3 | Permit Number 28088 | 6011045.68858 | 2112172.30893 | 37.7802451338574 | -122.405387865261 | (37.7802451338574, -122.405387865261) | |
| 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) | |||
| 38984 | 38984 | 82050 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50668 | 5996119.951719999 | 2115777.79007 | 37.78929899740071 | -122.457283443584 | (37.7892989974007, -122.457283443584) | |
| 39275 | 39275 | 198334 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 432 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010764.31285 | 2112543.17724 | 37.7812477151384 | -122.406387417652 | (37.7812477151384, -122.406387417652) | |||
| 39379 | 39379 | 48916 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 77 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 5 | Permit Number 46108 | 6013166.41174 | 2106720.77544 | 37.765394797053496 | -122.39766878180299 | (37.7653947970535, -122.397668781803) | ||
| 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) | |||
| 39498 | 39498 | 198275 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1199 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 6011697.22277 | 2102839.72016 | 37.754656360309994 | -122.40247746938 | (37.75465636031, -122.40247746938) | |||
| 39506 | 39506 | 198280 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 951 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014735.9327300005 | 2097232.0415 | 37.739428022289204 | -122.39157667443001 | (37.7394280222892, -122.39157667443) | |||
| 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) | ||
| 39535 | 39535 | 136939 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1149 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008985.04879 | 2116923.16762 | 37.7931744171228 | -122.412852575501 | (37.7931744171228, -122.412852575501) |
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");