sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14379 48480 1 17   1 11 1 1         Permit Number 45832          
142086 110077 2 3 4099x ALEMANY BLVD   11 1 1     48     5991599.0 2086829.0 37.7095524384103 -122.470815701049 (37.7095524384103, -122.470815701049)
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)
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)
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)
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)
108439 110447 2 3 1400 Holloway Ave 1 11 1 1       5x5   5991161.796471 2091241.0154845002 37.7216414605593 -122.47264820285801 (37.7216414605593, -122.472648202858)
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)
99750 92208 1 60 300x Miramar Ave 2 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
100266 92210 1 143 300x Miramar Ave 4 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
112226 92209 1 60 300x Miramar Ave 3 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
112766 92207 1 143 300X Miramar Ave 1 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
128923 92212 1 17 300x Miramar Ave 6 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
139081 92211 1 60 300x Miramar Ave 5 11 1 1   12/29/2010 12:00:00 AM   2x2 Permit Number 54064 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
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)
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)
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)
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)
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)
79420 114061 2 47 700X LAKE MERCED BLVD 7 11 1 1     52     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
82410 99464 2 60 550X Miramar Ave 9 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
86969 99459 1 60 550X Miramar Ave 5 11 1 1   10/28/2014 12:00:00 AM 3 15x280 Permit Number 772553 5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
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)
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)
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)
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)
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)
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)
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)
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)
19496 34866 1 41 579 Miramar Ave 1 11 1 1 1 12/29/2015 12:00:00 AM     Permit Number 775311 5995338.59696042 2093168.95782094 37.7271760192259 -122.458349689476 (37.7271760192259, -122.458349689476)
78674 99497 1 180 1400X Plymouth Ave 4 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
83274 99496 1 60 1400X Plymouth Ave 3 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
87404 99494 1 60 1400X Plymouth Ave 1 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
122780 99495 1 60 1400X Plymouth Ave 2 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
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)
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)
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)
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)
101136 99470 2 60 600X Miramar Ave 8 11 1 1     30 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
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)
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)
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)
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)
84567 99479 2 12 650X Miramar Ave 7 11 1 1     30 15x280   5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
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)
100862 99476 1 60 650X Miramar Ave 2 11 1 1   10/28/2014 12:00:00 AM 3 15x280 Permit Number 772553 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
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)
101615 99480 2 12 650X Miramar Ave 8 11 1 1     30 15x280   5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
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)
128765 99475 1 60 650X Miramar Ave 1 11 1 1   04/18/2014 12:00:00 AM 44 15x280 Permit Number 772553 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
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)
86095 103414 1 180 1490X Plymouth Ave 1 11 1 1   04/18/2013 12:00:00 AM     Permit Number 770026 5995919.3 2094026.5 37.7295639775589 -122.456404198854 (37.7295639775589, -122.456404198854)
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)
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)
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)
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)
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)
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)
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)
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)
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)
113986 115182 1 51 315 Lakeshore Dr 1 11 1 1   01/15/2016 12:00:00 AM     Permit Number 775158 5983956.6 2095109.9 37.7318446842931 -122.497839799214 (37.7318446842931, -122.497839799214)
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)
112663 114044 2 103 549X ARLINGTON ST   11 1 1     70     6003400.0 2095634.0 37.734404428182295 -122.430657330781 (37.7344044281823, -122.430657330781)
122644 110235 2 40 2346x CASTRO ST 1 11 1 1       3x3   6002664.5 2098664.4 37.742683511585206 -122.43341667357402 (37.7426835115852, -122.433416673574)
117426 106344 1 7 2428 14th Ave 1 11 1 1   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922)
144189 106345 1 7 2428 14th Ave 2 11 1 1   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922)
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)
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)
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)
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)
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)
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)
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)
44175 99145 2 5 302X Pacheco St 29 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
78288 99129 2 3 302X Pacheco St 12 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
81983 99149 2 3 302X Pacheco St 33 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
83372 99155 2 3 302X Pacheco St 38 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
83574 99156 2 3 302X Pacheco St 39 11 1 1     6     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
85707 99130 2 3 302X Pacheco St 13 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
88064 99162 2 3 302X Pacheco St 46 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
89044 99160 2 3 302X Pacheco St 44 11 1 1     48     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
89067 99157 2 3 302X Pacheco St 40 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
89136 99125 2 47 302X Pacheco St 8 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
90030 99150 2 3 302X Pacheco St 34 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
Powered by Datasette · Query took 29.275ms · Data source: data.sfgov.org