sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
142086 110077 2 3 4099x ALEMANY BLVD   11 1 1     48     5991599.0 2086829.0 37.7095524384103 -122.470815701049 (37.7095524384103, -122.470815701049)
3232 253369 2 2 449X Trumbull St 1 11 1 1       Width 10ft   6005840.0 2094317.0 37.730926169648 -122.42212790794599 (37.730926169648, -122.422127907946)
15485 111661 2 18 1398x Kansas St 1 11 1 2   06/25/2015 01:32:00 PM 3 3x3   6011721.86925 2101900.7924099998 37.7520796461774 -122.402326221379 (37.7520796461774, -122.402326221379)
22919 251161 2 3 528 Noriega St 1 11 1 1       3x3   5992330.0 2103518.0 37.7554185113149 -122.46950331083401 (37.7554185113149, -122.469503310834)
26254 116994 2 6 600M Divisadero St 1 11 1 2     3     6001630.0135 2110553.7073 37.775269918649705 -122.43784499428999 (37.7752699186497, -122.43784499429)
35699 117207 2 180 1300x De Haro St 1 11 1 1     13     6012255.77341 2102253.00873 37.753076544652 -122.40050462841002 (37.753076544652, -122.40050462841)
66037 121471 2 15 102X King St 1 11 1 9     9 3x3   6015546.21298 2111901.81315 37.779753015830394 -122.38979944679701 (37.7797530158304, -122.389799446797)
78159 109162 2 46 51x OCTAVIA ST 1 11 1 2     6 3x20   6005650.4 2109419.7 37.772384002649005 -122.42385688843399 (37.772384002649, -122.423856888434)
78281 111082 2 60 130 JUNIPERO SERRA BLVD 1 11 1 1       3x3   5991393.0 2095322.0 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186)
78765 122579 2 84 2500X Lyon St 1 11 1 1     30 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
79587 115562 2 3 450x JUNIPERO SERRA BLVD 1 11 1 1     30 3x3   5991387.0 2094058.0 37.7293892334347 -122.472074965405 (37.7293892334347, -122.472074965405)
83074 109632 2 2 2X GENEVA AVE 1 11 1 2       3x3   5997165.4 2091482.5 37.7226502134341 -122.45191286533199 (37.7226502134341, -122.451912865332)
88594 112580 2 40 274X SAN MARCOS AVE 1 11 1 1       3x20   5993121.0 2100271.0 37.7465487656332 -122.46653182115801 (37.7465487656332, -122.466531821158)
89664 110683 2 169 1 EDDY ST 1 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
90152 107496 2 3 846x JUNIPERO SERRA BLVD 1 11 1 1     60     5991242.0 2091754.0 37.7230546314384 -122.47240834171801 (37.7230546314384, -122.472408341718)
92233 111089 2 15 10x HIGUERA AVE 1 11 1 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777485 5988057.0 2090190.0 37.7185754269376 -122.483303520979 (37.7185754269376, -122.483303520979)
93812 116900 2 11 4 BAYSIDE VILLAGE PL 1 11 1 1       3x3   6015480.0 2114022.0 37.7855708982649 -122.390176670868 (37.7855708982649, -122.390176670868)
96023 113237 2 129 700X JUNIPERO SERRA BLVD 1 11 1 1       3x3   5991325.0 2093086.0 37.726716776202295 -122.472218478241 (37.7267167762023, -122.472218478241)
97066 99466 2 60 600X Miramar Ave 1 11 1 1     30 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
97780 109648 2 47 800X BROTHERHOOD WAY 1 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
99860 114066 2 47 600x LAKE MERCED BLVD 1 11 1 1     36     5987697.0 2093816.0 37.7285105386339 -122.48481373540702 (37.7285105386339, -122.484813735407)
101290 111777 2 17 96 CRESTLINE DR 1 11 1 1       3x3   5998960.0 2102304.0 37.7524661019794 -122.446487505153 (37.7524661019794, -122.446487505153)
105313 110264 2 47 220x CASHMERE ST 1 11 1 2       5x40   6015982.5 2095938.0 37.735943960522796 -122.38717631599701 (37.7359439605228, -122.387176315997)
108228 106878 2 3 180X SAN MARCOS AVE 1 11 1 1 4   26     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
108439 110447 2 3 1400 Holloway Ave 1 11 1 1       5x5   5991161.796471 2091241.0154845002 37.7216414605593 -122.47264820285801 (37.7216414605593, -122.472648202858)
111356 109637 2 2 1X Geneva Ave 1 11 1 2       3x3   6001799.0 2091822.0 37.723846713797 -122.435919833731 (37.723846713797, -122.435919833731)
111885 115833 2 47 900X LAKE MERCED BLVD 1 11 1 1   08/30/2016 12:00:00 AM 3 10x100   5987646.0 2090104.0 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844)
114819 115563 2 3 600x JUNIPERO SERRA BLVD 1 11 1 1     40 3x3   5991349.0 2093478.0 37.7277944993603 -122.47216407308998 (37.7277944993603, -122.47216407309)
116269 96365 2 17 2017 Grant Ave 1 11 1 1   06/07/2011 12:00:00 AM 12 3x3 Permit Number 767883 6010284.4 2121422.5 37.805601328212795 -122.408674274121 (37.8056013282128, -122.408674274121)
119968 104734 2 25 5490x 03RD ST 1 11 1 2     40 9x9   6014203.0 2093127.0 37.7281268221954 -122.39313217573601 (37.7281268221954, -122.393132175736)
120095 99457 2 143 550X Miramar Ave 1 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
120510 97485 2 143 500X Miramar Ave 1 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
121966 107497 2 3 826 JUNIPERO SERRA BLVD 1 11 1 2     36     5991253.8 2091935.2 37.723552844701295 -122.47238075500601 (37.7235528447013, -122.472380755006)
122644 110235 2 40 2346x CASTRO ST 1 11 1 1       3x3   6002664.5 2098664.4 37.742683511585206 -122.43341667357402 (37.7426835115852, -122.433416673574)
126354 114055 2 47 700X LAKE MERCED BLVD 1 11 1 1     50     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
128319 99451 2 143 400X Miramar Ave 1 11 1 1     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
142441 99120 2 47 302X Pacheco St 1 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
80646 99473 2 143 600X Miramar Ave 2 11 1 1     30 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
82990 122582 2 6 2500X Lyon St 2 11 1 1     6 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
89076 97486 2 60 500X Miramar Ave 2 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
91074 99452 2 60 400X Miramar Ave 2 11 1 1     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
93810 109633 2 2 2X GENEVA AVE 2 11 1 2       3x3   5997165.4 2091482.5 37.7226502134341 -122.45191286533199 (37.7226502134341, -122.451912865332)
98698 110684 2 169 1 EDDY ST 2 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
106153 99462 2 60 550X Miramar Ave 2 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
109323 109649 2 47 800X BROTHERHOOD WAY 2 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
109936 114056 2 47 700X LAKE MERCED BLVD 2 11 1 1     61     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
114243 115834 2 71 900X LAKE MERCED BLVD 2 11 1 1   08/30/2016 12:00:00 AM 3 10x100 Permit Number 777492 5987646.0 2090104.0 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844)
114247 106879 2 126 180X SAN MARCOS AVE 2 11 1 1 4   6     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
126415 99483 2 60 700X Miramar Ave 2 11 1 1     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
127274 109638 2 2 1X Geneva Ave 2 11 1 2       3x3   6001799.0 2091822.0 37.723846713797 -122.435919833731 (37.723846713797, -122.435919833731)
128652 99121 2 3 302X Pacheco St 2 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
139244 99492 2 60 800X Miramar Ave 2 11 1 1     30 15x280   5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
142725 112581 2 40 274X SAN MARCOS AVE 2 11 1 1       3x20   5993121.0 2100271.0 37.7465487656332 -122.46653182115801 (37.7465487656332, -122.466531821158)
10756 110237 2 15 200X Winston Dr 3 11 1 2     11 6x18   5989487.1744800005 2093569.3277200002 37.7279373404144 -122.47860704469 (37.7279373404144, -122.47860704469)
93833 109634 2 2 2X GENEVA AVE 3 11 1 2       3x3   5997165.4 2091482.5 37.7226502134341 -122.45191286533199 (37.7226502134341, -122.451912865332)
94262 106880 2 53 180X SAN MARCOS AVE 3 11 1 1 4   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
102939 99481 2 60 650X Miramar Ave 3 11 1 1     30 15x280   5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
105709 122583 2 141 2500X Lyon St 3 11 1 1     20 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
107501 115835 2 47 900X LAKE MERCED BLVD 3 11 1 1   08/30/2016 12:00:00 AM 3 10x100   5987646.0 2090104.0 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844)
113640 110685 2 169 1 EDDY ST 3 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
114163 99486 2 143 700X Miramar Ave 3 11 1 1     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
117015 97487 2 60 500X Miramar Ave 3 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
118963 109639 2 3 1X Geneva Ave 3 11 1 2       3x3   6001799.0 2091822.0 37.723846713797 -122.435919833731 (37.723846713797, -122.435919833731)
119431 99122 2 47 302X Pacheco St 3 11 1 1     48     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
119791 99453 2 60 400X Miramar Ave 3 11 1 1     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
128399 99493 2 60 800X Miramar Ave 3 11 1 1     30 15x280   5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
141106 99467 2 60 600X Miramar Ave 3 11 1 1     6 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
142707 99458 2 143 550X Miramar Ave 3 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
146162 114057 2 47 700X LAKE MERCED BLVD 3 11 1 1     46     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
24427 99454 2 12 400X Miramar Ave 4 11 1 1     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
77822 97488 2 12 500X Miramar Ave 4 11 1 1     10 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
88472 99487 2 143 700X Miramar Ave 4 11 1 1     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
106499 110686 2 169 1 EDDY ST 4 11 1 1       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
110259 109640 2 3 1X Geneva Ave 4 11 1 2       3x3   6001799.0 2091822.0 37.723846713797 -122.435919833731 (37.723846713797, -122.435919833731)
113908 99123 2 3 302X Pacheco St 4 11 1 1     6     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
118992 114058 2 47 700X LAKE MERCED BLVD 4 11 1 1     58     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
121555 99465 2 12 550X Miramar Ave 4 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
123808 99468 2 60 600X Miramar Ave 4 11 1 1     6 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
125204 109635 2 3 2X GENEVA AVE 4 11 1 2       3x3   5997165.4 2091482.5 37.7226502134341 -122.45191286533199 (37.7226502134341, -122.451912865332)
125523 106883 2 53 180X SAN MARCOS AVE 4 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
143024 109165 2 46 51x OCTAVIA ST 4 11 1 2       3x20   6005650.4 2109419.7 37.772384002649005 -122.42385688843399 (37.772384002649, -122.423856888434)
145855 122584 2 71 2500X Lyon St 4 11 1 1     11 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
90036 97489 2 143 500X Miramar Ave 5 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
99445 99474 2 143 650X Miramar Ave 5 11 1 1     30 15x280   5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
99764 109166 2 46 51x OCTAVIA ST 5 11 1 2       3x20   6005650.4 2109419.7 37.772384002649005 -122.42385688843399 (37.772384002649, -122.423856888434)
105911 109636 2 2 2X GENEVA AVE 5 11 1 2       3x3   5997165.4 2091482.5 37.7226502134341 -122.45191286533199 (37.7226502134341, -122.451912865332)
112364 99472 2 143 600X Miramar Ave 5 11 1 1     30 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
117951 110687 2 169 1 EDDY ST 5 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
118496 99484 2 60 700X Miramar Ave 5 11 1 1     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
127993 122585 2 116 2500X Lyon St 5 11 1 1     70 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
142943 114059 2 47 700X LAKE MERCED BLVD 5 11 1 1     38     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
145354 99455 2 143 400X Miramar Ave 5 11 1 1     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
20071 99485 2 60 700X Miramar Ave 6 11 1 1     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
77875 106884 2 53 180X SAN MARCOS AVE 6 11 1 1 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
90742 99463 2 60 550X Miramar Ave 6 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
94507 99469 2 60 600X Miramar Ave 6 11 1 1     4 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
95382 99489 2 164 800X Miramar Ave 6 11 1 1     30 15x280   5995450.2 2094280.5 37.7302344585425 -122.458044289565 (37.7302344585425, -122.458044289565)
98520 114060 2 47 700X LAKE MERCED BLVD 6 11 1 1     60     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
101015 99477 2 143 650X Miramar Ave 6 11 1 1     30 15x280   5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
102772 109653 2 47 800X BROTHERHOOD WAY 6 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
Powered by Datasette · Query took 87.296ms · Data source: data.sfgov.org