sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
10097 173851 1 54 450 Toland St 6 1 2 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
39959 141131 2 54 1760 Ellis St 6 1 1 1     0 Width 0ft   6002332.7569 2113004.3119 37.7820385992621 -122.435589403585 (37.7820385992621, -122.435589403585)
48113 185273 2 54 2601 Sunset Blvd 6 2 1 1     0 Width 0ft   5985037.6088 2097007.6084 37.7371186003252 -122.494242407159 (37.7371186003252, -122.494242407159)
48404 141143 2 54 2011 Geary Blvd 6 1 1 1     0 Width 0ft   6001931.7546 2113588.2444 37.783619145517896 -122.43701850487301 (37.7836191455179, -122.437018504873)
54373 246202 2 54 737 Buena Vista Ave West 6 1 1 1     0 Width 0ft   5999863.7722 2107959.3261 37.7680458100097 -122.443768378658 (37.7680458100097, -122.443768378658)
65435 183890 2 54 1390 Quintara St 6 2 1 1     3 Width 0ft   5988977.7676 2101017.0459 37.748357251925604 -122.480913117409 (37.7483572519256, -122.480913117409)
69387 139039 2 54 1501 BRODERICK ST 6 1 1 1     0 Width 0ft   6000650.9974 2113849.5584 37.7842637658196 -122.441468180362 (37.7842637658196, -122.441468180362)
78523 108805 2 54 401-499 University St 6 1 1 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
79036 116326 2 54 1400X Potrero Ave 6 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
84777 116279 2 54 700X Greenwich St 6 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
96655 105086 6 54 344 Fulton St 6 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
106237 115066 3 54 70 Coral Rd 6 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
120303 114621 2 54 2400X Post St 6 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
138812 108798 2 54 501-599 University St 6 1 1 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
139188 108993 2 54 2073-2099X Jefferson St 6 1 1 1           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501)
145400 116946 2 54 3676 23RD ST 6 1 1 1       3x3   6005238.0 2102584.0 37.753591501312705 -122.424797029407 (37.7535915013127, -122.424797029407)
147382 185840 2 54 2000 35th Ave 6 2 1 1     0 Width 0ft   5985426.2822 2101257.1323 37.7488093846788 -122.493211576533 (37.7488093846788, -122.493211576533)
158360 137787 2 54 2190 Golden Gate Ave 6 1 1 1     0 Width 0ft   5999114.5715 2111518.024 37.7777743262559 -122.44661584556101 (37.7777743262559, -122.446615845561)
159669 137910 2 54 1911 Pine St 6 1 1 1     0 Width 0ft   6004805.9953 2115383.078 37.78871026126421 -122.427202616598 (37.7887102612642, -122.427202616598)
175934 140091 2 54 1250 Scott St 6 1 1 1     0 Width 0ft   6001831.6388 2112795.421 37.781436562836106 -122.43730807844801 (37.7814365628361, -122.437308078448)
91200 33411 1 54 100 Ulloa St 6 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
95556 104158 1 54 525X Church St 6 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
Powered by Datasette · Query took 21.033ms · Data source: data.sfgov.org