trees
1,985 rows where qSpecies_id = 83 sorted by qCareAssistant descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 810 | 75303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.406566076957 | (37.7648621726769, -122.406566076957) | 8 | 4 | 8 | 28853 | 19 | |||
| 1245 | 213791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 209 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 768064 | 5995620.63174 | 2091343.81767 | 37.7221808240739 | -122.45724272857 | (37.7221808240739, -122.45724272857) | 9 | 8 | 4 | 28861 | 24 |
| 1601 | 39981 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935122 | (37.7325519363025, -122.39310935122) | 10 | 3 | 8 | 58 | 1 | |
| 1758 | 73714 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012133.53509 | 2102840.64813 | 37.7546832563417 | -122.400968639917 | (37.7546832563417, -122.400968639917) | 10 | 3 | 8 | 28856 | 29 | |||
| 2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
| 2641 | 262546 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Apollo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 6012643 | 2094250 | 37.731123564074 | -122.398603958182 | (37.731123564074, -122.398603958182) | 10 | 3 | 8 | 58 | 1 | |||
| 2769 | 81793 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.423593274768 | (37.7767477786156, -122.423593274768) | 7 | 9 | 11 | 28852 | 10 | ||
| 2819 | 70680 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | 8 | 4 | 8 | 28853 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 19624 | 31313 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 709 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 7 | Permit Number 34949 | 6004462.32974 | 2110985.15865 | 37.7766152272516 | -122.428078115713 | (37.7766152272516, -122.428078115713) | 7 | 9 | 11 | 28852 | 10 | |
| 19630 | 69390 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | 9 | 7 | 6 | 28861 | 5 | ||
| 19822 | 67477 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1543 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 8 | Permit Number 30999 | 6001755.4775 | 2111486.6649 | 37.7778387194393 | -122.437477810444 | (37.7778387194393, -122.437477810444) | 15 | 5 | 11 | 29492 | 41 | |
| 20763 | 59417 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25158 | 6004255.489826 | 2098009.09356154 | 37.7409743251647 | -122.427868803942 | (37.7409743251647, -122.427868803942) | 2 | 7 | 5 | 63 | 7 | ||
| 21197 | 63882 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3533 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24589 | 6004803.22751205 | 2103657.20146126 | 37.7565136952268 | -122.426376975449 | (37.7565136952268, -122.426376975449) | 2 | 4 | 5 | 28862 | 22 | ||
| 21516 | 43755 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 264 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 3 | Permit Number 43391 | 5990896.10038 | 2113625.86147 | 37.783088990728 | -122.475200003572 | (37.783088990728, -122.475200003572) | 11 | 6 | 2 | 54 | 26 | |
| 22264 | 60143 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1610 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19673 | 5990907.91625844 | 2104426.54438296 | 37.7578308453136 | -122.474487560238 | (37.7578308453136, -122.474487560238) | 1 | 8 | 4 | 56 | 12 | ||
| 22366 | 108443 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 559 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | 11 | 6 | 2 | 54 | 11 | |||
| 23197 | 95639 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 252 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767405 | 6006489 | 2104635 | 37.7592936513862 | -122.420616372933 | (37.7592936513862, -122.420616372933) | 2 | 4 | 7 | 28859 | 19 | |
| 23539 | 61014 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.433536447887 | (37.7354717570522, -122.433536447887) | 2 | 7 | 5 | 63 | 7 | ||
| 23910 | 69318 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1466 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1994 12:00:00 AM | 12 | Permit Number 33399 | 6004829.35126 | 2120222.0032 | 37.8019980398336 | -122.427466672957 | (37.8019980398336, -122.427466672957) | 13 | 9 | 1 | 57 | 17 | |
| 25132 | 63326 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 17 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1987 12:00:00 AM | Permit Number 23899 | 6008102.76980253 | 2100057.0858479 | 37.746814552568 | -122.41471118136 | (37.746814552568, -122.41471118136) | 2 | 7 | 7 | 28859 | 2 | ||
| 25420 | 30655 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 35 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.7731639163293 | -122.417349579607 | (37.7731639163293, -122.417349579607) | 8 | 2 | 9 | 28853 | 19 |
| 25796 | 95782 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3619 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767526 | 6005487 | 2104873 | 37.7598906214089 | -122.424098704222 | (37.7598906214089, -122.424098704222) | 2 | 4 | 5 | 28859 | 19 | |
| 26993 | 34292 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2758 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46984 | 6010209.51678065 | 2102837.66319596 | 37.7545675469901 | -122.407622236094 | (37.7545675469901, -122.407622236094) | 2 | 4 | 7 | 28859 | 19 | ||
| 27967 | 30728 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
| 30163 | 96054 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1261 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767682 | 6009524 | 2101832 | 37.7517678233481 | -122.409921957152 | (37.7517678233481, -122.409921957152) | 2 | 4 | 7 | 28859 | 19 | |
| 30900 | 59896 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 906 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19363 | 6009911.82950519 | 2103913.88861057 | 37.7575059527221 | -122.408727642987 | (37.7575059527221, -122.408727642987) | 2 | 4 | 7 | 28859 | 19 | ||
| 30981 | 69392 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.7124713889678 | -122.435199299374 | (37.7124713889678, -122.435199299374) | 9 | 7 | 6 | 28861 | 5 | ||
| 32777 | 68466 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 60 Badger St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32328 | 6002354.04049623 | 2094409.88800929 | 37.7309839839817 | -122.434186069273 | (37.7309839839817, -122.434186069273) | 9 | 7 | 5 | 28861 | 25 | ||
| 33561 | 52155 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1431 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 8 | Permit Number 48347 | 6016125.1581 | 2093936.3843 | 37.7304558237734 | -122.386543560163 | (37.7304558237734, -122.386543560163) | 10 | 3 | 8 | 58 | 1 | |
| 34051 | 52167 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1614 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48360 | 6009265.56204047 | 2099978.30779957 | 37.7466635086597 | -122.410684778697 | (37.7466635086597, -122.410684778697) | 2 | 7 | 7 | 28859 | 2 | ||
| 35054 | 69098 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1658 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33113 | 5992499.06205436 | 2104168.35309074 | 37.757213980438 | -122.468965974451 | (37.757213980438, -122.468965974451) | 1 | 8 | 4 | 56 | 12 | ||
| 35148 | 69289 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1900 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33361 | 5990665.04614057 | 2102443.50433652 | 37.7523718663796 | -122.475182730707 | (37.7523718663796, -122.475182730707) | 1 | 8 | 4 | 29491 | 12 | ||
| 35311 | 63346 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 149 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1987 12:00:00 AM | Permit Number 23920 | 6009928.22027252 | 2099880.94738001 | 37.746433309385 | -122.408386498152 | (37.746433309385, -122.408386498152) | 2 | 7 | 7 | 28859 | 2 | ||
| 35480 | 81725 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1111X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833 | 2102945.53994176 | 37.7551316851739 | -122.391004420622 | (37.7551316851739, -122.391004420622) | 10 | 3 | 8 | 28856 | 29 |
| 35557 | 34252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.8043734614398 | -122.42269665354 | (37.8043734614398, -122.42269665354) | 5 | 1 | 1 | 28858 | 32 | |
| 35936 | 63312 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23878 | 6010125.57376989 | 2099924.9230182 | 37.7465651066228 | -122.407707169195 | (37.7465651066228, -122.407707169195) | 2 | 7 | 7 | 28859 | 2 | ||
| 36675 | 59905 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 925 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19373 | 6009969.2907688 | 2103816.25695251 | 37.7572410963252 | -122.40852203114 | (37.7572410963252, -122.40852203114) | 2 | 4 | 7 | 28859 | 19 | ||
| 38270 | 32235 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 5 | Permit Number 35550 | 6008746.13073 | 2099389.39192 | 37.7450173393701 | -122.412439304646 | (37.7450173393701, -122.412439304646) | 2 | 7 | 7 | 28859 | 2 | |
| 38546 | 63256 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 317 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1987 12:00:00 AM | 3x3 | Permit Number 23809 | 6006547.75913435 | 2104256.57264854 | 37.7582578891884 | -122.420386294584 | (37.7582578891884, -122.420386294584) | 2 | 4 | 7 | 28859 | 19 | |
| 39181 | 67145 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.407735447457 | (37.7448433809463, -122.407735447457) | 2 | 7 | 7 | 28859 | 2 | ||
| 39596 | 47559 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 309 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45421 | 6004167.03194558 | 2101865.16274932 | 37.7515571949372 | -122.428449439906 | (37.7515571949372, -122.428449439906) | 2 | 4 | 5 | 28862 | 22 | ||
| 40024 | 63520 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 821 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | Permit Number 24130 | 6009935.53523311 | 2104433.5559768 | 37.7589341701034 | -122.408682318494 | (37.7589341701034, -122.408682318494) | 2 | 4 | 7 | 28859 | 19 | ||
| 40700 | 30616 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1621 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 7 | Permit Number 34577 | 6008176.3922 | 2108702.7792 | 37.7705577837388 | -122.415068461945 | (37.7705577837388, -122.415068461945) | 8 | 2 | 9 | 28853 | 19 | |
| 41317 | 96048 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1653 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324 | 2099841 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | 2 | 7 | 7 | 28859 | 2 |
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) );