sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4309 1910 3 35 47 Beideman St 2 1 1 2     6 3X3   6001514.9606 2113070.1349 37.782172849750296 -122.43842331734601 (37.7821728497503, -122.438423317346)
118129 2453 3 35 1801X Buchanan St 1 1 1 2   06/26/2012 12:00:00 AM 0 4X4   6003961.1396892 2114603.1916159 37.786521075947796 -122.430070036959 (37.7865210759478, -122.430070036959)
106288 2454 3 35 1801X Buchanan St 2 1 1 2   06/26/2012 12:00:00 AM 6 4X4   6003961.1396892 2114603.1916159 37.786521075947796 -122.430070036959 (37.7865210759478, -122.430070036959)
103494 2455 3 35 1801X Buchanan St 3 1 1 2   06/26/2012 12:00:00 AM 18 4X4   6003961.1396892 2114603.1916159 37.786521075947796 -122.430070036959 (37.7865210759478, -122.430070036959)
123154 4019 1 35 1760 Cesar Chavez St 2 1 1 1   03/23/2006 12:00:00 AM 3 2X3   6013957.30178 2101067.5315943 37.7499162221241 -122.39453736171801 (37.7499162221241, -122.394537361718)
123464 4023 3 35 1900 Cesar Chavez St 1 1 1 2   06/26/2015 02:44:00 PM 3 3X3   6013444.007912099 2101040.051797 37.7498122193832 -122.39631044368099 (37.7498122193832, -122.396310443681)
121773 4025 3 35 1900 Cesar Chavez St 3 1 1 2   06/25/2015 03:01:00 PM 3 3X3   6013444.007912099 2101040.051797 37.7498122193832 -122.39631044368099 (37.7498122193832, -122.396310443681)
119406 4026 3 35 1900 Cesar Chavez St 4 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6013444.007912099 2101040.051797 37.7498122193832 -122.39631044368099 (37.7498122193832, -122.396310443681)
125081 4027 3 35 2150 Cesar Chavez St 1 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
143514 4029 3 35 2150 Cesar Chavez St 3 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
107830 4033 3 35 2150 Cesar Chavez St 7 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
5269 8090 1 35 762 Fulton St 1 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004349.2473 2111557.1689 37.7781794280627 -122.428510082803 (37.7781794280627, -122.428510082803)
5536 8091 1 35 762 Fulton St 2 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004317.1512 2111553.1108 37.7781664691559 -122.42862082556499 (37.7781664691559, -122.428620825565)
4504 8092 1 35 762 Fulton St 3 1 1 19   12/04/2010 12:00:00 AM 3 3X3   6004291.3267 2111546.8391 37.778147787093 -122.428709714706 (37.778147787093, -122.428709714706)
5542 8104 3 35 780 Fulton St 1 1 1 2   12/04/2010 12:00:00 AM 3 3X3   6004088.9733 2111516.0342 37.7780517500412 -122.429407531137 (37.7780517500412, -122.429407531137)
7425 8168 1 35 1160 Fulton St 1 1 1 1     35 3X3   6002214.9627 2111253.4218 37.7772244047313 -122.435871600468 (37.7772244047313, -122.435871600468)
141683 8518 3 35 2099X Geary Blvd 14 1 1 2   02/17/1999 12:00:00 AM 3 3x3   6001704.2218086 2113592.1733887 37.7836169980639 -122.437805961293 (37.7836169980639, -122.437805961293)
102392 8520 3 35 1901 Geary Blvd 2 1 1 2   02/17/1999 12:00:00 AM 3 3x3   6001704.2218086 2113592.1733887 37.7836169980639 -122.437805961293 (37.7836169980639, -122.437805961293)
19795 9378 3 35 320 Gold Mine Dr 1 1 1 2     6 2X2   6001091.814301901 2097867.0769738997 37.740404899832896 -122.438797433034 (37.7404048998329, -122.438797433034)
18986 10211 3 35 1311 Guerrero St 1 1 1 2   01/15/1991 12:00:00 AM 12 2X2   6005852.922730001 2101311.29856 37.7501316687427 -122.422580057332 (37.7501316687427, -122.422580057332)
18983 11186 3 35 100 Idora Ave 2 11 1 2     18 8   5995298.39303 2099423.25523 37.7443464775133 -122.458941312315 (37.7443464775133, -122.458941312315)
18799 11188 3 35 100 Idora Ave 1 11 1 2     24 8   5995291.088769999 2099424.10153 37.7443483813689 -122.45896663000299 (37.7443483813689, -122.458966630003)
141416 11200 3 35 186 Idora Ave 3 11 1 2     12 8   5995344.6608195 2099448.7962231003 37.74441926622529 -122.45878317784799 (37.7444192662253, -122.458783177848)
8037 12253 1 35 528 Laguna St 1 1 1 1   06/02/2003 12:00:00 AM 6 3x3   6005030.2517 2110722.9994 37.7759275170107 -122.426094839447 (37.7759275170107, -122.426094839447)
9842 12410 3 35 1610X Laguna St 1 1 1 2   09/13/1989 12:00:00 AM 7 4X4   6004460.5933 2114341.7023 37.78583136591 -122.42832340690398 (37.78583136591, -122.428323406904)
9845 12411 3 35 1610X Laguna St 2 1 1 2   09/13/1989 12:00:00 AM 6 4X4   6004443.6433 2114336.5232 37.785816186279504 -122.42838167990801 (37.7858161862795, -122.428381679908)
103342 12426 3 35 1701X Laguna St 5 1 1 2   01/08/2014 12:00:00 AM 3 4X4   6004430.116669999 2114714.4618599997 37.786853145727704 -122.428455426283 (37.7868531457277, -122.428455426283)
83620 12440 1 35 1595X Laguna St 6 1 1 1     6 3X3   6004488.80475 2114299.5475 37.785717215657 -122.428222797765 (37.785717215657, -122.428222797765)
3528 13088 1 35 722 Lombard St 1 1 1 1     45 3X3   6008925.6016 2120449.3844 37.802853199751794 -122.413307745784 (37.8028531997518, -122.413307745784)
7927 13089 1 35 722 Lombard St 2 1 1 1     60 3X3   6008909.0684 2120447.731 37.8028477316821 -122.41336484235 (37.8028477316821, -122.41336484235)
6874 13090 1 35 724 Lombard St 1 1 1 1   02/26/2004 12:00:00 AM 12 3X3   6008885.9219 2120447.4555 37.8028456756355 -122.413444921903 (37.8028456756355, -122.413444921903)
143081 13118 3 35 1633 Lombard St 1 1 1 2     24 3X3   6004565.4050748 2119750.0667864 37.800687292153896 -122.428346396238 (37.8006872921539, -122.428346396238)
101182 13415 3 35 430 Marietta Dr 1 11 1 2     25 5   5999619.6561933 2097087.2734828999 37.7381798806191 -122.443831547884 (37.7381798806191, -122.443831547884)
14606 15049 3 35 1125 Mendell St 1 1 1 2   01/15/1999 12:00:00 AM 25 8X15   6015485.0268 2096001.9904 37.7360921037992 -122.388900760186 (37.7360921037992, -122.388900760186)
86979 16604 1 35 101 Noe St 2 1 1 1   06/28/2016 12:00:00 AM 3 3X3 Permit Number 778401 6002878.7558281 2107677.2386141997 37.7674427729111 -122.433319725194 (37.7674427729111, -122.433319725194)
110833 16607 3 35 107 Noe St 2 1 1 2     2 3X3   6002880.641859099 2107642.9841193003 37.7673488254303 -122.433310753696 (37.7673488254303, -122.433310753696)
127780 16687 3 35 500 Noriega St 1 11 1 2     6 2   5992496.9362665005 2103468.0481268 37.755291002769496 -122.468922364571 (37.7552910027695, -122.468922364571)
368 18096 3 35 3008 Pine St 1 1 1 2   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.786481285230295 -122.44577068023099 (37.7864812852303, -122.445770680231)
10132 18098 3 35 3016 Pine St 1 1 1 2   01/31/2017 11:58:00 AM 3     5999364.6601 2114676.4418 37.7864608055495 -122.445977930803 (37.7864608055495, -122.445977930803)
107990 18204 1 35 1570 Post St 4 1 1 1     3 4X4   6004662.4699013 2114369.5525339 37.7859192566668 -122.42762695498699 (37.7859192566668, -122.427626954987)
8518 18226 3 35 1675 Post St 3 1 1 2     12 3X3   6004172.0667 2114245.454 37.785550761919 -122.42931476245899 (37.785550761919, -122.429314762459)
20466 18597 1 35 415 Randolph St 1 1 1 1   05/05/1999 12:00:00 AM 6 3X3   5992871.5273 2088492.4561 37.7141934014371 -122.466538492306 (37.7141934014371, -122.466538492306)
114696 18784 3 35 345X Roosevelt Way 2 1 1 2   01/08/2014 12:00:00 AM 3 3x3   6000292.8158924 2106925.3125911 37.7652311289718 -122.442210131131 (37.7652311289718, -122.442210131131)
9027 21627 3 35 1615 Sutter St 1 1 1 2 3 10/14/2010 12:00:00 AM 6 4X4 Permit Number 53778 6004639.3671 2114660.2794 37.7867162131248 -122.42772760613701 (37.7867162131248, -122.427727606137)
158 21682 3 35 1830 Sutter St 1 1 1 2   03/28/2017 12:00:00 AM 3 4x4   6003825.2217 2114604.0634 37.7865157709252 -122.43054034167 (37.7865157709252, -122.43054034167)
426 21683 1 35 1840 Sutter St 1 1 1 1   08/03/1999 12:00:00 AM 6 2x2   6003770.0848 2114594.6383 37.786486768354294 -122.430730428794 (37.7864867683543, -122.430730428794)
2665 21684 1 35 1840 Sutter St 2 1 1 1   04/09/2004 12:00:00 AM 3 4x4   6003739.9244 2114585.2131 37.7864591803505 -122.43083410335501 (37.7864591803505, -122.430834103355)
6750 21685 1 35 1840 Sutter St 3 1 1 1   08/03/1999 12:00:00 AM 6 4x4   6003694.6838 2114582.3856 37.7864488534059 -122.43099042257299 (37.7864488534059, -122.430990422573)
5466 21688 1 35 1881 Sutter St 3 1 1 1   05/19/1992 12:00:00 AM 2 4x4   6003696.9634 2114537.7544 37.7863264365495 -122.430979349218 (37.7863264365495, -122.430979349218)
92173 21707 1 35 1710X Webster St 9 1 1 1   03/30/2006 12:00:00 AM 6 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
90524 21708 1 35 1710X Webster St 10 1 1 1   03/30/2006 12:00:00 AM 7 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249)
7481 21730 1 35 1955 Sutter St 1 1 1 1   04/25/1990 12:00:00 AM 6 3X3   6003249.1628 2114463.8768 37.786098203806205 -122.43252334451599 (37.7860982038062, -122.432523344516)
6496 23490 3 35 2500X Van Ness Ave 6 11 1 2     30 9   6005777.87956 2119177.1307599996 37.799182688783496 -122.424109961515 (37.7991826887835, -122.424109961515)
6792 23871 3 35 1499X Webster St 4 1 1 2     12 3X3   6003600.3539 2113692.9201 37.784001259600295 -122.43125326646499 (37.7840012596003, -122.431253266465)
6475 23884 3 35 1750X Geary Blvd 1 1 1 2     3 3X3   6003258.4682 2113929.8349 37.7846323872704 -122.432452992684 (37.7846323872704, -122.432452992684)
4179 23894 1 35 1581 Webster St 1 1 1 1   10/10/2017 09:37:00 AM 3 3X3   6003529.5219 2114142.2135 37.7852308919409 -122.431530405312 (37.7852308919409, -122.431530405312)
2427 23895 1 35 1581 Webster St 2 1 1 1   03/30/2006 12:00:00 AM 3 3X3   6003532.7108 2114115.4269999997 37.7851575236987 -122.431517459739 (37.7851575236987, -122.431517459739)
7053 23897 1 35 1581 Webster St 4 1 1 1   03/30/2006 12:00:00 AM 3 3X3   6003549.9307 2114010.8321 37.784871308404 -122.431450414863 (37.784871308404, -122.431450414863)
6039 23898 1 35 1581 Webster St 5 1 1 1   03/30/2006 12:00:00 AM 3 3X3   6003553.1196 2113987.2345 37.7848066960652 -122.43143769715701 (37.7848066960652, -122.431437697157)
5993 23902 3 35 1600X Webster St 5 11 1 2     8 20   6003560.0188 2114334.411 37.7857603463241 -122.431438620741 (37.7857603463241, -122.431438620741)
605 23903 3 35 1600X Webster St 6 11 1 2     3 6   6003560.4697 2114360.5617 37.7858321751093 -122.431438928251 (37.7858321751093, -122.431438928251)
26263 23904 3 35 1600X Webster St 7 11 1 2     6 6   6003550.0996 2114363.7178 37.7858402532263 -122.43147503127199 (37.7858402532263, -122.431475031272)
112336 24168 3 35 95X Whitney Young Cir 1 1 1 2   01/01/2008 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
22231 25471 1 35 237 Randolph St 1 1 1 1   03/08/2005 12:00:00 AM 3 3X3   5993297.6081 2088487.2193 37.7142036007288 -122.465065423908 (37.7142036007288, -122.465065423908)
18656 25472 1 35 205X Randolph St 1 1 1 1   05/03/1999 12:00:00 AM 6 3X3   5993432.494 2088486.2672 37.714208763487896 -122.46459914058599 (37.7142087634879, -122.464599140586)
10780 26783 1 35 6 Leland Ave 2 1 1 1     3 4X4   6010951.9721 2087077.0783 37.711333837408205 -122.40394559103301 (37.7113338374082, -122.403945591033)
13116 26784 1 35 6 Leland Ave 3 1 1 1     3 4X4   6010928.7998 2087090.8926 37.7113704740421 -122.40402665236999 (37.7113704740421, -122.40402665237)
11422 26785 1 35 28 Leland Ave 1 1 1 1   10/13/1999 12:00:00 AM 3 3X3   6010847.2509 2087135.4549 37.7114882765061 -122.40431164223101 (37.7114882765061, -122.404311642231)
12802 26786 1 35 34 Leland Ave 1 1 1 1     3 3X3   6010794.6675 2087161.3009 37.7115563058928 -122.404495203342 (37.7115563058928, -122.404495203342)
10592 26788 1 35 78 Leland Ave 1 1 1 1   08/06/1999 12:00:00 AM 4 3X3   6010596.3656 2087261.1203 37.711819305554 -122.40518761518801 (37.711819305554, -122.405187615188)
12328 26789 1 35 96 Leland Ave 1 1 1 1   12/15/2010 12:00:00 AM 3 3X3   6010520.1642 2087302.5632 37.7119288389604 -122.40545390649599 (37.7119288389604, -122.405453906496)
11545 26790 3 35 106 Leland Ave 1 1 1 2   06/03/2015 09:40:00 AM 3 3X3   6010430.5942 2087350.2448 37.7120547543657 -122.405766843704 (37.7120547543657, -122.405766843704)
12918 26791 1 35 110 Leland Ave 1 1 1 1   08/06/1999 12:00:00 AM 4 3x3   6010397.1725 2087366.7328 37.712098157972605 -122.40588352001801 (37.7120981579726, -122.405883520018)
13045 26792 1 35 128 Leland Ave 1 1 1 1   01/29/2002 12:00:00 AM 3 3x3   6010340.5785 2087395.6982 37.7121745258223 -122.40608116557199 (37.7121745258223, -122.406081165572)
10559 26794 1 35 186 Leland Ave 1 1 1 1   08/09/1999 12:00:00 AM 2 3x3   6010044.3489 2087538.0893 37.7125489295627 -122.407115057358 (37.7125489295627, -122.407115057358)
12910 26795 3 35 159 Leland Ave 1 1 1 2   12/15/2010 12:00:00 AM 3 3x3   6010135.8151 2087452.9607 37.712320301990204 -122.40679292443501 (37.7123203019902, -122.406792924435)
12883 26798 1 35 141 Leland Ave 2 1 1 1     3 3x3   6010259.698 2087389.6823 37.71215348320929 -122.406360290051 (37.7121534832093, -122.406360290051)
12450 26799 1 35 141 Leland Ave 3 1 1 1     3 3x3   6010285.5441 2087377.2049 37.7121206686095 -122.40627007937 (37.7121206686095, -122.40627007937)
11042 26800 1 35 117 Leland Ave 1 1 1 1   08/09/1999 12:00:00 AM 5 3x3   6010377.1195 2087327.5180000002 37.7119893605537 -122.40595006858901 (37.7119893605537, -122.405950068589)
6947 26936 1 35 1529 Golden Gate Ave 1 1 1 1     3 3X3   6002004.7416 2111860.8692 37.7788803585551 -122.436642312661 (37.7788803585551, -122.436642312661)
5333 26937 1 35 1529 Golden Gate Ave 2 1 1 1     3 3X3   6002019.9705 2111862.8998 37.7788867994939 -122.436589775324 (37.7788867994939, -122.436589775324)
11559 27104 1 35 637 Silver Ave 1 1 1 1     3 2X3   6005511.99058 2093568.16222 37.7288515201802 -122.423208682549 (37.7288515201802, -122.423208682549)
10932 27180 1 35 225 Silver Ave 1 1 1 1   07/11/1999 12:00:00 AM 3 2X3   6002717.36844 2093904.29403 37.7296163521897 -122.432893878247 (37.7296163521897, -122.432893878247)
124164 27720 3 35 1300X Cesar Chavez St 2 1 1 2   04/11/2015 06:49:00 AM 3 3X3   6015137.8598649 2101142.4987414 37.750187626613496 -122.39046013782401 (37.7501876266135, -122.390460137824)
104005 27743 3 35 1399 Cesar Chavez St 4 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6014867.852606599 2101105.5872465 37.7500712934283 -122.391391267014 (37.7500712934283, -122.391391267014)
46253 27745 3 35 1399 Cesar Chavez St 6 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6014867.852606599 2101105.5872465 37.7500712934283 -122.391391267014 (37.7500712934283, -122.391391267014)
83929 27750 3 35 1299 Cesar Chavez St 3 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
118003 27753 3 35 1299 Cesar Chavez St 6 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
126737 27754 3 35 1299 Cesar Chavez St 7 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
80506 27758 3 35 1299 Cesar Chavez St 11 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
127102 27759 3 35 1099X Cesar Chavez St 1 1 1 2   12/25/2005 12:00:00 AM 4 3x3   6015711.817910201 2101113.2850563 37.750139234821 -122.38847329943701 (37.750139234821, -122.388473299437)
213 28640 3 35 1300 Webster St 2 11 1 2   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.782776612799296 -122.430825656777 (37.7827766127993, -122.430825656777)
7067 28641 3 35 1300 Webster St 3 11 1 2     8 20   6003709.2011 2113267.9212 37.7828404869024 -122.43084635463 (37.7828404869024, -122.43084635463)
5957 28643 3 35 1300 Webster St 5 11 1 2     10 20   6003700.2631 2113325.6745 37.7829985565916 -122.43088139933201 (37.7829985565916, -122.430881399332)
7475 28644 3 35 1300 Webster St 6 11 1 2   04/21/2008 12:00:00 AM 3 20   6003694.7628 2113348.3634 37.7830605429851 -122.430902047868 (37.7830605429851, -122.430902047868)
5350 28646 3 35 1600X Webster St 8 11 1 2     8 6   6003557.7645 2114374.9896 37.7858716371659 -122.431449317827 (37.7858716371659, -122.431449317827)
4516 28647 3 35 1600X Webster St 9 11 1 2     8 6   6003547.8453 2114380.4001 37.785885930849204 -122.431484021877 (37.7858859308492, -122.431484021877)
8595 28648 3 35 1600X Webster St 10 11 1 2   04/21/2008 12:00:00 AM 3 6   6003548.747 2114394.8281 37.7859255976047 -122.43148193261601 (37.7859255976047, -122.431481932616)
96146 29251 3 35 1300X Cesar Chavez St 5 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015137.8598649 2101142.4987414 37.750187626613496 -122.39046013782401 (37.7501876266135, -122.390460137824)
126999 30734 1 35 281 Rose St 2 1 1 1 1 01/31/1995 12:00:00 AM     Permit Number 34629 6005251.19976575 2109714.98569866 37.7731722414546 -122.42525877680299 (37.7731722414546, -122.425258776803)
169020 30735 1 35 281 Rose St 1 1 1 1 1 01/31/1995 12:00:00 AM 6   Permit Number 34629 6005244.0655 2109725.8172 37.773201579085004 -122.42528422609699 (37.773201579085, -122.425284226097)
Powered by Datasette · Query took 26.951ms · Data source: data.sfgov.org