Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51018 | 51018 | 198427 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1322 Hudson Ave | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017279.83873 | 2095283.438 | 37.7342184214395 | -122.382645321023 | (37.7342184214395, -122.382645321023) | |||
| 168011 | 168011 | 180473 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008102.7284699995 | 2092853.30423 | 37.727034540698206 | -122.414201739328 | (37.7270345406982, -122.414201739328) | |||
| 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) | |||
| 24196 | 24196 | 198273 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014246.68754 | 2106694.7124400004 | 37.7653833298046 | -122.393930504207 | (37.7653833298046, -122.393930504207) | ||||
| 188968 | 188968 | 180471 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008133.97671 | 2092747.70208 | 37.7267463349569 | -122.414086246606 | (37.7267463349569, -122.414086246606) | |||
| 176102 | 176102 | 180470 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008144.58637 | 2092721.9532599999 | 37.7266762301091 | -122.414047748408 | (37.7266762301091, -122.414047748408) | |||
| 165210 | 165210 | 180469 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008151.81482 | 2092695.5003099998 | 37.726604001951706 | -122.414020889251 | (37.7266040019517, -122.414020889251) | |||
| 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) | |||
| 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) | |||
| 163520 | 163520 | 180466 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008185.76877 | 2092582.87899 | 37.7262966748277 | -122.41389554805299 | (37.7262966748277, -122.413895548053) | |||
| 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) | |||
| 146764 | 146764 | 180464 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008203.25845 | 2092526.29978 | 37.7261423026224 | -122.41383108645701 | (37.7261423026224, -122.413831086457) | |||
| 76791 | 76791 | 180463 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008211.686319999 | 2092495.1796099998 | 37.7260573265766 | -122.41379975137698 | (37.7260573265766, -122.413799751377) | |||
| 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) | |||
| 51615 | 51615 | 198272 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014300.74273 | 2106595.72792 | 37.765114544025295 | -122.393736609482 | (37.7651145440253, -122.393736609482) | ||||
| 45148 | 45148 | 180461 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008237.96297 | 2092412.37306 | 37.7258314330722 | -122.41370305985501 | (37.7258314330722, -122.413703059855) | |||
| 163390 | 163390 | 198310 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 299 Bryant St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015446.63596 | 2114020.379 | 37.7855645967725 | -122.390291988402 | (37.7855645967725, -122.390291988402) | |||
| 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) | |||
| 167739 | 167739 | 180459 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008256.12418 | 2092350.6219099998 | 37.7256628974135 | -122.413635911985 | (37.7256628974135, -122.413635911985) | |||
| 50620 | 50620 | 180458 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008265.9310099995 | 2092323.59976 | 37.725589251032 | -122.41360010007901 | (37.725589251032, -122.413600100079) | |||
| 186938 | 186938 | 180457 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008281.899180001 | 2092268.5986400002 | 37.725439126312104 | -122.413541011012 | (37.7254391263121, -122.413541011012) | |||
| 62144 | 62144 | 180456 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008358.46394 | 2092021.93043 | 37.7247661267393 | -122.41325889728998 | (37.7247661267393, -122.41325889729) | |||
| 100705 | 100705 | 122895 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 159839 | 159839 | 198423 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017270.50645 | 2094483.4459099998 | 37.7320212859403 | -122.38262193865299 | (37.7320212859403, -122.382621938653) | |||
| 87507 | 87507 | 122894 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 180617 | 180617 | 180455 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008364.39889 | 2091998.61159 | 37.7247024313603 | -122.413236732598 | (37.7247024313603, -122.413236732598) | |||
| 138864 | 138864 | 122893 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 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) | |||
| 16106 | 16106 | 12141 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016374.05041 | 2095443.42618 | 37.7346076354195 | -122.38578809634899 | (37.7346076354195, -122.385788096349) | |||
| 61024 | 61024 | 180453 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008383.04001 | 2091938.2142400001 | 37.7245376395946 | -122.4131680235 | (37.7245376395946, -122.4131680235) | |||
| 144507 | 144507 | 122892 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 23892 | 23892 | 180452 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008393.709980001 | 2091906.0725900002 | 37.724449984452704 | -122.413128866997 | (37.7244499844527, -122.413128866997) | |||
| 77493 | 77493 | 50330 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 79180 | 79180 | 122891 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 145834 | 145834 | 93374 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 147691 | 147691 | 198299 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017490.49598 | 2099601.17912 | 37.746085707003004 | -122.38221728150499 | (37.746085707003, -122.382217281505) | |||
| 159205 | 159205 | 198306 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 502 Beale St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6015908.341130001 | 2113925.9394400003 | 37.78533088635999 | -122.38868801426202 | (37.78533088636, -122.388688014262) | |||
| 162847 | 162847 | 198309 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015688.10696 | 2113472.66106 | 37.7840740783932 | -122.389418298834 | (37.7840740783932, -122.389418298834) | |||
| 169667 | 169667 | 198381 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011515.1376 | 2113488.48882 | 37.78388529271079 | -122.403856459201 | (37.7838852927108, -122.403856459201) | |||
| 74713 | 74713 | 198308 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015701.627180001 | 2113485.85575 | 37.7841110576194 | -122.389372445082 | (37.7841110576194, -122.389372445082) | |||
| 83773 | 83773 | 122890 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 85351 | 85351 | 50343 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 85816 | 85816 | 93373 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 158057 | 158057 | 180451 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008402.1171699995 | 2091878.23344 | 37.724374016020896 | -122.413097836812 | (37.7243740160209, -122.413097836812) | |||
| 161806 | 161806 | 198380 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011497.44668 | 2113474.8432400003 | 37.7838468368044 | -122.403916703013 | (37.7838468368044, -122.403916703013) | |||
| 172019 | 172019 | 198298 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017519.7761 | 2099586.1475400003 | 37.7460460504973 | -122.38211498813601 | (37.7460460504973, -122.382114988136) | |||
| 48947 | 48947 | 180450 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008413.5895 | 2091843.5213400002 | 37.7242793479848 | -122.413055725159 | (37.7242793479848, -122.413055725159) | |||
| 82016 | 82016 | 50342 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 84374 | 84374 | 122889 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 140039 | 140039 | 93372 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 181380 | 181380 | 198379 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011483.05552 | 2113458.79622 | 37.783801971433 | -122.403965361713 | (37.783801971433, -122.403965361713) | |||
| 183395 | 183395 | 198297 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017533.81233 | 2099583.55419 | 37.7460397048816 | -122.382066271836 | (37.7460397048816, -122.382066271836) | |||
| 53948 | 53948 | 198296 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017552.343280001 | 2099579.4388200003 | 37.7460294283132 | -122.382001907384 | (37.7460294283132, -122.382001907384) | |||
| 65756 | 65756 | 198271 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Pennsylvania Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014323.67834 | 2106481.09805 | 37.7648010700346 | -122.393649256519 | (37.7648010700346, -122.393649256519) | ||||
| 74674 | 74674 | 180449 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008420.75846 | 2091817.8357900002 | 37.724209223351295 | -122.413029127716 | (37.7242092233513, -122.413029127716) | |||
| 89782 | 89782 | 122888 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 100973 | 100973 | 93371 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 108353 | 108353 | 50341 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 115957 | 115957 | 198378 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011469.09396 | 2113447.40875 | 37.783769924074605 | -122.40401286211001 | (37.7837699240746, -122.40401286211) | |||
| 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) | |||
| 73875 | 73875 | 198295 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017570.97457 | 2099580.31165 | 37.746032853833206 | -122.38193754289101 | (37.7460328538332, -122.381937542891) | |||
| 98750 | 98750 | 50339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 108794 | 108794 | 28590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
| 126508 | 126508 | 122887 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 129375 | 129375 | 93370 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 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) | |||
| 50176 | 50176 | 198425 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1335 Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017678.76067 | 2094717.52418 | 37.7326865639235 | -122.38122677090401 | (37.7326865639235, -122.381226770904) | |||
| 57758 | 57758 | 198294 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017591.2197 | 2099581.33021 | 37.7460367685821 | -122.381867608025 | (37.7460367685821, -122.381867608025) | |||
| 66929 | 66929 | 198422 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1196 La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017170.944180001 | 2094491.5929599998 | 37.7320381554174 | -122.38296671716199 | (37.7320381554174, -122.382966717162) | |||
| 76935 | 76935 | 198376 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011438.043190001 | 2113419.02892 | 37.7836902648328 | -122.404118288736 | (37.7836902648328, -122.404118288736) | |||
| 78212 | 78212 | 93369 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 84890 | 84890 | 50338 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 89911 | 89911 | 122886 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 119764 | 119764 | 28589 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
| 124692 | 124692 | 95484 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986002.98697 | 2111639.37953 | 37.777349862368496 | -122.491981644298 | (37.7773498623685, -122.491981644298) | |||
| 181510 | 181510 | 180447 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008436.67038 | 2091759.83513 | 37.7240508590526 | -122.412970023366 | (37.7240508590526, -122.412970023366) | |||
| 78993 | 78993 | 50337 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 88350 | 88350 | 62378 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1985 12:00:00 AM | 24 | Permit Number 22527 | 5986003.033530001 | 2111613.32749 | 37.7772783336166 | -122.491979564694 | (37.7772783336166, -122.491979564694) | |
| 105370 | 105370 | 122885 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 107846 | 107846 | 93368 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 117573 | 117573 | 28588 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 132057 | 132057 | 198269 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015584.25134 | 2107180.42064 | 37.7667912238576 | -122.38933806131 | (37.7667912238576, -122.38933806131) | |||
| 176058 | 176058 | 198395 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010955.650090001 | 2112999.3376599997 | 37.7825109262834 | -122.40575762241998 | (37.7825109262834, -122.40575762242) | |||
| 183751 | 183751 | 198375 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011427.189130001 | 2113412.24686 | 37.7836710364202 | -122.40415536240101 | (37.7836710364202, -122.404155362401) | |||
| 184169 | 184169 | 180446 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008445.91914 | 2091731.3401099998 | 37.723973136934205 | -122.412936037975 | (37.7239731369342, -122.412936037975) | |||
| 22160 | 22160 | 24821 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 12 | 3x3 | 6007884.87342 | 2094945.99869 | 37.7327683887373 | -122.41510292745701 | (37.7327683887373, -122.415102927457) | ||
| 51539 | 51539 | 198268 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015559.03734 | 2107179.0425299997 | 37.7667860419549 | -122.389425176852 | (37.7667860419549, -122.389425176852) | |||
| 57835 | 57835 | 198293 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017632.06769 | 2099583.36051 | 37.746044598982 | -122.381726500798 | (37.746044598982, -122.381726500798) | |||
| 98617 | 98617 | 26044 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 7 | 3X3 | 5996138.5208 | 2088089.89027 | 37.7132760340232 | -122.45521749021002 | (37.7132760340232, -122.45521749021) | ||
| 123561 | 123561 | 95485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.777159118639496 | -122.49196396094601 | (37.7771591186395, -122.491963960946) | |||
| 144043 | 144043 | 122884 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
| 145966 | 145966 | 93367 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 146099 | 146099 | 50336 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) | |||
| 159480 | 159480 | 198394 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010970.67722 | 2113013.70432 | 37.782551214095 | -122.40570664706001 | (37.782551214095, -122.40570664706) | |||
| 175717 | 175717 | 198374 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 413 Minna St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011406.73882 | 2113394.65572 | 37.7836215925909 | -122.40422487458599 | (37.7836215925909, -122.404224874586) | |||
| 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) | |||
| 49590 | 49590 | 23252 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 780X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1997 12:00:00 AM | 3 | 4X4 | 6006324.392990001 | 2112868.49551 | 37.7818915869358 | -122.42177049090598 | (37.7818915869358, -122.421770490906) | ||
| 81738 | 81738 | 16859 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 150 Oak St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2012 12:00:00 AM | 3 | 4X4 | Permit Number 768229 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | |
| 107773 | 107773 | 26043 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 3X3 | 5996178.64561 | 2088089.5286700001 | 37.7132773431944 | -122.455078779743 | (37.7132773431944, -122.455078779743) | ||
| 113669 | 113669 | 50325 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 800 Howard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47027 | 6011804.62749252 | 2113253.78285817 | 37.783257013527496 | -122.40283841310101 | (37.7832570135275, -122.402838413101) |
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");