sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
111888 49075 1 31 1970 Ocean Ave 1 1 1 1 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
112114 42733 1 31 2155 Bay Shore Blvd 5 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
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)
112993 99104 2 31 3644 20th St 1 1 1 1       3x3   6006000.9 2104423.0 37.7586840282695 -122.422289399469 (37.7586840282695, -122.422289399469)
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)
113940 107411 1 31 3634 20th St 2 10 1 1       3x3   6006068.0 2104353.0 37.7584956093101 -122.422052363883 (37.7584956093101, -122.422052363883)
114146 34047 1 31 375 Alabama St 6 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
114868 83791 1 31 369 Prentiss St 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50933 6008828.16902132 2097088.78446754 37.7387049796432 -122.411993079981 (37.7387049796432, -122.411993079981)
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)
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)
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)
116911 109315 2 31 1516 BROADWAY 2 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
117278 50801 1 31 466 Staples Ave 1 1 1 1 1 08/11/2004 12:00:00 AM     Permit Number 47598 5997189.59146779 2093842.28323419 37.7291310061031 -122.451999409113 (37.7291310061031, -122.451999409113)
117733 62050 1 31 70 13th St 1 1 1 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008120.0 2108416.0 37.769767186200795 -122.41524321981701 (37.7697671862008, -122.415243219817)
117817 42739 1 31 2155 Bay Shore Blvd 7 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
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)
118249 39861 1 31 70 13th St 4 1 1 1   01/18/2008 12:00:00 AM   3x3 Permit Number 50122 6008235.62773227 2108364.64558499 37.7696326766808 -122.41483963035499 (37.7696326766808, -122.414839630355)
118491 106781 1 31 1177 De Haro St 2 5 1 1   06/03/2014 12:00:00 AM     Permit Number 773142 6012276.4 2102941.5 37.7549681417933 -122.400481655091 (37.7549681417933, -122.400481655091)
118733 16313 3 31 758X Monterey Blvd 5 11 1 2   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.45247618016899 (37.7316364140758, -122.452476180169)
119574 47386 1 31 400 Ellington Ave 1 1 1 1   05/13/2002 12:00:00 AM     Permit Number 45302 5998534.7421818 2087640.83447452 37.712180218724896 -122.446903063491 (37.7121802187249, -122.446903063491)
119778 51920 1 31 45 Sheridan St 1 1 1 1   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009316.82358159 2109402.74774996 37.772543755510895 -122.41117313594499 (37.7725437555109, -122.411173135945)
120475 108220 1 31 240 Shotwell St 9 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
120632 42737 1 31 2155 Bay Shore Blvd 1 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
120751 34077 1 31 2851X 16th St 3 1 1 1 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
120865 49076 1 31 1970 Ocean Ave 3 1 1 1 1 01/07/2003 12:00:00 AM     Permit Number 46231 5993706.31601319 2092791.54243423 37.7260457932168 -122.46396504093 (37.7260457932168, -122.46396504093)
121741 99249 1 31 435 Paul Ave 1 1 1 1   08/27/2012 12:00:00 AM   3x3 Permit Number 769233 6012286.9 2091380.6 37.7232249352354 -122.399633675727 (37.7232249352354, -122.399633675727)
122229 123216 2 31 654 09th Ave 1 1 1 1     12 Width 3ft   5993193.61084 2111027.91211 37.7760886204879 -122.46706267834298 (37.7760886204879, -122.467062678343)
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)
123243 34051 1 31 375 Alabama St 4 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
123498 49162 1 31 804 Faxon Ave 1 1 1 1 1 01/23/2003 12:00:00 AM     Permit Number 46282 5994926.32764665 2093370.69967083 37.7277062535492 -122.45978949774499 (37.7277062535492, -122.459789497745)
123673 65048 1 31 375 Banks St 1 1 1 1 1 06/18/1994 12:00:00 AM     Permit Number 27001 6008641.92550277 2097033.56507471 37.7385429081789 -122.41263312174401 (37.7385429081789, -122.412633121744)
124789 88372 1 31 45 Sheridan St 2 1 1 1   07/20/2005 12:00:00 AM   2x3 Permit Number 48123 6009306.0 2109414.0 37.77257404455771 -122.411211370961 (37.7725740445577, -122.411211370961)
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)
126801 34084 1 31 240 Shotwell St 7 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)
127065 84127 1 31 88 Mill St 1 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50980 6010360.09243836 2089687.02520781 37.7184671339256 -122.406175049692 (37.7184671339256, -122.406175049692)
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)
127349 42308 1 31 249 Edna St 1 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42531 5998732.34943109 2093642.59637242 37.7286709604577 -122.446651628377 (37.7286709604577, -122.446651628377)
128240 215433 2 31 20 Lakewood Ave 2 1 1 1     9 Width 3ft   5993594.89235 2092910.6701200001 37.726366466724 -122.464358867875 (37.726366466724, -122.464358867875)
128411 52305 1 31 715 Buena Vista Ave West 2 1 1 1   07/29/2016 12:00:00 AM 3   Permit Number 48465 5999876.8 2107852.1 37.7677521370965 -122.443715612896 (37.7677521370965, -122.443715612896)
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)
128783 44007 1 31 2701X 17th St 3 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 3 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
129363 108222 1 31 240 Shotwell St 11 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
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)
130161 215412 2 31 1407 14th Ave 1 1 1 1     13 Width 3ft   5991770.8881 2105805.69837 37.7616676000029 -122.471603571552 (37.7616676000029, -122.471603571552)
130541 199802 2 31 1350 Donner Ave 8 1 1 1     7 Width 0ft   6015069.8022 2090954.144 37.7222087062567 -122.389983862743 (37.7222087062567, -122.389983862743)
131633 241213 2 31 2801 17th St 3 1 1 1     13 Width 3ft   6009032.16938 2106352.76347 37.76415323799171 -122.411942216073 (37.7641532379917, -122.411942216073)
132120 241214 2 31 2801 17th St 2 1 1 1     12 Width 3ft   6009008.65245 2106350.93983 37.764146911276704 -122.41202342575899 (37.7641469112767, -122.412023425759)
132906 198004 3 31 920x Jamestown Ave 12 11 1 2     10 Width 5ft   6014389.315880001 2089371.37328 37.7178249676301 -122.39222551819401 (37.7178249676301, -122.392225518194)
135321 215425 2 31 15 Fairfield Way 1 1 1 1     7 Width 3ft   5993828.92178 2092931.25645 37.7264364789445 -122.463551338741 (37.7264364789445, -122.463551338741)
135775 179965 2 31 86 Arago St 2 9 1 1     9     5999606.18552 2093002.3803299998 37.726962952855104 -122.443584762453 (37.7269629528551, -122.443584762453)
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)
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)
136653 215429 2 31 20 Lakewood Ave 6 1 1 1     8 Width 3ft   5993645.021930001 2093008.9273599999 37.726639146565 -122.46419270373801 (37.726639146565, -122.464192703738)
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)
137872 82840 1 31 1379 Quesada Ave 1 1 1 1   07/08/2009 12:00:00 AM 13 3x3 Permit Number 52465 6016423.5899 2093711.7525 37.729855545757 -122.38549618052299 (37.729855545757, -122.385496180523)
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)
139874 16201 3 31 500X Monterey Blvd 1 11 1 2   02/02/2003 12:00:00 AM 12 5   5998782.1299536 2094714.7967047 37.7316178141427 -122.446556643647 (37.7316178141427, -122.446556643647)
140788 34085 1 31 2851X 16th St 1 1 1 1 1 12/19/2011 12:00:00 AM 6 3x3 Permit Number 768574 6007780.97837226 2105869.55428135 37.7627561815899 -122.41623551068999 (37.7627561815899, -122.41623551069)
140792 94868 6 31 51 Princeton St   5 1 1 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
141062 48927 1 31 1362 Florida St 1 1 1 1 1 11/25/2002 12:00:00 AM     Permit Number 46117 6009515.72884218 2101239.2044667 37.7501396750607 -122.40990871780501 (37.7501396750607, -122.409908717805)
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)
142033 34048 1 31 375 Alabama St 9 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
142472 108226 1 31 240 Shotwell St 15 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
142933 63531 1 31 645 Shotwell St 1 1 1 1 1 04/10/1987 12:00:00 AM     Permit Number 24143 6007924.14567941 2104175.72058203 37.7581133535123 -122.41562041035299 (37.7581133535123, -122.415620410353)
143287 44011 1 31 405X Florida St 2 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 2 on Florida 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
144031 16312 3 31 758X Monterey Blvd 4 11 1 2   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.45247618016899 (37.7316364140758, -122.452476180169)
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)
145218 71944 1 31 1342 Shotwell St 1 1 1 1   11/04/1995 12:00:00 AM   3x3 Permit Number 50253 6008035.06455956 2100432.68279191 37.7478420534954 -122.414971880187 (37.7478420534954, -122.414971880187)
145642 108223 1 31 240 Shotwell St 12 1 1 1       3x3   6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
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)
145861 38219 1 31 118 Lyon St 1 1 1 1 1 12/09/2000 12:00:00 AM     Permit Number 40340 6000363.19569215 2109305.86913973 37.7717715527779 -122.44213760158001 (37.7717715527779, -122.44213760158)
146236 63542 1 31 2389 Folsom St 1 1 1 1 1 04/13/1987 12:00:00 AM     Permit Number 24157 6008220.818199201 2104530.13411616 37.7591031640479 -122.414619465951 (37.7591031640479, -122.414619465951)
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)
147184 215439 2 31 217 Staples Ave 6 1 1 1     13 Width 2ft   5998709.4181699995 2093777.72882 37.729040692553 -122.44674062198 (37.729040692553, -122.44674062198)
148653 215421 2 31 2085 09th Ave 1 2 1 1     7 Width 3ft   5993516.19097 2101401.9668400004 37.74967690946279 -122.46524744032101 (37.7496769094628, -122.465247440321)
149959 197978 2 31 1100 Mariposa St 1 1 1 1     7 Width 4ft   6013947.00765 2106209.45605 37.764034263084504 -122.394933045925 (37.7640342630845, -122.394933045925)
150042 241222 2 31 2800 17th St 6 1 1 1     8 Width 3ft   6009029.52417 2106399.69099 37.7642819417697 -122.411954681586 (37.7642819417697, -122.411954681586)
151347 136741 2 31 2900 Broderick St 1 9 1 1     11 Width 4ft   6000055.17715 2118534.1134099998 37.797092364871794 -122.44386618458701 (37.7970923648718, -122.443866184587)
151710 197982 2 31 601 Wisconsin St 17 9 1 1     8 Width 6ft   6012729.113 2104654.63686 37.759697277132204 -122.39903627291001 (37.7596972771322, -122.39903627291)
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)
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)
153956 241211 2 31 2801 17th St 5 1 1 1     13 Width 3ft   6009079.81613 2106354.44033 37.7641605153159 -122.411777537601 (37.7641605153159, -122.411777537601)
156017 63197 1 31 472 37th Ave 1 1 1 1 1 12/18/1986 12:00:00 AM 14   Permit Number 23738 5984415.8334099995 2112620.0121299997 37.7799494956437 -122.49754445897301 (37.7799494956437, -122.497544458973)
156645 179959 2 31 162 Tunnel Ave 3 1 1 1     13 Width 3ft   6011901.82986 2087473.4551099997 37.7124752317148 -122.400690449024 (37.7124752317148, -122.400690449024)
157293 60204 1 31 1400 16th St 1 1 1 1   06/04/1982 12:00:00 AM 8 4x4 Permit Number 19750 6012229.2906 2107053.9352 37.766257350909704 -122.400933496957 (37.7662573509097, -122.400933496957)
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)
157670 241194 2 31 699 Hampshire St 2 1 1 1     7 Width 3ft   6010150.13435 2105098.1288099997 37.7607709543248 -122.4079869968 (37.7607709543248, -122.4079869968)
157728 215438 2 31 217 Staples Ave 5 1 1 1     11 Width 2ft   5998696.43814 2093778.97623 37.7290433761531 -122.44678558449101 (37.7290433761531, -122.446785584491)
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)
158454 250756 2 31 2900 Lake St 1 4 1 1     6 Width 0ft   5986048.1037 2114785.2005 37.7859900201618 -122.492057248563 (37.7859900201618, -122.492057248563)
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)
159781 197990 2 31 155 Grace St 3 1 1 1     6 Width 2ft   6008384.453919999 2110216.9376 37.774726996282 -122.414455930021 (37.774726996282, -122.414455930021)
159970 124330 2 31 130 Palm Ave 1 1 1 1     8 Width 3ft   5995934.0004900005 2113471.95009 37.782957097905395 -122.457759890544 (37.7829570979054, -122.457759890544)
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)
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)
160717 197991 2 31 3419 Jennings St 2 2 1 1     13     6013294.96544 2089742.68292 37.7187836844998 -122.396034235213 (37.7187836844998, -122.396034235213)
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)
162786 143059 2 31 440 GREENWICH ST 1 1 1 1     11 Width 0ft   6010738.656 2120349.8129 37.8026814253217 -122.40702659346701 (37.8026814253217, -122.407026593467)
162849 241205 2 31 2389 Folsom St 1 1 1 1     12 Width 4ft   6008219.00846 2104543.8944099997 37.7591408449879 -122.414626698671 (37.7591408449879, -122.414626698671)
162886 197999 2 31 828 Jamestown Ave 1 4 1 1     10 Width 5ft   6014890.34253 2088931.57147 37.7166451650195 -122.39046296391399 (37.7166451650195, -122.390462963914)
Powered by Datasette · Query took 3.201ms · Data source: data.sfgov.org