sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2713 109887 2 190 1024 Pacific Ave 1 1 1 1     10     6009193.94635 2118049.36414 37.796278400188704 -122.412209406439 (37.7962784001887, -122.412209406439)
23535 207712 2 190 579 Hearst Ave 1 9 1 1     7     5997579.44084 2094367.86788 37.730596459453395 -122.450689553205 (37.7305964594534, -122.450689553205)
25243 126568 2 190 2745 Larkin St 4 9 1 1     4     6006520.94056 2120654.06544 37.8032799020007 -122.421643667929 (37.8032799020007, -122.421643667929)
29901 191709 2 190 3535 Jennings St 1 2 1 1     9     6013020.366769999 2089365.2626599998 37.717732082047895 -122.39695697201 (37.7177320820479, -122.39695697201)
34441 191696 2 190 1700 22nd St 3 7 1 1     7     6012930.9536 2103804.38992 37.7573739307682 -122.398278546439 (37.7573739307682, -122.398278546439)
34794 224120 2 190 1350 Noe St 6 9 1 1     8     6003219.3903 2100351.64414 37.7473477571063 -122.431618456154 (37.7473477571063, -122.431618456154)
35240 207714 2 190 298 Staples Ave 11 9 1 1     12     5998133.74364 2093826.5868 37.7291419427263 -122.448734282271 (37.7291419427263, -122.448734282271)
36917 191685 2 190 1301 Minnesota St 13 7 1 1     4     6015385.022890001 2102351.0583099998 37.7535197845136 -122.38968982661801 (37.7535197845136, -122.389689826618)
37458 246770 2 190 99 Waltham St 3 17 1 1     9     6009309.01668 2098932.20278 37.7437935707282 -122.410460661231 (37.7437935707282, -122.410460661231)
37671 176274 2 190 775 London St 1 2 1 1     6     6000713.865119999 2089358.3764799999 37.7170204575094 -122.439494437135 (37.7170204575094, -122.439494437135)
38723 191689 2 190 1 01st St 27 23 1 1     3     6014402.09171 2105890.67407 37.7631842517621 -122.393336722306 (37.7631842517621, -122.393336722306)
41072 32329 1 190 1884 08th Ave 1 1 1 1   10/02/1996 12:00:00 AM 5   Permit Number 36893 5993786.54543 2102682.50055 37.7532085147622 -122.46440551389601 (37.7532085147622, -122.464405513896)
41649 73939 2 190 1450 Santiago St 2 1 1 1 1 07/22/1995 12:00:00 AM 2     5988330.9539 2099688.5183 37.744671848150894 -122.483052396761 (37.7446718481509, -122.483052396761)
41768 191697 2 190 1700 22nd St 7 7 1 1     13     6012906.9277800005 2103803.94978 37.7573713838993 -122.398361606903 (37.7573713838993, -122.398361606903)
42410 126571 2 190 1013 Vallejo St 2 7 1 1     13     6008640.83285 2118637.5271099997 37.7978622987641 -122.414164932777 (37.7978622987641, -122.414164932777)
45069 126561 2 190 8 Codman Pl 2 13 1 1     7     6009832.93804 2117260.0663900003 37.7941470150322 -122.40994260678998 (37.7941470150322, -122.40994260679)
47316 126572 2 190 1001 Vallejo St 5 7 1 1     6     6008680.36365 2118649.32289 37.7978969073709 -122.414028979559 (37.7978969073709, -122.414028979559)
48398 224111 2 190 1100 San Jose Ave 50 9 1 1     4     6004733.53405 2096634.51546 37.7372270772601 -122.42611806850799 (37.7372270772601, -122.426118068508)
48766 191702 2 190 1998 Revere Ave 7 9 1 1     1     6013024.54675 2095962.65305 37.7358474048249 -122.397404937794 (37.7358474048249, -122.397404937794)
50134 191700 3 190 1700x Quesada Ave 39 3 1 2     3     6014384.30677 2095263.8272900002 37.7340041867507 -122.39265480417801 (37.7340041867507, -122.392654804178)
54742 72881 2 190 130 Alpha St 5 1 1 1 1 11/21/1998 12:00:00 AM 8     6010899.06821 2088108.5640200002 37.714163133309896 -122.40420099129601 (37.7141631333099, -122.404200991296)
55102 191686 2 190 1301 Minnesota St 14 7 1 1     6     6015385.377169999 2102357.3727700002 37.7535371423304 -122.38968904242701 (37.7535371423304, -122.389689042427)
56447 191691 2 190 2301 19th St 2 9 1 1     7     6010894.94565 2105057.58809 37.7607013108401 -122.405408158461 (37.7607013108401, -122.405408158461)
56636 207715 2 190 117 Judson Ave 2 9 1 1     2     5999294.96193 2093458.5663400001 37.7281977787 -122.444693427785 (37.7281977787, -122.444693427785)
61536 246754 2 190 1838 Alabama St 1 7 1 1     16     6009313.62627 2099009.8875700003 37.7440071345341 -122.410450206611 (37.7440071345341, -122.410450206611)
64078 247873 2 190 388 Mayflower St 1 17 1 1     9     6009888.01932 2098399.59712 37.7423635938187 -122.40842103750299 (37.7423635938187, -122.408421037503)
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)
64747 191695 3 190 950x Kansas St 4 3 1 2     4     6011603.94241 2103847.92507 37.7574194607598 -122.40287096412901 (37.7574194607598, -122.402870964129)
65580 191710 3 190 1427x Innes Ave 28 3 1 2     3     6016141.2133599995 2096757.17707 37.7382020430791 -122.386684681762 (37.7382020430791, -122.386684681762)
67005 191705 2 190 1700 Armstrong Ave 3 17 1 1     6     6013900.77828 2092879.68746 37.727430958252604 -122.394159667654 (37.7274309582526, -122.394159667654)
67780 191690 3 190 900x Carolina St 22 3 1 2     2     6012468.62754 2103498.74867 37.756508943061206 -122.39985600137399 (37.7565089430612, -122.399856001374)
68300 224116 2 190 400 Prospect Ave 15 9 1 1     7     6006205.79839 2097605.42741 37.7399760871276 -122.421096686769 (37.7399760871276, -122.421096686769)
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)
73220 246771 2 190 1850 Alabama St 1 2 1 1     18     6009333.37029 2098874.50038 37.743636497837 -122.410372378408 (37.743636497837, -122.410372378408)
73834 207713 2 190 171 Flood Ave 3 9 1 1     11     5999625.5730099995 2094046.65577 37.7298313962868 -122.443592725033 (37.7298313962868, -122.443592725033)
74925 61499 1 190 154 20th Ave 1 1 1 1 1 08/27/1984 12:00:00 AM 7   Permit Number 21452 5989629.6033 2114330.31946 37.7849497475064 -122.47963307901001 (37.7849497475064, -122.47963307901)
75891 61497 1 190 137 20th Ave 1 1 1 1 1 07/20/1984 12:00:00 AM 9   Permit Number 21447 5989576.46395 2114470.4752700003 37.7853314889271 -122.479827181582 (37.7853314889271, -122.479827181582)
84522 113121 2 190 1x TOMASO CT 9 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
133017 224114 2 190 1100 San Jose Ave 70 7 1 1     6     6004687.50549 2096549.1812200001 37.736990167061 -122.42627113673001 (37.736990167061, -122.42627113673)
133319 54637 1 190 1747 Quint St 1 1 1 1   07/27/1972 12:00:00 AM 1   Permit Number 10460 6012648.74415 2095666.1739599998 37.7350124040996 -122.39868344459299 (37.7350124040996, -122.398683444593)
133784 224113 2 190 1100 San Jose Ave 69 7 1 1     4     6004690.02185 2096554.43933 37.7370047468799 -122.426262810788 (37.7370047468799, -122.426262810788)
135288 246764 2 190 70 Waltham St 8 7 1 1     8     6009279.96949 2098891.64841 37.7436805888792 -122.410558236772 (37.7436805888792, -122.410558236772)
135662 191707 2 190 2187 Revere Ave 1 9 1 1     12     6011937.92175 2096699.9343299998 37.7378112633764 -122.401213644004 (37.7378112633764, -122.401213644004)
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)
141988 113120 2 190 1x TOMASO CT 8 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
143567 111509 3 190 800x BOSWORTH ST 4 7 1 2     4     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
153224 176279 2 190 671 London St 2 2 1 1     7     6001065.40936 2089903.8077599998 37.7185380904529 -122.43831837391001 (37.7185380904529, -122.43831837391)
159049 224115 2 190 1100 San Jose Ave 71 7 1 1     8     6004680.7613 2096547.43611 37.7369849941684 -122.426294330213 (37.7369849941684, -122.426294330213)
162057 247967 2 190 16 Joy St 3 7 1 1     4     6010333.495709999 2098927.4961099997 37.743838026898295 -122.40691790615 (37.7438380268983, -122.40691790615)
163114 126569 2 190 2745 Larkin St 5 9 1 1     8     6006516.40415 2120646.68987 37.8032593947653 -122.42165884218599 (37.8032593947653, -122.421658842186)
165090 73562 2 190 1620 La Salle Ave 1 1 1 1 1 05/21/1988 12:00:00 AM 8     6015449.230359999 2096256.56638 37.7367891335144 -122.389042293172 (37.7367891335144, -122.389042293172)
165369 224112 2 190 1100 San Jose Ave 51 9 1 1     5     6004737.84332 2096628.1853599998 37.7372099397936 -122.42610271887101 (37.7372099397936, -122.426102718871)
167274 126570 2 190 94 MacOndray Ln 1 9 1 1     7     6008053.53116 2119101.30283 37.7991027057905 -122.41623003160299 (37.7991027057905, -122.416230031603)
172056 207733 2 190 500 Joost Ave 3 9 1 1     4     5998757.70005 2094996.74516 37.732390582643205 -122.446661380942 (37.7323905826432, -122.446661380942)
172289 207711 3 190 200x Terrace Dr 31 3 1 2     12     5993844.07189 2096487.62875 37.7362022754996 -122.463756979508 (37.7362022754996, -122.463756979508)
174539 207721 2 190 228 Montana St 1 10 1 1     5     5994631.9391 2089350.3088 37.7166502911674 -122.460515994629 (37.7166502911674, -122.460515994629)
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)
177598 65002 1 190 1628 Visitacion Ave 1 1 1 1   03/31/1989 12:00:00 AM 7   Permit Number 26041 6007789.57951 2087924.3929599999 37.713483198176796 -122.414935588817 (37.7134831981768, -122.414935588817)
179174 71359 2 190 1620 La Salle Ave 2 1 1 1 1 05/21/1988 12:00:00 AM 7     6015449.34332 2096256.73769 37.7367896101585 -122.389041914574 (37.7367896101585, -122.389041914574)
180825 224130 2 190 840 Castro St 2 9 1 1     18     6002416.06064 2103301.09689 37.7554006877977 -122.434607174889 (37.7554006877977, -122.434607174889)
182532 247879 2 190 388 Mayflower St 8 17 1 1     3     6009924.148030001 2098382.32436 37.7423181897436 -122.408294896795 (37.7423181897436, -122.408294896795)
182683 191698 2 190 602 Arthur Ave 35 7 1 1     2     6015659.044530001 2099869.60737 37.7467214305684 -122.38856899259 (37.7467214305684, -122.38856899259)
184764 126562 2 190 8 Codman Pl 1 13 1 1     9     6009829.32931 2117256.5326099996 37.7941371098806 -122.40995484385901 (37.7941371098806, -122.409954843859)
185039 224123 2 190 523 Powhattan Ave 1 2 1 1     7     6008526.38321 2098121.4064599997 37.7415233967761 -122.413109512687 (37.7415233967761, -122.413109512687)
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)
186894 246755 2 190 1838 Alabama St 2 7 1 1     16     6009311.20113 2098998.06122 37.7439745260177 -122.410457757318 (37.7439745260177, -122.410457757318)
16686 19817 3 190 100 STAIRWAY25 1 1 1 2     12 100ST            
14534 18564 3 190 1700X Quesada Ave 19 11 1 2     30 19   6014511.59225 2095170.6430400002 37.7337553901961 -122.392208220649 (37.7337553901961, -122.392208220649)
11287 20003 3 190 100 STAIRWAY46 23 1 1 2     3 2            
6018 19926 3 190 100 STAIRWAY37 6 1 1 2     3 20ST            
17045 19792 3 190 100 STAIRWAY19 14 1 1 2     6 20ST            
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)
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)
78574 109626 2 190 117 JUDSON AVE   5 1 1       3x12   5999286.5 2093444.4 37.728158398345705 -122.44472166307101 (37.7281583983457, -122.444721663071)
2765 173854 2 190 240 Missouri St 1 1 1 1       3x3   6013446.0 2105960.0 37.763321440581 -122.396648407729 (37.763321440581, -122.396648407729)
15545 17442 1 190 1944 Palou Ave 1 1 1 1     2 3x3   6013068.40824 2096637.6125599998 37.73770314508 -122.39730060745501 (37.73770314508, -122.397300607455)
27406 111563 2 190 1498x Kansas St 4 1 1 1     13 3x3   6011720.06091 2101415.9054400004 37.750748151322604 -122.40229838558001 (37.7507481513226, -122.40229838558)
94834 99679 3 190 165 Grattan St 1 1 1 4 2   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
141580 109627 2 190 500 CIRCULAR AVE 1 5 1 1       3x3   5999334.0 2093430.0 37.728121569817 -122.444556419888 (37.728121569817, -122.444556419888)
150484 88782 1 190 166 Havelock St 1 1 1 1   09/02/2008 12:00:00 AM 9 3x3 Permit Number 51699 5999327.1574099995 2092949.02389 37.7268005308142 -122.444545520761 (37.7268005308142, -122.444545520761)
153997 111169 1 190 1469 Pacific Ave 2 1 1 1     7 3x3   6007081.20428 2117722.0309900003 37.795260849674705 -122.41949671281701 (37.7952608496747, -122.419496712817)
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)
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)
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)
7267 19835 3 190 100 STAIRWAY25 19 1 1 2     12 60X            
8172 19836 3 190 100 STAIRWAY25 20 1 1 2     12 60X            
15209 19838 3 190 100 STAIRWAY25 22 1 1 2     6 60X            
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)
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)
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)
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)
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)
59361 176270 2 190 195 Rome St 1 7 1 1     3 Width 0ft   5998756.35201 2088943.21744 37.7157689240671 -122.44623074418001 (37.7157689240671, -122.44623074418)
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)
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)
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)
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)
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)
155016 176272 2 190 179 Niagara Ave 1 10 1 1     5 Width 0ft   5999311.03211 2089604.94508 37.717617539904296 -122.444361048235 (37.7176175399043, -122.444361048235)
155390 176273 2 190 179 Niagara Ave 2 10 1 1     2 Width 0ft   5999314.98259 2089602.87456 37.717612080124205 -122.444347244552 (37.7176120801242, -122.444347244552)
Powered by Datasette · Query took 4.337ms · Data source: data.sfgov.org