Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||||
| 4213 | 4213 | 252892 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4793 | 4793 | 12272 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | ||
| 7399 | 7399 | 45765 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.782245347199996 | -122.451230630986 | (37.7822453472, -122.451230630986) | |
| 9226 | 9226 | 10863 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275X HUDSON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 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) | |||
| 12322 | 12322 | 27195 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2001 12:00:00 AM | 3 | 3X3 | 6003315.89626 | 2093507.2409400002 | 37.728560063388294 | -122.430796382249 | (37.7285600633883, -122.430796382249) | ||
| 12327 | 12327 | 27038 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1346 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009450.86564 | 2094320.46878 | 37.7311386966779 | -122.409644741423 | (37.7311386966779, -122.409644741423) | ||
| 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) | |||
| 13978 | 13978 | 27170 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2080 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6012569.10474 | 2096085.04169 | 37.7361580900166 | -122.398988178079 | (37.7361580900166, -122.398988178079) | ||
| 14326 | 14326 | 27149 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1735 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6011161.84153 | 2095168.8132099998 | 37.7335638013107 | -122.403789237593 | (37.7335638013107, -122.403789237593) | ||
| 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) | |||
| 15119 | 15119 | 27174 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013069.06083 | 2096365.0106900001 | 37.7369546735192 | -122.397279240461 | (37.7369546735192, -122.397279240461) | ||
| 16026 | 16026 | 27153 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1700X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/12/2001 12:00:00 AM | 6 | 3X3 | 6011109.96837 | 2095074.7045 | 37.7333025005961 | -122.403961958687 | (37.7333025005961, -122.403961958687) | ||
| 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) | ||
| 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) | |||
| 18825 | 18825 | 3878 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 7 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2014 11:33:00 AM | 12 | 3X3 | 6002011.6108099995 | 2108665.28098 | 37.7701064612771 | -122.436389779582 | (37.7701064612771, -122.436389779582) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 40373 | 40373 | 37238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.755729192821704 | -122.48675431687 | (37.7557291928217, -122.48675431687) | ||
| 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) | |||
| 46851 | 46851 | 125887 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006289.37196 | 2113344.7288599997 | 37.7831972322057 | -122.42192548758301 | (37.7831972322057, -122.421925487583) | |||
| 47784 | 47784 | 221322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005240.85494 | 2105024.4327599998 | 37.760292519512205 | -122.42496077502899 | (37.7602925195122, -122.424960775029) | |||
| 50129 | 50129 | 175762 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011080.3120099995 | 2091995.56752 | 37.7248461762995 | -122.403847893187 | (37.7248461762995, -122.403847893187) | |||
| 51501 | 51501 | 44809 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.48995834721501 | (37.7616494289947, -122.489958347215) | |
| 51832 | 51832 | 222565 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007123.52166 | 2100080.2988 | 37.7468232221335 | -122.418098981082 | (37.7468232221335, -122.418098981082) | |||
| 52367 | 52367 | 175777 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.09808 | 2091752.9850700002 | 37.7237891931904 | -122.42786706372601 | (37.7237891931904, -122.427867063726) | |||
| 53807 | 53807 | 188319 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101001 | (37.7571363191045, -122.39902607101) | |||
| 54979 | 54979 | 221358 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000996.09085 | 2097469.1732900003 | 37.73930690338871 | -122.439099895546 | (37.7393069033887, -122.439099895546) | |||
| 56696 | 56696 | 188309 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012912.6135599995 | 2106204.46931 | 37.763962999012996 | -122.398510384468 | (37.763962999013, -122.398510384468) | |||
| 57253 | 57253 | 244273 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 466 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004356.0229 | 2109819.4835 | 37.7734085536944 | -122.428362760697 | (37.7734085536944, -122.428362760697) | |||
| 60064 | 60064 | 221336 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 385 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005546.153 | 2106769.6455599996 | 37.765101701713704 | -122.42402900095 | (37.7651017017137, -122.42402900095) | |||
| 61855 | 61855 | 175792 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009511.22188 | 2093372.0739 | 37.728537987719605 | -122.409369173844 | (37.7285379877196, -122.409369173844) | |||
| 62206 | 62206 | 188301 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008261.50029 | 2109526.90873 | 37.772825431974894 | -122.41483240691002 | (37.7728254319749, -122.41483240691) | |||
| 63601 | 63601 | 125885 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | |||
| 64408 | 64408 | 188294 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6008162.78535 | 2108877.84718 | 37.771037714636705 | -122.415127922313 | (37.7710377146367, -122.415127922313) | |||
| 65637 | 65637 | 222567 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 College Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004467.78746 | 2096013.76695 | 37.735507618486096 | -122.42699267809601 | (37.7355076184861, -122.426992678096) | |||
| 69764 | 69764 | 222544 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2885 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002432.22505 | 2095435.0142400002 | 37.733803183770796 | -122.433989022279 | (37.7338031837708, -122.433989022279) | |||
| 71804 | 71804 | 188313 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 299 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012940.76459 | 2105761.15041 | 37.7627473116745 | -122.39838191001199 | (37.7627473116745, -122.398381910012) | |||
| 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) | |||
| 72456 | 72456 | 188317 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011501.39155 | 2104667.35812 | 37.759663715319704 | -122.403283270917 | (37.7596637153197, -122.403283270917) | |||
| 74849 | 74849 | 49815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | 11 | 3x3 | Permit Number 46737 | 6012411.853019999 | 2104156.1373900003 | 37.7583108228906 | -122.40009851524599 | (37.7583108228906, -122.400098515246) | |
| 75444 | 75444 | 43894 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 716 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2000 12:00:00 AM | 6 | Permit Number 43499 | 6009202.88564 | 2110443.77487 | 37.7753957816152 | -122.41164082808399 | (37.7753957816152, -122.411640828084) | ||
| 80681 | 80681 | 110721 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1898X 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | |||||
| 80689 | 80689 | 106706 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199X BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | |||
| 80878 | 80878 | 108581 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1X GARDENSIDE DR | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999463.0 | 2102872.0 | 37.7540544083949 | -122.44478887768 | (37.7540544083949, -122.44478887768) | |||||
| 81716 | 81716 | 116348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 84181 | 84181 | 100793 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Recently planted by FUF. | 6008363.0 | 2103862.0 | 37.757276607365604 | -122.414080464335 | (37.7572766073656, -122.414080464335) | ||||
| 84601 | 84601 | 49808 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | ||
| 84720 | 84720 | 18799 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 36 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017963.3534873 | 2094445.0871971 | 37.731954211667706 | -122.380223926679 | (37.7319542116677, -122.380223926679) | |||
| 84733 | 84733 | 116949 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 123 WEST PORTAL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992936.0 | 2097647.0 | 37.7393332491746 | -122.46698079132099 | (37.7393332491746, -122.466980791321) | ||||
| 87473 | 87473 | 121683 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1645 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993978.0 | 2104308.0 | 37.757682752419896 | -122.46386140871401 | (37.7576827524199, -122.463861408714) | ||||
| 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) | |||
| 87714 | 87714 | 27034 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1300X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6009318.030669999 | 2094252.37415 | 37.7309442788115 | -122.41009917146799 | (37.7309442788115, -122.410099171468) | ||
| 88418 | 88418 | 109186 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 198x JUDSON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998796.0 | 2093546.0 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | ||||
| 89646 | 89646 | 27087 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006221.2435099995 | 2093597.03752 | 37.7289708064437 | -122.420758791245 | (37.7289708064437, -122.420758791245) | ||
| 89747 | 89747 | 39705 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 90504 | 90504 | 39664 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 91494 | 91494 | 26491 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 912X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1998 12:00:00 AM | 6 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | ||
| 92664 | 92664 | 39671 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 93454 | 93454 | 108730 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006.0 | 2102886.0 | 37.7548564119513 | -122.39795458116001 | (37.7548564119513, -122.39795458116) |
| 93761 | 93761 | 47226 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | ||
| 93893 | 93893 | 24248 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 265X Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1990 12:00:00 AM | 3 | 4x4 | 6006141.132777 | 2113311.4044124 | 37.783097370149 | -122.422435967678 | (37.783097370149, -122.422435967678) | ||
| 94854 | 94854 | 4316 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 15X Brompton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002232.19854 | 2095653.4678599997 | 37.734391653538104 | -122.434696188605 | (37.7343916535381, -122.434696188605) | |||
| 97484 | 97484 | 104505 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 157163 ALBION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6005993.0 | 2106325.0 | 37.7639060282426 | -122.422451867395 | (37.7639060282426, -122.422451867395) | |||
| 97590 | 97590 | 104767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1111 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | |||
| 100585 | 100585 | 52491 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.536314401 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | |||
| 101221 | 101221 | 33575 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 166 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37683 | 6007091.70402672 | 2098068.82881396 | 37.7412983853712 | -122.418066427995 | (37.7412983853712, -122.418066427995) | |||
| 106138 | 106138 | 38323 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1303 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | ||
| 107812 | 107812 | 87643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1002X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 108854 | 108854 | 27124 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 109661 | 109661 | 100285 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1426 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 10129 | 5994323.3 | 2105790.0 | 37.761771833907794 | -122.462774738749 | (37.7617718339078, -122.462774738749) | ||||
| 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) | |||
| 110016 | 110016 | 27122 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2003 12:00:00 AM | 12 | 2x2 | 6013082.27872 | 2096428.43607 | 37.7371295622807 | -122.39723798628401 | (37.7371295622807, -122.397237986284) | ||
| 110629 | 110629 | 120154 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 187 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002716.18242301 | 2104822.03495589 | 37.759593852181894 | -122.433677959685 | (37.7595938521819, -122.433677959685) | ||||
| 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) |
| 115420 | 115420 | 68441 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 137 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 14 | Permit Number 32298 | 6009913.44601622 | 2099873.29602914 | 37.7464114730886 | -122.40843704647 | (37.7464114730886, -122.40843704647) | ||
| 115613 | 115613 | 27054 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1048X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007856.910540001 | 2093638.04837 | 37.7291754686195 | -122.41510705369 | (37.7291754686195, -122.41510705369) | ||
| 116012 | 116012 | 111669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
| 117337 | 117337 | 107106 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 532 NOE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6002950.4 | 2105092.9 | 37.760350869576705 | -122.43288727007901 | (37.7603508695767, -122.432887270079) | |||
| 118043 | 118043 | 107041 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6013691.7 | 2105657.2 | 37.7625036896712 | -122.39577738754299 | (37.7625036896712, -122.395777387543) | ||||
| 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) | |||
| 124221 | 124221 | 44343 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 233 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | Permit Number 43727 | 5991164.04904901 | 2113857.0036857 | 37.7837391697575 | -122.47428989169201 | (37.7837391697575, -122.474289891692) | |||
| 125961 | 125961 | 101604 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 180X Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 5998894.7 | 2093810.1 | 37.7291401587489 | -122.446102418286 | (37.7291401587489, -122.446102418286) | |||
| 129616 | 129616 | 188290 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009398.69382 | 2109531.26602 | 37.7729012277415 | -122.410899015985 | (37.7729012277415, -122.410899015985) |
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");