400 rows where qSpecies_id = 43 sorted by Neighborhoods (old)

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) ▼
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
4468 40059 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 3 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
5387 38597 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 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
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
12770 38626 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 2 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
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
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
20690 38595 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 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
23688 68883 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 59 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM     Permit Number 32855 6013060.20442694 2090777.05783105 37.721610806199 -122.396918198144 (37.721610806199, -122.396918198144) 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
30259 36821 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 6 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
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
47665 40058 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 4 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
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
58227 38593 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
58314 38629 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 4 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
59390 38622 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 1 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
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
67064 40067 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1400 Thomas Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2005 12:00:00 AM     Permit Number 41294 6015817.64770175 2093187.90304466 37.7283836150635 -122.387554479201 (37.7283836150635, -122.387554479201) 10 3 8 58 1
71570 36820 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 8 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
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
72918 38642 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40567 6015859.80735798 2093156.47365065 37.7282996512663 -122.38740653837 (37.7282996512663, -122.38740653837) 10 3 8 58 1
75146 42256 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1451 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2000 12:00:00 AM     Permit Number 42500 6014382.14951701 2101979.25998884 37.7524432441755 -122.39313199334 (37.7524432441755, -122.39313199334) 10 3 8 28856 1
82292 38596 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 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
86065 29418 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2601X Ingalls St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6015194.8940554 2091164.3100784 37.7227927176508 -122.389566117231 (37.7227927176508, -122.389566117231) 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
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
90544 36823 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 3 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
93563 38619 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 2 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
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
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
114130 36832 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2655 Ingalls St 3 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
115401 40066 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1400 Thomas Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2005 12:00:00 AM     Permit Number 41294 6015817.64770175 2093187.90304466 37.7283836150635 -122.387554479201 (37.7283836150635, -122.387554479201) 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
118676 38594 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 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
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
124971 36826 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 7 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
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
129068 36828 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2600 Ingalls St 2 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
129093 40069 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1410 Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41295 6015766.58727052 2093225.96783558 37.7284853051097 -122.387733653848 (37.7284853051097, -122.387733653848) 10 3 8 58 1
135659 36831 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2655 Ingalls St 2 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
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
138527 42740 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 188 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42736 6012851.94955825 2087048.25997051 37.7113606761586 -122.397376721388 (37.7113606761586, -122.397376721388) 10 3 8 309 1
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
140640 38620 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 3 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
145081 36827 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2600 Ingalls St 1 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
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
146130 40068 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1410 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41295 6015766.58727052 2093225.96783558 37.7284853051097 -122.387733653848 (37.7284853051097, -122.387733653848) 10 3 8 58 1
147085 40061 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 2 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
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
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
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
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
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
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
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
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
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
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
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
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
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
61291 113491 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 366x 07TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712 2113143 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165) 11 6 2 54 11
64036 43694 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 750 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43338 5993218.66242977 2110366.15850001 37.7742730687673 -122.46692789928 (37.7742730687673, -122.46692789928) 11 6 2 54 11
70992 38813 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 343 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1998 12:00:00 AM     Permit Number 40648 5992447.48955931 2113145.89233921 37.7818609227719 -122.469797921948 (37.7818609227719, -122.469797921948) 11 6 2 54 11
108586 38812 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 343 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1998 12:00:00 AM     Permit Number 40648 5992447.48955931 2113145.89233921 37.7818609227719 -122.469797921948 (37.7818609227719, -122.469797921948) 11 6 2 54 11
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
36266 41842 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1459 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42231 5992090.13126179 2105515.92983571 37.7608904365533 -122.470478344247 (37.7608904365533, -122.470478344247) 1 8 4 56 12
36381 37477 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1466 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39948 5991509.07030691 2105439.09012647 37.7606458402301 -122.472482356472 (37.7606458402301, -122.472482356472) 1 8 4 56 12
67851 34930 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1790 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/1997 12:00:00 AM     Permit Number 38522 5991259.7839455 2103214.98783119 37.7545246106445 -122.473182309921 (37.7545246106445, -122.473182309921) 1 8 4 56 12
68189 68517 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 146 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32397 5993053.91795071 2101210.30087773 37.7491239746497 -122.466832052807 (37.7491239746497, -122.466832052807) 1 8 4 29491 12
93886 68599 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1939 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/1993 12:00:00 AM     Permit Number 32502 5991241.84953509 2102215.30732714 37.7517787113613 -122.473171429533 (37.7517787113613, -122.473171429533) 1 8 4 29491 12
97486 36111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1290 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39208 5992413.02593495 2106678.51938145 37.7641012654702 -122.469446232974 (37.7641012654702, -122.469446232974) 11 8 11 56 12
100897 68054 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1881 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1993 12:00:00 AM     Permit Number 31791 5993737.20481548 2102706.11474697 37.7532705090115 -122.46457785688 (37.7532705090115, -122.46457785688) 1 8 4 56 12
116814 41829 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1406 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42215 5991820.03879919 2105845.80564429 37.7617805674142 -122.471436503306 (37.7617805674142, -122.471436503306) 1 8 4 56 12
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
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
31600 38082 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000645.66901 2113851.82701 37.7842696912791 -122.44148677751 (37.7842696912791, -122.44148677751) 15 6 11 29490 13
33819 38088 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000614.67901 2114079.17001 37.7848921510189 -122.441610312074 (37.7848921510189, -122.441610312074) 15 6 11 29490 13
47019 39910 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
49210 114656 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6001274.7016 2113900.9823 37.78444047533 -122.439314075739 (37.78444047533, -122.439314075739) 15 6 11 29490 13
49379 38081 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000619.36701 2114044.53501 37.7847973193303 -122.441591606798 (37.7847973193303, -122.441591606798) 15 6 11 29490 13
49579 114652 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6001448.056 2113923.3749 37.7845118231904 -122.438715935573 (37.7845118231904, -122.438715935573) 15 6 11 29490 13
64436 114654 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001378.1104 2113915.8269 37.7844871189173 -122.438957381866 (37.7844871189173, -122.438957381866) 15 6 11 29490 13
70486 38076 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000627.17901 2113992.97301 37.7846561884399 -122.441560878475 (37.7846561884399, -122.441560878475) 15 6 11 29490 13
73346 38079 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000639.41901 2113899.22301 37.7843994724246 -122.441511802515 (37.7843994724246, -122.441511802515) 15 6 11 29490 13
77186 39908 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
86961 39907 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
88322 38072 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000643.06501 2113866.93101 37.7843110146233 -122.441496870623 (37.7843110146233, -122.441496870623) 15 6 11 29490 13
89820 39905 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
109355 38078 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000636.81501 2113914.58701 37.7844415096587 -122.441521914323 (37.7844415096587, -122.441521914323) 15 6 11 29490 13
127672 38084 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
136957 38083 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
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
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

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