sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
928 224422 7 32 3255x 24th St 2 8 1 6     16 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
3799 178336 6 3 401 Ocean Ave 2 9 1 6     29 Width 8ft   5998664.9682 2091522.93582 37.722847017548204 -122.44673211618999 (37.7228470175482, -122.44673211619)
6302 106216 2 32 585X Bush St 2 1 1 6     10 3x5   6010698.10573 2115852.22595 37.7903298740626 -122.406849749212 (37.7903298740626, -122.406849749212)
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
28447 116579 6 98 3000x 19TH AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
78249 116605 2 253 1325x 08TH AVE 2 7 1 6           5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
81716 116348 2 20 4051X 24TH ST 2 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
84141 120594 6 3 499x Ocean Ave 2 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
97915 121201 2 36 423 18th Ave 2 1 1 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
101689 120996 2 43 352 SUTTER ST 2 1 1 6       3x5   6010871.2 2115571.1 37.789567653219 -122.40623103688499 (37.789567653219, -122.406231036885)
107199 112376 6 36 801 ULLOA ST 2 1 1 6     24     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
113455 116607 2 253 1325x 08TH AVE 2 1 1 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
118730 27437 1 101 1690X Indiana St 2 1 1 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
119101 116621 2 41 5732X GEARY BLVD 2 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
122767 106225 2 43 340 SUTTER ST 2 1 1 6     22 3x5   6010923.2 2115578.3 37.789590331237704 -122.406051628897 (37.7895903312377, -122.406051628897)
126965 91828 1 127 1941 Harrison St 2 1 1 6   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.41312959117799 (37.7664314036014, -122.413129591178)
139825 122420 2 46 2200 San Jose Ave 2 1 1 6       3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
141808 25402 1 12 495X Geneva Ave 2 1 1 6   06/28/1996 12:00:00 AM 6 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
Powered by Datasette · Query took 1.762ms · Data source: data.sfgov.org