sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
87147 750 3 47 2301X 36th Ave 4 1 1 2   09/19/2016 01:42:00 PM 3 6   5985126.566983701 2099532.1780828 37.7440555948275 -122.494120857895 (37.7440555948275, -122.494120857895)
186596 2255 3 47 700X Brotherhood Way 1 11 1 2     17     5990660.02895 2088282.4204099998 37.713488829713796 -122.474166893001 (37.7134888297138, -122.474166893001)
149883 2256 3 47 700X Brotherhood Way 2 11 1 2     15     5990689.72825 2088261.00769 37.7134317560555 -122.47406268136801 (37.7134317560555, -122.474062681368)
10938 2269 3 47 700X Brotherhood Way 3 11 1 2     6 14M   5990714.96133 2088247.7727 37.7133968776506 -122.473974502829 (37.7133968776506, -122.473974502829)
11028 2270 3 47 700X Brotherhood Way 4 11 1 2     6 14M   5990735.60667 2088236.9442599998 37.7133683412468 -122.473902356505 (37.7133683412468, -122.473902356505)
10618 2271 3 47 700X Brotherhood Way 5 11 1 2     25 14M   5990752.82343 2088228.49759 37.71334614597279 -122.47384223413499 (37.7133461459728, -122.473842234135)
12203 2287 3 47 800X Brotherhood Way 2 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989126.18342 2088688.6181299998 37.7145151729252 -122.47949804711 (37.7145151729252, -122.47949804711)
11963 2289 3 47 800X Brotherhood Way 4 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989454.26944 2088678.0808599999 37.7145052920719 -122.478363292437 (37.7145052920719, -122.478363292437)
10549 2290 3 47 800X Brotherhood Way 5 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989540.89128 2088682.16282 37.714521528411495 -122.478064194121 (37.7145215284115, -122.478064194121)
8584 2988 3 47 2266X California St 3 1 1 2     35 3X3   6003528.90719 2115622.95537 37.7892965998021 -122.431638286196 (37.7892965998021, -122.431638286196)
119658 4989 3 47 5300 Diamond Heights Blvd 6 11 1 2     24 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
87415 5005 3 47 5300 Diamond Heights Blvd 22 11 1 2     50 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
127927 5011 3 47 5300 Diamond Heights Blvd 28 11 1 2     18 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
23130 5046 3 47 5399X Diamond Heights Blvd 7 1 1 2     30     6002013.964380001 2098440.0292 37.7420305128012 -122.43564998647 (37.7420305128012, -122.43564998647)
23021 5047 3 47 5399X Diamond Heights Blvd 8 1 1 2     30     6002007.86459 2098449.21717 37.7420553943514 -122.43567173476002 (37.7420553943514, -122.43567173476)
23106 5048 3 47 5399X Diamond Heights Blvd 9 1 1 2     26     6002000.04243 2098472.35983 37.7421184943815 -122.435700436623 (37.7421184943815, -122.435700436623)
23275 5049 3 47 5399X Diamond Heights Blvd 10 1 1 2     39     6001985.29603 2098499.31047 37.7421916569134 -122.43575335275101 (37.7421916569134, -122.435753352751)
23006 5050 3 47 5399X Diamond Heights Blvd 11 1 1 2     19     6001979.62541 2098516.88417 37.7422395880754 -122.43577421703002 (37.7422395880754, -122.43577421703)
23290 5051 3 47 5399X Diamond Heights Blvd 12 1 1 2     16     6001971.36584 2098533.18854 37.7422838868872 -122.43580394232 (37.7422838868872, -122.43580394232)
23272 5052 3 47 5399X Diamond Heights Blvd 13 1 1 2     27     6001966.9976699995 2098545.79058 37.742318241009606 -122.43581994754999 (37.7423182410096, -122.43581994755)
22142 8214 3 47 2189X Funston Ave 5 11 1 2     6 8X25   5992287.42413 2100535.51604 37.747226921486295 -122.469433461595 (37.7472269214863, -122.469433461595)
95966 8220 3 47 2100X Funston Ave 11 11 1 2     6 8X25   5992292.4750795 2101127.8707395 37.748853667046106 -122.46945910791901 (37.7488536670461, -122.469459107919)
90449 8221 3 47 2100X Funston Ave 12 11 1 2     6 8X25   5992292.4750795 2101127.8707395 37.748853667046106 -122.46945910791901 (37.7488536670461, -122.469459107919)
6794 8396 3 47 1500 Geary Blvd 7 11 1 2   06/09/1994 12:00:00 AM 6 8   6004125.3824 2113965.9717 37.7847807304874 -122.429456338379 (37.7847807304874, -122.429456338379)
4214 8397 3 47 1500 Geary Blvd 8 11 1 2     18 8   6004036.9348 2113953.0096 37.7847401317276 -122.42976141314301 (37.7847401317276, -122.429761413143)
6510 8398 3 47 1500 Geary Blvd 9 11 1 2     18 8   6003997.2859 2113948.4347 37.784725324941604 -122.429898258777 (37.7847253249416, -122.429898258777)
6096 8399 3 47 1500 Geary Blvd 10 11 1 2     18 8   6003960.687000001 2113944.6223 37.7847127843654 -122.430024606782 (37.7847127843654, -122.430024606782)
4098 8400 3 47 1500 Geary Blvd 11 11 1 2     18 8   6003921.0381 2113941.5724 37.7847021645415 -122.430161561145 (37.7847021645415, -122.430161561145)
7230 8401 3 47 1500 Geary Blvd 12 11 1 2     18 8   6003886.7265 2113933.9476 37.7846792853457 -122.43027972368401 (37.7846792853457, -122.430279723684)
23079 8464 3 47 1900 Geary Blvd 1 11 1 2     17 8   6002427.515 2113723.6274 37.784019039174794 -122.435313053048 (37.7840190391748, -122.435313053048)
4512 8466 3 47 1900 Geary Blvd 3 11 1 2     36 8   6002359.1538 2113715.5053 37.7839928555225 -122.435548976348 (37.7839928555225, -122.435548976348)
4399 8467 3 47 1900 Geary Blvd 4 11 1 2     36 8   6002321.2505 2113708.7369 37.783972118374 -122.435679623339 (37.783972118374, -122.435679623339)
6463 8468 3 47 1900 Geary Blvd 5 11 1 2     36 8   6002285.3778 2113701.9684 37.7839514961521 -122.435803245129 (37.7839514961521, -122.435803245129)
5929 8470 3 47 1900 Geary Blvd 7 11 1 2     36 8   6002187.2355 2113695.2 37.7839273365059 -122.43614229642701 (37.7839273365059, -122.436142296427)
8647 8473 3 47 1900 Geary Blvd 10 11 1 2     48 8   6001933.4192 2113657.2968 37.7838088404542 -122.437017691332 (37.7838088404542, -122.437017691332)
6721 8476 3 47 1900 Geary Blvd 13 11 1 2     48 8   6001756.762999999 2113633.6072 37.783733752237 -122.437627157513 (37.783733752237, -122.437627157513)
8879 8531 3 47 2100 Geary Blvd 2 11 1 2     24 6   6001578.5839 2113601.7956 37.783636273313604 -122.43824130906401 (37.7836362733136, -122.438241309064)
503 8533 3 47 2100 Geary Blvd 4 11 1 2     18 6   6001504.6387 2113566.4305 37.783534963845 -122.43849459602801 (37.783534963845, -122.438494596028)
815 8534 3 47 2100 Geary Blvd 5 11 1 2   06/10/1994 12:00:00 AM 6 6   6001381.7916 2113512.2830000003 37.78337929999999 -122.43891571692801 (37.7833793, -122.438915716928)
7140 8579 3 47 2200 Geary Blvd 6 11 1 2     18 6   6000836.5941 2113437.661 37.7831433729932 -122.440796526182 (37.7831433729932, -122.440796526182)
1561 8580 3 47 2200 Geary Blvd 7 11 1 2   06/01/1994 12:00:00 AM 6 6   6000778.3855 2113430.8926 37.783121473536795 -122.44099741813 (37.7831214735368, -122.44099741813)
5633 8583 3 47 2200 Geary Blvd 10 11 1 2     36 6   6000590.222999999 2113406.0186 37.7830424571155 -122.441646596602 (37.7830424571155, -122.441646596602)
6839 8584 3 47 2200 Geary Blvd 11 11 1 2     36 6   6000533.0297 2113398.5733 37.7830187554699 -122.441843926918 (37.7830187554699, -122.441843926918)
1776 8585 3 47 2200 Geary Blvd 12 11 1 2   06/01/1994 12:00:00 AM 6 6   6000465.007 2113386.3901 37.78298142730029 -122.442078382069 (37.7829814273003, -122.442078382069)
7773 8602 3 47 2400 Geary Blvd 2 11 1 2     36 6   6000066.0077 2113328.1816 37.7827988555755 -122.44345456827601 (37.7827988555755, -122.443454568276)
2531 8603 3 47 2400 Geary Blvd 3 11 1 2     36 6   5999987.1554 2113318.7057 37.782768340075606 -122.443726682203 (37.7827683400756, -122.443726682203)
8960 8622 3 47 2600 Geary Blvd 10 11 1 2     12 20   5999315.0497 2113216.8408 37.782450288182 -122.44604454634701 (37.782450288182, -122.446044546347)
8713 8650 3 47 2800 Geary Blvd 2 11 1 2     6 M6   5998245.1291 2113130.374 37.7821517178635 -122.449739754186 (37.7821517178635, -122.449739754186)
142607 11185 3 47 110 Idora Ave 1 11 1 2     48 8   5995900.4612004 2099322.604417 37.744104705607704 -122.45685222203001 (37.7441047056077, -122.45685222203)
127498 11191 3 47 148 Idora Ave 1 11 1 2     48 8   5995624.0655798 2099382.6906533 37.7442538125131 -122.457812277707 (37.7442538125131, -122.457812277707)
20319 11702 3 47 700X Junipero Serra Blvd 19 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991290.07475 2092800.9455099998 37.7259320662922 -122.47231844175501 (37.7259320662922, -122.472318441755)
17727 11703 3 47 700X Junipero Serra Blvd 20 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991288.65534 2092789.2072 37.725899753665104 -122.47232249319299 (37.7258997536651, -122.472322493193)
17929 11710 3 47 700X Junipero Serra Blvd 27 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991285.51963 2092735.44075 37.7257519428913 -122.47232941528699 (37.7257519428913, -122.472329415287)
17118 11746 3 47 700X Junipero Serra Blvd 29 11 1 2   03/03/2006 12:00:00 AM 3 6X6   5991277.67104 2092671.80389 37.7255767576586 -122.472351910013 (37.7255767576586, -122.472351910013)
17468 11748 3 47 700X Junipero Serra Blvd 31 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991276.77165 2092652.88165 37.7255247498407 -122.472353640304 (37.7255247498407, -122.472353640304)
85296 12456 1 47 307 Lake Merced Blvd 1 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
145293 12457 1 47 307 Lake Merced Blvd 2 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
79934 12458 1 47 307 Lake Merced Blvd 3 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
108403 12459 1 47 307 Lake Merced Blvd 4 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
127369 12460 1 47 307 Lake Merced Blvd 5 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
101961 12461 1 47 307 Lake Merced Blvd 6 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
140349 12462 1 47 307 Lake Merced Blvd 7 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
93559 12463 1 47 307 Lake Merced Blvd 8 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
138346 12464 1 47 307 Lake Merced Blvd 9 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
111079 12465 1 47 307 Lake Merced Blvd 10 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
77359 12466 1 47 307 Lake Merced Blvd 11 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
100881 12467 1 47 307 Lake Merced Blvd 12 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
96684 12468 1 47 307 Lake Merced Blvd 13 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
81281 12469 1 47 307 Lake Merced Blvd 14 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
144723 12470 1 47 307 Lake Merced Blvd 15 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
104160 12471 1 47 307 Lake Merced Blvd 16 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
98709 12472 1 47 307 Lake Merced Blvd 17 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
115085 12473 1 47 307 Lake Merced Blvd 18 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
116784 12474 1 47 307 Lake Merced Blvd 19 1 1 13     24 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
91597 12475 1 47 307 Lake Merced Blvd 20 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
145316 12476 1 47 307 Lake Merced Blvd 21 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
118813 12477 1 47 307 Lake Merced Blvd 22 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
111984 12478 1 47 307 Lake Merced Blvd 23 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
113404 12479 1 47 307 Lake Merced Blvd 24 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
78443 12480 1 47 307 Lake Merced Blvd 25 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
116167 12481 1 47 307 Lake Merced Blvd 26 1 1 13     36 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
96901 12482 1 47 307 Lake Merced Blvd 27 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
78476 12483 1 47 307 Lake Merced Blvd 28 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
84240 12484 1 47 307 Lake Merced Blvd 29 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
117794 12485 1 47 307 Lake Merced Blvd 30 1 1 13     36 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
121516 12486 1 47 307 Lake Merced Blvd 31 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
107010 12487 1 47 307 Lake Merced Blvd 32 1 1 13     24 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
138304 12489 1 47 307 Lake Merced Blvd 34 1 1 13     18 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
113400 12491 1 47 307 Lake Merced Blvd 36 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
124901 12497 1 47 307 Lake Merced Blvd 42 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
126959 12498 1 47 307 Lake Merced Blvd 43 1 1 13     12 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
77993 12500 3 47 1200X Lake Merced Blvd 2 11 1 2     6 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
90329 12501 3 47 1200X Lake Merced Blvd 3 11 1 2     6 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
91431 12502 3 47 1200X Lake Merced Blvd 4 11 1 2     12 8   5987438.4549992 2087542.2692131 37.7112694082243 -122.485247377649 (37.7112694082243, -122.485247377649)
144625 13284 3 47 2576 Lombard St 1 1 1 2   10/26/1993 12:00:00 AM 26 3X3   6000068.810330001 2119230.46658 37.799005143246 -122.443869066799 (37.799005143246, -122.443869066799)
6783 14432 3 47 90X Masonic Ave 4 11 1 2     50 3X3   5998887.9614 2113022.2482 37.781891589698894 -122.44750806785801 (37.7818915896989, -122.447508067858)
5866 14435 3 47 90X Masonic Ave 7 11 1 2     40 3X3   5998902.8519 2113071.3194 37.7820271773983 -122.447460087026 (37.7820271773983, -122.447460087026)
110448 15988 3 47 236 Moncada Way 1 11 1 2     48 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
17384 16354 3 47 1500X Monterey Blvd 4 11 1 2     18 4-HOA   5993443.33225 2095241.5642099997 37.7327577911269 -122.465052016742 (37.7327577911269, -122.465052016742)
3981 18927 3 47 2691 Sacramento St 1 1 1 2     6 3X3   6001960.28459 2115686.06098 37.7893808348161 -122.437070045665 (37.7893808348161, -122.437070045665)
10904 19431 3 47 1200X Sloat Blvd 4 11 1 2   11/13/2007 12:00:00 AM 6 20   5987714.9376 2095926.0092 37.7343051218756 -122.48490645815501 (37.7343051218756, -122.484906458155)
Powered by Datasette · Query took 17.553ms · Data source: data.sfgov.org