sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
125272 110420 2 20 419X 18TH AVE 18 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
81716 116348 2 20 4051X 24TH ST 2 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
93939 116353 2 20 4051X 24TH ST 7 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
98882 116352 2 20 4051X 24TH ST 6 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
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)
121491 116351 2 20 4051X 24TH ST 5 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
121613 116354 2 20 4051X 24TH ST 8 1 1 6     10 3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
124160 116349 2 20 4051X 24TH ST 3 1 1 6       3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
140025 116347 2 20 4051X 24TH ST 1 1 1 6     10 3x3   6002850.0 2101803.0 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035)
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)
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)
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)
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)
98059 96209 3 20 201X Diamond St 1 1 1 4 2 05/28/2012 12:00:00 AM 3 4x4   6001762.6 2104666.8 37.759113460692 -122.43696480408701 (37.759113460692, -122.436964804087)
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)
129289 30741 3 20 490X Page St 4 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)
13832 27154 1 20 1700X Silver Ave 3 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011126.61874 2095085.7194599998 37.7333336755986 -122.403905168305 (37.7333336755986, -122.403905168305)
15856 27155 1 20 1700X Silver Ave 4 1 1 3   01/29/2000 12:00:00 AM 6 3X3   6011143.89147 2095098.83858 37.733370662922795 -122.403846374205 (37.7333706629228, -122.403846374205)
16026 27153 1 20 1700X Silver Ave 2 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011109.96837 2095074.7045 37.7333025005961 -122.403961958687 (37.7333025005961, -122.403961958687)
40373 37238 3 20 2200X Moraga St 2 5 1 3   03/26/2013 12:00:00 AM 11   Permit Number 770085 5987346.2909 2103736.5081 37.755729192821704 -122.48675431687 (37.7557291928217, -122.48675431687)
78978 87642 1 20 1002X Laguna St 1 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
95392 37236 3 20 2200X Moraga St 8 5 1 3   03/26/2013 12:00:00 AM     Permit Number 770085 5987459.55498562 2104367.82715752 37.757469225946295 -122.48640896705601 (37.7574692259463, -122.486408967056)
95395 27160 1 20 1700X Silver Ave 9 1 1 3     3 3X3   6011020.5092245005 2095004.7366116 37.733105385033795 -122.40426632243 (37.7331053850338, -122.40426632243)
107812 87643 1 20 1002X Laguna St 2 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
140654 27152 1 20 1700X Silver Ave 1 1 1 3   06/02/1999 12:00:00 AM 6 3X3   6011020.5092245005 2095004.7366116 37.733105385033795 -122.40426632243 (37.7331053850338, -122.40426632243)
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)
5851 9507 3 20 935 Golden Gate Ave 4 1 1 2     6 3X3   6005077.1287 2112297.1038 37.7802522713917 -122.42604476220501 (37.7802522713917, -122.426044762205)
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)
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)
10857 27206 3 20 302 Silver Ave 13 1 1 2   09/28/2012 12:00:00 AM 3 3X3   6003601.03384 2093471.82188 37.7284789616114 -122.429808120849 (37.7284789616114, -122.429808120849)
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)
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)
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)
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)
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)
12768 27200 3 20 302 Silver Ave 7 1 1 2   02/23/2005 12:00:00 AM 3 3X3   6003430.014219999 2093478.3653900002 37.728487242572605 -122.430399810923 (37.7284872425726, -122.430399810923)
14326 27149 3 20 1735 Silver Ave 2 1 1 2   06/16/1999 12:00:00 AM 3 3X3   6011161.84153 2095168.8132099998 37.7335638013107 -122.403789237593 (37.7335638013107, -122.403789237593)
15016 27146 3 20 1751 Silver Ave 3 1 1 2   05/19/1999 12:00:00 AM 3 2X3   6011294.03802 2095268.15566 37.7338439590333 -122.403339179952 (37.7338439590333, -122.403339179952)
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)
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)
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)
18825 3878 3 20 7 Castro St 2 1 1 2   08/23/2014 11:33:00 AM 12 3X3   6002011.6108099995 2108665.28098 37.7701064612771 -122.436389779582 (37.7701064612771, -122.436389779582)
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)
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)
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)
80831 26977 3 20 526 Silver Ave 1 1 1 2   06/08/1999 12:00:00 AM 6 3X3   6004737.76851 2093468.91574 37.728535287917 -122.425878161452 (37.728535287917, -122.425878161452)
83301 10882 3 20 1175X Hudson Ave 15 1 1 2     6 3X4   6017544.4990408 2094830.7506973 37.732990049052205 -122.381698823278 (37.7329900490522, -122.381698823278)
84720 18799 3 20 36 Rosie Lee Ln 2 1 1 2     12 3X4   6017963.3534873 2094445.0871971 37.731954211667706 -122.380223926679 (37.7319542116677, -122.380223926679)
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)
85541 30142 3 20 410X Mansell St 4 11 1 2     9 M   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
93893 24248 3 20 265X Willow St 2 1 1 2   05/01/1990 12:00:00 AM 3 4x4   6006141.132777 2113311.4044124 37.783097370149 -122.422435967678 (37.783097370149, -122.422435967678)
94410 10855 3 20 1299X HUDSON AVE 4 1 1 2   06/21/1996 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
97270 27128 3 20 2095X Silver Ave 6 1 1 2   06/16/1999 12:00:00 AM 6 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
98718 19415 3 20 600X Sloat Blvd 6 11 1 2   05/04/1999 12:00:00 AM 3 20   5989744.831209299 2096044.8028161 37.7347493206824 -122.477897219949 (37.7347493206824, -122.477897219949)
99616 26698 3 20 89 Dukes Ct 1 1 1 2     6 3X4   6016127.069051901 2096424.3370057999 37.73728734855921 -122.386710382374 (37.7372873485592, -122.386710382374)
100175 10387 3 20 1352 Haight St 1 1 1 2     30 3X3   5999669.18514 2108830.5589 37.7704268951205 -122.44450405514799 (37.7704268951205, -122.444504055148)
100453 27079 3 20 799X Silver Ave 1 1 1 2   06/26/1999 12:00:00 AM 8 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
101415 24476 3 20 99X Sussex St 1 1 1 2     12 3X3   6002281.226578901 2096676.7830479 37.73720422475029 -122.43459982975 (37.7372042247503, -122.43459982975)
102034 19417 3 20 800X Sloat Blvd 1 11 1 2   05/04/1999 12:00:00 AM 3 20   5988998.102828201 2096024.0271709 37.7346489082814 -122.48047736602301 (37.7346489082814, -122.480477366023)
107624 24238 3 20 200X Willow St 7 1 1 2   01/22/1999 12:00:00 AM 6 4X4   6006547.3507 2113418.3192 37.7834138390239 -122.421038210119 (37.7834138390239, -122.421038210119)
107953 19416 3 20 700X Sloat Blvd 1 11 1 2   05/04/1999 12:00:00 AM 3 20   5989518.2187007 2096039.5354251 37.7347217027544 -122.4786803033 (37.7347217027544, -122.4786803033)
108854 27124 3 20 2095X Silver Ave 2 1 1 2   06/16/1999 12:00:00 AM 3 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
110016 27122 3 20 2335 Silver Ave 2 1 1 2   01/02/2003 12:00:00 AM 12 2x2   6013082.27872 2096428.43607 37.7371295622807 -122.39723798628401 (37.7371295622807, -122.397237986284)
113106 27129 3 20 2095X Silver Ave 7 1 1 2   06/16/1999 12:00:00 AM 6 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
113808 89718 3 20 1655 Anza St 1 1 1 2   02/08/2008 12:00:00 AM 3 3x3   5993507.69164 2112056.80986 37.778931820846296 -122.46605098131501 (37.7789318208463, -122.466050981315)
114797 5808 3 20 22 Dukes Ct 1 1 1 2   04/02/2012 12:00:00 AM 3     6016199.5009328 2096264.8663221002 37.736853484109794 -122.38644883389 (37.7368534841098, -122.38644883389)
115921 10852 3 20 1299X HUDSON AVE 1 1 1 2   04/07/2016 12:00:00 AM 3 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
119626 12947 3 20 35 Lillian St 1 1 1 2     12 3X4   6017849.360696499 2094492.6056632 37.7320783980043 -122.38062132992901 (37.7320783980043, -122.380621329929)
127783 27126 3 20 2095X Silver Ave 4 1 1 2   06/16/1999 12:00:00 AM 6 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
129366 26984 3 20 1381 Silver Ave 1 1 1 2   06/22/1999 12:00:00 AM 6 3X3   6009547.85305 2094416.1727 37.7314069136466 -122.40931618879401 (37.7314069136466, -122.409316188794)
135572 221334 3 20 90x Peralta Ave 1 3 1 2     12 Width 10ft   6010340.53234 2100283.1811900004 37.747560836176 -122.406989109071 (37.747560836176, -122.406989109071)
139848 27127 3 20 2095X Silver Ave 5 1 1 2   06/16/1999 12:00:00 AM 6 3X3   6012407.8106259005 2096047.4553772 37.736045896585495 -122.399543203223 (37.7360458965855, -122.399543203223)
140514 10856 3 20 1299X HUDSON AVE 5 1 1 2   06/21/1996 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
140827 4393 3 20 25 Chilton Ave 2 1 1 2     18 3X3   6001738.943443701 2095739.8615836997 37.7346008554747 -122.436407710795 (37.7346008554747, -122.436407710795)
143415 27238 3 20 275 Silver Ave 1 1 1 2   06/26/1999 12:00:00 AM 6 3X3   6003040.40904 2093714.4077 37.729113284389 -122.43176354159401 (37.729113284389, -122.431763541594)
144749 16346 3 20 900X Monterey Blvd 4 11 1 2   01/19/2013 12:00:00 AM 3 5   5996119.1686597 2094698.5315602 37.7314206866198 -122.45576179592301 (37.7314206866198, -122.455761795923)
146218 12283 3 20 803X Laguna St 1 1 1 2   03/01/2000 12:00:00 AM 3 4X4   6004627.99576 2111737.28964 37.7786897656705 -122.427558625827 (37.7786897656705, -122.427558625827)
40 222540 2 20 1 Newburg St 3 1 1 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
43 222539 2 20 1 Newburg St 2 1 1 1     6 Width 2ft   6002564.39948 2099984.1142599997 37.7463014588556 -122.433857099823 (37.7463014588556, -122.433857099823)
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)
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)
2817 253222 2 20 148 Felton St 3 1 1 1       Width 3ft   6010428.10303 2093767.62468 37.729675416078294 -122.406227307752 (37.7296754160783, -122.406227307752)
2839 253221 2 20 148 Felton St 2 1 1 1       Width 3ft   6010428.10303 2093767.62468 37.729675416078294 -122.406227307752 (37.7296754160783, -122.406227307752)
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)
3796 182316 1 20 2726 Kirkham St 3 1 1 1   04/12/2001 12:00:00 AM 3 Width 0ft Permit Number 43905 5986380.5744 2105064.6172 37.759319468361 -122.490191716108 (37.759319468361, -122.490191716108)
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)
Powered by Datasette · Query took 11.681ms · Data source: data.sfgov.org