trees
368 rows where qSpecies_id = 144 sorted by Neighborhoods (old)
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | |||
112229 | 201986 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013604.03863 | 2092295.50097 | 37.7258104024118 | -122.395144602456 | (37.7258104024118, -122.395144602456) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | ||||
152816 | 201969 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6013782.62401 | 2092181.31295 | 37.7255067948939 | -122.394519248986 | (37.7255067948939, -122.394519248986) | 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 | |||
164179 | 201985 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013611.24152 | 2092292.43846 | 37.7258023939381 | -122.395119487989 | (37.7258023939381, -122.395119487989) | 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 | |||
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 | ||||
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 | |||
177262 | 38549 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1843 Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | 3x3 | Permit Number 40519 | 6015893.6443 | 2093219.8325 | 37.7284754960653 | -122.387293979367 | (37.7284754960653, -122.387293979367) | 10 | 3 | 8 | 58 | 1 |
182684 | 201981 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 6013639.52945 | 2092282.86186 | 37.7257776715983 | -122.395021027505 | (37.7257776715983, -122.395021027505) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
193469 | 201987 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1651 Carroll Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013596.70102 | 2092297.48635 | 37.7258154458067 | -122.395170107233 | (37.7258154458067, -122.395170107233) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
77499 | 122933 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 184 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5992764.59544 | 2114230.49713 | 37.7848572746711 | -122.468779840358 | (37.7848572746711, -122.468779840358) | 11 | 6 | 2 | 54 | 11 | |||
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 | |
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 | |
178745 | 122932 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 184 10th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5992762.84609 | 2114244.11852 | 37.7848945742073 | -122.468786884025 | (37.7848945742073, -122.468786884025) | 11 | 6 | 2 | 54 | 11 | |||
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 | ||||
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 | |||
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 | |||
57488 | 207427 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1466 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991507.09847 | 2105443.15069 | 37.7606568753312 | -122.472489472137 | (37.7606568753312, -122.472489472137) | 1 | 8 | 4 | 56 | 12 | |||
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 | ||||
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 | |||
112491 | 207429 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1459 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5992094.23397 | 2105504.39511 | 37.7608590024631 | -122.470463314831 | (37.7608590024631, -122.470463314831) | 1 | 8 | 4 | 56 | 12 | |||
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 | ||||
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 | |||
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 | ||||
188959 | 207428 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5991814.94231 | 2105825.1395 | 37.7617235288256 | -122.471452623948 | (37.7617235288256, -122.471452623948) | 1 | 8 | 4 | 56 | 12 | |||
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 | ||||
55523 | 124159 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 970 Anza St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5995776.57441 | 2112223.28537 | 37.7795195518878 | -122.458214112906 | (37.7795195518878, -122.458214112906) | 11 | 6 | 2 | 54 | 16 | |||
139628 | 124158 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 970 Anza St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5995788.03534 | 2112225.31952 | 37.7795257956775 | -122.458174612179 | (37.7795257956775, -122.458174612179) | 11 | 6 | 2 | 54 | 16 | |||
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 | |||
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 | ||||
110115 | 126464 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2219 Chestnut St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 1ft | 6001195.64946 | 2119661.17014 | 37.8002519521333 | -122.440000735651 | (37.8002519521333, -122.440000735651) | 13 | 9 | 1 | 57 | 17 | |||
114617 | 126466 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1454 Jefferson St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6002229.50712 | 2121606.26883 | 37.8056514799082 | -122.436562488975 | (37.8056514799082, -122.436562488975) | 13 | 9 | 1 | 57 | 17 | |||
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 | |
177385 | 126463 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 845 Marina Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5998902.34401 | 2121345.9026 | 37.8047469543639 | -122.448057809532 | (37.8047469543639, -122.448057809532) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
61632 | 191037 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2255 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010742.72974 | 2105979.64591 | 37.7632245620984 | -122.405999565232 | (37.7632245620984, -122.405999565232) | 8 | 4 | 8 | 28859 | 19 | |||
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 | |||
89225 | 223887 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005112.75604 | 2103680.27946 | 37.7565945540051 | -122.42530815707 | (37.7565945540051, -122.42530815707) | 2 | 4 | 5 | 28859 | 19 | |||
126098 | 223883 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005389.40986 | 2103549.44963 | 37.7562509518289 | -122.424342082823 | (37.7562509518289, -122.424342082823) | 2 | 4 | 5 | 28859 | 19 | |||
130089 | 191036 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 2255 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010727.3327 | 2105979.27336 | 37.7632226779992 | -122.4060527925 | (37.7632226779992, -122.4060527925) | 8 | 4 | 8 | 28859 | 19 | |||
130671 | 223918 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 885 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007588.79194 | 2104568.22054 | 37.7591722115349 | -122.416808017787 | (37.7591722115349, -122.416808017787) | 2 | 4 | 7 | 28859 | 19 | |||
160648 | 106692 | Undocumented 4 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | 6005110.7 | 2103657.1 | 37.7565307924788 | -122.425313618185 | (37.7565307924788, -122.425313618185) | 2 | 4 | 5 | 28859 | 19 | |||
176989 | 223881 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1504 Bryant St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009376.30557 | 2107741.27022 | 37.7679850594966 | -122.410850015515 | (37.7679850594966, -122.410850015515) | 8 | 4 | 7 | 28853 | 19 | |||
189432 | 223889 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 3487 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005159.43202 | 2103680.76581 | 37.7565985263084 | -122.425146769228 | (37.7565985263084, -122.425146769228) | 2 | 4 | 5 | 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 | |||
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 | |||
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 | |||
54506 | 223912 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 69 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007426.45015 | 2098992.55773 | 37.7438535743744 | -122.416974423853 | (37.7438535743744, -122.416974423853) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | ||||
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 | |||
96486 | 223914 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 588 Ogden Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6007781.00432 | 2096146.35103 | 37.7360584568237 | -122.415546984806 | (37.7360584568237, -122.415546984806) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
101311 | 223294 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 779 Andover St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007381.1978 | 2095205.15374 | 37.7334516540573 | -122.416862619235 | (37.7334516540573, -122.416862619235) | 2 | 7 | 7 | 28859 | 2 | |||
102769 | 223915 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 588 Ogden Ave | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6007768.9471 | 2096146.59786 | 37.7360584568223 | -122.415588689077 | (37.7360584568223, -122.415588689077) | 2 | 7 | 7 | 28859 | 2 | |||
112376 | 223296 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 383 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006096.41442 | 2097922.56825 | 37.7408407178299 | -122.421497409371 | (37.7408407178299, -122.421497409371) | 2 | 7 | 7 | 28859 | 2 | |||
112707 | 223890 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009196.08294 | 2099133.75469 | 37.7443406562118 | -122.410865393019 | (37.7443406562118, -122.410865393019) | 2 | 7 | 7 | 28859 | 2 | |||
136351 | 223917 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 213 Montcalm St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 6ft | 6009962.76785 | 2099649.19619 | 37.7457989059869 | -122.408250693314 | (37.7457989059869, -122.408250693314) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
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 | |||
160715 | 223892 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008958.71449 | 2099085.99444 | 37.7441962043945 | -122.411682792229 | (37.7441962043945, -122.411682792229) | 2 | 7 | 7 | 28859 | 2 | |||
164785 | 222511 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 190 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006121.17792 | 2096336.36399 | 37.7364867517461 | -122.421299173611 | (37.7364867517461, -122.421299173611) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );