sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7799 36854 1 37   1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9099 36836 1 37   2 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9535 36839 1 37   5 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
13906 36837 1 37   3 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
15723 36838 1 37   4 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
16572 36840 1 37   6 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
78340 38765 1 37   2 1 1 1   10/20/1998 12:00:00 AM     Permit Number 40634 6001679.43660737 2094405.04903571 37.7309323858205 -122.436517937945 (37.7309323858205, -122.436517937945)
88580 38767 1 37   4 1 1 1   10/20/1998 12:00:00 AM     Permit Number 40634 6001679.43660737 2094405.04903571 37.7309323858205 -122.436517937945 (37.7309323858205, -122.436517937945)
89240 38763 1 37   5 1 1 1   10/20/1998 12:00:00 AM     Permit Number 40634 6001679.43660737 2094405.04903571 37.7309323858205 -122.436517937945 (37.7309323858205, -122.436517937945)
112711 38766 1 37   3 1 1 1   10/20/1998 12:00:00 AM     Permit Number 40634 6001679.43660737 2094405.04903571 37.7309323858205 -122.436517937945 (37.7309323858205, -122.436517937945)
125029 38764 1 37   1 1 1 1   10/20/1998 12:00:00 AM     Permit Number 40634 6001679.43660737 2094405.04903571 37.7309323858205 -122.436517937945 (37.7309323858205, -122.436517937945)
137783 247787 2 37 0 30th St 3 4 1 1     6 Width 3ft   6004405.04711 2098420.28659 37.74211182679821 -122.42738097477199 (37.7421118267982, -122.427380974772)
154157 247786 2 37 0 30th St 2 4 1 1     3 Width 3ft   6004434.4666 2098422.1705099996 37.7421186634473 -122.42727938556101 (37.7421186634473, -122.427279385561)
114410 37147 1 37 1 27th St 2 1 1 1 1 06/05/1998 12:00:00 AM     Permit Number 39729 6006163.65409791 2100221.79185056 37.7471576573064 -122.42142816381799 (37.7471576573064, -122.421428163818)
122248 37149 1 37 1 27th St 1 1 1 1 1 06/05/1998 12:00:00 AM     Permit Number 39729 6006163.65409791 2100221.79185056 37.7471576573064 -122.42142816381799 (37.7471576573064, -122.421428163818)
145907 37148 1 37 1 27th St 3 1 1 1 1 06/05/1998 12:00:00 AM     Permit Number 39729 6006163.65409791 2100221.79185056 37.7471576573064 -122.42142816381799 (37.7471576573064, -122.421428163818)
33541 242192 2 37 1 Castro St 18 1 1 1     1 Width 3ft   6002211.39696 2108163.69762 37.7687405871237 -122.43566283237499 (37.7687405871237, -122.435662832375)
99159 242191 2 37 1 Castro St 1 1 1 1     1 Width 3ft   6002232.110859999 2107759.61358 37.76763224826921 -122.435562272887 (37.7676322482692, -122.435562272887)
117708 36932 1 37 1 Hoffman Ave 1 1 1 1 1 11/15/2003 12:00:00 AM     Permit Number 39573 6000605.12386462 2102858.71031165 37.7540830303141 -122.440838195083 (37.7540830303141, -122.440838195083)
142370 36933 1 37 1 Hoffman Ave 2 1 1 1 1 05/27/1998 12:00:00 AM     Permit Number 39573 6000605.12386462 2102858.71031165 37.7540830303141 -122.440838195083 (37.7540830303141, -122.440838195083)
145075 36931 1 37 1 Hoffman Ave 3 1 1 1 1 05/27/1998 12:00:00 AM     Permit Number 39573 6000605.12386462 2102858.71031165 37.7540830303141 -122.440838195083 (37.7540830303141, -122.440838195083)
30078 241966 2 37 1 Holly Park Cir 1 1 1 1     11 Width 3ft   6006454.12488 2096966.7090099999 37.7382363045723 -122.420192755695 (37.7382363045723, -122.420192755695)
70391 241968 2 37 1 Holly Park Cir 4 1 1 1     11 Width 3ft   6006548.82894 2096926.6354599998 37.7381316072746 -122.41986247247499 (37.7381316072746, -122.419862472475)
76854 241967 2 37 1 Holly Park Cir 3 1 1 1     11 Width 3ft   6006413.05624 2096945.1311299999 37.73817474237261 -122.420333219896 (37.7381747423726, -122.420333219896)
139627 112262 5 37 1 Holly Park Cir 3 1 1 1     10 3x15   6006308.21143459 2096885.36921844 37.7380047408881 -122.420691480393 (37.7380047408881, -122.420691480393)
115951 200596 2 37 1 Las Villas Ct 1 1 1 1     4 Width 0ft   6016417.1805 2094923.5303 37.7331824919173 -122.38560275837798 (37.7331824919173, -122.385602758378)
32239 68739 1 37 1 Lawrence Ave 1 1 1 1   11/16/1993 12:00:00 AM 8   Permit Number 32659 5997216.23373 2086785.97531 37.709757556936495 -122.45139857511101 (37.7097575569365, -122.451398575111)
37301 180009 2 37 1 Lawrence Ave 3 1 1 1     8 Width 3ft   5997247.3865 2086752.55268 37.7096675698642 -122.45128849717399 (37.7096675698642, -122.451288497174)
74913 180008 2 37 1 Lawrence Ave 2 1 1 1     7 Width 3ft   5997232.2014 2086767.6701 37.7097082093476 -122.451342068885 (37.7097082093476, -122.451342068885)
151119 180011 2 37 1 Lawrence Ave 5 1 1 1     8 Width 3ft   5997275.602999999 2086720.88269 37.7095822269181 -122.451188694021 (37.7095822269181, -122.451188694021)
174890 180010 2 37 1 Lawrence Ave 4 1 1 1     8 Width 3ft   5997262.56254 2086737.01263 37.7096257693921 -122.45123492637501 (37.7096257693921, -122.451234926375)
30093 30664 1 37 1 McCoppin St 4 1 1 1 1 06/26/2003 12:00:00 AM 3   Permit Number 46640 6006594.41261 2109123.24947 37.7716232677391 -122.420570406196 (37.7716232677391, -122.420570406196)
46052 242860 2 37 1 McCoppin St 3 1 1 1     2 Width 3ft   6006601.51384 2109123.7876 37.77162514551679 -122.420545880782 (37.7716251455168, -122.420545880782)
56201 30662 1 37 1 McCoppin St 2 1 1 1 1 06/26/2003 12:00:00 AM 2   Permit Number 46640 6006559.28152 2109117.66624 37.771605957578394 -122.42069153050801 (37.7716059575784, -122.420691530508)
76817 90411 3 37 1 McCoppin St 4 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006552.3 2109010.7 37.771311860318 -122.420708085152 (37.771311860318, -122.420708085152)
77634 90408 3 37 1 McCoppin St 1 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006661.144462001 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693)
104896 90409 3 37 1 McCoppin St 2 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006661.144462001 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693)
109635 90410 3 37 1 McCoppin St 3 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006661.144462001 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693)
113758 30668 1 37 1 McCoppin St 8 1 1 1 1 01/30/1995 12:00:00 AM     Permit Number 34595 6006663.15128516 2109148.64693366 37.7716968767803 -122.42033443755 (37.7716968767803, -122.42033443755)
132534 242859 2 37 1 McCoppin St 1 1 1 1     2 Width 3ft   6006473.643180001 2109116.62874 37.7715982818596 -122.420987685352 (37.7715982818596, -122.420987685352)
141337 30667 1 37 1 McCoppin St 7 1 1 1 1 01/30/1995 12:00:00 AM     Permit Number 34595 6006663.15128516 2109148.64693366 37.7716968767803 -122.42033443755 (37.7716968767803, -122.42033443755)
168897 30669 1 37 1 McCoppin St 1 1 1 1 1 06/26/2003 12:00:00 AM 2   Permit Number 46640 6006474.54027 2109116.5589 37.7715981406638 -122.42098457729999 (37.7715981406638, -122.4209845773)
177721 30663 1 37 1 McCoppin St 3 1 1 1 1 06/26/2003 12:00:00 AM 3   Permit Number 46640 6006564.909030001 2109121.1634 37.7716158771129 -122.420672312891 (37.7716158771129, -122.420672312891)
98645 91174 1 37 1 Polk St 1 1 1 1   10/16/2008 12:00:00 AM   3X3 Permit Number 51891 6007496.395175 2110885.881534 37.7765138277066 -122.41757533494 (37.7765138277066, -122.41757533494)
104332 91175 1 37 1 Polk St 2 1 1 1   10/16/2008 12:00:00 AM     Permit Number 51891 6007496.395175 2110885.881534 37.7765138277066 -122.41757533494 (37.7765138277066, -122.41757533494)
1952 139587 3 37 1 Saint Joseph's Ave 4 1 1 2     11 Width 0ft   6000732.3602 2112121.031 37.7795223070318 -122.441062642932 (37.7795223070318, -122.441062642932)
49912 246603 2 37 1 Waller St 5 4 1 1     2 Width 4ft   6005584.08918 2109245.7263700003 37.7719025692852 -122.42407388970899 (37.7719025692852, -122.424073889709)
76509 246605 2 37 1 Waller St 7 4 1 1     3 Width 4ft   6005631.61729 2109252.77035 37.7719245936684 -122.42390998734899 (37.7719245936684, -122.423909987349)
132570 246600 2 37 1 Waller St 2 4 1 1     1 Width 4ft   6005541.07514 2109239.2971099997 37.771882487431 -122.424222221193 (37.771882487431, -122.424222221193)
149193 246604 2 37 1 Waller St 6 4 1 1     1 Width 4ft   6005614.489030001 2109249.34773 37.7719142289884 -122.423968991887 (37.7719142289884, -122.423968991887)
156968 246602 2 37 1 Waller St 4 4 1 1     2 Width 4ft   6005566.51625 2109243.72851 37.77189609146429 -122.424134533696 (37.7718960914643, -122.424134533696)
165531 246601 2 37 1 Waller St 3 4 1 1     2 Width 4ft   6005553.210969999 2109241.87873 37.77189026116871 -122.424180426085 (37.7718902611687, -122.424180426085)
131719 198129 2 37 10 Apollo St 1 4 1 1     14 Width 3ft   6013057.33243 2094752.72387 37.7325270152047 -122.39720676767901 (37.7325270152047, -122.397206767679)
173422 218543 2 37 10 Elmhurst Dr 1 4 1 1     7 Width 3ft   5991239.17772 2094375.63397 37.7302528212926 -122.472609144905 (37.7302528212926, -122.472609144905)
69581 200585 2 37 10 Las Villas Ct 1 1 1 1     6 Width 0ft   6016408.3895 2094976.9039 37.7333285587394 -122.38563687008002 (37.7333285587394, -122.38563687008)
54166 242236 2 37 10 Loma Vista Ter 1 1 1 1     7 Width 3ft   5999958.34407 2106938.77843 37.7652490349443 -122.443367952968 (37.7652490349443, -122.443367952968)
153763 242239 2 37 10 Loma Vista Ter 4 1 1 1     8 Width 3ft   5999972.43901 2106916.37432 37.765188322609 -122.443317592742 (37.765188322609, -122.443317592742)
159937 242238 2 37 10 Loma Vista Ter 3 1 1 1     7 Width 3ft   5999968.62465 2106925.5157 37.765213205047495 -122.443331442302 (37.7652132050475, -122.443331442302)
185581 242237 2 37 10 Loma Vista Ter 2 1 1 1     6 Width 3ft   5999962.961130001 2106933.24517 37.7652341052825 -122.443351586234 (37.7652341052825, -122.443351586234)
131697 84175 1 37 10 Mill St 1 1 1 1   06/05/2008 12:00:00 AM 4 3x3 Permit Number 50693 6010501.10356 2090044.1422599999 37.7194555904939 -122.405712770528 (37.7194555904939, -122.405712770528)
155589 180161 2 37 10 Rolph St 2 1 1 1     4 Width 3ft   6000203.12908 2088838.03405 37.715562633976205 -122.441222488037 (37.7155626339762, -122.441222488037)
187322 180160 2 37 10 Rolph St 1 1 1 1     3 Width 3ft   6000171.58523 2088857.19454 37.7156134474691 -122.44133289151199 (37.7156134474691, -122.441332891512)
41151 214936 2 37 10 San Andreas Way 6 2 1 1     2 Width 4ft   5993805.7734 2095746.0567400001 37.7341638955498 -122.463835582055 (37.7341638955498, -122.463835582055)
67261 214931 2 37 10 San Andreas Way 1 2 1 1     2 Width 4ft   5993780.73912 2095831.5977 37.734397327182705 -122.46392833994499 (37.7343973271827, -122.463928339945)
69575 214932 2 37 10 San Andreas Way 2 2 1 1     2 Width 4ft   5993788.65441 2095818.8700599999 37.7343628363837 -122.463900050863 (37.7343628363837, -122.463900050863)
155414 214934 2 37 10 San Andreas Way 4 2 1 1     2 Width 4ft   5993802.59672 2095785.6905900002 37.7342725372347 -122.463849440612 (37.7342725372347, -122.463849440612)
168514 214935 2 37 10 San Andreas Way 5 2 1 1     2 Width 4ft   5993803.057030001 2095767.7757400002 37.7342233740152 -122.463846549273 (37.7342233740152, -122.463846549273)
182128 214933 2 37 10 San Andreas Way 3 2 1 1     2 Width 4ft   5993794.553230001 2095807.5426900003 37.7343320741677 -122.463878834949 (37.7343320741677, -122.463878834949)
62981 56298 1 37 100 09th Ave 1 1 1 1 1 09/30/1993 12:00:00 AM 7   Permit Number 32247 5993056.25051 2114776.86302 37.7863742905451 -122.467810568951 (37.7863742905451, -122.467810568951)
834 140247 2 37 100 Ashbury St 9 1 1 1     1 Width 0ft   5998760.3863 2110325.7376 37.77448037673879 -122.447755234881 (37.7744803767388, -122.447755234881)
38216 218684 2 37 100 Colon Ave 2 1 1 1     8 Width 3ft   5996159.93427 2093814.55265 37.72899583258479 -122.455556993472 (37.7289958325848, -122.455556993472)
94536 36309 1 37 100 Colon Ave 2 1 1 1 1 05/14/1998 12:00:00 AM     Permit Number 39290 5996171.57528841 2093770.15553217 37.72887459674929 -122.455513542245 (37.7288745967493, -122.455513542245)
96299 36312 1 37 100 Colon Ave 5 1 1 1 1 05/14/1998 12:00:00 AM     Permit Number 39290 5996171.57528841 2093770.15553217 37.72887459674929 -122.455513542245 (37.7288745967493, -122.455513542245)
113904 36310 1 37 100 Colon Ave 3 1 1 1 1 05/14/1998 12:00:00 AM     Permit Number 39290 5996171.57528841 2093770.15553217 37.72887459674929 -122.455513542245 (37.7288745967493, -122.455513542245)
130664 218683 2 37 100 Colon Ave 1 1 1 1     8 Width 3ft   5996159.6314199995 2093800.0617900002 37.7289560267814 -122.455556993487 (37.7289560267814, -122.455556993487)
142467 36308 1 37 100 Colon Ave 1 1 1 1 1 05/14/1998 12:00:00 AM     Permit Number 39290 5996171.57528841 2093770.15553217 37.72887459674929 -122.455513542245 (37.7288745967493, -122.455513542245)
145414 36311 1 37 100 Colon Ave 4 1 1 1 1 05/14/1998 12:00:00 AM     Permit Number 39290 5996171.57528841 2093770.15553217 37.72887459674929 -122.455513542245 (37.7288745967493, -122.455513542245)
54271 82877 1 37 100 Girard St 1 1 1 1   07/08/2009 12:00:00 AM 5 3x3 Permit Number 52475 6010467.51259 2094188.12138 37.730832215827 -122.406120676945 (37.730832215827, -122.406120676945)
117282 82874 1 37 100 Girard St 4 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52475 6010457.79461314 2094219.31159395 37.730917314013 -122.40615647032601 (37.730917314013, -122.406156470326)
119559 82873 1 37 100 Girard St 5 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52475 6010457.79461314 2094219.31159395 37.730917314013 -122.40615647032601 (37.730917314013, -122.406156470326)
125257 82875 1 37 100 Girard St 3 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52475 6010457.79461314 2094219.31159395 37.730917314013 -122.40615647032601 (37.730917314013, -122.406156470326)
125487 82876 1 37 100 Girard St 2 1 1 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52475 6010457.79461314 2094219.31159395 37.730917314013 -122.40615647032601 (37.730917314013, -122.406156470326)
166038 75713 2 37 100 Goettingen St 2 1 1 1 1 04/30/1994 12:00:00 AM 8     6009899.57579 2093995.19407 37.7302706953269 -122.408070533924 (37.7302706953269, -122.408070533924)
26332 218682 2 37 100 Greenwood Ave 2 1 1 1     5 Width 3ft   5996235.990669999 2093774.3040900002 37.728889683804795 -122.45529115477699 (37.7288896838048, -122.455291154777)
157139 218681 2 37 100 Greenwood Ave 1 1 1 1     6 Width 3ft   5996249.01925 2093772.54485 37.7288856008733 -122.455245987239 (37.7288856008733, -122.455245987239)
151356 138200 2 37 100 MASONIC AVE 4 1 1 1     1 Width 0ft   5998935.002 2112526.6295 37.780533437474396 -122.44730964733401 (37.7805334374744, -122.447309647334)
178724 138203 2 37 100 MASONIC AVE 8 1 1 1     1 Width 0ft   5998926.8799 2112606.4971 37.780752269091 -122.44734349554199 (37.780752269091, -122.447343495542)
184909 138202 2 37 100 MASONIC AVE 6 1 1 1     1 Width 0ft   5998931.6178 2112562.5022 37.7806317412334 -122.44732393749399 (37.7806317412334, -122.447323937494)
9282 14446 1 37 100 Masonic Ave 3 1 1 1   05/11/2012 12:00:00 AM 3 3x3   5998938.7246 2112487.711 37.780426790070706 -122.44729396725201 (37.7804267900707, -122.447293967252)
83922 14449 3 37 100 Masonic Ave 6 1 1 2   05/12/2012 12:00:00 AM 3 3x3   5998904.0552777 2112732.9517082 37.781098176364395 -122.447431561272 (37.7810981763644, -122.447431561272)
107949 14451 3 37 100 Masonic Ave 8 1 1 2   05/12/2012 12:00:00 AM 3 3x3   5998904.0552777 2112732.9517082 37.781098176364395 -122.447431561272 (37.7810981763644, -122.447431561272)
115635 14447 3 37 100 Masonic Ave 4 1 1 2   05/12/2012 12:00:00 AM 3 3x3   5998904.0552777 2112732.9517082 37.781098176364395 -122.447431561272 (37.7810981763644, -122.447431561272)
27867 241239 2 37 100 McCoppin St 1 4 1 1     5 Width 3ft   6005928.367769999 2109150.09439 37.7716594186857 -122.42287620587601 (37.7716594186857, -122.422876205876)
150338 241238 2 37 100 McCoppin St 2 4 1 1     3 Width 3ft   6005908.08699 2109147.66491 37.771651603561104 -122.422946185717 (37.7716516035611, -122.422946185717)
23837 242256 2 37 100 Oak St 2 1 1 1     4 Width 4ft   6006379.216440001 2110444.9043099997 37.77524008469361 -122.421408658888 (37.7752400846936, -122.421408658888)
24065 242257 2 37 100 Oak St 3 1 1 1     4 Width 4ft   6006301.70753 2110434.24272 37.7752064401631 -122.42167602284401 (37.7752064401631, -122.421676022844)
36493 242259 2 37 100 Oak St 6 1 1 1     3 Width 4ft   6006155.99242 2110416.55826 37.7751496650453 -122.42217882840299 (37.7751496650453, -122.422178828403)
49845 242255 2 37 100 Oak St 1 1 1 1     4 Width 4ft   6006442.072269999 2110453.56934 37.7752674204858 -122.421191841332 (37.7752674204858, -122.421191841332)
157428 242260 2 37 100 Oak St 7 1 1 1     3 Width 4ft   6006119.6892099995 2110408.87993 37.77512653448729 -122.422303863832 (37.7751265344873, -122.422303863832)
187925 242258 2 37 100 Oak St 4 1 1 1     4 Width 4ft   6006281.32025 2110433.89565 37.7752043375461 -122.42174652250401 (37.7752043375461, -122.421746522504)
21616 25457 1 37 100 Randolph St 2 1 1 3   12/10/1997 12:00:00 AM 6 3X3   5993681.7949 2088543.8714 37.7143812997511 -122.463741645146 (37.7143812997511, -122.463741645146)
Powered by Datasette · Query took 51.4ms · Data source: data.sfgov.org