trees

Custom SQL query returning 18 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
17 164866 5 13 719 Faxon Ave 1 Sidewalk: Property side : Yard Tree 2   11/16/2020 12:00:00 AM 3 4x6 Permit Number 782492 5994853.78052 2092811.30491 37.7261661184654 -122.459999785581 (37.7261661184654, -122.459999785581) 9 7 4 28861 40
2103 262299 5 6 209 Prentiss St 1 Sidewalk: Curb side : Cutout Tree 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
3516 92206 5 22 443 Madrid St 1 Sidewalk: Curb side : Cutout Tree 2   07/22/2015 12:00:00 AM 3 3x3 Permit Number 775730 6002885.09645 2091274.76844 37.7224057768794 -122.432126318576 (37.7224057768794, -122.432126318576) 9 7 6 28861 5
3533 263634 5 17 211 Sawyer St 1 Sidewalk: Curb side : Cutout Tree 2   09/01/2020 12:00:00 AM 3 3x3   6008194.27066 2088426.33179 37.71488415001 -122.413572307092 (37.71488415001, -122.413572307092) 9 7 8 309 39
6139 264669 5 297 1890 Church St 2 Sidewalk: Curb side : Cutout Tree 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
6318 261662 5 168 137 Elsie St 1 Sidewalk: Property side : Yard Tree 2   02/13/2020 12:00:00 AM 3     6007155.81154 2098485.15545 37.7424451335194 -122.417874270912 (37.7424451335194, -122.417874270912) 2 7 7 28859 2
9107 264723 5 32 335 Precita Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/18/2020 12:00:00 AM 3 4x4 Permit Number 782646 6008658.96802 2100212.34216 37.7472720863526 -122.412798868954 (37.7472720863526, -122.412798868954) 2 7 7 28859 2
10736 262270 5 1 10X Restani Stwy 4 Unaccepted Street : Yard Tree 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
12694 262268 5 1 10X Restani Stwy 2 Unaccepted Street : Yard Tree 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
14968 262269 5 1 10X Restani Stwy 3 Unaccepted Street : Yard Tree 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
15098 169494 5 297 1890 Church St 1 Sidewalk: Curb side : Cutout Tree 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
15368 262300 5 6 209 Prentiss St 2 Sidewalk: Curb side : Cutout Tree 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
16257 225172 5 343 248 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/08/2020 12:00:00 AM 3 4x4 Permit Number 779647 6006535.62128 2098220.14009 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071) 2 7 7 28859 2
16264 111321 5 70 1X Peabody St 1 Sidewalk: Curb side : Cutout Tree 2     15     6010185.88551 2087316.24933 37.7119477217782 -122.406610237293 (37.7119477217782, -122.406610237293) 9 7 8 309 39
16422 262267 5 1 10X Restani Stwy 1 Unaccepted Street : Yard Tree 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
17710 169495 5 297 150 Randall St 1 Sidewalk: Curb side : Cutout Tree 2   09/11/2020 12:00:00 AM 3 Width 3ft Permit Number 770415 6004561.3283 2097566.6275 37.7397767110236 -122.426779823841 (37.7397767110236, -122.426779823841) 2 7 5 63 7
194410 265060 5 181 48 Miraloma Dr 1 Sidewalk: Property side : Yard Tree 2   12/28/2020 12:00:00 AM 3 6x6 Permit Number 782253 5994833.01253 2097558.21258 37.7391987718964 -122.46041537824 (37.7391987718964, -122.46041537824) 9 7 4 59 40
194417 265061 5 84 48 Miraloma Dr 2 Sidewalk: Property side : Yard Tree 2       6x6   5994833.01253 2097558.21258 37.7391987718964 -122.46041537824 (37.7391987718964, -122.46041537824) 9 7 4 59 40