sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
14328 29834 1 21 1700X Evans Ave 1 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015058.47657 2099001.06615 37.7443032965649 -122.390585032484 (37.7443032965649, -122.390585032484)
15882 29835 1 21 1700X Evans Ave 2 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015037.39009 2099016.77397 37.744345257128295 -122.390659043104 (37.7443452571283, -122.390659043104)
15770 29836 1 21 1700X Evans Ave 3 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015024.36841 2099025.2141299997 37.744367709607296 -122.390704659402 (37.7443677096073, -122.390704659402)
16509 29837 1 21 1700X Evans Ave 4 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015003.68842 2099041.04772 37.744410037986704 -122.39077727337099 (37.7444100379867, -122.390777273371)
13529 29838 1 21 1700X Evans Ave 5 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014986.46906 2099054.93467 37.7444472132656 -122.39083778516 (37.7444472132656, -122.39083778516)
16702 29840 1 21 1700X Evans Ave 7 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014944.2776 2099085.41213 37.7445285569526 -122.390985805465 (37.7445285569526, -122.390985805465)
13422 29844 1 21 1700X Evans Ave 10 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014896.13106 2099120.97008 37.74462351995 -122.39115477280001 (37.74462351995, -122.3911547728)
16061 29846 1 21 1700X Evans Ave 11 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014879.93963 2099132.42343 37.7446540699209 -122.391211560464 (37.7446540699209, -122.391211560464)
15365 29858 1 15 1700X Evans Ave 13 1 1 13     12 4X4   6014689.41423 2099276.62431 37.7450394402319 -122.391880446552 (37.7450394402319, -122.391880446552)
83384 17658 1 85 1000X Phelps St 3 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
87807 17661 1 85 1000X Phelps St 6 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104025 17656 1 85 1000X Phelps St 1 1 1 13   11/15/1992 12:00:00 AM 6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104908 17662 1 85 1000X Phelps St 7 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
117411 17659 1 85 1000X Phelps St 4 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
125491 17660 1 85 1000X Phelps St 5 1 1 13     12 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
125710 85667 1 254 639 Bryant St 3 1 1 13   04/23/2007 12:00:00 AM 3 3x3   6012912.0 2111624.0 37.77884377468779 -122.39889289846501 (37.7788437746878, -122.398892898465)
104270 75029 2 80 141X Arleta Ave 1 1 1 13 1 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
104340 74892 2 80 141X Arleta Ave 2 1 1 13 1 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
133018 116821 2 15 111 Bay St 8 7 1 13     14     6010478.7636 2121651.8235 37.806241877556 -122.408017830638 (37.806241877556, -122.408017830638)
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)
59669 116819 2 15 111 Bay St 6 7 1 13     11     6010427.9948 2121647.4361 37.8062269882557 -122.40819321595501 (37.8062269882557, -122.408193215955)
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)
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)
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)
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)
17977 116827 2 15 111 BAY ST 14 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
83489 116828 2 15 111 BAY ST 15 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
83621 116826 2 15 111 BAY ST 13 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
85395 116822 2 15 111 BAY ST 9 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
92074 116820 2 15 111 BAY ST 7 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
93526 116831 2 15 111 BAY ST 18 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
94354 116825 2 15 111 BAY ST 12 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
99346 116823 2 15 111 BAY ST 10 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
107057 116830 2 15 111 BAY ST 17 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
110974 116818 2 15 111 BAY ST 5 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
111971 116809 2 15 111 BAY ST 1 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
126108 116824 2 15 111 BAY ST 11 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
127145 116817 2 15 111 BAY ST 4 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
139776 116829 2 15 111 BAY ST 16 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
144844 116816 2 15 111 BAY ST 3 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
146001 116815 2 15 111 BAY ST 2 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
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)
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)
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)
144887 116832 2 15 2 Midway St 7 7 1 13           6010125.275107 2121295.55695439 37.8052438606833 -122.409215987298 (37.8052438606833, -122.409215987298)
96335 107866 2 60 300 ALEMANY BLVD 1 5 1 13     15 3x3   6008820.4 2095497.5 37.734335221774394 -122.411907523711 (37.7343352217744, -122.411907523711)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
97919 11876 1 46 1501X Junipero Serra Blvd 2 1 1 13     12 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061)
107376 11877 1 46 1501X Junipero Serra Blvd 3 1 1 13     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061)
128325 11875 1 407 1501X Junipero Serra Blvd 1 1 1 13     18 3x3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061)
139746 11878 1 46 1501X Junipero Serra Blvd 4 1 1 13     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061)
105274 11872 1 442 1499X Junipero Serra Blvd 2 1 1 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
106977 11873 1 53 1499X Junipero Serra Blvd 3 1 1 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
125399 11871 1 53 1499X Junipero Serra Blvd 1 1 1 13     24 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
141240 11874 1 53 1499X Junipero Serra Blvd 4 1 1 13     30 3   5991566.5284818 2087248.8358641004 37.7107033285334 -122.470958490818 (37.7107033285334, -122.470958490818)
9947 11824 1 12 1299X Junipero Serra Blvd 14 2 1 13   03/13/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
96683 11823 1 5 1299X Junipero Serra Blvd 15 1 1 13     24 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
114303 11822 1 2 1299X Junipero Serra Blvd 16 2 1 13     10 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
118852 11820 1 5 1299X Junipero Serra Blvd 7 1 1 13     12 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
18608 24390 1 60 501X Junipero Serra Blvd 6 1 1 13   06/22/1995 12:00:00 AM 6 3   5991485.44871 2094112.7680400002 37.7295453093597 -122.471738611958 (37.7295453093597, -122.471738611958)
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)
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)
Powered by Datasette · Query took 4.537ms · Data source: data.sfgov.org