sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
74925 61499 1 190 154 20th Ave 1 1 1 1 1 08/27/1984 12:00:00 AM 7   Permit Number 21452 5989629.6033 2114330.31946 37.7849497475064 -122.47963307901001 (37.7849497475064, -122.47963307901)
153997 111169 1 190 1469 Pacific Ave 2 1 1 1     7 3x3   6007081.20428 2117722.0309900003 37.795260849674705 -122.41949671281701 (37.7952608496747, -122.419496712817)
177598 65002 1 190 1628 Visitacion Ave 1 1 1 1   03/31/1989 12:00:00 AM 7   Permit Number 26041 6007789.57951 2087924.3929599999 37.713483198176796 -122.414935588817 (37.7134831981768, -122.414935588817)
23535 207712 2 190 579 Hearst Ave 1 9 1 1     7     5997579.44084 2094367.86788 37.730596459453395 -122.450689553205 (37.7305964594534, -122.450689553205)
23748 224117 2 190 2818 23rd St 2 1 1 1     7 Width 4ft   6009831.98095 2102814.76339 37.754483528604396 -122.40892624516701 (37.7544835286044, -122.408926245167)
25572 191703 2 190 1501 Quint St 2 7 1 1     7 Width 4ft   6013259.66608 2096346.4213299998 37.7369142408999 -122.396618925818 (37.7369142408999, -122.396618925818)
34441 191696 2 190 1700 22nd St 3 7 1 1     7     6012930.9536 2103804.38992 37.7573739307682 -122.398278546439 (37.7573739307682, -122.398278546439)
45069 126561 2 190 8 Codman Pl 2 13 1 1     7     6009832.93804 2117260.0663900003 37.7941470150322 -122.40994260678998 (37.7941470150322, -122.40994260679)
56447 191691 2 190 2301 19th St 2 9 1 1     7     6010894.94565 2105057.58809 37.7607013108401 -122.405408158461 (37.7607013108401, -122.405408158461)
57318 218344 2 190 385 Castenada Ave 4 2 1 1     7 Width 0ft   5993369.339269999 2100022.3312 37.745880311731 -122.46565503467501 (37.745880311731, -122.465655034675)
68300 224116 2 190 400 Prospect Ave 15 9 1 1     7     6006205.79839 2097605.42741 37.7399760871276 -122.421096686769 (37.7399760871276, -122.421096686769)
75558 191687 2 190 800 19th St 1 9 1 1     7 Width 10ft   6015123.17396 2105339.16037 37.7617099499859 -122.390804173874 (37.7617099499859, -122.390804173874)
153224 176279 2 190 671 London St 2 2 1 1     7     6001065.40936 2089903.8077599998 37.7185380904529 -122.43831837391001 (37.7185380904529, -122.43831837391)
154589 201358 2 190 245 Kalmanovitz St 1 2 1 1     7 Width 2ft   6013008.61874 2092664.0279400002 37.726789172374794 -122.39722877051001 (37.7267891723748, -122.39722877051)
154781 126564 2 190 1519 Pacific Ave 2 1 1 1     7 Width 4ft   6006833.89403 2117675.37487 37.7951188107324 -122.42034913432501 (37.7951188107324, -122.420349134325)
162191 123640 2 190 345 Arguello Blvd 7 9 1 1     7 Width 6ft   5995501.56716 2113883.85045 37.784063214039605 -122.459285759007 (37.7840632140396, -122.459285759007)
167274 126570 2 190 94 MacOndray Ln 1 9 1 1     7     6008053.53116 2119101.30283 37.7991027057905 -122.41623003160299 (37.7991027057905, -122.416230031603)
168183 118733 2 190 706 44th Ave 1 1 1 1     7 Width 3ft   5982303.905590001 2110925.66237 37.7751732905824 -122.504724857451 (37.7751732905824, -122.504724857451)
171139 126563 2 190 1519 Pacific Ave 1 1 1 1     7 Width 4ft   6006819.81222 2117673.20836 37.795112068514705 -122.420397705787 (37.7951120685147, -122.420397705787)
179174 71359 2 190 1620 La Salle Ave 2 1 1 1 1 05/21/1988 12:00:00 AM 7     6015449.34332 2096256.73769 37.7367896101585 -122.389041914574 (37.7367896101585, -122.389041914574)
185039 224123 2 190 523 Powhattan Ave 1 2 1 1     7     6008526.38321 2098121.4064599997 37.7415233967761 -122.413109512687 (37.7415233967761, -122.413109512687)
Powered by Datasette · Query took 5.622ms · Data source: data.sfgov.org