Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3721 | 3721 | 36883 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2515 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002662.87522 | 2116961.2420799998 | 37.792922065545504 | -122.43473038919501 | (37.7929220655455, -122.434730389195) | ||
| 3779 | 3779 | 61682 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 27 Ceres St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 4 | Permit Number 21679 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 19658 | 19658 | 103913 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 20296 | 20296 | 103912 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 23388 | 23388 | 191040 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6015380.38588 | 2102504.53618 | 37.75394094514021 | -122.389716581452 | (37.7539409451402, -122.389716581452) | ||||
| 23823 | 23823 | 42743 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 295 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42737 | 6012647.1314 | 2087116.87515 | 37.7115376741026 | -122.398089440585 | (37.7115376741026, -122.398089440585) | ||
| 25505 | 25505 | 37639 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 574 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40056 | 5993171.91156 | 2111565.06758 | 37.7775622521226 | -122.467176805707 | (37.7775622521226, -122.467176805707) | |
| 25878 | 25878 | 207430 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991564.83032 | 2104929.84825 | 37.759250823982605 | -122.47225238743601 | (37.7592508239826, -122.472252387436) | ||||
| 26369 | 26369 | 201988 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013586.6338 | 2092298.57883 | 37.7258178856713 | -122.39520498563 | (37.7258178856713, -122.39520498563) | ||||
| 26383 | 26383 | 207515 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 71 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999632.40668 | 2095469.97761 | 37.7337398948819 | -122.443671310503 | (37.7337398948819, -122.443671310503) | ||||
| 28382 | 28382 | 207524 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 266 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998309.1596 | 2093573.15338 | 37.728456103557896 | -122.448109616788 | (37.7284561035579, -122.448109616788) | ||||
| 30038 | 30038 | 207511 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999356.36789 | 2095270.9974099998 | 37.733177794305 | -122.44461135834601 | (37.733177794305, -122.444611358346) | ||||
| 31908 | 31908 | 207496 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 426 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5993791.26805 | 2090028.04623 | 37.7184627965046 | -122.46347090877899 | (37.7184627965046, -122.463470908779) | ||||
| 34784 | 34784 | 207435 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991562.287830001 | 2104945.46167 | 37.759293547166 | -122.472262318665 | (37.759293547166, -122.472262318665) | ||||
| 36240 | 36240 | 50010 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1465@ 26th ST Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 7 | Permit Number 46741 | 6012041.28455 | 2101546.95627 | 37.7511259142534 | -122.401196767325 | (37.7511259142534, -122.401196767325) | |
| 36954 | 36954 | 56424 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 279 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2011 12:00:00 AM | 4 | Permit Number 767957 | 5990232.5043 | 2113517.65935 | 37.7827534137466 | -122.477487840106 | (37.7827534137466, -122.477487840106) | ||
| 37206 | 37206 | 64452 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2255 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 6 | Permit Number 49675 | 6010720.79087 | 2105970.79652 | 37.763199036616996 | -122.40607482140499 | (37.763199036617, -122.406074821405) | |
| 38347 | 38347 | 103902 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 41726 | 41726 | 247864 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 399 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009555.15097 | 2098432.68764 | 37.742435806664794 | -122.409574335293 | (37.7424358066648, -122.409574335293) | ||||
| 42194 | 42194 | 207483 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999342.799240001 | 2094043.6842 | 37.729807105610206 | -122.444570089355 | (37.7298071056102, -122.444570089355) | ||||
| 44388 | 44388 | 247962 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 14 Joy St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6010359.95763 | 2098907.35395 | 37.7437842015861 | -122.40682498730699 | (37.7437842015861, -122.406824987307) | ||||
| 45589 | 45589 | 191045 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 900x Carolina St | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012497.15794 | 2103097.51934 | 37.755408845542895 | -122.399729160991 | (37.7554088455429, -122.399729160991) | ||||
| 51848 | 51848 | 191050 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1980 Revere Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6013083.07129 | 2095907.7948099999 | 37.7357000338279 | -122.39719874844201 | (37.7357000338279, -122.397198748442) | ||||
| 54391 | 54391 | 207512 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999349.275230001 | 2095271.40684 | 37.733178513774796 | -122.44463590891701 | (37.7331785137748, -122.444635908917) | ||||
| 54894 | 54894 | 69414 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 77 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 8 | Permit Number 33519 | 6001938.39138 | 2087385.6198099998 | 37.711673318833796 | -122.435120827182 | (37.7116733188338, -122.435120827182) | |
| 55207 | 55207 | 207432 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5991562.70907 | 2104938.76193 | 37.7592751758288 | -122.47226037344299 | (37.7592751758288, -122.472260373443) | ||||
| 55215 | 55215 | 207480 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999342.45977 | 2094050.8697400002 | 37.729826816053794 | -122.444571779177 | (37.7298268160538, -122.444571779177) | ||||
| 55413 | 55413 | 76397 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 701 Amador St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1999 12:00:00 AM | 5 | 6016633.05444 | 2099489.61531 | 37.7457319802501 | -122.38517445926 | (37.7457319802501, -122.38517445926) | ||
| 55553 | 55553 | 201990 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013571.200540001 | 2092301.5748400001 | 37.7258252538048 | -122.395258547459 | (37.7258252538048, -122.395258547459) | ||||
| 56735 | 56735 | 207486 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 112 Marston Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998687.36534 | 2093224.2464299998 | 37.7275196997744 | -122.44677705081499 | (37.7275196997744, -122.446777050815) | ||||
| 59100 | 59100 | 207479 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999342.510319999 | 2094053.30224 | 37.729833498015 | -122.444571779181 | (37.729833498015, -122.444571779181) | ||||
| 59840 | 59840 | 207507 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 131 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6000533.96633 | 2095190.65838 | 37.7330243285976 | -122.44053433311501 | (37.7330243285976, -122.440534333115) | ||||
| 60278 | 60278 | 176208 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6000504.57511 | 2093791.5155099998 | 37.729180932853296 | -122.44053562992701 | (37.7291809328533, -122.440535629927) | ||||
| 62894 | 62894 | 50307 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 755 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 6 | Permit Number 47018 | 6012755.49383 | 2104002.55412 | 37.7579082710796 | -122.398899267499 | (37.7579082710796, -122.398899267499) | ||
| 63235 | 63235 | 191038 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015383.3127 | 2102378.63663 | 37.7535954139151 | -122.38969766693 | (37.7535954139151, -122.38969766693) | ||||
| 63255 | 63255 | 191046 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 900x Carolina St | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6012503.19406 | 2103068.83729 | 37.7553304273806 | -122.399706272322 | (37.7553304273806, -122.399706272322) | ||||
| 64439 | 64439 | 67487 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1715 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 3 | Permit Number 31011 | 6012862.87074 | 2104700.41126 | 37.759830416353296 | -122.398576880337 | (37.7598304163533, -122.398576880337) | |
| 64506 | 64506 | 76360 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 701 Amador St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1999 12:00:00 AM | 6 | 6016677.697430001 | 2099491.25427 | 37.7457389499883 | -122.38502020301901 | (37.7457389499883, -122.385020203019) | ||
| 68970 | 68970 | 31151 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 666 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34854 | 5997015.55395 | 2094425.7402599999 | 37.7307230695921 | -122.45264315945299 | (37.7307230695921, -122.452643159453) | |
| 69833 | 69833 | 207431 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5991561.23107 | 2104931.23818 | 37.7592544320617 | -122.472264936581 | (37.7592544320617, -122.472264936581) | ||||
| 71939 | 71939 | 223885 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1201 San Jose Ave | 53 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004491.44373 | 2096094.2643900001 | 37.7357299839367 | -122.42691662060601 | (37.7357299839367, -122.426916620606) | ||||
| 72322 | 72322 | 31150 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 666 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34854 | 5996999.96036 | 2094426.5225799999 | 37.730724324156704 | -122.452697125077 | (37.7307243241567, -122.452697125077) | |
| 73235 | 73235 | 191044 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 801 19th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6015135.407930001 | 2105291.0534099997 | 37.761578537441395 | -122.390758499125 | (37.7615785374414, -122.390758499125) | ||||
| 73507 | 73507 | 207506 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 155 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000387.096390001 | 2095198.9294 | 37.7330386745754 | -122.44104269288401 | (37.7330386745754, -122.441042692884) | ||||
| 74228 | 74228 | 207484 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 117 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999294.91677 | 2093456.39313 | 37.728191808994495 | -122.444693427765 | (37.7281918089945, -122.444693427765) | ||||
| 77357 | 77357 | 111267 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700X BOSWORTH ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 86086 | 86086 | 103907 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 87677 | 87677 | 111277 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700X BOSWORTH ST | 15 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 94145 | 94145 | 103911 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 100077 | 100077 | 103909 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 107558 | 107558 | 103901 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 109731 | 109731 | 103908 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 118191 | 118191 | 103906 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 120276 | 120276 | 103903 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 120437 | 120437 | 191051 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1998 Revere Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013034.574440001 | 2095940.33474 | 37.735786681697796 | -122.397368703228 | (37.7357866816978, -122.397368703228) | ||||
| 121082 | 121082 | 223287 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1847 Castro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6002650.76741 | 2100087.2842900003 | 37.74658964030979 | -122.43356582202499 | (37.7465896403098, -122.433565822025) | ||||
| 122458 | 122458 | 72275 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 745 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 5 | 5983802.0 | 2110725.0 | 37.7747103425962 | -122.499527862048 | (37.7747103425962, -122.499527862048) | ||
| 123434 | 123434 | 457 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 760x 23rd Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/31/2002 12:00:00 AM | 3 | 5988833.54517 | 2109972.18567 | 37.7729372568337 | -122.482067772117 | (37.7729372568337, -122.482067772117) | |||
| 124611 | 124611 | 103905 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 128312 | 128312 | 103900 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 130638 | 130638 | 222519 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6001410.303590001 | 2099959.16929 | 37.7461674068134 | -122.437846031097 | (37.7461674068134, -122.437846031097) | ||||
| 131092 | 131092 | 207434 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5991566.656769999 | 2104946.06953 | 37.759295469034704 | -122.47224725320801 | (37.7592954690347, -122.472247253208) | ||||
| 132267 | 132267 | 38192 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 715 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 6 | Permit Number 40321 | 6011331.34824 | 2091527.76082 | 37.72357569684971 | -122.40294719786002 | (37.7235756968497, -122.40294719786) | |
| 134434 | 134434 | 70478 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 64 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 10 | 6005133.6380900005 | 2092919.2307799999 | 37.7270483380922 | -122.42447053479799 | (37.7270483380922, -122.424470534798) | ||
| 135093 | 135093 | 222518 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 6001409.25224 | 2099957.5688 | 37.746162952463 | -122.43784955191201 | (37.746162952463, -122.437849551912) | ||||
| 136760 | 136760 | 207514 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 747 Detroit St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5999418.54493 | 2095450.46717 | 37.7336741238608 | -122.444409289657 | (37.7336741238608, -122.444409289657) | ||||
| 136862 | 136862 | 207482 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999342.84979 | 2094046.1167 | 37.729813787571395 | -122.444570089359 | (37.7298137875714, -122.444570089359) | ||||
| 137134 | 137134 | 207510 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999358.72288 | 2095270.42475 | 37.733176356297 | -122.44460317539301 | (37.733176356297, -122.444603175393) | ||||
| 138857 | 138857 | 103904 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 144807 | 144807 | 103910 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 151056 | 151056 | 41175 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2435 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 4 | Permit Number 41894 | 5999108.60374 | 2120208.9624099997 | 37.801637012407106 | -122.44726215142799 | (37.8016370124071, -122.447262151428) | |
| 151825 | 151825 | 247963 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 14 Joy St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6010355.2725599995 | 2098907.44942 | 37.7437842015769 | -122.406841193976 | (37.7437842015769, -122.406841193976) | ||||
| 152372 | 152372 | 187583 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 747 University St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6008740.19071 | 2090749.62669 | 37.721294072735795 | -122.411849445609 | (37.7212940727358, -122.411849445609) | ||||
| 153031 | 153031 | 207437 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5991566.59817 | 2104953.6030599996 | 37.75931615072629 | -122.472248005034 | (37.7593161507263, -122.472248005034) | ||||
| 153343 | 153343 | 201989 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6013578.50346 | 2092296.28411 | 37.725811132676704 | -122.395232931161 | (37.7258111326767, -122.395232931161) | ||||
| 154279 | 154279 | 207509 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999366.08904 | 2095270.5336900002 | 37.7331770757488 | -122.444577716507 | (37.7331770757488, -122.444577716507) | ||||
| 154439 | 154439 | 76341 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 701 Amador St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1999 12:00:00 AM | 4 | 6016694.6962 | 2099491.47617 | 37.7457404995381 | -122.38496143864599 | (37.7457404995381, -122.384961438646) | ||
| 154831 | 154831 | 207505 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 404 Baden St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6000763.5114400005 | 2095280.18835 | 37.7332832254367 | -122.439747153813 | (37.7332832254367, -122.439747153813) | ||||
| 155813 | 155813 | 207481 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999342.64859 | 2094048.18923 | 37.7298194667739 | -122.44457093382799 | (37.7298194667739, -122.444570933828) | ||||
| 157311 | 157311 | 247865 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 400 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009511.40819 | 2098411.1338400003 | 37.742374173428004 | -122.40972406433201 | (37.742374173428, -122.409724064332) | ||||
| 158480 | 158480 | 207525 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 98 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999467.57051 | 2093538.93345 | 37.728428296507104 | -122.444102487738 | (37.7284282965071, -122.444102487738) | ||||
| 165061 | 165061 | 191039 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015379.43369 | 2102383.15198 | 37.7536075970141 | -122.38971139686599 | (37.7536075970141, -122.389711396866) | ||||
| 165427 | 165427 | 34706 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 640 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38363 | 5981668.46483 | 2111340.0522 | 37.776273682439 | -122.50695369625299 | (37.776273682439, -122.506953696253) | |
| 165592 | 165592 | 187592 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010726.84858 | 2091332.925 | 37.723006943986896 | -122.405023145203 | (37.7230069439869, -122.405023145203) | ||||
| 165634 | 165634 | 187593 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010735.28382 | 2091330.7832 | 37.7230015345836 | -122.40499383541001 | (37.7230015345836, -122.40499383541) | ||||
| 166758 | 166758 | 51342 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2121 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2004 12:00:00 AM | 4 | Permit Number 47688 | 6004025.96964 | 2116952.58925 | 37.7929755986043 | -122.430013396525 | (37.7929755986043, -122.430013396525) | ||
| 168500 | 168500 | 191043 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6015378.95321 | 2102517.9125200002 | 37.7539775942935 | -122.38972247021799 | (37.7539775942935, -122.389722470218) | ||||
| 169299 | 169299 | 191042 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6015379.59979 | 2102513.14016 | 37.7539645262576 | -122.38971990086701 | (37.7539645262576, -122.389719900867) | ||||
| 173871 | 173871 | 35481 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1011 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 9 | Permit Number 38892 | 6007771.76175 | 2093386.17164 | 37.7284790839175 | -122.415383596892 | (37.7284790839175, -122.415383596892) | ||
| 173925 | 173925 | 176210 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6000484.20754 | 2093783.71625 | 37.729158358072 | -122.440605482959 | (37.729158358072, -122.440605482959) | ||||
| 175038 | 175038 | 207458 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 458 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998364.99374 | 2094412.73568 | 37.7307645903989 | -122.44797701984899 | (37.7307645903989, -122.447977019849) | ||||
| 176159 | 176159 | 207433 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5991566.33601 | 2104938.68548 | 37.7592751758208 | -122.472247824277 | (37.7592751758208, -122.472247824277) | ||||
| 176356 | 176356 | 207436 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1550 15th Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5991562.0984 | 2104952.11788 | 37.759311812397 | -122.472263459012 | (37.759311812397, -122.472263459012) | ||||
| 177674 | 177674 | 176209 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000493.40055 | 2093786.9872599998 | 37.729167863003504 | -122.440573936562 | (37.7291678630035, -122.440573936562) | ||||
| 180012 | 180012 | 207508 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999372.65026 | 2095269.8732900003 | 37.7331756368378 | -122.44455498523001 | (37.7331756368378, -122.44455498523) | ||||
| 180794 | 180794 | 191041 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6015379.6035400005 | 2102508.57435 | 37.7539519897179 | -122.38971956902 | (37.7539519897179, -122.38971956902) | ||||
| 183211 | 183211 | 222520 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6001413.31101 | 2099956.87619 | 37.7461612815178 | -122.437835467626 | (37.7461612815178, -122.437835467626) | ||||
| 184394 | 184394 | 31994 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 115 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 4 | Permit Number 35395 | 5993939.00756 | 2114733.42644 | 37.786305958853895 | -122.464753322645 | (37.7863059588539, -122.464753322645) | |
| 185014 | 185014 | 207488 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 36 Harold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5996823.38616 | 2090394.7857400002 | 37.7196440101375 | -122.45301664789801 | (37.7196440101375, -122.453016647898) | ||||
| 185995 | 185995 | 207504 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 61 Burnside Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6001193.27416 | 2095765.4721 | 37.734640154910295 | -122.43829610308399 | (37.7346401549103, -122.438296103084) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");