sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
168416 186800 2 54 1200 Sunset Blvd 78 9 1 1     3 Width 0ft   5984846.2035 2106925.1049 37.7643381205783 -122.495635466651 (37.7643381205783, -122.495635466651)
51976 181517 2 54 1400 Sunset Blvd 77 9 1 1     4 Width 0ft   5984871.9567 2105586.7319 37.7606648313705 -122.49544767930401 (37.7606648313705, -122.495447679304)
70132 186781 2 54 1200 Sunset Blvd 49 9 1 1     4 Width 0ft   5984857.4742 2106824.7830000003 37.764063324835796 -122.49558908498399 (37.7640633248358, -122.495589084984)
169869 186771 2 54 1200 Sunset Blvd 39 9 1 1     4 Width 0ft   5984865.2362 2106774.8154 37.7639265823683 -122.495558553205 (37.7639265823683, -122.495558553205)
178220 199651 2 54 0 37 4 1 1     0 Width 0ft   6018297.01834 2097895.80454 37.7414476037323 -122.37930996579901 (37.7414476037323, -122.379309965799)
72618 199649 2 54 1601 Evans Ave 22 4 1 1     0 Width 1ft   6015107.35337 2098882.19142 37.7439796026678 -122.390407721252 (37.7439796026678, -122.390407721252)
36431 137758 2 54 101 Saint Joseph's Ave 19 1 1 1     0 Width 0ft   6000707.9938 2112291.934 37.7799901751967 -122.44115920153799 (37.7799901751967, -122.441159201538)
113797 116339 2 54 1400X Potrero Ave 19 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
108927 116338 2 54 1400X Potrero Ave 18 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
143572 116337 2 54 1400X Potrero Ave 17 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
99135 114630 2 54 2400X Post St 16 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
144301 116336 2 54 1400X Potrero Ave 16 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
169042 141492 2 54 2901 TURK BLVD 16 1 1 1     0 Width 0ft   5996949.0657 2111520.205 37.7776563807789 -122.454107193938 (37.7776563807789, -122.454107193938)
96844 114629 2 54 2400X Post St 15 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
98178 116335 2 54 1400X Potrero Ave 15 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
89960 114628 2 54 2400X Post St 14 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
107184 116334 2 54 1400X Potrero Ave 14 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
2526 141913 2 54 900 MCALLISTER ST 13 1 1 1     0 Width 0ft   6004416.1749 2111910.2001 37.779152551854104 -122.42830372330299 (37.7791525518541, -122.428303723303)
87576 114627 2 54 2400X Post St 13 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
94078 116333 2 54 1400X Potrero Ave 13 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
173500 183897 2 54 1390 Quintara St 13 1 1 1     3 Width 0ft   5989145.605 2101022.1677 37.7483810695929 -122.480333121199 (37.7483810695929, -122.480333121199)
177826 140999 2 54 2425 GEARY BLVD 13 1 1 1     0 Width 0ft   6000127.896000001 2113280.4932 37.7826714447065 -122.44323703523399 (37.7826714447065, -122.443237035234)
71724 185834 2 54 2099 34th Ave 12 1 1 1     0 Width 0ft   5985700.3236 2100993.5674 37.7481017314756 -122.492244550883 (37.7481017314756, -122.492244550883)
73962 141419 2 54 530 IVY ST 12 1 1 1     0 Width 0ft   6004593.8117 2111048.5166 37.7767966306404 -122.42762779625099 (37.7767966306404, -122.427627796251)
83855 114626 2 54 2400X Post St 12 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
91482 116332 2 54 1400X Potrero Ave 12 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
166129 183896 2 54 1390 Quintara St 12 1 1 1     4 Width 0ft   5989127.4817 2101020.5917 37.7483756891409 -122.48039567509501 (37.7483756891409, -122.480395675095)
37652 141525 2 54 200 STANYAN ST 11 1 1 1     0 Width 0ft   5996673.9338 2111292.1171 37.7770143310958 -122.455042477562 (37.7770143310958, -122.455042477562)
51927 141418 2 54 530 IVY ST 11 1 1 1     0 Width 0ft   6004607.07 2111051.7308 37.776806205978 -122.42758216085 (37.776806205978, -122.42758216085)
52002 182469 2 54 1599 30th Ave 11 1 1 1     0 Width 0ft   5986816.8873 2104483.4967 37.757749341610705 -122.488640040992 (37.7577493416107, -122.488640040992)
72583 114625 2 54 2400X Post St 11 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
80868 116284 2 54 700X Greenwich St 11 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
97038 105091 6 54 344 Fulton St 11 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
121543 116331 2 54 1400X Potrero Ave 11 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
151138 183895 2 54 1390 Quintara St 11 1 1 1     4 Width 0ft   5989106.2065 2101019.8038 37.74837228939921 -122.480469185732 (37.7483722893992, -122.480469185732)
156661 137740 2 54 101 Saint Joseph's Ave 11 1 1 1     0 Width 0ft   6000679.5664 2112493.295 37.7805414418009 -122.441271996241 (37.7805414418009, -122.441271996241)
181306 185833 2 54 2091 34th Ave 11 1 1 1     0 Width 0ft   5985698.6694 2101072.9677 37.748319646443 -122.49225611672199 (37.748319646443, -122.492256116722)
46800 141745 2 54 1595 GEARY BLVD 10 1 1 1     0 Width 0ft   6004047.2174 2113886.8031 37.7845589275233 -122.429721115021 (37.7845589275233, -122.429721115021)
60095 137739 2 54 101 Saint Joseph's Ave 10 1 1 1     0 Width 0ft   6000676.859 2112512.2466 37.7805933238275 -122.441282722586 (37.7805933238275, -122.441282722586)
63252 183894 2 54 1390 Quintara St 10 1 1 1     4 Width 0ft   5989083.3554 2101019.0158 37.7483687977509 -122.480548145718 (37.7483687977509, -122.480548145718)
82769 108801 2 54 501-599 University St 10 1 1 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
92470 116283 2 54 700X Greenwich St 10 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
107067 116330 2 54 1400X Potrero Ave 10 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
109194 108807 2 54 401-499 University St 10 1 1 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
115978 108771 2 54 500X Lathrop Ave 10 1 1 1 1         6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
116897 108813 2 54 301-399 University St 10 1 1 1           6008160.407269999 2092653.74948 37.726489845684796 -122.41398823310301 (37.7264898456848, -122.413988233103)
121162 105090 6 54 344 Fulton St 10 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
136199 185844 2 54 2000 35th Ave 10 2 1 1     0 Width 0ft   5985416.9086 2101532.2764 37.74956430714639 -122.49326425755699 (37.7495643071464, -122.493264257557)
136289 137589 2 54 1150 PIERCE ST 10 1 1 1     0 Width 0ft   6002346.2752 2112589.0782 37.780899240130296 -122.435512922421 (37.7808992401303, -122.435512922421)
163263 141945 2 54 1101 GOLDEN GATE AVE 10 1 1 1     0 Width 0ft   6004212.2215 2112170.9783 37.7798570416861 -122.429027879664 (37.7798570416861, -122.429027879664)
28730 140456 2 54 1459 Eddy St 9 1 1 1     0 Width 0ft   6003479.0697 2112771.1641 37.7814634747388 -122.431607035931 (37.7814634747388, -122.431607035931)
31028 139809 2 54 1101 GOUGH ST 9 1 1 1     0 Width 0ft   6005660.0139 2112868.3262 37.7818536339515 -122.424068925498 (37.7818536339515, -122.424068925498)
75169 141944 2 54 1101 GOLDEN GATE AVE 9 1 1 1     0 Width 0ft   6004183.4678 2112169.0928 37.779850236925 -122.429127216952 (37.779850236925, -122.429127216952)
86041 105089 6 54 344 Fulton St 9 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
88387 116329 2 54 1400X Potrero Ave 9 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
98757 116282 2 54 700X Greenwich St 9 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
117492 115069 3 54 70 Coral Rd 9 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
134084 246372 2 54 1999 Mission St 9 1 1 1     0 Width 0ft   6006820.4847 2107009.8327 37.7658330635794 -122.41963843327801 (37.7658330635794, -122.419638433278)
135485 137588 2 54 1150 PIERCE ST 9 1 1 1     0 Width 0ft   6002345.2566 2112562.5967 37.7808264707559 -122.435514551268 (37.7808264707559, -122.435514551268)
150931 185843 2 54 2000 35th Ave 9 2 1 1     0 Width 0ft   5985418.5628 2101473.2776 37.7494024092815 -122.493254191383 (37.7494024092815, -122.493254191383)
152924 141523 2 54 200 STANYAN ST 9 1 1 1     0 Width 0ft   5996684.3575 2111222.9913 37.7768251277487 -122.455001422863 (37.7768251277487, -122.455001422863)
166203 183906 2 54 2101 22nd Ave 9 1 1 1     0 Width 0ft   5989443.8513 2100449.3142 37.7468254913409 -122.47925990315399 (37.7468254913409, -122.479259903154)
10106 173853 1 54 450 Toland St 8 1 2 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
37734 137587 2 54 1150 PIERCE ST 8 1 1 1     0 Width 0ft   6002352.8955 2112542.7356 37.78077237103221 -122.435486703411 (37.7807723710322, -122.435486703411)
42883 185830 2 54 2071 34th Ave 8 1 1 1     0 Width 0ft   5985698.118 2101152.3680000002 37.7485376258716 -122.49226386921801 (37.7485376258716, -122.492263869218)
45116 185842 2 54 2000 35th Ave 8 2 1 1     0 Width 0ft   5985421.3197 2101412.6246 37.7492360339251 -122.493240190301 (37.7492360339251, -122.493240190301)
46705 244976 2 54 201 Rose St 8 1 1 1     0 Width 0ft   6005594.1388 2109777.4773 37.773363196496895 -122.42407694938998 (37.7733631964969, -122.42407694939)
63962 141522 2 54 200 STANYAN ST 8 1 1 1     0 Width 0ft   5996688.4722 2111189.7999 37.7767342289075 -122.454984790063 (37.7767342289075, -122.454984790063)
69532 184973 2 54 2701 Sunset Blvd 8 1 1 1     0 Width 0ft   5985060.7433 2096318.9125 37.7352289790934 -122.494111677716 (37.7352289790934, -122.494111677716)
71149 142745 3 54 700x COLUMBUS AVE 8 11 1 2     0 Width 0ft   6009127.5357 2120116.4029 37.8019502507169 -122.412585395041 (37.8019502507169, -122.412585395041)
79728 108812 2 54 301-399 University St 8 1 1 1           6008160.407269999 2092653.74948 37.726489845684796 -122.41398823310301 (37.7264898456848, -122.413988233103)
83119 114623 2 54 2400X Post St 8 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
87071 115068 3 54 70 Coral Rd 8 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
93124 116328 2 54 1400X Potrero Ave 8 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
110162 108806 2 54 401-499 University St 8 1 1 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
116105 116281 2 54 700X Greenwich St 8 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
117730 108800 2 54 501-599 University St 8 1 1 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
141862 105088 6 54 344 Fulton St 8 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
149988 141161 2 54 2007 Geary Blvd 8 1 1 1     0 Width 0ft   6002005.8356 2113598.0542 37.7836502911761 -122.43676291583598 (37.7836502911761, -122.436762915836)
161855 142539 2 54 2100 POWELL ST 8 1 1 1     0 Width 0ft   6009429.9045 2121027.6379 37.80446924024871 -122.411603472126 (37.8044692402487, -122.411603472126)
182050 200501 2 54 1550 Armstrong Ave 8 1 1 1     0 Width 0ft   6014687.5837 2092287.487 37.7258485955534 -122.39139827547399 (37.7258485955534, -122.391398275474)
10092 173852 1 54 450 Toland St 7 1 2 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
22811 185829 2 54 2061 34th Ave 7 1 1 1     0 Width 0ft   5985695.3610000005 2101217.9835 37.7487176270346 -122.49227823369301 (37.7487176270346, -122.492278233693)
28402 137551 2 54 1526 Steiner St 7 1 1 1     0 Width 0ft   6002668.0924 2113464.7267 37.7833218226195 -122.434462226416 (37.7833218226195, -122.434462226416)
30940 185841 2 54 2000 35th Ave 7 2 1 1     0 Width 0ft   5985424.0767 2101308.9631 37.748951568943205 -122.493223020907 (37.7489515689432, -122.493223020907)
40764 186526 2 54 1501 Sunset Blvd 7 2 1 1     0 Width 0ft   5984782.9201 2104548.9278 37.7578100967767 -122.495679060793 (37.7578100967767, -122.495679060793)
61664 245454 2 54 2700 16th St 7 1 1 1     0 Width 0ft   6008487.3357 2106844.226 37.765472098116796 -122.41386141193001 (37.7654720981168, -122.41386141193)
73809 139018 2 54 2569 SUTTER ST 7 1 1 1     0 Width 0ft   6000314.1665 2114058.3378 37.784817825136706 -122.44264848882601 (37.7848178251367, -122.442648488826)
74459 137586 2 54 1150 PIERCE ST 7 1 1 1     0 Width 0ft   6002357.4789 2112504.0318 37.7806663604621 -122.435468077701 (37.7806663604621, -122.435468077701)
97624 114622 2 54 2400X Post St 7 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
113187 115067 3 54 70 Coral Rd 7 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
113454 108799 2 54 501-599 University St 7 1 1 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
118898 116327 2 54 1400X Potrero Ave 7 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
120796 105087 6 54 344 Fulton St 7 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
125482 116947 2 54 3676 23RD ST 7 1 1 1       3x3   6005238.0 2102584.0 37.753591501312705 -122.424797029407 (37.7535915013127, -122.424797029407)
140188 116280 2 54 700X Greenwich St 7 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
168746 142538 2 54 2100 POWELL ST 7 1 1 1     0 Width 0ft   6009433.1509 2121013.8406 37.8044315384071 -122.41159126219999 (37.8044315384071, -122.4115912622)
172874 139933 2 54 800 GOUGH ST 7 1 1 1     0 Width 0ft   6005708.0541 2112525.3709 37.7809146750444 -122.42387833426001 (37.7809146750444, -122.42387833426)
179050 186412 2 54 1601 Sunset Blvd 7 2 1 1     0 Width 0ft   5984810.0324 2103749.2702 37.7556160465723 -122.49552631838101 (37.7556160465723, -122.495526318381)
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
10097 173851 1 54 450 Toland St 6 1 2 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
Powered by Datasette · Query took 18.055ms · Data source: data.sfgov.org