sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
596 240413 3 45 3420 Market St 2 4 1 2   04/19/1996 12:00:00 AM 8 Width 3ft   6000107.95046 2103900.11575 37.756914147893795 -122.442632304847 (37.7569141478938, -122.442632304847)
31206 246759 2 45 70 Waltham St 3 7 1 1     8     6009196.74806 2098886.80636 37.7436626276403 -122.410845655606 (37.7436626276403, -122.410845655606)
40291 240392 2 45 1803 Folsom St 1 1 1 1     8 Width 4ft   6008038.16649 2107910.1392200002 37.768373611578205 -122.415490461517 (37.7683736115782, -122.415490461517)
45898 78303 2 45 4200 Anza St 4 1 1 1 1 07/22/2000 12:00:00 AM 8     5985601.84615 2111830.0583200003 37.7778499560934 -122.493383352985 (37.7778499560934, -122.493383352985)
54599 240401 2 45 499 Hoffman Ave 2 1 1 1     8 Width 3ft   6000694.66286 2101176.32982 37.749468718214004 -122.440407898332 (37.749468718214, -122.440407898332)
57928 54837 1 45 131 Ashbury St 1 1 1 1 1 10/28/1995 12:00:00 AM 8   Permit Number 10691 5998715.81827648 2110282.46474316 37.77435901320929 -122.447906287477 (37.7743590132093, -122.447906287477)
59699 197345 2 45 1277 Howard St 1 1 1 1     8 Width 3ft   6008901.33871 2110395.02653 37.7752450102959 -122.41268050642599 (37.7752450102959, -122.412680506426)
60527 32523 1 45 861 Moultrie St 1 1 1 1 1 10/15/1996 12:00:00 AM 8   Permit Number 37025 6007568.6691 2095324.89508 37.7337909808565 -122.416222953925 (37.7337909808565, -122.416222953925)
75966 197346 2 45 1245 Howard St 1 1 1 1     8 Width 3ft   6008998.58265 2110487.32292 37.7755038918289 -122.412350641372 (37.7755038918289, -122.412350641372)
101774 8103 1 45 775 Fulton St 2 1 1 1   04/14/1998 12:00:00 AM 8 3X3   6004110.63243 2111457.69852 37.7778928009026 -122.42932844351601 (37.7778928009026, -122.429328443516)
135936 214037 2 45 510 Ramsell St 1 9 1 1     8 Width 5ft   5993017.248790001 2090566.81293 37.719897493047704 -122.466185481793 (37.7198974930477, -122.466185481793)
151712 248239 2 45 298 Esmeralda Ave 4 17 1 1     8     6006759.33465 2099019.31967 37.7438895076886 -122.419283056374 (37.7438895076886, -122.419283056374)
156395 136314 2 45 107 Bernard St 2 1 1 1     8 Width 2ft   6008318.73536 2118064.92593 37.796271980829 -122.415238929252 (37.796271980829, -122.415238929252)
159513 214043 2 45 212 Edna St 1 1 1 1     8 Width 2ft   5998768.52981 2093586.90837 37.7285201208974 -122.446522546303 (37.7285201208974, -122.446522546303)
162768 42678 1 45 1097 Green St 1 1 1 1 1 06/26/2000 12:00:00 AM 8   Permit Number 42702 6007821.24509 2118860.5405 37.7984285685682 -122.417016754032 (37.7984285685682, -122.417016754032)
167372 40008 1 45 950 Innes Ave 1 1 1 1 1 02/03/1999 12:00:00 AM 8   Permit Number 41261 6018990.20826 2094681.6711099998 37.7326604269313 -122.376690235261 (37.7326604269313, -122.376690235261)
173397 179371 2 45 479 Goettingen St 2 1 1 1     8 Width 3ft   6010448.30169 2092366.9553099999 37.7258306011814 -122.40605884135401 (37.7258306011814, -122.406058841354)
175872 78389 2 45 4200 Anza St 2 1 1 1 1 07/22/2000 12:00:00 AM 8     5985613.90998 2111830.68363 37.77785237866 -122.49334166667101 (37.77785237866, -122.493341666671)
178929 247983 2 45 497 Peralta Ave 1 17 1 1     8     6009757.51939 2099637.18115 37.74575442014729 -122.408959568646 (37.7457544201473, -122.408959568646)
179090 240400 2 45 499 Hoffman Ave 1 1 1 1     8 Width 3ft   6000695.68287 2101155.78818 37.74941237387971 -122.440402898093 (37.7494123738797, -122.440402898093)
Powered by Datasette · Query took 7.011ms · Data source: data.sfgov.org