sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1928 252837 7 114 98 Prosper St 5 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1929 252833 7 114 98 Prosper St 1 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1948 252834 7 114 98 Prosper St 2 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1955 252835 7 114 98 Prosper St 3 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
3552 253469 7 114 701 Stanyan St 5 17 1 1           5997178.0 2108423.0 37.7691653834469 -122.45309160151399 (37.7691653834469, -122.453091601514)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
18793 114373 7 62 805 GONZALEZ DR 1 7 1 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
19656 101900 7 3 1100 Ocean Ave 1 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
22826 251117 7 212 2024 Castro St 1 13 1 1           6002622.0 2099601.0 37.7452527853239 -122.43363054854099 (37.7452527853239, -122.433630548541)
74398 97290 7 3 55 Hiliritas Ave   7 1 1         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981)
76012 97025 7 88 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
76017 106971 7 3 3479X San Bruno Ave 1 7 1 1     30     6011510.60551 2091910.0343099998 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294)
77987 100070 7 17 331 Serrano Dr 1 7 1 1         Permit Number 777990 5990400.0 2090718.0 37.7201612636948 -122.47524333880699 (37.7201612636948, -122.475243338807)
78101 96597 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
78509 102745 7 47 222 Moncada Way 1 7 1 1           5992354.0 2093377.4 37.727576385896604 -122.468682482409 (37.7275763858966, -122.468682482409)
78510 114817 7 3 100 RACCOON DR 1 16 1 1           5998725.0 2104028.0 37.757186355085004 -122.447424250084 (37.757186355085, -122.447424250084)
78805 97021 7 180 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
78854 101901 7 2 1100 Ocean Ave 2 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
79011 108637 7 3 15 TUCKER AVE   13 1 1           6011049.2 2088423.2 37.715035447895396 -122.403704200211 (37.7150354478954, -122.403704200211)
79404 97051 7 180 795 Wisconsin St   9 1 1 1 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.39877559017401 (37.7574425906128, -122.398775590174)
79535 96590 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
79751 105231 7 105 460X ROOSEVELT WAY 1 7 1 1     9     6000051.0 2106345.0 37.7636239504047 -122.44300483360901 (37.7636239504047, -122.443004833609)
80457 104540 7 19 1101 Van Ness Ave 4 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
80595 102251 7 458 125X Powhattan Ave 4 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
80672 98502 7 17 244 Glenview Dr   13 2 1           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376)
80849 97052 7 291 795 Wisconsin St   9 1 1 1 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.39877559017401 (37.7574425906128, -122.398775590174)
81073 101977 7 129 601 Grand View Ave   7 1 1           6000076.2 2101609.9 37.750623962991796 -122.44257767940901 (37.7506239629918, -122.442577679409)
81165 97014 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81341 97022 7 195 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
81598 94690 7 329 749 Congo St   7 1 1   10/28/2010 12:00:00 AM     Permit Number 53820 6000274.0 2096023.0 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367)
81703 96593 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
82720 98465 7 17 190 Portola Dr   13 2 1           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302)
82732 102470 7 3 1021 Kirkham St 2 13 1 1           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129)
82893 97042 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
84088 103516 7 47 980 Green St 1 13 1 1           6008298.0 2118971.0 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445)
84515 104544 7 19 1101 Van Ness Ave 8 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
85013 97015 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
85657 96591 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
86057 94469 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
86843 109377 7 86 111 BAY ST 4 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
87429 108624 7 19 101 GENEBERN WAY 1 7 1 1           6005050.2 2095237.8 37.733409902631 -122.42492386614401 (37.733409902631, -122.424923866144)
87538 97027 7 1 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
87654 99961 7 28 537 Valley St 1 7 1 1   07/25/2012 12:00:00 AM     Permit Number 768880 6002459.0 2099152.0 37.7440106863694 -122.434162082356 (37.7440106863694, -122.434162082356)
88802 97029 7 232 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
88934 107130 7 65 751 DOLORES ST 1 8 1 1           6005081.8 2103948.4 37.7573290011944 -122.42543429450701 (37.7573290011944, -122.425434294507)
88993 121199 7 47 72 Fountain St 1 13 1 1           6000322.0 2101283.0 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556)
89166 102275 7 17 267 Topaz Way   13 2 1           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857)
90103 100046 7 17 562 28th St   7 1 1   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262.0 2099459.0 37.7448424535299 -122.43486521318898 (37.7448424535299, -122.434865213189)
90230 98140 7 47 315 San Marcos Ave   7 1 1           5992920.8 2100212.1 37.746375486546704 -122.467219803339 (37.7463754865467, -122.467219803339)
90248 97040 7 14 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
91108 97177 7 17 257 Roosevelt Way   13 1 1         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.765819014897296 -122.44030407045099 (37.7658190148973, -122.440304070451)
92938 99277 7 17 85X 10th St 3 7 1 1   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517.0 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722)
92954 97034 7 54 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94698 104538 7 19 1101 Van Ness Ave 1 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
94734 98893 7 17 216 Glenview Dr   13 2 1           5998910.0 2100761.0 37.7482265448319 -122.44654941060699 (37.7482265448319, -122.446549410607)
94845 97016 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
96460 109375 7 86 111 BAY ST 2 13 1 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
97037 97024 7 52 1455 Alabama St   1 1 1   08/16/2011 12:00:00 AM     Permit Number 768189 6009349.0 2100759.5 37.748813167460106 -122.410451409671 (37.7488131674601, -122.410451409671)
97416 96594 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
97530 99275 7 17 85X 10th St 1 7 1 1   04/25/2012 12:00:00 AM     Permit Number 768878 6007907.6 2110517.0 37.7755240963356 -122.416126724722 (37.7755240963356, -122.416126724722)
97796 104543 7 19 1101 Van Ness Ave 7 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
98291 98892 7 17 220 Glenview Dr   13 2 1           5998935.0 2100753.0 37.7482060067302 -122.44646238623999 (37.7482060067302, -122.44646238624)
98516 104542 7 19 1101 Van Ness Ave 6 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
98644 106968 7 54 351 26th Ave   13 1 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
98786 100139 7 17 155 05th St 2 7 1 1         Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923)
99354 102249 7 41 125X Powhattan Ave 2 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
99642 113379 7 250 140 CASTENADA AVE 1 7 1 1     50     5994437.0 2101097.0 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848)
99802 98890 7 17 256 Glenview Dr   13 2 1           5999134.0 2100748.0 37.748203642185395 -122.44577389345 (37.7482036421854, -122.44577389345)
99914 97028 7 112 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
100275 96676 7 84 1701 21st Ave 1 1 1 1   06/22/2011 12:00:00 AM       5989644.3 2103769.9 37.7559545815884 -122.478809598698 (37.7559545815884, -122.478809598698)
101483 113482 7 3 2839 Pierce St   13 1 1           6001345.0 2118077.0 37.7959107386074 -122.43937030854799 (37.7959107386074, -122.439370308548)
101894 102250 7 41 125X Powhattan Ave 3 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
102208 110843 7 231 2037 TURK BLVD   7 1 1     15     6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
102914 112377 7 36 801 ULLOA ST 3 1 1 6     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197)
103566 94487 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
103600 98436 7 17 238 Glenview Dr   13 1 1           5999035.0 2100736.0 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035)
104476 97043 7 322 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
104754 102248 7 41 125X Powhattan Ave 1 7 1 1   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592)
104783 96999 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
105403 105236 7 47 235X STATES ST 1 13 1 1     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
105598 106227 7 103 38 Stanford Heights Ave 1 13 1 1           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874)
107232 98405 7 12 84 Richland Ave   1 1 1   02/08/2012 12:00:00 AM     Permit Number 768549 6005038.1 2096133.0 37.735867237922 -122.425029371072 (37.735867237922, -122.425029371072)
107366 101903 7 75 1100 Ocean Ave 4 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
107492 98715 7 3 26 Vernon St   13 1 1           5992459.0 2088068.0 37.713004133171 -122.46793347935301 (37.713004133171, -122.467933479353)
107550 97032 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
107936 118318 7 22 20 Norton St 1 7 1 6           6002015.686319999 2092167.12899 37.724806667280895 -122.435195459751 (37.7248066672809, -122.435195459751)
107998 97023 7 52 1443 Alabama St   1 1 1   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.748893803646105 -122.410459018192 (37.7488938036461, -122.410459018192)
108286 100045 7 181 556 28th St   7 1 1         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666)
108324 105353 7 17 1979 SAN JOSE AVE 2 7 1 1   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552)
109029 108973 7 3 3485X SAN BRUNO AVE 1 3 1 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
109200 101625 7 250 64 Levant St 1 8 1 1         Permit Number 769362 6000275.9 2106473.5 37.76398959970761 -122.442236202383 (37.7639895997076, -122.442236202383)
109233 104397 7 231 350 Collingwood St 1 7 1 1           6002086.0 2103822.0 37.756812219827296 -122.43578589078301 (37.7568122198273, -122.435785890783)
110024 96606 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
110616 101905 7 75 1100 Ocean Ave 6 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
110958 108680 7 19 240 SANTA ANA AVE 1 13 1 1           5992606.9 2095181.7 37.73254515275271 -122.46793939448999 (37.7325451527527, -122.46793939449)
Powered by Datasette · Query took 3.147ms · Data source: data.sfgov.org