sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
134605 194275 2 100 1 01st St 34 23 1 1     8     6014376.659969999 2105881.88915 37.76315871732 -122.39342406806101 (37.76315871732, -122.393424068061)
26354 234378 2 100 1 Bird St 1 1 1 1     37 Width 5ft   6005998.07456 2105729.78745 37.7622720010628 -122.42239202167299 (37.7622720010628, -122.422392021673)
25380 124656 2 100 1 Presidio Ter 1 2 1 1     24 Width 7ft   5995441.43994 2115441.36584 37.7883362746058 -122.45960662195401 (37.7883362746058, -122.459606621954)
17252 24963 3 100 100 Dolores St 4 11 1 2     90 20   6004800.736959999 2107633.50365 37.7674315357679 -122.42666873508999 (37.7674315357679, -122.42666873509)
19333 24968 3 100 100 Dolores St 9 11 1 2     90 20   6004810.58196 2107534.1310400004 37.767159239034704 -122.426627605497 (37.7671592390347, -122.426627605497)
19334 24962 3 100 100 Dolores St 3 11 1 2   04/21/2005 12:00:00 AM 30 20   6004805.8872 2107667.07109 37.76752399506629 -122.42665331171999 (37.7675239950663, -122.42665331172)
19826 24965 3 100 100 Dolores St 6 11 1 2     90 20   6004804.04595 2107595.6918 37.767327900586 -122.42665459683799 (37.767327900586, -122.426654596838)
20452 24966 3 100 100 Dolores St 7 11 1 2     90 20   6004812.73188 2107584.41194 37.76729741985871 -122.426623750096 (37.7672974198587, -122.426623750096)
22009 24961 3 100 100 Dolores St 1 11 1 2   04/21/2005 12:00:00 AM 90 20   6004800.95891 2107734.51921 37.76770891277079 -122.42667516163999 (37.7677089127708, -122.42667516164)
15304 19794 3 100 100 STAIRWAY19 16 1 1 2     18 50ST            
11148 20065 3 100 100 STAIRWAY54 12 1 1 2     3 15ST            
77877 28025 1 100 100 The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014170.25601 2117873.24701 37.796072794607895 -122.39497787369301 (37.7960727946079, -122.394977873693)
78636 28030 1 100 100 The Embarcadero 10 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014322.16601 2117689.8700099997 37.795577730351205 -122.39443938464899 (37.7955777303512, -122.394439384649)
78875 27848 1 100 100 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
78913 25684 1 100 100 The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
81297 28024 1 100 100 The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014145.300009999 2117911.2250099997 37.7961756855245 -122.39506688844999 (37.7961756855245, -122.39506688845)
81526 103927 3 100 100 The Embarcadero 13 11 1 2   02/05/2001 12:00:00 AM   4x4   6014859.0 2117030.0 37.793795709183996 -122.392535650186 (37.793795709184, -122.392535650186)
82580 28021 1 100 100 The Embarcadero 1 11 1 9   02/05/2001 12:00:00 AM 24 4x4   6014080.19501 2118017.56101 37.796464038519396 -122.39529961933201 (37.7964640385194, -122.395299619332)
92971 28023 1 100 100 The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 24 4x4   6014119.25801 2117944.86201 37.7962665966149 -122.395159357042 (37.7962665966149, -122.395159357042)
94898 28032 1 100 100 The Embarcadero 12 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014349.29301 2117643.21201 37.7954511263865 -122.394342251353 (37.7954511263865, -122.394342251353)
102648 28027 1 100 100 The Embarcadero 7 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014263.57201 2117754.9750099997 37.795753235969 -122.394646693031 (37.795753235969, -122.394646693031)
104388 28031 1 100 100 The Embarcadero 11 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014334.10201 2117669.25401 37.7955217871698 -122.394396639485 (37.7955217871698, -122.394396639485)
109189 27850 1 100 100 The Embarcadero 5 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015895.51701 2112292.73501 37.7808457639334 -122.38861833648701 (37.7808457639334, -122.388618336487)
115397 28022 1 100 100 The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014106.23701 2117977.41401 37.796355252616294 -122.39520669408002 (37.7963552526163, -122.39520669408)
117445 27852 1 100 100 The Embarcadero 7 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015817.39201 2112182.05801 37.780537539741395 -122.388880882265 (37.7805375397414, -122.388880882265)
120266 27849 1 100 100 The Embarcadero 4 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015921.55801 2112354.58401 37.7810170305764 -122.388532565578 (37.7810170305764, -122.388532565578)
123608 28026 1 100 100 The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014253.80701 2117776.67601 37.795812278914 -122.39468200241699 (37.795812278914, -122.394682002417)
126124 25683 1 100 100 The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015960.62101 2112553.15201 37.781564418481004 -122.388411289639 (37.781564418481, -122.388411289639)
139779 27853 1 100 100 The Embarcadero 8 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015772.90401 2112134.31501 37.780403982219205 -122.389031454309 (37.7804039822192, -122.389031454309)
139983 27851 1 100 100 The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015857.5390099995 2112236.31101 37.7806887314792 -122.388745782008 (37.7806887314792, -122.388745782008)
142211 28029 1 100 100 The Embarcadero 9 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014304.80501 2117713.7420099997 37.7956423121436 -122.394501129585 (37.7956423121436, -122.394501129585)
144979 28028 1 100 100 The Embarcadero 8 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014289.61401 2117737.61301 37.7957070117951 -122.394555365911 (37.7957070117951, -122.394555365911)
9337 113319 1 100 100 VALENCIA ST 1 1 1 1     18 3x3   6005986.0 2109035.0 37.7713466487942 -122.42266867187 (37.7713466487942, -122.42266867187)
46040 187495 2 100 100 Walbridge St 1 7 1 1     8     6005184.36761 2086469.76682 37.709342367834395 -122.423836763664 (37.7093423678344, -122.423836763664)
48420 187504 2 100 100 Walbridge St 10 7 1 1     9     6005101.69485 2086503.71935 37.7094309267755 -122.424124907354 (37.7094309267755, -122.424124907354)
59904 187497 2 100 100 Walbridge St 3 7 1 1     6     6005151.09396 2086478.68565 37.7093649785846 -122.42395239669399 (37.7093649785846, -122.423952396694)
163407 187499 2 100 100 Walbridge St 5 7 1 1     8     6005135.10052 2086491.02363 37.7093979531098 -122.42400854947999 (37.7093979531098, -122.42400854948)
17056 25058 3 100 1000X Dolores St 1 11 1 2     90 20   6005092.48697 2102458.1018 37.753237594341996 -122.425291287561 (37.753237594342, -122.425291287561)
17722 25061 3 100 1000X Dolores St 4 11 1 2     90 20   6005097.79962 2102345.06954 37.7529275341834 -122.425264872687 (37.7529275341834, -122.425264872687)
21757 25064 3 100 1000X Dolores St 7 11 1 2     40 20   6005102.4225699995 2102227.07793 37.7526038178156 -122.425240490271 (37.7526038178156, -122.425240490271)
22227 25067 3 100 1000X Dolores St 10 11 1 2     40 20   6005110.57075 2102123.34784 37.7523194593995 -122.425204931964 (37.7523194593995, -122.425204931964)
47801 234359 3 100 1000x Dolores St 13 3 1 2     31     6005116.63925 2102018.48994 37.752031886768705 -122.42517648553302 (37.7520318867687, -122.425176485533)
27286 132113 3 100 1000x The Embarcadero 2 3 1 2     21 Width 10ft   6013330.52243 2119204.92075 37.7996825238869 -122.39797700193701 (37.7996825238869, -122.397977001937)
58367 132070 3 100 1000x The Embarcadero 1 11 1 2     23 Width 5ft   6013297.802519999 2119184.84583 37.7996255806051 -122.39808881644501 (37.7996255806051, -122.398088816445)
62709 132071 3 100 1000x The Embarcadero 3 3 1 2     23 Width 10ft   6013261.919290001 2119233.02284 37.7997558644996 -122.39821636821199 (37.7997558644996, -122.398216368212)
66065 132114 3 100 1000x The Embarcadero 4 3 1 2     20 Width 10ft   6013298.81612 2119255.09608 37.799818527453105 -122.39809024008001 (37.7998185274531, -122.39809024008)
68393 132116 3 100 1000x The Embarcadero 8 3 1 2     23 Width 10ft   6013189.6161 2119421.22304 37.800268589579204 -122.39847977871901 (37.8002685895792, -122.398479778719)
115831 132073 3 100 1000x The Embarcadero 7 3 1 2     24 Width 10ft   6013155.58738 2119398.1180000002 37.800203252927105 -122.39859590999501 (37.8002032529271, -122.398595909995)
131771 132074 3 100 1000x The Embarcadero 9 3 1 2     20 Width 10ft   6013098.86351 2119482.52775 37.800431861502396 -122.39879812525601 (37.8004318615024, -122.398798125256)
133036 132072 3 100 1000x The Embarcadero 5 3 1 2     24 Width 10ft   6013209.184309999 2119314.66631 37.799977100409 -122.39840458371201 (37.799977100409, -122.398404583712)
137882 132117 3 100 1000x The Embarcadero 10 3 1 2     17 Width 10ft   6013132.776319999 2119506.7755299998 37.800500329583 -122.398682475136 (37.800500329583, -122.398682475136)
147998 132115 3 100 1000x The Embarcadero 6 3 1 2     23 Width 10ft   6013243.85901 2119336.7003900004 37.8000395322586 -122.398286142085 (37.8000395322586, -122.398286142085)
149367 234380 2 100 1001 San Jose Ave 4 2 1 1     9 Width 3ft   6005142.82168 2096774.43039 37.7376343766353 -122.424712922782 (37.7376343766353, -122.424712922782)
176402 210907 2 100 1009 Kirkham St 1 10 1 1     32 Width 3ft   5991740.69924 2105187.8933900003 37.7599695243799 -122.47166295830499 (37.7599695243799, -122.471662958305)
157078 120819 2 100 101 20th Ave 5 1 1 1     22 Width 5ft   5989573.42956 2114582.3778 37.7856385654779 -122.47984587101999 (37.7856385654779, -122.47984587102)
43396 194272 2 100 1022 Minna St 2 4 1 1     9 Width 3ft   6007547.687530001 2109714.25342 37.7732997020571 -122.41731485230801 (37.7732997020571, -122.417314852308)
39528 194389 2 100 1031 Key Ave 4 2 1 1     36     6013123.75243 2089902.89375 37.7192140640518 -122.396637279208 (37.7192140640518, -122.396637279208)
42834 194390 2 100 1031 Key Ave 5 2 1 1     29     6013152.66051 2089880.8718700001 37.719155205216104 -122.396535811395 (37.7191552052161, -122.396535811395)
48345 194388 2 100 1031 Key Ave 3 2 1 1     40     6013107.94825 2089911.6587099999 37.7192372512804 -122.39669252276501 (37.7192372512804, -122.396692522765)
162443 194387 2 100 1031 Key Ave 2 2 1 1     31     6013093.20116 2089924.2998099998 37.7192711404238 -122.39674438396099 (37.7192711404238, -122.396744383961)
186407 194386 2 100 1031 Key Ave 1 2 1 1     32     6013080.03152 2089934.31035 37.7192978943535 -122.396790608192 (37.7192978943535, -122.396790608192)
132845 234388 2 100 1069 Dolores St 2 1 1 1     30 Width 5ft   6005149.23502 2102137.71701 37.7523610979942 -122.425072246905 (37.7523610979942, -122.425072246905)
16962 25071 3 100 1100X Dolores St 2 11 1 2     80 20   6005127.376540001 2101840.69033 37.751544296835206 -122.42512670443001 (37.7515442968352, -122.42512670443)
18230 25073 3 100 1100X Dolores St 4 11 1 2     90 20   6005132.2187 2101761.89405 37.7513282140435 -122.42510435359199 (37.7513282140435, -122.425104353592)
18432 25070 3 100 1100X Dolores St 1 11 1 2     80 20   6005125.726319999 2101888.99536 37.751676838028395 -122.425135847862 (37.7516768380284, -122.425135847862)
20762 25074 3 100 1100X Dolores St 5 11 1 2     70 20   6005132.37065 2101712.1567700002 37.751191655576 -122.425100289545 (37.751191655576, -122.425100289545)
21721 25072 3 100 1100X Dolores St 3 11 1 2     80 20   6005130.36391 2101800.2565200003 37.751433443721 -122.425113497011 (37.751433443721, -122.425113497011)
5785 25798 1 100 1100X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012871.9305 2119823.23547 37.801354716114 -122.39960734420201 (37.801354716114, -122.399607344202)
103830 27697 1 100 1100X The Embarcadero 2 11 1 9     36 10   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
25390 132077 3 100 1100x The Embarcadero 7 3 1 2     23 Width 10ft   6012714.4120000005 2120058.1365799997 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451)
32862 132075 3 100 1100x The Embarcadero 3 3 1 2     23 Width 10ft   6012816.85763 2119903.53523 37.8015721299035 -122.399803563704 (37.8015721299035, -122.399803563704)
37174 132080 3 100 1100x The Embarcadero 13 3 1 2     26 Width 10ft   6012562.54875 2120282.53748 37.802598598112 -122.40071023410101 (37.802598598112, -122.400710234101)
48115 132100 3 100 1100x The Embarcadero 15 3 1 2     24 Width 10ft   6012551.63717 2120363.68822 37.802820809805496 -122.400753698321 (37.8028208098055, -122.400753698321)
49479 132094 3 100 1100x The Embarcadero 4 3 1 2     24 Width 10ft   6012848.0944 2119927.2949200002 37.8016391096046 -122.39969713882601 (37.8016391096046, -122.399697138826)
56654 132101 3 100 1100x The Embarcadero 17 3 1 2     18 Width 10ft   6012520.61539 2120407.16114 37.802938445615 -122.40086410632 (37.802938445615, -122.40086410632)
59618 132097 3 100 1100x The Embarcadero 10 3 1 2     22 Width 10ft   6012695.81427 2120154.0888900002 37.8022533411719 -122.400240038841 (37.8022533411719, -122.400240038841)
61544 132098 3 100 1100x The Embarcadero 12 3 1 2     23 Width 10ft   6012646.4501 2120224.08688 37.802442786052396 -122.40041578348699 (37.8024427860524, -122.400415783487)
75574 132078 3 100 1100x The Embarcadero 9 3 1 2     21 Width 10ft   6012663.130340001 2120132.51785 37.8021922897941 -122.40035162582899 (37.8021922897941, -122.400351625829)
76777 132095 3 100 1100x The Embarcadero 6 3 1 2     23 Width 10ft   6012798.77066 2120004.26494 37.801847701082394 -122.39987323058901 (37.8018477010824, -122.399873230589)
129992 132099 3 100 1100x The Embarcadero 14 3 1 2     22 Width 10ft   6012592.45443 2120302.68635 37.8026555899447 -122.40060816104099 (37.8026555899447, -122.400608161041)
135157 132081 3 100 1100x The Embarcadero 16 3 1 2     20 Width 10ft   6012501.69351 2120366.8481099997 37.802826700352995 -122.400926752172 (37.802826700353, -122.400926752172)
150555 132096 3 100 1100x The Embarcadero 8 3 1 2     21 Width 10ft   6012742.85934 2120080.46122 37.8020538004962 -122.400072065282 (37.8020538004962, -122.400072065282)
164266 132076 3 100 1100x The Embarcadero 5 3 1 2     25 Width 10ft   6012766.891340001 2119978.53875 37.8017752858665 -122.399981740966 (37.8017752858665, -122.399981740966)
176286 132079 3 100 1100x The Embarcadero 11 3 1 2     21 Width 10ft   6012611.87531 2120208.19637 37.8023972264213 -122.40053431322399 (37.8023972264213, -122.400534313224)
186566 132093 3 100 1100x The Embarcadero 2 3 1 2     25 Width 10ft   6012902.31977 2119848.32419 37.8014252975988 -122.39950394556699 (37.8014252975988, -122.399503945567)
81176 27963 1 100 1101X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
105106 25746 1 100 1101X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
111083 25747 1 100 1101X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
187792 210906 2 100 1113 Kirkham St 3 10 1 1     5 Width 4ft   5991529.16752 2105177.12145 37.7599277068135 -122.47239375186301 (37.7599277068135, -122.472393751863)
33156 234362 3 100 1150x Dolores St 4 3 1 2     25     6005144.45634 2101528.47617 37.7506879938715 -122.425045428228 (37.7506879938715, -122.425045428228)
63890 234360 3 100 1150x Dolores St 2 3 1 2     21     6005142.56045 2101579.1271 37.7508269625113 -122.425055587855 (37.7508269625113, -122.425055587855)
132937 234364 3 100 1150x Dolores St 6 3 1 2     23     6005148.136969999 2101464.62312 37.7505128760752 -122.425028157637 (37.7505128760752, -122.425028157637)
151204 234363 3 100 1150x Dolores St 5 3 1 2     25     6005145.85028 2101496.26634 37.7505996318694 -122.425038316369 (37.7505996318694, -122.425038316369)
154721 234361 3 100 1150x Dolores St 3 3 1 2     27     6005142.97819 2101556.59196 37.75076510982829 -122.42505254004699 (37.7507651098283, -122.425052540047)
158301 234365 3 100 1150x Dolores St 7 3 1 2     33     6005150.81264 2101423.31762 37.7503996118641 -122.425015966416 (37.7503996118641, -122.425015966416)
151971 194274 3 100 1150x Tennessee St 17 3 1 2     28     6015578.255919999 2103421.32087 37.756469211897 -122.389096301947 (37.756469211897, -122.389096301947)
152917 194273 3 100 1150x Tennessee St 16 3 1 2     20 Width 8ft   6015573.17514 2103426.7647700002 37.7564838780418 -122.38911425333 (37.7564838780418, -122.38911425333)
100172 25080 3 100 1156 DOLORES ST 1 11 1 2     90 20   6005077.9 2101580.2 37.7508262556468 -122.425279266089 (37.7508262556468, -122.425279266089)
85336 25079 3 100 1162 DOLORES ST 1 11 1 2     80 20   6005068.3 2101554.8 37.7507559707678 -122.42531065650499 (37.7507559707678, -122.425310656505)
121975 25078 3 100 1166 DOLORES ST 1 11 1 2     80 20   6005069.8 2101528.7 37.7506843909536 -122.42530361228901 (37.7506843909536, -122.425303612289)
93699 25077 3 100 1178 DOLORES ST 1 11 1 2     80 20   6005072.5 2101478.6 37.750546980486895 -122.42529071074 (37.7505469804869, -122.42529071074)
Powered by Datasette · Query took 10.713ms · Data source: data.sfgov.org