trees

Custom SQL query returning 89 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
156111 96589 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
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
9627 228661 1 11 4235 19th St 1 Sidewalk: Curb side : Cutout Tree 4     13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943) 2 4 5 28862 3
12520 228662 1 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree 4     16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999) 2 4 5 28862 3
17590 73937 1 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/07/1990 12:00:00 AM 10 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
78271 73518 1 11 4235 19th St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2015 07:36:00 AM 3 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
134492 228663 1 11 4235 19th St 6 Sidewalk: Curb side : Cutout Tree 4   06/23/2015 07:36:00 AM 2 Width 3ft   6001958.87793 2104675.64602 37.7591489038263 -122.436286615639 (37.7591489038263, -122.436286615639) 2 4 5 28862 3
160840 74160 1 11 4235 19th St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/07/1990 12:00:00 AM 10 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
98248 94927 7 19 325 Sanchez St   Sidewalk: Curb side : Cutout Tree 4   12/07/2010 12:00:00 AM   3x3 Permit Number 53976 6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
26191 99549 1 27 200X Henry St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
44657 99552 1 27 200X Henry St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 12/28/2016 06:02:00 AM 3 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
45651 99551 1 27 200X Henry St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   26 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
83391 99548 1 27 200X Henry St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   24 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
100854 99553 1 27 200X Henry St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   24 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
111362 99557 1 27 200X Henry St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   30 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
115483 99554 1 27 200X Henry St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
122873 99555 1 27 200X Henry St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   30 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
157537 99556 1 27 200X Henry St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   30 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
192623 99547 1 27 200X Henry St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   24 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
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
16064 235284 1 36 4235 19th St 3 Sidewalk: Curb side : Cutout Tree 4     11 Width 3ft   6001885.77275 2104671.54401 37.7591334867264 -122.436539154285 (37.7591334867264, -122.436539154285) 2 4 5 28862 3
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
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
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
139813 71107 1 36 4235 19th St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/07/1990 12:00:00 AM 8 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
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
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
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
18687 104158 1 45 525X Church St 6 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
31577 104151 1 45 525X Church St 1 Sidewalk: Property side : Cutout Landscaping 4 DPW     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
79291 104154 1 45 525X Church St 2 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
94668 104156 1 45 525X Church St 4 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
111419 104155 1 45 525X Church St 3 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
153628 104153 1 45 525X Church St 1 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
156692 104157 1 45 525X Church St 5 Sidewalk: Curb side : Cutout Landscaping 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
164652 104152 1 45 525X Church St 2 Sidewalk: Property side : Cutout Landscaping 4 DPW     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
4591 113471 4 54 450 CHURCH ST 28 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
15342 113473 4 54 450 CHURCH ST 30 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
33807 113465 4 54 450 CHURCH ST 1 Sidewalk: Curb side : Cutout Tree 4     20 6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
43317 113469 4 54 450 CHURCH ST 26 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
65054 113474 4 54 450 CHURCH ST 31 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
67077 113468 4 54 450 CHURCH ST 4 Sidewalk: Curb side : Cutout Tree 4   06/21/2016 02:14:00 PM 3 6x7   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
83117 113466 4 54 450 CHURCH ST 2 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
91889 113472 4 54 450 CHURCH ST 29 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
143625 113475 4 54 450 CHURCH ST 32 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
147121 113467 4 54 450 CHURCH ST 24 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
188448 113470 4 54 450 CHURCH ST 27 Sidewalk: Curb side : Cutout Tree 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
112801 96209 1 60 201X Diamond St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/28/2012 12:00:00 AM 3 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
142390 96210 1 67 201X Diamond St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/28/2012 12:00:00 AM 3 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
7851 220311 1 70 4235 19th St 4 Sidewalk: Curb side : Cutout Tree 4     18 Width 3ft   6001938.02984 2104676.35813 37.7591496745354 -122.436358769151 (37.7591496745354, -122.436358769151) 2 4 5 28862 3
12179 220312 1 70 4235 19th St 7 Sidewalk: Curb side : Cutout Tree 4     15 Width 3ft   6002007.42492 2104678.29116 37.7591589249724 -122.436118906483 (37.7591589249724, -122.436118906483) 2 4 5 28862 3
37806 71177 1 70 4235 19th St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
45359 96211 1 70 201X Diamond St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
46043 96215 1 70 200X Collingwood St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   26 4x4   6002035.7 2104682 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266) 2 4 5 28862 3
68625 96214 1 70 200X Collingwood St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 3x3   6002035.7 2104682 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266) 2 4 5 28862 3
98383 96212 1 70 201X Diamond St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   14 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
121802 96216 1 70 200X Collingwood St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 4x4   6002035.7 2104682 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266) 2 4 5 28862 3
132313 73528 1 70 4235 19th St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
2474 256556 8 75 3401X 16th St 5 Side Yard : Yard Tree 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
34431 256554 8 75 3401X 16th St 3 Side Yard : Yard Tree 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
90011 256555 8 75 3401X 16th St 4 Side Yard : Yard Tree 4   02/08/2019 08:48:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
175776 256557 8 75 3401X 16th St 6 Side Yard : Yard Tree 4   02/08/2019 08:44:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
176971 256553 8 75 3401X 16th St 2 Side Yard : Yard Tree 4   02/08/2019 09:24:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
189291 256552 8 75 3401X 16th St 1 Side Yard : Yard Tree 4   02/08/2019 08:54:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
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
67453 173941 1 127 3750 18th St 4 Sidewalk: Curb side : Cutout Tree 4       3x3   6004590 2105440 37.7613967828987 -122.427241380377 (37.7613967828987, -122.427241380377) 8 4 5 28862 3
67735 99550 1 129 200X Henry St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 07/19/2016 04:45:00 AM 3 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
34835 71106 1 150 4235 19th St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 06/23/2015 07:32:00 AM 3 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
8082 96598 8 317 325 Sanchez St   Sidewalk: Property side : Cutout tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
19875 96597 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
33788 96601 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
35006 96602 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
120469 96606 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
136541 96599 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
138264 96604 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
142618 96600 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
184992 96603 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
186894 96605 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3