Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132275 | 132275 | 125715 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 165 Francisco St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6010453.93223 | 2121307.9619 | 37.8052963286168 | -122.408079498365 | (37.8052963286168, -122.408079498365) | |||
| 65712 | 65712 | 116889 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 799X Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999179.62484 | 2121450.57939 | 37.8050502147576 | -122.447105792604 | (37.8050502147576, -122.447105792604) | |||
| 68660 | 68660 | 125694 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3651 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999115.53218 | 2121417.6212299997 | 37.8049560584444 | -122.447325218189 | (37.8049560584444, -122.447325218189) | |||
| 55359 | 55359 | 125693 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3651 Baker St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999120.54197 | 2121369.94055 | 37.804825426501395 | -122.447304447454 | (37.8048254265014, -122.447304447454) | |||
| 55434 | 55434 | 125692 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3651 Baker St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999123.87818 | 2121357.2001099996 | 37.8047906353434 | -122.44729198466001 | (37.8047906353434, -122.44729198466) | |||
| 94020 | 94020 | 104295 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3665X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999151.92915 | 2121319.46506 | 37.8046886279394 | -122.44719219431002 | (37.8046886279394, -122.44719219431) | ||||
| 98616 | 98616 | 104294 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3665X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999151.92915 | 2121319.46506 | 37.8046886279394 | -122.44719219431002 | (37.8046886279394, -122.44719219431) | ||||
| 208 | 208 | 100305 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3701 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003064.411830001 | 2121045.8637900003 | 37.804160163827206 | -122.433633107497 | (37.8041601638272, -122.433633107497) | |||
| 58138 | 58138 | 33322 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3115 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37465 | 6004626.67946 | 2120295.23032 | 37.8021876375982 | -122.428173235217 | (37.8021876375982, -122.428173235217) | |
| 147813 | 147813 | 33323 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3115 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | Permit Number 37465 | 6004629.84544 | 2120270.80512 | 37.802120751438295 | -122.428160537697 | (37.8021207514383, -122.428160537697) | |
| 62837 | 62837 | 125708 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 987 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008267.41837 | 2119270.58084 | 37.7995795254212 | -122.41550189821001 | (37.7995795254212, -122.41550189821) | |||
| 58122 | 58122 | 125707 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 987 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008244.72432 | 2119269.3091700003 | 37.7995747581204 | -122.415580337966 | (37.7995747581204, -122.415580337966) | |||
| 79343 | 79343 | 34456 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | ||
| 124171 | 124171 | 34457 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 999x UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38200 | 6008246.0 | 2119227.0 | 37.7994586593975 | -122.415572926479 | (37.7994586593975, -122.415572926479) | |
| 185444 | 185444 | 34477 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1818 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 11 | Permit Number 46532 | 6008722.614159999 | 2119125.18072 | 37.7992058679054 | -122.413916459984 | (37.7992058679054, -122.413916459984) | |
| 53493 | 53493 | 33102 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 375 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37343 | 6011697.96502 | 2119046.16805 | 37.799155568835 | -122.40361510367701 | (37.799155568835, -122.403615103677) | |
| 147953 | 147953 | 33095 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1127 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 11 | Permit Number 37338 | 6011115.1734 | 2118807.4721 | 37.798467596260096 | -122.405614950876 | (37.7984675962601, -122.405614950876) | |
| 45990 | 45990 | 34666 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3047 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1997 12:00:00 AM | 3 | 5.5x6 | Permit Number 38514 | 6003371.82856 | 2118846.08663 | 37.7981375866326 | -122.432412059279 | (37.7981375866326, -122.432412059279) |
| 31337 | 31337 | 125710 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009006.53902 | 2118723.89067 | 37.798119966232704 | -122.412905591427 | (37.7981199662327, -122.412905591427) | ||||
| 147647 | 147647 | 125711 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 954 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6008937.17158 | 2118714.51142 | 37.798090319168 | -122.413144960375 | (37.798090319168, -122.413144960375) | ||||
| 172627 | 172627 | 125709 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009014.12735 | 2118712.39114 | 37.798088817308 | -122.412878520028 | (37.798088817308, -122.412878520028) | ||||
| 158306 | 158306 | 125712 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008850.76057 | 2118710.67422 | 37.798074931775396 | -122.413443697187 | (37.7980749317754, -122.413443697187) | ||||
| 133304 | 133304 | 125713 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 956 Vallejo St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6008845.05182 | 2118706.6905799997 | 37.7980636731514 | -122.41346316930799 | (37.7980636731514, -122.413463169308) | ||||
| 162353 | 162353 | 125714 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 941 Vallejo St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6008973.41059 | 2118698.11415 | 37.7980473306652 | -122.413018402384 | (37.7980473306652, -122.413018402384) | ||||
| 28594 | 28594 | 35262 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2231 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38747 | 6006326.183230001 | 2118540.89021 | 37.797466675306104 | -122.42216741420499 | (37.7974666753061, -122.422167414205) | |
| 119181 | 119181 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 61 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | ||
| 139835 | 139835 | 88996 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2924 Steiner St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3x3 | Permit Number 51745 | 6002052.0 | 2118164.0 | 37.7961898267193 | -122.436930189765 | (37.7961898267193, -122.436930189765) | |||
| 6342 | 6342 | 30510 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2774 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 6x7 | Permit Number 778747 | 5999768.8918 | 2117782.75925 | 37.7950130117898 | -122.444802762862 | (37.7950130117898, -122.444802762862) | |
| 89002 | 89002 | 119272 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1101 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | 3x3 | 6009465.43944441 | 2117056.87897214 | 37.793568508665295 | -122.41119983681601 | (37.7935685086653, -122.411199836816) | ||
| 53433 | 53433 | 125701 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009113.9445 | 2117050.28629 | 37.7935306880345 | -122.412415576041 | (37.7935306880345, -122.412415576041) | |||
| 130310 | 130310 | 125702 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009077.34196 | 2117044.73858 | 37.7935134012698 | -122.41254183184799 | (37.7935134012698, -122.412541831848) | |||
| 75084 | 75084 | 125704 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008924.73472 | 2116833.00784 | 37.792923474790896 | -122.413054888768 | (37.7929234747909, -122.413054888768) | |||
| 24322 | 24322 | 125703 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008909.16091 | 2116830.53076 | 37.7929157990679 | -122.4131085999 | (37.7929157990679, -122.4131085999) | |||
| 50257 | 50257 | 125705 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008691.84445 | 2116822.80562 | 37.792882385661 | -122.41385998166001 | (37.792882385661, -122.41385998166) | |||
| 30304 | 30304 | 125706 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008674.29968 | 2116820.86226 | 37.7928760643434 | -122.41392055009199 | (37.7928760643434, -122.413920550092) | |||
| 122013 | 122013 | 73893 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 10 | 6007549.1868 | 2116472.92184 | 37.7918574535089 | -122.417788830994 | (37.7918574535089, -122.417788830994) | ||
| 155622 | 155622 | 74125 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 9 | 6007522.57983 | 2116468.5162 | 37.7918438593627 | -122.417880578935 | (37.7918438593627, -122.417880578935) | ||
| 113972 | 113972 | 51581 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1639 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2005 12:00:00 AM | 3 | Permit Number 47874 | 6006611.817858701 | 2116483.82002415 | 37.791834582054896 | -122.421032908654 | (37.7918345820549, -122.421032908654) | ||
| 186861 | 186861 | 41550 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2271 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2000 12:00:00 AM | 5 | Permit Number 42072 | 6003891.05094 | 2116280.93986 | 37.7911237785009 | -122.430432278226 | (37.7911237785009, -122.430432278226) | ||
| 50526 | 50526 | 72443 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 11 | 6008813.774540001 | 2115937.32557 | 37.790457920444005 | -122.413375446746 | (37.790457920444, -122.413375446746) | ||
| 181814 | 181814 | 74235 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1069 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6008785.22187 | 2115933.15302 | 37.79044486048821 | -122.413473942277 | (37.7904448604882, -122.413473942277) | ||
| 169257 | 169257 | 125697 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6000257.02708 | 2116105.09438 | 37.790434429256 | -122.44299320909599 | (37.790434429256, -122.442993209096) | |||
| 28775 | 28775 | 125696 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000243.1729999995 | 2116103.47647 | 37.7904291970031 | -122.44304102692399 | (37.7904291970031, -122.443041026924) | |||
| 46436 | 46436 | 125695 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000226.0917 | 2116100.01999 | 37.790418732490004 | -122.443099878582 | (37.79041873249, -122.443099878582) | |||
| 27077 | 27077 | 50163 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2127WASHINGTON Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2003 12:00:00 AM | 4 | Permit Number 46876 | 6000341.02119 | 2116095.30485 | 37.7904123382987 | -122.442701892589 | (37.7904123382987, -122.442701892589) | ||
| 24588 | 24588 | 125698 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2107 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5999370.9628800005 | 2116081.41447 | 37.7903188519859 | -122.446057218191 | (37.7903188519859, -122.446057218191) | |||
| 29270 | 29270 | 125699 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2107 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5999372.165130001 | 2116056.16018 | 37.79024957900621 | -122.446051241271 | (37.7902495790062, -122.446051241271) | |||
| 77556 | 77556 | 34600 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3200 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38292 | 5999389.38393742 | 2116031.83359368 | 37.7901837678549 | -122.445989915265 | (37.7901837678549, -122.445989915265) | ||
| 87174 | 87174 | 34601 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3200 Washington St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38292 | 5999389.38393742 | 2116031.83359368 | 37.7901837678549 | -122.445989915265 | (37.7901837678549, -122.445989915265) | ||
| 43684 | 43684 | 67023 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2111 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 2 | Permit Number 768246 | 6000360.43065 | 2115965.11174 | 37.79005596844821 | -122.44262538545 | (37.7900559684482, -122.44262538545) | ||
| 171572 | 171572 | 32717 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008227.34815 | 2115705.62066 | 37.7897887726751 | -122.415388040436 | (37.7897887726751, -122.415388040436) |
| 71231 | 71231 | 32716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008229.60793 | 2115679.81731 | 37.7897180499914 | -122.41537839431801 | (37.7897180499914, -122.415378394318) |
| 100684 | 100684 | 66868 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 980 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 3x3 | Permit Number 30175 | 6007892.40589298 | 2115166.96998046 | 37.7882909386851 | -122.416508740658 | (37.7882909386851, -122.416508740658) | |
| 162854 | 162854 | 137857 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1845 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004358.4918 | 2115232.5475 | 37.7882716253172 | -122.428740178583 | (37.7882716253172, -122.428740178583) | |||
| 97462 | 97462 | 47590 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 246 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45434 | 5987870.09368443 | 2115354.49759594 | 37.7876594816311 | -122.485795537984 | (37.7876594816311, -122.485795537984) | |
| 85928 | 85928 | 87198 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3984 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2008 12:00:00 AM | 3 | 2.5x3 | Permit Number 50214 | 5995710.95001 | 2114863.89205 | 37.786766180939395 | -122.45863234603901 | (37.7867661809394, -122.458632346039) | |
| 24810 | 24810 | 125700 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 900 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007433.50155 | 2114436.05545 | 37.786258207895706 | -122.418044641354 | (37.7862582078957, -122.418044641354) | |||
| 3441 | 3441 | 32703 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 890 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37106 | 6007477.85623 | 2114415.95786 | 37.7862055211206 | -122.417889760126 | (37.7862055211206, -122.417889760126) |
| 44423 | 44423 | 38052 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40249 | 6000449.1918 | 2114423.1814 | 37.7858272875297 | -122.442207546183 | (37.7858272875297, -122.442207546183) | |
| 168364 | 168364 | 38053 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 9 | Permit Number 40249 | 6000435.904 | 2114420.5238 | 37.785819233145205 | -122.442253327272 | (37.7858192331452, -122.442253327272) | |
| 58385 | 58385 | 125691 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 16 Iris Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5997626.06875 | 2114398.69705 | 37.785598761105 | -122.45197294599899 | (37.785598761105, -122.451972945999) | |||
| 30971 | 30971 | 188230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012869.68369 | 2113682.0678 | 37.784492396237 | -122.39918379321001 | (37.784492396237, -122.39918379321) | |||
| 148224 | 148224 | 188231 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012859.425559999 | 2113671.68237 | 37.7844633085723 | -122.399218553795 | (37.7844633085723, -122.399218553795) | |||
| 52040 | 52040 | 48559 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1407 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | 5 | Permit Number 45875 | 5999686.8778 | 2113772.6173 | 37.7839975324947 | -122.444798150334 | (37.7839975324947, -122.444798150334) | ||
| 27026 | 27026 | 52825 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 323 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48850 | 5987743.22888 | 2113770.24482 | 37.7833021825875 | -122.486118118549 | (37.7833021825875, -122.486118118549) | ||
| 52243 | 52243 | 140387 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1701 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003030.1364 | 2113397.2369999997 | 37.783157057463605 | -122.433204874911 | (37.7831570574636, -122.433204874911) | |||
| 151597 | 151597 | 140386 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1739 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002991.9931 | 2113391.544 | 37.783139262071096 | -122.433336428258 | (37.7831392620711, -122.433336428258) | |||
| 172622 | 172622 | 140385 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1745 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002953.8498 | 2113388.1282 | 37.7831277191493 | -122.433468144329 | (37.7831277191493, -122.433468144329) | |||
| 67360 | 67360 | 141771 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1749 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002929.9391 | 2113383.5737 | 37.7831138570318 | -122.433550539983 | (37.7831138570318, -122.433550539983) | |||
| 56659 | 56659 | 39383 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 11 | Permit Number 40924 | 6011035.938999999 | 2112201.64162 | 37.7803251294514 | -122.405423660089 | (37.7803251294514, -122.405423660089) | |
| 40240 | 40240 | 39382 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 442 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 15 | Permit Number 40924 | 6011028.8433300005 | 2112194.85786 | 37.7803061060932 | -122.40544772953699 | (37.7803061060932, -122.405447729537) | ||
| 110504 | 110504 | 63153 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1135 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1996 12:00:00 AM | Permit Number 23689 | 6001346.37062481 | 2112270.98254885 | 37.7799689896828 | -122.438949272681 | (37.7799689896828, -122.438949272681) | ||
| 174350 | 174350 | 93937 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 427 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53392 | 5990582.69863 | 2112452.2597 | 37.7798484361675 | -122.476198485506 | (37.7798484361675, -122.476198485506) | |
| 147940 | 147940 | 118015 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 484 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5984418.072319999 | 2112574.2634400004 | 37.779824014236205 | -122.49753333513901 | (37.7798240142362, -122.497533335139) | |||
| 152875 | 152875 | 40214 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 483 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 13 | Permit Number 41394 | 5981888.55122 | 2112529.15759 | 37.7795515745255 | -122.506280566157 | (37.7795515745255, -122.506280566157) | |
| 110888 | 110888 | 51881 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 438 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/2005 12:00:00 AM | Permit Number 48097 | 5989393.54128853 | 2112360.26063999 | 37.7795268026551 | -122.48030552365499 | (37.7795268026551, -122.480305523655) | ||
| 36627 | 36627 | 40215 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 483 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 9 | Permit Number 41394 | 5981890.02626 | 2112509.7593099996 | 37.7794983994124 | -122.506274024618 | (37.7794983994124, -122.506274024618) | |
| 6578 | 6578 | 9618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2000 12:00:00 AM | 7 | 3X3 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.43379332982599 | (37.7793993714118, -122.433793329826) | ||
| 6505 | 6505 | 20152 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 12 | 3X3 | 6002876.4729 | 2111952.9425 | 37.7791826693541 | -122.433633233262 | (37.7791826693541, -122.433633233262) | ||
| 157325 | 157325 | 40205 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 531 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 10 | Permit Number 41387 | 5982523.74709 | 2112147.83586 | 37.7785419514891 | -122.50405493614099 | (37.7785419514891, -122.504054936141) | |
| 32937 | 32937 | 40207 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 11 | Permit Number 41389 | 5982528.29213 | 2112062.1562099997 | 37.7783069675702 | -122.504032865431 | (37.7783069675702, -122.504032865431) | |
| 43319 | 43319 | 103461 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 666 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2013 12:00:00 AM | 0 | 3x3 | Permit Number 770172 | 6005398.7 | 2111581.8 | 37.77830639149621 | -122.42488139317899 | (37.7783063914962, -122.424881393179) | |
| 127305 | 127305 | 45839 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 562 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2001 12:00:00 AM | Permit Number 44449 | 5984130.8408017 | 2112009.83198879 | 37.778257408954794 | -122.498485276772 | (37.7782574089548, -122.498485276772) | |||
| 128964 | 128964 | 34704 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 615 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38361 | 5981612.97325 | 2111540.52057 | 37.7768208414608 | -122.50716052883699 | (37.7768208414608, -122.507160528837) | |
| 50049 | 50049 | 72364 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 617 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 8 | 5991265.11371 | 2111180.08401 | 37.7763949395058 | -122.47374490167499 | (37.7763949395058, -122.473744901675) | ||
| 81835 | 81835 | 40103 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2701 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1999 12:00:00 AM | Permit Number 41327 | 5987231.374238401 | 2111151.67144351 | 37.7760824787808 | -122.48769646963801 | (37.7760824787808, -122.487696469638) | |||
| 186023 | 186023 | 72370 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3 | 5990680.359209999 | 2111038.5537900003 | 37.7759724517855 | -122.475757373153 | (37.7759724517855, -122.475757373153) | ||
| 184170 | 184170 | 73750 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 638 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 4 | 5990680.77629 | 2111023.575 | 37.7759313483187 | -122.47575483630501 | (37.7759313483187, -122.475754836305) | ||
| 112815 | 112815 | 34708 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38364 | 5981680.40522934 | 2111119.17303473 | 37.7756679163326 | -122.506896004177 | (37.7756679163326, -122.506896004177) | ||
| 163553 | 163553 | 34707 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 678 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 8 | Permit Number 38364 | 5981677.4444 | 2111118.32695 | 37.7756654188698 | -122.506906183465 | (37.7756654188698, -122.506906183465) | |
| 158678 | 158678 | 52682 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984583.26235 | 2111053.32202 | 37.7756576289957 | -122.496849595053 | (37.7756576289957, -122.496849595053) | ||
| 57759 | 57759 | 52679 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984569.7272 | 2111052.9985 | 37.77565594760279 | -122.49689639188101 | (37.7756559476028, -122.496896391881) | ||
| 180730 | 180730 | 52680 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984555.73131 | 2111052.6848299997 | 37.7756542662383 | -122.496944783224 | (37.7756542662383, -122.496944783224) | ||
| 154225 | 154225 | 52681 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3535 REVISED Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 6 | Permit Number 48754 | 5984542.32395 | 2111051.13386 | 37.7756492220711 | -122.49699104738 | (37.7756492220711, -122.49699104738) | ||
| 75940 | 75940 | 118109 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3595 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984506.18513 | 2111050.5276 | 37.775645439688894 | -122.497116013795 | (37.7756454396889, -122.497116013795) | |||
| 157132 | 157132 | 52677 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984472.12802 | 2111009.36044 | 37.7755304106086 | -122.49723078434401 | (37.7755304106086, -122.497230784344) | ||
| 159448 | 159448 | 52683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 5 | Permit Number 48754 | 5984474.1727 | 2110997.72398 | 37.7754985800658 | -122.49722285223801 | (37.7754985800658, -122.497222852238) | ||
| 174075 | 174075 | 52673 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 700 REVISED 37th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 7 | Permit Number 48754 | 5984474.785130001 | 2110952.04196 | 37.7753731862643 | -122.497217360825 | (37.7753731862643, -122.497217360825) | ||
| 159373 | 159373 | 38691 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 13904 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40604 | 6001240.455 | 2110421.1619 | 37.7748838228637 | -122.439183061176 | (37.7748838228637, -122.439183061176) | |
| 158553 | 158553 | 47683 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 730 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 8 | Permit Number 45474 | 5991337.42645 | 2110428.10245 | 37.7743343910633 | -122.473439892203 | (37.7743343910633, -122.473439892203) |
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");