Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3056 | 3056 | 223292 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998862.7522 | 2107587.12928 | 37.766966704981996 | -122.447203994986 | (37.766966704982, -122.447203994986) | |||
| 3058 | 3058 | 223293 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 101X Downey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998863.8718 | 2107567.85033 | 37.7669138338245 | -122.44719873483601 | (37.7669138338245, -122.447198734836) | |||
| 3721 | 3721 | 36883 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2515 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002662.87522 | 2116961.2420799998 | 37.792922065545504 | -122.43473038919501 | (37.7929220655455, -122.434730389195) | ||
| 3779 | 3779 | 61682 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 27 Ceres St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 4 | Permit Number 21679 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | |
| 19658 | 19658 | 103913 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 14 | 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) | |||
| 20296 | 20296 | 103912 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 13 | 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) | |||
| 20756 | 20756 | 26940 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3 | 6005048.82283 | 2102481.7377299997 | 37.7533000261745 | -122.425443969077 | (37.7533000261745, -122.425443969077) | |||
| 21036 | 21036 | 26938 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3 | 6005048.24826 | 2102491.89317 | 37.753327878185395 | -122.42544667872299 | (37.7533278781854, -122.425446678723) | |||
| 21889 | 21889 | 16054 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 215 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2000 12:00:00 AM | 3 | 3X3 | 6000626.0327699995 | 2094620.4537900002 | 37.7314639212093 | -122.440175160965 | (37.7314639212093, -122.440175160965) | ||
| 22358 | 22358 | 122197 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 131 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991469.09784 | 2114541.60598 | 37.7856365655774 | -122.47328449533899 | (37.7856365655774, -122.473284495339) | |||
| 22363 | 22363 | 223333 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 203 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004237.41218 | 2097504.4182 | 37.7395875791097 | -122.42789535729099 | (37.7395875791097, -122.427895357291) | |||
| 23388 | 23388 | 191040 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1301 Minnesota St | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6015380.38588 | 2102504.53618 | 37.75394094514021 | -122.389716581452 | (37.7539409451402, -122.389716581452) | ||||
| 23823 | 23823 | 42743 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 295 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42737 | 6012647.1314 | 2087116.87515 | 37.7115376741026 | -122.398089440585 | (37.7115376741026, -122.398089440585) | ||
| 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) | |||
| 24238 | 24238 | 223314 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 737 Sanchez St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003692.0750400005 | 2104158.0805900004 | 37.7578261171073 | -122.43025546792101 | (37.7578261171073, -122.430255467921) | |||
| 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) | |||
| 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) | |||
| 24928 | 24928 | 223320 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 5 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003607.3788 | 2104219.57182 | 37.7579901597246 | -122.430552770305 | (37.7579901597246, -122.430552770305) | |||
| 25470 | 25470 | 223317 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 2 | : Yard 23 | Tree 1 | Private 1 | 3 | Width 3ft | 6003628.73131 | 2104227.65103 | 37.7580135529078 | -122.430479500748 | (37.7580135529078, -122.430479500748) | |||
| 25505 | 25505 | 37639 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 574 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 6 | Permit Number 40056 | 5993171.91156 | 2111565.06758 | 37.7775622521226 | -122.467176805707 | (37.7775622521226, -122.467176805707) | |
| 25525 | 25525 | 223307 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Hill St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004278.85639 | 2103386.69911 | 37.755741304225396 | -122.428171160475 | (37.7557413042254, -122.428171160475) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 26100 | 26100 | 201969 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6013782.624009999 | 2092181.31295 | 37.725506794893896 | -122.394519248986 | (37.7255067948939, -122.394519248986) | |||
| 26369 | 26369 | 201988 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013586.6338 | 2092298.57883 | 37.7258178856713 | -122.39520498563 | (37.7258178856713, -122.39520498563) | ||||
| 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) | ||||
| 26691 | 26691 | 222522 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 791 27th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 5ft | 6001439.60059 | 2099957.7516 | 37.7461651800752 | -122.43774462443899 | (37.7461651800752, -122.437744624439) | |||
| 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) | |||
| 26792 | 26792 | 223897 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005050.02816 | 2102464.15698 | 37.753251821628204 | -122.42543854974899 | (37.7532518216282, -122.425438549749) | |||
| 27218 | 27218 | 223299 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 267 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006192.90217 | 2101673.64979 | 37.7511457766604 | -122.4214301167 | (37.7511457766604, -122.4214301167) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 28548 | 28548 | 223916 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6007765.411040001 | 2096148.4497200001 | 37.736063342858 | -122.415601045774 | (37.736063342858, -122.415601045774) | |||
| 29457 | 29457 | 223906 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005052.89667 | 2102434.79152 | 37.7531713529793 | -122.42542654021901 | (37.7531713529793, -122.425426540219) | |||
| 29667 | 29667 | 176185 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5998832.19664 | 2090623.5038299998 | 37.7203869364761 | -122.446089381522 | (37.7203869364761, -122.446089381522) | |||
| 30038 | 30038 | 207511 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 300 Mangels Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5999356.36789 | 2095270.9974099998 | 37.733177794305 | -122.44461135834601 | (37.733177794305, -122.444611358346) | ||||
| 30335 | 30335 | 223901 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005051.96111 | 2102449.00234 | 37.753210319725106 | -122.425430786811 | (37.7532103197251, -122.425430786811) | |||
| 30834 | 30834 | 222515 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1445 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001418.004509999 | 2099470.26771 | 37.7448254366625 | -122.43778439245001 | (37.7448254366625, -122.43778439245) | |||
| 31618 | 31618 | 222513 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1445 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6001419.9831 | 2099436.11309 | 37.7447317686527 | -122.43777510514 | (37.7447317686527, -122.43777510514) | |||
| 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) | ||||
| 33336 | 33336 | 117665 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5983866.28213 | 2111708.82719 | 37.7774154190485 | -122.49937821872601 | (37.7774154190485, -122.499378218726) | |||
| 33489 | 33489 | 223330 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 71 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005065.72447 | 2097560.7917400002 | 37.73978919271671 | -122.425035418766 | (37.7397891927167, -122.425035418766) | |||
| 33695 | 33695 | 117663 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4739 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5983899.75591 | 2111710.53343 | 37.7774220677076 | -122.499262549855 | (37.7774220677076, -122.499262549855) | |||
| 34556 | 34556 | 176189 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998893.49045 | 2090593.19981 | 37.7203072286757 | -122.445875331189 | (37.7203072286757, -122.445875331189) | |||
| 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) | ||||
| 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) | |||
| 35988 | 35988 | 222510 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 123 Marsily St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6004279.53355 | 2095213.5865099998 | 37.7332998565836 | -122.427586552585 | (37.7332998565836, -122.427586552585) | |||
| 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) | |
| 36355 | 36355 | 191048 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 508 Missouri St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 8ft | 6013509.22069 | 2104630.04045 | 37.759673181581796 | -122.396336524335 | (37.7596731815818, -122.396336524335) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 37542 | 37542 | 223915 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 588 Ogden Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6007768.9471 | 2096146.5978599999 | 37.73605845682229 | -122.415588689077 | (37.7360584568223, -122.415588689077) | |||
| 38078 | 38078 | 223907 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005052.86926 | 2102433.4593700003 | 37.7531676936567 | -122.425426540214 | (37.7531676936567, -122.425426540214) | |||
| 38165 | 38165 | 223321 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4404 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 6 | Width 3ft | 6003607.59341 | 2104210.2360400003 | 37.757964538052796 | -122.430551361954 | (37.7579645380528, -122.430551361954) | |||
| 38347 | 38347 | 103902 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 6025 03rd St | 3 | 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) | |||
| 39053 | 39053 | 201987 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6013596.70102 | 2092297.48635 | 37.7258154458067 | -122.39517010723301 | (37.7258154458067, -122.395170107233) | |||
| 39353 | 39353 | 176191 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5998925.79803 | 2090576.3375099998 | 37.7202627733854 | -122.44576244287799 | (37.7202627733854, -122.445762442878) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 41771 | 41771 | 223284 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1626 Diamond St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 8ft | 6002000.28454 | 2099249.93485 | 37.7442535469551 | -122.43575521973801 | (37.7442535469551, -122.435755219738) | |||
| 41929 | 41929 | 223332 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004952.548830001 | 2097554.1312700002 | 37.7397645108307 | -122.425426258725 | (37.7397645108307, -122.425426258725) | |||
| 42166 | 42166 | 122933 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 184 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5992764.59544 | 2114230.49713 | 37.784857274671104 | -122.46877984035801 | (37.7848572746711, -122.468779840358) | |||
| 42194 | 42194 | 207483 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 209 Flood Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999342.799240001 | 2094043.6842 | 37.729807105610206 | -122.444570089355 | (37.7298071056102, -122.444570089355) | ||||
| 42777 | 42777 | 223302 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 4039 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6001887.34135 | 2103503.7757599996 | 37.7559271662088 | -122.436450149275 | (37.7559271662088, -122.436450149275) | |||
| 43694 | 43694 | 176202 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 746 Olmstead St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6009489.79963 | 2090597.2729099998 | 37.7209177667302 | -122.40924750276501 | (37.7209177667302, -122.409247502765) | |||
| 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) | |||
| 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) | |||
| 44388 | 44388 | 247962 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 14 Joy St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6010359.95763 | 2098907.35395 | 37.7437842015861 | -122.40682498730699 | (37.7437842015861, -122.406824987307) | ||||
| 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) | |||
| 45589 | 45589 | 191045 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 900x Carolina St | 40 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012497.15794 | 2103097.51934 | 37.755408845542895 | -122.399729160991 | (37.7554088455429, -122.399729160991) | ||||
| 45758 | 45758 | 126465 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2219 Chestnut St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6001229.96585 | 2119664.24858 | 37.800262358175395 | -122.43988220860099 | (37.8002623581754, -122.439882208601) | |||
| 46264 | 46264 | 223891 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 150 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008990.48886 | 2099085.34531 | 37.7441962044045 | -122.41157287709999 | (37.7441962044045, -122.4115728771) | |||
| 46304 | 46304 | 207446 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993786.60025 | 2094254.5373 | 37.7300674458375 | -122.46379364666201 | (37.7300674458375, -122.463793646662) | |||
| 46383 | 46383 | 223887 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 3487 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005112.75604 | 2103680.27946 | 37.756594554005105 | -122.42530815706999 | (37.7565945540051, -122.42530815707) | |||
| 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) | |||
| 47611 | 47611 | 207519 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 906 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998840.32295 | 2095592.3894200001 | 37.7340308003734 | -122.446418571155 | (37.7340308003734, -122.446418571155) | |||
| 47905 | 47905 | 126466 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1454 Jefferson St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002229.507119999 | 2121606.26883 | 37.80565147990821 | -122.43656248897499 | (37.8056514799082, -122.436562488975) | |||
| 48055 | 48055 | 176194 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 500 Geneva Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5998956.61434 | 2090559.37492 | 37.720217957471704 | -122.44565470229799 | (37.7202179574717, -122.445654702298) | |||
| 48269 | 48269 | 191036 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2255 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010727.3327 | 2105979.27336 | 37.7632226779992 | -122.4060527925 | (37.7632226779992, -122.4060527925) | |||
| 48467 | 48467 | 223324 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 2811 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001009.920609999 | 2105447.67366 | 37.7612147391902 | -122.439623902619 | (37.7612147391902, -122.439623902619) | |||
| 48630 | 48630 | 247006 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 401 Valley St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 6003253.92203 | 2099189.92697 | 37.7441599095582 | -122.43141613026 | (37.7441599095582, -122.43141613026) | |||
| 48696 | 48696 | 223905 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6005052.74936 | 2102437.1740599996 | 37.7531778865567 | -122.42542721918699 | (37.7531778865567, -122.425427219187) | |||
| 49051 | 49051 | 222516 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1231 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001372.111959999 | 2100107.80211 | 37.7465733454859 | -122.437988737291 | (37.7465733454859, -122.437988737291) | |||
| 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) | |||
| 49541 | 49541 | 223895 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005049.77309 | 2102470.79439 | 37.7532700319998 | -122.425439904151 | (37.7532700319998, -122.425439904151) | |||
| 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) | |||
| 50776 | 50776 | 223311 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 15 Seward St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6001071.26024 | 2104220.2611599998 | 37.7578480551551 | -122.43932377368401 | (37.7578480551551, -122.439323773684) |
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");