trees

Custom SQL query returning 20 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
992 192119 7 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
5748 115724 4 243 250x Octavia St 1 Side Yard : Yard Tree 7                              
38544 14628 7 27 460 McAllister St 1 Sidewalk: Curb side : Cutout Tree 7     20 3X3   6006936.4820313 2112240.9458517 37.7802029857658 -122.419608403425 (37.7802029857658, -122.419608403425) 7 9 9 28852 36
45235 15147 7 53 895X Mission St 1 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
46393 91975 7 40 1320X 09th Ave 1 Sidewalk: Curb side : Cutout Tree 7   02/20/2009 12:00:00 AM 3 3x3   5993343.893066 2106486.203602 37.7636269686455 -122.46621268437 (37.7636269686455, -122.46621268437) 1 8 11 56 12
55672 23150 7 11 50 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 7     3 3X3   6007031.8302252 2110521.0652082 37.7754859780082 -122.419156518057 (37.7754859780082, -122.419156518057) 7 9 9 28852 36
60921 239 7 99 3010X 19th Ave 1 Sidewalk: Curb side : Cutout Tree 7     90 2   5990623.3177 2095139.449 37.7323143965058 -122.474793962374 (37.7323143965058, -122.474793962374) 1 8 4 64 40
88124 27588 7 78 2100X San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree 7   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.949435 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696) 10 7 7 309 2
110566 14098 7 27 1480X Market St 1 Sidewalk: Curb side : Cutout Tree 7     12 4x4   6007076.6773563 2110527.4337913 37.7755059900951 -122.419001832587 (37.7755059900951, -122.419001832587) 7 2 9 28852 36
115211 59556 7 36 4079 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree 7 Private 02/03/1981 12:00:00 AM 15   Permit Number 18942 6003404.16952868 2100363.87266154 37.7473918055728 -122.430980375601 (37.7473918055728, -122.430980375601) 2 4 5 63 22
122483 14626 7 148 410X McAllister St 1 Sidewalk: Curb side : Cutout Tree 7   01/05/2001 12:00:00 AM 20 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
127129 23174 1 27 240 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree 7     5 3x3   6006908.21847 2111432.04348 37.7779803432508 -122.419648771078 (37.7779803432508, -122.419648771078) 7 9 9 28852 36
150707 28886 7 19 120X 04th St 1 Sidewalk: Curb side : Cutout Tree 7   02/11/2006 12:00:00 AM 3 3x3   6011510.8284999 2113558.299704 37.7840767362854 -122.403876281312 (37.7840767362854, -122.403876281312) 12 2 9 28853 34
155906 134565 1 27 99 Grove St 1 Sidewalk: Curb side : Cutout Tree 7     15 Width 4ft   6007431.26589 2111583.6583 37.7784260904314 -122.417850109903 (37.7784260904314, -122.417850109903) 7 9 9 28852 36
156055 653 1 53 3255X 24th St 1 Sidewalk: Curb side : Cutout Tree 7     3 4x4   6007260.4251 2102038.7621 37.7522084236972 -122.417764377532 (37.7522084236972, -122.417764377532) 2 4 7 28859 19
165205 9950 7 27 95X Grove St 1 Sidewalk: Curb side : Cutout Tree 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
166064 14099 7 27 1484 Market St 1 Sidewalk: Curb side : Cutout Tree 7     12 4X4   6007056.5524178 2110508.208095 37.7754520676647 -122.419070085744 (37.7754520676647, -122.419070085744) 7 2 9 28852 36
170682 14102 7 27 1525 Market St 1 Sidewalk: Curb side : Cutout Tree 7     12 4X4   6006946.0284757 2110289.3486747 37.774844907593 -122.419436884969 (37.774844907593, -122.419436884969) 8 2 9 28853 19
181356 110306 1 14 899x Stanyan St 1 Sidewalk: Curb side : Cutout Tree 7   04/03/2015 12:00:00 AM   4x3.9   5997166.64381 2107575.86009 37.7668387037649 -122.45306972129 (37.7668387037649, -122.45306972129) 15 5 11 29492 8
188945 112147 4 12 101X 05TH ST 1 Sidewalk: Curb side : Cutout Tree 7     10 3x3   6010794 2113100 37.782778280213 -122.406323959165 (37.782778280213, -122.406323959165) 12 2 9 28853 34