sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2707 14854 3 72 1357 McAllister St 1 1 1 2   05/21/1992 12:00:00 AM 6 3x3   6002671.377 2111611.0853 37.7782323757584 -122.43431829621201 (37.7782323757584, -122.434318296212)
16525 18547 9 72 1700X Quesada Ave 2 11 1 2     30 19   6014668.27449 2095058.7142299998 37.733456755021 -122.391658696189 (37.733456755021, -122.391658696189)
6567 18905 3 72 2602 Sacramento St 1 1 1 2     6 3X3   6002286.89222 2115779.97328 37.789657253131 -122.435946744753 (37.789657253131, -122.435946744753)
6873 23463 3 72 2300 Van Ness Ave 1 11 1 2     12 9   6005896.8378 2118341.60488 37.7968952622641 -122.423638887645 (37.7968952622641, -122.423638887645)
15860 26103 3 72 1557 Oakdale Ave 1 1 1 2   07/22/1988 12:00:00 AM 12 3x3   6015264.4135 2095277.0122 37.734089230154204 -122.38961289841002 (37.7340892301542, -122.38961289841)
6012 27414 3 72 2300 Van Ness Ave 2 11 1 2     12 9   6005892.4011 2118361.12861 37.7969486190501 -122.42365562852801 (37.7969486190501, -122.423655628528)
8282 27415 3 72 2300 Van Ness Ave 3 11 1 2     12 9   6005889.8891 2118381.22689 37.7970036620469 -122.423665750374 (37.7970036620469, -122.423665750374)
17124 29888 3 72 1126 Guerrero St 1 1 1 2     25 3x3   6005721.57126 2102405.52669 37.7531287556897 -122.42311204680901 (37.7531287556897, -122.423112046809)
53128 51089 1 72 2550 Pierce St 1 1 1 1   07/26/2004 12:00:00 AM 6   Permit Number 47546 6001713.34736 2117152.10978 37.7933921861489 -122.438029475688 (37.7933921861489, -122.438029475688)
38807 58192 1 72 707 10th Ave 1 1 1 1   05/02/1978 12:00:00 AM 10   Permit Number 17180 5992850.41876 2110607.08647 37.7749133313412 -122.468219240401 (37.7749133313412, -122.468219240401)
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)
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)
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)
57900 68433 1 72 2518 Jackson St 1 1 1 1   08/26/1993 12:00:00 AM 3   Permit Number 32286 6002013.47223 2116725.04565 37.7922366418513 -122.436960435397 (37.7922366418513, -122.436960435397)
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)
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)
37992 87842 1 72 150 Golden Gate Ave 3 1 1 1   06/06/2008 12:00:00 AM 5 3x3 Permit Number 50723 6008797.68605 2112863.51271 37.7820170689709 -122.41321365958099 (37.7820170689709, -122.413213659581)
7597 98002 2 72 1904 Filbert St 1 1 1 1     8 4x12   6003787.47736 2119037.49851 37.7986867144679 -122.430987461215 (37.7986867144679, -122.430987461215)
285 98003 2 72 1904 Filbert St 2 1 1 1     10 4x12   6003782.57859 2119037.12075 37.7986853996597 -122.431004385541 (37.7986853996597, -122.431004385541)
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)
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)
32055 116119 2 72 1649x Newhall St 1 1 1 1     8 2x2   6014063.167280001 2095217.05774 37.7338579263887 -122.393761818374 (37.7338579263887, -122.393761818374)
29426 117740 2 72 475 39th Ave 2 2 1 1     3 Width 4ft   5983746.49746 2112674.00016 37.7800584750229 -122.499863945897 (37.7800584750229, -122.499863945897)
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)
46324 135861 2 72 5 Dicha Aly 2 2 1 1     1 Width 2ft   5998316.32407 2113776.61007 37.783930185978704 -122.44954003254999 (37.7839301859787, -122.44954003255)
36891 135862 2 72 8 Kimball Pl 2 1 1 1     2 Width 4ft   6008000.712730001 2116486.83875 37.791921065252204 -122.416227532369 (37.7919210652522, -122.416227532369)
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)
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)
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)
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)
39539 135867 2 72 2881 Vallejo St 1 1 1 1     3 Width 4ft   5999809.285519999 2117392.98346 37.7939450956373 -122.44463496643401 (37.7939450956373, -122.444634966434)
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)
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)
53560 135870 2 72 2550 Pierce St 3 1 1 1     3 Width 4ft   6001706.98139 2117190.01379 37.7934958986807 -122.438054218747 (37.7934958986807, -122.438054218747)
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)
60540 135872 2 72 2550 Pierce St 5 1 1 1     5 Width 4ft   6001695.18556 2117280.97246 37.7937449767048 -122.43810155185601 (37.7937449767048, -122.438101551856)
153689 135873 2 72 1002 Vallejo St 1 13 1 1     10     6008628.64799 2118672.57502 37.7979578472257 -122.414209576908 (37.7979578472257, -122.414209576908)
166052 135874 2 72 941 Vallejo St 5 7 1 1     14     6008901.53322 2118681.17119 37.7979967743805 -122.413265921012 (37.7979967743805, -122.413265921012)
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)
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)
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)
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)
32056 178850 2 72 178 Dublin St 1 9 1 1     11 Width 5ft   6004207.2935 2089409.6566400002 37.7173594632439 -122.427422984776 (37.7173594632439, -122.427422984776)
61323 178851 2 72 642 Madrid St 1 1 1 1     11 Width 2ft   6002153.25457 2090190.2605700002 37.719386440714004 -122.43457861601101 (37.719386440714, -122.434578616011)
43929 178852 2 72 642 Moscow St 1 1 1 1     1 Width 1ft   6003293.17352 2089466.63658 37.71746417401 -122.43058673410299 (37.71746417401, -122.430586734103)
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)
41254 178854 2 72 401 Leland Ave 1 1 1 1     4 Width 3ft   6008573.82268 2088029.4794 37.7138157809362 -122.41223237962099 (37.7138157809362, -122.412232379621)
32673 178855 2 72 1101 Girard St 2 1 1 1     9 Width 3ft   6011864.77985 2089786.97938 37.718825637867205 -122.400980956107 (37.7188256378672, -122.400980956107)
28120 178856 2 72 121 Delta St 1 17 1 1     18     6009824.00265 2088991.8165400003 37.71652823335621 -122.407979098955 (37.7165282333562, -122.407979098955)
37563 178857 2 72 701 Delta St 4 9 1 1     12 Width 3ft   6009291.72599 2087274.3379400002 37.711782574777004 -122.409697761866 (37.711782574777, -122.409697761866)
36992 181899 2 72 2374 28th Ave 1 1 1 1     6 Width 0ft   5987671.9860000005 2099129.3564 37.7430981701656 -122.48528992840201 (37.7430981701656, -122.485289928402)
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)
61362 182193 2 72 2830 Lawton St 1 1 1 1     1 Width 0ft   5985470.896000001 2104355.1387 37.757318269846394 -122.49328551153499 (37.7573182698464, -122.493285511535)
33471 182339 2 72 3081 Kirkham St 1 2 1 1     1 Width 0ft   5985312.4034 2104975.8588 37.759013323653 -122.493879375972 (37.759013323653, -122.493879375972)
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)
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)
65313 183563 2 72 2593 30th Ave 2 2 1 1     5 Width 0ft   5987056.9644 2097643.917 37.738983699378096 -122.487307395263 (37.7389836993781, -122.487307395263)
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)
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)
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)
47913 196323 2 72 1922 23rd St 1 7 1 1     3     6012591.21229 2102864.69613 37.7547748064319 -122.399387546319 (37.7547748064319, -122.399387546319)
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)
60249 196325 2 72 582 Rhode Island St 5 9 1 1     4     6011758.16915 2105659.78061 37.7624030241958 -122.402464984075 (37.7624030241958, -122.402464984075)
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)
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)
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)
66220 196329 2 72 582 Rhode Island St 9 9 1 1     4     6011758.91837 2105646.20338 37.7623657859795 -122.402461438042 (37.7623657859795, -122.402461438042)
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)
164953 196331 2 72 801 Arkansas St 22 9 1 1     2     6013062.01072 2103694.01523 37.757078165347096 -122.397817553962 (37.7570781653471, -122.397817553962)
169509 196332 2 72 801 Arkansas St 23 9 1 1     2     6013061.70024 2103702.02862 37.7571001510787 -122.39781918981001 (37.7571001510787, -122.39781918981)
187588 196333 2 72 801 Arkansas St 24 9 1 1     3     6013061.90076 2103711.9152599997 37.757127308803604 -122.397819189808 (37.7571273088036, -122.397819189808)
37189 196334 2 72 185 Hampshire St 2 10 1 1     8 Width 5ft   6010020.7902 2107448.7072099997 37.767217864928206 -122.408600163592 (37.7672178649282, -122.408600163592)
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)
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)
62511 202088 2 72 1 Gould St 16 2 1 1     7     6012849.75876 2091137.38485 37.722588475066 -122.397670917693 (37.722588475066, -122.397670917693)
41869 214310 2 72 1870 19th Ave 1 1 1 1     9 Width 1ft   5990380.69599 2102646.45339 37.752912626128705 -122.476180871663 (37.7529126261287, -122.476180871663)
62421 214311 2 72 1616 09th Ave 1 7 1 1     8 Width 6ft   5993417.73262 2104465.9003 37.7580840030825 -122.46581049954901 (37.7580840030825, -122.465810499549)
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)
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)
56030 214314 2 72 1630 09th Ave 2 7 1 1     10 Width 6ft   5993419.49404 2104375.41426 37.7578356535119 -122.465797833501 (37.7578356535119, -122.465797833501)
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)
64453 214316 2 72 1898 08th Ave 3 1 1 1     2 Width 3ft   5993790.06824 2102612.96107 37.7530177802481 -122.464388282898 (37.7530177802481, -122.464388282898)
57881 214317 2 72 20 Belmont Ave 10 2 1 1     21     5996726.67758 2106195.56131 37.763023532129004 -122.454491761784 (37.763023532129, -122.454491761784)
55084 214318 2 72 16 Belmont Ave 1 2 1 1     9     5996661.1210199995 2106238.0269400002 37.763136371875895 -122.454721566453 (37.7631363718759, -122.454721566453)
55556 214319 2 72 109 Edgewood Ave 4 1 1 1     1 Width 2ft   5996574.94596 2106340.51258 37.7634128279669 -122.455027021201 (37.7634128279669, -122.455027021201)
137397 214320 2 72 1518 05th Ave 4 10 1 1     4     5994627.9467 2105254.67875 37.7603195216609 -122.46168228042801 (37.7603195216609, -122.461682280428)
43791 214321 2 72 166 Lomita Ave 1 1 1 1     10 Width 3ft   5991310.02713 2104174.00205 37.757160720399796 -122.47307849028601 (37.7571607203998, -122.473078490286)
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)
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)
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)
62287 214325 2 72 121 Miraloma Dr 2 9 1 1     4 Width 2ft   5994585.09435 2096884.89716 37.7373357495539 -122.461223767378 (37.7373357495539, -122.461223767378)
39041 214326 2 72 121 Miraloma Dr 3 9 1 1     4 Width 2ft   5994581.43196 2096914.1717599998 37.7374159195969 -122.461238551316 (37.7374159195969, -122.461238551316)
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)
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)
51364 214329 3 72 100x Idora Ave 11 3 1 2     11 Width 9ft   5995487.46893 2099377.84768 37.744232666505106 -122.45828424602301 (37.7442326665051, -122.458284246023)
38489 214330 3 72 100x Idora Ave 12 3 1 2     10 Width 9ft   5995527.4625 2099368.48178 37.7442092481691 -122.458145280077 (37.7442092481691, -122.458145280077)
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)
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)
23870 214333 2 72 312 Hearst Ave 6 9 1 1     4 Width 10ft   5999316.02125 2094400.93218 37.7307864969836 -122.44468833131901 (37.7307864969836, -122.444688331319)
57629 214334 2 72 470 Hearst Ave 1 9 1 1     2 Width 10ft   5998312.15542 2094413.4318799998 37.7307634815435 -122.448159739578 (37.7307634815435, -122.448159739578)
74387 214335 2 72 570 Hearst Ave 1 9 1 1     4     5997650.4841 2094424.8417 37.730756962361 -122.450448052843 (37.730756962361, -122.450448052843)
Powered by Datasette · Query took 4.962ms · Data source: data.sfgov.org