sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
358 251286 3 20 1299x Hudson Ave 7 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
375 251284 3 20 1299x Hudson Ave 5 1 1 2 3 06/21/1996 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
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)
398 251281 3 20 1275x Hudson Ave 4 1 1 2 3 03/23/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
402 251283 3 20 1299x Hudson Ave 9 1 1 2 3 06/06/1997 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
410 251287 3 20 1299x Hudson Ave 8 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
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)
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)
4203 252894 2 20 300x Howth St 4 1 1 1   10/10/2017 04:10:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4213 252892 2 20 300x Howth St 2 1 1 1   10/10/2017 04:08:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4246 252893 2 20 300x Howth St 3 1 1 1   10/10/2017 04:25:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
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)
4849 253684 2 20 767 Burrows St 1 1 1 1       3x3   6009074.0 2092682.0 37.7266186845557 -122.410831962563 (37.7266186845557, -122.410831962563)
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)
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)
7399 45765 1 20 99 Blake St 2 1 1 1   04/02/2002 12:00:00 AM 5 3x3 Permit Number 44690 5997815.0796 2113173.4382 37.782245347199996 -122.451230630986 (37.7822453472, -122.451230630986)
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)
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)
10145 173881 2 20 1245 Willard St 1 1 1 1       3x3   5996703.0 2107106.0 37.7655220059747 -122.45463943175601 (37.7655220059747, -122.454639431756)
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)
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)
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)
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)
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)
13269 187626 2 20 298x Molimo Dr 1 5 1 1       3x3   5997428.0 2096652.0 37.7368594694916 -122.451377782024 (37.7368594694916, -122.451377782024)
13750 96932 3 20 901 Bay Shore Blvd 2 1 1 1     3 3x3   6011002.04218 2094782.5630700001 37.732494311353506 -122.404314536086 (37.7324943113535, -122.404314536086)
13770 96936 2 20 901 Bay Shore Blvd 6 1 1 1     3 3x3   6010967.89306 2094873.35668 37.732741703157394 -122.404438986978 (37.7327417031574, -122.404438986978)
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)
14841 96934 2 20 901 Bay Shore Blvd 4 1 1 1     3 3x3   6010990.76512 2094811.6628299998 37.7325735829947 -122.404355571269 (37.7325735829947, -122.404355571269)
14985 97996 2 20 1450 Mariposa St 2 1 1 1     3 3x3   6012957.391559999 2106153.16264 37.7638246167349 -122.398351909517 (37.7638246167349, -122.398351909517)
15120 101159 2 20 1490X 19th St 4 1 1 1     12 3x3   6013387.24003 2105243.87751 37.7613518552239 -122.39680143245701 (37.7613518552239, -122.396801432457)
15147 96937 2 20 901 Bay Shore Blvd 7 1 1 1     3 3x3   6010960.45235 2094890.17175 37.732787457976706 -122.40446589470699 (37.7327874579767, -122.404465894707)
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)
16389 96935 2 20 901 Bay Shore Blvd 5 1 1 1     3 3x3   6010973.7505 2094855.21788 37.7326922251695 -122.404417459925 (37.7326922251695, -122.404417459925)
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)
16570 96933 3 20 901 Bay Shore Blvd 3 1 1 1     3 3x3   6010997.56747 2094792.1485099997 37.7325203809043 -122.40433068074101 (37.7325203809043, -122.404330680741)
17300 30745 3 20 486X Page St 6 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004274.8073 2109806.6859 37.773368818647 -122.42864278458 (37.773368818647, -122.42864278458)
17361 30744 3 20 380 Webster St 4 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004178.56485 2109886.0183099997 37.7735811988523 -122.428981357915 (37.7735811988523, -122.428981357915)
18822 30746 3 20 490X Page St 7 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004256.1031 2109802.2559 37.7733555963905 -122.42870716917601 (37.7733555963905, -122.428707169176)
19179 96019 1 20 810 Jones St 4 1 1 1 1 09/02/2011 12:00:00 AM   3x3 Permit Number 767661 6008769.0 2115301.0 37.7887082111555 -122.413485341988 (37.7887082111555, -122.413485341988)
20531 30747 3 20 496X Page St 8 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004231.9845 2109799.7949 37.77334747404829 -122.42879042330799 (37.7733474740483, -122.428790423308)
21303 30742 3 20 380 Webster St 3 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004180.58298 2109863.27384 37.7735188623338 -122.428972754992 (37.7735188623338, -122.428972754992)
36944 88065 1 20 2055 Silver Ave 10 1 1 1   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51066 6012481.79699 2096085.11316 37.7361534207291 -122.399290043599 (37.7361534207291, -122.399290043599)
45600 57691 1 20 120 Conrad St 1 1 1 1   12/13/1976 12:00:00 AM 8 3x3 Permit Number 16595 6001759.0 2096663.0 37.7371367196384 -122.436404416578 (37.7371367196384, -122.436404416578)
45681 49816 1 20 824 Carolina St 1 1 1 1 1 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46737 6012410.64537 2104168.1082 37.758343624767605 -122.400103532548 (37.7583436247676, -122.400103532548)
50384 43896 1 20 716 Tehama St 1 1 1 1   07/21/2008 12:00:00 AM 6 3x3 Permit Number 51474 6009227.05246 2110468.55015 37.7754651643179 -122.411558979885 (37.7754651643179, -122.411558979885)
54695 52371 1 20 970JONES Bush St 1 1 1 1 1 12/14/2005 12:00:00 AM 6 3x3 Permit Number 48503 6008855.4568 2115649.67517 37.78967044259821 -122.41321087889901 (37.7896704425982, -122.413210878899)
55954 49814 1 20 824 Carolina St 3 1 1 1   06/11/2003 12:00:00 AM 3 3x3 Permit Number 46606 6012411.85736 2104145.59448 37.758281874620295 -122.400097759826 (37.7582818746203, -122.400097759826)
72565 116874 1 20 824 Carolina St 4 1 1 1     10 3x3   6012413.67241 2104134.33813 37.7582510683591 -122.400090692038 (37.7582510683591, -122.400090692038)
74849 49815 1 20 824 Carolina St 2 1 1 1   07/25/2003 12:00:00 AM 11 3x3 Permit Number 46737 6012411.853019999 2104156.1373900003 37.7583108228906 -122.40009851524599 (37.7583108228906, -122.400098515246)
79995 109185 2 20 198x JUDSON AVE 1 1 1 1       3x3   5998796.0 2093546.0 37.7284093651166 -122.446424638984 (37.7284093651166, -122.446424638984)
80689 106706 2 20 199X BRIGHTON AVE 2 1 1 1     10 3x3   5996224.0 2090880.0 37.7209419254054 -122.455123542447 (37.7209419254054, -122.455123542447)
81603 96837 2 20 190 Bradford St 1 1 1 1     5 3x3   6009513.0 2097465.0 37.7397763850106 -122.40965179524099 (37.7397763850106, -122.409651795241)
81716 116348 2 20 4051X 24TH ST 2 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
83690 57741 1 20 112 Conrad St 1 1 1 1   12/29/1976 12:00:00 AM 10 3x3 Permit Number 16659 6001762.0 2096689.0 37.7372082800729 -122.436395904515 (37.7372082800729, -122.436395904515)
84733 116949 2 20 123 WEST PORTAL AVE 2 1 1 1       3x3   5992936.0 2097647.0 37.7393332491746 -122.46698079132099 (37.7393332491746, -122.466980791321)
84820 103510 2 20 100X Leroy Pl 4 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
85326 106091 3 20 1200 HUDSON AVE 12 1 1 2     8 3x3   6017390.0 2095089.0 37.733690618402704 -122.382250932174 (37.7336906184027, -122.382250932174)
86916 30739 3 20 490X Page St 3 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
87473 121683 2 20 1645 07th Ave 2 1 1 1       3x3   5993978.0 2104308.0 37.757682752419896 -122.46386140871401 (37.7576827524199, -122.463861408714)
87700 100152 2 20 500X Noe St 2 1 1 1     8 3x3   6002933.4 2105264.1 37.760819979332105 -122.432958296422 (37.7608199793321, -122.432958296422)
87901 94146 1 20 1715 11th Ave 1 1 1 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53554 5992756.7 2103771.7 37.7561397565087 -122.468046118338 (37.7561397565087, -122.468046118338)
88418 109186 2 20 198x JUDSON AVE 2 1 1 1       3x3   5998796.0 2093546.0 37.7284093651166 -122.446424638984 (37.7284093651166, -122.446424638984)
89141 30743 3 20 490X Page St 5 1 1 4 2 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
90156 104503 2 20 157 ALBION ST   1 1 1     13 3x3   6005993.0 2106325.0 37.7639060282426 -122.422451867395 (37.7639060282426, -122.422451867395)
90638 111230 2 20 1113 SCOTT ST 3 1 1 1       3x3   6001842.0 2112262.0 37.779972512780105 -122.4372340286 (37.7799725127801, -122.4372340286)
90810 49467 1 20 3624 20th St 1 1 1 1 1 08/09/2003 12:00:00 AM 4 3x3 Permit Number 46393 6006125.2277224995 2104366.11259234 37.7585348409416 -122.421855375902 (37.7585348409416, -122.421855375902)
91224 96020 1 20 810 Jones St 5 1 1 1 1 09/02/2011 12:00:00 AM   3x3 Permit Number 767661 6008769.0 2115301.0 37.7887082111555 -122.413485341988 (37.7887082111555, -122.413485341988)
91508 82031 1 20 471 Mangels Ave 1 1 1 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49837 5998319.05661716 2095227.73962292 37.7329997723608 -122.448194494208 (37.7329997723608, -122.448194494208)
92027 103511 2 20 100X Leroy Pl 5 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
92630 112551 2 20 26 HIDALGO TER 1 1 1 1     15 3x3   6004993.0 2107524.0 37.7671417328885 -122.425995926974 (37.7671417328885, -122.425995926974)
92699 97048 2 20 1590X Shafter Ave 3 1 1 1     8 3x3   6014988.7 2094146.3 37.7309692313217 -122.39048715342 (37.7309692313217, -122.39048715342)
93238 96931 3 20 901 Bay Shore Blvd 1 1 1 1     3 3x3   6010934.9 2094931.8 37.7329003323541 -122.404557165415 (37.7329003323541, -122.404557165415)
93454 108730 1 20 1822-1898X 23rd St 2 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773105 6013006.0 2102886.0 37.7548564119513 -122.39795458116001 (37.7548564119513, -122.39795458116)
93655 97046 2 20 1590X SHAFTER AVE 1 1 1 1     12 3x3   6014988.0 2094146.0 37.7309683687499 -122.390489552503 (37.7309683687499, -122.390489552503)
93939 116353 2 20 4051X 24TH ST 7 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
95927 114570 2 20 366 MISSISSIPPI ST 1 1 1 1       3x3   6014008.0 2105399.0 37.7618123194661 -122.394665331171 (37.7618123194661, -122.394665331171)
95994 95534 1 20 3725 23rd St 1 1 1 1 1 03/02/2011 12:00:00 AM   3x3 Permit Number 767323 6004904.0 2102501.0 37.7533447323081 -122.425946167651 (37.7533447323081, -122.425946167651)
96727 96840 2 20 180 Bradford St 1 1 1 1     5 3x3   6009512.0 2097540.0 37.739982262694 -122.409660545137 (37.739982262694, -122.409660545137)
96902 98541 2 20 4016 18th St 1 1 1 1       3x3   6002873.0 2105350.0 37.76105241392221 -122.433173330823 (37.7610524139222, -122.433173330823)
97484 104505 2 20 157163 ALBION ST 2 1 1 1     5 3x3   6005993.0 2106325.0 37.7639060282426 -122.422451867395 (37.7639060282426, -122.422451867395)
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)
98722 48359 1 20 1400X Lyon St 1 1 1 1   07/17/2002 12:00:00 AM 7 3x3 Permit Number 45770 6005451.0 2114476.0 37.78625610570921 -122.424906431455 (37.7862561057092, -122.424906431455)
98882 116352 2 20 4051X 24TH ST 6 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
98916 100147 2 20 3955 18th St 1 1 1 1     8 3x3   6003272.0 2105332.0 37.761025616168396 -122.431792078279 (37.7610256161684, -122.431792078279)
100229 104766 2 20 1111 CASTRO ST 1 1 1 1     14 3x3   6002562.6 2102271.3 37.7525814287469 -122.434026788658 (37.7525814287469, -122.434026788658)
100719 114307 2 20 595 ELLIS ST 1 1 1 1       3x3   6008020.0 2113749.0 37.7844047125189 -122.415966831143 (37.7844047125189, -122.415966831143)
101889 95411 1 20 2815 Diamond St 1 1 1 1 4   1 3x3 Planted by Glen Park Library; will become DPW maintained. 6002467.0 2095594.0 37.734241695714005 -122.43388015504499 (37.734241695714, -122.433880155045)
102340 56923 1 20 3917 24th St 1 1 1 1   07/09/1974 12:00:00 AM 18 3x3 Permit Number 14165 6003709.0 2101851.0 37.751492377455705 -122.430032361 (37.7514923774557, -122.430032361)
104860 95797 1 20 907 Treat Ave 1 1 1 1 1 08/19/2011 12:00:00 AM   3x3 Permit Number 767539 6008624.3 2103231.6 37.7555603448561 -122.413132208673 (37.7555603448561, -122.413132208673)
108607 38681 1 20 1725 Fulton St 1 1 1 1 1 10/05/1998 12:00:00 AM   3x3 Permit Number 40598 5999507.78485898 2110823.62249875 37.775890130447294 -122.445205652379 (37.7758901304473, -122.445205652379)
109764 97047 2 20 1590X Shafter Ave 2 1 1 1     8 3x3   6014988.7 2094146.3 37.7309692313217 -122.39048715342 (37.7309692313217, -122.39048715342)
110994 111670 2 20 99x CARL ST 1 1 1 1       3x3   5998115.0 2107097.0 37.7655781805803 -122.44975501544201 (37.7655781805803, -122.449755015442)
111008 116626 2 20 5732X GEARY BLVD 7 8 1 6 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
111092 103509 2 20 100X Leroy Pl 3 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
112231 30737 3 20 490X Page St 2 1 1 4 2 07/05/2000 12:00:00 AM 4 3x3 Permit Number 42884 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
113735 30736 3 20 490X Page St 1 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
Powered by Datasette · Query took 9.113ms · Data source: data.sfgov.org