sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
81662 115444 2 5 99x Vandewater St 5 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
97297 115442 2 5 99x Vandewater St 3 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
112326 115441 2 5 99x Vandewater St 2 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
113661 115440 2 5 99x Vandewater St 1 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
115493 115443 2 5 99x Vandewater St 4 1 1 1       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249)
13964 24120 3 5 99X Whitney Young Cir 1 1 1 2     24 3x3   6016647.77235 2095170.8389599998 37.7338743084492 -122.384822755067 (37.7338743084492, -122.384822755067)
85680 99097 6 5 99X Santa Monica Way 1 2 1 1           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
104809 116896 2 5 998X KIRKHAM ST 2 1 1 1       3x3   5991857.0 2105283.0 37.760237390046704 -122.471267663471 (37.7602373900467, -122.471267663471)
125344 116895 2 5 998X KIRKHAM ST 1 1 1 1       3x3   5991857.0 2105283.0 37.760237390046704 -122.471267663471 (37.7602373900467, -122.471267663471)
9882 173729 3 5 994 Carolina St 2 11 1 2     6 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
9906 173728 3 5 994 Carolina St 1 11 1 2     8 3x3   6012439.0 2103318.0 37.7560109950145 -122.399945772243 (37.7560109950145, -122.399945772243)
154189 247416 2 5 991 Page St 2 1 1 1     14 Width 0ft   6001894.4537 2109427.399 37.7721923905385 -122.43684958992901 (37.7721923905385, -122.436849589929)
132566 203830 2 5 990 Yerba Buena Ave 1 2 1 1     10     5995335.27016 2094553.61244 37.730977754916 -122.45846137648998 (37.730977754916, -122.45846137649)
43424 140778 2 5 99 Terra Vista Ave 1 1 1 1     10 Width 0ft   6000008.8144 2112798.5514 37.78134136570179 -122.44361437311599 (37.7813413657018, -122.443614373116)
42983 30852 1 5 99 South Van Ness Ave 2 1 1 1   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442)
100372 30856 1 5 99 South Van Ness Ave 3 1 1 1   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442)
104646 30855 1 5 99 South Van Ness Ave 5 1 1 1   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442)
140019 30857 1 5 99 South Van Ness Ave 1 1 1 1   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442)
140989 30854 1 5 99 South Van Ness Ave 6 1 1 1   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442)
141603 30853 1 5 99 South Van Ness Ave 7 1 1 1   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442)
71572 203997 2 5 99 Merced Ave 4 1 1 1     12 Width 3ft   5994838.45589 2099724.9238 37.745148334641 -122.460553522421 (37.745148334641, -122.460553522421)
103795 92788 1 5 99 Buena Vista Ter 1 1 1 1       3x3 Permit Number 53006 6001506.4 2107657.3 37.7673100756575 -122.438065079874 (37.7673100756575, -122.438065079874)
62277 250545 2 5 99 25th Ave 1 2 1 1     12 Width 5ft   5987996.344380001 2115386.3423900004 37.7877542741995 -122.485361078263 (37.7877542741995, -122.485361078263)
79584 116089 6 5 98x WOODWARD ST 3 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
103243 116088 6 5 98x WOODWARD ST 2 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
107871 116087 6 5 98x WOODWARD ST 1 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
125535 116090 6 5 98x WOODWARD ST 4 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
139135 112417 2 5 98X BROADMOOR DR 1 8 1 1     28 3x3   5990934.0 2093194.0 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435)
18902 2171 3 5 980X Haight St 1 1 1 2     30 3x3   6001393.407000001 2109056.2142 37.771144720167705 -122.43855614944799 (37.7711447201677, -122.438556149448)
156682 175042 2 5 98 San Diego Ave 1 7 1 1     33     5992757.09235 2086323.81583 37.7082322293939 -122.466776470378 (37.7082322293939, -122.466776470378)
10124 173862 2 5 98 Frederick St 1 1 1 1       3x3   5999618.0 2107794.0 37.7675778447629 -122.444606591258 (37.7675778447629, -122.444606591258)
159067 187733 2 5 97 Whitney Young Cir 1 1 1 1     18 Width 4ft   6016669.5568699995 2095074.42086 37.7336107684215 -122.384740724326 (37.7336107684215, -122.384740724326)
186826 187734 2 5 97 Whitney Young Cir 2 1 1 1     21 Width 3ft   6016672.472159999 2095023.0659400001 37.7334699192814 -122.384727069019 (37.7334699192814, -122.384727069019)
32675 125260 2 5 962 Union St 1 1 1 1     11 Width 2ft   6008370.79579 2119332.90352 37.799756458059 -122.415148587839 (37.799756458059, -122.415148587839)
67831 188723 2 5 961 Le Conte Ave 1 2 1 1     7     6013346.445730001 2089388.2762799999 37.717813418545205 -122.39583146685499 (37.7178134185452, -122.395831466855)
152170 188724 2 5 961 Le Conte Ave 3 2 1 1     8     6013382.05808 2089359.66984 37.7177368520568 -122.395706366661 (37.7177368520568, -122.395706366661)
84837 24174 3 5 95X Whitney Young Cir 7 1 1 2     18 6x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
100171 24182 3 5 95X Whitney Young Cir 15 1 1 2     12 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
122978 24169 3 5 95X Whitney Young Cir 2 1 1 2     30 4x6   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
47154 203685 2 5 959 Kirkham St 2 1 1 1     16 Width 3ft   5991882.496280001 2105197.7773599997 37.7600048659563 -122.471173275634 (37.7600048659563, -122.471173275634)
71784 203686 2 5 959 Kirkham St 3 1 1 1     15 Width 3ft   5991902.66845 2105197.58333 37.7600054999736 -122.471103496339 (37.7600054999736, -122.471103496339)
171808 203687 2 5 959 Kirkham St 4 1 1 1     13 Width 3ft   5991923.80205 2105198.98577 37.760010573041896 -122.471030508255 (37.7600105730419, -122.471030508255)
74583 125259 2 5 956 Union St 1 1 1 1     12 Width 2ft   6008388.69953 2119336.7815799997 37.7997681123759 -122.41508690874599 (37.7997681123759, -122.415086908746)
41350 203862 2 5 951 Junipero Serra Blvd 13 1 1 1     24 Width 4ft   5991278.5837 2090872.19555 37.7206355315929 -122.472217633157 (37.7206355315929, -122.472217633157)
76210 218201 2 5 950 Ulloa St 2 2 1 1     14 Width 2ft   5993067.47845 2098384.4578299997 37.7413657105616 -122.466579789523 (37.7413657105616, -122.466579789523)
157946 203688 2 5 950 Kirkham St 2 1 1 1     17 Width 4ft   5991858.41058 2105254.40313 37.7601589521859 -122.471260701418 (37.7601589521859, -122.471260701418)
36573 203963 2 5 95 Wawona St 1 1 1 1     14 Width 3ft   5993055.09065 2098419.62465 37.7414615549015 -122.46662517742901 (37.7414615549015, -122.466625177429)
130106 203964 2 5 95 Wawona St 2 1 1 1     14 Width 3ft   5993057.74173 2098432.01976 37.7414957417343 -122.466616911738 (37.7414957417343, -122.466616911738)
67675 125287 2 5 945 Green St 1 7 1 1     18     6008576.87154 2118976.92053 37.798790596063206 -122.414410284916 (37.7987905960632, -122.414410284916)
110309 116003 2 5 945 FRONT ST 2 1 1 1   06/08/2016 12:00:00 AM 3 3x3   6012663.0 2119386.0 37.8001425245044 -122.40029961366501 (37.8001425245044, -122.400299613665)
172088 125288 2 5 943 Green St 11 17 1 1     1     6008674.79926 2118995.08989 37.7988459853112 -122.41407270821101 (37.7988459853112, -122.414072708211)
75430 125286 2 5 941 Vallejo St 6 7 1 1     11     6008909.00848 2118677.12072 37.797986072467204 -122.413239767796 (37.7979860724672, -122.413239767796)
57654 246248 2 5 94 Frederick St 3 1 1 1     12 Width 0ft   5999664.5107 2107772.1777 37.7675205800989 -122.44444414881399 (37.7675205800989, -122.444444148814)
159663 139450 2 5 934 DIVISADERO ST 1 1 1 1     25 Width 0ft   6001513.171 2111631.5925 37.77822287523 -122.438326416807 (37.77822287523, -122.438326416807)
166054 142662 2 5 93 Vandewater St 1 1 1 1     21 Width 0ft   6008939.5318 2121284.2688 37.805146365416896 -122.413318615775 (37.8051463654169, -122.413318615775)
88900 100067 2 5 93 Buena Vista Ter 1 1 1 1       2x2 On property line with 99 Buena Vista Ter 6001505.1 2107681.4 37.76737617437121 -122.438071302911 (37.7673761743712, -122.438071302911)
149428 221379 2 5 93 Buena Vista Ter 1 1 1 1     16 Width 3ft   6001485.45303 2107668.90579 37.7673407510066 -122.438138363796 (37.7673407510066, -122.438138363796)
9888 173719 3 5 922 Carolina St 1 11 1 2     12 3x3   6012422.0 2103621.0 37.7568420188621 -122.40002584196199 (37.7568420188621, -122.400025841962)
156135 200237 2 5 919 Ingerson Ave 1 19 1 1     4 Width 0ft   6014571.1757 2089512.0366 37.7182212977035 -122.39160673351002 (37.7182212977035, -122.39160673351)
34242 142663 2 5 91 Vandewater St 2 1 1 1     15 Width 0ft   6008956.5365 2121285.8147 37.80515156476479 -122.41325987814301 (37.8051515647648, -122.413259878143)
46008 187764 2 5 91 Kiska Rd 6 9 1 1     18     6019412.692980001 2093581.83976 37.729663759061 -122.37515338563 (37.729663759061, -122.37515338563)
137993 187765 2 5 91 Kiska Rd 7 9 1 1     26     6019429.17387 2093568.53818 37.7296281423191 -122.375095487273 (37.7296281423191, -122.375095487273)
8054 14425 3 5 90X Masonic Ave 1 11 1 2     40 12   5998875.1013 2112962.0092 37.781725454134396 -122.447548220181 (37.7817254541344, -122.447548220181)
118350 105142 2 5 90X Hillway Ave 2 1 1 1           5996094.58438 2106700.45244 37.764373561312205 -122.456714459214 (37.7643735613122, -122.456714459214)
101747 113695 6 5 907 FLORIDA ST 1 1 1 1     24 3x3   6009441.0 2103786.0 37.7571284172194 -122.41034693748101 (37.7571284172194, -122.410346937481)
9889 3743 3 5 906 Carolina St 2 11 1 2     18 18   6012418.0 2103694.0 37.757042237838796 -122.400044801952 (37.7570422378388, -122.400044801952)
115881 11755 3 5 901X Junipero Serra Blvd 1 1 1 2     24 3X4   5991288.1161497 2091224.4470027 37.7216032788517 -122.472210346501 (37.7216032788517, -122.472210346501)
53970 188566 2 5 901 Iowa St 1 7 1 1     15     6014791.61868 2102890.82424 37.7549689439879 -122.391779701799 (37.7549689439879, -122.391779701799)
60507 188584 3 5 900x Carolina St 28 3 1 2     11     6012486.48206 2103413.8081 37.756276710205995 -122.39978828959299 (37.756276710206, -122.399788289593)
63150 188587 3 5 900x Carolina St 55 3 1 2     16     6012500.08207 2102956.31087 37.7550212809088 -122.399709133985 (37.7550212809088, -122.399709133985)
74110 188585 3 5 900x Carolina St 36 3 1 2     10     6012499.61765 2103177.92943 37.755629771207 -122.39972630024799 (37.755629771207, -122.399726300248)
130923 188582 3 5 900x Carolina St 19 3 1 2     5     6012479.86277 2103522.41115 37.7565745414011 -122.39981880719999 (37.7565745414011, -122.3998188072)
137116 188583 3 5 900x Carolina St 20 3 1 2     5     6012480.57258 2103516.6299400004 37.7565587070348 -122.399815946472 (37.7565587070348, -122.399815946472)
146596 188586 3 5 900x Carolina St 45 3 1 2     18     6012501.01622 2103043.06832 37.755259550009896 -122.399711994725 (37.7552595500099, -122.399711994725)
147407 188588 3 5 900x Carolina St 57 3 1 2     13     6012513.0739 2102944.23906 37.754988858573 -122.399663356681 (37.754988858573, -122.399663356681)
155305 188580 3 5 900x Carolina St 6 3 1 2     11     6012471.14702 2103650.00365 37.7569243965657 -122.399857908838 (37.7569243965657, -122.399857908838)
166461 188581 3 5 900x Carolina St 18 3 1 2     5     6012475.30485 2103528.81943 37.75659188303771 -122.39983502019 (37.7565918830377, -122.39983502019)
83174 111552 3 5 900x BOSWORTH ST 30 7 1 2     6     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
141167 111532 3 5 900x BOSWORTH ST 10 7 1 2     12     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
143355 111556 3 5 900x BOSWORTH ST 34 7 1 2     6     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
18289 5540 3 5 900X Dolores St 9 1 1 2     60 3X3   6005033.64005 2102782.9896400003 37.7541263358861 -122.425517912248 (37.7541263358861, -122.425517912248)
21468 5532 3 5 900X Dolores St 1 1 1 2     20 3X3   6005017.6668300005 2103067.07529 37.7549054662318 -122.42559336895599 (37.7549054662318, -122.425593368956)
162928 125289 2 5 900 Green St 7 7 1 1     3     6008651.45364 2119007.8784 37.7988797881271 -122.414154397206 (37.7988797881271, -122.414154397206)
49334 220209 2 5 900 Dolores St 10 1 1 1     15 Width 3ft   6005038.30793 2102756.62564 37.7540542102343 -122.42549989342399 (37.7540542102343, -122.425499893424)
15525 3745 3 5 900 Carolina St 4 11 1 2     6 18   6012461.71984 2103674.63492 37.7569915030708 -122.39989224135799 (37.7569915030708, -122.399892241358)
97293 55547 1 5 90- 92 CASELLI AVE 1 1 1 1   12/29/1972 12:00:00 AM     Permit Number 11515 6000515.5 2104940.8 37.759794835822 -122.44129751840201 (37.759794835822, -122.441297518402)
174779 142641 2 5 90 VANDEWATER ST 1 1 1 1     15 Width 0ft   6008933.8636 2121305.911 37.805205471231105 -122.413339762783 (37.8052054712311, -122.413339762783)
186248 220313 2 5 90 Caselli Ave 1 1 1 1     17 Width 5ft   6000504.24211 2104917.08566 37.7597290807509 -122.44133475221201 (37.7597290807509, -122.441334752212)
169832 203866 2 5 90 Brighton Ave 1 1 1 1     4 Width 3ft   5996236.4849 2090473.9124900002 37.7198276211289 -122.455051057381 (37.7198276211289, -122.455051057381)
174329 203919 2 5 9 Hillway Ave 10 1 1 1     18 Width 4ft   5996077.658919999 2106538.2502599997 37.763927223976005 -122.456761267518 (37.763927223976, -122.456761267518)
35992 203867 2 5 9 Granada Ave 1 1 1 1     4 Width 4ft   5995596.425009999 2089995.66595 37.7184777288524 -122.45722892757401 (37.7184777288524, -122.457228927574)
51801 203869 2 5 9 Granada Ave 3 2 1 1     5 Width 4ft   5995595.19547 2089971.4511099998 37.7184111700071 -122.45723142680401 (37.7184111700071, -122.457231426804)
57390 203868 2 5 9 Granada Ave 2 2 1 1     3 Width 4ft   5995595.3460099995 2089978.64807 37.7184309398048 -122.457231426799 (37.7184309398048, -122.457231426799)
163702 203870 2 5 9 Granada Ave 4 2 1 1     4 Width 4ft   5995594.9546 2089959.9355900001 37.718379537275894 -122.45723142680401 (37.7183795372759, -122.457231426804)
163854 203872 2 5 9 Granada Ave 6 2 1 1     3 Width 4ft   5995594.11167 2089942.67302 37.7183320899249 -122.457233092344 (37.7183320899249, -122.457233092344)
164225 203871 2 5 9 Granada Ave 5 2 1 1     4 Width 4ft   5995594.53815 2089951.54412 37.718356472363794 -122.45723225957799 (37.7183564723638, -122.457232259578)
38647 122188 2 5 9 14th Ave 1 2 1 1     21 Width 7ft   5991455.25466 2115068.89976 37.7870835661247 -122.473370861161 (37.7870835661247, -122.473370861161)
158460 142664 2 5 89 Vandewater St 3 1 1 1     11 Width 0ft   6008968.9034 2121287.3605 37.80515650344 -122.41321719022 (37.80515650344, -122.41321719022)
72439 140779 2 5 89 Terra Vista Ave 2 1 1 1     8 Width 0ft   6000037.9186 2112803.9662 37.781357893205204 -122.443514076205 (37.7813578932052, -122.443514076205)
30937 220217 2 5 89 Chattanooga St 1 1 1 1     8 Width 3ft   6004733.058759999 2103154.09475 37.755128315543296 -122.42658382018699 (37.7551283155433, -122.426583820187)
Powered by Datasette · Query took 28.527ms · Data source: data.sfgov.org