trees

Custom SQL query returning 24 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
22137 120283 1 77 139 24th Ave 1 Sidewalk: Curb side : Yard Tree 2     13     5988317.15466 2115062.63745 37.786884157218 -122.484227400222 (37.786884157218, -122.484227400222) 11 6 1 55 33
76440 136047 1 77 20 Cherry St 6 Sidewalk: Curb side : Yard Tree 2     6     5996079.9197 2115992.25742 37.7898855676012 -122.457437471381 (37.7898855676012, -122.457437471381) 11   1 54 31
79306 136048 1 77 20 Cherry St 7 Sidewalk: Curb side : Yard Tree 2     8     5996075.48126 2116002.11474 37.7899123782026 -122.457453541344 (37.7899123782026, -122.457453541344) 11   1 54 31
150831 136046 1 77 20 Cherry St 5 Sidewalk: Curb side : Yard Tree 2     6     5996087.67176 2116001.00322 37.78991002647 -122.45741128312 (37.78991002647, -122.45741128312) 11   1 54 31
158164 120284 1 77 139 24th Ave 3 Sidewalk: Curb side : Yard Tree 2     8     5988322.78334 2115034.52421 37.7868072939982 -122.484205864007 (37.7868072939982, -122.484205864007) 11 6 1 55 33
70516 123029 1 77 730 Funston Ave 2 Sidewalk: Curb side : Yard Tree 2     2 Width 3ft   5991968.39214 2110452.13533 37.7744368966539 -122.471259036935 (37.7744368966539, -122.471259036935) 11 6 2 54 11
105268 213731 1 77 72 Merced Ave 1 Sidewalk: Curb side : Yard Tree 2     4 Width 3ft   5994987.04868 2099905.16215 37.7456517715262 -122.460052772716 (37.7456517715262, -122.460052772716) 1 8 4 59 40
184976 213732 1 77 475 Dewey Blvd 3 Sidewalk: Curb side : Yard Tree 2     5 Width 3ft   5994831.427 2100060.8711 37.746070357361 -122.460602166776 (37.746070357361, -122.460602166776) 1 8 4 59 40
15965 136043 1 77 3425 Jackson St 2 Sidewalk: Curb side : Yard Tree 2     10 Width 4ft   5997844.87788 2116098.17267 37.7902776009696 -122.451338548042 (37.7902776009696, -122.451338548042) 11 6 1 54 31
43837 124379 1 77 37 Jordan Ave 1 Sidewalk: Curb side : Yard Tree 2     4 Width 4ft   5996169.18438 2114263.97819 37.785145303794 -122.457003563892 (37.785145303794, -122.457003563892) 11 6 1 54 31
83042 123363 1 77 770 04th Ave 3 Sidewalk: Curb side : Yard Tree 2     6 Width 4ft   5994763.50549 2110414.96281 37.7744961151162 -122.461587583233 (37.7744961151162, -122.461587583233) 11 6 2 54 11
88338 213729 1 77 150 Alton Ave 3 Sidewalk: Curb side : Yard Tree 2     2 Width 4ft   5993589.16073 2101660.48807 37.7503909504883 -122.465013883688 (37.7503909504883, -122.465013883688) 1 8 4 29491 40
102636 124378 1 77 37 Jordan Ave 2 Sidewalk: Curb side : Yard Tree 2     4 Width 4ft   5996168.03045 2114275.5227 37.7851769356666 -122.457008391438 (37.7851769356666, -122.457008391438) 11 6 1 54 31
116368 118026 1 77 51 Shore View Ave 3 Sidewalk: Curb side : Yard Tree 2     6 Width 4ft   5984344.44515 2112788.18454 37.780407063583 -122.49780384034 (37.780407063583, -122.49780384034) 11 6 2 55 26
120911 118028 1 77 51 Shore View Ave 1 Sidewalk: Curb side : Yard Tree 2     7 Width 4ft   5984316.15967 2112798.24876 37.780433038793 -122.49790243493 (37.780433038793, -122.49790243493) 11 6 2 55 26
182789 123365 1 77 770 04th Ave 1 Sidewalk: Curb side : Yard Tree 2     10 Width 4ft   5994764.07466 2110395.82025 37.7744435874791 -122.461584226231 (37.7744435874791, -122.461584226231) 11 6 2 54 11
183292 123364 1 77 770 04th Ave 2 Sidewalk: Curb side : Yard Tree 2     5 Width 4ft   5994764.09915 2110406.2546 37.7744722388497 -122.461584898177 (37.7744722388497, -122.461584898177) 11 6 2 54 11
51211 122964 1 77 98 09th Ave 5 Sidewalk: Curb side : Yard Tree 2     10 Width 5ft   5993049.94359 2114912.63546 37.7867467201865 -122.467842267803 (37.7867467201865, -122.467842267803) 11 6 1 54 11
90085 136045 1 77 2 Laurel St 6 Sidewalk: Curb side : Yard Tree 2     5 Width 5ft   5997979.66837 2116375.74786 37.7910474656235 -122.45089220822 (37.7910474656235, -122.45089220822) 13 6 1 54 31
103313 122967 1 77 98 09th Ave 2 Sidewalk: Curb side : Yard Tree 2     4 Width 5ft   5993050.69162 2114890.11462 37.7866849273422 -122.467838041215 (37.7866849273422, -122.467838041215) 11 6 1 54 11
119804 136040 1 77 55 Laurel St 7 Sidewalk: Curb side : Yard Tree 2     13 Width 5ft   5997963.88145 2116192.9912 37.7905447607719 -122.450933646298 (37.7905447607719, -122.450933646298) 11 6 1 54 31
121681 120334 1 77 16 West Clay St 1 Sidewalk: Curb side : Yard Tree 2     7 Width 5ft   5988822.29899 2115016.65173 37.7867872922875 -122.482476367259 (37.7867872922875, -122.482476367259) 11 6 1 55 33
147580 136044 1 77 2 Laurel St 7 Sidewalk: Curb side : Yard Tree 2     5 Width 5ft   5997978.05362 2116388.40928 37.7910821380693 -122.450898708531 (37.7910821380693, -122.450898708531) 13 6 1 54 31
180974 239003 1 77 2392 Bryant St 1 Sidewalk: Curb side : Yard Tree 2     1 Width 6ft   6009661.58461 2103420.7224 37.7561378099155 -122.409558287803 (37.7561378099155, -122.409558287803) 2 4 7 28859 19