400 rows where qSpecies_id = 43 sorted by Location

View and edit SQL

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)
96443 37870 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
136572 37871 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
137049 37869 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/2002 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
49935 40037 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 5 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
85527 40036 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 4 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
90253 40035 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 3 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
119829 40038 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 6 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
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
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
36083 40050 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1439 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41287 6015928.43712332 2093739.41771764 37.729904100557 -122.387209925263 (37.729904100557, -122.387209925263) 10 3 8 58 1
72685 40051 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1439 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41287 6015928.43712332 2093739.41771764 37.729904100557 -122.387209925263 (37.729904100557, -122.387209925263) 10 3 8 58 1
27476 31110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Edna St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34838 5998740.33351858 2094135.45298345 37.7300246851321 -122.446659473393 (37.7300246851321, -122.446659473393) 9 7 4 28861 40
54982 31111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Edna St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34838 5998740.33351858 2094135.45298345 37.7300246851321 -122.446659473393 (37.7300246851321, -122.446659473393) 9 7 4 28861 40
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
63942 31145 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 419 Hearst Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/2006 12:00:00 AM   3x3 Permit Number 34852 5998635.87955939 2094356.6234018 37.7306259997996 -122.447036492148 (37.7306259997996, -122.447036492148) 9 7 4 28861 40
146965 31139 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 419 Hearst Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34852 5998635.87955939 2094356.6234018 37.7306259997996 -122.447036492148 (37.7306259997996, -122.447036492148) 9 7 4 28861 40
139109 38601 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1534 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40552 6015446.13574073 2094163.07491578 37.7310406573671 -122.388906878559 (37.7310406573671, -122.388906878559) 10 3 8 58 1
15667 38606 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1558 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40554 6015323.31475554 2094254.15832382 37.7312839455717 -122.389337853373 (37.7312839455717, -122.389337853373) 10 3 8 58 1
8969 38615 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 3 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
21583 38613 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/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
26720 38614 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 2 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
89942 38612 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 5 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
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
125189 38617 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1619 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40558 6014993.23240611 2094434.43177017 37.7317606344589 -122.390491609305 (37.7317606344589, -122.390491609305) 10 3 8 58 1
28494 42555 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 519 Darien Way 2 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
143304 42554 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 519 Darien Way 1 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
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
146098 38618 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1648 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40559 6014913.01600852 2094558.97753063 37.7320981616183 -122.390777636678 (37.7320981616183, -122.390777636678) 10 3 8 58 1
74322 39707 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 738 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41092 5997200.32170515 2095026.51323817 37.7323832338006 -122.452047720375 (37.7323832338006, -122.452047720375) 9 7 4 59 40
9053 38570 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 6 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
16009 38566 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 2 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
98576 38571 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 7 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
117190 38569 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 5 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
137180 38567 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 3 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
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
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
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
101538 39689 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 56 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41074 6013706.29242939 2094956.2180602 37.7331218759444 -122.394977388495 (37.7331218759444, -122.394977388495) 10 3 8 58 1
94534 42120 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 630 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/06/2002 12:00:00 AM     Permit Number 42417 5997254.13334531 2095296.10071131 37.7331265386983 -122.451881123727 (37.7331265386983, -122.451881123727) 9 7 4 59 40
60108 39693 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1475 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41078 6015709.80747314 2094943.53448428 37.7331982540931 -122.388049755187 (37.7331982540931, -122.388049755187) 10 3 8 58 1
36889 207426 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 404 Baden St 1 Side Yard : Yard Tree Private 2     3     6000774.5178 2095253.08109 37.7332094216698 -122.439707159174 (37.7332094216698, -122.439707159174) 9 7 5 63 40
132556 43498 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4145 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2000 12:00:00 AM     Permit Number 43178 6008355.55350511 2095881.30836855 37.7353629859312 -122.413541790025 (37.7353629859312, -122.413541790025) 10 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
136510 34429 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38173 6002089.34387418 2096139.54747106 37.7357182050796 -122.435224839434 (37.7357182050796, -122.435224839434) 2 7 5 63 7
142691 36568 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 327 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/19/1998 12:00:00 AM     Permit Number 39430 6006720.99763739 2096073.95090972 37.7358000222337 -122.419206729617 (37.7358000222337, -122.419206729617) 2 7 7 28859 2
21691 35960 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 555 Holly Park Cir 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39118 6006291.48461818 2096239.28811556 37.7362298031477 -122.420703460764 (37.7362298031477, -122.420703460764) 2 7 7 28859 2
42461 35961 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 555 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39118 6006291.48461818 2096239.28811556 37.7362298031477 -122.420703460764 (37.7362298031477, -122.420703460764) 2 7 7 28859 2
36633 35970 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 190 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39128 6006126.55379065 2096333.04753419 37.7364779485792 -122.421280351482 (37.7364779485792, -122.421280351482) 2 7 7 28859 2
45134 34388 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 100 Mateo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38136 6003730.56187145 2096520.40051304 37.7368570045518 -122.429577666227 (37.7368570045518, -122.429577666227) 2 7 5 63 7
32117 183413 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2350 Wawona St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5985629.7915 2097026.6067 37.737205400625 -122.492196390733 (37.737205400625, -122.492196390733) 1 8 3 29491 35
142202 34398 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 141 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2016 12:00:00 AM 3   Permit Number 38145 6002598.06465628 2096836.91119738 37.7376618812243 -122.433515816831 (37.7376618812243, -122.433515816831) 2 7 5 63 7
125415 34401 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 157 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38148 6002541.2507672 2096900.64630627 37.7378336595187 -122.433716803341 (37.7378336595187, -122.433716803341) 2 7 5 63 7
63600 34404 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 171 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38152 6002491.04646095 2096956.56807226 37.7379843589135 -122.433894379886 (37.7379843589135, -122.433894379886) 2 7 5 63 7
67437 36510 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 406 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39387 6007487.22983868 2096928.20854387 37.7381887481689 -122.416618053798 (37.7381887481689, -122.416618053798) 2 7 7 28859 2
50923 34400 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 156 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38147 6002471.83146577 2097061.86671715 37.738272394243 -122.433968340214 (37.738272394243, -122.433968340214) 2 7 5 63 7
29221 34402 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 160 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38149 6002458.41825324 2097080.12272084 37.7383217597979 -122.434016021054 (37.7383217597979, -122.434016021054) 2 7 5 63 7
123655 38553 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1791 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40521 6014535.26572589 2096873.10267881 37.7384313099375 -122.392245401183 (37.7384313099375, -122.392245401183) 10 3 8 58 1
3336 35927 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 22 Appleton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1998 12:00:00 AM     Permit Number 39097 6005564.10753047 2097077.73566378 37.738490969573 -122.423277889221 (37.738490969573, -122.423277889221) 2 7 7 28859 2
20587 40463 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 378 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/1999 12:00:00 AM     Permit Number 41548 6007684.60346868 2097335.44684482 37.7393180333935 -122.415964462581 (37.7393180333935, -122.415964462581) 2 7 7 28859 2
110316 42870 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2554 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/03/2000 12:00:00 AM 5   Permit Number 42793 5986474.4308 2097869.1881 37.73956824618 -122.489338060188 (37.73956824618, -122.489338060188) 1 8 3 29491 35
26194 34414 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 205 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38161 6004190.49432582 2097526.98545022 37.7396468892769 -122.428059186764 (37.7396468892769, -122.428059186764) 2 7 5 63 7
83598 34569 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 212 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38277 6008791.12126389 2097614.61295509 37.7401467112036 -122.41215832665 (37.7401467112036, -122.41215832665) 10 7 7 28859 2
29364 183465 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2530 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5988020.0365 2098057.021 37.7401740893942 -122.484007860756 (37.7401740893942, -122.484007860756) 1 8 3 29491 35
94256 34355 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 84 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2003 12:00:00 AM     Permit Number 38111 6004874.55521399 2097707.40817778 37.7401809675376 -122.425706834494 (37.7401809675376, -122.425706834494) 2 7 5 63 7
37192 35942 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 21 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39105 6007225.31509594 2097693.4445482 37.7402751828319 -122.417577847872 (37.7402751828319, -122.417577847872) 2 7 7 28859 2
126442 35941 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 19 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39104 6007226.10455525 2097703.31078326 37.7403023177454 -122.417575817322 (37.7403023177454, -122.417575817322) 2 7 7 28859 2
67615 69146 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2479 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33181 5983616.53937475 2098288.7238606 37.7405529339472 -122.499250248288 (37.7405529339472, -122.499250248288) 1 8 3 29491 35
13812 34364 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1862 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38120 6004563.40220029 2097868.81083057 37.7406065549579 -122.426794167737 (37.7406065549579, -122.426794167737) 2 7 5 63 7
143533 38037 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40239 5992979.27513605 2098217.94646306 37.7409034220219 -122.466872661258 (37.7409034220219, -122.466872661258) 1 8 4 59 40
14374 34363 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1846 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38119 6004556.0268692 2098000.12862747 37.7409667067108 -122.426829018524 (37.7409667067108, -122.426829018524) 2 7 5 63 7
72873 38036 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 111 Wawona St 2 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
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
100434 37455 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39928 6008336.46582591 2098008.78903327 37.7412035106459 -122.413758220259 (37.7412035106459, -122.413758220259) 2 7 7 28859 2
126210 37454 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39928 6008336.46582591 2098008.78903327 37.7412035106459 -122.413758220259 (37.7412035106459, -122.413758220259) 2 7 7 28859 2
122187 35402 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 531 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38857 6003188.18562105 2098310.25744294 37.7417408149917 -122.431580643052 (37.7417408149917, -122.431580643052) 2 7 5 63 7
20564 35401 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 527 30th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38856 6003213.78352736 2098311.09733417 37.7417445720019 -122.431492193982 (37.7417445720019, -122.431492193982) 2 7 5 63 7
14912 34353 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 11 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38109 6004890.69932117 2098315.24737801 37.7418508681298 -122.425694266568 (37.7418508681298, -122.425694266568) 2 7 5 63 7
75154 23668 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 315 Virginia Ave 3 Median : Cutout Tree DPW 1     3 12   6006939.5968988 2098278.7889768 37.7418663267774 -122.418607247372 (37.7418663267774, -122.418607247372) 2 7 7 28859 2
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
1543 259573 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 298 Public Park 3 Unaccepted Street : Cutout Tree Private 2       5x10   5994238 2098707 37.7423188086517 -122.462555955845 (37.7423188086517, -122.462555955845) 1 8 4 59 40
3986 116680 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 100 Esmeralda Ave 19 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
142598 35422 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 527 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38873 6002518.46166442 2099137.02773671 37.7439729506581 -122.433955407599 (37.7439729506581, -122.433955407599) 2 7 5 63 22
86212 43997 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 146 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43554 6008915.83516029 2099075.89728061 37.7441660743482 -122.411830346827 (37.7441660743482, -122.411830346827) 2 7 7 28859 2
3049 43998 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 150 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43555 6008950.71046834 2099077.83692872 37.7441733566649 -122.411709892219 (37.7441733566649, -122.411709892219) 2 7 7 28859 2
88126 43999 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 158 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43556 6009020.46100461 2099081.71622052 37.7441879209123 -122.411468983209 (37.7441879209123, -122.411468983209) 2 7 7 28859 2
18989 37041 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 3 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
29030 37044 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 6 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
44466 37043 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 5 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
127677 37042 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 4 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
142418 37039 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 1 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
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
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
89415 40641 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 187 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM     Permit Number 41639 6009210.87994007 2099144.38708889 37.7443706801351 -122.410814978675 (37.7443706801351, -122.410814978675) 2 7 7 28859 2
140614 37066 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 326 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/2004 12:00:00 AM     Permit Number 39668 6003784.55345185 2099265.25748104 37.7443968092105 -122.429586694845 (37.7443968092105, -122.429586694845) 2 7 5 63 22
68850 187339 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985079.354 2099690.9452 37.7444887635366 -122.494295807794 (37.7444887635366, -122.494295807794) 1 8 3 29491 35
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
131612 37420 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 679 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39898 6002152.44125634 2099703.71933952 37.7455081743626 -122.435261547297 (37.7455081743626, -122.435261547297) 2 7 5 63 22
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
41386 121194 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 255x Red Rock Way 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
105045 37437 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 51 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39912 6010454.2114909 2099614.59600709 37.745731407921 -122.406548905427 (37.745731407921, -122.406548905427) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);