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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 21889 | 21889 | 16054 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 215 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2000 12:00:00 AM | 3 | 3X3 | 6000626.0327699995 | 2094620.4537900002 | 37.7314639212093 | -122.440175160965 | (37.7314639212093, -122.440175160965) | ||
| 22363 | 22363 | 223333 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 203 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004237.41218 | 2097504.4182 | 37.7395875791097 | -122.42789535729099 | (37.7395875791097, -122.427895357291) | |||
| 23859 | 23859 | 223337 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 21 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002002.72042 | 2096679.5859400001 | 37.737196106421706 | -122.435562951888 | (37.7371961064217, -122.435562951888) | |||
| 24113 | 24113 | 223308 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4645 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000449.27846 | 2104630.8077 | 37.7589399004855 | -122.44150430050199 | (37.7589399004855, -122.441504300502) | |||
| 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) | |||
| 24868 | 24868 | 223297 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 216 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007815.61312 | 2100277.20089 | 37.747402801003204 | -122.41571972750201 | (37.7474028010032, -122.415719727502) | |||
| 25505 | 25505 | 37639 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 574 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40056 | 5993171.91156 | 2111565.06758 | 37.7775622521226 | -122.467176805707 | (37.7775622521226, -122.467176805707) | |
| 25855 | 25855 | 176183 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5998729.89326 | 2090676.55478 | 37.7205267594696 | -122.446446824275 | (37.7205267594696, -122.446446824275) | |||
| 26062 | 26062 | 247051 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 519 Valley St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002519.90495 | 2099141.5459 | 37.743985438385295 | -122.43395073994499 | (37.7439854383853, -122.433950739945) | |||
| 26383 | 26383 | 207515 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 71 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999632.40668 | 2095469.97761 | 37.7337398948819 | -122.443671310503 | (37.7337398948819, -122.443671310503) | ||||
| 27710 | 27710 | 247815 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 536 30th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003101.83098 | 2098352.54128 | 37.7418520216442 | -122.43188224706101 | (37.7418520216442, -122.431882247061) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 33489 | 33489 | 223330 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 71 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005065.72447 | 2097560.7917400002 | 37.73978919271671 | -122.425035418766 | (37.7397891927167, -122.425035418766) | |||
| 35272 | 35272 | 223291 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 271 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6002969.0531 | 2096218.7937599998 | 37.7359857142716 | -122.432189003136 | (37.7359857142716, -122.432189003136) | |||
| 36240 | 36240 | 50010 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1465@ 26th ST Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 7 | Permit Number 46741 | 6012041.28455 | 2101546.95627 | 37.7511259142534 | -122.401196767325 | (37.7511259142534, -122.401196767325) | |
| 36954 | 36954 | 56424 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 279 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2011 12:00:00 AM | 4 | Permit Number 767957 | 5990232.5043 | 2113517.65935 | 37.7827534137466 | -122.477487840106 | (37.7827534137466, -122.477487840106) | ||
| 37079 | 37079 | 207498 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1315 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995864.997719999 | 2092813.12874 | 37.726229233786704 | -122.45650421791099 | (37.7262292337867, -122.456504217911) | |||
| 37144 | 37144 | 126467 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2711 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001788.68499 | 2115988.81164 | 37.7902023547025 | -122.437685450844 | (37.7902023547025, -122.437685450844) | |||
| 37206 | 37206 | 64452 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2255 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 6 | Permit Number 49675 | 6010720.79087 | 2105970.79652 | 37.763199036616996 | -122.40607482140499 | (37.763199036617, -122.406074821405) | |
| 40162 | 40162 | 223298 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 352 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007782.782930001 | 2105864.77472 | 37.7627431594916 | -122.416228930816 | (37.7627431594916, -122.416228930816) | |||
| 41331 | 41331 | 223920 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 603 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006073.38987 | 2099874.4724 | 37.7461989073679 | -122.421715625397 | (37.7461989073679, -122.421715625397) | |||
| 41726 | 41726 | 247864 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 399 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009555.15097 | 2098432.68764 | 37.742435806664794 | -122.409574335293 | (37.7424358066648, -122.409574335293) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 45553 | 45553 | 207517 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 215 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5999350.95651 | 2095746.5877599998 | 37.73448334463821 | -122.444664238484 | (37.7344833446382, -122.444664238484) | |||
| 46264 | 46264 | 223891 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008990.48886 | 2099085.34531 | 37.7441962044045 | -122.41157287709999 | (37.7441962044045, -122.4115728771) | |||
| 46304 | 46304 | 207446 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993786.60025 | 2094254.5373 | 37.7300674458375 | -122.46379364666201 | (37.7300674458375, -122.463793646662) | |||
| 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) | |||
| 50781 | 50781 | 223919 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 293 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006519.52162 | 2104466.46125 | 37.7588326032685 | -122.420498850765 | (37.7588326032685, -122.420498850765) | |||
| 51461 | 51461 | 223294 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 779 Andover St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6007381.1978 | 2095205.1537400002 | 37.7334516540573 | -122.416862619235 | (37.7334516540573, -122.416862619235) | |||
| 51936 | 51936 | 223295 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 19 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007196.68855 | 2097540.75873 | 37.7398543306231 | -122.417666007897 | (37.7398543306231, -122.417666007897) | |||
| 54894 | 54894 | 69414 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 77 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 8 | Permit Number 33519 | 6001938.39138 | 2087385.6198099998 | 37.711673318833796 | -122.435120827182 | (37.7116733188338, -122.435120827182) | |
| 55413 | 55413 | 76397 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 701 Amador St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1999 12:00:00 AM | 5 | 6016633.05444 | 2099489.61531 | 37.7457319802501 | -122.38517445926 | (37.7457319802501, -122.38517445926) | ||
| 55553 | 55553 | 201990 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6013571.200540001 | 2092301.5748400001 | 37.7258252538048 | -122.395258547459 | (37.7258252538048, -122.395258547459) | ||||
| 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) | |||
| 57161 | 57161 | 249936 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 339 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011252.89025 | 2120033.51867 | 37.8018417214754 | -122.405224787598 | (37.8018417214754, -122.405224787598) | |||
| 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) | |||
| 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) | |||
| 58654 | 58654 | 223912 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 69 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007426.45015 | 2098992.55773 | 37.7438535743744 | -122.41697442385299 | (37.7438535743744, -122.416974423853) | |||
| 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) | ||||
| 60278 | 60278 | 176208 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 328 Santa Rosa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6000504.57511 | 2093791.5155099998 | 37.729180932853296 | -122.44053562992701 | (37.7291809328533, -122.440535629927) | ||||
| 61457 | 61457 | 223323 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000992.8223 | 2105437.44063 | 37.7611856686148 | -122.43968230461 | (37.7611856686148, -122.43968230461) | |||
| 62238 | 62238 | 176207 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 178 Cotter St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6001859.62036 | 2093660.3477 | 37.7288978433404 | -122.435841750723 | (37.7288978433404, -122.435841750723) | |||
| 62894 | 62894 | 50307 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 755 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 6 | Permit Number 47018 | 6012755.49383 | 2104002.55412 | 37.7579082710796 | -122.398899267499 | (37.7579082710796, -122.398899267499) | ||
| 63542 | 63542 | 176204 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 538 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001908.14836 | 2093650.44447 | 37.7288734078601 | -122.43567327801901 | (37.7288734078601, -122.435673278019) | |||
| 64439 | 64439 | 67487 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1715 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 3 | Permit Number 31011 | 6012862.87074 | 2104700.41126 | 37.759830416353296 | -122.398576880337 | (37.7598304163533, -122.398576880337) | |
| 64755 | 64755 | 223890 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009196.08294 | 2099133.7546900003 | 37.7443406562118 | -122.41086539301901 | (37.7443406562118, -122.410865393019) | |||
| 66168 | 66168 | 207429 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1459 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5992094.2339699995 | 2105504.39511 | 37.7608590024631 | -122.47046331483101 | (37.7608590024631, -122.470463314831) | |||
| 67234 | 67234 | 248105 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010429.9574 | 2099572.50671 | 37.745614482938706 | -122.406629807421 | (37.7456144829387, -122.406629807421) | |||
| 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) | |||
| 68970 | 68970 | 31151 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 666 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34854 | 5997015.55395 | 2094425.7402599999 | 37.7307230695921 | -122.45264315945299 | (37.7307230695921, -122.452643159453) | |
| 70135 | 70135 | 222512 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 95 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005345.21251 | 2099598.65373 | 37.7454004829386 | -122.42421396182199 | (37.7454004829386, -122.424213961822) | |||
| 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) | |||
| 72269 | 72269 | 222511 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 190 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006121.17792 | 2096336.3639900002 | 37.7364867517461 | -122.42129917361099 | (37.7364867517461, -122.421299173611) | |||
| 72412 | 72412 | 223315 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 359 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003283.341019999 | 2104456.3095299997 | 37.7586218228666 | -122.431690331759 | (37.7586218228666, -122.431690331759) | |||
| 73179 | 73179 | 176199 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 800 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6011139.2917 | 2091015.07876 | 37.722157251034496 | -122.403575053247 | (37.7221572510345, -122.403575053247) | |||
| 73235 | 73235 | 191044 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 801 19th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6015135.407930001 | 2105291.0534099997 | 37.761578537441395 | -122.390758499125 | (37.7615785374414, -122.390758499125) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 74349 | 74349 | 207520 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 910 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5998827.615259999 | 2095598.2840200001 | 37.734046259733404 | -122.44646292933001 | (37.7340462597334, -122.44646292933) | |||
| 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) | |||
| 77007 | 77007 | 207442 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 67 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993137.4318699995 | 2098655.60003 | 37.7421142351796 | -122.46635761832701 | (37.7421142351796, -122.466357618327) | |||
| 81102 | 81102 | 94349 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1265@ Waller St Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999439.6 | 2108532.0 | 37.7695940252359 | -122.445276718787 | (37.7695940252359, -122.445276718787) | ||||
| 88339 | 88339 | 115364 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 69 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007449.0 | 2098988.0 | 37.743842328307 | -122.416896128684 | (37.743842328307, -122.416896128684) | |||
| 91814 | 91814 | 113278 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2083 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003046.0 | 2118476.0 | 37.797102943491 | -122.433513059035 | (37.797102943491, -122.433513059035) | ||||
| 94561 | 94561 | 5564 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1004 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x20 | 6005043.313071599 | 2102494.5958208 | 37.753335020194996 | -122.425463937964 | (37.753335020195, -122.425463937964) | |||
| 119728 | 119728 | 106692 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 6005110.7 | 2103657.1 | 37.75653079247879 | -122.425313618185 | (37.7565307924788, -122.425313618185) | |||
| 120089 | 120089 | 223296 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 383 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006096.414419999 | 2097922.56825 | 37.7408407178299 | -122.421497409371 | (37.7408407178299, -122.421497409371) | |||
| 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) | ||
| 128312 | 128312 | 103900 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6013653.2 | 2091451.0 | 37.7234943066524 | -122.394915533675 | (37.7234943066524, -122.394915533675) | |||
| 129641 | 129641 | 223328 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 255 30th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6004815.61888 | 2098395.7664900003 | 37.742067712369 | -122.42595960077401 | (37.742067712369, -122.425959600774) | |||
| 132267 | 132267 | 38192 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 715 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | 6 | Permit Number 40321 | 6011331.34824 | 2091527.76082 | 37.72357569684971 | -122.40294719786002 | (37.7235756968497, -122.40294719786) | |
| 132370 | 132370 | 117666 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5983855.9686900005 | 2111709.85463 | 37.7774176350156 | -122.49941397168699 | (37.7774176350156, -122.499413971687) | |||
| 133070 | 133070 | 223913 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6007786.13084 | 2096145.8013 | 37.736057235545296 | -122.41552922139601 | (37.7360572355453, -122.415529221396) | |||
| 134108 | 134108 | 223917 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 213 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6009962.76785 | 2099649.19619 | 37.7457989059869 | -122.408250693314 | (37.7457989059869, -122.408250693314) | |||
| 134434 | 134434 | 70478 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 64 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 10 | 6005133.6380900005 | 2092919.2307799999 | 37.7270483380922 | -122.42447053479799 | (37.7270483380922, -122.424470534798) | ||
| 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) | |||
| 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) | |||
| 137185 | 137185 | 176211 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 223 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007229.58334 | 2092624.58551 | 37.7263574447365 | -122.417203995595 | (37.7263574447365, -122.417203995595) | |||
| 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) | |||
| 150243 | 150243 | 207450 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 520 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996939.366169999 | 2093634.8584599998 | 37.7285471311368 | -122.45284948821899 | (37.7285471311368, -122.452849488219) | |||
| 151056 | 151056 | 41175 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2435 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/1999 12:00:00 AM | 4 | Permit Number 41894 | 5999108.60374 | 2120208.9624099997 | 37.801637012407106 | -122.44726215142799 | (37.8016370124071, -122.447262151428) | |
| 151521 | 151521 | 223316 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 1 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003622.06269 | 2104228.7754599997 | 37.7580162625599 | -122.430502643895 | (37.7580162625599, -122.430502643895) | |||
| 152734 | 152734 | 223289 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2230 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6002654.982580001 | 2098989.6554 | 37.743576047195795 | -122.43347282043699 | (37.7435760471958, -122.433472820437) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");