sf-trees

Data source: data.sfgov.org

Custom SQL query returning 22 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31616 191508 2 55 55 Sherman St 25 4 1 1     3 Width 10ft   6010631.502780001 2111081.40715 37.777226606154706 -122.406743828871 (37.7772266061547, -122.406743828871)
36586 207860 2 55 88 Ralston St 2 4 1 1     6 Width 3ft   5992206.435269999 2088409.02561 37.7139259191081 -122.468831219804 (37.7139259191081, -122.468831219804)
45797 207862 2 55 50 Vernon St 2 4 1 1     13 Width 3ft   5992461.4298 2088225.8604700002 37.7134377203567 -122.467936556254 (37.7134377203567, -122.467936556254)
46570 226667 2 55 201 Buchanan St 4 4 1 1     8 Width 3ft   6004704.0947199995 2109267.38309 37.7719123098365 -122.42711939795 (37.7719123098365, -122.42711939795)
62524 207864 2 55 2545 Ocean Ave 1 4 1 1     8 Width 3ft   5991142.22279 2094819.8771799998 37.731466988790395 -122.47297671042801 (37.7314669887904, -122.472976710428)
63748 207859 2 55 88 Ralston St 1 4 1 1     5 Width 3ft   5992207.50569 2088392.37957 37.713880274943 -122.468826309486 (37.713880274943, -122.468826309486)
64260 226666 2 55 201 Buchanan St 3 4 1 1     3 Width 3ft   6004707.88321 2109244.5049400004 37.771849706222504 -122.42710466345899 (37.7718497062225, -122.427104663459)
67169 207858 2 55 143 Garfield St 1 4 1 1     6 Width 3ft   5993571.00568 2090460.55199 37.7196376600192 -122.46426364137699 (37.7196376600192, -122.464263641377)
69576 226665 2 55 201 Buchanan St 2 4 1 1     7 Width 3ft   6004711.01966 2109215.80754 37.7717710874854 -122.42709176988701 (37.7717710874854, -122.427091769887)
70640 191448 2 55 1375 Fairfax Ave 3 4 1 1     6 Width 3ft   6016804.06254 2097268.13995 37.7396417192015 -122.384428434726 (37.7396417192015, -122.384428434726)
132468 191449 2 55 1224 Fairfax Ave 4 4 1 1     4 Width 4ft   6017403.85827 2096904.38167 37.7386760604628 -122.382329276794 (37.7386760604628, -122.382329276794)
147022 207861 2 55 70 Ralston St 1 4 1 1     9 Width 3ft   5992207.07547 2088343.8619 37.7137470322778 -122.46882426804702 (37.7137470322778, -122.468824268047)
153647 191443 2 55 394 19th St 2 4 1 1     10 Width 3ft   6013161.12259 2105230.3834700002 37.7613022153415 -122.397582536801 (37.7613022153415, -122.397582536801)
163117 191445 2 55 1451 19th St 3 4 1 1     4 Width 4ft   6013335.759880001 2105192.0474900003 37.761206675862205 -122.396975847857 (37.7612066758622, -122.396975847857)
165759 226664 2 55 201 Buchanan St 1 4 1 1     12 Width 3ft   6004714.2759300005 2109192.94036 37.771708483891395 -122.42707887721201 (37.7717084838914, -122.427078877212)
167236 191450 2 55 1298 Fairfax Ave 7 4 1 1     6 Width 3ft   6017131.85969 2097105.51243 37.73921329744729 -122.383283724566 (37.7392132974473, -122.383283724566)
170780 249329 2 55 814 Post St 1 4 1 1     6 Width 3ft   6008232.68347 2114867.71891 37.7874883986038 -122.415310240102 (37.7874883986038, -122.415310240102)
177365 191447 2 55 1300 Phelps St 10 4 1 1     15 Width 5ft   6014017.68905 2096332.11237 37.7369171097253 -122.393997082801 (37.7369171097253, -122.393997082801)
180465 191444 2 55 200 Connecticut St 1 4 1 1     14 Width 2ft   6013146.00458 2106079.844 37.763633804867 -122.397694407074 (37.763633804867, -122.397694407074)
182691 246495 2 55 359 Duncan St 1 4 1 1     15 Width 3ft   6004220.129819999 2099827.66275 37.7459656978564 -122.428120633885 (37.7459656978564, -122.428120633885)
183784 226662 2 55 109 Buchanan St 1 4 1 1     10 Width 3ft   6004759.3932300005 2108882.7963099997 37.7708594546408 -122.42690072149901 (37.7708594546408, -122.426900721499)
187511 226663 2 55 109 Buchanan St 2 4 1 1     10 Width 4ft   6004754.99125 2108900.4446099997 37.77090766370029 -122.426917205171 (37.7709076637003, -122.426917205171)
Powered by Datasette · Query took 27.573ms · Data source: data.sfgov.org