sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
123296 177517 2 22 654 Peru Ave 5 17 1 1     3     6005174.05368 2092521.73439 37.7259591826438 -122.424302559431 (37.7259591826438, -122.424302559431)
131384 248174 2 22 218 Esmeralda Ave 3 17 1 1     18     6007322.63795 2098720.65313 37.7431011449024 -122.41731411847401 (37.7431011449024, -122.417314118474)
79581 117011 2 22 457X CASTRO ST 1 16 1 6 3   27 3x6   6002348.0 2105584.0 37.7616651256499 -122.435005811888 (37.7616651256499, -122.435005811888)
89465 114506 2 22 10 LOMBARD ST 1 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
125405 114508 2 22 10 LOMBARD ST 3 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
27928 231945 2 22 33 Penny Ln 4 13 1 1     2 Width 2ft   6002666.1416 2096136.6991599998 37.7357431221521 -122.433230424364 (37.7357431221521, -122.433230424364)
43309 231938 2 22 1 Penny Ln 1 13 1 1     4 Width 2ft   6002328.37989 2096518.1207400002 37.7367712513805 -122.43442545876499 (37.7367712513805, -122.434425458765)
47848 209611 2 22 77 Ralston St 1 13 1 1     13     5992168.85342 2088365.8404 37.7138051716457 -122.468957974754 (37.7138051716457, -122.468957974754)
62808 231942 2 22 31 Penny Ln 5 13 1 1     5 Width 2ft   6002659.32372 2096145.42523 37.735766695166504 -122.433254619725 (37.7357666951665, -122.433254619725)
132003 231941 2 22 31 Penny Ln 3 13 1 1     4 Width 2ft   6002655.75902 2096147.9144099997 37.7357733276597 -122.43326712208 (37.7357733276597, -122.43326712208)
149582 231939 2 22 1 Penny Ln 2 13 1 1     5 Width 2ft   6002331.25514 2096517.0119 37.7367683699712 -122.434415438526 (37.7367683699712, -122.434415438526)
155248 231944 2 22 33 Penny Ln 3 13 1 1     9 Width 2ft   6002664.28784 2096138.10096 37.7357468660117 -122.43323693366001 (37.7357468660117, -122.43323693366)
155846 231943 2 22 33 Penny Ln 2 13 1 1     1 Width 2ft   6002661.77062 2096140.53935 37.7357534184718 -122.43324581083901 (37.7357534184718, -122.433245810839)
184761 231940 2 22 31 Penny Ln 1 13 1 1     5 Width 2ft   6002651.97591 2096151.4784799998 37.735782899162395 -122.433280456348 (37.7357828991624, -122.433280456348)
43528 209215 3 22 99x Castenada Ave 25 11 1 2     15 Width 5ft   5993821.14503 2100240.07202 37.746504222711295 -122.46410856948 (37.7465042227113, -122.46410856948)
44102 209213 3 22 99x San Marcos Ave 23 11 1 2     2 Width 5ft   5993777.82606 2100247.64237 37.7465225122089 -122.46425891004101 (37.7465225122089, -122.464258910041)
53156 209769 3 22 100x Pacheco St 2 11 1 2     2 Width 3ft   5994792.885 2099741.94773 37.745192456276705 -122.460712331024 (37.7451924562767, -122.460712331024)
60137 209212 3 22 99x San Marcos Ave 22 11 1 2     2 Width 5ft   5993771.94389 2100232.96399 37.746481870051106 -122.4642781843 (37.7464818700511, -122.4642781843)
75541 209208 3 22 99x San Marcos Ave 18 11 1 2     3 Width 5ft   5993802.83706 2100253.03783 37.7465387683529 -122.46417281704399 (37.7465387683529, -122.464172817044)
106244 459 3 22 760x 23rd Ave 23 11 1 2     12     5988830.89675 2110023.4193700003 37.773077776353 -122.48208068722602 (37.773077776353, -122.482080687226)
123719 209209 3 22 99x San Marcos Ave 19 11 1 2     3 Width 5ft   5993795.21392 2100243.94669 37.746513367011 -122.464198516942 (37.746513367011, -122.464198516942)
134453 209214 3 22 99x Castenada Ave 24 11 1 2     8 Width 5ft   5993812.322269999 2100226.93547 37.746467644571 -122.464138123878 (37.746467644571, -122.464138123878)
134537 209762 3 22 1200x Plymouth Ave 2 11 1 2     7 Width 3ft   5995809.026930001 2092599.65126 37.72563986216979 -122.456682272862 (37.7256398621698, -122.456682272862)
134757 209210 3 22 99x San Marcos Ave 20 11 1 2     1 Width 5ft   5993788.41941 2100238.90873 37.746499142429705 -122.464221645739 (37.7464991424297, -122.464221645739)
152005 209768 3 22 100x Pacheco St 1 11 1 2     2 Width 3ft   5994733.37028 2099685.92288 37.7450352017206 -122.460914061546 (37.7450352017206, -122.460914061546)
157795 209207 3 22 99x San Marcos Ave 17 11 1 2     3 Width 5ft   5993815.86849 2100254.24474 37.7465428332992 -122.46412784372801 (37.7465428332992, -122.464127843728)
161466 193529 3 22 2x Garlington Ct 5 11 1 2     6 Width 6ft   6016723.20154 2094502.11588 37.732042299514106 -122.38451540818001 (37.7320422995141, -122.38451540818)
178018 209211 3 22 99x San Marcos Ave 21 11 1 2     2 Width 5ft   5993782.2667 2100229.04683 37.7464717095186 -122.46424220511601 (37.7464717095186, -122.464242205116)
4327 103839 3 22 1552 Polk St 1 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006685.2576 2116316.1212 37.791378262309706 -122.420766896 (37.7913782623097, -122.420766896)
25173 140670 2 22 40 COLE ST 1 10 1 1     2 Width 0ft   5997774.3514 2110415.6204 37.7746707659902 -122.451172585534 (37.7746707659902, -122.451172585534)
33890 231844 2 22 96 Museum Way 1 10 1 1     11 Width 3ft   6000872.22935 2106652.07973 37.764513903924104 -122.44018648793501 (37.7645139039241, -122.440186487935)
39973 131171 2 22 1028 Chestnut St 1 10 1 1     7 Width 4ft   6006900.3516 2120517.59651 37.802926579956704 -122.420321008927 (37.8029265799567, -122.420321008927)
46561 131183 2 22 504 Commercial St 2 10 1 1     6 Width 5ft   6012392.07307 2117339.05892 37.7945070037376 -122.401093222084 (37.7945070037376, -122.401093222084)
51159 231682 2 22 141 Elsie St 1 10 1 1     9 Width 5ft   6007132.37905 2098439.10695 37.7423173758515 -122.417952030056 (37.7423173758515, -122.417952030056)
59455 131090 2 22 1651 North Point St 1 10 1 1     13 Width 4ft   6002849.6651 2120943.5541 37.8038670612875 -122.434368934585 (37.8038670612875, -122.434368934585)
59844 250237 2 22 523 Commercial St 1 10 1 1     7 Width 0ft   6012474.90226 2117332.79898 37.7944944357317 -122.400806180977 (37.7944944357317, -122.400806180977)
62892 131172 2 22 1028 Chestnut St 2 10 1 1     4 Width 4ft   6006879.14909 2120515.3465299997 37.8029192073136 -122.42039422091999 (37.8029192073136, -122.42039422092)
72701 131185 2 22 504 Commercial St 4 10 1 1     4 Width 5ft   6012367.16594 2117335.57564 37.7944960499984 -122.401179159505 (37.7944960499984, -122.401179159505)
73011 244935 2 22 290 Page St 2 10 1 1     4 Width 0ft   6005183.8966 2109935.4965 37.7737739081682 -122.42550728374701 (37.7737739081682, -122.425507283747)
73537 250236 2 22 520 Commercial St 7 10 1 1     6 Width 0ft   6012472.9903 2117349.79933 37.794541008002895 -122.400813991574 (37.7945410080029, -122.400813991574)
75268 231771 2 22 2123 Castro St 1 10 1 1     2 Width 8ft   6002709.35623 2099334.27137 37.744525367058394 -122.43330942979901 (37.7445253670584, -122.433309429799)
75798 209607 2 22 488 Arch St 2 10 1 1     7 Width 6ft   5992758.831730001 2090447.2277099998 37.719554228122504 -122.46707004236099 (37.7195542281225, -122.467070042361)
75844 250239 2 22 523 Commercial St 3 10 1 1     6 Width 0ft   6012493.23475 2117334.36425 37.7944997561019 -122.400742857909 (37.7944997561019, -122.400742857909)
131519 131182 2 22 504 Commercial St 1 10 1 1     7 Width 5ft   6012408.13843 2117341.1258 37.7945135750949 -122.401037778889 (37.7945135750949, -122.401037778889)
136763 231925 2 22 125 Moffitt St 1 10 1 1     3 Width 3ft   6002717.16903 2096703.03689 37.737301050095205 -122.433094454065 (37.7373010500952, -122.433094454065)
137641 250240 2 22 523 Commercial St 4 10 1 1     8 Width 0ft   6012509.92284 2117337.5567099997 37.794509452601105 -122.40068533906201 (37.7945094526011, -122.400685339062)
150348 131178 2 22 505 Commercial St 2 10 1 1     5 Width 5ft   6012368.62422 2117315.33506 37.7944405555417 -122.401172690686 (37.7944405555417, -122.401172690686)
155461 131181 2 22 505 Commercial St 5 10 1 1     6 Width 5ft   6012409.58027 2117320.08736 37.7944558889799 -122.401031310972 (37.7944558889799, -122.401031310972)
155709 131184 2 22 504 Commercial St 3 10 1 1     5 Width 5ft   6012380.30044 2117337.96833 37.794503352491 -122.40113388043301 (37.794503352491, -122.401133880433)
156877 250238 2 22 523 Commercial St 2 10 1 1     6 Width 0ft   6012482.15733 2117334.58927 37.7944997561041 -122.400781203214 (37.7944997561041, -122.400781203214)
156945 250242 2 22 523 Commercial St 6 10 1 1     4 Width 0ft   6012536.17343 2117342.3206700003 37.7945239973486 -122.400594842992 (37.7945239973486, -122.400594842992)
158973 131177 2 22 505 Commercial St 1 10 1 1     7 Width 5ft   6012356.862380001 2117314.77617 37.794438364791205 -122.401213349039 (37.7944383647912, -122.401213349039)
159208 131180 2 22 505 Commercial St 4 10 1 1     4 Width 5ft   6012394.326669999 2117318.5359 37.794450778130205 -122.401083981553 (37.7944507781302, -122.401083981553)
159643 250241 2 22 523 Commercial St 5 10 1 1     5 Width 0ft   6012522.17079 2117340.39818 37.7945179377025 -122.400643159068 (37.7945179377025, -122.400643159068)
161819 209556 2 22 992 Waithman Way 1 10 1 1     7 Width 4ft   5996028.8528 2098497.23395 37.741845813638 -122.456348606399 (37.741845813638, -122.456348606399)
165068 250233 2 22 520 Commercial St 4 10 1 1     8 Width 0ft   6012521.31946 2117354.65914 37.794557047424796 -122.400647107095 (37.7945570474248, -122.400647107095)
169217 250232 2 22 520 Commercial St 3 10 1 1     9 Width 0ft   6012525.89293 2117355.21508 37.794558828975 -122.400631321282 (37.794558828975, -122.400631321282)
169447 231770 2 22 2127 Castro St 1 10 1 1     2 Width 8ft   6002711.64432 2099292.5474900003 37.7444109328282 -122.433298537219 (37.7444109328282, -122.433298537219)
169486 231937 2 22 289 Randall St 1 10 1 1     8 Width 3ft   6003768.435219999 2097853.76766 37.740520270493796 -122.429541784839 (37.7405202704938, -122.429541784839)
169948 182141 2 22 1414 25th Ave 1 10 1 1     2 Width 0ft   5988378.9203 2105649.8128 37.761042756843 -122.48332344606001 (37.761042756843, -122.48332344606)
170813 231934 2 22 125 Randall St 1 10 1 1     11 Width 3ft   6004720.88088 2097540.11743 37.739712940109705 -122.42622627133801 (37.7397129401097, -122.426226271338)
175764 250230 2 22 520 Commercial St 1 10 1 1     12 Width 0ft   6012537.64619 2117356.2743599997 37.7945623929982 -122.400590727701 (37.7945623929982, -122.400590727701)
175818 182134 2 22 1434 25th Ave 3 10 1 1     13 Width 0ft   5988383.0453 2105547.1446 37.7607610979396 -122.483301653477 (37.7607610979396, -122.483301653477)
180902 250231 2 22 520 Commercial St 2 10 1 1     13 Width 0ft   6012532.440909999 2117356.70467 37.7945632842246 -122.400608768988 (37.7945632842246, -122.400608768988)
184358 131179 2 22 505 Commercial St 3 10 1 1     6 Width 5ft   6012381.19757 2117316.40905 37.7944442058913 -122.40112926060101 (37.7944442058913, -122.401129260601)
186459 250234 2 22 520 Commercial St 5 10 1 1     8 Width 0ft   6012500.45193 2117354.10926 37.79455437373571 -122.400719273201 (37.7945543737357, -122.400719273201)
188464 250235 2 22 520 Commercial St 6 10 1 1     11 Width 0ft   6012481.472999999 2117350.27619 37.7945427904834 -122.40078467369601 (37.7945427904834, -122.400784673696)
5061 253757 2 22 330 Twin Peaks Blvd 1 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5072 253758 2 22 330 Twin Peaks Blvd 2 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5078 253759 2 22 330 Twin Peaks Blvd 3 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
23410 184354 2 22 1251 Sunset Blvd 1 9 1 1     8 Width 0ft   5984645.6432 2106661.7256 37.7636032084053 -122.496309703367 (37.7636032084053, -122.496309703367)
23510 209272 2 22 843 Detroit St 8 9 1 1     2 Width 5ft   5999418.82606 2095617.22879 37.7341320280635 -122.444420298265 (37.7341320280635, -122.444420298265)
23984 209244 2 22 775 Ulloa St 1 9 1 1     10 Width 3ft   5993691.11569 2098103.1453400003 37.740629265622104 -122.46440306685801 (37.7406292656221, -122.464403066858)
24117 231843 2 22 481 Duboce Ave 1 9 1 1     8 Width 3ft   6003596.22484 2108318.99367 37.769245552863495 -122.430883903372 (37.7692455528635, -122.430883903372)
24474 193517 2 22 1600 Bay Shore Blvd 9 9 1 1     11 Width 6ft   6011952.06769 2091431.9694299998 37.7233473149134 -122.400794740685 (37.7233473149134, -122.400794740685)
24511 231737 2 22 1301 Douglass St 7 9 1 1     9 Width 4ft   6001392.41312 2099896.6008200003 37.745994591279796 -122.437903413209 (37.7459945912798, -122.437903413209)
24797 120177 2 22 130 26th Ave 1 9 1 1     14 Width 2ft   5987747.51554 2115102.62556 37.786960769727294 -122.486201131854 (37.7869607697273, -122.486201131854)
25520 185142 2 22 2513 33rd Ave 3 9 1 1     7 Width 0ft   5986108.0169 2098114.3936 37.7402201189445 -122.49062297943001 (37.7402201189445, -122.49062297943)
26834 209313 2 22 1826 17th Ave 1 9 1 1     3 Width 6ft   5990960.58685 2102941.94344 37.7537575742797 -122.474197079625 (37.7537575742797, -122.474197079625)
27030 185143 2 22 2515 33rd Ave 4 9 1 1     8 Width 0ft   5986108.0169 2098100.5968 37.7401822366116 -122.490621964597 (37.7401822366116, -122.490621964597)
27903 231769 2 22 4189 26th St 1 9 1 1     22 Width 4ft   6002709.32864 2100612.54197 37.7480351970786 -122.43340085217399 (37.7480351970786, -122.433400852174)
28001 231739 2 22 1125 Douglass St 1 9 1 1     8 Width 6ft   6001361.831259999 2100439.6299099997 37.7474838811735 -122.438048052091 (37.7474838811735, -122.438048052091)
31133 193520 2 22 1600 Bay Shore Blvd 14 9 1 1     9 Width 6ft   6011963.497280001 2091396.5487400002 37.7232506944377 -122.40075274327101 (37.7232506944377, -122.400752743271)
31939 209228 2 22 56 Evelyn Way 1 9 1 1     6 Width 3ft   5998514.63023 2098457.8445099997 37.74188004722 -122.44775080166201 (37.74188004722, -122.447750801662)
33187 131119 2 22 2628 Broderick St 1 9 1 1     7 Width 4ft   6000183.00251 2117622.17381 37.7945957101685 -122.443358342831 (37.7945957101685, -122.443358342831)
37895 131120 2 22 2628 Broderick St 2 9 1 1     7 Width 4ft   6000180.43791 2117639.7288599997 37.794643765458495 -122.443368478199 (37.7946437654585, -122.443368478199)
38380 209308 2 22 1639 17th Ave 2 9 1 1     8 Width 6ft   5990857.84677 2104245.01196 37.757329504260895 -122.47464747089799 (37.7573295042609, -122.474647470898)
38792 209609 2 22 562 Bright St 1 9 1 1     12     5993802.84348 2090885.4872 37.7208177899974 -122.463493089652 (37.7208177899974, -122.463493089652)
40745 209268 2 22 32 Melrose Ave 1 9 1 1     11     5999881.425980001 2095527.25505 37.733911365001795 -122.442814491289 (37.7339113650018, -122.442814491289)
43105 123507 2 22 2630 Fulton St 2 9 1 1     15     5995207.28646 2110317.68378 37.7742545467647 -122.460045421131 (37.7742545467647, -122.460045421131)
43459 209229 2 22 33 Vista Verde Ct 1 9 1 1     12 Width 3ft   5999182.21514 2096030.8365200001 37.735254194030205 -122.445268061295 (37.7352541940302, -122.445268061295)
44434 131140 2 22 2600 Webster St 5 9 1 1     10 Width 4ft   6003103.94403 2117640.65389 37.7948125861925 -122.433252839042 (37.7948125861925, -122.433252839042)
44561 209311 2 22 1832 17th Ave 2 9 1 1     5 Width 6ft   5990964.740730001 2102918.21669 37.7536926674944 -122.474180983568 (37.7536926674944, -122.474180983568)
45839 131081 2 22 5 Emerson St 1 9 1 1     6 Width 1ft   5998643.89609 2113680.41304 37.783684787975105 -122.44839982888901 (37.7836847879751, -122.448399828889)
46948 231738 2 22 1301 Douglass St 10 9 1 1     6 Width 4ft   6001390.706780001 2099947.28717 37.7461336669543 -122.43791294333799 (37.7461336669543, -122.437912943338)
48168 209368 2 22 951 Noriega St 2 9 1 1     5 Width 5ft   5991004.55512 2103118.24834 37.7542442082052 -122.474057891556 (37.7542442082052, -122.474057891556)
48975 209610 2 22 562 Bright St 2 9 1 1     12     5993801.59682 2090894.0331 37.720841183149 -122.463498018815 (37.720841183149, -122.463498018815)
51597 209223 2 22 130 Brentwood Ave 1 9 1 1     2 Width 3ft   5995706.7736599995 2095617.4090900002 37.7339200254769 -122.457253962012 (37.7339200254769, -122.457253962012)
52096 131138 2 22 2600 Webster St 3 9 1 1     6 Width 4ft   6003109.50461 2117608.6290700003 37.7947249697315 -122.433231309294 (37.7947249697315, -122.433231309294)
52928 209595 2 22 162 Staples Ave 1 9 1 1     11     5999000.613059999 2093809.32995 37.7291440921224 -122.44573621416001 (37.7291440921224, -122.44573621416)
Powered by Datasette · Query took 36.213ms · Data source: data.sfgov.org