Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39414 | 39414 | 119522 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 790 31st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5986359.69309 | 2110558.27509 | 37.7744022999761 | -122.490668135755 | (37.7744022999761, -122.490668135755) | |||
| 168895 | 168895 | 214143 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1374 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5991484.96158 | 2106064.6726900004 | 37.7623621284382 | -122.472611348256 | (37.7623621284382, -122.472611348256) | |||
| 103582 | 103582 | 36119 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1374 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2016 12:00:00 AM | 3 | 5x3 | Permit Number 43440 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.47260356904499 | (37.7623789807661, -122.472603569045) |
| 165868 | 165868 | 124080 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 701 Funston Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991937.65647 | 2110107.3837099997 | 37.7734885240998 | -122.47134023204399 | (37.7734885240998, -122.471340232044) | |||
| 154763 | 154763 | 214144 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1349 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991798.36054 | 2098388.78808 | 37.7413042814624 | -122.470968230225 | (37.7413042814624, -122.470968230225) | |||
| 161534 | 161534 | 214145 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 763 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994412.31981 | 2089911.6856900002 | 37.7181790612911 | -122.46131577523 | (37.7181790612911, -122.46131577523) | |||
| 151562 | 151562 | 214146 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 201 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996074.923830001 | 2094212.2108599998 | 37.730082827848896 | -122.455879614453 | (37.7300828278489, -122.455879614453) | |||
| 31301 | 31301 | 136352 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Euclid Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5997962.800430001 | 2113889.01187 | 37.7842185814711 | -122.450771195452 | (37.7842185814711, -122.450771195452) | |||
| 134284 | 134284 | 240933 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 43 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000253.26444 | 2104774.2655 | 37.7593226312454 | -122.44219250487801 | (37.7593226312454, -122.442192504878) | |||
| 186965 | 186965 | 240930 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4621 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000546.64601 | 2104633.37076 | 37.758952484691704 | -122.44116774269699 | (37.7589524846917, -122.441167742697) | |||
| 129608 | 129608 | 36878 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000806.763119999 | 2116642.34595 | 37.791940909692705 | -122.441129724752 | (37.7919409096927, -122.441129724752) | |
| 37373 | 37373 | 36876 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000808.4477 | 2116625.0074 | 37.791893398513395 | -122.44112265160601 | (37.7918933985134, -122.441122651606) | |
| 163979 | 163979 | 36875 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000811.564809999 | 2116611.03172 | 37.791855202492705 | -122.44111086330099 | (37.7918552024927, -122.441110863301) | |
| 53894 | 53894 | 36877 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 7 | Permit Number 39539 | 6000814.63294 | 2116594.68212 | 37.7918104855159 | -122.441099074089 | (37.7918104855159, -122.441099074089) | |
| 133058 | 133058 | 36879 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000815.69964 | 2116580.40998 | 37.7917713587016 | -122.441094358926 | (37.7917713587016, -122.441094358926) | |
| 65397 | 65397 | 240931 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4596 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000667.48938 | 2104674.07897 | 37.7590711421385 | -122.440752730779 | (37.7590711421385, -122.440752730779) | |||
| 136578 | 136578 | 240932 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4586 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000693.49124 | 2104675.50422 | 37.7590765362773 | -122.44066290647 | (37.7590765362773, -122.44066290647) | |||
| 166807 | 166807 | 240921 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6001181.68085 | 2096585.4639299999 | 37.7368910024193 | -122.438394913397 | (37.7368910024193, -122.438394913397) | |||
| 129742 | 129742 | 240935 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2500 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001976.89611 | 2105831.81092 | 37.7623244756286 | -122.43630704373001 | (37.7623244756286, -122.43630704373) | |||
| 179937 | 179937 | 240936 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2500 Market St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6001978.22314 | 2105823.15955 | 37.76230079647421 | -122.436301834857 | (37.7623007964742, -122.436301834857) | |||
| 129678 | 129678 | 240937 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2500 Market St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 6001979.1428 | 2105813.01717 | 37.762273000223104 | -122.43629792821501 | (37.7622730002231, -122.436297928215) | |||
| 148758 | 148758 | 240922 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 25 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6001848.30609 | 2096993.36955 | 37.738048911920295 | -122.436119279702 | (37.7380489119203, -122.436119279702) | |||
| 53759 | 53759 | 136355 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1639 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6002367.638040001 | 2121224.4246 | 37.8046108851334 | -122.436057126653 | (37.8046108851334, -122.436057126653) | |||
| 120451 | 120451 | 240947 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 80 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002399.94637 | 2096660.6120799999 | 37.7371665618784 | -122.43418820594101 | (37.7371665618784, -122.434188205941) | |||
| 164629 | 164629 | 240934 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4069 19th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6002570.92304 | 2104708.1255900003 | 37.75927284118389 | -122.434172195294 | (37.7592728411839, -122.434172195294) | |||
| 59323 | 59323 | 240918 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4158 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002863.78754 | 2100671.92533 | 37.748207011640794 | -122.43287098151 | (37.7482070116408, -122.43287098151) | |||
| 54852 | 54852 | 240919 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 556 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002989.394780001 | 2095969.72486 | 37.7353029813381 | -122.432100892951 | (37.7353029813381, -122.432100892951) | |||
| 142266 | 142266 | 98139 | Property Tree 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 556 Laidley St | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003085.0 | 2096041.0 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | |||||
| 27001 | 27001 | 240920 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 83 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003674.035680001 | 2096782.4089099998 | 37.7375732191201 | -122.42979178467199 | (37.7375732191201, -122.429791784672) | |||
| 67549 | 67549 | 240945 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 192 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004100.4699 | 2097291.61636 | 37.738995525713 | -122.428353681499 | (37.738995525713, -122.428353681499) | |||
| 76461 | 76461 | 240943 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004289.81829 | 2105251.99931 | 37.7608635971022 | -122.428266184633 | (37.7608635971022, -122.428266184633) | |||
| 25675 | 25675 | 240946 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004126.6518 | 2097259.6464 | 37.7389092249709 | -122.42826087863199 | (37.7389092249709, -122.428260878632) | |||
| 187538 | 187538 | 240942 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004290.97855 | 2105224.4421599996 | 37.760787997378394 | -122.428260207767 | (37.7607879973784, -122.428260207767) | |||
| 44992 | 44992 | 240941 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 53 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004292.854119999 | 2105210.6370599996 | 37.760750197983896 | -122.4282527371 | (37.7607501979839, -122.4282527371) | |||
| 151209 | 151209 | 240939 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 51 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 6004310.3515 | 2105242.1115200003 | 37.7608376093901 | -122.428194464629 | (37.7608376093901, -122.428194464629) | |||
| 67915 | 67915 | 240938 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 6004312.93129 | 2105220.54809 | 37.760778547308895 | -122.428184005481 | (37.7607785473089, -122.428184005481) | |||
| 63969 | 63969 | 240940 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 52 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 6004314.46376 | 2105211.05218 | 37.7607525605073 | -122.428178028592 | (37.7607525605073, -122.428178028592) | |||
| 182226 | 182226 | 103279 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 221 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2013 12:00:00 AM | 3 | 5x6 | Permit Number 770111 | 6004127.45538 | 2092231.09561 | 37.725101999253894 | -122.42789988087699 | (37.7251019992539, -122.427899880877) | |
| 18807 | 18807 | 4403 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1044 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004378.89078 | 2102815.5899099996 | 37.754178832009295 | -122.42778451855101 | (37.7541788320093, -122.427784518551) | |||
| 71315 | 71315 | 240944 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 88 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004279.64168 | 2097645.58275 | 37.7399775737156 | -122.427759401399 | (37.7399775737156, -122.427759401399) | |||
| 119120 | 119120 | 240916 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 64 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6004904.76782 | 2096171.47798 | 37.735965357221296 | -122.425493090943 | (37.7359653572213, -122.425493090943) | |||
| 149695 | 149695 | 240510 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 180 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6005414.721480001 | 2107962.30986 | 37.7683690520207 | -122.424568435908 | (37.7683690520207, -122.424568435908) | |||
| 64844 | 64844 | 38496 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1520 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | 7 | Permit Number 40490 | 6005695.28325 | 2118608.46159 | 37.797616603979996 | -122.424355304657 | (37.79761660398, -122.424355304657) | |
| 36656 | 36656 | 136354 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1508 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005758.24578 | 2118617.72057 | 37.79764558194071 | -122.42413809590401 | (37.7976455819407, -122.424138095904) | |||
| 27075 | 27075 | 136353 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1508 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005781.66694 | 2118620.21558 | 37.7976537549681 | -122.424057229776 | (37.7976537549681, -122.424057229776) | |||
| 66952 | 66952 | 240514 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 457 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005714.7802800005 | 2107820.47236 | 37.7679965411359 | -122.423520473904 | (37.7679965411359, -122.423520473904) | |||
| 184571 | 184571 | 240515 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 457 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005735.72646 | 2107821.05877 | 37.767999333531996 | -122.42344806497499 | (37.767999333532, -122.423448064975) | |||
| 75542 | 75542 | 38389 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2435 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 6 | 6x5 | Permit Number 40447 | 6006233.73845 | 2119201.43676 | 37.7992751543766 | -122.422534259363 | (37.7992751543766, -122.422534259363) | |
| 67808 | 67808 | 38390 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2435 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 5 | 3x5 | Permit Number 40447 | 6006235.29717 | 2119188.7184099997 | 37.799240320944904 | -122.42252796141399 | (37.7992403209449, -122.422527961414) | |
| 45338 | 45338 | 240929 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 147 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005793.48345 | 2096408.78374 | 37.7366671197906 | -122.42243729804399 | (37.7366671197906, -122.422437298044) | |||
| 152295 | 152295 | 240917 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 83 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005893.634 | 2099040.4578400003 | 37.74389875452329 | -122.42227795437901 | (37.7438987545233, -122.422277954379) | |||
| 48807 | 48807 | 240912 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006337.237319999 | 2105831.0184 | 37.7625690840066 | -122.421226172049 | (37.7625690840066, -122.421226172049) | |||
| 164610 | 164610 | 240913 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006349.99918 | 2105832.52537 | 37.7625739412505 | -122.421182140339 | (37.7625739412505, -122.421182140339) | |||
| 188943 | 188943 | 240914 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006391.17124 | 2105833.44907 | 37.762578798502204 | -122.421039806442 | (37.7625787985022, -122.421039806442) | |||
| 42363 | 42363 | 240915 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 315 Lexington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006533.583380001 | 2104305.2413 | 37.7583907231708 | -122.420438775123 | (37.7583907231708, -122.420438775123) | |||
| 149314 | 149314 | 248251 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 104 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006828.21507 | 2098946.74431 | 37.7436941111088 | -122.419039736691 | (37.7436941111088, -122.419039736691) | |||
| 64024 | 64024 | 240907 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 355 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007123.31174 | 2096296.95431 | 37.736434989479896 | -122.417831571267 | (37.7364349894799, -122.417831571267) | |||
| 133157 | 133157 | 240928 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 3380 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007637.32467 | 2104441.25017 | 37.75882630980679 | -122.416631173298 | (37.7588263098068, -122.416631173298) | |||
| 165148 | 165148 | 136357 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 456 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007973.2563 | 2114063.6307200002 | 37.785265984095105 | -122.416150839088 | (37.7852659840951, -122.416150839088) | |||
| 105945 | 105945 | 34777 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1148 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2002 12:00:00 AM | 12 | 4xt | Permit Number 45651 | 6008035.00461404 | 2101235.83901924 | 37.750047336859105 | -122.41502892690501 | (37.7500473368591, -122.415028926905) |
| 68738 | 68738 | 240927 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1148 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008036.38125 | 2101261.79072 | 37.750118671749796 | -122.415026003064 | (37.7501186717498, -122.415026003064) | |||
| 121086 | 121086 | 136356 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 400 Leavenworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008467.36905 | 2113992.78863 | 37.7850992389805 | -122.414436340073 | (37.7850992389805, -122.414436340073) | |||
| 103276 | 103276 | 94983 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2010 12:00:00 AM | 3x3 | Permit Number 54004 | 6008557.0 | 2113884.0 | 37.784805566420005 | -122.414118544888 | (37.78480556642, -122.414118544888) | ||
| 129730 | 129730 | 34468 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 6 | Permit Number 41458 | 6008697.37022 | 2118963.2326 | 37.7987597807915 | -122.413992350181 | (37.7987597807915, -122.413992350181) | |
| 159120 | 159120 | 34472 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 6 | Permit Number 38203 | 6008700.38514 | 2118953.79893 | 37.7987340476021 | -122.41398124983601 | (37.7987340476021, -122.413981249836) | ||
| 152896 | 152896 | 34475 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 5 | Permit Number 38203 | 6008703.71619 | 2118937.2294 | 37.7986887388648 | -122.41396855051201 | (37.7986887388648, -122.413968550512) | ||
| 152778 | 152778 | 136358 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008706.64463 | 2118922.43677 | 37.7986482864407 | -122.41395737013399 | (37.7986482864407, -122.413957370134) | |||
| 43994 | 43994 | 136359 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008708.52224 | 2118897.8442599997 | 37.7985808669576 | -122.413949132363 | (37.7985808669576, -122.413949132363) | |||
| 29594 | 29594 | 136360 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008711.32926 | 2118885.42513 | 37.7985469247543 | -122.41393854015499 | (37.7985469247543, -122.413938540155) | |||
| 131561 | 131561 | 136361 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1715 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008713.647609999 | 2118857.43693 | 37.7984702062984 | -122.413928536971 | (37.7984702062984, -122.413928536971) | |||
| 27443 | 27443 | 136362 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1715 Taylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6008714.5466 | 2118843.19382 | 37.7984311487376 | -122.413924418086 | (37.7984311487376, -122.413924418086) | |||
| 62026 | 62026 | 240905 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008695.452190001 | 2101477.07086 | 37.750746796947396 | -122.412762107295 | (37.7507467969474, -122.412762107295) | |||
| 64881 | 64881 | 240906 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008696.38021 | 2101499.73493 | 37.7508090794957 | -122.412760500211 | (37.7508090794957, -122.412760500211) | |||
| 188132 | 188132 | 240904 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008695.81166 | 2101451.46415 | 37.7506765068321 | -122.4127590541 | (37.7506765068321, -122.4127590541) | |||
| 167771 | 167771 | 240903 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008699.59316 | 2101430.0617400003 | 37.750617952853204 | -122.412744464408 | (37.7506179528532, -122.412744464408) | |||
| 179906 | 179906 | 240902 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008701.46806 | 2101407.50971 | 37.7505561352606 | -122.41273638667101 | (37.7505561352606, -122.412736386671) | |||
| 62745 | 62745 | 240901 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008702.87271 | 2101385.26076 | 37.7504951234628 | -122.41272995653601 | (37.7504951234628, -122.412729956536) | |||
| 132094 | 132094 | 240900 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008703.81283 | 2101363.0213 | 37.7504341116489 | -122.412725133468 | (37.7504341116489, -122.412725133468) | |||
| 68933 | 68933 | 240899 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008706.04279 | 2101335.66338 | 37.750359118082706 | -122.412715488225 | (37.7503591180827, -122.412715488225) | |||
| 186197 | 186197 | 240898 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008707.03966 | 2101316.20021 | 37.7503057325231 | -122.412710665178 | (37.7503057325231, -122.412710665178) | |||
| 153478 | 153478 | 240897 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008707.95115 | 2101292.57262 | 37.750240907605 | -122.41270584302 | (37.750240907605, -122.41270584302) | |||
| 32059 | 32059 | 240896 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008710.779680001 | 2101249.00025 | 37.7501214263764 | -122.41269298178999 | (37.7501214263764, -122.41269298179) | |||
| 132473 | 132473 | 240894 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008712.70804 | 2101184.1513099996 | 37.749943473916204 | -122.41268172950501 | (37.7499434739162, -122.412681729505) | |||
| 25742 | 25742 | 240895 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008713.19989 | 2101208.21335 | 37.7500095705047 | -122.41268172948999 | (37.7500095705047, -122.41268172949) | |||
| 178947 | 178947 | 240893 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008715.08963 | 2101164.19704 | 37.749888817618796 | -122.412672083351 | (37.7498888176188, -122.412672083351) | |||
| 169825 | 169825 | 240892 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008719.07534 | 2101109.02745 | 37.749737557951 | -122.412654400905 | (37.749737557951, -122.412654400905) | |||
| 54799 | 54799 | 240891 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008718.64971 | 2101088.20431 | 37.7496803583719 | -122.41265440088999 | (37.7496803583719, -122.41265440089) | |||
| 48402 | 48402 | 240890 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008720.4908300005 | 2101064.55739 | 37.749615532544 | -122.412646362752 | (37.749615532544, -122.412646362752) | |||
| 50197 | 50197 | 240889 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008721.46882 | 2101044.16868 | 37.7495596045891 | -122.41264153966999 | (37.7495596045891, -122.41264153967) | |||
| 52247 | 52247 | 240888 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008723.38535 | 2101024.2236 | 37.7495049474174 | -122.41263350244199 | (37.7495049474174, -122.412633502442) | |||
| 55890 | 55890 | 46507 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 675 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 7 | Permit Number 44677 | 6009082.35488 | 2111157.53331 | 37.7773488321059 | -122.41210822822599 | (37.7773488321059, -122.412108228226) | ||
| 33768 | 33768 | 46508 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 675 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 5 | Permit Number 44677 | 6009091.30835 | 2111167.9463 | 37.777377926079 | -122.412077991228 | (37.777377926079, -122.412077991228) | ||
| 44420 | 44420 | 197457 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009096.316000001 | 2110957.37076 | 37.77680001633121 | -122.412045782913 | (37.7768000163312, -122.412045782913) | |||
| 177407 | 177407 | 197456 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009124.387019999 | 2110985.0611099997 | 37.7768776224341 | -122.411950633731 | (37.7768776224341, -122.411950633731) | |||
| 59554 | 59554 | 197455 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009137.470430001 | 2110995.28328 | 37.7769064241241 | -122.41190609659999 | (37.7769064241241, -122.4119060966) | |||
| 169428 | 169428 | 197454 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009151.50306 | 2111008.9827799997 | 37.7769448269774 | -122.41185852156 | (37.7769448269774, -122.41185852156) | |||
| 72748 | 72748 | 197453 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009170.60283 | 2111027.24083 | 37.776996030778896 | -122.411793739793 | (37.7769960307789, -122.411793739793) | |||
| 177658 | 177658 | 240923 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 828 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009093.2856 | 2104203.13194 | 37.758254269047 | -122.411578943013 | (37.758254269047, -122.411578943013) | |||
| 61868 | 61868 | 197451 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009234.5273400005 | 2111091.20385 | 37.77717524406629 | -122.41157712459 | (37.7771752440663, -122.41157712459) | |||
| 176203 | 176203 | 197450 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6009244.39331 | 2111101.4918 | 37.777204045757706 | -122.41154372197701 | (37.7772040457577, -122.411543721977) |
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");