sf-trees

Data source: data.sfgov.org

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29426 117740 2 72 475 39th Ave 2 2 1 1     3 Width 4ft   5983746.49746 2112674.00016 37.7800584750229 -122.499863945897 (37.7800584750229, -122.499863945897)
32082 214339 2 72 10 Granada Ave 5 1 1 1     3 Width 3ft   5995645.61653 2089973.7563200002 37.7184203952771 -122.45705730996401 (37.7184203952771, -122.457057309964)
39539 135867 2 72 2881 Vallejo St 1 1 1 1     3 Width 4ft   5999809.285519999 2117392.98346 37.7939450956373 -122.44463496643401 (37.7939450956373, -122.444634966434)
47913 196323 2 72 1922 23rd St 1 7 1 1     3     6012591.21229 2102864.69613 37.7547748064319 -122.399387546319 (37.7547748064319, -122.399387546319)
53560 135870 2 72 2550 Pierce St 3 1 1 1     3 Width 4ft   6001706.98139 2117190.01379 37.7934958986807 -122.438054218747 (37.7934958986807, -122.438054218747)
57900 68433 1 72 2518 Jackson St 1 1 1 1   08/26/1993 12:00:00 AM 3   Permit Number 32286 6002013.47223 2116725.04565 37.7922366418513 -122.436960435397 (37.7922366418513, -122.436960435397)
60135 237893 2 72 48 Mirabel Ave 1 1 1 1     3 Width 2ft   6007622.588690001 2099939.38246 37.746464374648596 -122.416363270665 (37.7464643746486, -122.416363270665)
62151 214338 2 72 10 Granada Ave 3 1 1 1     3 Width 3ft   5995645.44763 2089954.0994900002 37.7183664125644 -122.4570564727 (37.7183664125644, -122.4570564727)
74881 237899 2 72 401 Capp St 2 1 1 1     3 Width 3ft   6007240.84354 2104941.30252 37.760177031272995 -122.418037841569 (37.760177031273, -122.418037841569)
76982 135865 2 72 2518 Jackson St 2 1 1 1     3 Width 3ft   6001998.80283 2116724.02313 37.792233000491294 -122.437011118472 (37.7922330004913, -122.437011118472)
125300 196327 2 72 582 Rhode Island St 7 9 1 1     3     6011756.69483 2105652.08155 37.7623818019909 -122.402469541836 (37.7623818019909, -122.402469541836)
147995 135868 2 72 2881 Vallejo St 2 1 1 1     3 Width 4ft   5999820.06951 2117394.7311 37.7939505095535 -122.444597778561 (37.7939505095535, -122.444597778561)
150930 237889 2 72 722 Andover St 1 1 1 1     3 Width 3ft   6007362.196 2095569.17155 37.7344500984995 -122.416954096469 (37.7344500984995, -122.416954096469)
175844 60597 1 72 839 Central Ave 1 1 1 1 1 01/07/1983 12:00:00 AM 3   Permit Number 20219 5999535.7853 2111409.5838 37.7775006284393 -122.44515092859301 (37.7775006284393, -122.445150928593)
178991 237875 2 72 200 Kingston St 6 7 1 1     3     6006243.1676199995 2098035.54696 37.7411592055212 -122.420998010444 (37.7411592055212, -122.420998010444)
186227 214352 2 72 50 Garcia Ave 4 2 1 1     3 Width 3ft   5995162.00455 2099364.3275 37.744176835692 -122.459408645009 (37.744176835692, -122.459408645009)
187588 196333 2 72 801 Arkansas St 24 9 1 1     3     6013061.90076 2103711.9152599997 37.757127308803604 -122.397819189808 (37.7571273088036, -122.397819189808)
Powered by Datasette · Query took 1.584ms · Data source: data.sfgov.org