sf-trees

Data source: data.sfgov.org

Custom SQL query returning 28 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
23507 208860 2 89 1359 16th Ave 1 1 1 1     4 Width 3ft   5991111.19274 2106147.12197 37.762566869885 -122.473910078106 (37.762566869885, -122.473910078106)
26735 75220 2 89 246 Cole St 3 1 1 1 1 04/23/1994 12:00:00 AM 1     5997870.8316 2109714.2746 37.772750574805 -122.450788263508 (37.772750574805, -122.450788263508)
61210 75375 2 89 242 Cole St 1 1 1 1 1 04/23/1994 12:00:00 AM 2     5997883.096 2109628.0405 37.77251450021 -122.450739621122 (37.77251450021, -122.450739621122)
81779 110680 2 89 162 DUNCAN ST 1 1 1 1       3x3   6005508.0 2099957.0 37.7463936103079 -122.423676542195 (37.7463936103079, -122.423676542195)
89150 106270 2 89 49 MISSOURI ST 10 1 1 1     10 3x3   6013498.7 2106906.8 37.765924077220504 -122.39653250625 (37.7659240772205, -122.39653250625)
90860 104718 2 89 100x PRECITA AVE 2 1 1 1           6007128.0 2100007.0 37.7466222122015 -122.418078299823 (37.7466222122015, -122.418078299823)
91693 110449 2 89 28 BELCHER ST 2 1 1 1       3x3 Permit Number 775444 6003746.0 2108157.0 37.7688092427031 -122.430354279635 (37.7688092427031, -122.430354279635)
95574 106372 2 89 260 MAGELLAN AVE 1 1 1 1       4x4   5994684.4 2100364.8 37.7468964099217 -122.461132589625 (37.7468964099217, -122.461132589625)
98708 110448 2 89 28 BELCHER ST 1 1 1 1       3x3 Permit Number 775444 6003746.0 2108157.0 37.7688092427031 -122.430354279635 (37.7688092427031, -122.430354279635)
118597 115761 2 89 924 NOE ST 1 1 1 1     4 3x3   6003074.0 2102857.0 37.7542186318325 -122.43230010699301 (37.7542186318325, -122.432300106993)
122138 100151 2 89 4047 18th St 1 1 1 1     2 5x5 Permit Number 776452 6002690.0 2105300.0 37.760904743288705 -122.433802674054 (37.7609047432887, -122.433802674054)
129027 104763 2 89 51 VICKSBURG ST 2 1 1 1   06/09/2014 12:00:00 AM 15 4x4 Permit Number 772738 6004133.6 2102760.4 37.7540134146385 -122.428628860828 (37.7540134146385, -122.428628860828)
131573 244383 2 89 251 Oak St 1 1 1 1     2 Width 0ft   6005771.1844 2110310.2456 37.7748360439411 -122.423502407009 (37.7748360439411, -122.423502407009)
141702 85208 2 89 3099 California St 1 1 1 1   07/16/2007 12:00:00 AM     Permit Number 49530 5999545.0 2115014.0 37.7873979483893 -122.44537828227502 (37.7873979483893, -122.445378282275)
141848 96914 2 89 4396X 23rd St 1 1 1 1 1 10/30/1996 12:00:00 AM   3x3 Permit exists for 2 Magnolias on Hoffman frontage. These two appear to be about the same age. 6000641.3 2102303.1 37.7525595190983 -122.440673239158 (37.7525595190983, -122.440673239158)
148646 230429 2 89 2649 22nd St 1 1 1 1     1 Width 3ft   6010278.55114 2103378.6457700003 37.756056828675206 -122.407421632625 (37.7560568286752, -122.407421632625)
160103 140179 2 89 246 COLE ST 2 1 1 1     1 Width 0ft   5997872.7479 2109697.411 37.7727043813962 -122.450780418722 (37.7727043813962, -122.450780418722)
177913 140178 2 89 246 COLE ST 1 1 1 1     1 Width 0ft   5997876.1972 2109680.9307 37.7726593281832 -122.450767298801 (37.7726593281832, -122.450767298801)
183597 230428 2 89 436 Murray St 1 1 1 1     1 Width 3ft   6006457.38895 2096010.6224 37.7356112869209 -122.42011363694999 (37.7356112869209, -122.42011363695)
80813 104947 2 89 532 Gonzalez Dr 4 2 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
132803 245119 2 89 129 Baker St 1 2 1 1     14 Width 0ft   6000771.8557 2109441.6092 37.7721675418639 -122.44073376176 (37.7721675418639, -122.44073376176)
148968 245120 2 89 129 Baker St 2 2 1 1     4 Width 0ft   6000774.8471 2109422.9959 37.7721166047697 -122.44072207891001 (37.7721166047697, -122.44072207891)
166123 193439 2 89 1301 Minnesota St 10 7 1 1     1     6015387.42836 2102311.75717 37.753412005279294 -122.38967876317 (37.7534120052793, -122.38967876317)
35469 208862 2 89 639 Mangels Ave 2 9 1 1     11     5997188.9726599995 2095238.55048 37.7329647871987 -122.45210224963499 (37.7329647871987, -122.452102249635)
42433 208861 2 89 263 Flood Ave 1 9 1 1     11     5998987.837069999 2094055.2995 37.7298187374412 -122.44579806412399 (37.7298187374412, -122.445798064124)
52886 131013 2 89 2531 Filbert St 1 10 1 1     6 Width 3ft   6000837.80329 2118568.05574 37.797230171598 -122.44116054993401 (37.797230171598, -122.441160549934)
52473 230427 2 89 230 Coso Ave 1 17 1 1     1     6007601.41363 2099515.46986 37.74529921477939 -122.416406470502 (37.7452992147794, -122.416406470502)
57021 230426 2 89 230 Coso Ave 2 17 1 1     1     6007649.023990001 2099489.86888 37.745231597464795 -122.416240028469 (37.7452315974648, -122.416240028469)
Powered by Datasette · Query took 59.938ms · Data source: data.sfgov.org