Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116470 | 116470 | 42740 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 188 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42736 | 6012851.94955825 | 2087048.25997051 | 37.7113606761586 | -122.397376721388 | (37.7113606761586, -122.397376721388) | ||
| 94624 | 94624 | 31013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | ||
| 140714 | 140714 | 34803 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | Permit Number 38439 | 5997690.29775308 | 2087581.0038805 | 37.7119676582592 | -122.449817388593 | (37.7119676582592, -122.449817388593) | ||
| 91922 | 91922 | 38511 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 64 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1998 12:00:00 AM | Permit Number 40500 | 6008516.43042503 | 2087785.37039582 | 37.7131422875132 | -122.412413505045 | (37.7131422875132, -122.412413505045) | |||
| 99168 | 99168 | 51637 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 189 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47927 | 5996660.05636895 | 2089154.42395132 | 37.7162289049692 | -122.453491707846 | (37.7162289049692, -122.453491707846) | |||
| 103319 | 103319 | 32293 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 160 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41561 | 5996702.09015079 | 2089306.2071389998 | 37.716648075661794 | -122.453357371649 | (37.7166480756618, -122.453357371649) | ||
| 112383 | 112383 | 43743 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 240 Summit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.717159230973394 | -122.45422216598699 | (37.7171592309734, -122.454222165987) | ||
| 118876 | 118876 | 43744 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 240 Summit St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.717159230973394 | -122.45422216598699 | (37.7171592309734, -122.454222165987) | ||
| 95853 | 95853 | 43745 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 253 Summit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | ||
| 107053 | 107053 | 43746 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 253 Summit St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | ||
| 118568 | 118568 | 31184 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | ||
| 81242 | 81242 | 39675 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 97619 | 97619 | 39676 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41061 | 5994057.0703552 | 2090076.01512202 | 37.718609818509606 | -122.462555624891 | (37.7186098185096, -122.462555624891) | ||
| 67051 | 67051 | 207425 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991937.91081 | 2090925.4069599998 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | |||
| 90972 | 90972 | 36820 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 91047 | 91047 | 36823 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 106343 | 106343 | 36826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 117721 | 117721 | 36822 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 126247 | 126247 | 36821 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 138628 | 138628 | 36819 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1220 Fitzgerald Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 126984 | 126984 | 68883 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 59 Carr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32855 | 6013060.20442694 | 2090777.05783105 | 37.721610806199 | -122.396918198144 | (37.721610806199, -122.396918198144) | ||
| 88033 | 88033 | 38209 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 830 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40332 | 6010874.68113014 | 2090828.02861629 | 37.7216288654759 | -122.40447659257 | (37.7216288654759, -122.40447659257) | ||
| 115724 | 115724 | 38211 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 201 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40334 | 6011139.75939059 | 2091047.44760609 | 37.7222461553598 | -122.40357571280501 | (37.7222461553598, -122.403575712805) | ||
| 108536 | 108536 | 36832 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2655 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.38985519407301 | (37.7224666226612, -122.389855194073) | ||
| 110277 | 110277 | 36831 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2655 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.38985519407301 | (37.7224666226612, -122.389855194073) | ||
| 113139 | 113139 | 36830 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2655 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.38985519407301 | (37.7224666226612, -122.389855194073) | ||
| 110097 | 110097 | 45413 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 845 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.46322780413401 | (37.7226703098261, -122.463227804134) | ||
| 126706 | 126706 | 45414 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 845 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.46322780413401 | (37.7226703098261, -122.463227804134) | ||
| 94608 | 94608 | 29418 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2601X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015194.8940554 | 2091164.3100784 | 37.7227927176508 | -122.38956611723101 | (37.7227927176508, -122.389566117231) | |||
| 109133 | 109133 | 36828 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2600 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | ||
| 110387 | 110387 | 36827 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2600 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | ||
| 110879 | 110879 | 36829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2600 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | ||
| 128899 | 128899 | 38196 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 730 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | ||
| 140156 | 140156 | 38195 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 730 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | ||
| 141212 | 141212 | 38197 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 731 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40324 | 6011355.00492598 | 2091469.0696772 | 37.723415864008295 | -122.402861294571 | (37.7234158640083, -122.402861294571) | ||
| 96432 | 96432 | 38194 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40322 | 6011294.88736359 | 2091487.49408108 | 37.7234630966145 | -122.40307040641301 | (37.7234630966145, -122.403070406413) | ||
| 128191 | 128191 | 38193 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 722 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40322 | 6011294.88736359 | 2091487.49408108 | 37.7234630966145 | -122.40307040641301 | (37.7234630966145, -122.403070406413) | ||
| 1735 | 1735 | 251679 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 5 Dwight St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011495.0 | 2091622.0 | 37.7238435952898 | -122.40238810251101 | (37.7238435952898, -122.402388102511) | |||||
| 112483 | 112483 | 38176 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 5 Dwight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40311 | 6011565.07182758 | 2091659.31063556 | 37.7239499540685 | -122.402148496173 | (37.7239499540685, -122.402148496173) | ||
| 139653 | 139653 | 38180 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 42 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40313 | 6011447.25206772 | 2091677.58315317 | 37.723993549606796 | -122.402557066965 | (37.7239935496068, -122.402557066965) | ||
| 100059 | 100059 | 38179 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 36 Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40312 | 6011464.3100447 | 2091682.81198966 | 37.724008859229706 | -122.402498467389 | (37.7240088592297, -122.402498467389) | ||
| 1107 | 1107 | 52527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.3638799998 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) |
| 128091 | 128091 | 36470 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 101 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.725761835422794 | -122.456655052435 | (37.7257618354228, -122.456655052435) | ||
| 139667 | 139667 | 36471 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 101 San Ramon Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39368 | 5995817.82622595 | 2092643.889646 | 37.725761835422794 | -122.456655052435 | (37.7257618354228, -122.456655052435) | ||
| 79109 | 79109 | 36453 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | ||
| 125375 | 125375 | 36454 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39355 | 5995842.07912733 | 2092771.30842103 | 37.7261130893774 | -122.45658042282 | (37.7261130893774, -122.45658042282) | ||
| 84680 | 84680 | 36336 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 44 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.45722557992399 | (37.7262004833581, -122.457225579924) | ||
| 125553 | 125553 | 36334 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 44 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.45722557992399 | (37.7262004833581, -122.457225579924) | ||
| 141725 | 141725 | 36335 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 44 Eastwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.45722557992399 | (37.7262004833581, -122.457225579924) | ||
| 93706 | 93706 | 38199 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 455 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40326 | 6010407.74547618 | 2092510.58020697 | 37.726222696711105 | -122.40620915650801 | (37.7262226967111, -122.406209156508) | ||
| 82515 | 82515 | 38172 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 433 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40308 | 6010665.04465284 | 2092691.20819375 | 37.7267330524509 | -122.40533239712099 | (37.7267330524509, -122.405332397121) | ||
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 120211 | 120211 | 38170 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 349 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761002 | 37.726921215477205 | -122.40603833071998 | (37.7269212154772, -122.40603833072) | ||
| 144251 | 144251 | 38169 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 349 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761002 | 37.726921215477205 | -122.40603833071998 | (37.7269212154772, -122.40603833072) | ||
| 146226 | 146226 | 38168 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 349 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40306 | 6010462.31979056 | 2092763.8646761002 | 37.726921215477205 | -122.40603833071998 | (37.7269212154772, -122.40603833072) | ||
| 123371 | 123371 | 38167 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 315 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40305 | 6010555.26362325 | 2092792.3936381 | 37.7270047480515 | -122.405719032848 | (37.7270047480515, -122.405719032848) | ||
| 125836 | 125836 | 35741 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 231 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | Permit Number 39015 | 6007788.68777846 | 2092857.60054619 | 37.7270286926321 | -122.415287680245 | (37.7270286926321, -122.415287680245) | ||
| 84291 | 84291 | 40058 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 112672 | 112672 | 40061 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 116635 | 116635 | 40060 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 124234 | 124234 | 40059 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1298 Thomas Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.727259437575704 | -122.38557377869301 | (37.7272594375757, -122.385573778693) | ||
| 142628 | 142628 | 37786 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 301 Hamilton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1998 12:00:00 AM | Permit Number 40119 | 6009341.93324933 | 2092913.86947002 | 37.7272703689284 | -122.409922083912 | (37.7272703689284, -122.409922083912) | |||
| 20473 | 20473 | 68412 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | ||
| 112782 | 112782 | 42013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 39 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42341 | 5993258.45652191 | 2093300.0310097 | 37.7274161576674 | -122.46555017500799 | (37.7274161576674, -122.465550175008) | ||
| 98352 | 98352 | 36491 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 105808 | 105808 | 36493 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 111017 | 111017 | 36488 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 113737 | 113737 | 36492 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 125859 | 125859 | 36489 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 144458 | 144458 | 36487 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 95 Westwood Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.727451222085705 | -122.459125749197 | (37.7274512220857, -122.459125749197) | |||
| 83148 | 83148 | 37782 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 289 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40117 | 6009320.94225991 | 2092982.60267054 | 37.7274579192917 | -122.409999500097 | (37.7274579192917, -122.409999500097) | ||
| 142065 | 142065 | 37783 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 289 Hamilton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40117 | 6009320.94225991 | 2092982.60267054 | 37.7274579192917 | -122.409999500097 | (37.7274579192917, -122.409999500097) | ||
| 81385 | 81385 | 34111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 101426 | 101426 | 34110 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1398 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39363 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 87203 | 87203 | 38622 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 97472 | 97472 | 38619 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 109923 | 109923 | 38620 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 117991 | 117991 | 38621 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1295 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.727729298658296 | -122.385043230392 | (37.7277292986583, -122.385043230392) | ||
| 114090 | 114090 | 43251 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 270 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43039 | 6009534.75313896 | 2093131.57732831 | 37.727878953409 | -122.409270860276 | (37.727878953409, -122.409270860276) | ||
| 88116 | 88116 | 38642 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40567 | 6015859.80735798 | 2093156.47365065 | 37.7282996512663 | -122.38740653837 | (37.7282996512663, -122.38740653837) | ||
| 86438 | 86438 | 40067 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.38755447920099 | (37.7283836150635, -122.387554479201) | ||
| 105358 | 105358 | 40066 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1400 Thomas Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.38755447920099 | (37.7283836150635, -122.387554479201) | ||
| 17972 | 17972 | 38597 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 89321 | 89321 | 38593 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 91768 | 91768 | 38596 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 106822 | 106822 | 38594 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 126038 | 126038 | 38595 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1301 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.728459445030296 | -122.38466443810499 | (37.7284594450303, -122.384664438105) | ||
| 128395 | 128395 | 42023 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 110 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42346 | 5993552.23919225 | 2093678.6131862 | 37.7284725917152 | -122.464562053467 | (37.7284725917152, -122.464562053467) | ||
| 78000 | 78000 | 31125 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | ||
| 124999 | 124999 | 31124 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | ||
| 105548 | 105548 | 40069 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1410 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | ||
| 113398 | 113398 | 40068 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1410 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | ||
| 129175 | 129175 | 31126 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34843 | 5998070.7770048 | 2093598.16198917 | 37.7285111411981 | -122.448935514449 | (37.7285111411981, -122.448935514449) | ||
| 104525 | 104525 | 35745 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1005 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | Permit Number 39018 | 6007884.66062501 | 2093417.72691387 | 37.728572072766 | -122.41499553105301 | (37.728572072766, -122.414995531053) | ||
| 84960 | 84960 | 42029 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42351 | 5994340.62872168 | 2093722.8989966 | 37.728639607369 | -122.461839780515 | (37.728639607369, -122.461839780515) | ||
| 112576 | 112576 | 38598 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1329 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40549 | 6016511.31684241 | 2093304.91013991 | 37.7287432904596 | -122.385164559023 | (37.7287432904596, -122.385164559023) | ||
| 144295 | 144295 | 64645 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856003 | 37.7288421898975 | -122.46009728755301 | (37.7288421898975, -122.460097287553) | ||
| 41814 | 41814 | 38626 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 88362 | 88362 | 38629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | ||
| 117173 | 117173 | 38627 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1396 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");