trees

Custom SQL query returning 29 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
121864 87402 12 7 1300 Webster St 7 Median : Cutout Tree 1   04/21/2008 12:00:00 AM 3 3x3   6003725.160049 2113179.069411 37.7825974263114 -122.430784800607 (37.7825974263114, -122.430784800607) 15 9 11 29490 41
15423 85309 12 9 1250 Haight St 1 Sidewalk: Curb side : Cutout Tree 1 Private 07/26/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.7706407896873 -122.442827504693 (37.7706407896873, -122.442827504693) 15 5 11 29492 9
188548 85310 12 9 1250 Haight St 2 Sidewalk: Curb side : Cutout Tree 1 Private 07/27/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.7706407896873 -122.442827504693 (37.7706407896873, -122.442827504693) 15 5 11 29492 9
63001 85312 12 11 1366 Turk St 2 Sidewalk: Curb side : Cutout Tree 1     9 3x3   6003535.85294 2112477.60862 37.7806606630436 -122.431389631549 (37.7806606630436, -122.431389631549) 15 9 11 29490 41
127776 87423 12 11 45X Jones St 2 Sidewalk: Curb side : Cutout Tree 1   04/22/2008 12:00:00 AM 3 3x3   6009092.517834 2112687.614007 37.7815506408215 -122.412181237011 (37.7815506408215, -122.412181237011) 7 10 9 28852 36
161715 85436 12 11 1397X Buchanan St 7 Sidewalk: Curb side : Cutout Tree 1 Private 08/17/2007 12:00:00 AM 3 3x3 Maintenance agreement ends 8/17/2010 6004184.830731 2113056.513958 37.782286952179 -122.429185796304 (37.782286952179, -122.429185796304) 7 9 11 29490 41
176108 87410 12 11 898X Ellis St 1 Sidewalk: Curb side : Cutout Tree 1   04/22/2008 12:00:00 AM 3 3x3   6006570.640875 2113589.260791 37.7838845156579 -122.420969775985 (37.7838845156579, -122.420969775985) 7 9 9 28858 36
27555 173771 12 17 231 Stratford Dr 1 Sidewalk: Property side : Yard Tree 2   02/13/2017 12:00:00 AM 3 3x3 Permit Number 779366 5990884.97189 2090977.23451 37.7209011553391 -122.473585870316 (37.7209011553391, -122.473585870316) 9 8 4 64 40
153890 173885 12 17 410 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/03/2017 12:00:00 AM 3 3x3 Permit Number 774920 5998687.3529 2094401.81487 37.7307530256695 -122.446861792344 (37.7307530256695, -122.446861792344) 9 7 4 59 40
165385 87425 12 17 25X Jones St   Sidewalk: Curb side : Cutout Tree 1   04/22/2008 12:00:00 AM 3 3x3   6009102.081359 2112621.960117 37.781370907497 -122.412143510234 (37.781370907497, -122.412143510234) 7 10 9 28852 36
5639 85379 12 40 3390 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree 1     3 3x3   6007302.06128 2100623.11206 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933) 2 4 7 28859 19
29752 85380 12 40 3390 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree 1     3 3x3   6007302.06128 2100623.11206 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933) 2 4 7 28859 19
90185 85377 12 40 3390 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree 1     3 3x3   6007302.06128 2100623.11206 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933) 2 4 7 28859 19
14210 85214 12 50 2889 24th St 1 Sidewalk: Curb side : Cutout Tree 1 Private 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.7526413233918 -122.409722943913 (37.7526413233918, -122.409722943913) 2 4 7 28859 19
83738 85306 12 57 1661 Pine St 10 Sidewalk: Curb side : Cutout Tree 1     6 3x3   6005989.138522 2115548.501173 37.7892313094718 -122.423120870526 (37.7892313094718, -122.423120870526) 13 9 1 28858 41
6750 85484 12 62 2448 Hyde St 2 Sidewalk: Curb side : Cutout Tree 1     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276) 5 1 1 28858 32
75194 85483 12 62 2448 Hyde St 1 Sidewalk: Curb side : Cutout Tree 1     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276) 5 1 1 28858 32
55314 87432 12 75 598X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree 1   04/22/2008 12:00:00 AM 3 3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
85799 87431 12 75 522X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree 1   04/22/2008 12:00:00 AM 3 3x3   6006584.964111 2094794.1521 37.7322783147803 -122.419586279513 (37.7322783147803, -122.419586279513) 2 7 7 28861 2
129540 87430 12 75 522X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree 1   04/22/2008 12:00:00 AM 3 3x3   6006584.964111 2094794.1521 37.7322783147803 -122.419586279513 (37.7322783147803, -122.419586279513) 2 7 7 28861 2
152280 87429 12 75 500X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree 1   04/22/2008 12:00:00 AM 3 3x3   6006724.46969 2094782.06277 37.7322529772765 -122.419103118684 (37.7322529772765, -122.419103118684) 2 7 7 28861 2
49154 87400 12 83 400X Monterey Blvd 10 Median : Cutout Tree 1   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815) 9 7 4 59 40
88049 87399 12 83 400X Monterey Blvd 9 Median : Cutout Tree 1   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815) 9 7 4 59 40
168120 87401 12 83 400X Monterey Blvd 11 Median : Cutout Tree 1   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815) 9 7 4 59 40
39770 122604 12 84 132 Surrey St 3 Sidewalk: Curb side : Cutout Tree 2   11/21/2016 12:00:00 AM 3 3x3 Permit Number 779127 6002205.30607 2096205.31937 37.7359053840536 -122.434828615692 (37.7359053840536, -122.434828615692) 2 7 5 63 7
175182 122603 12 84 132 Surrey St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 779127 6002205.30607 2096205.31937 37.7359053840536 -122.434828615692 (37.7359053840536, -122.434828615692) 2 7 5 63 7
163157 85249 12 123 1335 Fulton St 1 Sidewalk: Curb side : Cutout Tree 1 Private 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.12437 2111060.02557 37.7766442216524 -122.438849483935 (37.7766442216524, -122.438849483935) 15 5 11 29492 10
190505 85250 12 123 1335 Fulton St 2 Sidewalk: Curb side : Cutout Tree 1 Private 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.12437 2111060.02557 37.7766442216524 -122.438849483935 (37.7766442216524, -122.438849483935) 15 5 11 29492 10
57641 87858 12 131     Sidewalk: Curb side : Cutout Tree 2       3x3   6000340.49747 2104887.90927 37.7596396402708 -122.441898968169 (37.7596396402708, -122.441898968169) 2 4 5 28862 3