Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50781 | 50781 | 223919 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 293 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006519.52162 | 2104466.46125 | 37.7588326032685 | -122.420498850765 | (37.7588326032685, -122.420498850765) | |||
| 51210 | 51210 | 117851 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 646 39th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5983837.5936900005 | 2111421.5646599997 | 37.776624996189206 | -122.499456225728 | (37.7766249961892, -122.499456225728) | |||
| 51461 | 51461 | 223294 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 779 Andover St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6007381.1978 | 2095205.1537400002 | 37.7334516540573 | -122.416862619235 | (37.7334516540573, -122.416862619235) | |||
| 51848 | 51848 | 191050 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1980 Revere Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6013083.07129 | 2095907.7948099999 | 37.7357000338279 | -122.39719874844201 | (37.7357000338279, -122.397198748442) | ||||
| 51936 | 51936 | 223295 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007196.68855 | 2097540.75873 | 37.7398543306231 | -122.417666007897 | (37.7398543306231, -122.417666007897) | |||
| 51944 | 51944 | 223900 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005051.2163 | 2102450.9229099997 | 37.753215551081794 | -122.425433499183 | (37.7532155510818, -122.425433499183) | |||
| 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) | |||
| 54391 | 54391 | 207512 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999349.275230001 | 2095271.40684 | 37.733178513774796 | -122.44463590891701 | (37.7331785137748, -122.444635908917) | ||||
| 54481 | 54481 | 222526 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4302 Cesar Chavez St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6001855.92203 | 2100330.2514 | 37.7472116402063 | -122.436331694157 | (37.7472116402063, -122.436331694157) | |||
| 54589 | 54589 | 222509 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 123 Marsily St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6004280.34409 | 2095211.59088 | 37.733294422879 | -122.427583608195 | (37.733294422879, -122.427583608195) | |||
| 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) | |
| 54905 | 54905 | 223909 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005053.21271 | 2102428.9939599996 | 37.753155452084705 | -122.42542503473899 | (37.7531554520847, -122.425425034739) | |||
| 54985 | 54985 | 126463 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 845 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998902.34401 | 2121345.9026 | 37.8047469543639 | -122.44805780953199 | (37.8047469543639, -122.448057809532) | |||
| 55207 | 55207 | 207432 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5991562.70907 | 2104938.76193 | 37.7592751758288 | -122.47226037344299 | (37.7592751758288, -122.472260373443) | ||||
| 55215 | 55215 | 207480 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999342.45977 | 2094050.8697400002 | 37.729826816053794 | -122.444571779177 | (37.7298268160538, -122.444571779177) | ||||
| 55413 | 55413 | 76397 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 701 Amador St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1999 12:00:00 AM | 5 | 6016633.05444 | 2099489.61531 | 37.7457319802501 | -122.38517445926 | (37.7457319802501, -122.38517445926) | ||
| 55504 | 55504 | 223313 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6001079.43787 | 2104214.39787 | 37.757832421350706 | -122.439295071829 | (37.7578324213507, -122.439295071829) | |||
| 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) | ||||
| 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) | |||
| 56678 | 56678 | 207501 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 421 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995678.5149300005 | 2095805.70725 | 37.7344354233544 | -122.457365278307 | (37.7344354233544, -122.457365278307) | |||
| 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) | ||||
| 57161 | 57161 | 249936 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 339 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011252.89025 | 2120033.51867 | 37.8018417214754 | -122.405224787598 | (37.8018417214754, -122.405224787598) | |||
| 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) | |||
| 58247 | 58247 | 222508 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 123 Marsily St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6004280.8593 | 2095209.0357 | 37.7332874360711 | -122.427581644992 | (37.7332874360711, -122.427581644992) | |||
| 58654 | 58654 | 223912 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 69 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007426.45015 | 2098992.55773 | 37.7438535743744 | -122.41697442385299 | (37.7438535743744, -122.416974423853) | |||
| 59100 | 59100 | 207479 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999342.510319999 | 2094053.30224 | 37.729833498015 | -122.444571779181 | (37.729833498015, -122.444571779181) | ||||
| 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) | |||
| 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) | |||
| 59840 | 59840 | 207507 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 131 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6000533.96633 | 2095190.65838 | 37.7330243285976 | -122.44053433311501 | (37.7330243285976, -122.440534333115) | ||||
| 59913 | 59913 | 222517 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 714 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6001862.10862 | 2099746.95983 | 37.7456104108039 | -122.436268564438 | (37.7456104108039, -122.436268564438) | |||
| 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) | ||||
| 61457 | 61457 | 223323 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000992.8223 | 2105437.44063 | 37.7611856686148 | -122.43968230461 | (37.7611856686148, -122.43968230461) | |||
| 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) | |||
| 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) | |||
| 62894 | 62894 | 50307 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 755 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 6 | Permit Number 47018 | 6012755.49383 | 2104002.55412 | 37.7579082710796 | -122.398899267499 | (37.7579082710796, -122.398899267499) | ||
| 63235 | 63235 | 191038 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015383.3127 | 2102378.63663 | 37.7535954139151 | -122.38969766693 | (37.7535954139151, -122.38969766693) | ||||
| 63255 | 63255 | 191046 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 900x Carolina St | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6012503.19406 | 2103068.83729 | 37.7553304273806 | -122.399706272322 | (37.7553304273806, -122.399706272322) | ||||
| 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) | |||
| 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) | |||
| 64439 | 64439 | 67487 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1715 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 3 | Permit Number 31011 | 6012862.87074 | 2104700.41126 | 37.759830416353296 | -122.398576880337 | (37.7598304163533, -122.398576880337) | |
| 64506 | 64506 | 76360 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 701 Amador St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1999 12:00:00 AM | 6 | 6016677.697430001 | 2099491.25427 | 37.7457389499883 | -122.38502020301901 | (37.7457389499883, -122.385020203019) | ||
| 64755 | 64755 | 223890 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009196.08294 | 2099133.7546900003 | 37.7443406562118 | -122.41086539301901 | (37.7443406562118, -122.410865393019) | |||
| 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) | |||
| 64887 | 64887 | 124159 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 970 Anza St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5995776.57441 | 2112223.28537 | 37.7795195518878 | -122.45821411290599 | (37.7795195518878, -122.458214112906) | |||
| 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) | |||
| 65841 | 65841 | 223335 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 147 Beacon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6003368.46906 | 2097136.1116900002 | 37.7385270976507 | -122.43087350809999 | (37.7385270976507, -122.4308735081) | |||
| 66168 | 66168 | 207429 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5992094.2339699995 | 2105504.39511 | 37.7608590024631 | -122.47046331483101 | (37.7608590024631, -122.470463314831) | |||
| 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) | |||
| 67234 | 67234 | 248105 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010429.9574 | 2099572.50671 | 37.745614482938706 | -122.406629807421 | (37.7456144829387, -122.406629807421) | |||
| 67975 | 67975 | 222532 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002001.73175 | 2099265.91821 | 37.744297515714 | -122.43575135893101 | (37.744297515714, -122.435751358931) | |||
| 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) | |||
| 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) | |||
| 68242 | 68242 | 223322 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 7 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003609.4958 | 2104203.70513 | 37.757946713498704 | -122.430544316686 | (37.7579467134987, -122.430544316686) | |||
| 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) | |||
| 68874 | 68874 | 207441 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1290 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5992406.747330001 | 2106715.1011 | 37.76420134633379 | -122.46947061170602 | (37.7642013463338, -122.469470611706) | |||
| 68970 | 68970 | 31151 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 666 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34854 | 5997015.55395 | 2094425.7402599999 | 37.7307230695921 | -122.45264315945299 | (37.7307230695921, -122.452643159453) | |
| 69833 | 69833 | 207431 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5991561.23107 | 2104931.23818 | 37.7592544320617 | -122.472264936581 | (37.7592544320617, -122.472264936581) | ||||
| 70125 | 70125 | 223914 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6007781.004319999 | 2096146.35103 | 37.7360584568237 | -122.415546984806 | (37.7360584568237, -122.415546984806) | |||
| 70135 | 70135 | 222512 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 95 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005345.21251 | 2099598.65373 | 37.7454004829386 | -122.42421396182199 | (37.7454004829386, -122.424213961822) | |||
| 70216 | 70216 | 207499 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2225 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5993421.6511 | 2100648.01596 | 37.747601300271604 | -122.46551959497101 | (37.7476013002716, -122.465519594971) | |||
| 70316 | 70316 | 222536 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.604180001 | 2099254.59883 | 37.7442663713055 | -122.43575444811898 | (37.7442663713055, -122.435754448119) | |||
| 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) | |||
| 71939 | 71939 | 223885 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1201 San Jose Ave | 53 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004491.44373 | 2096094.2643900001 | 37.7357299839367 | -122.42691662060601 | (37.7357299839367, -122.426916620606) | ||||
| 72269 | 72269 | 222511 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 190 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006121.17792 | 2096336.3639900002 | 37.7364867517461 | -122.42129917361099 | (37.7364867517461, -122.421299173611) | |||
| 72322 | 72322 | 31150 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 666 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34854 | 5996999.96036 | 2094426.5225799999 | 37.730724324156704 | -122.452697125077 | (37.7307243241567, -122.452697125077) | |
| 72412 | 72412 | 223315 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 359 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003283.341019999 | 2104456.3095299997 | 37.7586218228666 | -122.431690331759 | (37.7586218228666, -122.431690331759) | |||
| 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) | |||
| 73235 | 73235 | 191044 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 801 19th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6015135.407930001 | 2105291.0534099997 | 37.761578537441395 | -122.390758499125 | (37.7615785374414, -122.390758499125) | ||||
| 73507 | 73507 | 207506 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 155 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000387.096390001 | 2095198.9294 | 37.7330386745754 | -122.44104269288401 | (37.7330386745754, -122.441042692884) | ||||
| 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) | |||
| 74101 | 74101 | 223309 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6001055.986930001 | 2104225.03313 | 37.75786028864879 | -122.4393769371 | (37.7578602886488, -122.4393769371) | |||
| 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) | ||||
| 74349 | 74349 | 207520 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 910 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5998827.615259999 | 2095598.2840200001 | 37.734046259733404 | -122.44646292933001 | (37.7340462597334, -122.44646292933) | |||
| 75831 | 75831 | 223288 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 560 27th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 10ft | 6002668.43005 | 2100082.97716 | 37.7465788160763 | -122.433504438803 | (37.7465788160763, -122.433504438803) | |||
| 76605 | 76605 | 207439 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 306 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993339.70707 | 2104624.4462200003 | 37.758514827803104 | -122.46609186415199 | (37.7585148278031, -122.466091864152) | |||
| 76858 | 76858 | 223306 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004310.1714 | 2103386.37188 | 37.7557421774856 | -122.428062839822 | (37.7557421774856, -122.428062839822) | |||
| 77007 | 77007 | 207442 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 67 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993137.4318699995 | 2098655.60003 | 37.7421142351796 | -122.46635761832701 | (37.7421142351796, -122.466357618327) | |||
| 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) | |||
| 77357 | 77357 | 111267 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700X BOSWORTH ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 81102 | 81102 | 94349 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 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) | |||
| 87677 | 87677 | 111277 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700X BOSWORTH ST | 15 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 88339 | 88339 | 115364 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 69 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007449.0 | 2098988.0 | 37.743842328307 | -122.416896128684 | (37.743842328307, -122.416896128684) | |||
| 88509 | 88509 | 23596 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 200X Vasquez Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 90361 | 90361 | 88617 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2494 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51590 | 5981831.2 | 2098131.1 | 37.740015242507 | -122.505411474316 | (37.740015242507, -122.505411474316) | |||
| 91472 | 91472 | 94355 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2010 12:00:00 AM | 3x3 | Permit Number 53635 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||
| 91814 | 91814 | 113278 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2083 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003046.0 | 2118476.0 | 37.797102943491 | -122.433513059035 | (37.797102943491, -122.433513059035) | ||||
| 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) | |||
| 94561 | 94561 | 5564 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1004 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x20 | 6005043.313071599 | 2102494.5958208 | 37.753335020194996 | -122.425463937964 | (37.753335020195, -122.425463937964) | |||
| 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) | |||
| 106533 | 106533 | 223300 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 9 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005822.66174 | 2099626.06801 | 37.7455027034951 | -122.422564964906 | (37.7455027034951, -122.422564964906) | |||
| 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) | |||
| 116198 | 116198 | 117664 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5983878.8751300005 | 2111710.17251 | 37.7774198517188 | -122.49933475552601 | (37.7774198517188, -122.499334755526) | |||
| 117707 | 117707 | 94350 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 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) | |||
| 119592 | 119592 | 207447 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2 Teresita Blvd | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997345.19439 | 2099475.93136 | 37.7446085570499 | -122.451867739721 | (37.7446085570499, -122.451867739721) | |||
| 119728 | 119728 | 106692 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 6005110.7 | 2103657.1 | 37.75653079247879 | -122.425313618185 | (37.7565307924788, -122.425313618185) | |||
| 120089 | 120089 | 223296 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 383 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006096.414419999 | 2097922.56825 | 37.7408407178299 | -122.421497409371 | (37.7408407178299, -122.421497409371) | |||
| 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) |
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");