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)
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
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
94076 31013 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1016 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34783 6002340.84086344 2087450.93520516 37.7118755052494 -122.433734519918 (37.7118755052494, -122.433734519918) 9 7 6 28861 5
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
86559 38511 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 64 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1998 12:00:00 AM     Permit Number 40500 6008516.43042503 2087785.37039582 37.7131422875132 -122.412413505045 (37.7131422875132, -122.412413505045) 9 7 8 309 39
107910 51637 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 189 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2005 12:00:00 AM     Permit Number 47927 5996660.05636895 2089154.42395132 37.7162289049692 -122.453491707846 (37.7162289049692, -122.453491707846) 9 8 6 28861 24
111332 32293 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 160 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1999 12:00:00 AM     Permit Number 41561 5996702.09015079 2089306.207139 37.7166480756618 -122.453357371649 (37.7166480756618, -122.453357371649) 9 8 6 28861 24
147242 43743 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 240 Summit St 1 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
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
82374 43745 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 253 Summit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43378 5996396.86656602 2089502.57565196 37.7171697577055 -122.454426548253 (37.7171697577055, -122.454426548253) 9 8 6 28861 24
116835 43746 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 253 Summit St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43378 5996396.86656602 2089502.57565196 37.7171697577055 -122.454426548253 (37.7171697577055, -122.454426548253) 9 8 6 28861 24
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
43841 39675 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 Orizaba Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41061 5994057.0703552 2090076.01512202 37.7186098185096 -122.462555624891 (37.7186098185096, -122.462555624891) 9 8 6 28861 24
100219 39676 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 Orizaba Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41061 5994057.0703552 2090076.01512202 37.7186098185096 -122.462555624891 (37.7186098185096, -122.462555624891) 9 8 6 28861 24
63515 207425 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 359 Byxbee St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   5991937.91081 2090925.40696 37.7208197721094 -122.469942439193 (37.7208197721094, -122.469942439193) 9 8 6 64 24
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
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
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
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
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
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
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
72189 38209 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 830 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40332 6010874.68113014 2090828.02861629 37.7216288654759 -122.40447659257 (37.7216288654759, -122.40447659257) 10 3 7 309 28
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
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
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
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
29470 45414 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 845 Head St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2001 12:00:00 AM     Permit Number 44215 5993893.70509068 2091558.26488077 37.7226703098261 -122.463227804134 (37.7226703098261, -122.463227804134) 9 8 4 59 40
120572 45413 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 845 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2001 12:00:00 AM     Permit Number 44215 5993893.70509068 2091558.26488077 37.7226703098261 -122.463227804134 (37.7226703098261, -122.463227804134) 9 8 4 59 40
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
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
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
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
23158 38196 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 730 Girard St 2 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
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
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
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
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
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
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
14145 52527 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 123 San Juan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM 5 2x3 Permit Number 779986 6001343.89555 2092234.36388 37.7249531074958 -122.437522568322 (37.7249531074958, -122.437522568322) 9 7 6 28861 25
35658 36470 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 101 San Ramon Way 2 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
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
22221 36454 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1315 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39355 5995842.07912733 2092771.30842103 37.7261130893774 -122.45658042282 (37.7261130893774, -122.45658042282) 9 7 4 28861 40
47043 36453 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1315 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39355 5995842.07912733 2092771.30842103 37.7261130893774 -122.45658042282 (37.7261130893774, -122.45658042282) 9 7 4 28861 40
22083 36334 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 44 Eastwood Dr 2 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
75770 36336 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 44 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/2002 12:00:00 AM     Permit Number 39301 5995656.19844855 2092807.02452797 37.7262004833581 -122.457225579924 (37.7262004833581, -122.457225579924) 9 7 4 28861 40
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
86025 38199 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 455 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40326 6010407.74547618 2092510.58020697 37.7262226967111 -122.406209156508 (37.7262226967111, -122.406209156508) 10 3 7 309 28
43878 38172 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 433 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40308 6010665.04465284 2092691.20819375 37.7267330524509 -122.405332397121 (37.7267330524509, -122.405332397121) 10 3 7 309 28
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
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
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
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
18513 38167 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 315 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40305 6010555.26362325 2092792.3936381 37.7270047480515 -122.405719032848 (37.7270047480515, -122.405719032848) 10 3 7 309 28
20022 35741 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 231 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39015 6007788.68777846 2092857.60054619 37.7270286926321 -122.415287680245 (37.7270286926321, -122.415287680245) 9 3 7 309 28
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
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
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
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
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
12226 68412 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 33 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32249 5993232.78328668 2093269.41121212 37.7273306024275 -122.465636703092 (37.7273306024275, -122.465636703092) 9 8 4 59 40
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
25563 36489 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 5 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
97659 36491 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 6 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
119125 36493 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 3 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
140321 36492 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 1 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
144944 36488 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 2 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
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
44351 37782 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 289 Hamilton St 1 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
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
47534 34111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1398 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39363 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
106874 34110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1398 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39363 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
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
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
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
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
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
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
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
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
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
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
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
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
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
23544 42023 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 110 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42346 5993552.23919225 2093678.6131862 37.7284725917152 -122.464562053467 (37.7284725917152, -122.464562053467) 9 8 4 59 40
31634 31124 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 15 Foerster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34842 5998070.62548996 2093588.33279569 37.7284841438842 -122.448935330498 (37.7284841438842, -122.448935330498) 9 7 4 28861 40
36936 31125 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 15 Foerster St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34842 5998070.62548996 2093588.33279569 37.7284841438842 -122.448935330498 (37.7284841438842, -122.448935330498) 9 7 4 28861 40
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
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
22627 31126 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 19 Foerster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34843 5998070.7770048 2093598.16198917 37.7285111411981 -122.448935514449 (37.7285111411981, -122.448935514449) 9 7 4 28861 40
116815 35745 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1005 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39018 6007884.66062501 2093417.72691387 37.728572072766 -122.414995531053 (37.728572072766, -122.414995531053) 9 3 7 309 5
64456 42029 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 65 Upland Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42351 5994340.62872168 2093722.8989966 37.728639607369 -122.461839780515 (37.728639607369, -122.461839780515) 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
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
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
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
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

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