sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14406 120561 2 82 245 Mississippi St 1 1 1 1     14 3x3   6014054.5814 2105863.37396 37.7630899785332 -122.394536741704 (37.7630899785332, -122.394536741704)
37414 239253 2 82 3715 26th St 4 1 1 1     14 Width 3ft   6005658.48797 2100784.3269 37.7486737543928 -122.42321497059099 (37.7486737543928, -122.423214970591)
52692 240154 2 82 568 Belvedere St 1 1 1 1     14 Width 4ft   5998646.15561 2105899.30537 37.76231998711071 -122.44783164083799 (37.7623199871107, -122.447831640838)
54939 42167 1 82 525 05th St 6 1 1 1   06/21/2000 12:00:00 AM 14   Permit Number 42460 6012577.4664 2111216.9324 37.7777074143023 -122.400021595319 (37.7777074143023, -122.400021595319)
66368 213958 2 82 360 Faxon Ave 7 1 1 1     14 Width 3ft   5994774.32905 2091126.87145 37.721536499390105 -122.460152462564 (37.7215364993901, -122.460152462564)
78871 102179 2 82 4354 20th St 1 1 1 1     14 3x3   6002056.0 2104132.0 37.7576617009806 -122.435911822312 (37.7576617009806, -122.435911822312)
79899 239331 2 82 3265 Harrison St 1 1 1 1     14 Width 3ft   6009040.25236 2099669.18 37.7458020770125 -122.411442043712 (37.7458020770125, -122.411442043712)
108092 61119 1 82 1120 South Van Ness Ave 1 1 1 1   09/08/1983 12:00:00 AM 14 3x3 Permit Number 20967 6007612.89522655 2103123.90329719 37.7552078032974 -122.416622341764 (37.7552078032974, -122.416622341764)
130889 68778 1 82 2020 Larkin St 1 1 1 1   11/16/1993 12:00:00 AM 14 3x3 Permit Number 32708 6006907.41923 2118207.98167 37.796585358595294 -122.420132542485 (37.7965853585953, -122.420132542485)
131782 179284 2 82 721 Goettingen St 1 10 1 1     14 Width 4ft   6010763.30464 2091319.72205 37.7229727292859 -122.404896194231 (37.7229727292859, -122.404896194231)
133160 239292 2 82 900 York St 2 1 1 1     14 Width 3ft   6009918.7268199995 2103885.22613 37.7574276383036 -122.40870176718799 (37.7574276383036, -122.408701767188)
149069 240177 2 82 431 Gates St 1 1 1 1     14 Width 3ft   6008245.857419999 2096810.19574 37.7379073478479 -122.41398674200799 (37.7379073478479, -122.413986742008)
157156 239261 2 82 1400 Utah St 5 4 1 1     14 Width 3ft   6010855.2107 2101671.833 37.751402557405896 -122.405307149322 (37.7514025574059, -122.405307149322)
158817 61793 1 82 2104 23rd St 1 1 1 1 1 01/26/1985 12:00:00 AM 14   Permit Number 21816 6012153.01638 2102841.4950099997 37.7546866683749 -122.40090132743201 (37.7546866683749, -122.400901327432)
173537 197097 2 82 379 Pennsylvania Ave 1 1 1 1     14 Width 3ft   6014372.8543300005 2105361.9972099997 37.7617309959041 -122.39340084578001 (37.7617309959041, -122.39340084578)
183206 197098 2 82 373 Pennsylvania Ave 1 1 1 1     14 Width 3ft   6014370.26401 2105387.58342 37.761801106151204 -122.393411595362 (37.7618011061512, -122.393411595362)
Powered by Datasette · Query took 19.278ms · Data source: data.sfgov.org