3,267 rows where qSpecies_id = 67 sorted by TreeID

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)
111037 100187 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 217 Montcalm St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.408692480229 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
168610 100188 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 217 Montcalm St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.408692480229 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
38323 100251 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 540 Delancey St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6015234.41692 2113622.27838 37.7844597292764 -122.390998376191 (37.7844597292764, -122.390998376191) 6 2 9 28856 6
160805 100255 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 1456 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 769196 5993711.5 2105567.7 37.7611262002583 -122.464874548889 (37.7611262002583, -122.464874548889) 1 8 11 56 12
8685 10038 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 360 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005474.31982 2106984.12162 37.7656865461171 -122.424292710045 (37.7656865461171, -122.424292710045) 8 4 5 28853 19
186885 10043 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 360 Guerrero St 6 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005477.51423 2106859.76809 37.765345281278 -122.424272816157 (37.765345281278, -122.424272816157) 8 4 5 28853 19
189420 10044 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 360 Guerrero St 7 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005474.87318 2106843.21233 37.7652996739685 -122.424280773353 (37.7652996739685, -122.424280773353) 8 4 5 28853 19
81383 10049 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 389 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2003 12:00:00 AM 3 3X3   6005557.3779151 2106729.2709881 37.7649914764619 -122.42398730533 (37.7649914764619, -122.42398730533) 8 4 5 28853 19
23377 100670 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
80554 100671 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
138476 100672 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
10172 100673 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 680X Francisco St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
13824 101104 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 1580 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25190 5989126.9 2103185.1 37.754318820325 -122.480556110859 (37.754318820325, -122.480556110859) 1 8 3 56 35
187920 101146 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 455 Arkansas St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6012986.24461 2104921.29012 37.7604437737932 -122.398165684193 (37.7604437737932, -122.398165684193) 10 3 8 28856 29
52172 101147 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 455 Arkansas St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6012984.94495 2104946.73271 37.760513561162 -122.398171964177 (37.760513561162, -122.398171964177) 10 3 8 28856 29
115976 101148 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 455 Arkansas St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6012983.73857 2104971.40242 37.7605812315668 -122.398177867333 (37.7605812315668, -122.398177867333) 10 3 8 28856 29
108514 101149 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 455 Arkansas St 5 Sidewalk: Curb side : Cutout Tree Private 2     13 3x4   6012981.15639 2104998.3662 37.7606551243498 -122.398188689753 (37.7606551243498, -122.398188689753) 10 3 8 28856 29
72789 101152 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
114642 101153 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
37971 101154 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 6x5   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
7441 101155 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1400X 19th St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
84117 101191 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 328 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994863 2106716 37.764345459457 -122.460975263176 (37.764345459457, -122.460975263176) 15 5 11 56 12
170359 101316 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 273 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
120148 101370 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5984248.6802 2102962.4909 37.7534228823557 -122.497409539234 (37.7534228823557, -122.497409539234) 1 8 3 56 35
42177 101371 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   5984231.0823 2102962.1525 37.7534209217472 -122.497470370582 (37.7534209217472, -122.497470370582) 1 8 3 56 35
36905 101372 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984213.4843 2102962.4909 37.7534208194067 -122.497531252237 (37.7534208194067, -122.497531252237) 1 8 3 56 35
44502 101373 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984197.9169 2102961.1373 37.7534161902989 -122.497584986841 (37.7534161902989, -122.497584986841) 1 8 3 56 35
36857 101374 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 3136 Noriega St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984176.5964 2102959.4451 37.7534102942266 -122.497658591569 (37.7534102942266, -122.497658591569) 1 8 3 56 35
99007 101971 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 4082 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003063 2104088 37.7575980408955 -122.432426064524 (37.7575980408955, -122.432426064524) 2 4 5 28862 3
121970 102062 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 26 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM 4 3x3 Permit Number 769724 6007185 2097679 37.7402332527197 -122.417716218117 (37.7402332527197, -122.417716218117) 2 7 7 28859 2
95186 102083 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 714 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/2009 12:00:00 AM 3 3x3 Permit Number 52511 5991334.07902 2110523.03796 37.7745948642856 -122.473458397492 (37.7745948642856, -122.473458397492) 11 6 2 54 26
105729 102246 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 337 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x6   6013795.01675 2105505.95048 37.7620941385477 -122.395409453676 (37.7620941385477, -122.395409453676) 10 3 8 28856 29
125387 102252 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 374 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 6x6   6013186.08579 2105322.73493 37.7615571821298 -122.397502676109 (37.7615571821298, -122.397502676109) 10 3 8 28856 29
138087 102364 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 567 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5986874.21168 2112080.47621 37.7786118751095 -122.489000269726 (37.7786118751095, -122.489000269726) 11 6 2 55 26
130968 102382 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 471-473 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6002995 2105507 37.7614904180073 -122.432762601795 (37.7614904180073, -122.432762601795) 15 4 5 28862 3
186753 102383 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 471-473 Noe St 2 Sidewalk: Property side : Cutout Tree Private 2   01/22/2013 12:00:00 AM 12 3x3 Permit Number 769850 6002995 2105507 37.7614904180073 -122.432762601795 (37.7614904180073, -122.432762601795) 15 4 5 28862 3
135065 102447 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1001 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5992369.44663 2113417.7931 37.7826029764943 -122.47008771644 (37.7826029764943, -122.47008771644) 11 6 2 54 11
143883 102537 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 295X 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5993671.19381 2113641.83475 37.7832933015719 -122.46560054894 (37.7832933015719, -122.46560054894) 11 6 2 54 11
25523 102538 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 295X Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994650.9 2113509.7 37.7829869539372 -122.462201593946 (37.7829869539372, -122.462201593946) 11 6 2 54 11
68932 102539 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 295X 07th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993677.6 2113542.9 37.7830220231158 -122.465571196437 (37.7830220231158, -122.465571196437) 11 6 2 54 11
127798 102540 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 295X 07th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5993671.76443 2113576.34059 37.783113505313 -122.465593815173 (37.783113505313, -122.465593815173) 11 6 2 54 11
192395 102739 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1249 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016779.4097 2092749.4074 37.7272328159816 -122.384199065737 (37.7272328159816, -122.384199065737) 10 3 8 58 1
27200 103055 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 2301 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 29932 5986892 2102979 37.7536227864704 -122.488269714105 (37.7536227864704, -122.488269714105) 1 8 3 56 35
176399 10345 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 954 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6001545.3048 2109077.8189 37.7712126807777 -122.43803227825 (37.7712126807777, -122.43803227825) 15 5 11 29492 9
92814 103995 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1410X Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
180005 103996 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1410X Hawes St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
39661 103997 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1410X Hawes St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
84748 103998 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1410X Hawes St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
107964 103999 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1201 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6017169.9617 2092803.1151 37.727401872803 -122.382852652572 (37.727401872803, -122.382852652572) 10 3 8 58 1
55686 104068 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 596 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       6x7   5990015.48741 2111618.44137 37.7775260938356 -122.478099719504 (37.7775260938356, -122.478099719504) 11 6 2 55 26
118716 104136 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 342 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 5x12   5989675.78614 2113047.57545 37.7814303745315 -122.479379426187 (37.7814303745315, -122.479379426187) 11 6 2 55 26
127485 104557 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 201203 HEARST AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6000007 2094313 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
140953 104558 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 201203 HEARST AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6000007 2094313 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
77990 104559 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 201203 HEARST AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6000007 2094313 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
104600 104560 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 201203 HEARST AVE 5 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6000007 2094313 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
133138 104792 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 700 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12   Permit Number 771234 5983853.47126 2110973.39069 37.775395371596 -122.499368174663 (37.775395371596, -122.499368174663) 11 6 2 55 26
128751 104793 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 700 39th Ave   Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5983853.59876 2111004.1266 37.7754797710072 -122.499370005427 (37.7754797710072, -122.499370005427) 11 6 2 55 26
130941 104818 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 700 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 771234 5983853.47864 2110990.25289 37.7754416707598 -122.499369395484 (37.7754416707598, -122.499369395484) 11 6 2 55 26
46292 104895 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 300 Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
119556 104896 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 302 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4569 104897 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 303 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
68086 104901 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 314 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
86867 104902 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 332 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
152262 104903 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 411 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
83428 104905 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 419 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
93915 104907 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 432 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
104010 104913 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 608 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
131974 104917 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 702 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
57324 104918 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 719 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990421 2090607 37.719857702396 -122.475162650507 (37.719857702396, -122.475162650507) 1 8 4 64 40
65749 104923 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 767 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
40812 104971 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 752 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770765 6012376.8 2104435.9 37.7590770349231 -122.400239393453 (37.7590770349231, -122.400239393453) 10 3 8 28856 29
170081 105128 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1835 47TH AVE   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774579 5981612.2 2102591.6 37.7522496399023 -122.506499383522 (37.7522496399023, -122.506499383522) 1 8 3 56 35
153864 105459 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1118 WALLER ST 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000021.8 2108530.5 37.7696231224597 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
166132 105460 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1118 WALLER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000021.8 2108530.5 37.7696231224597 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
23402 105461 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1118 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000021.8 2108530.5 37.7696231224597 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
147202 105462 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1118 WALLER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000021.8 2108530.5 37.7696231224597 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
55032 105463 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1118 WALLER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6000021.8 2108530.5 37.7696231224597 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
168064 105549 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1200 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6017207.7562 2092857.3745 37.7275529466122 -122.382725769768 (37.7275529466122, -122.382725769768) 10 3 8 58 1
44911 105550 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1200 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6017193.2263 2092868.7457 37.7275833669602 -122.382776791229 (37.7275833669602, -122.382776791229) 10 3 8 58 1
10420 105551 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1398X HAWES ST 3 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6017214 2092838 37.7275000929711 -122.382702837059 (37.7275000929711, -122.382702837059) 10 3 8 58 1
119217 105958 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1915 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     9     6003627.84338 2119315.76937 37.7994417277114 -122.431559722312 (37.7994417277114, -122.431559722312) 13 9 1 57 17
175148 106213 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1646 35th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7     5985329.6566 2104002.0012 37.7563403897038 -122.493747943766 (37.7563403897038, -122.493747943766) 1 8 3 56 35
168413 106611 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 1154 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6011908.79849 2103025.72201 37.7551788898075 -122.401758852609 (37.7551788898075, -122.401758852609) 10 3 8 28856 29
77521 106628 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 875 CLAYTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 6x12   5998657.7 2107117.8 37.7656663268312 -122.447879442364 (37.7656663268312, -122.447879442364) 15 5 11 29492 9
50892 106700 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 14 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006150.8 2103502 37.7561636307283 -122.421705560003 (37.7561636307283, -122.421705560003) 2 4 5 28859 19
160472 106701 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 16 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6006126.3 2103500.7 37.7561586796345 -122.421790197112 (37.7561586796345, -122.421790197112) 2 4 5 28859 19
73254 106702 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 12 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 5x5   6006261.1 2103486.1 37.756126192255 -122.421322975472 (37.756126192255, -122.421322975472) 2 4 5 28859 19
40624 106717 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 201X Harkness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6011633.03626 2089278.76713 37.7174172599795 -122.401746303446 (37.7174172599795, -122.401746303446) 10 7 8 309 39
127329 107039 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1315 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 4x4   6013638.38831 2105678.022 37.7625578964607 -122.39596323371 (37.7625578964607, -122.39596323371) 14 3 8 28856 29
80636 107195 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1017 CLEMENT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5992399 2113429 37.7826354559957 -122.469986291665 (37.7826354559957, -122.469986291665) 11 6 2 54 11
17841 107624 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 467 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011064.4697 2111919.17259 37.7795511306237 -122.405305061079 (37.7795511306237, -122.405305061079) 14 2 9 28853 34
298 107634 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 2431 24TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6011247.3 2102253.3 37.7530210518745 -122.403992166267 (37.7530210518745, -122.403992166267) 10 4 8 28859 19
1578 10783 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1200X Hudson Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x4   6017715.9911991 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913) 10 3 8 58 1
10973 10788 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1200X Hudson Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x4   6017715.9911991 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913) 10 3 8 58 1
35428 10789 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1200X Hudson Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x4   6017715.9911991 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913) 10 3 8 58 1
31212 108029 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1308 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6017326.2062 2092992.2495 37.7279298303143 -122.382325662572 (37.7279298303143, -122.382325662572) 10 3 8 58 1
43011 108263 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 400x ELIZABETH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003752 2102232 37.7525409491736 -122.429910836031 (37.7525409491736, -122.429910836031) 2 4 5 28862 22
132745 108265 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 400x ELIZABETH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003752 2102232 37.7525409491736 -122.429910836031 (37.7525409491736, -122.429910836031) 2 4 5 28862 22
122150 108266 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 400x ELIZABETH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003752 2102232 37.7525409491736 -122.429910836031 (37.7525409491736, -122.429910836031) 2 4 5 28862 22
77427 10850 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1220X Hudson Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X4   6017356.4574634 2095156.0177673 37.7338727832056 -122.382371560842 (37.7338727832056, -122.382371560842) 10 3 8 58 1

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