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          
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)
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)
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)
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)
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)
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)
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)
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)
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)
142086 110077 2 3 4099x ALEMANY BLVD   11 1 1     48     5991599.0 2086829.0 37.7095524384103 -122.470815701049 (37.7095524384103, -122.470815701049)
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)
22919 251161 2 3 528 Noriega St 1 11 1 1       3x3   5992330.0 2103518.0 37.7554185113149 -122.46950331083401 (37.7554185113149, -122.469503310834)
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)
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)
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)
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)
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)
90362 99136 2 47 302X Pacheco St 19 11 1 1     36     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
96003 99142 2 3 302X Pacheco St 25 11 1 1     24     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
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)
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)
102180 99161 2 3 302X Pacheco St 45 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
106081 99140 2 3 302X Pacheco St 24 11 1 1     12     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
108235 99124 2 3 302X Pacheco St 7 11 1 1     12     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
110580 99137 2 3 302X Pacheco St 20 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
114310 99153 2 47 302X Pacheco St 41 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
118159 99144 2 47 302X Pacheco St 27 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
119431 99122 2 47 302X Pacheco St 3 11 1 1     48     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
120664 99135 2 5 302X Pacheco St 18 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
122205 99146 2 47 302X Pacheco St 30 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
124634 99132 2 3 302X Pacheco St 15 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
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)
141458 99133 2 47 302X Pacheco St 16 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
141756 99152 2 47 302X Pacheco St 36 11 1 1     9     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
142441 99120 2 47 302X Pacheco St 1 11 1 1     3     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
145757 99163 2 3 302X Pacheco St 47 11 1 1     18     5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
125989 87027 1 302 23 Magellan Ave 1 11 1 1       3x3 Permit Number 49971 5994623.4 2101166.9 37.74909526366879 -122.461401658799 (37.7490952636688, -122.461401658799)
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)
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)
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)
Powered by Datasette · Query took 29.979ms · Data source: data.sfgov.org