sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3044 253288 2 47 650 Peru Ave 4 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3046 253289 2 47 650 Peru Ave 5 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3049 253290 2 47 650 Peru Ave 6 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3050 253291 2 47 650 Peru Ave 7 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3112 253318 2 47 2 Euclid Ave 16 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3113 253332 2 47 2 Euclid Ave 27 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3115 253329 2 47 2 Euclid Ave 24 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3116 253328 2 47 2 Euclid Ave 23 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3119 253313 2 47 2 Euclid Ave 11 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3120 253308 2 47 2 Euclid Ave 6 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3121 253303 2 47 2 Euclid Ave 1 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3122 253323 2 47 2 Euclid Ave 21 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3123 253306 2 47 2 Euclid Ave 4 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3125 253309 2 47 2 Euclid Ave 7 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3127 253316 2 47 2 Euclid Ave 14 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3128 253330 2 47 2 Euclid Ave 25 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3129 253317 2 47 2 Euclid Ave 15 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3130 253319 2 47 2 Euclid Ave 17 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3131 253310 2 47 2 Euclid Ave 8 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3133 253333 2 47 2 Euclid Ave 28 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3135 253335 2 47 2 Euclid Ave 30 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3136 253320 2 47 2 Euclid Ave 18 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3139 253322 2 47 2 Euclid Ave 20 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3140 253334 2 47 2 Euclid Ave 29 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3141 253311 2 47 2 Euclid Ave 9 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3142 217765 2 47 470 West Portal Ave 4 9 1 1     42 Width 10ft   5991548.70787 2096139.0246599999 37.7351125606845 -122.471667523249 (37.7351125606845, -122.471667523249)
3143 253336 2 47 2 Euclid Ave 31 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3145 253304 2 47 2 Euclid Ave 2 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3146 253314 2 47 2 Euclid Ave 12 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3148 253327 2 47 2 Euclid Ave 22 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3150 253331 2 47 2 Euclid Ave 26 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3151 253312 2 47 2 Euclid Ave 10 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3152 253307 2 47 2 Euclid Ave 5 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3153 253315 2 47 2 Euclid Ave 13 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3155 253305 2 47 2 Euclid Ave 3 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3156 253321 2 47 2 Euclid Ave 19 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3496 253449 2 47 330 Twin Peaks Blvd 1 14 1 1       10x10   5998688.0 2103995.0 37.7570936308358 -122.44754983450599 (37.7570936308358, -122.447549834506)
4884 253710 2 47 1 Monument Way 4 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4891 253709 2 47 1 Monument Way 3 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4893 253707 2 47 1 Monument Way 1 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4898 253711 2 47 1 Monument Way 5 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
4906 253708 2 47 1 Monument Way 2 14 1 1       10x10   5999088.0 2105836.0 37.7621714109075 -122.446298918118 (37.7621714109075, -122.446298918118)
9172 173599 2 47 100X Warren Dr 1 1 1 1     20 3x3   5995367.0 2102770.0 37.7535397418859 -122.458946354326 (37.7535397418859, -122.458946354326)
9640 114128 2 47 1200X JUNIPERO SERRA BLVD 21 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9648 114133 2 47 1200X JUNIPERO SERRA BLVD 26 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9649 114125 2 47 1200X JUNIPERO SERRA BLVD 18 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9650 114131 2 47 1200X JUNIPERO SERRA BLVD 24 9 1 1     30     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9662 114130 2 47 1200X JUNIPERO SERRA BLVD 23 9 1 1     24     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9664 114135 2 47 1200X JUNIPERO SERRA BLVD 30 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9666 114127 2 47 1200X JUNIPERO SERRA BLVD 20 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9669 114126 2 47 1200X JUNIPERO SERRA BLVD 19 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9671 114132 2 47 1200X JUNIPERO SERRA BLVD 25 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9673 114129 2 47 1200X JUNIPERO SERRA BLVD 22 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9678 114134 2 47 1200X JUNIPERO SERRA BLVD 28 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9720 173652 2 47 65 ZIRCON PL 2 9 1 1           6002398.2 2098694.7 37.7427515964219 -122.43433962698201 (37.7427515964219, -122.434339626982)
10134 173877 2 47 2651 San Jose Ave 1 18 1 1       3x3   5997397.0 2088796.0 37.7152869722449 -122.450918658158 (37.7152869722449, -122.450918658158)
10255 112606 2 47 100X Monument Way 1 13 1 1       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076)
13314 187669 2 47 554 Valley St 1 3 1 1           6002324.0 2099197.0 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307)
16807 106757 2 47 999 Key Ave 1 2 1 1   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446)
18889 106642 2 47 4540X 17TH ST 1 9 1 1     24     5999139.0 2105833.0 37.762166086231204 -122.446122313424 (37.7621660862312, -122.446122313424)
22920 251148 2 47 625 Brotherhood Way 1 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22923 251152 2 47 625 Brotherhood Way 5 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22924 251154 2 47 625 Brotherhood Way 7 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22925 251150 2 47 625 Brotherhood Way 3 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22926 251147 2 47 113x Gladeview Way 1 13 1 1       3x3   5997915.0 2102038.0 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397)
22927 251157 2 47 625 Brotherhood Way 10 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22928 251155 2 47 625 Brotherhood Way 8 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22929 251156 2 47 625 Brotherhood Way 9 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22930 251151 2 47 625 Brotherhood Way 4 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22931 251158 2 47 625 Brotherhood Way 11 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22932 251153 2 47 625 Brotherhood Way 6 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22933 251149 2 47 625 Brotherhood Way 2 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22934 251159 2 47 625 Brotherhood Way 12 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
23418 186415 2 47 1601 Sunset Blvd 3 9 1 1     2 Width 0ft   5984728.3813 2104210.7037 37.756878233428004 -122.49584272637699 (37.756878233428, -122.495842726377)
23514 190971 2 47 800 Vermont St 11 2 1 1     42     6011272.24417 2104307.20268 37.7586620081736 -122.40405043579099 (37.7586620081736, -122.404050435791)
23551 181443 2 47 1400 Sunset Blvd 3 9 1 1     35 Width 0ft   5984892.2857 2105061.2409 37.759223169955796 -122.495338616437 (37.7592231699558, -122.495338616437)
23770 186402 2 47 1801 Sunset Blvd 69 9 1 1     99 Width 0ft   5984820.6527 2102319.266 37.7516902715465 -122.495384132242 (37.7516902715465, -122.495384132242)
23880 187141 2 47 2301 Sunset Blvd 3 9 1 1     52 Width 0ft   5984898.7676 2099479.6664 37.7438980796356 -122.494904654416 (37.7438980796356, -122.494904654416)
24024 206902 2 47 901 Monterey Blvd 4 2 1 1     6 Width 3ft   5996057.83075 2094626.65779 37.7312198182223 -122.45596865725 (37.7312198182223, -122.45596865725)
24028 186361 2 47 1801 Sunset Blvd 28 9 1 1     99 Width 0ft   5984795.4735 2102590.7965 37.752434345234 -122.495491228463 (37.752434345234, -122.495491228463)
24119 184645 2 47 3430 Moraga St 1 1 1 1     37 Width 0ft   5983573.582 2103608.0944 37.7551559377943 -122.49979184963699 (37.7551559377943, -122.499791849637)
24155 249927 2 47 358 Greenwich St 12 13 1 1     31 Width 0ft   6011132.35015 2120388.99651 37.8028110368738 -122.40566696715099 (37.8028110368738, -122.405666967151)
24212 181351 2 47 2300 Sunset Blvd 5 19 1 1     32 Width 0ft   5985090.6387 2098949.4558 37.7424534945744 -122.49420214621 (37.7424534945744, -122.49420214621)
24265 184994 2 47 2701 Sunset Blvd 20 9 1 1     52 Width 0ft   5984981.6045 2096535.6021 37.735819319769895 -122.494401253367 (37.7358193197699, -122.494401253367)
24279 138266 2 47 2600 GEARY BLVD 34 19 1 1     19 Width 0ft   5999024.6838 2113178.2607 37.7823277718518 -122.44704630425699 (37.7823277718518, -122.447046304257)
24438 118836 2 47 600 46th Ave 5 2 1 1     30 Width 3ft   5981651.25866 2111619.12831 37.77703893001029 -122.50703392298401 (37.7770389300103, -122.507033922984)
24469 186067 2 47 1901 Sunset Blvd 13 9 1 1     51 Width 0ft   5984814.1882 2102091.1256 37.751063482205 -122.495389663196 (37.751063482205, -122.495389663196)
24493 190983 2 47 2 Tulare St 20 7 1 1     15     6016115.94828 2100251.3725900003 37.7477949890666 -122.387015672733 (37.7477949890666, -122.387015672733)
24565 176109 2 47 520 Carter St 2 2 1 1     15     6005252.95246 2086362.20208 37.7090508894465 -122.42359208063299 (37.7090508894465, -122.423592080633)
24654 190986 2 47 2 Tulare St 16 7 1 1     23     6016149.69105 2100259.24355 37.747818469462 -122.38689953970601 (37.747818469462, -122.386899539706)
24694 206882 2 47 355 Parnassus Ave 10 9 1 1     24 Width 5ft   5996132.622880001 2106470.43448 37.7637441750665 -122.456566260324 (37.7637441750665, -122.456566260324)
24834 185543 2 47 2201 Sunset Blvd 27 9 1 1     46 Width 0ft   5984873.6046 2099981.069 37.7452733220295 -122.49502862542 (37.7452733220295, -122.49502862542)
25090 223699 2 47 1100 San Jose Ave 2 7 1 1     72     6004901.063490001 2096745.81285 37.737542142145706 -122.425546760699 (37.7375421421457, -122.425546760699)
25143 126422 2 47 71 MacOndray Ln 3 9 1 1     40     6008381.99212 2119124.63634 37.7991852374601 -122.415095094385 (37.7991852374601, -122.415095094385)
25247 185431 2 47 2300 Sunset Blvd 47 19 1 1     40 Width 0ft   5985098.6365 2099386.335 37.743653514796705 -122.49420668637899 (37.7436535147967, -122.494206686379)
25480 181380 2 47 1500 Sunset Blvd 13 9 1 1     20 Width 0ft   5984920.3702 2104474.5517 37.757613928882606 -122.49519822357901 (37.7576139288826, -122.495198223579)
25632 185934 2 47 2000 Sunset Blvd 77 9 1 1     25 Width 0ft   5984996.9702 2101528.251 37.74952868337 -122.494716099913 (37.74952868337, -122.494716099913)
25637 190976 2 47 800 Vermont St 25 2 1 1     18     6011280.21235 2104227.17617 37.758442718371704 -122.404017246303 (37.7584427183717, -122.404017246303)
25672 247989 2 47 130 Mullen Ave 1 7 1 1     15 Width 10ft   6009899.29934 2099821.3308900003 37.7462679959733 -122.40848229933901 (37.7462679959733, -122.408482299339)
25740 187008 2 47 2501 Sunset Blvd 27 9 1 1     99 Width 0ft   5984967.4388 2098043.05 37.739957538540295 -122.49456132318899 (37.7399575385403, -122.494561323189)
25920 205918 2 47 506 Congo St 4 9 1 1     33 Width 5ft   6000129.127169999 2095289.54923 37.7332727986918 -122.441941059826 (37.7332727986918, -122.441941059826)
Powered by Datasette · Query took 30.926ms · Data source: data.sfgov.org