Data source: data.sfgov.org
This data as json, CSV (advanced)
PermitNotes ✖
Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81023 | 81023 | 8805 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5995403.38727 | 2112856.28228 | 37.7812361417982 | -122.459550975813 | (37.7812361417982, -122.459550975813) | |||
81231 | 81231 | 18135 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
81681 | 81681 | 8949 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4800 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | |||
82164 | 82164 | 455 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 740X 23rd Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2015 08:09:00 AM | 3 | 8x100 | 5988822.12971 | 2110252.37193 | 37.773705906735 | -122.482127789493 | (37.773705906735, -122.482127789493) | ||
83074 | 83074 | 109632 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X GENEVA AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.45191286533199 | (37.7226502134341, -122.451912865332) | ||||
83150 | 83150 | 8775 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5996238.3231675 | 2112937.1732278 | 37.7815062207514 | -122.456668379023 | (37.7815062207514, -122.456668379023) | |||
83399 | 83399 | 8774 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5996238.3231675 | 2112937.1732278 | 37.7815062207514 | -122.456668379023 | (37.7815062207514, -122.456668379023) | |||
83770 | 83770 | 9235 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5987194.656872401 | 2112586.3612843 | 37.7800195894976 | -122.48792892082399 | (37.7800195894976, -122.487928920824) | |||
83831 | 83831 | 8840 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4000 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | |||
84592 | 84592 | 18138 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
84653 | 84653 | 811 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X 39th Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
84922 | 84922 | 24815 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1410 Holloway Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/29/1996 12:00:00 AM | 6 | 5X5 | 5991090.406971 | 2091239.8933513002 | 37.721634246792895 | -122.47289489311501 | (37.7216342467929, -122.472894893115) | ||
85809 | 85809 | 18134 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
86679 | 86679 | 30160 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 410X Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
87238 | 87238 | 99735 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Ocean Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.45157991133101 | (37.7230482703916, -122.451579911331) | |||||
88691 | 88691 | 18137 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
90322 | 90322 | 18118 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
90606 | 90606 | 9072 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5600X GEARY BLVD | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8M | 5989606.0 | 2112715.0 | 37.7805131616254 | -122.479596508871 | (37.7805131616254, -122.479596508871) | |||
90792 | 90792 | 14437 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3X Masonic Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 60 | 3X3 | 5998937.7460107 | 2113239.5974234 | 37.782491219087206 | -122.447351485422 | (37.7824912190872, -122.447351485422) | |||
91160 | 91160 | 8855 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4100 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | M6 | 5994282.52273 | 2112814.67509 | 37.7810573856067 | -122.46342556413799 | (37.7810573856067, -122.463425564138) | |||
92203 | 92203 | 14430 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3X Masonic Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998937.7460107 | 2113239.5974234 | 37.782491219087206 | -122.447351485422 | (37.7824912190872, -122.447351485422) | |||
93810 | 93810 | 109633 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X GENEVA AVE | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.45191286533199 | (37.7226502134341, -122.451912865332) | ||||
93833 | 93833 | 109634 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X GENEVA AVE | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.45191286533199 | (37.7226502134341, -122.451912865332) | ||||
94735 | 94735 | 8856 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4100 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5994351.4824043 | 2112844.0169008 | 37.7811419231371 | -122.463189129763 | (37.7811419231371, -122.463189129763) | |||
94764 | 94764 | 5004 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5300 Diamond Heights Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
95547 | 95547 | 24381 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1430 Holloway Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/1995 12:00:00 AM | 6 | 5X5 | 5990969.5329007 | 2091213.2242801997 | 37.7215540216702 | -122.47331077424101 | (37.7215540216702, -122.473310774241) | ||
98581 | 98581 | 8900 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4400 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5993172.426419999 | 2112775.73341 | 37.780886442479 | -122.467263075409 | (37.780886442479, -122.467263075409) | |||
100423 | 100423 | 109667 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
100452 | 100452 | 24387 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1480X Holloway Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/25/1995 12:00:00 AM | 6 | 5X5 | 5990575.8416276 | 2091128.5898468997 | 37.7212988320561 | -122.474665470581 | (37.7212988320561, -122.474665470581) | ||
102882 | 102882 | 8920 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5992929.66523 | 2112766.96396 | 37.7808483471396 | -122.468102259996 | (37.7808483471396, -122.468102259996) | |||
103055 | 103055 | 9242 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6500 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5986804.71401 | 2112545.62602 | 37.779884987759296 | -122.48927489456601 | (37.7798849877593, -122.489274894566) | |||
103407 | 103407 | 3285 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4499X California St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 12 | 5993686.787836 | 2114186.2636062 | 37.784789054514206 | -122.465586165431 | (37.7847890545142, -122.465586165431) | |||
103927 | 103927 | 18121 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
104430 | 104430 | 8876 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4200 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5993972.55334 | 2112803.7488599997 | 37.7810095216138 | -122.464497100676 | (37.7810095216138, -122.464497100676) | |||
105202 | 105202 | 8625 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
105365 | 105365 | 8944 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4800 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | M6 | 5991934.617219999 | 2112728.85524 | 37.7806861953639 | -122.47154180682101 | (37.7806861953639, -122.471541806821) | |||
105911 | 105911 | 109636 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X GENEVA AVE | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997165.4 | 2091482.5 | 37.7226502134341 | -122.45191286533199 | (37.7226502134341, -122.451912865332) | ||||
105968 | 105968 | 18132 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
106374 | 106374 | 8925 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4600 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5992673.34128 | 2112758.83762 | 37.7808112280203 | -122.46898841031 | (37.7808112280203, -122.46898841031) | |||
107564 | 107564 | 8877 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4200 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.46426453234699 | (37.7810917943038, -122.464264532347) | |||
108693 | 108693 | 18131 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
109496 | 109496 | 15077 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 56 Minerva St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996235.7379541 | 2089042.6583919 | 37.7158976903849 | -122.454950277078 | (37.7158976903849, -122.454950277078) | |||
109703 | 109703 | 8953 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5000 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8M | 5991565.8879728 | 2112742.4953614 | 37.780702308642205 | -122.47281840107401 | (37.7807023086422, -122.472818401074) | |||
111303 | 111303 | 8942 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4800 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | M6 | 5991986.82092 | 2112730.95711 | 37.780694986490296 | -122.471361364009 | (37.7806949864903, -122.471361364009) | |||
111356 | 111356 | 109637 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1X Geneva Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6001799.0 | 2091822.0 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | ||||
113009 | 113009 | 14436 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3X Masonic Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998937.7460107 | 2113239.5974234 | 37.782491219087206 | -122.447351485422 | (37.7824912190872, -122.447351485422) | |||
113273 | 113273 | 441 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 700x 23rd Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8x100 | 5988813.91417 | 2110455.50375 | 37.7742631725206 | -122.482171092771 | (37.7742631725206, -122.482171092771) | |||
113296 | 113296 | 18117 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
113665 | 113665 | 24385 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1470 Holloway Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/27/1995 12:00:00 AM | 6 | 5X5 | 5990600.335756 | 2091115.5185597 | 37.7212643608172 | -122.474579848687 | (37.7212643608172, -122.474579848687) | ||
114276 | 114276 | 109670 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
116685 | 116685 | 18120 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
117644 | 117644 | 109629 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
118011 | 118011 | 9272 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6800 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5985876.77214 | 2112514.93268 | 37.779746502555795 | -122.49248275059799 | (37.7797465025558, -122.492482750598) | |||
118059 | 118059 | 24384 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1470 Holloway Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/27/1995 12:00:00 AM | 6 | 5X5 | 5990600.335756 | 2091115.5185597 | 37.7212643608172 | -122.474579848687 | (37.7212643608172, -122.474579848687) | ||
118990 | 118990 | 18133 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
119138 | 119138 | 8918 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/20/1993 12:00:00 AM | 3 | M6 | 5993112.9148542 | 2112800.9475253 | 37.7809522379976 | -122.467470787412 | (37.7809522379976, -122.467470787412) | ||
120008 | 120008 | 9244 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5986755.12461 | 2112543.95379 | 37.779877501504295 | -122.48944632098801 | (37.7798775015043, -122.489446320988) | |||
120214 | 120214 | 91133 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 07/01/2008 12:00:00 AM | 3 | 3x3 | 6005738.144013 | 2094265.9668299998 | 37.730780298312 | -122.42247641656401 | (37.730780298312, -122.422476416564) | ||
120245 | 120245 | 18136 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
120588 | 120588 | 8833 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4000 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5994469.51609 | 2112821.7804400004 | 37.7810876666855 | -122.462779181397 | (37.7810876666855, -122.462779181397) | |||
120945 | 120945 | 9271 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6700 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5986262.7950193 | 2112550.8943707 | 37.7798678050128 | -122.49114999454599 | (37.7798678050128, -122.491149994546) | |||
121510 | 121510 | 18127 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
121681 | 121681 | 18130 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
122049 | 122049 | 8857 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4100 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5994217.54583 | 2112816.74995 | 37.7810593388069 | -122.46365050051399 | (37.7810593388069, -122.463650500514) | |||
122624 | 122624 | 24386 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1480X Holloway Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/1995 12:00:00 AM | 6 | 5X5 | 5990575.8416276 | 2091128.5898468997 | 37.7212988320561 | -122.474665470581 | (37.7212988320561, -122.474665470581) | ||
122680 | 122680 | 3284 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4499X California St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 12 | 5993686.787836 | 2114186.2636062 | 37.784789054514206 | -122.465586165431 | (37.7847890545142, -122.465586165431) | |||
122684 | 122684 | 8878 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4200 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 5993915.74496 | 2112803.5183599996 | 37.7810056138039 | -122.46469361074 | (37.7810056138039, -122.46469361074) | |||
123550 | 123550 | 91134 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400X Trumbull St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6005738.144013 | 2094265.9668299998 | 37.730780298312 | -122.42247641656401 | (37.730780298312, -122.422476416564) | |||
123644 | 123644 | 9237 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5987194.656872401 | 2112586.3612843 | 37.7800195894976 | -122.48792892082399 | (37.7800195894976, -122.487928920824) | |||
125872 | 125872 | 14427 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10X Masonic Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 12 | 5998974.4449529005 | 2113166.8020455004 | 37.782293438909505 | -122.447219282793 | (37.7822934389095, -122.447219282793) | |||
127274 | 127274 | 109638 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1X Geneva Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6001799.0 | 2091822.0 | 37.723846713797 | -122.435919833731 | (37.723846713797, -122.435919833731) | ||||
127556 | 127556 | 8802 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5995518.15698 | 2112860.63855 | 37.7812547016031 | -122.459154247437 | (37.7812547016031, -122.459154247437) | |||
127930 | 127930 | 99737 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Ocean Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.45157991133101 | (37.7230482703916, -122.451579911331) | |||||
127981 | 127981 | 18129 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
128598 | 128598 | 15059 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10X Minerva St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996572.9500165 | 2089038.2134875 | 37.7159048245128 | -122.45378440062001 | (37.7159048245128, -122.45378440062) | |||
129176 | 129176 | 18128 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
129455 | 129455 | 8924 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4600 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5992722.9705 | 2112757.4375299998 | 37.7808102510776 | -122.468816618286 | (37.7808102510776, -122.468816618286) | |||
138984 | 138984 | 8804 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5995465.2471 | 2112858.90023 | 37.7812468867685 | -122.459337162407 | (37.7812468867685, -122.459337162407) | |||
139911 | 139911 | 8954 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5000 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8M | 5991565.8879728 | 2112742.4953614 | 37.780702308642205 | -122.47281840107401 | (37.7807023086422, -122.472818401074) | |||
139946 | 139946 | 24379 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/1995 12:00:00 AM | 6 | 5X5 | 5991161.796471 | 2091241.0154845002 | 37.7216414605593 | -122.47264820285801 | (37.7216414605593, -122.472648202858) | ||
141110 | 141110 | 30159 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 410X Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
141462 | 141462 | 109668 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
143318 | 143318 | 8803 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5995605.0398634 | 2112886.723304 | 37.7813313178006 | -122.458855566555 | (37.7813313178006, -122.458855566555) | |||
143399 | 143399 | 8730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3200 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | M6 | 5997259.3218257995 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | |||
143924 | 143924 | 9260 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6600X GEARY BLVD | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | 8M | 5986507.8 | 2112600.0 | 37.7800169470705 | -122.49030603878799 | (37.7800169470705, -122.490306038788) | |||
145275 | 145275 | 9243 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8M | 5986886.6516554 | 2112572.1737573002 | 37.7799626628655 | -122.48899339188101 | (37.7799626628655, -122.488993391881) | |||
149358 | 149358 | 231440 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101x Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 5ft | 5999772.0505099995 | 2101277.39678 | 37.749693647646104 | -122.44360556645 | (37.7496936476461, -122.44360556645) | |||
152899 | 152899 | 209997 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600x Laguna Honda Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5995563.9847800005 | 2099958.8457299997 | 37.745832339203794 | -122.45806171149799 | (37.7458323392038, -122.458061711498) | |||
153903 | 153903 | 177681 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 0ft | 6011509.97843 | 2090681.5111 | 37.7212620415847 | -122.40227023048901 | (37.7212620415847, -122.402270230489) | |||
161022 | 161022 | 209998 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600x Laguna Honda Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995611.14441 | 2099907.3213400003 | 37.7456935756059 | -122.457894913326 | (37.7456935756059, -122.457894913326) | |||
167731 | 167731 | 177684 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 700x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6009640.77537 | 2090111.56917 | 37.7195925824204 | -122.408691375527 | (37.7195925824204, -122.408691375527) | |||
180119 | 180119 | 177682 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6010419.57085 | 2090347.6649900002 | 37.7202844416499 | -122.406015971566 | (37.7202844416499, -122.406015971566) | |||
183126 | 183126 | 117846 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 620x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 55 | Width 6ft | 5983813.41321 | 2111492.12904 | 37.7768173268114 | -122.49954508796999 | (37.7768173268114, -122.49954508797) | |||
1347 | 1347 | 251504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 620x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5992030.0 | 2103590.0 | 37.7555988620986 | -122.470546036282 | (37.7555988620986, -122.470546036282) | ||||
5104 | 5104 | 253785 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
5106 | 5106 | 253787 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
9890 | 9890 | 3755 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1050 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012450.5971046 | 2103074.0676917997 | 37.7553418567665 | -122.39988853682199 | (37.7553418567665, -122.399888536822) | |||
9909 | 9909 | 173722 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 928 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3x3 | 6012423.0 | 2103596.0 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | |||
10388 | 10388 | 2288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989397.47374 | 2088680.9253 | 37.714509804868605 | -122.47855980688699 | (37.7145098048686, -122.478559806887) | |
10721 | 10721 | 2286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989102.32398 | 2088689.12288 | 37.714515172905294 | -122.4795805509 | (37.7145151729053, -122.4795805509) |
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");