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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189018 | 189018 | 247049 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 527 Valley St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6002466.92979 | 2099138.14647 | 37.7439730978735 | -122.434133672824 | (37.7439730978735, -122.434133672824) | |||
| 188779 | 188779 | 222521 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 791 27th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6001435.72019 | 2099957.2234099996 | 37.746163509146 | -122.437758004524 | (37.746163509146, -122.437758004524) | |||
| 188310 | 188310 | 35816 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 448 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43043 | 6010644.99759 | 2092590.80492 | 37.7264562451386 | -122.405394631775 | (37.7264562451386, -122.405394631775) | |
| 188254 | 188254 | 223883 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 25 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005389.40986 | 2103549.4496299997 | 37.756250951828896 | -122.424342082823 | (37.7562509518289, -122.424342082823) | |||
| 188086 | 188086 | 65745 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 242 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 10 | Permit Number 28704 | 6000840.51659 | 2087219.5194400002 | 37.7111548407988 | -122.43890347461 | (37.7111548407988, -122.43890347461) | |
| 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) | |
| 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) | |||
| 186464 | 186464 | 223329 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 67 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005097.78213 | 2097560.50759 | 37.739790223334204 | -122.42492455661899 | (37.7397902233342, -122.424924556619) | |||
| 185995 | 185995 | 207504 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 61 Burnside Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6001193.27416 | 2095765.4721 | 37.734640154910295 | -122.43829610308399 | (37.7346401549103, -122.438296103084) | ||||
| 185446 | 185446 | 223886 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005095.80391 | 2103679.27098 | 37.756590827211596 | -122.425366711909 | (37.7565908272116, -122.425366711909) | |||
| 185339 | 185339 | 207457 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 409 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998694.027369999 | 2094363.85027 | 37.7306491651155 | -122.44683598699699 | (37.7306491651155, -122.446835986997) | |||
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | |||
| 184231 | 184231 | 223304 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004328.41422 | 2103387.58746 | 37.7557465472879 | -122.427999836924 | (37.7557465472879, -122.427999836924) | |||
| 184076 | 184076 | 223326 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001032.4361 | 2105462.77683 | 37.7612574902612 | -122.439547114034 | (37.7612574902612, -122.439547114034) | |||
| 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) | |||
| 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) | |||
| 183211 | 183211 | 222520 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6001413.31101 | 2099956.87619 | 37.7461612815178 | -122.437835467626 | (37.7461612815178, -122.437835467626) | ||||
| 183208 | 183208 | 191037 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2255 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010742.72974 | 2105979.64591 | 37.7632245620984 | -122.405999565232 | (37.7632245620984, -122.405999565232) | |||
| 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) | |||
| 182934 | 182934 | 176203 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6009481.93286 | 2090594.23315 | 37.7209089794419 | -122.40927448154301 | (37.7209089794419, -122.409274481543) | |||
| 182901 | 182901 | 207518 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 175 Stillings Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 5999625.441330001 | 2095740.45065 | 37.7344821530156 | -122.44371481609699 | (37.7344821530156, -122.443714816097) | |||
| 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) | |||
| 182728 | 182728 | 207456 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 409 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998672.99795 | 2094364.83217 | 37.7306506597914 | -122.446908759242 | (37.7306506597914, -122.446908759242) | |||
| 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) | |||
| 182526 | 182526 | 223882 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 91 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005342.969740001 | 2099598.2197 | 37.7453991645551 | -122.42422168610399 | (37.7453991645551, -122.424221686104) | |||
| 182447 | 182447 | 222528 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002000.45417 | 2099279.73368 | 37.74433537718021 | -122.43575676478001 | (37.7443353771802, -122.43575676478) | |||
| 182285 | 182285 | 223303 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 485 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003237.77215 | 2103281.8732 | 37.7553945175465 | -122.431764076148 | (37.7553945175465, -122.431764076148) | |||
| 182193 | 182193 | 222529 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002000.5993 | 2099275.94966 | 37.7443249953938 | -122.435755992271 | (37.7443249953938, -122.435755992271) | |||
| 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) | |||
| 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) | |||
| 181385 | 181385 | 176200 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6010755.27325 | 2091348.4361 | 37.723051123195894 | -122.404925977947 | (37.7230511231959, -122.404925977947) | |||
| 180874 | 180874 | 223336 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 5529 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6001836.83808 | 2097447.0447 | 37.7392939468595 | -122.436191387341 | (37.7392939468595, -122.436191387341) | |||
| 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) | ||||
| 180681 | 180681 | 223921 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 638 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005996.90211 | 2099753.4309900003 | 37.745862241665705 | -122.421971513987 | (37.7458622416657, -122.421971513987) | |||
| 180334 | 180334 | 201985 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6013611.24152 | 2092292.4384599999 | 37.7258023939381 | -122.395119487989 | (37.7258023939381, -122.395119487989) | |||
| 180012 | 180012 | 207508 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5999372.65026 | 2095269.8732900003 | 37.7331756368378 | -122.44455498523001 | (37.7331756368378, -122.44455498523) | ||||
| 179667 | 179667 | 222531 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.69845 | 2099269.9426700003 | 37.7443085072419 | -122.43575521973601 | (37.7443085072419, -122.435755219736) | |||
| 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) | |||
| 177674 | 177674 | 176209 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000493.40055 | 2093786.9872599998 | 37.729167863003504 | -122.440573936562 | (37.7291678630035, -122.440573936562) | ||||
| 176905 | 176905 | 223911 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 248 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006019.9376300005 | 2096086.78594 | 37.735795757653 | -122.421631483913 | (37.735795757653, -122.421631483913) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 175643 | 175643 | 223301 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4039 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6001871.11422 | 2103502.75724 | 37.7559234475104 | -122.43650619502701 | (37.7559234475104, -122.436506195027) | |||
| 175189 | 175189 | 223888 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005139.26418 | 2103680.11038 | 37.7565955873218 | -122.42521647029 | (37.7565955873218, -122.42521647029) | |||
| 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) | |||
| 175052 | 175052 | 176201 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009499.02915 | 2090599.59902 | 37.7209246708253 | -122.409215763009 | (37.7209246708253, -122.409215763009) | |||
| 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) | ||||
| 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) | |||
| 173925 | 173925 | 176210 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6000484.20754 | 2093783.71625 | 37.729158358072 | -122.440605482959 | (37.729158358072, -122.440605482959) | ||||
| 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) | ||
| 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) | |||
| 173507 | 173507 | 222524 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 739 27th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6001699.42535 | 2099975.49164 | 37.7462286605235 | -122.436847454466 | (37.7462286605235, -122.436847454466) | |||
| 173466 | 173466 | 223286 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 645 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002295.49975 | 2100024.3738599997 | 37.746396739322904 | -122.43478980021999 | (37.7463967393229, -122.43478980022) | |||
| 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) | |||
| 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) | |||
| 172389 | 172389 | 223327 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002483.76265 | 2096988.16335 | 37.738070698907 | -122.433921821343 | (37.738070698907, -122.433921821343) | |||
| 171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
| 171451 | 171451 | 222533 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 8ft | 6002001.23018 | 2099263.25954 | 37.74429018714 | -122.435752903069 | (37.74429018714, -122.435752903069) | |||
| 171294 | 171294 | 223319 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 4 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003647.0575 | 2104227.27295 | 37.7580135529116 | -122.43041609403299 | (37.7580135529116, -122.430416094033) | |||
| 171121 | 171121 | 176206 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 538 Cayuga Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001905.56245 | 2093653.69597 | 37.728882188857206 | -122.43568245020799 | (37.7288821888572, -122.435682450208) | |||
| 170606 | 170606 | 223305 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004321.04014 | 2103386.4662900004 | 37.7557430516272 | -122.428025258965 | (37.7557430516272, -122.428025258965) | |||
| 170560 | 170560 | 176190 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5998918.88698 | 2090579.95992 | 37.7202723250901 | -122.44578659238 | (37.7202723250901, -122.44578659238) | |||
| 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) | |||
| 170000 | 170000 | 223331 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 99 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005029.44165 | 2097557.40609 | 37.73977784686821 | -122.42516062868201 | (37.7397778468682, -122.425160628682) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 167343 | 167343 | 176196 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998970.24187 | 2090551.75587 | 37.7201978153451 | -122.445607049032 | (37.7201978153451, -122.445607049032) | |||
| 166758 | 166758 | 51342 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2121 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2004 12:00:00 AM | 4 | Permit Number 47688 | 6004025.96964 | 2116952.58925 | 37.7929755986043 | -122.430013396525 | (37.7929755986043, -122.430013396525) | ||
| 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) | |||
| 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) | |||
| 166462 | 166462 | 223290 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2230 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6002654.58184 | 2098981.1488799998 | 37.7435526675385 | -122.433473598326 | (37.7435526675385, -122.433473598326) | |||
| 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) | |||
| 165634 | 165634 | 187593 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010735.28382 | 2091330.7832 | 37.7230015345836 | -122.40499383541001 | (37.7230015345836, -122.40499383541) | ||||
| 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) | |||
| 165592 | 165592 | 187592 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 700 Goettingen St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010726.84858 | 2091332.925 | 37.723006943986896 | -122.405023145203 | (37.7230069439869, -122.405023145203) | ||||
| 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) | |
| 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) | ||||
| 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) | |||
| 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) | |||
| 164498 | 164498 | 223884 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 720 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007476.34391 | 2105418.19682 | 37.7614997244664 | -122.417257150023 | (37.7614997244664, -122.417257150023) | |||
| 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) | |||
| 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) | |||
| 163610 | 163610 | 222523 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 739 27th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6001699.76952 | 2099972.4424099997 | 37.7462203076195 | -122.43684604612301 | (37.7462203076195, -122.436846046123) | |||
| 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) | |||
| 161688 | 161688 | 191047 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 508 Missouri St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 8ft | 6013509.00195 | 2104632.60387 | 37.7596802080014 | -122.396337460525 | (37.7596802080014, -122.396337460525) | |||
| 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) | |||
| 159716 | 159716 | 223918 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 885 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007588.79194 | 2104568.22054 | 37.7591722115349 | -122.416808017787 | (37.7591722115349, -122.416808017787) | |||
| 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) | |||
| 158480 | 158480 | 207525 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 98 Judson Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999467.57051 | 2093538.93345 | 37.728428296507104 | -122.444102487738 | (37.7284282965071, -122.444102487738) | ||||
| 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) | |||
| 157461 | 157461 | 126464 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2219 Chestnut St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 1ft | 6001195.64946 | 2119661.17014 | 37.8002519521333 | -122.440000735651 | (37.8002519521333, -122.440000735651) | |||
| 157311 | 157311 | 247865 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 400 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009511.40819 | 2098411.1338400003 | 37.742374173428004 | -122.40972406433201 | (37.742374173428, -122.409724064332) |
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");