trees

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
33650 251244 1 27 99 Grove St 5 Sidewalk: Curb side : Cutout Tree 7   05/29/2013 12:00:00 AM       6007340.02606 2111591.01475 37.7784411543423 -122.418166265193 (37.7784411543423, -122.418166265193) 7 9 9 28852 36
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
40645 134568 1 27 99 Grove St 4 Sidewalk: Curb side : Cutout Tree 7   12/17/2009 12:00:00 AM 5 Width 4ft   6007669.37768 2111613.23365 37.7785206946058 -122.417028485685 (37.7785206946058, -122.417028485685) 7 9 9 28852 36
43608 112287 1 11 50 Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree 7     5     6007006.5 2110627.3 37.7757762467653 -122.419251679167 (37.7757762467653, -122.419251679167) 7 9 9 28852 36
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
56609 9951 7 27 95X Grove St 2 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
65065 23151 7 11 50 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree 7   08/24/1993 12:00:00 AM 8 3X3   6007030.5326516 2110530.1061031 37.7755107290659 -122.419161648128 (37.7755107290659, -122.419161648128) 7 9 9 28852 36
90491 134567 1 27 99 Grove St 3 Sidewalk: Curb side : Cutout Tree 7   07/06/2011 12:00:00 AM 4 Width 4ft   6007561.6986 2111595.58464 37.7784661768053 -122.417399738421 (37.7784661768053, -122.417399738421) 7 9 9 28852 36
94893 9952 7 27 95X Grove St 3 Sidewalk: Curb side : Cutout Tree 7   07/06/2011 12:00:00 AM 3 3x3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
102440 14627 7 27 410X McAllister St 2 Sidewalk: Curb side : Cutout Tree 7     35 3X3   6007165.24508 2112272.29684 37.7803019512551 -122.418819229453 (37.7803019512551, -122.418819229453) 7 9 9 28852 36
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
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
125734 26896 7 27 460 McAllister St 2 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
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
128940 23156 7 11 50 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 7   08/24/1993 12:00:00 AM 18 3X3   6007006.484382 2110627.274272 37.7757761752428 -122.419251731369 (37.7757761752428, -122.419251731369) 7 9 9 28852 36
133044 9953 7 27 95X Grove St 4 Sidewalk: Curb side : Cutout Tree 7   12/17/2009 12:00:00 AM 12 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
146362 134566 1 27 99 Grove St 2 Sidewalk: Curb side : Cutout Tree 7     14 Width 4ft   6007493.55732 2111589.97349 37.7784469358085 -122.417635067622 (37.7784469358085, -122.417635067622) 7 9 9 28852 36
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
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
190500 23152 7 11 50 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 7   10/03/2000 12:00:00 AM 12     6007026.70172 2110556.798269 37.7755838036152 -122.419176794071 (37.7755838036152, -122.419176794071) 7 9 9 28852 36