sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
134794 219325 2 19 1090 Capitol Ave 11 9 1 1     6 Width 1ft   5995080.6810800005 2091195.9220900002 37.721743712182395 -122.459098491296 (37.7217437121824, -122.459098491296)
37643 219320 2 19 1090 Capitol Ave 6 9 1 1     5 Width 1ft   5995079.65544 2091128.71847 37.7215591281313 -122.459097172915 (37.7215591281313, -122.459097172915)
153552 219315 2 19 1200 Capitol Ave 1 9 1 1     8 Width 1ft   5995096.96866 2091948.28525 37.7238104576833 -122.459096640518 (37.7238104576833, -122.459096640518)
35316 219317 2 19 1200 Capitol Ave 3 9 1 1     13 Width 1ft   5995097.23073 2091960.8022599998 37.7238448414569 -122.45909664051001 (37.7238448414569, -122.45909664051)
147427 219316 2 19 1200 Capitol Ave 2 9 1 1     11 Width 1ft   5995097.3414 2091954.20903 37.7238267443906 -122.45909578075899 (37.7238267443906, -122.459095780759)
147731 219334 2 19 800 Capitol Ave 3 9 1 1     7 Width 10ft   5995082.86973 2089689.0619599998 37.717606358621104 -122.45898187623001 (37.7176063586211, -122.45898187623)
162915 219279 2 19 59 Marne Ave 1 9 1 1     18 Width 10ft   5995277.33246 2097610.05281 37.7393666624493 -122.458882882444 (37.7393666624493, -122.458882882444)
171560 219327 2 19 101 Miramar Ave 2 9 1 1     10 Width 4ft   5995301.64396 2090617.7903200001 37.720169000171296 -122.458292861552 (37.7201690001713, -122.458292861552)
172065 219328 2 19 101 Miramar Ave 3 9 1 1     8 Width 4ft   5995301.79244 2090610.0663299998 37.720147800462996 -122.458291789543 (37.720147800463, -122.458291789543)
187057 219326 2 19 101 Miramar Ave 1 9 1 1     10 Width 4ft   5995302.40607 2090624.5686700002 37.7201876557032 -122.45829071756701 (37.7201876557032, -122.458290717567)
39633 219241 2 19 19 Miramar Ave 1 2 1 1     7 Width 3ft   5995302.14694 2090052.41762 37.7186166498261 -122.458250223781 (37.7186166498261, -122.458250223781)
65273 219243 2 19 19 Miramar Ave 4 2 1 1     6 Width 3ft   5995302.33675 2090036.07608 37.718571790736796 -122.45824838556601 (37.7185717907368, -122.458248385566)
53868 219242 2 19 19 Miramar Ave 3 2 1 1     11 Width 3ft   5995302.90929 2090039.9744900002 37.718582527746705 -122.45824668854799 (37.7185825277467, -122.458246688548)
62283 219329 2 19 100 Miramar Ave 1 9 1 1     6 Width 4ft   5995365.77553 2090599.7710099998 37.7201232084876 -122.45806987824699 (37.7201232084876, -122.458069878247)
90274 97299 1 19 1051 Portola Dr 2 9 1 1           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865)
93609 124569 2 19 1 Jordan Ave 1 9 1 1     6 Width 3ft   5996154.91779 2114511.96286 37.785825384071394 -122.457070865676 (37.7858253840714, -122.457070865676)
80360 110171 2 19 901 MONTEREY BLVD 1 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
94629 110173 2 19 901 MONTEREY BLVD 3 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
120525 110172 2 19 901 MONTEREY BLVD 2 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
122726 110174 2 19 901 MONTEREY BLVD 4 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
127293 110175 2 19 901 MONTEREY BLVD 5 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
159174 124497 2 19 2700 Golden Gate Ave 2 9 1 1     20 Width 3ft   5996600.75625 2111319.20262 37.7770845024867 -122.45529757783001 (37.7770845024867, -122.45529757783)
145739 176592 2 19 2249 Cayuga Ave 2 9 1 1     12 Width 10ft   5996118.04902 2086754.98706 37.70960952494271 -122.455191839948 (37.7096095249427, -122.455191839948)
61159 129163 2 19 101 Parker Ave 1 9 1 1     18 Width 2ft   5996819.747219999 2113790.05212 37.783881366273704 -122.45471857981701 (37.7838813662737, -122.454718579817)
92201 176628 2 19 3067 Alemany Blvd 1 9 1 1     7 Width 1ft   5996456.31752 2087068.2457400002 37.7104890628041 -122.454045341035 (37.7104890628041, -122.454045341035)
28089 94904 1 19 3701 Clay St 3 1 1 1     7 3x3   5997050.00292 2115323.90542 37.788106124051 -122.454032799976 (37.788106124051, -122.454032799976)
146538 129154 2 19 3701 Clay St 6 9 1 1     9 Width 3ft   5997094.15326 2115332.00999 37.7881309084546 -122.45388063381 (37.7881309084546, -122.45388063381)
166898 129156 2 19 341 Spruce St 1 9 1 1     17 Width 1ft   5997126.0863 2115169.43249 37.7876863448031 -122.453758406952 (37.7876863448031, -122.453758406952)
152524 219341 2 19 176 Margaret Ave 1 2 1 1     5 Width 10ft   5996604.57651 2089160.1054 37.7162413244539 -122.45368388192101 (37.7162413244539, -122.453683881921)
9555 105225 5 19 175 Spruce St 1 7 1 1     9     5997195.09596 2114417.64894 37.785626103218895 -122.453465347546 (37.7856261032189, -122.453465347546)
24727 129157 2 19 175 Spruce St 2 10 1 1     8 Width 3ft   5997198.13027 2114418.3589 37.785628226512706 -122.45345490104499 (37.7856282265127, -122.453454901045)
154596 206928 2 19 304 Ridgewood Ave 1 9 1 1     8 Width 3ft   5996825.61506 2095044.14156 37.7324101663 -122.453344433724 (37.7324101663, -122.453344433724)
162896 206930 2 19 304 Ridgewood Ave 3 9 1 1     6 Width 3ft   5996825.98874 2095054.21648 37.73243785103 -122.45334386894699 (37.73243785103, -122.453343868947)
160615 206929 2 19 304 Ridgewood Ave 2 9 1 1     7 Width 3ft   5996825.89712 2095049.8275 37.7324257946933 -122.453343868941 (37.7324257946933, -122.453343868941)
134411 206931 2 19 304 Ridgewood Ave 4 9 1 1     3 Width 3ft   5996826.10073 2095059.5810599998 37.7324525872975 -122.453343868939 (37.7324525872975, -122.453343868939)
41466 206932 2 19 304 Ridgewood Ave 5 9 1 1     8 Width 3ft   5996826.20254 2095064.45784 37.732465983599894 -122.453343868921 (37.7324659835999, -122.453343868921)
174519 219302 2 19 594 Flood Ave 4 9 1 1     15 Width 4ft   5996831.65871 2094146.3639099998 37.7299454303374 -122.453258748999 (37.7299454303374, -122.453258748999)
53053 219245 2 19 16 Lobos St 1 10 1 1     6 Width 2ft   5996729.7413 2088712.5742099998 37.7150196826824 -122.45321896478501 (37.7150196826824, -122.453218964785)
173921 219301 2 19 594 Flood Ave 3 9 1 1     26 Width 4ft   5996849.44073 2094145.99272 37.729945430323895 -122.453197247977 (37.7299454303239, -122.453197247977)
159319 250161 2 19 721 Parker Ave 1 9 1 1     20 Width 7ft   5997228.87455 2110733.66678 37.7755127924135 -122.45308245310301 (37.7755127924135, -122.453082453103)
36939 250162 2 19 721 Parker Ave 2 9 1 1     9 Width 7ft   5997228.928169999 2110728.99929 37.7754999797735 -122.45308193061301 (37.7754999797735, -122.453081930613)
172423 250164 2 19 721 Parker Ave 4 9 1 1     6 Width 7ft   5997230.43639 2110716.53529 37.7754658433095 -122.453075813411 (37.7754658433095, -122.453075813411)
175121 250163 2 19 721 Parker Ave 3 9 1 1     8 Width 7ft   5997230.95701 2110719.49417 37.775473997461205 -122.453074226111 (37.7754739974612, -122.453074226111)
171741 250165 2 19 721 Parker Ave 5 9 1 1     14 Width 7ft   5997232.24252 2110715.01845 37.7754617819717 -122.453069456091 (37.7754617819717, -122.453069456091)
173752 250166 2 19 721 Parker Ave 6 9 1 1     4 Width 7ft   5997232.8241 2110704.1079599997 37.7754318579352 -122.453066656515 (37.7754318579352, -122.453066656515)
55387 250167 2 19 721 Parker Ave 7 9 1 1     11 Width 7ft   5997232.75579 2110698.69263 37.775416984933 -122.453066501815 (37.775416984933, -122.453066501815)
166248 250168 2 19 721 Parker Ave 8 9 1 1     24 Width 7ft   5997236.19535 2110687.93342 37.775387640062796 -122.45305382679399 (37.7753876400628, -122.453053826794)
39084 250169 2 19 721 Parker Ave 10 9 1 1     15 Width 7ft   5997237.65706 2110666.34039 37.7753284349893 -122.453047211372 (37.7753284349893, -122.453047211372)
68885 250171 2 19 721 Parker Ave 12 9 1 1     7 Width 7ft   5997238.11076 2110659.10553 37.7753085959468 -122.45304511956002 (37.7753085959468, -122.45304511956)
42535 250173 2 19 721 Parker Ave 14 9 1 1     4 Width 7ft   5997239.18442 2110648.2538799997 37.7752788616692 -122.453040622039 (37.7752788616692, -122.453040622039)
169522 250170 2 19 721 Parker Ave 11 9 1 1     10 Width 7ft   5997240.0055 2110662.97968 37.7753193419419 -122.453038844971 (37.7753193419419, -122.453038844971)
36832 250172 2 19 721 Parker Ave 13 9 1 1     20 Width 7ft   5997240.90305 2110650.9273599996 37.775286300843796 -122.45303486996401 (37.7752863008438, -122.453034869964)
55652 250174 2 19 721 Parker Ave 15 9 1 1     20 Width 7ft   5997242.00203 2110645.63605 37.7752718352644 -122.45303068632299 (37.7752718352644, -122.453030686323)
155003 250175 2 19 721 Parker Ave 16 9 1 1     25 Width 7ft   5997242.30788 2110631.32988 37.7752325717698 -122.453028595406 (37.7752325717698, -122.453028595406)
59420 249634 2 19 2550 Golden Gate Ave 1 9 1 1     21 Width 4ft   5997294.55506 2111271.9763700003 37.776994614336 -122.452894113492 (37.776994614336, -122.452894113492)
107819 114704 2 19 524 Staples Ave 2 1 1 1           5996948.70097149 2093858.06219815 37.729160530354 -122.452833321223 (37.729160530354, -122.452833321223)
177708 176591 2 19 170 Lawrence Ave 2 9 1 1     5 Width 2ft   5996818.41137 2087266.2974900003 37.711053623008 -122.45280815898501 (37.711053623008, -122.452808158985)
40551 129159 2 19 135 Mayfair Dr 1 9 1 1     4 Width 4ft   5997408.66924 2114451.98586 37.785732623419 -122.452728928703 (37.785732623419, -122.452728928703)
177565 129160 2 19 135 Mayfair Dr 2 9 1 1     5 Width 4ft   5997418.31681 2114452.99804 37.7857359554012 -122.45269562410401 (37.7857359554012, -122.452695624104)
34985 129161 2 19 135 Mayfair Dr 3 9 1 1     5 Width 4ft   5997429.44136 2114454.7075099996 37.7857412865759 -122.452657259939 (37.7857412865759, -122.452657259939)
179462 129162 2 19 135 Mayfair Dr 4 9 1 1     5 Width 4ft   5997439.9594 2114456.55083 37.7857469505036 -122.452621003773 (37.7857469505036, -122.452621003773)
184432 219244 2 19 4 Farallones St 2 9 1 1     9 Width 2ft   5996960.480830001 2088401.3270400001 37.7141782922784 -122.452398988125 (37.7141782922784, -122.452398988125)
55719 110572 2 19 46 COOK ST 4 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
78535 110569 2 19 46 COOK ST 1 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
107354 110571 2 19 46 COOK ST 3 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
124373 110570 2 19 46 COOK ST 2 1 1 1     15     5997534.0 2113434.0 37.782944683725 -122.45222184269899 (37.782944683725, -122.452221842699)
61449 219253 2 19 449 Melrose Ave 2 9 1 1     3     5997174.7237 2095517.45722 37.7337297819926 -122.452171628738 (37.7337297819926, -122.452171628738)
171687 219254 2 19 449 Melrose Ave 3 9 1 1     4     5997174.97013 2095514.3444599998 37.7337212492173 -122.452170552242 (37.7337212492173, -122.452170552242)
47046 206921 2 19 638 Mangels Ave 1 9 1 1     12 Width 8ft   5997199.5508 2095299.8270400001 37.7331336438848 -122.452070097972 (37.7331336438848, -122.452070097972)
117763 110393 6 19 451 LOS PALMOS DR 1 5 1 1       3x8   5997298.0 2095759.0 37.7344000615683 -122.45176284684601 (37.7344000615683, -122.451762846846)
43916 249625 2 19 2450 Golden Gate Ave 3 9 1 1     19 Width 7ft   5997639.79528 2111322.31201 37.777152600940106 -122.451703458765 (37.7771526009401, -122.451703458765)
153125 249624 2 19 2450 Golden Gate Ave 2 9 1 1     18 Width 7ft   5997651.05189 2111322.51448 37.777153801533295 -122.451664533393 (37.7771538015333, -122.451664533393)
130965 249623 2 19 2450 Golden Gate Ave 1 9 1 1     21 Width 7ft   5997659.54255 2111324.05825 37.7771585265736 -122.451635273045 (37.7771585265736, -122.451635273045)
186803 226887 2 19 1266 Stanyan St 1 1 1 1     21 Width 3ft   5997536.57649 2105194.59271 37.7603215415281 -122.451618405363 (37.7603215415281, -122.451618405363)
187209 206920 2 19 411 Melrose Ave 1 9 1 1     2     5997366.58572 2095512.9448099998 37.7337283808453 -122.45150798300399 (37.7337283808453, -122.451507983004)
136885 219304 2 19 518 Flood Ave 6 9 1 1     6 Width 1ft   5997397.71686 2094138.95075 37.72995750373521 -122.45130129363501 (37.7299575037352, -122.451301293635)
161526 219303 2 19 518 Flood Ave 5 9 1 1     6 Width 1ft   5997404.84982 2094139.1246200001 37.729958389564295 -122.451276646793 (37.7299583895643, -122.451276646793)
46315 206948 2 19 422 Judson Ave 1 9 1 1     10 Width 5ft   5997397.5658599995 2093594.47343 37.7284624896392 -122.451262563442 (37.7284624896392, -122.451262563442)
167821 219239 2 19 579 Hearst Ave 2 9 1 1     6     5997578.77584 2094371.8563299999 37.7306073727237 -122.450692139651 (37.7306073727237, -122.450692139651)
148022 129158 2 19 280 Euclid Ave 1 9 1 1     14 Width 4ft   5998011.3909 2113983.2225200003 37.784480040475394 -122.45060988493401 (37.7844800404754, -122.450609884934)
157403 226885 2 19 1577 Shrader St 1 1 1 1     19 Width 4ft   5997889.74449 2105168.82757 37.760271015821296 -122.450395110664 (37.7602710158213, -122.450395110664)
159101 226886 2 19 1577 Shrader St 2 1 1 1     16 Width 4ft   5997890.66163 2105156.29016 37.760236643732796 -122.450391034916 (37.7602366437328, -122.450391034916)
60078 206943 2 19 359 Staples Ave 1 9 1 1     18 Width 10ft   5997695.93457 2093782.21524 37.728995063674105 -122.45024461989401 (37.7289950636741, -122.450244619894)
53919 218142 2 19 55 Ridge Ln 1 2 1 1     15 Width 8ft   5997830.51947 2089772.1428 37.717992043688895 -122.449490525783 (37.7179920436889, -122.449490525783)
164120 176827 2 19 1791 Cayuga Ave 1 9 1 1     8 Width 5ft   5997883.80423 2088433.1189700002 37.7143184408223 -122.44920992919799 (37.7143184408223, -122.449209929198)
149561 249609 2 19 2310 Golden Gate Ave 1 4 1 1     8 Width 2ft   5998473.33255 2111438.47015 37.7775192428532 -122.448828371134 (37.7775192428532, -122.448828371134)
134298 219306 2 19 148 Foerster St 3 9 1 1     10 Width 6ft   5998127.52225 2094054.8497 37.729768343017504 -122.44877222468 (37.7297683430175, -122.44877222468)
154574 219240 2 19 148 Foerster St 1 9 1 1     12 Width 6ft   5998128.33094 2094040.49389 37.729728971597794 -122.448768395353 (37.7297289715978, -122.448768395353)
151185 219248 2 19 580 Joost Ave 6 9 1 1     7 Width 2ft   5998168.32252 2095019.32726 37.7324189032047 -122.448700613456 (37.7324189032047, -122.448700613456)
73406 219296 2 19 381 Flood Ave 4 9 1 1     5 Width 10ft   5998149.50301 2094066.8230299999 37.7298024758953 -122.44869709712 (37.7298024758953, -122.44869709712)
177130 219295 2 19 480 Hearst Ave 10 9 1 1     12 Width 2ft   5998167.2791 2094421.20794 37.730776549584704 -122.44866115748998 (37.7307765495847, -122.44866115749)
158971 219297 2 19 381 Flood Ave 6 9 1 1     5 Width 10ft   5998167.92855 2094066.7216400001 37.7298032511049 -122.44863339092899 (37.7298032511049, -122.448633390929)
71408 219298 2 19 381 Flood Ave 9 9 1 1     4 Width 10ft   5998181.253169999 2094066.7264900003 37.729804026324 -122.448587326764 (37.729804026324, -122.448587326764)
77183 219299 2 19 381 Flood Ave 10 9 1 1     3 Width 10ft   5998187.186480001 2094065.75594 37.7298017006839 -122.44856674485901 (37.7298017006839, -122.448566744859)
66211 219294 2 19 480 Hearst Ave 6 9 1 1     8 Width 2ft   5998210.07192 2094421.64133 37.7307801864365 -122.44851324778799 (37.7307801864365, -122.448513247788)
24254 219293 2 19 480 Hearst Ave 5 9 1 1     7 Width 2ft   5998219.47976 2094421.4454299998 37.7307801864506 -122.448480709434 (37.7307801864506, -122.448480709434)
72467 206917 2 19 578 Joost Ave 1 9 1 1     12 Width 2ft   5998254.61477 2095017.4166400002 37.7324185911375 -122.448402144659 (37.7324185911375, -122.448402144659)
61343 129164 2 19 75 Emerson St 1 9 1 1     13 Width 8ft   5998679.83386 2113409.66692 37.7829434444333 -122.448255995832 (37.7829434444333, -122.448255995832)
129500 129165 2 19 75 Emerson St 3 9 1 1     7 Width 8ft   5998683.20091 2113396.5400099996 37.7829075938537 -122.448243401733 (37.7829075938537, -122.448243401733)
69431 219404 2 19 471 Mangels Ave 2 9 1 1     8 Width 3ft   5998306.28146 2095220.78528 37.7329799470492 -122.448238160486 (37.7329799470492, -122.448238160486)
46288 129166 2 19 75 Emerson St 4 9 1 1     10 Width 8ft   5998684.61281 2113379.65213 37.782861304856894 -122.448237300713 (37.7828613048569, -122.448237300713)
Powered by Datasette · Query took 9.89ms · Data source: data.sfgov.org