sf-trees

Data source: data.sfgov.org

Custom SQL query returning 27 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2852 215287 2 42 335 Noriega St 1 1 1 1     12 Width 3ft Permit Number 780412 5992944.71929 2103190.50616 37.7545548052666 -122.46735363008301 (37.7545548052666, -122.467353630083)
31678 137728 2 42 1989 McAllister St 1 1 1 1     12 Width 0ft   5999638.3271 2111189.9480000003 37.77690341710429 -122.444780412241 (37.7769034171043, -122.444780412241)
33288 220075 2 42 311 Douglass St 1 1 1 1     12 Width 3ft   6001146.06945 2104525.9934099996 37.758691778412704 -122.43908696419201 (37.7586917784127, -122.439086964192)
41095 220673 2 42 100 Alemany Blvd 25 1 1 1     12 Width 3ft   6009345.21028 2095878.12902 37.735409776738294 -122.410119940478 (37.7354097767383, -122.410119940478)
41760 203657 2 42 226 Joost Ave 2 9 1 1     12 Width 10ft   6000556.64604 2094979.3129099999 37.7324453144793 -122.440440771241 (37.7324453144793, -122.440440771241)
41964 246075 2 42 635 Clayton St 1 1 1 1     12 Width 0ft   5998492.5621 2108432.0423 37.7692654626532 -122.44854527514299 (37.7692654626532, -122.448545275143)
45189 220002 2 42 1001 Jarboe Ave 1 10 1 1     12 Width 8ft   6009383.355930001 2096884.0702099998 37.7381740121064 -122.4100590501 (37.7381740121064, -122.4100590501)
48670 220058 2 42 564 Shotwell St 1 1 1 1     12 Width 3ft   6007852.78726 2104670.9495900003 37.7594691272161 -122.415902267384 (37.7594691272161, -122.415902267384)
53685 220687 2 42 430 Hickory St 2 1 1 1     12 Width 3ft   6004894.475319999 2110399.44382 37.775031437471704 -122.426541481018 (37.7750314374717, -122.426541481018)
57888 220056 2 42 1424 Alabama St 1 1 1 1     12 Width 4ft   6009277.433730001 2100868.30065 37.7491078976199 -122.410706569176 (37.7491078976199, -122.410706569176)
61990 140718 2 42 556 SCOTT ST 3 1 1 1     12 Width 0ft   6002160.0013 2110449.3533 37.7750135114472 -122.436004179308 (37.7750135114472, -122.436004179308)
62065 188522 2 42 65 Whitney Young Cir 12 1 1 1     12 Width 4ft   6016938.13191 2094902.8329099999 37.7331544721811 -122.38380023041701 (37.7331544721811, -122.383800230417)
68651 220688 2 42 434 Hickory St 1 1 1 1     12 Width 3ft   6004866.02058 2110397.15298 37.7750235387365 -122.426639749043 (37.7750235387365, -122.426639749043)
72341 220010 2 42 3561 20th St 1 1 1 1     12 Width 3ft   6006555.55006 2104341.3837900003 37.758491199927 -122.420365369767 (37.758491199927, -122.420365369767)
72487 249768 2 42 266 Lombard St 4 7 1 1     12 Width 0ft   6010977.12206 2120702.10235 37.8036620671076 -122.406226211476 (37.8036620671076, -122.406226211476)
96893 105172 2 42 1601X NEWCOMB AVE 1 1 1 19     12 3x3 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074)
125571 220042 2 42 890 Alvarado St 2 1 1 1     12 Width 4ft   6000646.62015 2102597.34113 37.7533677370469 -122.440675944861 (37.7533677370469, -122.440675944861)
136405 203653 2 42 125 Brompton Ave 1 1 1 1     12 Width 4ft   6002114.00252 2095255.92738 37.733293387768995 -122.435076406948 (37.733293387769, -122.435076406948)
158299 138337 2 42 2250 Sutter St 1 1 1 1     12 Width 0ft   6001955.802999999 2114338.6797 37.7856810164636 -122.436989049911 (37.7856810164636, -122.436989049911)
162001 220694 2 42 4054 26th St 1 1 1 1     12 Width 4ft   6003525.2287099995 2100710.43544 37.74835024488029 -122.430586486796 (37.7483502448803, -122.430586486796)
166210 203659 2 42 628 Edna St 3 1 1 1     12 Width 3ft   5998583.28764 2094893.18321 37.7320962615306 -122.44725691200199 (37.7320962615306, -122.447256912002)
173115 203638 2 42 750 Grafton Ave 2 1 1 1     12 Width 3ft   5994537.11563 2090599.0913099998 37.720073694513104 -122.46093420637101 (37.7200736945131, -122.460934206371)
178617 188524 2 42 65 Whitney Young Cir 27 1 1 1     12 Width 3ft   6017319.36932 2094988.95682 37.7334120182438 -122.38248816719299 (37.7334120182438, -122.382488167193)
179662 203222 2 42 120 Taraval St 2 1 1 1     12 Width 3ft   5993081.79545 2099194.6713799997 37.7435911783029 -122.466589164064 (37.7435911783029, -122.466589164064)
180380 203655 2 42 230 Edna St 8 17 1 1     12     5998797.91036 2095380.6148 37.7334468948521 -122.446549972903 (37.7334468948521, -122.446549972903)
185093 220033 2 42 502 28th St 2 10 1 1     12     6002622.25428 2099488.24408 37.7449431983695 -122.433621612357 (37.7449431983695, -122.433621612357)
186973 220091 2 42 3076 Merritt St 1 1 1 1     12 Width 3ft   6000057.55788 2105416.72092 37.7610754998513 -122.442915486985 (37.7610754998513, -122.442915486985)
Powered by Datasette · Query took 172.052ms · Data source: data.sfgov.org