trees

Custom SQL query returning 16 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
36 166891 7 21 174 Jersey St 1 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 3x3 Permit Number 787855 6003954.63071 2101612.59597 37.7508516839573 -122.429165942869 (37.7508516839573, -122.429165942869) 2 4 5 28862 22
3182 261252 6 21 100 Collins St 1 Front Yard : Cutout Tree 2   12/18/2019 12:00:00 AM 3                        
15707 257978 1 21 2239 44th Ave 1 Sidewalk: Curb side : Cutout Tree 1     3     5982635.96784 2099878.65963 37.7448608850094 -122.502758291062 (37.7448608850094, -122.502758291062) 1 8 3 29491 35
21071 258216 7 21 1525 44th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 04/18/2019 12:00:00 AM 3 3x3 Permit Number 783183 5982470.91812 2104727.52358 37.758164806501 -122.503688017142 (37.758164806501, -122.503688017142) 1 8 3 56 35
33443 98454 1 21 1565 Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree 2   02/15/2012 12:00:00 AM 5 3x3 Permit Number 768686 6015422.71517 2096555.33224 37.7376080138989 -122.389154823532 (37.7376080138989, -122.389154823532) 10 3 8 58 1
42644 246501 1 21 267 Duncan St 1 : Tree 2     5 Width 3ft   6004772.39397 2099857.63594 37.7460792282712 -122.426213111567 (37.7460792282712, -122.426213111567) 2 7 5 63 22
45270 117718 1 21 3945 Clement St 4 Sidewalk: Property side : Yard Tree 2     4 Width 8ft   5983166.80961 2113082.0246 37.7811447555658 -122.501899513947 (37.7811447555658, -122.501899513947) 11 6 2 55 26
71635 258412 7 21 2130 45th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 05/14/2019 12:00:00 AM 3 3x3 Permit Number 783269 5982340.94516 2100600.50287 37.7468255237134 -122.503831858542 (37.7468255237134, -122.503831858542) 1 8 3 29491 35
78295 258230 7 21 2211 44th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 04/23/2019 12:00:00 AM 3 3x3 Permit Number 783203 5982629.52707 2100060.76504 37.7453605175795 -122.502794039293 (37.7453605175795, -122.502794039293) 1 8 3 29491 35
100654 254589 7 21 2118 47th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 03/06/2018 12:00:00 AM 3 3x3 Permit Number 781515 5981717.54613 2100657.45178 37.7469452139057 -122.505991697295 (37.7469452139057, -122.505991697295) 1 8 3 29491 35
103130 50851 1 21 283 10th Ave 2 Sidewalk: Curb side : Cutout Tree 2   04/08/2004 12:00:00 AM 8   Permit Number 47367 5992741.2206 2113607.79805 37.7831461632306 -122.468815380408 (37.7831461632306, -122.468815380408) 11 6 2 54 11
113389 78558 1 21 2286 45th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/02/2018 12:00:00 AM 3   Permit Number 781493 5982378.4208 2099556.0589 37.7439599736661 -122.503624940125 (37.7439599736661, -122.503624940125) 1 8 3 29491 35
134534 57239 1 21 1525 44th Ave 1 Sidewalk: Curb side : Cutout Tree 2   01/23/2008 12:00:00 AM 3 3x3 Permit Number 783183 5982470.2056 2104724.6567 37.7581568929674 -122.503690268992 (37.7581568929674, -122.503690268992) 1 8 3 56 35
141364 188811 1 21 1570 Michigan St 3 Sidewalk: Property side : Yard Tree 2     1 Width 2ft   6016519.20446 2100876.91622 37.7495349236186 -122.385664810978 (37.7495349236186, -122.385664810978) 10 3 8 58 1
149417 258454 7 21 2039 47th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF 05/15/2019 12:00:00 AM 3 3x3 Permit Number 783279 5981658.71984 2101205.85691 37.7484475179789 -122.506235768133 (37.7484475179789, -122.506235768133) 1 8 3 29491 35
168650 50850 1 21 283 10th Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/08/2004 12:00:00 AM 8   Permit Number 47367 5992740.70347 2113621.41529 37.7831835225698 -122.468818160681 (37.7831835225698, -122.468818160681) 11 6 2 54 11