Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87412 | 87412 | 37133 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1496 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39716 | 5980947.80639526 | 2104858.25790377 | 37.758434095356996 | -122.50896520854799 | (37.758434095357, -122.508965208548) | ||
| 102170 | 102170 | 37134 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1496 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39716 | 5980947.80639526 | 2104858.25790377 | 37.758434095356996 | -122.50896520854799 | (37.758434095357, -122.508965208548) | ||
| 87387 | 87387 | 90956 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 4645 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981155.438709999 | 2110931.20899 | 37.775120893377796 | -122.50869800264299 | (37.7751208933778, -122.508698002643) | ||
| 92685 | 92685 | 37106 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1495 48th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | ||
| 139615 | 139615 | 37105 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1495 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | ||
| 168384 | 168384 | 38354 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1875 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 0 | Permit Number 40422 | 5981305.52143941 | 2102319.66652747 | 37.751484926000295 | -122.50753973195499 | (37.7514849260003, -122.507539731955) | |
| 172710 | 172710 | 37131 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4234 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 6 | Permit Number 39713 | 5981666.4542 | 2104905.7911 | 37.7586069464275 | -122.506483373023 | (37.7586069464275, -122.506483373023) | |
| 43712 | 43712 | 37130 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4234 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 4 | Permit Number 39713 | 5981688.5295 | 2104905.7911 | 37.758608246146004 | -122.506407027964 | (37.758608246146, -122.506407027964) | |
| 78508 | 78508 | 68560 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32450 | 5981950.36786377 | 2112213.67297772 | 37.778688985847104 | -122.506043321809 | (37.7786889858471, -122.506043321809) | ||
| 30228 | 30228 | 37124 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4200 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | |
| 55361 | 55361 | 37123 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4200 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | |
| 164163 | 164163 | 37125 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4200 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | |
| 91302 | 91302 | 38347 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1567 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | Permit Number 40414 | 5981854.03597748 | 2104432.31461127 | 37.757317957298 | -122.5057995404 | (37.757317957298, -122.5057995404) | ||
| 121863 | 121863 | 68548 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.778332244778106 | -122.504940366327 | (37.7783322447781, -122.504940366327) | ||
| 152505 | 152505 | 38345 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1859 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 0 | Permit Number 40412 | 5982231.73051381 | 2102455.52324126 | 37.7519124687384 | -122.504346906094 | (37.7519124687384, -122.504346906094) | |
| 52169 | 52169 | 82920 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 1 | 5982872.9956 | 2103302.6049 | 37.754276013066104 | -122.502192036803 | (37.7542760130661, -122.502192036803) | ||
| 159867 | 159867 | 70368 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.50150735953899 | (37.7598111971708, -122.501507359539) | ||
| 76050 | 76050 | 37069 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1474 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 4 | Permit Number 39671 | 5983120.2149 | 2105112.095 | 37.7592588855971 | -122.501470953069 | (37.7592588855971, -122.501470953069) | |
| 189028 | 189028 | 79350 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1946 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767118 | 5983237.8759 | 2101878.6369 | 37.750387624519796 | -122.500824911735 | (37.7503876245198, -122.500824911735) |
| 162759 | 162759 | 40610 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1234 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 5 | Permit Number 41621 | 5983375.0645 | 2106732.8195 | 37.763723900700896 | -122.500709422357 | (37.7637239007009, -122.500709422357) | ||
| 87399 | 87399 | 69146 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2479 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33181 | 5983616.53937475 | 2098288.7238606005 | 37.7405529339472 | -122.499250248288 | (37.7405529339472, -122.499250248288) | ||
| 68022 | 68022 | 184739 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984690.4501 | 2106251.0591 | 37.7624782581791 | -122.496124432854 | (37.7624782581791, -122.496124432854) | |||
| 35901 | 35901 | 184740 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.762442323054294 | -122.49609061999399 | (37.7624423230543, -122.496090619994) | |||
| 150358 | 150358 | 187339 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985079.353999999 | 2099690.9452 | 37.7444887635366 | -122.494295807794 | (37.7444887635366, -122.494295807794) | |||
| 100178 | 100178 | 37225 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1471 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39789 | 5985552.67131947 | 2105212.4791892 | 37.759677072307 | -122.49306585859301 | (37.759677072307, -122.493065858593) | ||
| 34609 | 34609 | 182248 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1454 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985596.8527 | 2105324.6327 | 37.7599875985541 | -122.492921320569 | (37.7599875985541, -122.492921320569) | |||
| 60665 | 60665 | 183413 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2350 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985629.7915 | 2097026.6067 | 37.737205400625 | -122.492196390733 | (37.737205400625, -122.492196390733) | |||
| 37512 | 37512 | 38123 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1200 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 5 | Permit Number 40287 | 5985851.366 | 2107007.0192 | 37.7646218448258 | -122.49216497230199 | (37.7646218448258, -122.492164972302) | |
| 30105 | 30105 | 37213 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1443 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39778 | 5985860.9109 | 2105407.8744 | 37.7602315957486 | -122.49201421242701 | (37.7602315957486, -122.492014212427) | |
| 164395 | 164395 | 37212 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1443 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39778 | 5985860.9109 | 2105390.2338 | 37.760183159545996 | -122.49201291360501 | (37.760183159546, -122.492012913605) | |
| 160137 | 160137 | 44818 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2745 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986255.58 | 2105005.7872 | 37.7591506369625 | -122.490619673159 | (37.7591506369625, -122.490619673159) | |
| 28298 | 28298 | 44816 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2745 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986280.5132 | 2105006.9468 | 37.759155277278104 | -122.490533528729 | (37.7591552772781, -122.490533528729) | |
| 136792 | 136792 | 44817 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2745 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986315.8836 | 2105009.2662 | 37.7591637116246 | -122.49041137327299 | (37.7591637116246, -122.490411373273) | |
| 123547 | 123547 | 38121 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1332 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40285 | 5986502.93855263 | 2106173.76895003 | 37.762372038386104 | -122.48985010087699 | (37.7623720383861, -122.489850100877) | ||
| 155566 | 155566 | 42870 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2554 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42793 | 5986474.4308 | 2097869.1881 | 37.73956824618 | -122.489338060188 | (37.73956824618, -122.489338060188) | |
| 166357 | 166357 | 42277 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1718 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 7 | Permit Number 42514 | 5986906.0637 | 2103542.512 | 37.75517085776371 | -122.48826248721399 | (37.7551708577637, -122.488262487214) | |
| 85709 | 85709 | 37195 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1742 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39762 | 5986908.61171996 | 2103401.39400305 | 37.7547835348007 | -122.488243305818 | (37.7547835348007, -122.488243305818) | ||
| 64770 | 64770 | 69317 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2122 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 6 | Permit Number 33397 | 5987643.2305 | 2104427.6901 | 37.7576442978234 | -122.485778145282 | (37.7576442978234, -122.485778145282) | |
| 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) | |
| 174354 | 174354 | 72614 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1586 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 6 | 5987797.3449 | 2104500.8291 | 37.757854096737205 | -122.485250528016 | (37.7578540967372, -122.485250528016) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 174014 | 174014 | 72596 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1551 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 5 | 5988056.3788 | 2104735.0481 | 37.758512285148605 | -122.48437186974199 | (37.7585122851486, -122.484371869742) | ||
| 30022 | 30022 | 183465 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2530 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988020.0365 | 2098057.0209999997 | 37.7401740893942 | -122.484007860756 | (37.7401740893942, -122.484007860756) | |||
| 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) | |
| 97177 | 97177 | 42163 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4630 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42458 | 5989047.18920071 | 2109907.45432155 | 37.7727719459225 | -122.48132401917401 | (37.7727719459225, -122.481324019174) | ||
| 159923 | 159923 | 38864 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1442 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40691 | 5989006.457 | 2105496.048 | 37.7606570618134 | -122.48114183443701 | (37.7606570618134, -122.481141834437) | |
| 187149 | 187149 | 38860 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1549 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 0 | Permit Number 40687 | 5989292.62615578 | 2104803.36922141 | 37.758771784471996 | -122.480101420695 | (37.758771784472, -122.480101420695) | |
| 180381 | 180381 | 38863 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1565 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 0 | Permit Number 40690 | 5989296.21457943 | 2104699.06297943 | 37.758485596062705 | -122.480081376814 | (37.7584855960627, -122.480081376814) | |
| 71486 | 71486 | 38854 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1466 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 3 | Permit Number 40681 | 5989630.3392 | 2105375.4166 | 37.7603620895733 | -122.478975308071 | (37.7603620895733, -122.478975308071) | |
| 104928 | 104928 | 42147 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 490 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42443 | 5990026.73861506 | 2112033.51240967 | 37.7786664170583 | -122.47809115215901 | (37.7786664170583, -122.478091152159) | |||
| 10030 | 10030 | 55092 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 535 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779353 | 5990916.44075 | 2111744.45268 | 37.777924340701105 | -122.474992253786 | (37.7779243407011, -122.474992253786) | ||
| 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) | ||
| 146228 | 146228 | 69279 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1935 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33350 | 5991240.95366227 | 2102241.42925325 | 37.751850383474604 | -122.47317643242799 | (37.7518503834746, -122.473176432428) | ||
| 91475 | 91475 | 68599 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.47317142953301 | (37.7517787113613, -122.473171429533) | ||
| 126147 | 126147 | 37477 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39948 | 5991509.07030691 | 2105439.09012647 | 37.760645840230104 | -122.472482356472 | (37.7606458402301, -122.472482356472) | ||
| 106615 | 106615 | 41829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42215 | 5991820.03879919 | 2105845.80564429 | 37.761780567414206 | -122.47143650330601 | (37.7617805674142, -122.471436503306) | ||
| 128040 | 128040 | 41842 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42231 | 5992090.13126179 | 2105515.92983571 | 37.7608904365533 | -122.470478344247 | (37.7608904365533, -122.470478344247) | ||
| 85335 | 85335 | 37602 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 510 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40029 | 5992230.72627236 | 2111952.11164714 | 37.778570595599604 | -122.47046084649999 | (37.7785705955996, -122.4704608465) | ||
| 67051 | 67051 | 207425 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991937.91081 | 2090925.4069599998 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | |||
| 85736 | 85736 | 38813 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 343 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | ||
| 102122 | 102122 | 38812 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 343 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/1998 12:00:00 AM | Permit Number 40648 | 5992447.48955931 | 2113145.89233921 | 37.7818609227719 | -122.469797921948 | (37.7818609227719, -122.469797921948) | ||
| 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) | ||
| 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) | ||
| 119507 | 119507 | 40555 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 215 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41596 | 5992664.70806244 | 2095313.38893204 | 37.7329100758329 | -122.46774911404499 | (37.7329100758329, -122.467749114045) | ||
| 87560 | 87560 | 43694 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 750 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43338 | 5993218.66242977 | 2110366.15850001 | 37.77427306876729 | -122.46692789928001 | (37.7742730687673, -122.46692789928) | ||
| 119143 | 119143 | 43695 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43339 | 5993219.60495236 | 2110339.98425191 | 37.7742012556984 | -122.466922735732 | (37.7742012556984, -122.466922735732) | ||
| 113493 | 113493 | 38037 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 125 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40239 | 5992979.27513605 | 2098217.94646306 | 37.7409034220219 | -122.466872661258 | (37.7409034220219, -122.466872661258) | ||
| 89241 | 89241 | 68517 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | ||
| 86006 | 86006 | 38036 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 111 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40238 | 5993036.05890767 | 2098279.23820641 | 37.7410749908436 | -122.466680779864 | (37.7410749908436, -122.466680779864) | ||
| 143552 | 143552 | 38035 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 111 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40238 | 5993036.05890767 | 2098279.23820641 | 37.7410749908436 | -122.466680779864 | (37.7410749908436, -122.466680779864) | ||
| 77812 | 77812 | 42555 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 519 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | ||
| 115358 | 115358 | 42554 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 519 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | ||
| 145541 | 145541 | 42556 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 519 Darien Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | ||
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 20473 | 20473 | 68412 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | ||
| 112782 | 112782 | 42013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 39 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42341 | 5993258.45652191 | 2093300.0310097 | 37.7274161576674 | -122.46555017500799 | (37.7274161576674, -122.465550175008) | ||
| 140374 | 140374 | 68496 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | ||
| 86280 | 86280 | 113491 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 132 | 366x 07TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776681 | 5993712.0 | 2113143.0 | 37.7819259902039 | -122.465423128165 | (37.7819259902039, -122.465423128165) | |
| 101228 | 101228 | 68054 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1881 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31791 | 5993737.20481548 | 2102706.11474697 | 37.7532705090115 | -122.46457785688 | (37.7532705090115, -122.46457785688) | ||
| 128395 | 128395 | 42023 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 110 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42346 | 5993552.23919225 | 2093678.6131862 | 37.7284725917152 | -122.464562053467 | (37.7284725917152, -122.464562053467) | ||
| 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) | ||
| 110097 | 110097 | 45413 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 845 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.46322780413401 | (37.7226703098261, -122.463227804134) | ||
| 126706 | 126706 | 45414 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 845 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.46322780413401 | (37.7226703098261, -122.463227804134) | ||
| 81242 | 81242 | 39675 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 97619 | 97619 | 39676 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 84960 | 84960 | 42029 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42351 | 5994340.62872168 | 2093722.8989966 | 37.728639607369 | -122.461839780515 | (37.728639607369, -122.461839780515) | ||
| 144295 | 144295 | 64645 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856003 | 37.7288421898975 | -122.46009728755301 | (37.7288421898975, -122.460097287553) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");