trees

Custom SQL query returning 31 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
84488 112892 10 373 1X WEBSTER ST 4 Sidewalk: Property side : Yard Tree 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
86051 109944 10 39 400x CLEMENTINA ST 4 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
98375 112371 10 7 550 Jessie St 4 Sidewalk: Curb side : Cutout Tree 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
167623 117139 10 8 2203x NEWCOMB AVE 4 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
182184 109118 10 22 2036x 15TH ST 4 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
186791 118339 10 14 2 Page St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6006507 2110162 37.7744705012603 -122.420946535292 (37.7744705012603, -122.420946535292) 7 9 11 28852 10
6989 109119 10 22 2036x 15TH ST 5 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
23173 109936 10 11 260 05th St 5 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302 2112245.5 37.7804604268654 -122.404506314811 (37.7804604268654, -122.404506314811) 14 2 9 28853 34
86412 109945 10 39 400x CLEMENTINA ST 5 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
90738 117140 10 8 2203x NEWCOMB AVE 5 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
132551 112584 10 6 3400x WAWONA ST 5 Sidewalk: Property side : Cutout Tree 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
132994 117150 10 8 928 TOLAND ST 5 Front Yard : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011950 2098029 37.7414612698949 -122.401265252936 (37.7414612698949, -122.401265252936) 10 3 8 58 1
138839 113607 10 9 2900 18TH ST 5 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
41654 112585 10 6 3400x WAWONA ST 6 Sidewalk: Property side : Cutout Tree 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
89702 109120 10 22 2036x 15TH ST 6 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
115452 113608 10 9 2900 18TH ST 6 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
118512 109946 10 39 400x CLEMENTINA ST 6 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
154253 117141 10 8 2203x NEWCOMB AVE 6 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
20563 109121 10 22 2036x 15TH ST 7 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
134560 101923 10 148 1401X California St 7 Sidewalk: Curb side : Cutout Tree 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007402.7 2116063.9 37.7907261358602 -122.418266664095 (37.7907261358602, -122.418266664095) 13 1 10 28858 21
138302 107977 10 27 2750 JACKSON ST 7 Sidewalk: Curb side : Cutout Tree 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.4 2116670.4 37.7920344322485 -122.440129594684 (37.7920344322485, -122.440129594684) 13 6 1 29490 27
140065 117142 10 8 2203x NEWCOMB AVE 7 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
145260 109947 10 39 400x CLEMENTINA ST 7 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
147556 112586 10 6 3400x WAWONA ST 7 Sidewalk: Property side : Cutout Tree 2       4x4   5982411 2096792 37.7363725426512 -122.503307672629 (37.7363725426512, -122.503307672629) 1 8 3 29491 35
181612 113609 10 9 2900 18TH ST 7 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
41644 109948 10 39 400x CLEMENTINA ST 8 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
55582 117143 10 8 2203x NEWCOMB AVE 8 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
126583 109122 10 22 2036x 15TH ST 8 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
57202 109123 10 22 2036x 15TH ST 9 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
172332 117144 10 8 2203x NEWCOMB AVE 9 Sidewalk: Curb side : Cutout Tree 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983 2098083 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432) 10 3 8 58 1
192360 109949 10 39 400x CLEMENTINA ST 9 Sidewalk: Curb side : Cutout Tree 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34