sf-trees

Data source: data.sfgov.org

Custom SQL query returning 28 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
174472 36791 1 31 1350 Donner Ave 4 1 1 1   05/26/1998 12:00:00 AM 9 3x3 Permit Number 39527 6015186.7443 2090870.701 37.7219860731406 -122.389573793771 (37.7219860731406, -122.389573793771)
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)
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)
75251 84928 1 31 1500@Polk Broadway 4 1 1 1   06/06/2007 12:00:00 AM 6   Permit Number 49344 6006295.343780001 2118001.00844 37.79598255651371 -122.422235750095 (37.7959825565137, -122.422235750095)
81156 109317 2 31 1516 BROADWAY 4 1 1 1       3x3   6006331.3 2118082.2 37.796207516174796 -122.42211710536101 (37.7962075161748, -122.422117105361)
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)
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)
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)
3581 253486 4 31 1x Gordon St 4 1 1 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
178204 197987 2 31 2 Bridgeview Dr 4 7 1 1     9     6014076.35565 2095353.09382 37.734232186468894 -122.39372574026501 (37.7342321864689, -122.393725740265)
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)
101582 42735 1 31 2155 Bay Shore Blvd 4 1 1 1 1 06/26/2000 12:00:00 AM     Permit Number 42735 6011836.19977805 2087516.89388515 37.712590845234296 -122.400920338197 (37.7125908452343, -122.400920338197)
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)
86383 34081 1 31 240 SHOTWELL ST 4 1 1 1 1 07/05/1997 12:00:00 AM 6 3x3 Permit Number 37968 6007737.2 2106597.0 37.764751116814296 -122.41643845462299 (37.7647511168143, -122.416438454623)
81608 44006 1 31 2701X 17th St 4 1 1 1   06/12/2015 12:00:00 AM 3   Permit Number 43559. Tree 4 on 17th St 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
60020 241221 2 31 2800 17th St 4 1 1 1     9 Width 3ft   6009078.922 2106403.19833 37.764294343422996 -122.411784075669 (37.764294343423, -122.411784075669)
34328 241212 2 31 2801 17th St 4 1 1 1     11 Width 3ft   6009052.89196 2106353.81264 37.7641572813666 -122.411870616529 (37.7641572813666, -122.411870616529)
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)
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)
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)
91 241181 1 31 300 Duboce Ave 4 7 1 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004757.3052900005 2108409.26199 37.7695591257908 -122.42687421397 (37.7695591257908, -122.42687421397)
122492 44263 1 31 300 Duboce Ave 4 1 1 1   02/20/2001 12:00:00 AM     Permit Number 43693 6004891.25445895 2108442.06671817 37.769656772496795 -122.426413224583 (37.7696567724968, -122.426413224583)
123243 34051 1 31 375 Alabama St 4 1 1 1 1 07/05/1997 12:00:00 AM     Permit Number 37958 6008950.19472335 2106493.86234805 37.7645360636147 -122.41223571697999 (37.7645360636147, -122.41223571698)
110112 115632 2 31 55x 15TH ST 4 1 1 1       4x4   6012114.0 2107494.0 37.7674592382642 -122.40136319642001 (37.7674592382642, -122.40136319642)
118249 39861 1 31 70 13th St 4 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)
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)
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)
144031 16312 3 31 758X Monterey Blvd 4 11 1 2   02/02/2003 12:00:00 AM 12 5   5997070.7706475 2094757.2260752 37.7316364140758 -122.45247618016899 (37.7316364140758, -122.452476180169)
Powered by Datasette · Query took 5.23ms · Data source: data.sfgov.org