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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13358 | 13358 | 79034 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2002 12:00:00 AM | 1 | 2.5x4 | 6010138.62156 | 2111398.24518 | 37.7780689795412 | -122.40847122506399 | (37.7780689795412, -122.408471225064) | ||
| 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) | |
| 23058 | 23058 | 37914 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1310 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | 1 | 3x3 | Permit Number 40177 | 6013291.37009 | 2106638.00873 | 37.7651744955273 | -122.397230772395 | (37.7651744955273, -122.397230772395) | |
| 23334 | 23334 | 8279 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1601 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6015771.79311 | 2097687.24817 | 37.740735369454605 | -122.388026849781 | (37.7407353694546, -122.388026849781) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 28007 | 28007 | 198263 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015429.86935 | 2107171.76588 | 37.7667588995269 | -122.38987144293002 | (37.7667588995269, -122.38987144293) | |||
| 28474 | 28474 | 198266 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015509.21403 | 2107176.39831 | 37.7667760190131 | -122.389597324184 | (37.7667760190131, -122.389597324184) | |||
| 28616 | 28616 | 198332 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 441 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010628.31321 | 2112645.1996400002 | 37.781520235806106 | -122.406865104253 | (37.7815202358061, -122.406865104253) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 40735 | 40735 | 198261 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015349.85102 | 2107166.4928900003 | 37.7667399832017 | -122.390147846856 | (37.7667399832017, -122.390147846856) | |||
| 42267 | 42267 | 198426 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1333 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017711.66244 | 2094697.5586700002 | 37.7326335587832 | -122.381111632521 | (37.7326335587832, -122.381111632521) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 45489 | 45489 | 198383 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011433.08529 | 2113455.1444200003 | 37.783789152501996 | -122.404137983874 | (37.783789152502, -122.404137983874) | |||
| 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) | |||
| 46587 | 46587 | 198262 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015403.651819999 | 2107169.78818 | 37.766752015232 | -122.38996198758001 | (37.766752015232, -122.38996198758) | |||
| 48325 | 48325 | 136956 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012358.49357 | 2116085.98474 | 37.7910644861899 | -122.401121320516 | (37.7910644861899, -122.401121320516) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 52983 | 52983 | 198318 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 525 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010168.4896599995 | 2108781.79688 | 37.7708864936515 | -122.408183320597 | (37.7708864936515, -122.408183320597) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 63008 | 63008 | 114541 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 67092 | 67092 | 198290 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017692.8350599995 | 2099588.0199599997 | 37.746060748120705 | -122.381516697036 | (37.7460607481207, -122.381516697036) | |||
| 68392 | 68392 | 198317 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 525 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010159.723230001 | 2108789.19048 | 37.7709063039035 | -122.408214165578 | (37.7709063039035, -122.408214165578) | |||
| 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) | |||
| 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) | |||
| 69447 | 69447 | 198330 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 442 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010597.74808 | 2112652.40917 | 37.7815383211684 | -122.40697135373999 | (37.7815383211684, -122.40697135374) | |||
| 69929 | 69929 | 198264 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015458.161180001 | 2107173.009 | 37.7667638817829 | -122.389773672231 | (37.7667638817829, -122.389773672231) | |||
| 71767 | 71767 | 198424 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1197 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017092.18151 | 2094577.95359 | 37.7322709323521 | -122.38324502853999 | (37.7322709323521, -122.38324502854) | |||
| 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) | |||
| 72913 | 72913 | 198388 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011155.22341 | 2113196.02476 | 37.7830621414549 | -122.40508103546101 | (37.7830621414549, -122.405081035461) | |||
| 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) | |||
| 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) | |||
| 74463 | 74463 | 198340 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 410 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011276.2561800005 | 2112433.90925 | 37.7809763159449 | -122.404608642289 | (37.7809763159449, -122.404608642289) | |||
| 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) | |
| 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) | |||
| 74955 | 74955 | 198283 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017833.27301 | 2099593.92963 | 37.7460847276446 | -122.381031486718 | (37.7460847276446, -122.381031486718) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 129509 | 129509 | 198279 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 951 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014707.30065 | 2097191.0938 | 37.7393139990344 | -122.391672810175 | (37.7393139990344, -122.391672810175) | |||
| 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) | |||
| 129565 | 129565 | 198385 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011340.58329 | 2113365.77495 | 37.7835385959651 | -122.404451715074 | (37.7835385959651, -122.404451715074) | |||
| 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) | |||
| 130533 | 130533 | 198421 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1196 La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017061.11221 | 2094548.33613 | 37.732187891662896 | -122.383350382316 | (37.7321878916629, -122.383350382316) | |||
| 131704 | 131704 | 198291 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017672.75114 | 2099586.10688 | 37.746054386310796 | -122.38158601229601 | (37.7460543863108, -122.381586012296) | |||
| 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) | |||
| 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) | |||
| 132413 | 132413 | 198257 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 401 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6015249.12496 | 2107161.11313 | 37.7667196243297 | -122.390495868314 | (37.7667196243297, -122.390495868314) | |||
| 132456 | 132456 | 198307 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015819.881580001 | 2113595.44766 | 37.784418527738204 | -122.388970977841 | (37.7844185277382, -122.388970977841) |
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");