sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1981 35702 1 85   15 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
5612 35700 1 85   14 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
7342 35697 1 85   8 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
8272 35698 1 85   10 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
10284 35699 1 85   11 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11246 35705 1 85   7 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11435 35694 1 85   4 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11560 35695 1 85   5 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
11610 35704 1 85   17 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
12226 35696 1 85   6 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
14850 35701 1 85   13 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15690 35690 1 85   9 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15799 35703 1 85   16 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
15958 35692 1 85   2 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
16152 35693 1 85   3 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
144120 114104 6 85 400x ARBALLO DR 1 7 1 1     12 3x3   5988116.0 2090625.0 37.7197732605649 -122.48313145165001 (37.7197732605649, -122.48313145165)
90926 114099 6 85 201x VIDAL DR 1 1 1 1     14     5987665.0 2090646.0 37.719804665893605 -122.484691919383 (37.7198046658936, -122.484691919383)
160462 177154 2 85 734 Peru Ave 1 9 1 1     6 Width 8ft   6005364.09678 2092392.61851 37.725615388036104 -122.42363641630301 (37.7256153880361, -122.423636416303)
91941 52992 1 85 1800 Oakdale Ave 3 1 1 1       3x3 Permit Number 48973 6013995.42685531 2096291.44248921 37.7368042013217 -122.394071207374 (37.7368042013217, -122.394071207374)
112760 200367 2 85 1300 Phelps St 9 4 1 1     17 Width 5ft   6014030.85339 2096351.6806400002 37.7369715717905 -122.393952936896 (37.7369715717905, -122.393952936896)
25127 200366 2 85 1300 Phelps St 8 4 1 1     12 Width 5ft   6014047.106269999 2096372.4575200002 37.7370295240776 -122.393898196954 (37.7370295240776, -122.393898196954)
63351 200365 2 85 1300 Phelps St 7 4 1 1     6 Width 5ft   6014060.81183 2096393.5404700001 37.7370881751809 -122.39385228564801 (37.7370881751809, -122.393852285648)
157215 200364 2 85 1300 Phelps St 6 4 1 1     13 Width 5ft   6014077.799769999 2096412.7772 37.7371419393345 -122.393794896313 (37.7371419393345, -122.393794896313)
167176 200363 2 85 1300 Phelps St 5 4 1 1     8 Width 5ft   6014137.38405 2096492.6896799998 37.7373646735385 -122.393594476122 (37.7373646735385, -122.393594476122)
186583 200362 2 85 1300 Phelps St 3 4 1 1     7 Width 5ft   6014166.7855 2096532.27247 37.7374749933851 -122.39349559025801 (37.7374749933851, -122.393495590258)
169282 200361 2 85 1300 Phelps St 1 4 1 1     7 Width 5ft   6014182.02229 2096553.32448 37.7375336444497 -122.39344438196699 (37.7375336444497, -122.393444381967)
45529 200360 2 85 1150 Phelps St 5 4 1 1     6 Width 5ft   6014196.6239 2096573.2462900002 37.737589156904995 -122.393395290662 (37.737589156905, -122.393395290662)
46141 200359 2 85 1150 Phelps St 4 4 1 1     9 Width 5ft   6014213.143619999 2096595.32013 37.737650684936796 -122.393339717964 (37.7376506849368, -122.393339717964)
74895 200358 2 85 1150 Phelps St 3 4 1 1     12 Width 5ft   6014239.8641 2096632.70057 37.7377548084229 -122.393249946754 (37.7377548084229, -122.393249946754)
32103 38388 1 85 1150 Phelps St 2 1 1 1   08/17/1998 12:00:00 AM 5   Permit Number 40446 6014255.1081300005 2096652.83017 37.737810927032704 -122.39319864851801 (37.7378109270327, -122.393198648518)
57768 200357 2 85 900 Phelps St 21 1 1 1     8 Width 5ft   6014316.3111 2096732.3588400001 37.73803269625021 -122.392992601233 (37.7380326962502, -122.392992601233)
136918 200356 2 85 900 Phelps St 20 1 1 1     7 Width 5ft   6014331.3129900005 2096752.73935 37.7380894902424 -122.39294215736601 (37.7380894902424, -122.392942157366)
134636 200355 2 85 900 Phelps St 19 4 1 1     11 Width 5ft   6014345.08354 2096773.3910700001 37.7381469605042 -122.392895989784 (37.7381469605042, -122.392895989784)
164517 200354 2 85 900 Phelps St 18 1 1 1     11 Width 5ft   6014359.7983 2096791.80766 37.7381983459865 -122.392846401168 (37.7381983459865, -122.392846401168)
133126 200353 2 85 900 Phelps St 17 4 1 1     11 Width 5ft   6014392.43301 2096834.63166 37.738317744462 -122.392736560653 (37.738317744462, -122.392736560653)
57963 200352 2 85 900 Phelps St 16 4 1 1     14 Width 5ft   6014405.80816 2096853.92235 37.7383714555731 -122.392691664697 (37.7383714555731, -122.392691664697)
135542 200351 2 85 900 Phelps St 15 1 1 1     10 Width 5ft   6014421.213330001 2096874.8296 37.73842971815 -122.39263986285 (37.73842971815, -122.39263986285)
146537 200350 2 85 900 Phelps St 12 4 1 1     7 Width 4ft   6014508.81125 2096991.75117 37.738755625282394 -122.39234516490299 (37.7387556252824, -122.392345164903)
31300 200349 2 85 900 Phelps St 11 4 1 1     8 Width 4ft   6014526.629869999 2097016.7538700001 37.738825266977294 -122.392285304228 (37.7388252669773, -122.392285304228)
40723 200348 2 85 900 Phelps St 10 4 1 1     9 Width 4ft   6014546.28219 2097041.8855599998 37.738895364638 -122.39221911232599 (37.738895364638, -122.392219112326)
105063 200347 2 85 900 Phelps St 9 4 1 1     11 Width 4ft   6014556.031830001 2097054.78425 37.7389313231291 -122.392186304173 (37.7389313231291, -122.392186304173)
168594 200346 2 85 900 Phelps St 4 4 1 1     9 Width 4ft   6014640.20968 2097167.32462 37.7392450093596 -122.391903121137 (37.7392450093596, -122.391903121137)
83384 17658 1 85 1000X Phelps St 3 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
87807 17661 1 85 1000X Phelps St 6 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104025 17656 1 85 1000X Phelps St 1 1 1 13   11/15/1992 12:00:00 AM 6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104908 17662 1 85 1000X Phelps St 7 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
117411 17659 1 85 1000X Phelps St 4 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
125491 17660 1 85 1000X Phelps St 5 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
175699 200345 2 85 900 Phelps St 3 4 1 1     6 Width 4ft   6014658.54117 2097192.95407 37.7393164002222 -122.391841530176 (37.7393164002222, -122.391841530176)
169758 208167 2 85 2590 16th Ave 1 1 1 1     9 Width 3ft   5991441.567009999 2097783.56953 37.7396218639513 -122.47215777968201 (37.7396218639513, -122.472157779682)
72713 208168 2 85 2590 16th Ave 2 1 1 1     11 Width 3ft   5991441.450619999 2097800.63089 37.7396687033598 -122.472159425416 (37.7396687033598, -122.472159425416)
181097 208169 2 85 2590 16th Ave 3 1 1 1     9 Width 3ft   5991440.6028 2097828.1323700002 37.7397441663462 -122.472164360908 (37.7397441663462, -122.472164360908)
73201 228843 2 85 707 Eugenia Ave 2 1 1 1     14 Width 3ft   6007452.7290199995 2097768.34677 37.7404936415683 -122.416796844595 (37.7404936415683, -122.416796844595)
155277 228844 2 85 709 Eugenia Ave 1 1 1 1     10 Width 3ft   6007473.725769999 2097767.91667 37.7404936415809 -122.416724215363 (37.7404936415809, -122.416724215363)
94681 63072 1 85 709 Eugenia Ave 1 1 1 1 1 11/21/1986 12:00:00 AM     Permit Number 23550 6007407.20126882 2097784.26133742 37.740534778558605 -122.416955389518 (37.7405347785586, -122.416955389518)
151751 200344 2 85 750 Phelps St 40 4 1 1     4 Width 4ft   6015132.05324 2097828.30985 37.74108723188171 -122.390248699517 (37.7410872318817, -122.390248699517)
90452 86806 1 85 700X Phelps St 1 1 1 15     9 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992)
93009 86807 1 85 700X Phelps St 2 1 1 15     6 2x2   6015141.822176 2097839.440048 37.7411183349667 -122.3902156992 (37.7411183349667, -122.3902156992)
159507 200343 2 85 750 Phelps St 39 4 1 1     8 Width 4ft   6015141.18947 2097840.20057 37.741120388109294 -122.39021794000799 (37.7411203881093, -122.390217940008)
116101 17647 1 85 650X Phelps St 2 1 1 15     6 2x2   6015137.8127243 2097842.4274143996 37.7411263152677 -122.39022977121401 (37.7411263152677, -122.390229771214)
42998 200342 2 85 750 Phelps St 25 4 1 1     8 Width 2ft   6015273.793930001 2098017.0765 37.7416134072345 -122.389771789042 (37.7416134072345, -122.389771789042)
76523 200341 2 85 750 Phelps St 24 4 1 1     8 Width 2ft   6015282.07626 2098027.6206799997 37.74164281866221 -122.389743887597 (37.7416428186622, -122.389743887597)
72490 200340 2 85 750 Phelps St 23 4 1 1     8 Width 2ft   6015300.13853 2098052.9717 37.7417134289277 -122.38968320401399 (37.7417134289277, -122.389683204014)
137367 200339 2 85 750 Phelps St 22 4 1 1     5 Width 2ft   6015308.33502 2098065.1650799997 37.741747363937606 -122.389655714464 (37.7417473639376, -122.389655714464)
85626 17642 1 85 600X Phelps St 3 1 1 15     6 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
94447 17645 1 85 600X Phelps St 6 1 1 15     10 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
109408 17643 1 85 600X Phelps St 4 1 1 15     8 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
123909 17641 1 85 600X Phelps St 2 1 1 15     10 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
145002 17644 1 85 600X Phelps St 5 1 1 15     8 2x2   6015304.738625 2098066.4602575 37.74175072080671 -122.38966824014999 (37.7417507208067, -122.38966824015)
160126 200338 2 85 750 Phelps St 21 4 1 1     9 Width 2ft   6015318.39191 2098076.99567 37.7417804059521 -122.389621766852 (37.7417804059521, -122.389621766852)
185785 200337 2 85 750 Phelps St 9 4 1 1     10 Width 4ft   6015484.2575199995 2098301.13552 37.742405043569796 -122.389063899405 (37.7424050435698, -122.389063899405)
166431 200336 2 85 750 Phelps St 8 4 1 1     9 Width 3ft   6015493.51667 2098314.62088 37.7424425848476 -122.38903282511002 (37.7424425848476, -122.38903282511)
120380 64146 1 85 465 Day St 1 1 1 1 1 12/05/1987 12:00:00 AM     Permit Number 24921 6002780.16143913 2098575.90057442 37.7424470739996 -122.433010428517 (37.7424470739996, -122.433010428517)
2250 200335 1 85 750 Phelps St 7 4 1 15     4 Width 2ft   6015505.4551 2098329.2709 37.7424834725483 -122.388992567847 (37.7424834725483, -122.388992567847)
32287 227937 2 85 465 Day St 1 1 1 1     16 Width 4ft   6002968.42227 2098587.5279900003 37.7424896769594 -122.43236030960699 (37.7424896769594, -122.432360309607)
2256 200334 1 85 750 Phelps St 4 4 1 15   11/15/1992 12:00:00 AM 8 Width 3ft   6015528.91481 2098358.82009 37.742565908900204 -122.388913512973 (37.7425659089002, -122.388913512973)
75743 17631 1 85 420X Phelps St 1 1 1 15   11/15/1992 12:00:00 AM 6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
83164 17638 1 85 420X Phelps St 8 1 1 15     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
85032 17636 1 85 420X Phelps St 6 1 1 15     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
92402 17639 1 85 420X Phelps St 9 1 1 15     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
102325 17634 1 85 420X Phelps St 4 1 1 15     6 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
145599 17635 1 85 420X Phelps St 5 1 1 15     12 3X3   6015607.4628299 2098472.4768112 37.7428823403387 -122.38864984673799 (37.7428823403387, -122.388649846738)
24184 208171 2 85 158 Merced Ave 1 1 1 1     3 Width 4ft   5994395.10908 2099344.18308 37.744077400365 -122.46205892188401 (37.744077400365, -122.462058921884)
53935 208172 2 85 154 Merced Ave 1 1 1 1     4 Width 4ft   5994418.094740001 2099364.4172099996 37.7441342815725 -122.46198091018499 (37.7441342815725, -122.461980910185)
136849 208174 2 85 170 Vasquez Ave 2 2 1 1     6 Width 3ft   5994830.69157 2099413.59203 37.7442930488025 -122.460557814002 (37.7442930488025, -122.460557814002)
43828 208173 2 85 170 Vasquez Ave 1 2 1 1     9 Width 3ft   5994847.17518 2099430.14012 37.744339434016794 -122.460502016448 (37.7443394340168, -122.460502016448)
78762 85037 1 85 170 Vasquez Ave 1 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
90885 85038 1 85 170 Vasquez Ave 2 1 1 1           5994836.8 2099436.6 37.7443565743554 -122.460538359387 (37.7443565743554, -122.460538359387)
46833 227936 2 85 167 Valley St 1 1 1 1     26 Width 5ft   6004844.7517 2099277.52267 37.7444904598682 -122.42592162061001 (37.7444904598682, -122.42592162061)
84551 45668 1 85 46(REVISED) Clipper St 1 1 1 1 1 10/06/2003 12:00:00 AM     Permit Number 44364 6004865.19751473 2101080.41704042 37.7494419484142 -122.425979237767 (37.7494419484142, -122.425979237767)
46581 228841 2 85 65 Homestead St 2 1 1 1     16 Width 3ft   6000998.7373 2101290.13943 37.749798521207204 -122.439364559745 (37.7497985212072, -122.439364559745)
118847 108695 1 85 511 Alvarado St   1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774625 6003049.10666 2102687.45843 37.7537516993963 -122.432374086122 (37.7537516993963, -122.432374086122)
129842 228840 2 85 104 Chattanooga St 1 1 1 1     8 Width 4ft   6004701.59069 2103023.11733 37.754766903184 -122.426683319388 (37.754766903184, -122.426683319388)
33596 227938 2 85 25 Chattanooga St 1 1 1 1     4 Width 3ft   6004713.51107 2103480.2352 37.756022715594604 -122.426674645426 (37.7560227155946, -122.426674645426)
151478 228845 2 85 4526 20th St 1 1 1 1     17 Width 3ft   6001290.00365 2104097.6707200003 37.7575238972389 -122.438558485713 (37.7575238972389, -122.438558485713)
173137 227935 2 85 705 Treat Ave 1 1 1 1     1 Width 4ft   6008535.61915 2104408.30699 37.7587863358342 -122.413522114462 (37.7587863358342, -122.413522114462)
146016 108433 1 85 222x Cumberland St 6 1 1 1   06/03/2015 12:00:00 AM 3 4x4 Permit Number 774483 6004156.2455400005 2104544.03717 37.758912142621206 -122.428677685352 (37.7589121426212, -122.428677685352)
65614 228852 2 85 210 Cumberland St 7 1 1 1     3 Width 3ft   6004131.71858 2104545.14122 37.7589137859482 -122.428762589748 (37.7589137859482, -122.428762589748)
151732 228851 2 85 210 Cumberland St 6 1 1 1     3 Width 3ft   6004146.65332 2104546.1831400003 37.7589174920696 -122.42871101271002 (37.7589174920696, -122.42871101271)
68851 228850 2 85 210 Cumberland St 5 1 1 1     6 Width 3ft   6004169.71901 2104547.0578 37.7589211990752 -122.42863130311501 (37.7589211990752, -122.428631303115)
75033 228849 2 85 210 Cumberland St 4 1 1 1     5 Width 3ft   6004184.64448 2104547.65023 37.75892367042171 -122.42857972608499 (37.7589236704217, -122.428579726085)
Powered by Datasette · Query took 5.847ms · Data source: data.sfgov.org