sf-trees

Data source: data.sfgov.org

Custom SQL query returning 12 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1686 251474 2 110 151 32nd Ave 2 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1694 251475 2 110 151 32nd Ave 3 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1712 251473 2 110 151 32nd Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
33032 247630 2 110 286 Bradford St 5 7 1 1     7     6009492.89578 2096949.07994 37.738358653736206 -122.409684901541 (37.7383586537362, -122.409684901541)
40834 247628 2 110 286 Bradford St 3 7 1 1     9     6009493.85882 2096962.27736 37.738394944962394 -122.409682503062 (37.7383949449624, -122.409682503062)
41441 247627 2 110 286 Bradford St 2 7 1 1     9     6009494.8200900005 2096968.4162599999 37.7384118549208 -122.40967961262699 (37.7384118549208, -122.409679612627)
52897 132364 2 110 1 Maple St 1 7 1 1     13     5996506.6886 2116107.7681400003 37.7902272326358 -122.455969252601 (37.7902272326358, -122.455969252601)
57300 132363 2 110 1 Maple St 2 7 1 1     19     5996514.49254 2116105.13934 37.7902204625654 -122.455942061589 (37.7902204625654, -122.455942061589)
74523 194587 2 110 37 Maddux Ave 1 7 1 1     3 Width 9ft   6012781.54528 2095521.68187 37.7346230570026 -122.398214166653 (37.7346230570026, -122.398214166653)
97714 102073 6 110 273 Magellan Ave 3 7 1 1           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194)
155600 247629 2 110 286 Bradford St 4 7 1 1     12     6009493.3855 2096955.4623099999 37.738376205786096 -122.409683658684 (37.7383762057861, -122.409683658684)
174774 247626 2 110 286 Bradford St 1 7 1 1     8     6009494.96271 2096975.4044400002 37.7384310509429 -122.40967961262501 (37.7384310509429, -122.409679612625)
Powered by Datasette · Query took 30.563ms · Data source: data.sfgov.org