sf-trees

Data source: data.sfgov.org

Custom SQL query returning 72 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
89334 116094 6 86 300x EXECUTIVE PARK BLVD 4 1 1 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
110125 116836 6 60 1750 Geneva Ave 4 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
120789 120921 6 143 3995X Alemany Blvd 4 5 1 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
80545 114228 6 140 99x FONT BLVD 4 2 1 1     7     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
101280 113045 6 3 500 RAYMOND AVE 4 8 1 1       3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
89972 114147 6 3 1200x JUNIPERO SERRA BLVD 4 7 1 1     7     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
93266 114407 6 177 500X ARBALLO DR 4 1 1 1       3x3   5987859.0 2089716.0 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035)
125443 110737 6 333 1299x PERSIA AVE 4 1 1 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
111156 116535 6 17 598x MOUNT VERNON AVE 4 13 1 1   05/13/2016 12:00:00 AM 3 3x3 Permit Number 777833 5997754.0 2090179.0 37.7191048016003 -122.449784323005 (37.7191048016003, -122.449784323005)
124990 107541 6 3 2 GARFIELD ST 4 13 1 1     36     5993976.6 2090624.3 37.7201106425596 -122.46287353180901 (37.7201106425596, -122.462873531809)
139196 72854 6 39 24 Lunado Way 4 1 1 1   09/26/1998 12:00:00 AM       5991516.52955398 2091408.89207172 37.722122935753106 -122.47143422303499 (37.7221229357531, -122.471434223035)
86774 122640 6 47 3630X 19th Ave 4 9 1 1       3x8   5990614.0 2091411.0 37.7220764711857 -122.47455416918999 (37.7220764711857, -122.47455416919)
3811 177743 6 2 401 Ocean Ave 4 9 1 6     37     5998700.41574 2091522.98281 37.722849171448395 -122.446609585371 (37.7228491714484, -122.446609585371)
121815 112772 6 1 1X HOWTH ST 4 9 1 1       3x3   5998027.0 2091524.0 37.722813474972206 -122.44893750468901 (37.7228134749722, -122.448937504689)
96972 120593 6 2 499x Ocean Ave 4 1 1 6     34 3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
121106 102478 6 70 760 Victoria St 4 7 1 1           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167)
168767 96276 6 35 55@ Alemany Trumbull St 4 13 1 1     2     6003946.78636 2094329.77315 37.730854277083104 -122.428673970523 (37.7308542770831, -122.428673970523)
140648 104282 6 17 150X Middle Point Rd 4 7 1 20   09/17/2013 12:00:00 AM     Permit Number 770341 6018215.0 2095138.0 37.733870695497295 -122.37940203679399 (37.7338706954973, -122.379402036794)
119061 98288 6 41 300 Mangels Ave 4 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
142007 106310 6 71 99X Clearfield Dr 4 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
13315 187668 6 49 100x OGDEN AVE 4 13 1 1           6007659.0 2096105.0 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682)
4549 226945 6 19 998 Chenery St 4 9 1 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
112089 104435 6 60 1601X PORTOLA DR 4 7 1 1     16     5991823.0 2096240.0 37.73540567927029 -122.47072655808 (37.7354056792703, -122.47072655808)
105346 115752 6 6 100 Yerba Buena Ave 4 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769)
117245 116958 6 6 10x Yerba Buena Ave 4 1 1 1   05/10/2016 12:00:00 AM 3   Permit Number 777762 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
15902 108047 6 44 1301 Evans Ave 4 1 1 1   06/12/2015 12:00:00 AM 3 3x3   6017036.144669999 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928)
111585 88455 6 1 2801 Oakdale Ave 4 8 1 1       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089005 -122.40455177544202 (37.742488010089, -122.404551775442)
78531 104869 6 18 411 Holladay Ave 4 7 1 1         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202)
112502 104150 6 17 1710-1738 Diamond St 4 7 1 1         Permit Number 768304 6001979.7 2099047.6 37.743696813668706 -122.43581192261101 (37.7436968136687, -122.435811922611)
107460 121171 6 17 900x Duncan St 4 7 1 1       3x3   6000584.0 2099647.0 37.745263242779004 -122.44068088983101 (37.745263242779, -122.440680889831)
102851 121175 6 17 950 Duncan St 4 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
104788 121183 6 1 1000x Duncan St 4 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
129467 101981 6 25 25X Tiffany Ave 4 7 1 1           6006415.7 2099833.4 37.7461054290546 -122.42052904239901 (37.7461054290546, -122.420529042399)
1631 251621 6 47 72R Amber Dr 4 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
103556 102074 6 225 273 Magellan Ave 4 7 1 1           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
78513 113727 6 26 1580 Valencia St 4 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
128434 105863 6 26 3615-3623X Cesar Chavez St 4 7 1 1           6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
87953 105869 6 60 3555 Cesar Chavez St 4 7 1 1           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466)
87119 112572 6 141 162 GRAND VIEW AVE 4 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
85774 100552 6 193 4443 19th St 4 7 1 1           6001193.1 2104609.9 37.7589248414166 -122.43893032447399 (37.7589248414166, -122.438930324474)
1935 252836 6 114 98 Prosper St 4 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1947 252825 6 163 3852 17th St 4 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
128646 92900 6 103 208 States St 4 13 1 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
125535 116090 6 5 98x WOODWARD ST 4 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
114318 103614 6 39 200X Buchanan St 4 9 1 1           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637)
105295 111766 6 333 1860 HAYES ST 4 7 1 4           5998973.0 2110255.0 37.774298298931704 -122.44701467467199 (37.7742982989317, -122.447014674672)
100981 103655 6 17 307X Octavia St 4 7 1 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
108310 121160 6 11 350x Octavia St 4 17 1 1           6005623.0 2110494.0 37.7753322239184 -122.42402807847701 (37.7753322239184, -122.424028078477)
118374 93206 6 47 400 Masonic Ave 4 7 1 1   02/24/2010 12:00:00 AM     Permit Number 53203 5999124.7 2111407.5 37.777471434329904 -122.446572853901 (37.7774714343299, -122.446572853901)
108305 107139 6 26 700X Stevenson St 4 7 1 1   07/31/2014 12:00:00 AM     Permit Number 769156 6008444.340419999 2111440.4280000003 37.778089774899705 -122.41433535624701 (37.7780897748997, -122.414335356247)
54137 106873 6 26 38 08th St 4 8 1 1         Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
79254 104682 6 26 33 08th St 4 7 1 1         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615)
85903 105084 6 54 344 Fulton St 4 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
102985 110842 6 17 2037 TURK BLVD 4 7 1 1           6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138)
107857 94299 6 101 1150X Fillmore St 4 5 1 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
108992 88147 6 17 1475 Fillmore St 4 1 1 1   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975001 (37.7830370509294, -122.43279450975)
146074 94447 6 17 1103 Gough St 4 5 1 1   08/06/2010 12:00:00 AM   3x3 Permit Number 53668 6005549.7 2113553.5 37.7837287235103 -122.424499312595 (37.7837287235103, -122.424499312595)
110409 98703 6 47 7070@ 32nd Ave California St 4 25 1 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
139418 100697 6 85 200X 01st St 4 7 1 1   09/05/2012 12:00:00 AM     Permit Number 768932 6013804.4 2114954.0 37.7880368749487 -122.396039137137 (37.7880368749487, -122.396039137137)
9743 173674 6 135 299x Beale St 4 1 1 1       3x3   6014575.0 2115523.0 37.789642061391 -122.39341281176901 (37.789642061391, -122.393412811769)
117761 101439 6 2 600X Grant Ave 4 7 1 1           6010995.6 2116632.0 37.7924875884206 -122.40587538693701 (37.7924875884206, -122.405875386937)
91812 107986 6 19 2401x SCOTT ST 4 1 1 1       3x3   6001257.0 2116757.0 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378)
66608 113772 6 21 2550 Broadway 4 5 1 1     4     6001375.31674 2117310.7972 37.793808671186106 -122.439210462719 (37.7938086711861, -122.439210462719)
58626 101743 6 15 1590 Broadway 4 7 1 1   12/21/2012 12:00:00 AM 12   Permit Number 769428 6006129.33795 2117976.30804 37.795905370388205 -122.422808406898 (37.7959053703882, -122.422808406898)
84536 106945 6 11 1150 LOMBARD ST 4 7 1 1     13   Permit Number 773092 6006825.0 2120436.8 37.8027004869705 -122.420576026126 (37.8027004869705, -122.420576026126)
1708 251660 6 3 1050 North Point St 4 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
124450 112484 6 40 1275 Columbus Ave 4 7 1 1   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209)
Powered by Datasette · Query took 5.817ms · Data source: data.sfgov.org