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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 94561 | 94561 | 5564 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1004 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x20 | 6005043.313071599 | 2102494.5958208 | 37.753335020194996 | -122.425463937964 | (37.753335020195, -122.425463937964) | |||
| 21889 | 21889 | 16054 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 215 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2000 12:00:00 AM | 3 | 3X3 | 6000626.0327699995 | 2094620.4537900002 | 37.7314639212093 | -122.440175160965 | (37.7314639212093, -122.440175160965) | ||
| 88509 | 88509 | 23596 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 200X Vasquez Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 40 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 21036 | 21036 | 26938 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 6005048.24826 | 2102491.89317 | 37.753327878185395 | -122.42544667872299 | (37.7533278781854, -122.425446678723) | |||
| 20756 | 20756 | 26940 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3 | 6005048.82283 | 2102481.7377299997 | 37.7533000261745 | -122.425443969077 | (37.7533000261745, -122.425443969077) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 188310 | 188310 | 35816 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 448 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43043 | 6010644.99759 | 2092590.80492 | 37.7264562451386 | -122.405394631775 | (37.7264562451386, -122.405394631775) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 187272 | 187272 | 45474 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1349 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44253 | 5999367.63833 | 2089888.0893 | 37.718398218877 | -122.444185721794 | (37.718398218877, -122.444185721794) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 188086 | 188086 | 65745 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 242 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 10 | Permit Number 28704 | 6000840.51659 | 2087219.5194400002 | 37.7111548407988 | -122.43890347461 | (37.7111548407988, -122.43890347461) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 90361 | 90361 | 88617 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2494 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 3x3 | Permit Number 51590 | 5981831.2 | 2098131.1 | 37.740015242507 | -122.505411474316 | (37.740015242507, -122.505411474316) | |||
| 81102 | 81102 | 94349 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 117707 | 117707 | 94350 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 129119 | 129119 | 94351 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 138663 | 138663 | 94352 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 121635 | 121635 | 94353 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 128683 | 128683 | 94354 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 91472 | 91472 | 94355 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2010 12:00:00 AM | 3x3 | Permit Number 53635 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 119728 | 119728 | 106692 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 6005110.7 | 2103657.1 | 37.75653079247879 | -122.425313618185 | (37.7565307924788, -122.425313618185) | |||
| 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) | ||||
| 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) | ||||
| 91814 | 91814 | 113278 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2083 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003046.0 | 2118476.0 | 37.797102943491 | -122.433513059035 | (37.797102943491, -122.433513059035) | ||||
| 88339 | 88339 | 115364 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 69 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007449.0 | 2098988.0 | 37.743842328307 | -122.416896128684 | (37.743842328307, -122.416896128684) | |||
| 182123 | 182123 | 117662 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5983913.56445 | 2111711.8528 | 37.7774265003929 | -122.49921487984 | (37.7774265003929, -122.49921487984) | |||
| 33695 | 33695 | 117663 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5983899.75591 | 2111710.53343 | 37.7774220677076 | -122.499262549855 | (37.7774220677076, -122.499262549855) | |||
| 116198 | 116198 | 117664 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5983878.8751300005 | 2111710.17251 | 37.7774198517188 | -122.49933475552601 | (37.7774198517188, -122.499334755526) | |||
| 33336 | 33336 | 117665 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5983866.28213 | 2111708.82719 | 37.7774154190485 | -122.49937821872601 | (37.7774154190485, -122.499378218726) | |||
| 132370 | 132370 | 117666 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5983855.9686900005 | 2111709.85463 | 37.7774176350156 | -122.49941397168699 | (37.7774176350156, -122.499413971687) | |||
| 51210 | 51210 | 117851 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 646 39th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5983837.5936900005 | 2111421.5646599997 | 37.776624996189206 | -122.499456225728 | (37.7766249961892, -122.499456225728) | |||
| 44259 | 44259 | 117901 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 745 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983818.1839 | 2110710.73543 | 37.7746721257554 | -122.49947082515 | (37.7746721257554, -122.49947082515) | |||
| 156161 | 156161 | 121952 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 108 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5990864.509459999 | 2114720.39813 | 37.786092452656796 | -122.47538923366601 | (37.7860924526568, -122.475389233666) | |||
| 172723 | 172723 | 122196 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 131 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991469.44063 | 2114555.28767 | 37.7856741515485 | -122.473284307608 | (37.7856741515485, -122.473284307608) | |||
| 22358 | 22358 | 122197 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 131 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991469.09784 | 2114541.60598 | 37.7856365655774 | -122.47328449533899 | (37.7856365655774, -122.473284495339) | |||
| 155037 | 155037 | 122932 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 184 10th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5992762.84609 | 2114244.11852 | 37.7848945742073 | -122.46878688402501 | (37.7848945742073, -122.468786884025) | |||
| 42166 | 42166 | 122933 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 184 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5992764.59544 | 2114230.49713 | 37.784857274671104 | -122.46877984035801 | (37.7848572746711, -122.468779840358) | |||
| 24777 | 24777 | 123037 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 598 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991936.90153 | 2111420.91872 | 37.777095091129105 | -122.471438573307 | (37.7770950911291, -122.471438573307) | |||
| 147870 | 147870 | 124158 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 970 Anza St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5995788.03534 | 2112225.31952 | 37.7795257956775 | -122.458174612179 | (37.7795257956775, -122.458174612179) | |||
| 64887 | 64887 | 124159 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 970 Anza St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5995776.57441 | 2112223.28537 | 37.7795195518878 | -122.45821411290599 | (37.7795195518878, -122.458214112906) | |||
| 54985 | 54985 | 126463 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 845 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998902.34401 | 2121345.9026 | 37.8047469543639 | -122.44805780953199 | (37.8047469543639, -122.448057809532) | |||
| 157461 | 157461 | 126464 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2219 Chestnut St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 1ft | 6001195.64946 | 2119661.17014 | 37.8002519521333 | -122.440000735651 | (37.8002519521333, -122.440000735651) | |||
| 45758 | 45758 | 126465 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2219 Chestnut St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6001229.96585 | 2119664.24858 | 37.800262358175395 | -122.43988220860099 | (37.8002623581754, -122.439882208601) | |||
| 47905 | 47905 | 126466 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1454 Jefferson St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002229.507119999 | 2121606.26883 | 37.80565147990821 | -122.43656248897499 | (37.8056514799082, -122.436562488975) | |||
| 37144 | 37144 | 126467 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2711 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001788.68499 | 2115988.81164 | 37.7902023547025 | -122.437685450844 | (37.7902023547025, -122.437685450844) | |||
| 63942 | 63942 | 176182 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 200 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5998635.4334 | 2088884.2911 | 37.7156002193629 | -122.44664445567301 | (37.7156002193629, -122.446644455673) | |||
| 25855 | 25855 | 176183 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5998729.89326 | 2090676.55478 | 37.7205267594696 | -122.446446824275 | (37.7205267594696, -122.446446824275) | |||
| 59304 | 59304 | 176184 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998735.57322 | 2090674.4246200002 | 37.720521234959996 | -122.446427037372 | (37.72052123496, -122.446427037372) | |||
| 29667 | 29667 | 176185 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5998832.19664 | 2090623.5038299998 | 37.7203869364761 | -122.446089381522 | (37.7203869364761, -122.446089381522) | |||
| 154975 | 154975 | 176186 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998840.97625 | 2090619.3076900002 | 37.7203759162079 | -122.44605873171899 | (37.7203759162079, -122.446058731719) | |||
| 52978 | 52978 | 176187 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5998858.2339699995 | 2090609.3161099998 | 37.7203494671212 | -122.44599835935301 | (37.7203494671212, -122.445998359353) | |||
| 67050 | 67050 | 176188 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5998880.863480001 | 2090599.2128400002 | 37.7203230180654 | -122.44591941055401 | (37.7203230180654, -122.445919410554) | |||
| 34556 | 34556 | 176189 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998893.49045 | 2090593.19981 | 37.7203072286757 | -122.445875331189 | (37.7203072286757, -122.445875331189) | |||
| 170560 | 170560 | 176190 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5998918.88698 | 2090579.95992 | 37.7202723250901 | -122.44578659238 | (37.7202723250901, -122.44578659238) | |||
| 39353 | 39353 | 176191 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5998925.79803 | 2090576.3375099998 | 37.7202627733854 | -122.44576244287799 | (37.7202627733854, -122.445762442878) | |||
| 148799 | 148799 | 176192 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998935.8928 | 2090570.77641 | 37.7202480802556 | -122.445727149009 | (37.7202480802556, -122.445727149009) | |||
| 148790 | 148790 | 176193 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998949.70909 | 2090563.2644599997 | 37.7202282430074 | -122.445678850924 | (37.7202282430074, -122.445678850924) | |||
| 48055 | 48055 | 176194 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5998956.61434 | 2090559.37492 | 37.720217957471704 | -122.44565470229799 | (37.7202179574717, -122.445654702298) | |||
| 62213 | 62213 | 176195 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5998964.86489 | 2090556.5222099999 | 37.720210595634605 | -122.445625977963 | (37.7202105956346, -122.445625977963) | |||
| 167343 | 167343 | 176196 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998970.24187 | 2090551.75587 | 37.7201978153451 | -122.445607049032 | (37.7201978153451, -122.445607049032) | |||
| 151239 | 151239 | 176197 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5998975.73013 | 2090548.27475 | 37.720188570324204 | -122.445587827823 | (37.7201885703242, -122.445587827823) | |||
| 125294 | 125294 | 176198 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998989.57955 | 2090542.3676900002 | 37.720173141569 | -122.445539530639 | (37.720173141569, -122.445539530639) | |||
| 73179 | 73179 | 176199 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 800 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6011139.2917 | 2091015.07876 | 37.722157251034496 | -122.403575053247 | (37.7221572510345, -122.403575053247) | |||
| 181385 | 181385 | 176200 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6010755.27325 | 2091348.4361 | 37.723051123195894 | -122.404925977947 | (37.7230511231959, -122.404925977947) | |||
| 175052 | 175052 | 176201 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009499.02915 | 2090599.59902 | 37.7209246708253 | -122.409215763009 | (37.7209246708253, -122.409215763009) | |||
| 43694 | 43694 | 176202 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6009489.79963 | 2090597.2729099998 | 37.7209177667302 | -122.40924750276501 | (37.7209177667302, -122.409247502765) |
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");