trees

Custom SQL query returning 38 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
3008 251503 1 63 800X Bosworth St 15 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
5758 262529 8 63 555 Portola Dr 8 Front Yard : Yard Tree 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
12407 115154 1 63 245x ARLINGTON ST 3 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
15787 12969 1 63 99X Lippard Ave 3 Sidewalk: Curb side : Cutout Tree 1     36 3X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
19749 234503 1 63 1000 San Jose Ave 39 Front Yard : Yard Tree 2     2     6005117.95051 2097175.77056 37.7387349615553 -122.424827458621 (37.7387349615553, -122.424827458621) 2 7 5 63 7
22210 111263 1 63 700X BOSWORTH ST 1 Front Yard : Yard Tree 1     36     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
22926 251501 1 63 800X Bosworth St 13 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
24668 97534 6 63 203 Surrey St 1 Front Yard : Yard Tree 2         Permit Number 768282 6002070 2096079.6 37.7355525046422 -122.435287431957 (37.7355525046422, -122.435287431957) 2 7 5 63 7
38246 111524 1 63 900x BOSWORTH ST 2 Front Yard : Yard Tree 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
50762 2044 1 63 700X Bosworth St 1 Front Yard : Cutout Tree 1     36   Permit Number 772999 6002154.6210393 2095431.8532492 37.7337787461998 -122.434948555048 (37.7337787461998, -122.434948555048) 2 7 5 63 7
55697 111280 1 63 700X BOSWORTH ST 18 Front Yard : Cutout Tree 1     48     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
60691 111521 1 63 800x BOSWORTH ST 16 Front Yard : Yard Tree 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
62583 234511 1 63 1300 San Jose Ave 59 Front Yard : Yard Tree 2     5 Width 10ft   6003237.34595 2095470.24367 37.7339455743229 -122.431207993878 (37.7339455743229, -122.431207993878) 2 7 5 63 7
63289 111517 1 63 800x BOSWORTH ST 12 Front Yard : Yard Tree 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
68470 251502 1 63 800X Bosworth St 14 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69354 111518 1 63 800x BOSWORTH ST 13 Front Yard : Yard Tree 1     27     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
86352 234521 1 63 5300x Diamond Heights Blvd 4 Median : Yard Tree 1     30     6001544.41953 2098938.98574 37.7433738490244 -122.437309239227 (37.7433738490244, -122.437309239227) 2 7 5 63 7
90813 111522 1 63 800x BOSWORTH ST 17 Front Yard : Yard Tree 1     20     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
93601 115152 1 63 245x ARLINGTON ST 1 Median : Yard Tree 1     30 3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
97461 115155 1 63 245x ARLINGTON ST 4 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
105484 115153 1 63 245x ARLINGTON ST 2 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
105900 234504 1 63 1100 San Jose Ave 5 Front Yard : Yard Tree 2     16     6004845.11812 2096728.13188 37.7374904329363 -122.425738932323 (37.7374904329363, -122.425738932323) 2 7 5 63 7
110008 111523 1 63 900x BOSWORTH ST 1 Front Yard : Yard Tree 1     28     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
115262 251499 1 63 800X Bosworth St 11 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
119227 234505 1 63 1100 San Jose Ave 7 Front Yard : Yard Tree 2     16     6004841.55243 2096717.56088 37.7374612058616 -122.425750508406 (37.7374612058616, -122.425750508406) 2 7 5 63 7
121594 12970 1 63 99X Lippard Ave 4 Sidewalk: Curb side : Cutout Tree 1     36 5X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
126197 115156 1 63 245x ARLINGTON ST 5 Median : Yard Tree 1       3x3   6004671 2096632 37.7372166357496 -122.426334098447 (37.7372166357496, -122.426334098447) 2 7 5 63 7
134644 12968 1 63 99X Lippard Ave 2 Sidewalk: Curb side : Cutout Tree 1     36 4X4   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
148503 111281 1 63 700X BOSWORTH ST 19 Front Yard : Yard Tree 1     48     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
148660 234506 1 63 1100 San Jose Ave 8 Front Yard : Yard Tree 2     24     6004826.97139 2096714.28402 37.737451384369 -122.425800688759 (37.737451384369, -122.425800688759) 2 7 5 63 7
150055 111519 1 63 800x BOSWORTH ST 14 Front Yard : Yard Tree 1     36     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
161041 234512 1 63 1300 San Jose Ave 61 Front Yard : Yard Tree 2     12 Width 6ft   6003219.80457 2095456.80721 37.7339076867834 -122.431267680974 (37.7339076867834, -122.431267680974) 2 7 5 63 7
163088 12974 1 63 84 Lippard Ave 3 Sidewalk: Curb side : Cutout Tree 1     24 3X3   6001901.0890899 2095580.5218873 37.7341725574726 -122.435835722721 (37.7341725574726, -122.435835722721) 2 7 5 63 7
177928 251498 1 63 800X Bosworth St 10 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
183860 111506 1 63 800x BOSWORTH ST 1 Front Yard : Yard Tree 1     48     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
184944 251500 1 63 800X Bosworth St 12 Side Yard : Yard Tree 1           6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
186052 12967 1 63 99X Lippard Ave 1 Sidewalk: Curb side : Cutout Tree 1     30 3X3   6001957.7757889 2095598.483465 37.7342250957668 -122.435641023763 (37.7342250957668, -122.435641023763) 2 7 5 63 7
187165 234507 1 63 1100 San Jose Ave 32 Sidewalk: Property side : Yard Tree 2     17 Width 9ft   6004787.92016 2096687.497 37.7373756263678 -122.425933801003 (37.7373756263678, -122.425933801003) 2 7 5 63 7