Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14877 | 14877 | 27134 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1941 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 4 | 3X3 | 6011939.40312 | 2095757.43943 | 37.7352234533834 | -122.401142314262 | (37.7352234533834, -122.401142314262) | ||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||
44902 | 44902 | 43889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 4 | Permit Number 43498 | 6009135.81805 | 2110617.1891 | 37.775868173909004 | -122.411885088422 | (37.775868173909, -122.411885088422) | ||
49781 | 49781 | 222588 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4380 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000121.81513 | 2105788.1369 | 37.762098979601 | -122.44271991951 | (37.762098979601, -122.44271991951) | |||
51195 | 51195 | 244276 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 480 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | |||
52875 | 52875 | 186786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984829.112000001 | 2106870.9818 | 37.7641885128796 | -122.495690587985 | (37.7641885128796, -122.495690587985) | |||
54041 | 54041 | 188299 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007530.7890099995 | 2109693.3141 | 37.7732412569071 | -122.41737182255501 | (37.7732412569071, -122.417371822555) | |||
61402 | 61402 | 222561 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008138.86201 | 2096500.51335 | 37.7370510178737 | -122.414334773354 | (37.7370510178737, -122.414334773354) | |||
63668 | 63668 | 175754 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997730.99268 | 2086963.4604 | 37.7102743532383 | -122.449632264321 | (37.7102743532383, -122.449632264321) | |||
65031 | 65031 | 204644 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994179.89282 | 2090937.7889 | 37.7209831150476 | -122.46219354590099 | (37.7209831150476, -122.462193545901) | |||
72258 | 72258 | 47216 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45167 | 6008173.05313 | 2093488.0369799999 | 37.728781330768896 | -122.41400351077299 | (37.7287813307689, -122.414003510773) | |
76796 | 76796 | 222569 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4366 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001499.852999999 | 2101184.60004 | 37.749537240249296 | -122.43762412605601 | (37.7495372402493, -122.437624126056) | |||
90810 | 90810 | 49467 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3624 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46393 | 6006125.2277224995 | 2104366.11259234 | 37.7585348409416 | -122.421855375902 | (37.7585348409416, -122.421855375902) |
112231 | 112231 | 30737 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 4 | 3x3 | Permit Number 42884 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
131619 | 131619 | 96016 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884506996 | -122.41348521078999 | (37.788722884507, -122.41348521079) |
133403 | 133403 | 175786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 913 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008114.21781 | 2093492.5462599997 | 37.728790407640794 | -122.41420722787599 | (37.7287904076408, -122.414207227876) | |||
136013 | 136013 | 44808 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43903 | 5986465.0991 | 2105937.0115 | 37.7617197583894 | -122.489963557407 | (37.7617197583894, -122.489963557407) | |
136815 | 136815 | 188343 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012604.8118 | 2096159.0938799998 | 37.736363411533496 | -122.398869919026 | (37.7363634115335, -122.398869919026) | |||
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) | |||
146750 | 146750 | 188337 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1578 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6014186.2862599995 | 2095457.7275599998 | 37.7345255974821 | -122.393352991941 | (37.7345255974821, -122.393352991941) | |||
147272 | 147272 | 222591 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 310 Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003760.57016 | 2108690.93214 | 37.770276115676396 | -122.430341981792 | (37.7702761156764, -122.430341981792) | |||
149380 | 149380 | 204617 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 621 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993792.5560800005 | 2107303.5698 | 37.7658971178728 | -122.464720270343 | (37.7658971178728, -122.464720270343) | |||
151263 | 151263 | 43591 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2278 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 4 | Permit Number 43252 | 5987031.7486 | 2099759.5703 | 37.744791251078 | -122.487549954339 | (37.744791251078, -122.487549954339) | |
154491 | 154491 | 139380 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1460 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000719.7772 | 2113684.7085 | 37.7838150485268 | -122.441218395368 | (37.7838150485268, -122.441218395368) | |||
155931 | 155931 | 221355 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008404.74116 | 2103860.6266099997 | 37.757275180723 | -122.413936009452 | (37.757275180723, -122.413936009452) | |||
170117 | 170117 | 204631 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998374.865180001 | 2094370.4925900002 | 37.7306491651061 | -122.447939852652 | (37.7306491651061, -122.447939852652) | |||
172522 | 172522 | 204657 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200 Mesa Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993588.18999 | 2100755.25284 | 37.7479053493615 | -122.46495150490601 | (37.7479053493615, -122.464951504906) | |||
177360 | 177360 | 95997 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 56 Neptune St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767648 | 6013070.55126 | 2094035.71681 | 37.730558997287396 | -122.39711080912501 | (37.7305589972874, -122.397110809125) |
177509 | 177509 | 181743 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1219 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986121.7407 | 2106913.1555 | 37.7643799229814 | -122.491222922878 | (37.7643799229814, -122.491222922878) | |||
179630 | 179630 | 141961 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | |||
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) | |||
187433 | 187433 | 139381 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1470 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000719.1776 | 2113696.7015 | 37.7838479440673 | -122.44122133052299 | (37.7838479440673, -122.441221330523) | |||
187540 | 187540 | 36806 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.722897037873395 | -122.391191434704 | (37.7228970378734, -122.391191434704) |
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");