trees

Custom SQL query returning 38 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
770 111807 4 53 50X COLUMBIA SQUARE ST 4 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
5722 255886 4 53 50 Columbia Square St 7 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
6188 111792 4 53 55X SHERMAN ST 9 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
20034 255882 4 53 50 Columbia Square St 3 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
24565 10586 7 53 1050X Harrison St 4 Sidewalk: Curb side : Cutout Tree 5     75 3X3   6011036.2882597 2110765.2479161 37.7763811461579 -122.405321269139 (37.7763811461579, -122.405321269139) 14 2 9 28853 34
26375 111795 4 53 55X SHERMAN ST 12 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
29445 26153 7 53 1500 Oakdale Ave 24 Sidewalk: Curb side : Cutout Tree 5     12 3X3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
32372 111797 4 53 55X SHERMAN ST 14 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
47426 693 7 53 1299X Potrero Ave 7 Sidewalk: Curb side : Cutout Tree 5     24 3x3   6010664.7611959 2101498.8811325 37.7509170198962 -122.405953567035 (37.7509170198962, -122.405953567035) 10 4 8 28859 19
52462 116125 4 53 2500X Keith St 1 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
55561 99240 4 53 560X Ellis St 1 Sidewalk: Curb side : Cutout Tree 5     10 4x4   6008281 2113828 37.7846362978531 -122.415069452341 (37.7846362978531, -122.415069452341) 7 10 9 28858 36
55646 111811 4 53 50X COLUMBIA SQUARE ST 8 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
64331 5481 7 53 700X Dolores St 1 Sidewalk: Curb side : Cutout Tree 5     80 6   6004966.5668947 2104283.6095193 37.7582428963987 -122.425856676166 (37.7582428963987, -122.425856676166) 2 4 5 28862 3
69451 99244 4 53 570 Ellis St 2 Sidewalk: Curb side : Cutout Tree 5     11 4x4   6008204 2113818 37.784604512923 -122.41533513918 (37.784604512923, -122.41533513918) 7 10 9 28858 36
83526 694 7 53 1299X Potrero Ave 8 Sidewalk: Curb side : Cutout Tree 5     24 3x3   6010664.7611959 2101498.8811325 37.7509170198962 -122.405953567035 (37.7509170198962, -122.405953567035) 10 4 8 28859 19
89965 116128 4 53 2500X Keith St 4 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
98424 94303 6 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
105308 111809 4 53 50X COLUMBIA SQUARE ST 6 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
110239 94295 6 53 1150X Fillmore St 2 Sidewalk: Property side : Cutout Tree 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
112427 111796 4 53 55X SHERMAN ST 13 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
113146 111793 1 53 55X Sherman St 10 Sidewalk: Curb side : Cutout Tree 5     6 3x3   6010868.84129 2110834.34163 37.7765614981606 -122.405905386452 (37.7765614981606, -122.405905386452) 14 2 9 28853 34
118707 94293 6 53 1150X Fillmore St 1 Sidewalk: Property side : Cutout Tree 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
119106 111799 4 53 55X SHERMAN ST 16 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
121069 17729 7 53 1300X Pierce St 10 Sidewalk: Curb side : Cutout Tree 5     60 3X3   6002290.56024 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321) 15 5 11 29490 41
126595 111798 4 53 55X SHERMAN ST 15 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
126620 13077 7 53 645X Lombard St 7 Sidewalk: Curb side : Cutout Tree 5     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
134382 111810 4 53 50X COLUMBIA SQUARE ST 7 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
134469 17726 7 53 1300X Pierce St 7 Sidewalk: Curb side : Cutout Tree 5     50 3X3   6002290.56024 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321) 15 5 11 29490 41
152554 111794 4 53 55X SHERMAN ST 11 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
154035 99243 4 53 570 Ellis St 1 Sidewalk: Curb side : Cutout Tree 5     9 4x4   6008204 2113818 37.784604512923 -122.41533513918 (37.784604512923, -122.41533513918) 7 10 9 28858 36
163561 101313 4 53 4244X 19th St 6 Sidewalk: Curb side : Cutout Tree 5     14 5x6   6001912 2104709 37.7592378221466 -122.436451128899 (37.7592378221466, -122.436451128899) 2 4 5 28862 3
163580 116126 4 53 2500X Keith St 2 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
167113 111806 4 53 50X COLUMBIA SQUARE ST 3 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
174144 116127 4 53 2500X Keith St 3 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
182181 111804 4 53 50X COLUMBIA SQUARE ST 1 Sidewalk: Curb side : Cutout Tree 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
186352 255883 4 53 50 Columbia Square St 4 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
189496 255885 4 53 50 Columbia Square St 6 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
84337 9917 7 53 1905X Gough St 1 Sidewalk: Curb side : Cutout Tree 5     30 3x3 Permit Number 768908 6005198.9827241 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562) 13 9 1 28858 27