sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
88550 97441 1 78 1900@Gough Pacific Ave 1 5 1 1           6004943.9 2117474.7 37.794461125583794 -122.42687450783701 (37.7944611255838, -122.426874507837)
131835 138640 2 78 1646 LYON ST 2 1 1 1     13 Width 0ft   5999620.9791 2114590.0361 37.7862381910735 -122.445084920177 (37.7862381910735, -122.445084920177)
42011 138639 2 78 1646 LYON ST 1 1 1 1     9 Width 0ft   5999626.2324 2114571.6495 37.786188006097 -122.44506542288099 (37.786188006097, -122.445065422881)
9710 173649 2 78 2645 Lake St   1 1 1       3x3   5987243.0 2114574.0 37.7854798983764 -122.48790776340401 (37.7854798983764, -122.487907763404)
147091 122175 2 78 200 14th Ave 3 2 1 1     14 Width 3ft   5991544.95469 2113582.84567 37.7830084672106 -122.47295211599199 (37.7830084672106, -122.472952115992)
39034 122174 2 78 200 14th Ave 2 2 1 1     9 Width 4ft   5991544.6782 2113562.95943 37.782953849079 -122.472951621926 (37.782953849079, -122.472951621926)
155446 122173 2 78 200 14th Ave 1 2 1 1     8 Width 3ft   5991547.68728 2113548.29768 37.7829137661673 -122.472940142363 (37.7829137661673, -122.472940142363)
67081 120747 2 78 290 20th Ave 2 1 1 1     11 Width 4ft   5989660.66014 2113437.65192 37.7825005368819 -122.47946030153999 (37.7825005368819, -122.47946030154)
129898 123267 2 78 460 07th Ave 4 1 1 1     21 Width 5ft   5993762.56243 2112432.8054400003 37.779978903871296 -122.46519660622101 (37.7799789038713, -122.465196606221)
148693 123268 2 78 460 07th Ave 3 1 1 1     23 Width 5ft   5993762.02866 2112399.44022 37.779887261198795 -122.4651960286 (37.7798872611988, -122.4651960286)
13348 67250 1 78 566 40th Ave 1 1 1 1   02/28/2017 12:00:00 AM 3 3x3 Permit Number 779635 5983509.16426 2111956.3824 37.778074175435 -122.500631896763 (37.778074175435, -122.500631896763)
99596 89525 3 78 4900X Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5983384.65726 2111746.53595 37.7774906880837 -122.501047080127 (37.7774906880837, -122.501047080127)
143599 89529 3 78 5000X Anza St 3 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5983095.8091 2111736.71305 37.7774467524363 -122.50204555844 (37.7774467524363, -122.50204555844)
71193 89530 3 78 5014 Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5983074.33103 2111736.1703 37.7774440004005 -122.502119816782 (37.7774440004005, -122.502119816782)
116740 90919 3 78 5048 Anza St 2 1 1 2   11/10/2008 12:00:00 AM 5 3x3   5982934.22783 2111732.57013 37.7774258833955 -122.502604205438 (37.7774258833955, -122.502604205438)
72978 117659 2 78 5048 Anza St 1 1 1 1     3 Width 3ft   5982955.71016 2111732.11037 37.777425883386705 -122.502529858177 (37.7774258833867, -122.502529858177)
90227 89532 3 78 5130 Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5982703.43603 2111723.1091299998 37.777386341369706 -122.50340187617701 (37.7773863413697, -122.503401876177)
128775 89533 3 78 5140 Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5982684.3370199995 2111722.3179200003 37.7773830461441 -122.503467886196 (37.7773830461441, -122.503467886196)
97937 89571 3 78 4901X Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983370.6621900005 2111693.23015 37.777343504090396 -122.5010915494 (37.7773435040904, -122.5010915494)
99525 89538 3 78 5226 Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5982399.00612 2111713.8845599997 37.777343112143996 -122.50445429746 (37.777343112144, -122.50445429746)
89706 89572 3 78 4901X Anza St 2 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983389.31662 2111692.03112 37.777341307260706 -122.50102693 (37.7773413072607, -122.50102693)
161598 117655 2 78 4945 Anza St 2 1 1 1     5 Width 3ft   5983271.78514 2111690.7442400004 37.7773308720147 -122.501433407785 (37.7773308720147, -122.501433407785)
81150 89541 3 78 5300X Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5982202.45771 2111704.784 37.777306562133106 -122.505133536108 (37.7773065621331, -122.505133536108)
98051 89543 3 78 5300X Anza St 3 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5982144.573969999 2111703.4056700002 37.7772993717145 -122.50533366907801 (37.7772993717145, -122.505333669078)
140935 89566 3 78 5001X Anza St 2 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983110.49799 2111681.5935 37.7772962731377 -122.501990666002 (37.7772962731377, -122.501990666002)
108955 89544 3 78 5324 Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5982113.874969999 2111702.53608 37.777295177582204 -122.505439800548 (37.7772951775822, -122.505439800548)
112797 89565 3 78 5001X Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983089.7802099995 2111680.23644 37.777291329944 -122.50206223387899 (37.777291329944, -122.502062233879)
84065 89564 3 78 5021 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983068.09266 2111680.5005900003 37.7772907811029 -122.502137276438 (37.7772907811029, -122.502137276438)
96395 89563 3 78 5027 Anza St 2 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5983042.76149 2111679.44242 37.7772863874375 -122.502224825366 (37.7772863874375, -122.502224825366)
97710 89546 3 78 5450 Anza St 1 1 1 2   03/26/2008 12:00:00 AM 3 3x3   5981705.459980001 2111690.26917 37.777237453835895 -122.506851705119 (37.7772374538359, -122.506851705119)
92891 89547 3 78 5500 Anza St 3 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5981512.1941599995 2111683.29996 37.777206935443 -122.507519744478 (37.777206935443, -122.507519744478)
96472 89558 3 78 5239 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5982363.16543 2111656.98924 37.77718478612329 -122.504574063555 (37.7771847861233, -122.504574063555)
126333 89557 3 78 5239 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5982344.66025 2111655.7855 37.777180392486 -122.504637988559 (37.777180392486, -122.504637988559)
111693 89553 3 78 5301X Anza St 2 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5982158.297809999 2111648.1776099997 37.7771485392206 -122.50528210040001 (37.7771485392206, -122.5052821004)
127746 89551 3 78 5333 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5982065.67399 2111646.96238 37.7771397519236 -122.505602419867 (37.7771397519236, -122.505602419867)
103204 89548 3 78 5601 Anza St 1 1 1 2   03/27/2008 12:00:00 AM 3 3x3   5981205.071959999 2111615.6071 37.77700297412879 -122.50857713252199 (37.7770029741288, -122.508577132522)
142508 91011 3 78 4622 Cabrillo St 1 1 1 2   11/24/2008 12:00:00 AM 3 3x3   5981221.20719 2110309.11198 37.773416674213706 -122.508424309329 (37.7734166742137, -122.508424309329)
145358 90749 3 78 4327 Cabrillo St 1 1 1 2   04/14/2008 12:00:00 AM 3 3x3   5982140.9261 2110286.22946 37.773408005745296 -122.50524122882601 (37.7734080057453, -122.505241228826)
46884 119232 2 78 4333 Cabrillo St 1 1 1 1     3 Width 3ft   5982116.59434 2110285.8700900003 37.773405587282 -122.505325367756 (37.773405587282, -122.505325367756)
110367 99185 3 78 4345 Cabrillo St 2 1 1 2   12/25/2008 12:00:00 AM 3 3x3   5982067.9022699995 2110283.83078 37.7733971225951 -122.505493646453 (37.7733971225951, -122.505493646453)
110382 90732 3 78 4533 Cabrillo St 1 1 1 2   04/14/2008 12:00:00 AM 3 3x3   5981514.87502 2110263.98035 37.7733100587697 -122.507405139203 (37.7733100587697, -122.507405139203)
45802 240331 2 78 60 Sharon St 1 1 1 1     1 Width 3ft   6003844.61217 2106805.37047 37.7651035803891 -122.42991676164499 (37.7651035803891, -122.429916761645)
136839 240332 2 78 60 Sharon St 2 1 1 1     1 Width 3ft   6003844.27978 2106789.2546 37.765059311271294 -122.429916761647 (37.7650593112713, -122.429916761647)
357 181338 2 78 1220 28th Ave 2 1 1 1     5 Width 0ft   5987427.0 2106942.0 37.7645353017913 -122.486710570648 (37.7645353017913, -122.486710570648)
84236 87561 3 78 1426 48th Ave 1 1 1 2   08/23/2011 12:00:00 AM 3 3x3   5981248.5719800005 2105353.680971 37.759812110915206 -122.50796181336901 (37.7598121109152, -122.507961813369)
9751 173659 3 78 200 Lawton St 1 11 1 10           5993693.06683 2104628.21116 37.7585455452803 -122.46487007071998 (37.7585455452803, -122.46487007072)
55323 214007 3 78 100x Lawton St 1 11 1 2     4 Width 3ft   5993739.83569 2104610.7544299997 37.7585003100564 -122.464707056595 (37.7585003100564, -122.464707056595)
35082 214006 3 78 200x Lawton St 1 11 1 2     4 Width 3ft   5993658.67007 2104606.16817 37.7584830376791 -122.464987428342 (37.7584830376791, -122.464987428342)
167482 197210 2 78 1700 22nd St 10 7 1 1     14     6012879.70369 2103800.3418400004 37.7573599607159 -122.398455506044 (37.7573599607159, -122.398455506044)
184621 186023 2 78 1900 Sunset Blvd 18 9 1 1     8 Width 0ft   5985031.2475 2101908.1707 37.7505738451375 -122.49462557465901 (37.7505738451375, -122.494625574659)
4952 3661 1 78 100X Cargo Way 97 1 1 9   05/02/2017 12:21:00 PM 3 3X3   6017220.32274 2098859.87245 37.7440353039781 -122.38309992831199 (37.7440353039781, -122.383099928312)
5077 3660 1 78 100X Cargo Way 96 1 1 9     3 3X3   6017231.85716 2098842.1766 37.7439873521291 -122.383058813116 (37.7439873521291, -122.383058813116)
22351 3656 1 78 100X Cargo Way 92 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6017299.77103 2098787.22136 37.7438402086508 -122.38282015645201 (37.7438402086508, -122.382820156452)
13788 3654 1 78 100X Cargo Way 90 1 1 9     6 3X3   6017326.20806 2098774.96233 37.743808008441704 -122.38272788957899 (37.7438080084417, -122.382727889579)
22317 3653 1 78 100X Cargo Way 89 1 1 9     6 3X3   6017331.733030001 2098760.60047 37.7437688789233 -122.382707786159 (37.7437688789233, -122.382707786159)
5002 3650 1 78 100X Cargo Way 86 1 1 9   04/10/2017 10:18:00 AM 3 3X3   6017379.34335 2098718.96834 37.743657195713396 -122.382540263146 (37.7436571957134, -122.382540263146)
136158 197211 2 78 351 Cargo Way 1 4 1 1     8 Width 3ft   6017250.2855 2098720.3657 37.7436539023979 -122.382986615562 (37.7436539023979, -122.382986615562)
171037 197212 2 78 351 Cargo Way 2 4 1 1     4 Width 3ft   6017263.91913 2098709.4149599997 37.74362458719779 -122.38293871135099 (37.7436245871978, -122.382938711351)
35223 197213 2 78 351 Cargo Way 4 4 1 1     3 Width 3ft   6017295.11492 2098681.7702099998 37.74355040393579 -122.382828919425 (37.7435504039358, -122.382828919425)
4950 3646 5 78 100X Cargo Way 82 1 1 9   04/10/2017 10:16:00 AM 3 3X3   6017441.11571 2098662.50366 37.7435055673357 -122.38232273959999 (37.7435055673357, -122.3823227396)
5067 3644 1 78 100X Cargo Way 80 1 1 9   04/10/2017 10:15:00 AM 3 3X3   6017471.8409400005 2098633.68097 37.7434281231236 -122.382214493629 (37.7434281231236, -122.382214493629)
22311 3643 5 78 100X Cargo Way 79 1 1 9     6 3X3   6017487.6627 2098619.8542 37.7433910314633 -122.382158823763 (37.7433910314633, -122.382158823763)
5060 197214 2 78 351 Cargo Way 9 1 1 1     4 Width 3ft   6017373.601009999 2098611.9970400003 37.743363156981104 -122.382552677381 (37.7433631569811, -122.382552677381)
22339 3642 5 78 100X Cargo Way 78 1 1 9     6 3X3   6017503.4842 2098606.02713 37.7433539389383 -122.382103154832 (37.7433539389383, -122.382103154832)
5047 197215 2 78 351 Cargo Way 10 1 1 1     6 Width 3ft   6017388.82526 2098597.46987 37.743324109317 -122.38249902473 (37.743324109317, -122.38249902473)
4948 3641 1 78 100X Cargo Way 77 1 1 9   05/01/2017 03:31:00 PM 3 3X3   6017517.08856 2098593.13553 37.7433192925522 -122.38205521738999 (37.7433192925522, -122.38205521739)
156588 197216 2 78 351 Cargo Way 11 4 1 1     3 Width 3ft   6017405.29347 2098583.32775 37.7432861876121 -122.38244109758499 (37.7432861876121, -122.382441097585)
14056 3640 1 78 100X Cargo Way 76 1 1 9     12 3X3   6017536.43295 2098576.56598 37.7432748642351 -122.381987176477 (37.7432748642351, -122.381987176477)
152030 197217 2 78 351 Cargo Way 12 4 1 1     6 Width 3ft   6017418.77475 2098570.88696 37.7432527723975 -122.382393616971 (37.7432527723975, -122.382393616971)
164348 197218 2 78 351 Cargo Way 13 4 1 1     3 Width 3ft   6017435.50351 2098556.05574 37.743212972902704 -122.38233474108101 (37.7432129729027, -122.382334741081)
22332 3637 1 78 100X Cargo Way 73 1 1 9     6 3X3   6017581.37685 2098535.7297 37.7431652179942 -122.381828930869 (37.7431652179942, -122.381828930869)
22315 3636 5 78 100X Cargo Way 72 1 1 9     12 3X3   6017599.14752 2098522.45762 37.7431297568333 -122.38176656108601 (37.7431297568333, -122.381766561086)
4938 203012 3 78 351 Cargo Way 16 1 1 2   04/10/2017 11:41:00 AM 3 Width 3ft   6017482.43996 2098513.81637 37.743099584575795 -122.382169507733 (37.7430995845758, -122.382169507733)
13855 3635 1 78 100X Cargo Way 71 1 1 9   05/31/1996 12:00:00 AM 3 3x3   6017615.70257 2098508.02238 37.7430910347139 -122.38170831381201 (37.7430910347139, -122.381708313812)
14783 3633 1 78 100X Cargo Way 69 1 1 9     6 3X3   6017649.0599 2098484.04513 37.743027039860394 -122.381591304811 (37.7430270398604, -122.381591304811)
4930 197650 3 78 351 Cargo Way 18 1 1 2   05/03/2017 10:31:00 AM 3 Width 3ft   6017512.77369 2098485.85809 37.7430244920913 -122.38206267634399 (37.7430244920913, -122.382062676344)
22340 3632 5 78 100X Cargo Way 68 1 1 9     6 3X3   6017663.5913 2098472.7680200003 37.7429968775117 -122.38154027458799 (37.7429968775117, -122.381540274588)
4973 3631 5 78 100X Cargo Way 67 1 1 9   05/01/2017 03:27:00 PM 3 3X3   6017682.09522 2098458.88711 37.7429597849556 -122.381475327351 (37.7429597849556, -122.381475327351)
58085 197219 2 78 351 Cargo Way 20 4 1 1     4 Width 3ft   6017546.94281 2098457.41264 37.7429482736446 -122.38194254943599 (37.7429482736446, -122.381942549436)
4937 203013 3 78 351 Cargo Way 22 1 1 2   06/07/1996 12:00:00 AM 2 Width 3ft   6017575.06427 2098435.51559 37.742889701702794 -122.381843789478 (37.7428897017028, -122.381843789478)
22335 3628 5 78 100X Cargo Way 64 1 1 9     6 3X3   6017730.69941 2098422.13413 37.7428615520079 -122.38130471064899 (37.7428615520079, -122.381304710649)
4936 3492 3 78 201X Cargo Way 2 1 1 2   05/03/2017 10:28:00 AM 3 3X3   6017600.3443599995 2098412.1206099996 37.7428268597689 -122.38175475027599 (37.7428268597689, -122.381754750276)
15955 3494 3 78 201X Cargo Way 4 1 1 2     12 3X3   6017631.184309999 2098389.6910900003 37.7427669757157 -122.38164655374099 (37.7427669757157, -122.381646553741)
22324 3625 1 78 100X Cargo Way 61 1 1 9     6 3X3   6017781.374919999 2098384.59743 37.7427612812112 -122.38112687781 (37.7427612812112, -122.38112687781)
15070 3495 3 78 201X Cargo Way 5 1 1 2     12 3X3   6017646.36043 2098378.21595 37.742736305236605 -122.381593280624 (37.7427363052366, -122.381593280624)
4994 3624 5 78 100X Cargo Way 60 1 1 9   05/01/2017 03:25:00 PM 3 3X3   6017797.96297 2098371.7943700003 37.742727042232396 -122.38106863050601 (37.7427270422324, -122.381068630506)
15250 3496 3 78 201X Cargo Way 6 1 1 2     12 3X3   6017663.23695 2098365.77973 37.74270308968379 -122.381534061174 (37.7427030896838, -122.381534061174)
5003 3497 3 78 201X Cargo Way 7 1 1 2   04/10/2017 11:36:00 AM 3 3X3   6017681.58024 2098352.39138 37.7426673407245 -122.38146970386002 (37.7426673407245, -122.38146970386)
14225 3498 3 78 201X Cargo Way 8 1 1 2     12 3X3   6017700.75455 2098337.80167 37.7426283389164 -122.381402389631 (37.7426283389164, -122.381402389631)
1079 3621 5 78 100X Cargo Way 57 1 1 9   05/01/2017 03:22:00 PM 3 3X3   6017849.66978 2098333.64293 37.7426251400454 -122.380887189608 (37.7426251400454, -122.380887189608)
5035 3620 1 78 100X Cargo Way 56 1 1 9   05/01/2017 03:20:00 PM 3 3X3   6017867.03936 2098322.52996 37.7425955847281 -122.380826357655 (37.7425955847281, -122.380826357655)
15487 3499 3 78 201X Cargo Way 9 1 1 2     6 3X3   6017721.1126 2098322.7096700002 37.742588023232 -122.381330947484 (37.742588023232, -122.381330947484)
16830 3619 1 78 100X Cargo Way 55 1 1 9     6 3X3   6017883.8496199995 2098309.7670299998 37.742561468052294 -122.380767345063 (37.7425614680523, -122.380767345063)
14413 3500 3 78 201X Cargo Way 10 1 1 2     12 3X3   6017738.77776 2098309.39264 37.7425524325559 -122.381268940124 (37.7425524325559, -122.381268940124)
5070 3618 5 78 100X Cargo Way 54 1 1 9     12 3X3   6017899.85524 2098296.735 37.7425265680461 -122.380711096061 (37.7425265680461, -122.380711096061)
5013 3501 3 78 201X Cargo Way 11 1 1 2   05/03/2017 10:19:00 AM 3 3X3   6017757.788930001 2098294.27861 37.742511981949605 -122.381202153752 (37.7425119819496, -122.381202153752)
13849 3503 3 78 201X Cargo Way 13 1 1 2     3 3X3   6017795.07465 2098266.33581 37.742437314826496 -122.38107128711201 (37.7424373148265, -122.381071287112)
15552 3616 1 78 100X Cargo Way 52 1 1 9     12 3X3   6017954.336080001 2098256.07975 37.7424179434233 -122.38051989028901 (37.7424179434233, -122.380519890289)
15411 3504 3 78 201X Cargo Way 14 1 1 2     6 3X3   6017814.43885 2098252.58182 37.7424006179895 -122.3810033748 (37.7424006179895, -122.3810033748)
22328 3612 5 78 100X Cargo Way 48 1 1 9     6 3X3   6018020.628269999 2098207.76094 37.7422889275932 -122.380287312129 (37.7422889275932, -122.380287312129)
22337 3609 5 78 100X Cargo Way 45 1 1 9     9 3X3   6018070.77279 2098169.47823 37.7421865775631 -122.380111266222 (37.7421865775631, -122.380111266222)
Powered by Datasette · Query took 3.596ms · Data source: data.sfgov.org