sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25101 206960 2 19 546 Joost Ave 4 9 1 1     3     5998473.38947 2095013.2793400001 37.7324197368658 -122.44764549463899 (37.7324197368658, -122.447645494639)
25548 71937 2 19 1053 Montgomery St 1 1 1 1 1 10/21/1995 12:00:00 AM 4     6011562.24883 2118965.23166 37.7989257551836 -122.404079031531 (37.7989257551836, -122.404079031531)
26975 129323 2 19 1 Florence St 1 9 1 1     7     6008475.1891 2118345.56468 37.7970513368976 -122.414717435764 (37.7970513368976, -122.414717435764)
27272 206957 2 19 546 Joost Ave 1 9 1 1     1     5998473.21835 2095005.05828 37.7323971540007 -122.447645494648 (37.7323971540007, -122.447645494648)
27332 176698 2 19 283 Moscow St 2 9 1 1     8     6004617.240230001 2091470.03605 37.72303999319411 -122.42615258897 (37.7230399931941, -122.42615258897)
29711 218145 2 19 31 Ashton Ave 2 9 1 1     9     5994144.20993 2090116.67038 37.7187264660332 -122.462257368104 (37.7187264660332, -122.462257368104)
29956 176692 2 19 242 Athens St 8 9 1 1     12     6004473.28311 2091848.82103 37.72407191576529 -122.426677180615 (37.7240719157653, -122.426677180615)
31573 129332 2 19 1101 Greenwich St 10 7 1 1     1     6007563.684280001 2119863.77685 37.8011687120311 -122.417979152724 (37.8011687120311, -122.417979152724)
32280 129119 2 19 1114 Greenwich St 3 17 1 1     18     6007553.05086 2119913.7987599997 37.8013054611424 -122.418019497203 (37.8013054611424, -122.418019497203)
32430 176689 2 19 242 Athens St 4 9 1 1     9     6004476.46951 2091852.67463 37.72408267705 -122.426666440004 (37.72408267705, -122.426666440004)
34438 176721 2 19 83 Athens St 3 9 1 1     3     6005098.35657 2092750.06265 37.7265818471717 -122.42458047420799 (37.7265818471717, -122.424580474208)
35777 226865 2 19 1100 San Jose Ave 9 7 1 1     1     6004824.42349 2096711.0552700001 37.7374423749661 -122.425809268297 (37.7374423749661, -122.425809268297)
37322 219374 2 19 167 Hamerton Ave 1 9 1 1     14     6001346.700759999 2095283.33425 37.7333250412114 -122.437731137293 (37.7333250412114, -122.437731137293)
39701 129113 2 19 10 Hastings Ter 3 9 1 1     2     6007329.70066 2119282.266 37.7995588581063 -122.418747576633 (37.7995588581063, -122.418747576633)
41994 129117 2 19 12 Hastings Ter 8 9 1 1     5     6007264.16981 2119273.41538 37.7995308667162 -122.418973709394 (37.7995308667162, -122.418973709394)
43932 206959 2 19 546 Joost Ave 3 9 1 1     1     5998473.1983199995 2095010.9948599997 37.7324134532998 -122.44764599109399 (37.7324134532998, -122.447645991094)
47621 226917 2 19 1334 Diamond St 4 9 1 1     15     6001952.27802 2100070.91902 37.7465050491722 -122.43597994953699 (37.7465050491722, -122.435979949537)
50439 176687 2 19 242 Athens St 2 9 1 1     8     6004483.134190001 2091864.5004 37.7241155248047 -122.426644242931 (37.7241155248047, -122.426644242931)
52800 129325 2 19 1101 Greenwich St 3 7 1 1     4     6007543.5223900005 2119858.96336 37.801154360655 -122.41804858037399 (37.801154360655, -122.418048580374)
54077 176691 2 19 242 Athens St 6 9 1 1     8     6004467.85023 2091856.56465 37.7240928708828 -122.426696512434 (37.7240928708828, -122.426696512434)
54090 226841 2 19 601 Grand View Ave 4 9 1 1     21     6000050.597159999 2101613.91714 37.7506335336184 -122.44266650425301 (37.7506335336184, -122.442666504253)
54321 70512 2 19 75 Vienna St 1 1 1 1 1 06/25/1994 12:00:00 AM 5     6004917.4216 2092965.0192099998 37.7271618505134 -122.425221249286 (37.7271618505134, -122.425221249286)
54473 103306 2 19 611 Rhode Island St 1 1 1 1     15     6011832.19369 2105491.00064 37.7619437242424 -122.402197092231 (37.7619437242424, -122.402197092231)
55511 247671 2 19 170 Divisadero St 2 9 1 1     15     6001937.95373 2108623.93042 37.7699887373234 -122.43664159784099 (37.7699887373234, -122.436641597841)
55719 110572 2 19 46 COOK ST 4 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
57173 247138 2 19 500 27th St 8 7 1 1     5     6003171.95048 2100074.35789 37.7465837047841 -122.43176270469499 (37.7465837047841, -122.431762704695)
59244 71583 2 19 266 Flournoy St 1 1 1 1 1 09/30/1995 12:00:00 AM 7     5993925.4185 2086705.1573599998 37.7093466620935 -122.462766282735 (37.7093466620935, -122.462766282735)
60193 219308 2 19 166 Marston Ave 4 9 1 1     12     5998423.39601 2093237.9492099998 37.7275422412798 -122.447690576758 (37.7275422412798, -122.447690576758)
60332 129310 2 19 12 Hastings Ter 3 9 1 1     3     6007284.92251 2119276.14262 37.7995395235904 -122.418902090975 (37.7995395235904, -122.418902090975)
60867 246724 2 19 1501 Shotwell St 1 17 1 1     9     6008058.52794 2099329.47434 37.744814207710796 -122.41481267936001 (37.7448142077108, -122.41481267936)
60902 129330 2 19 1101 Greenwich St 8 7 1 1     2     6007557.40785 2119862.6523599997 37.8011652712212 -122.41800079219601 (37.8011652712212, -122.418000792196)
61449 219253 2 19 449 Melrose Ave 2 9 1 1     3     5997174.7237 2095517.45722 37.7337297819926 -122.452171628738 (37.7337297819926, -122.452171628738)
62195 84689 2 19 3632 Fillmore St 1 1 1 1 1   3     6002195.05393 2120739.39081 37.80326930438871 -122.436619630107 (37.8032693043887, -122.436619630107)
63287 219402 2 19 434 Mangels Ave 3 9 1 1     11     5998549.21745 2095283.33159 37.733165569840295 -122.44740277122601 (37.7331655698403, -122.447402771226)
64677 247136 2 19 500 27th St 6 7 1 1     3     6003181.95614 2100090.46758 37.7466285054035 -122.43172925621501 (37.7466285054035, -122.431729256215)
64780 129114 2 19 12 Hastings Ter 1 9 1 1     3     6007312.730219999 2119281.87279 37.79955682294621 -122.41880627269899 (37.7995568229462, -122.418806272699)
65360 129326 2 19 1101 Greenwich St 4 7 1 1     4     6007546.3898 2119859.39883 37.801155717731 -122.41803868875401 (37.801155717731, -122.418038688754)
66998 226943 2 19 301 Fairmount St 3 17 1 1     63     6004022.8098 2097135.0105400002 37.7385611270814 -122.42861103418001 (37.7385611270814, -122.42861103418)
67246 219401 2 19 434 Mangels Ave 2 9 1 1     9     5998548.8783 2095279.67226 37.7331555028062 -122.447403680457 (37.7331555028062, -122.447403680457)
74501 129333 2 19 1101 Greenwich St 12 7 1 1     1     6007566.1830400005 2119864.34532 37.8011704135381 -122.417970546228 (37.8011704135381, -122.417970546228)
75142 226916 2 19 1334 Diamond St 3 9 1 1     15     6001951.53708 2100078.27366 37.746525201185705 -122.435983037796 (37.7465252011857, -122.435983037796)
75513 190810 2 19 1400 De Haro St 3 9 1 1     12     6012250.57302 2101824.03335 37.75189838151329 -122.400492482157 (37.7518983815133, -122.400492482157)
78535 110569 2 19 46 COOK ST 1 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
89053 102912 2 19 84 Vienna St 1 5 1 1           6004823.0 2092922.0 37.7270383945734 -122.42554460371599 (37.7270383945734, -122.425544603716)
94696 107828 2 19 2601 Van Ness Ave 2 7 1 1     35   Permit Number 774138 6005744.5 2119283.2 37.799472043237294 -122.424233014169 (37.7994720432373, -122.424233014169)
97359 119672 2 19 2090x 20th St 1 5 1 1           6011896.0 2104722.0 37.7598357807336 -122.40192234981501 (37.7598357807336, -122.401922349815)
101905 97139 2 19 937 Goettingen St   25 2 1           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644)
104404 106685 2 19 100 Yukon St   8 1 1         Permit Number 772768 6000197.4 2104288.0 37.757984281634 -122.44235080136299 (37.757984281634, -122.442350801363)
107354 110571 2 19 46 COOK ST 3 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
107819 114704 2 19 524 Staples Ave 2 1 1 1           5996948.70097149 2093858.06219815 37.729160530354 -122.452833321223 (37.729160530354, -122.452833321223)
119837 219290 2 19 502 Edna St 4 9 1 1     14     5998794.71473 2094454.093 37.7309027019769 -122.44649438672899 (37.7309027019769, -122.446494386729)
123310 226843 2 19 601 Grand View Ave 6 9 1 1     13     6000048.9204 2101630.772 37.7506797174008 -122.442673512691 (37.7506797174008, -122.442673512691)
124373 110570 2 19 46 COOK ST 2 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
135078 176697 2 19 283 Moscow St 1 9 1 1     8     6004613.59426 2091464.71146 37.7230251669629 -122.426164813475 (37.7230251669629, -122.426164813475)
136064 206915 2 19 382 Joost Ave 2 9 1 1     12     5999548.48293 2094983.7433799999 37.7324000228394 -122.44392653538999 (37.7324000228394, -122.44392653539)
136870 206916 2 19 382 Joost Ave 3 9 1 1     13     5999547.8885699995 2094988.6031799999 37.7324133328074 -122.44392893927 (37.7324133328074, -122.44392893927)
138216 129178 2 19 3298 Lyon St 4 9 1 1     11     5998998.34734 2120131.24528 37.801417321497794 -122.447638089651 (37.8014173214978, -122.447638089651)
149094 129115 2 19 12 Hastings Ter 2 9 1 1     3     6007304.145280001 2119280.40626 37.7995523128455 -122.418835875684 (37.7995523128455, -122.418835875684)
149203 176720 2 19 83 Athens St 2 9 1 1     4     6005093.440280001 2092751.8073 37.7265863599479 -122.424597593708 (37.7265863599479, -122.424597593708)
149571 226942 2 19 301 Fairmount St 2 17 1 1     61     6004034.48943 2097139.1413599998 37.7385731303523 -122.428570945989 (37.7385731303523, -122.428570945989)
150004 247945 2 19 15 Joy St 1 7 1 1     4     6010344.08085 2098894.91993 37.743749172086794 -122.406879009554 (37.7437491720868, -122.406879009554)
151655 129180 2 19 3298 Lyon St 8 9 1 1     15     5998992.55112 2120173.79871 37.8015338304744 -122.447661212108 (37.8015338304744, -122.447661212108)
151959 176688 2 19 242 Athens St 3 9 1 1     10     6004477.9919300005 2091866.25637 37.7241200555896 -122.426662143938 (37.7241200555896, -122.426662143938)
153922 176719 2 19 83 Athens St 1 9 1 1     8     6005086.02152 2092756.70841 37.7265993983363 -122.424623588602 (37.7265993983363, -122.424623588602)
155571 129116 2 19 12 Hastings Ter 5 9 1 1     2     6007272.57871 2119275.5487599997 37.7995371979413 -122.418944762911 (37.7995371979413, -122.418944762911)
161824 226864 2 19 294 Bemis St 1 9 1 1     16     6002870.33579 2096200.69977 37.735930434733895 -122.43252901612499 (37.7359304347339, -122.432529016125)
166472 219289 2 19 212 Hearst Ave 3 9 1 1     15     6000021.7588599995 2094391.55227 37.7308009895552 -122.442247818595 (37.7308009895552, -122.442247818595)
167449 176718 2 19 139 Athens St 2 9 1 1     8     6004890.82087 2092414.1622099997 37.7256478157716 -122.42527402599801 (37.7256478157716, -122.425274025998)
167821 219239 2 19 579 Hearst Ave 2 9 1 1     6     5997578.77584 2094371.8563299999 37.7306073727237 -122.450692139651 (37.7306073727237, -122.450692139651)
169027 206958 2 19 546 Joost Ave 2 9 1 1     3     5998473.20462 2095007.84782 37.7324048126327 -122.447645742852 (37.7324048126327, -122.447645742852)
169303 129327 2 19 1101 Greenwich St 5 7 1 1     2     6007552.17158 2119860.88653 37.801160127991295 -122.41801878675899 (37.8011601279913, -122.418018786759)
170842 129329 2 19 1101 Greenwich St 7 7 1 1     1     6007555.7240699995 2119861.47467 37.8011619428155 -122.41800653528601 (37.8011619428155, -122.418006535286)
171348 190811 2 19 1400 De Haro St 4 9 1 1     15     6012250.38187 2101814.62177 37.7518725286982 -122.400492482145 (37.7518725286982, -122.400492482145)
171563 129328 2 19 1101 Greenwich St 6 7 1 1     1     6007553.95221 2119861.40094 37.8011616406485 -122.418012661478 (37.8011616406485, -122.418012661478)
171687 219254 2 19 449 Melrose Ave 3 9 1 1     4     5997174.97013 2095514.3444599998 37.7337212492173 -122.452170552242 (37.7337212492173, -122.452170552242)
173605 226941 2 19 300 Fairmount St 1 17 1 1     16     6004051.37428 2097144.63452 37.738589168851206 -122.42851295770399 (37.7385891688512, -122.428512957704)
173712 201343 2 19 1 Bitting Ave 5 9 1 1     5     6012739.9825 2092614.2530099999 37.72663754126479 -122.39815395433399 (37.7266375412648, -122.398153954334)
174096 219307 2 19 166 Marston Ave 2 9 1 1     9     5998440.900769999 2093236.39067 37.727538962329604 -122.447629950774 (37.7275389623296, -122.447629950774)
174640 176690 2 19 242 Athens St 5 9 1 1     10     6004472.37947 2091855.23398 37.724089473225206 -122.426680760821 (37.7240894732252, -122.426680760821)
175259 218146 2 19 31 Ashton Ave 3 7 1 1     7     5994143.80732 2090112.0989599999 37.7187138908262 -122.46225842838601 (37.7187138908262, -122.462258428386)
175549 247137 2 19 500 27th St 7 7 1 1     3     6003179.078430001 2100075.39017 37.7465869432333 -122.431738130709 (37.7465869432333, -122.431738130709)
179080 118669 2 19 4550 Balboa St 6 9 1 1     50     5981412.61192 2111005.49415 37.7753400136649 -122.507813913091 (37.7753400136649, -122.507813913091)
179518 176686 2 19 242 Athens St 1 9 1 1     7     6004486.61146 2091862.36635 37.7241098617621 -122.426632070637 (37.7241098617621, -122.426632070637)
179802 129331 2 19 1101 Greenwich St 9 7 1 1     2     6007561.62509 2119863.3782 37.8011675015458 -122.41798625015899 (37.8011675015458, -122.417986250159)
183882 129112 2 19 10 Hastings Ter 2 9 1 1     3     6007339.93679 2119283.26863 37.799562187397704 -122.41871222699801 (37.7995621873977, -122.418712226998)
184997 219400 2 19 434 Mangels Ave 1 9 1 1     10     5998549.53071 2095273.1110200002 37.7331375244767 -122.447400952815 (37.7331375244767, -122.447400952815)
187209 206920 2 19 411 Melrose Ave 1 9 1 1     2     5997366.58572 2095512.9448099998 37.7337283808453 -122.45150798300399 (37.7337283808453, -122.451507983004)
187387 226842 2 19 601 Grand View Ave 5 9 1 1     10     6000049.35116 2101618.9889599998 37.75064738858 -122.44267117713699 (37.75064738858, -122.442671177137)
188832 129179 2 19 3298 Lyon St 6 9 1 1     13     5998993.68481 2120160.70419 37.801497941247895 -122.44765634587601 (37.8014979412479, -122.447656345876)
14463 110915 2 19 77 Federal St 1 1 1 1     3 2x1   6014720.0191 2113052.86526 37.7828676936327 -122.39273818212 (37.7828676936327, -122.39273818212)
28768 110918 2 19 77 Federal St 4 1 1 1     3 2x1   6014775.51071 2113108.67341 37.7830240119856 -122.392550107818 (37.7830240119856, -122.392550107818)
151494 110917 2 19 77 Federal St 3 1 1 1     3 2x1   6014761.22745 2113096.50864 37.7829898170664 -122.39259867121001 (37.7829898170664, -122.39259867121)
164696 110916 2 19 77 Federal St 2 1 1 1     3 2x1   6014753.14393 2113088.0309200003 37.7829660902443 -122.392626043851 (37.7829660902443, -122.392626043851)
181098 110919 2 19 77 Federal St 5 1 1 1     3 2x1   6014784.35432 2113116.8816 37.783047040932395 -122.39252008665001 (37.7830470409324, -122.39252008665)
50164 107054 2 19 98X ROTTECK ST 3 1 1 1     12 2x2   6003385.0 2094496.0 37.731278888142704 -122.43062801306999 (37.7312788881427, -122.43062801307)
66804 115308 2 19 1309 Hyde St 2 5 1 1     10 2x2   6007523.230690001 2116877.91301 37.792967998429 -122.417907360732 (37.792967998429, -122.417907360732)
80890 108255 2 19 1798X Washington St 2 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
92163 108259 2 19 1798X Washington St 6 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
98097 108256 2 19 1798X Washington St 3 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
105668 108258 2 19 1798X Washington St 5 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
112717 108257 2 19 1798X Washington St 4 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
Powered by Datasette · Query took 104.677ms · Data source: data.sfgov.org