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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10418 | 10418 | 77647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | |
| 1366 | 1366 | 81793 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 435 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 5 | 3x3 | 6005759.2342 | 2111006.7416 | 37.7767477786156 | -122.42359327476801 | (37.7767477786156, -122.423593274768) | |
| 15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
| 16412 | 16412 | 30636 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47466 | 6008078.6625 | 2108652.1603 | 37.770413303673394 | -122.4154029268 | (37.7704133036734, -122.4154029268) |
| 18483 | 18483 | 66408 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | ||
| 19622 | 19622 | 63665 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.747527435901496 | -122.428684519984 | (37.7475274359015, -122.428684519984) | ||
| 20299 | 20299 | 63295 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23861 | 6008153.74699222 | 2100060.03492719 | 37.746825514117205 | -122.41453511521401 | (37.7468255141172, -122.414535115214) | ||
| 22963 | 22963 | 108630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1469-1471 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772871 | 6002136.635290001 | 2111543.9635799997 | 37.778017709796295 | -122.436163356374 | (37.7780177097963, -122.436163356374) |
| 24671 | 24671 | 58732 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2385 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | ||
| 25838 | 25838 | 75303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.40656607695699 | (37.7648621726769, -122.406566076957) | ||
| 27678 | 27678 | 68339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32156 | 5991257.09324 | 2112608.74204 | 37.7803171779643 | -122.47387689925101 | (37.7803171779643, -122.473876899251) | |
| 28339 | 28339 | 73442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 8 | 6004223.020830001 | 2091452.87155 | 37.72297057362721 | -122.42751410409402 | (37.7229705736272, -122.427514104094) | ||
| 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) | |
| 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) | |
| 32871 | 32871 | 74007 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2030 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 8 | 6012344.40813 | 2102849.33443 | 37.754718867688105 | -122.40023998938999 | (37.7547188676881, -122.40023998939) | ||
| 39170 | 39170 | 75389 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010589.86723 | 2106590.9300700002 | 37.7648944592258 | -122.40657134700199 | (37.7648944592258, -122.406571347002) | ||
| 39309 | 39309 | 70680 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | ||
| 40517 | 40517 | 31313 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 7 | Permit Number 34949 | 6004462.32974 | 2110985.15865 | 37.776615227251604 | -122.428078115713 | (37.7766152272516, -122.428078115713) | |
| 41799 | 41799 | 46849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.724327847540295 | -122.42848061451201 | (37.7243278475403, -122.428480614512) | |
| 44512 | 44512 | 38662 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 834 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40585 | 6001015.5346 | 2111586.9168 | 37.778071890037 | -122.440044714881 | (37.778071890037, -122.440044714881) |
| 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) | |
| 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) | |
| 46752 | 46752 | 121094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1697 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x3 | 6001082.7006 | 2111393.2018 | 37.777543821113206 | -122.43979847194099 | (37.7775438211132, -122.439798471941) | ||
| 47148 | 47148 | 72144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 5 | 6000049.527000001 | 2091859.62504 | 37.723850484693706 | -122.441970156497 | (37.7238504846937, -122.441970156497) | ||
| 47443 | 47443 | 96053 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
| 47463 | 47463 | 70412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | ||
| 47669 | 47669 | 36825 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.721341772631895 | -122.39177321286199 | (37.7213417726319, -122.391773212862) | |
| 48741 | 48741 | 71411 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | ||
| 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) | |
| 51549 | 51549 | 61556 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2098X 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | Permit Number 21516 | 6012360.0 | 2102825.0 | 37.754652920054795 | -122.40018435916299 | (37.7546529200548, -122.400184359163) | ||
| 52223 | 52223 | 48664 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1715REVISED Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 2 | Permit Number 45950 | 6004825.1941 | 2115340.0212 | 37.788593123793504 | -122.427133123433 | (37.7885931237935, -122.427133123433) | |
| 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) | |
| 53492 | 53492 | 75980 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 6555 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1989 12:00:00 AM | 3 | 5986643.29892 | 2112486.62546 | 37.7797135654944 | -122.48982895296699 | (37.7797135654944, -122.489828952967) | ||
| 53824 | 53824 | 30624 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1655 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35324 | 6008124.7709 | 2108587.5084 | 37.7702383761626 | -122.41523885993 | (37.7702383761626, -122.41523885993) | |
| 56000 | 56000 | 30618 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34580 | 6008139.305 | 2108622.0896 | 37.7703341448356 | -122.41519103466601 | (37.7703341448356, -122.415191034666) | |
| 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) | |
| 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) |
| 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) | |
| 59413 | 59413 | 70593 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | ||
| 60127 | 60127 | 30620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34580 | 6008131.7874 | 2108606.0519 | 37.7702896865902 | -122.415215902671 | (37.7702896865902, -122.415215902671) | |
| 60208 | 60208 | 50802 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 539REVISED 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53851 | 5993738.09251 | 2111820.21552 | 37.778295485898 | -122.465236749215 | (37.778295485898, -122.465236749215) |
| 60538 | 60538 | 75145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010592.19708 | 2106537.02068 | 37.76474656661821 | -122.406559489431 | (37.7647465666182, -122.406559489431) | ||
| 60896 | 60896 | 50021 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 137@ FELTON Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 8 | Permit Number 46755 | 6010268.64963 | 2093971.7239700002 | 37.730226909139105 | -122.406792936365 | (37.7302269091391, -122.406792936365) | |
| 61539 | 61539 | 38704 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1697 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 7 | 3x3 | Permit Number 40612 | 6001060.2221 | 2111388.0751 | 37.7775284649677 | -122.43987586473801 | (37.7775284649677, -122.439875864738) |
| 62420 | 62420 | 32198 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1516 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 9 | Permit Number 45854 | 6009303.2136699995 | 2100469.6159099997 | 37.748014643075706 | -122.410589271476 | (37.7480146430757, -122.410589271476) | |
| 64108 | 64108 | 83143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 1 | 6016637.512159999 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | ||
| 65322 | 65322 | 73401 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | ||
| 65491 | 65491 | 69396 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33500 | 6001570.284530001 | 2087031.2786 | 37.7106794663567 | -122.436367757869 | (37.7106794663567, -122.436367757869) | |
| 65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
| 66013 | 66013 | 36339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | ||
| 66931 | 66931 | 38591 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | Permit Number 40546 | 6015135.7246 | 2094671.1157 | 37.7324184244611 | -122.390015508372 | (37.7324184244611, -122.390015508372) | |
| 69129 | 69129 | 69449 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 435 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 7 | Permit Number 33559 | 5985596.63224 | 2112961.6611 | 37.7809567074922 | -122.493484787172 | (37.7809567074922, -122.493484787172) | |
| 69527 | 69527 | 31227 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34913 | 5992091.019830001 | 2097838.61761 | 37.7398105749846 | -122.46991627883301 | (37.7398105749846, -122.469916278833) | |
| 70015 | 70015 | 39981 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935121999 | (37.7325519363025, -122.39310935122) | |
| 70530 | 70530 | 73459 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 15 | 6010582.5171300005 | 2106716.25151 | 37.765238152235206 | -122.40660560128299 | (37.7652381522352, -122.406605601283) | ||
| 70653 | 70653 | 65118 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 127 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 4 | Permit Number 27088 | 5989266.29156 | 2114491.8349900004 | 37.7853721122289 | -122.480901836159 | (37.7853721122289, -122.480901836159) | |
| 71108 | 71108 | 31557 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 166 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2015 12:00:00 AM | 5 | Permit Number 774125 | 5998574.5828 | 2112531.8751 | 37.7805272390885 | -122.44855688064399 | (37.7805272390885, -122.448556880644) | |
| 71124 | 71124 | 59265 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1693 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | 3 | 3x3 | Permit Number 18600 | 6006592.1641 | 2116638.2998 | 37.7922576371531 | -122.421111884547 | (37.7922576371531, -122.421111884547) |
| 71194 | 71194 | 60642 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | ||
| 72842 | 72842 | 69456 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 5 | Permit Number 33566 | 5985607.3929 | 2112736.22477 | 37.7803383536355 | -122.493430946652 | (37.7803383536355, -122.493430946652) | |
| 77012 | 77012 | 73715 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2012 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | 6012416.66148 | 2102853.00124 | 37.7547329645749 | -122.399990373555 | (37.7547329645749, -122.399990373555) | ||
| 78128 | 78128 | 61014 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.43353644788701 | (37.7354717570522, -122.433536447887) | ||
| 78261 | 78261 | 63886 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3547 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24593 | 6004709.97412141 | 2103652.05428606 | 37.756494290475395 | -122.42669911246401 | (37.7564942904754, -122.426699112464) | ||
| 78545 | 78545 | 61239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3990 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21111 | 6003756.36871106 | 2104234.67606304 | 37.7580400715305 | -122.430038577553 | (37.7580400715305, -122.430038577553) | ||
| 78598 | 78598 | 69390 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | ||
| 78783 | 78783 | 47559 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 309 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45421 | 6004167.03194558 | 2101865.16274932 | 37.751557194937206 | -122.428449439906 | (37.7515571949372, -122.428449439906) | ||
| 78938 | 78938 | 59900 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19367 | 6009921.67857589 | 2103735.23260959 | 37.7570159551008 | -122.408680977559 | (37.7570159551008, -122.408680977559) | ||
| 79383 | 79383 | 43386 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 847 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43133 | 6001928.68244613 | 2101630.19955263 | 37.75078512339571 | -122.436173106924 | (37.7507851233957, -122.436173106924) | ||
| 79805 | 79805 | 63307 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3284 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1987 12:00:00 AM | Permit Number 23873 | 6009001.83575964 | 2099561.12656766 | 37.7455032313147 | -122.411567250412 | (37.7455032313147, -122.411567250412) | ||
| 80101 | 80101 | 63538 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 263 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24153 | 6006528.95547818 | 2104582.46189303 | 37.7591516457095 | -122.420474457983 | (37.7591516457095, -122.420474457983) | ||
| 80568 | 80568 | 68465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 56 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32327 | 6002348.42397311 | 2094432.09629198 | 37.731044644088605 | -122.43420707357201 | (37.7310446440886, -122.434207073572) | ||
| 80618 | 80618 | 63782 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3865 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24466 | 6004731.1418531 | 2101313.40519991 | 37.7500741027298 | -122.42645939339701 | (37.7500741027298, -122.426459393397) | ||
| 80705 | 80705 | 62440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 32 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22603 | 5999780.61180369 | 2105360.37553229 | 37.7609049960466 | -122.443869272306 | (37.7609049960466, -122.443869272306) | ||
| 81029 | 81029 | 63256 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 317 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1987 12:00:00 AM | 3x3 | Permit Number 23809 | 6006547.75913435 | 2104256.57264854 | 37.7582578891884 | -122.420386294584 | (37.7582578891884, -122.420386294584) | |
| 81623 | 81623 | 33440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 197 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37542 | 6006467.34357413 | 2098597.19964294 | 37.7427140119749 | -122.420262742218 | (37.7427140119749, -122.420262742218) | ||
| 81885 | 81885 | 61001 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20814 | 6002393.98738915 | 2096184.72110879 | 37.7358595366597 | -122.434174798209 | (37.7358595366597, -122.434174798209) | ||
| 81949 | 81949 | 59899 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 981 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1993 12:00:00 AM | Permit Number 29266 | 6009986.52664303 | 2103503.60894166 | 37.7563836002421 | -122.408440369707 | (37.7563836002421, -122.408440369707) | ||
| 82224 | 82224 | 67145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.40773544745701 | (37.7448433809463, -122.407735447457) | ||
| 82307 | 82307 | 63520 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 821 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24130 | 6009935.53523311 | 2104433.5559768 | 37.758934170103394 | -122.408682318494 | (37.7589341701034, -122.408682318494) | ||
| 82719 | 82719 | 95625 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3562 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767392 | 6005880.0 | 2105517.0 | 37.7616810754377 | -122.422785274783 | (37.7616810754377, -122.422785274783) | |
| 82753 | 82753 | 96048 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 82900 | 82900 | 37011 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39625 | 6009493.89299858 | 2102575.04875629 | 37.753806381943896 | -122.41007852412201 | (37.7538063819439, -122.410078524122) | ||
| 83425 | 83425 | 63297 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 41 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1987 12:00:00 AM | Permit Number 23889 | 6008204.7241819 | 2100062.98400649 | 37.74683647540329 | -122.414359049017 | (37.7468364754033, -122.414359049017) | ||
| 83502 | 83502 | 48864 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46854 | 5992914.37939707 | 2098147.89875638 | 37.740707342979995 | -122.467091953195 | (37.74070734298, -122.467091953195) | ||
| 83567 | 83567 | 63869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24572 | 6003633.93277578 | 2103298.63600494 | 37.7554629928496 | -122.43039522885599 | (37.7554629928496, -122.430395228856) | ||
| 83625 | 83625 | 58781 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2064 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | Permit Number 18024 | 6006472.52256241 | 2117868.87652577 | 37.7956297477373 | -122.42161328699801 | (37.7956297477373, -122.421613286998) | ||
| 84009 | 84009 | 32818 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4221 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37177 | 6001720.00837009 | 2102316.78849399 | 37.7526584745372 | -122.43694386703699 | (37.7526584745372, -122.436943867037) | ||
| 84350 | 84350 | 63529 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 650 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | 3x3 | Permit Number 24141 | 6007874.08689161 | 2104139.31003907 | 37.7580105644827 | -122.415790957509 | (37.7580105644827, -122.415790957509) | |
| 85034 | 85034 | 63518 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2720 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24128 | 6010089.4904363 | 2104586.73017727 | 37.759363373534796 | -122.408160669778 | (37.7593633735348, -122.408160669778) | ||
| 85171 | 85171 | 60613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20237 | 6004863.02785957 | 2097589.48802411 | 37.7398565341458 | -122.425738300436 | (37.7398565341458, -122.425738300436) | ||
| 85640 | 85640 | 108404 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 181-199 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007385.0 | 2107936.0 | 37.7684078844101 | -122.41775154293998 | (37.7684078844101, -122.41775154294) |
| 85789 | 85789 | 96047 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 85984 | 85984 | 57721 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2010 12:00:00 AM | Permit Number 53634 | 6004597.07146519 | 2109103.26366214 | 37.7714556250816 | -122.42747790523701 | (37.7714556250816, -122.427477905237) | ||
| 86258 | 86258 | 60128 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19656 | 6003855.48725366 | 2096277.36434342 | 37.736196755139 | -122.429128420374 | (37.736196755139, -122.429128420374) | ||
| 87025 | 87025 | 69100 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1667 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33115 | 5992448.84064151 | 2104114.43419147 | 37.757063031457 | -122.469135733901 | (37.757063031457, -122.469135733901) | ||
| 87043 | 87043 | 96121 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
| 87274 | 87274 | 102063 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 284 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769726 | 6006232.8 | 2098354.9 | 37.742035492788204 | -122.42105652774099 | (37.7420354927882, -122.421056527741) |
| 87888 | 87888 | 67079 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 5 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30476 | 6006639.64114826 | 2099650.94101578 | 37.7456170557754 | -122.419741737079 | (37.7456170557754, -122.419741737079) | ||
| 88779 | 88779 | 41683 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 68 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 10 | Permit Number 42137 | 5999567.20857147 | 2105392.00369761 | 37.760979664179104 | -122.44460961092501 | (37.7609796641791, -122.444609610925) | |
| 88856 | 88856 | 63299 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3250 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23865 | 6008990.90330008 | 2099756.44910168 | 37.7460389305968 | -122.41161885123199 | (37.7460389305968, -122.411618851232) |
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");