sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
59728 244843 2 75 90 Bartlett St 1 2 1 1     11 Width 9ft   6006632.98295 2103729.04135 37.7568142125173 -122.4200541162 (37.7568142125173, -122.4200541162)
62711 203188 2 75 2212 25th St 1 9 1 1     18 Width 9ft   6012161.98551 2101908.2137 37.752124581703896 -122.400804745651 (37.7521245817039, -122.400804745651)
171385 244815 2 75 451 Florida St 7 9 1 1     17 Width 9ft   6009251.4171400005 2106274.41145 37.7639503995181 -122.411178363391 (37.7639503995181, -122.411178363391)
187703 187521 3 75 100x Mary Teresa St 1 3 1 2     15 Width 9ft   6012597.41848 2087914.4030799998 37.7137247587658 -122.398317184005 (37.7137247587658, -122.398317184005)
37483 217487 2 75 15 Staples Ave 2 9 1 1     7 Width 8ft   5999757.91748 2093744.86936 37.729010308071 -122.44311353116501 (37.729010308071, -122.443113531165)
38493 181278 2 75 46 Admiral Ave 2 9 1 1     9 Width 8ft   6003332.53306 2094181.6518 37.730412786411904 -122.430786976247 (37.7304127864119, -122.430786976247)
44790 244846 2 75 90 Bartlett St 9 2 1 1     11 Width 8ft   6006641.954969999 2103569.5656 37.75637683445171 -122.42001177073901 (37.7563768344517, -122.420011770739)
52123 244847 2 75 90 Bartlett St 17 1 1 1     10 Width 8ft   6006653.79898 2103383.59728 37.7558668756582 -122.41995761356002 (37.7558668756582, -122.41995761356)
134129 244845 2 75 90 Bartlett St 8 2 1 1     10 Width 8ft   6006641.10837 2103579.2022 37.756403246631606 -122.42001538241999 (37.7564032466316, -122.42001538242)
151854 217482 2 75 19 Melrose Ave 1 9 1 1     4 Width 8ft   5999956.53878 2095464.0242299999 37.7337420298675 -122.442550265996 (37.7337420298675, -122.442550265996)
188775 246732 2 75 101 Ripley St 5 9 1 1     20 Width 8ft   6008546.25114 2099104.34804 37.7442234529633 -122.41311030320101 (37.7442234529633, -122.413110303201)
25274 203174 2 75 331 Pennsylvania Ave 2 9 1 1     20 Width 7ft   6014370.72377 2105559.7788 37.7622739427176 -122.39342205628999 (37.7622739427176, -122.39342205629)
156331 202029 2 75 1331 Fitzgerald Ave 1 9 1 1     20 Width 7ft   6013954.19623 2091006.8516900002 37.7222914964254 -122.39384396154199 (37.7222914964254, -122.393843961542)
185076 244824 2 75 773 Dolores St 2 2 1 1     4 Width 7ft   6005057.02214 2103838.7107 37.757026420139 -122.42551217995701 (37.757026420139, -122.425512179957)
25234 244842 2 75 41 Bartlett St 1 1 1 1     11 Width 6ft   6006681.50629 2103383.71332 37.755868755243704 -122.419861800707 (37.7558687552437, -122.419861800707)
27734 181258 3 75 2400x Bay Shore Blvd 3 11 1 2     15 Width 6ft   6010956.04386 2086896.41565 37.7108380015362 -122.403918812817 (37.7108380015362, -122.403918812817)
29208 181257 3 75 2400x Bay Shore Blvd 2 11 1 2     15 Width 6ft   6010977.11587 2086929.96483 37.7109312981009 -122.40384834192801 (37.7109312981009, -122.403848341928)
32803 243929 2 75 1409 Douglass St 1 9 1 1     15 Width 6ft   6001410.85086 2099557.6127299997 37.745064858666 -122.437815383076 (37.745064858666, -122.437815383076)
33738 181254 3 75 2200x Bay Shore Blvd 13 11 1 2     15 Width 6ft   6011072.17285 2087082.1734200001 37.711354542437 -122.403530502643 (37.711354542437, -122.403530502643)
35882 181250 3 75 2200x Bay Shore Blvd 9 11 1 2     15 Width 6ft   6011135.05622 2087186.9706 37.7116458067799 -122.403320528015 (37.7116458067799, -122.403320528015)
40752 181255 3 75 2200x Bay Shore Blvd 14 11 1 2     15 Width 6ft   6011058.3910300005 2087059.24952 37.71129082818 -122.403576524557 (37.71129082818, -122.403576524557)
42000 181235 3 75 2100x Bay Shore Blvd 4 11 1 2     16 Width 6ft   6011766.34512 2087531.33968 37.7126266136928 -122.401162793634 (37.7126266136928, -122.401162793634)
42138 181261 3 75 2400x Bay Shore Blvd 6 11 1 2     15 Width 6ft   6010896.06222 2086791.14453 37.710545596879705 -122.40411872042299 (37.7105455968797, -122.404118720423)
42329 181252 3 75 2200x Bay Shore Blvd 11 11 1 2     15 Width 6ft   6011104.47177 2087135.7976799998 37.711503587981205 -122.403422638862 (37.7115035879812, -122.403422638862)
44652 181259 3 75 2400x Bay Shore Blvd 4 11 1 2     15 Width 6ft   6010937.034659999 2086861.99587 37.710742429686206 -122.40398209272499 (37.7107424296862, -122.403982092725)
44785 243930 2 75 1351 Douglass St 2 9 1 1     18 Width 6ft   6001401.88208 2099729.52286 37.7455363732181 -122.437858706116 (37.7455363732181, -122.437858706116)
45408 244813 2 75 45 Hoff St 3 1 1 1     20 Width 6ft   6006570.0042 2106423.3785 37.7642086856934 -122.42046316294599 (37.7642086856934, -122.420463162946)
48660 243926 2 75 41 Bartlett St 1 10 1 1     11 Width 6ft   6006689.91006 2103386.78803 37.7558776711221 -122.41983295584299 (37.7558776711221, -122.419832955843)
48782 181251 3 75 2200x Bay Shore Blvd 10 11 1 2     15 Width 6ft   6011120.84177 2087163.22682 37.7115798172183 -122.40336798793999 (37.7115798172183, -122.40336798794)
57972 181260 3 75 2400x Bay Shore Blvd 5 11 1 2     15 Width 6ft   6010918.05044 2086828.8185599998 37.7106502707697 -122.40404537351601 (37.7106502707697, -122.404045373516)
59707 243931 2 75 784 Duncan St 3 9 1 1     8 Width 6ft   6001427.70796 2099722.90348 37.7455196665071 -122.437768930406 (37.7455196665071, -122.437768930406)
60011 181246 3 75 2200x Bay Shore Blvd 5 11 1 2     15 Width 6ft   6011206.95507 2087284.9541099998 37.711918865232 -122.403078912559 (37.711918865232, -122.403078912559)
60293 244814 2 75 45 Hoff St 4 1 1 1     23 Width 6ft   6006569.6779 2106452.55606 37.7642887820295 -122.420466362743 (37.7642887820295, -122.420466362743)
61157 243933 2 75 784 Duncan St 7 9 1 1     5 Width 6ft   6001410.80109 2099722.64145 37.7455179856652 -122.437827372845 (37.7455179856652, -122.437827372845)
64107 244844 2 75 90 Bartlett St 2 2 1 1     10 Width 6ft   6006630.92083 2103720.4372 37.7567904713264 -122.420060637198 (37.7567904713264, -122.420060637198)
67886 181273 2 75 328 Palmetto Ave 4 9 1 1     17 Width 6ft   5993253.89248 2087254.87445 37.710817354905295 -122.465127066954 (37.7108173549053, -122.465127066954)
76881 243925 2 75 33 Bartlett St 1 10 1 1     10 Width 6ft   6006679.07286 2103590.73607 37.7564370548525 -122.41988490606501 (37.7564370548525, -122.419884906065)
135845 243924 2 75 33 Bartlett St 2 10 1 1     10 Width 6ft   6006678.4863599995 2103600.0339099998 37.7564625515326 -122.419887594147 (37.7564625515326, -122.419887594147)
136431 181236 3 75 2100x Bay Shore Blvd 5 11 1 2     14 Width 6ft   6011740.78696 2087511.07022 37.712569531933 -122.401249707721 (37.712569531933, -122.401249707721)
137624 217466 2 75 380 Ralston St 1 9 1 1     13 Width 6ft   5992234.1227 2090402.1103 37.7194000456453 -122.46888047296801 (37.7194000456453, -122.468880472968)
147181 243932 2 75 784 Duncan St 6 9 1 1     5 Width 6ft   6001413.8789800005 2099722.88395 37.745518826532 -122.43781674736799 (37.745518826532, -122.437816747368)
147977 181274 2 75 328 Palmetto Ave 1 9 1 1     16 Width 6ft   5993286.62087 2087254.83892 37.7108191445702 -122.46501394844 (37.7108191445702, -122.46501394844)
148566 181253 3 75 2200x Bay Shore Blvd 12 11 1 2     15 Width 6ft   6011090.2657 2087112.4680700002 37.7114387360727 -122.403470098762 (37.7114387360727, -122.403470098762)
148908 118014 2 75 472 37th Ave 2 2 1 1     21 Width 6ft   5984415.81444 2112632.82053 37.779984662684704 -122.49754547051 (37.7799846626847, -122.49754547051)
150822 181256 3 75 2400x Bay Shore Blvd 1 11 1 2     15 Width 6ft   6010998.20467 2086964.34233 37.7110268699605 -122.40377787107799 (37.7110268699605, -122.403777871078)
153688 217480 2 75 271 Mangels Ave 2 9 1 1     20 Width 6ft   5999643.16837 2095215.32408 37.7330412898258 -122.44361581691099 (37.7330412898258, -122.443615816911)
159888 181249 3 75 2200x Bay Shore Blvd 8 11 1 2     15 Width 6ft   6011154.37999 2087216.41128 37.7117277242201 -122.40325580920602 (37.7117277242201, -122.403255809206)
167542 181237 3 75 2100x Bay Shore Blvd 6 11 1 2     14 Width 6ft   6011709.60443 2087494.2224299998 37.712521531527294 -122.40135630166 (37.7125215315273, -122.40135630166)
174910 181219 2 75 519 Lisbon St 1 2 1 1     21 Width 6ft   6002044.02941 2090439.9964599998 37.720065958565 -122.434974017336 (37.720065958565, -122.434974017336)
175756 181248 3 75 2200x Bay Shore Blvd 7 11 1 2     15 Width 6ft   6011168.55226 2087238.084 37.7117880246642 -122.403208349279 (37.7117880246642, -122.403208349279)
183212 181247 3 75 2200x Bay Shore Blvd 6 11 1 2     14 Width 6ft   6011190.75371 2087265.8089 37.7118653915605 -122.40313356348899 (37.7118653915605, -122.403133563489)
1512 243955 1 75 80 South Van Ness Ave 1 1 1 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007056.3814199995 2109908.18867 37.773804548164705 -122.419028109365 (37.7738045481647, -122.419028109365)
1514 243952 1 75 10 South Van Ness Ave 5 1 1 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007022.68787 2110044.22077 37.7741761624211 -122.41915431212601 (37.7741761624211, -122.419154312126)
1515 243950 1 75 10 South Van Ness Ave 3 1 1 1   07/14/2004 12:00:00 AM 13 Width 5ft Permit Number 47529 6007004.81099 2110130.42285 37.774411845966895 -122.419222267617 (37.7744118459669, -122.419222267617)
1516 243951 1 75 10 South Van Ness Ave 4 1 1 1   07/14/2004 12:00:00 AM 14 Width 5ft Permit Number 47529 6007014.66541 2110083.11128 37.774282494675795 -122.419184822535 (37.7742824946758, -122.419184822535)
1518 243948 1 75 10 South Van Ness Ave 1 1 1 1   07/14/2004 12:00:00 AM 11 Width 5ft Permit Number 47529 6006987.09759 2110205.04369 37.774615739356705 -122.41928883630399 (37.7746157393567, -122.419288836304)
1519 243949 1 75 10 South Van Ness Ave 2 1 1 1   07/14/2004 12:00:00 AM 12 Width 5ft Permit Number 47529 6006997.017419999 2110160.92453 37.7744951573695 -122.41925139124399 (37.7744951573695, -122.419251391244)
1521 243954 1 75 10 South Van Ness Ave 7 1 1 1   07/14/2004 12:00:00 AM 15 Width 5ft Permit Number 47529 6007048.80869 2109949.46518 37.773917457170796 -122.41905723302 (37.7739174571708, -122.41905723302)
1533 243953 1 75 10 South Van Ness Ave 6 1 1 1   07/14/2004 12:00:00 AM 14 Width 5ft Permit Number 47529 6007037.92355 2109985.61989 37.7740161163944 -122.41909745161301 (37.7740161163944, -122.419097451613)
23753 199483 2 75 1300 03rd St 4 1 1 1     13 Width 5ft   6015509.13182 2108964.41049 37.7716855044225 -122.38972250619801 (37.7716855044225, -122.389722506198)
23814 247646 2 75 900 Duboce Ave 2 4 1 1     13 Width 5ft   6001616.30949 2108303.20625 37.769089824469496 -122.43773118404499 (37.7690898244695, -122.437731184045)
27009 199444 2 75 1515 03rd St 1 1 1 1     20 Width 5ft   6015656.62698 2107992.23345 37.769024297155205 -122.389144413879 (37.7690242971552, -122.389144413879)
27058 247653 2 75 900 Duboce Ave 9 4 1 1     15 Width 5ft   6001528.81511 2108296.30035 37.7690658872209 -122.438033326596 (37.7690658872209, -122.438033326596)
28387 199462 2 75 1530 03rd St 14 1 1 1     11 Width 5ft   6015592.103080001 2107492.64638 37.7676489630463 -122.389332708559 (37.7676489630463, -122.389332708559)
28662 247652 2 75 900 Duboce Ave 8 4 1 1     14 Width 5ft   6001539.54665 2108297.82153 37.7690706742937 -122.437996315894 (37.7690706742937, -122.437996315894)
30691 244835 2 75 1880 Mission St 1 1 1 1     15 Width 5ft   6006729.90929 2107524.20157 37.7672402967355 -122.41998822018101 (37.7672402967355, -122.419988220181)
31881 199455 2 75 1401 03rd St 7 1 1 1     17 Width 5ft   6015625.9056 2108540.0716 37.7705268376657 -122.389288938555 (37.7705268376657, -122.389288938555)
32638 199456 2 75 1279 03rd St 1 1 1 1     16 Width 5ft   6015610.82208 2108808.9255 37.77126421521471 -122.38935989056299 (37.7712642152147, -122.389359890563)
32681 181225 3 75 2000x Bay Shore Blvd 9 11 1 2     14 Width 5ft   6012142.64872 2087966.32727 37.713841988985 -122.399892688298 (37.713841988985, -122.399892688298)
33501 199465 2 75 1530 03rd St 20 1 1 1     14 Width 5ft   6015601.020959999 2107350.5744 37.7672593587506 -122.389291940488 (37.7672593587506, -122.389291940488)
33585 137505 2 75 2521 Leavenworth St 2 1 1 1     17 Width 5ft   6007440.6556 2121042.48362 37.8043982179661 -122.41848851434601 (37.8043982179661, -122.418488514346)
33786 199476 2 75 1240 03rd St 3 1 1 1     15 Width 5ft   6015490.48538 2109320.84762 37.772663168207 -122.389811906894 (37.772663168207, -122.389811906894)
35626 199488 2 75 1300 03rd St 12 1 1 1     15 Width 5ft   6015518.167640001 2108801.30732 37.7712381600557 -122.38967985676099 (37.7712381600557, -122.389679856761)
36914 247654 2 75 900 Duboce Ave 10 4 1 1     15 Width 5ft   6001517.12711 2108295.57391 37.7690632279012 -122.438073702561 (37.7690632279012, -122.438073702561)
38378 203183 2 75 1900 03rd St 28 1 1 1     10 Width 5ft   6015658.44629 2106386.7571400004 37.7646161091615 -122.38902601186001 (37.7646161091615, -122.38902601186)
39967 199470 2 75 1050 03rd St 7 1 1 1     19 Width 5ft   6015462.75637 2109791.03207 37.7739526530238 -122.38994067543001 (37.7739526530238, -122.38994067543)
40393 244837 2 75 1880 Mission St 3 1 1 1     16 Width 5ft   6006731.37022 2107461.01908 37.7670668948411 -122.41997868286998 (37.7670668948411, -122.41997868287)
40665 244841 2 75 1880 Mission St 7 1 1 1     13 Width 5ft   6006736.38106 2107369.27612 37.766815272626296 -122.41995484006901 (37.7668152726263, -122.419954840069)
43387 247655 2 75 900 Duboce Ave 11 4 1 1     14 Width 5ft   6001504.48718 2108295.83572 37.769063227919105 -122.43811744198601 (37.7690632279191, -122.438117441986)
44421 199463 2 75 1530 03rd St 16 1 1 1     13 Width 5ft   6015595.21944 2107438.50948 37.7675004876899 -122.38931814851999 (37.7675004876899, -122.38931814852)
44505 181226 3 75 2000x Bay Shore Blvd 10 11 1 2     14 Width 5ft   6012120.3534699995 2087937.9432299999 37.713762809074 -122.39996775739901 (37.713762809074, -122.399967757399)
45072 181223 3 75 2000x Bay Shore Blvd 7 11 1 2     15 Width 5ft   6012185.06666 2088017.9901400001 37.7139862096601 -122.399749700601 (37.7139862096601, -122.399749700601)
45676 181228 3 75 2000x Bay Shore Blvd 12 11 1 2     13 Width 5ft   6012082.02881 2087884.13753 37.7136129325747 -122.400096445907 (37.7136129325747, -122.400096445907)
52239 199453 2 75 1401 03rd St 3 1 1 1     20 Width 5ft   6015629.79574 2108466.51232 37.7703250756792 -122.389270345061 (37.7703250756792, -122.389270345061)
52425 247649 2 75 900 Duboce Ave 5 4 1 1     14 Width 5ft   6001576.55462 2108299.96127 37.7690786539981 -122.437868461073 (37.7690786539981, -122.437868461073)
54749 137504 2 75 2521 Leavenworth St 1 1 1 1     16 Width 5ft   6007440.32409 2121045.18765 37.8044056238841 -122.41848985342399 (37.8044056238841, -122.418489853424)
54820 199491 2 75 991 Mission St 1 1 1 1     21 Width 5ft   6010160.462780001 2112475.94927 37.7810293246804 -122.408471707117 (37.7810293246804, -122.408471707117)
56235 199464 2 75 1530 03rd St 18 1 1 1     12 Width 5ft   6015598.48485 2107402.1848299997 37.7674009291493 -122.389304316962 (37.7674009291493, -122.389304316962)
57434 199481 2 75 1300 03rd St 2 1 1 1     18 Width 5ft   6015507.548169999 2109003.40137 37.77179247697679 -122.389730708003 (37.7717924769768, -122.389730708003)
59290 199446 2 75 1515 03rd St 5 1 1 1     21 Width 5ft   6015650.90558 2108071.91419 37.7692427658814 -122.38916976848199 (37.7692427658814, -122.389169768482)
60522 247645 2 75 900 Duboce Ave 1 4 1 1     14 Width 5ft   6001626.8491400005 2108303.83597 37.7690921528084 -122.437694773193 (37.7690921528084, -122.437694773193)
60563 181224 3 75 2000x Bay Shore Blvd 8 11 1 2     14 Width 5ft   6012163.826230001 2087990.6147200002 37.713909858116104 -122.39982119490601 (37.7139098581161, -122.399821194906)
60777 181229 3 75 2000x Bay Shore Blvd 13 11 1 2     14 Width 5ft   6012059.81705 2087859.8714700001 37.713545064337296 -122.400171515023 (37.7135450643373, -122.400171515023)
61712 203182 2 75 1900 03rd St 26 1 1 1     10 Width 5ft   6015656.28581 2106435.78787 37.7647506171774 -122.38903690803998 (37.7647506171774, -122.38903690804)
62268 181231 3 75 2000x Bay Shore Blvd 15 11 1 2     15 Width 5ft   6012012.90847 2087803.8646200001 37.713388665025 -122.40032971745 (37.713388665025, -122.40032971745)
63273 199485 2 75 1300 03rd St 8 1 1 1     15 Width 5ft   6015513.12326 2108880.27223 37.7714547006117 -122.389702821822 (37.7714547006117, -122.389702821822)
64963 199457 2 75 1279 03rd St 3 1 1 1     19 Width 5ft   6015609.11002 2108848.45381 37.7713726563476 -122.389368573515 (37.7713726563476, -122.389368573515)
65089 199459 2 75 1279 03rd St 6 1 1 1     16 Width 5ft   6015601.45578 2108929.3451900003 37.7715943419254 -122.389400699999 (37.7715943419254, -122.389400699999)
65873 199487 2 75 1300 03rd St 10 1 1 1     16 Width 5ft   6015516.37079 2108841.48357 37.7713483755645 -122.38968887873399 (37.7713483755645, -122.389688878734)
66564 199468 2 75 1050 03rd St 3 1 1 1     16 Width 5ft   6015459.06425 2109878.23066 37.77419187628129 -122.38995953961799 (37.7741918762813, -122.389959539618)
67150 199493 2 75 281 06th St 2 1 1 1     20 Width 5ft   6010934.97193 2111623.29262 37.7787314723253 -122.405732204886 (37.7787314723253, -122.405732204886)
Powered by Datasette · Query took 6.2ms · Data source: data.sfgov.org