trees
3,267 rows where qSpecies_id = 67 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );