trees

368 rows where qSpecies_id = 144 sorted by Neighborhoods (old)

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);