sf-trees

Data source: data.sfgov.org

Custom SQL query returning 42 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
260 221893 2 68 3164 25th St 3 1 1 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
3668 43018 1 68   3 1 1 1   07/05/2000 12:00:00 AM     Permit Number 42880          
6607 34069 1 68 955 Kennedy Ave 3 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37965          
7921 29760 3 68 500 Francisco St 3 1 1 2     6 3x3   6008840.5335 2121127.883 37.804711410621294 -122.41365014448401 (37.8047114106213, -122.413650144484)
9818 46930 1 68 1 Pacheco St 3 1 1 1 1 12/29/2016 12:00:00 AM 3   Permit Number 779184 5995168.47040897 2099126.50126016 37.743524195830396 -122.459369067857 (37.7435241958304, -122.459369067857)
9953 107188 1 68 1500 PAGE ST 3 1 1 1   09/15/2014 12:00:00 AM 3 3x3 Permit Number 773122 5999274.2 2109122.8 37.771206769657205 -122.445891326497 (37.7712067696572, -122.445891326497)
10511 38233 1 68 0 16th St 3 1 1 1   07/21/1998 12:00:00 AM     Permit Number 40352          
22152 10132 3 68 899 Guerrero St 3 1 1 2   02/04/1992 12:00:00 AM 6 3X3   6005714.0796 2103814.39751 37.756996764997 -122.42323809485599 (37.756996764997, -122.423238094856)
25801 225955 2 68 245 Roanoke St 3 1 1 1     1 Width 3ft   6003637.7380800005 2095933.74555 37.735240927214704 -122.42985676608299 (37.7352409272147, -122.429856766083)
31526 95134 1 68 450@ Wayland Somerset St 3 1 1 1     1 3x3   6010117.366119999 2092259.39432 37.7255167458877 -122.40719528853501 (37.7255167458877, -122.407195288535)
33404 225968 2 68 3599 24th St 3 1 1 1     20 Width 3ft   6005865.3441 2101966.56287 37.751931574603894 -122.422583660903 (37.7519315746039, -122.422583660903)
35468 49765 1 68 333 Schwerin St 3 1 1 1 1 06/04/2003 12:00:00 AM 5   Permit Number 46559 6008653.27394 2086377.17589 37.7092833534188 -122.411841080097 (37.7092833534188, -122.411841080097)
38420 244549 2 68 1500 Page St 3 1 1 1     4 Width 0ft   5999267.0062 2109103.195 37.7711525285338 -122.44591479977801 (37.7711525285338, -122.445914799778)
40705 192411 2 68 650 Rhode Island St 3 4 1 1     5 Width 3ft   6011779.44506 2105347.31232 37.7615462436837 -122.40236942660499 (37.7615462436837, -122.402369426605)
44681 225910 2 68 99 Fair Oaks St 3 1 1 1     7 Width 5ft   6005408.28506 2103204.3544 37.7553044666341 -122.42425226303101 (37.7553044666341, -122.424252263031)
58473 225900 2 68 1398 Bryant St 3 1 1 1     11 Width 4ft   6009378.42208 2107868.1744 37.768333627729504 -122.410851658572 (37.7683336277295, -122.410851658572)
59772 225960 2 68 202 Jarboe Ave 3 1 1 1     10 Width 3ft   6008021.65482 2096973.39205 37.7383428544349 -122.41477346894699 (37.7383428544349, -122.414773468947)
73386 176503 2 68 170 Brookdale Ave 3 9 1 1     8 Width 6ft   6005661.68615 2087270.92863 37.711569123398796 -122.422243953714 (37.7115691233988, -122.422243953714)
75984 225936 2 68 1232 Treat Ave 3 1 1 1     11 Width 3ft   6008666.40255 2101335.6889400003 37.7503569633096 -122.412852569207 (37.7503569633096, -122.412852569207)
76617 32627 1 68 75 Boardman Pl 3 1 1 1 1 10/23/1996 12:00:00 AM 15   Permit Number 37080 6011835.142990001 2109991.00563 37.774299885758 -122.40250333475599 (37.774299885758, -122.402503334756)
83902 113388 1 68 185 CASTENADA AVE 3 1 1 1     3     5994493.0 2100782.0 37.7480309194949 -122.461824674651 (37.7480309194949, -122.461824674651)
91176 32985 1 68 10X Sierra St 3 1 1 1 1 11/01/1996 12:00:00 AM   5x9 Permit Number 37296 6013812.07366772 2104214.5102771 37.7585490739971 -122.395259990599 (37.7585490739971, -122.395259990599)
95253 32807 1 68 1686 Hayes St 3 1 1 1 1 10/29/1996 12:00:00 AM     Permit Number 37166 5999791.91343358 2110220.51293563 37.7742503589901 -122.44417943364999 (37.7742503589901, -122.44417943365)
100066 48959 1 68 1521 Florida St 3 1 1 1   11/26/2002 12:00:00 AM     Permit Number 46145 6009607.60540748 2100518.70293664 37.7481664860313 -122.40954015648 (37.7481664860313, -122.40954015648)
105535 10695 3 68 1250 Hayes St 3 1 1 2     12 3X3   6001856.34415 2110522.16346 37.7751961745675 -122.43705980731701 (37.7751961745675, -122.437059807317)
110666 98258 2 68 2800X 16th St 3 1 1 1     10 3x3   6007899.1 2106885.5 37.7655523739417 -122.41589891426099 (37.7655523739417, -122.415898914261)
121526 105214 2 68 2400X 21ST AVE 3 1 1 1     2 3x3   5989837.0 2098691.0 37.7420204448441 -122.477771936587 (37.7420204448441, -122.477771936587)
121755 36066 1 68 1398 Bryant St 3 1 1 1   04/28/1998 12:00:00 AM     Permit Number 39186 6009394.0 2107812.0 37.76818025927739 -122.410793808029 (37.7681802592774, -122.410793808029)
121812 29765 3 68 570 Francisco St 3 1 1 2     6 4x4   6008571.0386595 2121096.2836166 37.8046095098754 -122.414580523895 (37.8046095098754, -122.414580523895)
129299 108168 1 68 2x FRANCONIA ST 3 1 1 1 1         6009949.0 2099997.0 37.74675312806 -122.40832282803001 (37.74675312806, -122.40832282803)
131583 219011 2 68 157 Miramar Ave 3 1 1 1     3 Width 3ft   5995317.533340001 2090902.82075 37.7209525389978 -122.458258556883 (37.7209525389978, -122.458258556883)
131668 176513 2 68 154 Brookdale Ave 3 9 1 1     8 Width 6ft   6006276.40846 2087403.9786200002 37.7119691058641 -122.42012874286199 (37.7119691058641, -122.420128742862)
132274 225962 2 68 200 Jarboe Ave 3 1 1 1     10 Width 3ft   6007966.252640001 2096976.9069400001 37.738349392503 -122.414965271836 (37.738349392503, -122.414965271836)
133659 142688 2 68 552 FRANCISCO ST 3 1 1 1     3 Width 0ft   6008641.5861 2121102.2307 37.8046298022358 -122.414336807992 (37.8046298022358, -122.414336807992)
136191 192416 2 68 1400 20th St 3 4 1 1     9 Width 3ft   6013651.01145 2104790.61421 37.760121971170896 -122.395857388933 (37.7601219711709, -122.395857388933)
154338 192414 2 68 740 Rhode Island St 3 4 1 1     16 Width 3ft   6011806.79674 2104934.73644 37.76041492892529 -122.40224581930799 (37.7604149289253, -122.402245819308)
164012 128873 2 68 1270 Clay St 3 9 1 1     3 Width 3ft   6008597.37413 2116983.75832 37.7933190163979 -122.414198247271 (37.7933190163979, -122.414198247271)
171362 192424 2 68 80 Carolina St 3 1 1 1     19 Width 4ft   6012214.215580001 2107593.00345 37.767736670334 -122.40102351921401 (37.767736670334, -122.401023519214)
173461 192419 2 68 2 Sierra St 3 4 1 1     8 Width 5ft   6013725.780809999 2104155.14731 37.7583812766799 -122.39555427333299 (37.7583812766799, -122.395554273333)
174678 128878 2 68 2507 Larkin St 3 1 1 1     1 Width 3ft   6006675.76572 2119877.35226 37.8011559740396 -122.421052707221 (37.8011559740396, -122.421052707221)
177304 176507 2 68 150 Brookdale Ave 3 9 1 1     45 Width 6ft   6005719.71054 2087314.8851 37.7116930913392 -122.422046526423 (37.7116930913392, -122.422046526423)
185659 245457 2 68 2800 16th St 3 1 1 1     9 Width 0ft   6007865.341 2106811.8898 37.7653483594859 -122.41601046611099 (37.7653483594859, -122.416010466111)
Powered by Datasette · Query took 5.565ms · Data source: data.sfgov.org