sf-trees

Data source: data.sfgov.org

Custom SQL query returning 16 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2540 141909 2 49 900 MCALLISTER ST 9 1 1 1     5 Width 0ft   6004576.1236 2111931.0419 37.779218827498205 -122.427751880486 (37.7792188274982, -122.427751880486)
38275 191664 2 49 535 Brannan St 9 1 1 1     8 Width 2ft   6013199.96962 2111004.76664 37.777159542827704 -122.397853242637 (37.7771595428277, -122.397853242637)
53616 35078 1 49 1541 12th Ave 9 1 1 1 1 01/26/1998 12:00:00 AM     Permit Number 38627 5992419.71878294 2104964.13539049 37.759394405692504 -122.46929829243 (37.7593944056925, -122.46929829243)
79816 99035 3 49 200X Bartlett St 9 1 1 4 2   10 3x3   6006692.0 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314)
88887 52809 1 49 25@ TEXAS Sierra St 9 1 1 1   05/25/2006 12:00:00 AM     Permit Number 48835 6013772.92448179 2104112.24559711 37.7582661000564 -122.39538822301 (37.7582661000564, -122.39538822301)
91474 46992 1 49 2011 26th St 9 1 1 1   05/01/2002 12:00:00 AM     Permit Number 44999 6012426.60175733 2101420.79231292 37.7508009841444 -122.39985543326799 (37.7508009841444, -122.399855433268)
109483 1769 3 49 2000X Bay Shore Blvd 9 1 1 2   06/11/2011 12:00:00 AM 3 3x3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
118904 26139 1 49 1500 Oakdale Ave 9 1 1 3   11/05/2005 12:00:00 AM 4 3x3   6015586.393477299 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626)
133813 223636 2 49 3351 Bartlett St 9 1 1 1     14 Width 3ft   6006708.59634 2102368.48305 37.7530826924205 -122.419696083521 (37.7530826924205, -122.419696083521)
139017 117144 8 49 2203x NEWCOMB AVE 9 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
147410 94756 1 49 491 Bay Shore Blvd 9 1 1 1   10/28/2010 12:00:00 AM 4 3x3   6010397.45691 2097793.22458 37.7407271415462 -122.406616826609 (37.7407271415462, -122.406616826609)
147839 200655 2 49 1516 Oakdale Ave 9 1 1 1     5 Width 0ft   6015384.228999999 2095258.3254 37.7340445629032 -122.389197350847 (37.7340445629032, -122.389197350847)
166638 114655 2 49 2200 Post St 9 1 1 1     5 3x3   6001302.3779 2113905.5111 37.7844544851842 -122.43921865019199 (37.7844544851842, -122.439218650192)
168758 207645 2 49 1541 Funston Ave 9 1 1 1     4 Width 3ft   5992161.381519999 2104923.06164 37.759266696124 -122.470188750009 (37.759266696124, -122.470188750009)
176015 223496 2 49 825 Shotwell St 9 1 1 1     10 Width 3ft   6007971.83825 2103118.56148 37.755213316757704 -122.415380629129 (37.7552133167577, -122.415380629129)
176926 223431 2 49 357 Precita Ave 9 1 1 1     4 Width 3ft   6009008.57649 2100230.6631 37.747342008624 -122.41159123855199 (37.747342008624, -122.411591238552)
Powered by Datasette · Query took 10.139ms · Data source: data.sfgov.org