sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
295 230413 3 73 310 Dolores St 2 1 1 2   04/14/2016 08:33:00 AM 1 Width 7ft   6004826.22566 2106515.9879900003 37.7643645463025 -122.42650099174601 (37.7643645463025, -122.426500991746)
313 230412 3 73 310 Dolores St 1 1 1 2   04/14/2016 08:29:00 AM 1 Width 6ft   6004822.22232 2106544.83878 37.7644435373721 -122.426516892666 (37.7644435373721, -122.426516892666)
532 6761 3 73 1275 Fairfax Ave 5 1 1 2   04/10/2017 01:35:00 PM 3 3x3   6017199.30801 2096970.01555 37.738844977413 -122.383041088382 (37.738844977413, -122.383041088382)
13398 29248 3 73 470X Bay Shore Blvd 1 1 1 2   04/07/2006 12:00:00 AM 3 3X3   6010243.1599 2097486.61497 37.7398766239144 -122.40712872251999 (37.7398766239144, -122.40712872252)
13581 18341 3 73 425 Potrero Ave 1 1 1 2   03/01/2014 12:00:00 AM 3 3x3   6010391.567000001 2106310.47571 37.7641132991006 -122.407237448759 (37.7641132991006, -122.407237448759)
14440 26560 3 73 430 Bay Shore Blvd 1 1 1 2   03/14/2006 12:00:00 AM 3 3X3   6010280.19543 2097760.62921 37.740631080471395 -122.40701997739599 (37.7406310804714, -122.407019977396)
15086 18346 3 73 447 Potrero Ave 1 1 1 2   02/21/2006 12:00:00 AM 3 3x3   6010394.89315 2106204.37839 37.7638221660807 -122.407218464984 (37.7638221660807, -122.407218464984)
16826 18350 3 73 459 Potrero Ave 1 1 1 2   01/08/2015 06:59:00 AM 3 3x3   6010395.85662 2106161.99214 37.7637058369709 -122.40721214454099 (37.7637058369709, -122.407212144541)
17958 18458 3 73 1136 Potrero Ave 1 1 1 2   12/01/2006 12:00:00 AM 3 4X4   6010508.182130001 2102591.0282099997 37.753907055971105 -122.406571988228 (37.7539070559711, -122.406571988228)
18206 5473 3 73 601 Dolores St 1 1 1 2   06/08/2016 05:56:00 AM 3 4X4   6005007.93466 2104733.32137 37.7594800368996 -122.42574561699301 (37.7594800368996, -122.425745616993)
18510 27621 3 73 1143 Potrero Ave 1 1 1 2   12/14/2013 12:00:00 AM 3 3x3   6010597.97715 2102516.5515099997 37.7537075827479 -122.406256207463 (37.7537075827479, -122.406256207463)
18743 18381 3 73 768 Potrero Ave 1 1 1 2     40 3x3   6010390.09454 2104720.536 37.7597476013854 -122.40713046091801 (37.7597476013854, -122.407130460918)
20449 18472 3 73 1245 Potrero Ave 1 1 1 2   04/11/2015 07:25:00 AM 3 3X3   6010625.30786 2102050.90235 37.7524305418599 -122.406128887762 (37.7524305418599, -122.406128887762)
21177 18475 3 73 1260 Potrero Ave 2 1 1 2   10/10/2013 12:00:00 AM 3 3x3   6010550.213330001 2101942.07688 37.75212753057279 -122.406380911075 (37.7521275305728, -122.406380911075)
21711 18473 3 73 1255 Potrero Ave 1 1 1 2   11/15/2013 12:00:00 AM 3 3x3   6010628.31505 2101997.99365 37.7522854344497 -122.40611476119301 (37.7522854344497, -122.406114761193)
21944 18455 3 73 1115 Potrero Ave 1 1 1 2   08/17/2015 12:46:00 PM 3 3X3   6010591.726009999 2102631.1286299997 37.754021836464794 -122.406285897673 (37.7540218364648, -122.406285897673)
23345 18460 3 73 1146 Potrero Ave 1 1 1 2   10/26/2006 12:00:00 AM 5 3X3   6010512.14548 2102543.99159 37.753778125574 -122.40655496764099 (37.753778125574, -122.406554967641)
83398 93296 3 73 999X Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004559.2 2103505.3 37.7560828122733 -122.42721008996901 (37.7560828122733, -122.427210089969)
86692 93242 3 73 636 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004253.0 2105189.0 37.7606885326436 -122.428389032489 (37.7606885326436, -122.428389032489)
89459 16928 3 73 518 Oak St 1 1 1 2   04/02/2007 12:00:00 AM 3 2.5 X3   6004333.80114 2110174.91218 37.7743832165186 -122.42846496781999 (37.7743832165186, -122.42846496782)
90330 93297 3 73 985 Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004420.0 2103163.0 37.755135063976205 -122.42766710326099 (37.7551350639762, -122.427667103261)
91544 93246 3 73 990 Church St 2 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
97825 93239 3 73 600X Church St 2 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971)
107887 93247 3 73 990 Church St 3 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
113588 93243 3 73 656 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004259.0 2105076.0 37.7603786010488 -122.428360227113 (37.7603786010488, -122.428360227113)
119249 93241 3 73 626 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004249.0 2105248.0 37.7608503062499 -122.428407072017 (37.7608503062499, -122.428407072017)
119713 93245 3 73 990 Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
120541 93238 3 73 600X Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971)
124081 93240 3 73 600X Church St 3 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971)
124793 93248 3 73 990 Church St 4 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004369.0 2103119.0 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146)
126057 93244 3 73 910X Church St 1 1 1 2   12/01/2008 12:00:00 AM 3 3x3   6004315.0 2103566.4 37.7562367654726 -122.42805896962099 (37.7562367654726, -122.428058969621)
127184 93298 3 73 869 Church St 1 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004381.0 2103841.0 37.75699448617571 -122.427850284713 (37.7569944861757, -122.427850284713)
140226 93299 3 73 801X Church St 6 1 1 2   12/12/2008 12:00:00 AM 3 3x3   6004394.3 2104124.7 37.757774211767796 -122.427824502367 (37.7577742117678, -122.427824502367)
145233 18367 3 73 625 Potrero Ave 1 1 1 2   07/17/2015 09:59:00 AM 3 4X3   6010438.66394 2105366.85434 37.7615249639888 -122.407008038291 (37.7615249639888, -122.407008038291)
Powered by Datasette · Query took 55.339ms · Data source: data.sfgov.org