sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1183 119797 3 46 201x Octavia St 5 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1185 119832 3 46 301x Octavia St 5 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1187 119794 3 46 201x Octavia St 2 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1189 119798 3 46 201x Octavia St 6 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1191 119838 3 46 301x Octavia St 11 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1192 119753 3 46 101x Octavia St 8 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1194 119795 3 46 201x Octavia St 3 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1196 119750 3 46 101x Octavia St 5 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1199 119799 3 46 201x Octavia St 7 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1201 119839 3 46 301x Octavia St 12 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1202 119754 3 46 101x Octavia St 9 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1203 119796 3 46 201x Octavia St 4 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1204 119749 3 46 101x Octavia St 4 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1206 119801 3 46 201x Octavia St 9 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1207 119793 3 46 201x Octavia St 1 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1208 119803 3 46 201x Octavia St 11 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1209 119800 3 46 201x Octavia St 8 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1211 119836 3 46 301x Octavia St 9 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1212 119828 3 46 301x Octavia St 1 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1213 119747 3 46 101x Octavia St 2 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1219 119829 3 46 301x Octavia St 2 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1222 119837 3 46 301x Octavia St 10 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1223 119752 3 46 101x Octavia St 7 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1226 119830 3 46 301x Octavia St 3 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1227 119736 3 46 101x Octavia St 1 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1228 119831 3 46 301x Octavia St 4 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1230 119834 3 46 301x Octavia St 7 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1231 119833 3 46 301x Octavia St 6 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1233 119757 3 46 101x Octavia St 12 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1234 119748 3 46 101x Octavia St 3 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1235 119756 3 46 101x Octavia St 11 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1347 251504 3 3 620x Noriega St 1 11 1 2       3x3   5992030.0 2103590.0 37.7555988620986 -122.470546036282 (37.7555988620986, -122.470546036282)
1529 251578 3 62 1000X Columbus Ave 6 11 1 2                    
3232 253369 2 2 449X Trumbull St 1 11 1 1       Width 10ft   6005840.0 2094317.0 37.730926169648 -122.42212790794599 (37.730926169648, -122.422127907946)
4063 253608 3 47 400X Portola Dr 1 11 1 2       10x10   5998814.0 2100235.0 37.746776792757004 -122.44684353081101 (37.746776792757, -122.446843530811)
5083 253786 3 47 1675X 15th Ave 2 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5090 253789 3 47 1651X 15th Ave 1 11 1 2       3x2   5991453.0 2104016.0 37.756735165128205 -122.47257252055401 (37.7567351651282, -122.472572520554)
5094 253788 3 2 1663X 15th Ave 1 11 1 2       3x3   5991413.0 2103963.0 37.756587325686105 -122.472706989611 (37.7565873256861, -122.472706989611)
5101 253790 3 47 1651X 15th Ave 2 11 1 2       3x2   5991453.0 2104016.0 37.756735165128205 -122.47257252055401 (37.7567351651282, -122.472572520554)
5102 253784 3 47 1709X 15th Ave 1 11 1 2       3x2   5991403.0 2103783.0 37.756092514171904 -122.472728448949 (37.7560925141719, -122.472728448949)
5104 253785 3 3 1675X 15th Ave 1 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5106 253787 3 3 1675X 15th Ave 3 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
9685 111779 3 60 356 Marietta Dr 4 11 1 2       5   5999368.0 2097504.0 37.7393097549515 -122.44473159198601 (37.7393097549515, -122.444731591986)
9748 173655 3 78 100 Lawton St 1 11 1 10                    
9751 173659 3 78 200 Lawton St 1 11 1 10           5993693.06683 2104628.21116 37.7585455452803 -122.46487007071998 (37.7585455452803, -122.46487007072)
10102 121489 3 80 2 Judah St 1 11 1 2       3x3            
10105 121488 3 80 750 Parnassus Ave 1 11 1 2       3x3   5994725.7235199995 2106063.1570900003 37.762545022051796 -122.461402729778 (37.7625450220518, -122.461402729778)
10222 173923 3 17 2160X 09th Ave 11 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10224 173918 3 17 2160X 09th Ave 6 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10225 173920 3 17 2160X 09th Ave 8 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10227 173914 3 17 2160X 09th Ave 1 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10228 173922 3 17 2160X 09th Ave 10 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10230 173919 3 17 2160X 09th Ave 7 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10232 173916 3 17 2160X 09th Ave 4 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10233 173917 3 17 2160X 09th Ave 5 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10237 173915 3 17 2160X 09th Ave 3 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
10238 173921 3 17 2160X 09th Ave 9 11 1 2       6x10   5993671.0 2100995.0 37.7485684085064 -122.464682560698 (37.7485684085064, -122.464682560698)
11135 173950 3 178 236 Moncada Way 15 11 1 2       35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
14379 48480 1 17   1 11 1 1         Permit Number 45832          
18486 106393 3 17 182x Lower Ter 20 11 1 2       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737)
19023 91430 3 105 800X Portola Dr 4 11 1 2   10/10/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.45405010417801 (37.7441872967186, -122.454050104178)
19496 34866 1 41 579 Miramar Ave 1 11 1 1 1 12/29/2015 12:00:00 AM     Permit Number 775311 5995338.59696042 2093168.95782094 37.7271760192259 -122.458349689476 (37.7271760192259, -122.458349689476)
22919 251161 2 3 528 Noriega St 1 11 1 1       3x3   5992330.0 2103518.0 37.7554185113149 -122.46950331083401 (37.7554185113149, -122.469503310834)
22922 251160 3 143 1126x Portola Dr 1 11 1 2 3     3x3   5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341)
25404 119731 3 86 104x Octavia St 11 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
30532 119696 3 86 4x Octavia St 14 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
50167 122876 3 51 2701X Alemany Blvd 5 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
53247 97256 3 425 198 Dolores St 2 11 1 2   10/05/2011 12:00:00 AM       6004815.0 2107196.0 37.766231062063206 -122.426588243906 (37.7662310620632, -122.426588243906)
53249 115326 3 47 2601X Sunset Blvd 21 11 1 2       40   5985098.343425 2097506.3093477003 37.7384914535226 -122.494069167367 (37.7384914535226, -122.494069167367)
61501 120626 3 71 1500 Geary Blvd 3 11 1 2           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401)
61692 119780 3 86 204x Octavia St 15 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
69381 91437 3 11 900X Portola Dr 2 11 1 2   02/22/2012 12:00:00 AM   4x4   5996336.043197 2098916.600218 37.7430149203693 -122.455316749086 (37.7430149203693, -122.455316749086)
72222 87818 1 180 85 Mendosa Ave 1 11 1 1   06/04/2008 12:00:00 AM     Permit Number 50680 5993356.0 2100787.0 37.747979128324 -122.46575670711701 (37.747979128324, -122.465756707117)
77657 99736 3 2 900X Ocean Ave 2 11 1 2           5997264.7 2091625.4 37.7230482703916 -122.45157991133101 (37.7230482703916, -122.451579911331)
77707 111573 3 3 1x SUNSET BLVD OFF RAMP 5 11 1 2       3x3   5984955.0 2095624.0 37.7333147463652 -122.494426056577 (37.7333147463652, -122.494426056577)
78112 99445 3 47 1601X 15th Ave 2 11 1 2           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604)
78281 111082 2 60 130 JUNIPERO SERRA BLVD 1 11 1 1       3x3   5991393.0 2095322.0 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186)
78492 122871 3 51 2900X Alemany Blvd 9 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
78616 106550 3 105 81 MINERVA ST   11 1 2           5996079.6 2088963.3 37.7156708325413 -122.455484227095 (37.7156708325413, -122.455484227095)
78660 91444 3 11 900X Portola Dr 8 11 1 2   10/14/2005 12:00:00 AM   4x4   5996336.043197 2098916.600218 37.7430149203693 -122.455316749086 (37.7430149203693, -122.455316749086)
78674 99497 1 180 1400X Plymouth Ave 4 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
78773 97390 3 87 1400X Broadway 14 11 1 2           6006851.0 2118099.6 37.7962845906619 -122.420320069483 (37.7962845906619, -122.420320069483)
79180 122891 3 51 2701X Alemany Blvd 20 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
79301 120625 3 71 1500 Geary Blvd 2 11 1 2           6004349.0 2113949.0 37.784746788576705 -122.428681484586 (37.7847467885767, -122.428681484586)
79566 119689 3 86 4x Octavia St 7 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
79813 111574 3 3 1x SUNSET BLVD OFF RAMP 6 11 1 2       3x3   5984955.0 2095624.0 37.7333147463652 -122.494426056577 (37.7333147463652, -122.494426056577)
79975 106399 3 17 182x Lower Ter 26 11 1 2       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737)
80464 91433 3 11 800X Portola Dr 9 11 1 2   10/01/2005 12:00:00 AM   4x4   5996711.121131 2099335.742872 37.7441872967186 -122.45405010417801 (37.7441872967186, -122.454050104178)
80509 110645 3 15 200x DRUMM ST 9 11 1 2           6013666.0 2117675.0 37.7955004026749 -122.396708806749 (37.7955004026749, -122.396708806749)
80604 109658 2 47 800X BROTHERHOOD WAY 29 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
80683 119723 3 86 104x Octavia St 3 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
80883 106374 3 17 182x Lower Ter 1 11 1 2       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737)
81045 109169 3 46 6x Octavia St Frontage West 6 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
81389 120633 3 34 1500 Geary Blvd 10 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
81473 106380 3 17 182x Lower Ter 7 11 1 2       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737)
81526 103927 3 100 100 The Embarcadero 13 11 1 2   02/05/2001 12:00:00 AM   4x4   6014859.0 2117030.0 37.793795709183996 -122.392535650186 (37.793795709184, -122.392535650186)
81773 104786 3 17 750 Holly Park Cir 2 11 1 2       2x2   6006276.6738599995 2096799.83163 37.7377680961975 -122.42079445065201 (37.7377680961975, -122.420794450652)
82181 106395 3 17 182x Lower Ter 22 11 1 2       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737)
82267 114834 3 198 251x TRUMBULL ST 16 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
82803 102580 3 15 2X Drumm St 6 11 1 2   03/12/2013 12:00:00 AM     Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259)
82903 114822 3 198 251x TRUMBULL ST 4 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
Powered by Datasette · Query took 29.865ms · Data source: data.sfgov.org