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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | |||
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) | |||
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) | ||
112227 | 112227 | 93354 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 37 | 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) | ||
116017 | 116017 | 93340 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 23 | 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) | ||
116175 | 116175 | 93382 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 3098X Turk Blvd | 3 | 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) | ||
117112 | 117112 | 93329 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 12 | 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) | ||
117216 | 117216 | 93353 | DPW Maintained 3 | Fraxinus americana 'Autumn Purple' :: American Autumn Purple Ash 449 | 2100X Turk Blvd | 36 | 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) |
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");