Street_Tree_List

Data source: data.sfgov.org

11,394 rows where qSpecies = 15

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25 23567 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2975 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/27/1992 12:00:00 AM 3 3X3   6005531.337230001 2120589.48411 37.803046726686894 -122.42506362870199 (37.8030467266869, -122.425063628702)
28 21823 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2741 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/19/2006 12:00:00 AM 3 4x4   6008229.33947 2122327.41953 37.8079706947476 -122.415850241604 (37.8079706947476, -122.415850241604)
33 2889 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1545 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3X3   6006951.47041 2116025.01423 37.79059395549061 -122.419825138035 (37.7905939554906, -122.419825138035)
36 13434 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2X Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4X4   6014136.36792 2117295.16476 37.7944836321678 -122.39505462349199 (37.7944836321678, -122.395054623492)
55 2909 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1700 California St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 4X4   6006037.49643 2115968.63965 37.7903876339283 -122.422983431149 (37.7903876339283, -122.422983431149)
72 25725 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 729 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6004286.7153 2111148.1106 37.777052715887706 -122.428697236196 (37.7770527158877, -122.428697236196)
75 138824 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 729 GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6004305.1004 2111150.1162 37.77705926326529 -122.428633779399 (37.7770592632653, -122.428633779399)
111 7749 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 400X Franklin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6006371.15759 2111615.2483900003 37.7784531123456 -122.421519673008 (37.7784531123456, -122.421519673008)
157 3193 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3698 California St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   5996969.37189 2114704.2549799997 37.7864001056199 -122.454266992435 (37.7864001056199, -122.454266992435)
178 2985 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2253 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     65 3X3   6003588.0004 2115559.2302 37.789124975971106 -122.431429279776 (37.7891249759711, -122.431429279776)
180 18700 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 100X Richardson Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5999457.6873699995 2119517.78462 37.799759164102895 -122.44600442526199 (37.7997591641029, -122.446004425262)
200 134567 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.778466176805296 -122.417399738421 (37.7784661768053, -122.417399738421)
203 134565 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     15 Width 4ft   6007431.26589 2111583.6583 37.7784260904314 -122.41785010990299 (37.7784260904314, -122.417850109903)
205 134566 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     14 Width 4ft   6007493.55732 2111589.9734900002 37.7784469358085 -122.417635067622 (37.7784469358085, -122.417635067622)
209 134568 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   12/17/2009 12:00:00 AM 5 Width 4ft   6007669.37768 2111613.23365 37.778520694605795 -122.41702848568501 (37.7785206946058, -122.417028485685)
210 13438 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2X Market St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2002 12:00:00 AM 6 4x4   6014077.43398 2117238.82075 37.794325647358704 -122.395254594939 (37.7943256473587, -122.395254594939)
214 251244 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 99 Grove St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.778441154342296 -122.41816626519301 (37.7784411543423, -122.418166265193)
227 13622 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 562 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4x4   6012358.746590001 2115584.5782 37.789687756343604 -122.401085198325 (37.7896877563436, -122.401085198325)
243 2928 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1834 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6005568.20527 2115901.70542 37.7901773571486 -122.42460238530501 (37.7901773571486, -122.424602385305)
248 23733 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 800X Webster St 8 Median : Cutout 11 Tree 1 DPW 2     35 20   6003923.026000001 2111743.9893 37.7786682616238 -122.429997867276 (37.7786682616238, -122.429997867276)
319 3139 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3320 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   5998401.91704 2114901.9804700003 37.7870250535005 -122.449325021743 (37.7870250535005, -122.449325021743)
345 13664 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 648 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6011893.33766 2115132.41268 37.788420242855395 -122.402663664993 (37.7884202428554, -122.402663664993)
346 235602 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 721 Valencia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006265.751680001 2105377.56697 37.761319982338904 -122.421441210755 (37.7613199823389, -122.421441210755)
353 13824 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 964 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 4x4   6009889.5706 2113199.7435 37.7830015179357 -122.40945995866699 (37.7830015179357, -122.409459958667)
356 5230 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1051 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2004 12:00:00 AM 3 4x4   6001389.4157 2112056.3671 37.7793821590717 -122.43878497743201 (37.7793821590717, -122.438784977432)
367 235603 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 715 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 3ft   6006265.7166 2105404.69213 37.7613944596986 -122.42144325851002 (37.7613944596986, -122.42144325851)
370 3092 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2980 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000114.4381800005 2115142.33295 37.7877828069853 -122.443417371621 (37.7877828069853, -122.443417371621)
405 13887 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1028 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6009423.7082400005 2112763.96692 37.781778865529105 -122.411040866943 (37.7817788655291, -122.411040866943)
408 23369 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1350 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 4x4   6006387.07969 2115184.64805 37.788254707334 -122.421718185767 (37.788254707334, -122.421718185767)
418 23307 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1000 Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/01/2014 12:00:00 AM 2 3x3   6006542.6232900005 2114014.0044299997 37.785049178209206 -122.421096875635 (37.7850491782092, -122.421096875635)
419 13971 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1150X Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6008925.3091 2112314.2981 37.780516220741 -122.412733301341 (37.780516220741, -122.412733301341)
422 23174 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 240 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     5 3x3   6006908.21847 2111432.04348 37.777980343250796 -122.419648771078 (37.7779803432508, -122.419648771078)
423 109554 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300x Van Ness Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006839.87541 2111919.81075 37.7793157843461 -122.41991981597201 (37.7793157843461, -122.419919815972)
425 251299 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
428 14314 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 4X4   6003589.1349 2107204.4091 37.766184772649495 -122.430828874247 (37.7661847726495, -122.430828874247)
431 251298 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
432 251297 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
435 95185 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1401X Divisadero St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6001223.4102 2113260.1588 37.78267801898829 -122.43944557401699 (37.7826780189883, -122.439445574017)
446 251296 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
449 200971 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1408 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5 Width 0ft Permit Number 779898 6007408.8361 2110843.7597 37.7763932439775 -122.417875241075 (37.7763932439775, -122.417875241075)
453 200966 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1438 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 Width 0ft Permit Number 779897 6007276.3996 2110716.1923 37.776035520315205 -122.418324330264 (37.7760355203152, -122.418324330264)
476 174954 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1400x Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4xt Permit Number 779898 6007316.0 2110809.0 37.776292577113104 -122.418193923043 (37.7762925771131, -122.418193923043)
477 14079 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1420 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4 Permit Number 779898 6007326.0633 2110762.9345 37.7761666587056 -122.418155844592 (37.7761666587056, -122.418155844592)
480 200973 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1416 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 Width 0ft Permit Number 779898 6007323.0 2110807.0 37.7762874795996 -122.41816956622401 (37.7762874795996, -122.418169566224)
481 14087 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1446 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4 Permit Number 779892 6007224.7884 2110663.6072 37.775888228839705 -122.418499137854 (37.7758882288397, -122.418499137854)
488 2821 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1100X California St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6008831.67633 2116355.92064 37.7916082855564 -122.41334312239701 (37.7916082855564, -122.413343122397)
489 200974 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1422 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 Width 0ft Permit Number 779898 6007323.0 2110807.0 37.7762874795996 -122.41816956622401 (37.7762874795996, -122.418169566224)
493 14089 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1446X Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4 Permit Number 779892 6007243.2905 2110686.0046 37.7759507683181 -122.418436722662 (37.7759507683181, -122.418436722662)
494 14085 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1446 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4 Permit Number 779892 6007257.8975 2110700.6115 37.775991697649104 -122.418387229062 (37.7759916976491, -122.418387229062)
502 18680 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 150X Richardson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 15X15TR   5999310.287959999 2119651.54595 37.8001180187875 -122.446524108406 (37.8001180187875, -122.446524108406)
521 5204 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 777 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 04/21/2016 12:00:00 AM 3 4X4   6001528.9942 2111019.6475 37.7765435284866 -122.438227828795 (37.7765435284866, -122.438227828795)
534 2998 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2314 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6003265.59996 2115577.92692 37.7891580349704 -122.43254607984501 (37.7891580349704, -122.432546079845)
535 13638 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 576 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4x4   6012273.72895 2115490.3220900004 37.7894242082171 -122.40137272597799 (37.7894242082171, -122.401372725978)
537 195070 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1532 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
550 3006 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2380 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     75 3X3   6002989.49365 2115542.57517 37.7890453067372 -122.433498845012 (37.7890453067372, -122.433498845012)
567 195068 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1532 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
584 14069 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1390 Market St 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6007575.3554 2111000.5411 37.7768330981624 -122.417310315452 (37.7768330981624, -122.417310315452)
589 26916 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1901 Geary Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     18 3X3   6002555.1851 2113680.9302 37.783909052953 -122.43486830704398 (37.783909052953, -122.434868307044)
612 23503 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2550 Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6005820.29029 2119236.56275 37.7993482683535 -122.42396743424999 (37.7993482683535, -122.42396743425)
614 2880 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1477 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6007321.86349 2116079.14078 37.7907634327304 -122.41854743611 (37.7907634327304, -122.41854743611)
647 13705 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 750 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6011215.546569999 2114485.16599 37.786605191509295 -122.404963137048 (37.7866051915093, -122.404963137048)
730 195047 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 360 06th St 2 : 4 Tree 1 DPW 2   03/26/2005 12:00:00 AM 3 Width 3ft Permit Number 42039 6011214.59355 2111232.18316 37.777673209496605 -122.404737337955 (37.7776732094966, -122.404737337955)
732 25708 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 586 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 3X3   6012145.80041 2110254.86265 37.77504171494321 -122.40144725460199 (37.7750417149432, -122.401447254602)
748 195045 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 312 06th St 1 : 4 Tree 1 DPW 2     10 Width 3ft   6010980.17572 2111476.79231 37.7783317443601 -122.40556550564501 (37.7783317443601, -122.405565505645)
761 195041 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 402 06th St 1 : 4 Tree 1 DPW 2     28 Width 3ft   6011480.36813 2111044.01847 37.777171403968296 -122.40380468436199 (37.7771714039683, -122.403804684362)
777 234744 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2455 15th St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     12 Width 3ft   6001486.4222099995 2107220.2274599997 37.766108846174795 -122.438102867577 (37.7661088461748, -122.438102867577)
778 100816 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 261 06th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 3x3   6010798.79921 2111766.85068 37.779118033309395 -122.406213398837 (37.7791180333094, -122.406213398837)
779 14058 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1390 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6007799.3288 2111218.6717 37.7774446311696 -122.416550977219 (37.7774446311696, -122.416550977219)
803 5878 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1090 Eddy St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6005272.8038 2113070.2583 37.7823862204069 -122.425422868476 (37.7823862204069, -122.425422868476)
861 109545 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300x Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006870.4118800005 2111707.44564 37.778734401395205 -122.419799104459 (37.7787344013952, -122.419799104459)
889 3094 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3006 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X2   5999959.6352699995 2115120.4195 37.7877138091859 -122.443951383666 (37.7877138091859, -122.443951383666)
917 8555 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2141 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3X3   6001312.669 2113446.883 37.7831957953331 -122.43915016448999 (37.7831957953331, -122.43915016449)
931 13827 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 964 Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 4X4   6009845.6649 2113195.3529 37.7829870022194 -122.409611544992 (37.7829870022194, -122.409611544992)
942 139350 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1400 GEARY BLVD 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 0ft   6004774.9676 2114125.1051 37.785254427644404 -122.427220325156 (37.7852544276444, -122.427220325156)
956 139346 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1400 GEARY BLVD 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6004901.3702 2114140.1368 37.7853028484475 -122.426784081516 (37.7853028484475, -122.426784081516)
958 139734 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1451 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 Width 0ft   6004831.5288 2113994.8119 37.784899873448204 -122.42701535739799 (37.7848998734482, -122.427015357398)
962 139345 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1400 GEARY BLVD 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     13 Width 0ft   6004932.8001 2114145.6028 37.7853196336912 -122.426675732937 (37.7853196336912, -122.426675732937)
964 139348 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1400 GEARY BLVD 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6004841.9268 2114136.7205 37.7852901070824 -122.426989494298 (37.7852901070824, -122.426989494298)
975 251421 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 300X King St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 09/30/2014 01:37:00 PM   3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
989 2976 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2187 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X2   6003939.8571 2115601.6948 37.7892615083399 -122.43021493095699 (37.7892615083399, -122.430214930957)
997 95184 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1401X Divisadero St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6001220.026000001 2113275.7262 37.7827205704951 -122.439458398161 (37.7827205704951, -122.439458398161)
1023 24311 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2639 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20     6006902.669840001 2121389.92308 37.8053218972443 -122.420374939461 (37.8053218972443, -122.420374939461)
1026 13476 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 200X Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4x4   6013666.75675 2116818.6011799998 37.7931489752948 -122.396646124018 (37.7931489752948, -122.396646124018)
1028 13480 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 200X Market St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     50 4X4   6013615.86639 2116768.91037 37.7930097035807 -122.396818723722 (37.7930097035807, -122.396818723722)
1061 7724 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 211 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/16/2012 12:00:00 AM 3 3x3 Permit Number 767727 6006415.79653 2110907.1088900003 37.7765112494182 -122.421314949539 (37.7765112494182, -122.421314949539)
1066 23276 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 819 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 4x4   6006534.60812 2113350.76252 37.7832276265901 -122.421077496141 (37.7832276265901, -122.421077496141)
1075 245468 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3290 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/29/2004 12:00:00 AM 9 Width 0ft   6006293.2609 2099139.2598 37.7441925761806 -122.420903147917 (37.7441925761806, -122.420903147917)
1085 245467 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3286 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/10/2004 12:00:00 AM 6 Width 0ft   6006306.9956 2099162.9834 37.7442584900037 -122.42085734017799 (37.7442584900037, -122.420857340178)
1115 2987 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2266X California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6003539.7936 2115618.85396 37.7892859554236 -122.431600327591 (37.7892859554236, -122.431600327591)
1123 28040 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1500 The Embarcadero 8 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6011973.34792 2120976.9306 37.8044723526732 -122.40279804081499 (37.8044723526732, -122.402798040815)
1133 13945 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1100 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/24/2000 12:00:00 AM 12 4x4   6009115.3446 2112460.3733 37.7809279727613 -122.412086202614 (37.7809279727613, -122.412086202614)
1136 3286 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 4620 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   5993188.57682 2114188.1560400003 37.784765502430794 -122.467309935148 (37.7847655024308, -122.467309935148)
1147 14071 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1390 Market St 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6007529.5869 2110959.6416 37.7767182228199 -122.41746574362101 (37.7767182228199, -122.417465743621)
1151 13977 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1150X Market St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6008909.6011 2112263.4341 37.780375678658295 -122.412784045926 (37.7803756786583, -122.412784045926)
1163 2939 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1910 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4x4   6005122.54257 2115837.0032200003 37.789974522242105 -122.42613973678499 (37.7899745222421, -122.426139736785)
1168 218199 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 819 Ulloa St 1 : 4 Tree 1 DPW 2     13 Width 3ft   5993346.67502 2098141.32486 37.740714236277 -122.46559677389799 (37.740714236277, -122.465596773898)
1198 3004 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2361 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     45 3X3   6003049.1023 2115481.5645 37.788881168762295 -122.433288245694 (37.7888811687623, -122.433288245694)
1218 23334 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1200 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3X3   6006464.90313 2114643.01968 37.7867719177417 -122.42141044944701 (37.7867719177417, -122.421410449447)
1238 3124 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3200 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5998922.57289 2114976.7733400003 37.7872601830687 -122.44752906213199 (37.7872601830687, -122.447529062132)
1253 3161 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3445 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   5997946.3873 2114759.1135 37.7866067115462 -122.450890739631 (37.7866067115462, -122.450890739631)

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