trees

Custom SQL query returning 25 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
985 262391 9 100 2646 38th Ave 1 Back Yard : Yard Tree 2       Width 0ft   5984657 2097167 37.7375339667511 -122.495570077384 (37.7375339667511, -122.495570077384) 1 8 3 29491 35
3361 261454 9 18 2 Geneva Ave 9 Sidewalk: Curb side : Cutout Tree 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
4850 262150 9 6 1295 47th Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
5653 215048 9 9 1719 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/03/2020 12:00:00 AM 3 3x3 Permit Number 782897 5990885.18116 2103671.34742 37.7557559568771 -122.474511074324 (37.7557559568771, -122.474511074324) 1 8 4 56 12
6683 262152 9 6 1295 47th Ave 3 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
8142 262151 9 6 1295 47th Ave 2 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
8479 204048 9 18 2 Geneva Ave 6 Sidewalk: Curb side : Cutout Tree 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
8858 261455 9 18 2 Geneva Ave 10 Sidewalk: Curb side : Cutout Tree 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
10378 163649 9 13 226 Sagamore St 1 Sidewalk: Curb side : Cutout Tree 2 DPW 07/01/2020 12:00:00 AM 3 3x4 Permit Number 784460 5994737.04022 2087470.63166 37.71149518743 -122.460016622663 (37.71149518743, -122.460016622663) 9 8 6 28861 24
11157 261456 9 18 2 Geneva Ave 11 Sidewalk: Curb side : Cutout Tree 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
12761 261857 9 32 176 Ramsell St 1 Sidewalk: Curb side : Cutout Tree 2   03/16/2020 12:00:00 AM 3     5992988.80812 2088380.73889 37.7138934199028 -122.466125014283 (37.7138934199028, -122.466125014283) 9 8 6 64 24
15121 261452 9 18 2 Geneva Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
15415 261457 9 18 2 Geneva Ave 12 Sidewalk: Curb side : Cutout Tree 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
16566 261453 9 18 2 Geneva Ave 8 Sidewalk: Curb side : Cutout Tree 2 FUF 02/13/2020 12:00:00 AM 3 3x4 Permit Number 782541 5997165 2091482 37.7226488176407 -122.451914211983 (37.7226488176407, -122.451914211983) 9 8 6 28861 24
18909 262153 9 6 1295 47th Ave 4 Sidewalk: Curb side : Cutout Tree 2   05/11/2020 12:00:00 AM 3 3x3   5981486.26206 2106277.60943 37.7623629555319 -122.50720831894 (37.7623629555319, -122.50720831894) 1 8 3 56 35
74288 105439 9 17 790 LAKEVIEW AVE 1 Front Yard : Yard Tree 2           5994224.8 2089960.8 37.7183031233486 -122.461967505828 (37.7183031233486, -122.461967505828) 9 8 6 28861 24
85850 114258 9 15 70x CHUMASERO DR 1 Front Yard : Yard Tree 2     40     5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
100633 104881 9 212 101 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2         missing? 5990474.7 2090014.4 37.7182336817112 -122.474933796522 (37.7182336817112, -122.474933796522) 1 8 4 64 14
112528 104689 9 15 657 PALMETTO AVE 1 Back Yard : Yard Tree 2     30     5991786 2087190.1 37.7105547448876 -122.470195680575 (37.7105547448876, -122.470195680575) 9 8 4 64 24
119017 105441 9 56 425 WAWONA ST   unknown : Yard Tree 2           5991587.6 2097036.5 37.7375790508831 -122.471598439568 (37.7375790508831, -122.471598439568) 1 8 4 29491 40
119423 114977 9 36 183 Lee Ave 1 Sidewalk: Curb side : Cutout Tree 2   12/28/2015 12:00:00 AM     Permit Number 774982 5996484.3 2091092.2 37.7215395068839 -122.454239087603 (37.7215395068839, -122.454239087603) 9 8 6 28861 24
150142 114761 9 15 2155 10TH AVE 1 Back Yard : Yard Tree 2       10x10   5993160 2101036 37.7486515109126 -122.466452556212 (37.7486515109126, -122.466452556212) 1 8 4 29491 40
160381 256862 9 200 133 Majestic Ave 1 Back Yard : Yard Tree 2           5997017.00624 2089223.65081 37.7164394409514 -122.452262915882 (37.7164394409514, -122.452262915882) 9 8 6 28861 24
160937 102060 9 41 115 Kensington Way 1 Back Yard : Yard Tree 2           5994908.3 2098325.8 37.7413107073974 -122.460210667073 (37.7413107073974, -122.460210667073) 1 8 4 59 40
167961 104436 9 28 2 SAN FERNANDO WAY 1 Front Yard : Yard Tree 2     13     5992040 2096369 37.7357724272627 -122.469985704629 (37.7357724272627, -122.469985704629) 1 8 4 59 40