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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 121635 | 121635 | 94353 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 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) | |||
| 128683 | 128683 | 94354 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 129119 | 129119 | 94351 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 138663 | 138663 | 94352 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 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) | |||
| 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) | |||
| 26062 | 26062 | 247051 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 519 Valley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.743985438385295 | -122.43395073994499 | (37.7439854383853, -122.433950739945) | |||
| 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) | |||
| 28548 | 28548 | 223916 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6007765.411040001 | 2096148.4497200001 | 37.736063342858 | -122.415601045774 | (37.736063342858, -122.415601045774) | |||
| 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) | ||||
| 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) | |||
| 41331 | 41331 | 223920 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 603 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006073.38987 | 2099874.4724 | 37.7461989073679 | -122.421715625397 | (37.7461989073679, -122.421715625397) | |||
| 41726 | 41726 | 247864 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 399 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009555.15097 | 2098432.68764 | 37.742435806664794 | -122.409574335293 | (37.7424358066648, -122.409574335293) | ||||
| 44388 | 44388 | 247962 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 14 Joy St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6010359.95763 | 2098907.35395 | 37.7437842015861 | -122.40682498730699 | (37.7437842015861, -122.406824987307) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 151825 | 151825 | 247963 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 14 Joy St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6010355.2725599995 | 2098907.44942 | 37.7437842015769 | -122.406841193976 | (37.7437842015769, -122.406841193976) | ||||
| 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) | |||
| 152923 | 152923 | 223910 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 156 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004889.92783 | 2099325.70173 | 37.7446253015285 | -122.42576883925699 | (37.7446253015285, -122.425768839257) | |||
| 157311 | 157311 | 247865 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 400 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009511.40819 | 2098411.1338400003 | 37.742374173428004 | -122.40972406433201 | (37.742374173428, -122.409724064332) | ||||
| 164542 | 164542 | 223896 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005049.72495 | 2102468.45452 | 37.7532636045415 | -122.42543990412399 | (37.7532636045415, -122.425439904124) | |||
| 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) | |||
| 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) | |||
| 175092 | 175092 | 223334 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 147 Beacon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6003368.54256 | 2097139.67402 | 37.7385368831568 | -122.43087350813299 | (37.7385368831568, -122.430873508133) | |||
| 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) | |||
| 184076 | 184076 | 223326 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001032.4361 | 2105462.77683 | 37.7612574902612 | -122.439547114034 | (37.7612574902612, -122.439547114034) | |||
| 27710 | 27710 | 247815 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 536 30th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003101.83098 | 2098352.54128 | 37.7418520216442 | -122.43188224706101 | (37.7418520216442, -122.431882247061) | |||
| 36355 | 36355 | 191048 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 508 Missouri St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 8ft | 6013509.22069 | 2104630.04045 | 37.759673181581796 | -122.396336524335 | (37.7596731815818, -122.396336524335) | |||
| 37542 | 37542 | 223915 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6007768.9471 | 2096146.5978599999 | 37.73605845682229 | -122.415588689077 | (37.7360584568223, -122.415588689077) | |||
| 41771 | 41771 | 223284 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.28454 | 2099249.93485 | 37.7442535469551 | -122.43575521973801 | (37.7442535469551, -122.435755219738) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 133070 | 133070 | 223913 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6007786.13084 | 2096145.8013 | 37.736057235545296 | -122.41552922139601 | (37.7360572355453, -122.415529221396) | |||
| 133999 | 133999 | 223283 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.55819 | 2099252.37585 | 37.744260264912 | -122.435754448127 | (37.744260264912, -122.435754448127) | |||
| 136760 | 136760 | 207514 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 747 Detroit St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5999418.54493 | 2095450.46717 | 37.7336741238608 | -122.444409289657 | (37.7336741238608, -122.444409289657) | ||||
| 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) | |||
| 150339 | 150339 | 222535 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.66396 | 2099257.4887 | 37.7442743096056 | -122.435754448132 | (37.7442743096056, -122.435754448132) | |||
| 151065 | 151065 | 223904 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005052.50435 | 2102441.86115 | 37.753190742372205 | -122.425428400012 | (37.7531907423722, -122.425428400012) | |||
| 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) | ||||
| 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) | ||||
| 164386 | 164386 | 223285 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.46161 | 2099247.70726 | 37.7442474405741 | -122.435754448124 | (37.7442474405741, -122.435754448124) | |||
| 166653 | 166653 | 207459 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.33255 | 2094441.7162 | 37.7308278882933 | -122.448963220871 | (37.7308278882933, -122.448963220871) | |||
| 171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
| 179667 | 179667 | 222531 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.69845 | 2099269.9426700003 | 37.7443085072419 | -122.43575521973601 | (37.7443085072419, -122.435755219736) | |||
| 180012 | 180012 | 207508 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999372.65026 | 2095269.8732900003 | 37.7331756368378 | -122.44455498523001 | (37.7331756368378, -122.44455498523) | ||||
| 182550 | 182550 | 207460 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.25164 | 2094437.83173 | 37.730817217831 | -122.44896322087799 | (37.730817217831, -122.448963220878) | |||
| 182901 | 182901 | 207518 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 175 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5999625.441330001 | 2095740.45065 | 37.7344821530156 | -122.44371481609699 | (37.7344821530156, -122.443714816097) | |||
| 183201 | 183201 | 223899 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005050.67979 | 2102453.42416 | 37.7532223886195 | -122.425435532533 | (37.7532223886195, -122.425435532533) | |||
| 183431 | 183431 | 207461 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.39557 | 2094433.7139599998 | 37.7308059196407 | -122.44896242678101 | (37.7308059196407, -122.448962426781) | |||
| 185995 | 185995 | 207504 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 61 Burnside Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6001193.27416 | 2095765.4721 | 37.734640154910295 | -122.43829610308399 | (37.7346401549103, -122.438296103084) | ||||
| 187148 | 187148 | 223902 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005052.00491 | 2102446.20203 | 37.753202633200296 | -122.425430436072 | (37.7532026332003, -122.425430436072) | |||
| 3721 | 3721 | 36883 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2515 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002662.87522 | 2116961.2420799998 | 37.792922065545504 | -122.43473038919501 | (37.7929220655455, -122.434730389195) | ||
| 21889 | 21889 | 16054 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 215 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2000 12:00:00 AM | 3 | 3X3 | 6000626.0327699995 | 2094620.4537900002 | 37.7314639212093 | -122.440175160965 | (37.7314639212093, -122.440175160965) | ||
| 24113 | 24113 | 223308 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000449.27846 | 2104630.8077 | 37.7589399004855 | -122.44150430050199 | (37.7589399004855, -122.441504300502) | |||
| 25470 | 25470 | 223317 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 2 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003628.73131 | 2104227.65103 | 37.7580135529078 | -122.430479500748 | (37.7580135529078, -122.430479500748) | |||
| 25525 | 25525 | 223307 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Hill St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004278.85639 | 2103386.69911 | 37.755741304225396 | -122.428171160475 | (37.7557413042254, -122.428171160475) | |||
| 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) | |||
| 30335 | 30335 | 223901 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005051.96111 | 2102449.00234 | 37.753210319725106 | -122.425430786811 | (37.7532103197251, -122.425430786811) | |||
| 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) | ||||
| 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) |
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");