sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
188342 70057 2 31 1799 Revere Ave 4 1 1 1 1 08/18/1990 12:00:00 AM 12     6014037.2583099995 2095146.8497099997 37.7336637097057 -122.393846481427 (37.7336637097057, -122.393846481427)
73423 72214 2 31 1799 Revere Ave 3 1 1 1 1 08/18/1990 12:00:00 AM 12     6014033.56934 2095149.8862 37.7336718422767 -122.39385944784901 (37.7336718422767, -122.393859447849)
109559 98644 2 31 2391 Folsom St 1 1 1 1     8 3x3   6008222.0 2104509.0 37.7590452010005 -122.414613883143 (37.7590452010005, -122.414613883143)
112993 99104 2 31 3644 20th St 1 1 1 1       3x3   6006000.9 2104423.0 37.7586840282695 -122.422289399469 (37.7586840282695, -122.422289399469)
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)
87668 103568 2 31 223 Parnassus Ave 1 1 1 1     8 3x3   5997125.5 2106655.6 37.76430954658429 -122.45314559026801 (37.7643095465843, -122.453145590268)
106980 108282 2 31 1 HENRY ADAMS ST 7 5 1 1     10 3x3   6011517.4 2108140.5 37.769201076268395 -122.40347225564399 (37.7692010762684, -122.403472255644)
96207 108286 2 31 1 HENRY ADAMS ST 11 5 1 1       3x3   6011517.4 2108140.5 37.769201076268395 -122.40347225564399 (37.7692010762684, -122.403472255644)
80952 109314 2 31 1516 BROADWAY 1 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)
53611 109316 2 31 1516 BROADWAY 3 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)
34945 113776 2 31 1710 Baker St 1 1 1 1     12 3x3   6000070.198 2114878.1306 37.7870548531015 -122.443551447546 (37.7870548531015, -122.443551447546)
110112 115632 2 31 55x 15TH ST 4 1 1 1       4x4   6012114.0 2107494.0 37.7674592382642 -122.40136319642001 (37.7674592382642, -122.40136319642)
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)
24481 117708 2 31 4001 Clement St 2 9 1 1     7 Width 7ft   5983029.04687 2113077.7485700003 37.7811249212832 -122.50237578006501 (37.7811249212832, -122.502375780065)
44646 119965 2 31 518 28th Ave 1 1 1 1     4 Width 4ft   5987217.06494 2112373.1551 37.7794354929176 -122.48783573328801 (37.7794354929176, -122.487835733288)
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)
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)
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)
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)
26722 136742 2 31 2900 Broderick St 2 9 1 1     11 Width 4ft   6000053.33945 2118542.13589 37.79711428765071 -122.443873120143 (37.7971142876507, -122.443873120143)
109031 136743 2 31 2900 Broderick St 4 9 1 1     10 Width 4ft   6000050.877859999 2118557.23395 37.7971556025074 -122.44388272313 (37.7971556025074, -122.44388272313)
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)
37691 136745 2 31 2908 Broderick St 1 9 1 1     11 Width 4ft   6000044.84961 2118592.59728 37.797252356970205 -122.44390612438801 (37.7972523569702, -122.443906124388)
35806 136746 2 31 2908 Broderick St 3 9 1 1     11 Width 4ft   6000043.09421 2118605.60705 37.7972879782152 -122.44391313370501 (37.7972879782152, -122.443913133705)
27899 136747 2 31 2859 Filbert St 4 9 1 1     10 Width 4ft   5999233.55999 2118349.36625 37.796538199022606 -122.446695870812 (37.7965381990226, -122.446695870812)
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)
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)
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)
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)
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)
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)
51116 179953 2 31 240 Peabody St 1 4 1 1     17 Width 3ft   6009701.772480001 2086128.1297 37.708658289510204 -122.408199733244 (37.7086582895102, -122.408199733244)
30518 179954 2 31 40 Tomaso Ct 1 4 1 1     23 Width 2ft   6009197.20014 2086405.9588 37.709392885454 -122.409963207553 (37.709392885454, -122.409963207553)
64095 179955 2 31 78 Sala Ter 2 9 1 1     16 Width 6ft   5998862.1125 2088471.1679599998 37.7144788232093 -122.445831259031 (37.7144788232093, -122.445831259031)
59883 179956 2 31 78 Sala Ter 1 9 1 1     14 Width 6ft   5998852.5351599995 2088480.84158 37.7145048379104 -122.44586505733999 (37.7145048379104, -122.44586505734)
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)
23598 179958 2 31 162 Tunnel Ave 2 1 1 1     14 Width 3ft   6011915.65824 2087516.33041 37.7125937299935 -122.40064566366999 (37.7125937299935, -122.40064566367)
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)
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)
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)
28207 179962 2 31 299 Lathrop Ave 4 1 1 1     5 Width 3ft   6012155.6977 2086855.9290099998 37.710793783685006 -122.39976966465599 (37.710793783685, -122.399769664656)
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)
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)
135775 179965 2 31 86 Arago St 2 9 1 1     9     5999606.18552 2093002.3803299998 37.726962952855104 -122.443584762453 (37.7269629528551, -122.443584762453)
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)
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)
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)
66988 179969 2 31 623 Goettingen St 2 1 1 1     4 Width 4ft   6010613.39722 2091824.0219599998 37.7243490517445 -122.40544989510599 (37.7243490517445, -122.405449895106)
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)
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)
41866 181367 2 31 4019 Judah St 1 1 1 1     6 Width 0ft   5982046.1498 2105540.3564 37.76037163028771 -122.505217265817 (37.7603716302877, -122.505217265817)
28815 182351 2 31 1501 35th Ave 2 2 1 1     10 Width 0ft   5985257.4301 2104935.3862 37.758898980602005 -122.49406651392 (37.758898980602, -122.49406651392)
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)
55615 182655 2 31 2618 Ortega St 2 2 1 1     10 Width 0ft   5985877.3992 2102330.3619999997 37.7517825562574 -122.49173063243201 (37.7517825562574, -122.491730632432)
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)
46627 182665 2 31 2618 Ortega St 1 2 1 1     9 Width 0ft   5985884.1902 2102331.3321 37.7517856167847 -122.491707219971 (37.7517856167847, -122.491707219971)
42196 183595 2 31 2639 22nd Ave 1 1 1 1     10 Width 0ft   5989548.2713 2097387.6993 37.7384251583472 -122.478674965089 (37.7384251583472, -122.478674965089)
184005 197977 2 31 1301 Minnesota St 73 7 1 1     3     6015364.560269999 2102275.50149 37.7533111867689 -122.389755314382 (37.7533111867689, -122.389755314382)
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)
37345 197979 2 31 601 Wisconsin St 21 2 1 1     11 Width 3ft   6012714.266419999 2104668.82572 37.759735409279706 -122.39908861614599 (37.7597354092797, -122.399088616146)
42049 197980 2 31 601 Wisconsin St 19 9 1 1     12 Width 6ft   6012727.8948800005 2104659.33214 37.759710101458204 -122.399040815374 (37.7597101014582, -122.399040815374)
44751 197981 2 31 601 Wisconsin St 18 9 1 1     11 Width 6ft   6012726.35291 2104657.30852 37.759704459115795 -122.39904600628 (37.7597044591158, -122.39904600628)
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)
49851 197983 2 31 1809 19th St 5 9 1 1     8 Width 6ft   6012297.3164 2105130.82765 37.760980720296295 -122.400563103211 (37.7609807202963, -122.400563103211)
67671 197984 2 31 1177 De Haro St 3 9 1 1     5 Width 4ft   6012264.79545 2102939.83963 37.754962935614294 -122.40052167053999 (37.7549629356143, -122.40052167054)
50744 197985 2 31 669 Mississippi St 2 4 1 1     9 Width 3ft   6014155.897999999 2104063.80675 37.758154390328 -122.394060332116 (37.758154390328, -122.394060332116)
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)
178204 197987 2 31 2 Bridgeview Dr 4 7 1 1     9     6014076.35565 2095353.09382 37.734232186468894 -122.39372574026501 (37.7342321864689, -122.393725740265)
51881 197988 2 31 82 Carolina St 1 1 1 1     10 Width 4ft   6012221.12319 2107462.35445 37.7673783228879 -122.40099044576 (37.7673783228879, -122.40099044576)
51602 197989 2 31 28 15th St 5 1 1 1     6 Width 4ft   6012209.71616 2107476.11774 37.7674154774686 -122.401030868501 (37.7674154774686, -122.401030868501)
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)
160717 197991 2 31 3419 Jennings St 2 2 1 1     13     6013294.96544 2089742.68292 37.7187836844998 -122.396034235213 (37.7187836844998, -122.396034235213)
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)
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)
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)
40655 197995 2 31 881 Jamestown Ave 16 9 1 1     6 Width 6ft   6014417.48937 2089293.51791 37.717612756412 -122.392122692435 (37.717612756412, -122.392122692435)
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)
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)
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)
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)
57252 199656 2 31 1395 Donner Ave 1 1 1 1     13 Width 0ft   6015030.8215 2090912.727 37.7220928214053 -122.39011571883199 (37.7220928214053, -122.390115718832)
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)
29244 215411 2 31 1939 16th Ave 1 1 1 1     10 Width 2ft   5991245.12391 2102202.13663 37.7517427376545 -122.473159145982 (37.7517427376545, -122.473159145982)
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)
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)
64723 215414 2 31 423 Flood Ave 3 9 1 1     13 Width 6ft   5997954.5929 2094069.3346400002 37.7297982247933 -122.449371101191 (37.7297982247933, -122.449371101191)
59497 215415 2 31 484 Faxon Ave 8 9 1 1     7 Width 3ft   5994798.18805 2091784.9127099998 37.7233446951982 -122.460117638125 (37.7233446951982, -122.460117638125)
41547 215416 2 31 286 Orizaba Ave 1 10 1 1     12     5994027.68196 2088444.22736 37.7141276262766 -122.462538908049 (37.7141276262766, -122.462538908049)
34503 215417 2 31 286 Orizaba Ave 2 10 1 1     12     5994025.97554 2088461.57938 37.7141751725286 -122.46254606394699 (37.7141751725286, -122.462546063947)
188473 215418 2 31 286 Orizaba Ave 3 10 1 1     10     5994025.68496 2088506.9373700002 37.7142996980529 -122.462550356439 (37.7142996980529, -122.462550356439)
33234 215420 2 31 2085 09th Ave 2 2 1 1     7 Width 3ft   5993528.81827 2101394.66819 37.7496575974161 -122.46520324492799 (37.7496575974161, -122.465203244928)
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)
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)
32139 215423 2 31 15 Fairfield Way 5 1 1 1     9 Width 3ft   5993769.4086 2092813.96021 37.72611098282629 -122.46374856183998 (37.7261109828263, -122.46374856184)
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)
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)
27219 215426 2 31 15 Fairfield Way 2 1 1 1     7 Width 3ft   5993822.27885 2092914.3969599998 37.7263898041365 -122.463573079846 (37.7263898041365, -122.463573079846)
58250 215427 2 31 15 Fairfield Way 3 1 1 1     8 Width 3ft   5993797.5326 2092869.7349099999 37.726265747145604 -122.463655385788 (37.7262657471456, -122.463655385788)
76250 215428 2 31 20 Lakewood Ave 7 1 1 1     10 Width 3ft   5993651.19736 2093024.90181 37.7266833644367 -122.464172514845 (37.7266833644367, -122.464172514845)
Powered by Datasette · Query took 89.653ms · Data source: data.sfgov.org