sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
82201 47719 1 472 227 Surrey St 1 1 1 1 1 05/22/2002 12:00:00 AM     Permit Number 45514 6001968.67680158 2096145.76019893 37.7357284107067 -122.435642476033 (37.7357284107067, -122.435642476033)
90693 50864 1 472 3949 26th St 1 1 1 1   04/08/2004 12:00:00 AM     Permit Number 47379 6004213.25771434 2100699.47949469 37.7483591159424 -122.428206518167 (37.7483591159424, -122.428206518167)
100233 39713 1 472 690 Mangels Ave 4 1 1 1   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806002 (37.7331206330938, -122.45318448806)
112202 39712 1 472 690 Mangels Ave 3 1 1 1   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806002 (37.7331206330938, -122.45318448806)
112657 46918 1 472 132 Apollo St 1 1 1 1   04/29/2002 12:00:00 AM     Permit Number 44975 6012573.05799142 2094250.99481075 37.731122398703 -122.39884583127301 (37.731122398703, -122.398845831273)
115674 39716 1 472 690 Mangels Ave 2 1 1 1   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806002 (37.7331206330938, -122.45318448806)
121350 39714 1 472 690 Mangels Ave 1 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806002 (37.7331206330938, -122.45318448806)
124480 39717 1 472 735 Mangels Ave 1 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41098 5996645.89936221 2095233.50926101 37.732919821696 -122.453979420774 (37.732919821696, -122.453979420774)
144946 39715 1 472 690 Mangels Ave 5 1 1 1   01/05/1999 12:00:00 AM     Permit Number 41097 5996877.25794519 2095301.81406685 37.7331206330938 -122.45318448806002 (37.7331206330938, -122.45318448806)
Powered by Datasette · Query took 1.141ms · Data source: data.sfgov.org