sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6518 97735 3 37 1150 Francisco St 13 1 1 4 2 06/22/2016 02:46:00 PM 3 3x3 Permit Number 50638 6005694.978999999 2120690.49004 37.8033333055591 -122.424504530974 (37.8033333055591, -122.424504530974)
104096 112062 2 37 1199 VISITACION AVE 4 1 1 4 2 08/18/2015 12:00:00 AM   4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
120376 112063 2 37 1199 VISITACION AVE 5 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
123118 112058 2 37 1199 VISITACION AVE 1 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
140135 112060 2 37 1199 VISITACION AVE 2 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
141095 112061 2 37 1199 VISITACION AVE 3 1 1 4 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
1697 42640 3 37 1651 Union St 10 1 1 4 2 09/25/2015 02:08:00 PM 3 3x3 Permit Number 42688 6005273.82097 2118847.7065 37.7982497015198 -122.42583071712299 (37.7982497015198, -122.425830717123)
80671 102030 2 37 165X Chattanooga St 10 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
92210 102025 2 37 165X Chattanooga St 5 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
94066 77325 2 37 165X Chattanooga St 1 1 1 4 2 11/18/1988 12:00:00 AM 3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
99976 102032 2 37 165X Chattanooga St 12 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
103838 102029 2 37 165X Chattanooga St 9 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
105164 102027 2 37 165X Chattanooga St 7 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
111333 102034 2 37 165X Chattanooga St 14 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
118157 102031 2 37 165X Chattanooga St 11 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
125030 102033 2 37 165X Chattanooga St 13 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
126295 102028 2 37 165X Chattanooga St 8 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
127011 102024 2 37 165X Chattanooga St 4 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
128300 102022 2 37 165X Chattanooga St 2 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
140326 102026 2 37 165X Chattanooga St 6 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
142587 102023 2 37 165X Chattanooga St 3 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
77166 77218 3 37 499X Hearst Ave 22 5 1 4 2 05/15/1999 12:00:00 AM 3 6x50   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
Powered by Datasette · Query took 5.156ms · Data source: data.sfgov.org