Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 26383 | 26383 | 207515 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 71 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999632.40668 | 2095469.97761 | 37.7337398948819 | -122.443671310503 | (37.7337398948819, -122.443671310503) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 30038 | 30038 | 207511 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999356.36789 | 2095270.9974099998 | 37.733177794305 | -122.44461135834601 | (37.733177794305, -122.444611358346) | ||||
| 30834 | 30834 | 222515 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1445 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001418.004509999 | 2099470.26771 | 37.7448254366625 | -122.43778439245001 | (37.7448254366625, -122.43778439245) | |||
| 31618 | 31618 | 222513 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1445 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001419.9831 | 2099436.11309 | 37.7447317686527 | -122.43777510514 | (37.7447317686527, -122.43777510514) | |||
| 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) | ||||
| 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) | |||
| 35272 | 35272 | 223291 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 271 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6002969.0531 | 2096218.7937599998 | 37.7359857142716 | -122.432189003136 | (37.7359857142716, -122.432189003136) | |||
| 35988 | 35988 | 222510 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 123 Marsily St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6004279.53355 | 2095213.5865099998 | 37.7332998565836 | -122.427586552585 | (37.7332998565836, -122.427586552585) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 45553 | 45553 | 207517 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 215 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5999350.95651 | 2095746.5877599998 | 37.73448334463821 | -122.444664238484 | (37.7344833446382, -122.444664238484) | |||
| 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) | |||
| 47611 | 47611 | 207519 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 906 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998840.32295 | 2095592.3894200001 | 37.7340308003734 | -122.446418571155 | (37.7340308003734, -122.446418571155) | |||
| 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) | |||
| 49292 | 49292 | 207513 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 454 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998419.395690001 | 2095283.7253 | 37.73315923141121 | -122.447851626453 | (37.7331592314112, -122.447851626453) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 130891 | 130891 | 207453 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 730 Ulloa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5993922.42412 | 2098155.36186 | 37.7407859697846 | -122.463607085923 | (37.7407859697846, -122.463607085923) | |||
| 134437 | 134437 | 207449 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 36 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5996496.77472 | 2095409.8676 | 37.7333955075962 | -122.454507715774 | (37.7333955075962, -122.454507715774) | |||
| 135986 | 135986 | 207463 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 698 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5996886.4017900005 | 2094438.11032 | 37.7307496337669 | -122.453090548796 | (37.7307496337669, -122.453090548796) | |||
| 136266 | 136266 | 207464 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 118 Ridgewood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5996817.27631 | 2094530.75495 | 37.731000051814206 | -122.453336211192 | (37.7310000518142, -122.453336211192) | |||
| 136456 | 136456 | 207503 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 745 Ulloa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5993822.08464 | 2098107.46233 | 37.7406486676059 | -122.463950543278 | (37.7406486676059, -122.463950543278) | |||
| 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) | ||||
| 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) | |||
| 137134 | 137134 | 207510 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999358.72288 | 2095270.42475 | 37.733176356297 | -122.44460317539301 | (37.733176356297, -122.444603175393) | ||||
| 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) | |||
| 137962 | 137962 | 207454 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 730 Ulloa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5993920.85369 | 2098154.62053 | 37.7407838437897 | -122.46361246204701 | (37.7407838437897, -122.463612462047) | |||
| 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) | |||
| 139784 | 139784 | 222525 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 739 27th St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001732.374 | 2099973.3898099996 | 37.7462247619684 | -122.43673337185601 | (37.7462247619684, -122.436733371856) | |||
| 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) | |||
| 146556 | 146556 | 207516 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 132 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999170.9063099995 | 2095539.25965 | 37.7339037945108 | -122.445271827652 | (37.7339037945108, -122.445271827652) | |||
| 147870 | 147870 | 124158 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 970 Anza St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5995788.03534 | 2112225.31952 | 37.7795257956775 | -122.458174612179 | (37.7795257956775, -122.458174612179) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 152734 | 152734 | 223289 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2230 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6002654.982580001 | 2098989.6554 | 37.743576047195795 | -122.43347282043699 | (37.7435760471958, -122.433472820437) | |||
| 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) | ||||
| 154279 | 154279 | 207509 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999366.08904 | 2095270.5336900002 | 37.7331770757488 | -122.444577716507 | (37.7331770757488, -122.444577716507) |
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");