trees
8,758 rows where qSpecies_id = 16 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5115 | 260959 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 9ft | 5996243 | 2114742 | 37.7864620624436 | -122.456782770891 | (37.7864620624436, -122.456782770891) | 11 | 6 | 1 | 54 | 31 | ||||
24043 | 131322 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 11 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 9ft | 5996256.90517 | 2114854.47123 | 37.786771676724 | -122.456742799955 | (37.786771676724, -122.456742799955) | 11 | 6 | 1 | 54 | 31 | |||
103384 | 131323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 12 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 9ft | 5996254.50366 | 2114867.62545 | 37.7868076567964 | -122.456752060266 | (37.7868076567964, -122.456752060266) | 11 | 6 | 1 | 54 | 31 | |||
129096 | 131324 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 14 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 9ft | 5996252.06992 | 2114879.22587 | 37.7868393686989 | -122.456761319676 | (37.7868393686989, -122.456761319676) | 11 | 6 | 1 | 54 | 31 | |||
151194 | 201933 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 190 Boutwell St | 3 | Front Yard : Yard | Tree | Private 2 | 20 | Width 9ft | 6010622.81918 | 2095611.54962 | 37.7347493344117 | -122.405683976059 | (37.7347493344117, -122.405683976059) | 10 | 3 | 8 | 58 | 1 | |||
160825 | 124291 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4401x Cornwall St | 3 | Median : Yard | Tree | DPW 1 | 16 | Width 9ft | 5993813.76372 | 2114194.95027 | 37.7848202285685 | -122.465147505193 | (37.7848202285685, -122.465147505193) | 11 | 6 | 2 | 54 | 11 | |||
173639 | 177584 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 414 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 9ft | 6010519.18521 | 2086688.04681 | 37.7102414461649 | -122.405414040027 | (37.7102414461649, -122.405414040027) | 9 | 7 | 8 | 309 | 39 | |||
15300 | 177686 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1669 Geneva Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003304.44382 | 2087685.74457 | 37.7125748721142 | -122.430420783092 | (37.7125748721142, -122.430420783092) | 9 | 7 | 6 | 28861 | 5 | |||
54270 | 117683 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 8ft | 5982577.24095 | 2112532.61095 | 37.7796015766002 | -122.503898389424 | (37.7796015766002, -122.503898389424) | 11 | 6 | 2 | 55 | 26 | |||
93057 | 210362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 518 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 8ft | 5994414.46458 | 2099738.54069 | 37.7451613217356 | -122.462020587381 | (37.7451613217356, -122.462020587381) | 1 | 8 | 4 | 29491 | 40 | |||
104816 | 193829 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900 Phelps St | 13 | Side Yard : Yard | Tree | Private 2 | 27 | Width 8ft | 6014453.31745 | 2096931.20635 | 37.7385863000185 | -122.392532803946 | (37.7385863000185, -122.392532803946) | 10 | 3 | 8 | 58 | 1 | |||
120517 | 210363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 524 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 8ft | 5994378.09701 | 2099709.41102 | 37.7450792451136 | -122.462144227084 | (37.7450792451136, -122.462144227084) | 1 | 8 | 4 | 29491 | 40 | |||
132678 | 210359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 8ft | 5994454.15108 | 2099778.5902 | 37.7452735724333 | -122.461886262866 | (37.7452735724333, -122.461886262866) | 1 | 8 | 4 | 29491 | 40 | |||
163324 | 177685 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1669 Geneva Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003327.32245 | 2087681.01569 | 37.7125631836054 | -122.430341370261 | (37.7125631836054, -122.430341370261) | 9 | 7 | 6 | 28861 | 5 | |||
163352 | 210361 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 518 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 8ft | 5994425.79046 | 2099752.36975 | 37.7451999449219 | -122.461982427372 | (37.7451999449219, -122.461982427372) | 1 | 8 | 4 | 29491 | 40 | |||
167098 | 210360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 8ft | 5994438.8447 | 2099764.40471 | 37.7452337414512 | -122.461938160916 | (37.7452337414512, -122.461938160916) | 1 | 8 | 4 | 29491 | 40 | |||
182803 | 251004 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 322 Point Lobos Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5981865.04882 | 2112690.30879 | 37.7799926644722 | -122.506373823301 | (37.7799926644722, -122.506373823301) | 11 | 6 | 2 | 55 | 26 | |||
182824 | 177792 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 290x Rolph St | 1 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6001464.09036 | 2088085.72956 | 37.7135687209947 | -122.436810222515 | (37.7135687209947, -122.436810222515) | 9 | 7 | 6 | 28861 | 5 | |||
188521 | 248249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98 Lundy's Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6006859.99776 | 2099020.88579 | 37.7438994766787 | -122.418935096973 | (37.7438994766787, -122.418935096973) | 2 | 7 | 7 | 28859 | 2 | |||
1677 | 259282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
5512 | 259281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
10423 | 259280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
25663 | 124292 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4401x Cornwall St | 2 | Median : Yard | Tree | DPW 1 | 18 | Width 7ft | 5993800.52883 | 2114192.89776 | 37.7848138297402 | -122.465193144089 | (37.7848138297402, -122.465193144089) | 11 | 6 | 2 | 54 | 11 | |||
26653 | 131315 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3805 Sacramento St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 7ft | 5996286.23718 | 2114889.77399 | 37.7868702927873 | -122.456643872732 | (37.7868702927873, -122.456643872732) | 11 | 6 | 1 | 54 | 31 | |||
30066 | 131313 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5996309.37683 | 2114891.39847 | 37.7868760817139 | -122.456563932896 | (37.7868760817139, -122.456563932896) | 11 | 6 | 1 | 54 | 31 | |||
48656 | 131292 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3844 Clay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 7ft | 5996357.59442 | 2115281.49962 | 37.7879499630747 | -122.456425331178 | (37.7879499630747, -122.456425331178) | 11 | 6 | 1 | 54 | 31 | |||
49803 | 193851 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1742 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6014478.00933 | 2096283.42528 | 37.7368089977332 | -122.392402134273 | (37.7368089977332, -122.392402134273) | 10 | 3 | 8 | 58 | 1 | |||
63212 | 232634 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 7ft | 5997131.22485 | 2106727.45092 | 37.7645071590035 | -122.45313097693 | (37.7645071590035, -122.45313097693) | 15 | 5 | 11 | 29492 | 12 | |||
93188 | 131316 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3805 Sacramento St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 5996272.99689 | 2114886.70083 | 37.7868610945112 | -122.456689458461 | (37.7868610945112, -122.456689458461) | 11 | 6 | 1 | 54 | 31 | |||
121314 | 210259 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1498 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 7ft | 5991185.1442 | 2105260.10386 | 37.7601356372635 | -122.473589602878 | (37.7601356372635, -122.473589602878) | 1 | 8 | 4 | 56 | 12 | |||
125952 | 193828 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Phelps St | 4 | : | Tree | Private 2 | 13 | Width 7ft | 6015597.83244 | 2098381.88934 | 37.7426330720665 | -122.388676823979 | (37.7426330720665, -122.388676823979) | 10 | 3 | 8 | 58 | 1 | |||
127445 | 131314 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | |||
128639 | 231273 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 7ft | 6005827.95185 | 2104051.54977 | 37.7576543555849 | -122.42286113503 | (37.7576543555849, -122.42286113503) | 2 | 4 | 5 | 28859 | 19 | |||
2051 | 250522 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5987685.78964 | 2115424.25577 | 37.7878402763649 | -122.486438309599 | (37.7878402763649, -122.486438309599) | 11 | 6 | 1 | 55 | 33 | |||
3330 | 213252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5991927.67162 | 2090111.22138 | 37.7185836258199 | -122.4699185829 | (37.7185836258199, -122.4699185829) | 9 | 8 | 6 | 64 | 24 | |||
4111 | 131305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5997155.69751 | 2115003.89282 | 37.7872335145555 | -122.453644000576 | (37.7872335145555, -122.453644000576) | 11 | 6 | 1 | 54 | 31 | |||
5507 | 122105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 315 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 6ft | 5990861.85286 | 2113260.77662 | 37.7820845839552 | -122.475291822165 | (37.7820845839552, -122.475291822165) | 11 | 6 | 2 | 54 | 26 | |||
11003 | 232475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799 Duncan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001440.92645 | 2099668.37427 | 37.7453706938136 | -122.437719318387 | (37.7453706938136, -122.437719318387) | 2 | 7 | 5 | 63 | 22 | |||
23261 | 193927 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 102 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6016656.21357 | 2095327.44827 | 37.7343047932166 | -122.384804477241 | (37.7343047932166, -122.384804477241) | 10 | 3 | 8 | 58 | 1 | |||
27061 | 131308 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 411 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5997165.67126 | 2114930.38502 | 37.7870322534693 | -122.453604183982 | (37.7870322534693, -122.453604183982) | 11 | 6 | 1 | 54 | 31 | |||
27207 | 131247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3044 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 6ft | 6000507.69667 | 2118799.54155 | 37.7978469617259 | -122.442319425314 | (37.7978469617259, -122.442319425314) | 13 | 9 | 1 | 57 | 17 | |||
29230 | 231271 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 117 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 6005427.23486 | 2103988.58905 | 37.7574588618652 | -122.424242501816 | (37.7574588618652, -122.424242501816) | 2 | 4 | 5 | 28859 | 19 | |||
33933 | 231203 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 27th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6005825.85771 | 2100250.83508 | 37.747218351845 | -122.422598301884 | (37.747218351845, -122.422598301884) | 2 | 7 | 5 | 28859 | 22 | |||
35212 | 131274 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6001259.5494 | 2119728.7209 | 37.8004410660637 | -122.439784463083 | (37.8004410660637, -122.439784463083) | 13 | 9 | 1 | 57 | 17 | |||
38152 | 210371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 580 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 6ft | 5994045.69009 | 2099393.7239 | 37.7441933031867 | -122.46327071969 | (37.7441933031867, -122.46327071969) | 1 | 8 | 4 | 29491 | 40 | |||
39415 | 117673 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7600x Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 23 | Width 6ft | 5983555 | 2112529 | 37.7796491073225 | -122.50051568716 | (37.7796491073225, -122.50051568716) | 11 | 6 | 2 | 55 | 26 | |||
42530 | 246934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 327 Frederick St | 1 | : | Tree | Private 2 | 22 | Width 6ft | 5998433.91472 | 2107557.60959 | 37.7668611389688 | -122.448685143299 | (37.7668611389688, -122.448685143299) | 15 | 5 | 11 | 29492 | 9 | |||
44985 | 210370 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 566 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 6ft | 5994128.20914 | 2099476.39451 | 37.7444250494711 | -122.462991385764 | (37.7444250494711, -122.462991385764) | 1 | 8 | 4 | 29491 | 40 | |||
47350 | 118032 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 87 Shore View Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 6ft | 5984165.42268 | 2112823.29914 | 37.7804929816344 | -122.49842574761 | (37.7804929816344, -122.49842574761) | 11 | 6 | 2 | 55 | 26 | |||
53243 | 231259 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 6ft | 6005519.56128 | 2104619.55288 | 37.7591965535096 | -122.423968067388 | (37.7591965535096, -122.423968067388) | 2 | 4 | 5 | 28859 | 19 | |||
53946 | 177787 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6002029.96459 | 2086740.42997 | 37.7099069684944 | -122.434758217838 | (37.7099069684944, -122.434758217838) | 9 | 7 | 6 | 28861 | 5 | |||
54244 | 131289 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3851 Clay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 6ft | 5996400.52935 | 2115242.07144 | 37.7878441686163 | -122.456273933012 | (37.7878441686163, -122.456273933012) | 11 | 6 | 1 | 54 | 31 | |||
54920 | 193822 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Fairfax Ave | 1 | : | Tree | Private 2 | 15 | Width 6ft | 6015679.27727 | 2098183.69362 | 37.7420933808115 | -122.388381378708 | (37.7420933808115, -122.388381378708) | 10 | 3 | 8 | 58 | 1 | |||
56477 | 177782 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002051.13514 | 2086675.27094 | 37.7097292579622 | -122.434680392291 | (37.7097292579622, -122.434680392291) | 9 | 7 | 6 | 28861 | 5 | |||
59331 | 210367 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 556 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 5994191.24694 | 2099535.29621 | 37.74459040962 | -122.46277768794 | (37.74459040962, -122.46277768794) | 1 | 8 | 4 | 29491 | 40 | |||
62618 | 124044 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 107 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 5992352.09576 | 2114780.57849 | 37.7863438071695 | -122.470247013789 | (37.7863438071695, -122.470247013789) | 11 | 6 | 2 | 54 | 11 | |||
62758 | 210052 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 170 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 5999621.6547 | 2094091.19744 | 37.7299534738595 | -122.443609469514 | (37.7299534738595, -122.443609469514) | 9 | 7 | 4 | 63 | 40 | |||
63040 | 118011 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 37th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 5984411.11276 | 2112748.04652 | 37.7803007642443 | -122.497570245136 | (37.7803007642443, -122.497570245136) | 11 | 6 | 2 | 55 | 26 | |||
63753 | 118012 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5984410.6966 | 2112728.55245 | 37.7802472147894 | -122.497570245124 | (37.7802472147894, -122.497570245124) | 11 | 6 | 2 | 55 | 26 | |||
65485 | 131333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 265 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6002225.92805 | 2121872.37078 | 37.806381921855 | -122.43659393376 | (37.806381921855, -122.43659393376) | 13 | 9 | 1 | 57 | 17 | |||
69872 | 119972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 634 28th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5987253.43236 | 2111593.97128 | 37.7772981958937 | -122.487652666537 | (37.7772981958937, -122.487652666537) | 11 | 6 | 2 | 55 | 26 | |||
70560 | 210365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 534 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 6ft | 5994315.06003 | 2099650.50954 | 37.7449138867781 | -122.462357924904 | (37.7449138867781, -122.462357924904) | 1 | 8 | 4 | 29491 | 40 | |||
73231 | 177788 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6002023.21365 | 2086760.44466 | 37.7099615411737 | -122.434782980643 | (37.7099615411737, -122.434782980643) | 9 | 7 | 6 | 28861 | 5 | |||
74472 | 131307 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 411 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 5997160.58958 | 2114965.32538 | 37.7871278990822 | -122.453624289255 | (37.7871278990822, -122.453624289255) | 11 | 6 | 1 | 54 | 31 | |||
77651 | 194018 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1453 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 6ft | 6016473.83192 | 2096817.21597 | 37.7383853069402 | -122.385538824053 | (37.7383853069402, -122.385538824053) | 10 | 3 | 8 | 58 | 1 | |||
80928 | 118013 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 46 Unnamed 010 | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5984414.93148 | 2112653.07007 | 37.7800402102954 | -122.497550020469 | (37.7800402102954, -122.497550020469) | 11 | 6 | 2 | 55 | 26 | |||
82137 | 210364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 534 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 6ft | 5994324.50153 | 2099658.66361 | 37.7449368194724 | -122.462325869469 | (37.7449368194724, -122.462325869469) | 1 | 8 | 4 | 29491 | 40 | |||
84640 | 177785 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002038.86994 | 2086713.23619 | 37.7098328059114 | -122.434725496011 | (37.7098328059114, -122.434725496011) | 9 | 7 | 6 | 28861 | 5 | |||
95429 | 210366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 538 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 6ft | 5994288.96082 | 2099626.87943 | 37.7448475015253 | -122.462446456853 | (37.7448475015253, -122.462446456853) | 1 | 8 | 4 | 29491 | 40 | |||
96269 | 193827 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Phelps St | 2 | : | Tree | Private 2 | 13 | Width 6ft | 6015556.71066 | 2098326.08175 | 37.7424775567988 | -122.388815117219 | (37.7424775567988, -122.388815117219) | 10 | 3 | 8 | 58 | 1 | |||
102225 | 131306 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 5997158.42232 | 2114987.04292 | 37.7871874054224 | -122.453633356219 | (37.7871874054224, -122.453633356219) | 11 | 6 | 1 | 54 | 31 | |||
104427 | 131642 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 California St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6011264.79438 | 2116619.39305 | 37.7924680239299 | -122.404943073171 | (37.7924680239299, -122.404943073171) | 5 | 1 | 10 | 28857 | 6 | |||
108213 | 231279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 814 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6010153.3708 | 2104365.87305 | 37.7587605261921 | -122.407924164764 | (37.7587605261921, -122.407924164764) | 2 | 4 | 7 | 28859 | 19 | |||
111457 | 177586 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 44 Melra Ct | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 6ft | 6008941.6423 | 2086478.69899 | 37.7095782887729 | -122.410851594747 | (37.7095782887729, -122.410851594747) | 9 | 7 | 8 | 309 | 39 | |||
111642 | 177786 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002034.31049 | 2086727.85439 | 37.709872685436 | -122.434742298935 | (37.709872685436, -122.434742298935) | 9 | 7 | 6 | 28861 | 5 | |||
112515 | 213264 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 412 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993268.14803 | 2089869.94743 | 37.7179985412884 | -122.465267625607 | (37.7179985412884, -122.465267625607) | 9 | 8 | 6 | 64 | 24 | |||
112976 | 131246 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2759 Broderick St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6000062.75843 | 2118080.35254 | 37.7958468901791 | -122.443807334766 | (37.7958468901791, -122.443807334766) | 13 | 9 | 1 | 57 | 17 | |||
113502 | 124038 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 641 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5993491.48434 | 2114824.31362 | 37.7865296989097 | -122.466308232743 | (37.7865296989097, -122.466308232743) | 11 | 6 | 2 | 54 | 11 | |||
114272 | 231204 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 27th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6005794.5833 | 2100249.17319 | 37.7472120242265 | -122.422706328451 | (37.7472120242265, -122.422706328451) | 2 | 7 | 5 | 28859 | 22 | |||
114364 | 231205 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 27th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 6005776.4324 | 2100248.01004 | 37.7472078063944 | -122.422769010297 | (37.7472078063944, -122.422769010297) | 2 | 7 | 5 | 28859 | 22 | |||
114686 | 131596 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 Hyde St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 6007094.87882 | 2120403.74203 | 37.80262492397 | -122.419639759879 | (37.80262492397, -122.419639759879) | 5 | 1 | 1 | 28858 | 32 | |||
115240 | 124337 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 198 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 5995954.81639 | 2112966.46 | 37.781570352551 | -122.457651289638 | (37.781570352551, -122.457651289638) | 11 | 6 | 1 | 54 | 31 | |||
117370 | 209822 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1269 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 6ft | 5994833.16927 | 2106873.1422 | 37.7647752145301 | -122.461089829528 | (37.7647752145301, -122.461089829528) | 15 | 5 | 11 | 56 | 12 | |||
119637 | 246503 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 259 Duncan St | 1 | : | Tree | Private 2 | 12 | Width 6ft | 6004822.9307 | 2099858.69154 | 37.7460849830515 | -122.426038437146 | (37.7460849830515, -122.426038437146) | 2 | 7 | 5 | 63 | 22 | |||
123518 | 177784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002043.43466 | 2086698.87237 | 37.7097936251552 | -122.43470869307 | (37.7097936251552, -122.43470869307) | 9 | 7 | 6 | 28861 | 5 | |||
123615 | 210369 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 566 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 6ft | 5994135.88554 | 2099484.58556 | 37.7444479822058 | -122.462965436724 | (37.7444479822058, -122.462965436724) | 1 | 8 | 4 | 29491 | 40 | |||
124788 | 193939 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 106 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6016645.02974 | 2095616.2669 | 37.7350972128654 | -122.384863257844 | (37.7350972128654, -122.384863257844) | 10 | 3 | 8 | 58 | 1 | |||
127502 | 177587 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 48 Melra Ct | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 6ft | 6008913.30843 | 2086433.54438 | 37.7094527146518 | -122.410946334729 | (37.7094527146518, -122.410946334729) | 9 | 7 | 8 | 309 | 39 | |||
133596 | 120749 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 146 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 5989628.02401 | 2114389.60737 | 37.7851124436917 | -122.479642882311 | (37.7851124436917, -122.479642882311) | 11 | 6 | 2 | 55 | 26 | |||
134792 | 193824 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Fairfax Ave | 3 | : | Tree | Private 2 | 14 | Width 6ft | 6015655.00087 | 2098203.32161 | 37.7421459299858 | -122.388466689285 | (37.7421459299858, -122.388466689285) | 10 | 3 | 8 | 58 | 1 | |||
138096 | 124040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 745 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 5993119.48667 | 2114809.4596 | 37.7864674430363 | -122.467594161184 | (37.7864674430363, -122.467594161184) | 11 | 6 | 2 | 54 | 11 | |||
140789 | 123177 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 751 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 5992859.34123 | 2110345.21172 | 37.7741948090381 | -122.468169321919 | (37.7741948090381, -122.468169321919) | 11 | 6 | 2 | 54 | 11 | |||
144812 | 231463 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6001418.80537 | 2099667.7715 | 37.7453677809127 | -122.437795766163 | (37.7453677809127, -122.437795766163) | 2 | 7 | 5 | 63 | 22 | |||
149759 | 250566 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5118 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 5991156.3355 | 2112754.9084 | 37.7807126740069 | -122.474236132126 | (37.7807126740069, -122.474236132126) | 11 | 6 | 2 | 54 | 26 | |||
153361 | 131641 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 California St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6011247.49311 | 2116619.95686 | 37.7924686048916 | -122.405002976111 | (37.7924686048916, -122.405002976111) | 5 | 1 | 10 | 28857 | 6 | |||
158419 | 210332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 640 Quintara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5991431.77229 | 2101156.95276 | 37.748883739807 | -122.472437508396 | (37.748883739807, -122.472437508396) | 1 | 8 | 4 | 29491 | 12 | |||
159799 | 193825 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Fairfax Ave | 6 | : | Tree | Private 2 | 15 | Width 6ft | 6015596.67696 | 2098247.43003 | 37.7422638104273 | -122.388671435242 | (37.7422638104273, -122.388671435242) | 10 | 3 | 8 | 58 | 1 | |||
160411 | 210368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 560 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 6ft | 5994160.62438 | 2099506.48586 | 37.7445095398745 | -122.462881484091 | (37.7445095398745, -122.462881484091) | 1 | 8 | 4 | 29491 | 40 | |||
161572 | 177783 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002048.25006 | 2086684.24887 | 37.7097537456034 | -122.434691005195 | (37.7097537456034, -122.434691005195) | 9 | 7 | 6 | 28861 | 5 | |||
167283 | 131293 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3830 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 5996455.99061 | 2115295.03805 | 37.7879927842832 | -122.456085879364 | (37.7879927842832, -122.456085879364) | 11 | 6 | 1 | 54 | 31 |
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) );