sf-trees

Data source: data.sfgov.org

Custom SQL query returning 19 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10106 173853 1 54 450 Toland St 8 1 2 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
37734 137587 2 54 1150 PIERCE ST 8 1 1 1     0 Width 0ft   6002352.8955 2112542.7356 37.78077237103221 -122.435486703411 (37.7807723710322, -122.435486703411)
42883 185830 2 54 2071 34th Ave 8 1 1 1     0 Width 0ft   5985698.118 2101152.3680000002 37.7485376258716 -122.49226386921801 (37.7485376258716, -122.492263869218)
45116 185842 2 54 2000 35th Ave 8 2 1 1     0 Width 0ft   5985421.3197 2101412.6246 37.7492360339251 -122.493240190301 (37.7492360339251, -122.493240190301)
46705 244976 2 54 201 Rose St 8 1 1 1     0 Width 0ft   6005594.1388 2109777.4773 37.773363196496895 -122.42407694938998 (37.7733631964969, -122.42407694939)
63962 141522 2 54 200 STANYAN ST 8 1 1 1     0 Width 0ft   5996688.4722 2111189.7999 37.7767342289075 -122.454984790063 (37.7767342289075, -122.454984790063)
69532 184973 2 54 2701 Sunset Blvd 8 1 1 1     0 Width 0ft   5985060.7433 2096318.9125 37.7352289790934 -122.494111677716 (37.7352289790934, -122.494111677716)
71149 142745 3 54 700x COLUMBUS AVE 8 11 1 2     0 Width 0ft   6009127.5357 2120116.4029 37.8019502507169 -122.412585395041 (37.8019502507169, -122.412585395041)
79728 108812 2 54 301-399 University St 8 1 1 1           6008160.407269999 2092653.74948 37.726489845684796 -122.41398823310301 (37.7264898456848, -122.413988233103)
83119 114623 2 54 2400X Post St 8 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
87071 115068 3 54 70 Coral Rd 8 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
93124 116328 2 54 1400X Potrero Ave 8 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
110162 108806 2 54 401-499 University St 8 1 1 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
116105 116281 2 54 700X Greenwich St 8 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
117730 108800 2 54 501-599 University St 8 1 1 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
141862 105088 6 54 344 Fulton St 8 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
149988 141161 2 54 2007 Geary Blvd 8 1 1 1     0 Width 0ft   6002005.8356 2113598.0542 37.7836502911761 -122.43676291583598 (37.7836502911761, -122.436762915836)
161855 142539 2 54 2100 POWELL ST 8 1 1 1     0 Width 0ft   6009429.9045 2121027.6379 37.80446924024871 -122.411603472126 (37.8044692402487, -122.411603472126)
182050 200501 2 54 1550 Armstrong Ave 8 1 1 1     0 Width 0ft   6014687.5837 2092287.487 37.7258485955534 -122.39139827547399 (37.7258485955534, -122.391398275474)
Powered by Datasette · Query took 14.756ms · Data source: data.sfgov.org