sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
79011 108637 7 3 15 TUCKER AVE   13 1 1           6011049.2 2088423.2 37.715035447895396 -122.403704200211 (37.7150354478954, -122.403704200211)
80672 98502 7 17 244 Glenview Dr   13 2 1           5999066.0 2100737.0 37.7481695560511 -122.44600824337601 (37.7481695560511, -122.446008243376)
82720 98465 7 17 190 Portola Dr   13 2 1           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302)
82794 110929 7 3 445 BEACON ST   13 1 1       3x3   6002243.0 2098437.0 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675)
89166 102275 7 17 267 Topaz Way   13 2 1           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857)
90297 107819 2 3 75X RALSTON ST   13 1 1     45   Permit Number 775492 5992193.0 2088303.0 37.7136340221674 -122.46886994586599 (37.7136340221674, -122.468869945866)
91108 97177 7 17 257 Roosevelt Way   13 1 1         Monterey cypress tree in backyard on private property; not a Significant tree 6000848.1 2107127.9 37.765819014897296 -122.44030407045099 (37.7658190148973, -122.440304070451)
94734 98893 7 17 216 Glenview Dr   13 2 1           5998910.0 2100761.0 37.7482265448319 -122.44654941060699 (37.7482265448319, -122.446549410607)
96669 112123 2 3 771 WALLER ST   13 1 1     24 3x3   6002060.0 2108730.0 37.770286913106204 -122.43622703445601 (37.7702869131062, -122.436227034456)
97106 102276 5 17 279 Topaz Way   13 2 1           6001205.6 2097796.6 37.7402178594385 -122.43839895973301 (37.7402178594385, -122.438398959733)
98291 98892 7 17 220 Glenview Dr   13 2 1           5998935.0 2100753.0 37.7482060067302 -122.44646238623999 (37.7482060067302, -122.44646238624)
98644 106968 7 54 351 26th Ave   13 1 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
98769 112422 2 17 279 Topaz Way   13 1 1   07/29/2015 12:00:00 AM 3 3x3 Permit Number 775772 6001205.6 2097796.6 37.7402178594385 -122.43839895973301 (37.7402178594385, -122.438398959733)
99282 87387 1 175 201 Topeka Ave   13 1 1   04/24/2008 12:00:00 AM     Permit Number 50366 6012955.9 2095077.8 37.7334139596128 -122.39758023766399 (37.7334139596128, -122.397580237664)
99802 98890 7 17 256 Glenview Dr   13 2 1           5999134.0 2100748.0 37.748203642185395 -122.44577389345 (37.7482036421854, -122.44577389345)
100855 114731 7 103 934 BRANNAN ST   13 1 1 9     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
101483 113482 7 3 2839 Pierce St   13 1 1           6001345.0 2118077.0 37.7959107386074 -122.43937030854799 (37.7959107386074, -122.439370308548)
102307 99256 7 116 1466 York St   13 1 1           6010099.0 2100741.0 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429)
103600 98436 7 17 238 Glenview Dr   13 1 1           5999035.0 2100736.0 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035)
107492 98715 7 3 26 Vernon St   13 1 1           5992459.0 2088068.0 37.713004133171 -122.46793347935301 (37.713004133171, -122.467933479353)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
112387 109194 7 180 4705 03rd St   13 1 19     45     6015121.6 2095617.0 37.7350148477359 -122.39013039721901 (37.7350148477359, -122.390130397219)
112498 106458 7 17 71 HANCOCK ST   13 1 1           6003861.6 2105050.0 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413)
112733 107503 2 3 4140 19th Ave   13 1 1           5992157.71887 2088336.37745 37.7137236301705 -122.46899431666 (37.7137236301705, -122.46899431666)
114652 97162 7 235 478 10th Ave   13 1 1         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686)
114869 111205 9 24 46 COOK ST   13 1 1     36   Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
114948 113440 7 47 190 BEACON ST   13 1 1     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
115312 100244 7 113 71 Sanchez St   13 1 1         Interior courtyard 6003507.0 2107903.0 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878)
115357 98501 7 17 232 Glenview Dr   13 2 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
116410 112904 2 105 727 BURNETT AVE   13 1 1       3x3   5999303.0 2101616.0 37.750596607185 -122.44525189688 (37.750596607185, -122.44525189688)
119700 100472 7 3 70 Stanford Heights Ave   13 1 1           5997872.4 2096006.9 37.735113616296 -122.44979482672899 (37.735113616296, -122.449794826729)
119975 112668 7 3 129 Henry St   13 1 1           6002668.0 2107340.8 37.766507036069605 -122.434024647923 (37.7665070360696, -122.434024647923)
120804 96938 7 17 1306 Cole St   13 1 1         Backyard tree on private property 5998246.0 2105961.0 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104)
122333 97685 7 47 84 Coventry Ct   13 1 1           5997084.0 2096485.0 37.7363812239889 -122.452555087132 (37.7363812239889, -122.452555087132)
122667 100169 3 3 180X Manchester St   13 1 2         Adjacent to rear of property - DPW parcel 6008242.0 2099158.0 37.7443536844995 -122.414166136282 (37.7443536844995, -122.414166136282)
124250 99374 7 3 21 Panorama Dr   13 1 1     24     5998009.0 2100230.0 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288)
125346 100148 7 17 209 Vicksburg St   13 1 1           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815)
128066 98503 7 47 208 Glenview Dr   13 1 1           5998871.0 2100779.0 37.74827374071911 -122.44668556582701 (37.7482737407191, -122.446685565827)
128311 98265 7 143 755 O'Farrell St   13 1 1         Backyard tree; not significant 6007700.0 2113968.3 37.784988860902295 -122.417089467607 (37.7849888609023, -122.417089467607)
129485 97033 7 70 61 Vicksburg St   13 1 1         Possible significant tree; Nellie RoW; rear yard 6004120.0 2102703.0 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406)
141038 102381 7 3 258 Molimo Dr   13 1 1           5997615.0 2096604.0 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905)
141787 103673 7 54 64 Henry St   13 1 1           6003097.0 2107420.0 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662)
142266 98139 7 124 556 Laidley St   13 1 1       3x3   6003085.0 2096041.0 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062)
142682 102752 7 116 2452 Green St   13 1 1           6001313.0 2117994.0 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
427 251307 2 17 200 Cashmere St 1 13 1 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
474 251300 2 36 100 Whitney Young Cir 1 13 1 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
669 251343 7 39 934 Brannan St 1 13 1 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
780 251383 2 113 49x Milan Ter 1 13 1 1       3x3   5997587.0 2087495.0 37.711725600519706 -122.450168218052 (37.7117256005197, -122.450168218052)
896 251302 2 103 1 Cashmere St 1 13 1 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
1305 251497 2 17 329x Warren Dr 1 13 1 1       3x3   5994610.0 2103362.0 37.7551216790189 -122.461607123764 (37.7551216790189, -122.461607123764)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1398 251517 2 47 145 Bonview St 1 13 1 1       3x3   6007188.0 2098162.0 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1607 251602 6 108 44R Amber Dr 1 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1625 251623 2 47 76R Amber Dr 1 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1626 251635 2 47 18R Amethyst Way 1 13 1 1           5999176.0 2100050.0 37.746289501198795 -122.445578473632 (37.7462895011988, -122.445578473632)
1628 251629 6 47 8R Amethyst Way 1 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1643 251614 2 47 64R Amber Dr 1 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1645 251626 6 47 2R Amethyst Way 1 13 1 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1648 251606 6 3 52R Amber Dr 1 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1650 251608 6 47 56R Amber Dr 1 13 1 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1652 251618 2 47 72R Amber Dr 1 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1996 252848 7 164 99 Reposa Way 1 13 1 1       3x3   5998022.0 2098104.0 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965)
2457 253065 2 64 1x Drake St 1 13 1 1       3x3   6001423.0 2086924.0 37.710376533009295 -122.436869130393 (37.7103765330093, -122.436869130393)
2502 253119 5 3 185 Belgrave Ave 1 13 1 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
3760 253533 3 77 1000 Cayuga Ave 1 13 1 2   09/22/2017 01:57:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3835 253567 5 218 25 Raycliff Ter 1 13 1 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
4283 253621 6 143 200x Montcalm St 1 13 1 1       3x3   6010036.0 2099760.0 37.7461072494139 -122.40800527847799 (37.7461072494139, -122.408005278478)
4447 253626 7 47 1671 Funston Ave 1 13 1 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
4922 253717 6 105 4101 Balboa St 1 13 1 1           5982822.0 2110967.0 37.7753172554615 -122.50293574331002 (37.7753172554615, -122.50293574331)
5096 253768 7 47 100 Raccoon Dr 1 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
8592 121500 5 3 251X Pennsylvania Ave 1 13 1 2                    
10146 173882 2 3 201x Howth St 1 13 1 1           5997459.0 2090748.0 37.7206502603184 -122.450845024895 (37.7206502603184, -122.450845024895)
10196 173897 2 105 90x Knollview Way 1 13 1 1       3x3   5997593.0 2101480.0 37.7501254274205 -122.451155378281 (37.7501254274205, -122.451155378281)
10199 173896 2 3 326x Dellbrook Ave 1 13 1 1       3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
10223 173927 6 3 240 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
10255 112606 2 47 100X Monument Way 1 13 1 1       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076)
13268 187627 5 47 88 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
13301 187651 6 1 175 Raccoon Dr 1 13 1 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
13321 187670 7 3 230 Victoria St 1 13 1 1       3x3   5993274.0 2088748.0 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001)
20974 109568 6 116 95 Nordhoff St 1 13 1 1         Permit Number 777169 6000348.8 2095645.6 37.734262946491704 -122.44120712981501 (37.7342629464917, -122.441207129815)
22300 248974 7 2 716 Goettingen St 1 13 1 1       3x3   6010713.0 2091306.0 37.7229322393396 -122.405069122237 (37.7229322393396, -122.405069122237)
22826 251117 7 212 2024 Castro St 1 13 1 1           6002622.0 2099601.0 37.7452527853239 -122.43363054854099 (37.7452527853239, -122.433630548541)
22866 251139 6 17 621X Gough St 1 13 1 1   03/10/2017 12:00:00 AM 3   Permit Number 779685          
22926 251147 2 47 113x Gladeview Way 1 13 1 1       3x3   5997915.0 2102038.0 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397)
23859 223337 2 197 21 Poppy Ln 1 13 1 1     5 Width 2ft   6002002.72042 2096679.5859400001 37.737196106421706 -122.435562951888 (37.7371961064217, -122.435562951888)
25761 217537 2 224 89 Ralston St 1 13 1 1     18     5992163.635980001 2088434.33055 37.713992927605204 -122.468980989298 (37.7139929276052, -122.468980989298)
26526 228904 2 11 902 Duboce Ave 1 13 1 1     6     6002231.23378 2108246.83249 37.7689699817064 -122.435600166732 (37.7689699817064, -122.435600166732)
27599 232417 2 1 173 Everson St 1 13 1 1     15     6002718.41885 2097663.27226 37.7399377058635 -122.433158722322 (37.7399377058635, -122.433158722322)
28419 108850 1 58 250x MONTCALM ST 1 13 1 1   02/09/2015 12:00:00 AM 3   Permit Number 774524 6009909.2 2099657.1 37.745817608401104 -122.40843648152 (37.7458176084011, -122.40843648152)
28538 212784 2 15 739 Foerster St 1 13 1 1     17 Width 3ft   5998105.0801800005 2095806.61255 37.734576984727795 -122.448975948078 (37.7345769847278, -122.448975948078)
30020 218148 2 47 35 Ashton Ave 1 13 1 1     25     5994122.86099 2090034.3755400002 37.7184992748049 -122.462325196761 (37.7184992748049, -122.462325196761)
30330 233958 2 108 19 Penny Ln 1 13 1 1     4 Width 2ft   6002544.64531 2096274.1188599998 37.73611355200129 -122.433660302082 (37.7361135520013, -122.433660302082)
35110 176590 2 288 4103 Alemany Blvd 1 13 1 1     23 Width 10ft   5991596.71486 2086796.0596 37.7094618598487 -122.470821200944 (37.7094618598487, -122.470821200944)
37767 211724 2 26 41 Ralston St 1 13 1 1     4     5992178.335940001 2088233.1934099998 37.71344150289679 -122.468915552827 (37.7134415028968, -122.468915552827)
Powered by Datasette · Query took 5.724ms · Data source: data.sfgov.org