trees
1,985 rows where qSpecies_id = 83
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9712 | 63295 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 29 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23861 | 6008153.74699222 | 2100060.03492719 | 37.7468255141172 | -122.414535115214 | (37.7468255141172, -122.414535115214) | 2 | 7 | 7 | 28859 | 2 | ||
9907 | 30593 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
9955 | 71391 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1531 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6015562.7322 | 2096452.7948 | 37.7373342278764 | -122.388663558077 | (37.7373342278764, -122.388663558077) | 10 | 3 | 8 | 58 | 1 | |||
9959 | 71411 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | 10 | 3 | 8 | 58 | 1 | |||
10024 | 35136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | 9 | 7 | 6 | 28861 | 5 | |
10453 | 75980 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 6555 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5986643.29892 | 2112486.62546 | 37.7797135654944 | -122.489828952967 | (37.7797135654944, -122.489828952967) | 11 | 6 | 2 | 55 | 26 | |||
10498 | 41462 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.7188806981616 | -122.466155833772 | (37.7188806981616, -122.466155833772) | 9 | 8 | 6 | 64 | 24 | |||
10522 | 31312 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.7763910940647 | -122.428032671161 | (37.7763910940647, -122.428032671161) | 7 | 9 | 11 | 28852 | 10 | |||
10528 | 96053 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | 2 | 7 | 7 | 28859 | 2 | |
10757 | 238849 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 199X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007801.00794 | 2096580.35759 | 37.737251268132 | -122.41550854151 | (37.737251268132, -122.41550854151) | 2 | 7 | 7 | 28859 | 2 | |||
10805 | 38591 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40546 | 6015135.7246 | 2094671.1157 | 37.7324184244611 | -122.390015508372 | (37.7324184244611, -122.390015508372) | 10 | 3 | 8 | 58 | 1 | |
10812 | 58694 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3633 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1979 12:00:00 AM | 4 | Permit Number 17970 | 5996855.26576 | 2115960.61486 | 37.7898431897625 | -122.454752572401 | (37.7898431897625, -122.454752572401) | 11 | 6 | 1 | 54 | 31 | ||
10955 | 116918 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
10982 | 96718 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2011 12:00:00 AM | 8 | Permit Number 767223 | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | ||
10984 | 138446 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1820 POST ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003295.7109 | 2114182.3135 | 37.7853277416205 | -122.432342183898 | (37.7853277416205, -122.432342183898) | 13 | 9 | 11 | 29490 | 13 | |||
11012 | 7356 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.7907946063198 | -122.434307574482 | (37.7907946063198, -122.434307574482) | 13 | 9 | 1 | 29490 | 27 | ||
11017 | 88581 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 515 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.70117 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | 11 | 6 | 2 | 55 | 26 | ||
11540 | 102493 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2001 McAllister St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5999461.6709 | 2111166.2585 | 37.7768282889466 | -122.445389813922 | (37.7768282889466, -122.445389813922) | 15 | 5 | 11 | 29492 | 16 | |||
11605 | 213995 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 6 | Width 3ft | Permit Number 32783 | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.443073900754 | (37.729960150431, -122.443073900754) | 9 | 7 | 4 | 63 | 40 | |
11654 | 259082 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1023 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009473.49904 | 2087244.25049 | 37.7117101453965 | -122.409067379874 | (37.7117101453965, -122.409067379874) | 9 | 7 | 8 | 309 | 39 | |||
11660 | 120676 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003502 | 2105614 | 37.7618129556584 | -122.431016735878 | (37.7618129556584, -122.431016735878) | 15 | 4 | 5 | 28862 | 3 | ||||
11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
11688 | 141943 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1101 GOLDEN GATE AVE | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004162.7275 | 2112162.4936 | 37.77983094307 | -122.429198496132 | (37.77983094307, -122.429198496132) | 7 | 9 | 11 | 29490 | 41 | |||
11751 | 142826 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1731 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | 13 | 9 | 10 | 28858 | 32 | |||
11829 | 259084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1041 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009428.83146 | 2087260.92835 | 37.7117534370142 | -122.409222939968 | (37.7117534370142, -122.409222939968) | 9 | 7 | 8 | 309 | 39 | |||
12053 | 72144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000049.527 | 2091859.62504 | 37.7238504846937 | -122.441970156497 | (37.7238504846937, -122.441970156497) | 9 | 7 | 6 | 28861 | 25 | |||
12061 | 239335 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3206 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008987.26449 | 2099969.0979 | 37.7466226130369 | -122.411646456035 | (37.7466226130369, -122.411646456035) | 2 | 7 | 7 | 28859 | 2 | |||
12071 | 81939 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | 13 | 9 | 10 | 28858 | 32 | ||
12162 | 239887 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007798.48319 | 2096533.32571 | 37.7371219869923 | -122.415513941937 | (37.7371219869923, -122.415513941937) | 2 | 7 | 7 | 28859 | 2 | |||
12199 | 30624 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1655 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 7 | Permit Number 35324 | 6008124.7709 | 2108587.5084 | 37.7702383761626 | -122.41523885993 | (37.7702383761626, -122.41523885993) | 8 | 2 | 9 | 28853 | 19 | |
12316 | 124412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3900 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5996120.28006 | 2115251.26489 | 37.7878533198568 | -122.45724420279 | (37.7878533198568, -122.45724420279) | 11 | 6 | 1 | 54 | 31 | |||
12336 | 85628 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1470 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015957.8963 | 2094137.5833 | 37.7309990152261 | -122.387135841638 | (37.7309990152261, -122.387135841638) | 10 | 3 | 8 | 58 | 1 | ||
12876 | 138454 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1901 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002945.3416 | 2114886.8927 | 37.7872424644786 | -122.433604726492 | (37.7872424644786, -122.433604726492) | 13 | 9 | 11 | 29490 | 27 | |||
13015 | 61560 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2117 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 9 | Permit Number 21520 | 6012109.3133 | 2102790.69622 | 37.7545447481545 | -122.401048896306 | (37.7545447481545, -122.401048896306) | 10 | 3 | 8 | 28856 | 29 | |
13059 | 58732 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2385 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | 13 | 9 | 1 | 29490 | 27 | ||
13308 | 74007 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2030 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6012344.40813 | 2102849.33443 | 37.7547188676881 | -122.40023998939 | (37.7547188676881, -122.40023998939) | 10 | 3 | 8 | 28856 | 29 | ||
13315 | 34250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.422766446326 | (37.8043668775019, -122.422766446326) | 5 | 1 | 1 | 28858 | 32 | |
13336 | 136240 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006640.65595 | 2116994.76492 | 37.7932391350289 | -122.420969421921 | (37.7932391350289, -122.420969421921) | 13 | 9 | 10 | 28858 | 32 | |||
13381 | 238854 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007995.79542 | 2096561.34412 | 37.7372100081447 | -122.414833724393 | (37.7372100081447, -122.414833724393) | 2 | 7 | 7 | 28859 | 2 | |||
13481 | 261122 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 56 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6014135.16378 | 2094796.13766 | 37.7327061665323 | -122.393483454939 | (37.7327061665323, -122.393483454939) | 10 | 3 | 8 | 58 | 1 | ||
13494 | 83178 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 743 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 51518 | 5990037.32656 | 2110290.06846 | 37.7738800155956 | -122.477927036337 | (37.7738800155956, -122.477927036337) | 11 | 6 | 2 | 55 | 26 | |
13512 | 259080 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1001 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
13556 | 264663 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1078 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014476.86082 | 2089998.27904 | 37.7195511879651 | -122.391966726039 | (37.7195511879651, -122.391966726039) | 10 | 3 | 8 | 58 | 1 | |||
13606 | 264731 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1515 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014824 | 2093132 | 37.7281750296252 | -122.390985688648 | (37.7281750296252, -122.390985688648) | 10 | 3 | 8 | 58 | 1 | ||||
13618 | 143549 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2245 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002240.1517 | 2118427.2493 | 37.7969233328664 | -122.436297997013 | (37.7969233328664, -122.436297997013) | 13 | 9 | 1 | 57 | 17 | |||
14031 | 213996 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999758.63525 | 2094089.70358 | 37.7299571835696 | -122.443135805584 | (37.7299571835696, -122.443135805584) | 9 | 7 | 4 | 63 | 40 | |||
14032 | 49886 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | |||
14084 | 258134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011357.19142 | 2092082.52958 | 37.7251004206417 | -122.402896861649 | (37.7251004206417, -122.402896861649) | 10 | 3 | 7 | 309 | 28 | |||
14166 | 197170 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1510X Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016200.17093 | 2097456.77974 | 37.740126273917 | -122.386529601766 | (37.740126273917, -122.386529601766) | 10 | 3 | 8 | 58 | 1 | |||
14223 | 34240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | 2 | 4 | 5 | 28862 | 22 | |||
14546 | 63665 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.7475274359015 | -122.428684519984 | (37.7475274359015, -122.428684519984) | 2 | 4 | 5 | 63 | 22 | ||
14662 | 248025 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 439 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6010001 | 2098476 | 37.7425797058833 | -122.408035769643 | (37.7425797058833, -122.408035769643) | 10 | 7 | 7 | 28859 | 2 | |||
14804 | 264658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 04:59:00 PM | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.391072554716 | (37.7211221378179, -122.391072554716) | 10 | 3 | 8 | 58 | 1 | |||
15005 | 261438 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 384 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007303 | 2095696 | 37.7347950116026 | -122.417167741106 | (37.7347950116026, -122.417167741106) | 2 | 7 | 7 | 28859 | 2 | ||||
15188 | 180603 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6009034.51206 | 2093748.44623 | 37.7295447050207 | -122.411043765455 | (37.7295447050207, -122.411043765455) | 9 | 3 | 7 | 309 | 28 | ||
15192 | 65109 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 145 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 5 | Permit Number 27078 | 5988958.23473 | 2114388.99376 | 37.7850718280894 | -122.481960071321 | (37.7850718280894, -122.481960071321) | 11 | 6 | 2 | 55 | 26 | |
15242 | 49368 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.404927851118 | (37.7149060701976, -122.404927851118) | 9 | 7 | 8 | 309 | 39 | |||
15461 | 197112 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2051 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012308.80023 | 2102801.31444 | 37.7545850296985 | -122.400359759302 | (37.7545850296985, -122.400359759302) | 10 | 3 | 8 | 28856 | 29 | |||
15478 | 252965 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:04:00 PM | 3 | |||||||||||||
15527 | 19972 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 STAIRWAY44 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
15634 | 136235 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008235.61174 | 2115647.76794 | 37.7896303876902 | -122.415355351862 | (37.7896303876902, -122.415355351862) | 5 | 1 | 10 | 28858 | 21 | |||
15852 | 239886 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007782.31959 | 2096534.49049 | 37.737124276671 | -122.415569909436 | (37.737124276671, -122.415569909436) | 2 | 7 | 7 | 28859 | 2 | |||
15862 | 99761 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485 | 2101232 | 37.7497233531083 | -122.434220849449 | (37.7497233531083, -122.434220849449) | 2 | 4 | 5 | 28862 | 22 | |||
15913 | 258136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 6011373.95167 | 2092087.62826 | 37.7251153564238 | -122.402839281337 | (37.7251153564238, -122.402839281337) | 10 | 3 | 7 | 309 | 28 | ||
15928 | 197140 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 53 Pomona St | 2 | : | Tree | Private 2 | 3 | Width 5ft | 6014151.58684 | 2094423.96338 | 37.7316851643341 | -122.39340063984 | (37.7316851643341, -122.39340063984) | 10 | 3 | 8 | 58 | 1 | |||
15988 | 136243 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006695.60451 | 2117001.64443 | 37.7932611216587 | -122.42077978457 | (37.7932611216587, -122.42077978457) | 13 | 9 | 10 | 28858 | 32 | |||
16016 | 5120 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2016 10:06:00 AM | 3 | 5X5 | 6002461.05615 | 2096042.42458 | 37.7354726294434 | -122.433932747209 | (37.7354726294434, -122.433932747209) | 2 | 7 | 5 | 63 | 7 | ||
16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
16300 | 248300 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3175 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006753.7624 | 2099865.7323 | 37.74621325229 | -122.419362356984 | (37.74621325229, -122.419362356984) | 2 | 7 | 7 | 28859 | 2 | |||
16436 | 142218 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 CENTRAL AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999746.1848 | 2109905.9886 | 37.773384146155 | -122.44431500945 | (37.773384146155, -122.44431500945) | 15 | 5 | 11 | 29492 | 16 | |||
16463 | 106806 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 167 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5996526.1156 | 2113255.0824 | 37.7823956347772 | -122.455695748043 | (37.7823956347772, -122.455695748043) | 11 | 6 | 1 | 54 | 31 | ||||
16482 | 138377 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2019 12:00:00 AM | 3 | Width 0ft | 6002995.393 | 2114531.5766 | 37.7862696963806 | -122.433406159019 | (37.7862696963806, -122.433406159019) | 13 | 9 | 11 | 29490 | 27 | ||
16496 | 60642 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | 2 | 7 | 5 | 63 | 7 | ||
16514 | 136241 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006661.22108 | 2116996.66069 | 37.7932454995431 | -122.42089839975 | (37.7932454995431, -122.42089839975) | 13 | 9 | 10 | 28858 | 32 | |||
16573 | 33529 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 171 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37639 | 6007349.55714183 | 2098075.84761469 | 37.7413321670111 | -122.417175357737 | (37.7413321670111, -122.417175357737) | 2 | 7 | 7 | 28859 | 2 | |||
17139 | 261451 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 295 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006893 | 2095807 | 37.7350767190782 | -122.41859312449 | (37.7350767190782, -122.41859312449) | 2 | 7 | 7 | 28859 | 2 | ||||
17262 | 258984 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 784344 | 6010137 | 2099925 | 37.7465659576292 | -122.407667663761 | (37.7465659576292, -122.407667663761) | 2 | 7 | 7 | 28859 | 2 | |||
17354 | 88467 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Augusta St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176 | 2095454 | 37.7343476550611 | -122.403760347511 | (37.7343476550611, -122.403760347511) | 10 | 3 | 8 | 58 | 1 | |||
17469 | 239268 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 43 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006498.06002 | 2108217.35728 | 37.769130472909 | -122.420839370946 | (37.769130472909, -122.420839370946) | 8 | 4 | 7 | 28853 | 19 | |||
17572 | 7280 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2020 02:03:00 PM | 3 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||
17729 | 197162 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 123 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016438.8167 | 2095743.2053 | 37.735434352517 | -122.385585060917 | (37.735434352517, -122.385585060917) | 10 | 3 | 8 | 58 | 1 | |||
17844 | 239290 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 870 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009903.27648 | 2104148.96892 | 37.7581509513321 | -122.408773807391 | (37.7581509513321, -122.408773807391) | 2 | 4 | 7 | 28859 | 19 | |||
17871 | 244081 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 43 | Width 0ft | 5998790.9441 | 2109040.9235 | 37.7709543519473 | -122.447557026238 | (37.7709543519473, -122.447557026238) | 15 | 5 | 11 | 29492 | 9 | ||
18101 | 48665 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1715REVISED Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2002 12:00:00 AM | 3 | Permit Number 769839 | 6004834.5382 | 2115307.6761 | 37.7885048406598 | -122.427098489488 | (37.7885048406598, -122.427098489488) | 13 | 9 | 11 | 28858 | 27 | |
18235 | 42453 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | 9 | 7 | 4 | 59 | 40 | ||
18403 | 238853 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007982.71274 | 2096562.40282 | 37.7372121799922 | -122.414879032248 | (37.7372121799922, -122.414879032248) | 2 | 7 | 7 | 28859 | 2 | |||
18559 | 70412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | 9 | 7 | 7 | 309 | 5 | |||
18577 | 147771 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 275 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993980.24137 | 2113705.13134 | 37.7834849172426 | -122.464535973179 | (37.7834849172426, -122.464535973179) | 11 | 6 | 2 | 54 | 11 | |||
18843 | 65788 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1990 12:00:00 AM | 7 | Permit Number 28756 | 5998021.12629 | 2115778.19726 | 37.7894091238674 | -122.450705664532 | (37.7894091238674, -122.450705664532) | 11 | 6 | 1 | 54 | 31 | ||
18871 | 108376 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 995X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.72698 | 2111024.20368 | 37.7766548889563 | -122.432206462364 | (37.7766548889563, -122.432206462364) | 15 | 9 | 11 | 29492 | 10 | ||
18940 | 137981 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1940 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6002965.4976 | 2115097.1921 | 37.7878210367847 | -122.433550025903 | (37.7878210367847, -122.433550025903) | 13 | 9 | 11 | 29490 | 27 | |||
18976 | 44337 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1386 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2001 12:00:00 AM | 10 | Permit Number 43722 | 6016111.02072 | 2094370.93672 | 37.7316482354559 | -122.386622725671 | (37.7316482354559, -122.386622725671) | 10 | 3 | 8 | 58 | 1 | ||
19055 | 61576 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2019 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 7 | Permit Number 21538 | 6012377.33608 | 2102802.45934 | 37.754591994948 | -122.400122823023 | (37.754591994948, -122.400122823023) | 10 | 3 | 8 | 28856 | 29 | |
19096 | 73459 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6010582.51713 | 2106716.25151 | 37.7652381522352 | -122.406605601283 | (37.7652381522352, -122.406605601283) | 8 | 4 | 8 | 28853 | 19 | |||
19125 | 72279 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | 11 | 6 | 2 | 55 | 26 | |||
19372 | 259083 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1029 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009458.60985 | 2087249.80978 | 37.7117245759679 | -122.409119233208 | (37.7117245759679, -122.409119233208) | 9 | 7 | 8 | 309 | 39 | |||
19440 | 262431 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 231 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6002625 | 2092333 | 37.7252966937933 | -122.433100982945 | (37.7252966937933, -122.433100982945) | 9 | 7 | 6 | 28861 | 5 | ||
19495 | 102487 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | 15 | 5 | 11 | 29492 | 16 | |||
19522 | 75060 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 390x Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010594.46043 | 2106517.2504 | 37.7646924085388 | -122.406550267789 | (37.7646924085388, -122.406550267789) | 8 | 4 | 8 | 28853 | 19 | |||
19617 | 78383 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );