trees

368 rows where qSpecies_id = 144 sorted by TreeID

✎ 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)
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
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
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
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
52981 103904 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 6025 03rd St 5 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675) 10 3 8 58 1
61560 103905 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 6025 03rd St 6 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675) 10 3 8 58 1
66250 103906 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 6025 03rd St 7 Sidewalk: Property side : Yard Tree Private 2   06/19/2013 12:00:00 AM     Permit Number 770276 6013653.2 2091451 37.7234943066524 -122.394915533675 (37.7234943066524, -122.394915533675) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
4110 117662 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 4739 Anza St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   5983913.56445 2111711.8528 37.7774265003929 -122.49921487984 (37.7774265003929, -122.49921487984) 11 6 2 55 26
91854 117663 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 4739 Anza St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5983899.75591 2111710.53343 37.7774220677076 -122.499262549855 (37.7774220677076, -122.499262549855) 11 6 2 55 26
66067 117664 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 4739 Anza St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5983878.87513 2111710.17251 37.7774198517188 -122.499334755526 (37.7774198517188, -122.499334755526) 11 6 2 55 26
38045 117665 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 4739 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   5983866.28213 2111708.82719 37.7774154190485 -122.499378218726 (37.7774154190485, -122.499378218726) 11 6 2 55 26
76982 117666 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 4739 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5983855.96869 2111709.85463 37.7774176350156 -122.499413971687 (37.7774176350156, -122.499413971687) 11 6 2 55 26
105597 117851 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 646 39th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5983837.59369 2111421.56466 37.7766249961892 -122.499456225728 (37.7766249961892, -122.499456225728) 11 6 2 55 26
174177 117901 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 745 39th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5983818.1839 2110710.73543 37.7746721257554 -122.49947082515 (37.7746721257554, -122.49947082515) 11 6 2 55 26
164936 121952 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 108 Lake St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   5990864.50946 2114720.39813 37.7860924526568 -122.475389233666 (37.7860924526568, -122.475389233666) 11 6 2 54 26
63985 122196 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 131 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991469.44063 2114555.28767 37.7856741515485 -122.473284307608 (37.7856741515485, -122.473284307608) 11 6 2 54 26
77335 122197 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 131 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991469.09784 2114541.60598 37.7856365655774 -122.473284495339 (37.7856365655774, -122.473284495339) 11 6 2 54 26
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
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
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
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
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
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
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
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
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
31339 126467 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 2711 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6001788.68499 2115988.81164 37.7902023547025 -122.437685450844 (37.7902023547025, -122.437685450844) 13 6 1 29490 27
95988 16054 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 215 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2000 12:00:00 AM 3 3X3   6000626.03277 2094620.45379 37.7314639212093 -122.440175160965 (37.7314639212093, -122.440175160965) 9 7 4 63 40
94233 176182 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 200 Rome St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5998635.4334 2088884.2911 37.7156002193629 -122.446644455673 (37.7156002193629, -122.446644455673) 9 7 6 28861 25
42588 176183 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   5998729.89326 2090676.55478 37.7205267594696 -122.446446824275 (37.7205267594696, -122.446446824275) 9 7 6 28861 25
47058 176184 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5998735.57322 2090674.42462 37.72052123496 -122.446427037372 (37.72052123496, -122.446427037372) 9 7 6 28861 25
75724 176185 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 6 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   5998832.19664 2090623.50383 37.7203869364761 -122.446089381522 (37.7203869364761, -122.446089381522) 9 7 6 28861 25
51942 176186 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 7 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   5998840.97625 2090619.30769 37.7203759162079 -122.446058731719 (37.7203759162079, -122.446058731719) 9 7 6 28861 25
92187 176187 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 8 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   5998858.23397 2090609.31611 37.7203494671212 -122.445998359353 (37.7203494671212, -122.445998359353) 9 7 6 28861 25
171728 176188 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 10 Sidewalk: Property side : Yard Tree Private 2     13 Width 5ft   5998880.86348 2090599.21284 37.7203230180654 -122.445919410554 (37.7203230180654, -122.445919410554) 9 7 6 28861 25
47776 176189 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 11 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   5998893.49045 2090593.19981 37.7203072286757 -122.445875331189 (37.7203072286757, -122.445875331189) 9 7 6 28861 25
43242 176190 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 13 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   5998918.88698 2090579.95992 37.7202723250901 -122.44578659238 (37.7202723250901, -122.44578659238) 9 7 6 28861 25
114177 176191 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 14 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   5998925.79803 2090576.33751 37.7202627733854 -122.445762442878 (37.7202627733854, -122.445762442878) 9 7 6 28861 25
107698 176192 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 15 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   5998935.8928 2090570.77641 37.7202480802556 -122.445727149009 (37.7202480802556, -122.445727149009) 9 7 6 28861 25
190741 176193 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 17 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   5998949.70909 2090563.26446 37.7202282430074 -122.445678850924 (37.7202282430074, -122.445678850924) 9 7 6 28861 25
40369 176194 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 18 Sidewalk: Property side : Yard Tree Private 2     14 Width 5ft   5998956.61434 2090559.37492 37.7202179574717 -122.445654702298 (37.7202179574717, -122.445654702298) 9 7 6 28861 25
29919 176195 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 19 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   5998964.86489 2090556.52221 37.7202105956346 -122.445625977963 (37.7202105956346, -122.445625977963) 9 7 6 28861 25
62605 176196 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 20 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   5998970.24187 2090551.75587 37.7201978153451 -122.445607049032 (37.7201978153451, -122.445607049032) 9 7 6 28861 25
107289 176197 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 21 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   5998975.73013 2090548.27475 37.7201885703242 -122.445587827823 (37.7201885703242, -122.445587827823) 9 7 6 28861 25
50046 176198 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 500 Geneva Ave 23 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   5998989.57955 2090542.36769 37.720173141569 -122.445539530639 (37.720173141569, -122.445539530639) 9 7 6 28861 25
80703 176199 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 800 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6011139.2917 2091015.07876 37.7221572510345 -122.403575053247 (37.7221572510345, -122.403575053247) 10 3 7 309 28
160476 176200 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 700 Goettingen St 1 Front Yard : Yard Tree Private 2     3 Width 0ft   6010755.27325 2091348.4361 37.7230511231959 -122.404925977947 (37.7230511231959, -122.404925977947) 10 3 7 309 28
98316 176201 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 746 Olmstead St 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 4ft   6009499.02915 2090599.59902 37.7209246708253 -122.409215763009 (37.7209246708253, -122.409215763009) 9 3 7 309 28
29343 176202 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 746 Olmstead St 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 4ft   6009489.79963 2090597.27291 37.7209177667302 -122.409247502765 (37.7209177667302, -122.409247502765) 9 3 7 309 28
107833 176203 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 746 Olmstead St 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6009481.93286 2090594.23315 37.7209089794419 -122.409274481543 (37.7209089794419, -122.409274481543) 9 3 7 309 28
127406 176204 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 538 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6001908.14836 2093650.44447 37.7288734078601 -122.435673278019 (37.7288734078601, -122.435673278019) 9 7 6 28861 25
14754 176205 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 538 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6001907.20593 2093652.13241 37.7288779890283 -122.435676656773 (37.7288779890283, -122.435676656773) 9 7 6 28861 25
174719 176206 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 538 Cayuga Ave 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6001905.56245 2093653.69597 37.7288821888572 -122.435682450208 (37.7288821888572, -122.435682450208) 9 7 6 28861 25
182158 176207 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 178 Cotter St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6001859.62036 2093660.3477 37.7288978433404 -122.435841750723 (37.7288978433404, -122.435841750723) 9 7 6 28861 25
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
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
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
150445 176211 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 223 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007229.58334 2092624.58551 37.7263574447365 -122.417203995595 (37.7263574447365, -122.417203995595) 9 3 7 309 28
62716 176212 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 643 Burrows St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009383.55707 2092917.45205 37.7272825386525 -122.409778442743 (37.7272825386525, -122.409778442743) 10 3 7 309 28
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
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
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
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
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
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
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
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
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
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
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
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
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
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
103322 191047 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 508 Missouri St 3 : Tree Private 2     5 Width 8ft   6013509.00195 2104632.60387 37.7596802080014 -122.396337460525 (37.7596802080014, -122.396337460525) 10 3 8 28856 29
153805 191048 DPW Maintained 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 508 Missouri St 4 : Tree Private 2     2 Width 8ft   6013509.22069 2104630.04045 37.7596731815818 -122.396336524335 (37.7596731815818, -122.396336524335) 10 3 8 28856 29
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
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
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
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
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
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
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
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
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
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
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
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
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

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