sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
474 251300 2 36 100 Whitney Young Cir 1 13 1 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
1197 224424 2 36 2500X Diamond St 1 1 1 1     22 Width 3ft   6002246.98159 2097281.36199 37.738862314555 -122.43476145089501 (37.738862314555, -122.434761450895)
2071 252870 2 36 716 McAllister St 1 7 1 1       3x3   6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
4566 176382 2 36 2112 Bay Shore Blvd 1 1 1 1     31 Width 3ft   6011978.0 2087840.0 37.7134859388755 -122.40045291074101 (37.7134859388755, -122.400452910741)
4693 253655 2 36 1048 Ingalls St 1 7 1 1       3x3   6018024.0 2094000.0 37.7307354351655 -122.379983340658 (37.7307354351655, -122.379983340658)
6470 110846 2 36 2776 Broadway 1 1 1 1     20 3x3   6000368.55091 2117170.43785 37.793365941237894 -122.44268387196999 (37.7933659412379, -122.44268387197)
16316 107069 2 36 400X Mariposa St 1 1 1 1   10/01/2014 12:00:00 AM 3 8x8 Permit Number 773144 6015928.73625 2106322.43558 37.764454474908 -122.388086653778 (37.764454474908, -122.388086653778)
23931 140150 2 36 280 Ashbury St 1 1 1 1     25 Width 0ft   5998837.1325 2109760.3619 37.772932385832895 -122.447449052578 (37.7729323858329, -122.447449052578)
24203 137837 2 36 1800X Pine St 1 1 1 1     21 Width 0ft   6005085.0 2115443.0 37.7888905662133 -122.42624156812799 (37.7888905662133, -122.426241568128)
25332 200710 2 36 1483 McKinnon Ave 1 1 1 1     16 Width 0ft   6016005.5719 2095421.2762 37.734526418728 -122.387060517703 (37.734526418728, -122.387060517703)
25829 218789 2 36 380 Monterey Blvd 1 9 1 1     30     5999445.613919999 2094740.51345 37.7317263020196 -122.44426470386101 (37.7317263020196, -122.444264703861)
26804 250105 2 36 1688 Pine St 1 4 1 1     18 Width 4ft   6005949.70174 2115586.76552 37.7893341482864 -122.423260038317 (37.7893341482864, -122.423260038317)
28059 206279 2 36 201 Elk St 1 9 1 1     17 Width 2ft   6000804.900880001 2095895.32742 37.7349746100829 -122.439648143869 (37.7349746100829, -122.439648143869)
29793 247852 2 36 80 Bradford St 1 17 1 1     27     6009577.25002 2098193.0016099997 37.741778919360705 -122.409481010838 (37.7417789193607, -122.409481010838)
31211 224444 2 36 50 Fillmore St 1 1 1 1     12 Width 3ft   6003894.23838 2108432.6331700003 37.7695744601141 -122.42986119705 (37.7695744601141, -122.42986119705)
31502 141200 2 36 1825 ELLIS ST 1 1 1 1     16 Width 0ft   6002183.0052 2112931.3819999998 37.7818298455487 -122.436102254923 (37.7818298455487, -122.436102254923)
32141 140165 2 36 210 Ashbury St 1 1 1 1     25 Width 0ft   5998802.9582 2110001.4341 37.7735923554748 -122.447584621644 (37.7735923554748, -122.447584621644)
33431 199352 2 36 2201 20th St 1 2 1 1     13 Width 4ft   6011438.777290001 2104618.08684 37.7595249301544 -122.403496357191 (37.7595249301544, -122.403496357191)
33604 206271 2 36 1510 Monterey Blvd 1 2 1 1     14 Width 4ft   5993525.3861 2095199.14432 37.7326460476786 -122.46476525891899 (37.7326460476786, -122.464765258919)
38240 176381 2 36 2020 Bay Shore Blvd 1 1 1 1     29 Width 4ft   6012133.88275 2088039.9913700002 37.714043767182105 -122.39992815667699 (37.7140437671821, -122.399928156677)
38508 206297 2 36 565 Los Palmos Dr 1 1 1 1     13 Width 3ft   5996520.85452 2095770.92684 37.7343882701062 -122.454450538684 (37.7343882701062, -122.454450538684)
40266 246174 2 36 1602 Waller St 1 1 1 1     26 Width 0ft   5997866.0088 2108213.3997 37.768629281127296 -122.45069671469 (37.7686292811273, -122.45069671469)
41379 224035 2 36 1619 Noe St 1 1 1 1     21 Width 3ft   6003374.882069999 2098756.34444 37.7429762470666 -122.430966938682 (37.7429762470666, -122.430966938682)
41393 248493 2 36 748 Shrader St 1 1 1 1     21 Width 0ft   5997645.2464 2107858.3326 37.7676417185294 -122.451434697353 (37.7676417185294, -122.451434697353)
41887 248497 2 36 114 Beulah St 1 1 1 1     14 Width 0ft   5997504.128 2107818.662 37.7675247113964 -122.45191994324699 (37.7675247113964, -122.451919943247)
41921 206270 2 36 301 Santa Clara Ave 1 2 1 1     20 Width 10ft   5993141.97199 2095936.7158400002 37.7346491229581 -122.46614438456801 (37.7346491229581, -122.466144384568)
42087 206272 2 36 70 Santa Clara Ave 1 2 1 1     21 Width 10ft   5993269.28362 2097133.14802 37.7379415715549 -122.46579112907 (37.7379415715549, -122.46579112907)
42622 200508 2 36 5999 03rd St 1 1 1 1     21 Width 0ft   6013714.4021 2091674.1069999998 37.7241103165863 -122.394719584244 (37.7241103165863, -122.394719584244)
44352 206286 2 36 199 Elk St 1 9 1 1     21 Width 3ft   6000787.19541 2095992.57825 37.735240630441396 -122.439716327743 (37.7352406304414, -122.439716327743)
44606 206273 2 36 335 Saint Francis Blvd 1 2 1 1     20 Width 10ft   5992818.8463 2096062.89914 37.734976942936 -122.46727070178301 (37.734976942936, -122.467270701783)
45323 224434 2 36 11 Wool St 1 1 1 1     21 Width 3ft   6007430.10011 2098092.51153 37.741382453248896 -122.416898048032 (37.7413824532489, -122.416898048032)
46757 244461 2 36 402 Steiner St 1 1 1 1     23 Width 0ft   6003240.6392 2109670.6251 37.772936647465 -122.43221039578 (37.772936647465, -122.43221039578)
48142 224439 2 36 3883 23rd St 1 1 1 1     28 Width 3ft   6003903.27581 2102441.01038 37.7531234083377 -122.429402602143 (37.7531234083377, -122.429402602143)
48470 206295 2 36 1289 08th Ave 1 1 1 1     21 Width 3ft   5993598.25468 2106726.01097 37.76430008921321 -122.465350355136 (37.7643000892132, -122.465350355136)
49495 224027 2 36 1350 Noe St 1 9 1 1     24     6003197.19524 2100390.33495 37.7474527349542 -122.431697967013 (37.7474527349542, -122.431697967013)
50686 139597 2 36 1122 BRODERICK ST 1 1 1 1     23 Width 0ft   6000883.0425 2112553.4494 37.7807181991979 -122.440572393516 (37.7807181991979, -122.440572393516)
50774 199342 2 36 1801 03rd St 1 9 1 1     25 Width 4ft   6015732.89393 2106644.75831 37.7653286510121 -122.38878652777201 (37.7653286510121, -122.388786527772)
51352 206266 2 36 1217 Arguello Blvd 1 1 1 1     14 Width 2ft   5995764.33389 2107222.76394 37.76578872620429 -122.457894496039 (37.7657887262043, -122.457894496039)
52077 218791 2 36 138 Monterey Blvd 1 1 1 1     23 Width 3ft   6001157.9301 2094692.71106 37.731692590921995 -122.438341469381 (37.731692590922, -122.438341469381)
52315 120312 2 36 160 23rd Ave 1 1 1 1     21 Width 4ft   5988698.92527 2114284.33233 37.784769373123005 -122.482849516634 (37.784769373123, -122.482849516634)
52323 126606 2 36 3388 Washington St 1 1 1 1     8 Width 2ft   5998604.48648 2115920.6274200003 37.7898335742166 -122.448697575531 (37.7898335742166, -122.448697575531)
53297 206294 2 36 1291 Arguello Blvd 1 1 1 1     14 Width 5ft   5995770.00748 2106810.2745 37.7646564626472 -122.457845020728 (37.7646564626472, -122.457845020728)
55714 107425 2 36 1600X Waller St 1 1 1 1           5997832.17799 2108247.26578 37.7687203321672 -122.450816174345 (37.7687203321672, -122.450816174345)
58396 121616 2 36 1410 Rhode Island St 1 1 1 1     10 3x3   6011977.96767 2101776.5671900003 37.7517528433307 -122.40143185998699 (37.7517528433307, -122.401431859987)
59213 246051 2 36 1426 Waller St 1 1 1 1     21 Width 0ft   5998854.4429 2108351.1869 37.7690641391097 -122.44728773272101 (37.7690641391097, -122.447287732721)
60423 224005 2 36 900 San Bruno Ave 1 2 1 1     15     6011012.17375 2104008.2643 37.7578266557966 -122.40492883511999 (37.7578266557966, -122.40492883512)
60842 200145 2 36 2905 Keith St 1 1 1 1     21 Width 0ft   6013593.3967 2091246.9908 37.7229308128444 -122.395107981509 (37.7229308128444, -122.395107981509)
63071 138599 2 36 2630 Pine St 1 1 1 1     27 Width 0ft   6001313.0958 2114947.1478 37.7873151619105 -122.43925625600001 (37.7873151619105, -122.439256256)
65172 200147 2 36 2911 Keith St 1 1 1 1     25 Width 0ft   6013569.8497 2091214.9407 37.7228415002198 -122.39518713528 (37.7228415002198, -122.39518713528)
65730 206293 2 36 1283 Arguello Blvd 1 1 1 1     14 Width 5ft   5995766.93118 2106868.2316900003 37.7648154214066 -122.457859855072 (37.7648154214066, -122.457859855072)
67715 248403 2 36 1713 Waller St 1 1 1 1     20 Width 0ft   5997457.4924 2108113.6175 37.7683319124677 -122.452102532521 (37.7683319124677, -122.452102532521)
69013 224423 2 36 210 Laidley St 1 1 1 1     12 Width 3ft   6004160.549319999 2097137.95677 37.73857701091271 -122.42813500683 (37.7385770109127, -122.42813500683)
70359 139620 2 36 1895 Eddy St 1 1 1 1     30 Width 0ft   6001417.4951 2112473.8357 37.7805300194093 -122.43871776158998 (37.7805300194093, -122.43871776159)
70451 176394 2 36 148 Milton St 1 17 1 1     21     6003833.54644 2094691.18415 37.731840220943205 -122.42909121820801 (37.7318402209432, -122.429091218208)
75042 224425 2 36 74 Arbor St 1 1 1 1     9 Width 3ft   6001911.23419 2096871.3219 37.7377173723477 -122.435892976098 (37.7377173723477, -122.435892976098)
76158 200563 2 36 1440 McKinnon Ave 1 1 1 1     21 Width 0ft   6016189.8592 2095311.5667 37.7342353814874 -122.386415722542 (37.7342353814874, -122.386415722542)
78803 105667 2 36 301X DORADO TER 1 19 1 1           5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
80052 224429 2 36 55 Conrad St 1 1 1 1     15 Width 2ft   6001826.44815 2096826.2196900002 37.737588715353496 -122.436182895046 (37.7375887153535, -122.436182895046)
84641 118343 2 36 162 23rd Ave 1 1 1 1       3x3   5988772.0 2114277.0 37.784753492132104 -122.48259616764 (37.7847534921321, -122.48259616764)
87976 111318 2 36 200x PENINSULA AVE 1 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
94372 111101 2 36 101X1 SURREY ST 1 1 1 1     19 3x3   6002238.0 2096221.0 37.7359502956153 -122.434716700898 (37.7359502956153, -122.434716700898)
96285 96780 2 36 1502X Monterey Blvd 1 1 1 1     12 3x50   5993551.4 2095180.8 37.732597178480894 -122.4646739916 (37.7325971784809, -122.4646739916)
98034 106401 2 36 22 22nd Ave 1 1 1 1     15 5x6   5988976.53234 2115004.21174 37.786762106623705 -122.481941850779 (37.7867621066237, -122.481941850779)
104633 99112 2 36 80X Bradford St 1 14 1 1           6009564.7 2098208.3 37.741820222197596 -122.40952548431801 (37.7418202221976, -122.409525484318)
105675 109208 2 36 2401x CASTRO ST 1 3 1 2           6002698.0 2098487.0 37.7421983129634 -122.43328816691401 (37.7421983129634, -122.433288166914)
106969 99110 2 36 94 Bernal Heights Blvd 1 14 1 1           6009548.4 2098143.7 37.741641931317396 -122.409577286243 (37.7416419313174, -122.409577286243)
108720 120968 2 36 79x Bradford St 1 20 1 1     30 3x3   6009615.0 2098188.0 37.7417673011584 -122.409350130422 (37.7417673011584, -122.409350130422)
121637 110196 2 36 60x ASHBURY ST 1 1 1 1       3x3   5998800.0 2110445.0 37.7748101047276 -122.44762679098999 (37.7748101047276, -122.44762679099)
124008 106918 2 36 274 PUTNAM ST 1 1 1 1           6009044.8 2096077.1 37.7359392652864 -122.41117262558201 (37.7359392652864, -122.411172625582)
127278 206267 2 36 576 Dewey Blvd 1 1 1 1     16 Width 6ft   5994070.0708800005 2099419.58791 37.7442657237995 -122.46318829319901 (37.7442657237995, -122.463188293199)
129571 206277 2 36 100 Yerba Buena Ave 1 2 1 1     15 Width 6ft   5994075.53376 2096720.2997299999 37.73685446745821 -122.46297360255801 (37.7368544674582, -122.462973602558)
129818 206264 2 36 1235 Arguello Blvd 1 1 1 1     25 Width 4ft   5995769.52537 2107097.9044 37.7654461924254 -122.45786750379101 (37.7654461924254, -122.457867503791)
129895 138989 2 36 999 Hayes St 1 1 1 1     18 Width 0ft   6003118.0992 2110635.6071 37.7755793009505 -122.432703221339 (37.7755793009505, -122.432703221339)
131150 248583 2 36 832 Shrader St 1 1 1 1     15 Width 0ft   5997671.8953 2107653.4687 37.7670807404856 -122.45132774569099 (37.7670807404856, -122.451327745691)
132302 137684 2 36 733 BAKER ST 1 1 1 1     25 Width 0ft   6000491.3923 2111526.0041 37.7778747868229 -122.441853533294 (37.7778747868229, -122.441853533294)
133793 206299 2 36 231 Edna St 1 17 1 1     21     5998763.35609 2095379.2875599999 37.733441276780205 -122.446669340837 (37.7334412767802, -122.446669340837)
134942 123506 2 36 2630 Fulton St 1 1 1 1     19 Width 8ft   5995210.5755199995 2110304.28467 37.774217945514 -122.460033072871 (37.774217945514, -122.460033072871)
135072 224028 2 36 1420 Shrader St 1 1 1 1     13 Width 4ft   5997836.6848 2105808.46526 37.7620242630195 -122.450624734548 (37.7620242630195, -122.450624734548)
136355 199367 2 36 1500 Michigan St 1 4 1 1     14 Width 3ft   6016510.76764 2101132.40556 37.7502359775117 -122.385711790678 (37.7502359775117, -122.385711790678)
136677 224431 2 36 111 Surrey St 1 1 1 1     20 Width 3ft   6002252.13649 2096208.5785299998 37.7359169916712 -122.434666937538 (37.7359169916712, -122.434666937538)
136960 224446 2 36 40 Fillmore St 1 1 1 1     17 Width 3ft   6003874.09282 2108583.13838 37.7699865699439 -122.42994161713001 (37.7699865699439, -122.42994161713)
137222 206278 2 36 121 Ortega St 1 2 1 1     23 Width 2ft   5993596.441240001 2102535.31336 37.7527934164816 -122.46505223798701 (37.7527934164816, -122.465052237987)
137668 200250 2 36 917 Ingerson Ave 1 19 1 1     5 Width 0ft   6014641.601 2089467.7692 37.7181036570096 -122.391360208379 (37.7181036570096, -122.391360208379)
142623 101243 2 36 1299X 08th Ave 1 1 1 1       3x3   5993606.4 2106666.6 37.7641374320151 -122.465317867129 (37.7641374320151, -122.465317867129)
144172 117163 2 36 832 SHRADER ST 1 1 1 1       3x3   5997697.0 2107652.0 37.767078145258004 -122.45124080685899 (37.767078145258, -122.451240806859)
148887 199373 2 36 200 Jennings St 1 4 1 1     13 Width 3ft   6018659.73844 2097012.77983 37.739042989241 -122.37799451303002 (37.739042989241, -122.37799451303)
149297 248615 2 36 446 Frederick St 1 1 1 1     21 Width 0ft   5997626.0167 2107489.4868 37.7666278609206 -122.451474603078 (37.7666278609206, -122.451474603078)
150366 246155 2 36 1644 Waller St 1 1 1 1     17 Width 0ft   5997687.6425 2108190.0819 37.768555044956 -122.45131198438801 (37.768555044956, -122.451311984388)
150414 199358 2 36 1144 Rhode Island St 1 4 1 1     11 Width 3ft   6011907.7918 2103052.2048299997 37.755251549640704 -122.401764195454 (37.7552515496407, -122.401764195454)
150829 224029 2 36 56 Alma St 1 1 1 1     21 Width 4ft   5998311.99153 2106260.3659 37.7632922630546 -122.44901339496799 (37.7632922630546, -122.449013394968)
151958 246078 2 36 646 Clayton St 1 1 1 1     23 Width 0ft   5998541.3176 2108402.6679 37.7691875956286 -122.44837451744 (37.7691875956286, -122.44837451744)
152422 199345 2 36 473 Pennsylvania Ave 1 1 1 1     24 Width 3ft   6014395.760480001 2104935.64517 37.7605615984582 -122.39329178588699 (37.7605615984582, -122.393291785887)
152670 200711 2 36 1485 McKinnon Ave 1 1 1 1     22 Width 0ft   6016014.8171 2095413.88 37.734506622191 -122.387028037996 (37.734506622191, -122.387028037996)
152750 206265 2 36 1223 Arguello Blvd 1 1 1 1     24 Width 4ft   5995764.11125 2107172.86823 37.765651712687394 -122.45789165508002 (37.7656517126874, -122.45789165508)
152830 199362 2 36 936 Wisconsin St 1 4 1 1     13 Width 4ft   6012742.61969 2103151.37524 37.7555704024715 -122.39888405366699 (37.7555704024715, -122.398884053667)
154600 224031 2 36 822 Clayton St 1 9 1 1     30 Width 4ft   5998688.13035 2107403.24761 37.766451833222604 -122.447794742535 (37.7664518332226, -122.447794742535)
155601 248526 2 36 75 Beulah St 1 1 1 1     13 Width 0ft   5997669.6241 2107795.1927 37.7674697483814 -122.451345824031 (37.7674697483814, -122.451345824031)
157239 224025 2 36 1193 Church St 1 1 1 1     19 Width 5ft   6004485.645169999 2101988.85608 37.7519148526121 -122.427356445766 (37.7519148526121, -122.427356445766)
157373 246154 2 36 1730 Waller St 1 1 1 1     20 Width 0ft   5997434.1745 2108152.8339 37.768438254928704 -122.45218601649401 (37.7684382549287, -122.452186016494)
158262 176380 2 36 229 Hester Ave 1 7 1 1     38     6012521.81555 2087619.26728 37.7129101627473 -122.398557799413 (37.7129101627473, -122.398557799413)
161708 206289 2 36 155 Monterey Blvd 1 1 1 1     23 Width 3ft   6001037.098230001 2094617.6771900002 37.7314796917331 -122.438753833738 (37.7314796917331, -122.438753833738)
Powered by Datasette · Query took 85.564ms · Data source: data.sfgov.org