trees

Custom SQL query returning 14 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
4829 158177 1 50 340 Laidley St 1 Sidewalk: Curb side : Cutout Tree 2     3 4x5   6003950.61422 2096725.29328 37.7374320507564 -122.42883145083 (37.7374320507564, -122.42883145083) 2 7 5 63 7
11124 230876 1 50 241 Whitney St 1 Sidewalk: Curb side : Cutout Tree 2   11/12/2020 01:31:00 PM 3 Width 4ft   6004420.76549 2097018.25838 37.7382630656916 -122.427226779685 (37.7382630656916, -122.427226779685) 2 7 5 63 7
20342 226375 1 50 235 Chenery St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6004677.73219 2096935.71561 37.7380509507014 -122.426332439909 (37.7380509507014, -122.426332439909) 2 7 5 63 7
28240 226821 1 50 1883 Church St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6004617.16315 2097706.60415 37.740164211802 -122.42659673537 (37.740164211802, -122.42659673537) 2 7 5 63 7
41208 226823 1 50 192 Laidley St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 2ft   6004115.91768 2097275.83468 37.7389530669259 -122.428299145692 (37.7389530669259, -122.428299145692) 2 7 5 63 7
54136 226376 1 50 268 Whitney St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6004329.65759 2096832.9872 37.7377492002742 -122.427528590399 (37.7377492002742, -122.427528590399) 2 7 5 63 7
64290 226822 1 50 39 Whitney St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   6004297.5525 2098038.31795 37.7410569481125 -122.427725448366 (37.7410569481125, -122.427725448366) 2 7 5 63 7
66767 88284 7 50 270 Whitney St   Sidewalk: Curb side : Cutout Tree 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51280 6004294.4 2096874.5 37.7378611907196 -122.427653449759 (37.7378611907196, -122.427653449759) 2 7 5 63 7
139345 226820 1 50 1891 Church St 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6004617.45608 2097657.55415 37.740029548214 -122.426592230667 (37.740029548214, -122.426592230667) 2 7 5 63 7
175338 226824 1 50 463 Arlington St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   6003840.68463 2095954.97206 37.7353107011233 -122.429156618694 (37.7353107011233, -122.429156618694) 2 7 5 63 7
25503 94663 7 50 1883 Church St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53800 6004614 2097695 37.7401321706185 -122.426606846161 (37.7401321706185, -122.426606846161) 2 7 5 63 7
29492 94652 7 50 463 Arlington St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/27/2017 12:00:00 AM 3 3x3 Permit Number 779226 6003847 2095961 37.735327609986 -122.429135213798 (37.735327609986, -122.429135213798) 2 7 5 63 7
130550 34378 7 50 192 Laidley St 3 Sidewalk: Curb side : Cutout Tree 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38129 6004119.49989193 2097245.26729923 37.7388693385577 -122.428284582088 (37.7388693385577, -122.428284582088) 2 7 5 63 7
178845 34366 7 50 1891 Church St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38122 6004628.22720814 2097641.9206333 37.7399872310586 -122.426553875593 (37.7399872310586, -122.426553875593) 2 7 5 63 7