sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7131 116025 1 1 1425 Vallejo St 2 1 1 1   05/02/2016 12:00:00 AM 3 3x3   6006694.6941 2118351.37216 37.796967084814 -122.42087880533501 (37.796967084814, -122.420878805335)
8885 53229 1 1 1435 Pacific Ave 1 1 1 1   08/08/2016 12:00:00 AM 3 3x3 Permit Number 6112 6007249.74611 2117746.2070299997 37.795336722764795 -122.41891524533999 (37.7953367227648, -122.41891524534)
10036 64803 1 1 110X VALLEY ST 1 1 1 1 1 01/24/2017 12:00:00 AM 3   Permit Number 779438 6005124.0 2099350.0 37.7447052436017 -122.424961191686 (37.7447052436017, -122.424961191686)
10229 173709 1 1 26 Alma St 2 1 1 1   02/09/2017 12:00:00 AM 3 7x6   5998468.52120725 2106293.91375272 37.76339332794971 -122.448474428781 (37.7633933279497, -122.448474428781)
10231 56289 1 1 26 Alma St 1 1 1 1   07/25/1973 12:00:00 AM 3 7x6 Permit Number 12417 5998468.52120725 2106293.91375272 37.76339332794971 -122.448474428781 (37.7633933279497, -122.448474428781)
10678 116741 1 1 1631 40th Ave 1 1 1 1   02/14/2017 12:00:00 AM 3 3x3 Permit Number 779477 5983734.6502 2104037.3849 37.7563440999856 -122.499266557723 (37.7563440999856, -122.499266557723)
11465 107858 1 1 2908 Sloat Blvd 1 1 1 1   08/17/2016 12:00:00 AM 3 3x3 Permit Number 778432 5981789.5382 2096536.8762 37.735635490547 -122.505437384685 (37.735635490547, -122.505437384685)
12762 116742 1 1 1638 40th Ave 1 1 1 1   08/02/2016 12:00:00 AM 3 6x3 Permit Number 778698 5983780.8141 2103988.0199 37.756211265636296 -122.499103262084 (37.7562112656363, -122.499103262084)
13181 117441 1 1 1204 20th Ave 1 1 1 1   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778732 5989885.5669 2107139.7037 37.765221164359495 -122.47822160390498 (37.7652211643595, -122.478221603905)
14583 25961 1 1 2193 Oakdale Ave 1 1 1 1   05/30/2000 12:00:00 AM 3 2x3   6011423.37679 2098134.57194 37.7417217530491 -122.403093568809 (37.7417217530491, -122.403093568809)
15432 25962 1 1 2193 Oakdale Ave 2 1 1 1   04/22/1997 12:00:00 AM 3 2X3   6011447.1772300005 2098118.06457 37.7416777564365 -122.40301011353901 (37.7416777564365, -122.403010113539)
19078 16995 1 1 900 Oak St 4 1 1 1   03/11/2007 12:00:00 AM 3 3X3   6002566.6368 2109915.0941 37.7735696608208 -122.43455933158998 (37.7735696608208, -122.43455933159)
67490 51036 1 1 2614 47th Ave 1 1 1 1   07/08/2004 12:00:00 AM 3   Permit Number 47511 5981836.5788 2097266.1752 37.7376407136614 -122.50532878706001 (37.7376407136614, -122.50532878706)
85087 111629 1 1 200 Central Ave 2 1 1 1   06/12/2015 12:00:00 AM 3     5999893.57375842 2109179.37340811 37.7713974526383 -122.443752960181 (37.7713974526383, -122.443752960181)
87521 58634 1 1 1018 Shrader St 1 1 1 1   08/18/2016 12:00:00 AM 3 4x4 Permit Number 17854 5997674.48741574 2107055.11858465 37.765437971850794 -122.45127562216999 (37.7654379718508, -122.45127562217)
88289 61437 1 1 788 08th Ave 1 1 1 1   07/19/2016 12:00:00 AM 3   Permit Number 778418 5993530.07441 2110197.53457 37.7738280413865 -122.46583842282101 (37.7738280413865, -122.465838422821)
93616 25960 1 1 2301X Oakdale Ave 3 1 1 1   04/22/1997 12:00:00 AM 3 2x3   6011400.367219999 2098224.16578 37.741966473568795 -122.40317942951 (37.7419664735688, -122.40317942951)
94657 25957 1 1 2695X Oakdale Ave 2 1 1 1   01/26/2004 12:00:00 AM 3 2x3   6011407.61362 2098218.7686799997 37.741952058974796 -122.40315399409201 (37.7419520589748, -122.403153994092)
110440 111631 1 1 200 Central Ave 4 1 1 1   06/12/2015 12:00:00 AM 3     5999893.57375842 2109179.37340811 37.7713974526383 -122.443752960181 (37.7713974526383, -122.443752960181)
115892 95277 1 1 554 06th Ave 1 1 1 1   02/02/2016 12:00:00 AM 3 5x7 Permit Number 777230 5994096.260869999 2111723.67308 37.778051054367204 -122.463990712248 (37.7780510543672, -122.463990712248)
125247 41048 1 1 855 LINCOLN WAY 1 1 1 1   09/26/2016 12:00:00 AM 3 3x3 Permit Number 41828 5993076.0 2107259.0 37.7657334037891 -122.46719542706002 (37.7657334037891, -122.46719542706)
139768 111630 1 1 200 Central Ave 3 1 1 1   06/12/2015 12:00:00 AM 3     5999893.57375842 2109179.37340811 37.7713974526383 -122.443752960181 (37.7713974526383, -122.443752960181)
140399 44756 1 1 256 Pennsylvania Ave 2 1 1 1   07/22/2015 12:00:00 AM 3   Permit Number 43869 6014282.34232981 2105939.88092695 37.7633127092766 -122.39375434301 (37.7633127092766, -122.39375434301)
Powered by Datasette · Query took 51.44ms · Data source: data.sfgov.org