sf-trees

Data source: data.sfgov.org

Custom SQL query returning 59 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
3474 106212 2 32 585X Bush St 5 1 1 6     12 3x5   6010752.41967 2115858.63176 37.790350501826204 -122.406662277468 (37.7903505018262, -122.406662277468)
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)
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)
6705 106209 2 26 585X Bush St 7 1 1 6     16 3x16   6010847.77195 2115873.69146 37.7903971865333 -122.406333425049 (37.7903971865333, -122.406333425049)
7182 106215 2 32 585X Bush St 3 1 1 6     14 3x5   6010717.90235 2115854.24398 37.79033652277371 -122.406781396238 (37.7903365227737, -122.406781396238)
19060 116350 2 262 4051X 24TH ST 4 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
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)
86385 26671 1 37 495X Geneva Ave 5 1 1 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
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)
94007 112375 6 36 801 ULLOA ST 1 1 1 6     42     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
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)
99827 122418 6 55 499x Ocean Ave 15 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
101689 120996 2 43 352 SUTTER ST 2 1 1 6       3x5   6010871.2 2115571.1 37.789567653219 -122.40623103688499 (37.789567653219, -122.406231036885)
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)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
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)
106006 25403 1 12 495X Geneva Ave 7 1 1 6   06/28/1996 12:00:00 AM 6 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
107199 112376 6 36 801 ULLOA ST 2 1 1 6     24     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
108277 25405 1 12 495X Geneva Ave 9 1 1 6   06/28/1996 12:00:00 AM 12 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
109707 26670 1 37 495X Geneva Ave 4 1 1 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
109913 122413 6 55 499x Ocean Ave 10 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
110472 25404 1 12 495X Geneva Ave 8 1 1 6   01/04/2002 12:00:00 AM 8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
110638 122414 6 55 499x Ocean Ave 11 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
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)
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)
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)
112873 122416 6 55 499x Ocean Ave 13 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
113027 27442 1 101 1690X Indiana St 7 1 1 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
113455 116607 2 253 1325x 08TH AVE 2 1 1 6       3x3   5993613.0 2106469.0 37.7635952548206 -122.46528068560801 (37.7635952548206, -122.465280685608)
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)
118684 27439 1 101 1690X Indiana St 4 1 1 6     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105)
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)
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)
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)
124160 116349 2 20 4051X 24TH ST 3 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
124657 121200 2 301 423 18th Ave 1 1 1 6       3x3   5990242.0 2112483.0 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216)
125935 26669 1 37 495X Geneva Ave 3 1 1 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
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)
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)
128572 26672 1 37 495X Geneva Ave 6 1 1 6     8 3X3   5998682.305166099 2090785.318168 37.720822680446894 -122.446619141783 (37.7208226804469, -122.446619141783)
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)
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 72.689ms · Data source: data.sfgov.org