Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87099 | 87099 | 9986 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | ||
| 122949 | 122949 | 9987 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | |||
| 85440 | 85440 | 14603 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 1265 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 5999439.61797 | 2108531.9802599996 | 37.7695939720606 | -122.44527665521002 | (37.7695939720606, -122.44527665521) | |||
| 85238 | 85238 | 23668 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 315 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | |||
| 94608 | 94608 | 29418 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2601X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015194.8940554 | 2091164.3100784 | 37.7227927176508 | -122.38956611723101 | (37.7227927176508, -122.389566117231) | |||
| 94624 | 94624 | 31013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | ||
| 78126 | 78126 | 31110 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | |||
| 83764 | 83764 | 31111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Edna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | |||
| 124999 | 124999 | 31124 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | ||
| 78000 | 78000 | 31125 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | ||
| 129175 | 129175 | 31126 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34843 | 5998070.7770048 | 2093598.16198917 | 37.7285111411981 | -122.448935514449 | (37.7285111411981, -122.448935514449) | ||
| 113914 | 113914 | 31139 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 419 Hearst Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018002 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | ||
| 87435 | 87435 | 31145 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 419 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 3x3 | Permit Number 34852 | 5998635.87955939 | 2094356.6234018002 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | |
| 118568 | 118568 | 31184 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | ||
| 109958 | 109958 | 31826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.41063668938601 | (37.7719174714901, -122.410636689386) | ||
| 140930 | 140930 | 31827 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.41063668938601 | (37.7719174714901, -122.410636689386) | ||
| 115914 | 115914 | 31829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | ||
| 121377 | 121377 | 31830 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 222 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | ||
| 103319 | 103319 | 32293 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 160 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41561 | 5996702.09015079 | 2089306.2071389998 | 37.716648075661794 | -122.453357371649 | (37.7166480756618, -122.453357371649) | ||
| 120616 | 120616 | 33344 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.46400139922599 | (37.730182659203, -122.464001399226) | ||
| 101426 | 101426 | 34110 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 81385 | 81385 | 34111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 117014 | 117014 | 34346 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 255 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38104 | 6004828.12803067 | 2098393.70147146 | 37.7420627492496 | -122.42591620110201 | (37.7420627492496, -122.425916201102) | ||
| 123908 | 123908 | 34353 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 11 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38109 | 6004890.69932117 | 2098315.24737801 | 37.741850868129795 | -122.42569426656799 | (37.7418508681298, -122.425694266568) | ||
| 96701 | 96701 | 34355 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 84 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2003 12:00:00 AM | Permit Number 38111 | 6004874.55521399 | 2097707.40817778 | 37.740180967537604 | -122.425706834494 | (37.7401809675376, -122.425706834494) | ||
| 20616 | 20616 | 34363 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1846 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38119 | 6004556.0268692 | 2098000.12862747 | 37.74096670671079 | -122.426829018524 | (37.7409667067108, -122.426829018524) | ||
| 19240 | 19240 | 34364 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1862 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38120 | 6004563.40220029 | 2097868.81083057 | 37.7406065549579 | -122.426794167737 | (37.7406065549579, -122.426794167737) | ||
| 84138 | 84138 | 34388 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38136 | 6003730.56187145 | 2096520.40051304 | 37.736857004551794 | -122.429577666227 | (37.7368570045518, -122.429577666227) | ||
| 114806 | 114806 | 34398 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | |
| 79608 | 79608 | 34400 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 156 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38147 | 6002471.83146577 | 2097061.86671715 | 37.738272394243005 | -122.43396834021401 | (37.738272394243, -122.433968340214) | ||
| 109752 | 109752 | 34401 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38148 | 6002541.2507672 | 2096900.64630627 | 37.73783365951871 | -122.43371680334101 | (37.7378336595187, -122.433716803341) | ||
| 124926 | 124926 | 34402 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 160 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38149 | 6002458.41825324 | 2097080.12272084 | 37.7383217597979 | -122.434016021054 | (37.7383217597979, -122.434016021054) | ||
| 84947 | 84947 | 34404 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38152 | 6002491.04646095 | 2096956.56807226 | 37.7379843589135 | -122.433894379886 | (37.7379843589135, -122.433894379886) | ||
| 77316 | 77316 | 34414 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 205 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38161 | 6004190.49432582 | 2097526.98545022 | 37.7396468892769 | -122.42805918676399 | (37.7396468892769, -122.428059186764) | ||
| 110376 | 110376 | 34429 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38173 | 6002089.34387418 | 2096139.54747106 | 37.7357182050796 | -122.435224839434 | (37.7357182050796, -122.435224839434) | ||
| 125291 | 125291 | 34482 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 840 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38209 | 6008945.03028541 | 2119415.9766961997 | 37.8000168102383 | -122.413167394928 | (37.8000168102383, -122.413167394928) | ||
| 138766 | 138766 | 34527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | |||
| 145421 | 145421 | 34528 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | ||
| 96015 | 96015 | 34569 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 212 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38277 | 6008791.12126389 | 2097614.61295509 | 37.7401467112036 | -122.41215832665002 | (37.7401467112036, -122.41215832665) | ||
| 36479 | 36479 | 34629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 6 | Permit Number 38311 | 5988774.7652 | 2103307.0873 | 37.7546332934455 | -122.481782802584 | (37.7546332934455, -122.481782802584) | |
| 44447 | 44447 | 34630 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38311 | 5988776.9552 | 2103320.2277 | 37.754669500818295 | -122.481776191509 | (37.7546695008183, -122.481776191509) | |
| 98252 | 98252 | 34646 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1596 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38325 | 5987803.91965419 | 2104439.10360026 | 37.7576849982837 | -122.48522326103 | (37.7576849982837, -122.48522326103) | |||
| 151243 | 151243 | 34648 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1591 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | Permit Number 38327 | 5987753.8097 | 2104490.816 | 37.757824067255704 | -122.485400354271 | (37.7578240672557, -122.485400354271) | |
| 126783 | 126783 | 34650 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1743 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38329 | 5987786.63645622 | 2103431.59810771 | 37.754917654251706 | -122.485209109036 | (37.7549176542517, -122.485209109036) | ||
| 59206 | 59206 | 34656 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5988021.6232 | 2105120.5638 | 37.7595687826789 | -122.484520345625 | (37.7595687826789, -122.484520345625) | |
| 34390 | 34390 | 34657 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38334 | 5988005.8211 | 2105120.9797 | 37.759569004405606 | -122.48457502698 | (37.7595690044056, -122.48457502698) | |
| 37832 | 37832 | 34658 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5987988.7714 | 2105120.9797 | 37.75956801150279 | -122.484633992596 | (37.7595680115028, -122.484633992596) | |
| 175318 | 175318 | 34659 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38334 | 5987972.9693 | 2105119.7321 | 37.7595636656584 | -122.484688551924 | (37.7595636656584, -122.484688551924) | |
| 35235 | 35235 | 34660 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38334 | 5987955.9197 | 2105118.4846 | 37.759559247409 | -122.484747425675 | (37.759559247409, -122.484747425675) | |
| 103409 | 103409 | 34672 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3112 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2005 12:00:00 AM | Permit Number 38340 | 6003381.034936099 | 2119134.6254032 | 37.7989303613953 | -122.43240082161199 | (37.7989303613953, -122.432400821612) | ||
| 140714 | 140714 | 34803 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | ||
| 88607 | 88607 | 34930 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1790 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/1997 12:00:00 AM | Permit Number 38522 | 5991259.7839455 | 2103214.98783119 | 37.754524610644495 | -122.473182309921 | (37.7545246106445, -122.473182309921) | ||
| 128520 | 128520 | 35401 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 527 30th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38856 | 6003213.78352736 | 2098311.09733417 | 37.7417445720019 | -122.431492193982 | (37.7417445720019, -122.431492193982) | ||
| 106324 | 106324 | 35402 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 531 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38857 | 6003188.18562105 | 2098310.25744294 | 37.7417408149917 | -122.431580643052 | (37.7417408149917, -122.431580643052) | ||
| 110576 | 110576 | 35422 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 527 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38873 | 6002518.46166442 | 2099137.02773671 | 37.743972950658105 | -122.43395540759899 | (37.7439729506581, -122.433955407599) | ||
| 142164 | 142164 | 35494 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3763 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38905 | 6005241.37948762 | 2104264.99377415 | 37.758207308358 | -122.42490492912201 | (37.758207308358, -122.424904929122) | ||
| 121072 | 121072 | 35510 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3478 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38912 | 6005194.49677521 | 2103146.93967049 | 37.7551347452856 | -122.424987522768 | (37.7551347452856, -122.424987522768) | ||
| 114825 | 114825 | 35519 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 90 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38920 | 6005793.71652674 | 2102887.49607432 | 37.754456203079705 | -122.422896805421 | (37.7544562030797, -122.422896805421) | ||
| 105699 | 105699 | 35548 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38924 | 6005398.06539258 | 2103564.19233402 | 37.75629192060661 | -122.42431319750798 | (37.7562919206066, -122.424313197508) | ||
| 140866 | 140866 | 35549 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 50 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.42445588668501 | (37.7558983622011, -122.424455886685) | ||
| 111236 | 111236 | 35550 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 50 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.42445588668501 | (37.7558983622011, -122.424455886685) | ||
| 125836 | 125836 | 35741 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 231 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | Permit Number 39015 | 6007788.68777846 | 2092857.60054619 | 37.7270286926321 | -122.415287680245 | (37.7270286926321, -122.415287680245) | ||
| 104525 | 104525 | 35745 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1005 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | Permit Number 39018 | 6007884.66062501 | 2093417.72691387 | 37.728572072766 | -122.41499553105301 | (37.728572072766, -122.414995531053) | ||
| 123356 | 123356 | 35927 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 22 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | Permit Number 39097 | 6005564.10753047 | 2097077.73566378 | 37.738490969573 | -122.423277889221 | (37.738490969573, -122.423277889221) | ||
| 106179 | 106179 | 35941 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39104 | 6007226.10455525 | 2097703.31078326 | 37.740302317745396 | -122.417575817322 | (37.7403023177454, -122.417575817322) | ||
| 126372 | 126372 | 35942 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 21 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39105 | 6007225.31509594 | 2097693.4445482 | 37.7402751828319 | -122.41757784787201 | (37.7402751828319, -122.417577847872) | ||
| 77834 | 77834 | 35960 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 555 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39118 | 6006291.48461818 | 2096239.28811556 | 37.7362298031477 | -122.420703460764 | (37.7362298031477, -122.420703460764) | ||
| 78418 | 78418 | 35961 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 555 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39118 | 6006291.48461818 | 2096239.28811556 | 37.7362298031477 | -122.420703460764 | (37.7362298031477, -122.420703460764) | ||
| 128003 | 128003 | 35970 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 190 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39128 | 6006126.55379065 | 2096333.04753419 | 37.7364779485792 | -122.421280351482 | (37.7364779485792, -122.421280351482) | ||
| 127227 | 127227 | 36076 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2091 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39189 | 6008123.15826597 | 2106262.62233667 | 37.7638546903501 | -122.41507985169399 | (37.7638546903501, -122.415079851694) | ||
| 141369 | 141369 | 36078 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2134 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39191 | 6008086.14600314 | 2105996.63644369 | 37.76312227463529 | -122.415189036821 | (37.7631222746353, -122.415189036821) | ||
| 99963 | 99963 | 36111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1290 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39208 | 5992413.02593495 | 2106678.51938145 | 37.7641012654702 | -122.469446232974 | (37.7641012654702, -122.469446232974) | ||
| 171957 | 171957 | 36187 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 35 Parker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39256 | 5996805.8212 | 2114349.7078 | 37.785417233263104 | -122.45480720748999 | (37.7854172332631, -122.45480720749) | |
| 66505 | 66505 | 36188 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 35 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 7 | Permit Number 39256 | 5996804.8059 | 2114366.2904 | 37.785462706430394 | -122.454811918638 | (37.7854627064304, -122.454811918638) | |
| 125553 | 125553 | 36334 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 44 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.45722557992399 | (37.7262004833581, -122.457225579924) | ||
| 141725 | 141725 | 36335 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 44 Eastwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.45722557992399 | (37.7262004833581, -122.457225579924) | ||
| 84680 | 84680 | 36336 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 44 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.45722557992399 | (37.7262004833581, -122.457225579924) | ||
| 79109 | 79109 | 36453 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | ||
| 125375 | 125375 | 36454 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | ||
| 128091 | 128091 | 36470 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.725761835422794 | -122.456655052435 | (37.7257618354228, -122.456655052435) | ||
| 139667 | 139667 | 36471 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.725761835422794 | -122.456655052435 | (37.7257618354228, -122.456655052435) | ||
| 144458 | 144458 | 36487 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 111017 | 111017 | 36488 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 125859 | 125859 | 36489 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 98352 | 98352 | 36491 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 113737 | 113737 | 36492 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 105808 | 105808 | 36493 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 91631 | 91631 | 36510 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 406 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39387 | 6007487.22983868 | 2096928.20854387 | 37.738188748168895 | -122.416618053798 | (37.7381887481689, -122.416618053798) | ||
| 114625 | 114625 | 36568 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 327 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/1998 12:00:00 AM | Permit Number 39430 | 6006720.99763739 | 2096073.95090972 | 37.735800022233704 | -122.419206729617 | (37.7358000222337, -122.419206729617) | ||
| 84649 | 84649 | 36717 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1999 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 139285 | 139285 | 36718 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 111647 | 111647 | 36719 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 98637 | 98637 | 36720 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | ||
| 138628 | 138628 | 36819 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 90972 | 90972 | 36820 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 126247 | 126247 | 36821 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 117721 | 117721 | 36822 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 91047 | 91047 | 36823 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 106343 | 106343 | 36826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 110387 | 110387 | 36827 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2600 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) |
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");