sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3 119263 3 3 495X Lakeshore Dr 1 3 1 2       10x30            
731 251375 3 47 401 Portola Dr 3 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
747 251378 3 47 401 Portola Dr 6 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 3 47 401 Portola Dr 2 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
757 251377 3 47 401 Portola Dr 5 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
763 251373 3 47 401 Portola Dr 1 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
764 251379 3 47 401 Portola Dr 7 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
785 251376 3 47 401 Portola Dr 4 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
1098 251438 3 47 2501X Santiago St 1 3 1 2                    
3208 253368 3 47 236 Moncada Way 1 3 1 2       10x10   5992398.0 2093455.0 37.7277919980392 -122.468536018982 (37.7277919980392, -122.468536018982)
5008 253723 3 177 1X Glenview Dr   3 1 2       3x3   5998487.0 2100314.0 37.746975021233204 -122.447979947083 (37.7469750212332, -122.447979947083)
9923 173740 2 17 2500X Lyon St 7 3 1 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
9924 173738 2 17 2500X Lyon St 5 3 1 1       3x3   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
13314 187669 2 47 554 Valley St 1 3 1 1           6002324.0 2099197.0 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307)
18076 107933 3 17 3098X Market St 1 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
22840 251107 3 46 1700X Quesada Ave 1 3 1 2                    
46600 116804 3 19 131 LAKESHORE DR 1 3 2 2       10x100   5984782.0 2094243.0 37.7295127607338 -122.494922366174 (37.7295127607338, -122.494922366174)
64871 115154 3 143 245x ARLINGTON ST 3 3 1 2       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447)
79307 107935 3 17 1099X Market St 3 3 1 2           6009025.86197 2112294.38137 37.7804671773494 -122.41238403194401 (37.7804671773494, -122.412384031944)
82353 109678 3 47 200X VIDAL DR 7 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
82835 113195 3 40 699X Noe St 2 3 1 1           6003039.779709999 2104315.51778 37.7582214335608 -122.432522620301 (37.7582214335608, -122.432522620301)
83073 109202 2 36 2401x CASTRO ST 6 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
83234 109676 3 47 200X VIDAL DR 5 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
85176 104920 2 75 750 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
85810 109204 2 36 2401x CASTRO ST 8 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
86474 109199 2 36 2401x CASTRO ST 7 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
88481 113536 3 3 100X CASHMERE ST 3 3 1 2           6017054.0 2095889.0 37.7358686950692 -122.38346826685301 (37.7358686950692, -122.383468266853)
91226 109209 2 180 2401x CASTRO ST 5 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
94540 106114 3 100 1752X DOLORES ST 1 3 1 2           6005197.0 2098194.1 37.741535528464496 -122.424626562024 (37.7415355284645, -122.424626562024)
97848 115153 3 143 245x ARLINGTON ST 2 3 1 2       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447)
101258 104921 2 75 750 Gonzalez Dr 2 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
102484 113196 3 76 4090X 20th St 1 3 1 2           6003325.9669699995 2104184.75857 37.7578786248615 -122.43152352597099 (37.7578786248615, -122.431523525971)
103039 115155 3 143 245x ARLINGTON ST 4 3 1 2       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447)
103732 113537 3 3 100X CASHMERE ST 4 3 1 2           6017054.0 2095889.0 37.7358686950692 -122.38346826685301 (37.7358686950692, -122.383468266853)
104474 97692 3 37 70x Benton Ave 1 3 1 2   11/05/2011 12:00:00 AM       6004768.61645 2094959.0484200001 37.732628603868704 -122.425877544976 (37.7326286038687, -122.425877544976)
104927 113538 3 3 100X CASHMERE ST 5 3 1 2           6017054.0 2095889.0 37.7358686950692 -122.38346826685301 (37.7358686950692, -122.383468266853)
105632 110346 2 36 2401x CASTRO ST 10 3 1 2       3x3   6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
105675 109208 2 36 2401x CASTRO ST 1 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
106565 115156 3 143 245x ARLINGTON ST 5 3 1 2       3x3   6004671.0 2096632.0 37.737216635749604 -122.426334098447 (37.7372166357496, -122.426334098447)
107740 107644 2 3 1400x KIRKWOOD AVE 1 3 1 1           6015822.8 2096363.1 37.7371023539668 -122.38775811873998 (37.7371023539668, -122.38775811874)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
109683 109675 3 47 200X VIDAL DR 4 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
110459 111240 3 60 745X SANCHEZ ST 5 3 1 2           6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
111624 104922 2 75 750 Gonzalez Dr 3 3 1 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
113148 104375 2 17 30 GARDENSIDE DR 1 3 2 1       50x50   5999465.0 2102094.0 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725)
116375 99101 6 11 55x Santa Monica Way 1 3 1 1   04/07/2012 12:00:00 AM     Permit Number 768464 5993693.6 2097654.3 37.739396991894104 -122.464361897304 (37.7393969918941, -122.464361897304)
116741 97397 3 149 1203X Sunset Blvd 17 3 1 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
123260 109205 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123401 109201 2 36 2401x CASTRO ST 4 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
123876 107934 3 17 3098X Market St 3 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
125797 109198 2 36 2401x CASTRO ST 2 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
127178 108238 2 17 764x JUNIPERO SERRA BLVD 1 3 1 1           5991289.6 2092496.8 37.7250969308873 -122.47229792145599 (37.7250969308873, -122.472297921456)
127394 111402 2 3 50x SANTA RITA AVE 7 3 1 1       29   5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
128009 109203 2 36 2401x CASTRO ST 9 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
128569 97396 3 24 1203X Sunset Blvd 15 3 1 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
140384 104978 2 116 66X San Lorenzo Way 1 3 1 1         Permit Number 770332 5993690.5 2097533.7 37.7390656757525 -122.46436386193301 (37.7390656757525, -122.464363861933)
141156 104399 3 47 2440X 37th Ave 1 3 1 2           5984875.46821 2098521.80546 37.7412666886784 -122.49491460561501 (37.7412666886784, -122.494914605615)
141517 109677 3 47 200X VIDAL DR 6 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
142186 107936 3 17 3098X Market St 2 3 1 2           5999920.0 2105144.0 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916)
142588 104374 2 17 22 GARDENSIDE DR 1 3 2 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
142749 97395 3 24 1203X Sunset Blvd 14 3 1 2           5989104.6 2108557.5 37.7690686805765 -122.48102656954599 (37.7690686805765, -122.481026569546)
144215 116451 2 3 250X CASHMERE ST 5 3 1 2           6016081.0 2096072.0 37.7363173516773 -122.386845101275 (37.7363173516773, -122.386845101275)
144513 111401 2 3 50x SANTA RITA AVE 6 3 1 1       40   5993713.0 2100532.0 37.74729954942379 -122.464503713167 (37.7472995494238, -122.464503713167)
144760 104926 2 75 810 Gonzalez Dr 1 3 1 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
146161 109674 3 47 200X VIDAL DR 3 3 1 2           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
1041 187245 3 129 2401 Sunset Blvd 28 3 1 2     1 Width 0ft   5984968.6731 2098517.9713 37.741261616740005 -122.494592058244 (37.74126161674, -122.494592058244)
11046 116538 3 48 1002x Naples St 1 3 1 2     1 3x3   6001578.1015800005 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612)
23395 208305 3 11 600x Bosworth St 6 3 1 2     1 Width 10ft   6002233.89157 2095386.08451 37.7336575763338 -122.43467122191299 (37.7336575763338, -122.434671221913)
24029 250142 3 89 2550x Lyon St 10 3 1 2     1     5999229.6006 2117622.80882 37.7945430395703 -122.44665726921801 (37.7945430395703, -122.446657269218)
26465 213721 3 237 66x Santa Monica Way 2 3 1 2     1     5993647.57824 2097426.08398 37.7387677148629 -122.46450445281401 (37.7387677148629, -122.464504452814)
26942 129350 3 19 1306x Montgomery St 38 3 1 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
27546 222774 3 335 2950x Cesar Chavez St 10 3 1 2     1     6009463.63512 2100579.86171 37.748326346280706 -122.41004232002301 (37.7483263462807, -122.410042320023)
27784 177494 3 315 1002x Naples St 8 3 1 2     1     6001533.96245 2088133.73568 37.7137045060241 -122.43657215399901 (37.7137045060241, -122.436572153999)
28868 208175 3 11 1000x Lawton St 3 3 1 2     1 Width 9ft   5991060.8036 2104516.28775 37.758086113802904 -122.473965364836 (37.7580861138029, -122.473965364836)
30666 189167 3 70 1300x De Haro St 18 3 1 2     1     6012264.80612 2102152.7525400002 37.7528017667079 -122.40046634965 (37.7528017667079, -122.40046634965)
31521 175079 3 109 1104x Alemany Blvd 1 3 1 2     1 Width 10ft   6003837.73065 2094453.4628599999 37.7311877286109 -122.42905980937599 (37.7311877286109, -122.429059809376)
32237 250565 3 26 6300x Geary Blvd 8 3 1 2     1 Width 10ft   5987286.538 2112566.9152 37.7799715553521 -122.48760963785601 (37.7799715553521, -122.487609637856)
32869 189966 3 299 900x Carolina St 73 3 1 2     1     6012515.82864 2102790.5172099997 37.754566925442795 -122.39964303739201 (37.7545669254428, -122.399643037392)
34570 251048 3 26 5700x Geary Blvd 2 3 1 2     1 Width 10ft   5989255.4598 2112633.0799 37.7802678632993 -122.480803179963 (37.7802678632993, -122.480803179963)
39141 119936 3 26 6500x Geary Blvd 7 3 1 2     1 Width 8ft   5986709.57611 2112539.19718 37.7798617820891 -122.489603541423 (37.7798617820891, -122.489603541423)
39879 222824 3 335 3200x Cesar Chavez St 4 3 1 2     1 Width 10ft   6008202.20567 2100572.2127900003 37.7482345623906 -122.41440378373001 (37.7482345623906, -122.41440378373)
40342 251093 3 26 6100x Geary Blvd 13 3 1 2     1 Width 10ft   5987925.4225 2112589.2174 37.780070032325 -122.485401115216 (37.780070032325, -122.485401115216)
42524 189228 3 274 1300x De Haro St 16 3 1 2     1     6012274.4793300005 2102155.74686 37.752810527903 -122.40043310802 (37.752810527903, -122.40043310802)
44686 251075 3 60 5100x Geary Blvd 3 3 1 2     1 Width 10ft   5990994.9145 2112700.954 37.7805551774565 -122.47479062026899 (37.7805551774565, -122.474790620269)
60953 251054 3 60 6000x Geary Blvd 5 3 1 2     1 Width 10ft   5988209.3153 2112595.4218 37.7801036030677 -122.48441946896601 (37.7801036030677, -122.484419468966)
60954 206815 3 47 2187x 09th Ave 3 3 1 2     1     5993562.9787 2100880.73772 37.7482484452101 -122.465047796213 (37.7482484452101, -122.465047796213)
67105 197178 3 180 1300x De Haro St 24 3 1 2     1     6012271.91368 2102115.47955 37.7526998195515 -122.40043915236099 (37.7526998195515, -122.400439152361)
70188 194167 3 41 1300x De Haro St 14 3 1 2     1     6012274.0442699995 2102163.00717 37.7528304388731 -122.40043512247802 (37.7528304388731, -122.400435122478)
73883 208307 3 11 700x Bosworth St 1 3 1 2     1 Width 10ft   6002108.77199 2095420.81947 37.7337458465985 -122.435106279748 (37.7337458465985, -122.435106279748)
74413 251035 3 26 5317x Geary Blvd 9 3 1 2     1 Width 10ft   5990415.7605 2112675.5562 37.7804518645045 -122.47679231146002 (37.7804518645045, -122.47679231146)
74497 190073 3 278 1700x Quesada Ave 35 3 1 2     1     6014423.28579 2095240.49948 37.7339422980969 -122.392518409417 (37.7339422980969, -122.392518409417)
76907 180414 3 51 1104x Alemany Blvd 4 3 1 2     1 Width 10ft   6003758.53299 2094425.58203 37.73110669070989 -122.42933162228 (37.7311066907099, -122.42933162228)
83067 208306 3 11 600x Bosworth St 7 3 1 2     1 Width 10ft   6002214.21615 2095390.4279 37.733668385273205 -122.434739555986 (37.7336683852732, -122.434739555986)
Powered by Datasette · Query took 8.89ms · Data source: data.sfgov.org