trees

Custom SQL query returning 30 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
5130 19834 1 286 100 STAIRWAY25 18 Sidewalk: Curb side : Cutout Tree 1     12 60X                      
7872 245376 1 286 3611 Mission St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6005395.9652 2097114.2995 37.7385818748087 -122.423861844056 (37.7385818748087, -122.423861844056) 2 7 7 28859 2
24547 249901 1 286 300 Greenwich St 2 Front Yard : Yard Tree 2     12 Width 0ft   6011319.85653 2120418.34038 37.8029020914108 -122.405020163053 (37.8029020914108, -122.405020163053) 3 1 10 308 23
29551 197374 1 286 950x Kansas St 1 Median : Yard Tree 1     8     6011591.5235 2103896.27295 37.7575515198905 -122.402917314288 (37.7575515198905, -122.402917314288) 10 3 8 28856 29
65097 110683 4 286 1 EDDY ST 1 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
65462 116225 4 286 118 CHATTANOOGA ST 1 Sidewalk: Curb side : Cutout Tree 2   04/20/2016 12:00:00 AM 3 3x3 Permit Number 777927 6004700 2102839 37.7542612701636 -122.426675709979 (37.7542612701636, -122.426675709979) 2 4 5 28862 22
80055 249907 1 286 302 Greenwich St 8 Front Yard : Yard Tree 2     15 Width 0ft   6011291.70664 2120428.42436 37.8029282059207 -122.405118287185 (37.8029282059207, -122.405118287185) 3 1 10 308 23
81310 31953 1 286 324 Larkin St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/06/1999 12:00:00 AM 4   Permit Number 41408 6007710.0688 2112466.2141 37.7808650628582 -122.416948170198 (37.7808650628582, -122.416948170198) 7 9 9 28852 36
90370 197372 1 286 930 Kansas St 4 Front Yard : Yard Tree 2     25     6011613.90792 2103884.43546 37.7575202666628 -122.402839066964 (37.7575202666628, -122.402839066964) 10 3 8 28856 29
97078 256001 1 286 358 Missouri St 1 Sidewalk: Property side : Cutout Tree 2       Width 3ft   6013435 2105417 37.7618298697813 -122.396648386097 (37.7618298697813, -122.396648386097) 10 3 8 28856 29
99466 113974 4 286 11 Hiliritas Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/22/2015 12:00:00 AM 27 3x3   6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865) 2 7 5 63 7
101109 110690 4 286 1 EDDY ST 8 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
101272 110684 4 286 1 EDDY ST 2 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
122253 247901 1 286 353 Mayflower St 3 Side Yard : Yard Tree 2     5     6009990.60603 2098394.26971 37.7423547103086 -122.408065946488 (37.7423547103086, -122.408065946488) 10 7 7 28859 2
128072 110686 4 286 1 EDDY ST 4 Median : Cutout Tree 2       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
140351 110689 4 286 1 EDDY ST 7 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
143278 110685 4 286 1 EDDY ST 3 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
145201 240508 1 286 1270 York St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6010037.21267 2101807.01479 37.7517279689944 -122.408145428579 (37.7517279689944, -122.408145428579) 2 4 7 28859 19
145685 247886 1 286 360 Mayflower St 1 Side Yard : Yard Tree 2     5     6009987.94672 2098379.73549 37.7423146536018 -122.408074116841 (37.7423146536018, -122.408074116841) 10 7 7 28859 2
147194 249905 1 286 302 Greenwich St 6 Front Yard : Yard Tree 2     12 Width 0ft   6011303.37304 2120427.41092 37.8029260754455 -122.405077843794 (37.8029260754455, -122.405077843794) 3 1 10 308 23
149097 197371 1 286 930 Kansas St 3 Front Yard : Yard Tree 2     24     6011612.77575 2103909.97364 37.7575903256389 -122.402844778561 (37.7575903256389, -122.402844778561) 10 3 8 28856 29
158526 136351 1 286 301 Euclid Ave 1 Sidewalk: Property side : Yard Tree 2     7 Width 4ft   5997836.98709 2113854.31851 37.7841161199161 -122.45120396002 (37.7841161199161, -122.45120396002) 15 6 1 54 31
160617 110687 4 286 1 EDDY ST 5 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
162775 240509 1 286 1541 Sanchez St 2 Sidewalk: Curb side : Cutout Tree 2     7 3x3   6003987.73328 2099308.02759 37.744525748363 -122.428887189917 (37.744525748363, -122.428887189917) 2 7 5 63 22
174679 98491 6 286 55X Perine Pl 1 Back Yard : Cutout Tree 2         Permit Number 768655 6002130.5 2115544.8 37.7890026421633 -122.436471006098 (37.7890026421633, -122.436471006098) 13 6 1 29490 27
183890 249904 1 286 302 Greenwich St 5 Front Yard : Yard Tree 2     16 Width 0ft   6011306.26717 2120416.48973 37.8028962503191 -122.405067059111 (37.8028962503191, -122.405067059111) 3 1 10 308 23
187289 115806 6 286 362 MISSOURI ST 1 Front Yard : Cutout Tree 2     12 3x3   6013446 2105415 37.7618249904211 -122.39661020099 (37.7618249904211, -122.39661020099) 10 3 8 28856 29
187514 110688 4 286 1 EDDY ST 6 Median : Cutout Tree 1       3x3   6010419 2113787 37.7846436353836 -122.40766976216 (37.7846436353836, -122.40766976216) 14 10 10 28852 36
190493 197373 1 286 999 Kansas St 2 Side Yard : Yard Tree 2     10     6011643.7126 2103814.56815 37.7573300906303 -122.402731076388 (37.7573300906303, -122.402731076388) 10 3 8 28856 29
193325 249902 1 286 300 Greenwich St 3 Front Yard : Yard Tree 2     15 Width 0ft   6011311.249 2120408.87898 37.8028756315546 -122.405049283115 (37.8028756315546, -122.405049283115) 3 1 10 308 23