trees

Custom SQL query returning 18 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
16583 241346 1 123 2601 Mariposa St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 6ft   6009581.66758 2105919.15522 37.7629934624139 -122.410011039795 (37.7629934624139, -122.410011039795) 8 4 8 28859 19
21100 241341 1 123 2701 18th St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6009762.27519 2105459.58065 37.7617416960496 -122.409353942929 (37.7617416960496, -122.409353942929) 2 4 8 28859 19
25076 241291 1 123 1225 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6011156.6405 2102469.67171 37.7536100953402 -122.404320914102 (37.7536100953402, -122.404320914102) 10 4 8 28859 19
42098 241379 1 123 3702 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6008438.87775 2097614.97452 37.7401279331501 -122.413376271417 (37.7401279331501, -122.413376271417) 2 7 7 28859 2
51900 40680 1 123 227 Maynard St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/10/1999 12:00:00 AM 11   Permit Number 41663 6004891.01488 2093810.36977 37.7294815042584 -122.425372669006 (37.7294815042584, -122.425372669006) 9 7 6 28861 5
53461 196972 1 123 900 Pennsylvania Ave 10 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   6014458.90845 2102627.41024 37.7542271903342 -122.392911888877 (37.7542271903342, -122.392911888877) 10 3 8 28856 29
54649 241274 1 123 2616 21st St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6010311.63301 2104008.02665 37.7577868194278 -122.407351591615 (37.7577868194278, -122.407351591615) 10 4 7 28859 19
55713 136180 1 123 3134 Baker St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5999407.16472 2119635.33058 37.8000790286731 -122.446187711617 (37.8000790286731, -122.446187711617) 13 9 1 57 17
64123 123208 1 123 400 09th Ave 4 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5993131.19371 2112699.04699 37.7806735020779 -122.467400140372 (37.7806735020779, -122.467400140372) 11 6 2 54 11
67242 241290 1 123 1227 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6011160.10458 2102427.21865 37.753493722159 -122.404305946667 (37.753493722159, -122.404305946667) 10 4 8 28859 19
91402 241353 1 123 2601 Mariposa St 9 Sidewalk: Curb side : Cutout Tree 2     11 Width 6ft   6009702.25291 2105928.94008 37.7630270871447 -122.409594665358 (37.7630270871447, -122.409594665358) 8 4 8 28859 19
103864 32350 1 123 2180 Bryant St 5 Sidewalk: Curb side : Cutout Tree 2 FUF 10/03/1996 12:00:00 AM 11   Permit Number 36907 6009568.01706 2104596.56642 37.7593611689943 -122.40996488119 (37.7593611689943, -122.40996488119) 2 4 7 28859 19
111775 241385 1 123 2169 Folsom St 5 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   6008146.20784 2105935.07496 37.7629566162671 -122.41497694503 (37.7629566162671, -122.41497694503) 8 4 7 28859 19
143795 247599 1 123 900 Tompkins Ave 4 Sidewalk: Property side : Yard Tree 2     11 Width 10ft   6009183.00439 2096409.33052 37.7368592482464 -122.410718251366 (37.7368592482464, -122.410718251366) 10 7 7 28859 2
157891 241292 1 123 1223 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6011155.71596 2102482.72814 37.7536458937577 -122.404325030294 (37.7536458937577, -122.404325030294) 10 4 8 28859 19
159489 241280 1 123 1334 Hampshire St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6010312.03054 2101467.09279 37.7508100021879 -122.40717110848 (37.7508100021879, -122.40717110848) 2 4 7 28859 19
160657 37985 1 123 570 Texas St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/08/1998 12:00:00 AM 11   Permit Number 40207 6013793.63158 2104435.25023 37.7591541522658 -122.395339235527 (37.7591541522658, -122.395339235527) 10 3 8 28856 29
180734 241381 1 123 2169 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 4ft   6008153.50864 2105811.23118 37.7626169800981 -122.414942928177 (37.7626169800981, -122.414942928177) 8 4 7 28859 19