Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1735 | 1735 | 251679 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 5 Dwight St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011495.0 | 2091622.0 | 37.7238435952898 | -122.40238810251101 | (37.7238435952898, -122.402388102511) | |||||
| 1813 | 1813 | 246390 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 1267 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 5999435.2691 | 2108467.7761 | 37.7694174354079 | -122.44528708087499 | (37.7694174354079, -122.445287080875) | |||
| 29286 | 29286 | 191035 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 30 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009859.31671 | 2111047.24968 | 37.77708958274221 | -122.409412667772 | (37.7770895827422, -122.409412667772) | |||
| 30022 | 30022 | 183465 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2530 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988020.0365 | 2098057.0209999997 | 37.7401740893942 | -122.484007860756 | (37.7401740893942, -122.484007860756) | |||
| 34609 | 34609 | 182248 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1454 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5985596.8527 | 2105324.6327 | 37.7599875985541 | -122.492921320569 | (37.7599875985541, -122.492921320569) | |||
| 35901 | 35901 | 184740 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.762442323054294 | -122.49609061999399 | (37.7624423230543, -122.496090619994) | |||
| 37152 | 37152 | 207426 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 404 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000774.5178 | 2095253.0810900002 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | ||||
| 39055 | 39055 | 246391 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1302 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999418.9163 | 2108430.2253 | 37.7693133969257 | -122.445340943975 | (37.7693133969257, -122.445340943975) | |||
| 39416 | 39416 | 141601 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1882 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998863.8341 | 2110436.3604 | 37.77479003056 | -122.447405354515 | (37.77479003056, -122.447405354515) | |||
| 41620 | 41620 | 126461 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1990 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000743.635919999 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | |||
| 49139 | 49139 | 114654 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001378.1104 | 2113915.8269 | 37.7844871189173 | -122.438957381866 | (37.7844871189173, -122.438957381866) | |||
| 50624 | 50624 | 141254 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | |||
| 52169 | 52169 | 82920 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 1 | 5982872.9956 | 2103302.6049 | 37.754276013066104 | -122.502192036803 | (37.7542760130661, -122.502192036803) | ||
| 60665 | 60665 | 183413 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2350 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985629.7915 | 2097026.6067 | 37.737205400625 | -122.492196390733 | (37.737205400625, -122.492196390733) | |||
| 67051 | 67051 | 207425 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 359 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991937.91081 | 2090925.4069599998 | 37.7208197721094 | -122.469942439193 | (37.7208197721094, -122.469942439193) | |||
| 68022 | 68022 | 184739 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1301 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984690.4501 | 2106251.0591 | 37.7624782581791 | -122.496124432854 | (37.7624782581791, -122.496124432854) | |||
| 69521 | 69521 | 73455 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 9 | 6009841.50181 | 2111066.87201 | 37.777142462880995 | -122.409475680552 | (37.777142462881, -122.409475680552) | ||
| 71417 | 71417 | 246395 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999349.2656 | 2108419.0206 | 37.769278655482296 | -122.445581055639 | (37.7692786554823, -122.445581055639) | |||
| 85238 | 85238 | 23668 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 315 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | |||
| 85440 | 85440 | 14603 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 1265 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 5999439.61797 | 2108531.9802599996 | 37.7695939720606 | -122.44527665521002 | (37.7695939720606, -122.44527665521) | |||
| 87099 | 87099 | 9986 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 2 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2007 12:00:00 AM | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | ||
| 87387 | 87387 | 90956 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 4645 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981155.438709999 | 2110931.20899 | 37.775120893377796 | -122.50869800264299 | (37.7751208933778, -122.508698002643) | ||
| 89766 | 89766 | 121619 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1465 Rhode Island St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012073.0 | 2101555.0 | 37.7511497699027 | -122.40108765644301 | (37.7511497699027, -122.401087656443) | |||||
| 94608 | 94608 | 29418 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2601X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015194.8940554 | 2091164.3100784 | 37.7227927176508 | -122.38956611723101 | (37.7227927176508, -122.389566117231) | |||
| 97168 | 97168 | 106921 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 112-118 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007680.5 | 2107244.2 | 37.7665249882726 | -122.416680417976 | (37.7665249882726, -122.416680417976) | |||
| 102643 | 102643 | 99920 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6008334.0 | 2118406.0 | 37.7972093435845 | -122.41521026614402 | (37.7972093435845, -122.415210266144) | |||||
| 122949 | 122949 | 9987 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 2 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2x2 | 6005339.0167972 | 2108804.8168432 | 37.7706780982219 | -122.424890239466 | (37.7706780982219, -122.424890239466) | |||
| 123721 | 123721 | 246397 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264092996 | -122.445696997639 | (37.769264264093, -122.445696997639) | |||
| 123800 | 123800 | 116680 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 100 Esmeralda Ave | 19 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 142237 | 142237 | 102442 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 4145 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6008344.0 | 2095883.0 | 37.735366982034996 | -122.413581854524 | (37.735366982035, -122.413581854524) | |||
| 150358 | 150358 | 187339 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985079.353999999 | 2099690.9452 | 37.7444887635366 | -122.494295807794 | (37.7444887635366, -122.494295807794) | |||
| 151873 | 151873 | 140845 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 527 EUCLID AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5996698.8799 | 2113809.925 | 37.7839289983891 | -122.455138170133 | (37.7839289983891, -122.455138170133) | |||
| 157189 | 157189 | 246392 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1310 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999402.5635 | 2108427.4999 | 37.7693049801732 | -122.44539731131901 | (37.7693049801732, -122.445397311319) | |||
| 159169 | 159169 | 246396 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999332.61 | 2108417.5065 | 37.769273547251004 | -122.445638557414 | (37.769273547251, -122.445638557414) | |||
| 159867 | 159867 | 70368 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.50150735953899 | (37.7598111971708, -122.501507359539) | ||
| 164594 | 164594 | 248448 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 136 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998284.3672 | 2107976.1331 | 37.768001745714 | -122.449232557107 | (37.768001745714, -122.449232557107) | |||
| 166412 | 166412 | 141253 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 45 PARKER AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996809.5439 | 2114265.4407 | 37.7851860717648 | -122.454788237668 | (37.7851860717648, -122.454788237668) | |||
| 171936 | 171936 | 246393 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1318 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999383.4853 | 2108424.4716 | 37.769295576121394 | -122.445463083857 | (37.7692955761214, -122.445463083857) | |||
| 171963 | 171963 | 247352 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 717 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003091.9924 | 2109593.0641 | 37.772715254913294 | -122.432719040926 | (37.7727152549133, -122.432719040926) | |||
| 174014 | 174014 | 72596 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1551 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 5 | 5988056.3788 | 2104735.0481 | 37.758512285148605 | -122.48437186974199 | (37.7585122851486, -122.484371869742) | ||
| 174354 | 174354 | 72614 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1586 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1997 12:00:00 AM | 6 | 5987797.3449 | 2104500.8291 | 37.757854096737205 | -122.485250528016 | (37.7578540967372, -122.485250528016) | ||
| 178672 | 178672 | 246394 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1320 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999365.9212 | 2108422.0489 | 37.769287921296204 | -122.44552366275299 | (37.7692879212962, -122.445523662753) | |||
| 181134 | 181134 | 114652 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001448.056 | 2113923.3749 | 37.7845118231904 | -122.438715935573 | (37.7845118231904, -122.438715935573) | |||
| 183202 | 183202 | 126462 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1990 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.803877229006204 | -122.441595650935 | (37.8038772290062, -122.441595650935) | |||
| 188090 | 188090 | 114656 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 2200 Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001274.7016 | 2113900.9823 | 37.78444047533 | -122.439314075739 | (37.78444047533, -122.439314075739) | |||
| 144295 | 144295 | 64645 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 855 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1997 12:00:00 AM | Permit Number 25560 | 5994845.99503562 | 2093786.0882856003 | 37.7288421898975 | -122.46009728755301 | (37.7288421898975, -122.460097287553) | ||
| 106711 | 106711 | 67467 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 4078 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 30982 | 6003350.50488606 | 2101289.69360575 | 37.7499308522406 | -122.431232018452 | (37.7499308522406, -122.431232018452) | ||
| 101228 | 101228 | 68054 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1881 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31791 | 5993737.20481548 | 2102706.11474697 | 37.7532705090115 | -122.46457785688 | (37.7532705090115, -122.46457785688) | ||
| 78181 | 78181 | 68180 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 75 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1993 12:00:00 AM | Permit Number 31952 | 5996329.36645327 | 2111693.70801186 | 37.7780972208044 | -122.45626347950899 | (37.7780972208044, -122.456263479509) | ||
| 90711 | 90711 | 68249 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | ||
| 119134 | 119134 | 68399 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32230 | 5993170.65048654 | 2093114.37273837 | 37.7269013208382 | -122.465840234227 | (37.7269013208382, -122.465840234227) | ||
| 20473 | 20473 | 68412 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | ||
| 140374 | 140374 | 68496 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1822 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32372 | 5993466.35859208 | 2103074.11595722 | 37.7542653280544 | -122.465541223192 | (37.7542653280544, -122.465541223192) | ||
| 89241 | 89241 | 68517 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 146 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32397 | 5993053.91795071 | 2101210.30087773 | 37.7491239746497 | -122.466832052807 | (37.7491239746497, -122.466832052807) | ||
| 121863 | 121863 | 68548 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 542 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32435 | 5982266.27393695 | 2112076.97528737 | 37.778332244778106 | -122.504940366327 | (37.7783322447781, -122.504940366327) | ||
| 78508 | 78508 | 68560 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 520 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32450 | 5981950.36786377 | 2112213.67297772 | 37.778688985847104 | -122.506043321809 | (37.7786889858471, -122.506043321809) | ||
| 91475 | 91475 | 68599 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32502 | 5991241.84953509 | 2102215.30732714 | 37.7517787113613 | -122.47317142953301 | (37.7517787113613, -122.473171429533) | ||
| 126984 | 126984 | 68883 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 59 Carr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32855 | 6013060.20442694 | 2090777.05783105 | 37.721610806199 | -122.396918198144 | (37.721610806199, -122.396918198144) | ||
| 87399 | 87399 | 69146 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2479 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33181 | 5983616.53937475 | 2098288.7238606005 | 37.7405529339472 | -122.499250248288 | (37.7405529339472, -122.499250248288) | ||
| 146228 | 146228 | 69279 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1935 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33350 | 5991240.95366227 | 2102241.42925325 | 37.751850383474604 | -122.47317643242799 | (37.7518503834746, -122.473176432428) | ||
| 64770 | 64770 | 69317 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2122 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 6 | Permit Number 33397 | 5987643.2305 | 2104427.6901 | 37.7576442978234 | -122.485778145282 | (37.7576442978234, -122.485778145282) | |
| 94624 | 94624 | 31013 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1016 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34783 | 6002340.84086344 | 2087450.93520516 | 37.7118755052494 | -122.433734519918 | (37.7118755052494, -122.433734519918) | ||
| 78126 | 78126 | 31110 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | |||
| 83764 | 83764 | 31111 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 415 Edna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | |||
| 78000 | 78000 | 31125 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | ||
| 124999 | 124999 | 31124 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 15 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | ||
| 129175 | 129175 | 31126 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 19 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34843 | 5998070.7770048 | 2093598.16198917 | 37.7285111411981 | -122.448935514449 | (37.7285111411981, -122.448935514449) | ||
| 87435 | 87435 | 31145 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 419 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 3x3 | Permit Number 34852 | 5998635.87955939 | 2094356.6234018002 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | |
| 113914 | 113914 | 31139 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 419 Hearst Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018002 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | ||
| 118568 | 118568 | 31184 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 700 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34882 | 5992197.59450604 | 2089880.36663556 | 37.7179653541743 | -122.468968787075 | (37.7179653541743, -122.468968787075) | ||
| 109958 | 109958 | 31826 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.41063668938601 | (37.7719174714901, -122.410636689386) | ||
| 140930 | 140930 | 31827 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.41063668938601 | (37.7719174714901, -122.410636689386) | ||
| 115914 | 115914 | 31829 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | ||
| 121377 | 121377 | 31830 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 222 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | ||
| 120616 | 120616 | 33344 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 760 Darien Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37481 | 5993727.41255463 | 2094297.74009538 | 37.730182659203 | -122.46400139922599 | (37.730182659203, -122.464001399226) | ||
| 117014 | 117014 | 34346 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 255 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38104 | 6004828.12803067 | 2098393.70147146 | 37.7420627492496 | -122.42591620110201 | (37.7420627492496, -122.425916201102) | ||
| 123908 | 123908 | 34353 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 11 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38109 | 6004890.69932117 | 2098315.24737801 | 37.741850868129795 | -122.42569426656799 | (37.7418508681298, -122.425694266568) | ||
| 96701 | 96701 | 34355 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 84 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2003 12:00:00 AM | Permit Number 38111 | 6004874.55521399 | 2097707.40817778 | 37.740180967537604 | -122.425706834494 | (37.7401809675376, -122.425706834494) | ||
| 20616 | 20616 | 34363 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1846 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38119 | 6004556.0268692 | 2098000.12862747 | 37.74096670671079 | -122.426829018524 | (37.7409667067108, -122.426829018524) | ||
| 19240 | 19240 | 34364 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1862 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38120 | 6004563.40220029 | 2097868.81083057 | 37.7406065549579 | -122.426794167737 | (37.7406065549579, -122.426794167737) | ||
| 84138 | 84138 | 34388 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38136 | 6003730.56187145 | 2096520.40051304 | 37.736857004551794 | -122.429577666227 | (37.7368570045518, -122.429577666227) | ||
| 114806 | 114806 | 34398 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2016 12:00:00 AM | 3 | Permit Number 38145 | 6002598.06465628 | 2096836.91119738 | 37.7376618812243 | -122.433515816831 | (37.7376618812243, -122.433515816831) | |
| 79608 | 79608 | 34400 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 156 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38147 | 6002471.83146577 | 2097061.86671715 | 37.738272394243005 | -122.43396834021401 | (37.738272394243, -122.433968340214) | ||
| 109752 | 109752 | 34401 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38148 | 6002541.2507672 | 2096900.64630627 | 37.73783365951871 | -122.43371680334101 | (37.7378336595187, -122.433716803341) | ||
| 124926 | 124926 | 34402 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 160 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38149 | 6002458.41825324 | 2097080.12272084 | 37.7383217597979 | -122.434016021054 | (37.7383217597979, -122.434016021054) | ||
| 84947 | 84947 | 34404 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 171 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38152 | 6002491.04646095 | 2096956.56807226 | 37.7379843589135 | -122.433894379886 | (37.7379843589135, -122.433894379886) | ||
| 77316 | 77316 | 34414 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 205 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38161 | 6004190.49432582 | 2097526.98545022 | 37.7396468892769 | -122.42805918676399 | (37.7396468892769, -122.428059186764) | ||
| 110376 | 110376 | 34429 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 204 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38173 | 6002089.34387418 | 2096139.54747106 | 37.7357182050796 | -122.435224839434 | (37.7357182050796, -122.435224839434) | ||
| 125291 | 125291 | 34482 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 840 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38209 | 6008945.03028541 | 2119415.9766961997 | 37.8000168102383 | -122.413167394928 | (37.8000168102383, -122.413167394928) | ||
| 138766 | 138766 | 34527 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | |||
| 145421 | 145421 | 34528 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | ||
| 96015 | 96015 | 34569 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 212 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38277 | 6008791.12126389 | 2097614.61295509 | 37.7401467112036 | -122.41215832665002 | (37.7401467112036, -122.41215832665) | ||
| 36479 | 36479 | 34629 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 6 | Permit Number 38311 | 5988774.7652 | 2103307.0873 | 37.7546332934455 | -122.481782802584 | (37.7546332934455, -122.481782802584) | |
| 44447 | 44447 | 34630 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1766 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38311 | 5988776.9552 | 2103320.2277 | 37.754669500818295 | -122.481776191509 | (37.7546695008183, -122.481776191509) | |
| 98252 | 98252 | 34646 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1596 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | Permit Number 38325 | 5987803.91965419 | 2104439.10360026 | 37.7576849982837 | -122.48522326103 | (37.7576849982837, -122.48522326103) | |||
| 151243 | 151243 | 34648 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1591 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | Permit Number 38327 | 5987753.8097 | 2104490.816 | 37.757824067255704 | -122.485400354271 | (37.7578240672557, -122.485400354271) | |
| 126783 | 126783 | 34650 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1743 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38329 | 5987786.63645622 | 2103431.59810771 | 37.754917654251706 | -122.485209109036 | (37.7549176542517, -122.485209109036) | ||
| 34390 | 34390 | 34657 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38334 | 5988005.8211 | 2105120.9797 | 37.759569004405606 | -122.48457502698 | (37.7595690044056, -122.48457502698) | |
| 35235 | 35235 | 34660 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38334 | 5987955.9197 | 2105118.4846 | 37.759559247409 | -122.484747425675 | (37.759559247409, -122.484747425675) | |
| 37832 | 37832 | 34658 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 2200 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5987988.7714 | 2105120.9797 | 37.75956801150279 | -122.484633992596 | (37.7595680115028, -122.484633992596) |
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");