sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10392 778 3 76 1800X 37th Ave 1 1 1 2   03/14/2006 12:00:00 AM 3 3X3   5984768.5556 2102340.232 37.7517447878795 -122.49556583438999 (37.7517447878795, -122.49556583439)
89666 1227 3 76 3600X Alemany Blvd 8 1 1 2   01/07/2004 12:00:00 AM 8 3X5   5993524.054670201 2087589.4711722 37.7117516532039 -122.46421760708901 (37.7117516532039, -122.464217607089)
23362 1241 3 76 3702X Alemany Blvd 6 1 1 2     4 3X5   5992970.26911 2087627.9134799999 37.711825271896 -122.466134417365 (37.711825271896, -122.466134417365)
78867 1243 3 76 3700X Alemany Blvd 8 1 1 2   01/07/2004 12:00:00 AM 3 3X5   5993218.71389 2087629.4001799999 37.71184368475021 -122.46527583828698 (37.7118436847502, -122.465275838287)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
94314 11430 3 76 810X Mendell St 3 1 1 2   03/11/2007 12:00:00 AM 3 3x3   6016021.05885 2096802.45168 37.738319705118705 -122.387103277147 (37.7383197051187, -122.387103277147)
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)
7029 13296 1 76 2770 Lombard St 1 1 1 1   01/08/2016 12:00:00 AM 2 3X3 Permit Number 770074 5999335.521430001 2119120.5005900003 37.79866135180829 -122.446398566642 (37.7986613518083, -122.446398566642)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
14916 15036 1 76 1011 Mendell St 1 1 1 1     3 3X3   6015667.53207 2096259.4401099999 37.7368091227302 -122.38828772241501 (37.7368091227302, -122.388287722415)
13872 15042 1 76 1024 Mendell St 1 1 1 1   02/28/2008 12:00:00 AM 3 3X3   6015618.91517 2096257.6222 37.7368014371311 -122.388455686999 (37.7368014371311, -122.388455686999)
14805 15047 1 76 1115 Mendell St 1 1 1 1   02/12/2008 12:00:00 AM 3 3x3   6015512.6554 2096045.3172 37.7362126017611 -122.388808259867 (37.7362126017611, -122.388808259867)
97253 21043 3 76 2101X Sunset Blvd 24 1 1 2     24 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
97905 23180 3 76 300X Van Ness Ave 6 11 1 2     3 9   6006874.5373229 2111536.5864673 37.778265495762 -122.41977270620701 (37.778265495762, -122.419772706207)
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)
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)
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)
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)
101935 23339 3 76 1202X Van Ness Ave 2 11 1 2   06/09/2005 12:00:00 AM 6 9x5   6006445.157123799 2114583.3806768996 37.7866070504124 -122.42147452901001 (37.7866070504124, -122.42147452901)
78759 23340 3 76 1202X Van Ness Ave 3 11 1 2   06/09/2005 12:00:00 AM 8 9x5   6006445.157123799 2114583.3806768996 37.7866070504124 -122.42147452901001 (37.7866070504124, -122.42147452901)
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)
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)
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)
128478 23388 3 76 1500X Van Ness Ave 1 11 1 2   06/09/2005 12:00:00 AM 6 G   6006302.3156668 2115604.1529311 37.789401783497 -122.42204126893 (37.789401783497, -122.42204126893)
8228 23389 3 76 1500X Van Ness Ave 2 11 1 2     30 9   6006261.55669 2115711.13882 37.789693241290294 -122.42218989455499 (37.7896932412903, -122.422189894555)
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)
86396 23507 3 76 2600X Van Ness Ave 1 11 1 2     3 9   6005789.5650879005 2119282.8766016 37.799473699725 -122.424077049734 (37.799473699725, -122.424077049734)
104579 23581 3 76 3100X Van Ness Ave 4 11 1 2   01/25/2008 12:00:00 AM 3 9   6005553.2513401 2120985.4040713003 37.804135058960796 -122.42501598068701 (37.8041350589608, -122.425015980687)
5306 23582 3 76 3100X Van Ness Ave 5 11 1 2   01/25/2008 12:00:00 AM 3 9   6005497.77155 2121198.52122 37.8047170896849 -122.425223146826 (37.8047170896849, -122.425223146826)
5461 23583 3 76 3100X Van Ness Ave 6 11 1 2     24 9   6005493.5455 2121226.7269099997 37.8047942964921 -122.425239779807 (37.8047942964921, -122.425239779807)
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)
87290 25474 3 76 830X Mendell St 1 1 1 2   02/10/2012 12:00:00 AM 3 3x3   6015988.777980001 2096759.23326 37.7381992484921 -122.387211875796 (37.7381992484921, -122.387211875796)
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)
15090 27536 1 76 1300 Illinois St 2 1 1 9   03/30/2006 12:00:00 AM 3 3X3   6016135.46193 2102904.74697 37.7550816812001 -122.38713323933099 (37.7550816812001, -122.387133239331)
111596 27542 1 76 1390 Illinois St 2 1 1 9   04/06/2006 12:00:00 AM 3 3X3   6016157.095863 2102619.361637 37.7542992711205 -122.387038518734 (37.7542992711205, -122.387038518734)
144322 27547 1 76 1301X Illinois St 5 1 1 9   04/06/2006 12:00:00 AM 3 3X3   6016173.411126 2103023.95301 37.755411097271704 -122.387010312465 (37.7554110972717, -122.387010312465)
142220 27550 1 76 1299X Illinois St 1 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)
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)
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)
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)
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)
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)
91104 27588 1 76 2100X San Bruno Ave 1 1 1 5   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.9494349998 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696)
88729 27589 1 76 2100X San Bruno Ave 2 1 1 5   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.9494349998 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696)
120755 27590 1 76 2100X San Bruno Ave 3 1 1 5   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.9494349998 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696)
25401 27591 1 76 2100X San Bruno Ave 4 1 1 5   06/21/2001 12:00:00 AM 3 3x3   6009789.2811665 2096218.9494349998 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696)
122065 27592 1 76 2100X San Bruno Ave 5 1 1 5   06/21/2001 12:00:00 AM 3 3X3   6009789.2811665 2096218.9494349998 37.7363704769246 -122.408608649696 (37.7363704769246, -122.408608649696)
52916 27593 3 76 2200X San Bruno Ave 1 1 1 2   06/21/2001 12:00:00 AM 12 3X3   6010149.0566544 2095763.2891253997 37.7351394742744 -122.407332636882 (37.7351394742744, -122.407332636882)
89967 27594 3 76 2200X San Bruno Ave 2 1 1 2   06/21/2001 12:00:00 AM 16 3X3   6010149.05665 2095763.28912 37.7351394742594 -122.407332636897 (37.7351394742594, -122.407332636897)
100424 27595 3 76 2200X San Bruno Ave 3 1 1 2   06/21/2001 12:00:00 AM 8 3X3   6010149.0566544 2095763.2891253997 37.7351394742744 -122.407332636882 (37.7351394742744, -122.407332636882)
129167 27596 3 76 2200X San Bruno Ave 4 1 1 2   03/20/2003 12:00:00 AM 6 3X3   6010149.0566544 2095763.2891253997 37.7351394742744 -122.407332636882 (37.7351394742744, -122.407332636882)
Powered by Datasette · Query took 4.555ms · Data source: data.sfgov.org