trees
368 rows where qSpecies_id = 144 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
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 | |
29814 | 207495 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 218 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5992735.18915 | 2088665.77704 | 37.7146614305504 | -122.467022318922 | (37.7146614305504, -122.467022318922) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
115459 | 207490 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 13 Thrift St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996346.95254 | 2089599.2142 | 37.7174322417932 | -122.454606053924 | (37.7174322417932, -122.454606053924) | 9 | 8 | 6 | 28861 | 24 | |||
112189 | 207489 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 226 Thrift St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 6ft | 5994760.7353 | 2089660.35047 | 37.7175090007127 | -122.460093262 | (37.7175090007127, -122.460093262) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
20949 | 207494 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992718.62693 | 2091039.53667 | 37.7211782436554 | -122.467252058845 | (37.7211782436554, -122.467252058845) | 9 | 8 | 6 | 64 | 24 | |||
155100 | 207493 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992717.93715 | 2091043.75308 | 37.7211897810709 | -122.467254749618 | (37.7211897810709, -122.467254749618) | 9 | 8 | 6 | 64 | 24 | |||
9168 | 207492 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5992718.40075 | 2091048.73917 | 37.7212034984214 | -122.467253509457 | (37.7212034984214, -122.467253509457) | 9 | 8 | 6 | 64 | 24 | |||
29893 | 207491 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 589 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5992718.20945 | 2091059.61299 | 37.7212333442383 | -122.467254960962 | (37.7212333442383, -122.467254960962) | 9 | 8 | 6 | 64 | 24 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | |||
155043 | 207487 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 484 Faxon Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994797.52832 | 2091773.84909 | 37.7233142792092 | -122.46011911753 | (37.7233142792092, -122.46011911753) | 9 | 8 | 4 | 28861 | 24 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | ||||
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 | ||||
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 | ||||
90982 | 207497 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995861.97122 | 2092806.17827 | 37.7262099757024 | -122.456514177902 | (37.7262099757024, -122.456514177902) | 9 | 7 | 4 | 28861 | 40 | |||
185219 | 207498 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995864.99772 | 2092813.12874 | 37.7262292337867 | -122.456504217911 | (37.7262292337867, -122.456504217911) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | ||||
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 | ||||
55014 | 207485 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 115 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5999342.30815 | 2093460.30056 | 37.7282052421686 | -122.444529875249 | (37.7282052421686, -122.444529875249) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||||
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 | ||||
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 |
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 | ||
28292 | 207450 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 520 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5996939.36617 | 2093634.85846 | 37.7285471311368 | -122.452849488219 | (37.7285471311368, -122.452849488219) | 9 | 7 | 4 | 28861 | 40 | |||
103007 | 207445 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994317.99715 | 2093727.15721 | 37.7286499965007 | -122.461918327265 | (37.7286499965007, -122.461918327265) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
164779 | 207471 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.11204 | 2094076.47997 | 37.7297711057327 | -122.452194268254 | (37.7297711057327, -122.452194268254) | 9 | 7 | 4 | 28861 | 40 | |||
63466 | 207478 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.33701 | 2094077.03588 | 37.7297740771139 | -122.452107103267 | (37.7297740771139, -122.452107103267) | 9 | 7 | 4 | 28861 | 40 | |||
177391 | 207470 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.5742 | 2094079.0064 | 37.7297780691825 | -122.452192852745 | (37.7297780691825, -122.452192852745) | 9 | 7 | 4 | 28861 | 40 | |||
175816 | 207477 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.54471 | 2094079.1487 | 37.729779890312 | -122.45210653761 | (37.729779890312, -122.45210653761) | 9 | 7 | 4 | 28861 | 40 | |||
125531 | 207469 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.98786 | 2094080.77856 | 37.7297829588082 | -122.452191550501 | (37.7297829588082, -122.452191550501) | 9 | 7 | 4 | 28861 | 40 | |||
107747 | 207476 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.49703 | 2094080.77851 | 37.7297843626508 | -122.452106819991 | (37.7297843626508, -122.452106819991) | 9 | 7 | 4 | 28861 | 40 | |||
129969 | 207468 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.68437 | 2094082.566 | 37.7297878493071 | -122.452192728615 | (37.7297878493071, -122.452192728615) | 9 | 7 | 4 | 28861 | 40 | |||
63641 | 207475 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.82346 | 2094082.98352 | 37.7297904357818 | -122.452105850522 | (37.7297904357818, -122.452105850522) | 9 | 7 | 4 | 28861 | 40 | |||
139847 | 207467 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.67547 | 2094084.42133 | 37.7297929430915 | -122.452192893201 | (37.7297929430915, -122.452192893201) | 9 | 7 | 4 | 28861 | 40 | |||
35029 | 207474 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.27619 | 2094085.18087 | 37.7297964378325 | -122.452107900965 | (37.7297964378325, -122.452107900965) | 9 | 7 | 4 | 28861 | 40 | |||
186703 | 207466 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.05021 | 2094086.70842 | 37.7297991870776 | -122.452195219742 | (37.7297991870776, -122.452195219742) | 9 | 7 | 4 | 28861 | 40 | |||
13497 | 207473 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.92167 | 2094087.86561 | 37.7298038464638 | -122.45210586311 | (37.7298038464638, -122.45210586311) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||||
159565 | 207465 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 555 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997138.25418 | 2094089.75184 | 37.7298075552683 | -122.452194734107 | (37.7298075552683, -122.452194734107) | 9 | 7 | 4 | 28861 | 40 | |||
133189 | 207472 | DPW Maintained 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 144 | 549 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997163.97203 | 2094090.10487 | 37.7298099978231 | -122.452105850512 | (37.7298099978231, -122.452105850512) | 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 |
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) );