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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 43 | 43 | 222539 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002564.39948 | 2099984.1142599997 | 37.7463014588556 | -122.433857099823 | (37.7463014588556, -122.433857099823) | |||
| 66 | 66 | 222538 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.43388469462201 | (37.746271638232, -122.433884694622) | |||
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 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) | ||||
| 2839 | 2839 | 253221 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6010428.10303 | 2093767.62468 | 37.729675416078294 | -122.406227307752 | (37.7296754160783, -122.406227307752) | ||||
| 3320 | 3320 | 56733 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | |||
| 4849 | 4849 | 253684 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009074.0 | 2092682.0 | 37.7266186845557 | -122.410831962563 | (37.7266186845557, -122.410831962563) | ||||
| 5700 | 5700 | 107235 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.788699385205796 | -122.413257820814 | (37.7886993852058, -122.413257820814) | |||
| 5851 | 5851 | 9507 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.42604476220501 | (37.7802522713917, -122.426044762205) | |||
| 8678 | 8678 | 26493 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 519 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004978.6865 | 2110816.0585 | 37.776180120030205 | -122.42627984394699 | (37.7761801200302, -122.426279843947) | |||
| 9360 | 9360 | 3447 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 26 Cameo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999491.3304257 | 2099768.5267533 | 37.7455346409258 | -122.44446787703998 | (37.7455346409258, -122.44446787704) | |||
| 10112 | 10112 | 5081 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2562 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6002249.017000001 | 2096934.71698 | 37.737910623162705 | -122.434729631968 | (37.7379106231627, -122.434729631968) | |||
| 10145 | 10145 | 173881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996703.0 | 2107106.0 | 37.7655220059747 | -122.45463943175601 | (37.7655220059747, -122.454639431756) | ||||
| 13269 | 13269 | 187626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 298x Molimo Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5997428.0 | 2096652.0 | 37.7368594694916 | -122.451377782024 | (37.7368594694916, -122.451377782024) | ||||
| 13750 | 13750 | 96932 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011002.04218 | 2094782.5630700001 | 37.732494311353506 | -122.404314536086 | (37.7324943113535, -122.404314536086) | |||
| 13770 | 13770 | 96936 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010967.89306 | 2094873.35668 | 37.732741703157394 | -122.404438986978 | (37.7327417031574, -122.404438986978) | |||
| 14841 | 14841 | 96934 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010990.76512 | 2094811.6628299998 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | |||
| 14985 | 14985 | 97996 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012957.391559999 | 2106153.16264 | 37.7638246167349 | -122.398351909517 | (37.7638246167349, -122.398351909517) | |||
| 15038 | 15038 | 101157 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x5 | 6013434.11839 | 2105245.8196900003 | 37.7613597971466 | -122.396639434871 | (37.7613597971466, -122.396639434871) | |||
| 15120 | 15120 | 101159 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.39680143245701 | (37.7613518552239, -122.396801432457) | |||
| 15147 | 15147 | 96937 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010960.45235 | 2094890.17175 | 37.732787457976706 | -122.40446589470699 | (37.7327874579767, -122.404465894707) | |||
| 15602 | 15602 | 101156 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013453.7614400005 | 2105247.5910900002 | 37.7613657542352 | -122.39657162148501 | (37.7613657542352, -122.396571621485) | |||
| 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) | |||
| 16389 | 16389 | 96935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | |||
| 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) | |||
| 17603 | 17603 | 10401 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1360 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999635.0074 | 2108810.0697 | 37.770368686739396 | -122.44462080278 | (37.7703686867394, -122.44462080278) | |||
| 17698 | 17698 | 2244 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 15X Brompton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002231.00143 | 2095678.63178 | 37.7344606799209 | -122.43470212621901 | (37.7344606799209, -122.434702126219) | |||
| 18107 | 18107 | 4392 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.734535279584605 | -122.43647449840799 | (37.7345352795846, -122.436474498408) | |||
| 18758 | 18758 | 4194 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004745.48765 | 2100483.94122 | 37.7477973974515 | -122.4263507348 | (37.7477973974515, -122.4263507348) | |||
| 19209 | 19209 | 7446 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008276.38457 | 2103575.68647 | 37.7564855903503 | -122.414359757402 | (37.7564855903503, -122.414359757402) | |||
| 19229 | 19229 | 4867 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 35 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6000770.192869999 | 2098181.8906900003 | 37.7412510011371 | -122.43993203733 | (37.7412510011371, -122.43993203733) | |||
| 20085 | 20085 | 4237 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4018 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003765.90932 | 2100430.48709 | 37.747595203776 | -122.429734255035 | (37.747595203776, -122.429734255035) | |||
| 21100 | 21100 | 4336 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 870 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001641.12667 | 2095893.9772400002 | 37.7350184628259 | -122.436756924204 | (37.7350184628259, -122.436756924204) | |||
| 23457 | 23457 | 221362 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) | |||
| 24046 | 24046 | 222589 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4384 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000100.50643 | 2105785.88471 | 37.762091580878604 | -122.44279345615601 | (37.7620915808786, -122.442793456156) | |||
| 24143 | 24143 | 221342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 211 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005048.208 | 2100165.37235 | 37.7469397877337 | -122.425281276331 | (37.7469397877337, -122.425281276331) | |||
| 24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
| 24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
| 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) | |||
| 25360 | 25360 | 188327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.754856873149706 | -122.398083326981 | (37.7548568731497, -122.398083326981) | |||
| 25555 | 25555 | 175783 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.729062833884605 | -122.419916279827 | (37.7290628338846, -122.419916279827) | |||
| 25966 | 25966 | 204670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999483.78605 | 2094717.6896400002 | 37.7316658109241 | -122.44413109610001 | (37.7316658109241, -122.4441310961) | |||
| 26245 | 26245 | 204609 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1382 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990541.2449199995 | 2105988.9613 | 37.7620995740555 | -122.475869749413 | (37.7620995740555, -122.475869749413) | |||
| 26495 | 26495 | 188354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1341 Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017148.15295 | 2095467.55143 | 37.73471668451 | -122.383113415457 | (37.73471668451, -122.383113415457) | |||
| 27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) | |||
| 27101 | 27101 | 124082 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3220 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993384.863369999 | 2110069.41246 | 37.773467874758296 | -122.466331413768 | (37.7734678747583, -122.466331413768) | |||
| 27115 | 27115 | 175782 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.729089224484795 | -122.419690364741 | (37.7290892244848, -122.419690364741) | |||
| 27371 | 27371 | 222562 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 190 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007642.65731 | 2100277.00661 | 37.747392543349704 | -122.416317784757 | (37.7473925433497, -122.416317784757) | |||
| 28171 | 28171 | 221347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009327.08226 | 2096770.42354 | 37.7378588087266 | -122.41024559558001 | (37.7378588087266, -122.41024559558) | |||
| 28362 | 28362 | 222576 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 471 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003000.71138 | 2105505.41806 | 37.7614863982993 | -122.432742735495 | (37.7614863982993, -122.432742735495) | |||
| 28372 | 28372 | 204655 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 452 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.46529981143298 | (37.7188834957636, -122.465299811433) | |||
| 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) | |||
| 28542 | 28542 | 204628 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5992344.57273 | 2095377.42888 | 37.733067423224 | -122.46886055298701 | (37.733067423224, -122.468860552987) | |||
| 29109 | 29109 | 222592 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 352 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003592.38415 | 2108668.4276900003 | 37.7702047958459 | -122.43092212997699 | (37.7702047958459, -122.430922129977) | |||
| 29365 | 29365 | 222548 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 191 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007220.93745 | 2097850.24968 | 37.740705488567706 | -122.417604094958 | (37.7407054885677, -122.417604094958) | |||
| 29847 | 29847 | 125882 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2100 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005138.856380001 | 2116964.61432 | 37.7930715805281 | -122.42616360296302 | (37.7930715805281, -122.426163602963) | |||
| 30100 | 30100 | 188310 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.658530001 | 2106249.7856099997 | 37.764087318611395 | -122.39852032646499 | (37.7640873186114, -122.398520326465) | |||
| 30579 | 30579 | 175758 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012839.87945 | 2087571.5634599999 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | ||||
| 30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
| 30793 | 30793 | 141963 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 841 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004850.8791 | 2111736.5633 | 37.7787003755045 | -122.42678753375401 | (37.7787003755045, -122.426787533754) | |||
| 31017 | 31017 | 222574 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 382 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003928.91308 | 2102165.887 | 37.752369435600706 | -122.429294326484 | (37.7523694356007, -122.429294326484) | |||
| 31367 | 31367 | 204614 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | |||
| 31738 | 31738 | 221360 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999311.904680001 | 2104005.96159 | 37.757159364222495 | -122.44539292943399 | (37.7571593642225, -122.445392929434) | |||
| 31785 | 31785 | 124081 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3220 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993396.8995199995 | 2110067.15404 | 37.7734623682136 | -122.46628961516399 | (37.7734623682136, -122.466289615164) | |||
| 32358 | 32358 | 204636 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 181 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 1ft | 5998882.21711 | 2093801.6387 | 37.729116213139704 | -122.446144964113 | (37.7291162131397, -122.446144964113) | |||
| 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) | |||
| 32795 | 32795 | 204648 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 733 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5995892.41562 | 2089491.7886299998 | 37.71711119551271 | -122.456169405709 | (37.7171111955127, -122.456169405709) | |||
| 32947 | 32947 | 222552 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 188 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007202.63127 | 2097897.94559 | 37.740835420825206 | -122.417670770702 | (37.7408354208252, -122.417670770702) | |||
| 33110 | 33110 | 244217 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 516 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998006.3233 | 2108756.3922 | 37.770128230531895 | -122.450250525647 | (37.7701282305319, -122.450250525647) | |||
| 33225 | 33225 | 188311 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | |||
| 33995 | 33995 | 244917 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1350 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999690.9856 | 2108819.5575 | 37.7703979319451 | -122.444427856782 | (37.7703979319451, -122.444427856782) | |||
| 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) | |||
| 34236 | 34236 | 188300 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791001 | (37.7728541761188, -122.41480452791) | |||
| 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) | |||
| 34559 | 34559 | 175753 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 755 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6000826.82092 | 2089512.30625 | 37.7174495420436 | -122.439115030257 | (37.7174495420436, -122.439115030257) | ||||
| 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) | |||
| 35293 | 35293 | 204639 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 185 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998393.85271 | 2093179.60638 | 37.7273803570158 | -122.44778850934401 | (37.7273803570158, -122.447788509344) | ||||
| 35460 | 35460 | 188321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.29279 | 2103681.1367599997 | 37.757023433506 | -122.399019199302 | (37.757023433506, -122.399019199302) | |||
| 35496 | 35496 | 204653 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 131 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.61668 | 2090064.78105 | 37.718425920692795 | -122.47171971360599 | (37.7184259206928, -122.471719713606) | |||
| 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) | |||
| 37729 | 37729 | 247042 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6002114.968169999 | 2099165.77298 | 37.7440289718731 | -122.43535264990601 | (37.7440289718731, -122.435352649906) | ||||
| 37998 | 37998 | 221341 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 217 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005002.96321 | 2100161.85612 | 37.7469275767478 | -122.42543747867201 | (37.7469275767478, -122.425437478672) | |||
| 38034 | 38034 | 188335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | |||
| 38265 | 38265 | 222573 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3917 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003673.95782 | 2101843.15091 | 37.7514688410299 | -122.43015298120301 | (37.7514688410299, -122.430152981203) | |||
| 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) | |||
| 38724 | 38724 | 204643 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995381.41136 | 2092014.7979700002 | 37.7240094335681 | -122.458118187113 | (37.7240094335681, -122.458118187113) | |||
| 38900 | 38900 | 222499 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 301 Webster St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004137.32896 | 2109855.92191 | 37.7734962273111 | -122.429121852705 | (37.7734962273111, -122.429121852705) | |||
| 39326 | 39326 | 221354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008383.52326 | 2103860.65415 | 37.7572740646699 | -122.41400939143601 | (37.7572740646699, -122.414009391436) | |||
| 39974 | 39974 | 188355 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017230.94644 | 2095282.0098400002 | 37.7342117988404 | -122.38281425956998 | (37.7342117988404, -122.38281425957) | |||
| 40087 | 40087 | 125883 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008823.04151 | 2115295.3212900003 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | |||
| 40334 | 40334 | 222553 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007213.79342 | 2097921.72013 | 37.740901328538996 | -122.417633860722 | (37.740901328539, -122.417633860722) | |||
| 41275 | 41275 | 188305 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 635 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015454.10981 | 2106058.18427 | 37.7637025904139 | -122.389709812266 | (37.7637025904139, -122.389709812266) | |||
| 41434 | 41434 | 175767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | ||||
| 41763 | 41763 | 222502 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005857.93432 | 2106390.78551 | 37.764079039426704 | -122.42292369548599 | (37.7640790394267, -122.422923695486) | |||
| 41865 | 41865 | 204668 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997569.23018 | 2095279.46651 | 37.7330989075946 | -122.45079055604499 | (37.7330989075946, -122.450790556045) | |||
| 41982 | 41982 | 188330 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 214 Texas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013707.236830001 | 2106019.4851599997 | 37.763499309471506 | -122.395749036807 | (37.7634993094715, -122.395749036807) | |||
| 42503 | 42503 | 204633 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998410.37704 | 2094369.2089900002 | 37.7306476704498 | -122.447816990888 | (37.7306476704498, -122.447816990888) | |||
| 43337 | 43337 | 204651 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 27 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.45097974552401 | (37.7179774953307, -122.450979745524) |
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");