sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
21779 29598 3 47 900X Junipero Serra Blvd 7 11 1 2   12/31/2014 08:52:00 AM 3     5991178.77498 2091110.6465200002 37.7212844823864 -122.472580013151 (37.7212844823864, -122.472580013151)
11132 1820 3 75 2100 Bay Shore Blvd 1 11 1 2   12/30/1991 12:00:00 AM 3 6   6011846.03792 2087600.59079 37.7128212089973 -122.400892211026 (37.7128212089973, -122.400892211026)
11580 1821 3 75 2100 Bay Shore Blvd 2 11 1 2   12/30/1991 12:00:00 AM 6 6   6011817.461569999 2087571.87835 37.712740776339295 -122.400988964593 (37.7127407763393, -122.400988964593)
125100 1818 3 114 2100 Bay Shore Blvd 3 11 1 2   12/30/1991 12:00:00 AM 3 6   6012027.2003656 2087907.9406618 37.7136752340099 -122.400287624748 (37.7136752340099, -122.400287624748)
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)
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)
10723 1798 3 75 2000 Bay Shore Blvd 6 11 1 2   12/27/1991 12:00:00 AM 12 6   6012206.26499 2088043.30695 37.714056906280604 -122.39967820720899 (37.7140569062806, -122.399678207209)
81891 1801 3 75 2020 Bay Shore Blvd 3 11 1 2   12/27/1991 12:00:00 AM 12 6   6012311.362568799 2088370.0571878997 37.7149599552833 -122.399337871901 (37.7149599552833, -122.399337871901)
97318 1810 3 75 2040 Bay Shore Blvd 2 11 1 2   12/27/1991 12:00:00 AM 12 6   6012267.4866135 2088237.9390645002 37.7145947398058 -122.399480256716 (37.7145947398058, -122.399480256716)
101386 1800 3 75 2020 Bay Shore Blvd 2 11 1 2   12/27/1991 12:00:00 AM 12 6   6012311.362568799 2088370.0571878997 37.7149599552833 -122.399337871901 (37.7149599552833, -122.399337871901)
112272 1797 3 75 2010 Bay Shore Blvd 5 11 1 2   12/27/1991 12:00:00 AM 12     6012333.445831 2088436.5537268997 37.7151437722719 -122.399266207491 (37.7151437722719, -122.399266207491)
96832 9274 3 108 6800 Geary Blvd 4 11 1 2   12/24/2014 02:02:00 PM 3 8M   5985760.86534 2112510.31266 37.779727039932794 -122.49288337676599 (37.7797270399328, -122.492883376766)
82198 18695 3 279 251X Richardson Ave 2 11 1 2   12/23/2002 12:00:00 AM 3 100   5999064.164064 2119841.396854 37.8006252370733 -122.44738946108299 (37.8006252370733, -122.447389461083)
83481 104785 3 37 750 Holly Park Cir 1 11 1 2   12/21/2014 11:00:00 PM 3 2x2   6006276.6738599995 2096799.83163 37.7377680961975 -122.42079445065201 (37.7377680961975, -122.420794450652)
84036 27864 1 15 900X The Embarcadero 5 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
89385 27863 1 15 900X The Embarcadero 4 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
90241 27861 1 15 900X The Embarcadero 2 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
94947 27865 1 15 900X The Embarcadero 6 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
110146 27862 1 15 900X The Embarcadero 3 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
128446 27860 1 15 900X The Embarcadero 1 11 1 9   12/20/2000 12:00:00 AM 24     6012583.0764321 2120386.2715161997 37.8028845715493 -122.400646489089 (37.8028845715493, -122.400646489089)
1379 25668 1 100 450X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6014174.0749699995 2117868.41683 37.796059744425996 -122.394964320767 (37.796059744426, -122.394964320767)
5331 25671 1 100 450X The Embarcadero 4 11 1 9   12/18/2000 12:00:00 AM 36 15   6014100.8579 2117974.29057 37.7963463772386 -122.395225088169 (37.7963463772386, -122.395225088169)
5927 25672 1 100 450X The Embarcadero 5 11 1 9   12/18/2000 12:00:00 AM 36 15   6014076.201780001 2118013.23421 37.796451936061295 -122.39531313361799 (37.7964519360613, -122.395313133618)
78913 25684 1 100 100 The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
81991 25679 1 100 350X The Embarcadero 3 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
89592 25669 1 100 450X The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 36 15   6013579.1997782 2118911.837786 37.7988916345337 -122.397095919657 (37.7988916345337, -122.397095919657)
92998 25682 1 100 350X The Embarcadero 6 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
94589 25673 1 100 450X The Embarcadero 6 11 1 9   12/18/2000 12:00:00 AM 36 15   6013579.1997782 2118911.837786 37.7988916345337 -122.397095919657 (37.7988916345337, -122.397095919657)
95406 25670 1 100 450X The Embarcadero 3 11 1 9   12/18/2000 12:00:00 AM 36 15   6013579.1997782 2118911.837786 37.7988916345337 -122.397095919657 (37.7988916345337, -122.397095919657)
104738 25646 1 100 550X The Embarcadero 4 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
113255 25643 1 100 550X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
114362 25635 1 100 650X The Embarcadero 4 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
114920 25677 1 100 350X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
117750 25678 1 100 350X The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
117942 25633 1 100 650X The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
118808 25681 1 100 350X The Embarcadero 5 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
125734 25647 1 100 550X The Embarcadero 5 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
125804 25634 1 100 650X The Embarcadero 3 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
126124 25683 1 100 100 The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015960.62101 2112553.15201 37.781564418481004 -122.388411289639 (37.781564418481, -122.388411289639)
126813 25644 1 100 550X The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
138363 25645 1 100 550X The Embarcadero 3 11 1 9   12/18/2000 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
140032 25632 1 100 650X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
142949 25680 1 100 350X The Embarcadero 4 11 1 9   12/18/2000 12:00:00 AM 36 15   6013785.794644901 2118604.8635638 37.7980602547356 -122.39635950070699 (37.7980602547356, -122.396359500707)
114873 23355 3 76 1250X Van Ness Ave 2 11 1 2   12/10/2003 12:00:00 AM 3 9   6006448.1236467 2114767.6788933 37.7871132551315 -122.421477359088 (37.7871132551315, -122.421477359088)
96124 27767 1 100 299X The Embarcadero 1 11 1 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
139415 27774 1 100 299X The Embarcadero 2 11 1 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
103844 23488 3 18 2500X Van Ness Ave 4 11 1 2   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
120512 23489 3 18 2500X Van Ness Ave 5 11 1 2   12/09/2004 12:00:00 AM 6 9   6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
124893 29668 3 18 2500 Van Ness Ave 3 11 1 2   12/09/2004 12:00:00 AM 6     6005837.0202043 2118942.4447679003 37.79854163961021 -122.42388861727899 (37.7985416396102, -122.423888617279)
81890 23390 3 76 1500X Van Ness Ave 3 11 1 2   12/09/2003 12:00:00 AM 6 9   6006302.3156668 2115604.1529311 37.789401783497 -122.42204126893 (37.789401783497, -122.42204126893)
9354 122862 3 51 3000X Alemany Blvd 9 11 1 2   12/08/2016 01:57:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9272 122860 3 51 3000X Alemany Blvd 7 11 1 2   12/08/2016 01:54:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9209 122858 3 51 3000X Alemany Blvd 5 11 1 2   12/08/2016 01:48:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9280 122859 3 51 3000X Alemany Blvd 6 11 1 2   12/08/2016 01:46:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9112 122861 3 51 3000X Alemany Blvd 8 11 1 2   12/08/2016 01:43:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9327 122854 3 51 3000X Alemany Blvd 1 11 1 2   12/08/2016 01:40:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9268 122855 3 51 3000X Alemany Blvd 2 11 1 2   12/08/2016 01:30:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9406 122857 3 51 3000X Alemany Blvd 4 11 1 2   12/08/2016 01:17:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9291 122856 3 51 3000X Alemany Blvd 3 11 1 2   12/08/2016 01:13:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
88242 23333 3 76 1142X Van Ness Ave 2 11 1 2   12/01/2003 12:00:00 AM 3 9   6006495.0913449 2114431.1382441004 37.7861918455124 -122.42129095338001 (37.7861918455124, -122.42129095338)
89183 23332 3 76 1142X Van Ness Ave 1 11 1 2   12/01/2003 12:00:00 AM 3 9   6006495.0913449 2114431.1382441004 37.7861918455124 -122.42129095338001 (37.7861918455124, -122.42129095338)
93088 23354 3 76 1250X Van Ness Ave 1 11 1 2   12/01/2003 12:00:00 AM 3 9   6006448.1236467 2114767.6788933 37.7871132551315 -122.421477359088 (37.7871132551315, -122.421477359088)
118845 23324 3 76 1108X Van Ness Ave 2 11 1 2   12/01/2003 12:00:00 AM 3 3x3   6006505.7907443 2114265.3196898997 37.7857371517591 -122.421242157065 (37.7857371517591, -122.421242157065)
139456 23323 3 76 1108X Van Ness Ave 1 11 1 2   12/01/2003 12:00:00 AM 3 3x3   6006505.7907443 2114265.3196898997 37.7857371517591 -122.421242157065 (37.7857371517591, -122.421242157065)
145922 23366 3 76 1356X Van Ness Ave 2 11 1 2   12/01/2003 12:00:00 AM 6 9   6006391.382589401 2115174.2493055 37.7882263975959 -122.42170255954201 (37.7882263975959, -122.421702559542)
6093 26031 1 100 450X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 10   6014122.12078 2117941.0950599997 37.7962564126589 -122.39514918719999 (37.7962564126589, -122.3951491872)
6748 26030 1 100 450X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 36 10   6014150.34723 2117905.1373099997 37.796159250800294 -122.395048997307 (37.7961592508003, -122.395048997307)
82090 27775 1 100 299X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
87172 26029 1 100 499X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 10   6013385.9217822 2119009.0450001 37.7991477810775 -122.397771551765 (37.7991477810775, -122.397771551765)
87650 27777 1 100 299X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
91779 26017 1 100 899X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
92364 27782 1 100 399X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
92465 26024 1 100 899X The Embarcadero 8 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
92652 27780 1 100 399X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
93392 26026 1 100 599X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
100132 27778 1 100 299X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
111571 27784 1 100 399X The Embarcadero 7 11 1 9   12/01/2000 12:00:00 AM 20     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
112720 27781 1 100 399X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
119621 26019 1 100 899X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
121752 27776 1 100 299X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
124284 26018 1 100 899X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
125860 27766 1 100 399X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
126250 26096 1 100 499X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 36 10   6013385.9217822 2119009.0450001 37.7991477810775 -122.397771551765 (37.7991477810775, -122.397771551765)
126593 26022 1 100 899X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
127947 26028 1 100 599X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
128560 26023 1 100 899X The Embarcadero 7 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
140237 26020 1 100 899X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
140893 27783 1 100 399X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
144442 26021 1 100 899X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 36 10   6012483.6012207 2120310.1113668997 37.8026699057947 -122.40098537237499 (37.8026699057947, -122.400985372375)
144544 27779 1 100 399X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 24     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
144869 26027 1 100 599X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
144953 26025 1 100 599X The Embarcadero 1 11 1 9   12/01/2000 12:00:00 AM 36 4X4   6012976.7050292995 2119636.8551197 37.8008488002257 -122.399231684673 (37.8008488002257, -122.399231684673)
79149 91241 3 109 842x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
82614 91242 3 109 842x Guerrero St 3 11 1 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
87396 91276 3 109 1156x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005723.0 2102230.0 37.75264688060071 -122.42309463069999 (37.7526468806007, -122.4230946307)
103989 91275 3 109 1150x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005721.0 2102265.0 37.7527428696504 -122.423104034617 (37.7527428696504, -122.423104034617)
107213 91271 3 109 1130x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005715.0 2102383.0 37.753066531779496 -122.423133170481 (37.7530665317795, -122.423133170481)
116212 91274 3 109 1144x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005719.0 2102300.0 37.7528388586979 -122.423113438558 (37.7528388586979, -122.423113438558)
123263 91272 3 109 1136x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005717.0 2102348.0 37.752970542737295 -122.423123766486 (37.7529705427373, -122.423123766486)
139621 91273 3 109 1140x Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3     6005718.0 2102324.0 37.752904700718105 -122.423118602517 (37.7529047007181, -122.423118602517)
141675 91237 3 109 808 Guerrero St 1 11 1 2   11/20/2009 12:00:00 AM 3 4x15   6005611.0 2104262.0 37.7582199589604 -122.423626406477 (37.7582199589604, -122.423626406477)
Powered by Datasette · Query took 34.475ms · Data source: data.sfgov.org