trees
368 rows where qSpecies_id = 144
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 835 | 61682 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 27 Ceres St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 4 | Permit Number 21679 | 6013919.66127 | 2093997.42296 | 37.7305010827376 | -122.394172607985 | (37.7305010827376, -122.394172607985) | 10 | 3 | 8 | 58 | 1 | |
| 961 | 76397 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6016633.05444 | 2099489.61531 | 37.7457319802501 | -122.38517445926 | (37.7457319802501, -122.38517445926) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 4102 | 222532 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 8ft | 6002001.73175 | 2099265.91821 | 37.744297515714 | -122.435751358931 | (37.744297515714, -122.435751358931) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 4179 | 76360 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016677.69743 | 2099491.25427 | 37.7457389499883 | -122.385020203019 | (37.7457389499883, -122.385020203019) | 10 | 3 | 8 | 58 | 1 | |||
| 5569 | 223298 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 352 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007782.78293 | 2105864.77472 | 37.7627431594916 | -122.416228930816 | (37.7627431594916, -122.416228930816) | 8 | 4 | 7 | 28859 | 19 | |||
| 7951 | 207453 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 730 Ulloa St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5993922.42412 | 2098155.36186 | 37.7407859697846 | -122.463607085923 | (37.7407859697846, -122.463607085923) | 1 | 8 | 4 | 59 | 40 | |||
| 8210 | 69414 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 79 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 8 | Permit Number 33519 | 6001925 | 2087361 | 37.7116049578173 | -122.435165351533 | (37.7116049578173, -122.435165351533) | 9 | 7 | 6 | 28861 | 5 | |
| 8219 | 223324 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2811 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001009.92061 | 2105447.67366 | 37.7612147391902 | -122.439623902619 | (37.7612147391902, -122.439623902619) | 15 | 4 | 5 | 28862 | 3 | |||
| 8750 | 223311 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 15 Seward St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6001071.26024 | 2104220.26116 | 37.7578480551551 | -122.439323773684 | (37.7578480551551, -122.439323773684) | 2 | 4 | 5 | 28862 | 38 | |||
| 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 | |||
| 9885 | 222514 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1445 Douglass St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001419.73158 | 2099453.0166 | 37.7447781673956 | -122.437777185266 | (37.7447781673956, -122.437777185266) | 2 | 7 | 5 | 63 | 22 | |||
| 9963 | 457 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 760x 23rd Ave | 25 | Median : Cutout | Tree | DPW 1 | 10/31/2002 12:00:00 AM | 3 | 5988833.54517 | 2109972.18567 | 37.7729372568337 | -122.482067772117 | (37.7729372568337, -122.482067772117) | 11 | 6 | 2 | 55 | 26 | |||
| 10856 | 207523 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997186.60025 | 2095013.78358 | 37.7323474952197 | -122.452094240274 | (37.7323474952197, -122.452094240274) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 12371 | 76341 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6016694.6962 | 2099491.47617 | 37.7457404995381 | -122.384961438646 | (37.7457404995381, -122.384961438646) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 14229 | 223305 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004321.04014 | 2103386.46629 | 37.7557430516272 | -122.428025258965 | (37.7557430516272, -122.428025258965) | 2 | 4 | 5 | 28862 | 22 | |||
| 14754 | 176205 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 538 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6001907.20593 | 2093652.13241 | 37.7288779890283 | -122.435676656773 | (37.7288779890283, -122.435676656773) | 9 | 7 | 6 | 28861 | 25 | |||
| 14838 | 72275 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 745 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983802 | 2110725 | 37.7747103425962 | -122.499527862048 | (37.7747103425962, -122.499527862048) | 11 | 6 | 2 | 55 | 26 | |||
| 14851 | 64452 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2255 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1988 12:00:00 AM | 6 | Permit Number 49675 | 6010720.79087 | 2105970.79652 | 37.763199036617 | -122.406074821405 | (37.763199036617, -122.406074821405) | 8 | 4 | 8 | 28859 | 19 | |
| 19131 | 248105 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6010429.9574 | 2099572.50671 | 37.7456144829387 | -122.406629807421 | (37.7456144829387, -122.406629807421) | 2 | 7 | 7 | 28859 | 2 | |||
| 19518 | 191049 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 701 Amador St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6016661.68258 | 2099490.66048 | 37.7457364337019 | -122.385075539199 | (37.7457364337019, -122.385075539199) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 19863 | 126465 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2219 Chestnut St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 1ft | 6001229.96585 | 2119664.24858 | 37.8002623581754 | -122.439882208601 | (37.8002623581754, -122.439882208601) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 20949 | 207494 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992718.62693 | 2091039.53667 | 37.7211782436554 | -122.467252058845 | (37.7211782436554, -122.467252058845) | 9 | 8 | 6 | 64 | 24 | |||
| 21084 | 223288 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 560 27th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 10ft | 6002668.43005 | 2100082.97716 | 37.7465788160763 | -122.433504438803 | (37.7465788160763, -122.433504438803) | 2 | 7 | 5 | 63 | 22 | |||
| 21848 | 207524 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 266 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998309.1596 | 2093573.15338 | 37.7284561035579 | -122.448109616788 | (37.7284561035579, -122.448109616788) | 9 | 7 | 4 | 28861 | 40 | ||||
| 22125 | 207502 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 715 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998000.03996 | 2095655.97005 | 37.7341573484745 | -122.44932825569 | (37.7341573484745, -122.44932825569) | 9 | 7 | 4 | 59 | 40 | |||
| 22532 | 223297 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 216 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007815.61312 | 2100277.20089 | 37.7474028010032 | -122.415719727502 | (37.7474028010032, -122.415719727502) | 2 | 7 | 7 | 28859 | 2 | |||
| 23135 | 223891 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008990.48886 | 2099085.34531 | 37.7441962044045 | -122.4115728771 | (37.7441962044045, -122.4115728771) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 25652 | 223299 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 267 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006192.90217 | 2101673.64979 | 37.7511457766604 | -122.4214301167 | (37.7511457766604, -122.4214301167) | 2 | 4 | 5 | 28859 | 19 | |||
| 26410 | 223291 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 271 Bemis St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6002969.0531 | 2096218.79376 | 37.7359857142716 | -122.432189003136 | (37.7359857142716, -122.432189003136) | 2 | 7 | 5 | 63 | 7 | |||
| 26487 | 223888 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005139.26418 | 2103680.11038 | 37.7565955873218 | -122.42521647029 | (37.7565955873218, -122.42521647029) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 28292 | 207450 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 520 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5996939.36617 | 2093634.85846 | 37.7285471311368 | -122.452849488219 | (37.7285471311368, -122.452849488219) | 9 | 7 | 4 | 28861 | 40 | |||
| 28526 | 111267 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700X BOSWORTH ST | 5 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 28901 | 207520 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 910 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5998827.61526 | 2095598.28402 | 37.7340462597334 | -122.44646292933 | (37.7340462597334, -122.44646292933) | 9 | 7 | 4 | 59 | 40 | |||
| 29200 | 207442 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 67 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993137.43187 | 2098655.60003 | 37.7421142351796 | -122.466357618327 | (37.7421142351796, -122.466357618327) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 29814 | 207495 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 218 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5992735.18915 | 2088665.77704 | 37.7146614305504 | -122.467022318922 | (37.7146614305504, -122.467022318922) | 9 | 8 | 6 | 64 | 24 | |||
| 29893 | 207491 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5992718.20945 | 2091059.61299 | 37.7212333442383 | -122.467254960962 | (37.7212333442383, -122.467254960962) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 30795 | 201990 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013571.20054 | 2092301.57484 | 37.7258252538048 | -122.395258547459 | (37.7258252538048, -122.395258547459) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||
| 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 | ||||
| 31755 | 222519 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 793 27th St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6001410.30359 | 2099959.16929 | 37.7461674068134 | -122.437846031097 | (37.7461674068134, -122.437846031097) | 2 | 7 | 5 | 63 | 22 | ||||
| 32854 | 223321 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 6 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6003607.59341 | 2104210.23604 | 37.7579645380528 | -122.430551361954 | (37.7579645380528, -122.430551361954) | 2 | 4 | 5 | 28862 | 3 | |||
| 33316 | 223332 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004952.54883 | 2097554.13127 | 37.7397645108307 | -122.425426258725 | (37.7397645108307, -122.425426258725) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | |||
| 36913 | 223293 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 101X Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998863.8718 | 2107567.85033 | 37.7669138338245 | -122.447198734836 | (37.7669138338245, -122.447198734836) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 38122 | 123037 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 598 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991936.90153 | 2111420.91872 | 37.7770950911291 | -122.471438573307 | (37.7770950911291, -122.471438573307) | 11 | 6 | 2 | 54 | 11 | |||
| 38228 | 207499 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2225 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993421.6511 | 2100648.01596 | 37.7476013002716 | -122.465519594971 | (37.7476013002716, -122.465519594971) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 39000 | 207522 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 654 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5997754.94762 | 2095022.4325 | 37.7324037829132 | -122.45012996444 | (37.7324037829132, -122.45012996444) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 39010 | 223338 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 17 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.7361200361187 | -122.433668499417 | (37.7361200361187, -122.433668499417) | 2 | 7 | 5 | 63 | 7 | |||
| 39165 | 34706 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 640 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38363 | 5981668.46483 | 2111340.0522 | 37.776273682439 | -122.506953696253 | (37.776273682439, -122.506953696253) | 11 | 6 | 2 | 55 | 26 | |
| 39485 | 222522 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 791 27th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 5ft | 6001439.60059 | 2099957.7516 | 37.7461651800752 | -122.437744624439 | (37.7461651800752, -122.437744624439) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 42588 | 176183 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5998729.89326 | 2090676.55478 | 37.7205267594696 | -122.446446824275 | (37.7205267594696, -122.446446824275) | 9 | 7 | 6 | 28861 | 25 | |||
| 42757 | 223285 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 12 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 8ft | 6002000.46161 | 2099247.70726 | 37.7442474405741 | -122.435754448124 | (37.7442474405741, -122.435754448124) | 2 | 7 | 5 | 63 | 22 | |||
| 42858 | 222527 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1400 Diamond St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 1ft | 6001954.88942 | 2099981.23883 | 37.7462589568792 | -122.435964503686 | (37.7462589568792, -122.435964503686) | 2 | 7 | 5 | 63 | 22 | |||
| 43034 | 207457 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 409 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998694.02737 | 2094363.85027 | 37.7306491651155 | -122.446835986997 | (37.7306491651155, -122.446835986997) | 9 | 7 | 4 | 28861 | 40 | |||
| 43242 | 176190 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5998918.88698 | 2090579.95992 | 37.7202723250901 | -122.44578659238 | (37.7202723250901, -122.44578659238) | 9 | 7 | 6 | 28861 | 25 | |||
| 43568 | 207525 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 98 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5999467.57051 | 2093538.93345 | 37.7284282965071 | -122.444102487738 | (37.7284282965071, -122.444102487738) | 9 | 7 | 4 | 63 | 40 | ||||
| 44018 | 223322 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 7 | : Yard | Tree | Private 2 | 6 | Width 3ft | 6003609.4958 | 2104203.70513 | 37.7579467134987 | -122.430544316686 | (37.7579467134987, -122.430544316686) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | ||||
| 44593 | 222513 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1445 Douglass St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6001419.9831 | 2099436.11309 | 37.7447317686527 | -122.43777510514 | (37.7447317686527, -122.43777510514) | 2 | 7 | 5 | 63 | 22 | |||
| 45171 | 223904 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1000 Dolores St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005052.50435 | 2102441.86115 | 37.7531907423722 | -122.425428400012 | (37.7531907423722, -122.425428400012) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||
| 46572 | 222510 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 123 Marsily St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6004279.53355 | 2095213.58651 | 37.7332998565836 | -122.427586552585 | (37.7332998565836, -122.427586552585) | 9 | 7 | 5 | 28861 | 25 | |||
| 46710 | 207439 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 306 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993339.70707 | 2104624.44622 | 37.7585148278031 | -122.466091864152 | (37.7585148278031, -122.466091864152) | 1 | 8 | 4 | 56 | 12 | |||
| 47058 | 176184 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998735.57322 | 2090674.42462 | 37.72052123496 | -122.446427037372 | (37.72052123496, -122.446427037372) | 9 | 7 | 6 | 28861 | 25 | |||
| 47776 | 176189 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998893.49045 | 2090593.19981 | 37.7203072286757 | -122.445875331189 | (37.7203072286757, -122.445875331189) | 9 | 7 | 6 | 28861 | 25 | |||
| 47903 | 207436 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5991562.0984 | 2104952.11788 | 37.759311812397 | -122.472263459012 | (37.759311812397, -122.472263459012) | 1 | 8 | 4 | 56 | 12 | ||||
| 48083 | 207440 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 337 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993165.92576 | 2104561.2758 | 37.7583313508388 | -122.466688281042 | (37.7583313508388, -122.466688281042) | 1 | 8 | 4 | 56 | 12 | |||
| 48584 | 223327 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002483.76265 | 2096988.16335 | 37.738070698907 | -122.433921821343 | (37.738070698907, -122.433921821343) | 2 | 7 | 5 | 63 | 7 | |||
| 48722 | 223886 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005095.80391 | 2103679.27098 | 37.7565908272116 | -122.425366711909 | (37.7565908272116, -122.425366711909) | 2 | 4 | 5 | 28859 | 19 | |||
| 49528 | 207479 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5999342.51032 | 2094053.30224 | 37.729833498015 | -122.444571779181 | (37.729833498015, -122.444571779181) | 9 | 7 | 4 | 28861 | 40 | ||||
| 49830 | 207482 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999342.84979 | 2094046.1167 | 37.7298137875714 | -122.444570089359 | (37.7298137875714, -122.444570089359) | 9 | 7 | 4 | 28861 | 40 | ||||
| 49977 | 222516 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001372.11196 | 2100107.80211 | 37.7465733454859 | -122.437988737291 | (37.7465733454859, -122.437988737291) | 2 | 4 | 5 | 63 | 22 | |||
| 50046 | 176198 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5998989.57955 | 2090542.36769 | 37.720173141569 | -122.445539530639 | (37.720173141569, -122.445539530639) | 9 | 7 | 6 | 28861 | 25 | |||
| 51282 | 223287 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1847 Castro St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 6002650.76741 | 2100087.28429 | 37.7465896403098 | -122.433565822025 | (37.7465896403098, -122.433565822025) | 2 | 7 | 5 | 63 | 22 | ||||
| 51942 | 176186 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 500 Geneva Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5998840.97625 | 2090619.30769 | 37.7203759162079 | -122.446058731719 | (37.7203759162079, -122.446058731719) | 9 | 7 | 6 | 28861 | 25 | |||
| 52708 | 223317 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 4004 20th St | 2 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003628.73131 | 2104227.65103 | 37.7580135529078 | -122.430479500748 | (37.7580135529078, -122.430479500748) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 54031 | 222531 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1626 Diamond St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 8ft | 6002000.69845 | 2099269.94267 | 37.7443085072419 | -122.435755219736 | (37.7443085072419, -122.435755219736) | 2 | 7 | 5 | 63 | 22 | |||
| 54103 | 42743 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 295 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42737 | 6012647.1314 | 2087116.87515 | 37.7115376741026 | -122.398089440585 | (37.7115376741026, -122.398089440585) | 10 | 3 | 8 | 309 | 1 | ||
| 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 |
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) );