sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
104630 11816 1 2 1201X Junipero Serra Blvd 2 1 1 13     6 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
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)
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)
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)
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)
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)
79410 24459 1 12 1199X Junipero Serra Blvd 3 1 1 13   01/18/2008 12:00:00 AM 3 3x3   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)
91193 11791 1 5 1199X Junipero Serra Blvd 14 1 1 13     30 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)
94360 24461 1 12 1199X Junipero Serra Blvd 7 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
96556 24460 1 60 1199X Junipero Serra Blvd 9 1 1 13   06/22/1995 12:00:00 AM 6 3x3   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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
104595 87713 1 12 1199X Junipero Serra Blvd 11 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991170.4069529995 2089609.549246 37.717162354271395 -122.47249955747499 (37.7171623542714, -122.472499557475)
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)
86548 24457 1 12 999X Junipero Serra Blvd 13 1 1 13   01/18/2008 12:00:00 AM 3 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)
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)
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)
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)
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)
90644 87708 1 12 999X Junipero Serra Blvd 7 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
94232 87707 1 12 999X Junipero Serra Blvd 5 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
97337 87706 1 12 999X Junipero Serra Blvd 2 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
98322 87710 1 12 999X Junipero Serra Blvd 12 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
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)
79858 87631 1 12 900X Junipero Serra Blvd 7 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
86590 87630 1 12 900X Junipero Serra Blvd 2 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
100974 87629 1 12 900X Junipero Serra Blvd 1 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
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)
19844 27797 1 60 899X Junipero Serra Blvd 3 1 1 13   03/17/2001 12:00:00 AM 3 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)
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)
83233 28848 1 60 899X Junipero Serra Blvd 15 1 1 13   03/08/2005 12:00:00 AM 3 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
89108 27799 1 60 899X Junipero Serra Blvd 23 1 1 13   03/08/2005 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
90084 24402 1 60 899X Junipero Serra Blvd 17 1 1 13   03/01/2000 12:00:00 AM 6 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
92392 24401 1 60 899X Junipero Serra Blvd 16 1 1 13   03/17/2001 12:00:00 AM 12 3X3   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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
95006 87704 1 12 899X Junipero Serra Blvd 10 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.7238979999 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777)
96704 87703 1 12 899X Junipero Serra Blvd 6 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.7238979999 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777)
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)
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)
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)
80752 24398 1 60 799X Junipero Serra Blvd 30 1 1 13   03/01/2000 12:00:00 AM 12 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
84989 24399 1 60 799X Junipero Serra Blvd 13 1 1 13   06/15/1995 12:00:00 AM 12 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)
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)
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)
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)
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)
100151 27800 1 2 799X Junipero Serra Blvd 3 1 1 13   03/17/2001 12:00:00 AM 12 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)
108860 24456 1 60 799X Junipero Serra Blvd 31 1 1 13   06/22/1995 12:00:00 AM 12 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)
109450 24400 1 60 799X Junipero Serra Blvd 22 1 1 13   06/15/1995 12:00:00 AM 6 3x3   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)
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)
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)
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)
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)
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)
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)
81955 87698 1 12 799X Junipero Serra Blvd 4 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
81957 87701 1 60 799X Junipero Serra Blvd 27 1 1 13     8 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
87918 87702 1 12 799X Junipero Serra Blvd 28 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
92672 85425 1 53 799X Junipero Serra Blvd 29 1 1 13     36 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
Powered by Datasette · Query took 5.21ms · Data source: data.sfgov.org