trees
1,985 rows where qSpecies_id = 83 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3095 | 28342 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3115 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007068 | 2100404 | 37.7477089074097 | -122.418313917469 | (37.7477089074097, -122.418313917469) | 2 | 7 | 7 | 28859 | 2 | ||
3341 | 71320 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004289.26563 | 2090538.00218 | 37.7204622897839 | -122.427219973626 | (37.7204622897839, -122.427219973626) | 9 | 7 | 6 | 28861 | 5 | |||
3450 | 52146 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2005 12:00:00 AM | Permit Number 48337 | |||||||||||||
3470 | 260424 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 751 Goettingen St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010808.85842 | 2091198.73798 | 37.7226430782423 | -122.404730210147 | (37.7226430782423, -122.404730210147) | 10 | 3 | 7 | 309 | 28 | |||
3492 | 30592 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
3545 | 70593 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | 9 | 7 | 6 | 28861 | 5 | |||
3565 | 48664 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1715REVISED Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2002 12:00:00 AM | 2 | Permit Number 45950 | 6004825.1941 | 2115340.0212 | 37.7885931237935 | -122.427133123433 | (37.7885931237935, -122.427133123433) | 13 | 9 | 11 | 28858 | 27 | |
3614 | 72128 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2012 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6012399.20292 | 2102851.6444 | 37.7547282656006 | -122.400050655116 | (37.7547282656006, -122.400050655116) | 10 | 3 | 8 | 28856 | 29 | |||
3781 | 46872 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | 5 | 9 | 10 | 28858 | 32 | |
3900 | 36339 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | ||
3969 | 73442 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004223.02083 | 2091452.87155 | 37.7229705736272 | -122.427514104094 | (37.7229705736272, -122.427514104094) | 9 | 7 | 6 | 28861 | 5 | |||
3973 | 138376 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2020 02:07:00 PM | 3 | Width 0ft | 6002992.9152 | 2114550.4079 | 37.786321261782 | -122.43341607774 | (37.786321261782, -122.43341607774) | 13 | 9 | 11 | 29490 | 27 | ||
4044 | 11466 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.96757 | 2095560.66167 | 37.7349522709331 | -122.384375566285 | (37.7349522709331, -122.384375566285) | 10 | 3 | 8 | 58 | 1 | ||
4284 | 244079 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998854.6041 | 2109046.905 | 37.7709744135065 | -122.447337256007 | (37.7709744135065, -122.447337256007) | 15 | 5 | 11 | 29492 | 9 | |||
4499 | 238850 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 199X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007815.26144 | 2096578.28635 | 37.7372463821225 | -122.415459113874 | (37.7372463821225, -122.415459113874) | 2 | 7 | 7 | 28859 | 2 | |||
4611 | 238852 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007968.84006 | 2096563.6752 | 37.7372148941494 | -122.414927086625 | (37.7372148941494, -122.414927086625) | 2 | 7 | 7 | 28859 | 2 | |||
4690 | 66408 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | 2 | 7 | 7 | 28859 | 2 | ||
4783 | 239336 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3206 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008986.81884 | 2099989.09053 | 37.7466774833742 | -122.411649409412 | (37.7466774833742, -122.411649409412) | 2 | 7 | 7 | 28859 | 2 | |||
4805 | 74096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001902.78384 | 2087667.72771 | 37.7124459030227 | -122.435264062185 | (37.7124459030227, -122.435264062185) | 9 | 7 | 6 | 28861 | 5 | |||
5043 | 238851 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6007952.96662 | 2096564.19788 | 37.7372154373458 | -122.414982005523 | (37.7372154373458, -122.414982005523) | 2 | 7 | 7 | 28859 | 2 | |||
5177 | 179302 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 200 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003690.09434 | 2092638.18195 | 37.7261950154772 | -122.429440808968 | (37.7261950154772, -122.429440808968) | 9 | 7 | 6 | 28861 | 5 | |||
5553 | 70621 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004140.66992 | 2091658.50291 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | 9 | 7 | 6 | 28861 | 5 | |||
5604 | 197168 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017908.19776 | 2093591.9406 | 37.729608594643 | -122.380355342249 | (37.729608594643, -122.380355342249) | 10 | 3 | 8 | 58 | 1 | |||
5677 | 123020 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 152 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993993.9147 | 2114546.78107 | 37.78579664693 | -122.464549802121 | (37.78579664693, -122.464549802121) | 11 | 6 | 1 | 54 | 11 | |||
5684 | 83143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6016637.51216 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | 10 | 3 | 8 | 58 | 1 | |||
5790 | 136106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2362 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002236.43409 | 2117779.37436 | 37.7951442255914 | -122.436264471651 | (37.7951442255914, -122.436264471651) | 13 | 9 | 1 | 57 | 17 | |||
5861 | 141599 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 30 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998723.6664 | 2110574.4541 | 37.7751611896291 | -122.447900165728 | (37.7751611896291, -122.447900165728) | 15 | 5 | 11 | 29492 | 16 | |||
5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
5972 | 136242 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006678.63942 | 2116999.88567 | 37.7932553363267 | -122.420838360099 | (37.7932553363267, -122.420838360099) | 13 | 9 | 10 | 28858 | 32 | |||
6129 | 85658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.3904746745 | (37.7326823614983, -122.3904746745) | 10 | 3 | 8 | 58 | 1 | ||
6142 | 73715 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2012 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012416.66148 | 2102853.00124 | 37.7547329645749 | -122.399990373555 | (37.7547329645749, -122.399990373555) | 10 | 3 | 8 | 28856 | 29 | |||
6199 | 244531 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | 15 | 5 | 11 | 29492 | 9 | |||
6265 | 239278 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 248 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006484.02549 | 2104654.1559 | 37.7593459686731 | -122.420634937075 | (37.7593459686731, -122.420634937075) | 2 | 4 | 7 | 28859 | 19 | |||
6386 | 238848 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 199x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007787.51207 | 2096580.63387 | 37.7372512681409 | -122.415555222622 | (37.7372512681409, -122.415555222622) | 2 | 7 | 7 | 28859 | 2 | |||
6409 | 61556 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2098X 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1984 12:00:00 AM | Permit Number 21516 | 6012360 | 2102825 | 37.7546529200548 | -122.400184359163 | (37.7546529200548, -122.400184359163) | 10 | 3 | 8 | 28856 | 29 | ||
6488 | 239304 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 821 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009936.73456 | 2104250.32887 | 37.7584311369078 | -122.408665244799 | (37.7584311369078, -122.408665244799) | 2 | 4 | 7 | 28859 | 19 | |||
7088 | 70592 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004234.1327 | 2091472.60684 | 37.7230253908821 | -122.4274770979 | (37.7230253908821, -122.4274770979) | 9 | 7 | 6 | 28861 | 5 | |||
7217 | 138378 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 10:23:00 AM | 3 | Width 0ft | 6002996.8797 | 2114513.7365 | 37.7862207963337 | -122.433399740113 | (37.7862207963337, -122.433399740113) | 13 | 9 | 11 | 29490 | 27 | ||
7485 | 61793 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2104 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 14 | Permit Number 21816 | 6012153.01638 | 2102841.49501 | 37.7546866683749 | -122.400901327432 | (37.7546866683749, -122.400901327432) | 10 | 3 | 8 | 28856 | 29 | |
7523 | 254506 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1928 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | 6004702.10653 | 2115410.06007 | 37.7887784716518 | -122.427563979846 | (37.7887784716518, -122.427563979846) | 13 | 9 | 11 | 28858 | 27 | |
7527 | 136248 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.8008927343603 | -122.414423864695 | (37.8008927343603, -122.414423864695) | 5 | 1 | 10 | 308 | 32 | |||
7715 | 260428 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 745 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
7723 | 69741 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010157.17597 | 2089735.57492 | 37.7185890892048 | -122.406879871126 | (37.7185890892048, -122.406879871126) | 10 | 7 | 8 | 309 | 39 | |||
7946 | 74150 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 740 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004499.396 | 2111088.6935 | 37.7769016055642 | -122.427957272174 | (37.7769016055642, -122.427957272174) | 7 | 9 | 11 | 28852 | 10 | |||
7988 | 24147 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | 10 | 3 | 8 | 58 | 1 | |||
8064 | 240144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998176.37667 | 2106172.12741 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | 15 | 5 | 11 | 29492 | 9 | |||
8128 | 90393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
8202 | 46512 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2188 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2002 12:00:00 AM | 8 | Permit Number 44678 | 6002606.94356 | 2118178.75715 | 37.7962618715428 | -122.435011030753 | (37.7962618715428, -122.435011030753) | 13 | 9 | 1 | 57 | 17 | |
8259 | 138334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1971 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002917.5822 | 2115096.7114 | 37.7878169981836 | -122.433715769701 | (37.7878169981836, -122.433715769701) | 13 | 9 | 11 | 29490 | 27 | |||
8277 | 75145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010592.19708 | 2106537.02068 | 37.7647465666182 | -122.406559489431 | (37.7647465666182, -122.406559489431) | 8 | 4 | 8 | 28853 | 19 | |||
8293 | 69460 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 446 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 3 | Permit Number 33570 | 5985026.61463 | 2112867.05169 | 37.7806635770894 | -122.495449750327 | (37.7806635770894, -122.495449750327) | 11 | 6 | 2 | 55 | 26 | |
8502 | 73401 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | 13 | 9 | 10 | 28858 | 32 | |||
8584 | 21731 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1963 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1997 12:00:00 AM | 3 | 3X3 | 6003249.5114044 | 2114468.5359796 | 37.7861110165037 | -122.432522471352 | (37.7861110165037, -122.432522471352) | 13 | 9 | 11 | 29490 | 13 | ||
8679 | 63303 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3270 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23869 | 6008997.33415907 | 2099641.55348585 | 37.7457238133599 | -122.411588497717 | (37.7457238133599, -122.411588497717) | 2 | 7 | 7 | 28859 | 2 | ||
8876 | 136239 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | 13 | 9 | 10 | 28858 | 32 | |||
8966 | 38869 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2439 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40694 | 5987327.75302366 | 2098677.68678111 | 37.7418379454862 | -122.486447023752 | (37.7418379454862, -122.486447023752) | 1 | 8 | 3 | 29491 | 35 | ||
9017 | 239285 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2750 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009605.36999 | 2105497.87366 | 37.7618380476199 | -122.409899320599 | (37.7618380476199, -122.409899320599) | 8 | 4 | 8 | 28859 | 19 | |||
9038 | 239314 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2720 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010004.35252 | 2104577.87538 | 37.7593342927654 | -122.40845449498 | (37.7593342927654, -122.40845449498) | 2 | 4 | 8 | 28859 | 19 | |||
9184 | 88476 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1531 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51429 | 6015551.7 | 2096433.9 | 37.7372817351758 | -122.388700383218 | (37.7372817351758, -122.388700383218) | 10 | 3 | 8 | 58 | 1 | ||
9223 | 60407 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1982 12:00:00 AM | 6 | Permit Number 19988 | 6016156.6712 | 2093985.1354 | 37.7305914290757 | -122.386438011678 | (37.7305914290757, -122.386438011678) | 10 | 3 | 8 | 58 | 1 | |
9288 | 85617 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | 10 | 3 | 8 | 58 | 1 | ||
9515 | 239254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3715 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005705.30849 | 2100786.77225 | 37.748683110957 | -122.423053239242 | (37.748683110957, -122.423053239242) | 2 | 4 | 5 | 28859 | 19 | |||
9559 | 90383 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006777.292282 | 2110019.638696 | 37.7740948433326 | -122.420001435971 | (37.7740948433326, -122.420001435971) | 8 | 2 | 9 | 28853 | 19 | ||
9648 | 72127 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6012120.03521 | 2102839.43148 | 37.7546791626274 | -122.401015240957 | (37.7546791626274, -122.401015240957) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
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 |
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) );