sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
85875 3577 1 76 100X Cargo Way 12 1 1 9     3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
103993 3578 1 76 100X Cargo Way 13 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
5059 83040 5 76 100X Cargo Way 12 1 1 9   02/04/2006 12:00:00 AM 6     6018704.22704 2097697.64106 37.740925933998 -122.37788821227699 (37.740925933998, -122.377888212277)
153213 83039 2 76 100X Cargo Way 13 1 1 9   02/04/2006 12:00:00 AM 12     6018611.72965 2097767.00037 37.741111283369705 -122.378212851336 (37.7411112833697, -122.378212851336)
13482 3542 3 76 201X Cargo Way 52 1 1 2   03/01/2006 12:00:00 AM 3 3X3   6018537.99972 2097717.76917 37.7409720404334 -122.378464368331 (37.7409720404334, -122.378464368331)
22353 3591 1 76 100X Cargo Way 27 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6018372.01456 2097944.0595 37.741584237724396 -122.37905400254499 (37.7415842377244, -122.379054002545)
141733 10733 3 76 1100 Hudson Ave 4 5 1 2   01/28/2016 08:19:00 AM 3 3x4   6018138.790397401 2094650.7890521 37.7325287066123 -122.379631682873 (37.7325287066123, -122.379631682873)
16415 3521 3 76 201X Cargo Way 31 1 1 2     6 3X3   6018183.10085 2097983.12019 37.7416810722141 -122.379709922198 (37.7416810722141, -122.379709922198)
72615 197255 2 76 1320 Hudson Ave 3 1 1 1     1 Width 3ft   6018070.99696 2094637.60558 37.7324887679223 -122.379865147852 (37.7324887679223, -122.379865147852)
70243 197256 2 76 1320 Hudson Ave 6 1 1 1     2 Width 3ft   6018044.32152 2094632.22344 37.732472518087 -122.37995699832899 (37.732472518087, -122.379956998329)
89435 10777 3 76 1120X Hudson Ave 49 1 1 2   08/06/2014 12:00:00 AM 3 3x4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
102835 10749 3 76 1120X Hudson Ave 32 1 1 2   03/11/2006 12:00:00 AM 3 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
103746 10775 3 76 1120X Hudson Ave 48 5 1 2   03/10/2007 12:00:00 AM 3 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
144183 10760 3 76 1120X Hudson Ave 30 1 1 2   03/10/2007 12:00:00 AM 3 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
176622 197254 2 76 1333 Hudson Ave 10 1 1 1     3 Width 3ft   6017901.24331 2094608.61235 37.7323997926186 -122.380450018371 (37.7323997926186, -122.380450018371)
108454 10829 3 76 1139X Hudson Ave 36 1 1 2   03/15/2006 12:00:00 AM 3 3X4   6017900.94101 2094609.6380099999 37.7324025921986 -122.380451134764 (37.7324025921986, -122.380451134764)
92367 98130 3 76 1120X Hudson Ave 36 1 1 2   03/10/2007 12:00:00 AM 4 3x4   6017903.8 2094987.0 37.733438911814 -122.38046746904399 (37.733438911814, -122.380467469044)
179230 197253 2 76 1333 Hudson Ave 6 1 1 1     2 Width 3ft   6017800.41079 2094649.2469900001 37.7325058028811 -122.38080144733401 (37.7325058028811, -122.380801447334)
84694 10824 3 76 1139X Hudson Ave 31 1 1 2   12/17/2007 12:00:00 AM 3 3X4   6017795.47201 2094639.5860099997 37.732479003154104 -122.38081785069599 (37.7324790031541, -122.380817850696)
46248 197252 2 76 1333 Hudson Ave 5 1 1 1     2 Width 3ft   6017782.90663 2094656.28102 37.7325241508658 -122.38086245283999 (37.7325241508658, -122.38086245284)
96624 10823 3 76 1139X Hudson Ave 30 1 1 2   12/14/2007 12:00:00 AM 3 3X4   6017777.243009999 2094650.0030099999 37.7325066000949 -122.38088159725099 (37.7325066000949, -122.380881597251)
174616 197251 2 76 1333 Hudson Ave 3 1 1 1     3 Width 3ft   6017752.42929 2094673.2277 37.732569000954896 -122.380968999147 (37.7325690009549, -122.380968999147)
91634 10820 3 76 1139X Hudson Ave 27 1 1 2   12/14/2007 12:00:00 AM 3 3x4   6017736.87901 2094664.32601 37.7325437003489 -122.38102214211901 (37.7325437003489, -122.381022142119)
90100 10790 3 76 1200X Hudson Ave 13 1 1 2   02/12/1998 12:00:00 AM 8 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
108283 10782 3 76 1200X Hudson Ave 4 1 1 2   01/27/2016 09:31:00 AM 3 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
127727 26705 3 76 1200X Hudson Ave 5 1 1 2   03/23/2006 12:00:00 AM 3 3x4   6017715.991199099 2094753.0263542 37.7327861010711 -122.381100521913 (37.7327861010711, -122.381100521913)
78265 10877 3 76 1175X Hudson Ave 10 1 1 2   12/17/2007 12:00:00 AM 3     6017544.4990408 2094830.7506973 37.732990049052205 -122.381698823278 (37.7329900490522, -122.381698823278)
79309 10879 3 76 1175X Hudson Ave 12 1 1 2   03/23/2006 12:00:00 AM 3 3X4   6017544.4990408 2094830.7506973 37.732990049052205 -122.381698823278 (37.7329900490522, -122.381698823278)
140228 10876 3 76 1175X Hudson Ave 9 1 1 2   12/17/2007 12:00:00 AM 3 3X4   6017544.4990408 2094830.7506973 37.732990049052205 -122.381698823278 (37.7329900490522, -122.381698823278)
75378 197257 2 76 1322 Hudson Ave 26 1 1 1     2 Width 3ft   6017533.22144 2094905.154 37.733193723116 -122.38174298627199 (37.733193723116, -122.381742986272)
159917 197258 2 76 1322 Hudson Ave 27 1 1 1     1 Width 3ft   6017525.05376 2094913.62104 37.7332165209287 -122.38177181313299 (37.7332165209287, -122.381771813133)
170688 197259 2 76 1322 Hudson Ave 31 1 1 1     4 Width 3ft   6017468.44354 2094985.48685 37.73341072412121 -122.381972529223 (37.7334107241212, -122.381972529223)
75680 197250 2 76 1337 Hudson Ave 1 1 1 1     5 Width 3ft   6017426.32364 2094968.1062 37.733360674138105 -122.382116942362 (37.7333606741381, -122.382116942362)
80111 10795 3 76 1139X Hudson Ave 3 1 1 2   12/14/2007 12:00:00 AM 3 3x4   6017417.868009999 2094975.5240099998 37.733380574977204 -122.382146691971 (37.7333805749772, -122.382146691971)
161783 197260 2 76 1322 Hudson Ave 40 1 1 1     23 Width 3ft   6017393.357030001 2095090.62772 37.7336952732179 -122.38223943901698 (37.7336952732179, -122.382239439017)
59607 197261 2 76 1322 Hudson Ave 41 1 1 1     1 Width 3ft   6017380.571719999 2095099.80246 37.7337197590624 -122.38228428011499 (37.7337197590624, -122.382284280115)
77356 10849 3 76 1220X Hudson Ave 1 1 1 2   03/23/2006 12:00:00 AM 6 3X4   6017356.4574634 2095156.0177673001 37.7338727832056 -122.382371560842 (37.7338727832056, -122.382371560842)
89270 10851 1 76 1220X Hudson Ave 3 1 1 1   12/27/2007 12:00:00 AM 3 3X4   6017356.4574634 2095156.0177673001 37.7338727832056 -122.382371560842 (37.7338727832056, -122.382371560842)
344 251279 3 76 1200x Hudson Ave 8 1 1 2 3     3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
393 251277 3 76 1200x Hudson Ave 3 1 1 2 3 10/26/2011 12:00:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
409 251278 3 76 1200x Hudson Ave 4 1 1 2 3 01/27/2016 09:31:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
60807 197262 2 76 1322 Hudson Ave 46 1 1 1     2 Width 3ft   6017335.88738 2095181.6845 37.733942122725395 -122.38244446375201 (37.7339421227254, -122.382444463752)
187937 197249 2 76 1339 Hudson Ave 9 1 1 1     3 Width 3ft   6017286.5777 2095179.92105 37.733934556716 -122.382614821425 (37.733934556716, -122.382614821425)
179697 197248 2 76 1339 Hudson Ave 7 1 1 1     3 Width 3ft   6017268.43044 2095223.8124400002 37.7340540712292 -122.382680615833 (37.7340540712292, -122.382680615833)
184913 197247 2 76 1339 Hudson Ave 6 1 1 1     3 Width 3ft   6017256.120180001 2095247.45205 37.7341183008123 -122.382724821107 (37.7341183008123, -122.382724821107)
36467 197263 2 76 1322 Hudson Ave 54 1 1 1     5 Width 3ft   6017252.47245 2095336.30143 37.7343620620475 -122.382743613324 (37.7343620620475, -122.382743613324)
96804 14891 3 76 151 Mendell St 5 1 1 2   02/25/2008 12:00:00 AM 3 3x3   6017309.26732 2098441.11643 37.7428903993232 -122.382763240232 (37.7428903993232, -122.382763240232)
152349 197264 2 76 1322 Hudson Ave 55 1 1 1     2 Width 3ft   6017243.9601 2095358.62855 37.734422897596005 -122.382774596779 (37.734422897596, -122.382774596779)
128155 10791 3 76 1200X Hudson Ave 14 1 1 2   12/17/2007 12:00:00 AM 3 3x4   6017221.84081 2095393.05521 37.734516204285605 -122.382853466196 (37.7345162042856, -122.382853466196)
14802 24222 8 76 54 Whitney Young Cir 1 1 1 1   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.38288292190398 (37.7334154068844, -122.382882921904)
42259 197246 2 76 1339 Hudson Ave 1 1 1 1     2 Width 3ft   6017203.85974 2095339.7013299998 37.7343687116489 -122.382911921471 (37.7343687116489, -122.382911921471)
22320 3658 1 76 100X Cargo Way 94 1 1 9     6 3x3   6017265.726009999 2098814.03291 37.7439119466908 -122.382939742901 (37.7439119466908, -122.382939742901)
57512 197265 2 76 1328 Hudson Ave 1 1 1 1     3 Width 3ft   6017187.84442 2095472.38417 37.734732147456604 -122.382976523354 (37.7347321474566, -122.382976523354)
16517 14896 3 76 151 Mendell St 10 1 1 2   09/15/2016 12:00:00 AM 3 3x3   6017148.9857 2098654.5103700003 37.743467479245794 -122.38333230594601 (37.7434674792458, -122.383332305946)
13711 14895 3 76 151 Mendell St 9 1 1 2   01/28/2000 12:00:00 AM 3 3x3   6017124.7449900005 2098611.99106 37.743349390171105 -122.383413165805 (37.7433493901711, -122.383413165805)
15542 14893 3 76 151 Mendell St 7 1 1 2   12/21/2008 12:00:00 AM 3 3x3   6017107.5762 2098575.41356 37.7432480069006 -122.38346998587 (37.7432480069006, -122.38346998587)
52745 197242 2 76 151 Mendell St 3 4 1 1     7 Width 3ft   6017080.03361 2098493.68243 37.7430220675307 -122.383559533147 (37.7430220675307, -122.383559533147)
23027 14877 3 76 50 Mendell St 3 1 1 2     3 3X3   6017083.42225 2098683.73205 37.7435440924819 -122.383561044027 (37.7435440924819, -122.383561044027)
94700 14884 3 76 50 Mendell St 10 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6017061.80062 2098665.73573 37.74349348316439 -122.383634554347 (37.7434934831644, -122.383634554347)
105309 14878 1 76 50 Mendell St 4 1 1 1   02/10/2012 12:00:00 AM 3 3x3   6017061.80062 2098665.73573 37.74349348316439 -122.383634554347 (37.7434934831644, -122.383634554347)
13627 14879 3 76 50 Mendell St 5 1 1 2     12 3x3   6017057.00036 2098638.4724 37.743418358272706 -122.383649254902 (37.7434183582727, -122.383649254902)
16610 14901 1 76 175 Mendell St 1 1 1 1   02/25/2008 12:00:00 AM 12 3x3   6017044.13522 2098333.33165 37.7425797926155 -122.383672499702 (37.7425797926155, -122.383672499702)
16393 14881 1 76 50 Mendell St 7 1 1 1   02/21/2008 12:00:00 AM 3 3x3   6017041.97386 2098599.86831 37.743311528701504 -122.383698526073 (37.7433115287015, -122.383698526073)
16312 14882 3 76 50 Mendell St 8 1 1 2     18 3x3   6017027.26925 2098565.83494 37.7432172671691 -122.383747002247 (37.7432172671691, -122.383747002247)
188304 197241 2 76 201 Mendell St 3 4 1 1     3 Width 3ft   6016985.47526 2098058.3462799997 37.7418214959701 -122.383856188014 (37.7418214959701, -122.383856188014)
142275 14923 3 76 190 Mendell St 1 1 1 2   07/23/2015 08:59:00 AM 3 3x3   6016976.73758 2098306.80908 37.7425032414108 -122.383903696919 (37.7425032414108, -122.383903696919)
107792 14957 3 76 275 Mendell St 4 1 1 2   07/11/2007 12:00:00 AM 3 3X3   6016965.76785 2098027.33997 37.7417352694795 -122.38392217193301 (37.7417352694795, -122.383922171933)
67475 197240 2 76 301 Mendell St 8 4 1 1     3 Width 3ft   6016921.73157 2097930.91265 37.7414680650873 -122.384067722948 (37.7414680650873, -122.384067722948)
14574 14944 3 76 200X Mendell St 12 1 1 2   02/21/2008 12:00:00 AM 3 3X3   6016843.847680001 2097941.18235 37.7414919573859 -122.384337736299 (37.7414919573859, -122.384337736299)
88338 14961 3 76 355 Mendell St 2 1 1 2     18 3X3   6016837.91572 2097829.62207 37.741185307463496 -122.384350479174 (37.7411853074635, -122.384350479174)
13742 14945 3 76 200X Mendell St 13 1 1 2   02/25/2008 12:00:00 AM 3 3X3   6016835.656690001 2097927.0465 37.7414526902904 -122.384365073909 (37.7414526902904, -122.384365073909)
132253 197245 2 76 401 Mendell St 5 4 1 1     6 Width 3ft   6016656.39457 2097572.2278400003 37.7404685163083 -122.38496019216001 (37.7404685163083, -122.38496019216)
30199 197244 2 76 401 Mendell St 3 4 1 1     3 Width 3ft   6016639.49339 2097549.35813 37.7404047858594 -122.38501703741699 (37.7404047858594, -122.385017037417)
174606 197243 2 76 401 Mendell St 2 4 1 1     9 Width 3ft   6016629.41985 2097534.84725 37.7403643847096 -122.38505085732099 (37.7403643847096, -122.385050857321)
16096 14971 1 76 400X Mendell St 4 1 1 11   02/25/2008 12:00:00 AM 3 3X3   6016631.74011 2097650.02311 37.740680762618396 -122.385050857322 (37.7406807626184, -122.385050857322)
87342 14977 3 76 495X Mendell St 1 1 1 2   02/20/2008 12:00:00 AM 3 3x3   6016593.7594099995 2097492.39708 37.7402458525216 -122.385171201108 (37.7402458525216, -122.385171201108)
118418 14981 3 76 495X Mendell St 5 1 1 2   02/11/2008 12:00:00 AM 3 3X3   6016593.7594099995 2097492.39708 37.7402458525216 -122.385171201108 (37.7402458525216, -122.385171201108)
182869 197272 2 76 621 Mendell St 4 1 1 1     4 Width 3ft   6016550.5665 2097428.77687 37.740068774853796 -122.38531611416401 (37.7400687748538, -122.385316114164)
84773 15001 1 76 501 Mendell St 2 1 1 1   02/22/2008 12:00:00 AM 3 3X3   6016547.419430001 2097394.04536 37.739973235060205 -122.38532457596901 (37.7399732350602, -122.385324575969)
104312 15003 1 76 501 Mendell St 4 1 1 1   02/21/2008 12:00:00 AM 3 3X3   6016547.419430001 2097394.04536 37.739973235060205 -122.38532457596901 (37.7399732350602, -122.385324575969)
124664 15000 1 76 501 Mendell St 1 1 1 1     3 3X3   6016547.419430001 2097394.04536 37.739973235060205 -122.38532457596901 (37.7399732350602, -122.385324575969)
74976 197271 2 76 621 Mendell St 2 1 1 1     3 Width 3ft   6016522.123869999 2097389.36221 37.739958976617295 -122.385411712102 (37.7399589766173, -122.385411712102)
105453 197270 2 76 621 Mendell St 1 1 1 1     5 Width 3ft   6016507.88272 2097368.67206 37.739901377747294 -122.385459511073 (37.7399013777473, -122.385459511073)
14657 12132 3 76 1400X La Salle Ave 12 1 1 2   12/28/2016 05:53:00 AM 3 3X3   6016426.995019999 2095242.04569 37.734057614557 -122.385591017134 (37.734057614557, -122.385591017134)
53585 197269 2 76 623 Mendell St 10 1 1 1     3 Width 3ft   6016467.035209999 2097318.03546 37.7397600798502 -122.385597217932 (37.7397600798502, -122.385597217932)
65823 197268 2 76 623 Mendell St 9 1 1 1     4 Width 3ft   6016457.45945 2097300.20103 37.7397105802781 -122.385629084527 (37.7397105802781, -122.385629084527)
23243 14987 3 76 500 Mendell St 3 1 1 2   02/25/2008 12:00:00 AM 2 3X3   6016458.61367 2097424.13027 37.7400509287079 -122.38563372862 (37.7400509287079, -122.38563372862)
14722 14988 3 76 500 Mendell St 4 1 1 2   04/11/2013 12:00:00 AM 3 3x3   6016447.53347 2097406.0602 37.7400006988631 -122.38567078067801 (37.7400006988631, -122.385670780678)
138859 93980 1 76 54 Whitney Young Cir 1 1 1 1   05/07/2010 12:00:00 AM 3 3x3 Permit Number 53404 6016373.3 2096115.1 37.7364518752706 -122.385837492382 (37.7364518752706, -122.385837492382)
126922 15008 1 76 600X Mendell St 5 1 1 1   02/25/2008 12:00:00 AM 12 3x3   6016372.25512 2097272.64218 37.7396301943656 -122.385921767044 (37.7396301943656, -122.385921767044)
134739 197273 2 76 618 Mendell St 5 1 1 1     2 Width 3ft   6016318.01168 2097190.59348 37.7394019032644 -122.38610360101299 (37.7394019032644, -122.386103601013)
170255 65579 1 76 670 Mendell St 1 1 1 1   01/23/1990 12:00:00 AM 4   Permit Number 28479 6016251.26211 2097105.4929099998 37.739164539819 -122.386328462099 (37.739164539819, -122.386328462099)
119871 15016 1 76 670 Mendell St 2 1 1 1   02/25/2008 12:00:00 AM 5 3x3   6016248.60441 2097127.21289 37.739224031366795 -122.386339165233 (37.7392240313668, -122.386339165233)
147369 197233 2 76 1201 Illinois St 1 1 1 1     8 Width 3ft   6016183.784440001 2103092.78575 37.7556006718551 -122.38697923850799 (37.7556006718551, -122.386979238508)
78226 27556 1 76 1299X Illinois St 7 1 1 9   12/10/1999 12:00:00 AM 3 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089)
82165 27558 1 76 1299X Illinois St 9 1 1 9   03/07/2006 12:00:00 AM 6 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089)
84083 27571 1 76 1299X Illinois St 22 1 1 9   03/07/2006 12:00:00 AM 6 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089)
85613 27570 1 76 1299X Illinois St 21 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089)
90033 27553 1 76 1299X Illinois St 4 1 1 9   03/07/2006 12:00:00 AM 3 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089)
119050 27573 1 76 1299X Illinois St 24 1 1 9   03/07/2006 12:00:00 AM 6 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089)
138353 27569 1 76 1299X Illinois St 20 1 1 9   03/07/2006 12:00:00 AM 10 3X3   6016181.753398 2103053.032112 37.7554914042846 -122.386983490089 (37.7554914042846, -122.386983490089)
Powered by Datasette · Query took 4.73ms · Data source: data.sfgov.org