sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
166040 175807 2 58 156 San Juan Ave 2 9 1 1     3 Width 10ft   6001266.11551 2092303.88748 37.725139581023605 -122.437796421768 (37.7251395810236, -122.437796421768)
59138 222697 2 58 690 28th St 1 9 1 1     8 Width 6ft   6001460.97341 2099432.54018 37.744724288990895 -122.43763311299101 (37.7447242889909, -122.437633112991)
36204 222700 2 58 551 Eureka St 1 1 1 1     2 Width 3ft   6001566.9280900005 2102610.03358 37.7534549532875 -122.437494242369 (37.7534549532875, -122.437494242369)
48921 204737 2 58 230 Acadia St 1 1 1 1     1 Width 3ft   6001436.76661 2095116.79206 37.7328728755875 -122.43740783373 (37.7328728755875, -122.43740783373)
63474 175799 2 58 1500 San Jose Ave 8 2 1 1     5 Width 8ft   6001536.44317 2094235.33238 37.7304582561421 -122.43700014314 (37.7304582561421, -122.43700014314)
44119 222706 2 58 4218 24th St 1 1 1 1     1 Width 3ft   6001708.51992 2101780.94195 37.7511865150679 -122.43694523773199 (37.7511865150679, -122.436945237732)
89633 55158 1 58 4218 24th St 1 1 1 1   01/26/2016 12:00:00 AM     Permit Number 775652 6001766.13275037 2101783.99509326 37.751198172676 -122.436746225237 (37.751198172676, -122.436746225237)
110009 108903 1 58 200 Cordova St 1 1 1 1 1     3x3 Permit Number 772783 6001785.77868 2087307.18495 37.7114492867677 -122.43564268921001 (37.7114492867677, -122.43564268921)
140417 108905 1 58 200 Cordova St 2 1 1 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772783 6001785.8 2087307.2 37.7114493293027 -122.43564261659901 (37.7114493293027, -122.435642616599)
167905 94813 1 58 2948 Fillmore St 1 1 1 1   11/09/2010 12:00:00 AM 2 3x3 Permit Number 53896 6002515.07841 2118365.04564 37.7967681547718 -122.43534223486799 (37.7967681547718, -122.435342234868)
187407 175800 2 58 701 Madrid St 1 1 1 1     1 Width 2ft   6001959.2202699995 2089802.6495400001 37.71831113034379 -122.43522160969401 (37.7183111303438, -122.435221609694)
116475 109575 1 58 400 France Ave 2 1 1 1 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002004.0 2089808.9 37.7183308355338 -122.43506727205299 (37.7183308355338, -122.435067272053)
12634 109574 1 58 400 France Ave 1 1 1 1 1 02/24/2015 12:00:00 AM 3 3x3 Permit Number 774875 6002013.87176 2089826.5009400002 37.7183797243364 -122.435034407708 (37.7183797243364, -122.435034407708)
78986 105989 1 58 651X Duncan St 2 1 1 1           6002337.0 2099724.0 37.745574339333 -122.434624822764 (37.745574339333, -122.434624822764)
94755 105988 1 58 651X Duncan St 1 1 1 1           6002337.0 2099724.0 37.745574339333 -122.434624822764 (37.745574339333, -122.434624822764)
61729 222698 2 58 4215 26th St 1 1 1 1     4 Width 2ft   6002437.17664 2100607.07314 37.7480047370361 -122.434341551122 (37.7480047370361, -122.434341551122)
20912 52837 1 58 4219@ CASTRO 26th St 1 1 1 1   06/22/2006 12:00:00 AM     Permit Number 48855 6002474.48025452 2100603.93596677 37.7479982404255 -122.434212332638 (37.7479982404255, -122.434212332638)
124888 48984 1 58 4215 26th St 1 1 1 1 1 12/05/2002 12:00:00 AM     Permit Number 46171 6002499.14803074 2100605.29142344 37.7480033622388 -122.43412712945299 (37.7480033622388, -122.434127129453)
10903 110032 1 58 630 Edinburgh St 1 1 1 1 1 03/19/2015 12:00:00 AM 3 3x3 Permit Number 775191 6002420.02658 2090107.3938799999 37.719174047824104 -122.433650566035 (37.7191740478241, -122.433650566035)
175877 222699 2 58 2102 Castro St 1 10 1 1     2 Width 5ft   6002635.97774 2099387.5471900003 37.744667486907204 -122.43356696417 (37.7446674869072, -122.43356696417)
109034 88642 1 58 637 Noe St   1 1 1   08/05/2008 12:00:00 AM   3x3 Permit Number 51602 6003051.0 2104517.0 37.758775291756294 -122.43249820666401 (37.7587752917563, -122.432498206664)
179565 222694 2 58 427 Valley St 2 2 1 1     7     6003122.71421 2099186.4838799997 37.7441430185014 -122.431869572034 (37.7441430185014, -122.431869572034)
83450 68449 1 58 4054 20th St 2 7 1 1 1 04/24/1999 12:00:00 AM     Permit Number 32307 6003251.17179249 2104206.64930012 37.757934492021604 -122.431783761852 (37.7579344920216, -122.431783761852)
12527 108378 1 58 358 Edinburgh St 2 1 1 1 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773808 6003377.41913 2091635.77484 37.7234249209965 -122.43045021882 (37.7234249209965, -122.43045021882)
78290 37278 1 58 700 Sanchez St 2 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
85068 37279 1 58 700 Sanchez St 1 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
109099 37281 1 58 700 Sanchez St 5 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
125842 37280 1 58 700 Sanchez St 3 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
141695 37284 1 58 700 Sanchez St 4 1 1 1   06/15/1998 12:00:00 AM     Permit Number 39817 6003661.86134005 2104206.66341524 37.7579578025996 -122.430363425655 (37.7579578025996, -122.430363425655)
114980 37338 1 58 740 Sanchez St 1 1 1 1 1 03/05/2002 12:00:00 AM     Permit Number 44638 6003659.25274291 2103921.20422444 37.757173851767604 -122.430352080919 (37.7571738517676, -122.430352080919)
115789 37339 1 58 790 Sanchez St 1 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39845 6003692.20622256 2103684.04749104 37.7565245422275 -122.43022119623501 (37.7565245422275, -122.430221196235)
62729 96749 3 58 399X Liberty St 3 1 1 2     6 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
79996 96750 3 58 399X Liberty St 4 1 1 2     6 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
121505 96747 3 58 399X Liberty St 1 1 1 2     4 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
145019 96748 3 58 399X Liberty St 2 1 1 2     4 1.5x2   6003700.0 2103889.2 37.7570882837734 -122.430208878023 (37.7570882837734, -122.430208878023)
24677 111241 3 58 745X SANCHEZ ST 4 3 1 2     6     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
88809 37303 1 58 400 Hill St 7 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
92997 37307 1 58 400 Hill St 10 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
99854 37306 1 58 400 Hill St 9 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
109912 37301 1 58 400 Hill St 8 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
112126 37302 1 58 400 Hill St 3 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
118645 37300 1 58 400 Hill St 1 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
120225 37305 1 58 400 Hill St 6 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
129209 37309 1 58 400 Hill St 2 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
139508 37304 1 58 400 Hill St 5 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
143101 37299 1 58 400 Hill St 4 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
145383 37308 1 58 400 Hill St 11 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39826 6003717.20570413 2103355.3114542 37.7556233268944 -122.430111288531 (37.7556233268944, -122.430111288531)
77589 110797 8 58 440 29th St 1 1 1 1   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.743606443306206 -122.42986661573299 (37.7436064433062, -122.429866615733)
156342 222693 2 58 440 29th St 1 1 1 1     2 Width 2ft   6003701.6023699995 2098966.92625 37.74357296341329 -122.42985224701 (37.7435729634133, -122.42985224701)
122747 37294 1 58 261 Cumberland St 1 1 1 1 1 06/15/1998 12:00:00 AM     Permit Number 39823 6003941.02088917 2104485.98513979 37.7587405625745 -122.42941789284599 (37.7587405625745, -122.429417892846)
148165 222701 2 58 340 Chenery St 1 1 1 1     4 Width 3ft   6004099.43344 2096524.74955 37.7368898251991 -122.42830262426399 (37.7368898251991, -122.428302624264)
86034 51889 1 58 340 Chenery St 1 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48102 6004103.48678716 2096538.35102027 37.736927401104396 -122.42828957914601 (37.7369274011044, -122.428289579146)
77303 34415 1 58 209 Randall St 1 1 1 1 1 07/15/1997 12:00:00 AM     Permit Number 38162 6004171.37602222 2097541.35369817 37.739685259534504 -122.42812631334499 (37.7396852595345, -122.428126313345)
45347 108716 1 58 201 Randall St   1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773302 6004213.21698 2097517.4141599997 37.73962189424871 -122.427979939698 (37.7396218942487, -122.427979939698)
89470 50387 1 58 296 Liberty St 4 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532583998 37.75737018369129 -122.427864268021 (37.7573701836913, -122.427864268021)
107669 50389 1 58 296 Liberty St 1 1 1 1   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532583998 37.75737018369129 -122.427864268021 (37.7573701836913, -122.427864268021)
146575 222710 2 58 201 Randall St 1 9 1 1     2 Width 3ft   6004263.21249 2097476.0489 37.7395111430209 -122.427804130079 (37.7395111430209, -122.427804130079)
28752 222686 2 58 1201 San Jose Ave 17 7 1 1     1     6004284.84781 2095906.59844 37.735203011805204 -122.427617536921 (37.7352030118052, -122.427617536921)
125182 34411 1 58 191 Randall St 1 1 1 1 1 07/15/1997 12:00:00 AM     Permit Number 38159 6004342.16299585 2097508.24193041 37.739604003626795 -122.427533446458 (37.7396040036268, -122.427533446458)
105073 34365 1 58 1863 Church St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38121 6004615.32037959 2097871.72676254 37.7406174967526 -122.42661486213999 (37.7406174967526, -122.42661486214)
12013 116582 1 58 195 Maynard St 1 1 1 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 778001 6004664.28928 2093799.33843 37.729438402445105 -122.426155697039 (37.7294384024451, -122.426155697039)
162790 222684 2 58 1100 San Jose Ave 28 7 1 1     4     6004829.85448 2096667.61167 37.7373233955514 -122.42578739946501 (37.7373233955514, -122.425787399465)
65950 222683 2 58 1100 San Jose Ave 27 7 1 1     4     6004834.7029800005 2096673.11166 37.7373387712724 -122.425771027308 (37.7373387712724, -122.425771027308)
69867 222678 2 58 749 Dolores St 4 2 1 1     5 Width 8ft   6005045.75661 2104048.66592 37.7576022713581 -122.425566082603 (37.7576022713581, -122.425566082603)
44937 222679 2 58 749 Dolores St 7 2 1 1     3 Width 8ft   6005046.9751 2104064.76222 37.7576465368663 -122.425563014118 (37.7576465368663, -122.425563014118)
101966 37855 1 58 50 Ina Ct 3 1 1 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
107545 37854 1 58 50 Ina Ct 2 1 1 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
138640 37856 1 58 50 Ina Ct 4 1 1 1   07/07/1998 12:00:00 AM     Permit Number 40144 6004964.50568845 2091639.69049004 37.7235254489092 -122.42496422599702 (37.7235254489092, -122.424964225997)
116919 175809 2 58 72 La Grande Ave 2 17 1 1     4     6005230.95207 2091785.5880000002 37.7239410985769 -122.424053538037 (37.7239410985769, -122.424053538037)
173385 175810 2 58 72 La Grande Ave 3 17 1 1     6     6005231.38021 2091782.6619 37.7239330883183 -122.424051850035 (37.7239330883183, -122.424051850035)
53626 175808 2 58 72 La Grande Ave 1 17 1 1     3     6005234.38829 2091786.48978 37.7239437686747 -122.42404172366001 (37.7239437686747, -122.42404172366)
149164 175811 2 58 15 Athens St 1 9 1 1     1     6005336.45581 2093162.3032099998 37.727727212929004 -122.423786672331 (37.727727212929, -122.423786672331)
26902 175812 2 58 15 Athens St 2 9 1 1     2     6005342.42292 2093158.1624099999 37.727716180055204 -122.42376574960899 (37.7277161800552, -122.423765749609)
39239 175813 2 58 15 Athens St 3 9 1 1     1     6005348.05368 2093155.48995 37.727709159929105 -122.42374609402201 (37.7277091599291, -122.423746094022)
6711 31341 1 58 430 Hayes St 2 1 1 1   12/29/2014 12:00:00 AM 3 3x3 Permit Number 772811 6005729.4209 2111051.1148 37.7768679337671 -122.423699563703 (37.7768679337671, -122.423699563703)
75485 175814 2 58 11 Athens St 3 9 1 1     3     6005376.332880001 2093192.89602 37.727813465104 -122.423650990705 (37.727813465104, -122.423650990705)
49828 222696 2 58 73 Leese St 1 1 1 1     1 Width 3ft   6005530.879319999 2096284.28114 37.736310445970204 -122.423336387162 (37.7363104459702, -122.423336387162)
440 157410 1 58 125 Highland Ave 2 1 1 1   04/06/2017 12:00:00 AM 3 2x5   6005546.67522 2096690.9332 37.7374279129674 -122.423310672857 (37.7374279129674, -122.423310672857)
438 157409 1 58 125 Highland Ave 1 1 1 1   04/06/2017 12:00:00 AM 3 3x5   6005572.56549 2096690.1102099998 37.7374271143738 -122.423221099494 (37.7374271143738, -122.423221099494)
44360 222680 2 58 76 Tiffany Ave 1 1 1 1     2 Width 6ft   6006248.111740001 2099605.96855 37.7454715078156 -122.421092396098 (37.7454715078156, -122.421092396098)
90034 42692 1 58 2500 Larkin St 5 1 1 1   06/26/2000 12:00:00 AM     Permit Number 42711 6006694.5506045995 2119774.0082852 37.8008732765742 -122.42098036158701 (37.8008732765742, -122.420980361587)
119936 42691 1 58 2500 Larkin St 1 1 1 1   06/26/2000 12:00:00 AM     Permit Number 42711 6006694.5506045995 2119774.0082852 37.8008732765742 -122.42098036158701 (37.8008732765742, -122.420980361587)
77695 42820 1 58 801 Bay St 10 1 1 1 1 06/29/2000 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
77758 42824 1 58 801 Bay St 6 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
78919 42827 1 58 801 Bay St 1 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
82453 42828 1 58 801 Bay St 4 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
102378 42822 1 58 801 Bay St 8 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
120509 42825 1 58 801 Bay St 5 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
123571 42821 1 58 801 Bay St 9 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
126150 42826 1 58 801 Bay St 3 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
127386 42819 1 58 801 Bay St 2 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
141381 42823 1 58 801 Bay St 7 1 1 1 1 09/11/2004 12:00:00 AM     Permit Number 42765 6006945.227660701 2121167.35462349 37.8047131790945 -122.42021185631901 (37.8047131790945, -122.420211856319)
11005 108841 1 58 125 Pioche St 1 5 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773762 6006499.8637 2093472.98879 37.7286458955893 -122.419786780156 (37.7286458955893, -122.419786780156)
166591 222687 2 58 200 Eugenia Ave 19 7 1 1     5     6006597.39234 2098081.5973 37.741305610657 -122.419776492811 (37.741305610657, -122.419776492811)
172205 222688 2 58 200 Eugenia Ave 20 7 1 1     10     6006604.22222 2098080.62198 37.741303317398206 -122.419752808255 (37.7413033173982, -122.419752808255)
129974 222689 2 58 200 Eugenia Ave 33 7 1 1     7 Width 10ft   6006609.95498 2098107.9290400003 37.7413786194175 -122.419734923451 (37.7413786194175, -122.419734923451)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
155156 125935 2 58 1132 Greenwich St 2 7 1 1     9     6007463.08276 2119890.85277 37.8012373932575 -122.418329199431 (37.8012373932575, -122.418329199431)
51309 222685 2 58 145 Coso Ave 2 9 1 1     5     6007512.1231 2099620.66206 37.74558302735271 -122.41672267392201 (37.7455830273527, -122.416722673922)
145814 106327 1 58 37 Elsie St   1 1 1       3X3 Permit Number 772574 6007569.3 2099210.3 37.7444594805766 -122.4164959017 (37.7444594805766, -122.4164959017)
Powered by Datasette · Query took 4.122ms · Data source: data.sfgov.org