trees

Custom SQL query returning 19 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
15441 70583 1 65 1801 Clement St 3 Sidewalk: Curb side : Cutout Tree 2 FUF   13     5989858.46515 2113331.71432 37.7822211492768 -122.478768239422 (37.7822211492768, -122.478768239422) 11 6 2 55 26
41585 37085 1 65 1487 45th Ave 2 Sidewalk: Curb side : Cutout Tree 2   06/01/1998 12:00:00 AM 13   Permit Number 39685 5982149.7032 2104986.8677 37.7588580004754 -122.504818115198 (37.7588580004754, -122.504818115198) 1 8 3 56 35
48865 175202 1 65 654 Peru Ave 6 Side Yard : Yard Tree 2     13     6005192.08696 2092525.09672 37.7259694331304 -122.424240458534 (37.7259694331304, -122.424240458534) 9 7 6 28861 5
66364 175206 1 65 653 Peru Ave 7 Side Yard : Yard Tree 2     13     6005071.10082 2092642.69367 37.7262854962678 -122.424667061852 (37.7262854962678, -122.424667061852) 9 7 6 28861 5
111637 37615 1 65 458 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/26/1998 12:00:00 AM 13   Permit Number 40039 5990633.38312 2112269.25863 37.779348904808 -122.476009778191 (37.779348904808, -122.476009778191) 11 6 2 54 26
175566 53159 1 65 1747@ 3RD ST Quesada Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 11/02/2006 12:00:00 AM 13   Permit Number 49080 6014484.90518 2095154.52732 37.7337096578753 -122.392299359741 (37.7337096578753, -122.392299359741) 10 3 8 58 1
182539 38225 1 65 1099 Mississippi St 2 Sidewalk: Curb side : Cutout Tree 2   07/21/1998 12:00:00 AM 13   Permit Number 40351 6014263.22127 2102058.4146 37.7526539784223 -122.39354880945 (37.7526539784223, -122.39354880945) 10 3 8 28856 29
12461 70586 1 65 1829 Clement St 2 Sidewalk: Curb side : Cutout Tree 2 FUF   13 3x3   5989790.05617 2113327.40851 37.7822053543666 -122.479004586193 (37.7822053543666, -122.479004586193) 11 6 2 55 26
79042 95674 1 65 1898X Clement St 1 Sidewalk: Curb side : Cutout Tree 2     13 3x6   5989702.02326 2113382.65311 37.7823519280112 -122.479313179938 (37.7823519280112, -122.479313179938) 11 6 2 55 26
91062 84740 1 65 143 Alhambra St 1 Front Yard : Cutout Tree 2   03/27/2007 12:00:00 AM 13 4x6 Permit Number 49254 6001588.49283 2120281.76365 37.8019782934262 -122.438685839601 (37.8019782934262, -122.438685839601) 13 9 1 57 17
23153 125554 1 65 22 Dashiell Hammett St 3 Sidewalk: Curb side : Cutout Tree 2     13 Width 1ft   6010380.8435 2116036.16558 37.7908171708214 -122.40796043625 (37.7908171708214, -122.40796043625) 5 1 10 28857 21
167184 221846 1 65 19 Saint Marys Ave 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 2ft   6004388.2708 2095606.1808 37.7343839821397 -122.427238573395 (37.7343839821397, -122.427238573395) 2 7 5 28861 25
65100 221877 1 65 22 Coleridge St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6006964.5888 2099612.44373 37.7455296507747 -122.418615385312 (37.7455296507747, -122.418615385312) 2 7 7 28859 2
77457 175216 1 65 240 Dwight St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6010752.32605 2091460.28671 37.7233580771044 -122.404944037249 (37.7233580771044, -122.404944037249) 10 3 7 309 28
123884 203541 1 65 510 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5998007.81838 2094409.85226 37.7307362500822 -122.449211618134 (37.7307362500822, -122.449211618134) 9 7 4 59 40
149376 203563 1 65 1725 10th Ave 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5993082.43615 2103702.81326 37.7559694172734 -122.466914614344 (37.7559694172734, -122.466914614344) 1 8 4 56 12
578 221823 1 65 199X Ogden Ave 6 Sidewalk: Curb side : Pot Tree 2     13 Width 4ft   6007760.27568 2096148.55485 37.7360633428545 -122.415618808282 (37.7360633428545, -122.415618808282) 2 7 7 28859 2
72559 221853 1 65 430 Clipper St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 4ft   6002339.61262 2100938.00703 37.7489078650277 -122.434702583968 (37.7489078650277, -122.434702583968) 2 4 5 28862 22
150779 125547 1 65 1445 Greenwich St 3 Sidewalk: Curb side : Cutout Tree 2     13 Width 4ft   6005968.56582 2119641.09275 37.8004673748183 -122.423483123267 (37.8004673748183, -122.423483123267) 13 9 1 28858 32