sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
27051 196337 2 353 602 Arthur Ave 1 7 1 1     4     6015979.32592 2099953.2392599997 37.7469688106565 -122.38746731498199 (37.7469688106565, -122.387467314982)
30197 196336 2 353 1750 22nd St 6 17 1 1     9     6012821.16046 2103795.98592 37.757344738798 -122.398657667323 (37.757344738798, -122.398657667323)
36595 196340 2 353 602 Arthur Ave 4 7 1 1     4 Width 8ft   6015958.58897 2099937.15281 37.7469234920398 -122.387537900079 (37.7469234920398, -122.387537900079)
47420 237953 2 353 5569 Diamond Heights Blvd 2 9 1 1     8 Width 4ft   6001685.30274 2097174.90356 37.7385380999471 -122.436695853025 (37.7385380999471, -122.436695853025)
48787 237954 2 353 5569 Diamond Heights Blvd 1 9 1 1     2 Width 3ft   6001676.453319999 2097164.39417 37.7385087406884 -122.43672569793002 (37.7385087406884, -122.43672569793)
51189 196345 2 353 602 Arthur Ave 34 7 1 1     4     6015663.1317300005 2099868.27306 37.7467179933348 -122.388554766215 (37.7467179933348, -122.388554766215)
58494 214359 2 353 618 Detroit St 4 9 1 1     1 Width 10ft   5999464.23273 2095044.92453 37.732563205716204 -122.444222201904 (37.7325632057162, -122.444222201904)
68337 196343 2 353 602 Arthur Ave 31 7 1 1     18     6015689.423719999 2099879.91957 37.7467514292439 -122.388464663129 (37.7467514292439, -122.388464663129)
70989 196341 2 353 602 Arthur Ave 10 7 1 1     5     6015838.55119 2099899.27486 37.7468128376585 -122.387950340845 (37.7468128376585, -122.387950340845)
81165 97014 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
85013 97015 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
94845 97016 7 353 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
112315 114756 1 353 301X Olmstead St 1 1 1 1   12/04/2015 12:00:00 AM     Permit Number 777132 6010782.8898599995 2090965.6524200002 37.722001621884 -122.40480357636001 (37.722001621884, -122.40480357636)
114328 121377 6 353 2701 Jackson St 1 1 1 1       3x3   6001200.0 2116539.0 37.79167953949779 -122.439761713662 (37.7916795394978, -122.439761713662)
131586 196344 2 353 602 Arthur Ave 33 7 1 1     5     6015666.28786 2099877.42762 37.7467433047611 -122.38854449143801 (37.7467433047611, -122.388544491438)
158271 237955 2 353 43 Harry St 1 9 1 1     12 Width 5ft   6003146.635009999 2097611.34949 37.739819419837396 -122.431674423652 (37.7398194198374, -122.431674423652)
161815 196342 2 353 602 Arthur Ave 13 7 1 1     5     6015828.19689 2099862.61894 37.7467116144672 -122.38798358786501 (37.7467116144672, -122.387983587865)
164450 178858 2 353 321 Olmstead St 1 1 1 1     1 Width 3ft   6010771.67715 2090938.6411099997 37.7219268276555 -122.40484043533701 (37.7219268276555, -122.404840435337)
164689 237952 2 353 1243 Stanyan St 1 1 1 1     2 Width 4ft   5997445.05985 2105447.6147 37.761011034661706 -122.45195317171301 (37.7610110346617, -122.451953171713)
170630 83694 2 353 2455 29th Ave 1 1 1 1 1   3     5987336.2715 2098572.6525 37.7415500456995 -122.486409860339 (37.7415500456995, -122.486409860339)
179258 196339 2 353 602 Arthur Ave 3 7 1 1     4 Width 8ft   6015967.11689 2099936.1121799997 37.7469211070262 -122.387508338452 (37.7469211070262, -122.387508338452)
186723 196338 2 353 602 Arthur Ave 2 7 1 1     2     6015971.97004 2099951.82403 37.7469645173129 -122.387492652478 (37.7469645173129, -122.387492652478)
187204 237951 2 353 200 Eugenia Ave 5 7 1 1     1     6006574.718780001 2098103.54318 37.7413645918137 -122.419856447043 (37.7413645918137, -122.419856447043)
Powered by Datasette · Query took 2.241ms · Data source: data.sfgov.org