trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
32511 117226 1 97 1009 HARRISON ST 12 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
40283 30534 7 97 1020 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.77681277294 -122.404779881684 (37.77681277294, -122.404779881684) 14 2 9 28853 34
45618 30532 7 97 1020 Harrison St 4 Sidewalk: Curb side : Cutout Tree 2   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.77681277294 -122.404779881684 (37.77681277294, -122.404779881684) 14 2 9 28853 34
60674 30533 7 97 1020 Harrison St 2 Sidewalk: Curb side : Cutout Tree 2   01/25/1995 12:00:00 AM     Permit Number 34535 6011195.92412392 2110919.1949505 37.77681277294 -122.404779881684 (37.77681277294, -122.404779881684) 14 2 9 28853 34
67963 117227 1 97 1009 HARRISON ST 13 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
74931 64702 7 97 110 Cyril Magnin St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25683 6010200.02442425 2113768.63085544 37.7845809377612 -122.408426051637 (37.7845809377612, -122.408426051637) 14 10 10 28852 36
86094 117224 1 97 1009 HARRISON ST 10 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
88021 115029 1 97 1009 HARRISON ST 5 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
98731 64717 7 97 35 Powell St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25671 6010371.58706878 2113906.86566108 37.7849701038252 -122.407842251054 (37.7849701038252, -122.407842251054) 14 10 10 28852 36
111103 64725 7 97 174 Ellis St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25680 6010012.44318345 2114072.97215331 37.7854060800363 -122.409096504402 (37.7854060800363, -122.409096504402) 14 10 9 28852 36
117473 115032 1 97 1009 HARRISON ST 8 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
122705 115031 1 97 1009 HARRISON ST 7 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
132591 115030 1 97 1009 HARRISON ST 6 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
135027 115025 1 97 1009 HARRISON ST 1 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
143436 115026 1 97 1009 HARRISON ST 2 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
144563 64727 7 97 166 Eddy St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25682 6009623.89289745 2113671.39889681 37.7842816815144 -122.410412412425 (37.7842816815144, -122.410412412425) 14 10 9 28852 36
145158 117225 1 97 1009 HARRISON ST 11 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
171805 115033 1 97 1009 HARRISON ST 9 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
178512 115027 1 97 1009 HARRISON ST 3 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
186261 64726 7 97 127 Ellis St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/14/1988 12:00:00 AM     Permit Number 25681 6010217.12887008 2114048.91615067 37.7853514923776 -122.40838665256 (37.7853514923776, -122.40838665256) 14 10 10 28852 36
193914 115028 1 97 1009 HARRISON ST 4 Sidewalk: Curb side : Cutout Tree 1       3x10   6011058 2110680 37.7761482889947 -122.405240157274 (37.7761482889947, -122.405240157274) 14 2 9 28853 34
30353 105684 8 97 635 08TH ST 1 Front Yard : Pot Tree 2     10     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
187823 199429 1 97 1340 18th St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6013567.84766 2105719.02996 37.7626665705253 -122.396210084142 (37.7626665705253, -122.396210084142) 14 3 8 28856 29
33799 112160 1 97 1328 18th St 2 Sidewalk: Curb side : Cutout Tree 2     18 3x3   6013587.23518 2105720.84823 37.7626726418425 -122.396143156607 (37.7626726418425, -122.396143156607) 14 3 8 28856 29
145638 105686 8 97 635 08TH ST 3 Front Yard : Pot Tree 2     6     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
33251 105685 8 97 635 08TH ST 2 Front Yard : Pot Tree 2     8     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34