sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
79921 1719 1 15 50X Bay St 1 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
142437 1720 1 15 50X Bay St 2 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
125164 1721 1 15 50X Bay St 3 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
107737 1722 1 15 50X Bay St 4 1 1 13     6 3x9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
115308 1723 1 15 50X Bay St 5 1 1 13     12 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
112223 1724 1 15 50X Bay St 6 1 1 13     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
102952 1725 1 15 50X Bay St 7 1 1 13   12/15/1992 12:00:00 AM 6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
97827 1726 1 15 50X Bay St 8 1 1 13     12 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
114188 1727 1 15 50X Bay St 9 1 1 13     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
126259 1728 1 15 50X Bay St 10 1 1 13     12 3x9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
143982 1729 1 15 50X Bay St 11 1 1 13     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
121717 1730 1 15 50X Bay St 12 1 1 13     18 3x9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
112155 1731 1 15 50X Bay St 13 1 1 13     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
96617 1732 1 15 50X Bay St 14 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
118758 1733 1 15 50X Bay St 15 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
84379 1734 1 15 50X Bay St 16 1 1 13     36 3x9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
124401 1735 1 15 50X Bay St 17 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
86191 1736 1 15 50X Bay St 18 1 1 13     18 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
49118 1737 1 15 50X Bay St 19 1 1 13     18 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
2320 1739 1 15 111 Bay St 2 1 1 13   08/19/2006 12:00:00 AM 3     6010211.1306 2121614.8438 37.8061253525476 -122.408941413862 (37.8061253525476, -122.408941413862)
8258 1740 1 15 111 Bay St 3 1 1 13     12 5   6010239.3355 2121619.2312 37.8061389791251 -122.408844115422 (37.8061389791251, -122.408844115422)
5751 1741 1 15 111 Bay St 4 1 1 13     12 5   6010277.5688 2121623.6186 37.8061531673047 -122.408712111835 (37.8061531673047, -122.408712111835)
8654 1742 1 15 111 Bay St 5 1 1 13     12 5   6010362.8102 2121638.0345 37.8061975236724 -122.408418135849 (37.8061975236724, -122.408418135849)
6111 1744 1 15 111 Bay St 7 1 1 13     18 5   6010455.5729 2121649.3164 37.806233695246796 -122.40809790947901 (37.8062336952468, -122.408097909479)
6981 1746 1 15 111 Bay St 9 1 1 13     24 5   6010500.0739 2121656.211 37.8062551176462 -122.40794439194401 (37.8062551176462, -122.407944391944)
8663 1747 1 15 111 Bay St 10 1 1 13     18 5   6010526.3985 2121656.8377 37.80625831218661 -122.40785333492902 (37.8062583121866, -122.407853334929)
6698 1748 1 15 111 Bay St 11 1 1 13     18 5   6010555.2301 2121661.2252 37.806271973223794 -122.407753867308 (37.8062719732238, -122.407753867308)
8833 1749 1 15 111 Bay St 12 1 1 13     18 5   6010575.9137 2121665.6126 37.8062851777933 -122.40768259734502 (37.8062851777933, -122.407682597345)
7132 1750 1 15 111 Bay St 13 1 1 13     18 5   6010626.0557 2121671.8803 37.8063051940875 -122.4075095136 (37.8063051940875, -122.4075095136)
8607 1751 1 15 111 Bay St 14 1 1 13     24 5   6010656.7677 2121676.8945 37.8063206808441 -122.40740358257901 (37.8063206808441, -122.407403582579)
7500 1752 1 15 111 Bay St 15 1 1 13     24 5   6010681.2119 2121680.6552 37.806332374912294 -122.40731925401899 (37.8063323749123, -122.407319254019)
97364 1754 1 15 111 Bay St 17 1 1 13     12 5   6010168.4492363 2121611.1016263003 37.8061126865638 -122.409088856241 (37.8061126865638, -122.409088856241)
119036 1755 1 15 111 Bay St 18 1 1 13     12 5   6010168.4492363 2121611.1016263003 37.8061126865638 -122.409088856241 (37.8061126865638, -122.409088856241)
99468 1756 1 15 111 Bay St 19 1 1 13     24 5   6010168.4492363 2121611.1016263003 37.8061126865638 -122.409088856241 (37.8061126865638, -122.409088856241)
2990 11143 1 41 2553X Hyde St 1 1 1 13     36 3X3   6006932.12852 2121148.49105 37.804660646434996 -122.42025584765301 (37.804660646435, -122.420255847653)
1980 11144 1 41 2553X Hyde St 2 1 1 13     36 3X3   6006934.8566 2121129.59308 37.8046089111446 -122.42024506476801 (37.8046089111446, -122.420245064768)
103862 11145 1 41 2595X Hyde St 1 1 1 13     36 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
128539 11146 1 41 2595X Hyde St 2 1 1 13     40 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
140009 11147 1 41 2595X Hyde St 3 1 1 13     6 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
101063 11148 1 41 2595X Hyde St 4 1 1 13     40 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
120483 11149 1 41 2595X Hyde St 5 1 1 13     36 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
99823 11150 1 41 2595X Hyde St 6 1 1 13     36 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
138383 11151 1 41 2595X Hyde St 7 1 1 13     36 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
113524 11152 1 41 2595X Hyde St 8 1 1 13     36 3X3   6006932.7654086 2121177.816266 37.804741201891495 -122.420255726238 (37.8047412018915, -122.420255726238)
109658 11633 1 53 499X Junipero Serra Blvd 1 1 1 13     30 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
93732 11634 1 83 499X Junipero Serra Blvd 2 1 1 13     12 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
125554 11635 1 2 499X Junipero Serra Blvd 3 1 1 13     18 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
49592 11636 1 83 499X Junipero Serra Blvd 4 1 1 13     12 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
140923 11637 1 40 499X Junipero Serra Blvd 5 1 1 13     18 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
109059 11648 1 60 699X Junipero Serra Blvd 3 1 1 13   01/28/2000 12:00:00 AM 3 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
118144 11649 1 2 699X Junipero Serra Blvd 4 1 1 13     12 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
139267 11650 1 2 699X Junipero Serra Blvd 5 1 1 13     12 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
128581 11651 1 12 699X Junipero Serra Blvd 8 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
19674 11652 1 53 699X Junipero Serra Blvd 9 1 1 13     18 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
141005 11653 1 60 699X Junipero Serra Blvd 10 1 1 13     18 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
93707 11654 1 60 699X Junipero Serra Blvd 13 1 1 13     30 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
86802 11655 1 2 699X Junipero Serra Blvd 15 1 1 13     12 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
100073 11656 1 53 699X Junipero Serra Blvd 16 1 1 13     18 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
97990 11657 1 83 699X Junipero Serra Blvd 18 1 1 13     12 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
78605 11658 1 60 699X Junipero Serra Blvd 19 1 1 13     24 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
86056 11659 1 60 699X Junipero Serra Blvd 20 1 1 13     12 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
113884 11686 1 53 799X Junipero Serra Blvd 8 1 1 13     30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
79051 11687 1 2 799X Junipero Serra Blvd 1 1 1 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
86583 11688 1 60 799X Junipero Serra Blvd 5 1 1 13     36 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
113163 11689 1 53 799X Junipero Serra Blvd 2 1 1 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
85915 11690 1 53 799X Junipero Serra Blvd 6 1 1 13     30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
122590 11691 1 60 799X Junipero Serra Blvd 7 1 1 13   03/17/2001 12:00:00 AM 9 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
91904 11692 1 53 799X Junipero Serra Blvd 9 1 1 13     24 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
105506 11693 1 60 799X Junipero Serra Blvd 10 1 1 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
88556 11694 1 53 799X Junipero Serra Blvd 11 1 1 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
111277 11695 1 53 799X Junipero Serra Blvd 12 1 1 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
79297 11696 1 53 799X Junipero Serra Blvd 15 1 1 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
88676 11697 1 60 799X Junipero Serra Blvd 21 1 1 13   06/21/1995 12:00:00 AM 6 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
89131 11698 1 12 799X Junipero Serra Blvd 19 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
91670 11699 1 60 799X Junipero Serra Blvd 24 1 1 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
109280 11700 1 15 799X Junipero Serra Blvd 32 1 1 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
77637 11714 1 12 899X Junipero Serra Blvd 1 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
105606 11715 1 60 899X Junipero Serra Blvd 2 1 1 13   06/15/1995 12:00:00 AM 12 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
143977 11717 1 60 899X Junipero Serra Blvd 5 1 1 13   03/08/2005 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
118796 11718 1 53 899X Junipero Serra Blvd 7 1 1 13     36 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
32415 11719 1 60 899X Junipero Serra Blvd 9 1 1 13     30 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
127364 11720 1 60 899X Junipero Serra Blvd 11 1 1 13     24 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
117588 11721 1 2 899X Junipero Serra Blvd 12 1 1 13     12 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
108076 11722 1 53 899X Junipero Serra Blvd 13 1 1 13     18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
92648 11723 1 2 899X Junipero Serra Blvd 14 1 1 13     18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
144393 11724 1 60 899X Junipero Serra Blvd 18 1 1 13   03/17/2001 12:00:00 AM 12 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
139141 11725 1 12 899X Junipero Serra Blvd 20 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
141711 11726 1 119 899X Junipero Serra Blvd 21 1 1 13   06/15/1995 12:00:00 AM 18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
124190 11727 1 60 899X Junipero Serra Blvd 22 1 1 13   06/15/1995 12:00:00 AM 12 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
103241 11760 1 60 999X Junipero Serra Blvd 1 1 1 13     24 3x3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
101927 11761 1 12 999X Junipero Serra Blvd 3 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
81627 11762 1 60 999X Junipero Serra Blvd 6 1 1 13     24 3X3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
125704 11772 1 60 1199X Junipero Serra Blvd 16 1 1 13   06/23/1995 12:00:00 AM 12 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
121435 11773 1 5 1199X Junipero Serra Blvd 18 1 1 13     18 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
79124 11774 1 5 1199X Junipero Serra Blvd 19 1 1 13     18 2x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
86430 11785 1 60 1199X Junipero Serra Blvd 1 1 1 13     30 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
116303 11786 1 12 1199X Junipero Serra Blvd 2 1 1 13   03/17/2001 12:00:00 AM 6 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
111936 11787 1 5 1199X Junipero Serra Blvd 6 1 1 13     12 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
92042 11788 1 5 1199X Junipero Serra Blvd 8 1 1 13     18 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
102978 11789 1 5 1199X Junipero Serra Blvd 10 1 1 13     24 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
142712 11790 1 60 1199X Junipero Serra Blvd 12 1 1 13     24 3x4   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
Powered by Datasette · Query took 4.199ms · Data source: data.sfgov.org