sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
185878 50830 1 31 621 Baker St 1 1 1 1   03/19/2004 12:00:00 AM 9   Permit Number 47349 6000535.8217 2111139.1847 37.7768152106013 -122.441672069607 (37.7768152106013, -122.441672069607)
111471 52313 1 31 4400HOFFMAN 24th St 3 1 1 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
113895 52312 1 31 4400HOFFMAN 24th St 2 1 1 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
115414 52311 1 31 4400HOFFMAN 24th St 1 1 1 1   05/22/2009 12:00:00 AM   3x3 Permit Number 52154 6000634.55195661 2101724.81174328 37.7509712947951 -122.440655099281 (37.7509712947951, -122.440655099281)
103766 85491 1 31 4400 24th St   1 1 1   09/05/2007 12:00:00 AM   3x3 Permit Number 52154 6000641.0 2101716.0 37.7509474670616 -122.440632169404 (37.7509474670616, -122.440632169404)
160919 241224 2 31 44 Museum Way 1 1 1 1     5 Width 3ft   6000710.17183 2106760.2697 37.764801739133205 -122.44075476054701 (37.7648017391332, -122.440754760547)
136987 51838 1 31 135 Morse St 1 1 1 1   07/13/2005 12:00:00 AM 8   Permit Number 48065 6000803.77084 2087905.29553 37.713035738688504 -122.43907959427 (37.7130357386885, -122.43907959427)
129978 136740 2 31 1920 Beach St 8 9 1 1     12 Width 6ft   6000976.885419999 2121020.42839 37.8039716578185 -122.44085530385 (37.8039716578185, -122.44085530385)
17013 16027 1 31 160 Monterey Blvd 1 1 1 1   02/23/2005 12:00:00 AM 3 3X3   6001078.56062 2094701.12537 37.7317111799206 -122.43861646769899 (37.7317111799206, -122.438616467699)
125170 63543 1 31 1715 Golden Gate Ave 1 1 1 1 1 03/14/1994 12:00:00 AM     Permit Number 33376 6001376.18344652 2111778.57795299 37.7786186676026 -122.43881084154499 (37.7786186676026, -122.438810841545)
136649 141332 2 31 1324 HAYES ST 2 10 1 1     6 Width 0ft   6001489.2623 2110460.5875 37.7750062304087 -122.43832521117099 (37.7750062304087, -122.438325211171)
54816 57900 1 31 1324 Hayes St 1 1 1 1   06/09/1977 12:00:00 AM 5   Permit Number 16856 6001502.5818 2110462.7186 37.77501283944979 -122.438279288937 (37.7750128394498, -122.438279288937)
72724 247212 2 31 800 Duboce Ave 11 2 1 1     7 Width 3ft   6001824.5154099995 2108284.91798 37.7690514458872 -122.437009703838 (37.7690514458872, -122.437009703838)
91227 67800 1 31 4318 26th St 1 1 1 1 1 12/17/1992 12:00:00 AM     Permit Number 31444 6001831.31402978 2100620.67337741 37.7480076719463 -122.43643756932501 (37.7480076719463, -122.436437569325)
56645 247209 2 31 800 Duboce Ave 5 2 1 1     6 Width 3ft   6001860.515269999 2108286.6653 37.7690582897368 -122.436885307832 (37.7690582897368, -122.436885307832)
152480 241225 2 31 4049 17th St 1 1 1 1     7 Width 2ft   6001920.58101 2105839.72544 37.7623430070574 -122.43650238277901 (37.7623430070574, -122.436502382779)
94065 41897 1 31 2500 Market St 1 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42262 6001987.05760353 2105790.14936536 37.762210660505 -122.436268917311 (37.762210660505, -122.436268917311)
98438 117606 1 31 420 Castro St 2 1 1 1     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.43521453981701 (37.7622721434766, -122.435214539817)
128524 117607 1 31 420 Castro St 3 1 1 1     6 3X3   6002292.2454566 2105806.2278627 37.7622721434766 -122.43521453981701 (37.7622721434766, -122.435214539817)
6292 87392 1 31 3322 Fillmore St 2 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002333.63287 2119648.2941900003 37.800281314083705 -122.43606195061199 (37.8002813140837, -122.436061950612)
6671 87391 1 31 3322 Fillmore St 1 1 1 1   01/24/2015 12:00:00 AM 3 3x3 Permit Number 773384 6002335.87278 2119635.99284 37.800247665053 -122.43605331890801 (37.800247665053, -122.436053318908)
50962 179971 2 31 160 Baltimore Way 2 2 1 1     8 Width 6ft   6002384.15556 2086207.4195700001 37.708463540423104 -122.43349600315001 (37.7084635404231, -122.43349600315)
157611 136748 2 31 165 Marina Blvd 2 9 1 1     4 Width 7ft   6002698.42353 2121575.97678 37.80559494132721 -122.43493757052299 (37.8055949413272, -122.434937570523)
187402 179964 2 31 85 South Hill Blvd 2 2 1 1     5 Width 4ft   6002952.82685 2087126.8782400002 37.7110204227269 -122.431596206017 (37.7110204227269, -122.431596206017)
70744 179963 2 31 85 South Hill Blvd 1 2 1 1     5 Width 4ft   6002963.44574 2087110.53022 37.7109761365014 -122.431558338255 (37.7109761365014, -122.431558338255)
135983 241218 2 31 4130 Cesar Chavez St 2 9 1 1     12 Width 6ft   6003089.92025 2100398.1705 37.7474681682179 -122.43206947603399 (37.7474681682179, -122.432069476034)
87848 100205 2 31 4085 20th St 1 1 1 1   09/27/2012 12:00:00 AM 12 3x4 Permit Number 769140 6003091.0 2104064.0 37.757533730328205 -122.43232751517901 (37.7575337303282, -122.432327515179)
66969 241217 2 31 4130 Cesar Chavez St 1 9 1 1     9 Width 6ft   6003092.5802 2100398.11558 37.7474681682247 -122.432060274186 (37.7474681682247, -122.432060274186)
35762 241219 2 31 4130 Cesar Chavez St 3 9 1 1     11 Width 6ft   6003095.93223 2100399.3712299997 37.7474718059861 -122.432048772745 (37.7474718059861, -122.432048772745)
86818 68587 1 31 104 Laidley St 1 1 1 1 1 09/24/1994 12:00:00 AM     Permit Number 32485 6003450.61209517 2097770.88653532 37.7402746975659 -122.430634780555 (37.7402746975659, -122.430634780555)
69860 241226 2 31 102 Laidley St 1 1 1 1     10 Width 3ft   6003452.26052 2097778.5444 37.740295817689294 -122.43062962727 (37.7402958176893, -122.43062962727)
68564 241227 2 31 104 Laidley St 1 1 1 1     11 Width 3ft   6003479.820730001 2097757.7557200002 37.7402402980644 -122.430532852122 (37.7402402980644, -122.430532852122)
29979 241228 2 31 128 Laidley St 1 1 1 1     11 Width 3ft   6003596.19295 2097670.1680900003 37.740006394279796 -122.43012423703699 (37.7400063942798, -122.430124237037)
116426 65602 1 31 114 Maynard St 1 1 1 1 1 02/06/1990 12:00:00 AM 13   Permit Number 28504 6004165.03379 2093741.9135900002 37.729252495484 -122.427877581308 (37.729252495484, -122.427877581308)
71330 179970 2 31 307 Athens St 2 1 1 1     7 Width 4ft   6004288.05392 2091472.8528 37.7230291158735 -122.42729072060101 (37.7230291158735, -122.427290720601)
174334 241198 2 31 106 Chattanooga St 5 10 1 1     3 Width 4ft   6004702.81282 2102995.20065 37.754690319613296 -122.426677105059 (37.7546903196133, -122.426677105059)
91 241181 1 31 300 Duboce Ave 4 7 1 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004757.3052900005 2108409.26199 37.7695591257908 -122.42687421397 (37.7695591257908, -122.42687421397)
76 241180 1 31 300 Duboce Ave 3 7 1 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004770.13014 2108408.30025 37.7695572102182 -122.426829784767 (37.7695572102182, -122.426829784767)
90 241179 1 31 300 Duboce Ave 2 7 1 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004783.47466 2108409.88584 37.769562318364 -122.426783739481 (37.769562318364, -122.426783739481)
82 241178 1 31 300 Duboce Ave 1 7 1 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004795.3896699995 2108410.1055900003 37.769563595403106 -122.42674254153299 (37.7695635954031, -122.426742541533)
98175 44261 1 31 300 Duboce Ave 2 1 1 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
109165 44264 1 31 300 Duboce Ave 1 1 1 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
116223 44262 1 31 300 Duboce Ave 3 1 1 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
122492 44263 1 31 300 Duboce Ave 4 1 1 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
159390 246465 2 31 220 Duncan St 1 4 1 1     10 Width 3ft   6005035.80445 2099919.28541 37.746263388739706 -122.425306657892 (37.7462633887397, -122.425306657892)
185205 179966 2 31 716 Peru Ave 4 9 1 1     10 Width 2ft   6005255.40982 2092462.4838400001 37.725801087223 -122.424017104714 (37.725801087223, -122.424017104714)
180078 241183 2 31 1720 Dolores St 5 9 1 1     3 Width 3ft   6005264.11037 2098316.58265 37.7418756279601 -122.424403226839 (37.7418756279601, -122.424403226839)
184272 241184 2 31 1720 Dolores St 8 9 1 1     3 Width 3ft   6005265.18206 2098303.13157 37.7418387548635 -122.424398564767 (37.7418387548635, -122.424398564767)
146364 179967 2 31 716 Peru Ave 8 9 1 1     9 Width 2ft   6005275.29843 2092450.03888 37.7257680389529 -122.423947466603 (37.7257680389529, -122.423947466603)
97652 4167 3 31 3781 Cesar Chavez St 1 1 1 2   01/04/1993 12:00:00 AM 12 3X3   6005338.8489102 2100470.9859700003 37.7477953482432 -122.424297997893 (37.7477953482432, -122.424297997893)
27397 241185 2 31 3781 Cesar Chavez St 2 1 1 1     11 Width 4ft   6005371.2767199995 2100474.34138 37.7478063924621 -122.424186102634 (37.7478063924621, -122.424186102634)
19758 4166 3 31 3771 Cesar Chavez St 1 1 1 2   10/18/1999 12:00:00 AM 3 3X3   6005390.77926 2100476.4482400003 37.747813278574 -122.424118813557 (37.747813278574, -122.424118813557)
80434 30020 3 31 710X San Jose Ave 12 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005718.76576524 2099005.5772577 37.7437931149581 -122.42288013057501 (37.7437931149581, -122.422880130575)
82547 30021 3 31 710X San Jose Ave 13 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6005718.76576524 2099005.5772577 37.7437931149581 -122.42288013057501 (37.7437931149581, -122.422880130575)
54785 66435 1 31 154 Highland Ave 1 1 1 1 1 01/29/2016 12:00:00 AM 3   Permit Number 776442 6005832.64379623 2096619.46427693 37.7372478105316 -122.422316867971 (37.7372478105316, -122.422316867971)
168702 241202 2 31 154 Highland Ave 1 1 1 1     3 Width 3ft   6005836.15299 2096624.2788099998 37.7372612281114 -122.42230507703 (37.7372612281114, -122.42230507703)
185349 179968 2 31 675 Silver Ave 3 9 1 1     32 Width 2ft   6005852.39602 2093589.2328700002 37.7289285803821 -122.422033372066 (37.7289285803821, -122.422033372066)
112993 99104 2 31 3644 20th St 1 1 1 1       3x3   6006000.9 2104423.0 37.7586840282695 -122.422289399469 (37.7586840282695, -122.422289399469)
83323 30003 3 31 610X San Jose Ave 15 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6006030.83928578 2099887.5672939997 37.74623246341729 -122.42186369026399 (37.7462324634173, -122.421863690264)
138600 30004 3 31 610X San Jose Ave 16 11 1 2   03/24/2007 12:00:00 AM 3 3x3   6006030.83928578 2099887.5672939997 37.74623246341729 -122.42186369026399 (37.7462324634173, -122.421863690264)
60023 241192 2 31 3630 20th St 3 10 1 1     7 Width 3ft   6006049.00576 2104357.91631 37.7585080370469 -122.42211840383499 (37.7585080370469, -122.422118403835)
65029 241191 2 31 3630 20th St 1 1 1 1     6 Width 3ft   6006057.8545699995 2104359.21039 37.7585120893797 -122.42208789256901 (37.7585120893797, -122.422087892569)
18492 63236 1 31 3634 20th St 1 10 1 1 1 01/13/1987 12:00:00 AM 12   Permit Number 23784 6006063.67565171 2104362.69748074 37.7585219924343 -122.422068008351 (37.7585219924343, -122.422068008351)
113940 107411 1 31 3634 20th St 2 10 1 1       3x3   6006068.0 2104353.0 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883)
31101 66988 1 31 1445 Green St 1 1 1 1   02/12/1992 12:00:00 AM 12   Permit Number 30339 6006117.71616 2118619.27503 37.7976701397196 -122.422894339811 (37.7976701397196, -122.422894339811)
75251 84928 1 31 1500@Polk Broadway 4 1 1 1   06/06/2007 12:00:00 AM 6   Permit Number 49344 6006295.343780001 2118001.00844 37.79598255651371 -122.422235750095 (37.7959825565137, -122.422235750095)
160212 63573 1 31 1500@Polk Broadway 3 1 1 1 1 12/29/1993 12:00:00 AM 6   Permit Number 49344 6006306.38676 2118003.57118 37.795990216032294 -122.422197721351 (37.7959902160323, -122.422197721351)
53611 109316 2 31 1516 BROADWAY 3 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
80952 109314 2 31 1516 BROADWAY 1 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
81156 109317 2 31 1516 BROADWAY 4 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
116911 109315 2 31 1516 BROADWAY 2 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
127307 110182 1 31 339 ELSIE ST 1 1 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 776744 6006513.8 2097161.9 37.7387756178582 -122.420000276005 (37.7387756178582, -122.420000276005)
158174 241187 2 31 45 Hoff St 2 1 1 1     8 Width 6ft   6006570.58835 2106391.73918 37.7641218444722 -122.420458896575 (37.7641218444722, -122.420458896575)
173562 241186 2 31 45 Hoff St 1 1 1 1     8 Width 6ft   6006573.70754 2106363.42565 37.764044277946205 -122.42044609832399 (37.7640442779462, -122.420446098324)
82313 64622 1 31 350 San Carlos St 1 1 1 1 1 08/15/1988 12:00:00 AM     Permit Number 25527 6006698.09280064 2104074.24597744 37.75776573278821 -122.41985343647801 (37.7577657327882, -122.419853436478)
90069 40438 1 31 400 Cortland Ave 1 1 1 1 1 06/10/1999 12:00:00 AM     Permit Number 41530 6007160.84774193 2097270.742449 37.7391109088923 -122.417770796303 (37.7391109088923, -122.417770796303)
101783 47561 1 31 580 Capp St 2 1 1 1 1 05/14/2002 12:00:00 AM     Permit Number 45422 6007250.69827751 2103936.71356757 37.7574192165742 -122.41793254418002 (37.7574192165742, -122.41793254418)
112598 47560 1 31 580 Capp St 1 1 1 1 1 05/14/2002 12:00:00 AM     Permit Number 45422 6007250.69827751 2103936.71356757 37.7574192165742 -122.41793254418002 (37.7574192165742, -122.41793254418)
141713 82360 1 31 415-421 South Van Ness Ave 1 1 1 1 1 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498)
145835 80165 1 31 415-421 South Van Ness Ave 2 1 1 1 1 12/23/2011 12:00:00 AM 10 3x3 Permit Number 768604 6007434.83105048 2107262.94030089 37.766562624561 -122.417531473498 (37.766562624561, -122.417531473498)
178574 241189 2 31 415 South Van Ness Ave 1 1 1 1     11 Width 4ft   6007440.26209 2107242.97401 37.7665081073951 -122.41751127324 (37.7665081073951, -122.41751127324)
42490 241188 2 31 419 South Van Ness Ave 1 1 1 1     10 Width 4ft   6007442.12211 2107229.45736 37.7664710984984 -122.417503881697 (37.7664710984984, -122.417503881697)
65216 136751 2 31 1142 Filbert St 1 2 1 1     12 Width 3ft   6007453.51921 2119553.70533 37.8003111329029 -122.41833837521999 (37.8003111329029, -122.41833837522)
153492 136750 2 31 1124 Filbert St 1 2 1 1     8 Width 5ft   6007528.1043 2119564.5184299997 37.8003450211571 -122.41808104771299 (37.8003450211571, -122.418081047713)
140792 94868 6 31 51 Princeton St   5 1 1 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
164545 82366 6 31 51 Princeton St 3 1 1 1 1 05/28/2005 12:00:00 AM 9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059)
160016 241207 2 31 1142 South Van Ness Ave 2 1 1 1     10 Width 3ft   6007609.4952 2103000.12596 37.754867747762795 -122.41662533218701 (37.7548677477628, -122.416625332187)
86383 34081 1 31 240 SHOTWELL ST 4 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
100434 108225 1 31 240 Shotwell St 14 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
105965 108221 1 31 240 Shotwell St 10 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
118122 108224 1 31 240 Shotwell St 13 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
118194 108227 1 31 240 Shotwell St 16 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
120475 108220 1 31 240 Shotwell St 9 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
129363 108222 1 31 240 Shotwell St 11 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
142472 108226 1 31 240 Shotwell St 15 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
145642 108223 1 31 240 Shotwell St 12 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
145082 88286 1 31 240 Shotwell St 1 1 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51287 6007754.0 2106536.0 37.7645845697556 -122.416376026653 (37.7645845697556, -122.416376026653)
18713 34080 1 31 240 Shotwell St 3 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
86898 34083 1 31 240 Shotwell St 6 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
98468 34082 1 31 240 Shotwell St 5 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
98537 34079 1 31 240 Shotwell St 2 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
Powered by Datasette · Query took 6.977ms · Data source: data.sfgov.org