8,758 rows where qSpecies_id = 16 sorted by PlotSize descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);