trees

Custom SQL query returning 35 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
118486 100845 4 63 1 Estero Ave 3 Sidewalk: Property side : Yard Tree 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
36279 99451 4 63 400X Miramar Ave 1 Median : Cutout Tree 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
193394 99455 4 63 400X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.458120762721 (37.7250639553871, -122.458120762721) 9 7 4 28861 40
23455 97490 4 63 500X Miramar Ave 7 Median : Cutout Tree 2     12 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
70023 97489 4 63 500X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
163251 97485 4 63 500X Miramar Ave 1 Median : Cutout Tree 2     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.458022688068 (37.7258701708071, -122.458022688068) 9 7 4 28861 40
33425 99460 4 63 550X Miramar Ave 7 Median : Cutout Tree 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
161917 99457 4 63 550X Miramar Ave 1 Median : Cutout Tree 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
188497 99458 4 63 550X Miramar Ave 3 Median : Cutout Tree 2     30 15x280   5995413 2092983.7 37.7266716211667 -122.458079078858 (37.7266716211667, -122.458079078858) 9 7 4 28861 40
49979 99473 4 63 600X Miramar Ave 2 Median : Cutout Tree 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
139390 99472 4 63 600X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995435.2 2093399 37.7278132105567 -122.458032376835 (37.7278132105567, -122.458032376835) 9 7 4 28861 40
101918 99474 4 63 650X Miramar Ave 5 Median : Cutout Tree 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
111527 99477 4 63 650X Miramar Ave 6 Median : Cutout Tree 2     30 15x280   5995425.4 2093662.3 37.728535605791 -122.458085302932 (37.728535605791, -122.458085302932) 9 7 4 28861 40
74864 99487 4 63 700X Miramar Ave 4 Median : Cutout Tree 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
142912 99486 4 63 700X Miramar Ave 3 Median : Cutout Tree 2     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204) 9 7 4 28861 40
106034 255453 4 63 90 Kiska Rd 1 Front Yard : Yard Tree 2       3x3   6018381 2093938 37.7305848832053 -122.378744818809 (37.7305848832053, -122.378744818809) 10 3 8 58 1
1588 260075 4 63 171X Gellert Dr 1 Median : Yard Tree 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
139657 256152 4 63 80X Peralta Ave 1 Median : Cutout Tree 2       3x3   6010428 2100359 37.747773912222 -122.406691992098 (37.747773912222, -122.406691992098) 2 7 7 28859 2
193904 99774 4 63 4330 26th St 1 Sidewalk: Curb side : Cutout Tree 2       8x6   6001764 2100607 37.7479663028981 -122.436669359529 (37.7479663028981, -122.436669359529) 2 4 5 28862 22
87762 117289 4 63 26X GLADEVIEW WAY 1 Sidewalk: Curb side : Yard Tree 2       3x3   5997876 2101605 37.7504848455829 -122.450185761312 (37.7504848455829, -122.450185761312) 1 5 4 63 38
77915 257969 4 63 1998X 09th Ave 1 Sidewalk: Property side : Yard Tree 2       6x15   5993560 2101938 37.7511512457798 -122.465134876758 (37.7511512457798, -122.465134876758) 1 8 4 29491 12
8023 121696 4 63 1300x De Haro St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
140522 121695 4 63 1300x De Haro St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
179258 121697 4 63 1300x De Haro St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6012218 2102254 37.7530771598286 -122.400635326689 (37.7530771598286, -122.400635326689) 10 3 8 28856 29
120346 98601 4 63 301 Twin Peaks Blvd 1 Sidewalk: Property side : Cutout Tree 2     24 3x3   5998661.2 2104103.7 37.757390562446 -122.447650343479 (37.757390562446, -122.447650343479) 15 5 5 63 3
92020 110148 4 63 90 WOODLAND AVE 2 Sidewalk: Curb side : Cutout Tree 2     38 4x9   5997155.9 2105983.7 37.7624664223167 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
193846 110147 4 63 90 WOODLAND AVE 1 Sidewalk: Curb side : Cutout Tree 2     46 4x15   5997155.9 2105983.7 37.7624664223167 -122.452991942132 (37.7624664223167, -122.452991942132) 15 5 11 29492 12
25732 116996 4 63 606x FULTON ST   Front Yard : Yard Tree 2   09/29/2016 12:00:00 AM 3     6004628 2111737 37.7786889706302 -122.427558590519 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
99612 258091 4 63 1500x Steiner St 1 Sidewalk: Property side : Yard Tree 1       15x50   6002808 2113496 37.7834156319858 -122.433980438269 (37.7834156319858, -122.433980438269) 13 9 11 29490 41
163885 115556 4 63 3897 CLAY ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5996199 2115222 37.7877774871206 -122.456969730492 (37.7877774871206, -122.456969730492) 11 6 1 54 31
90211 96976 4 63 390X Filbert St 1 Median : Yard Tree 5     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116) 3 1 10 308 23
50112 109625 4 63 312x FILBERT ST 1 Unaccepted Street : Yard Tree 2     14     6011362.9 2120079.8 37.801974948341 -122.40484736081 (37.801974948341, -122.40484736081) 3 1 10 308 23
17203 107449 4 63 1130x CHESTNUT ST 1 Unaccepted Street : Yard Tree 2     60     6006351.9 2120450.9 37.8027125282147 -122.422214196597 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
103781 108605 4 63 1140x CHESTNUT ST 2 Unaccepted Street : Yard Tree 2           6006369.1 2120452.7 37.8027184407042 -122.422154803739 (37.8027184407042, -122.422154803739) 5 9 1 28858 32
85334 256616 4 63 1541X Montgomery St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23