sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2538 39950 1 180 0 Ervine St 8 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
2691 253165 6 180 1451 Bay St 3 7 1 1       3x3   6003691.0 2120547.0 37.802825946660796 -122.431429119577 (37.8028259466608, -122.431429119577)
3107 18939 3 180 2760 Sacramento St 1 1 1 2     24 4X4   6001611.94448 2115686.46462 37.78936213699829 -122.438275289198 (37.7893621369983, -122.438275289198)
3506 247939 4 180 29 Joy St 2 14 1 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
6380 46722 1 180   1 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
6817 39953 1 180 0 Ervine St 5 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
7518 39946 1 180 0 Ervine St 3 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
7701 18936 3 180 2721 Sacramento St 1 1 1 2     18 3X3   6001590.13521 2115636.51425 37.7892237457171 -122.43834716658199 (37.7892237457171, -122.438347166582)
8602 18938 3 180 2730 Sacramento St 1 1 1 2   06/21/2001 12:00:00 AM 6 4X4   6001751.73398 2115704.11419 37.7894185478752 -122.437792899137 (37.7894185478752, -122.437792899137)
8803 39951 1 180 0 Ervine St 9 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
9553 173610 2 180 344 Gold Mine Dr 1 1 1 1     20 3x3   6001093.0 2097562.0 37.739567297515705 -122.43877147759301 (37.7395672975157, -122.438771477593)
10494 117130 2 180 2671 24th Ave 1 1 1 1     8 3x3   5988936.0754 2097168.6937 37.737788261480105 -122.480775587362 (37.7377882614801, -122.480775587362)
10505 39952 1 180 0 Ervine St 10 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
10598 95755 3 180 260 Madrid St 6 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003450.901459999 2092257.0440599998 37.725134950402705 -122.43024050589399 (37.7251349504027, -122.430240505894)
10637 46729 1 180   5 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
10694 95758 3 180 260 Madrid St 9 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003422.17585 2092210.8120900001 37.7250063806226 -122.43033651031901 (37.7250063806226, -122.430336510319)
10839 95753 3 180 260 Madrid St 4 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003478.85461 2092303.3656900001 37.7252637225375 -122.430147177848 (37.7252637225375, -122.430147177848)
11117 97240 3 180 260 Madrid St 11 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814)
11296 39947 1 180 0 Ervine St 4 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
11344 46730 1 180   4 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
11480 95754 3 180 260 Madrid St 5 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003464.56282 2092279.46461 37.7251972860232 -122.43019487878999 (37.7251972860232, -122.43019487879)
11625 46731 1 180   3 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
12446 95750 3 180 260 Madrid St 1 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003564.18987 2092436.8443200001 37.7256350580097 -122.429861698861 (37.7256350580097, -122.429861698861)
12724 39945 1 180 0 Ervine St 2 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
12755 39949 1 180 0 Ervine St 1 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
12923 111444 1 180 241 Oneida Ave 34 1 1 2 6   14 6x12   5999970.3074 2091024.03837 37.721551640364396 -122.442184051271 (37.7215516403644, -122.442184051271)
13635 39944 1 180 0 Ervine St 7 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
14047 6510 3 180 1200X Evans Ave 2 11 1 2     18 15   6017613.51756 2097076.90112 37.7391613427334 -122.381616361724 (37.7391613427334, -122.381616361724)
14428 51357 3 180 50 Pomona St 8 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014147.24137 2094593.6145900001 37.732150750552 -122.393427531355 (37.732150750552, -122.393427531355)
15467 46732 1 180   2 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
15759 39948 1 180 0 Ervine St 6 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41215          
16318 29651 3 180 1500X La Salle Ave 10 11 1 2   04/07/2006 12:00:00 AM 3 12x31   6015684.3928 2096048.7707 37.7362316014874 -122.388214728777 (37.7362316014874, -122.388214728777)
16765 29652 3 180 1500X La Salle Ave 11 11 1 2   04/07/2006 12:00:00 AM 3 12x31   6015669.3226 2096063.2130000002 37.7362704220955 -122.38826784077101 (37.7362704220955, -122.388267840771)
19137 29594 3 180 900X Junipero Serra Blvd 3 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991181.08119 2091145.24325 37.7213796099522 -122.472574562389 (37.7213796099522, -122.472574562389)
19833 26915 3 180 10 Caine Ave 11 11 1 2   01/26/1999 12:00:00 AM 3 10   5997570.4467 2089598.1443599998 37.7174994031582 -122.450376943463 (37.7174994031582, -122.450376943463)
19990 10459 1 180 1569 Haight St 1 1 1 1   12/29/1994 12:00:00 AM 25 3X3   5998651.396000001 2108625.3987 37.76980545066029 -122.44800980256201 (37.7698054506603, -122.448009802562)
20652 44154 1 180 67 Saint Charles Ave 9 1 1 1   12/08/2000 12:00:00 AM     Permit Number 43634 5992085.5284034 2088073.73243086 37.7129982990606 -122.469224726443 (37.7129982990606, -122.469224726443)
22814 184050 2 180 1600 Sunset Blvd 51 9 1 1     1 Width 0ft   5984953.7413 2103846.6967 37.755891966793605 -122.495036518918 (37.7558919667936, -122.495036518918)
22890 247970 2 180 159 Faith St 1 9 1 1     22 Width 8ft   6010298.66575 2099104.3209599997 37.744321600460296 -122.407050801679 (37.7443216004603, -122.407050801679)
22891 247616 2 180 300 Bradford St 7 7 1 1     2     6009490.26965 2096786.7692099998 37.737912836413706 -122.409682528235 (37.7379128364137, -122.409682528235)
22906 240229 2 180 116 Crescent Ave 13 2 1 1     2 Width 10ft   6006267.81246 2095797.32513 37.7350149365947 -122.42075393896299 (37.7350149365947, -122.420753938963)
23389 43452 1 180 241 Oneida Ave 12 1 1 2 6 07/18/2000 12:00:00 AM 10   Permit Number 43162 5999577.25447 2091228.40825 37.7220903846374 -122.44355739787599 (37.7220903846374, -122.443557397876)
23449 202104 2 180 1828 Egbert Ave 8 9 1 1     14 Width 8ft   6012020.3729 2092885.5297599998 37.727342303098204 -122.400660684147 (37.7273423030982, -122.400660684147)
23459 240288 2 180 3980 22nd St 2 4 1 1     20     6001954.916780001 2102957.6016 37.7544313427449 -122.43617736779 (37.7544313427449, -122.43617736779)
23743 185183 2 180 2500 Sunset Blvd 35 9 1 1     1 Width 0ft   5985128.0455 2097828.1066 37.7393767603936 -122.493990182941 (37.7393767603936, -122.493990182941)
23907 247195 2 180 900 Waller St 9 7 1 1     20     6001251.021869999 2108666.7471 37.7700672400275 -122.43902074711201 (37.7700672400275, -122.439020747112)
24401 240280 2 180 691 29th St 7 9 1 1     2     6002099.074659999 2098828.06304 37.7431007968732 -122.435383453493 (37.7431007968732, -122.435383453493)
24546 200029 2 180 1575 Quesada Ave 1 1 1 1     3 Width 0ft   6015274.8561 2094571.5849 37.7321528483199 -122.38952754545 (37.7321528483199, -122.38952754545)
24577 43433 1 180 241 Oneida Ave 27 1 1 2 6 07/18/2000 12:00:00 AM 16   Permit Number 43162 5999846.51913 2091089.02473 37.7217230223792 -122.442616616172 (37.7217230223792, -122.442616616172)
24892 197177 2 180 1900 23rd St 6 7 1 1     13     6012740.291540001 2102830.02856 37.7546879247201 -122.39886955298599 (37.7546879247201, -122.398869552986)
25422 240306 2 180 134 Hancock St 1 1 1 1     6 Width 3ft   6003388.16897 2105086.9505 37.7603593535203 -122.43137280722901 (37.7603593535203, -122.431372807229)
25922 197195 3 180 1700x Quesada Ave 52 3 1 2     5     6014229.96459 2095381.0032900001 37.734317354963395 -122.393196613328 (37.7343173549634, -122.393196613328)
26060 43443 1 180 241 Oneida Ave 5 1 1 2 6 03/06/2004 12:00:00 AM 6   Permit Number 43162 5999469.30626 2091283.8759 37.722236528981206 -122.44393453036999 (37.7222365289812, -122.44393453037)
26361 200031 2 180 1575 Quesada Ave 3 1 1 1     5 Width 0ft   6015313.8786 2094541.9059 37.732073519349896 -122.389390563006 (37.7320735193499, -122.389390563006)
26728 197173 2 180 1900 23rd St 1 7 1 1     7     6012739.26156 2102864.49072 37.7547824929244 -122.39887553350201 (37.7547824929244, -122.398875533502)
26754 197191 2 180 602 Arthur Ave 12 7 1 1     18     6015839.12005 2099880.54912 37.7467614521736 -122.38794706729799 (37.7467614521736, -122.387947067298)
26786 118668 2 180 4240 Balboa St 1 1 1 1     5 Width 3ft   5982392.892440001 2111033.85887 37.7754756009165 -122.504425054608 (37.7754756009165, -122.504425054608)
26939 179341 3 180 100x Mansell St 9 11 1 2     11 Width 0ft   6011434.8537800005 2090631.08875 37.7211193983363 -122.40252637270599 (37.7211193983363, -122.402526372706)
27096 240267 2 180 517 Powhattan Ave 1 2 1 1     7     6008465.29724 2098131.45059 37.7415475462934 -122.413321437934 (37.7415475462934, -122.413321437934)
27098 249881 2 180 230 Greenwich St 17 13 1 1     16 Width 0ft   6011514.20842 2120460.74576 37.803029388647104 -122.404350588107 (37.8030293886471, -122.404350588107)
27927 247528 2 180 1101 Waller St 9 17 1 1     2     6000060.08033 2108486.82414 37.7695053822964 -122.443127261125 (37.7695053822964, -122.443127261125)
28102 187262 2 180 2401 Sunset Blvd 45 9 1 1     2 Width 0ft   5984975.6548 2098407.337 37.7409582534083 -122.494559764363 (37.7409582534083, -122.494559764363)
28166 247620 2 180 300 Bradford St 11 7 1 1     3     6009499.0149 2096845.5713799999 37.7380747845204 -122.40965644069901 (37.7380747845204, -122.409656440699)
28305 247111 2 180 2301 Castro St 29 7 1 1     2     6002712.026930001 2098697.32849 37.7427766218445 -122.43325469165899 (37.7427766218445, -122.433254691659)
28535 136276 2 180 1927 Jackson St 2 1 1 1     3 Width 5ft   6004921.8107 2117075.88034 37.7933648188709 -122.426922521966 (37.7933648188709, -122.426922521966)
28704 43445 1 180 241 Oneida Ave 28 1 1 2 6 07/18/2000 12:00:00 AM 5   Permit Number 43162 5999858.82768 2091082.35027 37.7217053974709 -122.44257358990299 (37.7217053974709, -122.442573589903)
29435 186031 2 180 1900 Sunset Blvd 26 9 1 1     1 Width 0ft   5985004.6307 2102018.5095 37.7508752473191 -122.49472575020901 (37.7508752473191, -122.494725750209)
29707 197189 2 180 602 Arthur Ave 7 7 1 1     21     6015936.19644 2099934.12978 37.7469139511226 -122.387615121238 (37.7469139511226, -122.387615121238)
30011 247106 2 180 2301 Castro St 24 7 1 1     10     6002702.97811 2098815.3340000003 37.7431001241765 -122.433294410209 (37.7431001241765, -122.433294410209)
30168 122242 2 180 1628 Lake St 5 2 1 1     4 Width 5ft   5990370.4799 2114772.2223799997 37.7862060986385 -122.477102214032 (37.7862060986385, -122.477102214032)
30396 136277 2 180 2745 Larkin St 7 9 1 1     23     6006529.34062 2120636.08267 37.8032309995586 -122.421613321221 (37.8032309995586, -122.421613321221)
30625 240316 2 180 310 Liberty St 48 2 1 1     3 Width 3ft   6003835.66179 2103919.1699900003 37.75717825719121 -122.429741845306 (37.7571782571912, -122.429741845306)
30649 240300 2 180 300 Clipper St 15 1 1 1     8 Width 3ft   6002726.96622 2100956.54522 37.748980749680705 -122.433364440431 (37.7489807496807, -122.433364440431)
30845 197201 2 180 2001 Revere Ave 18 9 1 1     6     6012348.821330001 2096403.61302 37.737020542553395 -122.399772154858 (37.7370205425534, -122.399772154858)
30995 240260 2 180 155 Appleton Ave 22 1 1 1     2 Width 2ft   6005682.645959999 2097069.8371299999 37.7384759711765 -122.42286747885001 (37.7384759711765, -122.42286747885)
31046 247622 2 180 300 Bradford St 13 7 1 1     1     6009485.42402 2096845.0974 37.7380727214716 -122.409703397886 (37.7380727214716, -122.409703397886)
31175 247826 2 180 96 Banks St 2 7 1 1     6     6008666.54857 2098148.46053 37.741605548963896 -122.412626779128 (37.7416055489639, -122.412626779128)
31284 247949 2 180 7 Joy St 2 17 1 1     11     6010404.2439 2098872.53529 37.7436910749942 -122.406669401896 (37.7436910749942, -122.406669401896)
31469 185640 2 180 2100 Sunset Blvd 20 9 1 1     1 Width 0ft   5985051.8314 2100435.5567 37.746531653861204 -122.494445852676 (37.7465316538612, -122.494445852676)
31609 240284 2 180 687 29th St 3 9 1 1     3     6002190.93807 2098832.7894099997 37.743118991043204 -122.435066152888 (37.7431189910432, -122.435066152888)
31690 186201 2 180 1701 Sunset Blvd 12 9 1 1     1 Width 0ft   5984749.405 2103445.7422 37.7547790924201 -122.49571359587799 (37.7547790924201, -122.495713595878)
31727 197188 2 180 1800 Illinois St 13 2 1 1     5 Width 6ft   6016258.08648 2100618.43223 37.748810728335705 -122.386549751994 (37.7488107283357, -122.386549751994)
31729 240297 2 180 300 Clipper St 7 1 1 1     5 Width 3ft   6002954.68882 2100970.7991299997 37.74903280421721 -122.432577993181 (37.7490328042172, -122.432577993181)
32035 247948 2 180 7 Joy St 1 17 1 1     13     6010393.64964 2098873.99577 37.7436944924075 -122.406706137374 (37.7436944924075, -122.406706137374)
32218 240217 2 180 116 Crescent Ave 1 2 1 1     8 Width 10ft   6006077.44236 2095815.2832099998 37.73505351389 -122.42141339202298 (37.73505351389, -122.421413392023)
32440 197209 2 180 91 Kiska Rd 5 9 1 1     7     6019354.09765 2093629.3399099999 37.729790960977205 -122.375359249432 (37.7297909609772, -122.375359249432)
33136 240242 2 180 351 Richland Ave 1 1 1 1     1 Width 3ft   6006956.98547 2096047.9435299998 37.73574189906971 -122.41838898186701 (37.7357418990697, -122.418388981867)
33278 247842 2 180 74 Nevada St 1 9 1 1     18 Width 6ft   6009022.44109 2098193.5019099996 37.741749190479396 -122.411399399688 (37.7417491904794, -122.411399399688)
33677 43434 1 180 241 Oneida Ave 26 1 1 2 6 07/18/2000 12:00:00 AM 7   Permit Number 43162 5999832.90051 2091096.8327900001 37.7217436851966 -122.44266425237 (37.7217436851966, -122.44266425237)
34358 136279 2 180 1151 Lombard St 3 9 1 1     15     6006698.81265 2120089.55435 37.8017399263049 -122.420988029784 (37.8017399263049, -122.420988029784)
35074 240231 2 180 116 Crescent Ave 15 2 1 1     1 Width 10ft   6006293.37748 2095794.5924900002 37.7350088742503 -122.420665357522 (37.7350088742503, -122.420665357522)
35207 240218 2 180 116 Crescent Ave 2 2 1 1     8 Width 10ft   6006103.73166 2095810.88544 37.7350429207983 -122.421322188175 (37.7350429207983, -122.421322188175)
35699 117207 2 180 1300x De Haro St 1 11 1 1     13     6012255.77341 2102253.00873 37.753076544652 -122.40050462841002 (37.753076544652, -122.40050462841)
35717 185687 2 180 2101 Sunset Blvd 19 9 1 1     1 Width 0ft   5984902.932 2100564.5408 37.7468770936492 -122.49497023200001 (37.7468770936492, -122.494970232)
35779 136278 2 180 2507 Larkin St 6 1 1 1     8 Width 3ft   6006657.1862 2120015.9614 37.8015355122184 -122.421126848223 (37.8015355122184, -122.421126848223)
35786 52156 1 180 1771 Quesada Ave 1 1 1 1 1 10/31/2005 12:00:00 AM 11   Permit Number 48348 6014341.22767 2095259.71993 37.733990516146996 -122.392803455827 (37.733990516147, -122.392803455827)
36356 185174 2 180 2500 Sunset Blvd 26 9 1 1     2 Width 0ft   5985128.7096 2097775.6475 37.7392327606429 -122.49398402167401 (37.7392327606429, -122.493984021674)
36600 246014 2 180 1569 Haight St 2 1 1 1     4 Width 0ft   5998668.6573 2108626.9128 37.7698105946696 -122.44795020544599 (37.7698105946696, -122.447950205446)
37017 240304 2 180 4185 25th St 10 1 1 1     10 Width 3ft   6002908.0812800005 2101214.2225599997 37.7496985444673 -122.43275654908899 (37.7496985444673, -122.432756549089)
37334 185718 2 180 2101 Sunset Blvd 50 9 1 1     2 Width 0ft   5984903.2589 2100385.7239 37.7463861302867 -122.494955918818 (37.7463861302867, -122.494955918818)
37501 240270 2 180 527 Banks St 5 2 1 1     9     6008672.46387 2098105.62692 37.7414882692663 -122.412603298703 (37.7414882692663, -122.412603298703)
Powered by Datasette · Query took 2.37ms · Data source: data.sfgov.org