sf-trees

Data source: data.sfgov.org

Custom SQL query returning 78 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
111356 109637 2 2 1X Geneva Ave 1 11 1 2       3x3   6001799.0 2091822.0 37.723846713797 -122.435919833731 (37.723846713797, -122.435919833731)
111872 97492 2 60 500X Miramar Ave 8 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
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)
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)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
113640 110685 2 169 1 EDDY ST 3 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
113908 99123 2 3 302X Pacheco St 4 11 1 1     6     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
114059 99165 2 3 302X Pacheco St 14 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
114276 109670 2 2 200X GELLERT DR 34 11 1 2       30x200   5985380.0 2094516.3 37.730298158604995 -122.492875173009 (37.730298158605, -122.492875173009)
114310 99153 2 47 302X Pacheco St 41 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
115225 99164 2 47 302X Pacheco St 48 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
115321 99126 2 3 302X Pacheco St 9 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
115393 99134 2 3 302X Pacheco St 17 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
116110 110689 2 169 1 EDDY ST 7 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
116259 122587 2 116 2500X Lyon St 7 11 1 1     45 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
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)
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)
117644 109629 2 2 200X GELLERT DR 30 11 1 2       30x200   5985380.0 2094516.3 37.730298158604995 -122.492875173009 (37.730298158605, -122.492875173009)
117951 110687 2 169 1 EDDY ST 5 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
118159 99144 2 47 302X Pacheco St 27 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
118963 109639 2 3 1X Geneva Ave 3 11 1 2       3x3   6001799.0 2091822.0 37.723846713797 -122.435919833731 (37.723846713797, -122.435919833731)
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)
119431 99122 2 47 302X Pacheco St 3 11 1 1     48     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
119712 122589 2 141 2500X Lyon St 9 11 1 1       10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
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)
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)
120664 99135 2 5 302X Pacheco St 18 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
122205 99146 2 47 302X Pacheco St 30 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
122644 110235 2 40 2346x CASTRO ST 1 11 1 1       3x3   6002664.5 2098664.4 37.742683511585206 -122.43341667357402 (37.7426835115852, -122.433416673574)
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)
123960 111099 2 3 480X LAKESHORE DR 20 11 1 2       30x200   5984942.0 2095282.0 37.7323749444343 -122.49444579849501 (37.7323749444343, -122.494445798495)
124400 105235 2 42 182X LOWER TER 27 11 1 1     24 200x30   6000081.0 2106216.0 37.763271458828704 -122.442891809215 (37.7632714588287, -122.442891809215)
124634 99132 2 3 302X Pacheco St 15 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
126256 97490 2 143 500X Miramar Ave 7 11 1 1     12 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
126291 99460 2 143 550X Miramar Ave 7 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
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)
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)
127626 97493 2 60 500X Miramar Ave 9 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
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)
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)
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)
128652 99121 2 3 302X Pacheco St 2 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
129106 99131 2 3 302X Pacheco St 14 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
138468 99139 2 3 302X Pacheco St 22 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
138905 99128 2 47 302X Pacheco St 11 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)
139369 97491 2 12 500X Miramar Ave 6 11 1 1   10/14/2011 12:00:00 AM 30 15x280 Permit Number 768370 5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
139448 99461 2 164 550X Miramar Ave 8 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
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)
141458 99133 2 47 302X Pacheco St 16 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
141462 109668 2 2 200X GELLERT DR 32 11 1 2       30x200   5985380.0 2094516.3 37.730298158604995 -122.492875173009 (37.730298158605, -122.492875173009)
141756 99152 2 47 302X Pacheco St 36 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
142047 109652 2 47 800X BROTHERHOOD WAY 23 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
142086 110077 2 3 4099x ALEMANY BLVD   11 1 1     48     5991599.0 2086829.0 37.7095524384103 -122.470815701049 (37.7095524384103, -122.470815701049)
142441 99120 2 47 302X Pacheco St 1 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
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)
143024 109165 2 46 51x OCTAVIA ST 4 11 1 2       3x20   6005650.4 2109419.7 37.772384002649005 -122.42385688843399 (37.772384002649, -122.423856888434)
143403 122586 2 84 2500X Lyon St 6 11 1 1     12 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
143891 110688 2 169 1 EDDY ST 6 11 1 2       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
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)
145583 109651 2 47 800X BROTHERHOOD WAY 22 11 1 2           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318)
145757 99163 2 3 302X Pacheco St 47 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
Powered by Datasette · Query took 49.192ms · Data source: data.sfgov.org