trees
1,985 rows where qSpecies_id = 83 sorted by YCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152827 | 136250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2711 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006868.56519 | 2121594.39083 | 37.8058813915667 | -122.420507486038 | (37.8058813915667, -122.420507486038) | 5 | 1 | 1 | 28858 | 32 | |||
| 109327 | 11173 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2717 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006873.7712695 | 2121594.1615237 | 37.8058810553361 | -122.420489453273 | (37.8058810553361, -122.420489453273) | 5 | 1 | 1 | 28858 | 32 | |||
| 96374 | 136251 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2711 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006870.92139 | 2121576.32062 | 37.8058319081714 | -122.420498048543 | (37.8058319081714, -122.420498048543) | 5 | 1 | 1 | 28858 | 32 | |||
| 3017 | 136252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006854.74284 | 2121556.78092 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | 5 | 1 | 1 | 28858 | 32 | |||
| 137653 | 136253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006835.20454 | 2121555.13749 | 37.8057717318427 | -122.420620147698 | (37.8057717318427, -122.420620147698) | 5 | 1 | 1 | 28858 | 32 | |||
| 48947 | 136254 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 804 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006813.5477 | 2121550.30022 | 37.8057572293748 | -122.420694750958 | (37.8057572293748, -122.420694750958) | 5 | 1 | 1 | 28858 | 32 | |||
| 146253 | 91043 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50399 | 6006460.43386 | 2121423.80416 | 37.8053899957025 | -122.421907764657 | (37.8053899957025, -122.421907764657) | 5 | 1 | 1 | 28858 | 32 | |
| 35410 | 87680 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
| 41167 | 87679 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
| 49392 | 87678 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
| 91874 | 91042 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006462.58838 | 2121409.81945 | 37.8053517187772 | -122.421899314626 | (37.8053517187772, -122.421899314626) | 5 | 1 | 1 | 28858 | 32 | |
| 142312 | 91041 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006464.74623 | 2121395.99646 | 37.8053138860806 | -122.421890864574 | (37.8053138860806, -122.421890864574) | 5 | 1 | 1 | 28858 | 32 | |
| 99143 | 69369 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3715 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33463 | 6002534.67482 | 2121358.09542 | 37.8049873980077 | -122.435488648981 | (37.8049873980077, -122.435488648981) | 13 | 9 | 1 | 57 | 17 | |
| 69520 | 136201 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001803.6012 | 2121217.14439 | 37.8045588359743 | -122.438008504412 | (37.8045588359743, -122.438008504412) | 13 | 9 | 1 | 57 | 17 | |||
| 127420 | 69368 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3636 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 13 | Permit Number 33462 | 6002615.01621 | 2121133.09873 | 37.8043741790738 | -122.43519451582 | (37.8043741790738, -122.43519451582) | 13 | 9 | 1 | 57 | 17 | |
| 30443 | 136227 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3630 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002616.6752 | 2121115.11425 | 37.804324892641 | -122.435187487615 | (37.804324892641, -122.435187487615) | 13 | 9 | 1 | 57 | 17 | |||
| 127151 | 69367 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3630 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 11 | Permit Number 33461 | 6002617.53648 | 2121095.37594 | 37.8042707453542 | -122.435183094434 | (37.8042707453542, -122.435183094434) | 13 | 9 | 1 | 57 | 17 | |
| 81997 | 34253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.422635193862 | (37.8043767538414, -122.422635193862) | 5 | 1 | 1 | 28858 | 32 | |
| 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 | |
| 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 | |
| 33350 | 136264 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011327.59811 | 2121029.05024 | 37.8045793836809 | -122.405036399426 | (37.8045793836809, -122.405036399426) | 3 | 1 | 10 | 28860 | 6 | |||
| 174230 | 136263 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | 3 | 1 | 10 | 28860 | 6 | |||
| 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 | ||||
| 153472 | 136260 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 740 Francisco St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | 5 | 1 | 1 | 308 | 32 | |||
| 101595 | 136229 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1695 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002733.14719 | 2120927.81311 | 37.8038172262563 | -122.434771025084 | (37.8038172262563, -122.434771025084) | 13 | 9 | 1 | 57 | 17 | |||
| 167196 | 136228 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1695 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002671.67342 | 2120917.48858 | 37.8037853875576 | -122.434983019554 | (37.8037853875576, -122.434983019554) | 13 | 9 | 1 | 57 | 17 | |||
| 68649 | 136200 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000132.37327 | 2120911.69707 | 37.8036249781613 | -122.443769967932 | (37.8036249781613, -122.443769967932) | 13 | 9 | 1 | 57 | 17 | |||
| 82779 | 136199 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000108.92159 | 2120908.29838 | 37.8036143086235 | -122.443850879042 | (37.8036143086235, -122.443850879042) | 13 | 9 | 1 | 57 | 17 | |||
| 147864 | 136198 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000083.32441 | 2120905.42804 | 37.8036049673534 | -122.443939252695 | (37.8036049673534, -122.443939252695) | 13 | 9 | 1 | 57 | 17 | |||
| 81316 | 136197 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2101 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000062.25305 | 2120901.6465 | 37.8035933822804 | -122.444011899049 | (37.8035933822804, -122.444011899049) | 13 | 9 | 1 | 57 | 17 | |||
| 181802 | 136223 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3699 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000162.37398 | 2120896.27063 | 37.8035843324119 | -122.443665040435 | (37.8035843324119, -122.443665040435) | 13 | 9 | 1 | 57 | 17 | |||
| 38148 | 136224 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3699 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000162.1216 | 2120884.12041 | 37.8035509567753 | -122.443665040422 | (37.8035509567753, -122.443665040422) | 13 | 9 | 1 | 57 | 17 | |||
| 170365 | 136225 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3699 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000164.78748 | 2120871.42318 | 37.803516245636 | -122.443654902352 | (37.803516245636, -122.443654902352) | 13 | 9 | 1 | 57 | 17 | |||
| 28692 | 48873 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1993 12:00:00 AM | 12 | 3x3 | Permit Number 46081 | 6011769.28798 | 2120850.10657 | 37.8041127290715 | -122.40349528428 | (37.8041127290715, -122.40349528428) | 3 | 1 | 10 | 28860 | 6 | |
| 115566 | 48872 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46081 | 6011751.8076 | 2120847.07255 | 37.8041034220013 | -122.403555563145 | (37.8041034220013, -122.403555563145) | 3 | 1 | 10 | 28860 | 6 | |
| 57088 | 101338 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32655 | 6008893.4466 | 2120790.6495 | 37.8037884230366 | -122.413443168222 | (37.8037884230366, -122.413443168222) | 3 | 1 | 10 | 308 | 23 | ||
| 132439 | 95867 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 733 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767588 | 6008296.37826 | 2120666.6947 | 37.8034145323264 | -122.415500582505 | (37.8034145323264, -122.415500582505) | 5 | 1 | 10 | 308 | 32 |
| 151874 | 249824 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1690 Kearny St | 6 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6010866.76079 | 2120642.67591 | 37.8034927229673 | -122.40660393394 | (37.8034927229673, -122.40660393394) | 3 | 1 | 10 | 308 | 23 | |||
| 105709 | 69354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1342 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 11 | Permit Number 33445 | 6004870.03416 | 2120576.9578 | 37.8029749544875 | -122.427351191008 | (37.8029749544875, -122.427351191008) | 13 | 9 | 1 | 57 | 17 | |
| 381 | 136202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | 13 | 9 | 1 | 57 | 17 | |||
| 190087 | 69353 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33444 | 6004896.60555 | 2120531.01209 | 37.8028503021536 | -122.427255965393 | (37.8028503021536, -122.427255965393) | 13 | 9 | 1 | 57 | 17 | |
| 149435 | 136203 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1349 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004849.18598 | 2120525.70738 | 37.8028330549672 | -122.427419683394 | (37.8028330549672, -122.427419683394) | 13 | 9 | 1 | 57 | 17 | |||
| 96801 | 69357 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1355 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33448 | 6004836.73382 | 2120523.45104 | 37.8028261553684 | -122.427462613431 | (37.8028261553684, -122.427462613431) | 13 | 9 | 1 | 57 | 17 | |
| 61599 | 62003 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1446 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 11 | Permit Number 33451 | 6004382.28893 | 2120508.49846 | 37.8027593860996 | -122.429034158913 | (37.8027593860996, -122.429034158913) | 13 | 9 | 1 | 57 | 17 | |
| 102855 | 62004 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1468 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | Permit Number 33452 | 6004296.2409 | 2120497.97462 | 37.8027256192439 | -122.429331178017 | (37.8027256192439, -122.429331178017) | 13 | 9 | 1 | 57 | 17 | |
| 190545 | 69359 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3130 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 6 | Permit Number 33453 | 6004667.12401 | 2120354.39385 | 37.8023523736266 | -122.428037496051 | (37.8023523736266, -122.428037496051) | 13 | 9 | 1 | 57 | 17 | |
| 23046 | 136230 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3100 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004683.10116 | 2120231.33167 | 37.8020153805639 | -122.427973432847 | (37.8020153805639, -122.427973432847) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |
| 86325 | 69319 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1490 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33400 | 6004756.29564 | 2120212.83745 | 37.8019687408272 | -122.427718826659 | (37.8019687408272, -122.427718826659) | 13 | 9 | 1 | 57 | 17 | ||
| 136855 | 136262 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012539.85481 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | 3 | 1 | 10 | 28860 | 6 | ||||
| 149755 | 69320 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1546 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1994 12:00:00 AM | 6 | Permit Number 33401 | 6004443.14953 | 2120171.11922 | 37.8018364748398 | -122.428799484421 | (37.8018364748398, -122.428799484421) | 13 | 9 | 1 | 57 | 17 | |
| 37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 46495 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
| 89745 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
| 105107 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 118931 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
| 193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 27479 | 136226 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | 13 | 9 | 1 | 57 | 17 | |||
| 95171 | 255309 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2127 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | 3x3 | 6008541.64537 | 2120124.79782 | 37.8019404020961 | -122.414613452743 | (37.8019404020961, -122.414613452743) | 5 | 1 | 10 | 308 | 32 | ||
| 186933 | 61372 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3240 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32977 | 5999005.45241 | 2119937.78509 | 37.800886538036 | -122.447599568972 | (37.800886538036, -122.447599568972) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 46070 | 136222 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3159 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999346.78651 | 2119715.31037 | 37.8002951834309 | -122.446402399571 | (37.8002951834309, -122.446402399571) | 13 | 9 | 1 | 57 | 17 | |||
| 65266 | 82025 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 900-904 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50637 | 6008560.7244 | 2119705.22703 | 37.8007894373545 | -122.41451772334 | (37.8007894373545, -122.41451772334) | 5 | 1 | 10 | 308 | 32 | |
| 132522 | 136259 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007679.18524 | 2119665.29199 | 37.8006302222728 | -122.417565392635 | (37.8006302222728, -122.417565392635) | 5 | 1 | 1 | 308 | 32 | |||
| 49749 | 104043 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782596 | 6006090.81059 | 2119657.40346 | 37.8005190588724 | -122.423061266572 | (37.8005190588724, -122.423061266572) | 13 | 9 | 1 | 28858 | 32 | |
| 63186 | 136258 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007680.05725 | 2119655.03643 | 37.8006021121473 | -122.417561647852 | (37.8006021121473, -122.417561647852) | 5 | 1 | 1 | 308 | 32 | |||
| 33527 | 136257 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2106 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007681.63018 | 2119639.37861 | 37.8005592082118 | -122.417555094503 | (37.8005592082118, -122.417555094503) | 5 | 1 | 1 | 308 | 32 | |||
| 176997 | 80106 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2522 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50838 | 5999743.67056 | 2119517.2337 | 37.7997739777354 | -122.445014781615 | (37.7997739777354, -122.445014781615) | 13 | 9 | 1 | 57 | 17 | |
| 79823 | 52196 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.8000369880733 | -122.419461903656 | (37.8000369880733, -122.419461903656) | 5 | 1 | 1 | 28858 | 32 | ||
| 60277 | 101046 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 774347 | 6012049.48691 | 2119300.00717 | 37.7998721792109 | -122.402416569092 | (37.7998721792109, -122.402416569092) | 3 | 1 | 10 | 28860 | 6 | ||
| 68810 | 101047 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1050 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774347 | 6012043 | 2119296 | 37.799860814363 | -122.402438734441 | (37.799860814363, -122.402438734441) | 3 | 1 | 10 | 28860 | 6 | |
| 120563 | 136261 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008598.0245 | 2119155.01738 | 37.7992807940363 | -122.414349696679 | (37.7992807940363, -122.414349696679) | 5 | 1 | 10 | 308 | 32 | ||||
| 160665 | 50669 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3130 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 9 | Permit Number 47247 | 6002419.67533 | 2119034.32922 | 37.7986004146463 | -122.435720259485 | (37.7986004146463, -122.435720259485) | 13 | 9 | 1 | 57 | 17 | ||
| 155084 | 50668 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3130 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 4 | Permit Number 47247 | 6002421.15482 | 2119020.47996 | 37.7985624722307 | -122.435714148614 | (37.7985624722307, -122.435714148614) | 13 | 9 | 1 | 57 | 17 | ||
| 156909 | 65517 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1990 12:00:00 AM | 9 | Permit Number 28403 | 6003226.45222 | 2118960.15524 | 37.7984425449573 | -122.432923257305 | (37.7984425449573, -122.432923257305) | 13 | 9 | 1 | 57 | 17 | ||
| 147985 | 48960 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2038 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | 10 | Permit Number 46146 | 6003159.19812 | 2118949.28174 | 37.7984088743259 | -122.433155199676 | (37.7984088743259, -122.433155199676) | 13 | 9 | 1 | 57 | 17 | ||
| 145775 | 99598 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3001 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 17057 | 6002874.08515 | 2118929.42484 | 37.7983381750246 | -122.434140356598 | (37.7983381750246, -122.434140356598) | 13 | 9 | 1 | 57 | 17 | |||
| 125315 | 99597 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3001@Filbert Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
| 169715 | 136196 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2102 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002856.44865 | 2118905.61709 | 37.7982718041617 | -122.43419968127 | (37.7982718041617, -122.43419968127) | 13 | 9 | 1 | 57 | 17 | |||
| 98774 | 100361 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1135 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6007562.69285 | 2118825.76087 | 37.7983185248271 | -122.417908959744 | (37.7983185248271, -122.417908959744) | 5 | 1 | 10 | 28858 | 32 | |||
| 32452 | 4617 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | 3 | 1 | 10 | 308 | 23 | ||
| 28102 | 4618 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6010598.00994 | 2118821.58602 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | 3 | 1 | 10 | 308 | 23 | |||
| 135107 | 35263 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2314 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52291 | 6006344.46456 | 2118787.78744 | 37.7981456238821 | -122.422121705266 | (37.7981456238821, -122.422121705266) | 13 | 9 | 10 | 28858 | 32 | |
| 176557 | 35264 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2316 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52291 | 6006351.5463232 | 2118737.5484062 | 37.7980080796095 | -122.422093629292 | (37.7980080796095, -122.422093629292) | 13 | 9 | 10 | 28858 | 32 | ||
| 139061 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 720 BATTERY ST | 1 | unknown : Yard | Tree | Private 2 | 6012486 | 2118560 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | 3 | 1 | 10 | 28860 | 6 | |||||
| 21703 | 95365 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647797 | -122.407799105269 | (37.797637647797, -122.407799105269) | 3 | 1 | 10 | 308 | 4 | ||
| 60118 | 95364 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 661 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.479 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | 3 | 1 | 10 | 308 | 4 | ||
| 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 | |||
| 179294 | 30566 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34543 | 6002231.0779 | 2118426.88679 | 37.796921821948 | -122.436329368507 | (37.796921821948, -122.436329368507) | 13 | 9 | 1 | 57 | 17 | ||
| 153182 | 56681 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6002229.691 | 2118425.2879 | 37.7969173530103 | -122.436334053014 | (37.7969173530103, -122.436334053014) | 13 | 9 | 1 | 57 | 17 | ||||
| 96175 | 136255 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1422 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6006750.35587 | 2118407.27559 | 37.797123718848 | -122.42069017254 | (37.797123718848, -122.42069017254) | 13 | 9 | 10 | 28858 | 32 | |||
| 49348 | 136256 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1422 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006727.18618 | 2118403.84078 | 37.7971129818473 | -122.420770101557 | (37.7971129818473, -122.420770101557) | 13 | 9 | 10 | 28858 | 32 | |||
| 109593 | 136249 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1717 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008299.50959 | 2118376.18019 | 37.7971255273819 | -122.415327499887 | (37.7971255273819, -122.415327499887) | 5 | 1 | 10 | 28858 | 21 | |||
| 281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
| 108813 | 136193 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002531.20881 | 2118254.41346 | 37.7964653035841 | -122.43527850261 | (37.7964653035841, -122.43527850261) | 13 | 9 | 1 | 57 | 17 | |||
| 131447 | 136217 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001997.91666 | 2118237.10039 | 37.7963874672615 | -122.43712256518 | (37.7963874672615, -122.43712256518) | 13 | 9 | 1 | 57 | 17 | |||
| 79252 | 136192 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002533.36728 | 2118236.78125 | 37.7964170126905 | -122.435269772002 | (37.7964170126905, -122.435269772002) | 13 | 9 | 1 | 57 | 17 | |||
| 156720 | 34975 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Jackson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38557 | 6012788.97638306 | 2118225.73375032 | 37.7969637351298 | -122.399782167941 | (37.7969637351298, -122.399782167941) | 3 | 1 | 10 | 28860 | 6 | |||
| 188580 | 136218 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2901 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002000.86832 | 2118219.41961 | 37.7963390882297 | -122.437111085304 | (37.7963390882297, -122.437111085304) | 13 | 9 | 1 | 57 | 17 | |||
| 182977 | 136191 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6002535.25273 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) | 13 | 9 | 1 | 57 | 17 |
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) );