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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24450 | 24450 | 45488 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2934 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44266 | 5990009.93985 | 2095708.66875 | 37.733841765574205 | -122.476956105249 | (37.7338417655742, -122.476956105249) | |
| 29934 | 29934 | 129496 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1101 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6007491.98236 | 2119862.03748 | 37.8011599004699 | -122.418227149773 | (37.8011599004699, -122.418227149773) | ||||
| 30391 | 30391 | 207358 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 171 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998941.871780001 | 2093762.1788299999 | 37.7290112721346 | -122.445935896945 | (37.7290112721346, -122.445935896945) | ||||
| 30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
| 31691 | 31691 | 37790 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 6 | Permit Number 40120 | 6009327.0324 | 2092792.3248 | 37.7269357978389 | -122.40996501967899 | (37.7269357978389, -122.409965019679) | |
| 33118 | 33118 | 118541 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.423690001 | 2112399.66579 | 37.779163567264 | -122.50817750438699 | (37.779163567264, -122.508177504387) | ||||
| 33948 | 33948 | 37792 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 310 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 5 | Permit Number 40120 | 6009317.62312 | 2092827.34387 | 37.727031425442 | -122.410000018602 | (37.727031425442, -122.410000018602) | |
| 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) | ||
| 34562 | 34562 | 34814 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 485 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 5 | Permit Number 38705 | 5983755.240019999 | 2112575.55408 | 37.779788683805705 | -122.49982642326599 | (37.7797886838057, -122.499826423266) | |
| 35068 | 35068 | 207355 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 430 Edna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998789.17566 | 2094262.87598 | 37.730377348622106 | -122.446499784464 | (37.7303773486221, -122.446499784464) | ||||
| 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) | |
| 35444 | 35444 | 31932 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1210 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35348 | 5981508.8658 | 2106816.8909 | 37.763844998562206 | -122.507170151225 | (37.7638449985622, -122.507170151225) | |
| 36376 | 36376 | 37433 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1419 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1998 12:00:00 AM | 6 | Permit Number 39907 | 5991189.91551 | 2110613.34906 | 37.7748344845766 | -122.473963672883 | (37.7748344845766, -122.473963672883) | ||
| 40805 | 40805 | 122909 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2x 12th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5992095.78801 | 2114872.2732700002 | 37.7865807540814 | -122.471140447624 | (37.7865807540814, -122.471140447624) | ||||
| 43818 | 43818 | 68271 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 432 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2014 12:00:00 AM | 8 | Permit Number 771022 | 6009763.0481199995 | 2092384.22175 | 37.7258396600504 | -122.408428941659 | (37.7258396600504, -122.408428941659) | |
| 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) | ||||
| 47695 | 47695 | 41753 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1644 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 4 | Permit Number 42182 | 6006856.27196 | 2116746.53055 | 37.7925696967985 | -122.42020574908899 | (37.7925696967985, -122.420205749089) | |
| 47768 | 47768 | 35124 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 6 | Permit Number 38659 | 6001796.31519 | 2089542.9326900002 | 37.717588753495 | -122.43576613121701 | (37.717588753495, -122.435766131217) | |
| 47861 | 47861 | 62489 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 25 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 8 | Permit Number 22660 | 6000933.610719999 | 2092903.74949 | 37.726767752305605 | -122.43898882388399 | (37.7267677523056, -122.438988823884) | |
| 48088 | 48088 | 31195 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 260 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1995 12:00:00 AM | 6 | Permit Number 34888 | 5992024.42182 | 2086737.21442 | 37.7093250109181 | -122.469338707216 | (37.7093250109181, -122.469338707216) | ||
| 48932 | 48932 | 70374 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | ||
| 51466 | 51466 | 118540 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.117190001 | 2112394.76177 | 37.7791500842164 | -122.50817820058701 | (37.7791500842164, -122.508178200587) | ||||
| 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) | ||||
| 52623 | 52623 | 40627 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | ||
| 53679 | 53679 | 207188 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999995.26886 | 2094392.10213 | 37.7308009895535 | -122.442339437931 | (37.7308009895535, -122.442339437931) | ||||
| 54128 | 54128 | 247978 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009784.19004 | 2099413.44589 | 37.7451415861154 | -122.40885156275299 | (37.7451415861154, -122.408851562753) | ||||
| 56500 | 56500 | 177008 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 67 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6001385.71309 | 2093783.96595 | 37.7292103388668 | -122.43748892737301 | (37.7292103388668, -122.437488927373) | ||||
| 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) | ||
| 57870 | 57870 | 37592 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 639 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40020 | 5992524.028 | 2111081.26309 | 37.776196436129396 | -122.46938280754699 | (37.7761964361294, -122.469382807547) | |
| 59008 | 59008 | 38198 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 885 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | Permit Number 40325 | 6011564.90625 | 2090771.94385 | 37.721513417393496 | -122.402086713936 | (37.7215134173935, -122.402086713936) | |
| 59196 | 59196 | 78418 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2987 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5988809.97189 | 2095328.5114400003 | 37.732728266388 | -122.481076880696 | (37.732728266388, -122.481076880696) | ||
| 59492 | 59492 | 31354 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2324 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34964 | 5992033.25034 | 2099586.3658 | 37.7446061063992 | -122.47024325973 | (37.7446061063992, -122.47024325973) | |
| 60597 | 60597 | 35146 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 936 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 8 | Permit Number 38676 | 6002023.61816 | 2088453.4827599998 | 37.714610274410205 | -122.434902580586 | (37.7146102744102, -122.434902580586) | |
| 60961 | 60961 | 43315 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 259 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43078 | 6004448.9414 | 2091752.36291 | 37.72380568677679 | -122.426754460261 | (37.7238056867768, -122.426754460261) | |
| 62306 | 62306 | 52667 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226@ MARIPOSA Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2006 12:00:00 AM | 4 | Permit Number 48748 | 6013989.6640800005 | 2106012.3733900003 | 37.7634954891429 | -122.39477170574301 | (37.7634954891429, -122.394771705743) | ||
| 62502 | 62502 | 46769 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 54 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44865 | 6002394.404709999 | 2093228.74941 | 37.7277431363295 | -122.43396212714599 | (37.7277431363295, -122.433962127146) | |
| 63480 | 63480 | 177019 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 25 Madrid St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004214.26597 | 2093378.8456299999 | 37.728258376811496 | -122.427681523704 | (37.7282583768115, -122.427681523704) | ||||
| 65074 | 65074 | 67318 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 666 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 9 | Permit Number 30800 | 5993501.91813 | 2110961.7349 | 37.7759247065994 | -122.46599136010799 | (37.7759247065994, -122.465991360108) | |
| 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) | |
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | |
| 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) | |
| 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) | |||||
| 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) | |
| 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) | ||
| 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) | ||
| 134174 | 134174 | 71938 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 384 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011634.93944 | 2119088.82833 | 37.7992691828709 | -122.403836198406 | (37.7992691828709, -122.403836198406) | ||
| 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) | ||||
| 138152 | 138152 | 226584 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 116 Franconia St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010066.87681 | 2099747.40872 | 37.746074405213704 | -122.40789762220301 | (37.7460744052137, -122.407897622203) | ||||
| 148538 | 148538 | 42630 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2634 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42686 | 6004473.47116 | 2118249.9245 | 37.7965630841803 | -122.428557534402 | (37.7965630841803, -122.428557534402) | |
| 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) | |
| 149732 | 149732 | 191412 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1998 Revere Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6013024.42365 | 2095944.26783 | 37.7357969159791 | -122.39740407446001 | (37.7357969159791, -122.39740407446) | ||||
| 152184 | 152184 | 50302 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 59 Inverness Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2004 12:00:00 AM | 4 | Permit Number 47012 | 5988294.3182 | 2095513.1698900003 | 37.7332053009864 | -122.482873130798 | (37.7332053009864, -122.482873130798) | |
| 152419 | 152419 | 207191 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999968.7786 | 2094392.65203 | 37.7308009895755 | -122.442431058168 | (37.7308009895755, -122.442431058168) | ||||
| 153673 | 153673 | 72284 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 828 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 3 | 5982951.02608 | 2110145.8974099997 | 37.773070328481396 | -122.502428636033 | (37.7730703284814, -122.502428636033) | ||
| 154328 | 154328 | 35122 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 723 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 7 | Permit Number 38657 | 6001912.16427 | 2089726.3543900002 | 37.7180989685677 | -122.435378807601 | (37.7180989685677, -122.435378807601) | |
| 154723 | 154723 | 43162 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 221 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 42972 | 6005660.57006 | 2092632.04042 | 37.726289518943 | -122.42262853710301 | (37.726289518943, -122.422628537103) | |
| 155422 | 155422 | 120286 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 157 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5988329.9195 | 2114925.99705 | 37.786509724826004 | -122.48417321294501 | (37.786509724826, -122.484173212945) | ||||
| 156575 | 156575 | 118539 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5981337.09939 | 2112389.25007 | 37.7791349496719 | -122.508177852958 | (37.7791349496719, -122.508177852958) | ||||
| 156798 | 156798 | 207352 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 630 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997888.696769999 | 2095016.78994 | 37.732395942619 | -122.44966715802299 | (37.732395942619, -122.449667158023) | ||||
| 158363 | 158363 | 207189 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999987.6528199995 | 2094392.26023 | 37.7308009895722 | -122.442365779062 | (37.7308009895722, -122.442365779062) | ||||
| 158840 | 158840 | 35127 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 775 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 5 | Permit Number 38661 | 6001730.34361 | 2089436.21425 | 37.71729198082 | -122.43598653257799 | (37.71729198082, -122.435986532578) | |
| 159473 | 159473 | 78478 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2987 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5988808.95801 | 2095345.9881400003 | 37.7327761939684 | -122.481081665112 | (37.7327761939684, -122.481081665112) | ||
| 161710 | 161710 | 43171 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 369 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 8 | Permit Number 42980 | 6005855.02005 | 2091989.32837 | 37.7245357402195 | -122.42191069731501 | (37.7245357402195, -122.421910697315) | |
| 161784 | 161784 | 226591 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 793 27th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001403.92595 | 2099956.05685 | 37.7461584981302 | -122.43786786123998 | (37.7461584981302, -122.43786786124) | ||||
| 162483 | 162483 | 207356 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 247 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998447.51248 | 2093764.7485200001 | 37.7289900868122 | -122.447645112433 | (37.7289900868122, -122.447645112433) | ||||
| 163271 | 163271 | 32472 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 117 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36980 | 6000335.64895 | 2106187.4701799997 | 37.7632076377424 | -122.442009017113 | (37.7632076377424, -122.442009017113) | |
| 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) | ||||
| 168579 | 168579 | 43185 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 62 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42987 | 6005330.72095 | 2092724.62519 | 37.7265251215375 | -122.42377539032101 | (37.7265251215375, -122.423775390321) | |
| 171196 | 171196 | 31366 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2475 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34971 | 5991057.56391 | 2098576.78296 | 37.7417775946723 | -122.473543328283 | (37.7417775946723, -122.473543328283) | |
| 171748 | 171748 | 207363 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 98 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999482.34141 | 2093540.9124 | 37.7284345728794 | -122.444051566321 | (37.7284345728794, -122.444051566321) | ||||
| 172268 | 172268 | 51484 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47795 | 6013789.90035 | 2095538.1570700002 | 37.7347244096963 | -122.394729070715 | (37.7347244096963, -122.394729070715) | ||
| 174997 | 174997 | 176989 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998947.7718 | 2089388.6360799999 | 37.717002872174504 | -122.445601123393 | (37.7170028721745, -122.445601123393) | ||||
| 178613 | 178613 | 176988 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998975.21291 | 2089361.52774 | 37.7169300054919 | -122.445504324886 | (37.7169300054919, -122.445504324886) | ||||
| 178747 | 178747 | 47762 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2462 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2002 12:00:00 AM | 4 | Permit Number 45541 | 5988312.7876 | 2098561.9922 | 37.741577647038 | -122.48303266006 | (37.741577647038, -122.48303266006) | |
| 179233 | 179233 | 129494 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 14 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007592.27134 | 2119390.32661 | 37.7998703454969 | -122.417846649312 | (37.7998703454969, -122.417846649312) | ||||
| 179554 | 179554 | 42889 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988969.9668 | 2098294.7493 | 37.7408820870559 | -122.48074082372801 | (37.7408820870559, -122.480740823728) | |
| 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) | ||
| 181320 | 181320 | 129489 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2120 Jefferson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999042.28702 | 2121160.24008 | 37.80424517403429 | -122.44756015169901 | (37.8042451740343, -122.447560151699) | ||||
| 181540 | 181540 | 43847 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2828 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 3 | Permit Number 43469 | 5985600.1899 | 2096127.6598 | 37.734735400872204 | -122.492232562099 | (37.7347354008722, -122.492232562099) | |
| 182650 | 182650 | 207192 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999965.474330001 | 2094393.0504400001 | 37.730801895176896 | -122.442442510114 | (37.7308018951769, -122.442442510114) | ||||
| 183734 | 183734 | 35133 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 805 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 6 | Permit Number 38663 | 6001614.17085 | 2089254.80742 | 37.7167872776758 | -122.43637511074101 | (37.7167872776758, -122.436375110741) | |
| 185589 | 185589 | 207219 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999123.85922 | 2093459.79448 | 37.728191385403704 | -122.445285022505 | (37.7281913854037, -122.445285022505) | ||||
| 186519 | 186519 | 32589 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.763129529589705 | -122.493148331917 | (37.7631295295897, -122.493148331917) | |
| 187631 | 187631 | 207235 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 44 Montana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5996222.23222 | 2089333.72162 | 37.716696107125394 | -122.455017978523 | (37.7166961071254, -122.455017978523) | ||||
| 188791 | 188791 | 177020 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 235 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004327.3137300005 | 2092022.6110200002 | 37.724540851055 | -122.42719414780599 | (37.724540851055, -122.427194147806) |
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");