Street_Tree_List

Data source: data.sfgov.org

1,742 rows where qSpecies = 51 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23088 29 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 742 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3X3   6003854.77769 2107764.13441 37.7677366901162 -122.42994999788799 (37.7677366901162, -122.429949997888)
118517 431 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2010X Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/1997 12:00:00 AM 20 3X3   5989200.24086 2114740.63501 37.786051407249 -122.481148573701 (37.786051407249, -122.481148573701)
128353 432 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2010X Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/15/1997 12:00:00 AM 30 3X3   5989200.24086 2114740.63501 37.786051407249 -122.481148573701 (37.786051407249, -122.481148573701)
127224 475 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1110X Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/11/2015 06:40:00 PM 3 3x3   6005715.8108342 2102491.4524088 37.753364362762 -122.42313807467801 (37.753364362762, -122.423138074678)
154 830 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1384 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/28/2017 12:15:00 PM 3 5.5x6.5   5981549.5887 2105676.5499 37.7607163481902 -122.506944712409 (37.7607163481902, -122.506944712409)
22063 855 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 378 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/16/1995 12:00:00 AM 6 3X3   6008306.24694 2095178.0824099998 37.7334293112951 -122.41366253820401 (37.7334293112951, -122.413662538204)
20785 856 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 400X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/2001 12:00:00 AM 8 3x3   6008178.91279 2095102.6011299998 37.7332149048351 -122.414097431452 (37.7332149048351, -122.414097431452)
17386 857 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 400X Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/2015 09:50:00 AM 3 3x3   6008157.97396 2095088.68273 37.7331755118234 -122.41416883853701 (37.7331755118234, -122.414168838537)
12988 904 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1179 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/22/2016 12:00:00 AM 3 2X2   6003419.3756099995 2094263.29224 37.7306418725253 -122.430492572378 (37.7306418725253, -122.430492572378)
12419 981 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1604 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2003 12:00:00 AM 6 3X3   6001745.7594099995 2092854.52102 37.7266787581039 -122.436177732017 (37.7266787581039, -122.436177732017)
111383 1199 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3099X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
141065 1200 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3099X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
87032 1201 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3099X Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
95862 1202 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3099X Alemany Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
125579 1467 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 200 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 3X3   5995559.29766 2114744.3111900003 37.786429126950104 -122.45914836167401 (37.7864291269501, -122.459148361674)
23242 1673 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 200 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4     5994963.861330001 2111486.70203 37.7774503572538 -122.460972213003 (37.7774503572538, -122.460972213003)
119701 1677 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 302 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/25/2002 12:00:00 AM 3 3X3   5994635.149619999 2111475.19089 37.777399830436 -122.46210849201599 (37.777399830436, -122.462108492016)
23024 2316 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2263 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5     6009682.41451 2104184.36513 37.7582357681755 -122.409540144857 (37.7582357681755, -122.409540144857)
15078 2525 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1570 Burke Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/10/2016 02:24:00 PM 3 3X3   6016567.66909 2098923.0431 37.7441726718323 -122.385361080243 (37.7441726718323, -122.385361080243)
16215 2527 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1570 Burke Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/10/2016 02:21:00 PM 3 3X3   6016536.91868 2098947.33995 37.7442376847211 -122.38546910231001 (37.7442376847211, -122.38546910231)
17358 4165 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3770 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2016 12:00:00 AM 3 3X3 Permit Number 774303 6005421.09901 2100523.30385 37.747943645176704 -122.424017300779 (37.7479436451767, -122.424017300779)
78480 5014 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5313 Diamond Heights Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/21/1997 12:00:00 AM 3 3   6001578.667721 2098979.6063858 37.7434873306528 -122.437193725781 (37.7434873306528, -122.437193725781)
80001 5015 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5313 Diamond Heights Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/1997 12:00:00 AM 3 2   6001578.667721 2098979.6063858 37.7434873306528 -122.437193725781 (37.7434873306528, -122.437193725781)
88812 5035 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5343 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/21/1997 12:00:00 AM 3 3X3   6001794.1836781 2098779.6603168 37.742950574320204 -122.43643421934401 (37.7429505743202, -122.436434219344)
97045 5037 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5355 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/1997 12:00:00 AM 3 3X3   6001868.9723963 2098685.9233744 37.7426974440588 -122.436168914431 (37.7426974440588, -122.436168914431)
89081 5038 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5361 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/21/1997 12:00:00 AM 3 3X3   6001904.577984599 2098640.1233312 37.7425737107311 -122.43604252412399 (37.7425737107311, -122.436042524124)
110102 5039 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5367 Diamond Heights Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/1992 12:00:00 AM 3 3X3   6001935.2122711 2098586.2052626 37.7424274046596 -122.435932742747 (37.7424274046596, -122.435932742747)
20345 5583 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1069 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6005153.43733 2102137.63056 37.752361098006894 -122.42505770847299 (37.7523610980069, -122.425057708473)
54781 6305 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1797X Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/10/1997 12:00:00 AM 9 3X3   6002532.11938 2112833.28187 37.781580315205396 -122.434887466275 (37.7815803152054, -122.434887466275)
104103 7871 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1001 Franklin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/21/1997 12:00:00 AM 3 3X3   6006017.92474 2113680.1220400003 37.7841028269903 -122.42288843164101 (37.7841028269903, -122.422888431641)
22422 7875 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1050 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2014 02:38:00 PM 3 4X4   6006070.45315 2113764.9909599996 37.7843388199314 -122.422712735214 (37.7843388199314, -122.422712735214)
23334 8279 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1601 Galvez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3x3   6015771.79311 2097687.24817 37.740735369454605 -122.388026849781 (37.7407353694546, -122.388026849781)
142012 8890 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4300 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/1996 12:00:00 AM 3 3X3   5993676.36815 2112846.77323 37.7811105766569 -122.46552487036199 (37.7811105766569, -122.465524870362)
87763 8934 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4630 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2002 12:00:00 AM 3 2X2   5992661.51426 2112807.7475 37.7809448378746 -122.46903288589701 (37.7809448378746, -122.469032885897)
144382 9239 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6406 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/27/1996 12:00:00 AM 3 3X3   5987099.50219 2112606.70022 37.780069883306396 -122.488259594393 (37.7800698833064, -122.488259594393)
97698 9253 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6500X Geary Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/12/2011 12:00:00 AM 2 2X3   5986722.32109 2112597.81428 37.7800234720171 -122.489563763122 (37.7800234720171, -122.489563763122)
138537 10053 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 425 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/2006 12:00:00 AM 3 3X2   6005568.8374122 2106507.5213951 37.7643832516565 -122.42393189992501 (37.7643832516565, -122.423931899925)
20425 10057 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 439 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/09/2016 06:50:00 AM 3 3X3   6005566.67326 2106440.43668 37.7641989307536 -122.423934614407 (37.7641989307536, -122.423934614407)
19486 10095 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 727 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/28/2016 05:21:00 AM 3 2X2   6005664.2360000005 2104708.85405 37.759449920391 -122.423474060781 (37.759449920391, -122.423474060781)
16928 10096 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 737 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2011 12:00:00 AM 3 3x3   6005665.871 2104659.8313700003 37.7593154078879 -122.42346492097602 (37.7593154078879, -122.423464920976)
21922 10107 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 799X Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/02/2014 06:59:00 AM 3 3x4   6005682.50344 2104371.2203900004 37.7585238884792 -122.423386880525 (37.7585238884792, -122.423386880525)
21046 10125 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 876 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2015 02:57:00 PM 3 3x3   6005640.441980001 2103866.83654 37.757136594295396 -122.423496489872 (37.7571365942954, -122.423496489872)
18818 10127 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 892 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3x3   6005646.424 2103793.6441599997 37.7569359627397 -122.42347059841002 (37.7569359627397, -122.42347059841)
22211 10150 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 966 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/02/2012 12:00:00 AM 3 3x3   6005669.65476 2103355.68664 37.7557347445795 -122.423359124725 (37.7557347445795, -122.423359124725)
17728 10153 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 978 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2016 06:51:00 AM 3 3x4   6005672.85931 2103292.97405 37.7555627312558 -122.423343584439 (37.7555627312558, -122.423343584439)
92901 10154 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 986 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/2006 12:00:00 AM 3 3x3   6005675.0599084 2103229.8800101 37.755389613891 -122.423331489083 (37.755389613891, -122.423331489083)
18648 10186 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1130 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/03/2015 04:47:00 AM 3 4x5   6005723.69305 2102361.07491 37.753006821117296 -122.423101549889 (37.7530068211173, -122.423101549889)
18209 10188 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1148 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/05/2016 12:00:00 AM 3 2x4   6005734.612380001 2102244.83146 37.75268825965679 -122.423055527089 (37.7526882596568, -122.423055527089)
21836 10190 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1160 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/04/2015 09:38:00 AM 3 2x2   6005734.23383 2102203.6860700003 37.7525752625596 -122.42305391193001 (37.7525752625596, -122.42305391193)
85469 10201 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1233 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/30/2006 12:00:00 AM 3 3X3   6005829.840660599 2101789.0505836997 37.7514421637243 -122.422693823491 (37.7514421637243, -122.422693823491)
21694 10206 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1274 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/13/2010 12:00:00 AM 3 2X2   6005768.7769 2101585.68354 37.7508803192719 -122.422890537479 (37.7508803192719, -122.422890537479)
9186 10962 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1431 Hudson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1998 12:00:00 AM 3 3X4   6016563.2925523 2096760.0557493 37.7382333059102 -122.385225528118 (37.7382333059102, -122.385225528118)
117525 12095 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1261X La Salle Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/23/1996 12:00:00 AM 6 3X3   6017141.6501925 2094501.7221284 37.732064349457005 -122.383068698568 (37.732064349457, -122.383068698568)
144194 12106 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1281X La Salle Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/23/1996 12:00:00 AM 6 3X3   6017033.141005999 2094557.4754692002 37.732211440602605 -122.383447721977 (37.7322114406026, -122.383447721977)
22997 12121 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400X La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3X3   6016540.00349 2094984.34395 37.733356269266295 -122.38518235797899 (37.7333562692663, -122.385182357979)
15469 12131 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400X La Salle Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016434.11275 2095220.18267 37.7339979769066 -122.38556488553499 (37.7339979769066, -122.385564885535)
16106 12141 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400X La Salle Ave 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6016374.05041 2095443.42618 37.7346076354195 -122.38578809634899 (37.7346076354195, -122.385788096349)
16692 12234 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1570 La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/25/2002 12:00:00 AM 6 3X3   6015728.02305 2096056.7839799998 37.7362560216982 -122.38806443872 (37.7362560216982, -122.38806443872)
14268 12235 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1574 La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/27/1997 12:00:00 AM 6 3X3   6015715.635319999 2096065.54177 37.736279382483204 -122.38810787958201 (37.7362793824832, -122.388107879582)
89527 12448 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1989X Pine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/31/2006 12:00:00 AM 3 3X3   6004432.626396201 2115327.1853143997 37.7885356724235 -122.428490433403 (37.7885356724235, -122.428490433403)
92244 12608 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 700 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 3X3   5993288.45121 2114872.37286 37.786649939560796 -122.46701416661199 (37.7866499395608, -122.467014166612)
78031 12721 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1535 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/1997 12:00:00 AM 20 3X3   5990655.40582 2114718.61196 37.7860754253896 -122.476112538286 (37.7860754253896, -122.476112538286)
110986 12738 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1630 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/12/2013 12:00:00 AM 100 4x4   5990343.3046 2114764.5197400004 37.7861833727245 -122.47719566934299 (37.7861833727245, -122.477195669343)
128148 12774 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1842 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/15/1997 12:00:00 AM 20 6   5989637.59951 2114741.75598 37.7860799008728 -122.479635529609 (37.7860799008728, -122.479635529609)
128791 12775 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1842 Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/1997 12:00:00 AM 20 6   5989652.1071 2114741.09637 37.786078932501 -122.47958528952 (37.786078932501, -122.47958528952)
108155 12781 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1914 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/1997 12:00:00 AM 40 3X3   5989486.1909300005 2114733.67338 37.786048911885096 -122.48015876501101 (37.7860489118851, -122.480158765011)
22225 15638 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3620 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/30/2015 12:00:00 AM 3 3X3 Permit Number 774763 6005333.2664 2097101.2564 37.7385425216055 -122.42407769940901 (37.7385425216055, -122.424077699409)
78080 15703 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4260 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2009 12:00:00 AM 3 3X3   6003241.43292 2093747.9611099998 37.7292168076411 -122.431070980005 (37.7292168076411, -122.431070980005)
13082 15846 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5256 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2015 12:00:00 AM 6 3x3 Permit Number 775938 5999899.043409999 2088666.4410599999 37.7150741519211 -122.442261231071 (37.7150741519211, -122.442261231071)
125649 15854 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5319 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/1995 12:00:00 AM 6 3X3   5999668.720480001 2088318.36983 37.714105297270606 -122.443032341019 (37.7141052972706, -122.443032341019)
142815 15859 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5367 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/1995 12:00:00 AM 6 3X3   5999657.0 2088324.0 37.7141200881786 -122.44307325545601 (37.7141200881786, -122.443073255456)
79600 15934 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5775 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/1995 12:00:00 AM 6 3X3   5997641.29025 2086713.63365 37.7095832536665 -122.449924299561 (37.7095832536665, -122.449924299561)
96152 15940 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5810X MISSION ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/20/1998 12:00:00 AM 6 3X3   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
9415 15943 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5810X MISSION ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
84568 15970 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5919X Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/28/1995 12:00:00 AM 6 3X3   5996671.773019999 2086351.2464599998 37.708532699460896 -122.45324895592199 (37.7085326994609, -122.453248955922)
108782 15977 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5937 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/28/1995 12:00:00 AM 6 3X3   5996505.5077599995 2086284.06053 37.7083386912237 -122.453818737586 (37.7083386912237, -122.453818737586)
81738 16859 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 150 Oak St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/14/2012 12:00:00 AM 3 4X4 Permit Number 768229 6006257.87931 2110498.54999 37.7753805408795 -122.421832203671 (37.7753805408795, -122.421832203671)
18695 16874 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 269 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/21/2015 08:43:00 AM 3 3X3   6005705.9301 2110300.3269 37.7748051262311 -122.423727430112 (37.7748051262311, -122.423727430112)
21052 16925 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 512 Oak St 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     25     6004419.62206 2110173.45228 37.7743840640969 -122.42816799305099 (37.7743840640969, -122.428167993051)
86022 17243 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 10X Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/2003 12:00:00 AM 6 3X34   5993969.30173 2088537.74626 37.7143810447114 -122.462747471174 (37.7143810447114, -122.462747471174)
98332 17706 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1195X Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/21/2012 12:00:00 AM 3 4x4   6002295.810192 2112602.9289849997 37.78093440458979 -122.435688496636 (37.7809344045898, -122.435688496636)
81038 17707 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1195X Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/21/2012 12:00:00 AM 3 4x4   6002295.810192 2112602.9289849997 37.78093440458979 -122.435688496636 (37.7809344045898, -122.435688496636)
143672 18582 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 200 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/08/2005 12:00:00 AM 3 3X3   5993482.998785401 2088541.1278418999 37.7143623091404 -122.46442855867399 (37.7143623091404, -122.464428558674)
145771 18583 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 200 Randolph St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/08/2005 12:00:00 AM 3 3X3   5993482.998785401 2088541.1278418999 37.7143623091404 -122.46442855867399 (37.7143623091404, -122.464428558674)
88818 18610 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 615 Randolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2016 12:00:00 AM 3 3x3 Permit Number 778725 5992407.5548851 2088503.1314627 37.7141959284164 -122.468142922603 (37.7141959284164, -122.468142922603)
86323 21844 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 217X Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/09/2000 12:00:00 AM 3 3X3   5994893.74214 2111425.45184 37.777278145464294 -122.461210335739 (37.7772781454643, -122.461210335739)
47439 21845 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 211X Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3X3   5994919.338930001 2111427.06219 37.7772840400997 -122.461121905578 (37.7772840400997, -122.461121905578)
13984 21894 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2068 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2003 12:00:00 AM 3 2X3   6015677.89854 2105976.47682 37.7634906462863 -122.388930084758 (37.7634906462863, -122.388930084758)
14801 22531 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6619 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2015 08:00:00 AM 3 3X3   6012836.07271 2089639.80613 37.7184756630977 -122.397613243265 (37.7184756630977, -122.397613243265)
111482 22572 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 790X Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2001 12:00:00 AM 3 4X4   6006221.944519999 2112852.52787 37.7818419658886 -122.422123780993 (37.7818419658886, -122.422123780993)
108601 22587 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 801 Turk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/06/1997 12:00:00 AM 6 4x4   6006166.11327 2112793.0062543997 37.781675384913605 -122.422312701127 (37.7816753849136, -122.422312701127)
104635 22590 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 801 Turk St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/06/1997 12:00:00 AM 6 4x4   6006166.11327 2112793.0062543997 37.781675384913605 -122.422312701127 (37.7816753849136, -122.422312701127)
127549 22596 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 810X Turk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/1997 12:00:00 AM 3 4x4   6006111.721580001 2112834.13473 37.7817852453704 -122.42250379427601 (37.7817852453704, -122.422503794276)
90153 22597 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 810X Turk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/1997 12:00:00 AM 3 4x4   6006111.721580001 2112834.13473 37.7817852453704 -122.42250379427601 (37.7817852453704, -122.422503794276)
89102 22603 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 888 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/06/1997 12:00:00 AM 6 4X4   6005725.0 2112755.0 37.781546136890796 -122.423836042859 (37.7815461368908, -122.423836042859)
100477 22696 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1390 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/28/1997 12:00:00 AM 6 3X3   6003467.66311 2112468.72246 37.780632399020796 -122.431624898149 (37.7806323990208, -122.431624898149)
144092 22698 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1390 Turk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/28/1997 12:00:00 AM 6 3X3   6003367.49805 2112454.4444 37.7805875170515 -122.43197039694701 (37.7805875170515, -122.431970396947)
89793 22701 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400X Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2001 12:00:00 AM 6 3X3   6003258.39673 2112440.37761 37.7805427074609 -122.432346825159 (37.7805427074609, -122.432346825159)
89638 22703 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1410 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/19/2001 12:00:00 AM 6 3X3   6003133.70477 2112422.88036 37.7804875932729 -122.432776943127 (37.7804875932729, -122.432776943127)
88088 22706 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1420 Turk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/19/2001 12:00:00 AM 6 3X3   6003033.98605 2112410.1866099997 37.7804470833639 -122.433121009687 (37.7804470833639, -122.433121009687)

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" 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");
Powered by Datasette · Query took 1029.24ms · Data source: data.sfgov.org