sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
119063 86884 1 70 2534 46th Ave   1 1 1   10/23/2007 12:00:00 AM   3x3 Permit Number 49809 5982151.4 2097835.7 37.73922299278121 -122.504282496051 (37.7392229927812, -122.504282496051)
129485 97033 7 70 61 Vicksburg St   13 1 1         Possible significant tree; Nellie RoW; rear yard 6004120.0 2102703.0 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406)
144315 88208 1 70 607 Central Ave   1 1 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51212 5999619.0 2110591.2 37.775258305073 -122.444804221322 (37.775258305073, -122.444804221322)
28352 125438 2 70 250 Euclid Ave 0 7 1 1     15     5998091.24108 2114006.2469099998 37.78454782955 -122.45033529224199 (37.78454782955, -122.450335292242)
53096 125439 2 70 99 Collins St 0 17 1 1     7     5998117.25486 2114050.06951 37.7846696436241 -122.450248453727 (37.7846696436241, -122.450248453727)
1099 250070 3 70 399 Austin St 1 4 1 2     2 Width 3ft   6005393.47416 2115303.0126799997 37.788523627097 -122.425164323999 (37.788523627097, -122.425164323999)
1850 251747 2 70 706 Rolph St 1 1 1 1       3x3   6002959.0 2087321.0 37.7115537887528 -122.431588720074 (37.7115537887528, -122.431588720074)
5093 18924 1 70 2675 Sacramento St 1 1 1 1   05/14/2013 12:00:00 AM 3 4x4 Permit Number 770153 6002021.65815 2115693.95851 37.7894060077371 -122.43685826610701 (37.7894060077371, -122.436858266107)
7189 111999 2 70 2414 Webster St 1 1 1 1   09/04/2015 12:00:00 AM 24 4x4 Permit Number 776155 6003178.791259999 2117077.11494 37.793269498846705 -122.432953577047 (37.7932694988467, -122.432953577047)
7458 18926 3 70 2689 Sacramento St 1 1 1 2     6 3X3   6001985.03027 2115691.49541 37.7893971628975 -122.43698481780599 (37.7893971628975, -122.436984817806)
8942 19287 1 70 2810X Sacramento St 1 1 1 1     12 3x3   6001358.59585 2115648.89401 37.7892445650455 -122.439149150528 (37.7892445650455, -122.439149150528)
11199 79973 1 70 983 Cayuga Ave 1 1 1 1 1 12/24/2014 12:00:00 AM 3   Permit Number 773711 6000743.92966 2091299.8612400002 37.722353046939 -122.439529617696 (37.722353046939, -122.439529617696)
11423 110030 1 70 327 Edinburgh St 1 1 1 1 1 03/19/2015 12:00:00 AM 3 3x3 Permit Number 774319 6003526.63098 2091782.5181900002 37.7238362969822 -122.429944883475 (37.7238362969822, -122.429944883475)
14649 67492 1 70 1119 Kansas St 1 1 1 1 1 03/28/2015 12:00:00 AM 3   Permit Number 774343 6011679.29477 2103189.50582 37.7556157939465 -122.40256406509701 (37.7556157939465, -122.402564065097)
17640 4490 3 70 1602 Church St 1 1 1 2   01/30/2002 12:00:00 AM 3 3X3   6004561.8284 2099527.9975 37.7451622129677 -122.426917747467 (37.7451622129677, -122.426917747467)
18805 27714 3 70 5587 Diamond Heights Blvd 1 1 1 2     3 3X3   6001610.45471 2097108.7336400002 37.7383521588292 -122.436949905209 (37.7383521588292, -122.436949905209)
19541 31130 1 70 127 Foerster St 1 1 1 1 1 03/21/1995 12:00:00 AM 2 3x3 Permit Number 34845 5998083.60465 2093967.1558599998 37.729525044927705 -122.448917737661 (37.7295250449277, -122.448917737661)
20258 50073 1 70 2622 16th Ave 1 1 1 1 1 07/28/2003 12:00:00 AM     Permit Number 46804 5991453.86395603 2097563.96514649 37.739019597898505 -122.472099259809 (37.7390195978985, -122.472099259809)
22560 7122 1 70 300X Fern St 1 1 1 1   01/28/2003 12:00:00 AM 3 3x3   6005816.457909999 2115038.11546 37.787820171109 -122.423682021812 (37.787820171109, -122.423682021812)
22608 9889 3 70 1700 Gough St 1 1 1 2     24 3X3   6005347.08674 2115527.81747 37.78913826426621 -122.425340821331 (37.7891382642662, -122.425340821331)
22690 28059 1 70 399X Fern St 1 1 1 1   01/28/2003 12:00:00 AM 3 3X3   6005443.48959 2114960.28563 37.7875854093804 -122.42496688413 (37.7875854093804, -122.42496688413)
22809 125505 2 70 45 Havens St 1 9 1 1     11     6007613.99229 2119386.63886 37.799861442220895 -122.41777122496 (37.7998614422209, -122.41777122496)
23721 220632 2 70 18 Kronquist Ct 1 9 1 1     5 Width 1ft   6002213.33941 2100174.25358 37.746803608795396 -122.43508461868299 (37.7468036087954, -122.435084618683)
24227 203475 2 70 2357 16th Ave 1 2 1 1     8 Width 3ft   5991280.398630001 2099387.14513 37.7440155431828 -122.472831922275 (37.7440155431828, -122.472831922275)
24395 92752 1 70 3356 Baker St 1 1 1 1   10/07/2009 12:00:00 AM 4 3x3 Permit Number 52980 5999300.27951 2120375.08626 37.8021040941904 -122.446610827352 (37.8021040941904, -122.446610827352)
24633 220637 2 70 79 Bemis St 1 1 1 1     7 Width 3ft   6003700.73164 2096802.6587900002 37.7376303323698 -122.429700927958 (37.7376303323698, -122.429700927958)
25297 203469 2 70 300 Flood Ave 1 9 1 1     3     5998711.4385400005 2094111.50955 37.7299572914866 -122.446757644361 (37.7299572914866, -122.446757644361)
25528 33293 1 70 166 Sproule Ln 1 1 1 1 1 11/14/1996 12:00:00 AM 10   Permit Number 37451 6009221.08576 2116982.79677 37.7933513902069 -122.412040085683 (37.7933513902069, -122.412040085683)
26515 220605 2 70 51 Arnold Ave 1 1 1 1     3 Width 2ft   6006588.43416 2095556.2784900002 37.7343711416034 -122.419628336682 (37.7343711416034, -122.419628336682)
27160 203449 2 70 1474 Funston Ave 1 1 1 1     10 Width 3ft   5992141.42239 2105406.9692 37.7605942249661 -122.47029301742901 (37.7605942249661, -122.470293017429)
27258 220664 2 70 1192 Sanchez St 1 1 1 1     10 Width 3ft   6003819.11819 2101351.9934400003 37.7501284581809 -122.429615973494 (37.7501284581809, -122.429615973494)
27386 220596 2 70 452 Shotwell St 1 4 1 1     4 Width 3ft   6007814.59662 2105186.38117 37.7608822364448 -122.416070852512 (37.7608822364448, -122.416070852512)
28260 92446 1 70 1554 46th Ave 1 1 1 1 1 07/30/2009 12:00:00 AM 4 3x3 Permit Number 52837 5981923.4 2104509.6 37.7575342433798 -122.505565385243 (37.7575342433798, -122.505565385243)
28571 203474 2 70 663 16th Ave 1 1 1 1     11 Width 3ft   5991409.42461 2097303.39162 37.7383015575699 -122.472233919881 (37.7383015575699, -122.472233919881)
29119 220589 2 70 653 Duncan St 1 10 1 1     1 Width 2ft   6002332.20411 2099716.00641 37.7455521185496 -122.43464083471301 (37.7455521185496, -122.434640834713)
31097 123452 2 70 735 02nd Ave 1 1 1 1     1 Width 3ft   5995332.97895 2110593.9249 37.7750202604257 -122.459630642924 (37.7750202604257, -122.459630642924)
31567 203453 2 70 2658 16th Ave 1 1 1 1     4 Width 3ft   5991457.8354 2097316.5348 37.738340446961104 -122.47206749851001 (37.7383404469611, -122.47206749851)
31786 221763 2 70 3816 21st St 1 1 1 1     7 Width 3ft   6002948.3546400005 2103602.92928 37.7562596509731 -122.432787903054 (37.7562596509731, -122.432787903054)
31906 220602 2 70 345 Valley St 1 1 1 1     8 Width 2ft   6003653.16044 2099206.97915 37.744229349819896 -122.43003686791401 (37.7442293498199, -122.430036867914)
32542 221762 2 70 4407 20th St 1 1 1 1     8 Width 3ft   6001705.956180001 2104074.38405 37.7574836102927 -122.43711828977399 (37.7574836102927, -122.437118289774)
33240 189153 2 70 2 Shipley St 1 4 1 1     6 Width 3ft   6012332.534469999 2112551.48713 37.781358134807796 -122.400962694499 (37.7813581348078, -122.400962694499)
33358 220588 2 70 1285 Hampshire St 1 1 1 1     15 Width 3ft   6010337.44954 2101779.52105 37.7516692837277 -122.40710522684499 (37.7516692837277, -122.407105226845)
33827 203454 2 70 5 Madrone Ave 1 1 1 1     6 Width 3ft   5993011.06637 2099068.7919400004 37.743241463417796 -122.466824576891 (37.7432414634178, -122.466824576891)
33839 220603 2 70 418 Valley St 1 1 1 1     13 Width 2ft   6003167.3476 2099231.48151 37.744269101647795 -122.43171845176501 (37.7442691016478, -122.431718451765)
33859 220622 2 70 58 Fountain St 1 10 1 1     4 Width 3ft   6000334.98133 2101342.05017 37.7499032598351 -122.441663574927 (37.7499032598351, -122.441663574927)
36849 220592 2 70 1383 Natoma St 1 1 1 1     5 Width 2ft   6007189.08287 2107465.79435 37.76710578333971 -122.418395859874 (37.7671057833397, -122.418395859874)
37156 189173 2 70 1960 Quesada Ave 1 4 1 1     4 Width 2ft   6013345.84088 2096070.7044 37.73616197508429 -122.396301660307 (37.7361619750843, -122.396301660307)
37791 220646 2 70 816 Crescent Ave 1 1 1 1     7 Width 3ft   6008205.0189 2095636.66757 37.7346828016745 -122.41404494431801 (37.7346828016745, -122.414044944318)
38930 220655 2 70 580 Ogden Ave 1 1 1 1     9 Width 3ft   6008083.69599 2096082.2563599998 37.735899476465704 -122.41449592016599 (37.7358994764657, -122.414495920166)
40602 203478 2 70 2453 Funston Ave 1 1 1 1     7 Width 3ft   5992323.79318 2098755.04508 37.74234030496479 -122.469178135975 (37.7423403049648, -122.469178135975)
41654 125506 2 70 7 Fallon Pl 1 9 1 1     8 Width 4ft   6008920.97468 2118571.47788 37.7976966751291 -122.413190886946 (37.7976966751291, -122.413190886946)
41684 203490 2 70 29 Joost Ave 1 1 1 1     4 Width 3ft   6001874.24208 2094906.2061700001 37.7323195164307 -122.43588030914302 (37.7323195164307, -122.435880309143)
43148 32487 1 70 257 States St 1 1 1 1 1 10/10/1996 12:00:00 AM 5   Permit Number 36994 6000562.081590001 2106647.6707099997 37.7644841354656 -122.441258885382 (37.7644841354656, -122.441258885382)
43773 189175 2 70 1 Anthony St 1 2 1 1     1 Width 5ft   6012666.59913 2115298.5353200003 37.788919518565706 -122.39999995672599 (37.7889195185657, -122.399999956726)
43939 203498 2 70 234 Flood Ave 1 1 1 1     4 Width 3ft   5999190.87551 2094097.9228400001 37.72994736206179 -122.445099202768 (37.7299473620618, -122.445099202768)
43952 221766 2 70 712 Waller St 1 1 1 1     2 Width 3ft   6002158.80169 2108813.78872 37.770522589268204 -122.43589127638799 (37.7705225892682, -122.435891276388)
44045 221755 2 70 14 Vicksburg St 1 1 1 1     12 Width 5ft   6004062.6885 2102905.39693 37.7544075287057 -122.42888442629601 (37.7544075287057, -122.428884426296)
44557 119343 2 70 462 32nd Ave 1 1 1 1     2 Width 3ft   5985960.41468 2112779.42827 37.7804776215792 -122.49221287963199 (37.7804776215792, -122.492212879632)
44628 220614 2 70 2979 21st St 1 1 1 1     1 Width 3ft   6008369.0064199995 2103859.12249 37.757269043737395 -122.414059488154 (37.7572690437374, -122.414059488154)
45092 64967 1 70 1671 Filbert St 1 1 1 1 1 09/25/2013 12:00:00 AM 3   Permit Number 770626 6004948.17442 2119151.63157 37.799065794014396 -122.42697920982201 (37.7990657940144, -122.426979209822)
46074 221767 2 70 287 Hermann St 1 9 1 1     7 Width 3ft   6003902.82897 2108654.79623 37.770184952298 -122.429847331292 (37.770184952298, -122.429847331292)
46755 37601 1 70 781 11th Ave 1 1 1 1 1 06/26/1998 12:00:00 AM 11 6x9 Permit Number 40028 5992556.63358 2110168.87379 37.7736931455181 -122.469203595419 (37.7736931455181, -122.469203595419)
46865 249820 2 70 281 Kearny St 1 7 1 1     13 Width 0ft   6010902.80513 2120614.31353 37.8034168633488 -122.40647720057301 (37.8034168633488, -122.406477200573)
47327 201923 2 70 125 Elmira St 1 4 1 1     13 Width 4ft   6011215.48386 2096005.8192 37.735865039640395 -122.403662651736 (37.7358650396404, -122.403662651736)
48805 220628 2 70 907 Elizabeth St 1 9 1 1     8 Width 4ft   6000553.10276 2101957.71166 37.751606143208 -122.44095346395201 (37.751606143208, -122.440953463952)
48809 125436 2 70 3157 Steiner St 1 1 1 1     6 Width 3ft   6001892.570830001 2119015.7946 37.798519569189 -122.437542875929 (37.798519569189, -122.437542875929)
48850 246960 2 70 2177 15th St 1 4 1 1     2 Width 3ft   6003038.46952 2107086.92585 37.7658309772437 -122.432725124067 (37.7658309772437, -122.432725124067)
49140 175171 2 70 399 Vienna St 1 9 1 1     3 Width 3ft   6003766.2619199995 2091125.7997700002 37.7220466613948 -122.429069717203 (37.7220466613948, -122.429069717203)
49472 41212 1 70 3676 Fillmore St 1 1 1 1 1 11/29/1999 12:00:00 AM 6   Permit Number 41921 6002149.73701 2121055.69726 37.804135222937 -122.43679910691002 (37.804135222937, -122.43679910691)
49575 123145 2 70 562 10th Ave 1 1 1 1     1 Width 3ft   5992857.65671 2111637.4840599997 37.7777429430313 -122.468269178657 (37.7777429430313, -122.468269178657)
49765 94178 1 70 1379 Kansas St 1 1 1 1   06/22/2010 12:00:00 AM 5 3x3 Permit Number 53590 6011748.15969 2101956.8719099998 37.752235095787704 -122.402239247057 (37.7522350957877, -122.402239247057)
49806 221764 2 70 3809 16th St 1 9 1 1     2 Width 2ft   6001727.44948 2106346.3994299998 37.7637232334694 -122.437206631108 (37.7637232334694, -122.437206631108)
50288 220659 2 70 998 Alabama St 1 1 1 1     6 Width 3ft   6009137.788819999 2103468.55533 37.756239784053996 -122.41137313676799 (37.756239784054, -122.411373136768)
50380 189181 2 70 40 Bluxome St 1 1 1 1     17 Width 2ft   6013494.8789800005 2110935.49205 37.7769857497279 -122.39682819267901 (37.7769857497279, -122.396828192679)
50442 220612 2 70 9 Bradford St 1 1 1 1     6 Width 4ft   6009640.52107 2098655.41337 37.743052146240295 -122.409294863773 (37.7430521462403, -122.409294863773)
50704 35721 1 70 556 Bowdoin St 1 1 1 1 1 04/13/1998 12:00:00 AM 10   Permit Number 39004 6008810.28905 2093458.06001 37.728734789961706 -122.411798418969 (37.7287347899617, -122.411798418969)
50982 220615 2 70 3117 20th St 1 1 1 1     4 Width 3ft   6009011.326230001 2104478.69915 37.75900631630999 -122.411881867955 (37.75900631631, -122.411881867955)
51714 125450 2 70 44 Normandie Ter 1 9 1 1     7 Width 3ft   6000949.24806 2117425.20451 37.79409854965171 -122.44069290604999 (37.7940985496517, -122.44069290605)
53779 120025 2 70 743 28th Ave 1 1 1 1     1 Width 4ft   5987224.82866 2110876.6376900002 37.775326931785294 -122.487698901899 (37.7753269317853, -122.487698901899)
54337 175154 2 70 229 Delano Ave 1 9 1 1     1 Width 4ft   6000079.77144 2092298.5573 37.7250574153596 -122.44189709559299 (37.7250574153596, -122.441897095593)
54933 203443 2 70 1 Marne Ave 1 9 1 1     1 Width 2ft   5995223.6819 2097798.00617 37.7398796519151 -122.459081986971 (37.7398796519151, -122.459081986971)
55795 189170 2 70 360 Texas St 1 10 1 1     10 Width 3ft   6013732.7365 2105419.1930299997 37.761852457439495 -122.395618779897 (37.7618524574395, -122.395618779897)
56342 125442 2 70 3719 Scott St 1 4 1 1     1 Width 3ft   6000612.64349 2121133.3219999997 37.8042608824853 -122.442123892024 (37.8042608824853, -122.442123892024)
56741 220619 2 70 618 28th St 1 9 1 1     11     6001863.58646 2099454.0588599998 37.744806257700205 -122.43624249671801 (37.7448062577002, -122.436242496718)
57215 175165 2 70 218 Congdon St 1 1 1 1     4 Width 3ft   6004671.92277 2094015.32561 37.730031886663 -122.42614467765 (37.730031886663, -122.42614467765)
57484 221751 2 70 4000 25th St 1 1 1 1     7 Width 3ft   6003801.92979 2101310.951 37.750014791971104 -122.429672485102 (37.7500147919711, -122.429672485102)
58297 220644 2 70 16 Bronte St 1 1 1 1     20 Width 3ft   6009354.03531 2097334.2588400003 37.7394084890188 -122.410192201918 (37.7394084890188, -122.410192201918)
58353 125529 2 70 11 Miller Pl 1 1 1 1     6 Width 2ft   6010076.61244 2116904.10673 37.793183289838 -122.40907433472 (37.793183289838, -122.40907433472)
58639 203477 2 70 2331 18th Ave 1 1 1 1     1 Width 3ft   5990713.76496 2099522.32344 37.7443538888309 -122.47480105801701 (37.7443538888309, -122.474801058017)
59975 220649 2 70 41 Stoneman St 1 1 1 1     11 Width 3ft   6008103.651880001 2099402.16609 37.7450163384242 -122.414661792014 (37.7450163384242, -122.414661792014)
60321 203473 2 70 128 Howth St 1 4 1 1     10 Width 3ft   5997584.72507 2091125.26044 37.7216933258806 -122.450437617121 (37.7216933258806, -122.450437617121)
63040 249939 2 70 331 Filbert St 1 7 1 1     7 Width 0ft   6011281.55151 2120038.154 37.801856051265204 -122.40512593233 (37.8018560512652, -122.40512593233)
63274 203472 2 70 126 Howth St 1 4 1 1     5 Width 3ft   5997592.47815 2091138.0222 37.721728810427706 -122.450411736413 (37.7217288104277, -122.450411736413)
63403 221758 2 70 4515 20th St 1 1 1 1     2 Width 3ft   6001348.5727699995 2104052.2530799997 37.757402522937 -122.438352676761 (37.757402522937, -122.438352676761)
63596 220634 2 70 628 Chenery St 1 1 1 1     13 Width 3ft   6002844.7092 2095716.3109400002 37.7345989605548 -122.432583028494 (37.7345989605548, -122.432583028494)
64345 35678 1 70 373 26th Ave 1 1 1 1   06/08/1998 12:00:00 AM 3   Permit Number 39754 5987751.633830001 2113488.06207 37.7825278787916 -122.486068320452 (37.7825278787916, -122.486068320452)
64363 248092 2 70 8 Brewster St 1 1 1 1     3 Width 2ft   6010451.32651 2099884.28332 37.7464717490664 -122.40657788235701 (37.7464717490664, -122.406577882357)
64810 220647 2 70 157 Bonview St 1 1 1 1     10 Width 3ft   6007230.99534 2098247.75396 37.7417975128515 -122.41759748493999 (37.7417975128515, -122.41759748494)
65098 92415 1 70 1507 37th Ave 1 1 1 1 1 07/29/2009 12:00:00 AM 0 3x3 Permit Number 52808 5984617.9 2104898.8 37.758761083263 -122.49627557459499 (37.758761083263, -122.496275574595)
65581 35740 1 70 9 Princeton St 1 1 1 1 1 03/18/2000 12:00:00 AM 12   Permit Number 39014 6007525.01662 2093953.7328599999 37.7300236128799 -122.416276791867 (37.7300236128799, -122.416276791867)
65850 92445 1 70 2646 45th Ave 1 1 1 1 1 07/30/2009 12:00:00 AM 5 3x3 Permit Number 52836 5982487.2 2097095.3 37.737209800771296 -122.503066669454 (37.7372098007713, -122.503066669454)
Powered by Datasette · Query took 7.678ms · Data source: data.sfgov.org