Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118068 | 118068 | 55720 | Permitted Site 1 | Liquidambar styraciflua 'Burgundy' :: Burgundy Sweet Gum 501 | 58 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2010 12:00:00 AM | Permit Number 53177 | 6003133.68670367 | 2107965.52082477 | 37.7682487847408 | -122.432458547407 | (37.7682487847408, -122.432458547407) | |||
| 90412 | 90412 | 117515 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 252 SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003503.0 | 2106732.0 | 37.76488277097621 | -122.43109307683599 | (37.7648827709762, -122.431093076836) | |||||
| 120633 | 120633 | 33490 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 35 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37609 | 6006977.21573848 | 2099539.13365135 | 37.74532906867729 | -122.418566525643 | (37.7453290686773, -122.418566525643) | ||
| 126777 | 126777 | 33504 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 187 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37598 | 6006493.12826546 | 2098644.93339698 | 37.7428465310244 | -122.420176972942 | (37.7428465310244, -122.420176972942) | |||
| 144735 | 144735 | 33506 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 229 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37601 | 6006405.76060345 | 2098478.97764317 | 37.7423859306557 | -122.42046728912099 | (37.7423859306557, -122.420467289121) | |||
| 145498 | 145498 | 33505 | Permitted Site 1 | Fraxinus holotricha :: Holotricha Ash 500 | 201 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37599 | 6006452.6422085995 | 2098569.84491652 | 37.7426380736375 | -122.42031163432199 | (37.7426380736375, -122.420311634322) | |||
| 88612 | 88612 | 95698 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 90751 | 90751 | 95699 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 95246 | 95246 | 95696 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 120606 | 120606 | 95697 | Permitted Site 1 | Malus floribunda 'Prairie Fire' :: Prairie Fire Crabapple Tree 499 | 101 Arbor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767450 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |
| 88058 | 88058 | 94937 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 112975 | 112975 | 94938 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 139320 | 139320 | 94936 | Significant Tree 6 | Malus 'Gala' :: Apple Tree 'Gala' 498 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 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) | |||||
| 87379 | 87379 | 95376 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 3864 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767248 | 6004016.0 | 2102485.0 | 37.753250574879395 | -122.429015915711 | (37.7532505748794, -122.429015915711) | |
| 90744 | 90744 | 94882 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 1778 Quesada Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53949 | 6014333.3 | 2095365.5 | 37.7342805262691 | -122.392838262387 | (37.7342805262691, -122.392838262387) | ||
| 91664 | 91664 | 95389 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 4751 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767258 | 6000210.0 | 2101069.0 | 37.749146408168 | -122.442076167893 | (37.749146408168, -122.442076167893) | |
| 115012 | 115012 | 95548 | Permitted Site 1 | Crataegus laevigata 'Paul's Scarlet' :: Paul's Scarlet Hawthorn 496 | 1701x SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767348 | 6003979.0 | 2098037.0 | 37.74103530456421 | -122.428826793148 | (37.7410353045642, -122.428826793148) |
| 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) | |||
| 91238 | 91238 | 107719 | Permitted Site 1 | Prunus serrula :: Birchbark Cherry 495 | 3301x 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774073 | 6007483.0 | 2105569.0 | 37.761914169510604 | -122.417244815958 | (37.7619141695106, -122.417244815958) | |
| 98556 | 98556 | 97557 | Permitted Site 1 | Prunus serrula :: Birchbark Cherry 495 | 1316 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2011 12:00:00 AM | Permit Number 768295 | 5993059.9 | 2106465.7 | 37.7635542817507 | -122.467193428173 | (37.7635542817507, -122.467193428173) | |||
| 86832 | 86832 | 98699 | Permitted Site 1 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 494 | 2490X Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2012 12:00:00 AM | 3x3 | Permit Number 768696 | 6000865.0 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | ||
| 89301 | 89301 | 98701 | Permitted Site 1 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 494 | 2490X Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2012 12:00:00 AM | 3x3 | Permit Number 768696 | 6000865.0 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | ||
| 89877 | 89877 | 98698 | Permitted Site 1 | Rhamnus alaternus 'John Edwards' :: John Edwards Buckthorn 494 | 2490X Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2012 12:00:00 AM | 3x3 | Permit Number 768696 | 6000865.0 | 2116767.3 | 37.7922873178989 | -122.440937193321 | (37.7922873178989, -122.440937193321) | ||
| 86750 | 86750 | 106343 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 5 | Sidewalk: Curb side : Cutout 1 | 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) | ||
| 97261 | 97261 | 106340 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | |||
| 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) | ||
| 143282 | 143282 | 106339 | Permitted Site 1 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497X Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.6 | 2099138.4 | 37.7439915346951 | -122.433052549622 | (37.7439915346951, -122.433052549622) | ||
| 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) | ||
| 86198 | 86198 | 47414 | Permitted Site 1 | Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' 492 | 396 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45325 | 6003061.80741147 | 2104489.40624321 | 37.7587001387613 | -122.43245885881001 | (37.7587001387613, -122.43245885881) | ||
| 146197 | 146197 | 47413 | Permitted Site 1 | Juglans 'Paradox' :: Paradox Walnut Tree 'Paradox' 492 | 396 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45325 | 6003061.80741147 | 2104489.40624321 | 37.7587001387613 | -122.43245885881001 | (37.7587001387613, -122.43245885881) | ||
| 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) | ||
| 85671 | 85671 | 40135 | Permitted Site 1 | Geijera spp :: Geijera 489 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41339 | 6009180.78986515 | 2103366.6928894 | 37.755962504482 | -122.411217228554 | (37.755962504482, -122.411217228554) | ||||
| 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) | ||||
| 85457 | 85457 | 50410 | Permitted Site 1 | Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 487 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47065 | 6000234.812518599 | 2094385.17995161 | 37.7307956329874 | -122.441510803123 | (37.7307956329874, -122.441510803123) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 97751 | 97751 | 110321 | Significant Tree 6 | Ilex opaca :: American Holly 484 | 1x SAN PABLO AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774750 | 5994773.0 | 2097898.0 | 37.740128291439 | -122.460647489756 | (37.740128291439, -122.460647489756) | ||
| 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) | |||
| 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) | |
| 84353 | 84353 | 115886 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 88703 | 88703 | 66716 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 3506 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1991 12:00:00 AM | 12 | 3x3 | Permit Number 29957 | 6006118.0 | 2102026.0 | 37.752109025945295 | -122.42171416073799 | (37.7521090259453, -122.421714160738) | |
| 109365 | 109365 | 107697 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 2401 MORAGA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 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) | |||||
| 126350 | 126350 | 115887 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 126630 | 126630 | 115885 | Planning Code 138.1 required 4 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | 10x10 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | |
| 141297 | 141297 | 107698 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 2401 MORAGA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | ||||
| 142899 | 142899 | 100073 | Permitted Site 1 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 482 | 930@ Lorraine Ct Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2012 12:00:00 AM | 3x3 | Permit Number 769060 | 5996162.0 | 2112255.0 | 37.7796287713947 | -122.45688306406099 | (37.7796287713947, -122.456883064061) | ||
| 84332 | 84332 | 52189 | Permitted Site 1 | Liquidambar formosana :: Chinese Sweet Gum 481 | 985 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50862 | 5998794.16746472 | 2106547.68954693 | 37.7641087462545 | -122.44736639531901 | (37.7641087462545, -122.447366395319) | ||
| 111417 | 111417 | 57009 | Permitted Site 1 | Liquidambar formosana :: Chinese Sweet Gum 481 | 24 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2015 12:00:00 AM | 3 | Permit Number 775634 | 6003352.23299803 | 2107445.91361589 | 37.7668344601842 | -122.43166551543001 | (37.7668344601842, -122.43166551543) | ||
| 84047 | 84047 | 38429 | Permitted Site 1 | Sambucus mexicana :: Blue Elderberry 480 | 1000X Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1998 12:00:00 AM | 6012766.0 | 2102838.0 | 37.7547112450133 | -122.398781204994 | (37.7547112450133, -122.398781204994) | ||||
| 101071 | 101071 | 111757 | Landmark tree 9 | Sambucus mexicana :: Blue Elderberry 480 | 3440X Folsom St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6008633.6974599995 | 2098934.7859 | 37.743762781475 | -122.41279594632401 | (37.743762781475, -122.412795946324) | |||||
| 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) | ||||
| 83778 | 83778 | 87644 | Permitted Site 1 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 | 1770X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004459.1886599995 | 2114839.9257 | 37.7871992830496 | -122.428363789521 | (37.7871992830496, -122.428363789521) | |||
| 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) | ||
| 140328 | 140328 | 83461 | Permitted Site 1 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 | 847 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50441 | 6000958.23221364 | 2101981.88946936 | 37.7516955955481 | -122.43955421112601 | (37.7516955955481, -122.439554211126) | ||
| 83777 | 83777 | 103097 | Section 143 8 | Fagus sylvatica 'Red Obelisk' :: Red Obelisk Beech 478 | 1199X Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3x3 | Permit Number 768649 | 6008392.3 | 2117900.9 | 37.7958257402639 | -122.41497276422399 | (37.7958257402639, -122.414972764224) | ||
| 82982 | 82982 | 92439 | Permitted Site 1 | Griselinia lucida :: Griselinia 477 | 1314 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52829 | 5982178.1 | 2106127.8 | 37.761992345907004 | -122.50480444860399 | (37.761992345907, -122.504804448604) | |
| 83334 | 83334 | 115773 | Permitted Site 1 | Griselinia lucida :: Griselinia 477 | 1247 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772445 | 6015089.2 | 2090491.5 | 37.720939452782105 | -122.389884508267 | (37.7209394527821, -122.389884508267) | ||
| 107550 | 107550 | 97032 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 140389 | 140389 | 97037 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145522 | 145522 | 97036 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 82944 | 82944 | 97131 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 91445 | 91445 | 97133 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 92039 | 92039 | 97130 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 93695 | 93695 | 97128 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 119675 | 119675 | 97132 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 124371 | 124371 | 97129 | Permitted Site 1 | Pinus thunbergii 'Thunderhead' :: Thunderhead Pine 476 | 2690 Broadway | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 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) |
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");