Street_Tree_List

Data source: data.sfgov.org

884 rows where qSpecies = 100 sorted by PlotSize 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
36940 36940 233930 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 451 Florida St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 9ft   6009251.7265800005 2106253.20346 37.763892184592706 -122.41117579493 (37.7638921845927, -122.41117579493)
39479 39479 234374 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 581 Dolores St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 9ft   6004996.87402 2105008.5457599997 37.760235113069896 -122.425803460464 (37.7602351130699, -122.425803460464)
64753 64753 233931 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 451 Florida St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 9ft   6009251.45318 2106264.05651 37.763921969247704 -122.411177507234 (37.7639219692477, -122.411177507234)
159189 159189 234375 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 581 Dolores St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 9ft   6004995.06327 2105009.72546 37.760238249920604 -122.425809806971 (37.7602382499206, -122.425809806971)
168179 168179 119407 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 375 32nd Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26 Width 9ft   5985884.85714 2113320.57304 37.78195903231371 -122.49251412874399 (37.7819590323137, -122.492514128744)
179975 179975 234373 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 581 Dolores St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 9ft   6004999.25531 2105001.6441599997 37.76021629747461 -122.42579473344401 (37.7602162974746, -122.425794733444)
608 608 233928 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 8 Octavia St Frontage East 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
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)
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)
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)
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)
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)
30590 30590 118002 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 7 Shore View Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5984637.38492 2112844.95185 37.780580098776795 -122.49679463074699 (37.7805800987768, -122.496794630747)
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)
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)
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)
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)
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)
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)
45534 45534 124659 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 199 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     37 Width 8ft   5995478.86593 2115238.56038 37.7877815776324 -122.45946244145901 (37.7877815776324, -122.459462441459)
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)
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)
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)
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)
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)
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)
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)
58200 58200 246535 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1x Octavia St 1 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6005703.308569999 2109325.61851 37.7721286642513 -122.423667182089 (37.7721286642513, -122.423667182089)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
137727 137727 246536 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1x Octavia St 2 Median : Yard 3 Tree 1 DPW 2     31 Width 8ft   6005696.49055 2109344.97624 37.7721814310539 -122.42369214280501 (37.7721814310539, -122.423692142805)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
25380 25380 124656 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1 Presidio Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 7ft   5995441.43994 2115441.36584 37.7883362746058 -122.45960662195401 (37.7883362746058, -122.459606621954)
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)
41054 41054 194324 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     18 Width 7ft   6014719.872819999 2117222.0655900002 37.7943153492131 -122.39303049145701 (37.7943153492131, -122.393030491457)
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)
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)
72003 72003 194321 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     22 Width 7ft   6014800.62587 2117118.44333 37.794035312034104 -122.392743821769 (37.7940353120341, -122.392743821769)
131405 131405 194320 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     23 Width 7ft   6014831.89764 2117081.36813 37.7939352489635 -122.392633022622 (37.7939352489635, -122.392633022622)
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)
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)
137503 137503 234343 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 769 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 7ft   6005056.066269999 2103868.0427200003 37.7571069049763 -122.42551757317601 (37.7571069049763, -122.425517573176)
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)
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)
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)
171516 171516 194323 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     15 Width 7ft   6014746.37404 2117187.8708099998 37.7942229303951 -122.39293639989201 (37.7942229303951, -122.392936399892)
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)
179136 179136 124657 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 30 Presidio Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 7ft   5995444.46973 2115398.79213 37.7882195529326 -122.459593054716 (37.7882195529326, -122.459593054716)
182110 182110 194322 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     22 Width 7ft   6014773.3420400005 2117151.64182 37.7941249519603 -122.392840551058 (37.7941249519603, -122.392840551058)
183295 183295 194277 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1301 Rhode Island St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     48 Width 7ft   6012002.23785 2102241.02504 37.7530294975215 -122.401380567153 (37.7530294975215, -122.401380567153)
185824 185824 234392 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1379 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 7ft   6005257.78896 2100266.47383 37.7472292273428 -122.424563754022 (37.7472292273428, -122.424563754022)
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)
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)
23789 23789 234390 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1600 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 6ft   6005245.617219999 2098983.50062 37.7437057887861 -122.42451459797199 (37.7437057887861, -122.424514597972)
39811 39811 234396 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1351 Douglass St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 6ft   6001401.68154 2099734.75899 37.74555073898829 -122.43785977451701 (37.7455507389883, -122.437859774517)
42292 42292 234344 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 751 Dolores St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6005051.924 2103931.9938 37.757282265587 -122.42553644996299 (37.757282265587, -122.425536449963)
54191 54191 234389 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 1488 Dolores St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 6ft   6005200.95707 2099699.7446 37.7456699090375 -122.424719964457 (37.7456699090375, -122.424719964457)
72691 72691 234342 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 500 Dolores St 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 6ft   6004943.9168300005 2104413.64545 37.7585986644128 -122.425944266413 (37.7585986644128, -122.425944266413)
76588 76588 247039 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 574 Valley St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 6ft   6002246.4280199995 2099186.76685 37.7440940809725 -122.43489959305 (37.7440940809725, -122.43489959305)

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