trees
400 rows where qSpecies_id = 43 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193933 | 40300 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | |||
| 193773 | 34629 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1766 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 6 | Permit Number 38311 | 5988774.7652 | 2103307.0873 | 37.7546332934455 | -122.481782802584 | (37.7546332934455, -122.481782802584) | 1 | 8 | 3 | 56 | 35 | |
| 191442 | 38168 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 349 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761 | 37.7269212154772 | -122.40603833072 | (37.7269212154772, -122.40603833072) | 10 | 3 | 7 | 309 | 28 | ||
| 190993 | 42556 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
| 190933 | 40610 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1234 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/1999 12:00:00 AM | 5 | Permit Number 41621 | 5983375.0645 | 2106732.8195 | 37.7637239007009 | -122.500709422357 | (37.7637239007009, -122.500709422357) | 1 | 8 | 3 | 56 | 35 | ||
| 190764 | 38080 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000641.24201 | 2113883.59801 | 37.7843566740562 | -122.441504373964 | (37.7843566740562, -122.441504373964) | 15 | 6 | 11 | 29490 | 13 | ||
| 190034 | 69279 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1935 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33350 | 5991240.95366227 | 2102241.42925325 | 37.7518503834746 | -122.473176432428 | (37.7518503834746, -122.473176432428) | 1 | 8 | 4 | 29491 | 12 | ||
| 189659 | 34528 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | ||
| 189493 | 36335 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
| 187515 | 37783 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 289 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40117 | 6009320.94225991 | 2092982.60267054 | 37.7274579192917 | -122.409999500097 | (37.7274579192917, -122.409999500097) | 10 | 3 | 7 | 309 | 28 | ||
| 187434 | 36819 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
| 185863 | 37786 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 301 Hamilton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1998 12:00:00 AM | Permit Number 40119 | 6009341.93324933 | 2092913.86947002 | 37.7272703689284 | -122.409922083912 | (37.7272703689284, -122.409922083912) | 10 | 3 | 7 | 309 | 28 | |||
| 184921 | 38197 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 731 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40324 | 6011355.00492598 | 2091469.0696772 | 37.7234158640083 | -122.402861294571 | (37.7234158640083, -122.402861294571) | 10 | 3 | 7 | 309 | 28 | ||
| 184586 | 37749 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1271 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/1999 12:00:00 AM | Permit Number 40096 | 6009537.93489258 | 2101780.18844977 | 37.7516263413346 | -122.409870111191 | (37.7516263413346, -122.409870111191) | 2 | 4 | 7 | 28859 | 19 | ||
| 183856 | 35549 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 50 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.424455886685 | (37.7558983622011, -122.424455886685) | 2 | 4 | 5 | 28859 | 19 | ||
| 183814 | 37700 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
| 183661 | 79350 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1946 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767118 | 5983237.8759 | 2101878.6369 | 37.7503876245198 | -122.500824911735 | (37.7503876245198, -122.500824911735) | 1 | 8 | 3 | 29491 | 35 |
| 183262 | 38616 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
| 182131 | 40049 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1435 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41286 | 6015948.92421606 | 2093724.14562026 | 37.7298633009427 | -122.38713803352 | (37.7298633009427, -122.38713803352) | 10 | 3 | 8 | 58 | 1 | ||
| 181292 | 38074 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000621.45001 | 2114020.83701 | 37.7847323694056 | -122.441582699114 | (37.7847323694056, -122.441582699114) | 15 | 6 | 11 | 29490 | 13 | ||
| 181109 | 38195 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 730 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | 10 | 3 | 7 | 309 | 28 | ||
| 180904 | 34527 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | |||
| 180644 | 248448 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 136 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998284.3672 | 2107976.1331 | 37.768001745714 | -122.449232557107 | (37.768001745714, -122.449232557107) | 15 | 5 | 11 | 29492 | 9 | |||
| 180479 | 35494 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3763 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38905 | 6005241.37948762 | 2104264.99377415 | 37.758207308358 | -122.424904929122 | (37.758207308358, -122.424904929122) | 2 | 4 | 5 | 28859 | 19 | ||
| 180365 | 141254 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | 11 | 6 | 1 | 54 | 31 | |||
| 179725 | 38035 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 111 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40238 | 5993036.05890767 | 2098279.23820641 | 37.7410749908436 | -122.466680779864 | (37.7410749908436, -122.466680779864) | 1 | 8 | 4 | 59 | 40 | ||
| 179341 | 38180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 42 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40313 | 6011447.25206772 | 2091677.58315317 | 37.7239935496068 | -122.402557066965 | (37.7239935496068, -122.402557066965) | 10 | 3 | 7 | 309 | 28 | ||
| 178986 | 38863 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1565 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 0 | Permit Number 40690 | 5989296.21457943 | 2104699.06297943 | 37.7584855960627 | -122.480081376814 | (37.7584855960627, -122.480081376814) | 1 | 8 | 3 | 56 | 35 | |
| 178631 | 38169 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 349 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761 | 37.7269212154772 | -122.40603833072 | (37.7269212154772, -122.40603833072) | 10 | 3 | 7 | 309 | 28 | ||
| 178201 | 68496 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | 1 | 8 | 4 | 56 | 12 | ||
| 177763 | 255250 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 209x Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
| 177318 | 37526 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1150 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39975 | 6007323.5106073 | 2115257.61387493 | 37.7885078148262 | -122.418483459105 | (37.7885078148262, -122.418483459105) | 13 | 9 | 10 | 28858 | 21 | ||
| 177223 | 38077 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000633.42901 | 2113935.94101 | 37.7844999493368 | -122.441535161579 | (37.7844999493368, -122.441535161579) | 15 | 6 | 11 | 29490 | 13 | ||
| 176908 | 43107 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
| 176487 | 34803 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | 9 | 7 | 6 | 28861 | 25 | ||
| 175884 | 37069 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1474 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 4 | Permit Number 39671 | 5983120.2149 | 2105112.095 | 37.7592588855971 | -122.501470953069 | (37.7592588855971, -122.501470953069) | 1 | 8 | 3 | 56 | 35 | |
| 174203 | 37705 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
| 173715 | 36487 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
| 173663 | 37275 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3894 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39816 | 6002513.25180394 | 2102998.13185029 | 37.754574335137 | -122.434249400487 | (37.754574335137, -122.434249400487) | 2 | 4 | 5 | 28862 | 22 | |||
| 173565 | 38123 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1200 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 5 | Permit Number 40287 | 5985851.366 | 2107007.0192 | 37.7646218448258 | -122.492164972302 | (37.7646218448258, -122.492164972302) | 1 | 8 | 3 | 56 | 35 | |
| 173394 | 64645 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856 | 37.7288421898975 | -122.460097287553 | (37.7288421898975, -122.460097287553) | 9 | 7 | 4 | 28861 | 40 | ||
| 172957 | 40642 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.7443667457738 | -122.410880064189 | (37.7443667457738, -122.410880064189) | 2 | 7 | 7 | 28859 | 2 | |||
| 172758 | 102442 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008344 | 2095883 | 37.735366982035 | -122.413581854524 | (37.735366982035, -122.413581854524) | 10 | 7 | 7 | 28859 | 2 | |||
| 172670 | 39490 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 4054 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40948 | 6002823.01095214 | 2101848.4791437 | 37.7514352381886 | -122.433096036215 | (37.7514352381886, -122.433096036215) | 2 | 4 | 5 | 28862 | 22 | ||
| 172638 | 126461 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000743.63592 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | 13 | 9 | 1 | 57 | 17 | |||
| 172252 | 31827 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.410636689386 | (37.7719174714901, -122.410636689386) | 8 | 2 | 9 | 28853 | 34 | ||
| 172166 | 36078 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2134 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39191 | 6008086.14600314 | 2105996.63644369 | 37.7631222746353 | -122.415189036821 | (37.7631222746353, -122.415189036821) | 8 | 4 | 7 | 28859 | 19 | ||
| 172042 | 36471 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.7257618354228 | -122.456655052435 | (37.7257618354228, -122.456655052435) | 9 | 7 | 4 | 28861 | 40 | ||
| 171637 | 37105 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1495 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39704 | 5981217.84304819 | 2104908.99665532 | 37.7585893245545 | -122.508035083937 | (37.7585893245545, -122.508035083937) | 1 | 8 | 3 | 56 | 35 | ||
| 170901 | 36718 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
| 170691 | 37458 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39930 | 6010305.7989409 | 2099791.60340169 | 37.7462091274065 | -122.407074571233 | (37.7462091274065, -122.407074571233) | 2 | 7 | 7 | 28859 | 2 | ||
| 169743 | 37845 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 132 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2005 12:00:00 AM | Permit Number 40137 | 6010294.81147281 | 2099208.35616527 | 37.7446070428057 | -122.40707146066 | (37.7446070428057, -122.40707146066) | 2 | 7 | 7 | 28859 | 2 | ||
| 169593 | 43744 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
| 169396 | 33344 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.464001399226 | (37.730182659203, -122.464001399226) | 9 | 8 | 4 | 59 | 40 | ||
| 168833 | 37703 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
| 168308 | 37063 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1468 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39664 | 6003912.84552522 | 2099719.17052238 | 37.7456504127787 | -122.429175446828 | (37.7456504127787, -122.429175446828) | 2 | 7 | 5 | 63 | 22 | ||
| 168287 | 39138 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
| 168179 | 37708 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
| 166774 | 141601 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1882 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998863.8341 | 2110436.3604 | 37.77479003056 | -122.447405354515 | (37.77479003056, -122.447405354515) | 15 | 5 | 11 | 29492 | 16 | |||
| 166564 | 37709 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
| 166378 | 38565 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
| 165786 | 38568 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
| 165109 | 39139 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1081 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40817 | 6007463.5839422 | 2101024.83737451 | 37.7494358467299 | -122.416989987658 | (37.7494358467299, -122.416989987658) | 2 | 4 | 7 | 28859 | 19 | ||
| 163982 | 35510 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3478 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38912 | 6005194.49677521 | 2103146.93967049 | 37.7551347452856 | -122.424987522768 | (37.7551347452856, -122.424987522768) | 2 | 4 | 5 | 28859 | 19 | ||
| 163727 | 184740 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.7624423230543 | -122.496090619994 | (37.7624423230543, -122.496090619994) | 1 | 8 | 3 | 56 | 35 | |||
| 162751 | 43695 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 754 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43339 | 5993219.60495236 | 2110339.98425191 | 37.7742012556984 | -122.466922735732 | (37.7742012556984, -122.466922735732) | 11 | 6 | 2 | 54 | 11 | ||
| 162238 | 68548 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.7783322447781 | -122.504940366327 | (37.7783322447781, -122.504940366327) | 11 | 6 | 2 | 55 | 26 | ||
| 161625 | 126462 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.8038772290062 | -122.441595650935 | (37.8038772290062, -122.441595650935) | 13 | 9 | 1 | 57 | 17 | |||
| 161440 | 9987 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | 8 | 2 | 5 | 28853 | 19 | |||
| 161378 | 34346 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 255 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38104 | 6004828.12803067 | 2098393.70147146 | 37.7420627492496 | -122.425916201102 | (37.7420627492496, -122.425916201102) | 2 | 7 | 5 | 63 | 7 | ||
| 161249 | 38075 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000624.05401 | 2114007.81601 | 37.7846967654532 | -122.441572755427 | (37.7846967654532, -122.441572755427) | 15 | 6 | 11 | 29490 | 13 | ||
| 160706 | 38628 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1998 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 | |||
| 160336 | 68399 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | 9 | 8 | 4 | 59 | 40 | ||
| 159345 | 37542 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 704 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39985 | 6008763.04341244 | 2114941.12322015 | 37.7877197423167 | -122.413480489066 | (37.7877197423167, -122.413480489066) | 5 | 1 | 10 | 28858 | 21 | ||
| 159010 | 37040 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
| 157890 | 40555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 215 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 41596 | 5992664.70806244 | 2095313.38893204 | 37.7329100758329 | -122.467749114045 | (37.7329100758329, -122.467749114045) | 9 | 8 | 4 | 59 | 40 | ||
| 157106 | 38170 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 349 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761 | 37.7269212154772 | -122.40603833072 | (37.7269212154772, -122.40603833072) | 10 | 3 | 7 | 309 | 28 | ||
| 156451 | 31830 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
| 155651 | 38627 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 | ||
| 155289 | 31184 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | 9 | 8 | 6 | 64 | 24 | ||
| 155234 | 39134 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 810 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2000 12:00:00 AM | Permit Number 40813 | 6007325.69907761 | 2102579.12781976 | 37.7536958179011 | -122.417576944272 | (37.7536958179011, -122.417576944272) | 2 | 4 | 7 | 28859 | 19 | ||
| 155194 | 55092 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 535 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779353 | 5990916.44075 | 2111744.45268 | 37.7779243407011 | -122.474992253786 | (37.7779243407011, -122.474992253786) | 11 | 6 | 2 | 54 | 26 | ||
| 154775 | 37314 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 485 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39829 | 6003203.23907746 | 2103274.86360864 | 37.7553733132886 | -122.431883001431 | (37.7553733132886, -122.431883001431) | 2 | 4 | 5 | 28862 | 22 | ||
| 153929 | 36822 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
| 152483 | 38621 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1295 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.7277292986583 | -122.385043230392 | (37.7277292986583, -122.385043230392) | 10 | 3 | 8 | 58 | 1 | ||
| 152141 | 40299 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2155 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41445 | 6006883.99939755 | 2105792.08668164 | 37.7624929958367 | -122.419332354319 | (37.7624929958367, -122.419332354319) | 8 | 4 | 7 | 28859 | 19 | ||
| 151832 | 36719 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
| 151562 | 40060 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
| 151337 | 36907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 884 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40695 | 6000695.68812692 | 2102606.86536781 | 37.7533966824522 | -122.440506941015 | (37.7533966824522, -122.440506941015) | 2 | 4 | 5 | 28862 | 22 | ||
| 151050 | 42013 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 39 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42341 | 5993258.45652191 | 2093300.0310097 | 37.7274161576674 | -122.465550175008 | (37.7274161576674, -122.465550175008) | 9 | 8 | 4 | 59 | 40 | ||
| 150948 | 38598 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1329 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40549 | 6016511.31684241 | 2093304.91013991 | 37.7287432904596 | -122.385164559023 | (37.7287432904596, -122.385164559023) | 10 | 3 | 8 | 58 | 1 | ||
| 150403 | 43108 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
| 150087 | 39909 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2001 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | ||
| 150043 | 246390 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1267 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 0ft | 5999435.2691 | 2108467.7761 | 37.7694174354079 | -122.445287080875 | (37.7694174354079, -122.445287080875) | 15 | 5 | 11 | 29492 | 9 | |||
| 149752 | 38073 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000616.76201 | 2114062.24301 | 37.7848457925173 | -122.441601890436 | (37.7848457925173, -122.441601890436) | 15 | 6 | 11 | 29490 | 13 | ||
| 149710 | 40034 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
| 148461 | 43110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42936 | 6009339.17842867 | 2114353.98733566 | 37.7861399408742 | -122.411445668311 | (37.7861399408742, -122.411445668311) | 5 | 10 | 9 | 28852 | 36 | ||
| 148447 | 35550 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 50 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38925 | 6005353.87687584 | 2103421.76830911 | 37.7558983622011 | -122.424455886685 | (37.7558983622011, -122.424455886685) | 2 | 4 | 5 | 28859 | 19 | ||
| 148296 | 36829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2600 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | 10 | 3 | 8 | 58 | 1 | ||
| 147777 | 36830 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2655 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.389855194073 | (37.7224666226612, -122.389855194073) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );