sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
140792 94868 6 31 51 Princeton St   5 1 1 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
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)
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)
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)
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)
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)
164340 117703 2 31 4001 Clement St 7 9 1 1     10 Width 7ft   5983084.790030001 2113081.26685 37.7811378565893 -122.502183200126 (37.7811378565893, -122.502183200126)
164851 247521 2 31 1101 Waller St 2 17 1 1     5     6000007.86979 2108477.01107 37.7694754609529 -122.443307149811 (37.7694754609529, -122.443307149811)
164853 215422 2 31 15 Fairfield Way 4 1 1 1     8 Width 3ft   5993781.00975 2092831.61045 37.7261601145848 -122.46370973814 (37.7261601145848, -122.46370973814)
166118 215413 2 31 423 Flood Ave 2 9 1 1     12 Width 6ft   5997941.5079 2094069.28168 37.7297973308762 -122.44941633348999 (37.7297973308762, -122.44941633349)
166430 179960 2 31 162 Tunnel Ave 4 1 1 1     13 Width 3ft   6011897.9450900005 2087458.38855 37.7124336452757 -122.400702818282 (37.7124336452757, -122.400702818282)
166443 241208 2 31 2801 17th St 8 1 1 1     12 Width 3ft   6009151.461180001 2106358.27771 37.7641750708383 -122.41153000822901 (37.7641750708383, -122.411530008229)
167445 215432 2 31 20 Lakewood Ave 3 1 1 1     8 Width 3ft   5993607.07382 2092934.5708400002 37.7264327944236 -122.464318491921 (37.7264327944236, -122.464318491921)
168300 215431 2 31 20 Lakewood Ave 4 1 1 1     8 Width 3ft   5993618.37614 2092959.3845099998 37.726501578172396 -122.464281221309 (37.7265015781724, -122.464281221309)
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)
170469 197997 2 31 881 Jamestown Ave 19 9 1 1     9 Width 6ft   6014474.56871 2089262.00767 37.717529404523795 -122.391923191299 (37.7175294045238, -122.391923191299)
170472 241215 2 31 2801 17th St 1 1 1 1     14 Width 3ft   6008984.20306 2106349.91543 37.7641427267158 -122.412107917041 (37.7641427267158, -122.412107917041)
171952 241182 2 31 1362 Florida St 1 1 1 1     11 Width 3ft   6009519.86871 2101254.76714 37.7501826387226 -122.409895500292 (37.7501826387226, -122.409895500292)
172140 115615 1 31 1400 16th St 5 1 1 1     7 4x4   6012069.0366 2107045.8512 37.766226213653 -122.40148722008699 (37.766226213653, -122.401487220087)
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)
173632 241206 2 31 2387 Folsom St 1 1 1 1     13 Width 4ft   6008217.68506 2104568.2265 37.759207580982 -122.414632997525 (37.759207580982, -122.414632997525)
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)
174371 179957 2 31 162 Tunnel Ave 1 1 1 1     12 Width 3ft   6011927.1671400005 2087557.3453099998 37.7127069906044 -122.40060876447599 (37.7127069906044, -122.400608764476)
175277 241199 2 31 24 Carl St 1 1 1 1     9 Width 4ft   5998508.2304 2107266.01278 37.7660647371231 -122.448407097228 (37.7660647371231, -122.448407097228)
175537 136749 2 31 1360 Jones St 4 9 1 1     8 Width 2ft   6008500.72583 2117239.96883 37.794017078290295 -122.41455079677701 (37.7940170782903, -122.414550796777)
178056 136744 2 31 2906 Broderick St 2 9 1 1     11 Width 4ft   6000047.06944 2118581.72583 37.7972226334754 -122.44389766175101 (37.7972226334754, -122.443897661751)
178127 197992 2 31 881 Jamestown Ave 11 9 1 1     6 Width 6ft   6014311.92 2089359.19845 37.717787240171795 -122.392492192366 (37.7177872401718, -122.392492192366)
178204 197987 2 31 2 Bridgeview Dr 4 7 1 1     9     6014076.35565 2095353.09382 37.734232186468894 -122.39372574026501 (37.7342321864689, -122.393725740265)
178207 198003 3 31 920x Jamestown Ave 1 11 1 2     12 Width 5ft   6014527.01214 2089285.60779 37.7175971171782 -122.391743566112 (37.7175971171782, -122.391743566112)
178324 215437 2 31 217 Staples Ave 4 1 1 1     12 Width 2ft   5998668.44451 2093778.0926299999 37.729039350777 -122.44688229669701 (37.729039350777, -122.446882296697)
178543 197994 2 31 881 Jamestown Ave 14 9 1 1     9 Width 6ft   6014370.9162 2089321.9827 37.717688329142604 -122.392285665748 (37.7176883291426, -122.392285665748)
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)
178635 182656 2 31 2618 Ortega St 3 2 1 1     7 Width 0ft   5985872.0635 2102330.847 37.7517835760889 -122.491749119446 (37.7517835760889, -122.491749119446)
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)
181600 241204 2 31 2399 Folsom St 2 1 1 1     7 Width 4ft   6008220.32471 2104519.20022 37.759073114347295 -122.414620398932 (37.7590731143473, -122.414620398932)
181948 215424 2 31 15 Fairfield Way 6 1 1 1     8 Width 3ft   5993760.13704 2092800.2871 37.7260729055276 -122.463779620842 (37.7260729055276, -122.463779620842)
182005 197998 2 31 881 Jamestown Ave 20 9 1 1     6 Width 6ft   6014511.88744 2089238.1825599999 37.717466057201705 -122.391792531525 (37.7174660572017, -122.391792531525)
182308 197996 2 31 881 Jamestown Ave 17 9 1 1     8 Width 6ft   6014434.42252 2089286.69966 37.7175949749992 -122.392063685205 (37.7175949749992, -122.392063685205)
182516 215434 2 31 20 Lakewood Ave 1 1 1 1     12 Width 3ft   5993586.39661 2092891.1654599998 37.7263124219742 -122.464386821508 (37.7263124219742, -122.464386821508)
184005 197977 2 31 1301 Minnesota St 73 7 1 1     3     6015364.560269999 2102275.50149 37.7533111867689 -122.389755314382 (37.7533111867689, -122.389755314382)
184240 197993 2 31 881 Jamestown Ave 12 9 1 1     8 Width 6ft   6014330.76175 2089346.27019 37.7177527880479 -122.392426160549 (37.7177527880479, -122.392426160549)
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)
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)
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)
186537 182441 2 31 1529 34th Ave 1 1 1 1     5 Width 0ft   5985572.6922 2104787.172 37.7585104674539 -122.492965288536 (37.7585104674539, -122.492965288536)
186902 197986 2 31 498 Mississippi St 1 4 1 1     10 Width 3ft   6014051.93568 2104880.86729 37.7603920825505 -122.394477092339 (37.7603920825505, -122.394477092339)
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)
188005 215430 2 31 20 Lakewood Ave 5 1 1 1     9 Width 3ft   5993628.724219999 2092981.5344200002 37.72656299287289 -122.464247056069 (37.7265629928729, -122.464247056069)
188473 215418 2 31 286 Orizaba Ave 3 10 1 1     10     5994025.68496 2088506.9373700002 37.7142996980529 -122.462550356439 (37.7142996980529, -122.462550356439)
188528 246216 2 31 725 Buena Vista Ave West 4 1 1 1     4 Width 0ft   5999835.3063 2107870.2944 37.7677997276311 -122.443860441452 (37.7677997276311, -122.443860441452)
188676 241203 2 31 2399 Folsom St 1 1 1 1     7 Width 4ft   6008221.76709 2104500.66986 37.759022315257894 -122.414614099173 (37.7590223152579, -122.414614099173)
189124 179961 2 31 299 Lathrop Ave 2 1 1 1     5 Width 3ft   6012198.832140001 2086842.9214 37.7107604718955 -122.399619668515 (37.7107604718955, -122.399619668515)
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)
69093 114917 1 31 86 Carr St 2 1 1 1   01/04/2016 12:00:00 AM 8   Permit 774770 6012955.87899 2090602.59506 37.721125958889104 -122.397266597771 (37.7211259588891, -122.397266597771)
26649 49071 1 31 1970 Ocean Ave 7 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)
89857 49072 1 31 1970 Ocean Ave 6 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)
93667 49070 1 31 1970 Ocean Ave 2 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)
95324 49073 1 31 1970 Ocean Ave 5 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)
99383 49074 1 31 1970 Ocean Ave 4 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)
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)
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)
93469 69068 1 31 1407 14th Ave 1 1 1 1 1 01/10/1994 12:00:00 AM     Permit Number 33076 5991768.06854816 2105844.04694914 37.76177273191679 -122.471616117782 (37.7617727319168, -122.471616117782)
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)
94982 39859 1 31 70 13th St 2 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)
101513 83941 1 31 60 13th St 1 1 1 1   01/18/2008 12:00:00 AM   3X3 Permit Number 50121 6008302.41836553 2108360.42350377 37.7696248364946 -122.41460830425899 (37.7696248364946, -122.414608304259)
107863 39860 1 31 70 13th St 3 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)
Powered by Datasette · Query took 5.443ms · Data source: data.sfgov.org