trees

Custom SQL query returning 22 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
192824 227120 1 6 799 Duncan St 6 Sidewalk: Property side : Yard Tree 2     3 Width 4ft   6001486.23397 2099669.55813 37.7453765205103 -122.43756273743 (37.7453765205103, -122.43756273743) 2 7 5 63 22
186958 120000 1 6 818 30th Ave 1 Sidewalk: Property side : Yard Tree 2     1 Width 3ft   5986676.70436 2110336.54693 37.7738120096448 -122.489555240793 (37.7738120096448, -122.489555240793) 11 6 2 55 26
184601 119241 1 6 50 Sutro Heights Ave 2 Sidewalk: Property side : Yard Tree 2     1 Width 8ft   5981435.03386 2111334.77238 37.776245435782 -122.5077607921 (37.776245435782, -122.5077607921) 11 6 2 55 26
181974 227119 1 6 799 Duncan St 4 Sidewalk: Property side : Yard Tree 2     11 Width 4ft   6001473.16561 2099668.76787 37.7453736076231 -122.437607869022 (37.7453736076231, -122.437607869022) 2 7 5 63 22
177530 176905 1 6 68 Cambridge St 2 Sidewalk: Property side : Yard Tree 2     6 Width 3ft   6006453.00873 2094472.53688 37.7313877962987 -122.420019664972 (37.7313877962987, -122.420019664972) 9 7 7 28861 5
174893 191225 1 6 2350 20th St 2 Sidewalk: Property side : Yard Tree 2     4     6011119.4005 2104649.28038 37.7595927363317 -122.404603122242 (37.7595927363317, -122.404603122242) 10 3 8 28856 29
170413 191224 1 6 2350 20th St 1 Sidewalk: Property side : Yard Tree 2     4     6011129.67031 2104650.44992 37.7595965215873 -122.404567686256 (37.7595965215873, -122.404567686256) 10 3 8 28856 29
154132 119243 1 6 50 Sutro Heights Ave 4 Sidewalk: Property side : Yard Tree 2     1 Width 8ft   5981398.37029 2111333.42566 37.7762395779827 -122.507887519226 (37.7762395779827, -122.507887519226) 11 6 2 55 26
153956 176899 1 6 167 Madison St 2 Sidewalk: Property side : Yard Tree 2     1 Width 4ft   6005613.54422 2092807.28897 37.7267680598911 -122.422803552358 (37.7267680598911, -122.422803552358) 9 7 7 309 5
144465 227561 1 6 84 Seward St 7 Sidewalk: Property side : Yard Tree 2     9 Width 3ft   6000738.66154 2104570.78605 37.7587915779822 -122.44049917592 (37.7587915779822, -122.44049917592) 2 4 5 28862 38
83413 119242 1 6 50 Sutro Heights Ave 3 Sidewalk: Property side : Yard Tree 2     1 Width 8ft   5981417.66127 2111333.86508 37.7762419210818 -122.507820820241 (37.7762419210818, -122.507820820241) 11 6 2 55 26
78745 176904 1 6 68 Cambridge St 1 Sidewalk: Property side : Yard Tree 2     6 Width 3ft   6006443.50632 2094472.10137 37.7313860651023 -122.420052485745 (37.7313860651023, -122.420052485745) 9 7 7 28861 5
71720 227560 1 6 84 Seward St 6 Sidewalk: Property side : Yard Tree 2     8 Width 3ft   6000737.03493 2104555.7602 37.7587502280493 -122.440503723791 (37.7587502280493, -122.440503723791) 2 4 5 28862 38
57763 207044 1 6 755 Foerster St 1 Sidewalk: Property side : Yard Tree 2     4 Width 3ft   5998014.32968 2095894.50831 37.7348131350024 -122.44929603208 (37.7348131350024, -122.44929603208) 9 7 4 59 40
55754 176898 1 6 167 Madison St 1 Sidewalk: Property side : Yard Tree 2     1 Width 4ft   6005619.38027 2092788.13013 37.7267157831975 -122.422782016296 (37.7267157831975, -122.422782016296) 9 7 7 309 5
45123 107987 7 6 233 Laidley St   Sidewalk: Property side : Yard Tree 2   11/10/2014 12:00:00 AM 3   Permit Number 771182 6004231.95883 2097050.3446 37.7383404878499 -122.427881865747 (37.7383404878499, -122.427881865747) 2 7 5 63 7
40165 191226 1 6 2350 20th St 3 Sidewalk: Property side : Yard Tree 2     4 Width 7ft   6011107.06002 2104648.42845 37.7595897074225 -122.404645742032 (37.7595897074225, -122.404645742032) 10 3 8 28856 29
31711 227556 1 6 95 Seward St 2 Sidewalk: Property side : Yard Tree 2     7 Width 3ft   6000674.34081 2104608.13246 37.7588904593411 -122.440724304978 (37.7588904593411, -122.440724304978) 2 4 5 28862 38
25424 176901 1 6 167 Madison St 4 Sidewalk: Property side : Yard Tree 2     1 Width 4ft   6005600.43917 2092849.05844 37.7268820102711 -122.422851823466 (37.7268820102711, -122.422851823466) 9 7 7 309 5
13391 119240 1 6 50 Sutro Heights Ave 1 Sidewalk: Property side : Yard Tree 2     1 Width 8ft   5981455.34518 2111336.83463 37.776252294734 -122.507690683983 (37.776252294734, -122.507690683983) 11 6 2 55 26
9404 176900 1 6 167 Madison St 3 Sidewalk: Property side : Yard Tree 2     1 Width 4ft   6005606.72127 2092829.97134 37.7268299557374 -122.422828750447 (37.7268299557374, -122.422828750447) 9 7 7 309 5
5680 227559 1 6 84 Seward St 4 Sidewalk: Property side : Yard Tree 2     4 Width 3ft   6000741.27617 2104538.3206 37.7587025846742 -122.44048780488 (37.7587025846742, -122.44048780488) 2 4 5 28862 38