sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
466 1665 3 79 1400X Fell St 6 1 1 2   05/06/1992 12:00:00 AM 18 3X3   6000409.8977 2109962.9335 37.7735783473195 -122.44202322778901 (37.7735783473195, -122.442023227789)
984 24262 3 79 600X Willow St 6 1 1 2   11/19/2004 12:00:00 AM 3 3X3   6004514.0905 2113119.5269 37.7824786038336 -122.428051195433 (37.7824786038336, -122.428051195433)
5943 9604 1 79 1355 Golden Gate Ave 6 1 1 1     12 3X3   6003125.8375 2112021.5623 37.7793852280154 -122.432775482637 (37.7793852280154, -122.432775482637)
7596 21601 1 79 1515 Sutter St 6 1 1 1     12 3x3   6005314.151000001 2114757.5524 37.7870214478079 -122.42539993758999 (37.7870214478079, -122.42539993759)
8442 6187 3 79 1100 Ellis St 6 1 1 2     18 3X3   6005423.3129 2113433.3911 37.783391795987 -122.424928016493 (37.783391795987, -122.424928016493)
8818 6201 3 79 1135 Ellis St 6 1 1 2     12 3X3   6005283.7179 2113361.2024 37.783185697693604 -122.42540582178002 (37.7831856976936, -122.42540582178)
13571 29433 3 79 2401X Ingalls St 6 1 1 2   08/19/2011 12:00:00 AM 3 3x3   6015500.9632 2091579.7516 37.7239504043026 -122.388537076537 (37.7239504043026, -122.388537076537)
13647 30096 1 79 6190X 03rd St 6 1 1 1   07/07/2011 12:00:00 AM 6 3x3   6013417.4786 2091122.0564 37.722577983662504 -122.395707348923 (37.7225779836625, -122.395707348923)
13890 29426 1 79 2501X Ingalls St 6 1 1 1   02/28/2006 12:00:00 AM 6 3x3   6015353.5854 2091384.7495 37.723406798628 -122.389032933904 (37.723406798628, -122.389032933904)
14076 22397 1 79 5700 03rd St 6 1 1 1   02/17/1995 12:00:00 AM 6 3X3   6013870.7534 2092308.3783 37.7258605897355 -122.39422348311399 (37.7258605897355, -122.394223483114)
14358 22405 3 79 5800 03rd St 6 1 1 2   02/03/1992 12:00:00 AM 5 3X3   6013773.1583 2092062.8244 37.7251809229772 -122.394543678104 (37.7251809229772, -122.394543678104)
14553 29440 1 79 2301X Ingalls St 6 1 1 1   02/28/2006 12:00:00 AM 3 3X3   6015660.6839 2091799.6156 37.7245629575419 -122.38800027789101 (37.7245629575419, -122.388000277891)
15923 29386 1 79 3199X Ingalls St 6 1 1 1   02/28/2006 12:00:00 AM 4 3x3   6014271.9163 2089934.5554 37.719364835170396 -122.392670694873 (37.7193648351704, -122.392670694873)
18909 6905 1 79 333 Fell St 6 1 1 1     9 3X3   6005791.8208 2110660.0754 37.775797756638205 -122.42345589675699 (37.7757977566382, -122.423455896757)
19213 15287 3 79 1600 Mission St 6 1 1 2   04/12/1995 12:00:00 AM 6 3x3   6007004.1044 2109328.3326 37.7722094576916 -122.41916780485 (37.7722094576916, -122.41916780485)
30658 140638 2 79 472 Stanyan St 6 1 1 1     6 Width 0ft   5996864.7991 2109972.3061 37.7734014220919 -122.45428686398199 (37.7734014220919, -122.454286863982)
34727 200931 2 79 4101 03rd St 6 1 1 1     5 Width 0ft   6015563.8928 2097421.6465 37.7399945612986 -122.388727159879 (37.7399945612986, -122.388727159879)
43857 200669 2 79 1589 Newcomb Ave 6 1 1 1     10 Width 0ft   6015338.0615 2095574.9021 37.7349112589219 -122.38937906760201 (37.7349112589219, -122.389379067602)
50978 138229 2 79 101 Anza St 6 1 1 1     8 Width 0ft   5998536.6795 2112630.6942 37.7807964033341 -122.448695125032 (37.7807964033341, -122.448695125032)
55422 142796 2 79 533 Larkin St 6 1 1 1     11 Width 0ft   6007561.1357 2113189.4218 37.782842437698896 -122.417514674644 (37.7828424376989, -122.417514674644)
67479 139806 2 79 1101 GOUGH ST 6 1 1 1     11 Width 0ft   6005650.9929 2112934.249 37.7820341324354 -122.424104823616 (37.7820341324354, -122.424104823616)
72699 199800 2 79 2655 Ingalls St 6 1 1 1     5 Width 0ft   6015155.3655 2091117.0238 37.7226606870185 -122.389699459103 (37.7226606870185, -122.389699459103)
72896 139932 2 79 800 GOUGH ST 6 1 1 1     14 Width 0ft   6005703.8894 2112554.5236 37.7809944860981 -122.42389481563299 (37.7809944860981, -122.423894815633)
121378 99007 3 79 2099X Beach St 6 1 1 10   01/20/2015 12:00:00 AM 3   Permit Number 771149 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
132029 95309 1 79 5411 03rd St 6 1 1 1     7 3x3   6014280.8379999995 2093157.5675 37.728215078157604 -122.392865222605 (37.7282150781576, -122.392865222605)
150721 95600 2 79 1625 Carroll Ave 6 1 1 1     14 3x3   6014023.4144 2092013.9314 37.725060582122104 -122.393675141136 (37.7250605821221, -122.393675141136)
152121 200963 2 79 5600 03rd St 6 1 1 1     3 Width 0ft   6013968.5894 2092562.3664 37.7265634275491 -122.39390303961599 (37.7265634275491, -122.393903039616)
156891 137780 2 79 1773 Golden Gate Ave 6 1 1 1     1 Width 0ft   6001115.5375 2111737.5615 37.7784912146937 -122.439709572654 (37.7784912146937, -122.439709572654)
160475 246311 2 79 1601 Mission St 6 1 1 1     9 Width 0ft   6007089.8834 2109370.8451 37.772331017243 -122.41887410287201 (37.772331017243, -122.418874102872)
160708 140352 2 79 1314 ELLIS ST 6 1 1 1     1 Width 0ft   6004399.7686 2113290.1868 37.7829407248934 -122.428458867439 (37.7829407248934, -122.428458867439)
161209 200991 2 79 75 Folsom St 6 1 1 1     13 Width 0ft   6015446.9463 2115775.0495 37.7903825381625 -122.39041355919201 (37.7903825381625, -122.390413559192)
167448 200913 2 79 3801 03rd St 6 1 1 1     5 Width 0ft   6015728.5157 2097971.7279 37.7415140947501 -122.388196336709 (37.7415140947501, -122.388196336709)
176512 143432 2 79 855 SACRAMENTO ST 6 1 1 1     2 Width 0ft   6010753.9601 2116917.9148 37.793259124815705 -122.406731631165 (37.7932591248157, -122.406731631165)
177734 121012 2 79 199X Folsom St 6 1 1 1     4 4x4   6015178.5737 2115521.0723 37.7896702844128 -122.39132435625099 (37.7896702844128, -122.391324356251)
Powered by Datasette · Query took 12.334ms · Data source: data.sfgov.org