trees
368 rows where qSpecies_id = 144 sorted by DBH
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27622 | 103900 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 31507 | 94354 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 31558 | 94351 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 38920 | 103903 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 39002 | 103913 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 40152 | 94349 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 52981 | 103904 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 61560 | 103905 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 66250 | 103906 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 70927 | 88617 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2494 47th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51590 | 5981831.2 | 2098131.1 | 37.740015242507 | -122.505411474316 | (37.740015242507, -122.505411474316) | 1 | 8 | 3 | 29491 | 35 | |||
| 92875 | 103911 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 93161 | 103910 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 94057 | 113278 | Undocumented 4 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2083 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003046 | 2118476 | 37.797102943491 | -122.433513059035 | (37.797102943491, -122.433513059035) | 13 | 9 | 1 | 57 | 17 | ||||
| 94242 | 94355 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2010 12:00:00 AM | 3x3 | Permit Number 53635 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||
| 97048 | 103902 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 162282 | 103908 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 162486 | 94353 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 164527 | 103901 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 168114 | 94350 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 173690 | 103907 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 185750 | 94352 | Permitted Site 7 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1265@ Waller St Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999439.6 | 2108532 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | 15 | 5 | 11 | 29492 | 9 | ||||
| 186827 | 103909 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 190017 | 103912 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 6025 03rd St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | 10 | 3 | 8 | 58 | 1 | |||
| 9168 | 207492 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5992718.40075 | 2091048.73917 | 37.7212034984214 | -122.467253509457 | (37.7212034984214, -122.467253509457) | 9 | 8 | 6 | 64 | 24 | |||
| 13497 | 207473 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.92167 | 2094087.86561 | 37.7298038464638 | -122.45210586311 | (37.7298038464638, -122.45210586311) | 9 | 7 | 4 | 28861 | 40 | |||
| 34710 | 223920 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 603 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006073.38987 | 2099874.4724 | 37.7461989073679 | -122.421715625397 | (37.7461989073679, -122.421715625397) | 2 | 7 | 5 | 28859 | 2 | |||
| 35029 | 207474 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.27619 | 2094085.18087 | 37.7297964378325 | -122.452107900965 | (37.7297964378325, -122.452107900965) | 9 | 7 | 4 | 28861 | 40 | |||
| 57902 | 223919 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 293 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006519.52162 | 2104466.46125 | 37.7588326032685 | -122.420498850765 | (37.7588326032685, -122.420498850765) | 2 | 4 | 7 | 28859 | 19 | |||
| 60811 | 247865 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 400 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6009511.40819 | 2098411.13384 | 37.742374173428 | -122.409724064332 | (37.742374173428, -122.409724064332) | 10 | 7 | 7 | 28859 | 2 | ||||
| 63466 | 207478 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.33701 | 2094077.03588 | 37.7297740771139 | -122.452107103267 | (37.7297740771139, -122.452107103267) | 9 | 7 | 4 | 28861 | 40 | |||
| 63641 | 207475 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.82346 | 2094082.98352 | 37.7297904357818 | -122.452105850522 | (37.7297904357818, -122.452105850522) | 9 | 7 | 4 | 28861 | 40 | |||
| 70685 | 207510 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999358.72288 | 2095270.42475 | 37.733176356297 | -122.444603175393 | (37.733176356297, -122.444603175393) | 9 | 7 | 4 | 59 | 40 | ||||
| 71521 | 223335 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 147 Beacon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6003368.46906 | 2097136.11169 | 37.7385270976507 | -122.4308735081 | (37.7385270976507, -122.4308735081) | 2 | 7 | 5 | 63 | 7 | |||
| 95599 | 207515 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 71 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999632.40668 | 2095469.97761 | 37.7337398948819 | -122.443671310503 | (37.7337398948819, -122.443671310503) | 9 | 7 | 4 | 63 | 40 | ||||
| 102677 | 223896 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005049.72495 | 2102468.45452 | 37.7532636045415 | -122.425439904124 | (37.7532636045415, -122.425439904124) | 2 | 4 | 5 | 28862 | 22 | |||
| 103791 | 247051 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 519 Valley St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.7439854383853 | -122.433950739945 | (37.7439854383853, -122.433950739945) | 2 | 7 | 5 | 63 | 22 | |||
| 105597 | 117851 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 646 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5983837.59369 | 2111421.56466 | 37.7766249961892 | -122.499456225728 | (37.7766249961892, -122.499456225728) | 11 | 6 | 2 | 55 | 26 | |||
| 105948 | 223334 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 147 Beacon St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6003368.54256 | 2097139.67402 | 37.7385368831568 | -122.430873508133 | (37.7385368831568, -122.430873508133) | 2 | 7 | 5 | 63 | 7 | |||
| 107747 | 207476 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.49703 | 2094080.77851 | 37.7297843626508 | -122.452106819991 | (37.7297843626508, -122.452106819991) | 9 | 7 | 4 | 28861 | 40 | |||
| 112189 | 207489 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 226 Thrift St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 6ft | 5994760.7353 | 2089660.35047 | 37.7175090007127 | -122.460093262 | (37.7175090007127, -122.460093262) | 9 | 8 | 6 | 28861 | 24 | |||
| 112747 | 222525 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 739 27th St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 6001732.374 | 2099973.38981 | 37.7462247619684 | -122.436733371856 | (37.7462247619684, -122.436733371856) | 2 | 7 | 5 | 63 | 22 | |||
| 113718 | 223910 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 156 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004889.92783 | 2099325.70173 | 37.7446253015285 | -122.425768839257 | (37.7446253015285, -122.425768839257) | 2 | 7 | 5 | 63 | 22 | |||
| 124808 | 207464 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 118 Ridgewood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5996817.27631 | 2094530.75495 | 37.7310000518142 | -122.453336211192 | (37.7310000518142, -122.453336211192) | 9 | 7 | 4 | 59 | 40 | |||
| 125531 | 207469 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.98786 | 2094080.77856 | 37.7297829588082 | -122.452191550501 | (37.7297829588082, -122.452191550501) | 9 | 7 | 4 | 28861 | 40 | |||
| 129969 | 207468 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.68437 | 2094082.566 | 37.7297878493071 | -122.452192728615 | (37.7297878493071, -122.452192728615) | 9 | 7 | 4 | 28861 | 40 | |||
| 133189 | 207472 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.97203 | 2094090.10487 | 37.7298099978231 | -122.452105850512 | (37.7298099978231, -122.452105850512) | 9 | 7 | 4 | 28861 | 40 | |||
| 138631 | 247963 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 14 Joy St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6010355.27256 | 2098907.44942 | 37.7437842015769 | -122.406841193976 | (37.7437842015769, -122.406841193976) | 2 | 7 | 7 | 28859 | 2 | ||||
| 139847 | 207467 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.67547 | 2094084.42133 | 37.7297929430915 | -122.452192893201 | (37.7297929430915, -122.452192893201) | 9 | 7 | 4 | 28861 | 40 | |||
| 140955 | 223916 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 588 Ogden Ave | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6007765.41104 | 2096148.44972 | 37.736063342858 | -122.415601045774 | (37.736063342858, -122.415601045774) | 2 | 7 | 7 | 28859 | 2 | |||
| 147260 | 207511 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999356.36789 | 2095270.99741 | 37.733177794305 | -122.444611358346 | (37.733177794305, -122.444611358346) | 9 | 7 | 4 | 59 | 40 | ||||
| 159565 | 207465 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.25418 | 2094089.75184 | 37.7298075552683 | -122.452194734107 | (37.7298075552683, -122.452194734107) | 9 | 7 | 4 | 28861 | 40 | |||
| 164779 | 207471 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.11204 | 2094076.47997 | 37.7297711057327 | -122.452194268254 | (37.7297711057327, -122.452194268254) | 9 | 7 | 4 | 28861 | 40 | |||
| 165040 | 207512 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5999349.27523 | 2095271.40684 | 37.7331785137748 | -122.444635908917 | (37.7331785137748, -122.444635908917) | 9 | 7 | 4 | 59 | 40 | ||||
| 165406 | 223326 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2811 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001032.4361 | 2105462.77683 | 37.7612574902612 | -122.439547114034 | (37.7612574902612, -122.439547114034) | 15 | 4 | 5 | 28862 | 3 | |||
| 170383 | 247962 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 14 Joy St | 3 | Front Yard : Yard | Tree | Private 2 | 1 | 6010359.95763 | 2098907.35395 | 37.7437842015861 | -122.406824987307 | (37.7437842015861, -122.406824987307) | 2 | 7 | 7 | 28859 | 2 | ||||
| 175816 | 207477 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.54471 | 2094079.1487 | 37.729779890312 | -122.45210653761 | (37.729779890312, -122.45210653761) | 9 | 7 | 4 | 28861 | 40 | |||
| 177391 | 207470 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.5742 | 2094079.0064 | 37.7297780691825 | -122.452192852745 | (37.7297780691825, -122.452192852745) | 9 | 7 | 4 | 28861 | 40 | |||
| 186703 | 207466 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.05021 | 2094086.70842 | 37.7297991870776 | -122.452195219742 | (37.7297991870776, -122.452195219742) | 9 | 7 | 4 | 28861 | 40 | |||
| 191465 | 247864 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 399 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 1 | 6009555.15097 | 2098432.68764 | 37.7424358066648 | -122.409574335293 | (37.7424358066648, -122.409574335293) | 10 | 7 | 7 | 28859 | 2 | ||||
| 4052 | 70478 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 64 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6005133.63809 | 2092919.23078 | 37.7270483380922 | -122.424470534798 | (37.7270483380922, -122.424470534798) | 9 | 7 | 6 | 28861 | 5 | |||
| 19814 | 207462 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 698 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5996898.44311 | 2094438.2196 | 37.730750623922 | -122.453048928172 | (37.730750623922, -122.453048928172) | 9 | 7 | 4 | 59 | 40 | |||
| 19872 | 207443 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 220x Vasquez Ave | 2 | Median : Cutout | Tree | DPW 1 | 10 | Width 6ft | 5994526.33722 | 2099104.46758 | 37.743426756136 | -122.461587791356 | (37.743426756136, -122.461587791356) | 1 | 8 | 4 | 59 | 40 | |||
| 35537 | 222526 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4302 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001855.92203 | 2100330.2514 | 37.7472116402063 | -122.436331694157 | (37.7472116402063, -122.436331694157) | 2 | 4 | 5 | 63 | 22 | |||
| 44029 | 207430 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5991564.83032 | 2104929.84825 | 37.7592508239826 | -122.472252387436 | (37.7592508239826, -122.472252387436) | 1 | 8 | 4 | 56 | 12 | ||||
| 116187 | 65745 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 242 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 10 | Permit Number 28704 | 6000840.51659 | 2087219.51944 | 37.7111548407988 | -122.43890347461 | (37.7111548407988, -122.43890347461) | 9 | 7 | 6 | 28861 | 5 | |
| 117564 | 207435 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5991562.28783 | 2104945.46167 | 37.759293547166 | -122.472262318665 | (37.759293547166, -122.472262318665) | 1 | 8 | 4 | 56 | 12 | ||||
| 128104 | 191041 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 36 | Front Yard : Yard | Tree | Private 2 | 10 | 6015379.60354 | 2102508.57435 | 37.7539519897179 | -122.38971956902 | (37.7539519897179, -122.38971956902) | 10 | 3 | 8 | 28856 | 29 | ||||
| 139660 | 26940 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3 | 6005048.82283 | 2102481.73773 | 37.7533000261745 | -122.425443969077 | (37.7533000261745, -122.425443969077) | 2 | 4 | 5 | 28862 | 22 | |||
| 172895 | 223331 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 99 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005029.44165 | 2097557.40609 | 37.7397778468682 | -122.425160628682 | (37.7397778468682, -122.425160628682) | 2 | 7 | 5 | 63 | 7 | |||
| 4110 | 117662 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5983913.56445 | 2111711.8528 | 37.7774265003929 | -122.49921487984 | (37.7774265003929, -122.49921487984) | 11 | 6 | 2 | 55 | 26 | |||
| 11367 | 207449 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 36 Brentwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 5996496.77472 | 2095409.8676 | 37.7333955075962 | -122.454507715774 | (37.7333955075962, -122.454507715774) | 9 | 7 | 4 | 59 | 40 | |||
| 45554 | 207433 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5991566.33601 | 2104938.68548 | 37.7592751758208 | -122.472247824277 | (37.7592751758208, -122.472247824277) | 1 | 8 | 4 | 56 | 12 | ||||
| 66478 | 223884 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007476.34391 | 2105418.19682 | 37.7614997244664 | -122.417257150023 | (37.7614997244664, -122.417257150023) | 2 | 4 | 7 | 28859 | 19 | |||
| 90306 | 207463 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 698 Hearst Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5996886.40179 | 2094438.11032 | 37.7307496337669 | -122.453090548796 | (37.7307496337669, -122.453090548796) | 9 | 7 | 4 | 59 | 40 | |||
| 107833 | 176203 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 746 Olmstead St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6009481.93286 | 2090594.23315 | 37.7209089794419 | -122.409274481543 | (37.7209089794419, -122.409274481543) | 9 | 3 | 7 | 309 | 28 | |||
| 167398 | 207441 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1290 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5992406.74733 | 2106715.1011 | 37.7642013463338 | -122.469470611706 | (37.7642013463338, -122.469470611706) | 11 | 8 | 11 | 56 | 12 | |||
| 24472 | 223309 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6001055.98693 | 2104225.03313 | 37.7578602886488 | -122.4393769371 | (37.7578602886488, -122.4393769371) | 2 | 4 | 5 | 28862 | 38 | |||
| 29919 | 176195 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5998964.86489 | 2090556.52221 | 37.7202105956346 | -122.445625977963 | (37.7202105956346, -122.445625977963) | 9 | 7 | 6 | 28861 | 25 | |||
| 30560 | 223328 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 255 30th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6004815.61888 | 2098395.76649 | 37.742067712369 | -122.425959600774 | (37.742067712369, -122.425959600774) | 2 | 7 | 5 | 63 | 7 | |||
| 31339 | 126467 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2711 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001788.68499 | 2115988.81164 | 37.7902023547025 | -122.437685450844 | (37.7902023547025, -122.437685450844) | 13 | 6 | 1 | 29490 | 27 | |||
| 58422 | 115364 | Undocumented 4 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 69 ELSIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007449 | 2098988 | 37.743842328307 | -122.416896128684 | (37.743842328307, -122.416896128684) | 2 | 7 | 7 | 28859 | 2 | |||
| 65808 | 23596 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 200X Vasquez Ave | 7 | Median : Cutout | Tree | DPW 1 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.461921227095 | (37.7430347013579, -122.461921227095) | 1 | 8 | 4 | 59 | 40 | |||
| 94224 | 207438 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1230 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992085.75278 | 2107027.36715 | 37.7650401898777 | -122.470603574899 | (37.7650401898777, -122.470603574899) | 11 | 8 | 11 | 56 | 12 | |||
| 106688 | 207503 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 745 Ulloa St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5993822.08464 | 2098107.46233 | 37.7406486676059 | -122.463950543278 | (37.7406486676059, -122.463950543278) | 1 | 8 | 4 | 59 | 40 | |||
| 114177 | 176191 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5998925.79803 | 2090576.33751 | 37.7202627733854 | -122.445762442878 | (37.7202627733854, -122.445762442878) | 9 | 7 | 6 | 28861 | 25 | |||
| 136963 | 26938 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3 | 6005048.24826 | 2102491.89317 | 37.7533278781854 | -122.425446678723 | (37.7533278781854, -122.425446678723) | 2 | 4 | 5 | 28862 | 22 | |||
| 150811 | 222524 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 739 27th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6001699.42535 | 2099975.49164 | 37.7462286605235 | -122.436847454466 | (37.7462286605235, -122.436847454466) | 2 | 7 | 5 | 63 | 22 | |||
| 159517 | 191044 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 801 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6015135.40793 | 2105291.05341 | 37.7615785374414 | -122.390758499125 | (37.7615785374414, -122.390758499125) | 10 | 3 | 8 | 28856 | 29 | ||||
| 173868 | 207437 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5991566.59817 | 2104953.60306 | 37.7593161507263 | -122.472248005034 | (37.7593161507263, -122.472248005034) | 1 | 8 | 4 | 56 | 12 | ||||
| 183988 | 207434 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5991566.65677 | 2104946.06953 | 37.7592954690347 | -122.472247253208 | (37.7592954690347, -122.472247253208) | 1 | 8 | 4 | 56 | 12 | ||||
| 38045 | 117665 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5983866.28213 | 2111708.82719 | 37.7774154190485 | -122.499378218726 | (37.7774154190485, -122.499378218726) | 11 | 6 | 2 | 55 | 26 | |||
| 66067 | 117664 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4739 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5983878.87513 | 2111710.17251 | 37.7774198517188 | -122.499334755526 | (37.7774198517188, -122.499334755526) | 11 | 6 | 2 | 55 | 26 | |||
| 171728 | 176188 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5998880.86348 | 2090599.21284 | 37.7203230180654 | -122.445919410554 | (37.7203230180654, -122.445919410554) | 9 | 7 | 6 | 28861 | 25 | |||
| 40369 | 176194 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 5998956.61434 | 2090559.37492 | 37.7202179574717 | -122.445654702298 | (37.7202179574717, -122.445654702298) | 9 | 7 | 6 | 28861 | 25 | |||
| 58887 | 222517 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 714 Duncan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6001862.10862 | 2099746.95983 | 37.7456104108039 | -122.436268564438 | (37.7456104108039, -122.436268564438) | 2 | 7 | 5 | 63 | 22 | |||
| 135197 | 176210 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 328 Santa Rosa Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6000484.20754 | 2093783.71625 | 37.729158358072 | -122.440605482959 | (37.729158358072, -122.440605482959) | 9 | 7 | 6 | 28861 | 25 | ||||
| 41756 | 191040 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 35 | Front Yard : Yard | Tree | Private 2 | 15 | 6015380.38588 | 2102504.53618 | 37.7539409451402 | -122.389716581452 | (37.7539409451402, -122.389716581452) | 10 | 3 | 8 | 28856 | 29 | ||||
| 79445 | 223911 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 248 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006019.93763 | 2096086.78594 | 37.735795757653 | -122.421631483913 | (37.735795757653, -122.421631483913) | 2 | 7 | 7 | 28859 | 2 | |||
| 54449 | 191043 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 38 | Front Yard : Yard | Tree | Private 2 | 16 | 6015378.95321 | 2102517.91252 | 37.7539775942935 | -122.389722470218 | (37.7539775942935, -122.389722470218) | 10 | 3 | 8 | 28856 | 29 | ||||
| 29343 | 176202 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 746 Olmstead St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6009489.79963 | 2090597.27291 | 37.7209177667302 | -122.409247502765 | (37.7209177667302, -122.409247502765) | 9 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );