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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161848 | 161848 | 70149 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 754 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 8 | 5989468.1167 | 2110177.57013 | 37.773538072981204 | -122.479887770247 | (37.7735380729812, -122.479887770247) | ||
| 177436 | 177436 | 70333 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 143 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 7 | 6009984.51803 | 2093871.67123 | 37.7299362833339 | -122.407768169286 | (37.7299362833339, -122.407768169286) | ||
| 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) | ||
| 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) | ||
| 26966 | 26966 | 70402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006462.64225 | 2092921.27798 | 37.727128920939606 | -122.419876323835 | (37.7271289209396, -122.419876323835) | ||
| 162109 | 162109 | 70404 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 218 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006477.26442 | 2092881.04144 | 37.7270192639056 | -122.41982292118601 | (37.7270192639056, -122.419822921186) | ||
| 181702 | 181702 | 70405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006525.54367 | 2092869.6574799998 | 37.726990725739 | -122.41965521291999 | (37.726990725739, -122.41965521292) | ||
| 45366 | 45366 | 70407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 231 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006535.83698 | 2092862.23217 | 37.7269709172726 | -122.419619102459 | (37.7269709172726, -122.419619102459) | ||
| 26540 | 26540 | 70481 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 934 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 3 | 6005107.91916 | 2092023.60961 | 37.7245877066523 | -122.424495766183 | (37.7245877066523, -122.424495766183) | ||
| 117662 | 117662 | 70482 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 935 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 4 | 6005101.627719999 | 2092066.92628 | 37.724706289440796 | -122.424520594648 | (37.7247062894408, -122.424520594648) | ||
| 176376 | 176376 | 70562 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 8 | 6014127.69322 | 2112419.53716 | 37.7810958034577 | -122.39474303089199 | (37.7810958034577, -122.394743030892) | ||
| 67644 | 67644 | 70573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 862 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 11 | 5982961.78283 | 2109923.12422 | 37.772459289826 | -122.502374937437 | (37.772459289826, -122.502374937437) | ||
| 185243 | 185243 | 72258 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 230 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 11 | 6002786.80425 | 2092214.2025900001 | 37.7249796797621 | -122.432533160192 | (37.7249796797621, -122.432533160192) | ||
| 180856 | 180856 | 72281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.242880001 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | ||
| 173502 | 173502 | 73886 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014128.33524 | 2112437.75054 | 37.78114584894679 | -122.39474208568701 | (37.7811458489468, -122.394742085687) | ||
| 55075 | 55075 | 74119 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 7 | 6014130.8006 | 2112451.57445 | 37.7811839433263 | -122.39473452509199 | (37.7811839433263, -122.394734525092) | ||
| 181929 | 181929 | 74171 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 466 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 1 | 6011049.67315 | 2111947.37062 | 37.7796277285636 | -122.405358235294 | (37.7796277285636, -122.405358235294) | ||
| 15219 | 15219 | 74369 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 535 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 2 | 8x4 | 6009942.57894 | 2111988.4402900003 | 37.7796785357608 | -122.40919106762101 | (37.7796785357608, -122.409191067621) | |
| 147888 | 147888 | 74993 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 414 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1989 12:00:00 AM | 1 | 6011197.75639 | 2112352.56567 | 37.780748577930204 | -122.404874484592 | (37.7807485779302, -122.404874484592) | ||
| 130711 | 130711 | 75004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997965.54363 | 2116098.57851 | 37.7902856238171 | -122.450921084564 | (37.7902856238171, -122.450921084564) | ||
| 173810 | 173810 | 75766 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009894.26848 | 2094011.0737400001 | 37.730314000377 | -122.408090001562 | (37.730314000377, -122.408090001562) | ||
| 187128 | 187128 | 78262 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 6 | 6010118.26182 | 2092179.1105400003 | 37.725296353538795 | -122.40718653543699 | (37.7252963535388, -122.407186535437) | ||
| 154542 | 154542 | 78505 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 432 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009991.68308 | 2093152.7262400002 | 37.7279626131612 | -122.407692726044 | (37.7279626131612, -122.407692726044) | ||
| 133147 | 133147 | 78531 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 6 | 6010098.32429 | 2092174.05375 | 37.7252813528324 | -122.407255101567 | (37.7252813528324, -122.407255101567) | ||
| 43394 | 43394 | 78532 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6010074.13409 | 2092167.4028 | 37.725261736838604 | -122.407338256469 | (37.7252617368386, -122.407338256469) | ||
| 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) | ||
| 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) | ||
| 43763 | 43763 | 79959 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1719 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 5 | 6014649.309169999 | 2095031.35513 | 37.73338057973321 | -122.39172235292 | (37.7333805797332, -122.39172235292) | ||
| 50678 | 50678 | 80637 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 706 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6011239.20103 | 2105002.70461 | 37.7605698551303 | -122.404213664555 | (37.7605698551303, -122.404213664555) | ||
| 181939 | 181939 | 82808 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 637 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | 4 | 5992833.07706 | 2111118.80762 | 37.776317378073294 | -122.468316464164 | (37.7763173780733, -122.468316464164) | ||
| 86458 | 86458 | 95224 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 299 on 16th St Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6004880.0 | 2106610.0 | 37.764625720621794 | -122.426321695151 | (37.7646257206218, -122.426321695151) | |||
| 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) | |||
| 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) | |||
| 117880 | 117880 | 95486 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.777104032517705 | -122.49195980083701 | (37.7771040325177, -122.491959800837) | |||
| 111692 | 111692 | 95487 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.3689900003 | 37.777048124873296 | -122.49195459962401 | (37.7770481248733, -122.491954599624) | |||
| 91382 | 91382 | 95488 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.7101 | 2111508.12486 | 37.776989750535 | -122.491955639862 | (37.776989750535, -122.491955639862) | |||
| 140987 | 140987 | 95489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.5622099997 | 37.7769305539658 | -122.49195355936199 | (37.7769305539658, -122.491953559362) | |||
| 141798 | 141798 | 95490 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.49195251911199 | (37.7768664240251, -122.491952519112) | |||
| 94030 | 94030 | 95491 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.776807227327396 | -122.491945237383 | (37.7768072273274, -122.491945237383) | |||
| 96802 | 96802 | 95494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.2940599998 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | |||
| 93377 | 93377 | 95497 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985999.2312900005 | 2111660.71954 | 37.777408236422296 | -122.491996207782 | (37.7774082364223, -122.491996207782) | |||
| 108571 | 108571 | 95509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | ||
| 112142 | 112142 | 95511 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | ||
| 139550 | 139550 | 95513 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.2856099997 | 37.7783619491242 | -122.49205757976002 | (37.7783619491242, -122.49205757976) | |||
| 120188 | 120188 | 95514 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | ||
| 96578 | 96578 | 95515 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | |||
| 107004 | 107004 | 95516 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985994.45155 | 2111944.6872400003 | 37.778187651292896 | -122.492033654948 | (37.7781876512929, -122.492033654948) | |||
| 142332 | 142332 | 95517 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.49203365493601 | (37.778128454962, -122.492033654936) | |||
| 101527 | 101527 | 95518 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985992.056890001 | 2111902.81718 | 37.778072548088495 | -122.49203885528601 | (37.7780725480885, -122.492038855286) | |||
| 79513 | 79513 | 95519 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985993.74648 | 2111883.3180400003 | 37.7780191077803 | -122.49203157445 | (37.7780191077803, -122.49203157445) | |||
| 150833 | 150833 | 97956 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280x McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768057 | 6011739.12667 | 2098678.3172400002 | 37.7432323892731 | -122.40204002115499 | (37.7432323892731, -122.402040021155) | |
| 151131 | 151131 | 97958 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011714.55105 | 2098696.24817 | 37.7432802520847 | -122.402126258043 | (37.7432802520847, -122.402126258043) | |
| 151647 | 151647 | 97959 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768057 | 6011701.54939 | 2098706.65667 | 37.743308105886506 | -122.40217194628299 | (37.7433081058865, -122.402171946283) | |
| 146618 | 146618 | 97960 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011686.23984 | 2098718.09501 | 37.7433386585668 | -122.40222568708401 | (37.7433386585668, -122.402225687084) | |
| 176442 | 176442 | 97961 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2280X McKinnon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768057 | 6011645.30787 | 2098748.77937 | 37.743420626377294 | -122.402369377168 | (37.7434206263773, -122.402369377168) | |
| 5559 | 5559 | 98004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1908 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2015 12:00:00 AM | 14 | 5x5 | Permit Number 775450 | 6003753.55269 | 2119031.9849799997 | 37.79866965343071 | -122.43110445762301 | (37.7986696534307, -122.431104457623) | |
| 145720 | 145720 | 98741 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
| 144482 | 144482 | 98742 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
| 15099 | 15099 | 99592 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1855X Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014373.22453 | 2099430.50237 | 37.7454443986533 | -122.392984546922 | (37.7454443986533, -122.392984546922) | |||
| 95576 | 95576 | 100214 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001088.1 | 2111178.5 | 37.77695461161171 | -122.439764396806 | (37.7769546116117, -122.439764396806) | |||
| 6827 | 6827 | 100292 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3701 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003061.81659 | 2121064.97367 | 37.804212487284005 | -122.43364345509701 | (37.804212487284, -122.433643455097) | |||
| 14258 | 14258 | 100759 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 362 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6014440.04423 | 2112282.11717 | 37.780735840838396 | -122.39365282322201 | (37.7807358408384, -122.393652823222) | |||
| 14003 | 14003 | 100882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013366.225459999 | 2111763.75465 | 37.7792528084154 | -122.397331345366 | (37.7792528084154, -122.397331345366) | |||
| 16098 | 16098 | 100884 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013403.42787 | 2111798.46493 | 37.7793501860944 | -122.397205080544 | (37.7793501860944, -122.397205080544) | |||
| 14587 | 14587 | 100888 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013550.27415 | 2111938.66795 | 37.7797433256341 | -122.396706905611 | (37.7797433256341, -122.396706905611) | |||
| 15713 | 15713 | 100889 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013566.0867800005 | 2111954.86803 | 37.7797886874229 | -122.396653338395 | (37.7797886874229, -122.396653338395) | |||
| 15396 | 15396 | 100890 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013579.59012 | 2111966.26913 | 37.779820743762606 | -122.39660742352 | (37.7798207437626, -122.39660742352) | |||
| 13583 | 13583 | 100891 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013606.47382 | 2111993.91964 | 37.7798981618967 | -122.396516359044 | (37.7798981618967, -122.396516359044) | |||
| 15863 | 15863 | 100892 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 91 Welsh St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013627.65977 | 2112013.31498 | 37.7799525960738 | -122.396444426786 | (37.7799525960738, -122.396444426786) | |||
| 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) | |
| 15205 | 15205 | 102387 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 84 Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010709.4483199995 | 2111466.67522 | 37.778288823307 | -122.406501343779 | (37.778288823307, -122.406501343779) | |||
| 15592 | 15592 | 102388 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 90X Harriet St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010739.31321 | 2111434.0362400003 | 37.778200875001104 | -122.406395729189 | (37.7782008750011, -122.406395729189) | |||
| 4081 | 4081 | 102392 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 30X Harriet St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6010436.41014 | 2111752.09711 | 37.7790572463352 | -122.40746601596202 | (37.7790572463352, -122.407466015962) | |||
| 84938 | 84938 | 102708 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 999X PHELPS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744.0 | 2097272.0 | 37.7395381878784 | -122.39155157401501 | (37.7395381878784, -122.391551574015) | |
| 114153 | 114153 | 102709 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 999X PHELPS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744.0 | 2097272.0 | 37.7395381878784 | -122.39155157401501 | (37.7395381878784, -122.391551574015) | |
| 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) | |||
| 13559 | 13559 | 106005 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 59 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6013632.51665 | 2093922.487 | 37.7302793593954 | -122.395160068985 | (37.7302793593954, -122.395160068985) | ||
| 80644 | 80644 | 106769 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2600X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010715.11393 | 2102268.82005 | 37.753033918516 | -122.405833670893 | (37.753033918516, -122.405833670893) | ||||
| 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) | |||
| 94146 | 94146 | 110101 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1348 Douglass St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 774671 | 6001379.0 | 2099692.0 | 37.7454320431231 | -122.437935141467 | (37.7454320431231, -122.437935141467) | |||
| 9705 | 9705 | 110500 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900X JESSIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007667.0 | 2110717.0 | 37.7760597176113 | -122.416973193872 | (37.7760597176113, -122.416973193872) | |||
| 9708 | 9708 | 110501 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900X JESSIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007667.0 | 2110717.0 | 37.7760597176113 | -122.416973193872 | (37.7760597176113, -122.416973193872) | |||
| 114489 | 114489 | 111363 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 103584 | 103584 | 111364 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 116463 | 116463 | 111365 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 90501 | 90501 | 111366 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2x MELROSE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x9 | 5999779.0 | 2095500.0 | 37.7338306891962 | -122.443166651102 | (37.7338306891962, -122.443166651102) | |||
| 95213 | 95213 | 113810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |||
| 106701 | 106701 | 113812 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4101x 25TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 1 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
| 2218 | 2218 | 114579 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002950.36974 | 2121305.2817599997 | 37.8048659859314 | -122.43404631360701 | (37.8048659859314, -122.434046313607) | ||
| 6649 | 6649 | 114581 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1501 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3 | 3x3 | 6002967.5258 | 2121305.9196 | 37.8048687108976 | -122.433986988903 | (37.8048687108976, -122.433986988903) | ||
| 117433 | 117433 | 115917 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3100X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989023.45884 | 2111952.8782599997 | 37.7783867322409 | -122.481555937234 | (37.7783867322409, -122.481555937234) | |||
| 80755 | 80755 | 115918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3100X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989005.40184 | 2111951.8122900003 | 37.7783827554231 | -122.481618324321 | (37.7783827554231, -122.481618324321) | |||
| 56163 | 56163 | 116375 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50x Madera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012868.23872 | 2103276.4049 | 37.7559207054891 | -122.39845839373301 | (37.7559207054891, -122.398458393733) | |||
| 26251 | 26251 | 116376 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50x Madera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012832.143680001 | 2103274.0879599997 | 37.7559123328161 | -122.39858306046801 | (37.7559123328161, -122.398583060468) | |||
| 144893 | 144893 | 117180 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | |||
| 110307 | 110307 | 117181 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 8 KNOTT CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000120.0 | 2086463.0 | 37.7090365866676 | -122.44133950250601 | (37.7090365866676, -122.441339502506) | ||||
| 163695 | 163695 | 117668 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4826 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5983640.52001 | 2111755.82857 | 37.7775312233534 | -122.500162667158 | (37.7775312233534, -122.500162667158) | |||
| 163820 | 163820 | 117670 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 7751 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5982957.689809999 | 2112492.79061 | 37.779514605287794 | -122.502579326611 | (37.7795146052878, -122.502579326611) | |||
| 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) | |||
| 45764 | 45764 | 117863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 798 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983563.66024 | 2110432.70706 | 37.7738938035198 | -122.50033069971902 | (37.7738938035198, -122.500330699719) |
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");