Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113666 | 113666 | 101255 | DPW Maintained 3 | x Chiranthofremontia lenzii :: Hybrid Monkey Hand Tree 524 | 3700X Cesar Chavez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005840.6 | 2100555.6 | 37.74805599841039 | -122.422568977073 | (37.7480559984104, -122.422568977073) | |||||
| 101656 | 101656 | 23365 | DPW Maintained 3 | Eucalyptus simmondsi :: Simmond's Peppermint 512 | 1356X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | |||
| 113613 | 113613 | 23368 | DPW Maintained 3 | Eucalyptus simmondsi :: Simmond's Peppermint 512 | 1356X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | |||
| 100332 | 100332 | 21434 | DPW Maintained 3 | Pinus pinaster :: Maritime Pine 510 | 2692X Sunset Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 99928 | 99928 | 13724 | DPW Maintained 3 | Platanus orientalis :: Eastern Plane Tree 509 | 774X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6011177.3442372 | 2114442.7932563997 | 37.786486710466704 | -122.40509232379499 | (37.7864867104667, -122.405092323795) | |||
| 129280 | 129280 | 13725 | DPW Maintained 3 | Platanus orientalis :: Eastern Plane Tree 509 | 776 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 6011167.8494838 | 2114433.7120502 | 37.786461244836296 | -122.40512453376499 | (37.7864612448363, -122.405124533765) | |||
| 121943 | 121943 | 3925 | DPW Maintained 3 | Magnolia sargentiana 'Robusta' :: Robusta Magnolia 508 | 99X Castro St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/2010 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | ||
| 95817 | 95817 | 23447 | DPW Maintained 3 | Eucalyptus odorata :: Peppermint Box 507 | 2100X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006027.0678818 | 2117578.0674993 | 37.794806131309706 | -122.42313396012399 | (37.7948061313097, -122.423133960124) | |||
| 94793 | 94793 | 106979 | DPW Maintained 3 | Prunus domestica 'Green Gage' :: Green Gage Plum 506 | 801X Clipper St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 24 | 5999765.50041 | 2100345.59515 | 37.7471347718267 | -122.443561289165 | (37.7471347718267, -122.443561289165) | ||||
| 92792 | 92792 | 98222 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1501X 42nd Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
| 108295 | 108295 | 23405 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1700X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006206.237645401 | 2116289.0241793 | 37.79127685023521 | -122.422422371222 | (37.7912768502352, -122.422422371222) | |||
| 145968 | 145968 | 98223 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1501X 42nd Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | ||
| 85952 | 85952 | 21318 | DPW Maintained 3 | Eucalyptus longifolia :: Woollybutt 491 | 2501X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985074.890734901 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | |||
| 88415 | 88415 | 21317 | DPW Maintained 3 | Eucalyptus longifolia :: Woollybutt 491 | 2501X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5985074.890734901 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | |||
| 122861 | 122861 | 21319 | DPW Maintained 3 | Eucalyptus longifolia :: Woollybutt 491 | 2501X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | 5985074.890734901 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | |||
| 85857 | 85857 | 5426 | DPW Maintained 3 | Aesculus x carnea 'O'Neill' :: O'Neill Red Horse Chestnut 490 | 460X Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6004889.2026724005 | 2105697.5669461996 | 37.7621209168257 | -122.42622490044901 | (37.7621209168257, -122.426224900449) | ||
| 87219 | 87219 | 5548 | DPW Maintained 3 | Aesculus x carnea 'O'Neill' :: O'Neill Red Horse Chestnut 490 | 947 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/1997 12:00:00 AM | 18 | 3X3 | 6005119.2884742 | 2102839.5530036 | 37.7542864846581 | -122.42522574346201 | (37.7542864846581, -122.425225743462) | ||
| 124584 | 124584 | 5534 | DPW Maintained 3 | Aesculus x carnea 'O'Neill' :: O'Neill Red Horse Chestnut 490 | 900X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 4 | 3X6 | 6005027.1572891 | 2103111.0000553 | 37.7550266096242 | -122.425563674214 | (37.7550266096242, -122.425563674214) | ||
| 84884 | 84884 | 2783 | DPW Maintained 3 | Fortunella margarita :: Kumquat 486 | 424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/2008 12:00:00 AM | 12 | 3X3 | 5994280.27723 | 2110781.18915 | 37.7754738485256 | -122.463285730589 | (37.7754738485256, -122.463285730589) | ||
| 104304 | 104304 | 89575 | DPW Maintained 3 | Fortunella margarita :: Kumquat 486 | 4839 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983613.56659 | 2111700.17185 | 37.777376824173004 | -122.50025179081699 | (37.777376824173, -122.500251790817) | ||
| 84661 | 84661 | 8268 | DPW Maintained 3 | Acer x 'Autumn Blaze' :: Hybrid Maple 485 | 1525 GALVEZ AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6016246.0 | 2097351.0 | 37.739838361172204 | -122.38636376878901 | (37.7398383611722, -122.386363768789) | ||
| 84396 | 84396 | 90707 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4332 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982199.060847 | 2110334.3438979997 | 37.773543534511205 | -122.505043702231 | (37.7735435345112, -122.505043702231) | |
| 92270 | 92270 | 90716 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4530 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981585.539599 | 2110312.077402 | 37.77344628141061 | -122.507164273797 | (37.7734462814106, -122.507164273797) | |
| 96444 | 96444 | 90726 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4799X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980764.077178 | 2110242.237714 | 37.773206105836 | -122.510000589277 | (37.773206105836, -122.510000589277) | |
| 97676 | 97676 | 90709 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4400 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981985.083822 | 2110326.5779669997 | 37.7735096198008 | -122.505783291903 | (37.7735096198008, -122.505783291903) | |
| 105740 | 105740 | 90747 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4331 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982206.432655 | 2110294.58511 | 37.773434802186706 | -122.505015255541 | (37.7734348021867, -122.505015255541) | |
| 125345 | 125345 | 90733 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4525 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981604.755434 | 2110272.748468 | 37.773339427416296 | -122.50709488652001 | (37.7733394274163, -122.50709488652) | |
| 141260 | 141260 | 90748 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4331 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982206.432655 | 2110294.58511 | 37.773434802186706 | -122.505015255541 | (37.7734348021867, -122.505015255541) | |
| 144389 | 144389 | 90741 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4499X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981694.399658999 | 2110276.0019259998 | 37.7733536396946 | -122.50678504147801 | (37.7733536396946, -122.506785041478) | |
| 103185 | 103185 | 4735 | DPW Maintained 3 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 | 1100X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6008154.5819477 | 2121037.0963081 | 37.804423590750396 | -122.41601752221001 | (37.8044235907504, -122.41601752221) | ||
| 82879 | 82879 | 2302 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 89822 | 89822 | 2298 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 89900 | 89900 | 2261 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 101138 | 101138 | 2304 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 105930 | 105930 | 2267 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 750X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 107007 | 107007 | 2297 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 112198 | 112198 | 2265 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 123388 | 123388 | 2257 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 126997 | 126997 | 2258 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 127206 | 127206 | 2303 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 139834 | 139834 | 2259 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 140483 | 140483 | 2260 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 87567 | 87567 | 100981 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||
| 89035 | 89035 | 100982 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||
| 140818 | 140818 | 100980 | DPW Maintained 3 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/03/2013 12:00:00 AM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |
| 111796 | 111796 | 24818 | DPW Maintained 3 | Prunus spp 'Purpurea' :: Cherry Plum 467 | 400X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2015 12:00:00 AM | 3 | 3x3 | 6007983.04766 | 2094988.0680200001 | 37.73288941859111 | -122.41476648967699 | (37.7328894185911, -122.414766489677) | ||
| 105137 | 105137 | 101918 | DPW Maintained 3 | Prunus serrulata 'Akebono' :: 'Akebono' Cherry 463 | 114 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6001282.9 | 2098757.3 | 37.742860112399796 | -122.438200492302 | (37.7428601123998, -122.438200492302) | |||
| 78341 | 78341 | 23810 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1200X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 79282 | 79282 | 23870 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1495X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003590.023580001 | 2113875.44534 | 37.7845018426272 | -122.43130203900499 | (37.7845018426272, -122.431302039005) | |||
| 79461 | 79461 | 28107 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1355X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003646.0046556 | 2113350.9191197 | 37.783064797596296 | -122.431070913528 | (37.7830647975963, -122.431070913528) | |||
| 81906 | 81906 | 23815 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1200X Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 91984 | 91984 | 23817 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1200X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 95065 | 95065 | 23869 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1495X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003590.023580001 | 2113875.44534 | 37.7845018426272 | -122.43130203900499 | (37.7845018426272, -122.431302039005) | |||
| 95119 | 95119 | 23816 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1200X Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | |||
| 102385 | 102385 | 23872 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1495X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003590.023580001 | 2113875.44534 | 37.7845018426272 | -122.43130203900499 | (37.7845018426272, -122.431302039005) | |||
| 103040 | 103040 | 23839 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1355X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003646.0046556 | 2113350.9191197 | 37.783064797596296 | -122.431070913528 | (37.7830647975963, -122.431070913528) | |||
| 107662 | 107662 | 23873 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1495X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003590.023580001 | 2113875.44534 | 37.7845018426272 | -122.43130203900499 | (37.7845018426272, -122.431302039005) | |||
| 121648 | 121648 | 23809 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1200X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1993 12:00:00 AM | 40 | 3x3 | 6003795.894280001 | 2112830.35916 | 37.7816439623395 | -122.430515201234 | (37.7816439623395, -122.430515201234) | ||
| 144132 | 144132 | 23830 | DPW Maintained 3 | Fraxinus x Moraine :: Moraine Ash 462 | 1203X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003742.20526 | 2112831.75991 | 37.781644766894296 | -122.430701039692 | (37.7816447668943, -122.430701039692) | |||
| 78169 | 78169 | 90468 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 600 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988164.289455 | 2111871.41207 | 37.778113054108296 | -122.48452211150601 | (37.7781130541083, -122.484522111506) | |
| 102220 | 102220 | 90517 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 619 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988128.545308 | 2111752.691709 | 37.777784999781794 | -122.48463705113701 | (37.7777849997818, -122.484637051137) | |
| 112407 | 112407 | 90502 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 401X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988073.547859 | 2113275.972392 | 37.7819642960053 | -122.484939086563 | (37.7819642960053, -122.484939086563) | |
| 113740 | 113740 | 89640 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 3349X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5988302.001433 | 2111876.734088 | 37.7781356853217 | -122.484046112267 | (37.7781356853217, -122.484046112267) | |
| 139900 | 139900 | 91017 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 457 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988087.568302 | 2112897.540762 | 37.7809260463619 | -122.48486281200898 | (37.7809260463619, -122.484862812009) | |
| 142392 | 142392 | 90497 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 319 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988052.709 | 2113836.722691 | 37.7835027435823 | -122.485052332629 | (37.7835027435823, -122.485052332629) | |
| 94895 | 94895 | 89672 | DPW Maintained 3 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2627 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5990536.654767 | 2111956.813347 | 37.7784854072376 | -122.476321569471 | (37.7784854072376, -122.476321569471) | ||
| 107743 | 107743 | 89432 | DPW Maintained 3 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990207.269944999 | 2111985.0354509996 | 37.7785437899427 | -122.47746308716499 | (37.7785437899427, -122.477463087165) | ||
| 79884 | 79884 | 24198 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 55X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 138953 | 138953 | 63523 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 929 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 3 | 3x3 | Permit Number 24134 | 6006356.3 | 2104163.0 | 37.757990169538495 | -122.42104180117902 | (37.7579901695385, -122.421041801179) | |
| 142404 | 142404 | 24196 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 55X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 6 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 146199 | 146199 | 17226 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 1884X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001017.031830001 | 2091170.8979900002 | 37.722014482536295 | -122.438576333542 | (37.7220144825363, -122.438576333542) | |||
| 157453 | 157453 | 18552 | DPW Maintained 3 | Quercus engelmannii :: Engelmann oak 453 | 1700X Quesada Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 19 | 6014642.29362 | 2095077.14438 | 37.7335059182554 | -122.39174980833201 | (37.7335059182554, -122.391749808332) | |||
| 119388 | 119388 | 23234 | DPW Maintained 3 | Eucalyptus torquata :: Coral Gum 452 | 700X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006679.199292599 | 2112885.0865653 | 37.7819571437982 | -122.42054420111201 | (37.7819571437982, -122.420544201112) | |||
| 72584 | 72584 | 93335 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 80365 | 80365 | 93349 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 81223 | 81223 | 93326 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 81783 | 81783 | 93331 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 82808 | 82808 | 93337 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 85080 | 85080 | 93334 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 89071 | 89071 | 93323 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 90198 | 90198 | 93336 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 90887 | 90887 | 93327 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 91847 | 91847 | 93380 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 3098X Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996221.5 | 2111515.5 | 37.77760171599729 | -122.456623735227 | (37.7776017159973, -122.456623735227) | ||
| 93046 | 93046 | 93345 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 95185 | 95185 | 93343 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 95590 | 95590 | 93318 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 98985 | 98985 | 93333 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 99665 | 99665 | 93341 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 99880 | 99880 | 93381 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 3098X Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996221.5 | 2111515.5 | 37.77760171599729 | -122.456623735227 | (37.7776017159973, -122.456623735227) | ||
| 99962 | 99962 | 93342 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 100761 | 100761 | 93328 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 102390 | 102390 | 93321 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 103828 | 103828 | 93347 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 106678 | 106678 | 93339 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 106982 | 106982 | 93348 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 108173 | 108173 | 93346 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 108843 | 108843 | 93344 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 110827 | 110827 | 93330 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 111165 | 111165 | 93319 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) | ||
| 111286 | 111286 | 93324 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x3 | 5999954.2 | 2112061.6 | 37.779314771487996 | -122.44375035157302 | (37.779314771488, -122.443750351573) |
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");