sf-trees

Data source: data.sfgov.org

Custom SQL query returning 50 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)
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)
24884 109356 2 19 900x Chestnut St 3 5 1 1     11 5x45   6007464.49344 2120601.01033 37.8031873860571 -122.41837469975 (37.8031873860571, -122.41837469975)
48049 109359 2 19 900x Chestnut St 6 5 1 1     8 5x45   6007452.06537 2120598.7604799997 37.8031805089269 -122.41841754792802 (37.8031805089269, -122.418417547928)
66804 115308 2 19 1309 Hyde St 2 5 1 1     10 2x2   6007523.230690001 2116877.91301 37.792967998429 -122.417907360732 (37.792967998429, -122.417907360732)
66823 87246 1 19 236323 Larkin St 5 5 1 1   02/19/2008 12:00:00 AM 22 3x3 Permit Number 50274 6006702.92902 2119345.02683 37.7996958743116 -122.420920894495 (37.7996958743116, -122.420920894495)
70565 109362 2 19 900x Chestnut St 9 5 1 1     7 5x45   6007443.52896 2120597.58705 37.8031768064372 -122.41844700523701 (37.8031768064372, -122.418447005237)
71497 109357 2 19 900x Chestnut St 4 5 1 1     9 5x45   6007459.04695 2120599.58062 37.8031831538387 -122.41839344609801 (37.8031831538387, -122.418393446098)
75911 109363 2 19 900x Chestnut St 10 5 1 1     6 5x45   6007417.13772 2120593.69695 37.8031646394947 -122.418538057081 (37.8031646394947, -122.418538057081)
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)
80181 109321 2 19 3699 MARKET ST 1 5 1 1       3x3   6000396.5 2103077.7 37.7546724390671 -122.441575379015 (37.7546724390671, -122.441575379015)
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)
89053 102912 2 19 84 Vienna St 1 5 1 1           6004823.0 2092922.0 37.7270383945734 -122.42554460371599 (37.7270383945734, -122.425544603716)
91752 96831 1 19 2908 Baker St 2 5 1 1           5999535.9 2118868.1 37.797979769659996 -122.44568703479601 (37.79797976966, -122.445687034796)
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)
96170 113366 2 19 799X ORTEGA WAY 5 5 1 1       3x3   5991631.0 2102457.0 37.7524648607614 -122.47184332039 (37.7524648607614, -122.47184332039)
97359 119672 2 19 2090x 20th St 1 5 1 1           6011896.0 2104722.0 37.7598357807336 -122.40192234981501 (37.7598357807336, -122.401922349815)
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)
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)
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)
104233 106802 2 19 1850 BRYANT ST 2 5 1 1     30 3x2   6009455.7 2106195.7 37.763745730245795 -122.41046624869301 (37.7637457302458, -122.410466248693)
104644 106801 2 19 1850 BRYANT ST 1 5 1 1     25 2x3   6009455.7 2106195.7 37.763745730245795 -122.41046624869301 (37.7637457302458, -122.410466248693)
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)
108014 113985 2 19 109 MADRONE AVE 1 5 1 1       3x10   5992778.0 2098364.0 37.74129282931111 -122.46757920887899 (37.7412928293111, -122.467579208879)
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)
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)
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)
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)
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)
125685 96832 1 19 2908 Baker St 3 5 1 1           5999535.9 2118868.1 37.797979769659996 -122.44568703479601 (37.79797976966, -122.445687034796)
139234 93020 1 19 1403 11th Ave 3 5 1 1     10 2x2 Tree 3 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
140837 105857 6 19 1500X Valencia St 1 5 1 1       3x3   6006259.2 2100711.5 37.7485076710609 -122.42113253995599 (37.7485076710609, -122.421132539956)
145895 111072 2 19 1450 IRVING ST 1 5 1 11       3x3   5991277.0 2106586.0 37.7637815143869 -122.473368628437 (37.7637815143869, -122.473368628437)
147679 109360 2 19 900x Chestnut St 7 5 1 1     6 5x45   6007448.76613 2120598.25036 37.803178922540205 -122.418428928878 (37.8031789225402, -122.418428928878)
155176 109361 2 19 900x Chestnut St 8 5 1 1     8 5x45   6007445.84949 2120597.53947 37.803176806427004 -122.418438971581 (37.803176806427, -122.418438971581)
163077 87247 1 19 236323 Larkin St 6 5 1 1   02/19/2008 12:00:00 AM 2 3x3 Permit Number 50274 6006692.88945 2119331.74907 37.7996588510331 -122.42095469191601 (37.7996588510331, -122.420954691916)
168446 115307 2 19 1309 Hyde St 1 5 1 1     10 2x2   6007522.861409999 2116889.0118 37.792998452176796 -122.41790942558501 (37.7929984521768, -122.417909425585)
171997 109358 2 19 900x Chestnut St 5 5 1 1     7 5x45   6007454.77295 2120598.70497 37.8031805089291 -122.41840817430901 (37.8031805089291, -122.418408174309)
173674 109355 2 19 900x Chestnut St 2 5 1 1     12 5x45   6007469.51339 2120600.5219 37.8031863275346 -122.41835729337299 (37.8031863275346, -122.418357293373)
85124 85121 1 19 1403 11th Ave 2 5 2 1   02/27/2007 12:00:00 AM 7 2x2 Tree 2. Permit Number 49495. 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
92708 85104 1 19 1403 11th Ave 1 5 2 1     9 2x2 Tree 1 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
Powered by Datasette · Query took 11.228ms · Data source: data.sfgov.org