trees

Custom SQL query returning 15 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
290 72670 1 86 203 04th Ave 5 Sidewalk: Curb side : Cutout Tree 2 FUF   11     5994586.71732 2114106.61682 37.7846222306097 -122.462466948558 (37.7846222306097, -122.462466948558) 11 6 2 54 11
3404 74737 1 86 151X Palm Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5995889.08215 2113282.06845 37.7824331529909 -122.457901543211 (37.7824331529909, -122.457901543211) 11 6 1 54 31
5140 70173 1 86 246 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   10     5992471.1879 2113801.97828 37.7836637247597 -122.469763717453 (37.7836637247597, -122.469763717453) 11 6 2 54 11
6245 75019 1 86 151X Palm Ave 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   6 3x3   5995892.05475 2113163.21783 37.782106991639 -122.457882656117 (37.782106991639, -122.457882656117) 11 6 1 54 31
41820 68457 1 86 119 14th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/04/1993 12:00:00 AM 12   Permit Number 32319 5991463.79981 2114626.05304 37.7858681269791 -122.473308986123 (37.7858681269791, -122.473308986123) 11 6 2 54 26
44958 136637 1 86 91 Mayfair Dr 2 Sidewalk: Property side : Yard Tree 2     10 Width 3ft   5997659.79036 2114483.77284 37.7858342881777 -122.451862419331 (37.7858342881777, -122.451862419331) 15 6 1 54 31
85219 136636 1 86 91 Mayfair Dr 1 Sidewalk: Property side : Yard Tree 2     10 Width 3ft   5997648.25188 2114482.46822 37.7858300451643 -122.451902244894 (37.7858300451643, -122.451902244894) 15 6 1 54 31
94393 68663 1 86 142 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/02/1993 12:00:00 AM 10   Permit Number 32570 5993373.867 2114549.20899 37.7857675498482 -122.466695151518 (37.7857675498482, -122.466695151518) 11 6 2 54 11
115107 123109 1 86 534 11th Ave 1 Sidewalk: Property side : Yard Tree 2     10 Width 4ft   5992552.3957 2111792.37608 37.7781505989958 -122.469336449069 (37.7781505989958, -122.469336449069) 11 6 2 54 11
118052 52756 1 86 176@ GEARY Palm Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/04/2006 12:00:00 AM 7   Permit Number 48800 5995950.25747 2113100.83881 37.7819390591214 -122.457676787394 (37.7819390591214, -122.457676787394) 11 6 1 54 31
127245 123108 1 86 534 11th Ave 2 Sidewalk: Property side : Yard Tree 2     10 Width 4ft   5992553.53653 2111802.27469 37.7781778438173 -122.469333223241 (37.7781778438173, -122.469333223241) 11 6 2 54 11
129943 123960 1 86 241 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 2ft Permit Number 782043 5993663.58723 2113895.36148 37.7839889783025 -122.465645289525 (37.7839889783025, -122.465645289525) 11 6 2 54 11
161074 41928 1 86 524 04th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM 9   Permit Number 42287 5994708.51972 2111929.51477 37.7786515066402 -122.461887634901 (37.7786515066402, -122.461887634901) 11 6 2 54 11
164736 136638 1 86 98 Blake St 4 Sidewalk: Property side : Yard Tree 2     8 Width 3ft   5997852.8228 2113221.03458 37.7823781953411 -122.451103490434 (37.7823781953411, -122.451103490434) 15 6 1 54 31
169423 41927 1 86 524 04th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM 6   Permit Number 42287 5994711.05634 2111911.6847 37.7786026960614 -122.46187756658 (37.7786026960614, -122.46187756658) 11 6 2 54 11