home / trees

Street_Tree_List

Data source: data.sfgov.org

1,783 rows where qSpecies = 50

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
218 100214 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 730 Broderick St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6001088.1 2111178.5 37.77695461161171 -122.439764396806 (37.7769546116117, -122.439764396806) 15 5 11 29492 41
282 100292 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 3701 Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6003061.81659 2121064.97367 37.804212487284005 -122.43364345509701 (37.804212487284, -122.433643455097) 13 9 1 57 17
419 100471 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 2 Crane St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/22/2012 12:00:00 AM 2 3x3 Permit Number 769206 6012374.98009 2091340.69375 37.723120270254 -122.39932639780899 (37.723120270254, -122.399326397809) 10 3 8 58 1
478 10053 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 425 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/30/2006 12:00:00 AM 3 3X2   6005568.8374122 2106507.5213951 37.7643832516565 -122.42393189992501 (37.7643832516565, -122.423931899925) 8 4 5 28859 19
517 10057 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 439 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/09/2016 06:50:00 AM 3 3X3   6005566.67326 2106440.43668 37.7641989307536 -122.423934614407 (37.7641989307536, -122.423934614407) 8 4 5 28859 19
677 100759 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 362 Brannan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     9 3x3   6014440.04423 2112282.11717 37.780735840838396 -122.39365282322201 (37.7807358408384, -122.393652823222) 6 2 9 28856 6
766 100856 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 70 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3 Permit Number 769158 5993666.6182699995 2115051.6302900002 37.7871639517517 -122.46571883909701 (37.7871639517517, -122.465718839097) 11 6 1 54 11
781 100882 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 91 Welsh St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013366.225459999 2111763.75465 37.7792528084154 -122.397331345366 (37.7792528084154, -122.397331345366) 6 2 9 28856 34
783 100884 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 91 Welsh St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013403.42787 2111798.46493 37.7793501860944 -122.397205080544 (37.7793501860944, -122.397205080544) 6 2 9 28856 34
787 100888 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 91 Welsh St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013550.27415 2111938.66795 37.7797433256341 -122.396706905611 (37.7797433256341, -122.396706905611) 6 2 9 28856 34
788 100889 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 91 Welsh St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013566.0867800005 2111954.86803 37.7797886874229 -122.396653338395 (37.7797886874229, -122.396653338395) 6 2 9 28856 34
790 100890 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 91 Welsh St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/28/2017 12:00:00 AM 3 3x3   6013579.59012 2111966.26913 37.779820743762606 -122.39660742352 (37.7798207437626, -122.39660742352) 6 2 9 28856 34
791 100891 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 91 Welsh St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/28/2017 12:00:00 AM 3 3x3   6013606.47382 2111993.91964 37.7798981618967 -122.396516359044 (37.7798981618967, -122.396516359044) 6 2 9 28856 34
792 100892 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 91 Welsh St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013627.65977 2112013.31498 37.7799525960738 -122.396444426786 (37.7799525960738, -122.396444426786) 6 2 9 28856 34
818 10095 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 727 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/28/2016 05:21:00 AM 3 2X2   6005664.2360000005 2104708.85405 37.759449920391 -122.423474060781 (37.759449920391, -122.423474060781) 2 4 5 28859 19
821 10096 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 737 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/19/2011 12:00:00 AM 3 3x3   6005665.871 2104659.8313700003 37.7593154078879 -122.42346492097602 (37.7593154078879, -122.423464920976) 2 4 5 28859 19
924 10107 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 799X Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/02/2014 06:59:00 AM 3 3x4   6005682.50344 2104371.2203900004 37.7585238884792 -122.423386880525 (37.7585238884792, -122.423386880525) 2 4 5 28859 19
1082 101234 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 251 Balboa St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   5994788.53914 2111424.28345 37.7772688824616 -122.46157417945801 (37.7772688824616, -122.461574179458) 11 6 2 54 11
1093 10125 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 876 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/11/2015 02:57:00 PM 3 3x3   6005640.441980001 2103866.83654 37.757136594295396 -122.423496489872 (37.7571365942954, -122.423496489872) 2 4 5 28859 19
1113 10127 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 892 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     45 3x3   6005646.424 2103793.6441599997 37.7569359627397 -122.42347059841002 (37.7569359627397, -122.42347059841) 2 4 5 28859 19
1203 101367 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 551 Minna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/17/2012 12:00:00 AM 1 3x5 Permit Number 769423 6009889.66847 2111940.62383 37.779544278688604 -122.409370733267 (37.7795442786886, -122.409370733267) 14 2 9 28853 34
1323 10150 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 966 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   11/02/2012 12:00:00 AM 3 3x3   6005669.65476 2103355.68664 37.7557347445795 -122.423359124725 (37.7557347445795, -122.423359124725) 2 4 5 28859 19
1344 10153 Planning Code 138.1 required 8 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 978 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/11/2016 06:51:00 AM 3 3x3 Permit Number 780464 6005672.85931 2103292.97405 37.7555627312558 -122.423343584439 (37.7555627312558, -122.423343584439) 2 4 5 28859 19
1355 10154 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 986 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/30/2006 12:00:00 AM 3 3x3   6005675.0599084 2103229.8800101 37.755389613891 -122.423331489083 (37.755389613891, -122.423331489083) 2 4 5 28859 19
1488 101682 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 2584 Filbert St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/22/1987 12:00:00 AM 12   Permit Number 24610 6000585.65494 2118590.7735099997 37.7972781827952 -122.44203467567301 (37.7972781827952, -122.442034675673) 13 9 1 57 17
1571 101775 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1700 Yosemite Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   10 3x3 Permit Number 19103 6014052.75296 2093112.8912 37.728079734566606 -122.393650601914 (37.7280797345666, -122.393650601914) 10 3 8 58 1
1613 10186 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1130 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   04/03/2015 04:47:00 AM 3 4x5   6005723.69305 2102361.07491 37.753006821117296 -122.423101549889 (37.7530068211173, -122.423101549889) 2 4 5 28859 19
1628 10188 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1148 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   07/05/2016 12:00:00 AM 3 2x4   6005734.612380001 2102244.83146 37.75268825965679 -122.423055527089 (37.7526882596568, -122.423055527089) 2 4 5 28859 19
1640 10190 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1160 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/04/2015 09:38:00 AM 3 2x2   6005734.23383 2102203.6860700003 37.7525752625596 -122.42305391193001 (37.7525752625596, -122.42305391193) 2 4 5 28859 19
1693 101974 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1230 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/11/2012 12:00:00 AM 3 3x3 Permit Number 769454 6013882.9225 2105271.9580900003 37.7614565354174 -122.39508902885099 (37.7614565354174, -122.395089028851) 10 3 8 28856 29
1730 10201 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1233 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/30/2006 12:00:00 AM 3 3X3   6005829.840660599 2101789.0505836997 37.7514421637243 -122.422693823491 (37.7514421637243, -122.422693823491) 2 4 5 28859 19
1779 10206 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1274 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/13/2010 12:00:00 AM 3 2X2   6005768.7769 2101585.68354 37.7508803192719 -122.422890537479 (37.7508803192719, -122.422890537479) 2 4 5 28859 19
2063 102353 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 662 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/10/2009 12:00:00 AM 2 3x3 Permit Number 52560 5992263.7285400005 2110921.14049 37.775741736970204 -122.470271582701 (37.7757417369702, -122.470271582701) 11 6 2 54 11
2095 102387 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 84 Harriet St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6010709.4483199995 2111466.67522 37.778288823307 -122.406501343779 (37.778288823307, -122.406501343779) 14 2 9 28853 34
2096 102388 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 90X Harriet St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6010739.31321 2111434.0362400003 37.778200875001104 -122.406395729189 (37.7782008750011, -122.406395729189) 14 2 9 28853 34
2100 102392 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 30X Harriet St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   6010436.41014 2111752.09711 37.7790572463352 -122.40746601596202 (37.7790572463352, -122.407466015962) 14 2 9 28853 34
2399 102708 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 999X PHELPS ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/07/2015 12:00:00 AM 3 3x3 Permit Number 773962 6014744.0 2097272.0 37.7395381878784 -122.39155157401501 (37.7395381878784, -122.391551574015) 10 3 8 58 1
2400 102709 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 999X PHELPS ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/07/2015 12:00:00 AM 3 3x3 Permit Number 773962 6014744.0 2097272.0 37.7395381878784 -122.39155157401501 (37.7395381878784, -122.391551574015) 10 3 8 58 1
3169 103531 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 130 South Hill Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/07/2014 12:00:00 AM 1   Permit Number 770957 6003099.91342 2086880.6888299999 37.7103527759382 -122.43107027978901 (37.7103527759382, -122.431070279789) 9 7 6 28861 5
3170 103532 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 130 South Hill Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/07/2014 12:00:00 AM 1   Permit Number 770957 6003118.601980001 2086861.7562 37.7103018500205 -122.431004337903 (37.7103018500205, -122.431004337903) 9 7 6 28861 5
3268 103638 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 3147 20th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773749 6008974.4 2104483.2 37.759016602910705 -122.412009894818 (37.7590166029107, -122.412009894818) 2 4 7 28859 19
3269 103639 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 3147 20th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773749 6008974.4 2104483.2 37.759016602910705 -122.412009894818 (37.7590166029107, -122.412009894818) 2 4 7 28859 19
3270 103640 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 3147 20th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773749 6008974.4 2104483.2 37.759016602910705 -122.412009894818 (37.7590166029107, -122.412009894818) 2 4 7 28859 19
3593 104000 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 157 Apollo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/17/2013 12:00:00 AM 3 3x3 Permit Number 58584 6012594.010480001 2094120.56345 37.7307654285701 -122.39876424420099 (37.7307654285701, -122.398764244201) 10 3 8 58 1
3990 104489 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 101X Arkansas St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6012893.40207 2106545.4722700003 37.7648982471715 -122.398600762736 (37.7648982471715, -122.398600762736) 14 3 8 28856 29
5260 106005 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 59 Reddy St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   3 3x3   6013632.51665 2093922.487 37.7302793593954 -122.395160068985 (37.7302793593954, -122.395160068985) 10 3 8 58 1
5268 106013 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 5235 DIAMOND HEIGHTS BLVD 8 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/16/2016 12:00:00 AM 2 3x3   6001081.8 2099374.5 37.7445433581402 -122.43894005993 (37.7445433581402, -122.43894005993) 2 7 5 63 22
5269 106014 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 5235 DIAMOND HEIGHTS BLVD 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     2 3x3   6001081.8 2099374.5 37.7445433581402 -122.43894005993 (37.7445433581402, -122.43894005993) 2 7 5 63 22
5270 106016 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 5285 DIAMOND HEIGHTS BLVD 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     2 3x3   6001339.5 2099171.1 37.7439995285584 -122.438034420154 (37.7439995285584, -122.438034420154) 2 7 5 63 22
5271 106017 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 5235 DIAMOND HEIGHTS BLVD 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     2 3x3   6001081.8 2099374.5 37.7445433581402 -122.43894005993 (37.7445433581402, -122.43894005993) 2 7 5 63 22
5272 106018 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 5285 DIAMOND HEIGHTS BLVD 8 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   12/22/2016 07:34:00 AM 3 3x3   6001339.5 2099171.1 37.7439995285584 -122.438034420154 (37.7439995285584, -122.438034420154) 2 7 5 63 22
5607 106411 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 2159 Chestnut St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/28/2014 12:00:00 AM 1   Permit Number 772621 6001561.17582 2119720.78456 37.8004364390406 -122.438740147849 (37.8004364390406, -122.438740147849) 13 9 1 57 17
5663 106495 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 278 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/20/2014 12:00:00 AM 3 3x3 Permit Number 773493 5993716.0557699995 2113668.3576599997 37.7833687137237 -122.46544727301 (37.7833687137237, -122.46544727301) 11 6 2 54 11
5876 106769 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 2600X 24th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6010715.11393 2102268.82005 37.753033918516 -122.405833670893 (37.753033918516, -122.405833670893) 10 4 8 28859 19
6326 107323 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 752 CAYUGA AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/24/2014 12:00:00 AM 3 4x2 Permit Number 773710 6001347.5 2092637.6 37.726060507123705 -122.43753897171801 (37.7260605071237, -122.437538971718) 9 7 6 28861 25
6824 107918 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 495 09th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2014 12:00:00 AM 3 3x3 Permit Number 774012 5993102.18956 2112225.85216 37.7793725629571 -122.467466058727 (37.7793725629571, -122.467466058727) 11 6 2 54 11
6825 107919 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 495 09th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2014 12:00:00 AM 3 3x3 Permit Number 774012 5993102.51842 2112200.9229900003 37.77930413319589 -122.46746310776501 (37.7793041331959, -122.467463107765) 11 6 2 54 11
6826 107920 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 495 09th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2014 12:00:00 AM 3 3x3 Permit Number 774012 5993103.579919999 2112156.71992 37.7791828248217 -122.467456220381 (37.7791828248217, -122.467456220381) 11 6 2 54 11
6827 107921 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 495 09th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2014 12:00:00 AM 3 3x3 Permit Number 774012 5993104.13522 2112142.54779 37.7791439440497 -122.46745326853599 (37.7791439440497, -122.467453268536) 11 6 2 54 11
6836 107930 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1800X Anza St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2014 12:00:00 AM 3 3x3 Permit Number 774012 5993080.40868 2112098.8542 37.7790226034666 -122.467532169341 (37.7790226034666, -122.467532169341) 11 6 2 54 11
6837 107931 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1800X Anza St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/2014 12:00:00 AM 3 3x3 Permit Number 774012 5993050.627169999 2112098.44273 37.779019754209706 -122.467635164784 (37.7790197542097, -122.467635164784) 11 6 2 54 11
7261 108380 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 286 Munich St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773804 6004439.17229 2090775.7474099998 37.7211235626427 -122.426718715963 (37.7211235626427, -122.426718715963) 9 7 6 28861 5
7350 108473 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1608 Anza St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3 Permit Number 773791 5993717.35879 2112110.81995 37.7790922117302 -122.465329589105 (37.7790922117302, -122.465329589105) 11 6 2 54 11
7380 108503 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1434 14th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773648 5991820.21793 2105663.11685 37.7612789627151 -122.47142257169901 (37.7612789627151, -122.471422571699) 1 8 4 56 12
7395 108517 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1474 17th Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773664 5990869.49269 2105368.92693 37.7604161511877 -122.474689222748 (37.7604161511877, -122.474689222748) 1 8 4 56 12
7399 108520 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1831 17th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773667 5990912.6193699995 2102936.28032 37.7537392459439 -122.47436254716699 (37.7537392459439, -122.474362547167) 1 8 4 56 12
7401 108522 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 2059 17th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773673 5990965.153 2101394.10507 37.7495078797857 -122.474068362776 (37.7495078797857, -122.474068362776) 1 8 4 29491 12
7437 108555 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 68X Wanda St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773714 6000555.61606 2091513.15028 37.7229279706553 -122.440195859767 (37.7229279706553, -122.440195859767) 9 7 6 28861 25
7451 108569 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 586 Somerset St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773764 6010254.2951 2091832.3673599998 37.7243518811862 -122.40669185444901 (37.7243518811862, -122.406691854449) 10 3 7 309 28
7478 108596 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 36 Bronte St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   1 3x3 Permit Number 770949 6009339.44395 2097251.26276 37.7391797819084 -122.410236794344 (37.7391797819084, -122.410236794344) 10 7 7 28859 2
7547 108660 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1462 Blake St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/30/2014 12:00:00 AM 3 3x3 Permit Number 771207 5997897.618969999 2112846.03551 37.781351110742996 -122.45092146754 (37.781351110743, -122.45092146754) 15 6 2 54 16
7677 108785 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1100-1198X Schwerin St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 FUF 2 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.136580001 2087632.54285 37.7127552255458 -122.41039559568199 (37.7127552255458, -122.410395595682) 9 7 8 309 39
7678 108786 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1100-1198X Schwerin St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 FUF 2 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.136580001 2087632.54285 37.7127552255458 -122.41039559568199 (37.7127552255458, -122.410395595682) 9 7 8 309 39
7679 108787 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1100-1198X Schwerin St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 FUF 2 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.136580001 2087632.54285 37.7127552255458 -122.41039559568199 (37.7127552255458, -122.410395595682) 9 7 8 309 39
7680 108788 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1100-1198X Schwerin St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 FUF 2 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.136580001 2087632.54285 37.7127552255458 -122.41039559568199 (37.7127552255458, -122.410395595682) 9 7 8 309 39
7681 108789 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1100-1198X Schwerin St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 FUF 2 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.136580001 2087632.54285 37.7127552255458 -122.41039559568199 (37.7127552255458, -122.410395595682) 9 7 8 309 39
7771 108872 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1317 Grove St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773401 6001507.20104 2110761.06824 37.775832295364104 -122.438284688432 (37.7758322953641, -122.438284688432) 15 5 11 29492 10
7777 108878 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 275 Staples Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773301 5998271.57935 2093779.45417 37.7290204086136 -122.44825438236 (37.7290204086136, -122.44825438236) 9 7 4 28861 40
7789 108889 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 534 Mangels Ave   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773372 5997888.03427 2095280.4903 37.7331199631343 -122.449688444288 (37.7331199631343, -122.449688444288) 9 7 4 59 40
7826 108924 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 335-341 Oak St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6005380.1 2110235.1 37.7746076306443 -122.42484990347602 (37.7746076306443, -122.424849903476) 7 9 11 28852 10
7935 109034 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 2042 33rd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772948 5986068.5 2101324.0 37.749030526651396 -122.490995740125 (37.7490305266514, -122.490995740125) 1 8 3 29491 35
7942 109041 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1638 36th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/22/2015 12:00:00 AM 3 3x3 Permit Number 773601 5985043.8 2104034.4 37.7564126199144 -122.49473890921699 (37.7564126199144, -122.494738909217) 1 8 3 56 35
7952 109050 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 48 Lurline St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/22/2015 12:00:00 AM 3 3x3 Permit Number 773230 5991933.0 2104990.6 37.7594389326357 -122.470983516472 (37.7594389326357, -122.470983516472) 1 8 4 56 12
7974 109074 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1520 Funston Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/23/2015 12:00:00 AM 3 3x3 Permit Number 773927 5992170.3 2105104.1 37.7597642954434 -122.470171088863 (37.7597642954434, -122.470171088863) 1 8 4 56 12
8405 109529 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 33 Pinehurst Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/20/2015 12:00:00 AM 3 3x3 Permit Number 774999 5993241.2 2093283.4 37.7273694976755 -122.465608622621 (37.7273694976755, -122.465608622621) 9 8 4 59 40
8435 109567 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 56 Seneca Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/23/2015 12:00:00 AM 3 3x3 Permit Number 775012 6000375.8 2089821.0 37.7182714712375 -122.440696127295 (37.7182714712375, -122.440696127295) 9 7 6 28861 25
8476 10962 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1431 Hudson Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/04/1998 12:00:00 AM 3 3X4   6016563.2925523 2096760.0557493 37.7382333059102 -122.385225528118 (37.7382333059102, -122.385225528118) 10 3 8 58 1
8520 109664 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 230X Craut St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   1 3x3   6004031.22514 2093803.38272 37.729413705278894 -122.428344548862 (37.7294137052789, -122.428344548862) 9 7 6 28861 5
8521 109665 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 230X Craut St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/27/2015 12:00:00 AM 3 3x3 Permit Number 775017 6004046.411069999 2093890.0445599998 37.729652518606 -122.42829822368 (37.729652518606, -122.42829822368) 9 7 6 28861 5
8630 109829 Private 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 629 TAYLOR ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/01/2015 12:00:00 AM     Permit Number 775362 6009246.3 2115118.4 37.7882336239769 -122.41182103906 (37.7882336239769, -122.41182103906) 5 1 10 28852 21
8665 109876 Permitted Site 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1631 20th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/05/2015 12:00:00 AM 3 3x3 Permit Number 775090 5989917.1 2104254.5 37.7573010006541 -122.47790160153099 (37.7573010006541, -122.477901601531) 1 8 3 56 35
8687 109905 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 224 12th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1     6007804.4869 2109016.66543 37.771398734904 -122.416377125602 (37.771398734904, -122.416377125602) 8 2 9 28853 19
8695 109917 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1627 34th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775114 5985575.9 2104128.7 37.7567026728441 -122.492905692842 (37.7567026728441, -122.492905692842) 1 8 3 56 35
8710 109934 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1890 22nd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775172 5989442.7 2102500.8 37.7524582627735 -122.479413946447 (37.7524582627735, -122.479413946447) 1 8 3 56 35
8780 110033 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 206 Lisbon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/19/2015 12:00:00 AM 3 3x3 Permit Number 775206 6003103.36951 2092214.97197 37.724999739126794 -122.431438884895 (37.7249997391268, -122.431438884895) 9 7 6 28861 5
8811 110101 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1348 Douglass St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/19/2016 12:00:00 AM   3x3 Permit Number 774671 6001379.0 2099692.0 37.7454320431231 -122.437935141467 (37.7454320431231, -122.437935141467) 2 4 5 63 22
9110 110499 Section 143 6 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 900X JESSIE ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872) 8 2 9 28853 34
9112 110500 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 900X JESSIE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872) 8 2 9 28853 34
9113 110501 Undocumented 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 900X JESSIE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872) 8 2 9 28853 34
9654 111054 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 638 Balboa St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     1 3x3   5993558.15565 2111433.38928 37.777222987024004 -122.465831098866 (37.777222987024, -122.465831098866) 11 6 2 54 11

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 84.748ms · Data source: data.sfgov.org