home / trees

Street_Tree_List

Data source: data.sfgov.org

3,267 rows where qSpecies = 45

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
188 100187 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 217 Montcalm St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
189 100188 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 217 Montcalm St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
247 100251 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 540 Delancey St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6015234.41692 2113622.27838 37.7844597292764 -122.390998376191 (37.7844597292764, -122.390998376191) 6 2 9 28856 6
251 100255 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 1456 08th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 4x4 Permit Number 769196 5993711.5 2105567.7 37.761126200258296 -122.46487454888901 (37.7611262002583, -122.464874548889) 1 8 11 56 12
354 10038 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 360 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   6005474.31982 2106984.12162 37.7656865461171 -122.424292710045 (37.7656865461171, -122.424292710045) 8 4 5 28853 19
397 10043 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 360 Guerrero St 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X3   6005477.51423 2106859.7680900004 37.765345281278 -122.424272816157 (37.765345281278, -122.424272816157) 8 4 5 28853 19
404 10044 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 360 Guerrero St 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 3X3   6005474.87318 2106843.21233 37.7652996739685 -122.424280773353 (37.7652996739685, -122.424280773353) 8 4 5 28853 19
438 10049 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 389 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/09/2003 12:00:00 AM 3 3X3   6005557.377915099 2106729.2709881 37.764991476461894 -122.42398730533002 (37.7649914764619, -122.42398730533) 8 4 5 28853 19
601 100670 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 680X Francisco St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
602 100671 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 680X Francisco St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
603 100672 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 680X Francisco St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
604 100673 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 680X Francisco St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6008043.6 2121019.4 37.804368760788 -122.41640033173 (37.804368760788, -122.41640033173) 5 1 10 308 32
947 101104 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 1580 Noriega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 25190 5989126.9 2103185.1 37.754318820325 -122.480556110859 (37.754318820325, -122.480556110859) 1 8 3 56 35
992 101146 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 455 Arkansas St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6012986.2446099995 2104921.29012 37.7604437737932 -122.398165684193 (37.7604437737932, -122.398165684193) 10 3 8 28856 29
993 101147 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 455 Arkansas St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6012984.94495 2104946.7327099997 37.760513561162 -122.398171964177 (37.760513561162, -122.398171964177) 10 3 8 28856 29
994 101148 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 455 Arkansas St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6012983.73857 2104971.40242 37.760581231566796 -122.39817786733299 (37.7605812315668, -122.398177867333) 10 3 8 28856 29
995 101149 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 455 Arkansas St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x4   6012981.15639 2104998.3662 37.760655124349796 -122.398188689753 (37.7606551243498, -122.398188689753) 10 3 8 28856 29
999 101152 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1400X 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
1000 101153 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1400X 19th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
1001 101154 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1400X 19th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 6x5   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
1002 101155 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1400X 19th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6013491.9 2105242.3 37.7613533485104 -122.396439344349 (37.7613533485104, -122.396439344349) 10 3 8 28856 29
1042 101191 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 328 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994863.0 2106716.0 37.764345459457004 -122.460975263176 (37.764345459457, -122.460975263176) 15 5 11 56 12
1156 101316 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 273 Magellan Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
1207 101370 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 3136 Noriega St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5984248.6802 2102962.4909 37.75342288235571 -122.49740953923401 (37.7534228823557, -122.497409539234) 1 8 3 56 35
1208 101371 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 3136 Noriega St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5984231.0823 2102962.1525 37.7534209217472 -122.49747037058201 (37.7534209217472, -122.497470370582) 1 8 3 56 35
1209 101372 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 3136 Noriega St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   5984213.4843 2102962.4909 37.753420819406706 -122.497531252237 (37.7534208194067, -122.497531252237) 1 8 3 56 35
1210 101373 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 3136 Noriega St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   5984197.9169 2102961.1373 37.7534161902989 -122.49758498684099 (37.7534161902989, -122.497584986841) 1 8 3 56 35
1211 101374 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 3136 Noriega St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   5984176.5964 2102959.4451 37.753410294226605 -122.497658591569 (37.7534102942266, -122.497658591569) 1 8 3 56 35
1690 101971 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 4082 20th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003063.0 2104088.0 37.7575980408955 -122.43242606452401 (37.7575980408955, -122.432426064524) 2 4 5 28862 3
1782 102062 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 26 Bennington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM 4 3x3 Permit Number 769724 6007185.0 2097679.0 37.740233252719705 -122.41771621811701 (37.7402332527197, -122.417716218117) 2 7 7 28859 2
1804 102083 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 714 15th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM 3 3x3 Permit Number 52511 5991334.07902 2110523.03796 37.7745948642856 -122.47345839749201 (37.7745948642856, -122.473458397492) 11 6 2 54 26
1961 102246 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 337 Texas St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x6   6013795.01675 2105505.95048 37.7620941385477 -122.395409453676 (37.7620941385477, -122.395409453676) 10 3 8 28856 29
1968 102252 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 374 Connecticut St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 6x6   6013186.08579 2105322.73493 37.7615571821298 -122.39750267610901 (37.7615571821298, -122.397502676109) 10 3 8 28856 29
2072 102364 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 567 29th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5986874.211680001 2112080.47621 37.7786118751095 -122.489000269726 (37.7786118751095, -122.489000269726) 11 6 2 55 26
2090 102382 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 471-473 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6002995.0 2105507.0 37.7614904180073 -122.432762601795 (37.7614904180073, -122.432762601795) 15 4 5 28862 3
2091 102383 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 471-473 Noe St 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2   01/22/2013 12:00:00 AM 12 3x3 Permit Number 769850 6002995.0 2105507.0 37.7614904180073 -122.432762601795 (37.7614904180073, -122.432762601795) 15 4 5 28862 3
2155 102447 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1001 Clement St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5992369.44663 2113417.7931 37.782602976494296 -122.47008771643999 (37.7826029764943, -122.47008771644) 11 6 2 54 11
2241 102537 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 295X 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5993671.19381 2113641.83475 37.783293301571895 -122.46560054893999 (37.7832933015719, -122.46560054894) 11 6 2 54 11
2242 102538 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 295X Clement St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5994650.9 2113509.7 37.782986953937204 -122.462201593946 (37.7829869539372, -122.462201593946) 11 6 2 54 11
2243 102539 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 295X 07th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993677.6 2113542.9 37.7830220231158 -122.465571196437 (37.7830220231158, -122.465571196437) 11 6 2 54 11
2245 102540 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 295X 07th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   5993671.76443 2113576.34059 37.783113505313004 -122.465593815173 (37.783113505313, -122.465593815173) 11 6 2 54 11
2423 102739 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1249 Shafter Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6016779.4097 2092749.4074 37.7272328159816 -122.384199065737 (37.7272328159816, -122.384199065737) 10 3 8 58 1
2715 103055 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 2301 Noriega St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 29932 5986892.0 2102979.0 37.7536227864704 -122.488269714105 (37.7536227864704, -122.488269714105) 1 8 3 56 35
3085 10345 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 954 Haight St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6001545.3048 2109077.8189 37.7712126807777 -122.43803227825 (37.7712126807777, -122.43803227825) 15 5 11 29492 9
3586 103995 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1410X Hawes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
3587 103996 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1410X Hawes St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
3588 103997 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1410X Hawes St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
3589 103998 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1410X Hawes St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6017134.59054 2092698.10151 37.7271115716676 -122.38296762653 (37.7271115716676, -122.38296762653) 10 3 8 58 1
3590 103999 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1201 Revere Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6017169.9617 2092803.1151 37.727401872803 -122.382852652572 (37.727401872803, -122.382852652572) 10 3 8 58 1
3644 104068 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 596 19th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x7   5990015.48741 2111618.44137 37.777526093835604 -122.47809971950399 (37.7775260938356, -122.478099719504) 11 6 2 55 26
3688 104136 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 342 20th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 5x12   5989675.78614 2113047.57545 37.781430374531496 -122.479379426187 (37.7814303745315, -122.479379426187) 11 6 2 55 26
4050 104557 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 201203 HEARST AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6000007.0 2094313.0 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
4051 104558 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 201203 HEARST AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6000007.0 2094313.0 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
4052 104559 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 201203 HEARST AVE 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6000007.0 2094313.0 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
4054 104560 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 201203 HEARST AVE 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6000007.0 2094313.0 37.7305844621254 -122.442293205182 (37.7305844621254, -122.442293205182) 9 7 4 63 40
4262 104792 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 700 39th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12   Permit Number 771234 5983853.47126 2110973.3906900003 37.775395371596 -122.49936817466299 (37.775395371596, -122.499368174663) 11 6 2 55 26
4263 104793 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 700 39th Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5983853.5987599995 2111004.1266 37.775479771007205 -122.499370005427 (37.7754797710072, -122.499370005427) 11 6 2 55 26
4284 104818 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 700 39th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3 Permit Number 771234 5983853.47864 2110990.25289 37.7754416707598 -122.49936939548401 (37.7754416707598, -122.499369395484) 11 6 2 55 26
4352 104895 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 300 Gonzalez Dr   Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4353 104896 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 302 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4354 104897 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 303 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4360 104901 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 314 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4361 104902 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 332 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4362 104903 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 411 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722) 1 8 4 64 40
4364 104905 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 419 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722) 1 8 4 64 40
4366 104907 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 432 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4373 104913 Significant Tree 4 Callistemon citrinus :: Lemon Bottlebrush 45 608 Gonzalez Dr 1 Front Yard : Yard 4 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4377 104917 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 702 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4378 104918 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 719 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990421.0 2090607.0 37.719857702396 -122.47516265050699 (37.719857702396, -122.475162650507) 1 8 4 64 40
4384 104923 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 767 Gonzalez Dr 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
4430 104971 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 752 Carolina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 770765 6012376.8 2104435.9 37.7590770349231 -122.400239393453 (37.7590770349231, -122.400239393453) 10 3 8 28856 29
4550 105128 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1835 47TH AVE   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774579 5981612.2 2102591.6 37.752249639902296 -122.506499383522 (37.7522496399023, -122.506499383522) 1 8 3 56 35
4806 105459 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1118 WALLER ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6000021.8 2108530.5 37.769623122459706 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
4808 105460 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1118 WALLER ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6000021.8 2108530.5 37.769623122459706 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
4809 105461 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1118 WALLER ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6000021.8 2108530.5 37.769623122459706 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
4810 105462 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1118 WALLER ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6000021.8 2108530.5 37.769623122459706 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
4811 105463 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1118 WALLER ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6000021.8 2108530.5 37.769623122459706 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
4888 105549 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1200 Revere Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6017207.7562 2092857.3745 37.72755294661221 -122.38272576976802 (37.7275529466122, -122.382725769768) 10 3 8 58 1
4890 105550 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1200 Revere Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6017193.2263 2092868.7457 37.727583366960204 -122.382776791229 (37.7275833669602, -122.382776791229) 10 3 8 58 1
4891 105551 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1398X HAWES ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 3x3   6017214.0 2092838.0 37.7275000929711 -122.382702837059 (37.7275000929711, -122.382702837059) 10 3 8 58 1
5214 105958 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1915 Greenwich St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9     6003627.84338 2119315.76937 37.7994417277114 -122.43155972231199 (37.7994417277114, -122.431559722312) 13 9 1 57 17
5436 106213 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1646 35th Ave 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     7     5985329.6566 2104002.0012 37.7563403897038 -122.493747943766 (37.7563403897038, -122.493747943766) 1 8 3 56 35
5767 106611 Significant Tree 4 Callistemon citrinus :: Lemon Bottlebrush 45 1154 Rhode Island St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 4x4   6011908.79849 2103025.7220099997 37.7551788898075 -122.401758852609 (37.7551788898075, -122.401758852609) 10 3 8 28856 29
5779 106628 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 875 CLAYTON ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 6x12   5998657.7 2107117.8 37.7656663268312 -122.44787944236401 (37.7656663268312, -122.447879442364) 15 5 11 29492 9
5827 106700 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 14 HILL ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6006150.8 2103502.0 37.756163630728295 -122.42170556000299 (37.7561636307283, -122.421705560003) 2 4 5 28859 19
5828 106701 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 16 HILL ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6006126.3 2103500.7 37.7561586796345 -122.421790197112 (37.7561586796345, -122.421790197112) 2 4 5 28859 19
5829 106702 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 12 HILL ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 5x5   6006261.1 2103486.1 37.756126192255 -122.421322975472 (37.756126192255, -122.421322975472) 2 4 5 28859 19
5844 106717 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 201X Harkness Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6011633.0362599995 2089278.7671299998 37.7174172599795 -122.401746303446 (37.7174172599795, -122.401746303446) 10 7 8 309 39
6102 107039 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1315 18th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 4x4   6013638.38831 2105678.022 37.762557896460706 -122.39596323371 (37.7625578964607, -122.39596323371) 14 3 8 28856 29
6215 107195 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 1017 CLEMENT ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   5992399.0 2113429.0 37.7826354559957 -122.469986291665 (37.7826354559957, -122.469986291665) 11 6 2 54 11
6579 107624 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 467 Clementina St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6011064.4697 2111919.17259 37.7795511306237 -122.405305061079 (37.7795511306237, -122.405305061079) 14 2 9 28853 34
6588 107634 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 2431 24TH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6011247.3 2102253.3 37.7530210518745 -122.40399216626699 (37.7530210518745, -122.403992166267) 10 4 8 28859 19
6731 10783 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1200X Hudson Ave 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913) 10 3 8 58 1
6784 10788 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1200X Hudson Ave 11 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913) 10 3 8 58 1
6795 10789 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1200X Hudson Ave 12 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913) 10 3 8 58 1
6932 108029 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1308 Hawes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6017326.2062 2092992.2495 37.727929830314295 -122.382325662572 (37.7279298303143, -122.382325662572) 10 3 8 58 1
7146 108263 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 400x ELIZABETH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   6003752.0 2102232.0 37.7525409491736 -122.429910836031 (37.7525409491736, -122.429910836031) 2 4 5 28862 22
7148 108265 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 400x ELIZABETH ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   6003752.0 2102232.0 37.7525409491736 -122.429910836031 (37.7525409491736, -122.429910836031) 2 4 5 28862 22
7149 108266 Undocumented 3 Callistemon citrinus :: Lemon Bottlebrush 45 400x ELIZABETH ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   6003752.0 2102232.0 37.7525409491736 -122.429910836031 (37.7525409491736, -122.429910836031) 2 4 5 28862 22
7376 10850 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 1220X Hudson Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3X4   6017356.4574634 2095156.0177673001 37.7338727832056 -122.382371560842 (37.7338727832056, -122.382371560842) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 88.428ms · Data source: data.sfgov.org