sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
80457 104540 7 19 1101 Van Ness Ave 4 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
84515 104544 7 19 1101 Van Ness Ave 8 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
87429 108624 7 19 101 GENEBERN WAY 1 7 1 1           6005050.2 2095237.8 37.733409902631 -122.42492386614401 (37.733409902631, -122.424923866144)
94698 104538 7 19 1101 Van Ness Ave 1 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
97796 104543 7 19 1101 Van Ness Ave 7 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
98516 104542 7 19 1101 Van Ness Ave 6 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
110958 108680 7 19 240 SANTA ANA AVE 1 13 1 1           5992606.9 2095181.7 37.73254515275271 -122.46793939448999 (37.7325451527527, -122.46793939449)
125858 104539 7 19 1101 Van Ness Ave 2 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
138525 104568 7 19 1101 Van Ness Ave 9 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
140502 104541 7 19 1101 Van Ness Ave 5 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
3534 253482 6 19 2179 41st Ave 1 7 1 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
3549 253470 6 19 3 Valletta Ct 2 18 1 1       6x10   5999319.0 2096479.0 37.736492551957895 -122.44482735214198 (37.7364925519579, -122.444827352142)
3709 253265 6 19 180 San Aleso Ave 1 8 1 1   09/19/2017 12:00:00 AM 3 3x3   5993319.0 2094440.0 37.730549723890206 -122.465423653439 (37.7305497238902, -122.465423653439)
4549 226945 6 19 998 Chenery St 4 9 1 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
78153 104715 6 19 3618 22nd St 1 9 1 1         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.42832583872601 (37.7549616692716, -122.428325838726)
83945 103563 6 19 878 14th St 1 7 1 1     15   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
84454 103564 6 19 878 14th St 2 7 1 1     13   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
85803 106833 6 19 174 STILLINGS AVE 1 7 1 1           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791)
88432 99828 6 19 2398 Broadway 2 7 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
89880 99852 6 19 86 Nordhoff St 1 7 1 1           6000395.0 2095652.0 37.734283150969794 -122.44104786104499 (37.7342831509698, -122.441047861045)
90158 108211 6 19 524 45th Ave 2 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
91812 107986 6 19 2401x SCOTT ST 4 1 1 1       3x3   6001257.0 2116757.0 37.7922813550603 -122.439580129378 (37.7922813550603, -122.439580129378)
91961 103591 6 19 55X Laguna St 3 7 1 1           6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
93035 103565 6 19 878 14th St 3 7 1 1     9   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
97259 116164 6 19 2411 OCTAVIA ST 1 2 1 1     13 15x4   6004495.0 2117637.0 37.7948813682629 -122.428439330772 (37.7948813682629, -122.428439330772)
97963 104717 6 19 3618 22nd St 3 9 1 1         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.42832583872601 (37.7549616692716, -122.428325838726)
99448 116072 6 19 388 POLARIS WAY 1 5 1 1       3x3   6000586.0 2086414.0 37.70892857908329 -122.439725431133 (37.7089285790833, -122.439725431133)
102075 109040 6 19 654 Precita Ave   7 1 1     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152)
109308 103590 6 19 55X Laguna St 2 7 1 1           6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
109984 116585 6 19 2100 22ND ST 1 1 1 1     30 3x3   6011843.0 2103815.0 37.757342401329105 -122.402041888427 (37.7573424013291, -122.402041888427)
111731 122636 6 19 3698X 19th Ave 1 5 1 1       3x3   5990586.0 2091171.0 37.7214158684235 -122.474633449984 (37.7214158684235, -122.474633449984)
112529 104716 6 19 3618 22nd St 2 9 1 1         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.42832583872601 (37.7549616692716, -122.428325838726)
115088 117438 6 19 230 AMBER DR 1 5 1 1     25 3X3   5999593.0 2099199.0 37.7439766577846 -122.444075405191 (37.7439766577846, -122.444075405191)
116755 103589 6 19 55X Laguna St 1 7 1 1           6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
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)
129210 95985 6 19 577 Sanchez St 1 25 1 1           6003673.0 2104901.0 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168)
140837 105857 6 19 1500X Valencia St 1 5 1 1       3x3   6006259.2 2100711.5 37.7485076710609 -122.42113253995599 (37.7485076710609, -122.421132539956)
143885 108210 6 19 524 45th Ave 1 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
9555 105225 5 19 175 Spruce St 1 7 1 1     9     5997195.09596 2114417.64894 37.785626103218895 -122.453465347546 (37.7856261032189, -122.453465347546)
5604 19964 3 19 100 STAIRWAY41 2 1 1 2     6 25ST            
6044 107491 3 19 1306x Montgomery St 20 11 1 2     8     6011446.048280001 2119975.7461599996 37.8016938891322 -122.40455229795 (37.8016938891322, -122.40455229795)
8096 19962 3 19 100 STAIRWAY41 -2 1 1 2     6 25ST            
9264 19963 3 19 100 STAIRWAY41 1 1 1 2     6 25ST            
11331 1100 3 19 2328 Alemany Blvd 1 1 1 2     25 3X3   5999423.31284 2089282.1433599999 37.71673760544579 -122.44394976577298 (37.7167376054458, -122.443949765773)
11566 16410 3 19 1186X Munich St 3 1 1 2     42 TR   6001066.26402 2087197.59203 37.7111074743937 -122.43812166787501 (37.7111074743937, -122.438121667875)
14648 19819 3 19 100 STAIRWAY25 3 1 1 2     12 100ST            
15377 25938 3 19 2000 Oakdale Ave 3 1 1 2   04/22/1997 12:00:00 AM 12 3x3   6012867.3394 2097145.5573099998 37.739086658519895 -122.39803142710899 (37.7390866585199, -122.398031427109)
15925 25939 3 19 2000 Oakdale Ave 4 1 1 2   04/22/1997 12:00:00 AM 10 3x3   6012857.31615 2097153.53613 37.7391080084261 -122.39806664277201 (37.7391080084261, -122.398066642772)
16920 19979 3 19 100 STAIRWAY45 6 1 1 2     3 30ST            
17954 16098 3 19 300 Monterey Blvd 1 1 1 2   12/17/1997 12:00:00 AM 6 2X3   6000050.52204 2094718.8331 37.7317012658005 -122.442171864536 (37.7317012658005, -122.442171864536)
18654 16099 3 19 300 Monterey Blvd 3 1 1 2     12 3X3   6000036.69943 2094718.89433 37.7317006461483 -122.442219656332 (37.7317006461483, -122.442219656332)
18666 19313 3 19 21 Shields St 1 1 1 2     3 3X3   5993901.63447 2089816.98545 37.7178896324771 -122.463074115289 (37.7178896324771, -122.463074115289)
19631 16102 3 19 300 Monterey Blvd 6 1 1 2     12 3X3   6000017.68556 2094719.9660099999 37.7317025050652 -122.442285467815 (37.7317025050652, -122.442285467815)
21395 16100 3 19 300 Monterey Blvd 4 1 1 2     12 3X3   6000028.57256 2094720.41703 37.7317043639536 -122.442247861742 (37.7317043639536, -122.442247861742)
21593 16127 3 19 330 Monterey Blvd 2 1 1 2     12 3x3   5999874.93833 2094721.1240700001 37.7316975479954 -122.442779055318 (37.7316975479954, -122.442779055318)
26942 129350 3 19 1306x Montgomery St 38 3 1 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
27490 129348 3 19 1306x Montgomery St 33 3 1 2     2 Width 8ft   6011427.80927 2120135.82348 37.802132403051 -122.404626688974 (37.802132403051, -122.404626688974)
32407 866 3 19 600X Alemany Blvd 4 1 1 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
43705 190817 3 19 390x Hampshire St 5 11 1 2     13 Width 5ft   6010044.56493 2106488.02831 37.7645813917285 -122.40845015844101 (37.7645813917285, -122.408450158441)
45155 190814 3 19 390x Hampshire St 1 11 1 2     16 Width 5ft   6010041.1190599995 2106539.02685 37.7647212291204 -122.40846567444599 (37.7647212291204, -122.408465674446)
46600 116804 3 19 131 LAKESHORE DR 1 3 2 2       10x100   5984782.0 2094243.0 37.7295127607338 -122.494922366174 (37.7295127607338, -122.494922366174)
75147 129353 3 19 1306x Montgomery St 51 3 1 2     6 Width 8ft   6011391.406830001 2120329.06369 37.8026609588854 -122.404766271855 (37.8026609588854, -122.404766271855)
86324 121732 3 19 1301 Vermont St 7 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
95182 16377 3 19 1400X Montgomery St 10 11 1 2     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
100221 5821 3 19 1027 Duncan St 1 1 1 2     75 3X3   5999811.0829915 2099731.7400522 37.745451872839 -122.443359584044 (37.745451872839, -122.443359584044)
104252 121734 3 19 1301 Vermont St 9 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
110428 12623 3 19 825 Lake St 1 1 1 2     27 3X3   5992882.168 2114794.01241 37.7864113245051 -122.468414093066 (37.7864113245051, -122.468414093066)
112118 878 3 19 600X Alemany Blvd 16 1 1 2     6 1X1   6007241.9784 2095034.8696299999 37.7329762592527 -122.41733187808398 (37.7329762592527, -122.417331878084)
135071 190816 3 19 390x Hampshire St 3 11 1 2     7 Width 5ft   6010044.10542 2106509.4810599997 37.7646402703573 -122.40845326111099 (37.7646402703573, -122.408453261111)
139863 24744 3 19 128X Point Lobos Ave 1 1 1 2   02/02/1996 12:00:00 AM 3 3x3   5982380.471419999 2112632.1433099997 37.7798632908372 -122.504586464809 (37.7798632908372, -122.504586464809)
154652 129351 3 19 1306x Montgomery St 39 3 1 2     1 Width 8ft   6011425.67929 2120161.57643 37.8022029953207 -122.404635873741 (37.8022029953207, -122.404635873741)
163136 129352 3 19 1306x Montgomery St 45 3 1 2     3 Width 8ft   6011406.69978 2120255.02893 37.8024585322873 -122.404708135188 (37.8024585322873, -122.404708135188)
175803 129354 3 19 1306x Montgomery St 52 3 1 2     14 Width 8ft   6011388.89614 2120338.61388 37.8026870410416 -122.40477563290199 (37.8026870410416, -122.404775632902)
181902 190815 3 19 390x Hampshire St 2 11 1 2     11 Width 5ft   6010042.68497 2106527.82648 37.7646905631515 -122.408459468238 (37.7646905631515, -122.408459468238)
183528 219372 3 19 400x Marietta Dr 17 11 1 2     9 Width 3ft   5999397.86314 2097051.08053 37.7380678498474 -122.444595794674 (37.7380678498474, -122.444595794674)
188999 129349 3 19 1306x Montgomery St 35 3 1 2     2 Width 8ft   6011426.64663 2120143.89656 37.8021545047788 -122.40463128093398 (37.8021545047788, -122.404631280934)
37 226924 2 19 1 Newburg St 1 6 1 1     11 Width 4ft   6002558.65829 2099967.6575700003 37.7462559468486 -122.433875776072 (37.7462559468486, -122.433875776072)
44 226925 2 19 1 Newburg St 2 6 1 1     19 Width 4ft   6002565.841680001 2099976.66752 37.746281093695 -122.433851580699 (37.746281093695, -122.433851580699)
49 251186 2 19 3042 Steiner St 1 5 1 1       3x3   6002010.0 2118654.0 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013)
65 226926 2 19 1 Newburg St 3 6 1 1     15 Width 4ft   6002574.76935 2099983.89995 37.7463014588644 -122.433821226777 (37.7463014588644, -122.433821226777)
265 109354 2 19 900x Chestnut St 1 5 1 1     6 5x45   6007474.1784 2120601.5824599997 37.803189502164294 -122.418341225173 (37.8031895021643, -122.418341225173)
4190 100829 2 19 1601X North Point St 2 1 1 1     12 3x3   6003036.60353 2120959.36193 37.803921074561295 -122.43372315391198 (37.8039210745613, -122.433723153912)
8375 100825 2 19 3661 Buchanan St 2 1 1 1     12 3x3   6003069.70231 2120954.84645 37.803910554290795 -122.43360829069401 (37.8039105542908, -122.433608290694)
8632 99720 2 19 2164 Hyde St 2 1 1 1     10 3x3   6007185.20399 2119756.67852 37.8008533386708 -122.41928126041701 (37.8008533386708, -122.419281260417)
9867 118924 2 19 855 La Playa 8 9 1 1   01/05/2017 12:00:00 AM 3 Width 4ft   5980738.40206 2109808.86226 37.772014669966396 -122.510057198601 (37.7720146699664, -122.510057198601)
12269 106828 2 19 631 Hamilton St 1 1 1 1     5 3x3   6009794.12958 2091448.15219 37.7232711495323 -122.40825550289 (37.7232711495323, -122.40825550289)
14463 110915 2 19 77 Federal St 1 1 1 1     3 2x1   6014720.0191 2113052.86526 37.7828676936327 -122.39273818212 (37.7828676936327, -122.39273818212)
23498 176772 2 19 937 Silver Ave 3 9 1 1     22 Width 5ft   6007351.78047 2093548.13266 37.72890017978 -122.41684696742901 (37.72890017978, -122.416846967429)
23542 176768 2 19 955 Silver Ave 1 9 1 1     13 Width 4ft   6007502.25565 2093569.5745700002 37.7289675174267 -122.416328280725 (37.7289675174267, -122.416328280725)
23567 137685 2 19 720 BAKER ST 2 1 1 1     1 Width 0ft   6000552.856000001 2111474.7278 37.7777374972355 -122.441637228704 (37.7777374972355, -122.441637228704)
23730 219413 2 19 845 Detroit St 7 9 1 1     13 Width 6ft   5999418.48835 2095681.2919599998 37.734307911173204 -122.444426068323 (37.7343079111732, -122.444426068323)
23847 226860 2 19 99 Elk St 4 9 1 1     9 Width 2ft   6000812.22961 2096323.57705 37.7361509008315 -122.43965349751801 (37.7361509008315, -122.439653497518)
23881 129298 2 19 1287 Filbert St 4 9 1 1     2 Width 3ft   6006767.5192599995 2119403.73147 37.799860702966 -122.420701557924 (37.799860702966, -122.420701557924)
24179 226965 2 19 26 Danvers St 1 9 1 1     6 Width 1ft   5999778.9374 2105368.70326 37.7609277664162 -122.44387566164801 (37.7609277664162, -122.443875661648)
24188 247556 2 19 815 Buena Vista Ave West 13 9 1 1     19 Width 2ft   6000035.32206 2108353.94379 37.7691391145131 -122.443203353661 (37.7691391145131, -122.443203353661)
24248 219332 2 19 1025 Junipero Serra Blvd 22 9 1 1     7 Width 3ft   5991262.77441 2090479.13965 37.719555381949206 -122.47224364333 (37.7195553819492, -122.47224364333)
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)
24631 176638 2 19 65 Santa Barbara Ave 1 9 1 1     11 Width 8ft   5993323.454919999 2086371.47099 37.7083957495352 -122.46482253315399 (37.7083957495352, -122.464822533154)
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)
24753 129266 2 19 24 Priest St 13 9 1 1     3 Width 10ft   6008334.4403800005 2117141.01825 37.7937360410291 -122.41511915572399 (37.7937360410291, -122.415119155724)
24785 129216 2 19 2711 Vallejo St 2 9 1 1     5 Width 4ft   6000537.3614300005 2117487.89488 37.794247216575606 -122.442122575399 (37.7942472165756, -122.442122575399)
Powered by Datasette · Query took 13.207ms · Data source: data.sfgov.org