sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
50086 113271 1 20 1321 Revere Ave   1 1 1   09/16/2015 12:00:00 AM     Permit Number 774420 6016529.9 2093260.0 37.7286210040554 -122.38509718743299 (37.7286210040554, -122.385097187433)
80412 99239 1 20 940 Laguna Honda Blvd   1 1 1   05/22/2012 12:00:00 AM     Permit Number 768814 5996167.3 2098870.1 37.7428775588654 -122.45589685275 (37.7428775588654, -122.45589685275)
90156 104503 2 20 157 ALBION ST   1 1 1     13 3x3   6005993.0 2106325.0 37.7639060282426 -122.422451867395 (37.7639060282426, -122.422451867395)
90159 104807 2 20 2069 GREEN ST   1 1 1           6003141.4 2118171.7 37.796272826569705 -122.433161198258 (37.7962728265697, -122.433161198258)
97552 108723 1 20 764 Arkansas St   1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773103 6013016.81056 2103494.00722 37.7565264696642 -122.39795984425301 (37.7565264696642, -122.397959844253)
104783 96999 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125835 97004 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
127139 108935 2 20 12X CAMP ST   1 1 1     12 3x3   6005858.0 2106413.0 37.764140038871396 -122.422925047265 (37.7641400388714, -122.422925047265)
66 222538 2 20 1 Newburg St 1 1 1 1     6 Width 2ft   6002556.19825 2099973.42317 37.746271638232 -122.43388469462201 (37.746271638232, -122.433884694622)
385 251282 3 20 1299x Hudson Ave 1 1 1 2 3 04/07/2016 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
392 251280 3 20 1275x Hudson Ave 1 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
420 54426 1 20 770 Carolina St 1 1 1 1   07/02/1973 12:00:00 AM 15 3x3 Permit Number 12242 6012397.0815 2104349.75534 37.758841631549394 -122.400163199892 (37.7588416315494, -122.400163199892)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
2997 246011 1 20 609 Ashbury St 1 1 1 1   08/09/1988 12:00:00 AM 8 Width 0ft Permit Number 25501 5998952.4081 2108635.9977 37.7698517546883 -122.446969376408 (37.7698517546883, -122.446969376408)
3320 56733 1 20 1583 McKinnon Ave 1 1 1 1     9   Permit Number 780681 6015469.0433 2095825.5988 37.7356068823061 -122.388943710821 (37.7356068823061, -122.388943710821)
4156 213178 1 20 629 Grafton Ave 1 1 1 1   10/06/2017 08:23:00 AM 3 Width 3ft Permit Number 20774 5994856.22066 2090552.89382 37.7199652039099 -122.45982783161502 (37.7199652039099, -122.459827831615)
4201 252891 2 20 300x Howth St 1 1 1 1   10/10/2017 04:13:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4212 204652 2 20 324 Howth St 1 1 1 1   10/10/2017 03:45:00 PM 3 Width 3ft   5997137.29551 2090290.56774 37.719375836806705 -122.45192406695601 (37.7193758368067, -122.451924066956)
4291 252895 2 20 790x Mount Vernon Ave 1 1 1 1   10/10/2017 03:29:00 PM 3 3x3   5997282.0 2090432.0 37.719772464034904 -122.45143407539 (37.7197724640349, -122.45143407539)
4444 24256 1 20 203 Willow St 1 1 1 1   03/15/2014 12:00:00 AM 3 2x3   6006439.8092 2113362.67149 37.783254981274204 -122.421406308981 (37.7832549812742, -122.421406308981)
4849 253684 2 20 767 Burrows St 1 1 1 1       3x3   6009074.0 2092682.0 37.7266186845557 -122.410831962563 (37.7266186845557, -122.410831962563)
5163 12318 1 20 999 Laguna St 1 1 1 1   06/18/1997 12:00:00 AM 6 4X4   6004783.3056 2112237.6551 37.7800724294036 -122.427056996678 (37.7800724294036, -122.427056996678)
5538 27609 1 20 2695 Sacramento St 1 1 1 1   09/22/2000 12:00:00 AM 3 3x3   6001941.56922 2115683.47507 37.7893726707572 -122.437134613375 (37.7893726707572, -122.437134613375)
5700 107235 2 20 786 Sutter St 1 1 1 1     2 3x3   6008834.66692 2115296.44284 37.788699385205796 -122.413257820814 (37.7886993852058, -122.413257820814)
5901 13142 1 20 1799 Lombard St 1 1 1 1   10/26/1993 12:00:00 AM 70 3X3   6003833.3629 2119660.0062 37.8003985594643 -122.43087313241999 (37.8003985594643, -122.43087313242)
7114 45767 1 20 99 Blake St 1 1 1 1 1 04/02/2002 12:00:00 AM 5 3x3 Permit Number 44690 5997811.6954 2113198.143 37.782312986330794 -122.45124412099399 (37.7823129863308, -122.451244120994)
7463 52815 1 20 2760 Broderick St 1 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 773616 6000112.35725 2118047.78661 37.7957603016641 -122.44363337348999 (37.7957603016641, -122.44363337349)
7980 12325 1 20 1015 Laguna St 1 1 1 1   06/25/1997 12:00:00 AM 6 4X4   6004759.9403 2112401.4167 37.7805207570776 -122.427149495677 (37.7805207570776, -122.427149495677)
8678 26493 1 20 519 Laguna St 1 1 1 1     6 3X3   6004978.6865 2110816.0585 37.776180120030205 -122.42627984394699 (37.7761801200302, -122.426279843947)
9115 90912 1 20 545 Cabrillo St 1 1 1 1   02/20/2008 12:00:00 AM 3 3x3   5993886.17439 2110710.21085 37.775256248873895 -122.464643860229 (37.7752562488739, -122.464643860229)
10007 99273 3 20 2825 Diamond St 1 1 1 2 2 02/01/2013 12:00:00 AM 3 3x3   6002499.0 2095479.8 37.733929944538204 -122.43376136145201 (37.7339299445382, -122.433761361452)
10112 5081 1 20 2562 Diamond St 1 1 1 1     14 3X3   6002249.017000001 2096934.71698 37.737910623162705 -122.434729631968 (37.7379106231627, -122.434729631968)
10145 173881 2 20 1245 Willard St 1 1 1 1       3x3   5996703.0 2107106.0 37.7655220059747 -122.45463943175601 (37.7655220059747, -122.454639431756)
10587 27191 1 20 270 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002970.12798 2093687.91706 37.729036562883 -122.43200461784299 (37.729036562883, -122.432004617843)
10609 27189 1 20 262 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002929.54622 2093714.9160799999 37.729108395319706 -122.432146839331 (37.7291083953197, -122.432146839331)
10667 26997 1 20 1231 Silver Ave 1 1 1 1   06/25/1999 12:00:00 AM 6 3X3   6008770.22229 2094084.7874099999 37.7304534015961 -122.41198120438801 (37.7304534015961, -122.411981204388)
10673 121353 2 20 1221 37th Ave 1 1 1 1   09/27/2016 12:00:00 AM 3 3x3   5984567.3281 2106871.8527 37.76417557031971 -122.496596073864 (37.7641755703197, -122.496596073864)
10695 27041 1 20 708 Silver Ave 1 1 1 1   05/26/1999 12:00:00 AM 7     6006055.4905900005 2093548.93813 37.728829392352 -122.42132839800199 (37.728829392352, -122.421328398002)
10716 27187 1 20 250 Silver Ave 1 1 1 1   11/25/2002 12:00:00 AM 6 2X3   6002862.24087 2093754.97277 37.7292145657007 -122.43238237894501 (37.7292145657007, -122.432382378945)
10789 27116 1 20 431 Silver Ave 1 1 1 1   11/28/2000 12:00:00 AM 3 3X3   6004280.51311 2093512.4294900002 37.7286289154695 -122.42746201715599 (37.7286289154695, -122.427462017156)
10826 27011 3 20 1468 Silver Ave 1 1 1 2   06/02/1999 12:00:00 AM 6 3X3   6010181.11487 2094586.49515 37.7319100425197 -122.407138874981 (37.7319100425197, -122.407138874981)
10845 27213 1 20 408 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 3X3   6003994.27009 2093465.08607 37.728482727073995 -122.428448202938 (37.728482727074, -122.428448202938)
10875 27118 1 20 488 Silver Ave 1 1 1 1   06/09/1999 12:00:00 AM 6 3X3   6004485.4929 2093473.96445 37.7285348904523 -122.426750651627 (37.7285348904523, -122.426750651627)
10969 26989 3 20 1327 Silver Ave 1 1 1 2   06/22/1999 12:00:00 AM 6 3X3   6009306.59459 2094318.78355 37.7311259838562 -122.41014339480101 (37.7311259838562, -122.410143394801)
10976 26998 3 20 1223 Silver Ave 1 1 1 2   06/25/1999 12:00:00 AM 6 3X3   6008728.29906 2094063.8664 37.7303936047791 -122.41212466153499 (37.7303936047791, -122.412124661535)
11022 27183 1 20 218 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2x3   6002694.31138 2093864.23527 37.729505052106795 -122.43297072801701 (37.7295050521068, -122.432970728017)
11300 26996 1 20 1239 Silver Ave 1 1 1 1   12/14/2000 12:00:00 AM 3 3X3   6008815.333330001 2094106.20179 37.730514731765396 -122.41182676109399 (37.7305147317654, -122.411826761094)
11427 27057 3 20 945 Silver Ave 1 1 1 2   06/25/1999 12:00:00 AM 7 2X3   6007415.89764 2093543.05958 37.72888985646029 -122.416624950003 (37.7288898564603, -122.416624950003)
11500 66889 1 20 562 Vienna St 1 1 1 1   12/06/1991 12:00:00 AM 8 3x3 Permit Number 30203 6003132.96801 2090225.04515 37.7195375196183 -122.43119459394899 (37.7195375196183, -122.431194593949)
11557 27528 3 20 1136 Silver Ave 1 1 1 2   11/25/2002 12:00:00 AM 3     6008310.55132 2093825.05625 37.729714434952506 -122.413551995327 (37.7297144349525, -122.413551995327)
11624 27194 1 20 302 Silver Ave 1 1 1 1   05/04/2001 12:00:00 AM 6 3X3   6003295.095930001 2093512.42424 37.7285731170511 -122.430868659863 (37.7285731170511, -122.430868659863)
11657 27033 1 20 1300X Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6009267.3963 2094255.34405 37.730949595331296 -122.410274433211 (37.7309495953313, -122.410274433211)
11744 27020 1 20 1495 Silver Ave 1 1 1 1   06/16/1999 12:00:00 AM 6 3X3   6010228.2725 2094648.6070599998 37.7320832276456 -122.40698021658399 (37.7320832276456, -122.406980216584)
11796 27192 1 20 284 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6003080.50306 2093615.49168 37.7288439559672 -122.431617874266 (37.7288439559672, -122.431617874266)
11914 27040 1 20 590 Silver Ave 1 1 1 1   05/26/1999 12:00:00 AM 6 3X3   6005314.150169999 2093510.97607 37.728683332565396 -122.423888566416 (37.7286833325654, -122.423888566416)
11918 27214 1 20 418 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 3X3   6004063.83311 2093462.31817 37.7284790632589 -122.428207522784 (37.7284790632589, -122.428207522784)
12081 27218 3 20 393 Silver Ave 1 1 1 2   08/10/1999 12:00:00 AM 6 3x3   6004009.64112 2093507.9183200002 37.728601204683706 -122.42839811609699 (37.7286012046837, -122.428398116097)
12154 26999 1 20 1200 Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6008714.80501 2094009.36438 37.7302431967539 -122.41216746208401 (37.7302431967539, -122.412167462084)
12164 27184 1 20 234 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2x3   6002780.32065 2093807.2617400002 37.7293534938515 -122.432669317552 (37.7293534938515, -122.432669317552)
12234 27239 1 20 267 Silver Ave 1 1 1 1   02/19/2004 12:00:00 AM 3 3X3   6002994.26296 2093731.2602 37.7291569416186 -122.431924275083 (37.7291569416186, -122.431924275083)
12304 27185 1 20 238 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002801.11945 2093793.8954 37.7293179724305 -122.43259645987101 (37.7293179724305, -122.432596459871)
12561 27049 1 20 910 Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3x3   6007348.52678 2093482.2197099999 37.7287190140661 -122.41685354777701 (37.7287190140661, -122.416853547777)
12570 27105 1 20 595 Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 3 3X3   6005329.57476 2093556.08719 37.728808068530796 -122.42383844898701 (37.7288080685308, -122.423838448987)
12660 27219 1 20 391 Silver Ave 1 1 1 1   08/10/1999 12:00:00 AM 6 3X3   6003983.54515 2093507.70675 37.728599147032 -122.428488316285 (37.728599147032, -122.428488316285)
12696 27224 1 20 367 Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 3 3X3   6003787.64028 2093509.2466099998 37.728592287005604 -122.429165680266 (37.7285922870056, -122.429165680266)
12742 27190 3 20 266 Silver Ave 1 1 1 2   06/08/1999 12:00:00 AM 6 2X3   6002951.03979 2093700.24177 37.729069321573604 -122.432071486902 (37.7290693215736, -122.432071486902)
12789 27012 1 20 1478 Silver Ave 1 1 1 1   07/13/1999 12:00:00 AM 6 3X3   6010237.54024 2094604.6047900002 37.731962925340206 -122.40694507558099 (37.7319629253402, -122.406945075581)
12957 27096 1 20 707 Silver Ave 1 1 1 1   03/17/2006 12:00:00 AM 3 3X3   6006037.723730001 2093592.8940700002 37.7289490840269 -122.42139293964199 (37.7289490840269, -122.421392939642)
12971 26990 1 20 1305 Silver Ave 1 1 1 1   06/22/1999 12:00:00 AM 6 3X3   6009240.62739 2094292.02443 37.731048811250794 -122.41036956712601 (37.7310488112508, -122.410369567126)
13026 27186 1 20 246 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2x3   6002844.3159300005 2093767.7045599998 37.729248507888606 -122.432445255941 (37.7292485078886, -122.432445255941)
13092 27221 1 20 385 Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 10 3x3   6003913.32371 2093508.9041799998 37.7285984608493 -122.428731161129 (37.7285984608493, -122.428731161129)
13190 27285 1 20 670 Silver Ave 1 1 1 1   05/26/1999 12:00:00 AM 3 3X3   6005819.54085 2093537.91486 37.728785819299105 -122.422143310586 (37.7287858192991, -122.422143310586)
13217 27037 1 20 1346 Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6009433.39606 2094313.9953700001 37.731119943119296 -122.409704680324 (37.7311199431193, -122.409704680324)
13269 187626 2 20 298x Molimo Dr 1 5 1 1       3x3   5997428.0 2096652.0 37.7368594694916 -122.451377782024 (37.7368594694916, -122.451377782024)
13949 27171 1 20 2206 Silver Ave 1 1 1 1   07/12/1999 12:00:00 AM 6 2X3   6012761.81609 2096197.8088200002 37.7364784617996 -122.398329801495 (37.7364784617996, -122.398329801495)
14213 25940 1 20 2018 Oakdale Ave 1 1 1 1   08/15/2000 12:00:00 AM 3 3x3   6012740.13667 2097232.43261 37.739318114344 -122.398477333477 (37.739318114344, -122.398477333477)
14432 27132 1 20 2009 Silver Ave 1 1 1 1   02/19/2004 12:00:00 AM 3 2X3   6012226.6815599995 2095938.3676200002 37.735736266604704 -122.40016178436501 (37.7357362666047, -122.400161784365)
14531 25952 1 20 2370 Oakdale Ave 1 1 1 1   04/22/1997 12:00:00 AM 3 3X3   6011712.98649 2098000.83737 37.7413707152901 -122.40208278929701 (37.7413707152901, -122.402082789297)
14877 27134 1 20 1941 Silver Ave 1 1 1 1   11/25/2002 12:00:00 AM 4 3X3   6011939.40312 2095757.43943 37.7352234533834 -122.401142314262 (37.7352234533834, -122.401142314262)
14967 27136 1 20 1909 Silver Ave 1 1 1 1   07/13/1999 12:00:00 AM 7 2X3   6011799.55776 2095649.995 37.734920630966 -122.40161826426599 (37.734920630966, -122.401618264266)
15540 27131 1 20 2015 Silver Ave 1 1 1 1   06/16/1999 12:00:00 AM 6 2X3   6012250.55523 2095951.9003599999 37.735774755805295 -122.400080193368 (37.7357747558053, -122.400080193368)
15602 101156 2 20 1490X 19th St 1 1 1 1     10 3x3   6013453.7614400005 2105247.5910900002 37.7613657542352 -122.39657162148501 (37.7613657542352, -122.396571621485)
15677 27163 3 20 1824 Silver Ave 1 1 1 2   06/02/1999 12:00:00 AM 6 3X3   6011556.81745 2095410.2686400001 37.734248844606206 -122.402440656527 (37.7342488446062, -122.402440656527)
16142 27165 1 20 1836 Silver Ave 1 1 1 1   06/02/1999 12:00:00 AM 6 3X3   6011599.21005 2095442.31315 37.7343391985891 -122.402296343211 (37.7343391985891, -122.402296343211)
16407 97995 2 20 1450 Mariposa St 1 1 1 1   03/09/2016 12:00:00 AM 3 3x3   6013004.40763 2106156.2643 37.7638357521307 -122.398189511757 (37.7638357521307, -122.398189511757)
17253 26483 3 20 148 Gold Mine Dr 1 1 1 2   05/29/2001 12:00:00 AM 10 3X3   6001028.50664 2098685.10655 37.7426474144589 -122.43907493846001 (37.7426474144589, -122.43907493846)
17274 22551 1 20 33 Topaz Way 1 1 1 1   06/03/1992 12:00:00 AM 20 2X3   6001555.699019999 2098568.2188 37.74235645138 -122.437243695762 (37.74235645138, -122.437243695762)
17603 10401 1 20 1360 Haight St 1 1 1 1     18 3X3   5999635.0074 2108810.0697 37.770368686739396 -122.44462080278 (37.7703686867394, -122.44462080278)
18107 4392 3 20 25 Chilton Ave 1 1 1 2     18 3X3   6001719.13999 2095716.38889 37.734535279584605 -122.43647449840799 (37.7345352795846, -122.436474498408)
18373 54772 1 20 1446 06th Ave 1 1 1 1   07/25/1972 12:00:00 AM   4x5 Permit Number 10621 5994307.43834186 2105670.05162948 37.7614415732371 -122.46282089526899 (37.7614415732371, -122.462820895269)
18758 4194 1 20 3870 Cesar Chavez St 1 1 1 1     12 3X3   6004745.48765 2100483.94122 37.7477973974515 -122.4263507348 (37.7477973974515, -122.4263507348)
19209 7446 1 20 2545 Folsom St 1 1 1 1     45 3X3   6008276.38457 2103575.68647 37.7564855903503 -122.414359757402 (37.7564855903503, -122.414359757402)
20005 9345 3 20 216 Gold Mine Dr 1 1 1 2   06/03/1992 12:00:00 AM 25 2X2   6000780.1302 2098439.42056 37.7419586830354 -122.439916138241 (37.7419586830354, -122.439916138241)
20085 4237 1 20 4018 Cesar Chavez St 1 1 1 1     6 3X3   6003765.90932 2100430.48709 37.747595203776 -122.429734255035 (37.747595203776, -122.429734255035)
21100 4336 3 20 870 Chenery St 1 1 1 2     18 3X3   6001641.12667 2095893.9772400002 37.7350184628259 -122.436756924204 (37.7350184628259, -122.436756924204)
21278 3458 1 20 58 Cameo Way 1 1 1 1   06/08/1992 12:00:00 AM 20 3X3   5999628.35603 2099484.01235 37.7447612502235 -122.443973626603 (37.7447612502235, -122.443973626603)
21641 22552 1 20 39 Topaz Way 1 1 1 1   06/03/1992 12:00:00 AM 20 2x3   6001599.33681 2098534.06318 37.7422651486201 -122.43709036493 (37.7422651486201, -122.43709036493)
21739 22825 1 20 80 Turquoise Way 1 1 1 1   01/04/1993 12:00:00 AM 25 3X3   5999298.50958 2099073.67343 37.7436157369876 -122.44508467424299 (37.7436157369876, -122.445084674243)
23127 27661 3 20 2211 Silver Ave 1 1 1 2   12/14/2000 12:00:00 AM 6 3X3   6012766.85578 2096252.7885099999 37.7366297052834 -122.398316233412 (37.7366297052834, -122.398316233412)
23457 221362 2 20 1301 Douglass St 1 1 1 1     1 Width 3ft   6001384.01408 2099859.31671 37.7458917403255 -122.437929785824 (37.7458917403255, -122.437929785824)
24046 222589 2 20 4384 17th St 1 1 1 1     4 Width 3ft   6000100.50643 2105785.88471 37.762091580878604 -122.44279345615601 (37.7620915808786, -122.442793456156)
Powered by Datasette · Query took 6.393ms · Data source: data.sfgov.org