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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152673 | 152673 | 226615 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 10 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005546.7514 | 2097096.0791900002 | 37.7385403572369 | -122.423339202051 | (37.7385403572369, -122.423339202051) | |||
| 28331 | 28331 | 207313 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996777.96593 | 2094453.90027 | 37.730786773973605 | -122.45346656615101 | (37.7307867739736, -122.453466566151) | |||
| 73988 | 73988 | 207312 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996777.2193 | 2094487.3918299999 | 37.730878690977704 | -122.45347156457399 | (37.7308786909777, -122.453471564574) | |||
| 137162 | 137162 | 207228 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1018 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995061.38916 | 2090705.2918200002 | 37.720395449464796 | -122.459129669002 | (37.7203954494648, -122.459129669002) | |||
| 186733 | 186733 | 226608 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1035 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997646.28955 | 2106916.84179 | 37.765056684330794 | -122.451363177783 | (37.7650566843308, -122.451363177783) | |||
| 184863 | 184863 | 226581 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006265.98852 | 2097494.29518 | 37.739674335789 | -122.420880685817 | (37.739674335789, -122.420880685817) | |||
| 51460 | 51460 | 226589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999827.96585 | 2100023.61803 | 37.7462542624189 | -122.443322166684 | (37.7462542624189, -122.443322166684) | |||
| 11989 | 11989 | 26837 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1100X Duncan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | ||||||||
| 53847 | 53847 | 207299 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996293.5704 | 2094296.85345 | 37.7303277824929 | -122.455129844261 | (37.7303277824929, -122.455129844261) | |||
| 76051 | 76051 | 207298 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 111 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996286.51947 | 2094316.70178 | 37.73038187671379 | -122.45515565391099 | (37.7303818767138, -122.455155653911) | |||
| 52623 | 52623 | 40627 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | ||
| 163271 | 163271 | 32472 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 117 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36980 | 6000335.64895 | 2106187.4701799997 | 37.7632076377424 | -122.442009017113 | (37.7632076377424, -122.442009017113) | |
| 177051 | 177051 | 207148 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1210 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992391.03537 | 2107185.15973 | 37.7654910946525 | -122.469559175111 | (37.7654910946525, -122.469559175111) | |||
| 35444 | 35444 | 31932 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1210 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35348 | 5981508.8658 | 2106816.8909 | 37.763844998562206 | -122.507170151225 | (37.7638449985622, -122.507170151225) | |
| 185161 | 185161 | 183715 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1226 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983995.5254 | 2106803.3357 | 37.7639539248956 | -122.49856868241899 | (37.7639539248956, -122.498568682419) | |||
| 25103 | 25103 | 226578 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 124 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998059.2298099995 | 2106534.17954 | 37.76402962709221 | -122.44990734536199 | (37.7640296270922, -122.449907345362) | |||
| 137148 | 137148 | 177027 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 127 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6004458.22384 | 2092761.54245 | 37.726577195866206 | -122.426794207588 | (37.7265771958662, -122.426794207588) | |||
| 186519 | 186519 | 32589 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.763129529589705 | -122.493148331917 | (37.7631295295897, -122.493148331917) | |
| 145138 | 145138 | 24745 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 128X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982364.706809999 | 2112649.87562 | 37.779911051225206 | -122.50464231484501 | (37.7799110512252, -122.504642314845) | ||
| 117257 | 117257 | 108497 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1339 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773641 | 5992378.78756 | 2106335.85187 | 37.7631584124216 | -122.46953970622101 | (37.7631584124216, -122.469539706221) |
| 136966 | 136966 | 207147 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1341 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5992375.35662 | 2106303.37048 | 37.7630690288235 | -122.469549207953 | (37.7630690288235, -122.469549207953) | |||
| 59419 | 59419 | 207291 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 135 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993593.95913 | 2093848.0757900001 | 37.7289402994475 | -122.464430125662 | (37.7289402994475, -122.464430125662) | |||
| 67505 | 67505 | 50406 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1361 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 4 | Permit Number 47058 | 5981810.1658 | 2105846.3225 | 37.761197837443596 | -122.50605609679701 | (37.7611978374436, -122.506056096797) | |
| 23605 | 23605 | 207223 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 137 Marston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998550.7404 | 2093191.23092 | 37.7274212410962 | -122.447246987057 | (37.7274212410962, -122.447246987057) | |||
| 109500 | 109500 | 116713 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1400 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6000212.5605 | 2113848.1665 | 37.78423495653821 | -122.44298491286699 | (37.7842349565382, -122.442984912867) | |||
| 130678 | 130678 | 116712 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1400 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6000214.6483 | 2113835.6397 | 37.784200680215605 | -122.44297678993999 | (37.7842006802156, -122.44297678994) | |||
| 60876 | 60876 | 226631 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002644.82708 | 2096800.8937799998 | 37.737565638743895 | -122.43335156393299 | (37.7375656387439, -122.433351563933) | |||
| 179189 | 179189 | 207142 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1419 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991123.51551 | 2105737.38087 | 37.7614425437634 | -122.473837564856 | (37.7614425437634, -122.473837564856) | |||
| 36376 | 36376 | 37433 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1419 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1998 12:00:00 AM | 6 | Permit Number 39907 | 5991189.91551 | 2110613.34906 | 37.7748344845766 | -122.473963672883 | (37.7748344845766, -122.473963672883) | ||
| 42942 | 42942 | 207270 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | |||
| 28926 | 28926 | 207301 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996452.48883 | 2094524.36789 | 37.7309615985977 | -122.454596874545 | (37.7309615985977, -122.454596874545) | |||
| 62171 | 62171 | 207300 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 145 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996448.99813 | 2094535.9636799998 | 37.730993237639105 | -122.45460977981199 | (37.7309932376391, -122.454609779812) | |||
| 49438 | 49438 | 226600 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1463 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6003321.08221 | 2099703.03715 | 37.7455725970047 | -122.431220523219 | (37.7455725970047, -122.431220523219) | |||
| 165783 | 165783 | 207222 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998739.609180001 | 2093444.36182 | 37.728127069498 | -122.44661227434999 | (37.728127069498, -122.44661227435) | |||
| 69145 | 69145 | 207269 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1477 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994263.394830001 | 2105452.9722599997 | 37.760842992730105 | -122.462957472303 | (37.7608429927301, -122.462957472303) | |||
| 45169 | 45169 | 183658 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1487 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981219.3285 | 2104945.9280000003 | 37.7586908149842 | -122.508032687607 | (37.7586908149842, -122.508032687607) | |||
| 173335 | 173335 | 183659 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1487 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981220.5326 | 2104962.3842 | 37.7587360699481 | -122.50802974468701 | (37.7587360699481, -122.508029744687) | |||
| 48932 | 48932 | 70374 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | ||
| 26310 | 26310 | 139038 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000648.2136 | 2113864.1729 | 37.7843037348812 | -122.441478860369 | (37.7843037348812, -122.441478860369) | |||
| 29485 | 29485 | 139037 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000646.8218 | 2113873.9159999997 | 37.7843304076342 | -122.441484374883 | (37.7843304076342, -122.441484374883) | |||
| 53082 | 53082 | 139036 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000642.6462 | 2113889.2265 | 37.784372208438604 | -122.441499920001 | (37.7843722084386, -122.441499920001) | |||
| 184226 | 184226 | 139035 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000637.7747 | 2113910.8003 | 37.7844311670031 | -122.441518322309 | (37.7844311670031, -122.441518322309) | |||
| 181523 | 181523 | 226601 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1518 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003286.59929 | 2099387.77612 | 37.7447050093281 | -122.431317259697 | (37.7447050093281, -122.431317259697) | |||
| 181185 | 181185 | 66621 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 153 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 2 | Permit Number 29825 | 5988002.0511 | 2114993.09117 | 37.7866748512276 | -122.48531246716499 | (37.7866748512276, -122.485312467165) | ||
| 189085 | 189085 | 139033 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1535 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000628.7276 | 2113990.1365 | 37.784648488341496 | -122.441555317265 | (37.7846484883415, -122.441555317265) | |||
| 185686 | 185686 | 139032 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1535 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000626.6398 | 2114005.4469999997 | 37.784690408082 | -122.441563639416 | (37.784690408082, -122.441563639416) | |||
| 177917 | 177917 | 177001 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 154 Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013011.29164 | 2086676.67622 | 37.7103492505861 | -122.396799956671 | (37.7103492505861, -122.396799956671) | |||
| 183532 | 183532 | 227705 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1552 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005224.91638 | 2099272.18009 | 37.744497267738105 | -122.424606707457 | (37.7444972677381, -122.424606707457) | |||
| 170261 | 170261 | 207163 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1557 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993970.96623 | 2104931.68714 | 37.7593948306232 | -122.46393100551902 | (37.7593948306232, -122.463931005519) | |||
| 70570 | 70570 | 207314 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994021.19813 | 2104903.51705 | 37.759320377550395 | -122.46375523571999 | (37.7593203775504, -122.46375523572) | |||
| 154080 | 154080 | 207315 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994029.69886 | 2104725.63145 | 37.7588324395785 | -122.463712925326 | (37.7588324395785, -122.463712925326) | |||
| 57295 | 57295 | 207143 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991127.14012 | 2104370.55559 | 37.7576898140615 | -122.473725315989 | (37.7576898140615, -122.473725315989) | |||
| 73802 | 73802 | 207144 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1617 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991126.06401 | 2104353.71257 | 37.757643505256205 | -122.473727808906 | (37.7576435052562, -122.473727808906) | |||
| 133337 | 133337 | 177023 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1628 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006643.54009 | 2092125.7831400002 | 37.7249548539585 | -122.419194556805 | (37.7249548539585, -122.419194556805) | |||
| 172270 | 172270 | 177022 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1628 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006681.726369999 | 2092138.2756599998 | 37.724991306183796 | -122.419063436538 | (37.7249913061838, -122.419063436538) | |||
| 43666 | 43666 | 207282 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 163 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995118.51339 | 2093829.85755 | 37.7289780403896 | -122.459158347475 | (37.7289780403896, -122.459158347475) | |||
| 47695 | 47695 | 41753 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1644 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 4 | Permit Number 42182 | 6006856.27196 | 2116746.53055 | 37.7925696967985 | -122.42020574908899 | (37.7925696967985, -122.420205749089) | |
| 62758 | 62758 | 207140 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990920.30999 | 2103955.3917900003 | 37.7565379030086 | -122.474410316087 | (37.7565379030086, -122.474410316087) | |||
| 167231 | 167231 | 207166 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 174 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995172.17423 | 2097043.6524099999 | 37.737805421392295 | -122.459205466579 | (37.7378054213923, -122.459205466579) | |||
| 30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
| 131950 | 131950 | 71605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 178 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994512.31694 | 2086511.3564 | 37.7088483153534 | -122.46072384594 | (37.7088483153534, -122.46072384594) | ||
| 57515 | 57515 | 67671 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1780 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 3 | Permit Number 31274 | 6014163.98928 | 2095111.2366 | 37.733572965423896 | -122.3934058406 | (37.7335729654239, -122.3934058406) | ||
| 60300 | 60300 | 182865 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1845 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989054.8495 | 2102750.5341 | 37.75312143070521 | -122.480773464165 | (37.7531214307052, -122.480773464165) | |||
| 187623 | 187623 | 226610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 187 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007102.33802 | 2097997.69789 | 37.7411036742096 | -122.418024617936 | (37.7411036742096, -122.418024617936) | |||
| 61927 | 61927 | 184535 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1914 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981673.4595 | 2102023.0319999997 | 37.7506921190217 | -122.506245385817 | (37.7506921190217, -122.506245385817) | |||
| 26934 | 26934 | 227699 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 194 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005300.17225 | 2100223.67209 | 37.7471140970563 | -122.42441415180099 | (37.7471140970563, -122.424414151801) | |||
| 134189 | 134189 | 226586 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 195 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006490.36158 | 2105010.39 | 37.760324461620705 | -122.420638312212 | (37.7603244616207, -122.420638312212) | |||
| 52741 | 52741 | 92437 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1974 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52827 | 5982618.164 | 2101679.0263 | 37.7498031456316 | -122.502953108098 | (37.7498031456316, -122.502953108098) |
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 31229 | 31229 | 226622 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004058.08528 | 2103018.40015 | 37.7547175483925 | -122.42890840132799 | (37.7547175483925, -122.428908401328) | |||
| 161425 | 161425 | 207217 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 201 Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5998700.58194 | 2093477.09847 | 37.7282147273036 | -122.44674954686701 | (37.7282147273036, -122.446749546867) | |||
| 155540 | 155540 | 226607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 205 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997675.15136 | 2106444.92247 | 37.7637625662095 | -122.45122931550699 | (37.7637625662095, -122.451229315507) | |||
| 75227 | 75227 | 185264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2147 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986264.4244 | 2097520.2042 | 37.7385977678327 | -122.490038499473 | (37.7385977678327, -122.490038499473) | |||
| 51665 | 51665 | 185263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2157 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986253.2809 | 2097519.1429 | 37.738594203049004 | -122.4900769498 | (37.738594203049, -122.4900769498) | |||
| 66099 | 66099 | 185262 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2167 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986237.8922 | 2097517.551 | 37.738588933455404 | -122.490130038774 | (37.7385889334554, -122.490130038774) | |||
| 131253 | 131253 | 185261 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2177 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986220.9115 | 2097517.551 | 37.7385879417998 | -122.49018874910401 | (37.7385879417998, -122.490188749104) | |||
| 187515 | 187515 | 207357 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 219 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998605.9960199995 | 2093779.39497 | 37.7290393588582 | -122.44709827877199 | (37.7290393588582, -122.447098278772) | |||
| 165558 | 165558 | 226619 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007856.36673 | 2100270.38915 | 37.747386388365705 | -122.415578321691 | (37.7473863883657, -122.415578321691) | |||
| 154723 | 154723 | 43162 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 221 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 42972 | 6005660.57006 | 2092632.04042 | 37.726289518943 | -122.42262853710301 | (37.726289518943, -122.422628537103) | |
| 150633 | 150633 | 207151 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 223 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994241.91079 | 2105279.16697 | 37.760364530923205 | -122.46301916490299 | (37.7603645309232, -122.463019164903) | |||
| 56436 | 56436 | 207226 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 224 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995369.52282 | 2091446.6873400002 | 37.722448854419795 | -122.45811818710399 | (37.7224488544198, -122.458118187104) | |||
| 58753 | 58753 | 185611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2241 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986448.3245 | 2100932.1027 | 37.747976665787895 | -122.489653506406 | (37.7479766657879, -122.489653506406) | |||
| 76937 | 76937 | 42890 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988984.6022 | 2098295.481 | 37.7408849467502 | -122.48069027409402 | (37.7408849467502, -122.480690274094) | |
| 179554 | 179554 | 42889 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988969.9668 | 2098294.7493 | 37.7408820870559 | -122.48074082372801 | (37.7408820870559, -122.480740823728) | |
| 40972 | 40972 | 185610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2251 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986429.217999999 | 2100931.4203 | 37.7479736765682 | -122.48971952481001 | (37.7479736765682, -122.48971952481) | |||
| 188359 | 188359 | 226618 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007884.76815 | 2100264.95114 | 37.7473730532316 | -122.415479726319 | (37.7473730532316, -122.415479726319) | |||
| 68986 | 68986 | 185609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2261 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986412.841 | 2100929.3732 | 37.747967099583 | -122.489776004492 | (37.747967099583, -122.489776004492) | |||
| 62306 | 62306 | 52667 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226@ MARIPOSA Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2006 12:00:00 AM | 4 | Permit Number 48748 | 6013989.6640800005 | 2106012.3733900003 | 37.7634954891429 | -122.39477170574301 | (37.7634954891429, -122.394771705743) | ||
| 59492 | 59492 | 31354 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2324 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34964 | 5992033.25034 | 2099586.3658 | 37.7446061063992 | -122.47024325973 | (37.7446061063992, -122.47024325973) | |
| 74258 | 74258 | 207354 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.09015 | 2094943.97322 | 37.732134696764 | -122.453363219655 | (37.732134696764, -122.453363219655) | |||
| 103991 | 103991 | 100461 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992450.0 | 2097712.0 | 37.7394836593705 | -122.468665877071 | (37.7394836593705, -122.468665877071) | |||||
| 135470 | 135470 | 207277 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992402.86272 | 2097663.9953099997 | 37.7393491274725 | -122.46882536342 | (37.7393491274725, -122.46882536342) | |||
| 34491 | 34491 | 207157 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992487.55481 | 2097691.20205 | 37.7394287228632 | -122.468534517269 | (37.7394287228632, -122.468534517269) | |||
| 74830 | 74830 | 207158 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992472.8250400005 | 2097675.82148 | 37.739385640835295 | -122.468584327098 | (37.7393856408353, -122.468584327098) | |||
| 158421 | 158421 | 207171 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 240 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999241.01629 | 2095793.3410200002 | 37.7346054437908 | -122.445047696791 | (37.7346054437908, -122.445047696791) | |||
| 131369 | 131369 | 207156 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991402.6198 | 2098893.19012 | 37.7426663442825 | -122.472373311184 | (37.7426663442825, -122.472373311184) | |||
| 154947 | 154947 | 207205 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 243 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997427.42425 | 2094320.33561 | 37.7304572443933 | -122.45121166810499 | (37.7304572443933, -122.451211668105) | |||
| 178747 | 178747 | 47762 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2462 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2002 12:00:00 AM | 4 | Permit Number 45541 | 5988312.7876 | 2098561.9922 | 37.741577647038 | -122.48303266006 | (37.741577647038, -122.48303266006) | |
| 171196 | 171196 | 31366 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2475 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34971 | 5991057.56391 | 2098576.78296 | 37.7417775946723 | -122.473543328283 | (37.7417775946723, -122.473543328283) | |
| 51759 | 51759 | 207273 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2486 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991107.555 | 2098499.64463 | 37.741568687546604 | -122.473364852413 | (37.7415686875466, -122.473364852413) |
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");