sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
14379 48480 1 17   1 11 1 1         Permit Number 45832          
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)
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)
22919 251161 2 3 528 Noriega St 1 11 1 1       3x3   5992330.0 2103518.0 37.7554185113149 -122.46950331083401 (37.7554185113149, -122.469503310834)
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)
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)
44175 99145 2 5 302X Pacheco St 29 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
72222 87818 1 180 85 Mendosa Ave 1 11 1 1   06/04/2008 12:00:00 AM     Permit Number 50680 5993356.0 2100787.0 37.747979128324 -122.46575670711701 (37.747979128324, -122.465756707117)
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)
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)
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)
78288 99129 2 3 302X Pacheco St 12 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
78674 99497 1 180 1400X Plymouth Ave 4 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
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)
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)
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)
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)
81983 99149 2 3 302X Pacheco St 33 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
83274 99496 1 60 1400X Plymouth Ave 3 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
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)
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)
84835 86968 1 17 3250 Van Ness Ave 1 11 1 1   10/27/2007 12:00:00 AM     Permit Number 49934 6005499.7 2121504.7 37.8055578865418 -122.42523827370701 (37.8055578865418, -122.425238273707)
85707 99130 2 3 302X Pacheco St 13 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
87404 99494 1 60 1400X Plymouth Ave 1 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
88064 99162 2 3 302X Pacheco St 46 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
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)
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)
89136 99125 2 47 302X Pacheco St 8 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
89216 122588 2 141 2500X Lyon St 8 11 1 1     13 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
90030 99150 2 3 302X Pacheco St 34 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
90362 99136 2 47 302X Pacheco St 19 11 1 1     36     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
91320 107140 1 80 250X Roosevelt Way   11 1 1   08/01/2014 12:00:00 AM   5x5 Permit Number 773751 6000794.71275 2107196.95489 37.766005582708395 -122.440493678393 (37.7660055827084, -122.440493678393)
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)
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)
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)
96003 99142 2 3 302X Pacheco St 25 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
96303 99148 2 47 302X Pacheco St 32 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
96311 99147 2 3 302X Pacheco St 31 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
96326 99151 2 47 302X Pacheco St 35 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
96426 99143 2 47 302X Pacheco St 26 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
96581 99127 2 3 302X Pacheco St 10 11 1 1     48     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
97137 99159 2 3 302X Pacheco St 43 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
97939 99158 2 3 302X Pacheco St 42 11 1 1     12     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
98538 98820 1 47 302X Pacheco St 28 11 1 1   05/09/2010 12:00:00 AM     Permit Number 768820 5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
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)
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)
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)
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)
101290 111777 2 17 96 CRESTLINE DR 1 11 1 1       3x3   5998960.0 2102304.0 37.7524661019794 -122.446487505153 (37.7524661019794, -122.446487505153)
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)
102180 99161 2 3 302X Pacheco St 45 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
103186 99154 2 47 302X Pacheco St 37 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
103352 99138 2 3 302X Pacheco St 21 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
103892 99141 2 3 302X Pacheco St 23 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
105287 105889 2 47 2150X 09TH AVE 11 11 1 1   03/21/2014 12:00:00 AM 40     5993666.0 2101247.0 37.7492600480712 -122.46471814740102 (37.7492600480712, -122.464718147401)
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)
106081 99140 2 3 302X Pacheco St 24 11 1 1     12     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
106499 110686 2 169 1 EDDY ST 4 11 1 1       3x3   6010419.0 2113787.0 37.7846436353836 -122.40766976216001 (37.7846436353836, -122.40766976216)
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)
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)
108235 99124 2 3 302X Pacheco St 7 11 1 1     12     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
108439 110447 2 3 1400 Holloway Ave 1 11 1 1       5x5   5991161.796471 2091241.0154845002 37.7216414605593 -122.47264820285801 (37.7216414605593, -122.472648202858)
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)
110580 99137 2 3 302X Pacheco St 20 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
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)
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)
113908 99123 2 3 302X Pacheco St 4 11 1 1     6     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
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)
Powered by Datasette · Query took 19.551ms · Data source: data.sfgov.org