Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1219 | 1219 | 119829 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 3831 | 3831 | 30286 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 10 | Permit Number 132 | 6008896.76565 | 2117570.49119 | 37.794946853168604 | -122.41320383718599 | (37.7949468531686, -122.413203837186) | ||
| 13945 | 13945 | 46285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 19810 | 19810 | 47528 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 39204 | 39204 | 32023 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 18 | Permit Number 35413 | 6001158.18036 | 2116931.31755 | 37.792754360865295 | -122.43993455095699 | (37.7927543608653, -122.439934550957) | ||
| 40344 | 40344 | 31076 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6006020.69113 | 2107294.3894700003 | 37.7665693044606 | -122.422424975532 | (37.7665693044606, -122.422424975532) | |
| 40396 | 40396 | 97985 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6015230.10587 | 2104016.74085 | 37.7580848025885 | -122.39034193764499 | (37.7580848025885, -122.390341937645) | ||||
| 62540 | 62540 | 32997 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.39805475731501 | (37.784617751847, -122.398054757315) | |
| 63412 | 63412 | 66733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1133 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1991 12:00:00 AM | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | |||
| 69807 | 69807 | 72412 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3485 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 10 | 5997617.1015 | 2116066.53919 | 37.7901776988858 | -122.452124350462 | (37.7901776988858, -122.452124350462) | ||
| 82092 | 82092 | 94046 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 42 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53454 | 5998445.0 | 2106022.0 | 37.7626453762737 | -122.44853619655001 | (37.7626453762737, -122.44853619655) | ||||
| 85972 | 85972 | 119818 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 87858 | 87858 | 45651 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 88211 | 88211 | 51850 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4000 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.43267780892599 | (37.7594924661239, -122.432677808926) | |||
| 90128 | 90128 | 49733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 93922 | 93922 | 119676 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 95821 | 95821 | 36145 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | ||
| 104368 | 104368 | 115739 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4077 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6001800.02048091 | 2105829.59496805 | 37.76230833972689 | -122.436918630667 | (37.7623083397269, -122.436918630667) | ||||
| 110843 | 110843 | 46502 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 115943 | 115943 | 41185 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.224090001 | 2120345.1134900004 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | |
| 120581 | 120581 | 46913 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 120965 | 120965 | 97833 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 125148 | 125148 | 44267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 126297 | 126297 | 39478 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2856 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 777203 | 5999897.32915775 | 2117456.37972289 | 37.7941241886563 | -122.44433488583 | (37.7941241886563, -122.44433488583) | |||
| 128093 | 128093 | 119709 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 128748 | 128748 | 32533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 131254 | 131254 | 198643 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6016155.89645 | 2108764.08817 | 37.7711713062286 | -122.38747130976401 | (37.7711713062286, -122.387471309764) | ||||
| 144605 | 144605 | 119782 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 146136 | 146136 | 37289 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) | |||
| 159214 | 159214 | 198602 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6016341.1963599995 | 2108654.11325 | 37.7708796003339 | -122.38682267373801 | (37.7708796003339, -122.386822673738) | ||||
| 160439 | 160439 | 198613 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015962.12973 | 2108632.67433 | 37.770799738754 | -122.388132389719 | (37.770799738754, -122.388132389719) | ||||
| 162813 | 162813 | 99285 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 6000571.30245 | 2116798.91345 | 37.7923573884461 | -122.441955660321 | (37.7923573884461, -122.441955660321) | ||||
| 163680 | 163680 | 76181 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 3 | 6009574.6956 | 2110252.7468 | 37.7748921128949 | -122.410341153951 | (37.7748921128949, -122.410341153951) | ||
| 176776 | 176776 | 105953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | ||
| 183809 | 183809 | 198628 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015696.32506 | 2108739.9117 | 37.7710794584904 | -122.389059310163 | (37.7710794584904, -122.389059310163) | ||||
| 42722 | 42722 | 110675 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 34 Bonita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 2.5x3 | 6006170.0244 | 2118492.14329 | 37.7973240194296 | -122.422704299571 | (37.7973240194296, -122.422704299571) | |||
| 155253 | 155253 | 115550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.39018178636199 | (37.7584697654838, -122.390181786362) | ||
| 11596 | 11596 | 17497 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.43491976573401 | (37.7226823390961, -122.434919765734) | |||
| 127 | 127 | 18052 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2840 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000317.799 | 2114808.7133 | 37.7868783690408 | -122.442689819484 | (37.7868783690408, -122.442689819484) | |||
| 5180 | 5180 | 17545 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6003118.2023599995 | 2090743.3942599997 | 37.7209599548222 | -122.431282614218 | (37.7209599548222, -122.431282614218) | |||
| 6566 | 6566 | 2631 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1884 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004489.1648 | 2115039.2121 | 37.787748169652204 | -122.428274287097 | (37.7877481696522, -122.428274287097) | |||
| 10250 | 10250 | 7523 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2801 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6008355.713819999 | 2102061.13803 | 37.752331439255705 | -122.413978269475 | (37.7523314392557, -122.413978269475) | |||
| 11239 | 11239 | 17609 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004106.27078 | 2090068.65464 | 37.7191632136975 | -122.42781910286999 | (37.7191632136975, -122.42781910287) | |||
| 11325 | 11325 | 17624 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | |||
| 15899 | 15899 | 22327 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 5155 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6014617.6908 | 2094280.6281 | 37.7313174804906 | -122.39177919347401 | (37.7313174804906, -122.391779193474) | |||
| 16950 | 16950 | 25174 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3062 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000130.8652 | 2105433.23803 | 37.761125030928895 | -122.44266313540199 | (37.7611250309289, -122.442663135402) | |||
| 17046 | 17046 | 7442 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2533 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008266.30803 | 2103660.34256 | 37.7567174706459 | -122.414400595608 | (37.7567174706459, -122.414400595608) | |||
| 17173 | 17173 | 7598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3106 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008393.64019 | 2100437.22493 | 37.7478746680801 | -122.41373225995702 | (37.7478746680801, -122.413732259957) | |||
| 17428 | 17428 | 7555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2906 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.30695 | 2101471.08552 | 37.750709860893394 | -122.41402439212601 | (37.7507098608934, -122.414024392126) | |||
| 17997 | 17997 | 7485 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2676 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008262.291898999 | 2102845.0627354 | 37.754478671863495 | -122.414356800841 | (37.7544786718635, -122.414356800841) | |||
| 19439 | 19439 | 28789 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2948 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6008341.65854 | 2101291.24867 | 37.7502167068411 | -122.413972416691 | (37.7502167068411, -122.413972416691) | ||
| 19576 | 19576 | 7525 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2804 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008301.92426 | 2102042.90132 | 37.7522783441942 | -122.41416299292601 | (37.7522783441942, -122.414162992926) | |||
| 20521 | 20521 | 7487 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008318.247830001 | 2102788.20898 | 37.7543257074831 | -122.41415926793002 | (37.7543257074831, -122.41415926793) | |||
| 20914 | 20914 | 4566 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106X Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2016 12:00:00 AM | 12 | 3X3 | 6006479.71302 | 2098542.22808 | 37.742563769401606 | -122.42021607152901 | (37.7425637694016, -122.420216071529) | ||
| 21798 | 21798 | 7504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2721 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.67294 | 2102549.63808 | 37.75367134367279 | -122.414099421647 | (37.7536713436728, -122.414099421647) | |||
| 21975 | 21975 | 7428 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2507 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008259.11324 | 2103798.38895 | 37.757096110403 | -122.414435245589 | (37.757096110403, -122.414435245589) | |||
| 22148 | 22148 | 7498 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008269.84083 | 2102643.6447900003 | 37.7539260478636 | -122.414316444251 | (37.7539260478636, -122.414316444251) | |||
| 77382 | 77382 | 22315 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
| 83814 | 83814 | 2633 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1884 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004452.48891 | 2115034.49338 | 37.7877331379393 | -122.428400842266 | (37.7877331379393, -122.428400842266) | |||
| 85712 | 85712 | 7527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008275.78702 | 2102017.83073 | 37.7522080378675 | -122.41425160630101 | (37.7522080378675, -122.414251606301) | |||
| 85950 | 85950 | 1325 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 4051X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5991764.76245 | 2086963.37686 | 37.709930989883496 | -122.47025258193399 | (37.7099309898835, -122.470252581934) | |||
| 87102 | 87102 | 17494 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 98X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6001936.09269 | 2091434.7408900002 | 37.722791174441106 | -122.43541823832199 | (37.7227911744411, -122.435418238322) | |||
| 87740 | 87740 | 18003 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2676 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001111.9740699995 | 2114914.60088 | 37.7872143495752 | -122.439949758664 | (37.7872143495752, -122.439949758664) | |||
| 90709 | 90709 | 7638 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6008420.15681 | 2099616.94183 | 37.7456238423258 | -122.413582558723 | (37.7456238423258, -122.413582558723) | |||
| 92145 | 92145 | 13322 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 435X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002777.3722738 | 2090962.3160143998 | 37.72154174394979 | -122.432476389775 | (37.7215417439498, -122.432476389775) | |||
| 95162 | 95162 | 18010 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2706 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6000978.8550569 | 2114898.1888313 | 37.787161707579 | -122.440409143182 | (37.787161707579, -122.440409143182) | |||
| 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) | ||
| 97919 | 97919 | 11876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 102436 | 102436 | 17547 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 548X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003010.146575901 | 2090756.9744765 | 37.72099111878529 | -122.431657099656 | (37.7209911187853, -122.431657099656) | |||
| 104484 | 104484 | 5323 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2689X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001088.8002445 | 2114863.0175008997 | 37.78707139571671 | -122.44002623476001 | (37.7870713957167, -122.44002623476) | |||
| 119628 | 119628 | 7596 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3085 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008718.17 | 2100791.65733 | 37.748866079627206 | -122.41263509881 | (37.7488660796272, -122.41263509881) | |||
| 124040 | 124040 | 17622 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004279.363726401 | 2089959.3319014 | 37.7188728276872 | -122.427213003456 | (37.7188728276872, -122.427213003456) | |||
| 138568 | 138568 | 17533 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 445X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002799.2909021 | 2090948.5412154999 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | |||
| 141190 | 141190 | 17484 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 220X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002262.892318901 | 2091226.5881509997 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | |||
| 141612 | 141612 | 7593 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3065 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 6 | 3X3 | 6008718.17 | 2100791.65733 | 37.748866079627206 | -122.41263509881 | (37.7488660796272, -122.41263509881) | ||
| 1166 | 1166 | 251466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 6069 | 6069 | 17933 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2418 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002186.7609 | 2115068.0006 | 37.7876966699691 | -122.43624221533301 | (37.7876966699691, -122.436242215333) | |||
| 8667 | 8667 | 6037 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1822 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51912 | 6001625.9468 | 2112554.8978 | 37.7807644518495 | -122.43800243798 | (37.7807644518495, -122.43800243798) | |
| 8832 | 8832 | 101524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001795.96309 | 2118760.54126 | 37.7978132173675 | -122.437858876082 | (37.7978132173675, -122.437858876082) | |||
| 10054 | 10054 | 173830 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000494.0 | 2114864.0 | 37.7870402148899 | -122.442084176412 | (37.7870402148899, -122.442084176412) | ||||
| 10157 | 10157 | 173899 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
| 11249 | 11249 | 17536 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003012.06568 | 2090814.03767 | 37.72114791043521 | -122.431654537837 | (37.7211479104352, -122.431654537837) | |||
| 11358 | 11358 | 17550 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 600 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6003170.84982 | 2090661.1447 | 37.7207370992233 | -122.431094760237 | (37.7207370992233, -122.431094760237) | |||
| 11718 | 11718 | 17568 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6003419.6169300005 | 2090505.6702299998 | 37.720324294201 | -122.430223763218 | (37.720324294201, -122.430223763218) | |||
| 11871 | 11871 | 17518 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002537.724219999 | 2091058.53445 | 37.72179234573429 | -122.433311659211 | (37.7217923457343, -122.433311659211) | |||
| 12769 | 12769 | 17578 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003799.63122 | 2090323.6743700001 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | |||
| 13173 | 13173 | 17514 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002400.99383 | 2091189.1997099998 | 37.7221433654964 | -122.433793634664 | (37.7221433654964, -122.433793634664) | |||
| 13651 | 13651 | 85765 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008925.8803 | 2109636.8219 | 37.773164535944794 | -122.412542002878 | (37.7731645359448, -122.412542002878) | ||
| 13679 | 13679 | 100568 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 868 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011788.1802 | 2112369.4793 | 37.780828003664 | -122.40283310111 | (37.780828003664, -122.40283310111) | |||
| 13721 | 13721 | 98856 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008586.80061 | 2110533.83683 | 37.7756084919722 | -122.413778389761 | (37.7756084919722, -122.413778389761) | |||
| 14196 | 14196 | 85787 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1211 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 4 | 3x3 | 6009621.8032 | 2110211.384 | 37.7747811809083 | -122.410175277249 | (37.7747811809083, -122.410175277249) | ||
| 15022 | 15022 | 85767 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008747.4583 | 2109466.0696 | 37.7726856753072 | -122.41314711365 | (37.7726856753072, -122.41314711365) | ||
| 15420 | 15420 | 98859 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008542.44899 | 2110581.95524 | 37.775738122962295 | -122.413935218038 | (37.7757381229623, -122.413935218038) | |||
| 15618 | 15618 | 49607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009479.3313 | 2110073.508 | 37.7743946188288 | -122.41065838012199 | (37.7743946188288, -122.410658380122) | |
| 15993 | 15993 | 85779 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009155.5683 | 2109764.3815 | 37.7735276724734 | -122.411756494108 | (37.7735276724734, -122.411756494108) | ||
| 16241 | 16241 | 91032 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010616.6864 | 2111159.8673 | 37.777441210433395 | -122.40680061468099 | (37.7774412104334, -122.406800614681) | ||
| 16370 | 16370 | 85856 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008268.3583 | 2108979.6799 | 37.7713232557148 | -122.414769948978 | (37.7713232557148, -122.414769948978) |
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");