sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4776 97245 3 12 301X Excelsior Ave 1 1 1 4 2 10/25/2017 04:18:00 PM 3 4x4 Permit Number 767495 6003351.72812 2092154.8424200001 37.724848709697106 -122.43057604836099 (37.7248487096971, -122.430576048361)
4799 97246 3 12 301X Excelsior Ave 2 1 1 4 2 10/25/2017 04:11:00 PM 3 4x4 Permit Number 767495 6003334.6314 2092165.82905 37.724877907973706 -122.430635933307 (37.7248779079737, -122.430635933307)
11025 97251 3 12 301X Excelsior Ave 7 1 1 4 2 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003227.5697 2092233.02297 37.7250563415646 -122.43101082650499 (37.7250563415646, -122.431010826505)
11401 97248 3 12 301X Excelsior Ave 4 1 1 4 2 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003299.02479 2092188.3041400001 37.724937602283504 -122.430760624301 (37.7249376022835, -122.430760624301)
12260 97249 3 12 301X Excelsior Ave 5 1 1 4 2 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003279.34346 2092200.52554 37.7249700444293 -122.43082953217301 (37.7249700444293, -122.430829532173)
12687 97250 3 12 301X Excelsior Ave 6 1 1 4 2 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003264.30376 2092207.6887700001 37.724988860924 -122.430882033691 (37.724988860924, -122.430882033691)
25232 116051 2 12 650x Kansas St 7 1 1 4 2   3 4x4   6011500.28754 2105307.1354099996 37.761420339490705 -122.40333209689699 (37.7614203394907, -122.403332096897)
50839 113034 3 12 251 06th Ave 5 1 1 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617)
80235 96569 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
90630 98561 3 12 2035X Stockton St 4 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
91242 98559 3 12 2035X Stockton St 2 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
99207 96568 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
110039 96585 3 12 401x Otsego Ave 10 1 1 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398)
124197 96567 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
125972 96577 3 12 401x Otsego Ave 1 1 1 4   05/14/2011 12:00:00 AM 2 3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398)
126599 98562 3 12 2035X Stockton St 5 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141315 98560 3 12 2035X Stockton St 3 1 1 4 2         6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
141465 97247 3 12 301X Excelsior Ave 3 1 1 4 2 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003399.0 2092092.0 37.7246788362927 -122.43040815339701 (37.7246788362927, -122.430408153397)
158318 116046 2 12 650x Kansas St 2 1 1 4 2   4 5x15   6011495.20108 2105434.8979700003 37.761770862847705 -122.40335867726002 (37.7617708628477, -122.40335867726)
163065 116050 2 12 650x Kansas St 6 1 1 4 2   3 4x4   6011499.79329 2105331.08163 37.76148606285779 -122.403335490949 (37.7614860628578, -122.403335490949)
Powered by Datasette · Query took 35.946ms · Data source: data.sfgov.org