Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188086 | 188086 | 65745 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 242 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 10 | Permit Number 28704 | 6000840.51659 | 2087219.5194400002 | 37.7111548407988 | -122.43890347461 | (37.7111548407988, -122.43890347461) | |
| 23823 | 23823 | 42743 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 295 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42737 | 6012647.1314 | 2087116.87515 | 37.7115376741026 | -122.398089440585 | (37.7115376741026, -122.398089440585) | ||
| 54894 | 54894 | 69414 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 77 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 8 | Permit Number 33519 | 6001938.39138 | 2087385.6198099998 | 37.711673318833796 | -122.435120827182 | (37.7116733188338, -122.435120827182) | |
| 44338 | 44338 | 207495 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 218 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5992735.18915 | 2088665.77704 | 37.7146614305504 | -122.467022318922 | (37.7146614305504, -122.467022318922) | |||
| 63942 | 63942 | 176182 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 200 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5998635.4334 | 2088884.2911 | 37.7156002193629 | -122.44664445567301 | (37.7156002193629, -122.446644455673) | |||
| 65750 | 65750 | 207490 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 13 Thrift St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996346.95254 | 2089599.2142 | 37.717432241793205 | -122.45460605392401 | (37.7174322417932, -122.454606053924) | |||
| 173568 | 173568 | 207489 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 226 Thrift St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 6ft | 5994760.7353 | 2089660.3504700002 | 37.7175090007127 | -122.460093262 | (37.7175090007127, -122.460093262) | |||
| 187272 | 187272 | 45474 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1349 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44253 | 5999367.63833 | 2089888.0893 | 37.718398218877 | -122.444185721794 | (37.718398218877, -122.444185721794) | |
| 31908 | 31908 | 207496 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 426 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5993791.26805 | 2090028.04623 | 37.7184627965046 | -122.46347090877899 | (37.7184627965046, -122.463470908779) | ||||
| 185014 | 185014 | 207488 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 36 Harold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5996823.38616 | 2090394.7857400002 | 37.7196440101375 | -122.45301664789801 | (37.7196440101375, -122.453016647898) | ||||
| 125294 | 125294 | 176198 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998989.57955 | 2090542.3676900002 | 37.720173141569 | -122.445539530639 | (37.720173141569, -122.445539530639) | |||
| 151239 | 151239 | 176197 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5998975.73013 | 2090548.27475 | 37.720188570324204 | -122.445587827823 | (37.7201885703242, -122.445587827823) | |||
| 167343 | 167343 | 176196 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998970.24187 | 2090551.75587 | 37.7201978153451 | -122.445607049032 | (37.7201978153451, -122.445607049032) | |||
| 62213 | 62213 | 176195 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5998964.86489 | 2090556.5222099999 | 37.720210595634605 | -122.445625977963 | (37.7202105956346, -122.445625977963) | |||
| 48055 | 48055 | 176194 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5998956.61434 | 2090559.37492 | 37.720217957471704 | -122.44565470229799 | (37.7202179574717, -122.445654702298) | |||
| 148790 | 148790 | 176193 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998949.70909 | 2090563.2644599997 | 37.7202282430074 | -122.445678850924 | (37.7202282430074, -122.445678850924) | |||
| 148799 | 148799 | 176192 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998935.8928 | 2090570.77641 | 37.7202480802556 | -122.445727149009 | (37.7202480802556, -122.445727149009) | |||
| 39353 | 39353 | 176191 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5998925.79803 | 2090576.3375099998 | 37.7202627733854 | -122.44576244287799 | (37.7202627733854, -122.445762442878) | |||
| 170560 | 170560 | 176190 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5998918.88698 | 2090579.95992 | 37.7202723250901 | -122.44578659238 | (37.7202723250901, -122.44578659238) | |||
| 34556 | 34556 | 176189 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998893.49045 | 2090593.19981 | 37.7203072286757 | -122.445875331189 | (37.7203072286757, -122.445875331189) | |||
| 67050 | 67050 | 176188 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5998880.863480001 | 2090599.2128400002 | 37.7203230180654 | -122.44591941055401 | (37.7203230180654, -122.445919410554) | |||
| 52978 | 52978 | 176187 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5998858.2339699995 | 2090609.3161099998 | 37.7203494671212 | -122.44599835935301 | (37.7203494671212, -122.445998359353) | |||
| 154975 | 154975 | 176186 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998840.97625 | 2090619.3076900002 | 37.7203759162079 | -122.44605873171899 | (37.7203759162079, -122.446058731719) | |||
| 29667 | 29667 | 176185 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5998832.19664 | 2090623.5038299998 | 37.7203869364761 | -122.446089381522 | (37.7203869364761, -122.446089381522) | |||
| 59304 | 59304 | 176184 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998735.57322 | 2090674.4246200002 | 37.720521234959996 | -122.446427037372 | (37.72052123496, -122.446427037372) | |||
| 25855 | 25855 | 176183 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5998729.89326 | 2090676.55478 | 37.7205267594696 | -122.446446824275 | (37.7205267594696, -122.446446824275) | |||
| 182934 | 182934 | 176203 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6009481.93286 | 2090594.23315 | 37.7209089794419 | -122.40927448154301 | (37.7209089794419, -122.409274481543) | |||
| 43694 | 43694 | 176202 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6009489.79963 | 2090597.2729099998 | 37.7209177667302 | -122.40924750276501 | (37.7209177667302, -122.409247502765) | |||
| 175052 | 175052 | 176201 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009499.02915 | 2090599.59902 | 37.7209246708253 | -122.409215763009 | (37.7209246708253, -122.409215763009) | |||
| 41608 | 41608 | 207494 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992718.62693 | 2091039.53667 | 37.7211782436554 | -122.467252058845 | (37.7211782436554, -122.467252058845) | |||
| 137385 | 137385 | 207493 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992717.93715 | 2091043.75308 | 37.7211897810709 | -122.467254749618 | (37.7211897810709, -122.467254749618) | |||
| 59457 | 59457 | 207492 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5992718.40075 | 2091048.7391700002 | 37.721203498421396 | -122.467253509457 | (37.7212034984214, -122.467253509457) | |||
| 68020 | 68020 | 207491 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992718.20945 | 2091059.61299 | 37.72123334423829 | -122.46725496096201 | (37.7212333442383, -122.467254960962) | |||
| 152372 | 152372 | 187583 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 747 University St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6008740.19071 | 2090749.62669 | 37.721294072735795 | -122.411849445609 | (37.7212940727358, -122.411849445609) | ||||
| 73179 | 73179 | 176199 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 800 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6011139.2917 | 2091015.07876 | 37.722157251034496 | -122.403575053247 | (37.7221572510345, -122.403575053247) | |||
| 165634 | 165634 | 187593 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010735.28382 | 2091330.7832 | 37.7230015345836 | -122.40499383541001 | (37.7230015345836, -122.40499383541) | ||||
| 165592 | 165592 | 187592 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010726.84858 | 2091332.925 | 37.723006943986896 | -122.405023145203 | (37.7230069439869, -122.405023145203) | ||||
| 181385 | 181385 | 176200 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6010755.27325 | 2091348.4361 | 37.723051123195894 | -122.404925977947 | (37.7230511231959, -122.404925977947) | |||
| 73782 | 73782 | 207487 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 484 Faxon Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994797.52832 | 2091773.8490900001 | 37.723314279209205 | -122.46011911753 | (37.7233142792092, -122.46011911753) | |||
| 19658 | 19658 | 103913 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 20296 | 20296 | 103912 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 38347 | 38347 | 103902 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 86086 | 86086 | 103907 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 94145 | 94145 | 103911 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 100077 | 100077 | 103909 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 107558 | 107558 | 103901 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 109731 | 109731 | 103908 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 118191 | 118191 | 103906 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 120276 | 120276 | 103903 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 124611 | 124611 | 103905 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 128312 | 128312 | 103900 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 138857 | 138857 | 103904 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 144807 | 144807 | 103910 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 132267 | 132267 | 38192 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 715 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 6 | Permit Number 40321 | 6011331.34824 | 2091527.76082 | 37.72357569684971 | -122.40294719786002 | (37.7235756968497, -122.40294719786) | |
| 26100 | 26100 | 201969 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6013782.624009999 | 2092181.31295 | 37.725506794893896 | -122.394519248986 | (37.7255067948939, -122.394519248986) | |||
| 77171 | 77171 | 201981 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6013639.52945 | 2092282.8618599998 | 37.725777671598294 | -122.395021027505 | (37.7257776715983, -122.395021027505) | |||
| 180334 | 180334 | 201985 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6013611.24152 | 2092292.4384599999 | 37.7258023939381 | -122.395119487989 | (37.7258023939381, -122.395119487989) | |||
| 68291 | 68291 | 201986 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6013604.03863 | 2092295.5009700002 | 37.725810402411796 | -122.395144602456 | (37.7258104024118, -122.395144602456) | |||
| 153343 | 153343 | 201989 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6013578.50346 | 2092296.28411 | 37.725811132676704 | -122.395232931161 | (37.7258111326767, -122.395232931161) | ||||
| 39053 | 39053 | 201987 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6013596.70102 | 2092297.48635 | 37.7258154458067 | -122.39517010723301 | (37.7258154458067, -122.395170107233) | |||
| 26369 | 26369 | 201988 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013586.6338 | 2092298.57883 | 37.7258178856713 | -122.39520498563 | (37.7258178856713, -122.39520498563) | ||||
| 55553 | 55553 | 201990 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013571.200540001 | 2092301.5748400001 | 37.7258252538048 | -122.395258547459 | (37.7258252538048, -122.395258547459) | ||||
| 154508 | 154508 | 207497 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995861.97122 | 2092806.17827 | 37.7262099757024 | -122.456514177902 | (37.7262099757024, -122.456514177902) | |||
| 37079 | 37079 | 207498 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995864.997719999 | 2092813.12874 | 37.726229233786704 | -122.45650421791099 | (37.7262292337867, -122.456504217911) | |||
| 137185 | 137185 | 176211 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 223 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007229.58334 | 2092624.58551 | 37.7263574447365 | -122.417203995595 | (37.7263574447365, -122.417203995595) | |||
| 188310 | 188310 | 35816 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 448 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43043 | 6010644.99759 | 2092590.80492 | 37.7264562451386 | -122.405394631775 | (37.7264562451386, -122.405394631775) | |
| 134434 | 134434 | 70478 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 64 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 10 | 6005133.6380900005 | 2092919.2307799999 | 37.7270483380922 | -122.42447053479799 | (37.7270483380922, -122.424470534798) | ||
| 64850 | 64850 | 176212 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 643 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009383.55707 | 2092917.45205 | 37.7272825386525 | -122.40977844274299 | (37.7272825386525, -122.409778442743) | |||
| 56735 | 56735 | 207486 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 112 Marston Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998687.36534 | 2093224.2464299998 | 37.7275196997744 | -122.44677705081499 | (37.7275196997744, -122.446777050815) | ||||
| 74228 | 74228 | 207484 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 117 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999294.91677 | 2093456.39313 | 37.728191808994495 | -122.444693427765 | (37.7281918089945, -122.444693427765) | ||||
| 169886 | 169886 | 207485 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 115 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5999342.30815 | 2093460.30056 | 37.728205242168606 | -122.444529875249 | (37.7282052421686, -122.444529875249) | |||
| 158480 | 158480 | 207525 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 98 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999467.57051 | 2093538.93345 | 37.728428296507104 | -122.444102487738 | (37.7284282965071, -122.444102487738) | ||||
| 28382 | 28382 | 207524 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 266 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998309.1596 | 2093573.15338 | 37.728456103557896 | -122.448109616788 | (37.7284561035579, -122.448109616788) | ||||
| 173871 | 173871 | 35481 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1011 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 9 | Permit Number 38892 | 6007771.76175 | 2093386.17164 | 37.7284790839175 | -122.415383596892 | (37.7284790839175, -122.415383596892) | ||
| 150243 | 150243 | 207450 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 520 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996939.366169999 | 2093634.8584599998 | 37.7285471311368 | -122.45284948821899 | (37.7285471311368, -122.452849488219) | |||
| 162780 | 162780 | 207445 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994317.99715 | 2093727.1572099999 | 37.7286499965007 | -122.461918327265 | (37.7286499965007, -122.461918327265) | |||
| 63542 | 63542 | 176204 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 538 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001908.14836 | 2093650.44447 | 37.7288734078601 | -122.43567327801901 | (37.7288734078601, -122.435673278019) | |||
| 150727 | 150727 | 176205 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 538 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001907.20593 | 2093652.1324099998 | 37.7288779890283 | -122.435676656773 | (37.7288779890283, -122.435676656773) | |||
| 171121 | 171121 | 176206 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 538 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001905.56245 | 2093653.69597 | 37.728882188857206 | -122.43568245020799 | (37.7288821888572, -122.435682450208) | |||
| 62238 | 62238 | 176207 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 178 Cotter St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6001859.62036 | 2093660.3477 | 37.7288978433404 | -122.435841750723 | (37.7288978433404, -122.435841750723) | |||
| 173925 | 173925 | 176210 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6000484.20754 | 2093783.71625 | 37.729158358072 | -122.440605482959 | (37.729158358072, -122.440605482959) | ||||
| 177674 | 177674 | 176209 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000493.40055 | 2093786.9872599998 | 37.729167863003504 | -122.440573936562 | (37.7291678630035, -122.440573936562) | ||||
| 60278 | 60278 | 176208 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6000504.57511 | 2093791.5155099998 | 37.729180932853296 | -122.44053562992701 | (37.7291809328533, -122.440535629927) | ||||
| 26765 | 26765 | 207471 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.11204 | 2094076.47997 | 37.7297711057327 | -122.45219426825399 | (37.7297711057327, -122.452194268254) | |||
| 70587 | 70587 | 207478 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.33701 | 2094077.0358799999 | 37.7297740771139 | -122.452107103267 | (37.7297740771139, -122.452107103267) | |||
| 56363 | 56363 | 207470 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.5742 | 2094079.0064 | 37.7297780691825 | -122.452192852745 | (37.7297780691825, -122.452192852745) | |||
| 152621 | 152621 | 207477 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.54471 | 2094079.1487 | 37.729779890312 | -122.45210653761002 | (37.729779890312, -122.45210653761) | |||
| 47406 | 47406 | 207469 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.98786 | 2094080.7785599998 | 37.7297829588082 | -122.452191550501 | (37.7297829588082, -122.452191550501) | |||
| 165627 | 165627 | 207476 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.49703 | 2094080.7785099999 | 37.7297843626508 | -122.452106819991 | (37.7297843626508, -122.452106819991) | |||
| 68201 | 68201 | 207468 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.68437 | 2094082.5659999999 | 37.7297878493071 | -122.452192728615 | (37.7297878493071, -122.452192728615) | |||
| 182773 | 182773 | 207475 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.82346 | 2094082.98352 | 37.7297904357818 | -122.452105850522 | (37.7297904357818, -122.452105850522) | |||
| 24737 | 24737 | 207467 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.67547 | 2094084.4213299998 | 37.7297929430915 | -122.452192893201 | (37.7297929430915, -122.452192893201) | |||
| 137035 | 137035 | 207474 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.276190001 | 2094085.18087 | 37.7297964378325 | -122.452107900965 | (37.7297964378325, -122.452107900965) | |||
| 36540 | 36540 | 207466 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.05021 | 2094086.70842 | 37.7297991870776 | -122.452195219742 | (37.7297991870776, -122.452195219742) | |||
| 39981 | 39981 | 207473 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.92167 | 2094087.8656099997 | 37.729803846463795 | -122.45210586311 | (37.7298038464638, -122.45210586311) | |||
| 42194 | 42194 | 207483 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999342.799240001 | 2094043.6842 | 37.729807105610206 | -122.444570089355 | (37.7298071056102, -122.444570089355) | ||||
| 27379 | 27379 | 207465 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.25418 | 2094089.75184 | 37.729807555268295 | -122.452194734107 | (37.7298075552683, -122.452194734107) | |||
| 57554 | 57554 | 207472 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.972030001 | 2094090.1048700002 | 37.729809997823104 | -122.45210585051201 | (37.7298099978231, -122.452105850512) | |||
| 136862 | 136862 | 207482 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999342.84979 | 2094046.1167 | 37.729813787571395 | -122.444570089359 | (37.7298137875714, -122.444570089359) | ||||
| 155813 | 155813 | 207481 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999342.64859 | 2094048.18923 | 37.7298194667739 | -122.44457093382799 | (37.7298194667739, -122.444570933828) |
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");