Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186005 | 186005 | 227076 | Undocumented 2 | Lagerstroemia spp :: Crape myrtle species 562 | 35 Yukon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000264.72064 | 2104678.20499 | 37.7590595255837 | -122.442145988358 | (37.7590595255837, -122.442145988358) | |||
185862 | 185862 | 232267 | Undocumented 2 | Moringa oleifera :: Drumstick tree 561 | 38 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009278.96363 | 2097829.67893 | 37.7407645965011 | -122.41048674157801 | (37.7407645965011, -122.410486741578) | |||
185138 | 185138 | 227078 | Undocumented 2 | Lagerstroemia x 'Tuscarora' :: Tuscarora Crape Myrtle 560 | 139 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005638.73494 | 2099902.37732 | 37.7462510077934 | -122.42322059318 | (37.7462510077934, -122.42322059318) | |||
184767 | 184767 | 234869 | Undocumented 2 | Populus deltoides :: Eastern cottonwood 559 | 483 Valley St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 6002812.524730001 | 2099166.42238 | 37.7440703451703 | -122.432940705074 | (37.7440703451703, -122.432940705074) | ||||
184389 | 184389 | 246328 | Undocumented 2 | Eucalyptus citriodora :: Lemon scented eucalyptus 558 | 1735 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6006779.179 | 2108213.1723 | 37.76913482316721 | -122.419866697495 | (37.7691348231672, -122.419866697495) | |||
179168 | 179168 | 247007 | Undocumented 2 | Callistemon salignus :: White flowering bottlebrush 557 | 401 Valley St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6003259.67301 | 2099184.77085 | 37.744146077987 | -122.431395876644 | (37.744146077987, -122.431395876644) | |||
178973 | 178973 | 222747 | Undocumented 2 | Cedrela fissilis :: Argentine cedar 556 | 131 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005909.4208 | 2106484.7834799998 | 37.764340040684296 | -122.422752299085 | (37.7643400406843, -122.422752299085) | |||
170666 | 170666 | 187858 | Undocumented 2 | Acer platanoides :: Norway Maple 554 | 550 Missouri St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6013512.81245 | 2104486.93396 | 37.7592804422575 | -122.39631407184099 | (37.7592804422575, -122.396314071841) | ||||
170201 | 170201 | 243956 | Undocumented 2 | Wodyetia bifurcata :: Foxtail palm 553 | 1374 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010321.8959800005 | 2101296.94026 | 37.7503433529628 | -122.407125000243 | (37.7503433529628, -122.407125000243) | |||
166103 | 166103 | 248402 | Undocumented 2 | Arbutus menziesii :: Pacific Madrone 551 | 701 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997566.8136 | 2108099.9902 | 37.7683007569323 | -122.45172341954999 | (37.7683007569323, -122.45172341955) | |||
173140 | 173140 | 248498 | Undocumented 2 | Arbutus menziesii :: Pacific Madrone 551 | 156 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998302.5369 | 2107853.4873 | 37.7676660307619 | -122.449160873661 | (37.7676660307619, -122.449160873661) | |||
162882 | 162882 | 220117 | Undocumented 2 | Acacia iteaphylla :: Willow wattle 550 | 1200 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010017.12435 | 2102145.65843 | 37.7526566844658 | -122.408238779095 | (37.7526566844658, -122.408238779095) | |||
180948 | 180948 | 188541 | Undocumented 2 | Acacia iteaphylla :: Willow wattle 550 | 1201 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6014304.71414 | 2104773.92766 | 37.7601124986177 | -122.393595357466 | (37.7601124986177, -122.393595357466) | |||
162156 | 162156 | 193474 | Undocumented 2 | Mangifera indica :: Mango 549 | 1310 Indiana St | 25 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014936.17409 | 2102358.6880200002 | 37.7535158347022 | -122.391242588881 | (37.7535158347022, -122.391242588881) | ||||
161504 | 161504 | 225137 | Undocumented 2 | Cercocarpus betuloides :: Mountain mahogany 548 | 1101 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004725.51952 | 2096307.5135400002 | 37.736328750759796 | -122.42612250576 | (37.7363287507598, -122.42612250576) | ||||
160329 | 160329 | 118189 | Undocumented 2 | Pinus sylvestris :: Scots Pine 546 | 806 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5985428.5638 | 2110364.72057 | 37.773816419818296 | -122.493874773697 | (37.7738164198183, -122.493874773697) | |||
155559 | 155559 | 188839 | Undocumented 2 | Brachychiton rupestris :: Narrow-leaf bottle tree 545 | 1754 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014336.85502 | 2094986.79308 | 37.7332408718702 | -122.392799486222 | (37.7332408718702, -122.392799486222) | |||
168155 | 168155 | 188838 | Undocumented 2 | Brachychiton rupestris :: Narrow-leaf bottle tree 545 | 1639 Kirkwood Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6014968.28203 | 2096897.0990000002 | 37.738521233155204 | -122.39074990519501 | (37.7385212331552, -122.390749905195) | |||
154172 | 154172 | 187565 | Undocumented 2 | Beaucarnea recurvata :: Ponytail palm 544 | 136 Alpha St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6010916.99184 | 2088120.11863 | 37.714195861437794 | -122.404139852688 | (37.7141958614378, -122.404139852688) | |||
167381 | 167381 | 187566 | Undocumented 2 | Beaucarnea recurvata :: Ponytail palm 544 | 136 Alpha St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6010914.5006 | 2088119.67508 | 37.7141945043399 | -122.404148432227 | (37.7141945043399, -122.404148432227) | |||
186930 | 186930 | 188812 | Undocumented 2 | Beaucarnea recurvata :: Ponytail palm 544 | 2211 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012100.78981 | 2101856.17323 | 37.7519782763782 | -122.40101271476601 | (37.7519782763782, -122.401012714766) | ||||
153481 | 153481 | 136057 | Undocumented 2 | Pseudopanax lessonii :: Five finger 543 | 331 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998559.644719999 | 2115379.19074 | 37.7883443679496 | -122.448813707713 | (37.7883443679496, -122.448813707713) | |||
150767 | 150767 | 131244 | Undocumented 2 | Meryta sinclairii :: Puka or puke tree 542 | 2770 Green St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999801.9058 | 2117795.56718 | 37.795050062951496 | -122.44468945095899 | (37.7950500629515, -122.444689450959) | |||
161876 | 161876 | 116755 | Undocumented 2 | Meryta sinclairii :: Puka or puke tree 542 | 601x Wisconsin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012732.7732 | 2104597.96658 | 37.7595418769705 | -122.39901963633999 | (37.7595418769705, -122.39901963634) | |||
147432 | 147432 | 248427 | Undocumented 2 | Acer campestre :: Hedge Maple 541 | 730 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999078.0822 | 2108014.2896 | 37.768151880704 | -122.44648994003401 | (37.768151880704, -122.446489940034) | |||
136308 | 136308 | 223353 | Undocumented 2 | Dypsis decaryi :: Triangle palm 536 | 476 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002943.03103 | 2105483.62599 | 37.7614232910681 | -122.432940670896 | (37.7614232910681, -122.432940670896) | |||
136054 | 136054 | 191713 | Undocumented 2 | Erythrina caffra :: Coral tree 535 | 601 Wisconsin St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6012726.33226 | 2104665.52893 | 37.759727029402704 | -122.399046654695 | (37.7597270294027, -122.399046654695) | |||
133988 | 133988 | 221178 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1101 San Jose Ave | 68 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005051.84205 | 2096632.8627099998 | 37.7372405248233 | -122.425017413417 | (37.7372405248233, -122.425017413417) | |||
163433 | 163433 | 205609 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1484 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5991184.61852 | 2105324.79706 | 37.760313237173 | -122.47359614005899 | (37.760313237173, -122.473596140059) | |||
180475 | 180475 | 188232 | Undocumented 2 | Arbutus unedo 'Compacta' :: Dwarf strawberry tree 534 | 1498 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014336.19933 | 2102024.0819200003 | 37.7525637629087 | -122.39329403420601 | (37.7525637629087, -122.393294034206) | |||
133932 | 133932 | 197368 | Undocumented 2 | Rhopalostylis sapida :: Nikau palm 533 | 601 Wisconsin St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6012729.08438 | 2104643.98882 | 37.759668038361504 | -122.399035624504 | (37.7596680383615, -122.399035624504) | |||
128807 | 128807 | 102796 | Undocumented 2 | Magnolia grandiflora 'Timeless Beauty' :: Timeless Beauty Southern Magnolia 531 | 536 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002890.0 | 2102715.0 | 37.753818298827206 | -122.43292628008001 | (37.7538182988272, -122.43292628008) | ||||
122921 | 122921 | 106507 | Undocumented 2 | Ceanothus thyrsiflorus :: Blueblossom Ceanothus 529 | 50 FANNING WAY | Front Yard : Yard 7 | Tree 1 | Private 1 | 5991716.2 | 2101233.1 | 37.749109278682795 | -122.471459514348 | (37.7491092786828, -122.471459514348) | ||||||
122731 | 122731 | 104778 | Undocumented 2 | Ulmus parvifolia 'Athena' :: Chinese Elm 'Athena' 528 | 736 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002380.5 | 2103803.5 | 37.7567781475012 | -122.434766079383 | (37.7567781475012, -122.434766079383) | |||
165189 | 165189 | 215574 | Undocumented 2 | Ulmus procera :: English Elm 527 | 637 Detroit St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5999417.56245 | 2095197.50098 | 37.732979482112 | -122.444394512913 | (37.732979482112, -122.444394512913) | |||
131449 | 131449 | 120240 | Undocumented 2 | Chionanthus retusa :: Chinese Fringe Tree 526 | 288 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5988397.12224 | 2114058.72928 | 37.7841323663842 | -122.483877094997 | (37.7841323663842, -122.483877094997) | |||
155426 | 155426 | 190034 | Undocumented 2 | Chionanthus retusa :: Chinese Fringe Tree 526 | 594 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012963.9697199995 | 2104277.8254 | 37.7586757201207 | -122.398197577755 | (37.7586757201207, -122.398197577755) | |||
161922 | 161922 | 225212 | Undocumented 2 | Chionanthus retusa :: Chinese Fringe Tree 526 | 1357 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007181.04871 | 2107590.64768 | 37.76744814894921 | -122.41843250275801 | (37.7674481489492, -122.418432502758) | |||
162265 | 162265 | 227077 | Undocumented 2 | Lagerstroemia indica 'Natchez' :: Natchez Crape Myrtle 525 | 644 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007449.2504900005 | 2105879.4887599996 | 37.7627648007686 | -122.417383547038 | (37.7627648007686, -122.417383547038) | |||
112157 | 112157 | 122695 | Undocumented 2 | Acer saccharum :: Sugar Maple 522 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | ||||
109005 | 109005 | 99791 | Undocumented 2 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 520 | 4120-4124 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 6002399.0 | 2101817.0 | 37.7513247429435 | -122.43456006421499 | (37.7513247429435, -122.434560064215) | ||||
122132 | 122132 | 99793 | Undocumented 2 | Prunus serrulata 'Double Pink Weeping' :: Weeping Double Pink Flowering Cherry 520 | 4120-4124 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002399.0 | 2101817.0 | 37.7513247429435 | -122.43456006421499 | (37.7513247429435, -122.434560064215) | ||||
103902 | 103902 | 112152 | Undocumented 2 | Chorisia speciosa :: Silk Floss Tree 514 | 299x SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | ||||
105186 | 105186 | 113783 | Undocumented 2 | Chorisia speciosa :: Silk Floss Tree 514 | 1188 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6008033.0 | 2101004.0 | 37.7494106463882 | -122.41501945132 | (37.7494106463882, -122.41501945132) | |||
140878 | 140878 | 107632 | Undocumented 2 | Chorisia speciosa :: Silk Floss Tree 514 | 814 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010397.84183 | 2104391.4418 | 37.758844416174 | -122.407080469655 | (37.758844416174, -122.407080469655) | |||
101864 | 101864 | 122731 | Undocumented 2 | Citrus × limon 'Lisbon' :: Lisbon Lemon Tree 513 | 310 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003508.0 | 2106439.0 | 37.7640785470532 | -122.431054869188 | (37.7640785470532, -122.431054869188) | |||
96007 | 96007 | 102903 | Undocumented 2 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6002396.0 | 2104853.0 | 37.7596607018428 | -122.43478752318701 | (37.7596607018428, -122.434787523187) | |||
120962 | 120962 | 108073 | Undocumented 2 | Garrya elliptica 'Evie' :: Evie Coast Silktassel Tree 505 | 101 BUENA VISTA AVE EAST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001336.0 | 2108482.0 | 37.769564805176394 | -122.438713569331 | (37.7695648051764, -122.438713569331) | ||||
92918 | 92918 | 110864 | Undocumented 2 | Aesculus spp :: Horsechestnut 504 | 1798x 22ND ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6012787.0 | 2103832.0 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | |||||
143095 | 143095 | 99561 | Undocumented 2 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 418 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002462.0 | 2100938.0 | 37.748914793116995 | -122.434279368207 | (37.748914793117, -122.434279368207) | |||||
87731 | 87731 | 109029 | Undocumented 2 | Melaleuca leucadendron :: Weeping Tea Tree 497 | 923 CAPP ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007430.9 | 2101912.0 | 37.7518699557381 | -122.417165865844 | (37.7518699557381, -122.417165865844) | |||||
87008 | 87008 | 108240 | Undocumented 2 | Prunus serrula :: Birchbark Cherry 495 | 163 DELMAR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5999383.5 | 2107248.1 | 37.766065556669396 | -122.445378437485 | (37.7660655566694, -122.445378437485) | |||
101029 | 101029 | 122389 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 166 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991334.0 | 2104180.0 | 37.7571785771329 | -122.47299602104601 | (37.7571785771329, -122.472996021046) | ||||
101496 | 101496 | 117093 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
102296 | 102296 | 117095 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 2X 09TH AVE | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | |||
103462 | 103462 | 106338 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
145290 | 145290 | 106337 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
85592 | 85592 | 111045 | Undocumented 2 | Acer pseudoplatanus :: Sycamore Maple 488 | 400x BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004666.0 | 2109838.0 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | ||||
87709 | 87709 | 111046 | Undocumented 2 | Acer pseudoplatanus :: Sycamore Maple 488 | 400x BUCHANAN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004666.0 | 2109838.0 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | ||||
104529 | 104529 | 111048 | Undocumented 2 | Acer pseudoplatanus :: Sycamore Maple 488 | 400x BUCHANAN ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004666.0 | 2109838.0 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | ||||
138715 | 138715 | 111047 | Undocumented 2 | Acer pseudoplatanus :: Sycamore Maple 488 | 400x BUCHANAN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004666.0 | 2109838.0 | 37.7734769308436 | -122.42729182472 | (37.7734769308436, -122.42729182472) | ||||
171569 | 171569 | 187859 | Undocumented 2 | Acer pseudoplatanus :: Sycamore Maple 488 | 801 Arkansas St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6013056.7920699995 | 2103769.18964 | 37.7572842872596 | -122.39784087518 | (37.7572842872596, -122.39784087518) | ||||
117144 | 117144 | 192174 | Undocumented 2 | Fortunella margarita :: Kumquat 486 | 170 Venus St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012806.8459 | 2094069.7860400002 | 37.7306378606291 | -122.39802487285101 | (37.7306378606291, -122.398024872851) | |||
135347 | 135347 | 176478 | Undocumented 2 | Fortunella margarita :: Kumquat 486 | 44 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6002686.439069999 | 2087042.3982900002 | 37.7107733564667 | -122.432510875004 | (37.7107733564667, -122.432510875004) | |||
158915 | 158915 | 192175 | Undocumented 2 | Fortunella margarita :: Kumquat 486 | 1508 Quint St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6013162.6398599995 | 2096311.8698099998 | 37.7368139691889 | -122.396951969064 | (37.7368139691889, -122.396951969064) | |||
84560 | 84560 | 103946 | Undocumented 2 | Ilex opaca :: American Holly 484 | 243 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x3 | Permit Number 770210 | 6008640.0 | 2097502.0 | 37.739829020043295 | -122.41267288548401 | (37.7398290200433, -122.412672885484) | ||
159105 | 159105 | 249960 | Undocumented 2 | Ilex opaca :: American Holly 484 | 273 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011557.47515 | 2120068.82812 | 37.801955696153 | -122.40417326248999 | (37.801955696153, -122.40417326249) | |||
116955 | 116955 | 107434 | Undocumented 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 3169 WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999560.6 | 2115983.6 | 37.7900611064648 | -122.44539405336 | (37.7900611064648, -122.44539405336) | |||||
167266 | 167266 | 239563 | Undocumented 2 | Sambucus mexicana :: Blue Elderberry 480 | 51 13th St | 6 | : 4 | Tree 1 | Private 1 | 19 | Width 5ft | 6008200.43388 | 2108278.8287 | 37.7693950660465 | -122.414955290262 | (37.7693950660465, -122.414955290262) | |||
178977 | 178977 | 197475 | Undocumented 2 | Sambucus mexicana :: Blue Elderberry 480 | 1900 19th St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012041.1357 | 2105142.55363 | 37.760998626697294 | -122.40144994987 | (37.7609986266973, -122.40144994987) | ||||
82737 | 82737 | 106281 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 2 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
95834 | 95834 | 106280 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
119057 | 119057 | 106282 | Undocumented 2 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 474 | 399X Elliot St | 3 | Unaccepted Street : Yard 14 | Tree 1 | Rec/Park 3 | Permit Number 772905 | 6008798.75873 | 2088103.6204900001 | 37.7140319762934 | -122.41146014936301 | (37.7140319762934, -122.411460149363) | ||||
81570 | 81570 | 103674 | Undocumented 2 | Castanea dentata :: American Chestnut 471 | 3141 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008036.0 | 2102674.0 | 37.7539962579222 | -122.41512727180599 | (37.7539962579222, -122.415127271806) | ||||
141434 | 141434 | 106171 | Undocumented 2 | Tilia spp :: Linden 470 | 2521 19TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774749 | 6010356.3 | 2105009.4 | 37.7605388656214 | -122.40726770344601 | (37.7605388656214, -122.407267703446) | |
114847 | 114847 | 108140 | Undocumented 2 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 3390x 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006957.7 | 2105612.4 | 37.7620037686995 | -122.41906470461399 | (37.7620037686995, -122.419064704614) | ||||
94337 | 94337 | 114188 | Undocumented 2 | New Zealand Tea Tree :: New Zealand Tea Tree 466 | 2200 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x6 | 5997096.0 | 2109871.0 | 37.7731365175856 | -122.45347979574801 | (37.7731365175856, -122.453479795748) | ||||
144707 | 144707 | 115633 | Undocumented 2 | New Zealand Tea Tree :: New Zealand Tea Tree 466 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x9 | 6000786.8 | 2104618.2 | 37.7589245060719 | -122.44033609165001 | (37.7589245060719, -122.44033609165) | ||||
79691 | 79691 | 108875 | Undocumented 2 | Eucalyptus microtheca :: Flooded Box: Coolibah 465 | 240X NORIEGA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.46610704085501 | (37.7547470014972, -122.466107040855) | ||||
82268 | 82268 | 108877 | Undocumented 2 | Eucalyptus microtheca :: Flooded Box: Coolibah 465 | 240X NORIEGA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.46610704085501 | (37.7547470014972, -122.466107040855) | ||||
114098 | 114098 | 105750 | Undocumented 2 | Eucalyptus microtheca :: Flooded Box: Coolibah 465 | 240X NORIEGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.46610704085501 | (37.7547470014972, -122.466107040855) | |||
117499 | 117499 | 108876 | Undocumented 2 | Eucalyptus microtheca :: Flooded Box: Coolibah 465 | 240X NORIEGA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993306.5 | 2103252.9 | 37.7547470014972 | -122.46610704085501 | (37.7547470014972, -122.466107040855) | ||||
80032 | 80032 | 105543 | Undocumented 2 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 123 SOUTH VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6007367.5 | 2109091.5 | 37.771579629731704 | -122.417893993822 | (37.7715796297317, -122.417893993822) | |||
77975 | 77975 | 106185 | Undocumented 2 | Gleditsia triacanthos 'Aurea' :: Honey Locust 'Aurea' 456 | 1349 ULLOA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 5991806.5 | 2098368.4 | 37.741248771742896 | -122.470938602248 | (37.7412487717429, -122.470938602248) | |||
105124 | 105124 | 106186 | Undocumented 2 | Gleditsia triacanthos 'Aurea' :: Honey Locust 'Aurea' 456 | 1349 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 5991806.5 | 2098368.4 | 37.741248771742896 | -122.470938602248 | (37.7412487717429, -122.470938602248) | |||
75026 | 75026 | 199509 | Undocumented 2 | Quercus engelmannii :: Engelmann oak 453 | 800 19th St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6015055.67161 | 2105341.31512 | 37.7617121209521 | -122.39103778987 | (37.7617121209521, -122.39103778987) | |||
153814 | 153814 | 199510 | Undocumented 2 | Quercus engelmannii :: Engelmann oak 453 | 1 01st St | 14 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014434.26374 | 2105920.54159 | 37.7632680488164 | -122.39322753922801 | (37.7632680488164, -122.393227539228) | ||||
72971 | 72971 | 122942 | Undocumented 2 | Eucalyptus torquata :: Coral Gum 452 | 300 09th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993109.163980001 | 2113243.95905 | 37.7821684105844 | -122.467515988912 | (37.7821684105844, -122.467515988912) | |||
72609 | 72609 | 240846 | Undocumented 2 | Styrax japonicus :: Japanese Snowdrop Tree 451 | 2070 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008057.57585 | 2106395.3094 | 37.7642153325926 | -122.41531607580299 | (37.7642153325926, -122.415316075803) | |||
162587 | 162587 | 240845 | Undocumented 2 | Styrax japonicus :: Japanese Snowdrop Tree 451 | 237 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006873.33933 | 2096646.66058 | 37.737381134717204 | -122.418720625774 | (37.7373811347172, -122.418720625774) | |||
71888 | 71888 | 197477 | Undocumented 2 | Metrosideros excelsa 'Aurea' :: 447 | 1301 Minnesota St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015374.65635 | 2102387.84204 | 37.75362021001371 | -122.38972824565799 | (37.7536202100137, -122.389728245658) | ||||
173936 | 173936 | 197478 | Undocumented 2 | Metrosideros excelsa 'Aurea' :: 447 | 1301 Minnesota St | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015365.810330001 | 2102331.75895 | 37.7534657271771 | -122.389754920476 | (37.7534657271771, -122.389754920476) | ||||
182590 | 182590 | 197476 | Undocumented 2 | Metrosideros excelsa 'Aurea' :: 447 | 1301 Minnesota St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015385.43711 | 2102326.66714 | 37.7534528344877 | -122.38968669068899 | (37.7534528344877, -122.389686690689) | ||||
152379 | 152379 | 240365 | Undocumented 2 | Quercus wislizenii :: Interior Live Oak 446 | 322 Elsie St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006294.96909 | 2096881.84233 | 37.737994310480204 | -122.420737015497 | (37.7379943104802, -122.420737015497) | |||
71183 | 71183 | 245129 | Undocumented 2 | Catalpa speciosa :: Northern Catalpa 444 | 1262 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000511.2695 | 2109276.7485 | 37.771700032393 | -122.441623315797 | (37.771700032393, -122.441623315797) | |||
68539 | 68539 | 205975 | Undocumented 2 | Cedrus libani :: Lebanon cedar 443 | 5 Sequoia Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5998211.61791 | 2097832.09967 | 37.7401445796092 | -122.448753454923 | (37.7401445796092, -122.448753454923) | |||
67491 | 67491 | 190750 | Undocumented 2 | Juglans hindsii :: Walnut: Black (n.calif) 442 | 1717 Revere Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 6014482.8243 | 2094823.0948599998 | 37.732799496305596 | -122.392283381472 | (37.7327994963056, -122.392283381472) | ||||
76582 | 76582 | 246774 | Undocumented 2 | Juglans hindsii :: Walnut: Black (n.calif) 442 | 1850 Alabama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6009457.96402 | 2098740.81971 | 37.743276423664796 | -122.40993212697398 | (37.7432764236648, -122.409932126974) | ||||
67436 | 67436 | 197370 | Undocumented 2 | Rhus typhina :: Staghorn sumac 441 | 1914 23rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012653.596919999 | 2102871.10125 | 37.7547958703446 | -122.399172251311 | (37.7547958703446, -122.399172251311) | ||||
65849 | 65849 | 116063 | Undocumented 2 | Brachychiton discolor :: 440 | 2100x 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 19 | 3x3 | 6011332.66531 | 2105125.78364 | 37.760913024731295 | -122.403899073603 | (37.7609130247313, -122.403899073603) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");