sf-trees

Data source: data.sfgov.org

Custom SQL query returning 27 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
249 251254 2 66 330 09th Ave 1 12 1 6       3x3   5993109.0 2113253.0 37.782193225103605 -122.467517213871 (37.7821932251036, -122.467517213871)
914 225888 7 121 3255x 24th St 1 8 1 6     32 6x6   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
3803 178335 6 3 401 Ocean Ave 1 9 1 6     33 Width 8ft   5998656.04486 2091523.1214700001 37.72284701755029 -122.44676297552601 (37.7228470175503, -122.446762975526)
6211 106217 2 32 585X Bush St 1 1 1 6     10 3x5   6010670.9358 2115847.8332700003 37.790316292506795 -122.40694344599301 (37.7903162925068, -122.406943445993)
69379 122419 2 3 2200 San Jose Ave 1 1 1 6       3x3   5998886.0 2091075.0 37.7216297132481 -122.44593585753599 (37.7216297132481, -122.445935857536)
79581 117011 2 22 457X CASTRO ST 1 16 1 6 3   27 3x6   6002348.0 2105584.0 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
86909 120542 2 71 2450 California St 1 7 1 6 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
89093 116527 3 41 5732 GEARY BLVD 1 2 1 6 2     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
94007 112375 6 36 801 ULLOA ST 1 1 1 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
100355 116620 2 41 5732X GEARY BLVD 1 8 1 6 4   12 3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
102100 106226 2 43 350 Sutter St 1 1 1 6     22 3x5   6010879.0 2115572.0 37.7895705607022 -122.406204113006 (37.7895705607022, -122.406204113006)
103031 120596 6 3 499x Ocean Ave 1 1 1 6     36 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
107936 118318 7 22 20 Norton St 1 7 1 6           6002015.686319999 2092167.12899 37.724806667280895 -122.435195459751 (37.7248066672809, -122.435195459751)
109274 116606 2 253 1325x 08TH AVE 1 5 1 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
111158 27436 1 101 1690X Indiana St 1 1 1 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
112371 106224 2 43 340 SUTTER ST 1 1 1 6     24 3x5   6010923.2 2115578.3 37.789590331237704 -122.406051628897 (37.7895903312377, -122.406051628897)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
122201 91827 1 127 1941 Harrison St 1 1 1 6   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.41312959117799 (37.7664314036014, -122.413129591178)
122423 116604 2 253 1325x 08TH AVE 1 7 1 6           5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
124657 121200 2 301 423 18th Ave 1 1 1 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
126456 116577 6 98 3000x 19TH AVE 1 5 1 6 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
127092 116522 3 1 324 08TH AVE 1 5 1 6 2   8 3x3   5993416.0 2113304.0 37.7823509768718 -122.466458848407 (37.7823509768718, -122.466458848407)
127587 25401 1 12 495X Geneva Ave 1 1 1 6   06/28/1996 12:00:00 AM 8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
140025 116347 2 20 4051X 24TH ST 1 1 1 6     10 3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
Powered by Datasette · Query took 2.13ms · Data source: data.sfgov.org