trees

Custom SQL query returning 47 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
182689 108589 6 17 1139x HUDSON AVE 1 Sidewalk: Curb side : Yard Tree 2           6017760 2094672 37.7325660477977 -122.380942739781 (37.7325660477977, -122.380942739781) 10 3 8 58 1
46153 209002 6 17 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree 2   07/17/2018 12:00:00 AM 3 Width 4ft Permit Number 781950 5994125 2096751 37.7369416119865 -122.462804803775 (37.7369416119865, -122.462804803775) 9 8 4 59 40
21096 253953 6 41 11X Ravenwood Dr 2 Sidewalk: Curb side : Yard Tree 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
110540 253952 6 41 11X Ravenwood Dr 1 Sidewalk: Curb side : Yard Tree 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
38129 114239 6 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
13120 258703 6 17 131X Juan Bautista Cir 2 Sidewalk: Curb side : Yard Tree 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
15674 258702 6 17 131X Juan Bautista Cir 1 Sidewalk: Curb side : Yard Tree 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
5712 258876 6 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
137836 208971 6 17 150 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree 2   12/18/2018 12:00:00 AM 3 Width 6ft Permit Number 782070 5994318.90627 2096521.25566 37.7363219572757 -122.462117732164 (37.7363219572757, -122.462117732164) 9 8 4 59 40
162406 255994 6 19 179 Retiro Way 1 Sidewalk: Curb side : Yard Tree 2       3x3   6001908 2121813 37.8062008335618 -122.437689923584 (37.8062008335618, -122.437689923584) 13 9 1 57 17
91742 114074 6 253 18x HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree 2     5     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
161250 114073 6 253 18x HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree 2     6     5988029 2090212 37.7186342037977 -122.483401916227 (37.7186342037977, -122.483401916227) 1 8 4 64 14
16781 260951 6 15 190 Jackson St 1 Sidewalk: Curb side : Yard Tree 2       3x3   6013038 2118237 37.7970085486816 -122.398921272101 (37.7970085486816, -122.398921272101) 3 1 10 28860 6
145907 187657 6 70 2072 15th Ave 1 Sidewalk: Curb side : Yard Tree 2       3x3   5991666 2101424 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446) 1 8 4 29491 12
62334 87240 6 17 233 Arbor St 2 Sidewalk: Curb side : Yard Tree 2   02/14/2008 12:00:00 AM     Permit Number 50269 6001330 2096776 37.7374226054152 -122.437895752709 (37.7374226054152, -122.437895752709) 2 7 5 63 7
92381 116164 6 113 2411 OCTAVIA ST 1 Sidewalk: Curb side : Yard Tree 2     13 15x4   6004495 2117637 37.7948813682629 -122.428439330772 (37.7948813682629, -122.428439330772) 13 9 1 28858 27
106956 251495 6 17 2448 Clay St 1 Sidewalk: Curb side : Yard Tree 2   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026 2116224 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488) 13 9 1 29490 27
90315 112398 6 62 246 CRESCENT AVE 1 Sidewalk: Curb side : Yard Tree 2           6006552 2095759 37.7349257177289 -122.419768681192 (37.7349257177289, -122.419768681192) 2 7 7 28859 2
97189 114476 6 170 299x UNION ST 1 Sidewalk: Curb side : Yard Tree 2   12/29/2015 12:00:00 AM       6011527 2119680 37.8008863659875 -122.40425133897 (37.8008863659875, -122.40425133897) 3 1 10 308 23
119122 251575 6 15 300 Sussex St 1 Sidewalk: Curb side : Yard Tree 2   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194 2096647 37.7370606668352 -122.438356728037 (37.7370606668352, -122.438356728037) 2 7 5 63 7
104567 254405 6 57 321 Lexington St 2 Sidewalk: Curb side : Yard Tree 2       Width 3ft   6006540.69106 2104208.04068 37.7581242333638 -122.420407294379 (37.7581242333638, -122.420407294379) 2 4 7 28859 19
134725 187654 6 41 375 Woodside Ave 1 Sidewalk: Curb side : Yard Tree 2       3x3   5997267 2099886 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039) 1 5 4 59 38
891 207770 6 56 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree 2     35 Width 10ft   5993240.61068 2097284.1687 37.7383545825079 -122.465901234858 (37.7383545825079, -122.465901234858) 1 8 4 59 40
23985 114387 6 7 417x ARBALLO DR 1 Sidewalk: Curb side : Yard Tree 2     7     5988152 2090574 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928) 1 8 4 64 14
141906 114383 6 83 418X SERRANO DR 1 Sidewalk: Curb side : Yard Tree 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
41877 114072 6 19 454 ARBALLO DR 1 Sidewalk: Curb side : Yard Tree 2     4     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
193743 211099 6 17 501 Saint Francis Blvd 2 Sidewalk: Curb side : Yard Tree 2   05/18/2018 12:00:00 AM 3 10x10 Permit Number 781418 5993137.63738 2096084.35497 37.7350542531473 -122.466170096172 (37.7350542531473, -122.466170096172) 1 8 4 59 40
104794 115276 6 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
1875 261661 6 70 741 30th Ave 1 Sidewalk: Curb side : Yard Tree 2 FUF         5986614 2110873 37.7752812973329 -122.489811603249 (37.7752812973329, -122.489811603249) 11 6 2 55 26
51737 116458 6 260 777 Brotherhood Way 1 Sidewalk: Curb side : Yard Tree 2     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327) 1 8 4 64 14
63542 116459 6 260 777 Brotherhood Way 2 Sidewalk: Curb side : Yard Tree 2     20 10x20 Permit Number 777772 5989848.42836 2088633.83291 37.7144066723949 -122.476997704287 (37.7144066723949, -122.476997704287) 1 8 4 64 14
62177 99097 6 70 99X Santa Monica Way 1 Sidewalk: Curb side : Yard Tree 2           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094) 9 8 4 59 40
19388 114226 6 150 99x FONT BLVD 2 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
21577 114229 6 150 99x FONT BLVD 5 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
27121 114234 6 150 99x FONT BLVD 10 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
30455 114232 6 150 99x FONT BLVD 8 Sidewalk: Curb side : Yard Tree 2     15     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44052 114240 6 28 99x FONT BLVD 16 Sidewalk: Curb side : Yard Tree 2           5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
44804 114228 6 150 99x FONT BLVD 4 Sidewalk: Curb side : Yard Tree 2     7     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
62078 114235 6 150 99x FONT BLVD 11 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
109646 114230 6 150 99x FONT BLVD 6 Sidewalk: Curb side : Yard Tree 2     30     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
126287 114225 6 28 99x FONT BLVD 1 Sidewalk: Curb side : Yard Tree 2     48     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
128045 114227 6 150 99x FONT BLVD 3 Sidewalk: Curb side : Yard Tree 2     16     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
141272 114231 6 150 99x FONT BLVD 7 Sidewalk: Curb side : Yard Tree 2     10     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
154745 114237 6 150 99x FONT BLVD 13 Sidewalk: Curb side : Yard Tree 2     14     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
173544 114236 6 150 99x FONT BLVD 12 Sidewalk: Curb side : Yard Tree 2     22     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
179418 114233 6 150 99x FONT BLVD 9 Sidewalk: Curb side : Yard Tree 2     20     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
185977 114238 6 150 99x FONT BLVD 14 Sidewalk: Curb side : Yard Tree 2     13     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14