sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
146001 116815 2 15 111 BAY ST 2 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
145860 24413 1 60 1199X Junipero Serra Blvd 13 1 1 13   06/22/1995 12:00:00 AM 6 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
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)
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)
144887 116832 2 15 2 Midway St 7 7 1 13           6010125.275107 2121295.55695439 37.8052438606833 -122.409215987298 (37.8052438606833, -122.409215987298)
144844 116816 2 15 111 BAY ST 3 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
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)
144673 26172 1 60 799X Junipero Serra Blvd 17 1 1 13     12 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
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)
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)
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)
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)
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)
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)
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)
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)
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)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
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)
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)
139776 116829 2 15 111 BAY ST 16 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
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)
139406 11819 1 2 1201X Junipero Serra Blvd 5 1 1 13     6 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
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)
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)
138768 87709 1 12 999X Junipero Serra Blvd 8 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
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)
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)
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)
133018 116821 2 15 111 Bay St 8 7 1 13     14     6010478.7636 2121651.8235 37.806241877556 -122.408017830638 (37.806241877556, -122.408017830638)
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)
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)
128386 87705 1 12 899X Junipero Serra Blvd 19 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.7238979999 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777)
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)
127942 24412 1 60 1199X Junipero Serra Blvd 15 1 1 13   06/23/1995 12:00:00 AM 12 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
127707 11818 1 2 1201X Junipero Serra Blvd 4 1 1 13     6 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
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)
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)
127145 116817 2 15 111 BAY ST 4 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
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)
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)
126108 116824 2 15 111 BAY ST 11 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
125742 24458 1 60 999X Junipero Serra Blvd 14 1 1 13   03/17/2001 12:00:00 AM 6 3X3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
125729 24394 1 12 699X Junipero Serra Blvd 11 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
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)
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)
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)
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)
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)
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)
125010 24410 1 12 1199X Junipero Serra Blvd 4 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
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)
124553 87699 1 12 799X Junipero Serra Blvd 14 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
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)
124387 24396 1 12 699X Junipero Serra Blvd 14 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
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)
123921 24406 1 60 999X Junipero Serra Blvd 11 1 1 13   01/28/2000 12:00:00 AM 6 3x3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
122991 11815 1 5 1201X Junipero Serra Blvd 1 1 1 13     6 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
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)
121766 85427 1 53 799X Junipero Serra Blvd 18 1 1 13     18 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
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)
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)
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)
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)
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)
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)
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)
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)
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)
118719 87632 1 12 900X Junipero Serra Blvd 8 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
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)
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)
117787 24405 1 60 999X Junipero Serra Blvd 10 1 1 13   01/28/2000 12:00:00 AM 12 3X3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
117628 27826 1 60 799X Junipero Serra Blvd 26 1 1 13   03/08/2005 12:00:00 AM 3 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
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)
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)
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)
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)
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)
115573 24395 1 60 699X Junipero Serra Blvd 21 1 1 13   06/22/1995 12:00:00 AM 6 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
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)
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)
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)
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)
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)
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)
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)
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)
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)
112455 11817 1 5 1201X Junipero Serra Blvd 3 1 1 13     12 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
112345 26171 1 53 799X Junipero Serra Blvd 16 1 1 13   03/01/2000 12:00:00 AM 30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
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)
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)
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)
111971 116809 2 15 111 BAY ST 1 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
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)
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)
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)
110974 116818 2 15 111 BAY ST 5 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
110250 24414 1 60 1199X Junipero Serra Blvd 17 1 1 13   06/23/1995 12:00:00 AM 12 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
110010 87700 1 12 799X Junipero Serra Blvd 25 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
Powered by Datasette · Query took 2.826ms · Data source: data.sfgov.org