trees
368 rows where qSpecies_id = 144 sorted by PlotSize
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
54577 | 191045 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 900x Carolina St | 40 | Median : Yard | Tree | DPW 1 | 7 | 6012497.15794 | 2103097.51934 | 37.7554088455429 | -122.399729160991 | (37.7554088455429, -122.399729160991) | 10 | 3 | 8 | 28856 | 29 | ||||
57623 | 207431 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5991561.23107 | 2104931.23818 | 37.7592544320617 | -122.472264936581 | (37.7592544320617, -122.472264936581) | 1 | 8 | 4 | 56 | 12 | ||||
60417 | 191042 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 37 | Front Yard : Yard | Tree | Private 2 | 6 | 6015379.59979 | 2102513.14016 | 37.7539645262576 | -122.389719900867 | (37.7539645262576, -122.389719900867) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
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 | |||
68566 | 191038 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 17 | Front Yard : Yard | Tree | Private 2 | 7 | 6015383.3127 | 2102378.63663 | 37.7535954139151 | -122.38969766693 | (37.7535954139151, -122.38969766693) | 10 | 3 | 8 | 28856 | 29 | ||||
69906 | 67487 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1715 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 3 | Permit Number 31011 | 6012862.87074 | 2104700.41126 | 37.7598304163533 | -122.398576880337 | (37.7598304163533, -122.398576880337) | 10 | 3 | 8 | 28856 | 29 | |
70611 | 35481 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1011 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1998 12:00:00 AM | 9 | Permit Number 38892 | 6007771.76175 | 2093386.17164 | 37.7284790839175 | -122.415383596892 | (37.7284790839175, -122.415383596892) | 9 | 3 | 7 | 309 | 5 | ||
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 | ||||
72752 | 201988 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6013586.6338 | 2092298.57883 | 37.7258178856713 | -122.39520498563 | (37.7258178856713, -122.39520498563) | 10 | 3 | 8 | 58 | 1 | ||||
72823 | 111277 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700X BOSWORTH ST | 15 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
72876 | 187592 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700 Goettingen St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6010726.84858 | 2091332.925 | 37.7230069439869 | -122.405023145203 | (37.7230069439869, -122.405023145203) | 10 | 3 | 7 | 309 | 28 | ||||
75772 | 176209 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 328 Santa Rosa Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6000493.40055 | 2093786.98726 | 37.7291678630035 | -122.440573936562 | (37.7291678630035, -122.440573936562) | 9 | 7 | 6 | 28861 | 25 | ||||
77246 | 207483 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999342.79924 | 2094043.6842 | 37.7298071056102 | -122.444570089355 | (37.7298071056102, -122.444570089355) | 9 | 7 | 4 | 28861 | 40 | ||||
79281 | 38192 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 715 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 6 | Permit Number 40321 | 6011331.34824 | 2091527.76082 | 37.7235756968497 | -122.40294719786 | (37.7235756968497, -122.40294719786) | 10 | 3 | 7 | 309 | 28 | |
85296 | 207509 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999366.08904 | 2095270.53369 | 37.7331770757488 | -122.444577716507 | (37.7331770757488, -122.444577716507) | 9 | 7 | 4 | 59 | 40 | ||||
88044 | 191046 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 900x Carolina St | 44 | Median : Yard | Tree | DPW 1 | 6 | 6012503.19406 | 2103068.83729 | 37.7553304273806 | -122.399706272322 | (37.7553304273806, -122.399706272322) | 10 | 3 | 8 | 28856 | 29 | ||||
88105 | 222518 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 793 27th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | 6001409.25224 | 2099957.5688 | 37.746162952463 | -122.437849551912 | (37.746162952463, -122.437849551912) | 2 | 7 | 5 | 63 | 22 | ||||
91660 | 37639 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 574 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 6 | Permit Number 40056 | 5993171.91156 | 2111565.06758 | 37.7775622521226 | -122.467176805707 | (37.7775622521226, -122.467176805707) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
92980 | 50307 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 755 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 6 | Permit Number 47018 | 6012755.49383 | 2104002.55412 | 37.7579082710796 | -122.398899267499 | (37.7579082710796, -122.398899267499) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
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 | ||||
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 | |||
100112 | 223885 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1201 San Jose Ave | 53 | Front Yard : Yard | Tree | Private 2 | 4 | 6004491.44373 | 2096094.26439 | 37.7357299839367 | -122.426916620606 | (37.7357299839367, -122.426916620606) | 2 | 7 | 5 | 28861 | 2 | ||||
102655 | 207486 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 112 Marston Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998687.36534 | 2093224.24643 | 37.7275196997744 | -122.446777050815 | (37.7275196997744, -122.446777050815) | 9 | 7 | 4 | 28861 | 40 | ||||
108125 | 176208 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 328 Santa Rosa Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6000504.57511 | 2093791.51551 | 37.7291809328533 | -122.440535629927 | (37.7291809328533, -122.440535629927) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | ||||
119929 | 207504 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 61 Burnside Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6001193.27416 | 2095765.4721 | 37.7346401549103 | -122.438296103084 | (37.7346401549103, -122.438296103084) | 2 | 7 | 5 | 63 | 7 | ||||
122928 | 207514 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 747 Detroit St | 2 | Side Yard : Yard | Tree | Private 2 | 2 | 5999418.54493 | 2095450.46717 | 37.7336741238608 | -122.444409289657 | (37.7336741238608, -122.444409289657) | 9 | 7 | 4 | 59 | 40 | ||||
126598 | 45474 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1349 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 4 | Permit Number 44253 | 5999367.63833 | 2089888.0893 | 37.718398218877 | -122.444185721794 | (37.718398218877, -122.444185721794) | 9 | 7 | 6 | 28861 | 25 | |
127737 | 41175 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2435 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/1999 12:00:00 AM | 4 | Permit Number 41894 | 5999108.60374 | 2120208.96241 | 37.8016370124071 | -122.447262151428 | (37.8016370124071, -122.447262151428) | 13 | 9 | 1 | 57 | 17 | |
127869 | 207505 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 404 Baden St | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 6000763.51144 | 2095280.18835 | 37.7332832254367 | -122.439747153813 | (37.7332832254367, -122.439747153813) | 9 | 7 | 5 | 63 | 40 | ||||
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 | ||||
128276 | 207496 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 426 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5993791.26805 | 2090028.04623 | 37.7184627965046 | -122.463470908779 | (37.7184627965046, -122.463470908779) | 9 | 8 | 6 | 64 | 24 | ||||
131392 | 51342 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2121 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2004 12:00:00 AM | 4 | Permit Number 47688 | 6004025.96964 | 2116952.58925 | 37.7929755986043 | -122.430013396525 | (37.7929755986043, -122.430013396525) | 13 | 9 | 1 | 29490 | 27 | ||
133808 | 207484 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 117 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999294.91677 | 2093456.39313 | 37.7281918089945 | -122.444693427765 | (37.7281918089945, -122.444693427765) | 9 | 7 | 4 | 28861 | 40 | ||||
135120 | 207506 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 155 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000387.09639 | 2095198.9294 | 37.7330386745754 | -122.441042692884 | (37.7330386745754, -122.441042692884) | 9 | 7 | 5 | 63 | 40 | ||||
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 | ||||
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 | ||||
140444 | 191050 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1980 Revere Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6013083.07129 | 2095907.79481 | 37.7357000338279 | -122.397198748442 | (37.7357000338279, -122.397198748442) | 10 | 3 | 8 | 58 | 1 | ||||
141884 | 187593 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 700 Goettingen St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6010735.28382 | 2091330.7832 | 37.7230015345836 | -122.40499383541 | (37.7230015345836, -122.40499383541) | 10 | 3 | 7 | 309 | 28 | ||||
142855 | 207488 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 36 Harold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5996823.38616 | 2090394.78574 | 37.7196440101375 | -122.453016647898 | (37.7196440101375, -122.453016647898) | 9 | 8 | 6 | 28861 | 24 | ||||
142872 | 31994 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 115 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 4 | Permit Number 35395 | 5993939.00756 | 2114733.42644 | 37.7863059588539 | -122.464753322645 | (37.7863059588539, -122.464753322645) | 11 | 6 | 2 | 54 | 11 | |
144053 | 56424 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 279 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2011 12:00:00 AM | 4 | Permit Number 767957 | 5990232.5043 | 2113517.65935 | 37.7827534137466 | -122.477487840106 | (37.7827534137466, -122.477487840106) | 11 | 6 | 2 | 55 | 26 | ||
144109 | 50010 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1465@ 26th ST Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 7 | Permit Number 46741 | 6012041.28455 | 2101546.95627 | 37.7511259142534 | -122.401196767325 | (37.7511259142534, -122.401196767325) | 10 | 3 | 8 | 28856 | 29 | |
146687 | 201989 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013578.50346 | 2092296.28411 | 37.7258111326767 | -122.395232931161 | (37.7258111326767, -122.395232931161) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
149965 | 207458 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 458 Hearst Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998364.99374 | 2094412.73568 | 37.7307645903989 | -122.447977019849 | (37.7307645903989, -122.447977019849) | 9 | 7 | 4 | 59 | 40 | ||||
155978 | 191039 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1301 Minnesota St | 18 | Front Yard : Yard | Tree | Private 2 | 5 | 6015379.43369 | 2102383.15198 | 37.7536075970141 | -122.389711396866 | (37.7536075970141, -122.389711396866) | 10 | 3 | 8 | 28856 | 29 | ||||
157152 | 207508 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999372.65026 | 2095269.87329 | 37.7331756368378 | -122.44455498523 | (37.7331756368378, -122.44455498523) | 9 | 7 | 4 | 59 | 40 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
168761 | 187583 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 747 University St | 2 | Side Yard : Yard | Tree | Private 2 | 7 | 6008740.19071 | 2090749.62669 | 37.7212940727358 | -122.411849445609 | (37.7212940727358, -122.411849445609) | 9 | 3 | 7 | 309 | 28 | ||||
169414 | 191051 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1998 Revere Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6013034.57444 | 2095940.33474 | 37.7357866816978 | -122.397368703228 | (37.7357866816978, -122.397368703228) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
172338 | 207481 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999342.64859 | 2094048.18923 | 37.7298194667739 | -122.444570933828 | (37.7298194667739, -122.444570933828) | 9 | 7 | 4 | 28861 | 40 | ||||
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 | |||
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 | ||||
178265 | 222520 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 793 27th St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6001413.31101 | 2099956.87619 | 37.7461612815178 | -122.437835467626 | (37.7461612815178, -122.437835467626) | 2 | 7 | 5 | 63 | 22 | ||||
178836 | 207480 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 209 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5999342.45977 | 2094050.86974 | 37.7298268160538 | -122.444571779177 | (37.7298268160538, -122.444571779177) | 9 | 7 | 4 | 28861 | 40 | ||||
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 | ||||
185760 | 35816 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 448 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 5 | Permit Number 43043 | 6010644.99759 | 2092590.80492 | 37.7264562451386 | -122.405394631775 | (37.7264562451386, -122.405394631775) | 10 | 3 | 7 | 309 | 28 | |
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 | |||
191452 | 207507 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 131 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000533.96633 | 2095190.65838 | 37.7330243285976 | -122.440534333115 | (37.7330243285976, -122.440534333115) | 9 | 7 | 5 | 63 | 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 | ||||
192745 | 207432 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1550 15th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5991562.70907 | 2104938.76193 | 37.7592751758288 | -122.472260373443 | (37.7592751758288, -122.472260373443) | 1 | 8 | 4 | 56 | 12 |
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) );