sf-trees

Data source: data.sfgov.org

Custom SQL query returning 27 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
121292 22304 3 147 5012X 03rd St 3 1 1 2     3 3x3   6014702.6472 2094891.22359 37.7329987676998 -122.39152815342301 (37.7329987676998, -122.391528153423)
101764 22308 3 147 5033 03rd St 3 1 1 2   04/24/2000 12:00:00 AM 3 3x3   6014806.8487599995 2094754.47288 37.7326290611665 -122.39115834308599 (37.7326290611665, -122.391158343086)
98771 74661 1 147 165-167 11th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
19680 82786 1 147 1910-12 Keith St 3 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52461 6015243.83790646 2093539.28137109 37.72931663038511 -122.389562713545 (37.7293166303851, -122.389562713545)
91409 82833 1 147 165-167 11th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056)
83671 82942 1 147 236 08th St 3 1 1 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
124874 91022 3 147 140 South Van Ness Ave 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007266.813002 2109001.353693 37.7713264423251 -122.418235884317 (37.7713264423251, -122.418235884317)
80041 91027 3 147 722 South Van Ness Ave 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6007490.257402 2105446.273959 37.761577600545394 -122.417211018518 (37.7615776005454, -122.417211018518)
94383 94764 1 147 10X Waterloo St 3 1 1 1   10/28/2010 12:00:00 AM   3x3   6010555.4 2097635.9 37.740303997417 -122.406059635863 (37.740303997417, -122.406059635863)
81444 101926 8 147 1099X Hyde St 3 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
96771 102104 1 147 705X Tehama St 3 1 1 1       3x3 Permit Number 52427 6009386.0 2110546.0 37.775686737909496 -122.411014612047 (37.7756867379095, -122.411014612047)
100892 109943 8 147 400x CLEMENTINA ST 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
169669 114203 2 147 310 Carolina St 3 1 1 1     3 3x3   6012282.10678 2106442.32004 37.764580938483704 -122.400707843686 (37.7645809384837, -122.400707843686)
72607 197026 2 147 2 Waterloo St 3 4 1 1     3 Width 4ft   6010467.19371 2097248.77404 37.7392360988707 -122.406337349712 (37.7392360988707, -122.406337349712)
164504 239144 2 147 101 Hwy 101 N Off Ramp 3 9 1 1     4 Width 5ft   6005864.044969999 2109192.1189099997 37.7717711783282 -122.423101690202 (37.7717711783282, -122.423101690202)
35585 239152 2 147 100 Octavia St 3 4 1 1     4 Width 4ft   6005729.11778 2109714.63204 37.773198258533895 -122.42360556863599 (37.7731982585339, -122.423605568636)
65016 239173 2 147 3705 25th St 3 1 1 1     6 Width 3ft   6005734.96606 2101372.66505 37.7502935116564 -122.422992320041 (37.7502935116564, -122.422992320041)
52540 239181 2 147 380 14th St 3 1 1 1     2 Width 3ft   6006215.6761300005 2107893.9456599997 37.7682265409602 -122.42179314696001 (37.7682265409602, -122.42179314696)
44114 239182 2 147 3599 17th St 3 1 1 1     4 Width 3ft   6005021.22782 2106010.41037 37.7629873721785 -122.425790544398 (37.7629873721785, -122.425790544398)
167071 239187 2 147 483 South Van Ness Ave 3 1 1 1     4 Width 3ft   6007459.99284 2106907.97241 37.7655893815639 -122.41741928429701 (37.7655893815639, -122.417419284297)
160902 239191 2 147 101 Hwy 101 Northbound 3 13 1 1     6     6005967.76325 2108980.83852 37.7711969054453 -122.422727904078 (37.7711969054453, -122.422727904078)
61226 239216 2 147 100 Hwy 101 Southbound 3 13 1 1     5     6005843.543219999 2109006.7344400003 37.771261000120504 -122.42315942758499 (37.7712610001205, -122.423159427585)
154686 239219 2 147 2730 Bryant St 3 1 1 1     4 Width 4ft   6009767.82555 2101370.89854 37.7505154031821 -122.409046239907 (37.7505154031821, -122.409046239907)
158027 239221 2 147 2810 26th St 3 1 1 1     7 Width 3ft   6010295.22869 2101085.95879 37.749762551916106 -122.407202347334 (37.7497625519161, -122.407202347334)
35302 239224 2 147 2850 26th St 3 1 1 1     5 Width 3ft   6010131.271430001 2101077.30272 37.7497296070346 -122.407768710669 (37.7497296070346, -122.407768710669)
155009 239231 2 147 391 Church St 3 1 1 1     7 Width 3ft   6004225.7038199995 2106680.81705 37.764783160934 -122.42858977959699 (37.764783160934, -122.428589779597)
68673 249388 2 147 301 Eddy St 3 4 1 1     5 Width 3ft   6008934.66326 2113525.78003 37.78384318556579 -122.41278661472602 (37.7838431855658, -122.412786614726)
Powered by Datasette · Query took 3.798ms · Data source: data.sfgov.org