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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3056 | 3056 | 223292 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998862.7522 | 2107587.12928 | 37.766966704981996 | -122.447203994986 | (37.766966704982, -122.447203994986) | |||
| 3058 | 3058 | 223293 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 101X Downey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998863.8718 | 2107567.85033 | 37.7669138338245 | -122.44719873483601 | (37.7669138338245, -122.447198734836) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 22363 | 22363 | 223333 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 203 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004237.41218 | 2097504.4182 | 37.7395875791097 | -122.42789535729099 | (37.7395875791097, -122.427895357291) | |||
| 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) | ||
| 24113 | 24113 | 223308 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000449.27846 | 2104630.8077 | 37.7589399004855 | -122.44150430050199 | (37.7589399004855, -122.441504300502) | |||
| 24868 | 24868 | 223297 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 216 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007815.61312 | 2100277.20089 | 37.747402801003204 | -122.41571972750201 | (37.7474028010032, -122.415719727502) | |||
| 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) | |
| 25525 | 25525 | 223307 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Hill St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004278.85639 | 2103386.69911 | 37.755741304225396 | -122.428171160475 | (37.7557413042254, -122.428171160475) | |||
| 26792 | 26792 | 223897 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005050.02816 | 2102464.15698 | 37.753251821628204 | -122.42543854974899 | (37.7532518216282, -122.425438549749) | |||
| 27218 | 27218 | 223299 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 267 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006192.90217 | 2101673.64979 | 37.7511457766604 | -122.4214301167 | (37.7511457766604, -122.4214301167) | |||
| 28400 | 28400 | 207500 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 145 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995396.1404800005 | 2096963.9149 | 37.73759935523479 | -122.458425341581 | (37.7375993552348, -122.458425341581) | |||
| 29457 | 29457 | 223906 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005052.89667 | 2102434.79152 | 37.7531713529793 | -122.42542654021901 | (37.7531713529793, -122.425426540219) | |||
| 30335 | 30335 | 223901 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005051.96111 | 2102449.00234 | 37.753210319725106 | -122.425430786811 | (37.7532103197251, -122.425430786811) | |||
| 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) | |||
| 33489 | 33489 | 223330 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 71 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005065.72447 | 2097560.7917400002 | 37.73978919271671 | -122.425035418766 | (37.7397891927167, -122.425035418766) | |||
| 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) | |||
| 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) | ||
| 37079 | 37079 | 207498 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995864.997719999 | 2092813.12874 | 37.726229233786704 | -122.45650421791099 | (37.7262292337867, -122.456504217911) | |||
| 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) | |||
| 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) | |
| 38078 | 38078 | 223907 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005052.86926 | 2102433.4593700003 | 37.7531676936567 | -122.425426540214 | (37.7531676936567, -122.425426540214) | |||
| 40162 | 40162 | 223298 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 352 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007782.782930001 | 2105864.77472 | 37.7627431594916 | -122.416228930816 | (37.7627431594916, -122.416228930816) | |||
| 41331 | 41331 | 223920 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 603 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006073.38987 | 2099874.4724 | 37.7461989073679 | -122.421715625397 | (37.7461989073679, -122.421715625397) | |||
| 41929 | 41929 | 223332 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004952.548830001 | 2097554.1312700002 | 37.7397645108307 | -122.425426258725 | (37.7397645108307, -122.425426258725) | |||
| 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) | |||
| 42777 | 42777 | 223302 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4039 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6001887.34135 | 2103503.7757599996 | 37.7559271662088 | -122.436450149275 | (37.7559271662088, -122.436450149275) | |||
| 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) | |||
| 45177 | 45177 | 207438 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1230 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992085.752780001 | 2107027.36715 | 37.7650401898777 | -122.470603574899 | (37.7650401898777, -122.470603574899) | |||
| 46264 | 46264 | 223891 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008990.48886 | 2099085.34531 | 37.7441962044045 | -122.41157287709999 | (37.7441962044045, -122.4115728771) | |||
| 46304 | 46304 | 207446 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993786.60025 | 2094254.5373 | 37.7300674458375 | -122.46379364666201 | (37.7300674458375, -122.463793646662) | |||
| 46383 | 46383 | 223887 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005112.75604 | 2103680.27946 | 37.756594554005105 | -122.42530815706999 | (37.7565945540051, -122.42530815707) | |||
| 48269 | 48269 | 191036 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2255 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010727.3327 | 2105979.27336 | 37.7632226779992 | -122.4060527925 | (37.7632226779992, -122.4060527925) | |||
| 48467 | 48467 | 223324 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001009.920609999 | 2105447.67366 | 37.7612147391902 | -122.439623902619 | (37.7612147391902, -122.439623902619) | |||
| 48696 | 48696 | 223905 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005052.74936 | 2102437.1740599996 | 37.7531778865567 | -122.42542721918699 | (37.7531778865567, -122.425427219187) | |||
| 49051 | 49051 | 222516 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001372.111959999 | 2100107.80211 | 37.7465733454859 | -122.437988737291 | (37.7465733454859, -122.437988737291) | |||
| 49541 | 49541 | 223895 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005049.77309 | 2102470.79439 | 37.7532700319998 | -122.425439904151 | (37.7532700319998, -122.425439904151) | |||
| 50781 | 50781 | 223919 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 293 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006519.52162 | 2104466.46125 | 37.7588326032685 | -122.420498850765 | (37.7588326032685, -122.420498850765) | |||
| 51936 | 51936 | 223295 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007196.68855 | 2097540.75873 | 37.7398543306231 | -122.417666007897 | (37.7398543306231, -122.417666007897) | |||
| 51944 | 51944 | 223900 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005051.2163 | 2102450.9229099997 | 37.753215551081794 | -122.425433499183 | (37.7532155510818, -122.425433499183) | |||
| 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) | |
| 54905 | 54905 | 223909 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005053.21271 | 2102428.9939599996 | 37.753155452084705 | -122.42542503473899 | (37.7531554520847, -122.425425034739) | |||
| 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) | ||
| 56678 | 56678 | 207501 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 421 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995678.5149300005 | 2095805.70725 | 37.7344354233544 | -122.457365278307 | (37.7344354233544, -122.457365278307) | |||
| 58654 | 58654 | 223912 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 69 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007426.45015 | 2098992.55773 | 37.7438535743744 | -122.41697442385299 | (37.7438535743744, -122.416974423853) | |||
| 61457 | 61457 | 223323 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000992.8223 | 2105437.44063 | 37.7611856686148 | -122.43968230461 | (37.7611856686148, -122.43968230461) | |||
| 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) | ||
| 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) | ||
| 64755 | 64755 | 223890 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009196.08294 | 2099133.7546900003 | 37.7443406562118 | -122.41086539301901 | (37.7443406562118, -122.410865393019) | |||
| 64850 | 64850 | 176212 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 643 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009383.55707 | 2092917.45205 | 37.7272825386525 | -122.40977844274299 | (37.7272825386525, -122.409778442743) | |||
| 65750 | 65750 | 207490 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 13 Thrift St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996346.95254 | 2089599.2142 | 37.717432241793205 | -122.45460605392401 | (37.7174322417932, -122.454606053924) | |||
| 66168 | 66168 | 207429 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5992094.2339699995 | 2105504.39511 | 37.7608590024631 | -122.47046331483101 | (37.7608590024631, -122.470463314831) | |||
| 67234 | 67234 | 248105 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010429.9574 | 2099572.50671 | 37.745614482938706 | -122.406629807421 | (37.7456144829387, -122.406629807421) | |||
| 68874 | 68874 | 207441 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1290 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5992406.747330001 | 2106715.1011 | 37.76420134633379 | -122.46947061170602 | (37.7642013463338, -122.469470611706) | |||
| 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) | |
| 70135 | 70135 | 222512 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 95 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005345.21251 | 2099598.65373 | 37.7454004829386 | -122.42421396182199 | (37.7454004829386, -122.424213961822) | |||
| 72269 | 72269 | 222511 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 190 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006121.17792 | 2096336.3639900002 | 37.7364867517461 | -122.42129917361099 | (37.7364867517461, -122.421299173611) | |||
| 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) | |
| 72412 | 72412 | 223315 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 359 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003283.341019999 | 2104456.3095299997 | 37.7586218228666 | -122.431690331759 | (37.7586218228666, -122.431690331759) | |||
| 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) | |||
| 76605 | 76605 | 207439 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 306 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993339.70707 | 2104624.4462200003 | 37.758514827803104 | -122.46609186415199 | (37.7585148278031, -122.466091864152) | |||
| 76858 | 76858 | 223306 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004310.1714 | 2103386.37188 | 37.7557421774856 | -122.428062839822 | (37.7557421774856, -122.428062839822) | |||
| 77007 | 77007 | 207442 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 67 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993137.4318699995 | 2098655.60003 | 37.7421142351796 | -122.46635761832701 | (37.7421142351796, -122.466357618327) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | |||
| 106533 | 106533 | 223300 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 9 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005822.66174 | 2099626.06801 | 37.7455027034951 | -122.422564964906 | (37.7455027034951, -122.422564964906) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 120089 | 120089 | 223296 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 383 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006096.414419999 | 2097922.56825 | 37.7408407178299 | -122.421497409371 | (37.7408407178299, -122.421497409371) | |||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | |
| 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) | |||
| 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) | ||
| 137185 | 137185 | 176211 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 223 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007229.58334 | 2092624.58551 | 37.7263574447365 | -122.417203995595 | (37.7263574447365, -122.417203995595) | |||
| 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) | ||||
| 146526 | 146526 | 223889 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005159.432019999 | 2103680.76581 | 37.7565985263084 | -122.42514676922801 | (37.7565985263084, -122.425146769228) | |||
| 150243 | 150243 | 207450 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 520 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996939.366169999 | 2093634.8584599998 | 37.7285471311368 | -122.45284948821899 | (37.7285471311368, -122.452849488219) | |||
| 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) | |
| 151065 | 151065 | 223904 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005052.50435 | 2102441.86115 | 37.753190742372205 | -122.425428400012 | (37.7531907423722, -122.425428400012) | |||
| 152923 | 152923 | 223910 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 156 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004889.92783 | 2099325.70173 | 37.7446253015285 | -122.42576883925699 | (37.7446253015285, -122.425768839257) | |||
| 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) | ||
| 154508 | 154508 | 207497 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1315 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995861.97122 | 2092806.17827 | 37.7262099757024 | -122.456514177902 | (37.7262099757024, -122.456514177902) | |||
| 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) | |||
| 155196 | 155196 | 207440 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 337 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5993165.92576 | 2104561.2758 | 37.758331350838795 | -122.46668828104201 | (37.7583313508388, -122.466688281042) | |||
| 155734 | 155734 | 223325 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001022.61715 | 2105456.75234 | 37.7612403896494 | -122.439580641646 | (37.7612403896494, -122.439580641646) |
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");