Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 121 | 121 | 59839 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1201 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1981 12:00:00 AM | 3 | Permit Number 19293 | 6016946.5018 | 2093669.1216 | 37.729767407645895 | -122.383685429115 | (37.7297674076459, -122.383685429115) | |
| 497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
| 802 | 802 | 64866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1989 12:00:00 AM | 13 | Permit Number 25884 | 5997401.9097 | 2109840.7512 | 37.773070992957 | -122.45241943675501 | (37.773070992957, -122.452419436755) | |
| 2153 | 2153 | 251201 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000X Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Permit Number 780227 | 6004899.0 | 2108432.0 | 37.769629569555896 | -122.426385716137 | (37.7696295695559, -122.426385716137) | ||
| 2599 | 2599 | 56658 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2436 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5987881.10051 | 2113316.56801 | 37.7820645490157 | -122.485607837735 | (37.7820645490157, -122.485607837735) | ||||
| 3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
| 3770 | 3770 | 94964 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2010 12:00:00 AM | 12 | 5999368.8526 | 2116683.0767599996 | 37.791970737501 | -122.446107814943 | (37.791970737501, -122.446107814943) | |||
| 3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) | ||||
| 3910 | 3910 | 14420 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998841.5976 | 2113071.3194 | 37.7820236767836 | -122.44767199806299 | (37.7820236767836, -122.447671998063) | ||||
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 5603 | 5603 | 34246 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38056 | ||||||||||
| 5617 | 5617 | 35204 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 5969 | 5969 | 111118 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5997454.0334 | 2109847.6499 | 37.7730929211041 | -122.45223963309401 | (37.7730929211041, -122.452239633094) | |||
| 6011 | 6011 | 66459 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 26 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 12 | Permit Number 29609 | 5998393.1041 | 2113638.7682 | 37.7835561003446 | -122.449264468811 | (37.7835561003446, -122.449264468811) | |
| 6158 | 6158 | 111117 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997427.9716 | 2109844.5838 | 37.7730830093731 | -122.452329562425 | (37.7730830093731, -122.452329562425) | |||
| 6825 | 6825 | 35207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 6835 | 6835 | 35197 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7167 | 7167 | 35203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 7455 | 7455 | 66458 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 12 | Permit Number 29608 | 5998357.739 | 2113627.431 | 37.783522948461396 | -122.449386000758 | (37.7835229484614, -122.449386000758) | |
| 9617 | 9617 | 35183 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 9772 | 9772 | 31954 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 376 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779001 | 6007700.6127 | 2112534.0432 | 37.7810507733068 | -122.41698569087299 | (37.7810507733068, -122.416985690873) | ||
| 10310 | 10310 | 35176 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 10465 | 10465 | 46403 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3725 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/2014 12:00:00 AM | 3 | Permit Number 774152 | 5982443.3691 | 2102154.0013 | 37.7510970192105 | -122.50359271554501 | (37.7510970192105, -122.503592715545) | |
| 10910 | 10910 | 68310 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2186 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32121 | 5981735.8983 | 2100213.1522 | 37.7457263715271 | -122.505895303793 | (37.7457263715271, -122.505895303793) | |
| 11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 11317 | 11317 | 35209 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11636 | 11636 | 92966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2186 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5981735.5599 | 2100228.0428 | 37.7457672370442 | -122.505897577684 | (37.7457672370442, -122.505897577684) | |||
| 11988 | 11988 | 35180 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12382 | 12382 | 39827 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2194 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | 6 | Permit Number 44096. | 5981736.2368 | 2100175.5874 | 37.7456232489839 | -122.50589134882799 | (37.7456232489839, -122.505891348828) | |
| 12435 | 12435 | 35178 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12458 | 12458 | 35205 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12489 | 12489 | 35198 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 12872 | 12872 | 35210 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 13066 | 13066 | 97641 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1641 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5988864.7432 | 2103046.835 | 37.753923942343704 | -122.48145257962601 | (37.7539239423437, -122.481452579626) | ||||
| 13328 | 13328 | 63694 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1862 10TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 24352 | 5993137.0 | 2102888.0 | 37.753735299933 | -122.46666669057501 | (37.753735299933, -122.466666690575) | ||
| 14195 | 14195 | 35181 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14347 | 14347 | 87020 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 14575 | 14575 | 35206 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 14588 | 14588 | 35174 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16081 | 16081 | 35175 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16133 | 16133 | 35179 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16225 | 16225 | 35208 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16452 | 16452 | 35177 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 16638 | 16638 | 35212 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 18368 | 18368 | 55119 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1972 12:00:00 AM | 16 | Permit Number 11021 | 5997096.40798246 | 2105960.18380068 | 37.7623984432414 | -122.45319600431999 | (37.7623984432414, -122.45319600432) | ||
| 18560 | 18560 | 37810 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1746 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44738 | 5981328.72954544 | 2103184.35370388 | 37.753860479355396 | -122.50752362923201 | (37.7538604793554, -122.507523629232) | ||
| 18881 | 18881 | 111979 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 39 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5987939.0 | 2115796.0 | 37.788875735681 | -122.485589552136 | (37.788875735681, -122.485589552136) | |||||
| 18916 | 18916 | 65141 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 430 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1989 12:00:00 AM | Permit Number 27116 | 5981364.99930459 | 2112708.09753982 | 37.780012054358394 | -122.508105008848 | (37.7800120543584, -122.508105008848) | ||
| 19133 | 19133 | 37103 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
| 19238 | 19238 | 104509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 DICHIERA CT | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5998620.0 | 2088043.0 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | |||||
| 19272 | 19272 | 65062 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 481 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1989 12:00:00 AM | Permit Number 27018 | 5982198.4613122 | 2112526.22921648 | 37.7795617740877 | -122.505208255718 | (37.7795617740877, -122.505208255718) | ||
| 19499 | 19499 | 111948 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 75 SEACLIFF AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 5987695.0 | 2115788.0 | 37.7888395504461 | -122.486433160149 | (37.7888395504461, -122.486433160149) | ||||
| 19554 | 19554 | 106481 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 301X LAWTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993233.0 | 2104592.0 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | |||||
| 19555 | 19555 | 63127 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 51 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23641 | 6007142.25261762 | 2099206.716095 | 37.7444256145798 | -122.417972293386 | (37.7444256145798, -122.417972293386) | ||
| 19641 | 19641 | 94973 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 230 Seacliff Ave | 5 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53388 | 5987086.7 | 2115743.7 | 37.7886824393648 | -122.488534508212 | (37.7886824393648, -122.488534508212) | |||
| 19655 | 19655 | 97747 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2685 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | ||||
| 19792 | 19792 | 111947 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 95 SEACLIFF AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5987570.0 | 2115773.0 | 37.7887910778243 | -122.48686453517901 | (37.7887910778243, -122.486864535179) | ||||
| 19842 | 19842 | 37102 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.764023420548796 | -122.508237579769 | (37.7640234205488, -122.508237579769) | ||
| 20388 | 20388 | 111086 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 582X Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5996560.16999 | 2095740.09269 | 37.7343058616961 | -122.454312386561 | (37.7343058616961, -122.454312386561) | |||||
| 20909 | 20909 | 33583 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37691 | 6007181.85623533 | 2098126.23586774 | 37.741461086055295 | -122.417758780801 | (37.7414610860553, -122.417758780801) | |||
| 22879 | 22879 | 53904 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1075 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1972 12:00:00 AM | 15 | Permit Number 9616 | 6011239.099780001 | 2089785.6199599998 | 37.7187869832091 | -122.40314359991301 | (37.7187869832091, -122.403143599913) | ||
| 23471 | 23471 | 47859 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1399 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 5 | Permit Number 45616 | 5982746.5554 | 2105696.4247 | 37.7608413368995 | -122.50280648168899 | (37.7608413368995, -122.502806481689) | |
| 23735 | 23735 | 213223 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5996685.56427 | 2088703.70423 | 37.7149927956564 | -122.45337101855101 | (37.7149927956564, -122.453371018551) | ||||
| 23739 | 23739 | 62090 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1527 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 9 | Permit Number 31146 | 6013382.10776 | 2104727.08591 | 37.75993257304379 | -122.396782951399 | (37.7599325730438, -122.396782951399) | |
| 23767 | 23767 | 59869 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 682 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1981 12:00:00 AM | 17 | Permit Number 19328 | 5982606.75676 | 2111131.17183 | 37.7757553704933 | -122.50369246769199 | (37.7757553704933, -122.503692467692) | ||
| 23916 | 23916 | 177744 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001008.85116 | 2091721.5574 | 37.7235260030036 | -122.438644049011 | (37.7235260030036, -122.438644049011) | ||||
| 23918 | 23918 | 38491 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1055 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1998 12:00:00 AM | 7 | Permit Number 40486 | 6007969.19712 | 2118884.80635 | 37.7985035180865 | -122.416506512892 | (37.7985035180865, -122.416506512892) | |
| 23935 | 23935 | 31454 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 625 Douglass St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35026 | 6001228.91963 | 2102742.34175 | 37.7537990168301 | -122.43867262494601 | (37.7537990168301, -122.438672624946) | |
| 23992 | 23992 | 98191 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1060 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 23353 | 6007933.22723 | 2118928.4377099997 | 37.798621295993 | -122.416634072728 | (37.798621295993, -122.416634072728) | |||
| 23995 | 23995 | 68972 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3444 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 10 | Permit Number 32962 | 5999781.0936 | 2120437.57627 | 37.8023031276514 | -122.444951481035 | (37.8023031276514, -122.444951481035) | |
| 24018 | 24018 | 31934 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1286 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 0 | Permit Number 35350 | 5981530.42710663 | 2106331.73149581 | 37.762514160345205 | -122.50705958621 | (37.7625141603452, -122.50705958621) | |
| 24038 | 24038 | 37228 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1827 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39792 | 5985640.6866 | 2102775.6534 | 37.75299136712471 | -122.49258199603999 | (37.7529913671247, -122.49258199604) | |
| 24052 | 24052 | 68291 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2026 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 9 | Permit Number 32996 | 5981388.6776 | 2101267.3361 | 37.748600421328 | -122.50717411267401 | (37.748600421328, -122.507174112674) | |
| 24133 | 24133 | 109372 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2845 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5999495.25507 | 2118683.52154 | 37.7974706458052 | -122.44581439582701 | (37.7974706458052, -122.445814395827) | ||||
| 24252 | 24252 | 69018 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2035 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 10 | Permit Number 33022 | 5981651.8006 | 2101224.6231 | 37.748498637333896 | -122.50626108566799 | (37.7484986373339, -122.506261085668) | |
| 24352 | 24352 | 68538 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 790 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 12 | Permit Number 32420 | 5993840.78744 | 2110199.31187 | 37.7738508399811 | -122.464763753871 | (37.7738508399811, -122.464763753871) | |
| 24586 | 24586 | 61569 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 958 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 12 | Permit Number 21529 | 6012748.7696 | 2103051.87566 | 37.7552975409755 | -122.398855802363 | (37.7552975409755, -122.398855802363) | |
| 24705 | 24705 | 74639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 3 | 6007029.8225 | 2113512.7316900003 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | ||
| 24817 | 24817 | 70493 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6005304.47442 | 2091965.6716099998 | 37.7244397195916 | -122.42381218159599 | (37.7244397195916, -122.423812181596) | ||
| 24846 | 24846 | 62985 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3098 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1986 12:00:00 AM | 6 | Permit Number 23380 | 5999380.16737 | 2116683.12312 | 37.791971510928 | -122.446068669248 | (37.791971510928, -122.446068669248) | ||
| 24926 | 24926 | 56703 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1658 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5983163.3299 | 2103847.5064 | 37.7557892132897 | -122.50122830581999 | (37.7557892132897, -122.50122830582) | ||||
| 24969 | 24969 | 55607 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 670 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 18 | Permit Number 11583 | 5982603.93 | 2111220.05033 | 37.7759992387196 | -122.50370882963999 | (37.7759992387196, -122.50370882964) | ||
| 25025 | 25025 | 65744 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 184 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 11 | Permit Number 28703 | 6000756.34177 | 2087488.39058 | 37.711888311673796 | -122.43921366159901 | (37.7118883116738, -122.439213661599) | |
| 25108 | 25108 | 47852 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1430 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 4 | Permit Number 45611 | 5983111.9868 | 2105384.8257 | 37.760007243783704 | -122.501519585216 | (37.7600072437837, -122.501519585216) | |
| 25190 | 25190 | 60134 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1881 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1982 12:00:00 AM | 14 | Permit Number 19664 | 6003859.19532 | 2119347.90146 | 37.799543064221396 | -122.43076145709601 | (37.7995430642214, -122.430761457096) | ||
| 25280 | 25280 | 60068 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2309 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 11 | Permit Number 19568 | 5988521.12 | 2107125.5346 | 37.7651029613737 | -122.482939804052 | (37.7651029613737, -122.482939804052) | |
| 25326 | 25326 | 63559 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3655 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | Permit Number 24181 | 5982862.532000001 | 2104209.7007 | 37.7567660283709 | -122.502295347911 | (37.7567660283709, -122.502295347911) | |
| 25503 | 25503 | 55798 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2327 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1973 12:00:00 AM | 13 | Permit Number 11842 | 5985442.6323 | 2099366.9285 | 37.7436203536161 | -122.49301582028099 | (37.7436203536161, -122.493015820281) | ||
| 25537 | 25537 | 71240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.43840717979201 | (37.781532142896, -122.438407179792) | ||
| 25545 | 25545 | 71820 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1262 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 11 | 5988034.0091 | 2106701.9931 | 37.763911677097894 | -122.484593510615 | (37.7639116770979, -122.484593510615) | ||
| 25606 | 25606 | 68961 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2139 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 9 | Permit Number 32950 | 5988833.65861 | 2111208.64898 | 37.7763322483358 | -122.48215798183901 | (37.7763322483358, -122.482157981839) | |
| 25667 | 25667 | 60488 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1966 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1982 12:00:00 AM | 15 | Permit Number 20085 | 6001504.6387 | 2112889.2485 | 37.7816755945949 | -122.438446062556 | (37.7816755945949, -122.438446062556) | ||
| 25795 | 25795 | 49377 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 522Walbridge Carter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 46344 | 6005205.53768 | 2086236.36888 | 37.7087027016261 | -122.423747012218 | (37.7087027016261, -122.423747012218) | |||
| 26003 | 26003 | 70424 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982456.3495 | 2105108.4827 | 37.759209955641104 | -122.50376661440501 | (37.7592099556411, -122.503766614405) | ||
| 26013 | 26013 | 97112 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1345 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 18860 | 5989771.682 | 2103084.5073 | 37.754080071234704 | -122.47831896102699 | (37.7540800712347, -122.478318961027) | |||
| 26071 | 26071 | 58975 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 270 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1980 12:00:00 AM | 17 | Permit Number 18261 | 5994954.78208 | 2113734.81379 | 37.7836225481699 | -122.461166617418 | (37.7836225481699, -122.461166617418) | ||
| 26181 | 26181 | 74488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2334 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5983318.4565 | 2099328.1281 | 37.7433893618735 | -122.50035771523599 | (37.7433893618735, -122.500357715236) | ||
| 26350 | 26350 | 43056 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2183 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | Permit Number 42905 | 5981689.1961 | 2100235.8265 | 37.745785879800295 | -122.506058471243 | (37.7457858798003, -122.506058471243) | |
| 26367 | 26367 | 60088 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1278 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 15 | Permit Number 19589 | 5988967.2555 | 2106649.5291 | 37.76382192904121 | -122.481361886812 | (37.7638219290412, -122.481361886812) | |
| 26403 | 26403 | 58773 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1185 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1979 12:00:00 AM | 17 | Permit Number 18016 | 6011971.93292 | 2102954.59115 | 37.7549871030883 | -122.401535514949 | (37.7549871030883, -122.401535514949) |
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");