sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
639 20004 3 102 100 STAIRWAY46 24 1 1 2     3 2            
3857 19783 3 102 100 STAIRWAY19 5 1 1 2     6 50ST            
4120 139116 2 102 1501 LAGUNA ST 1 1 1 1       Width 0ft   6004490.8408 2114272.6601 37.7856435047825 -122.42821383671101 (37.7856435047825, -122.428213836711)
6613 12417 1 102 1691 Laguna St 1 1 1 1   09/13/1989 12:00:00 AM 6 4X4   6004447.0274 2114613.1852 37.786576022340604 -122.428389697922 (37.7865760223406, -122.428389697922)
6884 19587 3 102 100 STAIRWAY4 10 1 1 2     12 60            
7112 19788 3 102 100 STAIRWAY19 10 1 1 2     12 50ST            
7362 19927 3 102 100 STAIRWAY37 7 1 1 2     3 20ST            
8265 12418 1 102 1691 Laguna St 2 1 1 1   09/13/1989 12:00:00 AM 6 4X4   6004450.1666 2114579.9986 37.7864850778881 -122.42837647083799 (37.7864850778881, -122.428376470838)
9531 19924 3 102 100 STAIRWAY37 4 1 1 2     3 20ST            
9569 19774 3 102 100 STAIRWAY17 4 1 1 2     6 20ST            
12606 19931 3 102 100 STAIRWAY37 11 1 1 2     3 20ST            
12836 20072 3 102 100 STAIRWAY55 5 1 1 2     6 45X            
13148 19582 3 102 100 STAIRWAY4 5 1 1 2     12 60            
14532 19839 3 102 100 STAIRWAY25 23 1 1 2     6 60X            
16568 20049 3 102 100 STAIRWAY52 5 1 1 2     6 10            
16936 19796 3 102 100 STAIRWAY21 1 1 1 2     3 40ST            
17381 10116 1 102 842 Guerrero St 1 1 1 1     8 3X3   6005634.91055 2104075.87142 37.7577102430435 -122.42353048064501 (37.7577102430435, -122.423530480645)
18064 4209 1 102 3929 Cesar Chavez St 1 1 1 1     6 3X3   6004325.38397 2100415.60352 37.747586001896 -122.427798564152 (37.747586001896, -122.427798564152)
21869 22856 1 102 140 Turquoise Way 1 1 1 1     20 3X3   5999949.39722 2099144.09084 37.743846215245796 -122.44283912645099 (37.7438462152458, -122.442839126451)
24109 196523 2 102 1801 Mariposa St 4 1 1 1     3 Width 3ft   6011996.40725 2106050.2030700003 37.7634883341404 -122.401668444652 (37.7634883341404, -122.401668444652)
25106 52648 1 102 542@ ANZA 08th Ave 1 1 1 1   09/24/2010 12:00:00 AM 2   Permit Number 48732 5993472.644230001 2111791.25598 37.778200659528295 -122.466152920318 (37.7782006595283, -122.466152920318)
26103 122126 2 102 109 16th Ave 2 1 1 1     2 Width 3ft   5990812.19137 2114688.82235 37.786002721616796 -122.47556793196001 (37.7860027216168, -122.47556793196)
26481 238571 2 102 1474 Noe St 2 1 1 1     6 Width 3ft   6003271.46405 2099643.8513599997 37.745407274630104 -122.431387870873 (37.7454072746301, -122.431387870873)
26589 196520 2 102 1100 Pennsylvania Ave 6 2 1 1     1     6014495.9358 2101776.59314 37.751893084516894 -122.392724321763 (37.7518930845169, -122.392724321763)
26844 238541 2 102 31 Fair Oaks St 1 1 1 1     3 Width 4ft   6005390.57049 2103524.3903200002 37.7561822103525 -122.424336286693 (37.7561822103525, -122.424336286693)
27673 65516 1 102 159 16th Ave 1 1 1 1   02/09/1990 12:00:00 AM 5   Permit Number 28402 5990823.47806 2114342.11962 37.7850514269176 -122.47550355958299 (37.7850514269176, -122.475503559583)
32949 122123 2 102 109 16th Ave 5 1 1 1     4 Width 3ft   5990814.402869999 2114634.30613 37.7858531634971 -122.475556298764 (37.7858531634971, -122.475556298764)
33550 139117 1 102 1501 LAGUNA ST 2 1 1 1     3 Width 0ft   6004494.7186 2114242.7456 37.785561586454 -122.42819828794501 (37.785561586454, -122.428198287945)
34078 238570 2 102 1474 Noe St 1 1 1 1     6 Width 3ft   6003271.44835 2099657.0265900004 37.745443449856 -122.43138886550699 (37.745443449856, -122.431388865507)
34109 213714 2 102 125 Judson Ave 2 1 1 1     6 Width 4ft   5999173.83796 2093468.34199 37.728217707656704 -122.445112858974 (37.7282177076567, -122.445112858974)
34271 196527 2 102 333 Texas St 1 4 1 1     1 Width 3ft   6013792.65149 2105531.32389 37.7621636768226 -122.395419411895 (37.7621636768226, -122.395419411895)
35989 181654 2 102 1270 31st Ave 1 1 1 1     5 Width 0ft   5986485.9791 2106605.5895 37.763556707763705 -122.489940517963 (37.7635567077637, -122.489940517963)
36853 40939 1 102 2011 Buchanan St 1 1 1 1   03/17/2000 12:00:00 AM 4   Permit Number 42024 6003842.4279 2115465.9547 37.7888832815445 -122.43054233468 (37.7888832815445, -122.43054233468)
37271 118369 2 102 55 Vandewater St 2 1 1 1     4 2x2   6009060.6253 2121300.7581 37.805198438810294 -122.41290072218399 (37.8051984388103, -122.412900722184)
37295 238548 2 102 76 Montcalm St 1 1 1 1     5 Width 3ft   6010523.51123 2100011.17861 37.7468242140742 -122.406337213897 (37.7468242140742, -122.406337213897)
37570 246644 2 102 3350 Harrison St 5 17 1 1     4     6009046.23893 2099176.02556 37.744448319452204 -122.41138650967899 (37.7444483194522, -122.411386509679)
38068 138729 2 102 1615 BAKER ST 2 1 1 1     4 Width 0ft   6000051.0937 2114639.9425 37.786399760935204 -122.443600426882 (37.7863997609352, -122.443600426882)
39114 218412 2 102 205 Castenada Ave 4 2 1 1     5 Width 0ft   5994303.242319999 2100628.09542 37.7475974107089 -122.46246968273199 (37.7475974107089, -122.462469682732)
40073 196528 2 102 400 Texas St 1 4 1 1     5 Width 3ft   6013752.07769 2105195.9474400003 37.7612405497197 -122.395536244627 (37.7612405497197, -122.395536244627)
40214 238559 2 102 358 27th St 1 1 1 1     7 Width 2ft   6004157.57388 2100161.2554200003 37.746878126628204 -122.42836071599899 (37.7468781266282, -122.428360715999)
40329 111708 2 102 463 32nd Ave 2 1 1 1     5 3x3   5985915.33595 2112785.30995 37.780491135633 -122.49236925923701 (37.780491135633, -122.492369259237)
40780 120407 2 102 647 23rd Ave 1 1 1 1     4 Width 3ft   5988776.18848 2110908.47629 37.7755047148615 -122.48233478645399 (37.7755047148615, -122.482334786454)
41135 140281 2 102 100 COLE ST 4 1 1 1     6 Width 0ft   5997882.1979 2110255.1754 37.774236399597 -122.450787953752 (37.774236399597, -122.450787953752)
41456 218233 2 102 365 Wawona St 1 4 1 1     6 Width 2ft   5991919.11048 2097078.05412 37.737712321755 -122.470455286603 (37.737712321755, -122.470455286603)
42239 238567 2 102 638 27th St 1 1 1 1     5 Width 2ft   6002382.79124 2100064.9515299997 37.7465131116006 -122.434490857486 (37.7465131116006, -122.434490857486)
42348 238550 2 102 263 29th St 1 1 1 1     5 Width 2ft   6004819.40708 2098979.89063 37.7436717980264 -122.425988074184 (37.7436717980264, -122.425988074184)
42461 138764 2 102 1508 Baker St 3 1 1 1     5 Width 0ft   6000169.3138 2114165.2585 37.7851031433792 -122.44315731203301 (37.7851031433792, -122.443157312033)
42874 138762 2 102 1508 Baker St 1 1 1 1     6 Width 0ft   6000175.6546 2114135.1395 37.7850208059477 -122.443133211033 (37.7850208059477, -122.443133211033)
44368 181828 2 102 2311 31st Ave 2 2 1 1     1 Width 0ft   5986682.779 2099487.7451 37.744024532877496 -122.488736632211 (37.7440245328775, -122.488736632211)
44776 122127 2 102 109 16th Ave 1 1 1 1     3 Width 3ft   5990810.49016 2114703.81512 37.7860437889569 -122.47557491276699 (37.7860437889569, -122.475574912767)
46036 238574 2 102 290 States St 5 1 1 1     3 Width 3ft   6000331.0714 2106844.5013099997 37.7650114214522 -122.442072013715 (37.7650114214522, -122.442072013715)
47066 124234 2 102 1 Paramount Ter 2 1 1 1     4 Width 2ft   5996623.51945 2111013.40479 37.7762461678144 -122.455196729351 (37.7762461678144, -122.455196729351)
47508 238557 2 102 4014 26th St 3 1 1 1     4 Width 5ft   6003783.51976 2100724.3526 37.7484030872306 -122.429694315247 (37.7484030872306, -122.429694315247)
48410 110661 2 102 650 Steiner St 2 1 1 1     3 3x3   6003108.682999999 2110599.6041 37.775479911610205 -122.432733221791 (37.7754799116102, -122.432733221791)
48835 246649 2 102 3350 Harrison St 10 17 1 1     5     6009030.81997 2099159.0230900003 37.744400769587 -122.411438624517 (37.744400769587, -122.411438624517)
49097 136031 2 102 1635 Chestnut St 2 1 1 1     6 Width 2ft   6004020.9595 2120061.85215 37.8015125516123 -122.43025265844601 (37.8015125516123, -122.430252658446)
49306 238560 2 102 3329 18th St 1 1 1 1     1 Width 2ft   6007360.6242 2105555.31734 37.7618697145455 -122.417667096959 (37.7618697145455, -122.417667096959)
50786 185746 2 102 2195 28th Ave 2 1 1 1     4 Width 0ft   5987582.8307 2100358.089 37.746466749146705 -122.485688359332 (37.7464667491467, -122.485688359332)
51171 238569 2 102 1623 Noe St 2 1 1 1     6 Width 3ft   6003376.357030001 2098716.75556 37.7428676287329 -122.430959013851 (37.7428676287329, -122.430959013851)
51617 238566 2 102 621 27th St 1 1 1 1     4 Width 2ft   6002444.337069999 2100031.09777 37.7464236506235 -122.43427561915001 (37.7464236506235, -122.43427561915)
51635 185053 2 102 2719 41st Ave 1 1 1 1     3 Width 0ft   5983670.2351 2096626.4658 37.735991973866 -122.498941812175 (37.735991973866, -122.498941812175)
51760 246643 2 102 3350 Harrison St 4 17 1 1     7     6009035.26115 2099177.7888599997 37.7444525453606 -122.41142459327601 (37.7444525453606, -122.411424593276)
52859 137918 2 102 1914 WEBSTER ST 1 1 1 1     4 Width 0ft   6003425.977000001 2115322.684 37.7884662960967 -122.43197296209499 (37.7884662960967, -122.431972962095)
53364 142051 2 102 32 ATALAYA TER 2 1 1 1     5 Width 0ft   5998845.9761 2110971.5149 37.7762584069 -122.447505657858 (37.7762584069, -122.447505657858)
53624 213716 2 102 252 Lobos St 2 1 1 1     1 Width 3ft   5994453.52606 2088731.32317 37.7149404380182 -122.46108783483601 (37.7149404380182, -122.461087834836)
53745 35587 1 102 3600 Fillmore St 1 1 1 1   03/25/1998 12:00:00 AM 5   Permit Number 38951 6002200.57544 2120594.56512 37.8028719650354 -122.436590150328 (37.8028719650354, -122.436590150328)
54332 136034 2 102 1798 Bay St 4 1 1 1     4 Width 3ft   6002280.33301 2120565.85402 37.8027976639548 -122.43631209254801 (37.8027976639548, -122.436312092548)
54491 182113 2 102 2462 27th Ave 1 2 1 1     4 Width 0ft   5988005.6699 2098548.963 37.7415239963656 -122.484093600478 (37.7415239963656, -122.484093600478)
55281 246183 2 102 789 Buena Vista Ave West 1 1 1 1     8 Width 0ft   5999949.17 2108240.0487 37.7688214743495 -122.443493165297 (37.7688214743495, -122.443493165297)
55844 182092 2 102 2691 Ulloa St 1 1 1 1     3 Width 0ft   5987764.3751 2098252.1671 37.7406950216778 -122.48490613622101 (37.7406950216778, -122.484906136221)
55902 141596 2 102 1457 FULTON ST 2 1 1 1     5 Width 0ft   6000792.6568 2111003.6819 37.776457784318296 -122.440773879837 (37.7764577843183, -122.440773879837)
57874 53440 1 102 62 Palm Ave 1 1 1 1   10/24/1969 12:00:00 AM 5   Permit Number 6341 5995913.45443 2114081.21839 37.784628805515794 -122.45787507433701 (37.7846288055158, -122.457875074337)
61171 122124 2 102 109 16th Ave 4 1 1 1     2 Width 3ft   5990813.29617 2114656.20657 37.7859132318364 -122.47556172729601 (37.7859132318364, -122.475561727296)
62192 238561 2 102 84 Richland Ave 1 9 1 1     3 Width 2ft   6005027.1753 2096150.27417 37.735914051792896 -122.42506837081001 (37.7359140517929, -122.42506837081)
63912 196532 2 102 1317 19th St 1 4 1 1     5 Width 6ft   6013654.12142 2105210.0397200002 37.761273794973 -122.395876023757 (37.761273794973, -122.395876023757)
64692 120351 2 102 2122 Lake St 5 2 1 1     2 Width 6ft   5988809.84875 2114710.37 37.7859456052715 -122.482496990767 (37.7859456052715, -122.482496990767)
65056 196533 2 102 1301 19th St 1 4 1 1     5 Width 4ft   6013698.905669999 2105212.75779 37.7612837495574 -122.395721323302 (37.7612837495574, -122.395721323302)
65771 213712 2 102 611 Joost Ave 7 9 1 1     16     5998085.35885 2094959.9785200001 37.7322512012233 -122.448983163356 (37.7322512012233, -122.448983163356)
65988 57628 1 102 534 17th Ave 1 1 1 1   05/09/1990 12:00:00 AM 7   Permit Number 28866 5990653.097709999 2111727.01603 37.7778611992683 -122.475901966903 (37.7778611992683, -122.475901966903)
67945 123858 2 102 346 Lake St 1 1 1 1     4 Width 3ft   5994396.826309999 2114914.43525 37.7868293438726 -122.463182538439 (37.7868293438726, -122.463182538439)
69424 140279 2 102 100 COLE ST 1 1 1 1     5 Width 0ft   5997820.131 2110246.9364 37.7742102243098 -122.451002059087 (37.7742102243098, -122.451002059087)
69911 123859 2 102 346 Lake St 2 1 1 1     3 Width 3ft   5994390.43638 2114914.64585 37.7868295540161 -122.463204661228 (37.7868295540161, -122.463204661228)
70655 123321 2 102 678 05th Ave 2 1 1 1     7 Width 3ft   5994436.02989 2110905.4473599996 37.7758240001959 -122.462755965315 (37.7758240001959, -122.462755965315)
71754 238573 2 102 414 Collingwood St 3 9 1 1     5     6002098.58859 2103426.99001 37.755728332420794 -122.435714094642 (37.7557283324208, -122.435714094642)
71928 32263 1 102 1027 Diamond St 1 1 1 1   09/05/1997 12:00:00 AM 6   Permit Number 38508 6001961.80669 2101044.74865 37.7491794962361 -122.436016672442 (37.7491794962361, -122.436016672442)
72171 120349 2 102 2122 Lake St 3 2 1 1     1 Width 6ft   5988820.20378 2114710.2762700003 37.785945950300295 -122.48246115875799 (37.7859459503003, -122.482461158758)
72430 246645 2 102 3350 Harrison St 6 17 1 1     5     6009048.821140001 2099170.00785 37.7444319409756 -122.411377155852 (37.7444319409756, -122.411377155852)
72911 182859 2 102 1830 30th Ave 1 1 1 1     4 Width 0ft   5986931.5262 2102786.1611 37.7530956091735 -122.48811885646299 (37.7530956091735, -122.488118856463)
73399 185745 2 102 2195 28th Ave 1 1 1 1     3 Width 0ft   5987583.2114 2100377.5043 37.746520080568104 -122.485688467617 (37.7465200805681, -122.485688467617)
73862 181961 2 102 2468 28th Ave 1 1 1 1     2 Width 0ft   5987695.3371 2098486.355 37.741334018551996 -122.48516201907101 (37.741334018552, -122.485162019071)
75324 122125 2 102 109 16th Ave 3 1 1 1     2 Width 3ft   5990812.11385 2114674.53706 37.785963493705104 -122.475567156694 (37.7859634937051, -122.475567156694)
76415 185737 2 102 2134 32nd Ave 1 1 1 1     2 Width 0ft   5986377.6988 2100714.0842 37.7473739221204 -122.489881691592 (37.7473739221204, -122.489881691592)
79516 45755 1 102 27 Liberty St 2 1 1 1   10/12/2001 12:00:00 AM     Permit Number 44402 6006135.85394887 2104023.0641993 37.757593509181206 -122.421794258753 (37.7575935091812, -122.421794258753)
79842 13239 3 102 2335X Lombard St 1 1 1 2     3 3X3   6001220.6637699995 2119285.5724400003 37.799222084037396 -122.439887231455 (37.7992220840374, -122.439887231455)
81300 56269 1 102 27 Liberty St 1 1 1 1   10/12/2001 12:00:00 AM     Permit Number 44402 6006135.85394887 2104023.0641993 37.757593509181206 -122.421794258753 (37.7575935091812, -122.421794258753)
81355 85264 1 102 3000 Ocean Ave 3 1 1 1   07/24/2007 12:00:00 AM     Permit Number 49557 5989530.4 2095609.1 37.73354054474329 -122.478606721292 (37.7335405447433, -122.478606721292)
83360 51865 1 102 141 Alpine Ter 1 1 1 1   07/15/2005 12:00:00 AM     Permit Number 48086 6001731.90100781 2108013.17914536 37.768300053668206 -122.43731059058001 (37.7683000536682, -122.43731059058)
83673 44322 1 102 3101 Mission St 4 1 1 1   03/02/2001 12:00:00 AM     Permit Number 43712 6007112.977014599 2100542.34949089 37.7480913155606 -122.418168196056 (37.7480913155606, -122.418168196056)
84815 51422 1 102 655 05th St 1 1 1 1   06/30/2009 12:00:00 AM   3x3 Permit Number 52282 6013199.59186321 2110555.37408537 37.7759255920049 -122.397823019146 (37.7759255920049, -122.397823019146)
85015 63672 1 102 370 27th St 1 1 1 1   04/15/2015 12:00:00 AM 3   Permit Number 24323 6004106.96627638 2100160.80457488 37.7468740249128 -122.42853568027901 (37.7468740249128, -122.428535680279)
89647 424 1 102 1901X Lake St 2 1 1 1     12 3X3   5989549.9462 2114680.6916799997 37.7859071433722 -122.479934312872 (37.7859071433722, -122.479934312872)
Powered by Datasette · Query took 4.545ms · Data source: data.sfgov.org