sf-trees

Data source: data.sfgov.org

Custom SQL query returning 25 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2581 107490 3 84 1306x Montgomery St 19 11 1 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
6573 19697 3 84 100 STAIRWAY9 1 1 1 2     3 15ST            
9515 19958 3 84 100 STAIRWAY40 3 1 1 2     3 15ST            
9562 19696 3 84 100 STAIRWAY9 -3 1 1 2     12 15ST            
10800 19957 3 84 100 STAIRWAY40 2 1 1 2     3 15ST            
12896 19960 3 84 100 STAIRWAY41 18 1 1 2     6 25ST            
14815 29657 3 84 299X Cashmere St 1 11 1 2   04/07/2006 12:00:00 AM 3 3x3   6016930.3488300005 2095863.99444 37.735793199983796 -122.38389404137699 (37.7357931999838, -122.383894041377)
16368 19956 3 84 100 STAIRWAY40 1 1 1 2     12 15ST            
17606 6944 3 84 561 Fell St 1 1 1 2   03/09/2006 12:00:00 AM 3 3X3   6004740.44786 2110511.39404 37.7753301167361 -122.42708227125601 (37.7753301167361, -122.427082271256)
17845 21084 3 84 2192X Sunset Blvd 20 1 1 2     3 60   5984923.321673 2100279.0596028 37.7460944336033 -122.494878681905 (37.7460944336033, -122.494878681905)
21424 4161 3 84 3747 Cesar Chavez St 1 1 1 2   09/26/2001 12:00:00 AM 3 3X3   6005530.36537 2100484.52073 37.747843324004606 -122.423636704969 (37.7478433240046, -122.423636704969)
50088 1497 3 84 325 Arguello Blvd 3 1 1 2     2 3x3   5995534.5488977 2114067.6155393003 37.7845696798314 -122.45918496626999 (37.7845696798314, -122.45918496627)
77820 16688 3 84 600X Noriega St 1 11 1 2     3 2   5992180.8132004 2103552.59538 37.7555048781502 -122.47002175838301 (37.7555048781502, -122.470021758383)
96787 19030 3 84 3176 SACRAMENTO ST 2 1 1 2     7 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
98177 19029 3 84 3176 SACRAMENTO ST 4 1 1 2     8 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
102022 20856 3 84 1892X Sunset Blvd 6 1 1 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
119284 116071 3 84 4150X CLEMENT ST 1 7 1 2     8 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
119551 20857 3 84 1892X Sunset Blvd 7 1 1 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
121392 11193 3 84 162 Idora Ave 1 11 1 2     18 8   5995521.0890831 2099407.054304 37.7443147925186 -122.458170108957 (37.7443147925186, -122.458170108957)
123844 19023 3 84 3170 Sacramento St 2 1 1 2     7 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372)
139765 121317 3 84 1270 South Van Ness Ave 1 1 1 2     10 3x3   6007670.0 2102262.0 37.7528444245459 -122.41636381055099 (37.7528444245459, -122.416363810551)
144726 19028 3 84 3176 SACRAMENTO ST 3 1 1 2     7 2x2   5999568.0 2115477.0 37.78867053817721 -122.44533201 (37.7886705381772, -122.44533201)
144988 20855 3 84 1892X Sunset Blvd 5 1 1 2     3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
145402 19024 3 84 3170 Sacramento St 3 1 1 2     6 2X2   5999571.77228 2115429.18678 37.7885394709311 -122.445315519372 (37.7885394709311, -122.445315519372)
175278 199890 3 84 1200x Quesada Ave 1 11 1 2     3 Width 0ft   6017354.2822 2093058.6837 37.7281137963921 -122.382233221943 (37.7281137963921, -122.382233221943)
Powered by Datasette · Query took 2.309ms · Data source: data.sfgov.org