Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 181672 | 181672 | 198508 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 998 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6011865.97365 | 2103785.48158 | 37.757262632470606 | -122.401960360989 | (37.7572626324706, -122.401960360989) | |||
| 106640 | 106640 | 98271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 107595 | 107595 | 98272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | ||
| 109285 | 109285 | 98270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 118014 | 118014 | 98273 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 126904 | 126904 | 101710 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874.0 | 2103773.0 | 37.7572288087602 | -122.40193172517901 | (37.7572288087602, -122.401931725179) | ||
| 38828 | 38828 | 180542 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 990 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004004.09033 | 2090139.32192 | 37.7193514696869 | -122.42817733523 | (37.7193514696869, -122.42817733523) | |||
| 105440 | 105440 | 122758 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 99 Park Hill Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x5 | 6001111.0 | 2107407.0 | 37.766600319422004 | -122.439414765245 | (37.766600319422, -122.439414765245) | |||
| 149417 | 149417 | 242731 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 99 Park Hill Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001135.553669999 | 2107466.14024 | 37.7667641011975 | -122.43933407813101 | (37.7667641011975, -122.439334078131) | |||
| 3384 | 3384 | 242759 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 99 Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000876.8584 | 2105865.2464 | 37.7623537170769 | -122.440114051125 | (37.7623537170769, -122.440114051125) | |||
| 102344 | 102344 | 115732 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 99 ORD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 22 | 3x3 | 6000874.0 | 2105811.0 | 37.7622046070719 | -122.44012004716801 | (37.7622046070719, -122.440120047168) | ||
| 87102 | 87102 | 17494 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 98X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6001936.09269 | 2091434.7408900002 | 37.722791174441106 | -122.43541823832199 | (37.7227911744411, -122.435418238322) | |||
| 141057 | 141057 | 17493 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 98X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6001898.43212 | 2091454.2052 | 37.722842480127 | -122.435549814469 | (37.722842480127, -122.435549814469) | |||
| 14279 | 14279 | 85795 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 985 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 12 | 3x3 | 6011121.9774 | 2111644.9134 | 37.7788012938106 | -122.405086799447 | (37.7788012938106, -122.405086799447) | ||
| 16662 | 16662 | 105993 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6015232.0353 | 2104000.8036599997 | 37.758041149501096 | -122.39033415130501 | (37.7580411495011, -122.390334151305) | |||
| 40396 | 40396 | 97985 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6015230.10587 | 2104016.74085 | 37.7580848025885 | -122.39034193764499 | (37.7580848025885, -122.390341937645) | ||||
| 109035 | 109035 | 57076 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767819 | 6015234.40756552 | 2104029.6701639 | 37.7581205423321 | -122.39032796374501 | (37.7581205423321, -122.390327963745) | |
| 89026 | 89026 | 105992 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 MINNESOTA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6015221.1 | 2104017.4 | 37.758086112912004 | -122.39037313012 | (37.758086112912, -122.39037313012) | |||
| 28480 | 28480 | 198590 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013501.44813 | 2107135.10099 | 37.766551094088996 | -122.39653900576599 | (37.766551094089, -122.396539005766) | |||
| 42055 | 42055 | 198588 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013599.812609999 | 2107136.62549 | 37.766560753709 | -122.396198884879 | (37.766560753709, -122.396198884879) | |||
| 48814 | 48814 | 198592 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013452.45897 | 2107129.35079 | 37.766532578853 | -122.396708048633 | (37.766532578853, -122.396708048633) | |||
| 52763 | 52763 | 198591 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013476.96853 | 2107132.95858 | 37.766543849139204 | -122.39662352676399 | (37.7665438491392, -122.396623526764) | |||
| 59830 | 59830 | 198583 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013760.46871 | 2107146.56354 | 37.766596979302705 | -122.39564389615299 | (37.7665969793027, -122.395643896153) | |||
| 64547 | 64547 | 198587 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013654.04555 | 2107139.63113 | 37.7665720240075 | -122.396011512024 | (37.7665720240075, -122.396011512024) | |||
| 68611 | 68611 | 198586 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013678.519180001 | 2107141.48068 | 37.7665784640576 | -122.39592699106001 | (37.7665784640576, -122.39592699106) | |||
| 70687 | 70687 | 198589 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013524.37895 | 2107133.46335 | 37.766547873609994 | -122.396459576758 | (37.76654787361, -122.396459576758) | |||
| 77041 | 77041 | 198584 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013716.83628 | 2107143.63605 | 37.7665865138841 | -122.39579460903299 | (37.7665865138841, -122.395794609033) | |||
| 130589 | 130589 | 198582 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013779.59756 | 2107146.17602 | 37.766596979294704 | -122.395577705173 | (37.7665969792947, -122.395577705173) | |||
| 160966 | 160966 | 198581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013801.3988 | 2107146.90693 | 37.7666001988537 | -122.395502349162 | (37.7666001988537, -122.395502349162) | |||
| 188178 | 188178 | 198585 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013694.72301 | 2107142.03178 | 37.7665808787261 | -122.395870983078 | (37.7665808787261, -122.395870983078) | |||
| 147817 | 147817 | 198693 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 97 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6016661.34411 | 2095009.8516799998 | 37.733433020107 | -122.38476462199199 | (37.733433020107, -122.384764621992) | |||
| 166257 | 166257 | 198694 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 97 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6016624.01227 | 2094969.8217099998 | 37.733321041016104 | -122.38489090210899 | (37.7333210410161, -122.384890902109) | |||
| 16302 | 16302 | 85797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 969 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011197.4105 | 2111716.4639 | 37.779001971452395 | -122.40483088408399 | (37.7790019714524, -122.404830884084) | ||
| 16040 | 16040 | 57074 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 966 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 24 | 9x7.5 | Permit Number 14341 | 6015226.17172 | 2104099.64367 | 37.7583122177548 | -122.39036133601101 | (37.7583122177548, -122.390361336011) | |
| 55580 | 55580 | 41342 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 965 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | 4 | 3x3 | Permit Number 45442 | 6011232.3538 | 2111749.1886 | 37.77909377896079 | -122.40471230492099 | (37.7790937789608, -122.404712304921) |
| 43368 | 43368 | 66634 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 963 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2000 12:00:00 AM | 5 | 3x3 | Permit Number 29842 | 6010240.69544356 | 2103618.46143652 | 37.756713189996795 | -122.407569458435 | (37.7567131899968, -122.407569458435) |
| 47548 | 47548 | 242402 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 963 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010232.4769 | 2103605.5336599997 | 37.756677233172 | -122.407596969832 | (37.756677233172, -122.407596969832) | |||
| 16507 | 16507 | 85757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 960 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011195.1919 | 2111802.9901 | 37.7792394282463 | -122.404844652616 | (37.7792394282463, -122.404844652616) | ||
| 45912 | 45912 | 242593 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 960 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6000277.53945 | 2101991.5509200003 | 37.751683359019395 | -122.44190882273199 | (37.7516833590194, -122.441908822732) | |||
| 50126 | 50126 | 215570 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 96 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995600.39767 | 2096198.59734 | 37.7355097165874 | -122.457663772269 | (37.7355097165874, -122.457663772269) | |||
| 166774 | 166774 | 242781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 95x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.42209948031099 | (37.771601160584, -122.422099480311) | |||
| 34666 | 34666 | 57073 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.758419515877705 | -122.390379311651 | (37.7584195158777, -122.390379311651) | ||
| 14696 | 14696 | 85756 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 956 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011236.2364 | 2111841.2613 | 37.779346806168704 | -122.404705356954 | (37.7793468061687, -122.404705356954) | ||
| 33554 | 33554 | 242643 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 952 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007376.06475 | 2101722.46593 | 37.7513464531926 | -122.417342064 | (37.7513464531926, -122.417342064) | |||
| 35835 | 35835 | 242642 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 952 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007375.48933 | 2101738.08123 | 37.751389296887396 | -122.41734516035801 | (37.7513892968874, -122.417345160358) | |||
| 84600 | 84600 | 114012 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 952 CAPP ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 6007364.0 | 2101732.0 | 37.7513719527851 | -122.417384460989 | (37.7513719527851, -122.417384460989) | ||||
| 15095 | 15095 | 85799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 951 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011299.4671 | 2111813.5286 | 37.779274192475796 | -122.404484661651 | (37.7792741924758, -122.404484661651) | ||
| 73466 | 73466 | 242435 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 951 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6004408.4107 | 2103355.6712 | 37.7556634382295 | -122.427720909508 | (37.7556634382295, -122.427720909508) | |||
| 28363 | 28363 | 198495 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015477.3225 | 2104627.00235 | 37.7597741601603 | -122.389529568345 | (37.7597741601603, -122.389529568345) | |||
| 37220 | 37220 | 198494 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015476.06266 | 2104658.66701 | 37.759861034675104 | -122.389536136987 | (37.7598610346751, -122.389536136987) | |||
| 52042 | 52042 | 198493 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015474.58751 | 2104684.20174 | 37.7599310657768 | -122.389543022191 | (37.7599310657768, -122.389543022191) | |||
| 57127 | 57127 | 198496 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015478.89402 | 2104602.2091599996 | 37.759706170509205 | -122.389522401658 | (37.7597061705092, -122.389522401658) | |||
| 61711 | 61711 | 198497 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015478.44281 | 2104579.86448 | 37.759644791788396 | -122.389522401658 | (37.7596447917884, -122.389522401658) | |||
| 163612 | 163612 | 198492 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015469.84245 | 2104726.88605 | 37.7600480046386 | -122.389562414283 | (37.7600480046386, -122.389562414283) | |||
| 27464 | 27464 | 215498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993979.5407 | 2097285.08347 | 37.7383996933922 | -122.46334646239201 | (37.7383996933922, -122.463346462392) | |||
| 39846 | 39846 | 215499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993991.18061 | 2097202.58443 | 37.738173842158105 | -122.463300232714 | (37.7381738421581, -122.463300232714) | |||
| 184959 | 184959 | 215546 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993989.2635699995 | 2097198.82691 | 37.738163414500605 | -122.463306588246 | (37.7381634145006, -122.463306588246) | |||
| 184354 | 184354 | 242780 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 9ft | 6006179.77173 | 2109125.10938 | 37.7716049979898 | -122.422004807797 | (37.7716049979898, -122.422004807797) | |||
| 49109 | 49109 | 17607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 948X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003925.750010201 | 2090181.5613292998 | 37.719463016991504 | -122.42845113758601 | (37.7194630169915, -122.428451137586) | |||
| 13109 | 13109 | 17606 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 945X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004029.89293 | 2090169.1541 | 37.7194348422149 | -122.428090270065 | (37.7194348422149, -122.428090270065) | |||
| 10792 | 10792 | 17605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 937 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003999.6997 | 2090190.6100400002 | 37.7194920472054 | -122.428196165219 | (37.7194920472054, -122.428196165219) | |||
| 120892 | 120892 | 3749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 934 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012421.507139799 | 2103592.6632765 | 37.756764184951 | -122.40002555654199 | (37.756764184951, -122.400025556542) | |||
| 77338 | 77338 | 242772 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 930 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002452.7879800005 | 2102762.57285 | 37.753924114323894 | -122.434441659158 | (37.7539241143239, -122.434441659158) | |||
| 146335 | 146335 | 242771 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 930 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002454.1308 | 2102779.0218599997 | 37.753969355605896 | -122.434438191367 | (37.7539693556059, -122.434438191367) | |||
| 117986 | 117986 | 104772 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 930 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6002436.6 | 2102773.8 | 37.7539540224902 | -122.434498443618 | (37.7539540224902, -122.434498443618) | |||
| 142145 | 142145 | 104773 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 930 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002436.6 | 2102773.8 | 37.7539540224902 | -122.434498443618 | (37.7539540224902, -122.434498443618) | |||
| 49338 | 49338 | 242770 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 928 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002453.029680001 | 2102798.5166700003 | 37.7540228211998 | -122.434443393046 | (37.7540228211998, -122.434443393046) | |||
| 78176 | 78176 | 104771 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 928 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002435.2 | 2102798.9 | 37.7540228616298 | -122.43450507968299 | (37.7540228616298, -122.434505079683) | |||
| 24594 | 24594 | 115551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.39019037219299 | (37.7585616474178, -122.390190372193) | ||
| 155253 | 155253 | 115550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.39018178636199 | (37.7584697654838, -122.390181786362) | ||
| 180919 | 180919 | 115549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | ||
| 67400 | 67400 | 242769 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 922 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002452.60513 | 2102826.4857900003 | 37.754099593631295 | -122.43444686084999 | (37.7540995936313, -122.43444686085) | |||
| 65813 | 65813 | 180520 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6003878.6160699995 | 2090266.0202 | 37.71969225516521 | -122.42862007955799 | (37.7196922551652, -122.428620079558) | |||
| 160059 | 160059 | 180518 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003927.65212 | 2090238.59404 | 37.7196197239493 | -122.42844862563 | (37.7196197239493, -122.42844862563) | |||
| 174369 | 174369 | 180519 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 919 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6003897.75198 | 2090254.30542 | 37.719661171900796 | -122.42855309895701 | (37.7196611719008, -122.428553098957) | |||
| 15335 | 15335 | 57068 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 918 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 15 | 6x7 | Permit Number 14334 | 6015212.77238 | 2104346.7451400002 | 37.7589899621477 | -122.390424942382 | (37.7589899621477, -122.390424942382) | |
| 154074 | 154074 | 242768 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 918 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002453.76443 | 2102846.18378 | 37.7541537454185 | -122.434444259992 | (37.7541537454185, -122.434444259992) | |||
| 108400 | 108400 | 104769 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 918 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002432.5 | 2102848.2 | 37.7541580743967 | -122.43451794167801 | (37.7541580743967, -122.434517941678) | |||
| 122412 | 122412 | 104770 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 918 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002432.5 | 2102848.2 | 37.7541580743967 | -122.43451794167801 | (37.7541580743967, -122.434517941678) | |||
| 53852 | 53852 | 242681 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 915 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003786.92394 | 2102934.71001 | 37.7544724030869 | -122.429840181696 | (37.7544724030869, -122.429840181696) | |||
| 14290 | 14290 | 111683 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 915 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6x7 | 6015271.38469 | 2104348.4426599997 | 37.758997874376796 | -122.390222350301 | (37.7589978743768, -122.390222350301) | |||
| 27777 | 27777 | 112787 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 913 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6015266.54568 | 2104367.00121 | 37.7590485637711 | -122.390240382605 | (37.7590485637711, -122.390240382605) | |||
| 10537 | 10537 | 17602 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | |||
| 171377 | 171377 | 242767 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 912 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002452.815880001 | 2102860.93213 | 37.754194187024495 | -122.43444859472099 | (37.7541941870245, -122.434448594721) | |||
| 102518 | 102518 | 104768 | Private 5 | Ulmus parvifolia :: Chinese Elm 46 | 912 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6002431.1 | 2102873.8 | 37.7542282864134 | -122.43452461352699 | (37.7542282864134, -122.434524613527) | |||
| 2483 | 2483 | 201850 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 911 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6011602.0 | 2112119.0 | 37.7801298483764 | -122.403459565618 | (37.7801298483764, -122.403459565618) | |||
| 135988 | 135988 | 242371 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 10ft | 6006102.65154 | 2109126.4322 | 37.771604280331005 | -122.42227166541001 | (37.771604280331, -122.42227166541) | |||
| 138030 | 138030 | 242370 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6006121.14049 | 2109126.61017 | 37.7716058118802 | -122.422207723609 | (37.7716058118802, -122.422207723609) | |||
| 154128 | 154128 | 198491 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 907 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6015266.772030001 | 2104421.22514 | 37.7591974636091 | -122.39024338811599 | (37.7591974636091, -122.390243388116) | |||
| 34676 | 34676 | 242606 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 906 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997226.54796 | 2107348.00991 | 37.7662165183906 | -122.45284607618099 | (37.7662165183906, -122.452846076181) | |||
| 89129 | 89129 | 17601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 901X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x3 | 6003845.6513541 | 2090290.9535450002 | 37.719758851010496 | -122.42873580329399 | (37.7197588510105, -122.428735803294) | |||
| 109093 | 109093 | 17600 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 901X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6003845.6513541 | 2090290.9535450002 | 37.719758851010496 | -122.42873580329399 | (37.7197588510105, -122.428735803294) | |||
| 144473 | 144473 | 17599 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 901X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6003845.6513541 | 2090290.9535450002 | 37.719758851010496 | -122.42873580329399 | (37.7197588510105, -122.428735803294) | |||
| 71159 | 71159 | 84446 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6000457.5617 | 2112125.7689 | 37.77951966026271 | -122.442013625663 | (37.7795196602627, -122.442013625663) | |||
| 81725 | 81725 | 87967 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51002 | 6000425.8 | 2112036.7 | 37.779273289788605 | -122.442117107328 | (37.7792732897886, -122.442117107328) | ||
| 30111 | 30111 | 198501 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | ||||
| 183804 | 183804 | 198502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012462.6007 | 2103568.62023 | 37.75670045906929 | -122.399881750743 | (37.7567004590693, -122.399881750743) | ||||
| 111950 | 111950 | 114306 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997219.0 | 2107398.0 | 37.7663533458689 | -122.45287579158399 | (37.7663533458689, -122.452875791584) | ||||
| 12044 | 12044 | 17598 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003858.866640001 | 2090228.3157 | 37.719587609170006 | -122.42868565992399 | (37.71958760917, -122.428685659924) | |||
| 44745 | 44745 | 198486 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6015201.9775 | 2104548.15133 | 37.7595423814855 | -122.390476349396 | (37.7595423814855, -122.390476349396) |
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");