Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
16365 | 16365 | 27145 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011315.84096 | 2095284.6201400002 | 37.7338903847377 | -122.40326495802499 | (37.7338903847377, -122.403264958025) | ||
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) | |||
16407 | 16407 | 97995 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6013004.40763 | 2106156.2643 | 37.7638357521307 | -122.398189511757 | (37.7638357521307, -122.398189511757) | ||
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) | |||
17274 | 17274 | 22551 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 33 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 20 | 2X3 | 6001555.699019999 | 2098568.2188 | 37.74235645138 | -122.437243695762 | (37.74235645138, -122.437243695762) | ||
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) | |||
18373 | 18373 | 54772 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1446 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1972 12:00:00 AM | 4x5 | Permit Number 10621 | 5994307.43834186 | 2105670.05162948 | 37.7614415732371 | -122.46282089526899 | (37.7614415732371, -122.462820895269) | ||
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) | |||
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) | |
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) | |||
21278 | 21278 | 3458 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 58 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 20 | 3X3 | 5999628.35603 | 2099484.01235 | 37.7447612502235 | -122.443973626603 | (37.7447612502235, -122.443973626603) | ||
21641 | 21641 | 22552 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 39 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 20 | 2x3 | 6001599.33681 | 2098534.06318 | 37.7422651486201 | -122.43709036493 | (37.7422651486201, -122.43709036493) | ||
21739 | 21739 | 22825 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.44508467424299 | (37.7436157369876, -122.445084674243) | ||
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) | ||
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) | ||
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) | |||
26719 | 26719 | 44280 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.826330001 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | ||
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) | |||
27183 | 27183 | 48442 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 2 | 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) | |||
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) | |||
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) |
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) | |||
29332 | 29332 | 61172 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 346 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 11 | Permit Number 27084 | 5989366.0565 | 2113024.18126 | 37.781348145965296 | -122.480449215491 | (37.7813481459653, -122.480449215491) | |
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) | |||
32793 | 32793 | 67326 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 714 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 12 | Permit Number 30809 | 5993329.61616 | 2111427.9815700003 | 37.7771949529998 | -122.466621290245 | (37.7771949529998, -122.466621290245) | |
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) | |||
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) | ||
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) | |||
35176 | 35176 | 43892 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 6 | Permit Number 43498 | 6009086.19652 | 2110571.7349400003 | 37.7757405834934 | -122.412053529658 | (37.7757405834934, -122.412053529658) | ||
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) | |||
36392 | 36392 | 44281 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014169.386469999 | 2095432.395 | 37.734455100518 | -122.393409648353 | (37.734455100518, -122.393409648353) | ||
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) | |||
36944 | 36944 | 88065 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012481.79699 | 2096085.11316 | 37.7361534207291 | -122.399290043599 | (37.7361534207291, -122.399290043599) | |
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) | |||
38894 | 38894 | 50846 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 5 | Permit Number 47372 | 6003324.61709 | 2090530.54695 | 37.720387218868495 | -122.430553920527 | (37.7203872188685, -122.430553920527) | ||
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) | |||
39548 | 39548 | 72980 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.48504448823499 | (37.7550761133303, -122.485044488235) | ||
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) | |||
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) | |
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) | |||
41975 | 41975 | 65113 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.435380001 | 2112903.08855 | 37.781013182321104 | -122.480587794991 | (37.7810131823211, -122.480587794991) | |
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) | |||
42881 | 42881 | 78349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | ||
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) | |||
44057 | 44057 | 175774 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) |
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");