sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
49 251186 2 19 3042 Steiner St 1 5 1 1       3x3   6002010.0 2118654.0 37.7975328515761 -122.437110618013 (37.7975328515761, -122.437110618013)
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)
46600 116804 3 19 131 LAKESHORE DR 1 3 2 2       10x100   5984782.0 2094243.0 37.7295127607338 -122.494922366174 (37.7295127607338, -122.494922366174)
50099 108350 2 19 1501x RIVERA ST 6 9 1 1       3x3   5988383.0 2100343.0 37.746471910315705 -122.482920391178 (37.7464719103157, -122.482920391178)
77664 96104 2 19 2780X 18th St 8 5 1 1       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865921999 (37.7618258328219, -122.40992865922)
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)
80181 109321 2 19 3699 MARKET ST 1 5 1 1       3x3   6000396.5 2103077.7 37.7546724390671 -122.441575379015 (37.7546724390671, -122.441575379015)
80360 110171 2 19 901 MONTEREY BLVD 1 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
80457 104540 7 19 1101 Van Ness Ave 4 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
80890 108255 2 19 1798X Washington St 2 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
84330 111073 2 19 1450 IRVING ST 2 5 1 11       3x3   5991201.0 2106639.0 37.7639226370674 -122.473635352969 (37.7639226370674, -122.473635352969)
84515 104544 7 19 1101 Van Ness Ave 8 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
85803 106833 6 19 174 STILLINGS AVE 1 7 1 1           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791)
86324 121732 3 19 1301 Vermont St 7 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
87429 108624 7 19 101 GENEBERN WAY 1 7 1 1           6005050.2 2095237.8 37.733409902631 -122.42492386614401 (37.733409902631, -122.424923866144)
88432 99828 6 19 2398 Broadway 2 7 1 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
89053 102912 2 19 84 Vienna St 1 5 1 1           6004823.0 2092922.0 37.7270383945734 -122.42554460371599 (37.7270383945734, -122.425544603716)
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)
90274 97299 1 19 1051 Portola Dr 2 9 1 1           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865)
91752 96831 1 19 2908 Baker St 2 5 1 1           5999535.9 2118868.1 37.797979769659996 -122.44568703479601 (37.79797976966, -122.445687034796)
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)
92163 108259 2 19 1798X Washington St 6 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
94535 108345 2 19 1501x RIVERA ST 1 9 1 1       3x3   5988383.0 2100343.0 37.746471910315705 -122.482920391178 (37.7464719103157, -122.482920391178)
94629 110173 2 19 901 MONTEREY BLVD 3 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
94698 104538 7 19 1101 Van Ness Ave 1 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
96170 113366 2 19 799X ORTEGA WAY 5 5 1 1       3x3   5991631.0 2102457.0 37.7524648607614 -122.47184332039 (37.7524648607614, -122.47184332039)
97319 88347 1 19 100x Vienna St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004738.0 2092796.0 37.7266876232591 -122.425829482771 (37.7266876232591, -122.425829482771)
97359 119672 2 19 2090x 20th St 1 5 1 1           6011896.0 2104722.0 37.7598357807336 -122.40192234981501 (37.7598357807336, -122.401922349815)
97796 104543 7 19 1101 Van Ness Ave 7 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
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)
98097 108256 2 19 1798X Washington St 3 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
98516 104542 7 19 1101 Van Ness Ave 6 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
99148 108346 2 19 1501x RIVERA ST 2 9 1 1       3x3   5988383.0 2100343.0 37.746471910315705 -122.482920391178 (37.7464719103157, -122.482920391178)
99222 108353 2 19 1501x RIVERA ST 9 9 1 1       3x3   5988383.0 2100343.0 37.746471910315705 -122.482920391178 (37.7464719103157, -122.482920391178)
99448 116072 6 19 388 POLARIS WAY 1 5 1 1       3x3   6000586.0 2086414.0 37.70892857908329 -122.439725431133 (37.7089285790833, -122.439725431133)
99837 99918 1 19 1740 Jones St 5 5 1 1           6008334.0 2118406.0 37.7972093435845 -122.41521026614402 (37.7972093435845, -122.415210266144)
101905 97139 2 19 937 Goettingen St   25 2 1           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644)
103370 96098 2 19 1999 Bryant St 2 5 1 1       3x3 Permit Number 767752 6009553.0 2105475.0 37.7617723065941 -122.41007883348301 (37.7617723065941, -122.410078833483)
104252 121734 3 19 1301 Vermont St 9 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
104404 106685 2 19 100 Yukon St   8 1 1         Permit Number 772768 6000197.4 2104288.0 37.757984281634 -122.44235080136299 (37.757984281634, -122.442350801363)
105668 108258 2 19 1798X Washington St 5 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
107709 99917 1 19 1740 Jones St 3 5 1 1           6008334.0 2118406.0 37.7972093435845 -122.41521026614402 (37.7972093435845, -122.415210266144)
107724 99916 1 19 1740 Jones St 1 5 1 1           6008334.0 2118406.0 37.7972093435845 -122.41521026614402 (37.7972093435845, -122.415210266144)
107819 114704 2 19 524 Staples Ave 2 1 1 1           5996948.70097149 2093858.06219815 37.729160530354 -122.452833321223 (37.729160530354, -122.452833321223)
108014 113985 2 19 109 MADRONE AVE 1 5 1 1       3x10   5992778.0 2098364.0 37.74129282931111 -122.46757920887899 (37.7412928293111, -122.467579208879)
108530 110402 2 19 419X 18TH AVE 3 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
109308 103590 6 19 55X Laguna St 2 7 1 1           6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
110958 108680 7 19 240 SANTA ANA AVE 1 13 1 1           5992606.9 2095181.7 37.73254515275271 -122.46793939448999 (37.7325451527527, -122.46793939449)
111731 122636 6 19 3698X 19th Ave 1 5 1 1       3x3   5990586.0 2091171.0 37.7214158684235 -122.474633449984 (37.7214158684235, -122.474633449984)
112041 121326 2 19 19 25th Ave 1 5 1 1       3x3   5987896.0 2115988.0 37.7894004070969 -122.48575242171101 (37.7894004070969, -122.485752421711)
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)
112717 108257 2 19 1798X Washington St 4 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
114105 99919 1 19 1740 Jones St 4 5 1 1           6008334.0 2118406.0 37.7972093435845 -122.41521026614402 (37.7972093435845, -122.415210266144)
115013 96105 2 19 2780X 18th St 7 5 1 1       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865921999 (37.7618258328219, -122.40992865922)
115819 110406 2 19 419X 18TH AVE 7 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
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)
119866 96106 2 19 2780X 18th St 9 5 1 1       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865921999 (37.7618258328219, -122.40992865922)
120525 110172 2 19 901 MONTEREY BLVD 2 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
121707 108254 2 19 1798X Washington St 1 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
122281 96103 2 19 2780X 18th St 6 5 1 1       3x3 Permit Number 767752 6009596.8 2105493.6 37.7618258328219 -122.40992865921999 (37.7618258328219, -122.40992865922)
122726 110174 2 19 901 MONTEREY BLVD 4 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
124192 108351 2 19 1501x RIVERA ST 7 9 1 1       3x3   5988383.0 2100343.0 37.746471910315705 -122.482920391178 (37.7464719103157, -122.482920391178)
124212 108347 2 19 1501x RIVERA ST 3 9 1 1       3x3   5988383.0 2100343.0 37.746471910315705 -122.482920391178 (37.7464719103157, -122.482920391178)
125685 96832 1 19 2908 Baker St 3 5 1 1           5999535.9 2118868.1 37.797979769659996 -122.44568703479601 (37.79797976966, -122.445687034796)
125858 104539 7 19 1101 Van Ness Ave 2 7 1 1           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224)
127293 110175 2 19 901 MONTEREY BLVD 5 9 1 1       3x3   5996075.7 2094614.5 37.7311874614685 -122.455906001855 (37.7311874614685, -122.455906001855)
129210 95985 6 19 577 Sanchez St 1 25 1 1           6003673.0 2104901.0 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168)
129230 108349 2 19 1501x RIVERA ST 5 9 1 1       3x3   5988383.0 2100343.0 37.746471910315705 -122.482920391178 (37.7464719103157, -122.482920391178)
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)
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)
144668 110414 2 19 419X 18TH AVE 15 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
145895 111072 2 19 1450 IRVING ST 1 5 1 11       3x3   5991277.0 2106586.0 37.7637815143869 -122.473368628437 (37.7637815143869, -122.473368628437)
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)
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)
27272 206957 2 19 546 Joost Ave 1 9 1 1     1     5998473.21835 2095005.05828 37.7323971540007 -122.447645494648 (37.7323971540007, -122.447645494648)
31573 129332 2 19 1101 Greenwich St 10 7 1 1     1     6007563.684280001 2119863.77685 37.8011687120311 -122.417979152724 (37.8011687120311, -122.417979152724)
35777 226865 2 19 1100 San Jose Ave 9 7 1 1     1     6004824.42349 2096711.0552700001 37.7374423749661 -122.425809268297 (37.7374423749661, -122.425809268297)
43932 206959 2 19 546 Joost Ave 3 9 1 1     1     5998473.1983199995 2095010.9948599997 37.7324134532998 -122.44764599109399 (37.7324134532998, -122.447645991094)
61110 92458 1 19 3319 Lawton St 1 1 1 1 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52848 5983933.4582 2104246.8072 37.756930776386795 -122.498594490514 (37.7569307763868, -122.498594490514)
74501 129333 2 19 1101 Greenwich St 12 7 1 1     1     6007566.1830400005 2119864.34532 37.8011704135381 -122.417970546228 (37.8011704135381, -122.417970546228)
151034 249495 2 19 1801 California St 4 9 1 1     1 Width 2ft   6005713.466659999 2115852.8179900004 37.7900513270512 -122.42409631339399 (37.7900513270512, -122.424096313394)
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)
160401 227015 2 19 29 Poppy Ln 1 13 1 1     1 Width 2ft   6002114.09151 2096793.82616 37.7375161085743 -122.43518606040399 (37.7375161085743, -122.435186060404)
170842 129329 2 19 1101 Greenwich St 7 7 1 1     1     6007555.7240699995 2119861.47467 37.8011619428155 -122.41800653528601 (37.8011619428155, -122.418006535286)
171563 129328 2 19 1101 Greenwich St 6 7 1 1     1     6007553.95221 2119861.40094 37.8011616406485 -122.418012661478 (37.8011616406485, -122.418012661478)
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)
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)
35096 103483 1 19 116 Merrill St 1 1 1 1   07/03/2013 12:00:00 AM 2 3x3 Permit Number 770307 6009546.84586 2094694.0586599999 37.73216987282029 -122.409339274108 (37.7321698728203, -122.409339274108)
36594 129227 2 19 2711 Vallejo St 13 9 1 1     2 Width 4ft   6000607.86653 2117501.04945 37.794287353335704 -122.441879565091 (37.7942873533357, -122.441879565091)
39701 129113 2 19 10 Hastings Ter 3 9 1 1     2     6007329.70066 2119282.266 37.7995588581063 -122.418747576633 (37.7995588581063, -122.418747576633)
41224 227003 2 19 5411 Diamond Heights Blvd 2 9 1 1     2 Width 3ft   6002088.6819 2098074.75757 37.741031805779 -122.435365514706 (37.741031805779, -122.435365514706)
46668 32026 1 19 910 Harrison St 1 1 1 1   07/15/2005 12:00:00 AM 2   Permit Number 48084 6011942.61594 2111635.52885 37.7788213676447 -122.40224721144399 (37.7788213676447, -122.402247211444)
47827 176859 2 19 699 Prague St 5 9 1 1     2 Width 2ft   6002706.29177 2087440.6711400002 37.7118680526473 -122.432470687896 (37.7118680526473, -122.432470687896)
51153 176836 2 19 182 Niagara Ave 1 10 1 1     2 Width 0ft   5999285.39372 2089701.94289 37.7178824109155 -122.444456635388 (37.7178824109155, -122.444456635388)
56530 129361 2 19 555 California St 11 1 1 1     2 Width 4ft   6011684.8742 2116686.03693 37.7926744848808 -122.403494267154 (37.7926744848808, -122.403494267154)
Powered by Datasette · Query took 7.665ms · Data source: data.sfgov.org