Street_Tree_List

Data source: data.sfgov.org

11,394 rows where qSpecies = 15

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1284 235428 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2869 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/09/2016 12:00:00 AM 3 3x3   6010306.81938 2100635.6894799997 37.74852686004171 -122.40713053105101 (37.7485268600417, -122.407130531051)
1285 234575 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2990 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/09/2016 12:00:00 AM 3 Width 3ft   6009677.1610900005 2100624.0529099996 37.7484596510092 -122.409307067568 (37.7484596510092, -122.409307067568)
1291 234571 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2892 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/09/2017 12:00:00 AM 3 3x4   6010196.53099 2100680.54575 37.7486438528311 -122.407515070373 (37.7486438528311, -122.407515070373)
1292 3043 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2669 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     14 3x3   6001621.1928 2115287.1562 37.7882662649831 -122.43821467397 (37.7882662649831, -122.43821467397)
1318 100805 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2429 Jackson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6002563.2899400005 2116751.5140400003 37.79234055221529 -122.43505995207899 (37.7923405522153, -122.435059952079)
1319 23465 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2305 Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6005845.91849 2118326.2505200002 37.796850228717105 -122.42381398834699 (37.7968502287171, -122.423813988347)
1330 2943 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1946 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     75 4X4   6005029.19291 2115824.37334 37.7899345671834 -122.426461819067 (37.7899345671834, -122.426461819067)
1394 2927 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1820 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 3X3   6005591.4546 2115905.84085 37.7901900249849 -122.424522238615 (37.7901900249849, -122.424522238615)
1415 9957 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 165X Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4x4   6007023.214790001 2111521.59802 37.778232715494205 -122.41925731148399 (37.7782327154942, -122.419257311484)
1429 102682 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 4x4   6001423.65551 2115717.83054 37.7894375487454 -122.438928994703 (37.7894375487454, -122.438928994703)
1478 2891 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1555 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3x3   6006907.6574099995 2116020.89539 37.7905801778777 -122.419976436385 (37.7905801778777, -122.419976436385)
1506 3068 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2848 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6000738.310819999 2115229.75603 37.788058406004296 -122.441265170758 (37.7880584060043, -122.441265170758)
1575 246375 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2248 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     11 Width 0ft   6003217.3444 2106843.7794 37.765173499092995 -122.43208906900499 (37.765173499093, -122.432089069005)
1576 246374 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2248 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 Width 0ft   6003241.3918 2106872.8368 37.765254647007296 -122.432007970015 (37.7652546470073, -122.432007970015)
1584 3173 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3506 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/01/1992 12:00:00 AM 6 3X3   5997608.68374 2114790.70836 37.786674124564 -122.45206138623301 (37.786674124564, -122.452061386233)
1586 98725 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     14 3x3   6006216.75471 2111460.37935 37.7780191723707 -122.42204280683501 (37.7780191723707, -122.422042806835)
1588 246373 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2248 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 Width 0ft   6003269.4472 2106896.8842 37.7653222658326 -122.431912650355 (37.7653222658326, -122.431912650355)
1596 14066 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1390 Market St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6007645.4688 2111067.7331 37.7770215357502 -122.41707253353701 (37.7770215357502, -122.417072533537)
1612 13833 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 970 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 4x4   6009828.1026 2113177.7906 37.782937796191504 -122.40967106357901 (37.7829377961915, -122.409671063579)
1655 13618 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 554 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 4x4   6012397.92719 2115620.9372799997 37.7897897754213 -122.400952192186 (37.7897897754213, -122.400952192186)
1664 26404 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 34 Maple St 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     3 10   5996581.1026099995 2115987.02812 37.7898999837554 -122.455703055979 (37.7898999837554, -122.455703055979)
1665 251650 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 101X Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3            
1671 13627 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 570 Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4x4   6012289.31562 2115520.12346 37.789506905374395 -122.401320892642 (37.7895069053744, -122.401320892642)
1676 23357 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1300X Van Ness Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/26/2017 12:00:00 AM 3 3X3   6006405.911169999 2115051.67043 37.78789064557179 -122.4216435834 (37.7878906455718, -122.4216435834)
1685 251478 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2x Virginia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 DPW 4 02/21/2004 12:00:00 AM   3x3   6006146.0 2098692.0 37.7429562000135 -122.42138058886101 (37.7429562000135, -122.421380588861)
1692 2957 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2045 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004590.8896 2115694.3359 37.7895527302687 -122.427969040021 (37.7895527302687, -122.427969040021)
1721 23308 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1000 Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/1998 12:00:00 AM 5 3X3   6006538.20918 2114040.94612 37.785122904641796 -122.42111406077 (37.7851229046418, -122.42111406077)
1732 134349 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 838 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 Width 4ft   6010747.0 2114018.0 37.7852962621335 -122.40655126994301 (37.7852962621335, -122.406551269943)
1733 200858 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1133 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6008786.0 2112009.0 37.7796701249263 -122.413193644333 (37.7796701249263, -122.413193644333)
1738 13966 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1127 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 4x4   6008823.0 2112045.0 37.7797710494845 -122.413068191044 (37.7797710494845, -122.413068191044)
1740 200859 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1133 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 0ft   6008786.0 2112009.0 37.7796701249263 -122.413193644333 (37.7796701249263, -122.413193644333)
1741 28362 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3467 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/29/2004 12:00:00 AM 6 4x4   6005809.8912 2098114.7936 37.7413523657119 -122.422501756572 (37.7413523657119, -122.422501756572)
1743 200855 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1101 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 Width 0ft   6008978.4093 2112218.7143 37.7802567505844 -122.412542843301 (37.7802567505844, -122.412542843301)
1753 134350 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 838 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6010747.0 2114018.0 37.7852962621335 -122.40655126994301 (37.7852962621335, -122.406551269943)
1754 245399 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3467 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 4x4   6005818.4513 2098127.8856 37.7413887962973 -122.42247308874201 (37.7413887962973, -122.422473088742)
1755 13965 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1127 Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 4x4   6008823.0 2112045.0 37.7797710494845 -122.413068191044 (37.7797710494845, -122.413068191044)
1756 13756 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 838 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 4X4   6010747.0 2114018.0 37.7852962621335 -122.40655126994301 (37.7852962621335, -122.406551269943)
1761 200862 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1131 Market St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 Width 0ft   6008817.7245 2112082.7382 37.7798743734467 -122.41308911055201 (37.7798743734467, -122.413089110552)
1762 200860 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1131 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 Width 0ft   6008794.0112 2112059.0249 37.779807931141 -122.413169468366 (37.779807931141, -122.413169468366)
1763 200861 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1131 Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 Width 0ft   6008800.2278 2112051.2202 37.7797868502892 -122.41314741030199 (37.7797868502892, -122.413147410302)
1774 3070 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2860 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000658.3248 2115217.6526099998 37.788020616507104 -122.44154103868799 (37.7880206165071, -122.441541038688)
1831 28370 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1201 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/15/2005 12:00:00 AM 3 2X3   6001320.7065 2112568.2554 37.780783765197604 -122.43905936736999 (37.7807837651976, -122.43905936737)
1847 23549 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2835 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/27/2011 12:00:00 AM 3 3x3   6005591.52339 2120155.8854900002 37.8018595757201 -122.424824487257 (37.8018595757201, -122.424824487257)
1888 100797 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2471 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6002362.24857 2116725.90576 37.7922588209311 -122.435753725979 (37.7922588209311, -122.435753725979)
1890 245384 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3243 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/22/2005 12:00:00 AM 5 Width 0ft   6006512.1787 2099413.785 37.7449586977694 -122.420165655704 (37.7449586977694, -122.420165655704)
1899 25838 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 800X The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/30/1995 12:00:00 AM 6 4X4   6013225.308119999 2119220.74162 37.7997201038678 -122.39834219506099 (37.7997201038678, -122.398342195061)
1901 23857 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1400X Webster St 2 Median : Cutout 11 Tree 1 DPW 2     20 3X3   6003664.511 2113605.5032 37.7837648703142 -122.431025065183 (37.7837648703142, -122.431025065183)
1914 99186 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1961 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/24/2015 09:44:00 AM 3 3x3   6005002.72434 2115722.82694 37.7896542499749 -122.426546164276 (37.7896542499749, -122.426546164276)
1925 2958 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2055 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6004523.0139999995 2115687.6045 37.7895304073237 -122.428203402517 (37.7895304073237, -122.428203402517)
1954 20331 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 101X Sunset Blvd 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
1964 238618 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4302 24th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     14 Width 4ft   6001078.53558 2101746.02342 37.751054810249 -122.439121284114 (37.751054810249, -122.439121284114)
1974 238616 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4302 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     23 Width 4ft   6001186.94921 2101750.3744 37.7510729252903 -122.43874669133301 (37.7510729252903, -122.438746691333)
1975 238619 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4302 24th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     23 Width 4ft   6001066.93276 2101745.60422 37.7510529990026 -122.43916137771099 (37.7510529990026, -122.439161377711)
1989 133618 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 150 Richardson Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   5999272.2292 2119684.41545 37.8002060956892 -122.446658172159 (37.8002060956892, -122.446658172159)
2018 238617 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 4302 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2012 12:00:00 AM 5 Width 4ft Permit Number 769743 6001157.09349 2101748.35409 37.751065679453504 -122.438849790481 (37.7510656794535, -122.438849790481)
2024 139198 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1900 GEARY BLVD 26 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     18 Width 0ft   6001803.3539 2113704.6103 37.783931357581395 -122.437471057097 (37.7839313575814, -122.437471057097)
2033 139199 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1900 GEARY BLVD 27 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     19 Width 0ft   6001773.0984 2113703.8723 37.7839276110688 -122.437575676931 (37.7839276110688, -122.437575676931)
2041 13773 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 870 Market St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 4x4   6010487.82969 2113786.8175 37.7846469870112 -122.407431620471 (37.7846469870112, -122.407431620471)
2048 143400 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1150 MARKET ST 27 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 Width 0ft   6008592.8234 2111992.2193 37.779613202213994 -122.41386074083401 (37.779613202214, -122.413860740834)
2051 3179 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 3560 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3X2   5997388.758280001 2114760.01365 37.7865772450958 -122.45282005522101 (37.7865772450958, -122.452820055221)
2064 23285 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 850 Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6006625.13758 2113482.84587 37.783595398064996 -122.42077367996401 (37.783595398065, -122.420773679964)
2070 109552 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300x Van Ness Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006854.31545 2111807.2543900004 37.7790075453087 -122.419861872643 (37.7790075453087, -122.419861872643)
2087 252878 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 300X King St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3     3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
2088 3013 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2450 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6002627.84431 2115492.11411 37.7888862283618 -122.43474649336599 (37.7888862283618, -122.434746493366)
2089 195741 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 280 King St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 4ft   6014483.0 2111149.0 37.7776269440566 -122.39342489592899 (37.7776269440566, -122.393424895929)
2090 25842 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 800X The Embarcadero 6 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   10/30/1995 12:00:00 AM 6 4X4   6013279.137069999 2119139.97441 37.799501334781795 -122.398150256355 (37.7995013347818, -122.398150256355)
2096 200850 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6007584.0 2110630.0 37.77581616716321 -122.417254147161 (37.7758161671632, -122.417254147161)
2101 143399 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1150 MARKET ST 26 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 Width 0ft   6008612.8747 2111976.4646 37.779571069624 -122.413790259796 (37.779571069624, -122.413790259796)
2104 140318 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1170 MARKET ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     7 Width 0ft   6008545.5594 2111947.8198 37.779488637316206 -122.414021106074 (37.7794886373162, -122.414021106074)
2108 98580 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 370 Drumm St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/22/2017 12:00:00 AM 3 3x3   6013585.68076 2118314.1263900003 37.7972508218322 -122.397031561762 (37.7972508218322, -122.397031561762)
2112 13981 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1150X Market St 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6008866.9651 2112266.4261 37.7803815007944 -122.412931755866 (37.7803815007944, -122.412931755866)
2114 107983 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 15 2405x Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6001231.007069999 2116743.47753 37.7922427464694 -122.43966909537599 (37.7922427464694, -122.439669095376)
2131 2996 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2300 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 3X3   6003308.145280001 2115585.18188 37.7891803678189 -122.43239939681801 (37.7891803678189, -122.432399396818)
2167 3158 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 3410 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   5998012.98689 2114846.6357400003 37.7868508368504 -122.45066663485201 (37.7868508368504, -122.450666634852)
2203 8461 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1877 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002698.7987 2113699.0733 37.7839670221208 -122.43437275514 (37.7839670221208, -122.43437275514)
2205 123677 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 4308 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5994223.96504 2114319.57116 37.7851860492976 -122.46373740171002 (37.7851860492976, -122.46373740171)
2251 13985 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1155 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 4X4   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097)
2254 13986 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1155 Market St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 4X4   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097)
2285 2664 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 2018 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003759.2529 2114943.4782 37.78744398103571 -122.430792808025 (37.7874439810357, -122.430792808025)
2298 108161 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2559 Van Ness Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2014 12:00:00 AM 3 3x3 Permit Number 770697 6005729.40099 2119172.75383 37.79916793360329 -122.424277402689 (37.7991679336033, -122.424277402689)
2299 253020 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 760 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6004216.0 2110862.0 37.7762631241711 -122.42892145951299 (37.7762631241711, -122.428921459513)
2303 122440 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 599X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3 Permit Number 778941 6013669.1059 2114077.4124 37.785622440131 -122.39644576664499 (37.785622440131, -122.396445766645)
2305 201174 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 599X Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft Permit Number 778941 6013723.602999999 2114126.7683 37.785760992593296 -122.396260681537 (37.7857609925933, -122.396260681537)
2306 195019 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300X 02nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6013637.791730001 2113971.74755 37.785330566207705 -122.396546695873 (37.7853305662077, -122.396546695873)
2307 122432 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 598X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4 Permit Number 778941 6013714.3488 2114207.9998 37.7859835205848 -122.396298394128 (37.7859835205848, -122.396298394128)
2309 122433 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 598X Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x4 Permit Number 778941 6013698.925 2114193.6044 37.785943135879 -122.396350747311 (37.785943135879, -122.396350747311)
2313 201193 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 611 Folsom St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft Permit Number 778941 6013579.6483 2113996.1808 37.7853944182999 -122.39674956946399 (37.7853944182999, -122.396749569464)
2314 138948 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 738 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/07/2008 12:00:00 AM 4 Width 0ft Permit Number 51651 6004303.429 2110848.9359 37.7762322016228 -122.428618087069 (37.7762322016228, -122.428618087069)
2315 195022 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300X 02nd St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6013709.75083 2113894.09551 37.785121356022394 -122.39629229296001 (37.7851213560224, -122.39629229296)
2319 201172 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 599X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft Permit Number 778941 6013687.6143 2114096.9491 37.785677113353294 -122.396383102325 (37.7856771133533, -122.396383102325)
2320 1739 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 111 Bay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13   08/19/2006 12:00:00 AM 3     6010211.1306 2121614.8438 37.8061253525476 -122.408941413862 (37.8061253525476, -122.408941413862)
2323 201173 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 599X Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft Permit Number 778941 6013705.0945 2114111.3445 37.7857176125048 -122.39632363473801 (37.7857176125048, -122.396323634738)
2324 195018 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300X 02nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft Permit Number 778941 6013610.320719999 2113989.12597 37.7853767544813 -122.39664295660499 (37.7853767544813, -122.396642956605)
2330 6147 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 939 Ellis St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 4x4   6006318.99495 2113507.73043 37.7836464651567 -122.42183458592 (37.7836464651567, -122.42183458592)
2331 122431 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 598X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 4x4 Permit Number 778941 6013729.7725 2114223.4236 37.786026729010295 -122.396246113338 (37.7860267290103, -122.396246113338)
2332 122438 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 598X Folsom St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 4x4 Permit Number 778941 6013622.8347 2114119.5705 37.785735621476 -122.396608809095 (37.785735621476, -122.396608809095)
2334 122437 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 598X Folsom St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x4 Permit Number 778941 6013638.2584 2114134.9942 37.7857788297664 -122.396556528653 (37.7857788297664, -122.396556528653)
2335 195021 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300X 02nd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   6013679.6407 2113928.34961 37.7852137343684 -122.396398867136 (37.7852137343684, -122.396398867136)
2336 195020 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300X 02nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6013662.142659999 2113947.50545 37.785265358143896 -122.39646074858601 (37.7852653581439, -122.396460748586)
2337 122436 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 598X Folsom St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 4x4 Permit Number 778941 6013651.6256 2114147.3332 37.7858134537143 -122.39651114681001 (37.7858134537143, -122.39651114681)

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