sf-trees

Data source: data.sfgov.org

Custom SQL query returning 95 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
67614 214345 2 72 498 Vernon St 7 9 1 1     4 Width 10ft   5992504.20594 2091177.71285 37.7215452614802 -122.46800328954599 (37.7215452614802, -122.468003289546)
67839 135863 2 72 8 Kimball Pl 4 1 1 1     10 Width 4ft   6007998.64807 2116497.60836 37.7919505198577 -122.416235439221 (37.7919505198577, -122.416235439221)
69505 196330 2 72 582 Rhode Island St 11 9 1 1     2     6011759.958869999 2105639.7656 37.7623481673595 -122.40245738661801 (37.7623481673595, -122.402457386618)
70609 237916 2 72 1295 Stanyan St 2 1 1 1     12 Width 4ft   5997518.24966 2104934.77487 37.7596070976188 -122.451663046815 (37.7596070976188, -122.451663046815)
71198 214353 2 72 50 Garcia Ave 5 2 1 1     4 Width 3ft   5995149.72336 2099349.67966 37.74413591023829 -122.45945004977399 (37.7441359102383, -122.459450049774)
71736 214350 2 72 100 Vista Verde Ct 12 1 1 1     9 Width 3ft   5999173.543740001 2096088.2498400002 37.735411342443 -122.445302168061 (37.735411342443, -122.445302168061)
71993 237925 2 72 37 Seward St 7 7 1 1     14 Width 3ft   6000968.93807 2104244.5163 37.7579088304528 -122.439679384512 (37.7579088304528, -122.439679384512)
72296 237926 2 72 23 Seward St 1 7 1 1     12 Width 3ft   6001036.33691 2104228.71408 37.757869277361706 -122.43944515878799 (37.7578692773617, -122.439445158788)
73967 181900 2 72 2374 28th Ave 2 1 1 1     7 Width 0ft   5987672.3244 2099143.5701 37.7431372169369 -122.485289801059 (37.7431372169369, -122.485289801059)
74387 214335 2 72 570 Hearst Ave 1 9 1 1     4     5997650.4841 2094424.8417 37.730756962361 -122.450448052843 (37.730756962361, -122.450448052843)
74881 237899 2 72 401 Capp St 2 1 1 1     3 Width 3ft   6007240.84354 2104941.30252 37.760177031272995 -122.418037841569 (37.760177031273, -122.418037841569)
75667 123051 2 72 544 Funston Ave 2 2 1 1     1 Width 4ft   5991925.368290001 2111718.74321 37.777912168825004 -122.47150017707199 (37.777912168825, -122.471500177072)
76982 135865 2 72 2518 Jackson St 2 1 1 1     3 Width 3ft   6001998.80283 2116724.02313 37.792233000491294 -122.437011118472 (37.7922330004913, -122.437011118472)
84232 105709 2 72 739 10th Ave 1 1 1 1     10 3x3   5992855.21688 2110425.97288 37.7744163192706 -122.468189464852 (37.7744163192706, -122.468189464852)
94247 237894 2 72 101 Franconia St 1 1 1 1     7 Width 2ft   6010034.07785 2099858.60697 37.7463778949392 -122.408018877775 (37.7463778949392, -122.408018877775)
125300 196327 2 72 582 Rhode Island St 7 9 1 1     3     6011756.69483 2105652.08155 37.7623818019909 -122.402469541836 (37.7623818019909, -122.402469541836)
128545 183562 2 72 2591 30th Ave 1 2 1 1     5 Width 0ft   5987056.0774 2097655.4477 37.7390153079093 -122.487311308785 (37.7390153079093, -122.487311308785)
130531 237915 2 72 1295 Stanyan St 4 1 1 1     11 Width 4ft   5997519.793 2104903.6211900003 37.7595216458395 -122.451655461936 (37.7595216458395, -122.451655461936)
130582 214327 2 72 100 Vista Verde Ct 9 2 1 1     10 Width 10ft   5999204.10164 2096073.9362400002 37.7353737849692 -122.44519548960501 (37.7353737849692, -122.445195489605)
131366 237944 2 72 26 Ohlone Way 1 13 1 1     15 Width 2ft   6002164.0262 2096336.8178599998 37.736264104808 -122.43498073797701 (37.736264104808, -122.434980737977)
131846 214348 2 72 101 Montalvo Ave 1 2 1 1     16 Width 3ft   5993734.17627 2099649.69883 37.7448781944898 -122.464366439256 (37.7448781944898, -122.464366439256)
135434 214312 2 72 1616 09th Ave 2 7 1 1     8 Width 6ft   5993417.09067 2104452.78428 37.758047952866605 -122.465811766705 (37.7580479528666, -122.465811766705)
136222 142495 2 72 471 UNION ST 1 1 1 1     13 Width 0ft   6010670.1646 2119603.9064 37.800629516216 -122.407210998267 (37.800629516216, -122.407210998267)
137327 214332 3 72 100x Idora Ave 18 3 1 2     9 Width 9ft   5995718.21124 2099321.8453599997 37.7440921546362 -122.457482343055 (37.7440921546362, -122.457482343055)
137397 214320 2 72 1518 05th Ave 4 10 1 1     4     5994627.9467 2105254.67875 37.7603195216609 -122.46168228042801 (37.7603195216609, -122.461682280428)
138151 237906 2 72 3937 21st St 3 9 1 1     22 Width 3ft   6002245.415080001 2103514.00804 37.755975601915104 -122.43521254633 (37.7559756019151, -122.43521254633)
138178 214355 2 72 811 Congo St 23 9 1 1     7     6000531.25655 2095885.67636 37.734932531704004 -122.440593534571 (37.734932531704, -122.440593534571)
144327 87840 1 72 150 Golden Gate Ave 1 1 1 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008834.949469999 2112868.30248 37.78203231246879 -122.413085083511 (37.7820323124688, -122.413085083511)
146622 237895 2 72 101 Franconia St 1 1 1 1     10 Width 2ft   6010025.93602 2099871.47095 37.746412760754104 -122.40804793845501 (37.7464127607541, -122.408047938455)
147556 214315 2 72 1643 09th Ave 1 1 1 1     2 Width 2ft   5993376.02878 2104293.90166 37.7576093337224 -122.465942230469 (37.7576093337224, -122.465942230469)
147966 183564 2 72 2595 30th Ave 3 2 1 1     6 Width 0ft   5987057.6296 2097628.3948 37.738941118307295 -122.487303955513 (37.7389411183073, -122.487303955513)
147995 135868 2 72 2881 Vallejo St 2 1 1 1     3 Width 4ft   5999820.06951 2117394.7311 37.7939505095535 -122.444597778561 (37.7939505095535, -122.444597778561)
148360 237940 2 72 67 Potomac St 1 1 1 1     7 Width 3ft   6003085.03748 2108738.20516 37.7703676280017 -122.432682022255 (37.7703676280017, -122.432682022255)
148782 237922 2 72 167 Hartford St 1 1 1 1     15 Width 3ft   6002705.54642 2104925.31615 37.7598768339596 -122.433722125974 (37.7598768339596, -122.433722125974)
150930 237889 2 72 722 Andover St 1 1 1 1     3 Width 3ft   6007362.196 2095569.17155 37.7344500984995 -122.416954096469 (37.7344500984995, -122.416954096469)
153128 200001 2 72 1450 Griffith St 3 1 1 1     1 Width 0ft   6017674.9346 2092354.0887 37.7261968206849 -122.381075736801 (37.7261968206849, -122.381075736801)
153689 135873 2 72 1002 Vallejo St 1 13 1 1     10     6008628.64799 2118672.57502 37.7979578472257 -122.414209576908 (37.7979578472257, -122.414209576908)
153732 237942 2 72 320 Hermann St 1 1 1 1     12 Width 3ft   6003704.07001 2108683.26654 37.770251867271796 -122.43053686847901 (37.7702518672718, -122.430536868479)
153868 214322 3 72 350x Kensington Way 2 11 1 2     12 Width 6ft   5994251.85903 2099042.92229 37.7432419652355 -122.462532396964 (37.7432419652355, -122.462532396964)
154466 214328 2 72 100 Vista Verde Ct 10 2 1 1     7 Width 10ft   5999189.95231 2096066.10598 37.735351477276296 -122.44524384613001 (37.7353514772763, -122.44524384613)
154507 237885 2 72 730 Cole St 1 1 1 1     2 Width 3ft   5997985.449030001 2107861.4098900002 37.767669642974894 -122.450258206855 (37.7676696429749, -122.450258206855)
154593 237939 2 72 273 States St 1 1 1 1     14 Width 3ft   6000450.96835 2106715.6224 37.764664383877 -122.44164807149599 (37.764664383877, -122.441648071496)
155130 237898 2 72 1087 Florida St 1 1 1 1     8 Width 4ft   6009471.98593 2102823.41576 37.754487114207 -122.41017181789101 (37.754487114207, -122.410171817891)
155167 214341 2 72 144 Montana St 1 1 1 1     8 Width 3ft   5995498.01894 2089341.3443900002 37.7166754640834 -122.457521759431 (37.7166754640834, -122.457521759431)
155769 237900 2 72 2495 Harrison St 1 1 1 1     13 Width 3ft   6008886.650880001 2103959.41051 37.757573472348106 -122.412276352893 (37.7575734723481, -122.412276352893)
155852 237881 2 72 400 Prospect Ave 8 9 1 1     2     6006228.09651 2097633.90585 37.7400555395259 -122.42102161048 (37.7400555395259, -122.42102161048)
158382 142479 2 72 472 UNION ST 1 1 1 1     4 Width 0ft   6010643.4105 2119643.0095 37.8007353864259 -122.407306336996 (37.8007353864259, -122.407306336996)
158642 214324 2 72 121 Miraloma Dr 1 9 1 1     4 Width 2ft   5994586.44209 2096871.4866 37.7372990050334 -122.461218135833 (37.7372990050334, -122.461218135833)
159793 58839 1 72 2385 Broadway 1 1 1 1   11/27/1979 12:00:00 AM 8   Permit Number 18096 6002233.54572 2117374.3754 37.7940320393926 -122.43624546807699 (37.7940320393926, -122.436245468077)
160536 200068 2 72 2025 Lane St 1 1 1 1     1 Width 0ft   6014532.2716 2093611.1753 37.7294745562967 -122.392027707824 (37.7294745562967, -122.392027707824)
161002 237921 2 72 1235 Noe St 1 1 1 1     4 Width 3ft   6003247.45246 2101075.30094 37.7493363397968 -122.431573074532 (37.7493363397968, -122.431573074532)
161674 60384 1 72 1400 Palou Ave 1 1 1 1 1 11/06/1982 12:00:00 AM 4   Permit Number 19964 6015915.704 2094515.2497 37.7320336750995 -122.387308043521 (37.7320336750995, -122.387308043521)
162501 237907 2 72 3911 21st St 3 17 1 1     12     6002340.71018 2103530.84091 37.75602723197329 -122.43488418855301 (37.7560272319733, -122.434884188553)
164027 237931 2 72 18 Temple St 2 2 1 1     6 Width 3ft   5999994.62286 2105880.85812 37.7623463174434 -122.443166486857 (37.7623463174434, -122.443166486857)
164953 196331 2 72 801 Arkansas St 22 9 1 1     2     6013062.01072 2103694.01523 37.757078165347096 -122.397817553962 (37.7570781653471, -122.397817553962)
165180 214347 2 72 649 Parnassus Ave 5 1 1 1     4 Width 3ft   5995088.00725 2106121.15655 37.762725118180704 -122.460153932955 (37.7627251181807, -122.460153932955)
165498 237910 2 72 414 Collingwood St 2 9 1 1     26     6002101.86364 2103432.6858200002 37.755744157774295 -122.435703175979 (37.7557441577743, -122.435703175979)
166052 135874 2 72 941 Vallejo St 5 7 1 1     14     6008901.53322 2118681.17119 37.7979967743805 -122.413265921012 (37.7979967743805, -122.413265921012)
166087 237935 2 72 272 Corbett Ave 4 17 1 1     6 Width 3ft   5999636.03267 2105332.26436 37.7608195617885 -122.444367285948 (37.7608195617885, -122.444367285948)
168000 135869 2 72 2550 Pierce St 2 1 1 1     5 Width 4ft   6001710.05375 2117173.2312 37.7934499927743 -122.43804238544901 (37.7934499927743, -122.438042385449)
169138 139121 1 72 1501 LAGUNA ST 6 1 1 1     7 Width 0ft   6004511.3378 2114128.6273 37.785249186429 -122.428132654809 (37.785249186429, -122.428132654809)
169509 196332 2 72 801 Arkansas St 23 9 1 1     2     6013061.70024 2103702.02862 37.7571001510787 -122.39781918981001 (37.7571001510787, -122.39781918981)
169961 87841 1 72 150 Golden Gate Ave 2 1 1 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008821.92164 2112867.3350299997 37.782028924727705 -122.41313008558599 (37.7820289247277, -122.413130085586)
170671 237888 2 72 1294 Stanyan St 2 1 1 1     6 Width 3ft   5997563.8752 2104944.75074 37.7596371016855 -122.451505971246 (37.7596371016855, -122.451505971246)
171158 135864 2 72 2451 Steiner St 4 1 1 1     5 Width 4ft   6002234.27154 2116544.43758 37.791753285928294 -122.43618353624201 (37.7917532859283, -122.436183536242)
171405 183467 2 72 2534 26th Ave 1 2 1 1     2 Width 0ft   5988330.845 2098043.4689 37.740154968776395 -122.482932230746 (37.7401549687764, -122.482932230746)
171658 214349 2 72 290 San Fernando Way 2 1 1 1     6 Width 3ft   5992100.51565 2094983.26623 37.7319710480083 -122.46967563014299 (37.7319710480083, -122.469675630143)
171890 196322 2 72 320 Pennsylvania Ave 2 9 1 1     8 Width 6ft   6014284.29861 2105571.05325 37.7623000976946 -122.393721759867 (37.7623000976946, -122.393721759867)
173368 237884 2 72 1229 Stanyan St 1 1 1 1     18 Width 5ft   5997429.19812 2105587.8813099996 37.761395262795794 -122.452018150436 (37.7613952627958, -122.452018150436)
174239 196324 2 72 2014 19th St 1 1 1 1     19 Width 3ft   6011723.18554 2105150.8319599996 37.761003611654 -122.40255018945 (37.761003611654, -122.40255018945)
174532 214331 3 72 100x Idora Ave 13 3 1 2     2 Width 9ft   5995540.56521 2099364.9270200003 37.7442002405496 -122.458099716827 (37.7442002405496, -122.458099716827)
174607 237938 2 72 272 Corbett Ave 7 17 1 1     4 Width 3ft   5999643.14509 2105335.6231299997 37.7608291899369 -122.44434292871 (37.7608291899369, -122.44434292871)
174855 196321 2 72 1018 Pennsylvania Ave 1 7 1 1     8 Width 6ft   6014465.23121 2102394.5848 37.753588252598796 -122.392873735151 (37.7535882525988, -122.392873735151)
175815 237928 2 72 310 Liberty St 19 2 1 1     9 Width 3ft   6004144.43295 2103938.76991 37.75724955362679 -122.428675392374 (37.7572495536268, -122.428675392374)
175828 237890 2 72 101 Bradford St 1 9 1 1     21 Width 10ft   6009586.52326 2097993.57219 37.741231849177396 -122.409434875633 (37.7412318491774, -122.409434875633)
175844 60597 1 72 839 Central Ave 1 1 1 1 1 01/07/1983 12:00:00 AM 3   Permit Number 20219 5999535.7853 2111409.5838 37.7775006284393 -122.44515092859301 (37.7775006284393, -122.445150928593)
177430 214323 2 72 211 Granville Way 1 1 1 1     6 Width 5ft   5994213.9284 2098746.3020200003 37.742425335868 -122.462642037812 (37.742425335868, -122.462642037812)
177811 214313 2 72 1630 09th Ave 1 7 1 1     12 Width 6ft   5993420.04408 2104384.15571 37.7578596869935 -122.465796566365 (37.7578596869935, -122.465796566365)
178991 237875 2 72 200 Kingston St 6 7 1 1     3     6006243.1676199995 2098035.54696 37.7411592055212 -122.420998010444 (37.7411592055212, -122.420998010444)
179437 237912 2 72 3974 22nd St 3 4 1 1     20     6002002.928859999 2102961.58207 37.7544449998516 -122.436011614667 (37.7544449998516, -122.436011614667)
179831 178849 2 72 13 Liebig St 2 1 1 1     6 Width 1ft   5995911.23484 2086261.34028 37.7082422172863 -122.455870959398 (37.7082422172863, -122.455870959398)
180365 196328 2 72 582 Rhode Island St 8 9 1 1     4     6011759.42256 2105649.40128 37.7623745948457 -122.402459919101 (37.7623745948457, -122.402459919101)
180799 135866 2 72 200 Presidio Ave 1 1 1 1     8 Width 3ft   5999037.7073 2115878.6146 37.7897429809958 -122.447195652882 (37.7897429809958, -122.447195652882)
181167 214351 2 72 100 Vista Verde Ct 11 1 1 1     11 Width 3ft   5999187.72445 2096110.16457 37.735472324573706 -122.445254715344 (37.7354723245737, -122.445254715344)
182515 178853 2 72 34 Lois Ln 1 1 1 1     1 Width 2ft   6012436.48238 2087819.01103 37.7134538649768 -122.398866750723 (37.7134538649768, -122.398866750723)
182972 135871 2 72 2550 Pierce St 4 1 1 1     4 Width 4ft   6001702.83254 2117214.86813 37.7935639062924 -122.43807035526001 (37.7935639062924, -122.43807035526)
183312 237930 2 72 4119 20th St 2 1 1 1     1 Width 3ft   6002901.50765 2104134.40267 37.75771629278479 -122.432987885294 (37.7577162927848, -122.432987885294)
184895 237880 2 72 400 Prospect Ave 7 9 1 1     4     6006230.938630001 2097643.52174 37.7400821028175 -122.42101246614901 (37.7400821028175, -122.421012466149)
186159 196326 2 72 582 Rhode Island St 6 9 1 1     5     6011758.077269999 2105655.2615900002 37.7623906108466 -122.40246498408001 (37.7623906108466, -122.40246498408)
186227 214352 2 72 50 Garcia Ave 4 2 1 1     3 Width 3ft   5995162.00455 2099364.3275 37.744176835692 -122.459408645009 (37.744176835692, -122.459408645009)
186903 214342 2 72 331 Lakeview Ave 1 4 1 1     8 Width 3ft   5996752.352000001 2089647.99235 37.7175894189894 -122.45320830242599 (37.7175894189894, -122.453208302426)
186984 113952 2 72 1416 Powell St 5 1 1 1     11 3x3   6009764.02998 2118627.67395 37.7978982689348 -122.410277642896 (37.7978982689348, -122.410277642896)
187088 237920 2 72 1237 Noe St 1 1 1 1     4 Width 3ft   6003246.872269999 2101064.36652 37.7493062835598 -122.43157430031 (37.7493062835598, -122.43157430031)
187588 196333 2 72 801 Arkansas St 24 9 1 1     3     6013061.90076 2103711.9152599997 37.757127308803604 -122.397819189808 (37.7571273088036, -122.397819189808)
188194 237882 2 72 814 Treat Ave 1 1 1 1     11 Width 3ft   6008528.1634 2103776.1584 37.7570501811472 -122.41350319182101 (37.7570501811472, -122.413503191821)
Powered by Datasette · Query took 2.373ms · Data source: data.sfgov.org