sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
124714 119691 3 86 4x Octavia St 9 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
126370 119730 3 86 104x Octavia St 10 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
129094 119732 3 86 104x Octavia St 12 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
138816 119735 3 86 104x Octavia St 15 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
139912 119688 3 86 4x Octavia St 6 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
140489 119773 3 86 204x Octavia St 8 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
141892 119779 3 86 204x Octavia St 14 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142187 119776 3 86 204x Octavia St 11 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142339 119695 3 86 4x Octavia St 13 11 1 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
1192 119753 3 46 101x Octavia St 8 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1196 119750 3 46 101x Octavia St 5 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1202 119754 3 46 101x Octavia St 9 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1204 119749 3 46 101x Octavia St 4 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1213 119747 3 46 101x Octavia St 2 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1223 119752 3 46 101x Octavia St 7 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1227 119736 3 46 101x Octavia St 1 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
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)
99951 119755 3 46 106x Octavia St Frontage West 10 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
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)
83700 109168 3 46 6x Octavia St Frontage West 7 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
97204 109171 3 46 6x Octavia St Frontage West 4 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
99403 109164 3 46 6x Octavia St Frontage West 11 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
116938 109163 3 46 6x Octavia St Frontage West 12 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
121401 109167 3 46 6x Octavia St Frontage West 8 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
126070 109170 3 46 6x Octavia St Frontage West 5 11 1 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
127400 119700 3 100 6x Octavia St Frontage West 2 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
138316 119699 3 100 6x Octavia St Frontage West 1 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
144933 119701 3 46 6x Octavia St Frontage West 3 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
107397 25804 1 100 1300X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
109799 25803 1 100 1300X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
112807 25802 1 100 1300X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
116990 25800 1 100 1300X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
140551 25801 1 100 1300X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
5494 87738 3 18 3200X Van Ness Ave 10 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005444.64461 2121623.98788 37.8058823097966 -122.425437295217 (37.8058823097966, -122.425437295217)
8626 87739 3 18 3200X Van Ness Ave 11 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005433.618530001 2121623.41722 37.8058801199389 -122.42547541206699 (37.8058801199389, -122.425475412067)
69372 25749 1 100 1301X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
89841 25748 1 100 1301X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
101776 25752 1 100 1301X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
112942 25754 1 100 1301X The Embarcadero 7 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
117219 25750 1 100 1301X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
141888 25751 1 100 1301X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
146321 25753 1 100 1301X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
6941 87735 3 41 3200X Van Ness Ave 7 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005457.063999999 2121526.81323 37.8056161950061 -122.42538739630501 (37.8056161950061, -122.425387396305)
116269 96365 2 17 2017 Grant Ave 1 11 1 1   06/07/2011 12:00:00 AM 12 3x3 Permit Number 767883 6010284.4 2121422.5 37.805601328212795 -122.408674274121 (37.8056013282128, -122.408674274121)
84835 86968 1 17 3250 Van Ness Ave 1 11 1 1   10/27/2007 12:00:00 AM     Permit Number 49934 6005499.7 2121504.7 37.8055578865418 -122.42523827370701 (37.8055578865418, -122.425238273707)
140517 86969 1 17 3250 Van Ness Ave 2 11 1 1   10/27/2007 12:00:00 AM     Permit Number 49934 6005499.7 2121504.7 37.8055578865418 -122.42523827370701 (37.8055578865418, -122.425238273707)
56556 87733 3 41 3200X Van Ness Ave 5 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005465.59287 2121464.4175299997 37.8054453543938 -122.425353437905 (37.8054453543938, -122.425353437905)
5480 87732 3 41 3200X Van Ness Ave 4 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005468.85489 2121438.02655 37.8053730758726 -122.425340270033 (37.8053730758726, -122.425340270033)
7662 88451 3 18 3200X Van Ness Ave 1 11 1 2   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.805209901088396 -122.425294529632 (37.8052099010884, -122.425294529632)
187959 88452 3 18 3200X Van Ness Ave 2 11 1 2   06/07/2008 12:00:00 AM 4 5x12   6005470.42698 2121378.16696 37.8052088057127 -122.425330567252 (37.8052088057127, -122.425330567252)
87352 87731 3 41 3200X Van Ness Ave 3 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005484.434281 2121339.2825599997 37.8051028305372 -122.42527932450001 (37.8051028305372, -122.4252793245)
88228 87736 3 41 3200X Van Ness Ave 8 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005484.434281 2121339.2825599997 37.8051028305372 -122.42527932450001 (37.8051028305372, -122.4252793245)
113968 87734 3 41 3200X Van Ness Ave 6 11 1 2   05/10/2008 12:00:00 AM   4x4   6005484.434281 2121339.2825599997 37.8051028305372 -122.42527932450001 (37.8051028305372, -122.4252793245)
125002 87737 3 41 3200X Van Ness Ave 9 11 1 2   05/10/2008 12:00:00 AM 3 4x4   6005484.434281 2121339.2825599997 37.8051028305372 -122.42527932450001 (37.8051028305372, -122.4252793245)
1594 4731 3 62 1175X Columbus Ave 2 11 1 2     14 3x3   6007886.219880001 2121257.05551 37.8050124513131 -122.416961809043 (37.8050124513131, -122.416961809043)
7655 4730 3 62 1175X Columbus Ave 1 11 1 2     100 3x3   6007911.57425 2121225.41132 37.8049269905411 -122.41687182377 (37.8049269905411, -122.41687182377)
7054 4734 3 62 1100X Columbus Ave 5 11 1 2     60 3x3   6007950.0877 2121194.0464 37.80484303663339 -122.416736319981 (37.8048430366334, -122.416736319981)
5461 23583 3 76 3100X Van Ness Ave 6 11 1 2     24 9   6005493.5455 2121226.7269099997 37.8047942964921 -122.425239779807 (37.8047942964921, -122.425239779807)
8565 4733 3 62 1100X Columbus Ave 4 11 1 2     20 3x3   6007980.3619 2121165.8966 37.80476744709579 -122.416629557244 (37.8047674470958, -122.416629557244)
5306 23582 3 76 3100X Van Ness Ave 5 11 1 2   01/25/2008 12:00:00 AM 3 9   6005497.77155 2121198.52122 37.8047170896849 -122.425223146826 (37.8047170896849, -122.425223146826)
8587 4732 3 62 1100X Columbus Ave 3 11 1 2     14 3x3   6008014.3541 2121137.2157 37.8046906082857 -122.41650989053801 (37.8046906082857, -122.416509890538)
45194 142722 3 62 1100x COLUMBUS AVE 2 11 1 2     11 Width 0ft   6008044.6283 2121108.5348 37.804613560274504 -122.416403090609 (37.8046135602745, -122.416403090609)
36379 142721 3 62 1100x COLUMBUS AVE 1 11 1 2     17 Width 0ft   6008079.1516 2121077.7294 37.804530917755706 -122.416281435895 (37.8045309177557, -122.416281435895)
6953 23580 3 143 3100X Van Ness Ave 3 11 1 2     24 9   6005507.77084 2121129.71298 37.8045287248816 -122.42518364411501 (37.8045287248816, -122.425183644115)
7603 23579 3 143 3100X Van Ness Ave 2 11 1 2     42 3x3   6005511.92719 2121098.1181099997 37.804442208310206 -122.425167011149 (37.8044422083102, -122.425167011149)
87462 4736 3 62 1100X Columbus Ave 7 11 1 2     60 3x3   6008154.5819477 2121037.0963081 37.804423590750396 -122.41601752221001 (37.8044235907504, -122.41601752221)
103185 4735 3 479 1100X Columbus Ave 6 11 1 2   08/19/2006 12:00:00 AM 6 3x3   6008154.5819477 2121037.0963081 37.804423590750396 -122.41601752221001 (37.8044235907504, -122.41601752221)
1851 4718 3 62 1000X Columbus Ave 5 11 1 2     80 3   6008205.1504 2120957.4944 37.804207866952204 -122.415836885075 (37.8042078669522, -122.415836885075)
103830 27697 1 100 1100X The Embarcadero 2 11 1 9     36 10   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
104579 23581 3 76 3100X Van Ness Ave 4 11 1 2   01/25/2008 12:00:00 AM 3 9   6005553.2513401 2120985.4040713003 37.804135058960796 -122.42501598068701 (37.8041350589608, -122.425015980687)
116860 23578 3 105 3100X Van Ness Ave 1 11 1 2     24 9   6005553.2513401 2120985.4040713003 37.804135058960796 -122.42501598068701 (37.8041350589608, -122.425015980687)
6383 4717 3 62 1000X Columbus Ave 4 11 1 2   08/19/2006 12:00:00 AM 6 3   6008242.0329 2120925.0825 37.804120945419 -122.415706953629 (37.804120945419, -122.415706953629)
4067 25799 1 100 1300X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012220.09673 2120843.1378 37.8041187644177 -122.401934728525 (37.8041187644177, -122.401934728525)
81176 27963 1 100 1101X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
105106 25746 1 100 1101X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
111083 25747 1 100 1101X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
5299 4716 3 62 1000X Columbus Ave 3 11 1 2     70 3   6008306.8566 2120868.0824 37.803968081269204 -122.415478587922 (37.8039680812692, -122.415478587922)
8454 4715 3 62 1000X Columbus Ave 2 11 1 2   08/19/2006 12:00:00 AM 6 3   6008330.3273 2120843.4941 37.803901887177204 -122.415395624015 (37.8039018871772, -122.415395624015)
6099 4714 3 62 1000X Columbus Ave 1 11 1 2     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828)
127945 25787 1 100 800X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012271.38601 2120709.8440099997 37.803755634424206 -122.401747862284 (37.8037556344242, -122.401747862284)
124851 4719 3 62 1000X Columbus Ave 6 11 1 2     70 3   6008486.129587 2120728.7244 37.803595514004 -122.41484833114401 (37.803595514004, -122.414848331144)
123015 25788 1 100 800X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012327.37501 2120629.11501 37.8035370964877 -122.401548430804 (37.8035370964877, -122.401548430804)
120825 25789 1 100 800X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6012378.15701 2120553.5940099997 37.8033325675946 -122.40136738582899 (37.8033325675946, -122.401367385829)
76348 27944 1 100 999 The Embarcadero 1 11 1 9     24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
83420 27948 1 100 999 The Embarcadero 5 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
91110 27949 1 100 999 The Embarcadero 6 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
98325 27947 1 100 999 The Embarcadero 4 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
106831 27951 1 100 999 The Embarcadero 8 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
114665 27950 1 100 999 The Embarcadero 7 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
116513 27946 1 100 999 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
144240 27945 1 100 999 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
84036 27864 1 15 900X The Embarcadero 5 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
89385 27863 1 15 900X The Embarcadero 4 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
90241 27861 1 15 900X The Embarcadero 2 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
94947 27865 1 15 900X The Embarcadero 6 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
110146 27862 1 15 900X The Embarcadero 3 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
128446 27860 1 15 900X The Embarcadero 1 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
107210 25790 1 100 800X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6012501.85401 2120373.90601 37.8028460885889 -122.400926692934 (37.8028460885889, -122.400926692934)
91779 26017 1 100 899X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
Powered by Datasette · Query took 36.264ms · Data source: data.sfgov.org