Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96561 | 96561 | 112293 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 501x 27TH AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3xe | 5987510.0 | 2112219.0 | 37.7790293092803 | -122.486811036923 | (37.7790293092803, -122.486811036923) | ||||
| 96562 | 96562 | 95784 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767528 | 6009367.0 | 2103952.0 | 37.757580067238294 | -122.410614581161 | (37.7575800672383, -122.410614581161) | |
| 96563 | 96563 | 58596 | Permitted Site 1 | Tree(s) :: 17 | 237 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1979 12:00:00 AM | Permit Number 17797 | 5997662.333827 | 2105878.12355001 | 37.762205545901 | -122.451232767817 | (37.762205545901, -122.451232767817) | |||
| 96564 | 96564 | 101725 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 96565 | 96565 | 20978 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 2002X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 96566 | 96566 | 52598 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 423@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48692 | 6005028.51137557 | 2110420.01312959 | 37.7750954922138 | -122.426079285457 | (37.7750954922138, -122.426079285457) | |||
| 96567 | 96567 | 5805 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5 Dukes Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016140.1129447995 | 2096198.2445968003 | 37.73666726663679 | -122.386649521955 | (37.7366672666368, -122.386649521955) | |||
| 96568 | 96568 | 60791 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 276 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | Permit Number 20465 | 5998453.93543616 | 2112227.70718861 | 37.779685173955706 | -122.44895233828001 | (37.7796851739557, -122.44895233828) | ||
| 96569 | 96569 | 36422 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Montecito Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39337 | 5996091.95170793 | 2094186.31684288 | 37.7300127063789 | -122.455818876187 | (37.7300127063789, -122.455818876187) | |||
| 96570 | 96570 | 75019 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/31/1997 12:00:00 AM | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.45788265611701 | (37.782106991639, -122.457882656117) | |
| 96571 | 96571 | 120673 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3876 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003780.8 | 2105549.3 | 37.761651098806 | -122.430047862208 | (37.761651098806, -122.430047862208) | ||||
| 96572 | 96572 | 106939 | Undocumented 2 | Tree(s) :: 17 | 1607 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2014 12:00:00 AM | 3 | Permit Number 773600 | 5997889.0 | 2108175.0 | 37.768525161365105 | -122.45061442154498 | (37.7685251613651, -122.450614421545) | ||
| 96573 | 96573 | 90364 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 537 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993970.172866001 | 2111402.29422 | 37.7771613668446 | -122.46440355258301 | (37.7771613668446, -122.464403552583) | ||
| 96574 | 96574 | 12496 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 96575 | 96575 | 61016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 160 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20832 | 6001288.97314129 | 2096322.54651529 | 37.73617519459229 | -122.438005130092 | (37.7361751945923, -122.438005130092) | ||
| 96576 | 96576 | 115405 | Planning Code 138.1 required 4 | Podocarpus macrophyllus :: Yew Pine 168 | 2050 43RD AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/29/2016 12:00:00 AM | 3 | 3x3 | 5982969.0 | 2101168.0 | 37.7484206232379 | -122.50170211889 | (37.7484206232379, -122.50170211889) | ||
| 96577 | 96577 | 39797 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1920 41st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43808 | 5983539.51267339 | 2102067.82749571 | 37.75092479445271 | -122.499795829171 | (37.7509247944527, -122.499795829171) | ||
| 96578 | 96578 | 95515 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | |||
| 96579 | 96579 | 69525 | Permitted Site 1 | Tree(s) :: 17 | 331 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37671 | 6006434.40955607 | 2097930.66330617 | 37.740881996913 | -122.420329320725 | (37.740881996913, -122.420329320725) | |||
| 96580 | 96580 | 43346 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
| 96581 | 96581 | 99127 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 10 | Median : Cutout 11 | Tree 1 | Private 1 | 48 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 96582 | 96582 | 7090 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1892 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998388.9236 | 2109693.89838 | 37.7727242707137 | -122.448994665385 | (37.7727242707137, -122.448994665385) | |||
| 96583 | 96583 | 63710 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 150 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1987 12:00:00 AM | Permit Number 24372 | 6007410.32173139 | 2100162.00836053 | 37.7470637164949 | -122.41711304002399 | (37.7470637164949, -122.417113040024) | ||
| 96584 | 96584 | 112382 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3250 CESAR CHAVEZ ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007972.0 | 2100641.0 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | ||||
| 96585 | 96585 | 92497 | Permitted Site 1 | Tree(s) :: 17 | 2 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2009 12:00:00 AM | 3x3 | Permit Number 52870 | 6003584.0 | 2096729.0 | 37.7374214715094 | -122.43009927166901 | (37.7374214715094, -122.430099271669) | ||
| 96586 | 96586 | 44495 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 493 Oxford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | Permit Number 43798 | 6006879.93458161 | 2091734.97887269 | 37.7238950997865 | -122.418349669114 | (37.7238950997865, -122.418349669114) | ||
| 96587 | 96587 | 114401 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1X HIGUERA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987903.0 | 2090420.0 | 37.7191979850677 | -122.483852684784 | (37.7191979850677, -122.483852684784) | ||||
| 96588 | 96588 | 49613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 96589 | 96589 | 61299 | Permitted Site 1 | Tree(s) :: 17 | 1827 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2016 12:00:00 AM | 3 | Permit Number 777864 | 6004251.1107426 | 2118703.69866947 | 37.797796445538395 | -122.429359325581 | (37.7977964455384, -122.429359325581) | ||
| 96590 | 96590 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 1268 Lombard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6006289.0 | 2120073.0 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | ||||
| 96591 | 96591 | 18215 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1584 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1997 12:00:00 AM | 3 | 4X4 | 6004599.7258007005 | 2114360.9725003 | 37.78589214879229 | -122.42784342077499 | (37.7858921487923, -122.427843420775) | ||
| 96592 | 96592 | 31517 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1225 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35075 | 6011656.56027463 | 2091519.35210888 | 37.723570762838705 | -122.401822399904 | (37.7235707628387, -122.401822399904) | ||
| 96593 | 96593 | 90150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 606 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993698.31044 | 2111441.63963 | 37.77725372407561 | -122.46534686201001 | (37.7772537240756, -122.46534686201) | ||
| 96594 | 96594 | 35649 | Permitted Site 1 | Tree(s) :: 17 | 614 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | Permit Number 38977 | 6004449.21597902 | 2110696.79017837 | 37.775822696232 | -122.42810292491899 | (37.775822696232, -122.428102924919) | |||
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 96596 | 96596 | 58407 | Permitted Site 1 | Tree(s) :: 17 | 639 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | Permit Number 17542 | 5999765.8 | 2107710.4 | 37.7673567328153 | -122.44408936414801 | (37.7673567328153, -122.444089364148) | |||
| 96597 | 96597 | 42644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 96598 | 96598 | 23187 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 560X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006458.921066 | 2112191.041059 | 37.7800390474075 | -122.421256963785 | (37.7800390474075, -122.421256963785) | |||
| 96599 | 96599 | 27395 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007121.016846401 | 2120187.7710471 | 37.802033394640105 | -122.41953397743299 | (37.8020333946401, -122.419533977433) | |||
| 96600 | 96600 | 21065 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2192X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
| 96601 | 96601 | 121329 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2401x Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001103.0 | 2113984.0 | 37.784658648156295 | -122.439914057191 | (37.7846586481563, -122.439914057191) | ||||
| 96602 | 96602 | 103819 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.787095758933894 | -122.41982320605 | (37.7870957589339, -122.41982320605) | ||
| 96603 | 96603 | 17627 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2005 12:00:00 AM | 3 | 3X3 | 6004380.712681401 | 2089954.6929998002 | 37.718865821274 | -122.42686234984801 | (37.718865821274, -122.426862349848) | ||
| 96604 | 96604 | 115832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 FONT BLVD | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 30x30 | Permit Number 777501 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | ||
| 96605 | 96605 | 26144 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1500 Oakdale Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/22/1997 12:00:00 AM | 10 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 96606 | 96606 | 39362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2433 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40917 | 6008235.29946712 | 2104260.15851816 | 37.7583626864034 | -122.41455027836001 | (37.7583626864034, -122.41455027836) | ||
| 96607 | 96607 | 82282 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1735 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2005 12:00:00 AM | 10 | 3x3 | 6006758.35477915 | 2108129.92542605 | 37.7689050737926 | -122.419932819268 | (37.7689050737926, -122.419932819268) | ||
| 96608 | 96608 | 64064 | Permitted Site 1 | Tree(s) :: 17 | 2132 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1987 12:00:00 AM | Permit Number 24824 | 5991339.02868531 | 2100896.13297433 | 37.7481622280084 | -122.472739198028 | (37.7481622280084, -122.472739198028) | |||
| 96609 | 96609 | 35463 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 430 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1998 12:00:00 AM | Permit Number 38886 | 6007237.08907724 | 2112375.34283194 | 37.780588935594395 | -122.418577996505 | (37.7805889355944, -122.418577996505) | |||
| 96610 | 96610 | 116253 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
| 96611 | 96611 | 47872 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 745 Clement St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2002 12:00:00 AM | Permit Number 45622 | 5993251.273182 | 2113455.25810423 | 37.7827567838111 | -122.46703972599701 | (37.7827567838111, -122.467039725997) | |||
| 96612 | 96612 | 64961 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 120 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774717 | 6004261.49676722 | 2097472.14872907 | 37.739500336982296 | -122.427809784477 | (37.7395003369823, -122.427809784477) | |||
| 96613 | 96613 | 48836 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3700X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46054 | 6003439.85317318 | 2121384.75473793 | 37.805111964872395 | -122.43235808435 | (37.8051119648724, -122.43235808435) | |||
| 96614 | 96614 | 11757 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 901X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 96615 | 96615 | 117264 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1280 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007807.0 | 2115863.0 | 37.7901972632139 | -122.416853563641 | (37.7901972632139, -122.416853563641) | ||||
| 96616 | 96616 | 32176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35513 | 5984396.34237134 | 2094161.85808413 | 37.7292673830802 | -122.496249618321 | (37.7292673830802, -122.496249618321) | ||
| 96617 | 96617 | 1732 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 08/19/2006 12:00:00 AM | 3 | 3X9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | ||
| 96618 | 96618 | 4540 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1997 12:00:00 AM | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 96619 | 96619 | 2639 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004357.24991 | 2114951.14345 | 37.787498890276396 | -122.42872440700899 | (37.7874988902764, -122.428724407009) | |||
| 96620 | 96620 | 56888 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 379 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30734 | 6003470.66871359 | 2108600.18569561 | 37.7700105227729 | -122.431338270509 | (37.7700105227729, -122.431338270509) | ||
| 96621 | 96621 | 17118 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1907 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997842.841030001 | 2109183.73864 | 37.771292257165896 | -122.4508468245 | (37.7712922571659, -122.4508468245) | |||
| 96622 | 96622 | 65339 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 191 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28170 | 6001579.20108018 | 2095147.68073524 | 37.7329657853341 | -122.43691761276101 | (37.7329657853341, -122.436917612761) | ||
| 96623 | 96623 | 106177 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 96624 | 96624 | 10823 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X4 | 6017777.243009999 | 2094650.0030099999 | 37.7325066000949 | -122.38088159725099 | (37.7325066000949, -122.380881597251) | ||
| 96625 | 96625 | 93062 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2.5x2.5 | Tree 4 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | ||
| 96626 | 96626 | 41567 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 415 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2000 12:00:00 AM | Permit Number 42082 | 5990887.69242211 | 2112576.88642712 | 37.780208308315295 | -122.47515248865801 | (37.7802083083153, -122.475152488658) | |||
| 96627 | 96627 | 104900 | Significant Tree 6 | Betula pendula :: European White Birch 146 | 317 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 96628 | 96628 | 67501 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 394 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/18/1993 12:00:00 AM | Permit Number 31030 | 5998815.69417134 | 2094405.78441062 | 37.7307712562319 | -122.446418383601 | (37.7307712562319, -122.446418383601) | ||
| 96629 | 96629 | 20950 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1992X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 96630 | 96630 | 7221 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 96631 | 96631 | 22991 | Permitted Site 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 663 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2010 12:00:00 AM | 5 | 3x3 | 6006244.58019 | 2105713.9704299998 | 37.7622424736555 | -122.421538326696 | (37.7622424736555, -122.421538326696) | ||
| 96632 | 96632 | 116628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 5732X GEARY BLVD | 9 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 96633 | 96633 | 42373 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42548 | 5998094.3919548 | 2095072.92519048 | 37.7325618425703 | -122.448960067148 | (37.7325618425703, -122.448960067148) | ||
| 96634 | 96634 | 113321 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 222 HERMANN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004169.0 | 2108774.0 | 37.7705273263251 | -122.42893514768801 | (37.7705273263251, -122.428935147688) | |||
| 96635 | 96635 | 87186 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3041 Webster St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50188 | 6002864.0 | 2119027.0 | 37.798605518649296 | -122.43418223343599 | (37.7986055186493, -122.434182233436) | |||
| 96636 | 96636 | 20528 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 96637 | 96637 | 118362 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 55 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993600.0 | 2115147.0 | 37.78742196799121 | -122.46595625439501 | (37.7874219679912, -122.465956254395) | ||||
| 96638 | 96638 | 99562 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650X Brunswick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x6 | 5998578.4 | 2086902.6 | 37.710155688278 | -122.44669908653499 | (37.710155688278, -122.446699086535) | |||
| 96639 | 96639 | 111917 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 96640 | 96640 | 57015 | Permitted Site 1 | Tree(s) :: 17 | 61 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1974 12:00:00 AM | Permit Number 14274 | 6003123.99691774 | 2107381.1703596 | 37.7666437513211 | -122.432450321252 | (37.7666437513211, -122.432450321252) | |||
| 96641 | 96641 | 39769 | Permitted Site 1 | Tree(s) :: 17 | 746 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/1999 12:00:00 AM | Permit Number 41136 | 6002400.75595274 | 2103774.39797563 | 37.7566993903086 | -122.434693945987 | (37.7566993903086, -122.434693945987) | |||
| 96642 | 96642 | 52544 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2006 12:00:00 AM | 3 | 4x4 | Permit Number 48641 | 6004341.39214804 | 2108373.29158865 | 37.7694368344775 | -122.428310278261 | (37.7694368344775, -122.428310278261) | |
| 96643 | 96643 | 49293 | Permitted Site 1 | Tree(s) :: 17 | 1X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 96644 | 96644 | 40784 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 96645 | 96645 | 3977 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 240 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002231.9130424 | 2106826.8321431 | 37.765071047803396 | -122.435496220896 | (37.7650710478034, -122.435496220896) | |||
| 96646 | 96646 | 89752 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995478.0169 | 2112129.57687 | 37.779245093230294 | -122.459240156052 | (37.7792450932303, -122.459240156052) | ||
| 96647 | 96647 | 57177 | Permitted Site 1 | Tree(s) :: 17 | 157 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1974 12:00:00 AM | Permit Number 14456 | 6001133.30629268 | 2106258.52299923 | 37.7634481543544 | -122.43925528519699 | (37.7634481543544, -122.439255285197) | |||
| 96648 | 96648 | 8376 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1301X Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6005507.71189 | 2114109.8093 | 37.7852538400076 | -122.42468416339199 | (37.7852538400076, -122.424684163392) | ||||
| 96649 | 96649 | 89665 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2801X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989906.30924 | 2111928.05503 | 37.7783698693417 | -122.478500045616 | (37.7783698693417, -122.478500045616) | ||
| 96650 | 96650 | 35810 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.762580870322104 | -122.42044317973499 | (37.7625808703221, -122.420443179735) | ||
| 96651 | 96651 | 10718 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 96652 | 96652 | 88519 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 959 Monterey Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51450 | 5995460.1 | 2094437.2 | 37.730665287621996 | -122.458021400084 | (37.730665287622, -122.458021400084) | |||
| 96653 | 96653 | 94823 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 1247 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53903 | 5990745.7 | 2106901.7 | 37.764617562031496 | -122.475229262837 | (37.7646175620315, -122.475229262837) | |
| 96654 | 96654 | 55167 | Permitted Site 1 | Tree(s) :: 17 | 478 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1972 12:00:00 AM | Permit Number 11073 | 6002052.09521001 | 2101509.80198235 | 37.7504615512073 | -122.43573772223301 | (37.7504615512073, -122.435737722233) | |||
| 96655 | 96655 | 105086 | Significant Tree 6 | :: 54 | 344 Fulton St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 96656 | 96656 | 64820 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 144 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25829 | 6002367.6005326 | 2108976.22169962 | 37.770980449025004 | -122.43518066045799 | (37.770980449025, -122.435180660458) | ||
| 96657 | 96657 | 121361 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 399X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6017829.0 | 2098352.0 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | |||
| 96658 | 96658 | 24904 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2840 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2001 12:00:00 AM | 3 | 3X3 | 6011333.0 | 2092357.0 | 37.725852708866796 | -122.402999785692 | (37.7258527088668, -122.402999785692) | ||
| 96659 | 96659 | 10421 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999421.35342 | 2108678.34127 | 37.7699947998181 | -122.44535035645 | (37.7699947998181, -122.44535035645) | |||
| 96660 | 96660 | 63708 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 112 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1987 12:00:00 AM | Permit Number 24370 | 6007173.27804483 | 2100053.62409049 | 37.7467527797848 | -122.417925037233 | (37.7467527797848, -122.417925037233) |
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");