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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 67611 | 67611 | 43211 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 353 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 43002 | 6008758.60086 | 2094527.34935 | 37.73166792973 | -122.412052645639 | (37.73166792973, -122.412052645639) | |
| 67812 | 67812 | 207165 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995466.11989 | 2100230.17484 | 37.746571717707205 | -122.458419748693 | (37.7465717177072, -122.458419748693) | |||
| 67877 | 67877 | 207215 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Judson Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997615.0933300005 | 2093521.35715 | 37.7282741823893 | -122.450505294682 | (37.7282741823893, -122.450505294682) | |||
| 67927 | 67927 | 41944 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 567 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42302 | 5993743.34162 | 2111650.50193 | 37.7778298007164 | -122.465206260397 | (37.7778298007164, -122.465206260397) | |
| 67977 | 67977 | 117858 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983830.55841 | 2111665.32715 | 37.777293884605704 | -122.499498581311 | (37.7772938846057, -122.499498581311) | |||
| 68141 | 68141 | 207220 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 143 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5999153.87241 | 2093460.82982 | 37.7281959413875 | -122.445181340549 | (37.7281959413875, -122.445181340549) | ||||
| 68271 | 68271 | 177021 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1538 Burrows St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6006775.37088 | 2092172.2563099999 | 37.72508988269 | -122.41874212587 | (37.72508988269, -122.41874212587) | |||
| 68354 | 68354 | 207353 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 678 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5997598.43347 | 2095021.49363 | 37.7323922472992 | -122.45067100017201 | (37.7323922472992, -122.450671000172) | |||
| 68812 | 68812 | 207209 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 342 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5998785.841580001 | 2094004.8345400002 | 37.7296686369961 | -122.446492753553 | (37.7296686369961, -122.446492753553) | |||
| 68943 | 68943 | 207150 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 830 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5991404.13851 | 2102515.6148 | 37.752612672541105 | -122.47263211090099 | (37.7526126725411, -122.472632110901) | |||
| 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) | |||
| 69001 | 69001 | 176998 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 87 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6000227.51825 | 2089886.7347900001 | 37.7184435186304 | -122.441213386902 | (37.7184435186304, -122.441213386902) | |||
| 69070 | 69070 | 207341 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998515.2216 | 2095011.0330299998 | 37.7324159597185 | -122.447500710116 | (37.7324159597185, -122.447500710116) | ||||
| 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) | |||
| 69462 | 69462 | 119126 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 601 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981603.35382 | 2111608.79109 | 37.777007725640104 | -122.507198870746 | (37.7770077256401, -122.507198870746) | |||
| 69603 | 69603 | 207236 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996258.071 | 2089000.15441 | 37.7157822655196 | -122.45487001484301 | (37.7157822655196, -122.454870014843) | |||
| 70030 | 70030 | 177026 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Sweeny St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6008206.81715 | 2094351.9900900002 | 37.7311554564421 | -122.41394787781601 | (37.7311554564421, -122.413947877816) | |||
| 70085 | 70085 | 207207 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998074.45641 | 2093829.28565 | 37.7291459626917 | -122.44893943651199 | (37.7291459626917, -122.448939436512) | |||
| 70124 | 70124 | 207280 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993435.14458 | 2094919.26873 | 37.731872375313294 | -122.46505692344299 | (37.7318723753133, -122.465056923443) | |||
| 70286 | 70286 | 42982 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 469 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | 7 | Permit Number 42866 | 6008125.46012 | 2091747.89633 | 37.724000603132 | -122.414044988394 | (37.724000603132, -122.414044988394) | |
| 70323 | 70323 | 207350 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997300.95019 | 2095282.96772 | 37.7330931600175 | -122.451718319154 | (37.7330931600175, -122.451718319154) | |||
| 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) | |||
| 70722 | 70722 | 207218 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5999123.66307 | 2093458.3174700001 | 37.7281873186821 | -122.445285594449 | (37.7281873186821, -122.445285594449) | ||||
| 70729 | 70729 | 177010 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002632.11132 | 2094355.1655700002 | 37.73084950708879 | -122.433220824095 | (37.7308495070888, -122.433220824095) | |||
| 71088 | 71088 | 207340 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998514.78137 | 2095005.5292 | 37.732400822345205 | -122.44750183606001 | (37.7324008223452, -122.44750183606) | ||||
| 71287 | 71287 | 207201 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 351 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998416.44412 | 2094074.8160299999 | 37.7298396835571 | -122.447774830644 | (37.7298396835571, -122.447774830644) | |||
| 71533 | 71533 | 117965 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984581.6879 | 2111733.75019 | 37.7775257966351 | -122.496905272636 | (37.7775257966351, -122.496905272636) | |||
| 72391 | 72391 | 176996 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998705.41323 | 2087176.369 | 37.7109146507487 | -122.44627978598999 | (37.7109146507487, -122.44627978599) | |||
| 72894 | 72894 | 207221 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 125 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999184.61823 | 2093461.48115 | 37.7281994846941 | -122.44507509826401 | (37.7281994846941, -122.445075098264) | ||||
| 73076 | 73076 | 207146 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1440 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991174.2447 | 2105585.9909099997 | 37.7610298052998 | -122.47365107156601 | (37.7610298052998, -122.473651071566) | |||
| 73346 | 73346 | 226593 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001851.9880099995 | 2100572.11343 | 37.7478755125637 | -122.43636260477301 | (37.7478755125637, -122.436362604773) | |||
| 73614 | 73614 | 40348 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/17/1999 12:00:00 AM | 6 | Permit Number 41478 | 5984070.03891 | 2112340.8801599997 | 37.779162805435 | -122.498720071631 | (37.779162805435, -122.498720071631) | |
| 73643 | 73643 | 207345 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 628 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998591.38299 | 2094890.7633 | 37.732090079596794 | -122.44722875061399 | (37.7320900795968, -122.447228750614) | |||
| 73666 | 73666 | 184518 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4108 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982209.6889 | 2101522.5062 | 37.7493493689338 | -122.504354014902 | (37.7493493689338, -122.504354014902) | |||
| 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) | |||
| 73920 | 73920 | 207210 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 146 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999095.98576 | 2093806.86087 | 37.7291427575169 | -122.445406326639 | (37.7291427575169, -122.445406326639) | ||||
| 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) | |||
| 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) | |||
| 74277 | 74277 | 67405 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 774 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 9 | Permit Number 30904 | 5989782.793 | 2110097.20217 | 37.7733356814764 | -122.478793391379 | (37.7733356814764, -122.478793391379) | |
| 74649 | 74649 | 207296 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996041.08515 | 2094289.8634799998 | 37.7302941010767 | -122.456002210028 | (37.7302941010767, -122.456002210028) | |||
| 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) | |||
| 75032 | 75032 | 207204 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 655 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5997746.28105 | 2094978.11771 | 37.7322816091084 | -122.450156733641 | (37.7322816091084, -122.450156733641) | |||
| 75063 | 75063 | 123520 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5994672.01997 | 2110241.5879900004 | 37.774014807441795 | -122.461891472498 | (37.7740148074418, -122.461891472498) | |||
| 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) | |||
| 75474 | 75474 | 207342 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998499.20735 | 2095008.2855900002 | 37.7324075007117 | -122.447555877206 | (37.7324075007117, -122.447555877206) | ||||
| 75859 | 75859 | 207224 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 49 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998734.87043 | 2093158.9272 | 37.727343062112396 | -122.446608128468 | (37.7273430621124, -122.446608128468) | |||
| 75893 | 75893 | 70393 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 6 | 6005472.78201 | 2093254.0606099998 | 37.7279868534853 | -122.42332190988998 | (37.7279868534853, -122.42332190989) | ||
| 75923 | 75923 | 226602 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5200x Diamond Heights Blvd | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6001604.7772 | 2098884.15576 | 37.7432267298424 | -122.437096613431 | (37.7432267298424, -122.437096613431) | ||||
| 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) | |||
| 76063 | 76063 | 43217 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 45 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 4 | Permit Number 43007 | 6007564.041619999 | 2093733.91416 | 37.7294222326375 | -122.416126315492 | (37.7294222326375, -122.416126315492) | |
| 76065 | 76065 | 207186 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 50 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000874.80167 | 2094365.21675 | 37.730777259156 | -122.43929683358299 | (37.730777259156, -122.439296833583) | |||
| 76247 | 76247 | 207177 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995331.55155 | 2098239.9871900002 | 37.7410994231129 | -122.458741010797 | (37.7410994231129, -122.458741010797) | |||
| 76282 | 76282 | 226604 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Collingwood St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6002163.6712 | 2103050.21539 | 37.7546974962127 | -122.435462066843 | (37.7546974962127, -122.435462066843) | |||
| 76289 | 76289 | 250091 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1620 Gough St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005381.25743 | 2115289.65998 | 37.7884862737667 | -122.425205641527 | (37.7884862737667, -122.425205641527) | |||
| 76312 | 76312 | 207237 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 5996320.92755 | 2088998.85833 | 37.715782312278 | -122.454652661299 | (37.715782312278, -122.454652661299) | |||
| 76321 | 76321 | 207202 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 436 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997481.98173 | 2094926.0647599997 | 37.7321235559578 | -122.45106671987301 | (37.7321235559578, -122.451066719873) | ||||
| 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) | |
| 77335 | 77335 | 207193 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 312 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999342.629819999 | 2094390.1530400002 | 37.7307584183688 | -122.444595567153 | (37.7307584183688, -122.444595567153) | |||
| 79917 | 79917 | 1384 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2550X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X2 | 6002245.07965 | 2096962.3294799998 | 37.737986217166096 | -122.43474521929 | (37.7379862171661, -122.43474521929) | |||
| 80194 | 80194 | 4999 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 88236 | 88236 | 4991 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 89568 | 89568 | 87364 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 91369 | 91369 | 177012 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002642.0398 | 2094328.25695 | 37.730776185352504 | -122.433184577831 | (37.7307761853525, -122.433184577831) | |||
| 94015 | 94015 | 4992 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 94485 | 94485 | 87363 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 95563 | 95563 | 4998 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 97805 | 97805 | 4994 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 99734 | 99734 | 4993 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 100854 | 100854 | 19333 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 325 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993178.445205901 | 2089816.9668961002 | 37.7178478960527 | -122.46557383978 | (37.7178478960527, -122.46557383978) | |||
| 102241 | 102241 | 121608 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 102463 | 102463 | 87366 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 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) | |||||
| 108882 | 108882 | 90815 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985771.299330001 | 2110409.9607700002 | 37.7739606832472 | -122.49269254584101 | (37.7739606832472, -122.492692545841) | ||
| 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) | |||
| 110729 | 110729 | 4995 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 5300 Diamond Heights Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 112212 | 112212 | 207333 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 378 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998914.45517 | 2095254.7812700002 | 37.7331080419878 | -122.446137997991 | (37.7331080419878, -122.446137997991) | |||
| 116109 | 116109 | 115788 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | Permit Number 777599 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | |
| 116496 | 116496 | 177009 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 425 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6002141.25462 | 2093891.34658 | 37.729548108055 | -122.434884635528 | (37.729548108055, -122.434884635528) | |||
| 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) |
| 117656 | 117656 | 117966 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984567.33243 | 2111733.70358 | 37.7775248274666 | -122.496954928801 | (37.7775248274666, -122.496954928801) | |||
| 117773 | 117773 | 121606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 123823 | 123823 | 207323 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998893.471580001 | 2095962.39727 | 37.7350497898071 | -122.446261428139 | (37.7350497898071, -122.446261428139) | |||
| 123975 | 123975 | 57938 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 7 Byron Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2010 12:00:00 AM | 4 | Permit Number 53686 | 5999410.13624 | 2086691.6630000002 | 37.7096239797406 | -122.443809305177 | (37.7096239797406, -122.443809305177) | ||
| 125304 | 125304 | 177013 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002644.59595 | 2094315.3545 | 37.7307409031583 | -122.433174819278 | (37.7307409031583, -122.433174819278) | |||
| 129591 | 129591 | 185132 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2675 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985816.5603 | 2097133.8948 | 37.7375109017116 | -122.491558549707 | (37.7375109017116, -122.491558549707) | |||
| 129805 | 129805 | 226626 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Liberty St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6004198.11867 | 2103939.92108 | 37.757255752658295 | -122.42848980825899 | (37.7572557526583, -122.428489808259) | |||
| 129828 | 129828 | 226614 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 322 Elsie St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006361.987980001 | 2097015.1421299998 | 37.738364099132795 | -122.42051475707399 | (37.7383640991328, -122.420514757074) | |||
| 130406 | 130406 | 207187 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 50 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000857.41139 | 2094366.50638 | 37.730779810542295 | -122.439357046798 | (37.7307798105423, -122.439357046798) | |||
| 130433 | 130433 | 207283 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 84 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993642.59329 | 2093470.80397 | 37.7279072068291 | -122.464234616632 | (37.7279072068291, -122.464234616632) | |||
| 130565 | 130565 | 207178 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995329.77436 | 2098242.36362 | 37.7411058460538 | -122.45874732764 | (37.7411058460538, -122.45874732764) | |||
| 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) | |||
| 130898 | 130898 | 207284 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 84 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993637.22552 | 2093458.84875 | 37.727874071330106 | -122.464252305417 | (37.7278740713301, -122.464252305417) | |||
| 130905 | 130905 | 108372 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 575 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6001633.30512 | 2090300.73335 | 37.7196602437916 | -122.436383787393 | (37.7196602437916, -122.436383787393) | ||
| 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) | |||
| 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) | |||
| 131611 | 131611 | 207292 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 965 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994659.45419 | 2093917.36528 | 37.729191913559205 | -122.460751677241 | (37.7291919135592, -122.460751677241) | |||
| 131761 | 131761 | 207244 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 246 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991705.04474 | 2090167.4544799998 | 37.7187251566245 | -122.47069219949199 | (37.7187251566245, -122.470692199492) | |||
| 131833 | 131833 | 207161 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 509 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995344.03835 | 2092755.21065 | 37.726040281721296 | -122.45830094463498 | (37.7260402817213, -122.458300944635) | |||
| 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) |
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");