sf-trees

Data source: data.sfgov.org

Custom SQL query returning 42 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
23870 214333 2 72 312 Hearst Ave 6 9 1 1     4 Width 10ft   5999316.02125 2094400.93218 37.7307864969836 -122.44468833131901 (37.7307864969836, -122.444688331319)
24177 237873 2 72 1200 San Jose Ave 5 9 1 1     11 Width 4ft   6004198.3369 2096122.91618 37.7357920776323 -122.427932046027 (37.7357920776323, -122.427932046027)
26673 237878 2 72 400 Prospect Ave 3 9 1 1     4     6006265.8389800005 2097650.58343 37.7401034599156 -122.420892296036 (37.7401034599156, -122.420892296036)
28361 214344 2 72 498 Vernon St 2 9 1 1     8 Width 10ft   5992505.71978 2091140.82125 37.7214440535804 -122.467995374584 (37.7214440535804, -122.467995374584)
28893 237879 2 72 400 Prospect Ave 4 9 1 1     10     6006275.052019999 2097644.49058 37.74008724961789 -122.420860008587 (37.7400872496179, -122.420860008587)
29047 214358 2 72 550 Joost Ave 2 9 1 1     4     5998446.87478 2095010.46619 37.7324104972266 -122.447736959314 (37.7324104972266, -122.447736959314)
30466 214357 2 72 61 Stillings Ave 2 9 1 1     13 Width 6ft   6000162.633219999 2095683.1648400002 37.7343554844182 -122.441853461362 (37.7343554844182, -122.441853461362)
32056 178850 2 72 178 Dublin St 1 9 1 1     11 Width 5ft   6004207.2935 2089409.6566400002 37.7173594632439 -122.427422984776 (37.7173594632439, -122.427422984776)
37563 178857 2 72 701 Delta St 4 9 1 1     12 Width 3ft   6009291.72599 2087274.3379400002 37.711782574777004 -122.409697761866 (37.711782574777, -122.409697761866)
39041 214326 2 72 121 Miraloma Dr 3 9 1 1     4 Width 2ft   5994581.43196 2096914.1717599998 37.7374159195969 -122.461238551316 (37.7374159195969, -122.461238551316)
43511 237904 2 72 215 Grand View Ave 1 9 1 1     6 Width 5ft   6000729.50411 2103183.58085 37.7549821289444 -122.440431357129 (37.7549821289444, -122.440431357129)
45763 237933 2 72 101 Lower Ter 2 9 1 1     6 Width 3ft   6000440.92976 2106173.77589 37.7631760355812 -122.441643904037 (37.7631760355812, -122.441643904037)
46245 237876 2 72 400 Prospect Ave 1 9 1 1     4     6006280.46143 2097653.37775 37.740111956701 -122.420841935814 (37.740111956701, -122.420841935814)
46953 214356 2 72 811 Congo St 22 9 1 1     4     6000533.92821 2095885.0481 37.7349309587854 -122.44058425268 (37.7349309587854, -122.44058425268)
47303 237934 2 72 101 Lower Ter 3 9 1 1     6 Width 3ft   6000443.264219999 2106174.87839 37.76317919578 -122.441635909067 (37.76317919578, -122.441635909067)
50009 237932 2 72 101 Lower Ter 1 9 1 1     10 Width 3ft   6000437.08664 2106174.23917 37.7631770886698 -122.44165722931601 (37.7631770886698, -122.441657229316)
50181 237877 2 72 400 Prospect Ave 2 9 1 1     5     6006273.45555 2097651.54951 37.7401065418729 -122.420866029569 (37.7401065418729, -122.420866029569)
51929 237924 2 72 47 Seward St 2 9 1 1     15 Width 3ft   6000838.40395 2104323.1770900004 37.7581173832271 -122.440136465844 (37.7581173832271, -122.440136465844)
57629 214334 2 72 470 Hearst Ave 1 9 1 1     2 Width 10ft   5998312.15542 2094413.4318799998 37.7307634815435 -122.448159739578 (37.7307634815435, -122.448159739578)
59899 237911 2 72 414 Collingwood St 4 9 1 1     8     6002101.71196 2103425.3535700003 37.7557240165608 -122.435703175975 (37.7557240165608, -122.435703175975)
60249 196325 2 72 582 Rhode Island St 5 9 1 1     4     6011758.16915 2105659.78061 37.7624030241958 -122.402464984075 (37.7624030241958, -122.402464984075)
62044 214343 2 72 105 Beverly St 1 9 1 1     7 Width 10ft   5991402.99723 2089917.07257 37.7180201978552 -122.47171800938999 (37.7180201978552, -122.47171800939)
62287 214325 2 72 121 Miraloma Dr 2 9 1 1     4 Width 2ft   5994585.09435 2096884.89716 37.7373357495539 -122.461223767378 (37.7373357495539, -122.461223767378)
64642 214336 2 72 165 Marston Ave 1 9 1 1     10     5998449.688130001 2093175.59235 37.727372526598 -122.44759519826401 (37.727372526598, -122.447595198264)
66220 196329 2 72 582 Rhode Island St 9 9 1 1     4     6011758.91837 2105646.20338 37.7623657859795 -122.402461438042 (37.7623657859795, -122.402461438042)
67614 214345 2 72 498 Vernon St 7 9 1 1     4 Width 10ft   5992504.20594 2091177.71285 37.7215452614802 -122.46800328954599 (37.7215452614802, -122.468003289546)
69505 196330 2 72 582 Rhode Island St 11 9 1 1     2     6011759.958869999 2105639.7656 37.7623481673595 -122.40245738661801 (37.7623481673595, -122.402457386618)
74387 214335 2 72 570 Hearst Ave 1 9 1 1     4     5997650.4841 2094424.8417 37.730756962361 -122.450448052843 (37.730756962361, -122.450448052843)
125300 196327 2 72 582 Rhode Island St 7 9 1 1     3     6011756.69483 2105652.08155 37.7623818019909 -122.402469541836 (37.7623818019909, -122.402469541836)
138151 237906 2 72 3937 21st St 3 9 1 1     22 Width 3ft   6002245.415080001 2103514.00804 37.755975601915104 -122.43521254633 (37.7559756019151, -122.43521254633)
138178 214355 2 72 811 Congo St 23 9 1 1     7     6000531.25655 2095885.67636 37.734932531704004 -122.440593534571 (37.734932531704, -122.440593534571)
155852 237881 2 72 400 Prospect Ave 8 9 1 1     2     6006228.09651 2097633.90585 37.7400555395259 -122.42102161048 (37.7400555395259, -122.42102161048)
158642 214324 2 72 121 Miraloma Dr 1 9 1 1     4 Width 2ft   5994586.44209 2096871.4866 37.7372990050334 -122.461218135833 (37.7372990050334, -122.461218135833)
164953 196331 2 72 801 Arkansas St 22 9 1 1     2     6013062.01072 2103694.01523 37.757078165347096 -122.397817553962 (37.7570781653471, -122.397817553962)
165498 237910 2 72 414 Collingwood St 2 9 1 1     26     6002101.86364 2103432.6858200002 37.755744157774295 -122.435703175979 (37.7557441577743, -122.435703175979)
169509 196332 2 72 801 Arkansas St 23 9 1 1     2     6013061.70024 2103702.02862 37.7571001510787 -122.39781918981001 (37.7571001510787, -122.39781918981)
171890 196322 2 72 320 Pennsylvania Ave 2 9 1 1     8 Width 6ft   6014284.29861 2105571.05325 37.7623000976946 -122.393721759867 (37.7623000976946, -122.393721759867)
175828 237890 2 72 101 Bradford St 1 9 1 1     21 Width 10ft   6009586.52326 2097993.57219 37.741231849177396 -122.409434875633 (37.7412318491774, -122.409434875633)
180365 196328 2 72 582 Rhode Island St 8 9 1 1     4     6011759.42256 2105649.40128 37.7623745948457 -122.402459919101 (37.7623745948457, -122.402459919101)
184895 237880 2 72 400 Prospect Ave 7 9 1 1     4     6006230.938630001 2097643.52174 37.7400821028175 -122.42101246614901 (37.7400821028175, -122.421012466149)
186159 196326 2 72 582 Rhode Island St 6 9 1 1     5     6011758.077269999 2105655.2615900002 37.7623906108466 -122.40246498408001 (37.7623906108466, -122.40246498408)
187588 196333 2 72 801 Arkansas St 24 9 1 1     3     6013061.90076 2103711.9152599997 37.757127308803604 -122.397819189808 (37.7571273088036, -122.397819189808)
Powered by Datasette · Query took 40.806ms · Data source: data.sfgov.org