trees

Custom SQL query returning 17 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
2297 16623 1 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
18931 16634 1 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
22540 225094 1 5 621 Waller St 1 Sidewalk: Curb side : Cutout Tree 2   11/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780775 6002723.2165 2108842.98565 37.7706348030957 -122.433941050651 (37.7706348030957, -122.433941050651) 15 5 5 29492 9
47329 16647 1 5 178 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   09/04/2015 12:00:00 AM 14 4x4   6002850.60519 2107244.6681 37.7662534427777 -122.433386179722 (37.7662534427777, -122.433386179722) 15 5 5 28862 3
48301 225091 1 5 169 Lower Ter 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6000007.70524 2106202.33536 37.7632297601708 -122.443144329371 (37.7632297601708, -122.443144329371) 15 5 5 28862 3
54510 225090 1 5 188 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6002851.63466 2107200.77986 37.7661329947706 -122.433379482476 (37.7661329947706, -122.433379482476) 15 5 5 28862 3
62764 16626 1 5 138 Noe St 1 Sidewalk: Curb side : Cutout Tree 1   02/02/2001 12:00:00 AM 21 3X3   6002836.08721 2107485.6498 37.7669142960875 -122.43345361721 (37.7669142960875, -122.43345361721) 15 5 5 28862 3
66656 16644 1 5 170 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 4X4   6002849.24717 2107272.65524 37.7663302115978 -122.433392876987 (37.7663302115978, -122.433392876987) 15 5 5 28862 3
74388 16650 7 5 190 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6002855.60879 2107200.17785 37.7661315672606 -122.433365693732 (37.7661315672606, -122.433365693732) 15 5 5 28862 3
108284 225093 1 5 635 Waller St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6002682.06353 2108837.51126 37.770617436283 -122.434083007749 (37.770617436283, -122.434083007749) 15 5 5 29492 9
113085 58721 7 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree 2   03/16/1981 12:00:00 AM     Permit Number 19065 6002629.53182761 2108749.25499909 37.7703721248343 -122.434258404788 (37.7703721248343, -122.434258404788) 15 5 5 29492 9
124058 225092 1 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6002638.75231 2108633.09345 37.7700536971488 -122.434218205527 (37.7700536971488, -122.434218205527) 15 5 5 29492 9
134226 16641 7 5 161 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6002897.9493228 2107328.6416625 37.7664866995789 -122.433228426337 (37.7664866995789, -122.433228426337) 15 5 5 28862 3
134432 32473 1 5 144 Lower Ter 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/10/1996 12:00:00 AM 9   Permit Number 36981 6000263.91054 2106227.11632 37.7633124078752 -122.442259981907 (37.7633124078752, -122.442259981907) 15 5 5 28862 3
146708 116858 1 5 180 NOE ST 1 Sidewalk: Curb side : Cutout Tree 1     14 3x3   6002788 2107242 37.7662425648461 -122.433602528192 (37.7662425648461, -122.433602528192) 15 5 5 28862 3
172953 34010 7 5 123 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   04/28/1997 12:00:00 AM     Permit Number 37945 6002886.66979468 2107551.69377695 37.7670985064042 -122.433283380019 (37.7670985064042, -122.433283380019) 15 5 5 28862 3
177221 61796 7 5 60 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/25/1985 12:00:00 AM     Permit Number 21819 6002883.06164476 2108748.24537279 37.7703837393735 -122.433381373664 (37.7703837393735, -122.433381373664) 15 5 5 29492 9