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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 156175 | 156175 | 223893 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005048.71049 | 2102476.27815 | 37.753285029091394 | -122.425443969067 | (37.7532850290914, -122.425443969067) | |||
| 164542 | 164542 | 223896 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005049.72495 | 2102468.45452 | 37.7532636045415 | -122.42543990412399 | (37.7532636045415, -122.425439904124) | |||
| 165019 | 165019 | 223903 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005052.503 | 2102444.2727799998 | 37.7531973640707 | -122.42542857629101 | (37.7531973640707, -122.425428576291) | |||
| 174055 | 174055 | 223898 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005049.963959999 | 2102461.0372599997 | 37.753243251975896 | -122.425438549767 | (37.7532432519759, -122.425438549767) | |||
| 178454 | 178454 | 223894 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005048.6462900005 | 2102473.1584400004 | 37.7532764594666 | -122.42544396908501 | (37.7532764594666, -122.425443969085) | |||
| 183201 | 183201 | 223899 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005050.67979 | 2102453.42416 | 37.7532223886195 | -122.425435532533 | (37.7532223886195, -122.425435532533) | |||
| 185186 | 185186 | 223908 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005053.43289 | 2102431.11313 | 37.7531612832725 | -122.42542442411 | (37.7531612832725, -122.42542442411) | |||
| 187148 | 187148 | 223902 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005052.00491 | 2102446.20203 | 37.753202633200296 | -122.425430436072 | (37.7532026332003, -122.425430436072) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |
| 169886 | 169886 | 207485 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 115 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5999342.30815 | 2093460.30056 | 37.728205242168606 | -122.444529875249 | (37.7282052421686, -122.444529875249) | |||
| 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) | ||||
| 136266 | 136266 | 207464 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 118 Ridgewood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5996817.27631 | 2094530.75495 | 37.731000051814206 | -122.453336211192 | (37.7310000518142, -122.453336211192) | |||
| 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) | ||||
| 35988 | 35988 | 222510 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 123 Marsily St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6004279.53355 | 2095213.5865099998 | 37.7332998565836 | -122.427586552585 | (37.7332998565836, -122.427586552585) | |||
| 54589 | 54589 | 222509 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 123 Marsily St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6004280.34409 | 2095211.59088 | 37.733294422879 | -122.427583608195 | (37.733294422879, -122.427583608195) | |||
| 58247 | 58247 | 222508 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 123 Marsily St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6004280.8593 | 2095209.0357 | 37.7332874360711 | -122.427581644992 | (37.7332874360711, -122.427581644992) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 146556 | 146556 | 207516 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 132 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999170.9063099995 | 2095539.25965 | 37.7339037945108 | -122.445271827652 | (37.7339037945108, -122.445271827652) | |||
| 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) | |
| 167450 | 167450 | 207451 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 135 Marietta Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998537.14886 | 2098009.22031 | 37.74064952016 | -122.447640652719 | (37.74064952016, -122.447640652719) | |||
| 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) | ||||
| 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) | ||||
| 148078 | 148078 | 222527 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1400 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6001954.88942 | 2099981.2388299997 | 37.7462589568792 | -122.43596450368601 | (37.7462589568792, -122.435964503686) | |||
| 157964 | 157964 | 207428 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1406 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5991814.94231 | 2105825.1395 | 37.761723528825605 | -122.471452623948 | (37.7617235288256, -122.471452623948) | |||
| 30834 | 30834 | 222515 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1445 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001418.004509999 | 2099470.26771 | 37.7448254366625 | -122.43778439245001 | (37.7448254366625, -122.43778439245) | |||
| 31618 | 31618 | 222513 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1445 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001419.9831 | 2099436.11309 | 37.7447317686527 | -122.43777510514 | (37.7447317686527, -122.43777510514) | |||
| 183495 | 183495 | 222514 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1445 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001419.73158 | 2099453.0166 | 37.7447781673956 | -122.437777185266 | (37.7447781673956, -122.437777185266) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 181573 | 181573 | 223892 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 146 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008958.71449 | 2099085.99444 | 37.7441962043945 | -122.411682792229 | (37.7441962043945, -122.411682792229) | |||
| 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) | |
| 175897 | 175897 | 207427 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1466 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991507.09847 | 2105443.15069 | 37.7606568753312 | -122.472489472137 | (37.7606568753312, -122.472489472137) | |||
| 65841 | 65841 | 223335 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 147 Beacon St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6003368.46906 | 2097136.1116900002 | 37.7385270976507 | -122.43087350809999 | (37.7385270976507, -122.4308735081) | |||
| 175092 | 175092 | 223334 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 147 Beacon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6003368.54256 | 2097139.67402 | 37.7385368831568 | -122.43087350813299 | (37.7385368831568, -122.430873508133) | |||
| 50776 | 50776 | 223311 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6001071.26024 | 2104220.2611599998 | 37.7578480551551 | -122.43932377368401 | (37.7578480551551, -122.439323773684) | |||
| 55504 | 55504 | 223313 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6001079.43787 | 2104214.39787 | 37.757832421350706 | -122.439295071829 | (37.7578324213507, -122.439295071829) | |||
| 74101 | 74101 | 223309 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6001055.986930001 | 2104225.03313 | 37.75786028864879 | -122.4393769371 | (37.7578602886488, -122.4393769371) | |||
| 154833 | 154833 | 223312 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6001075.5552900005 | 2104217.4248099998 | 37.7578405116468 | -122.439308716341 | (37.7578405116468, -122.439308716341) | |||
| 165799 | 165799 | 223310 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6001063.6909 | 2104223.05336 | 37.7578552911032 | -122.439350151704 | (37.7578552911032, -122.439350151704) | |||
| 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) | |||
| 166720 | 166720 | 223881 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1504 Bryant St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009376.30557 | 2107741.2702200003 | 37.7679850594966 | -122.41085001551501 | (37.7679850594966, -122.410850015515) | |||
| 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) | ||||
| 168047 | 168047 | 207452 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 155 Marietta Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5998658.25141 | 2097950.47884 | 37.740495150632704 | -122.44721770154 | (37.7404951506327, -122.44721770154) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 41771 | 41771 | 223284 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.28454 | 2099249.93485 | 37.7442535469551 | -122.43575521973801 | (37.7442535469551, -122.435755219738) | |||
| 67975 | 67975 | 222532 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002001.73175 | 2099265.91821 | 37.744297515714 | -122.43575135893101 | (37.744297515714, -122.435751358931) | |||
| 70316 | 70316 | 222536 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.604180001 | 2099254.59883 | 37.7442663713055 | -122.43575444811898 | (37.7442663713055, -122.435754448119) | |||
| 133999 | 133999 | 223283 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.55819 | 2099252.37585 | 37.744260264912 | -122.435754448127 | (37.744260264912, -122.435754448127) | |||
| 148190 | 148190 | 222534 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 8ft | 6002001.170390001 | 2099260.36967 | 37.7442822488393 | -122.43575290309099 | (37.7442822488393, -122.435752903091) | |||
| 150339 | 150339 | 222535 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.66396 | 2099257.4887 | 37.7442743096056 | -122.435754448132 | (37.7442743096056, -122.435754448132) | |||
| 164386 | 164386 | 223285 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.46161 | 2099247.70726 | 37.7442474405741 | -122.435754448124 | (37.7442474405741, -122.435754448124) | |||
| 164401 | 164401 | 222530 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002000.54412 | 2099273.2820900003 | 37.7443176677386 | -122.435755992253 | (37.7443176677386, -122.435755992253) |
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");