sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
48038 176133 2 47 800 John Muir Dr 1 4 1 1     10 Width 0ft   5987205.94604 2086467.2590400001 37.708304151783295 -122.48597211903099 (37.7083041517833, -122.485972119031)
59353 176135 2 47 800 John Muir Dr 3 4 1 1     13 Width 0ft   5987227.516530001 2086480.11804 37.7083407164149 -122.485898513129 (37.7083407164149, -122.485898513129)
62380 176134 2 47 800 John Muir Dr 2 4 1 1     16 Width 0ft   5987222.73644 2086464.9299599999 37.7082987351809 -122.48591391940901 (37.7082987351809, -122.485913919409)
160483 176136 2 47 800 John Muir Dr 4 4 1 1     11 Width 0ft   5987247.74108 2086476.2363 37.7083312366754 -122.48582833093599 (37.7083312366754, -122.485828330936)
161785 176137 2 47 800 John Muir Dr 5 4 1 1     11 Width 0ft   5987255.345 2086484.45942 37.708354258405 -122.485802654386 (37.708354258405, -122.485802654386)
50152 113698 3 47 80 LINARES AVE 1 2 1 2           5994154.8 2102090.7 37.75160480205479 -122.46308908916401 (37.7516048020548, -122.463089089164)
69136 223812 2 47 80 Digby St 3 9 1 1     45 Width 10ft   6002658.76946 2097725.72103 37.740105791847704 -122.43336942626101 (37.7401057918477, -122.433369426261)
172875 223813 2 47 80 Digby St 4 9 1 1     46 Width 10ft   6002637.262130001 2097732.72749 37.740123809771 -122.43344429032301 (37.740123809771, -122.433444290323)
186743 223811 2 47 80 Digby St 1 9 1 1     49 Width 7ft   6002713.41805 2097728.02904 37.7401152293236 -122.433180638776 (37.7401152293236, -122.433180638776)
35760 223799 2 47 8 Laidley St 1 9 1 1     34     6003000.19412 2098305.51493 37.741717135947205 -122.43223031618601 (37.7417171359472, -122.432230316186)
137094 223733 2 47 799 Duncan St 7 9 1 1     3 Width 4ft   6001506.768759999 2099670.7244 37.7453808903115 -122.43749181510401 (37.7453808903115, -122.437491815104)
67489 223788 2 47 798 Sanchez St 1 9 1 1     48 Width 3ft   6003684.1064 2103653.23065 37.7564394677117 -122.430247009802 (37.7564394677117, -122.430247009802)
108304 41202 1 47 79 Midcrest Way 1 1 1 1         Permit Number 53043 5998096.00481154 2100748.3020607 37.748145150880795 -122.44936325399401 (37.7481451508808, -122.449363253994)
1736 251677 2 47 772x Panorama Dr 1 9 1 1       3x3   5996636.0 2102785.0 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212)
76219 248488 2 47 772 Ashbury St 1 1 1 1     21 Width 0ft   5999103.5198 2107851.3675 37.7677059906434 -122.44639023232 (37.7677059906434, -122.44639023232)
130487 248489 2 47 772 Ashbury St 2 1 1 1     19 Width 0ft   5999100.7943 2107872.5656 37.7677640396106 -122.446401184623 (37.7677640396106, -122.446401184623)
1600 251625 2 47 76R Amber Dr 3 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1624 251624 2 47 76R Amber Dr 2 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1625 251623 2 47 76R Amber Dr 1 13 1 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
961 251408 2 47 75 Christmas Tree Point Rd 1 1 1 1       3x3   5998776.0 2103023.0 37.75442978774979 -122.447175546291 (37.7544297877498, -122.447175546291)
1633 251599 2 47 740 Moraga St 1 7 1 1       3x3   5992006.0 2103899.0 37.756445907456396 -122.470651540396 (37.7564459074564, -122.470651540396)
57594 223778 2 47 731 Noe St 1 9 1 1     9 Width 3ft   6003093.21791 2103983.10417 37.757311735462295 -122.432314067334 (37.7573117354623, -122.432314067334)
169563 223779 2 47 731 Noe St 2 9 1 1     9 Width 3ft   6003094.682440001 2103994.83983 37.7573440418231 -122.43230984055201 (37.7573440418231, -122.432309840552)
78166 111586 3 47 730X Lake Merced Blvd 2 9 1 2     48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
89354 111589 3 47 730X Lake Merced Blvd 5 7 1 10 4       Permit Number 774260 5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
92075 111588 3 47 730X Lake Merced Blvd 4 7 1 10 4   48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
142323 111587 3 47 730X Lake Merced Blvd 1 9 1 2     48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
1631 251621 6 47 72R Amber Dr 4 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1637 251619 6 47 72R Amber Dr 2 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1638 251620 2 47 72R Amber Dr 3 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1640 251622 2 47 72R Amber Dr 5 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1652 251618 2 47 72R Amber Dr 1 13 1 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
88993 121199 7 47 72 Fountain St 1 13 1 1           6000322.0 2101283.0 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556)
25143 126422 2 47 71 MacOndray Ln 3 9 1 1     40     6008381.99212 2119124.63634 37.7991852374601 -122.415095094385 (37.7991852374601, -122.415095094385)
110409 98703 6 47 7070@ 32nd Ave California St 4 25 1 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
125647 85060 6 47 7070 California St 1 8 1 1   07/03/2007 12:00:00 AM     Permit Number 49405 5985878.0 2113896.0 37.7835385880022 -122.49258024231199 (37.7835385880022, -122.492580242312)
31803 223794 2 47 701 Church St 30 7 1 1     21 Width 3ft   6004330.71364 2104618.42618 37.7591262696742 -122.42807959421002 (37.7591262696742, -122.42807959421)
135900 223793 2 47 701 Church St 29 7 1 1     28 Width 3ft   6004332.42346 2104590.86919 37.7590507014501 -122.428071717046 (37.7590507014501, -122.428071717046)
149694 223692 2 47 701 Church St 44 7 1 1     13     6004344.5987 2104707.34802 37.7593712135304 -122.428037909748 (37.7593712135304, -122.428037909748)
160228 223792 2 47 701 Church St 28 7 1 1     33 Width 3ft   6004330.96009 2104564.9657799997 37.7589794940334 -122.428074932123 (37.7589794940334, -122.428074932123)
40380 176106 3 47 700x Mansell St 38 11 1 2     12 Width 0ft   6009144.0469 2089931.11882 37.719069269612206 -122.410395658243 (37.7190692696122, -122.410395658243)
148568 176105 3 47 700x Mansell St 29 11 1 2     105 Width 0ft   6009225.48687 2089982.90412 37.7192160263732 -122.41011780460899 (37.7192160263732, -122.410117804609)
176077 176104 3 47 700x Mansell St 19 11 1 2     26 Width 0ft   6009423.2681599995 2090026.7428 37.7193474820922 -122.409437239052 (37.7193474820922, -122.409437239052)
184827 176107 3 47 700x Mansell St 46 11 1 2     61 Width 0ft   6008982.60232 2089910.3513099998 37.7190031946297 -122.41095224595699 (37.7190031946297, -122.410952245957)
79420 114061 2 47 700X LAKE MERCED BLVD 7 11 1 1     52     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
98520 114060 2 47 700X LAKE MERCED BLVD 6 11 1 1     60     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
109936 114056 2 47 700X LAKE MERCED BLVD 2 11 1 1     61     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
118992 114058 2 47 700X LAKE MERCED BLVD 4 11 1 1     58     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
126354 114055 2 47 700X LAKE MERCED BLVD 1 11 1 1     50     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
142943 114059 2 47 700X LAKE MERCED BLVD 5 11 1 1     38     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
146162 114057 2 47 700X LAKE MERCED BLVD 3 11 1 1     46     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
17118 11746 3 47 700X Junipero Serra Blvd 29 11 1 2   03/03/2006 12:00:00 AM 3 6X6   5991277.67104 2092671.80389 37.7255767576586 -122.472351910013 (37.7255767576586, -122.472351910013)
17468 11748 3 47 700X Junipero Serra Blvd 31 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991276.77165 2092652.88165 37.7255247498407 -122.472353640304 (37.7255247498407, -122.472353640304)
17727 11703 3 47 700X Junipero Serra Blvd 20 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991288.65534 2092789.2072 37.725899753665104 -122.47232249319299 (37.7258997536651, -122.472322493193)
17929 11710 3 47 700X Junipero Serra Blvd 27 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991285.51963 2092735.44075 37.7257519428913 -122.47232941528699 (37.7257519428913, -122.472329415287)
20319 11702 3 47 700X Junipero Serra Blvd 19 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991290.07475 2092800.9455099998 37.7259320662922 -122.47231844175501 (37.7259320662922, -122.472318441755)
10618 2271 3 47 700X Brotherhood Way 5 11 1 2     25 14M   5990752.82343 2088228.49759 37.71334614597279 -122.47384223413499 (37.7133461459728, -122.473842234135)
10938 2269 3 47 700X Brotherhood Way 3 11 1 2     6 14M   5990714.96133 2088247.7727 37.7133968776506 -122.473974502829 (37.7133968776506, -122.473974502829)
11028 2270 3 47 700X Brotherhood Way 4 11 1 2     6 14M   5990735.60667 2088236.9442599998 37.7133683412468 -122.473902356505 (37.7133683412468, -122.473902356505)
149883 2256 3 47 700X Brotherhood Way 2 11 1 2     15     5990689.72825 2088261.00769 37.7134317560555 -122.47406268136801 (37.7134317560555, -122.474062681368)
186596 2255 3 47 700X Brotherhood Way 1 11 1 2     17     5990660.02895 2088282.4204099998 37.713488829713796 -122.474166893001 (37.7134888297138, -122.474166893001)
2186 252924 3 47 700 Sanchez St 1 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
35459 206866 2 47 700 Junipero Serra Blvd 132 4 1 1     28 Width 0ft   5991206.46725 2091692.32993 37.7228832440624 -122.472526676182 (37.7228832440624, -122.472526676182)
37023 206856 2 47 700 Junipero Serra Blvd 45 4 1 1     26 Width 0ft   5991248.852630001 2092491.9705700001 37.725081312132296 -122.47243842751101 (37.7250813121323, -122.472438427511)
53576 206867 2 47 700 Junipero Serra Blvd 134 4 1 1     5 Width 0ft   5991202.1664 2091654.5365900001 37.7227792239685 -122.47253878915501 (37.7227792239685, -122.472538789155)
55517 206864 2 47 700 Junipero Serra Blvd 108 4 1 1     16 Width 0ft   5991230.74264 2091941.55129 37.7235689492395 -122.472460922234 (37.7235689492395, -122.472460922234)
62264 206862 2 47 700 Junipero Serra Blvd 97 4 1 1     16 Width 0ft   5991236.44384 2092069.53712 37.7239206965711 -122.47245054045601 (37.7239206965711, -122.472450540456)
62342 206859 2 47 700 Junipero Serra Blvd 68 4 1 1     22 Width 0ft   5991233.44826 2092307.36701 37.724573545027205 -122.472478226105 (37.7245735450272, -122.472478226105)
62919 206858 2 47 700 Junipero Serra Blvd 66 4 1 1     19 Width 0ft   5991244.79193 2092323.0787 37.72461734199471 -122.472440157785 (37.7246173419947, -122.472440157785)
73599 206869 2 47 700 Junipero Serra Blvd 147 4 1 1     26 Width 0ft   5991181.8353699995 2091497.44747 37.722346719311396 -122.472597620994 (37.7223467193114, -122.472597620994)
74617 206861 2 47 700 Junipero Serra Blvd 89 4 1 1     15 Width 0ft   5991235.1013400005 2092148.3228200001 37.7241369448505 -122.47246092223 (37.7241369448505, -122.47246092223)
147332 206868 2 47 700 Junipero Serra Blvd 142 4 1 1     24 Width 0ft   5991190.247819999 2091564.0657099998 37.7225301234522 -122.472573395965 (37.7225301234522, -122.472573395965)
151740 206857 2 47 700 Junipero Serra Blvd 64 4 1 1     17 Width 0ft   5991242.804690001 2092347.545 37.7246844053568 -122.47244881018601 (37.7246844053568, -122.472448810186)
155354 206863 2 47 700 Junipero Serra Blvd 101 4 1 1     16 Width 0ft   5991231.24746 2092036.74802 37.723830365071 -122.47246611402599 (37.723830365071, -122.472466114026)
155655 206871 2 47 700 Junipero Serra Blvd 167 4 1 1     28 Width 0ft   5991178.39011 2091334.0196900002 37.721897787630404 -122.472597620991 (37.7218977876304, -122.472597620991)
159756 206860 2 47 700 Junipero Serra Blvd 79 4 1 1     14 Width 0ft   5991226.76432 2092227.75414 37.72435456098721 -122.472495529949 (37.7243545609872, -122.472495529949)
176049 206870 2 47 700 Junipero Serra Blvd 153 4 1 1     16 Width 0ft   5991175.977080001 2091433.26758 37.7221701581122 -122.47261319456699 (37.7221701581122, -122.472613194567)
185468 206865 2 47 700 Junipero Serra Blvd 129 4 1 1     25 Width 0ft   5991211.79314 2091726.01373 37.722976039705 -122.472510720395 (37.722976039705, -122.472510720395)
79781 122494 2 47 69x Bonview St 10 1 1 2       3x3   6007716.0 2099172.0 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063)
148117 223791 2 47 69 Levant St 2 9 1 1     36 Width 3ft   6000368.06545 2106346.5780599997 37.7636463558292 -122.441908320012 (37.7636463558292, -122.441908320012)
72965 99863 1 47 681 47th Ave 1 1 1 1     28     5981324.99313 2111098.19167 37.7755893711796 -122.508123883044 (37.7755893711796, -122.508123883044)
127792 99864 1 47 681 47th Ave 2 1 1 1         Permit Number 768887 5981306.2 2111092.9 37.775573734396204 -122.508188499048 (37.7755737343962, -122.508188499048)
174021 206805 2 47 68 Aerial Way 1 9 1 1     20 Width 2ft   5992337.85259 2102586.3377799997 37.752860862941205 -122.469408341716 (37.7528608629412, -122.469408341716)
167137 206811 3 47 66x Santa Monica Way 7 3 1 2     9     5993507.09013 2097468.08947 37.738874951811795 -122.464993240656 (37.7388749518118, -122.464993240656)
168306 206810 3 47 66x Santa Monica Way 1 3 1 2     14     5993662.74276 2097416.4076799997 37.7387420203269 -122.464451319071 (37.7387420203269, -122.464451319071)
184580 206812 3 47 66x Santa Monica Way 9 3 1 2     15     5993679.09704 2097560.53952 37.739138713068 -122.464405236026 (37.739138713068, -122.464405236026)
45479 206804 2 47 66 Aerial Way 1 9 1 1     30 Width 4ft   5992257.723230001 2102553.22068 37.7527653009777 -122.46968303065901 (37.7527653009777, -122.469683030659)
75219 176164 2 47 654 Peru Ave 2 17 1 1     33     6005136.16004 2092540.09119 37.7260074465758 -122.42443486048201 (37.7260074465758, -122.424434860482)
166544 176163 2 47 654 Peru Ave 1 17 1 1     23     6005125.75661 2092550.7271200002 37.726036063007705 -122.42447158070601 (37.7260360630077, -122.424471580706)
167034 176166 2 47 654 Peru Ave 4 17 1 1     30     6005147.67241 2092530.2100099998 37.7259809651314 -122.424394360408 (37.7259809651314, -122.424394360408)
179538 176165 2 47 654 Peru Ave 3 17 1 1     27     6005141.81262 2092533.90812 37.7259907884276 -122.42441488026199 (37.7259907884276, -122.424414880262)
3044 253288 2 47 650 Peru Ave 4 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3046 253289 2 47 650 Peru Ave 5 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3049 253290 2 47 650 Peru Ave 6 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
3050 253291 2 47 650 Peru Ave 7 7 1 1           6005101.95698 2092563.1940099997 37.7260689503102 -122.42455474103201 (37.7260689503102, -122.424554741032)
176669 223743 2 47 65 Zircon Pl 2 7 1 1     45     6002363.70914 2098682.85125 37.7427171047157 -122.434458039421 (37.7427171047157, -122.434458039421)
9720 173652 2 47 65 ZIRCON PL 2 9 1 1           6002398.2 2098694.7 37.7427515964219 -122.43433962698201 (37.7427515964219, -122.434339626982)
1613 251616 2 47 64R Amber Dr 3 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1619 251617 2 47 64R Amber Dr 4 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1639 251615 2 47 64R Amber Dr 2 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1643 251614 2 47 64R Amber Dr 1 13 1 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
Powered by Datasette · Query took 18.775ms · Data source: data.sfgov.org