sf-trees

Data source: data.sfgov.org

Custom SQL query returning 57 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)
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)
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)
19060 116350 2 262 4051X 24TH ST 4 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
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)
58682 116625 2 41 5732X GEARY BLVD 6 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
81716 116348 2 20 4051X 24TH ST 2 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
82760 120597 6 3 499x Ocean Ave 5 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84141 120594 6 3 499x Ocean Ave 2 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
84743 116631 2 41 5732X GEARY BLVD 12 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
91468 91762 1 150 1940 Harrison St   1 1 6   03/07/2007 12:00:00 AM 3 3x3   6008660.813755 2107281.610975 37.7666827970273 -122.413292321769 (37.7666827970273, -122.413292321769)
91855 122410 6 55 499x Ocean Ave 7 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
91870 122411 6 55 499x Ocean Ave 8 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
93939 116353 2 20 4051X 24TH ST 7 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
96632 116628 2 41 5732X GEARY BLVD 9 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
96972 120593 6 2 499x Ocean Ave 4 1 1 6     34 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)
98882 116352 2 20 4051X 24TH ST 6 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
98906 116629 2 41 5732X GEARY BLVD 10 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
99827 122418 6 55 499x Ocean Ave 15 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
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)
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)
105748 120595 6 3 499x Ocean Ave 3 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
109274 116606 2 253 1325x 08TH AVE 1 5 1 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
109913 122413 6 55 499x Ocean Ave 10 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
110638 122414 6 55 499x Ocean Ave 11 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
111008 116626 2 20 5732X GEARY BLVD 7 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
111773 91829 1 127 1941 Harrison St 3 1 1 6   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.41312959117799 (37.7664314036014, -122.413129591178)
112319 122417 6 55 499x Ocean Ave 14 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
112472 116609 2 253 1325x 08TH AVE 4 5 1 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
112873 122416 6 55 499x Ocean Ave 13 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
113343 116624 2 41 5732X GEARY BLVD 5 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
113455 116607 2 253 1325x 08TH AVE 2 1 1 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
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)
116737 122415 6 55 499x Ocean Ave 12 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
117760 116608 2 253 1325x 08TH AVE 3 1 1 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
118230 120598 6 3 499x Ocean Ave 6 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
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)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
121491 116351 2 20 4051X 24TH ST 5 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
121613 116354 2 20 4051X 24TH ST 8 1 1 6     10 3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
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)
122326 122412 6 55 499x Ocean Ave 9 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
123257 116622 2 41 5732X GEARY BLVD 3 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124160 116349 2 20 4051X 24TH ST 3 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
124339 116630 2 41 5732X GEARY BLVD 11 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124657 121200 2 301 423 18th Ave 1 1 1 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
125790 116627 2 41 5732X GEARY BLVD 8 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
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)
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)
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)
142683 116623 2 41 5732X GEARY BLVD 4 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
Powered by Datasette · Query took 2.626ms · Data source: data.sfgov.org