trees

Custom SQL query returning 17 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
147948 111036 6 224 3991-3997 Washington St 1 Front Yard : Yard Tree 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
153240 107142 6 168 2694 MCALLISTER ST 2 Front Yard : Yard Tree 2     48     5996297.4 2110789.6 37.7756129427938 -122.45630867289 (37.7756129427938, -122.45630867289) 11 6 2 54 16
153312 91106 6 17 2650 Turk Blvd 1 Front Yard : Yard Tree 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
156485 105434 6 8 4355 ANZA ST 1 Back Yard : Yard Tree 2     10     5985110.8 2111730.2 37.7775470387472 -122.495074662501 (37.7775470387472, -122.495074662501) 11 6 2 55 26
156782 12711 6 17 1449 Lake St 3 Front Yard : Cutout Tree 1   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046) 11 6 2 54 26
157354 187637 6 41 875 El Camino Del Mar 1 Side Yard : Yard Tree 2       10x10   5985641 2114972 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676) 11 6 1 55 15
161834 107985 6 51 2401x SCOTT ST 9 Sidewalk: Curb side : Cutout Tree 2       3x3   6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
162612 101203 6 17 7070 California St 2 Front Yard : Tree 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
163821 87242 6 15 4131 Geary Blvd 1 Sidewalk: Property side : Yard Tree 2         Permit Number 50271 5994116.9 2112250.5 37.7794987690846 -122.46395756624 (37.7794987690846, -122.46395756624) 11 6 2 54 11
172848 108210 6 113 524 45th Ave 1 Front Yard : Yard Tree 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
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
179316 112056 6 37 762 FUNSTON AVE 1 Sidewalk: Curb side : Cutout Tree 2 FUF   8     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
182598 92909 6 17 100 32nd Ave 1 Front Yard : Yard Tree 2   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
186507 254476 6 41 1511 Lyon St 1 Front Yard : Cutout Tree 2           5999620 2114151 37.7850326563334 -122.445056733542 (37.7850326563334, -122.445056733542) 15 6 1 29490 31
188669 99699 6 127 1750 Divisadero St 2 Front Yard : Cutout Tree 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27
189234 112390 6 52 2201X LYON ST 1 Sidewalk: Property side : Cutout Tree 2       3x12   5999307 2116423 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227) 13 6 1 29490 31
191593 91111 6 15 2650 Turk Blvd 2 Front Yard : Yard Tree 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16