sf-trees

Data source: data.sfgov.org

Custom SQL query returning 34 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
69 19206 3 30 630 Sansome St 4 1 1 2     12 3X3   6012230.08543 2117977.14861 37.7962500076802 -122.40169859442699 (37.7962500076802, -122.401698594427)
2850 27607 3 30 1377 Fulton St 1 1 1 2     3 3X3   6001133.4058 2111053.0447 37.7766127217509 -122.439598674592 (37.7766127217509, -122.439598674592)
3315 20250 3 30 1880 Steiner St 3 1 1 2     3 3X3   6002537.9918 2114673.3066 37.78663289034311 -122.43499878671301 (37.7866328903431, -122.434998786713)
6797 27608 3 30 1377 Fulton St 2 1 1 2     3 3X3   6001149.4313 2111053.53 37.776614966343296 -122.439543272646 (37.7766149663433, -122.439543272646)
7797 6925 3 30 460 Fell St 1 1 1 2     6 3X3   6005200.4571 2110629.3361 37.7756799587692 -122.42549938705099 (37.7756799587692, -122.425499387051)
8677 18861 1 30 2200 Sacramento St 1 1 1 1     5 3X3   6004226.06461 2116051.48796 37.790512733214 -122.42925677349 (37.790512733214, -122.42925677349)
9146 4532 1 30 45 Cleary Ct 3 1 1 1     12 3X3   6005027.0371 2113673.2533 37.784028006637996 -122.42631605911998 (37.784028006638, -122.42631605912)
9151 4530 1 30 45 Cleary Ct 1 1 1 1     18 3X3   6004963.1338 2113665.364 37.7840027322121 -122.426536579485 (37.7840027322121, -122.426536579485)
9193 4549 1 30 85 Cleary Ct 1 1 1 1     12 3X3   6004652.295 2113623.5507 37.7838703460943 -122.427608988739 (37.7838703460943, -122.427608988739)
9249 4552 1 30 85 Cleary Ct 4 1 1 1     12 3X3   6004747.7557 2113637.7514 37.7839147367985 -122.42727974188101 (37.7839147367985, -122.427279741881)
9257 4531 1 30 45 Cleary Ct 2 1 1 1     12 3X3   6004996.2689 2113667.7308 37.7840111039908 -122.426422112629 (37.7840111039908, -122.426422112629)
9465 4553 1 30 85 Cleary Ct 5 1 1 1     18 3X3   6004771.4236 2113636.9625 37.7839139091534 -122.427197803426 (37.7839139091534, -122.427197803426)
16227 7404 3 30 1060 Folsom St 1 1 1 2   05/28/1992 12:00:00 AM 24 3X3   6010543.2443 2111181.3457 37.777496075538004 -122.407056190657 (37.777496075538, -122.407056190657)
17244 25180 3 30 3226 Market St 2 1 1 2   04/18/1996 12:00:00 AM 6 3X3   5999422.34121 2104738.79635 37.7591778511874 -122.445063681349 (37.7591778511874, -122.445063681349)
17457 25179 3 30 3226 Market St 1 1 1 2   04/18/1996 12:00:00 AM 6 3X3   5999420.685330001 2104753.2461200003 37.7592174321694 -122.445070446966 (37.7592174321694, -122.445070446966)
18345 16909 3 30 457 Oak St 2 1 1 2   12/15/2009 12:00:00 AM 18 3X3   6004854.34153 2110178.37501 37.7744221674765 -122.42666456674101 (37.7744221674765, -122.426664566741)
20331 25181 3 30 3226 Market St 3 1 1 2   04/18/1996 12:00:00 AM 6 3X3   5999423.66493 2104708.37976 37.7590944103092 -122.44505691664101 (37.7590944103092, -122.445056916641)
22166 25182 3 30 3226 Market St 4 1 1 2   04/18/1996 12:00:00 AM 3 3X3   5999429.9273 2104670.84771 37.7589917140099 -122.4450325603 (37.7589917140099, -122.4450325603)
61696 4545 3 30 66 Cleary Ct 8 1 1 2     6 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
77532 4538 3 30 66 Cleary Ct 1 1 1 2     6 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
79949 4516 1 30 20X Cleary Ct 6 1 1 1     6 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.42642640211099 (37.7846101140023, -122.426426402111)
87087 4518 3 30 20X Cleary Ct 8 1 1 2     6 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.42642640211099 (37.7846101140023, -122.426426402111)
95689 16894 1 30 361 Oak St 1 1 1 1   06/14/2008 12:00:00 AM 3 3X3   6005282.37962 2110221.51905 37.7745648206797 -122.42518697132401 (37.7745648206797, -122.425186971324)
96001 7147 3 30 685X Oak St 4 1 1 2     18 3X3   6003730.753719999 2110025.58578 37.7739390589029 -122.430540363958 (37.7739390589029, -122.430540363958)
97235 4548 1 30 66 Cleary Ct 11 1 1 1     3 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
99626 4541 3 30 66 Cleary Ct 4 1 1 2     6 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
111944 16905 1 30 441 Oak St 1 1 1 1   12/10/2009 12:00:00 AM 3 3X3   6004878.06154 2110135.30859 37.774305258573996 -122.426579447402 (37.774305258574, -122.426579447402)
118583 26205 3 30 750 San Jose Ave 2 1 1 2   07/20/2007 12:00:00 AM 12 3X3   6005640.0872799 2098758.1364942 37.743109258996206 -122.423134597972 (37.7431092589962, -122.423134597972)
119172 4547 1 30 66 Cleary Ct 10 1 1 1     12 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
120267 27626 1 30 2310X Taylor St 3 1 1 1     3 3X3   6008495.093859999 2120769.31703 37.8037074748624 -122.41482018433399 (37.8037074748624, -122.414820184334)
121552 4543 3 30 66 Cleary Ct 6 1 1 2   09/21/1994 12:00:00 AM 12 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
122987 4550 3 30 85 Cleary Ct 2 1 1 2     12 3X3   6004735.0847094 2113637.0202701 37.783912012698394 -122.427323526754 (37.7839120126984, -122.427323526754)
138646 4517 3 30 20X Cleary Ct 7 1 1 2     6 3X3   6004999.51904 2113885.82273 37.7846101140023 -122.42642640211099 (37.7846101140023, -122.426426402111)
144085 4551 3 30 85 Cleary Ct 3 1 1 2   07/11/1991 12:00:00 AM 24 3X3   6004735.0847094 2113637.0202701 37.783912012698394 -122.427323526754 (37.7839120126984, -122.427323526754)
Powered by Datasette · Query took 9.284ms · Data source: data.sfgov.org