sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
37458 246770 2 190 99 Waltham St 3 17 1 1     9     6009309.01668 2098932.20278 37.7437935707282 -122.410460661231 (37.7437935707282, -122.410460661231)
64704 191708 2 190 979 Le Conte Ave 1 2 1 1     18     6013251.209530001 2089459.918 37.7180048338374 -122.396165676526 (37.7180048338374, -122.396165676526)
17577 5550 1 190 951 Dolores St 2 1 1 1   07/27/1998 12:00:00 AM 18 6   6005117.32575 2102805.17707 37.7541919854752 -122.425230085106 (37.7541919854752, -122.425230085106)
64747 191695 3 190 950x Kansas St 4 3 1 2     4     6011603.94241 2103847.92507 37.7574194607598 -122.40287096412901 (37.7574194607598, -122.402870964129)
33648 224127 2 190 950 Corbett Ave 1 1 1 1     9 Width 3ft   5999802.0318599995 2102082.0449599996 37.7519047262434 -122.443559684852 (37.7519047262434, -122.443559684852)
167274 126570 2 190 94 MacOndray Ln 1 9 1 1     7     6008053.53116 2119101.30283 37.7991027057905 -122.41623003160299 (37.7991027057905, -122.416230031603)
80361 115303 1 190 916 Ortega St 1 1 1 1   01/25/2016 12:00:00 AM   4x4 Permit Number 775645 5991143.3 2102523.7 37.7526197703983 -122.473534716603 (37.7526197703983, -122.473534716603)
100949 121598 1 190 916 Ortega St 2 1 1 1       4x4   5991143.3 2102523.7 37.7526197703983 -122.473534716603 (37.7526197703983, -122.473534716603)
157462 207708 2 190 916 Ortega St 1 9 1 1     2 Width 1ft   5991151.901959999 2102512.9309 37.7525906994144 -122.473504184373 (37.7525906994144, -122.473504184373)
167474 207709 2 190 916 Ortega St 2 9 1 1     2 Width 1ft   5991129.27817 2102510.74063 37.752583375332605 -122.47358226082 (37.7525833753326, -122.47358226082)
36817 176286 2 190 901 Delano Ave 7 9 1 1     6 Width 6ft   5998666.60141 2089601.1299700001 37.7175702751322 -122.446588269645 (37.7175702751322, -122.446588269645)
67780 191690 3 190 900x Carolina St 22 3 1 2     2     6012468.62754 2103498.74867 37.756508943061206 -122.39985600137399 (37.7565089430612, -122.399856001374)
65151 176278 2 190 87 Seneca Ave 1 1 1 1     1 Width 1ft   6000216.84897 2089896.4695599999 37.7184696403425 -122.441250964156 (37.7184696403425, -122.441250964156)
180825 224130 2 190 840 Castro St 2 9 1 1     18     6002416.06064 2103301.09689 37.7554006877977 -122.434607174889 (37.7554006877977, -122.434607174889)
143567 111509 3 190 800x BOSWORTH ST 4 7 1 2     4     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
75558 191687 2 190 800 19th St 1 9 1 1     7 Width 10ft   6015123.17396 2105339.16037 37.7617099499859 -122.390804173874 (37.7617099499859, -122.390804173874)
170332 191688 2 190 800 19th St 18 9 1 1     6 Width 10ft   6014977.94549 2105331.22601 37.761680105066105 -122.39130591015 (37.7616801050661, -122.39130591015)
45069 126561 2 190 8 Codman Pl 2 13 1 1     7     6009832.93804 2117260.0663900003 37.7941470150322 -122.40994260678998 (37.7941470150322, -122.40994260679)
184764 126562 2 190 8 Codman Pl 1 13 1 1     9     6009829.32931 2117256.5326099996 37.7941371098806 -122.40995484385901 (37.7941371098806, -122.409954843859)
186390 62603 1 190 792 37th Ave 1 1 1 1 1 02/22/1986 12:00:00 AM 6   Permit Number 22911 5984491.42084 2110500.08946 37.7741332293959 -122.497126446837 (37.7741332293959, -122.497126446837)
37671 176274 2 190 775 London St 1 2 1 1     6     6000713.865119999 2089358.3764799999 37.7170204575094 -122.439494437135 (37.7170204575094, -122.439494437135)
177554 191692 2 190 764 De Haro St 4 9 1 1     9     6012093.5937 2104845.22166 37.7601851458373 -122.401247624904 (37.7601851458373, -122.401247624904)
168654 207720 2 190 750 Grafton Ave 3 1 1 1     1 Width 3ft   5994515.7556300005 2090598.91337 37.7200719768186 -122.46100802721901 (37.7200719768186, -122.461008027219)
27037 207730 2 190 740 Foerster St 1 9 1 1     16 Width 3ft   5998158.00142 2095945.9651099998 37.7349626400957 -122.44880301654 (37.7349626400957, -122.44880301654)
168183 118733 2 190 706 44th Ave 1 1 1 1     7 Width 3ft   5982303.905590001 2110925.66237 37.7751732905824 -122.504724857451 (37.7751732905824, -122.504724857451)
135288 246764 2 190 70 Waltham St 8 7 1 1     8     6009279.96949 2098891.64841 37.7436805888792 -122.410558236772 (37.7436805888792, -122.410558236772)
55093 202013 2 190 7 Wheat St 2 4 1 1     3 Width 3ft   6012149.42791 2091374.5561400002 37.723200675946394 -122.40010846893601 (37.7232006759464, -122.400108468936)
71579 248210 2 190 69 Fair Ave 1 9 1 1     5 Width 6ft   6007064.668 2099422.3589 37.7450133544796 -122.418255851634 (37.7450133544796, -122.418255851634)
79512 804 3 190 680X 39th Ave 2 11 1 2     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033)
153224 176279 2 190 671 London St 2 2 1 1     7     6001065.40936 2089903.8077599998 37.7185380904529 -122.43831837391001 (37.7185380904529, -122.43831837391)
26210 118831 2 190 662 46th Ave 1 2 1 1     3 Width 3ft   5981671.941000001 2111218.67307 37.775940615740105 -122.50693266579799 (37.7759406157401, -122.506932665798)
158994 207710 2 190 641 Moraga St 1 1 1 1     3 Width 3ft   5992286.81518 2103851.81856 37.7563325940936 -122.46967695664 (37.7563325940936, -122.46967695664)
16066 22498 1 190 6404 03rd St 1 1 1 1   02/20/2003 12:00:00 AM 3 3X3   6013069.4059 2090221.21293 37.720085079934705 -122.39684744087799 (37.7200850799347, -122.396847440878)
160633 176276 2 190 62 Tomaso Ct 7 7 1 1     12 Width 8ft   6009192.32266 2086308.3659400002 37.7091246419674 -122.40997318013201 (37.7091246419674, -122.409973180132)
182683 191698 2 190 602 Arthur Ave 35 7 1 1     2     6015659.044530001 2099869.60737 37.7467214305684 -122.38856899259 (37.7467214305684, -122.38856899259)
148462 176280 2 190 600 Blanken Ave 2 9 1 1     5 Width 5ft   6013180.81524 2086857.6738099998 37.7108556687339 -122.39622672069599 (37.7108556687339, -122.396226720696)
177778 176281 2 190 600 Blanken Ave 3 9 1 1     3 Width 5ft   6013188.37125 2086854.32403 37.710846891333105 -122.39620037057101 (37.7108468913331, -122.396200370571)
23535 207712 2 190 579 Hearst Ave 1 9 1 1     7     5997579.44084 2094367.86788 37.730596459453395 -122.450689553205 (37.7305964594534, -122.450689553205)
138223 57922 1 190 539 Brunswick St 1 1 1 1   06/24/1977 12:00:00 AM 5   Permit Number 16880 5999313.15008 2086900.5185900002 37.7101919177852 -122.444159502961 (37.7101919177852, -122.444159502961)
172227 120404 2 190 527 23rd Ave 1 1 1 1     5 Width 3ft   5988748.3356 2111702.11927 37.777682216959704 -122.482489301184 (37.7776822169597, -122.482489301184)
185039 224123 2 190 523 Powhattan Ave 1 2 1 1     7     6008526.38321 2098121.4064599997 37.7415233967761 -122.413109512687 (37.7415233967761, -122.413109512687)
57409 176288 2 190 51 Tulane St 1 1 1 1     1 Width 2ft   6007278.5163199995 2093753.93468 37.7294611462914 -122.41711482421199 (37.7294611462914, -122.417114824212)
172056 207733 2 190 500 Joost Ave 3 9 1 1     4     5998757.70005 2094996.74516 37.732390582643205 -122.446661380942 (37.7323905826432, -122.446661380942)
141580 109627 2 190 500 CIRCULAR AVE 1 5 1 1       3x3   5999334.0 2093430.0 37.728121569817 -122.444556419888 (37.728121569817, -122.444556419888)
184746 191699 2 190 50 Quint St 4 7 1 1     4 Width 6ft   6015737.97927 2099766.7157099997 37.7464432855229 -122.388288861864 (37.7464432855229, -122.388288861864)
37182 143060 2 190 444 GREENWICH ST 1 1 1 1     6 Width 0ft   6010718.0238 2120346.7181 37.80267177317779 -122.407097773383 (37.8026717731778, -122.407097773383)
122151 207726 2 190 416 Ralston St 2 9 1 1     15 Width 10ft   5992237.92359 2090619.0138400001 37.719995829436 -122.468883110676 (37.719995829436, -122.468883110676)
184788 224119 2 190 410 Valley St 2 1 1 1     9 Width 2ft   6003252.6682 2099235.68131 37.744285469291896 -122.43142373132099 (37.7442854692919, -122.431423731321)
68300 224116 2 190 400 Prospect Ave 15 9 1 1     7     6006205.79839 2097605.42741 37.7399760871276 -122.421096686769 (37.7399760871276, -122.421096686769)
175044 207732 2 190 400 Congo St 2 9 1 1     19 Width 10ft   6000124.6238 2095012.3046900001 37.7325112932663 -122.441936736802 (37.7325112932663, -122.441936736802)
64078 247873 2 190 388 Mayflower St 1 17 1 1     9     6009888.01932 2098399.59712 37.7423635938187 -122.40842103750299 (37.7423635938187, -122.408421037503)
182532 247879 2 190 388 Mayflower St 8 17 1 1     3     6009924.148030001 2098382.32436 37.7423181897436 -122.408294896795 (37.7423181897436, -122.408294896795)
57318 218344 2 190 385 Castenada Ave 4 2 1 1     7 Width 0ft   5993369.339269999 2100022.3312 37.745880311731 -122.46565503467501 (37.745880311731, -122.465655034675)
179929 207728 2 190 3802 19th Ave 1 9 1 1     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.47466105158199 (37.7196901687566, -122.474661051582)
29285 207725 2 190 380 Ralston St 2 9 1 1     3 Width 6ft   5992234.508719999 2090438.5826599998 37.7195002121526 -122.468881791362 (37.7195002121526, -122.468881791362)
69216 207727 2 190 378 Victoria St 2 9 1 1     4 Width 6ft   5993265.77465 2089711.0849799998 37.717562206406 -122.46526429632601 (37.717562206406, -122.465264296326)
70263 48553 1 190 378 18th Ave 1 1 1 1   08/22/2002 12:00:00 AM 3   Permit Number 45869 5990302.44703 2112853.20794 37.780933073312504 -122.477197298017 (37.7809330733125, -122.477197298017)
73148 183678 2 190 3623 Irving St 2 1 1 1     5 Width 0ft   5984470.6439 2106306.3709 37.7626172515097 -122.49688873282601 (37.7626172515097, -122.496888732826)
29901 191709 2 190 3535 Jennings St 1 2 1 1     9     6013020.366769999 2089365.2626599998 37.717732082047895 -122.39695697201 (37.7177320820479, -122.39695697201)
77276 176283 2 190 35 Tomaso Ct 9 17 1 1     8 Width 3ft   6009206.42472 2086339.2337599997 37.7092101890802 -122.40992661863999 (37.7092101890802, -122.40992661864)
115840 176282 2 190 35 Tomaso Ct 8 17 1 1     3 Width 3ft   6009202.48899 2086331.0577900002 37.709187518951296 -122.40993964441401 (37.7091875189513, -122.409939644414)
162191 123640 2 190 345 Arguello Blvd 7 9 1 1     7 Width 6ft   5995501.56716 2113883.85045 37.784063214039605 -122.459285759007 (37.7840632140396, -122.459285759007)
166383 176290 2 190 324 Naylor St 1 1 1 1     8 Width 2ft   6002773.326830001 2086530.28935 37.7093721434675 -122.43217402313101 (37.7093721434675, -122.432174023131)
49466 224126 2 190 3213 21st St 2 1 1 1     2 Width 3ft   6006857.14128 2103777.70396 37.7569604557817 -122.41928234412902 (37.7569604557817, -122.419282344129)
161284 207731 2 190 32 Malta Dr 19 2 1 1     8 Width 3ft   5999573.254930001 2096045.34694 37.735316349769704 -122.443917140176 (37.7353163497697, -122.443917140176)
154658 207718 2 190 315 Faxon Ave 1 1 1 1     3 Width 3ft   5994723.84306 2090686.3460799998 37.7203240181088 -122.46029507616998 (37.7203240181088, -122.46029507617)
186212 200198 2 190 3125 Jennings St 2 2 1 1     1 Width 0ft   6013701.6232 2090281.2208 37.720285019418505 -122.394666263771 (37.7202850194185, -122.394666263771)
157517 224132 2 190 310 Liberty St 26 2 1 1     9 Width 3ft   6004003.018680001 2103934.91108 37.7572309538551 -122.42916418288401 (37.7572309538551, -122.429164182884)
66405 249910 2 190 308 Greenwich St 2 7 1 1     10 Width 0ft   6011272.31007 2120413.3018099996 37.8028855987512 -122.40518434418699 (37.8028855987512, -122.405184344187)
153779 207734 2 190 301 Joost Ave 4 9 1 1     8 Width 10ft   6000042.84201 2094939.4846400002 37.7323066857905 -122.442214249597 (37.7323066857905, -122.442214249597)
35482 207723 2 190 301 Byxbee St 1 9 1 1     5 Width 10ft   5991929.884269999 2090544.1507700002 37.719772472009204 -122.469942439216 (37.7197724720092, -122.469942439216)
129729 207722 2 190 300 Louisburg St 1 4 1 1     8 Width 3ft   5997412.90563 2090249.0512400002 37.7192776245304 -122.45096839786801 (37.7192776245304, -122.450968397868)
35128 249903 2 190 300 Greenwich St 4 7 1 1     17 Width 0ft   6011307.54061 2120412.72536 37.8028859854681 -122.40506238711399 (37.8028859854681, -122.405062387114)
35240 207714 2 190 298 Staples Ave 11 9 1 1     12     5998133.74364 2093826.5868 37.7291419427263 -122.448734282271 (37.7291419427263, -122.448734282271)
25968 249846 2 190 289 Greenwich St 3 17 1 1     14 Width 0ft   6011427.16735 2120382.55668 37.8028098362532 -122.40464628970601 (37.8028098362532, -122.404646289706)
165907 126567 2 190 2843 Larkin St 4 9 1 1     3 Width 5ft   6006455.5801099995 2121070.56705 37.8044198232789 -122.42189945398998 (37.8044198232789, -122.42189945399)
23748 224117 2 190 2818 23rd St 2 1 1 1     7 Width 4ft   6009831.98095 2102814.76339 37.754483528604396 -122.40892624516701 (37.7544835286044, -122.408926245167)
25243 126568 2 190 2745 Larkin St 4 9 1 1     4     6006520.94056 2120654.06544 37.8032799020007 -122.421643667929 (37.8032799020007, -122.421643667929)
163114 126569 2 190 2745 Larkin St 5 9 1 1     8     6006516.40415 2120646.68987 37.8032593947653 -122.42165884218599 (37.8032593947653, -122.421658842186)
172510 224129 2 190 26 Portola Dr 1 1 1 1     9 Width 3ft   5999702.07185 2101445.78437 37.7501520078164 -122.44385965101499 (37.7501520078164, -122.443859651015)
63802 183573 2 190 2587 26th Ave 1 1 1 1     4 Width 0ft   5988295.3826 2097727.4025 37.7392850696685 -122.483031684036 (37.7392850696685, -122.483031684036)
21420 7445 1 190 2548 Folsom St 1 1 1 1     30 3X3   6008209.4393 2103591.6656299997 37.7565257046152 -122.41459240931201 (37.7565257046152, -122.414592409312)
172703 176284 2 190 251 De Long St 2 2 1 1     4 Width 10ft   5993742.60383 2086796.45358 37.7095868089467 -122.46340473574101 (37.7095868089467, -122.463404735741)
160122 181986 2 190 2475 34th Ave 2 1 1 1     10 Width 0ft   5985788.161 2098383.3055 37.7409397902725 -122.491748687988 (37.7409397902725, -122.491748687988)
154589 201358 2 190 245 Kalmanovitz St 1 2 1 1     7 Width 2ft   6013008.61874 2092664.0279400002 37.726789172374794 -122.39722877051001 (37.7267891723748, -122.39722877051)
172414 249620 2 190 2400 Golden Gate Ave 1 9 1 1     1 Width 7ft   5997953.57215 2111367.44178 37.7772944806811 -122.45062126495199 (37.7772944806811, -122.450621264952)
2765 173854 2 190 240 Missouri St 1 1 1 1       3x3   6013446.0 2105960.0 37.763321440581 -122.396648407729 (37.763321440581, -122.396648407729)
72590 249863 2 190 233 Greenwich St 4 7 1 1     6 Width 0ft   6011630.0308300005 2120434.01589 37.8029624665125 -122.40394789778799 (37.8029624665125, -122.403947897788)
56447 191691 2 190 2301 19th St 2 9 1 1     7     6010894.94565 2105057.58809 37.7607013108401 -122.405408158461 (37.7607013108401, -122.405408158461)
34978 249883 2 190 230 Greenwich St 19 13 1 1     14 Width 0ft   6011507.08304 2120427.1107900003 37.802936637067496 -122.40437287690901 (37.8029366370675, -122.404372876909)
133186 249880 2 190 230 Greenwich St 16 13 1 1     11 Width 0ft   6011523.78476 2120446.01272 37.8029894704488 -122.404316411196 (37.8029894704488, -122.404316411196)
158045 249890 2 190 230 Greenwich St 26 13 1 1     11 Width 0ft   6011458.55673 2120431.8571900004 37.8029469576839 -122.40454113827101 (37.8029469576839, -122.404541138271)
158863 176275 2 190 23 Byron Ct 1 1 1 1     5 Width 3ft   5999165.787269999 2086612.0753799998 37.7093915094837 -122.444648098339 (37.7093915094837, -122.444648098339)
174539 207721 2 190 228 Montana St 1 10 1 1     5     5994631.9391 2089350.3088 37.7166502911674 -122.460515994629 (37.7166502911674, -122.460515994629)
177760 184363 2 190 2251 47th Ave 1 2 1 1     3 Width 0ft   5981706.71 2099767.9271 37.7445021893581 -122.50596322728998 (37.7445021893581, -122.50596322729)
180758 191694 2 190 2250 25th St 1 1 1 1     8 Width 2ft   6012110.050319999 2101893.7239200003 37.7520818989832 -122.400983328513 (37.7520818989832, -122.400983328513)
158587 249981 2 190 224 Filbert St 2 7 1 1     9 Width 0ft   6011659.45074 2120118.51197 37.8020978133144 -122.403823874987 (37.8020978133144, -122.403823874987)
50631 191693 2 190 2212 25th St 4 1 1 1     6 Width 3ft   6012143.16846 2101895.7398 37.752089281506706 -122.400868941954 (37.7520892815067, -122.400868941954)
135662 191707 2 190 2187 Revere Ave 1 9 1 1     12     6011937.92175 2096699.9343299998 37.7378112633764 -122.401213644004 (37.7378112633764, -122.401213644004)
24799 120350 2 190 2122 Lake St 4 2 1 1     3 Width 6ft   5988813.63616 2114710.28976 37.7859456052821 -122.482483881641 (37.7859456052821, -122.482483881641)
32095 224121 2 190 211 Ogden Ave 3 2 1 1     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452)
Powered by Datasette · Query took 2.427ms · Data source: data.sfgov.org