sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
63703 126423 2 47 1401 The Embarcadero 21 9 1 1     47     6010525.17738 2122242.65614 37.8078667556044 -122.40789889741899 (37.8078667556044, -122.407898897419)
157404 126412 2 47 1900 Jefferson St 1 9 1 1     14 Width 4ft   6000088.69563 2121303.7240299997 37.804698887418105 -122.443949299933 (37.8046988874181, -122.443949299933)
130214 249786 2 47 161 Chestnut St 3 7 1 1     18 Width 0ft   6010943.97363 2121044.47732 37.8046002902368 -122.406365062323 (37.8046002902368, -122.406365062323)
135517 249787 2 47 173 Chestnut St 1 7 1 1     23 Width 0ft   6010924.52484 2121034.4207099997 37.8045715892836 -122.40643165799 (37.8045715892836, -122.40643165799)
184674 126416 2 47 2836 Larkin St 12 17 1 1     46     6006501.512069999 2121012.26216 37.804262323204895 -122.421736358356 (37.8042623232049, -122.421736358356)
59780 126415 2 47 2836 Larkin St 11 17 1 1     48     6006502.51226 2121001.4648 37.804232732814704 -122.421732129727 (37.8042327328147, -122.421732129727)
35115 126414 2 47 2836 Larkin St 10 17 1 1     12     6006501.05561 2120998.5397099997 37.804224619123296 -122.421736962694 (37.8042246191233, -122.421736962694)
180433 126428 2 47 1701 North Point St 4 9 1 1     6 Width 3ft   6002587.87385 2120898.67704 37.803728977572604 -122.43527166598 (37.8037289775726, -122.43527166598)
7419 97731 3 47 1150 Francisco St 9 1 1 4 2   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.803388983478605 -122.42421815984501 (37.8033889834786, -122.424218159845)
171449 249865 2 47 1497 Montgomery St 1 17 1 1     24 Width 0ft   6011350.601919999 2120707.91777 37.8036989186248 -122.404934168095 (37.8036989186248, -122.404934168095)
38454 249866 2 47 1497 Montgomery St 2 17 1 1     20 Width 0ft   6011357.005059999 2120690.5710400003 37.8036516466761 -122.404910787509 (37.8036516466761, -122.404910787509)
53440 126417 2 47 2745 Larkin St 1 9 1 1     17     6006522.5634 2120685.74713 37.8033669833519 -122.42164030356301 (37.8033669833519, -122.421640303563)
179841 249924 2 47 358 Greenwich St 8 13 1 1     12 Width 0ft   6011171.36702 2120411.09017 37.802873882370896 -122.405533505089 (37.8028738823709, -122.405533505089)
46680 249916 2 47 358 Greenwich St 1 13 1 1     20 Width 0ft   6011201.85513 2120410.11068 37.8028728976405 -122.40542793096901 (37.8028728976405, -122.405427930969)
176394 249925 2 47 358 Greenwich St 10 13 1 1     14 Width 0ft   6011155.36985 2120409.86411 37.802869621408796 -122.40558877741002 (37.8028696214088, -122.40558877741)
132547 249917 2 47 358 Greenwich St 2 13 1 1     10 Width 0ft   6011197.83082 2120409.77535 37.802871751897 -122.405441833595 (37.802871751897, -122.405441833595)
176393 249926 2 47 358 Greenwich St 11 13 1 1     24 Width 0ft   6011142.49576 2120408.96257 37.8028664261111 -122.405633265077 (37.8028664261111, -122.405633265077)
76467 249921 2 47 358 Greenwich St 6 13 1 1     10 Width 0ft   6011183.71747 2120405.40754 37.8028589698347 -122.40549036550101 (37.8028589698347, -122.405490365501)
156630 249923 2 47 358 Greenwich St 9 13 1 1     33 Width 0ft   6011163.06331 2120405.05222 37.8028568393309 -122.40556181483801 (37.8028568393309, -122.405561814838)
46521 249857 2 47 241 Greenwich St 3 7 1 1     16 Width 0ft   6011495.8307 2120401.68392 37.8028661922948 -122.404410025227 (37.8028661922948, -122.404410025227)
170870 249922 2 47 358 Greenwich St 7 13 1 1     18 Width 0ft   6011172.25119 2120397.10621 37.802835535282604 -122.405529459923 (37.8028355352826, -122.405529459923)
74458 249919 2 47 358 Greenwich St 4 13 1 1     14 Width 0ft   6011190.2403 2120395.87946 37.8028331727783 -122.405467121607 (37.8028331727783, -122.405467121607)
51446 249918 2 47 358 Greenwich St 3 13 1 1     20 Width 0ft   6011195.29362 2120394.33345 37.8028292103611 -122.405449525493 (37.8028292103611, -122.405449525493)
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)
67041 249828 2 47 339 Greenwich St 1 7 1 1     26 Width 0ft   6011201.53996 2120373.03951 37.802771091668205 -122.405426409314 (37.8027710916682, -122.405426409314)
188593 249830 2 47 339 Greenwich St 3 7 1 1     22 Width 0ft   6011191.13425 2120368.12029 37.8027570028825 -122.405462071912 (37.8027570028825, -122.405462071912)
72912 126411 2 47 3398 Pierce St 1 9 1 1     20 Width 3ft   6001324.1548 2120088.88928 37.8014336702784 -122.439586737243 (37.8014336702784, -122.439586737243)
181873 250227 2 47 312 Filbert St 7 17 1 1     17 Width 0ft   6011220.88869 2120048.61475 37.8018813824768 -122.40533659221902 (37.8018813824768, -122.405336592219)
25946 126425 3 47 1306x Montgomery St 27 3 1 2     13 Width 8ft   6011438.821769999 2120037.4711599997 37.8018629670555 -122.40458165273701 (37.8018629670555, -122.404581652737)
39759 126424 3 47 1306x Montgomery St 26 3 1 2     15 Width 8ft   6011439.456040001 2120033.94187 37.801853311934096 -122.404579209268 (37.8018533119341, -122.404579209268)
182295 249826 2 47 391 Filbert St 2 7 1 1     41 Width 0ft   6011015.83097 2120024.81975 37.8018045803872 -122.406044514263 (37.8018045803872, -122.406044514263)
140619 95331 3 47 390X Filbert St 2 3 1 2     18     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
150704 126418 2 47 2237 Hyde St 1 9 1 1     17     6007090.48557 2119992.12642 37.8014944842289 -122.41962574124099 (37.8014944842289, -122.419625741241)
60877 250194 2 47 18 Alta St 1 13 1 1     3 Width 0ft   6011773.11718 2119954.14642 37.8016528548612 -122.403418962409 (37.8016528548612, -122.403418962409)
168070 250204 2 47 206 Union St 1 7 1 1     21 Width 0ft   6011843.5346800005 2119802.5611900003 37.8012405714539 -122.403164615272 (37.8012405714539, -122.403164615272)
46935 250205 2 47 212 Union St 1 7 1 1     13 Width 0ft   6011817.68969 2119792.01106 37.8012101599872 -122.4032533082 (37.8012101599872, -122.4032533082)
156317 250196 2 47 201 Union St 2 17 1 1     18 Width 0ft   6011857.70339 2119785.90004 37.801195615236395 -122.403114412425 (37.8011956152364, -122.403114412425)
186554 250195 2 47 201 Union St 1 17 1 1     18 Width 0ft   6011875.28376 2119779.56963 37.8011792152183 -122.40305313080401 (37.8011792152183, -122.403053130804)
60552 250197 2 47 201 Union St 3 17 1 1     14 Width 0ft   6011839.72623 2119769.92251 37.8011507408769 -122.403175497057 (37.8011507408769, -122.403175497057)
46469 250199 2 47 201 Union St 5 17 1 1     15 Width 0ft   6011821.07725 2119768.34547 37.8011453692141 -122.403239919993 (37.8011453692141, -122.403239919993)
139657 117644 7 47 1111X SANSOME ST 1 13 1 1       3x30   6011937.0 2119613.0 37.8007253016149 -122.402827843034 (37.8007253016149, -122.402827843034)
52668 126427 2 47 3130 Lyon St 3 9 1 1     5 Width 7ft   5999056.00761 2119563.15995 37.799860807300895 -122.447397647786 (37.7998608073009, -122.447397647786)
39035 126426 2 47 3130 Lyon St 2 9 1 1     5 Width 7ft   5999057.94156 2119543.59601 37.7998072004939 -122.44738954670099 (37.7998072004939, -122.447389546701)
144625 13284 3 47 2576 Lombard St 1 1 1 2   10/26/1993 12:00:00 AM 26 3X3   6000068.810330001 2119230.46658 37.799005143246 -122.443869066799 (37.799005143246, -122.443869066799)
25143 126422 2 47 71 MacOndray Ln 3 9 1 1     40     6008381.99212 2119124.63634 37.7991852374601 -122.415095094385 (37.7991852374601, -122.415095094385)
84088 103516 7 47 980 Green St 1 13 1 1           6008298.0 2118971.0 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445)
70384 126420 2 47 957 Green St 1 2 1 1     18     6008389.07771 2118963.83905 37.798744126289 -122.415059188055 (37.798744126289, -122.415059188055)
28068 126421 2 47 957 Green St 2 2 1 1     21     6008400.762999999 2118955.03362 37.7987206054154 -122.415018129477 (37.7987206054154, -122.415018129477)
157577 126419 2 47 956 Vallejo St 7 7 1 1     20     6008811.64334 2118703.9569599996 37.7980542914263 -122.413578579305 (37.7980542914263, -122.413578579305)
124625 111763 9 47 2626 Vallejo St 1 13 1 1           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268)
105567 126413 2 47 2601 Vallejo St 6 9 1 1     5 Width 4ft   6001029.975 2117557.6331599997 37.7944667608931 -122.440423085162 (37.7944667608931, -122.440423085162)
7193 110906 1 47 2891 Vallejo St 2 1 1 1   05/08/2015 12:00:00 AM 3 3x10 Permit Number 775210 5999784.0596900005 2117390.4095799997 37.7939365889551 -122.44472206489799 (37.7939365889551, -122.444722064898)
42862 249675 2 47 2400 Baker St 7 7 1 1     49     5999731.49147 2117154.85585 37.7932868206735 -122.444887014927 (37.7932868206735, -122.444887014927)
137161 249710 2 47 2901 Broadway 2 7 1 1     24     5999603.39885 2116998.0274799997 37.7928489002955 -122.44531894132099 (37.7928489002955, -122.445318941321)
35815 249711 2 47 2901 Broadway 1 7 1 1     30     5999592.84448 2116997.53125 37.7928469352999 -122.44535542411501 (37.7928469352999, -122.445355424115)
187617 249716 2 47 2975 Broadway 5 13 1 1     7     5999444.23089 2116975.8695799997 37.7927789735145 -122.44586807365 (37.7927789735145, -122.44586807365)
3981 18927 3 47 2691 Sacramento St 1 1 1 2     6 3X3   6001960.28459 2115686.06098 37.7893808348161 -122.437070045665 (37.7893808348161, -122.437070045665)
8584 2988 3 47 2266X California St 3 1 1 2     35 3X3   6003528.90719 2115622.95537 37.7892965998021 -122.431638286196 (37.7892965998021, -122.431638286196)
135127 122185 2 47 2 14th Ave 5 2 1 1     67     5991491.733030001 2115080.7655 37.787118258390606 -122.473245521028 (37.7871182583906, -122.473245521028)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
180025 250698 2 47 877 El Camino Del Mar 3 2 1 1     8 Width 4ft   5985618.29441 2114950.69693 37.78641929175679 -122.49355644897601 (37.7864192917568, -122.493556448976)
176606 250697 2 47 877 El Camino Del Mar 2 2 1 1     8 Width 4ft   5985607.20317 2114948.81702 37.7864134812469 -122.493594682746 (37.7864134812469, -122.493594682746)
53358 250696 2 47 877 El Camino Del Mar 1 2 1 1     5 Width 4ft   5985597.38635 2114946.90963 37.786407669826495 -122.493628505377 (37.7864076698265, -122.493628505377)
110409 98703 6 47 7070@ 32nd Ave California St 4 25 1 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
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)
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)
38782 139327 3 47 1350x GEARY BLVD 1 11 1 2     22 Width 0ft   6005396.3086 2114138.3218 37.785325835852795 -122.425071614426 (37.7853258358528, -122.425071614426)
54250 139328 3 47 1350x GEARY BLVD 2 11 1 2     17 Width 0ft   6005318.1985 2114131.1202 37.7853016493854 -122.42534133927 (37.7853016493854, -122.42534133927)
72905 139357 3 47 1350x GEARY BLVD 6 11 1 2     19 Width 0ft   6005019.8844 2114088.1873 37.785166908017004 -122.426370358064 (37.785166908017, -122.426370358064)
6794 8396 3 47 1500 Geary Blvd 7 11 1 2   06/09/1994 12:00:00 AM 6 8   6004125.3824 2113965.9717 37.7847807304874 -122.429456338379 (37.7847807304874, -122.429456338379)
4214 8397 3 47 1500 Geary Blvd 8 11 1 2     18 8   6004036.9348 2113953.0096 37.7847401317276 -122.42976141314301 (37.7847401317276, -122.429761413143)
Powered by Datasette · Query took 9.766ms · Data source: data.sfgov.org