Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40 | 40 | 222540 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002573.08856 | 2099992.67614 | 37.74632546084511 | -122.433827665916 | (37.7463254608451, -122.433827665916) | |||
| 2817 | 2817 | 253222 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 3796 | 3796 | 182316 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2726 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986380.5744 | 2105064.6172 | 37.759319468361 | -122.490191716108 | (37.759319468361, -122.490191716108) | |
| 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) | ||
| 9446 | 9446 | 10864 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/1993 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 10985 | 10985 | 27196 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 3 | 3X3 | 6003338.54684 | 2093501.7358400002 | 37.7285462309168 | -122.430717685294 | (37.7285462309168, -122.430717685294) | ||
| 13832 | 13832 | 27154 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011126.61874 | 2095085.7194599998 | 37.7333336755986 | -122.403905168305 | (37.7333336755986, -122.403905168305) | ||
| 15016 | 15016 | 27146 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011294.03802 | 2095268.15566 | 37.7338439590333 | -122.403339179952 | (37.7338439590333, -122.403339179952) | ||
| 15299 | 15299 | 27175 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013102.951669999 | 2096377.5356599998 | 37.736990951255706 | -122.397162941913 | (37.7369909512557, -122.397162941913) | ||
| 16317 | 16317 | 101158 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x5 | 6013408.6905 | 2105245.2503299997 | 37.7613568185891 | -122.396727339995 | (37.7613568185891, -122.396727339995) | |||
| 16570 | 16570 | 96933 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010997.56747 | 2094792.1485099997 | 37.7325203809043 | -122.40433068074101 | (37.7325203809043, -122.404330680741) | |||
| 21303 | 21303 | 30742 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004180.58298 | 2109863.27384 | 37.7735188623338 | -122.428972754992 | (37.7735188623338, -122.428972754992) |
| 22257 | 22257 | 125 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1032 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1990 12:00:00 AM | 18 | 3X3 | 6002008.22654 | 2107658.0827 | 37.767340750994 | -122.436329391899 | (37.767340750994, -122.436329391899) | ||
| 24896 | 24896 | 204623 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1880 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993786.05175 | 2102711.73048 | 37.7532887441949 | -122.46440934321801 | (37.7532887441949, -122.464409343218) | |||
| 25248 | 25248 | 188298 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | |||
| 28539 | 28539 | 188302 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | |||
| 32397 | 32397 | 125884 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008808.31826 | 2115292.9035099996 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | |||
| 34214 | 34214 | 188320 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | |||
| 34558 | 34558 | 188318 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2000 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012048.56124 | 2104706.10168 | 37.759800640718005 | -122.401393594734 | (37.759800640718, -122.401393594734) | |||
| 34992 | 34992 | 222570 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4308 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001844.3062 | 2101201.08908 | 37.7496020939667 | -122.43643417821698 | (37.7496020939667, -122.436434178217) | |||
| 36933 | 36933 | 244274 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 470 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004329.9355 | 2109813.5769 | 37.7733908594087 | -122.42845257964501 | (37.7733908594087, -122.428452579645) | |||
| 38282 | 38282 | 188358 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017132.819619999 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | |||
| 45649 | 45649 | 221353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3181 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007743.59292 | 2102655.4048200003 | 37.7539287629281 | -122.41613717119199 | (37.7539287629281, -122.416137171192) | |||
| 47579 | 47579 | 204671 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999561.20485 | 2094716.8073599997 | 37.7316678047194 | -122.443863381386 | (37.7316678047194, -122.443863381386) | |||
| 51006 | 51006 | 221351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006363.61838 | 2105832.54053 | 37.7625747506491 | -122.421135037456 | (37.7625747506491, -122.421135037456) | |||
| 55954 | 55954 | 49814 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.758281874620295 | -122.400097759826 | (37.7582818746203, -122.400097759826) | |
| 58207 | 58207 | 204627 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992327.28359 | 2095380.5803 | 37.7330750773552 | -122.46892055484301 | (37.7330750773552, -122.468920554843) | |||
| 61227 | 61227 | 140862 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996243.3642 | 2113769.3144 | 37.783791348572706 | -122.456711139169 | (37.7837913485727, -122.456711139169) | |||
| 61563 | 61563 | 247044 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002079.830030001 | 2099170.11996 | 37.74403891207071 | -122.43547446040199 | (37.7440389120707, -122.435474460402) | |||
| 65839 | 65839 | 36807 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 8 | Permit Number 39531 | 6014713.4944 | 2091220.9181 | 37.722921447771604 | -122.39123418192699 | (37.7229214477716, -122.391234181927) | |
| 68710 | 68710 | 188336 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.39704756789101 | (37.7613339848017, -122.397047567891) | |||
| 69711 | 69711 | 43893 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009099.28139 | 2110583.2527799997 | 37.7757729429148 | -122.41200907978201 | (37.7757729429148, -122.412009079782) | ||
| 70747 | 70747 | 222579 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002709.09948 | 2104829.71069 | 37.7596145259996 | -122.43370300460501 | (37.7596145259996, -122.433703004605) | |||
| 75566 | 75566 | 188350 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Dukes Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016183.298880001 | 2096350.88685 | 37.7370887822104 | -122.386510848195 | (37.7370887822104, -122.386510848195) | |||
| 79362 | 79362 | 47227 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | ||
| 82096 | 82096 | 116726 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180X PERALTA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009777.0 | 2100122.0 | 37.7470867174475 | -122.408926407614 | (37.7470867174475, -122.408926407614) | ||||
| 86916 | 86916 | 30739 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 90638 | 90638 | 111230 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1113 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
| 91385 | 91385 | 102872 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | ||||
| 92439 | 92439 | 10887 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1270X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | ||
| 92699 | 92699 | 97048 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | |||
| 98121 | 98121 | 47220 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 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) | |||
| 102452 | 102452 | 38105 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 111092 | 111092 | 103509 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 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) | ||
| 113526 | 113526 | 101605 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180X Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | |||
| 117917 | 117917 | 120155 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 187 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002716.18242301 | 2104822.03495589 | 37.759593852181894 | -122.433677959685 | (37.7595938521819, -122.433677959685) | ||||
| 120383 | 120383 | 95412 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 122819 | 122819 | 27088 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006210.7557 | 2093597.31773 | 37.728970984710294 | -122.42079506833099 | (37.7289709847103, -122.420795068331) | ||
| 123646 | 123646 | 110722 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | |||||
| 124160 | 124160 | 116349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 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) | |
| 127539 | 127539 | 30676 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1040 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.77341300719829 | -122.417256559972 | (37.7734130071983, -122.417256559972) |
| 128725 | 128725 | 109380 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 725X BURNETT AVE | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999257.1 | 2101645.9 | 37.7506760851616 | -122.44541277185499 | (37.7506760851616, -122.445412771855) | |||||
| 132822 | 132822 | 188306 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 635 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6015455.75158 | 2106081.00048 | 37.7637653298293 | -122.38970572753999 | (37.7637653298293, -122.38970572754) | |||
| 133233 | 133233 | 175763 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011100.65099 | 2092002.25417 | 37.724865672709605 | -122.40377805363 | (37.7248656727096, -122.40377805363) | |||
| 136971 | 136971 | 175757 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Vienna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003296.85898 | 2090487.74665 | 37.7202681261541 | -122.43064681870199 | (37.7202681261541, -122.430646818702) | |||
| 137701 | 137701 | 175778 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004138.179280001 | 2091770.31166 | 37.7238373950554 | -122.427829991858 | (37.7238373950554, -122.427829991858) | |||
| 137884 | 137884 | 221328 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 178 Peralta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009834.372719999 | 2100044.46783 | 37.7468770447458 | -122.40872254780399 | (37.7468770447458, -122.408722547804) | |||
| 139807 | 139807 | 43895 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 714 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2000 12:00:00 AM | Permit Number 43499 | 6009277.55531704 | 2110532.12490079 | 37.7756425583487 | -122.41138877012399 | (37.7756425583487, -122.411388770124) | |||
| 144559 | 144559 | 48440 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | |||
| 145034 | 145034 | 47724 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2015 12:00:00 AM | 3 | Permit Number 774851 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | ||
| 146237 | 146237 | 41633 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42113 | 5996241.92564567 | 2113793.75965037 | 37.7838583861175 | -122.456717884501 | (37.7838583861175, -122.456717884501) | |||
| 155530 | 155530 | 221343 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 24 Alma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998466.64161 | 2106282.9763 | 37.7633631889881 | -122.448480141942 | (37.7633631889881, -122.448480141942) | |||
| 155718 | 155718 | 188291 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009385.19996 | 2109515.63966 | 37.772857564751206 | -122.410944589137 | (37.7728575647512, -122.410944589137) | |||
| 162540 | 162540 | 188351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017067.0525 | 2095737.1486900002 | 37.7354524630578 | -122.383412571329 | (37.7354524630578, -122.383412571329) | |||
| 164398 | 164398 | 188287 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010207.19158 | 2110684.55446 | 37.776113191502496 | -122.408183667747 | (37.7761131915025, -122.408183667747) | |||
| 164499 | 164499 | 204646 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994133.91606 | 2090657.47285 | 37.7202107871682 | -122.462332152117 | (37.7202107871682, -122.462332152117) | |||
| 167180 | 167180 | 188340 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2080 Silver Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012583.4784699995 | 2096093.4959599997 | 37.7361821046275 | -122.39893907508801 | (37.7361821046275, -122.398939075088) | |||
| 167487 | 167487 | 181677 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2704 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987307.2214 | 2106457.8989 | 37.7631991100618 | -122.48708929014799 | (37.7631991100618, -122.487089290148) | |||
| 172887 | 172887 | 221363 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001383.2027 | 2099881.79885 | 37.745953424815504 | -122.43793420150699 | (37.7459534248155, -122.437934201507) | |||
| 175317 | 175317 | 188295 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 3 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.771047726812604 | -122.41517858743799 | (37.7710477268126, -122.415178587438) | |||
| 176001 | 176001 | 175793 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009507.12766 | 2093386.74095 | 37.7285780309381 | -122.409384362505 | (37.7285780309381, -122.409384362505) | |||
| 176762 | 176762 | 175785 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006201.21806 | 2093598.82119 | 37.7289745752989 | -122.420828147413 | (37.7289745752989, -122.420828147413) | |||
| 180340 | 180340 | 139382 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1480 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000715.5797 | 2113708.6945 | 37.7838806688155 | -122.441234638662 | (37.7838806688155, -122.441234638662) | |||
| 181394 | 181394 | 125880 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998726.98974 | 2113474.62388 | 37.783124495049 | -122.448097535281 | (37.783124495049, -122.448097535281) | |||
| 184588 | 184588 | 175788 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008132.91971 | 2093497.9491400002 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | |||
| 188602 | 188602 | 204669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997556.3797699995 | 2095278.95948 | 37.7330967797945 | -122.45083494657 | (37.7330967797945, -122.45083494657) |
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");