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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 68020 | 68020 | 207491 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5992718.20945 | 2091059.61299 | 37.72123334423829 | -122.46725496096201 | (37.7212333442383, -122.467254960962) | |||
| 137385 | 137385 | 207493 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992717.93715 | 2091043.75308 | 37.7211897810709 | -122.467254749618 | (37.7211897810709, -122.467254749618) | |||
| 59457 | 59457 | 207492 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5992718.40075 | 2091048.7391700002 | 37.721203498421396 | -122.467253509457 | (37.7212034984214, -122.467253509457) | |||
| 41608 | 41608 | 207494 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 589 Arch St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992718.62693 | 2091039.53667 | 37.7211782436554 | -122.467252058845 | (37.7211782436554, -122.467252058845) | |||
| 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) | |
| 44338 | 44338 | 207495 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 218 Arch St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5992735.18915 | 2088665.77704 | 37.7146614305504 | -122.467022318922 | (37.7146614305504, -122.467022318922) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 70216 | 70216 | 207499 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2225 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5993421.6511 | 2100648.01596 | 37.747601300271604 | -122.46551959497101 | (37.7476013002716, -122.465519594971) | |||
| 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) | |
| 136456 | 136456 | 207503 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 745 Ulloa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5993822.08464 | 2098107.46233 | 37.7406486676059 | -122.463950543278 | (37.7406486676059, -122.463950543278) | |||
| 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) | |||
| 137962 | 137962 | 207454 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 730 Ulloa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5993920.85369 | 2098154.62053 | 37.7407838437897 | -122.46361246204701 | (37.7407838437897, -122.463612462047) | |||
| 130891 | 130891 | 207453 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 730 Ulloa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5993922.42412 | 2098155.36186 | 37.7407859697846 | -122.463607085923 | (37.7407859697846, -122.463607085923) | |||
| 31908 | 31908 | 207496 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 426 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5993791.26805 | 2090028.04623 | 37.7184627965046 | -122.46347090877899 | (37.7184627965046, -122.463470908779) | ||||
| 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) | |||
| 162780 | 162780 | 207445 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 65 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994317.99715 | 2093727.1572099999 | 37.7286499965007 | -122.461918327265 | (37.7286499965007, -122.461918327265) | |||
| 150612 | 150612 | 207444 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 220x Vasquez Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5994513.07685 | 2099093.39362 | 37.743395586528294 | -122.461632839295 | (37.7433955865283, -122.461632839295) | |||
| 36606 | 36606 | 207443 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 220x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 6ft | 5994526.33722 | 2099104.46758 | 37.743426756135996 | -122.461587791356 | (37.743426756136, -122.461587791356) | |||
| 73782 | 73782 | 207487 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 484 Faxon Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994797.52832 | 2091773.8490900001 | 37.723314279209205 | -122.46011911753 | (37.7233142792092, -122.46011911753) | |||
| 173568 | 173568 | 207489 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 226 Thrift St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 6ft | 5994760.7353 | 2089660.3504700002 | 37.7175090007127 | -122.460093262 | (37.7175090007127, -122.460093262) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 134437 | 134437 | 207449 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 36 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5996496.77472 | 2095409.8676 | 37.7333955075962 | -122.454507715774 | (37.7333955075962, -122.454507715774) | |||
| 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) | |||
| 135986 | 135986 | 207463 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 698 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5996886.4017900005 | 2094438.11032 | 37.7307496337669 | -122.453090548796 | (37.7307496337669, -122.453090548796) | |||
| 170216 | 170216 | 207462 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 698 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5996898.443109999 | 2094438.2196 | 37.730750623922 | -122.453048928172 | (37.730750623922, -122.453048928172) | |||
| 185014 | 185014 | 207488 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 36 Harold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5996823.38616 | 2090394.7857400002 | 37.7196440101375 | -122.45301664789801 | (37.7196440101375, -122.453016647898) | ||||
| 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) | |||
| 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) | |
| 172979 | 172979 | 207455 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 651 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997115.25311 | 2094389.86364 | 37.7306302730502 | -122.45229589793199 | (37.7306302730502, -122.452295897932) | |||
| 36540 | 36540 | 207466 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.05021 | 2094086.70842 | 37.7297991870776 | -122.452195219742 | (37.7297991870776, -122.452195219742) | |||
| 27379 | 27379 | 207465 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.25418 | 2094089.75184 | 37.729807555268295 | -122.452194734107 | (37.7298075552683, -122.452194734107) | |||
| 26765 | 26765 | 207471 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.11204 | 2094076.47997 | 37.7297711057327 | -122.45219426825399 | (37.7297711057327, -122.452194268254) | |||
| 24737 | 24737 | 207467 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.67547 | 2094084.4213299998 | 37.7297929430915 | -122.452192893201 | (37.7297929430915, -122.452192893201) | |||
| 56363 | 56363 | 207470 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.5742 | 2094079.0064 | 37.7297780691825 | -122.452192852745 | (37.7297780691825, -122.452192852745) | |||
| 68201 | 68201 | 207468 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.68437 | 2094082.5659999999 | 37.7297878493071 | -122.452192728615 | (37.7297878493071, -122.452192728615) | |||
| 47406 | 47406 | 207469 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 555 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997138.98786 | 2094080.7785599998 | 37.7297829588082 | -122.452191550501 | (37.7297829588082, -122.452191550501) | |||
| 137035 | 137035 | 207474 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.276190001 | 2094085.18087 | 37.7297964378325 | -122.452107900965 | (37.7297964378325, -122.452107900965) | |||
| 70587 | 70587 | 207478 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.33701 | 2094077.0358799999 | 37.7297740771139 | -122.452107103267 | (37.7297740771139, -122.452107103267) | |||
| 165627 | 165627 | 207476 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.49703 | 2094080.7785099999 | 37.7297843626508 | -122.452106819991 | (37.7297843626508, -122.452106819991) | |||
| 152621 | 152621 | 207477 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.54471 | 2094079.1487 | 37.729779890312 | -122.45210653761002 | (37.729779890312, -122.45210653761) | |||
| 39981 | 39981 | 207473 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.92167 | 2094087.8656099997 | 37.729803846463795 | -122.45210586311 | (37.7298038464638, -122.45210586311) | |||
| 182773 | 182773 | 207475 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.82346 | 2094082.98352 | 37.7297904357818 | -122.452105850522 | (37.7297904357818, -122.452105850522) | |||
| 57554 | 57554 | 207472 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 549 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5997163.972030001 | 2094090.1048700002 | 37.729809997823104 | -122.45210585051201 | (37.7298099978231, -122.452105850512) | |||
| 159701 | 159701 | 207523 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 738 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997186.60025 | 2095013.7835799998 | 37.732347495219706 | -122.452094240274 | (37.7323474952197, -122.452094240274) | |||
| 167776 | 167776 | 207521 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 634 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5997235.64715 | 2095297.01681 | 37.733127995253795 | -122.45194510118999 | (37.7331279952538, -122.45194510119) | |||
| 119592 | 119592 | 207447 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2 Teresita Blvd | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997345.19439 | 2099475.93136 | 37.7446085570499 | -122.451867739721 | (37.7446085570499, -122.451867739721) | |||
| 50605 | 50605 | 207448 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2 Teresita Blvd | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997352.37481 | 2099467.67517 | 37.744586298832296 | -122.451842315884 | (37.7445862988323, -122.451842315884) | |||
| 184316 | 184316 | 207522 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 654 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5997754.94762 | 2095022.4325 | 37.7324037829132 | -122.45012996443998 | (37.7324037829132, -122.45012996444) | |||
| 161026 | 161026 | 207502 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 715 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998000.03996 | 2095655.97005 | 37.7341573484745 | -122.44932825568998 | (37.7341573484745, -122.44932825569) | |||
| 182550 | 182550 | 207460 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.25164 | 2094437.83173 | 37.730817217831 | -122.44896322087799 | (37.730817217831, -122.448963220878) | |||
| 166653 | 166653 | 207459 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.33255 | 2094441.7162 | 37.7308278882933 | -122.448963220871 | (37.7308278882933, -122.448963220871) | |||
| 183431 | 183431 | 207461 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 305 Foerster St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5998080.39557 | 2094433.7139599998 | 37.7308059196407 | -122.44896242678101 | (37.7308059196407, -122.448962426781) | |||
| 28382 | 28382 | 207524 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 266 Judson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998309.1596 | 2093573.15338 | 37.728456103557896 | -122.448109616788 | (37.7284561035579, -122.448109616788) | ||||
| 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) | |||
| 175038 | 175038 | 207458 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 458 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998364.99374 | 2094412.73568 | 37.7307645903989 | -122.44797701984899 | (37.7307645903989, -122.447977019849) | ||||
| 49292 | 49292 | 207513 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 454 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5998419.395690001 | 2095283.7253 | 37.73315923141121 | -122.447851626453 | (37.7331592314112, -122.447851626453) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) |
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");