Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44521 | 44521 | 136250 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2711 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006868.56519 | 2121594.39083 | 37.8058813915667 | -122.420507486038 | (37.8058813915667, -122.420507486038) | |||
| 103525 | 103525 | 11173 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2717 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006873.7712695 | 2121594.1615236998 | 37.8058810553361 | -122.42048945327299 | (37.8058810553361, -122.420489453273) | |||
| 130355 | 130355 | 136251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2711 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006870.92139 | 2121576.32062 | 37.8058319081714 | -122.420498048543 | (37.8058319081714, -122.420498048543) | |||
| 60462 | 60462 | 136252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006854.74284 | 2121556.7809200003 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | |||
| 40729 | 40729 | 136253 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 802 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006835.20454 | 2121555.13749 | 37.805771731842704 | -122.420620147698 | (37.8057717318427, -122.420620147698) | |||
| 158844 | 158844 | 136254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 804 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006813.5477 | 2121550.30022 | 37.8057572293748 | -122.420694750958 | (37.8057572293748, -122.420694750958) | |||
| 53160 | 53160 | 91043 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50399 | 6006460.43386 | 2121423.80416 | 37.8053899957025 | -122.421907764657 | (37.8053899957025, -122.421907764657) | |
| 79247 | 79247 | 87679 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.805369133986794 | -122.42172073484699 | (37.8053691339868, -122.421720734847) | ||
| 80418 | 80418 | 87678 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.805369133986794 | -122.42172073484699 | (37.8053691339868, -122.421720734847) | ||
| 125862 | 125862 | 87680 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.805369133986794 | -122.42172073484699 | (37.8053691339868, -122.421720734847) | ||
| 162161 | 162161 | 91042 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006462.588380001 | 2121409.81945 | 37.8053517187772 | -122.421899314626 | (37.8053517187772, -122.421899314626) | |
| 177088 | 177088 | 91041 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006464.746230001 | 2121395.99646 | 37.805313886080604 | -122.421890864574 | (37.8053138860806, -122.421890864574) | |
| 171342 | 171342 | 69369 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33463 | 6002534.674819999 | 2121358.09542 | 37.804987398007704 | -122.43548864898099 | (37.8049873980077, -122.435488648981) | |
| 36783 | 36783 | 136264 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011327.59811 | 2121029.0502400002 | 37.804579383680895 | -122.40503639942601 | (37.8045793836809, -122.405036399426) | |||
| 46311 | 46311 | 136201 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001803.6012 | 2121217.14439 | 37.8045588359743 | -122.438008504412 | (37.8045588359743, -122.438008504412) | |||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 57011 | 57011 | 136263 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | |||
| 158473 | 158473 | 34253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.42263519386199 | (37.8043767538414, -122.422635193862) | |
| 93193 | 93193 | 69368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3636 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 13 | Permit Number 33462 | 6002615.01621 | 2121133.0987299997 | 37.8043741790738 | -122.43519451581999 | (37.8043741790738, -122.43519451582) | |
| 135338 | 135338 | 34252 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.804373461439795 | -122.42269665353999 | (37.8043734614398, -122.42269665354) | |
| 52609 | 52609 | 34250 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.42276644632601 | (37.8043668775019, -122.422766446326) | |
| 147037 | 147037 | 136227 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3630 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002616.6752 | 2121115.11425 | 37.804324892641 | -122.435187487615 | (37.804324892641, -122.435187487615) | |||
| 136568 | 136568 | 136260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | |||
| 51017 | 51017 | 69367 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3630 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33461 | 6002617.53648 | 2121095.37594 | 37.8042707453542 | -122.435183094434 | (37.8042707453542, -122.435183094434) | |
| 45559 | 45559 | 48873 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/1993 12:00:00 AM | 12 | 3x3 | Permit Number 46081 | 6011769.2879800005 | 2120850.1065700003 | 37.8041127290715 | -122.40349528428001 | (37.8041127290715, -122.40349528428) | |
| 55755 | 55755 | 48872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46081 | 6011751.8076 | 2120847.07255 | 37.8041034220013 | -122.403555563145 | (37.8041034220013, -122.403555563145) | |
| 71447 | 71447 | 136229 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1695 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002733.14719 | 2120927.81311 | 37.8038172262563 | -122.434771025084 | (37.8038172262563, -122.434771025084) | |||
| 157108 | 157108 | 101338 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32655 | 6008893.4466 | 2120790.6495 | 37.80378842303661 | -122.413443168222 | (37.8037884230366, -122.413443168222) | ||
| 59563 | 59563 | 136228 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1695 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002671.67342 | 2120917.48858 | 37.8037853875576 | -122.43498301955401 | (37.8037853875576, -122.434983019554) | |||
| 186343 | 186343 | 136200 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000132.373269999 | 2120911.69707 | 37.803624978161295 | -122.443769967932 | (37.8036249781613, -122.443769967932) | |||
| 162116 | 162116 | 136199 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000108.92159 | 2120908.29838 | 37.8036143086235 | -122.443850879042 | (37.8036143086235, -122.443850879042) | |||
| 50287 | 50287 | 136198 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000083.32441 | 2120905.42804 | 37.803604967353394 | -122.443939252695 | (37.8036049673534, -122.443939252695) | |||
| 64583 | 64583 | 136197 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000062.25305 | 2120901.6465 | 37.8035933822804 | -122.444011899049 | (37.8035933822804, -122.444011899049) | |||
| 30859 | 30859 | 136223 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000162.373980001 | 2120896.2706299997 | 37.8035843324119 | -122.44366504043501 | (37.8035843324119, -122.443665040435) | |||
| 136988 | 136988 | 136224 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000162.1216 | 2120884.12041 | 37.8035509567753 | -122.443665040422 | (37.8035509567753, -122.443665040422) | |||
| 34519 | 34519 | 136225 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3699 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000164.78748 | 2120871.42318 | 37.803516245636004 | -122.44365490235201 | (37.803516245636, -122.443654902352) | |||
| 152567 | 152567 | 249824 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 285 Kearny St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010866.76079 | 2120642.6759099998 | 37.8034927229673 | -122.40660393393999 | (37.8034927229673, -122.40660393394) | |||
| 58447 | 58447 | 95867 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 733 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767588 | 6008296.37826 | 2120666.6947 | 37.8034145323264 | -122.415500582505 | (37.8034145323264, -122.415500582505) |
| 31500 | 31500 | 69354 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1342 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33445 | 6004870.03416 | 2120576.9578 | 37.8029749544875 | -122.427351191008 | (37.8029749544875, -122.427351191008) | |
| 157966 | 157966 | 136202 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | |||
| 46447 | 46447 | 69353 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1337 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33444 | 6004896.60555 | 2120531.0120900003 | 37.8028503021536 | -122.42725596539302 | (37.8028503021536, -122.427255965393) | |
| 74169 | 74169 | 136203 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1349 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004849.1859800005 | 2120525.70738 | 37.8028330549672 | -122.42741968339399 | (37.8028330549672, -122.427419683394) | |||
| 130342 | 130342 | 69357 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1355 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33448 | 6004836.73382 | 2120523.45104 | 37.8028261553684 | -122.42746261343099 | (37.8028261553684, -122.427462613431) | |
| 156029 | 156029 | 62003 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1446 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33451 | 6004382.288930001 | 2120508.49846 | 37.8027593860996 | -122.429034158913 | (37.8027593860996, -122.429034158913) | |
| 151838 | 151838 | 62004 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33452 | 6004296.2409 | 2120497.97462 | 37.8027256192439 | -122.42933117801701 | (37.8027256192439, -122.429331178017) | |
| 36414 | 36414 | 136262 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 11 Filbert St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012539.8548099995 | 2120210.2855 | 37.8023989459081 | -122.400783688018 | (37.8023989459081, -122.400783688018) | ||||
| 58666 | 58666 | 69359 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 6 | Permit Number 33453 | 6004667.124009999 | 2120354.39385 | 37.8023523736266 | -122.428037496051 | (37.8023523736266, -122.428037496051) | |
| 164273 | 164273 | 136230 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3100 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004683.10116 | 2120231.33167 | 37.8020153805639 | -122.427973432847 | (37.8020153805639, -122.427973432847) | |||
| 149613 | 149613 | 69318 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1466 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1994 12:00:00 AM | 12 | Permit Number 33399 | 6004829.35126 | 2120222.0032 | 37.801998039833606 | -122.427466672957 | (37.8019980398336, -122.427466672957) | |
| 166963 | 166963 | 69319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33400 | 6004756.29564 | 2120212.83745 | 37.801968740827206 | -122.42771882665899 | (37.8019687408272, -122.427718826659) | ||
| 57520 | 57520 | 69320 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1546 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1994 12:00:00 AM | 6 | Permit Number 33401 | 6004443.14953 | 2120171.11922 | 37.801836474839796 | -122.428799484421 | (37.8018364748398, -122.428799484421) | |
| 180069 | 180069 | 136226 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | |||
| 80993 | 80993 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 96134 | 96134 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 102660 | 102660 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 105009 | 105009 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 125168 | 125168 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 146084 | 146084 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 26558 | 26558 | 136248 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.800892734360296 | -122.414423864695 | (37.8008927343603, -122.414423864695) | |||
| 45995 | 45995 | 61372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3240 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32977 | 5999005.452409999 | 2119937.7850900004 | 37.800886538035996 | -122.447599568972 | (37.800886538036, -122.447599568972) | |
| 64020 | 64020 | 82025 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 900-904 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50637 | 6008560.7244 | 2119705.2270299997 | 37.800789437354496 | -122.41451772334 | (37.8007894373545, -122.41451772334) | |
| 28556 | 28556 | 136259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007679.1852400005 | 2119665.2919900003 | 37.800630222272794 | -122.417565392635 | (37.8006302222728, -122.417565392635) | |||
| 76552 | 76552 | 136258 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007680.05725 | 2119655.03643 | 37.800602112147295 | -122.417561647852 | (37.8006021121473, -122.417561647852) | |||
| 120866 | 120866 | 136257 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2106 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007681.63018 | 2119639.37861 | 37.8005592082118 | -122.417555094503 | (37.8005592082118, -122.417555094503) | |||
| 5178 | 5178 | 104043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1405 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006090.81059 | 2119657.4034599997 | 37.800519058872396 | -122.42306126657199 | (37.8005190588724, -122.423061266572) | |||
| 26386 | 26386 | 136222 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999346.78651 | 2119715.31037 | 37.8002951834309 | -122.446402399571 | (37.8002951834309, -122.446402399571) | |||
| 165345 | 165345 | 52196 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.800036988073295 | -122.419461903656 | (37.8000369880733, -122.419461903656) | ||
| 40781 | 40781 | 101046 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 774347 | 6012049.4869099995 | 2119300.00717 | 37.799872179210894 | -122.40241656909201 | (37.7998721792109, -122.402416569092) | ||
| 87927 | 87927 | 101047 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774347 | 6012043.0 | 2119296.0 | 37.799860814363 | -122.40243873444099 | (37.799860814363, -122.402438734441) | |
| 48550 | 48550 | 80106 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2522 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50838 | 5999743.6705599995 | 2119517.2337 | 37.7997739777354 | -122.44501478161501 | (37.7997739777354, -122.445014781615) | |
| 73613 | 73613 | 136261 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008598.0245 | 2119155.01738 | 37.7992807940363 | -122.414349696679 | (37.7992807940363, -122.414349696679) | ||||
| 148769 | 148769 | 50669 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 9 | Permit Number 47247 | 6002419.67533 | 2119034.32922 | 37.798600414646295 | -122.435720259485 | (37.7986004146463, -122.435720259485) | ||
| 45655 | 45655 | 50668 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 4 | Permit Number 47247 | 6002421.15482 | 2119020.4799599997 | 37.7985624722307 | -122.43571414861401 | (37.7985624722307, -122.435714148614) | ||
| 7900 | 7900 | 4617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | ||
| 124403 | 124403 | 4618 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6010598.00994 | 2118821.5860200003 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | |||
| 173304 | 173304 | 65517 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1990 12:00:00 AM | 9 | Permit Number 28403 | 6003226.452219999 | 2118960.15524 | 37.7984425449573 | -122.43292325730499 | (37.7984425449573, -122.432923257305) | ||
| 161261 | 161261 | 48960 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2038 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 10 | Permit Number 46146 | 6003159.19812 | 2118949.28174 | 37.7984088743259 | -122.433155199676 | (37.7984088743259, -122.433155199676) | ||
| 148823 | 148823 | 99598 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3001 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 17057 | 6002874.08515 | 2118929.42484 | 37.7983381750246 | -122.434140356598 | (37.7983381750246, -122.434140356598) | |||
| 106032 | 106032 | 99597 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3001@Filbert Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 17057 | 6002820.0 | 2118927.7 | 37.798330369321796 | -122.43432738402299 | (37.7983303693218, -122.434327384023) | ||||
| 70248 | 70248 | 100361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1135 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007562.69285 | 2118825.76087 | 37.7983185248271 | -122.417908959744 | (37.7983185248271, -122.417908959744) | |||
| 182445 | 182445 | 136196 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2102 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002856.44865 | 2118905.6170900003 | 37.7982718041617 | -122.43419968126999 | (37.7982718041617, -122.43419968127) | |||
| 175241 | 175241 | 35263 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2314 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52291 | 6006344.46456 | 2118787.78744 | 37.7981456238821 | -122.422121705266 | (37.7981456238821, -122.422121705266) | |
| 139534 | 139534 | 35264 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2316 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52291 | 6006351.546323201 | 2118737.5484062 | 37.7980080796095 | -122.422093629292 | (37.7980080796095, -122.422093629292) | ||
| 114979 | 114979 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 720 BATTERY ST | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 6012486.0 | 2118560.0 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | |||||
| 5925 | 5925 | 95365 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 778058 | 6010478.0762 | 2118518.1883 | 37.797637647796996 | -122.40779910526899 | (37.797637647797, -122.407799105269) | ||
| 53643 | 53643 | 95364 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 661 Broadway | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 3x3 | Permit Number 778058 | 6010448.4751 | 2118513.4790000003 | 37.797623060035 | -122.407901201302 | (37.797623060035, -122.407901201302) | ||
| 63227 | 63227 | 136249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1717 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008299.50959 | 2118376.18019 | 37.797125527381894 | -122.41532749988701 | (37.7971255273819, -122.415327499887) | |||
| 179989 | 179989 | 136255 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6006750.35587 | 2118407.27559 | 37.797123718848 | -122.42069017253999 | (37.797123718848, -122.42069017254) | |||
| 162611 | 162611 | 136256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006727.18618 | 2118403.8407799997 | 37.7971129818473 | -122.42077010155701 | (37.7971129818473, -122.420770101557) | |||
| 123067 | 123067 | 34975 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38557 | 6012788.97638306 | 2118225.73375032 | 37.79696373512979 | -122.399782167941 | (37.7969637351298, -122.399782167941) | |||
| 152812 | 152812 | 143549 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002240.1517 | 2118427.2493 | 37.7969233328664 | -122.436297997013 | (37.7969233328664, -122.436297997013) | |||
| 169277 | 169277 | 30566 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34543 | 6002231.0779 | 2118426.8867900004 | 37.796921821948 | -122.436329368507 | (37.796921821948, -122.436329368507) | ||
| 155527 | 155527 | 56681 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6002229.691000001 | 2118425.2879 | 37.79691735301029 | -122.436334053014 | (37.7969173530103, -122.436334053014) | ||||
| 130889 | 130889 | 68778 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2020 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 14 | 3x3 | Permit Number 32708 | 6006907.41923 | 2118207.98167 | 37.796585358595294 | -122.420132542485 | (37.7965853585953, -122.420132542485) | |
| 51010 | 51010 | 136194 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.43528810647699 | (37.7965053162169, -122.435288106477) | |||
| 132548 | 132548 | 136193 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002531.20881 | 2118254.41346 | 37.79646530358411 | -122.43527850261002 | (37.7964653035841, -122.43527850261) | |||
| 146977 | 146977 | 136192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002533.36728 | 2118236.78125 | 37.796417012690505 | -122.43526977200199 | (37.7964170126905, -122.435269772002) | |||
| 31714 | 31714 | 46872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | |
| 187068 | 187068 | 136217 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001997.91666 | 2118237.1003900003 | 37.7963874672615 | -122.43712256517999 | (37.7963874672615, -122.43712256518) | |||
| 26025 | 26025 | 136191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6002535.252730001 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");