trees

Custom SQL query returning 28 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
3329 260429 2 116 580 Capp St 7 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
3779 231240 2 27 2000 Bryant St 7 Sidewalk: Curb side : Cutout Tree 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009523.77815 2105243.21899 37.7611342507514 -122.410163536041 (37.7611342507514, -122.410163536041) 2 4 7 28859 19
7258 262001 2 27 607X Florida St 7 Sidewalk: Curb side : Cutout Tree 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
9333 261584 2 146 496 Urbano Dr 7 Sidewalk: Property side : Yard Tree 2       3x3   5992575 2091875 37.7234639294961 -122.467809264789 (37.7234639294961, -122.467809264789) 9 8 4 59 40
31968 253741 2 11 1 Henry Adams St 7 Sidewalk: Curb side : Cutout Tree 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
34241 122599 2 44 42X Colin P Kelly Jr St 7 Sidewalk: Curb side : Cutout Tree 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
35262 253489 2 116 1x Gordon St 7 Sidewalk: Curb side : Cutout Tree 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
41331 14313 2 27 2190X Market St 7 Sidewalk: Curb side : Cutout Tree 2   08/03/2018 12:00:00 AM 3 4x4 Permit Number 782146 6003603.86 2107219.9092 37.7662281664546 -122.430779049243 (37.7662281664546, -122.430779049243) 7 4 5 28862 3
48111 253753 2 11 2x Rhode Island St 7 Sidewalk: Curb side : Cutout Tree 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
50671 203206 2 72 189 Hubbell St 7 Sidewalk: Curb side : Cutout Tree 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013175.33077 2107284.78304 37.7669439332411 -122.397677495329 (37.7669439332411, -122.397677495329) 14 3 8 28856 20
52894 121531 2 12 333 Beale St 7 Sidewalk: Curb side : Cutout Tree 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
59194 198587 2 31 980 16th St 7 Sidewalk: Curb side : Cutout Tree 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013654.04555 2107139.63113 37.7665720240075 -122.396011512024 (37.7665720240075, -122.396011512024) 14 3 8 28856 20
75283 118380 2 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
83479 17757 2 127 1634 Pine St 7 Sidewalk: Curb side : Cutout Tree 1   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6005917.49192 2115584.99362 37.7893274652545 -122.423371354677 (37.7893274652545, -122.423371354677) 13 9 1 28858 41
102091 121512 2 11 300 Folsom St 7 Sidewalk: Property side : Cutout Tree 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
113221 122425 2 159 2655 Bush St 7 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
115253 251524 2 11 173 Sanchez St 7 Sidewalk: Curb side : Cutout Tree 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
116898 115354 2 75 399 Fremont St 7 Sidewalk: Curb side : Cutout Tree 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014804.62773 2114662.16926 37.7872911737029 -122.39255807669 (37.7872911737029, -122.39255807669) 6 2 9 28855 6
119022 60277 2 14 2690 Harrison St 7 Sidewalk: Curb side : Cutout Tree 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51145 6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
126344 109462 2 164 360 Berry St 7 Sidewalk: Curb side : Cutout Tree 2     10 4x4 Permit Number 773752 6013376.015 2109435.75899 37.7728612052211 -122.3971341969 (37.7728612052211, -122.3971341969) 14 2 9 310 20
131987 254722 2 31 900 16th St 7 Sidewalk: Curb side : Cutout Tree 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
134197 201699 2 11 342 08th St 7 Sidewalk: Curb side : Cutout Tree 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010014.86815 2109861.25987 37.7738418457656 -122.408790872027 (37.7738418457656, -122.408790872027) 8 2 9 28853 34
134827 255697 2 11 510 Townsend St 7 Sidewalk: Curb side : Cutout Tree 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
139844 121546 2 75 318 Main St 7 Sidewalk: Curb side : Cutout Tree 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
145930 44005 2 50 2701X 17th St 7 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
149325 187946 2 75 300 Main St 7 Sidewalk: Curb side : Yard Tree 2     3     6015145.56326 2115239.56325 37.7888954931699 -122.391418882079 (37.7888954931699, -122.391418882079) 6 2 9 28855 6
176698 256681 2 36 330 Twin Peaks Blvd 7 Front Yard : Yard Tree 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
179705 255411 2 75 199x Hayes St 7 Sidewalk: Curb side : Cutout Tree 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36