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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82360 | 82360 | 39674 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.718437864492394 | -122.462552614145 | (37.7184378644924, -122.462552614145) | ||
| 86680 | 86680 | 39663 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 90504 | 90504 | 39664 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 92664 | 92664 | 39671 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 99326 | 99326 | 39673 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 103711 | 103711 | 39650 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 114 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41043 | 5994182.55528924 | 2090689.21166175 | 37.7203007349832 | -122.462166324336 | (37.7203007349832, -122.462166324336) | ||
| 107537 | 107537 | 39654 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 326 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41047 | 5994205.8673586 | 2092067.47591786 | 37.7240864587641 | -122.46218564714898 | (37.7240864587641, -122.462185647149) | ||
| 107581 | 107581 | 39652 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 141 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41045 | 5994132.92951736 | 2090837.78725757 | 37.7207058303918 | -122.462348633516 | (37.7207058303918, -122.462348633516) | ||
| 112900 | 112900 | 39672 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 127185 | 127185 | 39670 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 139952 | 139952 | 39653 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41046 | 5994186.17432148 | 2090915.05015887 | 37.7209210416097 | -122.462170184545 | (37.7209210416097, -122.462170184545) | ||
| 145840 | 145840 | 39649 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 5 | 3x20 | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.720220556524204 | -122.462345612464 | (37.7202205565242, -122.462345612464) | |
| 126416 | 126416 | 57436 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4331 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 10 | 3x3 | Permit Number 32868 | 6001612.33019827 | 2105235.34197744 | 37.760665996510895 | -122.437525222221 | (37.7606659965109, -122.437525222221) |
| 83690 | 83690 | 57741 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1976 12:00:00 AM | 10 | 3x3 | Permit Number 16659 | 6001762.0 | 2096689.0 | 37.7372082800729 | -122.436395904515 | (37.7372082800729, -122.436395904515) | |
| 64059 | 64059 | 52490 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.536314401 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | ||
| 100585 | 100585 | 52491 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.536314401 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | |||
| 115519 | 115519 | 46180 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 321 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44508 | 5996626.00544099 | 2106611.60599874 | 37.7641601102413 | -122.45487001246599 | (37.7641601102413, -122.454870012466) | ||
| 162269 | 162269 | 39521 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1330 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 1 | 3x3 | Permit Number 40968 | 6012480.371 | 2107070.1033 | 37.7663157471753 | -122.400066187848 | (37.7663157471753, -122.400066187848) |
| 101753 | 101753 | 52421 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3987 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | Permit Number 48541 | 6003110.11516472 | 2104732.93493797 | 37.7593715494171 | -122.43230918120899 | (37.7593715494171, -122.432309181209) | |||
| 131758 | 131758 | 63193 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 435 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 12 | Permit Number 23733 | 5984052.79771 | 2112895.3666 | 37.78068425281221 | -122.498820690126 | (37.7806842528122, -122.498820690126) | |
| 54695 | 54695 | 52371 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.78967044259821 | -122.41321087889901 | (37.7896704425982, -122.413210878899) |
| 11300 | 11300 | 26996 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1239 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6008815.333330001 | 2094106.20179 | 37.730514731765396 | -122.41182676109399 | (37.7305147317654, -122.411826761094) | ||
| 23127 | 23127 | 27661 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2211 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6012766.85578 | 2096252.7885099999 | 37.7366297052834 | -122.398316233412 | (37.7366297052834, -122.398316233412) | ||
| 45600 | 45600 | 57691 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16595 | 6001759.0 | 2096663.0 | 37.7371367196384 | -122.436404416578 | (37.7371367196384, -122.436404416578) | |
| 34144 | 34144 | 71268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | ||
| 86882 | 86882 | 27082 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 98316 | 98316 | 41261 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 136 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41948 | 6003783.84120513 | 2096452.6287084 | 37.73667393521 | -122.429388624637 | (37.73667393521, -122.429388624637) | |||
| 11500 | 11500 | 66889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 562 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30203 | 6003132.96801 | 2090225.04515 | 37.7195375196183 | -122.43119459394899 | (37.7195375196183, -122.431194593949) | |
| 139865 | 139865 | 114669 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 176X Peralta Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | |||
| 82665 | 82665 | 39219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | |||
| 10789 | 10789 | 27116 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 431 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2000 12:00:00 AM | 3 | 3X3 | 6004280.51311 | 2093512.4294900002 | 37.7286289154695 | -122.42746201715599 | (37.7286289154695, -122.427462017156) | ||
| 11230 | 11230 | 27210 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2000 12:00:00 AM | 3 | 3X3 | 6003698.299930001 | 2093465.5644 | 37.728467287514206 | -122.42947142096901 | (37.7284672875142, -122.429471420969) | ||
| 84469 | 84469 | 33577 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.740956334538204 | -122.418288026055 | (37.7409563345382, -122.418288026055) | |||
| 101221 | 101221 | 33575 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 166 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37683 | 6007091.70402672 | 2098068.82881396 | 37.7412983853712 | -122.418066427995 | (37.7412983853712, -122.418066427995) | |||
| 121606 | 121606 | 53743 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 166 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37683 | 6007091.70402672 | 2098068.82881396 | 37.7412983853712 | -122.418066427995 | (37.7412983853712, -122.418066427995) | |||
| 10716 | 10716 | 27187 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 250 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 6 | 2X3 | 6002862.24087 | 2093754.97277 | 37.7292145657007 | -122.43238237894501 | (37.7292145657007, -122.432382378945) | ||
| 11557 | 11557 | 27528 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/25/2002 12:00:00 AM | 3 | 6008310.55132 | 2093825.05625 | 37.729714434952506 | -122.413551995327 | (37.7297144349525, -122.413551995327) | |||
| 14877 | 14877 | 27134 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1941 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 4 | 3X3 | 6011939.40312 | 2095757.43943 | 37.7352234533834 | -122.401142314262 | (37.7352234533834, -122.401142314262) | ||
| 98960 | 98960 | 33524 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37634 | 6007216.6223638 | 2097938.08467402 | 37.740946421126 | -122.417625238841 | (37.740946421126, -122.417625238841) | |||
| 103698 | 103698 | 33534 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37644 | 6007201.13991539 | 2097799.25218884 | 37.740564346758106 | -122.417668933754 | (37.7405643467581, -122.417668933754) | |||
| 103715 | 103715 | 33501 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37595 | 6006663.30728315 | 2098959.97627538 | 37.7437211553943 | -122.41961088786002 | (37.7437211553943, -122.41961088786) | ||
| 112296 | 112296 | 33525 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 188 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37635 | 6007199.10727987 | 2097905.4429638 | 37.7408558086436 | -122.417683486647 | (37.7408558086436, -122.417683486647) | |||
| 116395 | 116395 | 33543 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 225 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37651 | 6007131.02167651 | 2097668.57746319 | 37.7402015970519 | -122.417902115277 | (37.7402015970519, -122.417902115277) | |||
| 116738 | 116738 | 33527 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | 16 | Permit Number 37637 | 6007243.54484492 | 2097878.27946769 | 37.740783724234 | -122.41752791305001 | (37.740783724234, -122.41752791305) | ||
| 121375 | 121375 | 33526 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 196 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37636 | 6007164.07712738 | 2097840.15957198 | 37.7406745836679 | -122.417799981783 | (37.7406745836679, -122.417799981783) | ||
| 159023 | 159023 | 114552 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1121 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777071 | 6011681.54455 | 2103150.14548 | 37.7555078447183 | -122.402553516927 | (37.7555078447183, -122.402553516927) | ||
| 90190 | 90190 | 59352 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 469 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1980 12:00:00 AM | 11 | 4x4 | Permit Number 18701 | 5994737.99829015 | 2091686.56057322 | 37.7230711817022 | -122.460318578759 | (37.7230711817022, -122.460318578759) | |
| 114678 | 114678 | 56359 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 187 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32692 | 6002716.18242301 | 2104822.03495589 | 37.759593852181894 | -122.433677959685 | (37.7595938521819, -122.433677959685) | ||
| 95376 | 95376 | 45782 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 243 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2001 12:00:00 AM | Permit Number 44422 | 5992531.14944144 | 2097322.97472388 | 37.738420181663706 | -122.46835700549299 | (37.7384201816637, -122.468357005493) | |||
| 153875 | 153875 | 72840 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2634 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 5 | 5989285.167 | 2097358.0202 | 37.7383283873436 | -122.479582470664 | (37.7383283873436, -122.479582470664) | ||
| 100338 | 100338 | 33375 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37501 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.46864840809799 | (37.7330764284901, -122.468648408098) | |||
| 101974 | 101974 | 33374 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37501 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.46864840809799 | (37.7330764284901, -122.468648408098) | |||
| 131032 | 131032 | 33248 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2591 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37429 | 5987367.1404 | 2097667.8262 | 37.7390674308693 | -122.486236717873 | (37.7390674308693, -122.486236717873) |
| 153300 | 153300 | 33288 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.41336172668699 | (37.7925058062477, -122.413361726687) | |
| 171430 | 171430 | 30366 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694005 | -122.397947987108 | (37.756469231694, -122.397947987108) | |
| 7463 | 7463 | 52815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2760 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773616 | 6000112.35725 | 2118047.78661 | 37.7957603016641 | -122.44363337348999 | (37.7957603016641, -122.44363337349) | |
| 22702 | 22702 | 21528 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.829580001 | 2114935.40618 | 37.787560918141295 | -122.422279128893 | (37.7875609181413, -122.422279128893) | ||
| 98635 | 98635 | 32867 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37213 | 6001338.28217306 | 2101417.26764603 | 37.7501669020767 | -122.438199507309 | (37.7501669020767, -122.438199507309) | ||
| 188719 | 188719 | 53084 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 737 8TH & 9TH Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2006 12:00:00 AM | 2 | Permit Number 49051 | 6009184.03674 | 2110393.9636 | 37.7752579542298 | -122.411702510768 | (37.7752579542298, -122.411702510768) | ||
| 5901 | 5901 | 13142 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1799 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6003833.3629 | 2119660.0062 | 37.8003985594643 | -122.43087313241999 | (37.8003985594643, -122.43087313242) | ||
| 91508 | 91508 | 82031 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 471 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49837 | 5998319.05661716 | 2095227.73962292 | 37.7329997723608 | -122.448194494208 | (37.7329997723608, -122.448194494208) | ||
| 40165 | 40165 | 32579 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.763848120851705 | -122.49227291177401 | (37.7638481208517, -122.492272911774) | |
| 173464 | 173464 | 34932 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.785900071213604 | -122.442821815392 | (37.7859000712136, -122.442821815392) | ||
| 143953 | 143953 | 32519 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 845 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37021 | 6007591.14794748 | 2095436.54835454 | 37.734098820334 | -122.41615314248001 | (37.734098820334, -122.41615314248) | ||
| 4246 | 4246 | 252893 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4201 | 4201 | 252891 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:13:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4203 | 4203 | 252894 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:10:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4213 | 4213 | 252892 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4212 | 4212 | 204652 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:45:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.719375836806705 | -122.45192406695601 | (37.7193758368067, -122.451924066956) | ||
| 4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
| 185052 | 185052 | 32483 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 10 | Permit Number 36991 | 6001817.389140001 | 2106232.68155 | 37.763416104203 | -122.436887416735 | (37.763416104203, -122.436887416735) | |
| 4156 | 4156 | 213178 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 629 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:23:00 AM | 3 | Width 3ft | Permit Number 20774 | 5994856.22066 | 2090552.89382 | 37.7199652039099 | -122.45982783161502 | (37.7199652039099, -122.459827831615) | |
| 108607 | 108607 | 38681 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1725 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1998 12:00:00 AM | 3x3 | Permit Number 40598 | 5999507.78485898 | 2110823.62249875 | 37.775890130447294 | -122.445205652379 | (37.7758901304473, -122.445205652379) | |
| 95796 | 95796 | 32334 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | Permit Number 36897 | 6000779.60429895 | 2103438.99609434 | 37.7556862897816 | -122.440276412657 | (37.7556862897816, -122.440276412657) | |||
| 10857 | 10857 | 27206 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003601.03384 | 2093471.82188 | 37.7284789616114 | -122.429808120849 | (37.7284789616114, -122.429808120849) | ||
| 116288 | 116288 | 38652 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1276 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1998 12:00:00 AM | Permit Number 40574 | 5982148.09911045 | 2106418.94720672 | 37.762789987906 | -122.504929783979 | (37.762789987906, -122.504929783979) | |||
| 10673 | 10673 | 121353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.76417557031971 | -122.496596073864 | (37.7641755703197, -122.496596073864) | ||
| 79873 | 79873 | 45707 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.035480901 | 2103995.03426473 | 37.757130224218294 | -122.44533981581499 | (37.7571302242183, -122.445339815815) | |||
| 140779 | 140779 | 45706 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.035480901 | 2103995.03426473 | 37.757130224218294 | -122.44533981581499 | (37.7571302242183, -122.445339815815) | |||
| 90738 | 90738 | 48736 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553001 | (37.7355533009373, -122.39050541553) | ||
| 27384 | 27384 | 39767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.41541460189899 | (37.7836470686025, -122.415414601899) |
| 5538 | 5538 | 27609 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2000 12:00:00 AM | 3 | 3x3 | 6001941.56922 | 2115683.47507 | 37.7893726707572 | -122.437134613375 | (37.7893726707572, -122.437134613375) | ||
| 46438 | 46438 | 38557 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1511 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 12 | Permit Number 40522 | 6015824.3664 | 2095556.8722 | 37.7348887022439 | -122.38769646850001 | (37.7348887022439, -122.3876964685) | |
| 50086 | 50086 | 113271 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1321 Revere Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260.0 | 37.7286210040554 | -122.38509718743299 | (37.7286210040554, -122.385097187433) | ||||
| 115590 | 115590 | 63711 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 168 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 3x3 | Permit Number 776230 | 6007522.60556555 | 2100213.34826998 | 37.747211000323794 | -122.41672840745399 | (37.7472110003238, -122.416728407454) | ||
| 100533 | 100533 | 63555 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/2012 12:00:00 AM | Permit Number 768997 | 6008364.95764339 | 2103853.79348965 | 37.7572541841117 | -122.414073113457 | (37.7572541841117, -122.414073113457) | ||
| 162301 | 162301 | 67472 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 644 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 12 | Permit Number 30994 | 6012673.57761 | 2104437.3081900002 | 37.7590974455196 | -122.399213087719 | (37.7590974455196, -122.399213087719) | |
| 19179 | 19179 | 96019 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 91224 | 91224 | 96020 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 125086 | 125086 | 96018 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 131619 | 131619 | 96016 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884506996 | -122.41348521078999 | (37.788722884507, -122.41348521079) |
| 135943 | 135943 | 96017 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) |
| 103622 | 103622 | 48643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45936 | 5993334.71771315 | 2105415.01360696 | 37.7606852319988 | -122.466166570005 | (37.7606852319988, -122.466166570005) | ||
| 135995 | 135995 | 43888 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767585 | 6009068.61437 | 2110555.25783 | 37.775694354731606 | -122.412113186199 | (37.7756943547316, -122.412113186199) |
| 149504 | 149504 | 95866 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 32 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767584 | 6009326.62305 | 2109462.37063 | 37.7727080155855 | -122.411143450809 | (37.7727080155855, -122.411143450809) |
| 184805 | 184805 | 95843 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 30 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767866 | 6009338.07268 | 2109475.65364 | 37.7727451297231 | -122.411104783558 | (37.7727451297231, -122.411104783558) |
| 156878 | 156878 | 56952 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 795 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 7 | Permit Number 14204 | 5993489.41899 | 2110144.08424 | 37.7736789357713 | -122.465975170673 | (37.7736789357713, -122.465975170673) | ||
| 112096 | 112096 | 51290 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 738 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47662 | 5995079.16819472 | 2089446.39884805 | 37.716939850408394 | -122.458977110473 | (37.7169398504084, -122.458977110473) | |||
| 117199 | 117199 | 51289 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 875 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47661 | 5995029.72941729 | 2089837.87433116 | 37.718011907210204 | -122.45917632673999 | (37.7180119072102, -122.45917632674) | |||
| 115420 | 115420 | 68441 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 137 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 14 | Permit Number 32298 | 6009913.44601622 | 2099873.29602914 | 37.7464114730886 | -122.40843704647 | (37.7464114730886, -122.40843704647) |
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");