Street_Tree_List

Data source: data.sfgov.org

884 rows where qSpecies = 100 sorted by XCoord descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▲ YCoord Latitude Longitude Location
31219 31219 194283 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2 Tulare St 1 Front Yard : Yard 7 Tree 1 Private 1     44     6016255.79944 2100318.37917 37.747986718206604 -122.386536741486 (37.7479867182066, -122.386536741486)
151716 151716 194282 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2 Tulare St 6 Front Yard : Yard 7 Tree 1 Private 1     15     6016226.55416 2100307.94064 37.7479564371431 -122.386637143603 (37.7479564371431, -122.386637143603)
54301 54301 194281 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2 Tulare St 11 Front Yard : Yard 7 Tree 1 Private 1     38     6016211.24922 2100302.5214299997 37.7479407097974 -122.38668969007601 (37.7479407097974, -122.386689690076)
35368 35368 194364 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016200.86003 2114659.13107 37.78736027221179 -122.387727152497 (37.7873602722118, -122.387727152497)
70483 70483 194365 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016199.77941 2114766.14566 37.7876540501504 -122.38773836074199 (37.7876540501504, -122.387738360742)
157962 157962 194366 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016195.859569999 2114866.22772 37.78792863564279 -122.387758908461 (37.7879286356428, -122.387758908461)
61369 61369 194368 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016180.02295 2114964.39899 37.7881973143891 -122.38782055336901 (37.7881973143891, -122.387820553369)
76527 76527 194370 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016163.96985 2115051.82185 37.788436468407 -122.387882197423 (37.788436468407, -122.387882197423)
53093 53093 194359 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     33 Width 8ft   6016151.3585 2114078.17293 37.785762350501706 -122.38785786627199 (37.7857623505017, -122.387857866272)
158245 158245 194357 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x King St 4 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016143.59514 2113983.21728 37.7855011936686 -122.387878097405 (37.7855011936686, -122.387878097405)
119303 119303 194372 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016142.80175 2115153.3259099997 37.788714002784296 -122.387962522166 (37.7887140027843, -122.387962522166)
178718 178718 194367 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     32 Width 8ft   6016138.88729 2114959.31506 37.7881810762396 -122.38796252216999 (37.7881810762396, -122.38796252217)
147393 147393 194355 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016135.3126300005 2113894.74213 37.785257802049706 -122.38790057687001 (37.7852578020497, -122.38790057687)
127243 127243 194363 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6016134.25394 2114462.08003 37.7868155249754 -122.387943842344 (37.7868155249754, -122.387943842344)
152768 152768 194354 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6016129.928040001 2113821.08982 37.7850552711313 -122.387914064893 (37.7850552711313, -122.387914064893)
130206 130206 194374 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 11 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016126.62936 2115234.83636 37.788936915964705 -122.388024167087 (37.7889369159647, -122.388024167087)
59423 59423 194280 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2 Tulare St 18 Front Yard : Yard 7 Tree 1 Private 1     3     6016126.44291 2100241.55687 37.747768618243605 -122.38697869801202 (37.7477686182436, -122.386978698012)
25236 25236 194362 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016123.073030001 2114362.8388099996 37.786542411639 -122.38797559828899 (37.786542411639, -122.387975598289)
148681 148681 194369 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6016121.084980001 2115040.32123 37.7884025145026 -122.388029770758 (37.7884025145026, -122.388029770758)
25996 25996 194361 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016114.70966 2114269.45463 37.786285536482296 -122.38799801482 (37.7862855364823, -122.38799801482)
181517 181517 194279 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 2 Tulare St 21 Front Yard : Yard 7 Tree 1 Private 1     4     6016113.78589 2100276.91255 37.7478649967659 -122.387024931273 (37.7478649967659, -122.387024931273)
63682 63682 194360 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016108.030590001 2114179.2623099997 37.786037518748 -122.388014826737 (37.786037518748, -122.388014826737)
183458 183458 194358 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016102.75205 2114084.3299 37.7857765633769 -122.388026462162 (37.7857765633769, -122.388026462162)
164799 164799 194376 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016101.40226 2115318.33028 37.789164773592205 -122.38811727930201 (37.7891647735922, -122.388117279302)
69876 69876 194371 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016101.395269999 2115134.80634 37.7886608582508 -122.388104490939 (37.7886608582508, -122.388104490939)
130277 130277 194351 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 11 Median : Yard 3 Tree 1 DPW 2     31 Width 8ft   6016097.15673 2113420.59165 37.7839537779004 -122.387999487006 (37.7839537779004, -122.387999487006)
138222 138222 194356 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016092.96172 2113985.53296 37.7855047469016 -122.38805343733401 (37.7855047469016, -122.388053437334)
173116 173116 194373 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016083.2484800005 2115225.4963700003 37.7889088670017 -122.38817360834 (37.7889088670017, -122.38817360834)
76413 76413 194348 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     32 Width 8ft   6016063.83562 2113121.68463 37.783131200395296 -122.388093900527 (37.7831312003953, -122.388093900527)
42729 42729 194375 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6016059.60857 2115304.2736400003 37.7891238616108 -122.388260900137 (37.7891238616108, -122.388260900137)
182808 182808 194353 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6016057.99648 2113605.1395799997 37.7844583353237 -122.388147851742 (37.7844583353237, -122.388147851742)
130735 130735 194346 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016057.40985 2113028.64004 37.782875364847705 -122.388109635977 (37.7828753648477, -122.388109635977)
66121 66121 194352 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016055.63748 2113520.42583 37.7842255997618 -122.388150099168 (37.7842255997618, -122.388150099168)
153572 153572 194344 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016049.59347 2112931.0937900003 37.7826070916921 -122.38812986802 (37.7826070916921, -122.38812986802)
168401 168401 194350 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016048.53605 2113426.10211 37.7839662146185 -122.388168082915 (37.7839662146185, -122.388168082915)
182277 182277 194342 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6016043.56926 2112825.74631 37.7823174973895 -122.38814335514999 (37.7823174973895, -122.38814335515)
71598 71598 194349 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     25 Width 8ft   6016039.59045 2113336.99155 37.7837210414445 -122.388192810667 (37.7837210414445, -122.388192810667)
43461 43461 194341 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     25 Width 8ft   6016036.61123 2112738.53497 37.7820776491035 -122.388161338867 (37.7820776491035, -122.388161338867)
33192 33192 194377 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 14 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016027.16358 2115370.7776 37.789304668530896 -122.388377800289 (37.7893046685309, -122.388377800289)
56517 56517 194347 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     32 Width 8ft   6016017.18881 2113128.44937 37.783147190320896 -122.388255753298 (37.7831471903209, -122.388255753298)
163146 163146 194345 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016011.38638 2113034.09815 37.7828878015789 -122.388269240457 (37.7828878015789, -122.388269240457)
182585 182585 194343 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016001.634319999 2112937.23784 37.7826213045779 -122.38829621649799 (37.7826213045779, -122.388296216498)
155383 155383 194338 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 14 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015989.55415 2112403.0150099997 37.781153779156206 -122.388300712233 (37.7811537791562, -122.388300712233)
155521 155521 194340 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 16 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6015972.31673 2112547.01001 37.7815482020175 -122.388370398867 (37.7815482020175, -122.388370398867)
61273 61273 194336 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 12 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015966.10007 2112335.54697 37.7809672274079 -122.38837714201799 (37.7809672274079, -122.388377142018)
173586 173586 194339 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 15 Median : Yard 3 Tree 1 DPW 2     21 Width 8ft   6015964.49017 2112481.16819 37.781366981449295 -122.388392878343 (37.7813669814493, -122.388392878343)
126124 126124 25683 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 3X3   6015960.62101 2112553.15201 37.781564418481004 -122.388411289639 (37.781564418481, -122.388411289639)
35716 35716 194337 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 13 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6015953.29851 2112409.5704799998 37.781169770014294 -122.38842659752198 (37.7811697700143, -122.388426597522)
78913 78913 25684 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
27329 27329 194334 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 10 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015942.04821 2112270.67914 37.7807877820727 -122.388455820993 (37.7807877820727, -122.388455820993)
78875 78875 27848 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
29064 29064 194335 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 11 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015932.5598 2112347.87113 37.7809992081901 -122.38849403588999 (37.7809992081901, -122.38849403589)
120266 120266 27849 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015921.55801 2112354.58401 37.7810170305764 -122.388532565578 (37.7810170305764, -122.388532565578)
55186 55186 194332 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 8 Median : Yard 3 Tree 1 DPW 2     33 Width 8ft   6015905.66871 2112206.70701 37.7806101129033 -122.38857720969601 (37.7806101129033, -122.388577209696)
51725 51725 194333 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 9 Median : Yard 3 Tree 1 DPW 2     31 Width 8ft   6015903.377169999 2112286.3418900003 37.78082864545979 -122.38859069771999 (37.7808286454598, -122.38859069772)
109189 109189 27850 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015895.51701 2112292.73501 37.7808457639334 -122.38861833648701 (37.7808457639334, -122.388618336487)
29492 29492 194379 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015888.45756 2115624.95631 37.7899948982019 -122.388875463533 (37.7899948982019, -122.388875463533)
55101 55101 194331 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 7 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015869.7392 2112229.4323400003 37.7806705203569 -122.388703094985 (37.7806705203569, -122.388703094985)
46468 46468 194330 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 6 Median : Yard 3 Tree 1 DPW 2     32 Width 8ft   6015863.586519999 2112149.96757 37.780451986896296 -122.38871883132 (37.7804519868963, -122.38871883132)
139983 139983 27851 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015857.5390099995 2112236.31101 37.7806887314792 -122.388745782008 (37.7806887314792, -122.388745782008)
134092 134092 194378 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6015852.133669999 2115594.9283 37.7899104347693 -122.388999044794 (37.7899104347693, -122.388999044794)
59677 59677 194329 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 5 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6015829.09984 2112179.7817 37.7805319384279 -122.388840220015 (37.7805319384279, -122.388840220015)
153149 153149 194381 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6015827.50848 2115690.11268 37.79017042428 -122.389090895237 (37.79017042428, -122.389090895237)
117445 117445 27852 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015817.39201 2112182.05801 37.780537539741395 -122.388880882265 (37.7805375397414, -122.388880882265)
164090 164090 194328 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 4 Median : Yard 3 Tree 1 DPW 2     32 Width 8ft   6015816.38649 2112097.21372 37.7803045205874 -122.388878435804 (37.7803045205874, -122.388878435804)
42530 42530 194380 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015792.97899 2115653.31942 37.79006748427221 -122.38920779542102 (37.7900674842722, -122.389207795421)
156409 156409 194327 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 3 Median : Yard 3 Tree 1 DPW 2     25 Width 8ft   6015782.92624 2112129.67425 37.780391795274 -122.388996458319 (37.780391795274, -122.388996458319)
139779 139779 27853 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 8 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015772.90401 2112134.31501 37.780403982219205 -122.389031454309 (37.7804039822192, -122.389031454309)
135215 135215 194383 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6015768.92359 2115752.8180400003 37.7903393511162 -122.389297976729 (37.7903393511162, -122.389297976729)
162596 162596 194326 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 2 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015764.48229 2112042.08861 37.7801502823482 -122.38905414805599 (37.7801502823482, -122.389054148056)
170290 170290 194382 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6015730.53426 2115716.1031299997 37.7902364120368 -122.389428237241 (37.7902364120368, -122.389428237241)
168851 168851 194325 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 88 King St 1 : 4 Tree 1 Private 1     31 Width 8ft   6015700.5691599995 2111985.57661 37.779991570003205 -122.38927130734601 (37.7799915700032, -122.389271307346)
154122 154122 194384 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6015676.83265 2115781.59367 37.7904132565166 -122.38961861831699 (37.7904132565166, -122.389618618317)
48046 48046 194385 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6015616.39603 2115848.18198 37.7905927414207 -122.38983237995701 (37.7905927414207, -122.389832379957)
151971 151971 194274 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1150x Tennessee St 17 Median : Yard 3 Tree 1 DPW 2     28     6015578.255919999 2103421.32087 37.756469211897 -122.389096301947 (37.756469211897, -122.389096301947)
152917 152917 194273 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1150x Tennessee St 16 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   6015573.17514 2103426.7647700002 37.7564838780418 -122.38911425333 (37.7564838780418, -122.38911425333)
170719 170719 194307 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 200x The Embarcadero 1 Median : Cutout 11 Tree 1 DPW 2     25 Width 5ft   6015377.01126 2116388.0666 37.792061862225204 -122.39069838843399 (37.7920618622252, -122.390698388434)
151072 151072 194308 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 200x The Embarcadero 2 Median : Cutout 11 Tree 1 DPW 2     26 Width 5ft   6015341.48875 2116462.31194 37.792263751921 -122.39082648876999 (37.792263751921, -122.39082648877)
56280 56280 194309 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 380 The Embarcadero 1 : 4 Tree 1 Private 1     24 Width 7ft   6015233.93882 2116624.33128 37.79270265166021 -122.39120994708 (37.7927026516602, -122.39120994708)
26160 26160 194311 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     21 Width 7ft   6015171.2298099995 2116694.38601 37.79289152546961 -122.39143182424401 (37.7928915254696, -122.391431824244)
94674 94674 27870 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   01/31/2001 12:00:00 AM 24 4X4   6015155.50001 2116672.0830099997 37.79282941355329 -122.391484690649 (37.7928294135533, -122.391484690649)
133391 133391 194310 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     20 Width 7ft   6015149.43028 2116672.0498900004 37.7928289857212 -122.39150569005301 (37.7928289857212, -122.391505690053)
14133 14133 29536 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015127.6919 2091149.846 37.7227492757118 -122.38979741293699 (37.7227492757118, -122.389797412937)
187874 187874 194313 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     12 Width 7ft   6015116.8381 2116756.98357 37.793060384871 -122.391624402345 (37.793060384871, -122.391624402345)
118790 118790 27869 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800 The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   01/31/2001 12:00:00 AM 24 4X4   6015100.81301 2116738.49001 37.7930087163181 -122.39167855690701 (37.7930087163181, -122.391678556907)
70019 70019 194312 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     25 Width 7ft   6015090.90053 2116737.38808 37.7930051404365 -122.391712777831 (37.7930051404365, -122.391712777831)
13733 13733 29537 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2600X Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6015071.7012 2091079.6967 37.7225535544976 -122.38998606447299 (37.7225535544976, -122.389986064473)
160227 160227 194315 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     20 Width 7ft   6015053.743430001 2116822.79374 37.793237581902105 -122.391847319118 (37.7932375819021, -122.391847319118)
115406 115406 27868 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   01/31/2001 12:00:00 AM 24 4X4   6015038.31301 2116806.19801 37.793191157262704 -122.39189954881 (37.7931911572627, -122.39189954881)
136668 136668 194314 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     20 Width 7ft   6015030.092180001 2116803.1524 37.793182338337296 -122.39192778056601 (37.7931823383373, -122.391927780566)
162235 162235 194317 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     22 Width 7ft   6014996.79198 2116890.75749 37.7934210328094 -122.392049131461 (37.7934210328094, -122.392049131461)
125282 125282 27867 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800 The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   01/31/2001 12:00:00 AM 24 4X4   6014979.71901 2116870.00001 37.7933630896865 -122.392106753362 (37.7933630896865, -122.392106753362)
186747 186747 194316 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     26 Width 7ft   6014969.23068 2116866.2603700003 37.793352239169295 -122.392142782374 (37.7933522391693, -122.392142782374)
107507 107507 96673 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1449 Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4x4   6014955.39834 2095258.9558 37.7340225115191 -122.390680007822 (37.7340225115191, -122.390680007822)
174052 174052 194319 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 11 Median : Yard 3 Tree 1 DPW 2     19 Width 7ft   6014937.91263 2116957.6212 37.793601355862705 -122.392257538577 (37.7936013558627, -122.392257538577)
109422 109422 27866 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 800 The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   01/31/2001 12:00:00 AM 24 4X4   6014921.77607 2116935.19701 37.793538888238395 -122.39231180375 (37.7935388882384, -122.39231180375)
152011 152011 194318 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     24 Width 7ft   6014918.376630001 2116934.10067 37.7935356891802 -122.392323489462 (37.7935356891802, -122.392323489462)
14829 14829 95065 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 4801 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6014916.5089 2095299.5463 37.7341318071091 -122.390817297505 (37.7341318071091, -122.390817297505)
32439 32439 194391 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 828x Jamestown Ave 4 Median : Cutout 11 Tree 1 DPW 2     19 Width 5ft   6014866.8225 2088973.5540099998 37.7167591360948 -122.39054719349899 (37.7167591360948, -122.390547193499)
81526 81526 103927 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 13 Median : Cutout 11 Tree 1 DPW 2   02/05/2001 12:00:00 AM   4x4   6014859.0 2117030.0 37.793795709183996 -122.392535650186 (37.793795709184, -122.392535650186)

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 746.179ms · Data source: data.sfgov.org