sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
138223 57922 1 190 539 Brunswick St 1 1 1 1   06/24/1977 12:00:00 AM 5   Permit Number 16880 5999313.15008 2086900.5185900002 37.7101919177852 -122.444159502961 (37.7101919177852, -122.444159502961)
148462 176280 2 190 600 Blanken Ave 2 9 1 1     5 Width 5ft   6013180.81524 2086857.6738099998 37.7108556687339 -122.39622672069599 (37.7108556687339, -122.396226720696)
155016 176272 2 190 179 Niagara Ave 1 10 1 1     5 Width 0ft   5999311.03211 2089604.94508 37.717617539904296 -122.444361048235 (37.7176175399043, -122.444361048235)
158863 176275 2 190 23 Byron Ct 1 1 1 1     5 Width 3ft   5999165.787269999 2086612.0753799998 37.7093915094837 -122.444648098339 (37.7093915094837, -122.444648098339)
165369 224112 2 190 1100 San Jose Ave 51 9 1 1     5     6004737.84332 2096628.1853599998 37.7372099397936 -122.42610271887101 (37.7372099397936, -122.426102718871)
169472 207719 2 190 126 Brighton Ave 1 9 1 1     5 Width 1ft   5996251.42646 2090752.11635 37.7205923605284 -122.455019501973 (37.7205923605284, -122.455019501973)
172227 120404 2 190 527 23rd Ave 1 1 1 1     5 Width 3ft   5988748.3356 2111702.11927 37.777682216959704 -122.482489301184 (37.7776822169597, -122.482489301184)
174539 207721 2 190 228 Montana St 1 10 1 1     5     5994631.9391 2089350.3088 37.7166502911674 -122.460515994629 (37.7166502911674, -122.460515994629)
177924 126565 2 190 1519 Pacific Ave 3 1 1 1     5 Width 4ft   6006864.87455 2117678.3281900003 37.795128665521 -122.420242146478 (37.795128665521, -122.420242146478)
Powered by Datasette · Query took 2.508ms · Data source: data.sfgov.org