sf-trees

Data source: data.sfgov.org

Custom SQL query returning 14 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
139 116640 4 44 270 Brannan St 2 5 1 1     1 4x4   6015158.0 2112983.0 37.782700175280794 -122.39121805332199 (37.7827001752808, -122.391218053322)
451 192346 4 83 118 10th St 1 1 1 1   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.5452799997 37.7750719195804 -122.41581539288201 (37.7750719195804, -122.415815392882)
2257 229627 4 21 3662 Folsom St 1 1 1 1     1 Width 3ft   6008456.11159 2097816.22885 37.7406815009641 -122.41333091228701 (37.7406815009641, -122.413330912287)
12646 115976 4 88 2x Olmstead St 1 1 1 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
26519 115980 4 88 2x Olmstead St 5 1 1 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
97171 60705 4 41 963 Alabama St 1 1 1 1   03/05/1983 12:00:00 AM 1 3x3 Permit Number 20354 6009178.18020232 2103559.73737881 37.7564924147418 -122.4112398899 (37.7564924147418, -122.4112398899)
101502 111713 4 48 3038 CLEMENT ST 1 1 1 1   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051.0 2113265.0 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217)
127737 112972 4 12 4099x ULLOA ST 1 5 1 1   10/20/2015 12:00:00 AM 1 3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
145461 111714 4 48 3038 CLEMENT ST 2 1 1 1   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051.0 2113265.0 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217)
151101 39246 4 12 3524 Jackson St 2 1 1 1   08/22/2002 12:00:00 AM 1   Permit Number 772836 5997390.1418 2116079.3582900004 37.7901998932662 -122.452910535096 (37.7901998932662, -122.452910535096)
151629 116966 4 90 480 Potrero Ave 3 1 1 1     1 3x3   6010311.678719999 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703)
171742 115979 4 88 2x Olmstead St 4 1 1 1     1 3x3   6011610.19593 2091240.25279 37.722801825729604 -122.401963063449 (37.7228018257296, -122.401963063449)
172623 115978 4 88 2x Olmstead St 3 1 1 1     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721001 (37.7228154963084, -122.40191601721)
182061 115977 4 88 2x Olmstead St 2 1 1 1     1 3x3   6011639.0005 2091249.90123 37.722829925953896 -122.40186416949 (37.7228299259539, -122.40186416949)
Powered by Datasette · Query took 5.745ms · Data source: data.sfgov.org