sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
125685 96832 1 19 2908 Baker St 3 5 1 1           5999535.9 2118868.1 37.797979769659996 -122.44568703479601 (37.79797976966, -122.445687034796)
125858 104539 7 19 1101 Van Ness Ave 2 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
129210 95985 6 19 577 Sanchez St 1 25 1 1           6003673.0 2104901.0 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168)
130260 54791 1 19 280 Tocoloma Ave 1 1 1 1   08/02/1972 12:00:00 AM 18   Permit Number 10640 6012628.37407 2087183.5823 37.711719793993204 -122.39815894829901 (37.7117197939932, -122.398158948299)
131920 31117 1 19 450 Edna St 3 1 1 1 1 03/21/1995 12:00:00 AM 3   Permit Number 34839 5998792.33216 2094320.7757 37.7305365079364 -122.446493035949 (37.7305365079364, -122.446493035949)
133392 68011 1 19 2550 Leavenworth St 1 1 1 1   04/21/1993 12:00:00 AM 4   Permit Number 31741 6007478.84194 2121154.66744 37.8047083959278 -122.41836432607501 (37.8047083959278, -122.418364326075)
134405 62997 1 19 3718 Divisadero St 1 1 1 1   09/11/2015 12:00:00 AM 6   Permit Number 776580 6000198.89461 2121071.17508 37.8040666559246 -122.443551231218 (37.8040666559246, -122.443551231218)
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)
136530 46600 1 19 2425 Green St 1 1 1 1   04/10/2002 12:00:00 AM 5   Permit Number 44728 6001248.41305 2117934.15473 37.795513025858 -122.439694270995 (37.795513025858, -122.439694270995)
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)
138525 104568 7 19 1101 Van Ness Ave 9 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
140502 104541 7 19 1101 Van Ness Ave 5 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
143885 108210 6 19 524 45th Ave 1 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
146783 35594 1 19 1303 Rhode Island St 1 1 1 1 1 11/12/2005 12:00:00 AM 5   Permit Number 38957 6012015.58746 2102213.6753599998 37.752955146087295 -122.401332479509 (37.7529551460873, -122.401332479509)
148745 61250 1 19 2033 Leavenworth St 1 1 1 1 1 03/15/1997 12:00:00 AM 7   Permit Number 24211 6007651.97178 2119454.00624 37.800048553351296 -122.41764457883001 (37.8000485533513, -122.41764457883)
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)
157750 30806 1 19 138 Hamerton Ave 1 1 1 1 1 02/06/1995 12:00:00 AM 15   Permit Number 34671 6001325.75026 2095385.6774799998 37.7336048607826 -122.437810896383 (37.7336048607826, -122.437810896383)
159523 34521 1 19 306 Harvard St 1 1 1 1   07/22/1997 12:00:00 AM 11   Permit Number 38231 6006308.04583 2092388.1729 37.725656419580496 -122.42037294026301 (37.7256564195805, -122.420372940263)
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)
167693 38364 1 19 4001 Lawton St 1 1 1 1 1 05/01/2002 12:00:00 AM 5   Permit Number 44994 5981794.8549 2104174.5597 37.7566067521127 -122.50598509825001 (37.7566067521127, -122.50598509825)
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)
173736 57800 1 19 837 47th Ave 1 1 1 1   02/14/1977 12:00:00 AM 9   Permit Number 16735 5981352.9647 2110030.94394 37.7726606704836 -122.50794790130199 (37.7726606704836, -122.507947901302)
174096 219307 2 19 166 Marston Ave 2 9 1 1     9     5998440.900769999 2093236.39067 37.727538962329604 -122.447629950774 (37.7275389623296, -122.447629950774)
174140 49714 1 19 1181@ POLK Chestnut St 1 1 1 1 1 06/03/2003 12:00:00 AM 5   Permit Number 46526 6006207.33741 2120358.03247 37.8024493825888 -122.422707853704 (37.8024493825888, -122.422707853704)
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)
180391 69013 1 19 2183 45th Ave 1 1 1 1 1 01/05/1994 12:00:00 AM 4   Permit Number 33017 5982309.8617 2100270.0071 37.7459162464128 -122.50391486605301 (37.7459162464128, -122.503914866053)
183234 43136 1 19 1730 Burrows St 1 1 1 1 1 07/11/2000 12:00:00 AM 7   Permit Number 42952 6006290.853069999 2092023.3911599999 37.7246538391803 -122.42040649398199 (37.7246538391803, -122.420406493982)
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)
186712 38366 1 19 4001 Lawton St 3 1 1 1   08/03/1998 12:00:00 AM 6   Permit Number 40430 5981835.1907 2104176.6987 37.756614999407894 -122.50584576351999 (37.7566149994079, -122.50584576352)
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)
14648 19819 3 19 100 STAIRWAY25 3 1 1 2     12 100ST            
46600 116804 3 19 131 LAKESHORE DR 1 3 2 2       10x100   5984782.0 2094243.0 37.7295127607338 -122.494922366174 (37.7295127607338, -122.494922366174)
97259 116164 6 19 2411 OCTAVIA ST 1 2 1 1     13 15x4   6004495.0 2117637.0 37.7948813682629 -122.428439330772 (37.7948813682629, -122.428439330772)
32407 866 3 19 600X Alemany Blvd 4 1 1 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
112118 878 3 19 600X Alemany Blvd 16 1 1 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
5604 19964 3 19 100 STAIRWAY41 2 1 1 2     6 25ST            
8096 19962 3 19 100 STAIRWAY41 -2 1 1 2     6 25ST            
9264 19963 3 19 100 STAIRWAY41 1 1 1 2     6 25ST            
17954 16098 3 19 300 Monterey Blvd 1 1 1 2   12/17/1997 12:00:00 AM 6 2X3   6000050.52204 2094718.8331 37.7317012658005 -122.442171864536 (37.7317012658005, -122.442171864536)
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)
85124 85121 1 19 1403 11th Ave 2 5 2 1   02/27/2007 12:00:00 AM 7 2x2 Tree 2. Permit Number 49495. 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
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)
92708 85104 1 19 1403 11th Ave 1 5 2 1     9 2x2 Tree 1 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
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)
121707 108254 2 19 1798X Washington St 1 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
139234 93020 1 19 1403 11th Ave 3 5 1 1     10 2x2 Tree 3 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
168446 115307 2 19 1309 Hyde St 1 5 1 1     10 2x2   6007522.861409999 2116889.0118 37.792998452176796 -122.41790942558501 (37.7929984521768, -122.417909425585)
104644 106801 2 19 1850 BRYANT ST 1 5 1 1     25 2x3   6009455.7 2106195.7 37.763745730245795 -122.41046624869301 (37.7637457302458, -122.410466248693)
16920 19979 3 19 100 STAIRWAY45 6 1 1 2     3 30ST            
11045 27100 1 19 675 Silver Ave 1 1 1 1     30 3X3   6005860.0759 2093589.7540900002 37.728930444682206 -122.422006859139 (37.7289304446822, -122.422006859139)
11331 1100 3 19 2328 Alemany Blvd 1 1 1 2     25 3X3   5999423.31284 2089282.1433599999 37.71673760544579 -122.44394976577298 (37.7167376054458, -122.443949765773)
16907 16140 1 19 370 Monterey Blvd 4 1 1 1     6 3X3   5999741.99698 2094725.2386 37.7317012657937 -122.44323895423099 (37.7317012657937, -122.443238954231)
17854 4283 1 19 4301 Cesar Chavez St 2 1 1 1   04/07/1995 12:00:00 AM 3 3X3   6001860.11761 2100274.84005 37.7470597321331 -122.436313221179 (37.7470597321331, -122.436313221179)
18293 4370 1 19 998 Chenery St 1 1 1 1   06/04/1992 12:00:00 AM 12 3X3   6001204.190330001 2096097.5771700002 37.7355526592134 -122.438282146497 (37.7355526592134, -122.438282146497)
18654 16099 3 19 300 Monterey Blvd 3 1 1 2     12 3X3   6000036.69943 2094718.89433 37.7317006461483 -122.442219656332 (37.7317006461483, -122.442219656332)
18666 19313 3 19 21 Shields St 1 1 1 2     3 3X3   5993901.63447 2089816.98545 37.7178896324771 -122.463074115289 (37.7178896324771, -122.463074115289)
19631 16102 3 19 300 Monterey Blvd 6 1 1 2     12 3X3   6000017.68556 2094719.9660099999 37.7317025050652 -122.442285467815 (37.7317025050652, -122.442285467815)
21152 4284 1 19 4301 Cesar Chavez St 3 1 1 1   04/07/1995 12:00:00 AM 3 3X3   6001863.40945 2100279.02786 37.747071417908 -122.43630213795299 (37.747071417908, -122.436302137953)
21395 16100 3 19 300 Monterey Blvd 4 1 1 2     12 3X3   6000028.57256 2094720.41703 37.7317043639536 -122.442247861742 (37.7317043639536, -122.442247861742)
100221 5821 3 19 1027 Duncan St 1 1 1 2     75 3X3   5999811.0829915 2099731.7400522 37.745451872839 -122.443359584044 (37.745451872839, -122.443359584044)
110428 12623 3 19 825 Lake St 1 1 1 2     27 3X3   5992882.168 2114794.01241 37.7864113245051 -122.468414093066 (37.7864113245051, -122.468414093066)
115088 117438 6 19 230 AMBER DR 1 5 1 1     25 3X3   5999593.0 2099199.0 37.7439766577846 -122.444075405191 (37.7439766577846, -122.444075405191)
108014 113985 2 19 109 MADRONE AVE 1 5 1 1       3x10   5992778.0 2098364.0 37.74129282931111 -122.46757920887899 (37.7412928293111, -122.467579208879)
Powered by Datasette · Query took 15.119ms · Data source: data.sfgov.org