Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2997 | 2997 | 246011 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 609 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1988 12:00:00 AM | 8 | Width 0ft | Permit Number 25501 | 5998952.4081 | 2108635.9977 | 37.7698517546883 | -122.446969376408 | (37.7698517546883, -122.446969376408) | |
11500 | 11500 | 66889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 562 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30203 | 6003132.96801 | 2090225.04515 | 37.7195375196183 | -122.43119459394899 | (37.7195375196183, -122.431194593949) | |
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) | |||
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) | |||
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) | |||
45600 | 45600 | 57691 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16595 | 6001759.0 | 2096663.0 | 37.7371367196384 | -122.436404416578 | (37.7371367196384, -122.436404416578) | |
53675 | 53675 | 222572 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 524 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002965.6945400005 | 2102138.50273 | 37.7522396670301 | -122.432623334298 | (37.7522396670301, -122.432623334298) | |||
53683 | 53683 | 125881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2101 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001760.22052 | 2119747.88013 | 37.8005221579273 | -122.438053316704 | (37.8005221579273, -122.438053316704) | |||
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) | |||
61407 | 61407 | 222582 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 193 Diamond St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001750.8913900005 | 2104845.17495 | 37.759602569523395 | -122.437018068443 | (37.7596025695234, -122.437018068443) | |||
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) | |
67811 | 67811 | 42713 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1740 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42726 | 6014522.39227 | 2095210.25322 | 37.7338647513416 | -122.392173650716 | (37.7338647513416, -122.392173650716) | |
67823 | 67823 | 246058 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 610 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997562.1198 | 2108443.0956 | 37.769242567665295 | -122.451764409004 | (37.7692425676653, -122.451764409004) | |||
69023 | 69023 | 221356 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008902.61993 | 2103693.2247900004 | 37.7568434827621 | -122.412202312603 | (37.7568434827621, -122.412202312603) | |||
70295 | 70295 | 221361 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 118 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004573.07294 | 2095957.02532 | 37.7353577716318 | -122.426624626942 | (37.7353577716318, -122.426624626942) | |||
71944 | 71944 | 204615 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1255 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990928.50457 | 2105165.0384299997 | 37.7598597468563 | -122.474470250504 | (37.7598597468563, -122.474470250504) | |||
73411 | 73411 | 188359 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1334 Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017127.7114699995 | 2095678.22784 | 37.735294030402706 | -122.383198748549 | (37.7352940304027, -122.383198748549) | |||
75863 | 75863 | 221326 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005468.19863 | 2101476.92488 | 37.7505647282985 | -122.423922233444 | (37.7505647282985, -122.423922233444) | |||
84820 | 84820 | 103510 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
85326 | 85326 | 106091 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 HUDSON AVE | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6017390.0 | 2095089.0 | 37.733690618402704 | -122.382250932174 | (37.7336906184027, -122.382250932174) | |||
87700 | 87700 | 100152 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002933.4 | 2105264.1 | 37.760819979332105 | -122.432958296422 | (37.7608199793321, -122.432958296422) | |||
92027 | 92027 | 103511 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
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) | |||
98916 | 98916 | 100147 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3955 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003272.0 | 2105332.0 | 37.761025616168396 | -122.431792078279 | (37.7610256161684, -122.431792078279) | |||
100453 | 100453 | 27079 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1999 12:00:00 AM | 8 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
109764 | 109764 | 97047 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1590X Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6014988.7 | 2094146.3 | 37.7309692313217 | -122.39048715342 | (37.7309692313217, -122.39048715342) | |||
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) | |||
114447 | 114447 | 52659 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280508999 | (37.8056520959413, -122.44242280509) | ||
121213 | 121213 | 103508 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
128766 | 128766 | 103507 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
129952 | 129952 | 222505 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3632 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005354.298280001 | 2105491.7389599998 | 37.7615820394108 | -122.424601669449 | (37.7615820394108, -122.424601669449) | |||
130006 | 130006 | 204640 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998733.11218 | 2093060.00406 | 37.7270713418516 | -122.446607092452 | (37.7270713418516, -122.446607092452) | |||
131290 | 131290 | 204620 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993064.41106 | 2105672.78897 | 37.7613774166458 | -122.467120173251 | (37.7613774166458, -122.467120173251) | |||
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) | |||
134787 | 134787 | 222503 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6006973.91003 | 2107833.94781 | 37.7681045308268 | -122.41916622906099 | (37.7681045308268, -122.419166229061) | |||
136161 | 136161 | 188344 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012532.5163 | 2096115.8290099998 | 37.7362405866356 | -122.39911684046301 | (37.7362405866356, -122.399116840463) | |||
137747 | 137747 | 204626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992297.08253 | 2095382.05199 | 37.7330773733083 | -122.46902507404499 | (37.7330773733083, -122.469025074045) | |||
139018 | 139018 | 111080 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2811 14TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5992341.0 | 2097126.0 | 37.737868354045204 | -122.469000113007 | (37.7378683540452, -122.469000113007) | |||
147256 | 147256 | 222554 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 166 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007158.63327 | 2098165.90408 | 37.7415686992375 | -122.417841889206 | (37.7415686992375, -122.417841889206) | |||
150799 | 150799 | 175784 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6006219.087180001 | 2093598.2968400002 | 37.7289741427237 | -122.420766335217 | (37.7289741427237, -122.420766335217) | |||
150994 | 150994 | 222580 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 187 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002705.73544 | 2104848.45932 | 37.7596658143394 | -122.433715979125 | (37.7596658143394, -122.433715979125) | |||
152106 | 152106 | 204613 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5991174.12963 | 2105607.5581900002 | 37.7610890166517 | -122.47365304285401 | (37.7610890166517, -122.473653042854) | |||
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) | |||
157068 | 157068 | 30677 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 920 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 8 | Permit Number 34600 | 6008142.25986 | 2110035.66546 | 37.7742156570679 | -122.415280896104 | (37.7742156570679, -122.415280896104) | |
164795 | 164795 | 188303 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.772756446777294 | -122.414924528938 | (37.7727564467773, -122.414924528938) | |||
169960 | 169960 | 188332 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013443.0879999995 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | |||
174688 | 174688 | 222578 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002709.15868 | 2104802.31344 | 37.759539303105505 | -122.433700841745 | (37.7595393031055, -122.433700841745) | |||
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) | |||
179896 | 179896 | 56330 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2526 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1973 12:00:00 AM | 8 | Permit Number 12466 | 5987579.5629 | 2113304.9613200002 | 37.7820151066388 | -122.48665015476801 | (37.7820151066388, -122.486650154768) | ||
182888 | 182888 | 221350 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008608.79456 | 2102405.13937 | 37.753290200197895 | -122.413127394812 | (37.7532902001979, -122.413127394812) | |||
183394 | 183394 | 69157 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | |
185934 | 185934 | 188326 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012985.7528099995 | 2102888.64274 | 37.7548625406828 | -122.39802478743799 | (37.7548625406828, -122.398024787438) | |||
186252 | 186252 | 188346 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1716 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.39222777999399 | (37.7329022519179, -122.392227779994) | |||
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");