trees
8,758 rows where qSpecies_id = 16 sorted by TreeID descending
This data as json, CSV (advanced)
rowid | TreeID ▲ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188408 | 99873 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
50960 | 99872 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
146139 | 99871 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 194@Holloway Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 20767 | 5994516.9 | 2091196.7 | 37.7217134214697 | -122.46104737723 | (37.7217134214697, -122.46104737723) | 9 | 8 | 6 | 28861 | 24 | ||||
23526 | 99814 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 709 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001253 | 2102268 | 37.7524979583971 | -122.438555365412 | (37.7524979583971, -122.438555365412) | 2 | 4 | 5 | 28862 | 22 | ||||
55193 | 99785 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 803-805 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001281.6 | 2101711.5 | 37.7509715697707 | -122.438416595038 | (37.7509715697707, -122.438416595038) | 2 | 4 | 5 | 28862 | 22 | ||||
186697 | 99773 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4348 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001650 | 2100601 | 37.7479433490982 | -122.437063136505 | (37.7479433490982, -122.437063136505) | 2 | 4 | 5 | 28862 | 22 | ||||
39115 | 99769 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 575 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001440 | 2101432 | 37.7502131382163 | -122.437848816697 | (37.7502131382163, -122.437848816697) | 2 | 4 | 5 | 28862 | 22 | ||||
95637 | 99767 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 543 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001641 | 2101443 | 37.7502547692275 | -122.437154534913 | (37.7502547692275, -122.437154534913) | 2 | 4 | 5 | 28862 | 22 | ||||
111416 | 99757 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4295x 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.435981539714 | (37.7495164396885, -122.435981539714) | 2 | 4 | 5 | 28862 | 22 | ||||
83914 | 99756 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 517 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Probably planted at same time/permitted with tree no. 1 | 6001837 | 2100870 | 37.7486925868246 | -122.436435749617 | (37.7486925868246, -122.436435749617) | 2 | 4 | 5 | 28862 | 22 | |||
27202 | 99737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900X Ocean Ave | 3 | Median : Cutout | Tree | DPW 1 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.451579911331 | (37.7230482703916, -122.451579911331) | 9 | 7 | 4 | 28861 | 40 | |||||
37750 | 99736 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900X Ocean Ave | 2 | Median : Cutout | Tree | DPW 1 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.451579911331 | (37.7230482703916, -122.451579911331) | 9 | 7 | 4 | 28861 | 40 | |||||
63256 | 99735 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900X Ocean Ave | 1 | Median : Cutout | Tree | DPW 1 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.451579911331 | (37.7230482703916, -122.451579911331) | 9 | 7 | 4 | 28861 | 40 | |||||
54263 | 99731 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991009.5 | 2094863.7 | 37.7315796303384 | -122.473438749026 | (37.7315796303384, -122.473438749026) | 1 | 8 | 4 | 64 | 40 | ||||
164901 | 99730 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991009.5 | 2094863.7 | 37.7315796303384 | -122.473438749026 | (37.7315796303384, -122.473438749026) | 1 | 8 | 4 | 64 | 40 | ||||
32853 | 99729 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2645 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990840.1 | 2094977 | 37.7318809123737 | -122.474032655501 | (37.7318809123737, -122.474032655501) | 1 | 8 | 4 | 64 | 40 | ||||
94523 | 99689 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
45783 | 99671 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 150X Alma St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
74237 | 99512 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 154 Miraloma Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/15/2012 12:00:00 AM | Permit Number 768163 | 5994585.5 | 2096588.5 | 37.7365219395083 | -122.461200886189 | (37.7365219395083, -122.461200886189) | 9 | 7 | 4 | 59 | 40 | |||
126742 | 99373 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
18070 | 99372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 499X 29th Ave | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.489086903101 | (37.7799454996166, -122.489086903101) | 11 | 6 | 2 | 55 | 26 | ||
34496 | 99371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986853.20034 | 2112633.29686 | 37.7801285370834 | -122.489113608336 | (37.7801285370834, -122.489113608336) | 11 | 6 | 2 | 55 | 26 | ||
71997 | 99370 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986851.72562 | 2112647.47743 | 37.7801673868145 | -122.489119752829 | (37.7801673868145, -122.489119752829) | 11 | 6 | 2 | 55 | 26 | ||
188415 | 99369 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986847.81361 | 2112672.32158 | 37.7802353734381 | -122.489135113122 | (37.7802353734381, -122.489135113122) | 11 | 6 | 2 | 55 | 26 | ||
142644 | 99368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986849.57732 | 2112692.62378 | 37.7802912204421 | -122.489130504747 | (37.7802912204421, -122.489130504747) | 11 | 6 | 2 | 55 | 26 | ||
44884 | 99367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986848.24353 | 2112713.43374 | 37.7803482808136 | -122.489136649255 | (37.7803482808136, -122.489136649255) | 11 | 6 | 2 | 55 | 26 | ||
176883 | 99366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986848.25067 | 2112734.65735 | 37.7804065552175 | -122.489138185351 | (37.7804065552175, -122.489138185351) | 11 | 6 | 2 | 55 | 26 | ||
136557 | 99365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986845.14154 | 2112755.50502 | 37.7804636155038 | -122.489150474302 | (37.7804636155038, -122.489150474302) | 11 | 6 | 2 | 55 | 26 | ||
143111 | 99364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | Permit Number 773617 | 5986846.87705 | 2112774.48123 | 37.7805158200694 | -122.489145865965 | (37.7805158200694, -122.489145865965) | 11 | 6 | 2 | 55 | 26 | |
165116 | 99363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | Permit Number 773617 | 5986845.56233 | 2112796.17507 | 37.7805753084335 | -122.489152009534 | (37.7805753084335, -122.489152009534) | 11 | 6 | 2 | 55 | 26 | |
69455 | 99362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986843.02407 | 2112864.76375 | 37.7807634852432 | -122.489165834601 | (37.7807634852432, -122.489165834601) | 11 | 6 | 2 | 55 | 26 | ||
113863 | 99361 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986841.31224 | 2112888.67684 | 37.7808290438523 | -122.489173515193 | (37.7808290438523, -122.489173515193) | 11 | 6 | 2 | 55 | 26 | ||
98082 | 99360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986841.26301 | 2112907.24873 | 37.7808800340934 | -122.489175051323 | (37.7808800340934, -122.489175051323) | 11 | 6 | 2 | 55 | 26 | ||
80354 | 99359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986842.11085 | 2112926.24344 | 37.7809322376389 | -122.489173515185 | (37.7809322376389, -122.489173515185) | 11 | 6 | 2 | 55 | 26 | ||
40927 | 99358 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986838.55817 | 2112947.10039 | 37.7809892975063 | -122.489187339371 | (37.7809892975063, -122.489187339371) | 11 | 6 | 2 | 55 | 26 | ||
181422 | 99357 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986839.06552 | 2112970.96623 | 37.7810548559101 | -122.489187339385 | (37.7810548559101, -122.489187339385) | 11 | 6 | 2 | 55 | 26 | ||
33247 | 99356 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986838.12863 | 2112989.55693 | 37.781105845983 | -122.489191947731 | (37.781105845983, -122.489191947731) | 11 | 6 | 2 | 55 | 26 | ||
115408 | 99355 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x3 | 5986839.02344 | 2113010.76146 | 37.7811641198035 | -122.489190411627 | (37.7811641198035, -122.489190411627) | 11 | 6 | 2 | 55 | 26 | ||
77215 | 99354 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986839.80551 | 2113026.66255 | 37.7812078253097 | -122.489188875507 | (37.7812078253097, -122.489188875507) | 11 | 6 | 2 | 55 | 26 | ||
96888 | 99353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986836.83736 | 2113054.13933 | 37.781283095456 | -122.489201164445 | (37.781283095456, -122.489201164445) | 11 | 6 | 2 | 55 | 26 | ||
149215 | 99352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986835.92891 | 2113074.05562 | 37.7813377268782 | -122.489205771916 | (37.7813377268782, -122.489205771916) | 11 | 6 | 2 | 55 | 26 | ||
121890 | 99351 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986837.32394 | 2113097.90248 | 37.7814032849786 | -122.489202699651 | (37.7814032849786, -122.489202699651) | 11 | 6 | 2 | 55 | 26 | ||
49808 | 99350 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986835.93382 | 2113116.06056 | 37.7814530607414 | -122.489208844148 | (37.7814530607414, -122.489208844148) | 11 | 6 | 2 | 55 | 26 | ||
43550 | 99349 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986833.62785 | 2113132.91132 | 37.781499193517 | -122.489218060865 | (37.781499193517, -122.489218060865) | 11 | 6 | 2 | 55 | 26 | ||
150203 | 99348 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986834.12581 | 2113156.33503 | 37.7815635374039 | -122.489218060874 | (37.7815635374039, -122.489218060874) | 11 | 6 | 2 | 55 | 26 | ||
53024 | 99347 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986832.70752 | 2113173.16715 | 37.7816096708126 | -122.489224205331 | (37.7816096708126, -122.489224205331) | 11 | 6 | 2 | 55 | 26 | ||
102014 | 99346 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 32 | 5x5 | 5986570.64094 | 2113156.51142 | 37.7815486383406 | -122.490129593054 | (37.7815486383406, -122.490129593054) | 11 | 6 | 2 | 55 | 26 | ||
43418 | 99345 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 5986571.27659 | 2113136.01167 | 37.7814923890114 | -122.490125885703 | (37.7814923890114, -122.490125885703) | 11 | 6 | 2 | 55 | 26 | ||
155407 | 99339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3.5x3.5 | 5986576.13047 | 2112991.43823 | 37.7810957151351 | -122.490098456538 | (37.7810957151351, -122.490098456538) | 11 | 6 | 2 | 55 | 26 | ||
125196 | 99337 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5986576.2181 | 2112940.18967 | 37.7809550063526 | -122.490094382689 | (37.7809550063526, -122.490094382689) | 11 | 6 | 2 | 55 | 26 | ||
85465 | 99333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 30 | 4x4 | 5986581.86078 | 2112837.66907 | 37.7806738435833 | -122.490067319136 | (37.7806738435833, -122.490067319136) | 11 | 6 | 2 | 55 | 26 | ||
75990 | 99332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986580.56369 | 2112816.99686 | 37.7806170078534 | -122.490070285368 | (37.7806170078534, -122.490070285368) | 11 | 6 | 2 | 55 | 26 | ||
23426 | 99331 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986581.6367 | 2112796.91447 | 37.7805619300043 | -122.490065095801 | (37.7805619300043, -122.490065095801) | 11 | 6 | 2 | 55 | 26 | ||
170197 | 99330 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 4x4 | 5986582.50919 | 2112777.47658 | 37.780508610058 | -122.490060647344 | (37.780508610058, -122.490060647344) | 11 | 6 | 2 | 55 | 26 | ||
173471 | 99329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5986584.84396 | 2112715.96758 | 37.7803398602424 | -122.490048044897 | (37.7803398602424, -122.490048044897) | 11 | 6 | 2 | 55 | 26 | ||
127671 | 99328 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5986586.09055 | 2112693.96092 | 37.7802795090296 | -122.490042113304 | (37.7802795090296, -122.490042113304) | 11 | 6 | 2 | 55 | 26 | ||
110143 | 99327 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986588.01582 | 2112673.64698 | 37.7802238451734 | -122.490033958427 | (37.7802238451734, -122.490033958427) | 11 | 6 | 2 | 55 | 26 | ||
36069 | 99326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5986588.88353 | 2112653.99552 | 37.7801699385412 | -122.490029510836 | (37.7801699385412, -122.490029510836) | 11 | 6 | 2 | 55 | 26 | ||
44945 | 99261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3099X Polk St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x6 | 6005936.6 | 2121383.7 | 37.8052503240173 | -122.42371770971 | (37.8052503240173, -122.42371770971) | 5 | 1 | 1 | 28858 | 32 | ||
75310 | 99238 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38735 | 6006927 | 2119477 | 37.8000708669817 | -122.420154896537 | (37.8000708669817, -122.420154896537) | 5 | 1 | 1 | 28858 | 32 | ||||
135060 | 99237 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38735 | 6006927 | 2119477 | 37.8000708669817 | -122.420154896537 | (37.8000708669817, -122.420154896537) | 5 | 1 | 1 | 28858 | 32 | ||||
143752 | 992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1674 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6001533.42725 | 2092387.62151 | 37.7253846921419 | -122.436878346162 | (37.7253846921419, -122.436878346162) | 9 | 7 | 6 | 28861 | 25 | |||
37484 | 9910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1850 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005262.94947 | 2116061.61186 | 37.7905991760505 | -122.425669933628 | (37.7905991760505, -122.425669933628) | 13 | 9 | 1 | 28858 | 27 | |||
153602 | 991 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1664 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x4 | 6001564.02343 | 2092454.84645 | 37.7255710154858 | -122.436777388269 | (37.7255710154858, -122.436777388269) | 9 | 7 | 6 | 28861 | 25 | |||
73195 | 9909 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1850 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005266.16067 | 2116037.55632 | 37.7905333070273 | -122.425657110207 | (37.7905333070273, -122.425657110207) | 13 | 9 | 1 | 28858 | 27 | |||
9076 | 9908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.7904229062421 | -122.425793311632 | (37.7904229062421, -122.425793311632) | 13 | 9 | 1 | 28858 | 27 | |||
42921 | 9907 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6005224.35314 | 2116024.07833 | 37.7904939373852 | -122.425800802087 | (37.7904939373852, -122.425800802087) | 13 | 9 | 1 | 28858 | 27 | |||
157968 | 9904 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1801 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2019 09:05:00 AM | 3 | 3X3 | Permit Number 779094 | 6005227.80523 | 2115981.43035 | 37.7903770318133 | -122.425785821167 | (37.7903770318133, -122.425785821167) | 13 | 9 | 1 | 28858 | 27 | |
145877 | 98844 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5986472.5223 | 2103038.1714 | 37.7537607723384 | -122.489724692196 | (37.7537607723384, -122.489724692196) | 1 | 8 | 3 | 56 | 35 | |||
119567 | 98778 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003103.75462 | 2121176.62609 | 37.8045214349813 | -122.433506309391 | (37.8045214349813, -122.433506309391) | 13 | 9 | 1 | 57 | 17 | |||
49708 | 98777 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003095.78209 | 2121157.07886 | 37.8044673110903 | -122.433532501243 | (37.8044673110903, -122.433532501243) | 13 | 9 | 1 | 57 | 17 | |||
2945 | 98684 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014207 | 2094775 | 37.7326521179743 | -122.393233618799 | (37.7326521179743, -122.393233618799) | 10 | 3 | 8 | 58 | 1 | |||||
3496 | 98500 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1670 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990941.3 | 2104038.3 | 37.7567667631156 | -122.474343775715 | (37.7567667631156, -122.474343775715) | 1 | 8 | 4 | 56 | 12 | ||||
9461 | 98346 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1943 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281 | 2108783 | 37.7701597533774 | -122.452761318704 | (37.7701597533774, -122.452761318704) | 15 | 5 | 11 | 29492 | 9 | ||||
57560 | 98311 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 715 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994649.1 | 2090536.3 | 37.7199077277184 | -122.460542569514 | (37.7199077277184, -122.460542569514) | 9 | 8 | 6 | 28861 | 24 | ||||
1919 | 98261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 676 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 776653 | 5981365.73942 | 2111125.46261 | 37.775666650072 | -122.507984958591 | (37.775666650072, -122.507984958591) | 11 | 6 | 2 | 55 | 26 | ||
42549 | 98221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
62704 | 98219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
182423 | 98191 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1060 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 23353 | 6007933.22723 | 2118928.43771 | 37.798621295993 | -122.416634072728 | (37.798621295993, -122.416634072728) | 5 | 1 | 10 | 308 | 32 | |||
146213 | 98190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1060 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 23353 | 6007943.25928 | 2118930.38379 | 37.7986272036522 | -122.416599496497 | (37.7986272036522, -122.416599496497) | 5 | 1 | 10 | 308 | 32 | |||
66404 | 98148 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2495@Ulloa 27th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | Permit Number 768497 | 5987947.1 | 2098339.7 | 37.7409460050834 | -122.484280768936 | (37.7409460050834, -122.484280768936) | 1 | 8 | 3 | 29491 | 35 | |||
134187 | 98147 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2495@Ulloa 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | Permit Number 768497 | 5987947.1 | 2098339.7 | 37.7409460050834 | -122.484280768936 | (37.7409460050834, -122.484280768936) | 1 | 8 | 3 | 29491 | 35 | |||
76269 | 98023 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988265.4 | 2098998.6 | 37.7427736996347 | -122.483228504608 | (37.7427736996347, -122.483228504608) | 1 | 8 | 3 | 29491 | 35 | ||||
50982 | 98022 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988265.4 | 2098998.6 | 37.7427736996347 | -122.483228504608 | (37.7427736996347, -122.483228504608) | 1 | 8 | 3 | 29491 | 35 | ||||
98785 | 98021 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5988202.6314 | 2099008.2014 | 37.7427964094941 | -122.483446241685 | (37.7427964094941, -122.483446241685) | 1 | 8 | 3 | 29491 | 35 | |||
193535 | 98020 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5988217.8603 | 2099007.863 | 37.7427963666772 | -122.483393560294 | (37.7427963666772, -122.483393560294) | 1 | 8 | 3 | 29491 | 35 | |||
42565 | 98009 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400@Taraval 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990522.5 | 2099005.4 | 37.7429234655348 | -122.475424670664 | (37.7429234655348, -122.475424670664) | 1 | 8 | 4 | 29491 | 40 | ||||
174156 | 98008 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400@Taraval 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990522.5 | 2099005.4 | 37.7429234655348 | -122.475424670664 | (37.7429234655348, -122.475424670664) | 1 | 8 | 4 | 29491 | 40 | ||||
41472 | 98007 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400@Taraval 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990522.5 | 2099005.4 | 37.7429234655348 | -122.475424670664 | (37.7429234655348, -122.475424670664) | 1 | 8 | 4 | 29491 | 40 | ||||
35855 | 98006 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400@Taraval 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990522.5 | 2099005.4 | 37.7429234655348 | -122.475424670664 | (37.7429234655348, -122.475424670664) | 1 | 8 | 4 | 29491 | 40 | ||||
148970 | 98005 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1216 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 11315 | 5993346.5 | 2107166.2 | 37.7654942103327 | -122.466253088814 | (37.7654942103327, -122.466253088814) | 11 | 8 | 11 | 56 | 12 | ||||
154118 | 97987 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989682 | 2103145 | 37.7542409615373 | -122.478633523288 | (37.7542409615373, -122.478633523288) | 1 | 8 | 3 | 56 | 35 | ||||
94822 | 97986 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5989638.0679 | 2103147.9021 | 37.7542463791076 | -122.478785662011 | (37.7542463791076, -122.478785662011) | 1 | 8 | 3 | 56 | 35 | |||
101825 | 97903 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 375X Precita Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
190795 | 97750 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
183222 | 97749 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
27612 | 97748 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
1458 | 97747 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
20041 | 97746 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 | ||||
69333 | 97745 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2685 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18001 | 5986960.2 | 2097027.9 | 37.7372866359421 | -122.487596715706 | (37.7372866359421, -122.487596715706) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );