sf-trees

Data source: data.sfgov.org

Custom SQL query returning 27 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
33547 137666 2 42 1901 GOLDEN GATE AVE 3 1 1 1     5 Width 0ft   6000398.0082 2111639.7629 37.7781818179135 -122.442184748811 (37.7781818179135, -122.442184748811)
33878 220678 2 42 3607 20th St 1 1 1 1     5 Width 3ft   6006149.55219 2104320.61277 37.758411280773394 -122.421768019002 (37.7584112807734, -122.421768019002)
40035 220081 2 42 780 Noe St 1 1 1 1     5 Width 3ft   6003049.24321 2103668.76893 37.756446152387795 -122.432443698342 (37.7564461523878, -122.432443698342)
40646 219991 2 42 13 Bronte St 2 1 1 1     5 Width 2ft   6009385.52811 2097403.7869700002 37.739601163374 -122.41008822049601 (37.739601163374, -122.410088220496)
47618 220674 2 42 3548 19th St 1 1 1 1     5 Width 3ft   6005923.11971 2104936.6524900002 37.760090010159104 -122.42259489975201 (37.7600900101591, -122.422594899752)
53649 219989 2 42 936 Clayton St 2 1 1 1     5 Width 3ft   5998793.85425 2106724.38466 37.7645938887298 -122.447380197361 (37.7645938887298, -122.447380197361)
53663 220045 2 42 160 Marview Way 1 4 1 1     5 Width 3ft   5998323.68704 2103258.27383 37.755049936933 -122.448756699664 (37.755049936933, -122.448756699664)
53857 220052 2 42 50 Coleridge St 5 1 1 1     5 Width 3ft   6006851.995619999 2099403.94647 37.7449508246175 -122.418989930439 (37.7449508246175, -122.418989930439)
58569 174964 2 42 1645 Felton St 1 1 1 1     5 Width 2ft   6006075.21093 2092385.5914900003 37.7256362082245 -122.421177650028 (37.7256362082245, -122.421177650028)
60414 188512 2 42 101 Pennsylvania Ave 41 7 1 1     5     6014229.234019999 2106696.64866 37.7653876762377 -122.393991007905 (37.7653876762377, -122.393991007905)
60577 245840 2 42 421 Laguna St 1 1 1 1     5 Width 0ft   6005021.78 2110481.0306 37.775262650872 -122.42610691556601 (37.775262650872, -122.426106915566)
70721 245867 2 42 419 Laguna St 1 1 1 1     5 Width 0ft   6005023.743 2110457.4751 37.775198084155605 -122.42609844781799 (37.7751980841556, -122.426098447818)
132310 203658 2 42 531 Foerster St 1 1 1 1     5 Width 3ft   5998103.1876300005 2095162.16833 37.732807386054795 -122.448936084745 (37.7328073860548, -122.448936084745)
132605 142261 2 42 575 LINDEN ST 2 1 1 1     5 Width 0ft   6004683.1776 2110693.6136 37.775827208405104 -122.427293365492 (37.7758272084051, -122.427293365492)
133605 220082 2 42 780 Noe St 2 1 1 1     5 Width 3ft   6003052.51993 2103630.15774 37.7563403210743 -122.43242960863701 (37.7563403210743, -122.432429608637)
135030 75408 2 42 101 De Long St 1 1 1 1 1 09/30/1995 12:00:00 AM 5     5994441.08765 2086786.6315099997 37.7096000577555 -122.460989960739 (37.7096000577555, -122.460989960739)
152034 124751 2 42 566 Linden St 2 1 1 1     5 Width 3ft   6004689.62752 2110692.77739 37.775825277144705 -122.427270993988 (37.7758252771447, -122.427270993988)
152597 220675 2 42 3681 20th St 1 1 1 1     5 Width 3ft   6005766.61271 2104299.30973 37.758331185361 -122.423090881238 (37.758331185361, -122.423090881238)
161439 174963 2 42 27 Vienna St 1 1 1 1     5 Width 2ft   6005106.809719999 2093312.6606400001 37.7281270946664 -122.424591254394 (37.7281270946664, -122.424591254394)
162378 220679 2 42 3607 20th St 2 1 1 1     5 Width 3ft   6006165.33609 2104321.13003 37.758413591125205 -122.421713467922 (37.7584135911252, -122.421713467922)
164961 138533 2 42 2299 SUTTER ST 2 1 1 1     5 Width 0ft   6001645.5525 2114240.3384 37.7853933573613 -122.438055378776 (37.7853933573613, -122.438055378776)
168792 83538 2 42 243 Prague St 1 1 1 1 1 12/03/2005 12:00:00 AM 5     6004140.213830001 2089715.70651 37.7181960153187 -122.427676641269 (37.7181960153187, -122.427676641269)
170794 220080 2 42 517 Liberty St 1 1 1 1     5 Width 3ft   6002959.284990001 2103850.36087 37.756939658960206 -122.432767777111 (37.7569396589602, -122.432767777111)
171472 219996 2 42 80 Stoneman St 1 1 1 1     5 Width 2ft   6007954.3059 2099409.5241799997 37.7450281501379 -122.415178725923 (37.7450281501379, -122.415178725923)
173572 245839 2 42 423 Laguna St 2 1 1 1     5 Width 0ft   6005015.8911 2110507.8578 37.775335978986796 -122.4261291969 (37.7753359789868, -122.4261291969)
175760 220061 2 42 496 Bartlett St 1 1 1 1     5 Width 3ft   6006778.4719 2100919.5429 37.749108169217294 -122.41935165935101 (37.7491081692173, -122.419351659351)
185230 219990 2 42 151 Delmar St 1 1 1 1     5 Width 3ft   5999384.54447 2107324.60583 37.766275682101 -122.445380326357 (37.766275682101, -122.445380326357)
Powered by Datasette · Query took 108.379ms · Data source: data.sfgov.org