trees

Custom SQL query returning 16 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6108 75012 1 229 618X Missouri St 7 Sidewalk: Curb side : Cutout Tree 2 FUF   2     6013537.74567 2104188.90633 37.7584635107089 -122.396206952689 (37.7584635107089, -122.396206952689) 10 3 8 28856 29
57925 190908 1 229 1 01st St 32 : Yard Tree 2     1     6014392.80706 2105893.3505 37.7631910848138 -122.393369022367 (37.7631910848138, -122.393369022367) 14 3 8 28856 29
58071 206429 1 229 681 Joost Ave 3 Sidewalk: Property side : Yard Tree 2     1     5997546.57174 2094969.2613 37.7322458610553 -122.450846532568 (37.7322458610553, -122.450846532568) 9 7 4 59 40
182126 222977 1 229 150 Coso Ave 1 Sidewalk: Curb side : Yard Tree 2     2     6007376.65063 2099645.40217 37.7456433376618 -122.417192870974 (37.7456433376618, -122.417192870974) 2 7 7 28859 2
2411 110745 5 229 2300x Mariposa St 5 Sidewalk: Curb side : Cutout Tree 2   05/05/2015 12:00:00 AM 3 3x3   6010533.01376 2106015.32988 37.7633108106613 -122.406727421634 (37.7633108106613, -122.406727421634) 8 4 8 28859 19
31701 222976 1 229 1250 San Jose Ave 4 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   6003899.91915 2095844.78016 37.7350114921682 -122.428943969481 (37.7350114921682, -122.428943969481) 2 7 5 28861 7
37332 222975 1 229 1250 San Jose Ave 3 Sidewalk: Curb side : Cutout Tree 2     3 Width 2ft   6003909.72513 2095852.11349 37.7350321828746 -122.428910589378 (37.7350321828746, -122.428910589378) 2 7 5 28861 7
87881 222971 1 229 621 Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 2ft   6008732.36174 2096944.66893 37.7383038940073 -122.41231415408 (37.7383038940073, -122.41231415408) 10 7 7 28859 2
14096 206430 1 229 20 Mendosa Ave 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   5993491.73911 2101167.40276 37.749031446253 -122.465314958712 (37.749031446253, -122.465314958712) 1 8 4 29491 40
50799 222974 1 229 45 Aztec St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6007582.8393 2099584.38119 37.7454873853315 -122.416475577999 (37.7454873853315, -122.416475577999) 2 7 7 28859 2
145940 190909 1 229 1301 19th St 2 : Tree 2     4 Width 3ft   6013727.00615 2105213.48323 37.7612873045897 -122.395624185733 (37.7612873045897, -122.395624185733) 10 3 8 28856 29
21268 222973 1 229 271 Bemis St 3 Sidewalk: Property side : Yard Tree 2     1 Width 4ft   6002983.66177 2096230.12236 37.736017648289 -122.43213930391 (37.736017648289, -122.43213930391) 2 7 5 63 7
104350 126355 1 229 2826 Broderick St 3 Sidewalk: Property side : Yard Tree 2     2 Width 4ft   6000087.33004 2118307.97161 37.7964732733833 -122.443738673322 (37.7964732733833, -122.443738673322) 13 9 1 57 17
114956 222972 1 229 500x 27th St 27 Median : Cutout Tree 1     5 Width 4ft   6002994.97901 2100071.17381 37.7465649287282 -122.432374425345 (37.7465649287282, -122.432374425345) 2 7 5 63 22
58165 206428 1 229 999 Chenery St 1 Sidewalk: Property side : Yard Tree 2     4 Width 5ft   6000994.53554 2096137.98097 37.7356516718869 -122.439009895915 (37.7356516718869, -122.439009895915) 2 7 5 63 7
88428 190907 1 229 901 24th St 1 Sidewalk: Curb side : Pot Tree 2     2 Width 5ft   6015410.61611 2102532.4645 37.754019306672 -122.389613987713 (37.754019306672, -122.389613987713) 10 3 8 28856 29