trees

Custom SQL query returning 36 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2158 95238 4 36 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree 4 DPW     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
2915 223666 4 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
19907 102028 4 1 165X Chattanooga St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
20806 102022 4 1 165X Chattanooga St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
35858 102033 4 1 165X Chattanooga St 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
38321 102024 4 1 165X Chattanooga St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
39667 95239 4 36 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree 4 DPW   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
48405 102030 4 1 165X Chattanooga St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
56850 98746 4 36 540X Eureka St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
57036 98749 4 36 540X Eureka St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
61217 98752 4 36 540X Eureka St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
76443 102025 4 1 165X Chattanooga St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
84100 77325 4 1 165X Chattanooga St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 11/18/1988 12:00:00 AM 3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
84673 98750 4 36 540X Eureka St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
85492 95237 4 36 1220 Noe St 4 Sidewalk: Curb side : Cutout Tree 4 DPW   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
88151 98756 4 36 540X Eureka St 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
90910 98754 4 36 540X Eureka St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
92461 113825 4 106 1599x CASTRO ST 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 11/10/2015 12:00:00 AM 8 3x3   6002577 2101074 37.7492947436898 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
113529 102032 4 1 165X Chattanooga St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
128246 98744 4 7 540X Eureka St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
129482 102027 4 1 165X Chattanooga St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
130000 102029 4 1 165X Chattanooga St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
135552 102034 4 1 165X Chattanooga St 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
140158 98755 4 36 540X Eureka St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
140414 98753 4 36 540X Eureka St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
154088 95241 4 36 1220 Noe St 8 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
155740 95235 4 36 1220 Noe St 1 Sidewalk: Curb side : Cutout Tree 4 DPW   3 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
166045 113827 4 8 1599x CASTRO ST 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 02/16/2016 05:50:00 AM 3 3x3   6002577 2101074 37.7492947436898 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
167233 102031 4 1 165X Chattanooga St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
170711 95240 4 36 1220 Noe St 7 Sidewalk: Curb side : Cutout Tree 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
171496 98747 4 36 540X Eureka St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
175564 95236 4 36 1220 Noe St 2 Sidewalk: Curb side : Cutout Tree 4 DPW   12 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
177368 102023 4 1 165X Chattanooga St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
179818 98748 4 36 540X Eureka St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
183257 98751 4 36 540X Eureka St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
185959 102026 4 1 165X Chattanooga St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22