sf-trees

Data source: data.sfgov.org

Custom SQL query returning 25 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
178271 176340 3 103 200x Mansell St 15 11 1 2     8 Width 0ft   6011135.84107 2090535.2556900003 37.720839562571996 -122.403553239308 (37.720839562572, -122.403553239308)
165255 224249 3 103 500x 27th St 14 11 1 2     48 Width 4ft   6002852.0087 2100065.56768 37.7465414276517 -122.432868400457 (37.7465414276517, -122.432868400457)
149487 208977 3 103 300x Marietta Dr 45 11 1 2     27 Width 5ft   5999505.82373 2097502.74743 37.7393141797969 -122.44425497048401 (37.7393141797969, -122.444254970484)
144679 106811 3 103 3500X MISSION ST 17 11 1 2     20     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
139032 30154 3 103 410X Mansell St 23 11 1 2     24 M   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
127427 106795 3 103 199X ARLINGTON ST 55 11 1 2     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
113760 106810 3 103 3500X MISSION ST 10 11 1 2     11     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
109383 106792 3 103 199X ARLINGTON ST 1 11 1 2     15     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
106180 106794 3 103 199X ARLINGTON ST 51 11 1 2     18     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639)
99315 3751 3 103 990 Carolina St 1 11 1 2     42 18   6012435.5557064 2103342.2152382 37.756077292734105 -122.399959384248 (37.7560772927341, -122.399959384248)
87799 13410 3 103 364 Marietta Dr 3 11 1 2     12 5   5999660.108164 2097381.7238333 37.738990678772396 -122.443712833155 (37.7389906787724, -122.443712833155)
71413 113506 3 103 200x Mansell St 12 11 1 2     39 3x3   6011135.08211 2090555.5358799999 37.7208952054249 -122.40355728893199 (37.7208952054249, -122.403557288932)
47690 176337 3 103 100x Mansell St 5 11 1 2     59 Width 0ft   6011478.9031 2090656.6645400003 37.72119208331829 -122.40237590353901 (37.7211920833183, -122.402375903539)
44888 176341 3 103 500x Mansell St 17 11 1 2     11 Width 0ft   6010266.44711 2090286.24099 37.7201072185592 -122.406540946309 (37.7201072185592, -122.406540946309)
44177 113502 3 103 200x MANSELL ST 8 11 1 2     30 3x3   6011136.0 2090597.0 37.7210091086741 -122.403557031831 (37.7210091086741, -122.403557031831)
38393 176339 3 103 100x Mansell St 7 11 1 2     26 Width 0ft   6011461.59774 2090655.36204 37.7211875408569 -122.402435631998 (37.7211875408569, -122.402435631998)
28512 176338 3 103 100x Mansell St 6 11 1 2     5 Width 0ft   6011479.2515 2090641.1055 37.721149380822 -122.402373605767 (37.721149380822, -122.402373605767)
19139 29600 3 103 900X Junipero Serra Blvd 9 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991176.92289 2091079.14193 37.7211978713578 -122.472584119478 (37.7211978713578, -122.472584119478)
19068 26911 3 103 10 Caine Ave 7 11 1 2     18 10   5997609.86555 2089654.4499099997 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607)
12367 24267 3 103 350X Winding Way 5 11 1 2     12 8   6001124.44895 2086586.86413 37.7094338594468 -122.43787685174401 (37.7094338594468, -122.437876851744)
12342 24268 3 103 350X Winding Way 6 11 1 2     12 8   6001111.916180001 2086587.12369 37.7094338594537 -122.437920185566 (37.7094338594537, -122.437920185566)
8841 23183 3 103 520X Van Ness Ave 3 11 1 2   06/09/2005 12:00:00 AM 6 3X3   6006719.9876 2112427.32903 37.780702551515496 -122.42037059124901 (37.7807025515155, -122.420370591249)
7960 23202 3 103 520X Van Ness Ave 4 11 1 2     24 9   6006708.88776 2112470.99571 37.7808218241176 -122.420412091366 (37.7808218241176, -122.420412091366)
656 23200 3 103 520X Van Ness Ave 2 11 1 2     30 9   6006725.22564 2112390.29825 37.7806011691535 -122.420349841196 (37.7806011691535, -122.420349841196)
Powered by Datasette · Query took 15.334ms · Data source: data.sfgov.org