sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
54260 177419 2 88 100 Capistrano Ave 6 1 1 1     2 Width 2ft   6001443.854169999 2093560.7227900003 37.7286006695825 -122.437271950666 (37.7286006695825, -122.437271950666)
54394 193368 2 88 262 Mission St 2 1 1 1     2 Width 4ft   6013947.275280001 2116186.44855 37.79142884020779 -122.395631194149 (37.7914288402078, -122.395631194149)
54472 230304 2 88 3689 19th St 1 1 1 1     2 Width 5ft   6005034.41688 2104845.09352 37.7597884333033 -122.42566198362101 (37.7597884333033, -122.425661983621)
54565 177434 2 88 131 Brussels St 1 1 1 1     1 Width 4ft   6010258.4147 2094004.87757 37.7303173692474 -122.40683065573099 (37.7303173692474, -122.406830655731)
54895 193335 2 88 1260 Minnesota St 1 1 1 1     2 Width 3ft   6015305.18557 2102619.11987 37.7542513973846 -122.389984647787 (37.7542513973846, -122.389984647787)
55251 130983 2 88 2200 Beach St 6 9 1 1     1 Width 4ft   5999604.2907300005 2120890.91469 37.8035377808009 -122.44559592174 (37.8035377808009, -122.44559592174)
55341 130999 2 88 2009 Jones St 1 1 1 1     5 Width 3ft   6008124.35834 2119571.24818 37.8003970406522 -122.41601824307101 (37.8003970406522, -122.416018243071)
55956 246808 2 88 162 Brewster St 1 4 1 1     1 Width 2ft   6010230.46229 2099004.5054099998 37.744043711743004 -122.407279600877 (37.744043711743, -122.407279600877)
55977 230279 2 88 529 Buchanan St 2 2 1 1     1 Width 6ft   6004554.65684 2110370.74902 37.774933432055 -122.42771494250499 (37.774933432055, -122.427714942505)
56020 30506 1 88 3615 Sacramento St 1 1 1 1   09/30/1998 12:00:00 AM 6   Permit Number 40581 5997549.204530001 2115073.9457400003 37.787448412048604 -122.45228761430599 (37.7874484120486, -122.452287614306)
56377 193374 2 88 778 Tehama St 1 1 1 1     1 Width 2ft   6008975.96564 2110229.86919 37.7747957152898 -122.412410677425 (37.7747957152898, -122.412410677425)
56518 177443 2 88 63 Karen Ct 1 1 1 1     1 Width 2ft   6010306.59987 2091507.00491 37.7234614298874 -122.40648812732799 (37.7234614298874, -122.406488127328)
56984 38711 1 88 2000 McAllister St 2 1 1 1   05/16/2012 12:00:00 AM 1   Permit Number 768631 5999529.3553 2111223.7902 37.7769901198015 -122.44515981121201 (37.7769901198015, -122.445159811212)
56993 130971 2 88 2801 Webster St 2 10 1 1     2 Width 2ft   6002947.99505 2118332.47012 37.7967032866916 -122.43384191568998 (37.7967032866916, -122.43384191569)
57463 193356 2 88 60 Main St 2 1 1 1     2 Width 4ft   6014000.33626 2116445.25726 37.7921424198756 -122.395465742269 (37.7921424198756, -122.395465742269)
57558 230352 2 88 136 Moffitt St 1 1 1 1     1 Width 2ft   6002654.78135 2096839.9013099999 37.7376733091617 -122.433319933881 (37.7376733091617, -122.433319933881)
57885 230313 2 88 968 Hampshire St 1 1 1 1     2 Width 3ft   6010194.52879 2103588.6082900004 37.756628635618604 -122.40772701540399 (37.7566286356186, -122.407727015404)
59077 118718 2 88 818 44th Ave 1 1 1 1     1 Width 3ft   5982331.02075 2110159.51383 37.7730712650544 -122.504574285424 (37.7730712650544, -122.504574285424)
59160 230296 2 88 3500 19th St 5 1 1 1     2 Width 5ft   6006123.351530001 2104947.42015 37.7601308699707 -122.421903157405 (37.7601308699707, -122.421903157405)
59718 193339 2 88 1278 Minnesota St 1 1 1 1     4 Width 3ft   6015309.7122 2102531.15535 37.7540101165005 -122.389962849121 (37.7540101165005, -122.389962849121)
59745 208853 2 88 54 Martha Ave 1 1 1 1     15 Width 2ft   6000650.73977 2095621.13276 37.734212959854396 -122.440161475975 (37.7342129598544, -122.440161475975)
60128 250187 2 88 665 Parker Ave 4 4 1 1     1 Width 4ft   5997222.68042 2110871.6887 37.7758914096851 -122.453113845732 (37.7758914096851, -122.453113845732)
60143 72252 2 88 531 Madrid St 1 1 1 1 1 01/06/1996 12:00:00 AM 1     6002585.93283 2090796.9641 37.7210768666757 -122.43312633500601 (37.7210768666757, -122.433126335006)
60313 193334 2 88 1258 Minnesota St 5 1 1 1     2 Width 3ft   6015304.94166 2102636.75923 37.7542998178001 -122.38998672342 (37.7542998178001, -122.38998672342)
60469 80737 2 88 186 Allison St 1 1 1 1 1 03/22/2003 12:00:00 AM 1     6000043.5525400005 2087718.3093599998 37.7124790304587 -122.44169374357 (37.7124790304587, -122.44169374357)
60673 230347 2 88 1801 Church St 4 1 1 1     2 Width 3ft   6004579.28935 2098353.48586 37.741938260334294 -122.42677374352199 (37.7419382603343, -122.426773743522)
60907 50426 1 88 250 Howth St 1 1 1 1 1 11/12/2014 12:00:00 AM 3   Permit Number 773627 5997303.25557645 2090612.9654569 37.7202705700793 -122.45137364778 (37.7202705700793, -122.45137364778)
61056 85039 1 88 740 Natoma St 1 1 1 1   06/26/2007 12:00:00 AM 1 3x3 Permit Number 49387 6008855.33926 2110725.28618 37.776149243538796 -122.41286298423901 (37.7761492435388, -122.412862984239)
61145 95563 1 88 497 Elizabeth St 1 1 1 1 1     3x3   6003239.0 2102086.6 37.75211264995529 -122.43167449646799 (37.7521126499553, -122.431674496468)
61328 193352 2 88 1707 McKinnon Ave 1 4 1 1     4 Width 3ft   6014777.576230001 2096343.32459 37.736990099615 -122.39137057769199 (37.736990099615, -122.391370577692)
61520 130998 2 88 2201 Leavenworth St 4 9 1 1     5 Width 3ft   6007580.24685 2119942.9983 37.8013871663302 -122.41792745790899 (37.8013871663302, -122.417927457909)
61699 86883 1 88 550 Jersey St   1 1 1       3x3 Permit Number 49808 6001589.0 2101474.0 37.750336931820996 -122.43733657341998 (37.750336931821, -122.43733657342)
62134 96861 1 88 387 29th Ave 1 1 1 1   08/02/2011 12:00:00 AM 2 3x3 Permit Number 768142 5986826.57443 2113361.96386 37.7821276946473 -122.489259307913 (37.7821276946473, -122.489259307913)
62272 177397 2 88 650 France Ave 2 1 1 1     5 Width 4ft   6002573.73742 2089477.3552599999 37.717452821874105 -122.433074256169 (37.7174528218741, -122.433074256169)
63085 65128 1 88 184 20th Ave 1 1 1 1   03/31/2008 12:00:00 AM 3 3x3 Permit Number 50320 5989636.73328 2114131.59369 37.7844045165702 -122.47959386665 (37.7844045165702, -122.47959386665)
63292 177412 2 88 539 Moscow St 1 1 1 1     2 Width 2ft   6003697.3420400005 2090030.0653 37.719034114214004 -122.42922986306401 (37.719034114214, -122.429229863064)
63323 96333 1 88 11 Robblee Ave 1 1 1 1   04/28/2011 12:00:00 AM 3 3x3 Permit Number 767342 6012676.77436 2095976.0416 37.7358647977189 -122.398608271155 (37.7358647977189, -122.398608271155)
64180 84410 1 88 745 10th Ave 1 1 1 1   08/04/2008 12:00:00 AM 2 3x3 Permit Number 51564 5992859.62349 2110370.66867 37.774264723280204 -122.468170197773 (37.7742647232802, -122.468170197773)
64441 249953 2 88 303 Filbert St 2 17 1 1     4 Width 0ft   6011372.652369999 2120041.55492 37.8018704817969 -122.40481091868901 (37.8018704817969, -122.404810918689)
64511 177400 2 88 1112 Russia Ave 1 1 1 1     1 Width 2ft   6003994.8137 2089359.3172799998 37.7172092225078 -122.428153843121 (37.7172092225078, -122.428153843121)
65040 84492 1 88 1726 Revere Ave 1 1 1 1   01/22/2008 12:00:00 AM 6 3x3 Permit Number 50144 6014424.88297 2094914.9156 37.733048399857005 -122.392490121246 (37.733048399857, -122.392490121246)
65070 78191 2 88 680 Tennessee St 1 1 1 1 1 10/05/2002 12:00:00 AM 1     6015407.71241 2105894.14692 37.7632496064147 -122.389858829046 (37.7632496064147, -122.389858829046)
65368 230328 2 88 518 Banks St 1 1 1 1     1 Width 2ft   6008539.17549 2096369.5184099998 37.7367138134929 -122.41294144560601 (37.7367138134929, -122.412941445606)
65862 130969 2 88 95 Heather Ave 2 9 1 1     1     5997355.4901 2113891.63765 37.7841910082488 -122.452872452398 (37.7841910082488, -122.452872452398)
66196 107892 1 88 162 Brewster St   8 1 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.40727852777799 (37.7440766668365, -122.407278527778)
66302 61318 1 88 1419 Kansas St 1 1 1 1 1 06/02/2014 12:00:00 AM 1   Permit Number 772899 6011764.55732 2101642.9103 37.751373940974204 -122.402160470048 (37.7513739409742, -122.402160470048)
66339 84782 1 88 228 Mississippi St 1 1 1 1   03/20/2007 12:00:00 AM 5   Permit No. 49243 6013990.15625 2105982.3752200003 37.763413148108505 -122.394767902514 (37.7634131481085, -122.394767902514)
66578 70266 2 88 414 23rd Ave 2 1 1 1 1 02/17/1996 12:00:00 AM 8     5988762.33088 2112478.2196299997 37.7798139854521 -122.482497769619 (37.7798139854521, -122.482497769619)
66618 248252 2 88 110 Lundy's Ln 1 1 1 1     8 Width 3ft   6006810.41598 2098914.4324 37.7436043875329 -122.41909899033999 (37.7436043875329, -122.41909899034)
66636 82354 1 88 254 Dublin St 1 1 1 1   06/04/2008 12:00:00 AM   3x3 Permit Number 50649 6004015.90676212 2089097.25184538 37.716490841330106 -122.428062269463 (37.7164908413301, -122.428062269463)
66641 50836 1 88 202 Kirkham St 2 1 1 1   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742)
66770 193362 2 88 246 Mission St 2 1 1 1     2 Width 4ft   6014011.61838 2116245.86436 37.7915955610366 -122.39541273082399 (37.7915955610366, -122.395412730824)
66893 69450 1 88 438 33rd Ave 1 1 1 1 1 05/16/1994 12:00:00 AM 3   Permit Number 33560 5985645.83858 2112922.4758599997 37.780851994355004 -122.493311672832 (37.780851994355, -122.493311672832)
67154 122918 2 88 336 12th Ave 1 1 1 1     7 Width 3ft   5992182.56375 2113171.96239 37.781917187404794 -122.470716333226 (37.7819171874048, -122.470716333226)
67518 230357 2 88 137 Randall St 1 1 1 1     5 Width 3ft   6004642.1298400005 2097534.3319200003 37.739692602838296 -122.426498147168 (37.7396926028383, -122.426498147168)
68072 250185 2 88 665 Parker Ave 2 4 1 1     2 Width 4ft   5997218.614440001 2110901.95743 37.7759742867055 -122.453130096488 (37.7759742867055, -122.453130096488)
68109 112522 2 88 195 02nd Ave 1 1 1 1   09/09/2015 12:00:00 AM 1 3x3 Permit Number 776238 5995198.14893 2114301.9969900004 37.7851938828924 -122.460365776533 (37.7851938828924, -122.460365776533)
68243 87490 1 88 496 38th Ave 2 1 1 1   05/16/2008 12:00:00 AM 1 3x3 Permit Number 50390 5984109.08074 2112532.5405200003 37.77969133885821 -122.498599173652 (37.7796913388582, -122.498599173652)
68631 208843 2 88 40 Agua Way 1 1 1 1     4 Width 2ft   5997291.06099 2098595.63938 37.74218838968729 -122.451991423486 (37.7421883896873, -122.451991423486)
68652 124611 2 88 3931 Clay St 2 1 1 1     4 Width 3ft   5995971.07063 2115182.72875 37.787656567418 -122.457755475318 (37.787656567418, -122.457755475318)
68884 55891 1 88 1981 Union St 1 1 1 1   05/24/1979 12:00:00 AM 4   Permit Number 17936 6003525.54431 2118603.6465 37.7974806237872 -122.43186283789801 (37.7974806237872, -122.431862837898)
69069 130976 2 88 2801 Webster St 7 10 1 1     3 Width 2ft   6002956.82977 2118266.12381 37.796521618235005 -122.433806601098 (37.796521618235, -122.433806601098)
69222 68687 1 88 133 12th Ave 1 1 1 1 1 01/06/2014 12:00:00 AM 1 6x6 Permit Number 771044 5992088.87095 2114507.13587 37.7855777876584 -122.471137767056 (37.7855777876584, -122.471137767056)
69848 81662 2 88 563 14th Ave 1 1 1 1 1   4     5991577.12734 2111607.04314 37.7775853186785 -122.472696706975 (37.7775853186785, -122.472696706975)
70176 94709 1 88 739 12th Ave 1 1 1 1 1 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53847 5992236.9095 2110392.30167 37.7742881380791 -122.47032583467899 (37.7742881380791, -122.470325834679)
71256 52791 1 88 955@ MOSCOW Excelsior Ave 1 1 1 1   05/25/2006 12:00:00 AM 1   Permit Number 48832 6004754.52241 2091271.3997400003 37.7225023397811 -122.425663900979 (37.7225023397811, -122.425663900979)
71293 208847 2 88 422 Grafton Ave 1 1 1 1     1 Width 3ft   5995505.44933 2090582.5246599999 37.7200838784427 -122.457585828931 (37.7200838784427, -122.457585828931)
71656 123425 2 88 642 03rd Ave 1 1 1 1     23 Width 3ft   5995046.062419999 2111151.48991 37.7765346834922 -122.460663556381 (37.7765346834922, -122.460663556381)
71769 177406 2 88 618 Edinburgh St 2 1 1 1     3 Width 3ft   6002461.15734 2090172.80832 37.7193559950662 -122.433513065093 (37.7193559950662, -122.433513065093)
71813 249952 2 88 303 Filbert St 3 17 1 1     2 Width 0ft   6011371.46837 2120040.8031 37.801868351303796 -122.40481496294399 (37.8018683513038, -122.404814962944)
72263 193315 2 88 136 Hawthorne St 1 4 1 1     9 Width 2ft   6013291.138730001 2113684.88595 37.7845236126199 -122.39772589056001 (37.7845236126199, -122.39772589056)
72299 247777 2 88 240 30th St 1 4 1 1     2 Width 3ft   6005014.994390001 2098457.52943 37.742248565111204 -122.42527461684799 (37.7422485651112, -122.425274616848)
72311 193321 2 88 2111 18th St 3 1 1 1     3 Width 4ft   6011418.14714 2105550.13938 37.7620829860523 -122.403633286154 (37.7620829860523, -122.403633286154)
72470 130987 2 88 1332 Bush St 4 1 1 1     2 Width 3ft   6006981.766419999 2115388.7011599997 37.7888485036088 -122.419675148215 (37.7888485036088, -122.419675148215)
72706 112523 2 88 195 02nd Ave 2 1 1 1   09/09/2015 12:00:00 AM 1 3x3 Permit Number 776238 5995199.36548 2114291.31706 37.7851646286632 -122.46036079357799 (37.7851646286632, -122.460360793578)
72897 43147 1 88 249 Gambier St 1 1 1 1 1 03/08/2011 12:00:00 AM 4 3x3 Permit Number 767437 6005979.23995 2092615.6379200001 37.7262624547464 -122.421525745221 (37.7262624547464, -122.421525745221)
73049 70606 2 88 1250 Bush St 1 1 1 1 1 08/13/1994 12:00:00 AM 8     6007500.2862599995 2115460.0775 37.7890736803541 -122.41788619879298 (37.7890736803541, -122.417886198793)
73056 123366 2 88 780 04th Ave 2 2 1 1     3 Width 4ft   5994765.69029 2110380.32738 37.774401141157796 -122.461577514019 (37.7744011411578, -122.461577514019)
73090 123057 2 88 514 Funston Ave 2 2 1 1     5 Width 4ft   5991919.1397400005 2111920.98536 37.778467110254795 -122.47153646453998 (37.7784671102548, -122.47153646454)
73543 193322 2 88 2111 18th St 4 1 1 1     5 Width 4ft   6011436.66428 2105551.33646 37.762087307318104 -122.403569326371 (37.7620873073181, -122.403569326371)
73621 130991 2 88 1645 Washington St 1 1 1 1     4 Width 3ft   6006783.4642 2117013.9596599997 37.7932998878436 -122.42047665816901 (37.7932998878436, -122.420476658169)
73825 120376 2 88 123 25th Ave 1 1 1 1     4 Width 2ft   5987996.34408 2115176.14425 37.787177130208995 -122.48534564914301 (37.787177130209, -122.485345649143)
74024 230292 2 88 3500 19th St 1 1 1 1     2 Width 5ft   6006199.95177 2104950.54929 37.760143781519496 -122.42163845546499 (37.7601437815195, -122.421638455465)
74490 230306 2 88 65 Oakwood St 1 1 1 1     2 Width 3ft   6005267.4467 2105080.91438 37.7604491067472 -122.42487282493299 (37.7604491067472, -122.424872824933)
74564 177429 2 88 278 Ney St 1 1 1 1     1 Width 3ft   6005195.233080001 2094056.1980299999 37.7301736773527 -122.42433843338699 (37.7301736773527, -122.424338433387)
74610 230333 2 88 629 28th St 1 1 1 1     1 Width 2ft   6001808.677069999 2099403.33262 37.7446638554471 -122.436428732821 (37.7446638554471, -122.436428732821)
74720 131004 2 88 1109 Sansome St 2 1 1 1     5 Width 3ft   6011962.5768099995 2119524.82057 37.8004846103385 -122.402733131341 (37.8004846103385, -122.402733131341)
74944 230336 2 88 823 Castro St 2 1 1 1     10 Width 3ft   6002471.62973 2103413.82046 37.7557133541918 -122.434423059382 (37.7557133541918, -122.434423059382)
75167 177436 2 88 99 Karen Ct 2 1 1 1     1 Width 2ft   6010107.2934 2091444.47715 37.7232785896114 -122.40717269128099 (37.7232785896114, -122.407172691281)
75334 193343 2 88 698 Arkansas St 1 4 1 1     4 Width 3ft   6012989.114019999 2103849.31958 37.757500537346395 -122.39808055528299 (37.7575005373464, -122.398080555283)
75357 230307 2 88 316 San Carlos St 1 1 1 1     2 Width 3ft   6006700.0483099995 2104252.32406 37.758254804122 -122.419859309575 (37.758254804122, -122.419859309575)
75476 208842 2 88 168 Dorantes Ave 1 2 1 1     3 Width 4ft   5993717.6087 2099811.01881 37.7453201833801 -122.46443543703998 (37.7453201833801, -122.46443543704)
75481 249813 2 88 260 Chestnut St 3 7 1 1     3 Width 0ft   6010621.11973 2121031.8935700003 37.8045476726861 -122.407481446514 (37.8045476726861, -122.407481446514)
75641 124612 2 88 3931 Clay St 1 1 1 1     3 Width 3ft   5995955.42177 2115180.15749 37.7876486084254 -122.457809430854 (37.7876486084254, -122.457809430854)
76542 87077 1 88 2565 Larkin St 2 1 1 1   12/18/2007 12:00:00 AM 3 3x3 Permit Number 50014 6006603.98041 2120038.0860099997 37.8015932612686 -122.421312536668 (37.8015932612686, -122.421312536668)
76734 88076 1 88 674 Thornton Ave 1 1 1 1   06/24/2008 12:00:00 AM 5 3x3 Permit Number 51071 6011923.037330001 2094336.6439200002 37.731321332804605 -122.40109909554701 (37.7313213328046, -122.401099095547)
76764 108377 1 88 226 Munich St 1 1 1 1 1   1 3x3 Permit Number 773810 6004631.19295 2091083.0586299999 37.7219782266077 -122.42607682199801 (37.7219782266077, -122.426076821998)
76787 208846 2 88 36 De Montfort Ave 1 1 1 1     3 Width 3ft   5995163.31564 2091909.32906 37.7237073072365 -122.45886447241999 (37.7237073072365, -122.45886447242)
77021 32342 1 88 130 Lexington St 1 1 1 1 1 02/20/1998 12:00:00 AM 1   Permit Number 770451 6006450.269730001 2105316.80145 37.761163536302206 -122.420798725186 (37.7611635363022, -122.420798725186)
77158 208851 2 88 185 Vasquez Ave 1 2 1 1     4 Width 3ft   5994827.47674 2099365.31036 37.7441602944536 -122.46056543215299 (37.7441602944536, -122.460565432153)
77434 81367 2 88 1001 Polk St 1 10 1 1   11/08/2003 12:00:00 AM   3x3   6006914.85774282 2114314.60875621 37.7858955407321 -122.41983039718201 (37.7858955407321, -122.419830397182)
Powered by Datasette · Query took 6.521ms · Data source: data.sfgov.org