400 rows where qSpecies_id = 43 sorted by Fire Prevention Districts

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)
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
89187 251679 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 5 Dwight St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011495 2091622 37.7238435952898 -122.402388102511 (37.7238435952898, -122.402388102511) 10 3 7 309 28
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
111237 38179 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 36 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40312 6011464.3100447 2091682.81198966 37.7240088592297 -122.402498467389 (37.7240088592297, -122.402498467389) 10 3 7 309 28
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
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
134688 43251 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 270 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/12/2000 12:00:00 AM     Permit Number 43039 6009534.75313896 2093131.57732831 37.727878953409 -122.409270860276 (37.727878953409, -122.409270860276) 10 3 7 309 28
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
136441 38176 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 5 Dwight St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40311 6011565.07182758 2091659.31063556 37.7239499540685 -122.402148496173 (37.7239499540685, -122.402148496173) 10 3 7 309 28
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
147396 38211 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 201 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40334 6011139.75939059 2091047.44760609 37.7222461553598 -122.403575712805 (37.7222461553598, -122.403575712805) 10 3 7 309 28
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
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
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
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
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
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
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
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
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
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
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
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
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
34181 68180 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 75 Rossi Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM     Permit Number 31952 5996329.36645327 2111693.70801186 37.7780972208044 -122.456263479509 (37.7780972208044, -122.456263479509) 11 6 2 54 16
41684 68560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32450 5981950.36786377 2112213.67297772 37.7786889858471 -122.506043321809 (37.7786889858471, -122.506043321809) 11 6 2 55 26
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
67090 90956 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4645 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2008 12:00:00 AM 3 3x3   5981155.43871 2110931.20899 37.7751208933778 -122.508698002643 (37.7751208933778, -122.508698002643) 11 6 2 55 26
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
77362 42163 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4630 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42458 5989047.18920071 2109907.45432155 37.7727719459225 -122.481324019174 (37.7727719459225, -122.481324019174) 11 6 2 55 26
79658 141253 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 45 PARKER AVE 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5996809.5439 2114265.4407 37.7851860717648 -122.454788237668 (37.7851860717648, -122.454788237668) 11 6 1 54 31
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
104093 36188 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 35 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM 7   Permit Number 39256 5996804.8059 2114366.2904 37.7854627064304 -122.454811918638 (37.7854627064304, -122.454811918638) 11 6 1 54 31
106945 140845 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 527 EUCLID AVE 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5996698.8799 2113809.925 37.7839289983891 -122.455138170133 (37.7839289983891, -122.455138170133) 11 6 1 54 31
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
129953 42147 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 490 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2000 12:00:00 AM     Permit Number 42443 5990026.73861506 2112033.51240967 37.7786664170583 -122.478091152159 (37.7786664170583, -122.478091152159) 11 6 2 55 26
140389 36187 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 35 Parker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM 8   Permit Number 39256 5996805.8212 2114349.7078 37.7854172332631 -122.45480720749 (37.7854172332631, -122.45480720749) 11 6 1 54 31
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
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
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
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
32857 47691 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2858 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45490 6001036.99468682 2116264.16139907 37.7909156246348 -122.440305990836 (37.7909156246348, -122.440305990836) 13 6 1 29490 27
39342 37525 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1150 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/22/1998 12:00:00 AM   3x3 Permit Number 52992 6007323.5106073 2115257.61387493 37.7885078148262 -122.418483459105 (37.7885078148262, -122.418483459105) 13 9 10 28858 21
59370 68249 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3531 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32050 6001184.87724579 2120700.92595518 37.8031062325164 -122.440112611548 (37.8031062325164, -122.440112611548) 13 9 1 57 17
98159 34672 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3112 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/2005 12:00:00 AM     Permit Number 38340 6003381.0349361 2119134.6254032 37.7989303613953 -122.432400821612 (37.7989303613953, -122.432400821612) 13 9 1 57 17
108248 96988 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
122439 96990 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
135345 96989 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2201 North Point St   Sidewalk: Property side : Yard Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768194 6000179.9 2120547.2 37.8026268776405 -122.443579300178 (37.8026268776405, -122.443579300178) 13 9 1 57 17
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
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
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
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
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
7624 246397 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999315.6516 2108414.4782 37.769264264093 -122.445696997639 (37.769264264093, -122.445696997639) 15 5 11 29492 9
25595 247352 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 717 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003091.9924 2109593.0641 37.7727152549133 -122.432719040926 (37.7727152549133, -122.432719040926) 15 5 11 29492 9
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
32393 246393 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1318 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999383.4853 2108424.4716 37.7692955761214 -122.445463083857 (37.7692955761214, -122.445463083857) 15 5 11 29492 9
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
39432 37587 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
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
58011 246391 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1302 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999418.9163 2108430.2253 37.7693133969257 -122.445340943975 (37.7693133969257, -122.445340943975) 15 5 11 29492 9
62613 37588 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
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
65565 246392 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1310 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999402.5635 2108427.4999 37.7693049801732 -122.445397311319 (37.7693049801732, -122.445397311319) 15 5 11 29492 9
65609 37589 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3

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