Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 1773 | 1773 | 251685 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 66 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996558.0 | 2090330.0 | 37.719450911009005 | -122.453929311088 | (37.719450911009, -122.453929311088) | ||||
| 1779 | 1779 | 251684 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 62 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996557.0 | 2090306.0 | 37.719384955305294 | -122.453931035382 | (37.7193849553053, -122.453931035382) | ||||
| 2094 | 2094 | 252881 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3536 Jennings St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 6013049.3063900005 | 2089480.54762 | 37.718050242412296 | -122.39686501810199 | (37.7180502424123, -122.396865018102) | ||||
| 5541 | 5541 | 81381 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.41688358241899 | (37.7863320683098, -122.416883582419) | ||
| 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) | ||
| 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) | ||
| 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) | |||||
| 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) | ||||
| 138958 | 138958 | 87365 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 6 | 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) | ||
| 140890 | 140890 | 121607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 31001 | 31001 | 176999 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 906 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6001595.86635 | 2088796.01268 | 37.7155264893371 | -122.436405562669 | (37.7155264893371, -122.436405562669) | |||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 34276 | 34276 | 182870 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1847 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988127.2852 | 2102724.1956 | 37.752995155363 | -122.483979194232 | (37.752995155363, -122.483979194232) | |||
| 36484 | 36484 | 207243 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 324 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5996808.75565 | 2089668.4523599998 | 37.7176488300194 | -122.453014817795 | (37.7176488300194, -122.453014817795) | |||
| 39694 | 39694 | 191411 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 462 Thornton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6012808.38143 | 2094403.0124599999 | 37.7315529172119 | -122.39804293216001 | (37.7315529172119, -122.39804293216) | |||
| 42221 | 42221 | 207173 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995323.713819999 | 2098239.63146 | 37.7410979958728 | -122.45876808490601 | (37.7410979958728, -122.458768084906) | |||
| 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) | |||
| 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) |
| 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) | |||
| 59000 | 59000 | 227698 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 517 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004312.97566 | 2110291.73585 | 37.7747028072132 | -122.428545336007 | (37.7747028072132, -122.428545336007) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 137436 | 137436 | 177005 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 362 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009172.07817 | 2088408.58756 | 37.714890285531794 | -122.410191328669 | (37.7148902855318, -122.410191328669) | |||
| 138075 | 138075 | 227702 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004467.63219 | 2096063.7098700001 | 37.7356447417011 | -122.426996770882 | (37.7356447417011, -122.426996770882) | ||||
| 150333 | 150333 | 207234 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 422 Orizaba Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5994046.18721 | 2089200.86778 | 37.716206246401896 | -122.462529797908 | (37.7162062464019, -122.462529797908) | |||
| 159577 | 159577 | 226592 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001848.149780001 | 2100568.16422 | 37.7478644508775 | -122.43637559457198 | (37.7478644508775, -122.436375594572) | |||
| 163723 | 163723 | 207169 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 526 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996886.48859 | 2093636.72948 | 37.728549238251205 | -122.453032422917 | (37.7285492382512, -122.453032422917) | |||
| 163757 | 163757 | 183296 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1278 42nd Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5983073.0612 | 2106475.4841 | 37.7629995961897 | -122.50173490129801 | (37.7629995961897, -122.501734901298) | |||
| 164704 | 164704 | 207182 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995335.09015 | 2098246.93081 | 37.7411186919637 | -122.458729278246 | (37.7411186919637, -122.458729278246) | |||
| 166542 | 166542 | 227701 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004423.64254 | 2096032.0928 | 37.7355554408308 | -122.427146608748 | (37.7355554408308, -122.427146608748) | ||||
| 168553 | 168553 | 191409 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6014316.155809999 | 2104772.8809 | 37.760110260198495 | -122.39355571261999 | (37.7601102601985, -122.39355571262) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 186756 | 186756 | 182869 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1847 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988126.7611 | 2102732.0567 | 37.753016709320995 | -122.48398158304701 | (37.753016709321, -122.483981583047) | |||
| 41674 | 41674 | 185771 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1325 Ortega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989890.4756 | 2102411.1303 | 37.7522380517247 | -122.47785892610399 | (37.7522380517247, -122.477858926104) | |||
| 52088 | 52088 | 177024 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 11 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.42366493918301 | (37.7277939084451, -122.423664939183) | ||||
| 54071 | 54071 | 207232 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 5994766.53745 | 2089660.64097 | 37.7175101320775 | -122.46007322780301 | (37.7175101320775, -122.460073227803) | |||
| 57155 | 57155 | 207179 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5995334.19857 | 2098241.75122 | 37.741104418845794 | -122.458731986098 | (37.7411044188458, -122.458731986098) | |||
| 67090 | 67090 | 177002 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 721 Goettingen St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6010761.087830001 | 2091324.0286400001 | 37.7229844303778 | -122.404904160394 | (37.7229844303778, -122.404904160394) | |||
| 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) | |||
| 137025 | 137025 | 185770 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1325 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5989884.1917 | 2102410.6066 | 37.752236249076205 | -122.477880618296 | (37.7522362490762, -122.477880618296) | |||
| 138093 | 138093 | 207251 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 567 Arch St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5992723.294480001 | 2090942.0276900001 | 37.720910777190795 | -122.46722883836 | (37.7209107771908, -122.46722883836) | |||
| 148774 | 148774 | 68284 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 665 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2012 12:00:00 AM | 2 | Permit Number 769020 | 6009000.66847 | 2092983.8736400001 | 37.727443453448 | -122.411106781849 | (37.727443453448, -122.411106781849) | |
| 153744 | 153744 | 207155 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 606 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990983.67458 | 2099779.50243 | 37.7450756729987 | -122.473886535662 | (37.7450756729987, -122.473886535662) | |||
| 172332 | 172332 | 226576 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003654.19113 | 2098670.4327700003 | 37.7427561757625 | -122.42999503773501 | (37.7427561757625, -122.429995037735) | |||
| 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) | ||
| 20367 | 20367 | 29572 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 400X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991380.33669 | 2094272.13717 | 37.7299768148765 | -122.47211360317 | (37.7299768148765, -122.47211360317) | ||
| 20702 | 20702 | 16302 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 747 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1992 12:00:00 AM | 3 | 3X3 | 5997139.1851 | 2094676.1292299998 | 37.73141766098679 | -122.452233809638 | (37.7314176609868, -122.452233809638) | ||
| 21729 | 21729 | 29577 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 400X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991369.68485 | 2094223.17677 | 37.7298417654626 | -122.47214686011002 | (37.7298417654626, -122.47214686011) | ||
| 23484 | 23484 | 226621 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2498 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008827.83459 | 2103955.23814 | 37.7575587153899 | -122.412479469249 | (37.7575587153899, -122.412479469249) | |||
| 24701 | 24701 | 226623 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004079.6139400005 | 2102598.16626 | 37.7535649035083 | -122.428803992713 | (37.7535649035083, -122.428803992713) | |||
| 24966 | 24966 | 177004 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 746 Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009463.77429 | 2090581.8029200002 | 37.720873831251104 | -122.40933637376999 | (37.7208738312511, -122.40933637377) | |||
| 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) | |||
| 25493 | 25493 | 207183 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995337.35676 | 2098242.98475 | 37.7411079873364 | -122.458721155571 | (37.7411079873364, -122.458721155571) | |||
| 31099 | 31099 | 226629 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 54 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001984.40508 | 2105553.3896 | 37.761560425102 | -122.43626114684099 | (37.761560425102, -122.436261146841) | |||
| 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) | |||
| 33252 | 33252 | 129488 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3320 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999321.62812 | 2120233.7842099997 | 37.801717336245105 | -122.44652677938801 | (37.8017173362451, -122.446526779388) | |||
| 33451 | 33451 | 191410 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 777 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011870.78856 | 2104734.77484 | 37.7598694505299 | -122.402010442428 | (37.7598694505299, -122.402010442428) | |||
| 35186 | 35186 | 45487 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2934 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 3 | Permit Number 44266 | 5990011.75655 | 2095686.43247 | 37.7337808158159 | -122.476948200207 | (37.7337808158159, -122.476948200207) | |
| 36611 | 36611 | 207332 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 139 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6000483.56606 | 2095198.0934400002 | 37.7330418734682 | -122.44070911276 | (37.7330418734682, -122.44070911276) | |||
| 37207 | 37207 | 207145 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1418 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991828.31268 | 2105750.01462 | 37.7615180292623 | -122.471400907553 | (37.7615180292623, -122.471400907553) | |||
| 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) | |||
| 47592 | 47592 | 207190 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999972.7522599995 | 2094392.56954 | 37.7308009895699 | -122.44241731471399 | (37.7308009895699, -122.442417314714) | ||||
| 48704 | 48704 | 207278 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 575 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994134.4568 | 2099399.45739 | 37.7442141593615 | -122.462964201952 | (37.7442141593615, -122.462964201952) | |||
| 54556 | 54556 | 207281 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 595 Darien Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993428.290469999 | 2094922.6798 | 37.731881346040794 | -122.46508086700001 | (37.7318813460408, -122.465080867) | |||
| 56032 | 56032 | 207275 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993069.797230001 | 2099663.50314 | 37.7448777789813 | -122.46666472241999 | (37.7448777789813, -122.46666472242) | |||
| 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) | ||
| 58029 | 58029 | 207272 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Ortega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5991341.884190001 | 2102447.3188400003 | 37.7524215459225 | -122.472842415544 | (37.7524215459225, -122.472842415544) | |||
| 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) | |||
| 59680 | 59680 | 207153 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 37 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992857.79641 | 2101696.45596 | 37.750447510654396 | -122.467545586773 | (37.7504475106544, -122.467545586773) | |||
| 61495 | 61495 | 41940 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 642 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767709 | 5994437.32362 | 2111135.33206 | 37.7764552768418 | -122.46276817075301 | (37.7764552768418, -122.462768170753) |
| 62912 | 62912 | 177003 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 746 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009476.70201 | 2090586.0760400002 | 37.720886288652004 | -122.409291987754 | (37.720886288652, -122.409291987754) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |
| 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) |
| 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) | |||
| 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) | |||
| 133764 | 133764 | 207351 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 662 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5997053.67683 | 2095305.7853299999 | 37.7331416469589 | -122.45257485054701 | (37.7331416469589, -122.452574850547) | |||
| 135933 | 135933 | 176997 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 131 Farragut Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5997268.75573 | 2087384.8014900002 | 37.7114048037631 | -122.451260209013 | (37.7114048037631, -122.451260209013) | |||
| 136074 | 136074 | 207276 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5992917.36629 | 2099685.98724 | 37.7449307166945 | -122.467193430259 | (37.7449307166945, -122.467193430259) |
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");